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 1189: pa_debug.write_file('LOG','1000 Disc. Percent: ' || l_discount_percentage ||

1185: END;
1186: END IF; /* mcb flag */
1187: END IF; /* end of l_assignment_precedes_task flag check */
1188: IF g1_debug_mode = 'Y' THEN
1189: pa_debug.write_file('LOG','1000 Disc. Percent: ' || l_discount_percentage ||
1190: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1191: END IF;
1192: END IF; /* end of revenue and rate check */
1193: END IF;

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

1261:
1262:
1263: END LOOP;
1264: IF g1_debug_mode = 'Y' THEN
1265: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_discount_percentage ||
1266: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1267: END IF;
1268:
1269: EXCEPTION

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

1355: l_bill_rate := NULL;
1356: END;
1357: END IF; /* mcb flag */
1358: IF g1_debug_mode = 'Y' THEN
1359: pa_debug.write_file('LOG','1111 Disc. Percent: ' || l_discount_percentage || 'Revenue : ' || l_raw_revenue );
1360: END IF;
1361: END IF; /* end of l_assignment_precedes_task flag check */
1362: END IF; /* end of revenue and rate check */
1363: END IF;

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

1428:
1429: END LOOP;
1430:
1431: IF g1_debug_mode = 'Y' THEN
1432: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_discount_percentage ||
1433: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1434: END IF;
1435: EXCEPTION
1436: WHEN l_more_than_one_row THEN

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

1474: BETWEEN a.start_date_active
1475: AND NVL(a.end_date_active,p_item_date);
1476:
1477: IF g1_debug_mode = 'Y' THEN
1478: pa_debug.write_file('LOG','1003 Disc. Percent: ' || l_discount_percentage ||
1479: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1480: END IF;
1481:
1482: EXCEPTION

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

1520: BETWEEN a.start_date_active
1521: AND NVL(a.end_date_active,p_item_date);
1522:
1523: IF g1_debug_mode = 'Y' THEN
1524: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_discount_percentage ||
1525: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1526: END IF;
1527: EXCEPTION
1528: WHEN TOO_MANY_ROWS THEN

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

1565: BETWEEN a.start_date_active
1566: AND NVL(a.end_date_active,p_item_date);
1567:
1568: IF g1_debug_mode = 'Y' THEN
1569: pa_debug.write_file('LOG','1005 Disc. Percent: ' || l_discount_percentage ||
1570: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1571: END IF;
1572: EXCEPTION
1573: WHEN TOO_MANY_ROWS THEN

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

1611: BETWEEN a.start_date_active
1612: AND NVL(a.end_date_active,p_item_date) ;
1613:
1614: IF g1_debug_mode = 'Y' THEN
1615: pa_debug.write_file('LOG','1006 Disc. Percent: ' || l_discount_percentage ||
1616: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1617: END IF;
1618:
1619: EXCEPTION

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

1664: BETWEEN a.effective_start_date
1665: AND a.effective_end_date ; /*uncommented for bug 9257637 */
1666:
1667: IF g1_debug_mode = 'Y' THEN
1668: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||
1669: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1670: END IF;
1671:
1672: EXCEPTION

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

1697: AND NVL(j.end_date_active,p_item_date)
1698: AND l_called_process <>1; /*Added for Doosan rate api change */
1699:
1700: IF g1_debug_mode = 'Y' THEN
1701: pa_debug.write_file('LOG','1007 Disc. Percent: ' || l_discount_percentage ||
1702: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1703: END IF;
1704:
1705: EXCEPTION

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

1744: AND a.assignment_type IN ('E','C') -- Modified for CWK changes
1745: AND p_item_date BETWEEN a.effective_start_date AND a.effective_end_date ;
1746:
1747: IF g1_debug_mode = 'Y' THEN
1748: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||
1749: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1750: END IF;
1751: EXCEPTION
1752: WHEN TOO_MANY_ROWS THEN

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

1781: -- AND a.assignment_type IN ('E','C') -- Modified for CWK changes
1782: -- AND p_item_date BETWEEN a.effective_start_date AND a.effective_end_date ;
1783:
1784: IF g1_debug_mode = 'Y' THEN
1785: pa_debug.write_file('LOG','1008 Disc. Percent: ' || l_discount_percentage ||
1786: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1787: END IF;
1788: EXCEPTION
1789: WHEN TOO_MANY_ROWS THEN

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

1882: x_bill_rate := l_bill_rate;
1883: END IF;
1884:
1885: IF g1_debug_mode = 'Y' THEN
1886: pa_debug.write_file('LOG','1009 Disc. Percent: ' || l_discount_percentage ||
1887: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1888: END IF;
1889: EXCEPTION
1890: WHEN l_more_than_one_row THEN

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

1990: l_bill_rate := NULL;
1991: END;
1992: END IF; /* MCB FLAG */
1993: IF g1_debug_mode = 'Y' THEN
1994: pa_debug.write_file('LOG','1010 Disc. Percent: ' || l_discount_percentage ||
1995: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
1996: END IF;
1997: END IF;
1998:

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

2039: AND NVL(b.end_date_active,NVL(l_labor_schdl_fixed_date,p_item_date));
2040: -- AND NVL(b.org_id,-99) = NVL(l_project_org_id,-99); /* Commented for Bug 6041769 */
2041:
2042: IF g1_debug_mode = 'Y' THEN
2043: pa_debug.write_file('LOG','1011 Disc. Percent: ' || l_discount_percentage ||
2044: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2045: END IF;
2046:
2047: EXCEPTION

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

2087: AND NVL(b.end_date_active,NVL(l_labor_schdl_fixed_date,p_item_date));
2088: -- AND NVL(b.org_id,-99) = NVL(l_project_org_id,-99); /* Commented for Bug 6041769 */
2089:
2090: IF g1_debug_mode = 'Y' THEN
2091: pa_debug.write_file('LOG','1012 Disc. Percent: ' || l_discount_percentage || 'Revenue : '
2092: || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2093: END IF;
2094: EXCEPTION
2095: WHEN TOO_MANY_ROWS THEN

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

2187: l_raw_revenue := NULL;
2188: l_bill_rate := NULL;
2189: END;
2190: IF g1_debug_mode = 'Y' THEN
2191: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||
2192: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2193: END IF;
2194: ELSIF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND l_called_process <>0 AND
2195: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN

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

2220: l_raw_revenue := NULL;
2221: l_bill_rate := NULL;
2222: END;
2223: IF g1_debug_mode = 'Y' THEN
2224: pa_debug.write_file('LOG','1013 Disc. Percent: ' || l_discount_percentage ||
2225: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2226: END IF;
2227: END IF ;
2228:

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

2286: END IF; /* end if revenue calculated flag } */
2287:
2288:
2289: IF g1_debug_mode = 'Y' THEN
2290: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_discount_percentage ||
2291: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_rate_currency_code);
2292: END IF;
2293: l_txn_bill_rate := l_bill_rate; -- Removed NVL condition for bug 5079230
2294:

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

2315: x_markup_percentage := l_markup_percentage; /* Added for Asgmt overide */
2316:
2317: x_return_status := l_x_return_status;
2318: IF g1_debug_mode = 'Y' THEN
2319: pa_debug.write_file('LOG','Last statement in Assignment rev');
2320: END IF;
2321: EXCEPTION
2322: WHEN l_no_revenue THEN
2323: x_bill_rate := NULL;

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

3280: WHEN l_more_than_one_row_excep THEN
3281: RAISE;
3282: END;/*End of Item 22 ,pcb_='Y'*/
3283: IF g1_debug_mode = 'Y' THEN
3284: pa_debug.write_file('LOG','1001 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3285: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3286: END IF;
3287: END IF;
3288:

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

3537: RAISE;
3538: END;/*End of Item 23 ,pcb_='Y'*/
3539:
3540: IF g1_debug_mode = 'Y' THEN
3541: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3542: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3543: END IF;
3544: END IF;
3545:

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

3734: END LOOP;
3735:
3736: END IF;/* end of p_mcb*/
3737: IF g1_debug_mode = 'Y' THEN
3738: pa_debug.write_file('LOG','1002 Disc. Percent: ' || l_rate_discount_pct || 'Revenue : '
3739: || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
3740: END IF;
3741:
3742:

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

4001: RAISE;
4002: END;/*End of Item 25 ,pcb_='Y'*/
4003:
4004: IF g1_debug_mode = 'Y' THEN
4005: pa_debug.write_file('LOG','1004 Disc. Percent: ' || l_rate_discount_pct ||
4006: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
4007: END IF;
4008:
4009: END IF;

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

4023: x_raw_revenue := l_txn_raw_revenue ;
4024: x_return_status := l_x_return_status;
4025:
4026: IF g1_debug_mode = 'Y' THEN
4027: pa_debug.write_file('LOG','9999 Disc. Percent: ' || l_rate_discount_pct ||
4028: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || x_Rev_curr_code);
4029: END IF;
4030:
4031: EXCEPTION

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

4043: END IF;
4044: x_return_status := FND_API.G_RET_STS_ERROR;
4045: x_msg_count := 1;
4046: IF g1_debug_mode = 'Y' THEN
4047: pa_debug.write_file('LOG','1.SQLERROR ' || SQLCODE);
4048: END IF;
4049:
4050: WHEN OTHERS THEN
4051: x_raw_revenue:= NULL;

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

4065: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
4066: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REVENUE', /* name of the package*/
4067: p_procedure_name => 'Non_labor_Assignment');
4068: IF g1_debug_mode = 'Y' THEN
4069: pa_debug.write_file('LOG','2.SQLERROR ' || SQLCODE);
4070: END IF;
4071: RAISE;
4072: END IF;
4073: