eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_REVENUE dependencies on PA_DEBUG

Line 62: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

58: -- px_projfunc_bil_rate_date DATE No Bill rate date code of PFC
59: -- px_projfunc_bil_exchange_rate NUMBER No Bill exchange rate of PFC
60:
61:
62: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
63:
64: PROCEDURE Requirement_Rev_Amt (
65: p_project_id IN NUMBER,
66: p_task_id IN NUMBER,

Line 1170: pa_debug.write_file('LOG','1000 Disc. Percent: ' || l_discount_percentage ||

1166: END;
1167: END IF; /* mcb flag */
1168: END IF; /* end of l_assignment_precedes_task flag check */
1169: IF g1_debug_mode = 'Y' THEN
1170: pa_debug.write_file('LOG','1000 Disc. Percent: ' || l_discount_percentage ||
1171: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1172: END IF;
1173: END IF; /* end of revenue and rate check */
1174: END IF;

Line 1246: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_discount_percentage ||

1242:
1243:
1244: END LOOP;
1245: IF g1_debug_mode = 'Y' THEN
1246: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_discount_percentage ||
1247: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1248: END IF;
1249:
1250: EXCEPTION

Line 1340: pa_debug.write_file('LOG','1111 Disc. Percent: ' || l_discount_percentage || 'Revenue : ' || l_raw_revenue );

1336: l_bill_rate := NULL;
1337: END;
1338: END IF; /* mcb flag */
1339: IF g1_debug_mode = 'Y' THEN
1340: pa_debug.write_file('LOG','1111 Disc. Percent: ' || l_discount_percentage || 'Revenue : ' || l_raw_revenue );
1341: END IF;
1342: END IF; /* end of l_assignment_precedes_task flag check */
1343: END IF; /* end of revenue and rate check */
1344: END IF;

Line 1413: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_discount_percentage ||

1409:
1410: END LOOP;
1411:
1412: IF g1_debug_mode = 'Y' THEN
1413: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_discount_percentage ||
1414: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1415: END IF;
1416: EXCEPTION
1417: WHEN l_more_than_one_row THEN

Line 1459: pa_debug.write_file('LOG','1003 Disc. Percent: ' || l_discount_percentage ||

1455: BETWEEN a.start_date_active
1456: AND NVL(a.end_date_active,p_item_date);
1457:
1458: IF g1_debug_mode = 'Y' THEN
1459: pa_debug.write_file('LOG','1003 Disc. Percent: ' || l_discount_percentage ||
1460: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1461: END IF;
1462:
1463: EXCEPTION

Line 1505: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_discount_percentage ||

1501: BETWEEN a.start_date_active
1502: AND NVL(a.end_date_active,p_item_date);
1503:
1504: IF g1_debug_mode = 'Y' THEN
1505: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_discount_percentage ||
1506: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1507: END IF;
1508: EXCEPTION
1509: WHEN TOO_MANY_ROWS THEN

Line 1550: pa_debug.write_file('LOG','1005 Disc. Percent: ' || l_discount_percentage ||

1546: BETWEEN a.start_date_active
1547: AND NVL(a.end_date_active,p_item_date);
1548:
1549: IF g1_debug_mode = 'Y' THEN
1550: pa_debug.write_file('LOG','1005 Disc. Percent: ' || l_discount_percentage ||
1551: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1552: END IF;
1553: EXCEPTION
1554: WHEN TOO_MANY_ROWS THEN

Line 1596: pa_debug.write_file('LOG','1006 Disc. Percent: ' || l_discount_percentage ||

1592: BETWEEN a.start_date_active
1593: AND NVL(a.end_date_active,p_item_date) ;
1594:
1595: IF g1_debug_mode = 'Y' THEN
1596: pa_debug.write_file('LOG','1006 Disc. Percent: ' || l_discount_percentage ||
1597: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1598: END IF;
1599:
1600: EXCEPTION

Line 1649: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||

1645: BETWEEN a.effective_start_date Commented for Bug 6058676
1646: AND a.effective_end_date ; */
1647:
1648: IF g1_debug_mode = 'Y' THEN
1649: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||
1650: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1651: END IF;
1652:
1653: EXCEPTION

Line 1682: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||

1678: AND NVL(j.end_date_active,p_item_date)
1679: AND l_called_process <>1; /*Added for Doosan rate api change */
1680:
1681: IF g1_debug_mode = 'Y' THEN
1682: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||
1683: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1684: END IF;
1685:
1686: EXCEPTION

Line 1729: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||

1725: --AND a.assignment_type IN ('E','C') -- Modified for CWK changes
1726: --AND p_item_date BETWEEN a.effective_start_date AND a.effective_end_date ;
1727:
1728: IF g1_debug_mode = 'Y' THEN
1729: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||
1730: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1731: END IF;
1732: EXCEPTION
1733: WHEN TOO_MANY_ROWS THEN

Line 1766: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||

1762: -- AND a.assignment_type IN ('E','C') -- Modified for CWK changes
1763: -- AND p_item_date BETWEEN a.effective_start_date AND a.effective_end_date ;
1764:
1765: IF g1_debug_mode = 'Y' THEN
1766: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||
1767: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1768: END IF;
1769: EXCEPTION
1770: WHEN TOO_MANY_ROWS THEN

Line 1867: pa_debug.write_file('LOG','1009 Disc. Percent: ' || l_discount_percentage ||

1863: x_bill_rate := l_bill_rate;
1864: END IF;
1865:
1866: IF g1_debug_mode = 'Y' THEN
1867: pa_debug.write_file('LOG','1009 Disc. Percent: ' || l_discount_percentage ||
1868: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1869: END IF;
1870: EXCEPTION
1871: WHEN l_more_than_one_row THEN

Line 1975: pa_debug.write_file('LOG','1010 Disc. Percent: ' || l_discount_percentage ||

1971: l_bill_rate := NULL;
1972: END;
1973: END IF; /* MCB FLAG */
1974: IF g1_debug_mode = 'Y' THEN
1975: pa_debug.write_file('LOG','1010 Disc. Percent: ' || l_discount_percentage ||
1976: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1977: END IF;
1978: END IF;
1979:

Line 2024: pa_debug.write_file('LOG','1011 Disc. Percent: ' || l_discount_percentage ||

2020: AND NVL(b.end_date_active,NVL(l_labor_schdl_fixed_date,p_item_date));
2021: -- AND NVL(b.org_id,-99) = NVL(l_project_org_id,-99); /* Commented for Bug 6041769 */
2022:
2023: IF g1_debug_mode = 'Y' THEN
2024: pa_debug.write_file('LOG','1011 Disc. Percent: ' || l_discount_percentage ||
2025: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2026: END IF;
2027:
2028: EXCEPTION

Line 2072: pa_debug.write_file('LOG','1012 Disc. Percent: ' || l_discount_percentage || 'Revenue : '

2068: AND NVL(b.end_date_active,NVL(l_labor_schdl_fixed_date,p_item_date));
2069: -- AND NVL(b.org_id,-99) = NVL(l_project_org_id,-99); /* Commented for Bug 6041769 */
2070:
2071: IF g1_debug_mode = 'Y' THEN
2072: pa_debug.write_file('LOG','1012 Disc. Percent: ' || l_discount_percentage || 'Revenue : '
2073: || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2074: END IF;
2075: EXCEPTION
2076: WHEN TOO_MANY_ROWS THEN

Line 2171: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||

2167: l_raw_revenue := NULL;
2168: l_bill_rate := NULL;
2169: END;
2170: IF g1_debug_mode = 'Y' THEN
2171: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||
2172: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2173: END IF;
2174: ELSIF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND l_called_process <>0 AND
2175: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN

Line 2204: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||

2200: l_raw_revenue := NULL;
2201: l_bill_rate := NULL;
2202: END;
2203: IF g1_debug_mode = 'Y' THEN
2204: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||
2205: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2206: END IF;
2207: END IF ;
2208:

Line 2270: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_discount_percentage ||

2266: END IF; /* end if revenue calculated flag } */
2267:
2268:
2269: IF g1_debug_mode = 'Y' THEN
2270: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_discount_percentage ||
2271: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2272: END IF;
2273: l_txn_bill_rate := l_bill_rate; -- Removed NVL condition for bug 5079230
2274:

Line 2299: pa_debug.write_file('LOG','Last statement in Assignment rev');

2295: x_markup_percentage := l_markup_percentage; /* Added for Asgmt overide */
2296:
2297: x_return_status := l_x_return_status;
2298: IF g1_debug_mode = 'Y' THEN
2299: pa_debug.write_file('LOG','Last statement in Assignment rev');
2300: END IF;
2301: EXCEPTION
2302: WHEN l_no_revenue THEN
2303: x_bill_rate := NULL;

Line 3258: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '

3254: WHEN l_more_than_one_row_excep THEN
3255: RAISE;
3256: END;/*End of Item 22 ,pcb_='Y'*/
3257: IF g1_debug_mode = 'Y' THEN
3258: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3259: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3260: END IF;
3261: END IF;
3262:

Line 3515: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '

3511: RAISE;
3512: END;/*End of Item 23 ,pcb_='Y'*/
3513:
3514: IF g1_debug_mode = 'Y' THEN
3515: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3516: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3517: END IF;
3518: END IF;
3519:

Line 3712: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '

3708: END LOOP;
3709:
3710: END IF;/* end of p_mcb*/
3711: IF g1_debug_mode = 'Y' THEN
3712: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3713: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3714: END IF;
3715:
3716:

Line 3979: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_rate_discount_pct ||

3975: RAISE;
3976: END;/*End of Item 25 ,pcb_='Y'*/
3977:
3978: IF g1_debug_mode = 'Y' THEN
3979: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_rate_discount_pct ||
3980: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3981: END IF;
3982:
3983: END IF;

Line 4001: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_rate_discount_pct ||

3997: x_raw_revenue := l_txn_raw_revenue ;
3998: x_return_status := l_x_return_status;
3999:
4000: IF g1_debug_mode = 'Y' THEN
4001: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_rate_discount_pct ||
4002: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
4003: END IF;
4004:
4005: EXCEPTION

Line 4021: pa_debug.write_file('LOG','1.SQLERROR ' || SQLCODE);

4017: END IF;
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: x_msg_count := 1;
4020: IF g1_debug_mode = 'Y' THEN
4021: pa_debug.write_file('LOG','1.SQLERROR ' || SQLCODE);
4022: END IF;
4023:
4024: WHEN OTHERS THEN
4025: x_raw_revenue:= NULL;

Line 4043: pa_debug.write_file('LOG','2.SQLERROR ' || SQLCODE);

4039: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
4040: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REVENUE', /* name of the package*/
4041: p_procedure_name => 'Non_labor_Assignment');
4042: IF g1_debug_mode = 'Y' THEN
4043: pa_debug.write_file('LOG','2.SQLERROR ' || SQLCODE);
4044: END IF;
4045: RAISE;
4046: END IF;
4047: