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_RBS_UTILS dependencies on PA_DEBUG

Line 1497: pa_debug.log_message ('Error in API PA_RBS_VERSIONS_PVT.SET_REPORTING_FLAG' || SQLERRM);

1493: p_rbs_version_id => p_new_rbs_version_id,
1494: x_return_status => x_return_status );
1495:
1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1497: pa_debug.log_message ('Error in API PA_RBS_VERSIONS_PVT.SET_REPORTING_FLAG' || SQLERRM);
1498: --RETURN;
1499: END IF;
1500:
1501: --Call to Allocations handler API

Line 1509: pa_debug.log_message ('Error in API PA_ALLOC_UTILS.ASSOCIATE_RBS_TO_ALLOC_RULE' || SQLERRM);

1505: x_return_status => x_return_status,
1506: x_error_code => x_msg_data );
1507:
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: pa_debug.log_message ('Error in API PA_ALLOC_UTILS.ASSOCIATE_RBS_TO_ALLOC_RULE' || SQLERRM);
1510: --RETURN;
1511: END IF;
1512:
1513: --Call to Budgeting and Forecasting handler API

Line 1523: pa_debug.log_message ('Error in API PA_RLMI_RBS_MAP_PUB.PUSH_RBS_VERSION' || SQLERRM);

1519: x_msg_count => x_msg_count,
1520: x_msg_data => x_msg_data );
1521:
1522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1523: pa_debug.log_message ('Error in API PA_RLMI_RBS_MAP_PUB.PUSH_RBS_VERSION' || SQLERRM);
1524: --RETURN;
1525: END IF;
1526:
1527:

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

1563: SELECT Res_type_id
1564: FROM pa_res_types_b;
1565:
1566: l_res_type_id NUMBER;
1567: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1568: BEGIN
1569:
1570: --Initialize variables
1571: retcode := 0;

Line 1574: PA_DEBUG.SET_PROCESS(x_process => 'PLSQL',

1570: --Initialize variables
1571: retcode := 0;
1572: errbuf := NULL;
1573:
1574: PA_DEBUG.SET_PROCESS(x_process => 'PLSQL',
1575: x_debug_mode => PG_DEBUG);
1576:
1577: PA_DEBUG.WRITE_FILE('LOG', TO_CHAR(SYSDATE,'HH:MI:SS')||
1578: ': PA_DEBUG_MODE: '||PG_DEBUG);

Line 1577: PA_DEBUG.WRITE_FILE('LOG', TO_CHAR(SYSDATE,'HH:MI:SS')||

1573:
1574: PA_DEBUG.SET_PROCESS(x_process => 'PLSQL',
1575: x_debug_mode => PG_DEBUG);
1576:
1577: PA_DEBUG.WRITE_FILE('LOG', TO_CHAR(SYSDATE,'HH:MI:SS')||
1578: ': PA_DEBUG_MODE: '||PG_DEBUG);
1579:
1580: --Print report heading
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||

Line 1578: ': PA_DEBUG_MODE: '||PG_DEBUG);

1574: PA_DEBUG.SET_PROCESS(x_process => 'PLSQL',
1575: x_debug_mode => PG_DEBUG);
1576:
1577: PA_DEBUG.WRITE_FILE('LOG', TO_CHAR(SYSDATE,'HH:MI:SS')||
1578: ': PA_DEBUG_MODE: '||PG_DEBUG);
1579:
1580: --Print report heading
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
1582: ' '||

Line 1588: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||

1584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
1585:
1586:
1587: IF PG_DEBUG = 'Y' THEN
1588: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||
1589: 'deleting all rows from Tl table');
1590: END IF;
1591:
1592:

Line 1600: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||

1596:
1597:
1598: --Refreshing Rule based Rbs
1599: IF PG_DEBUG = 'Y' THEN
1600: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||
1601: 'Refreshing Rule Based Rbs');
1602: END IF;
1603:
1604: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 1639: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||

1635: AND lk.lookup_type = 'RBS_RULE_RESOURCE');
1636:
1637: --Refreshing the Version names
1638: IF PG_DEBUG = 'Y' THEN
1639: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||
1640: 'Refreshing Version Names ');
1641: END IF;
1642:
1643: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 1688: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1684: --FOR res_type_id=1 Res_type_code=BOM_LABOR
1685: IF l_res_type_id=1 THEN
1686: --dbms_output.put_line('For Res_Type_Id=1 BOM_LABOR');
1687: IF PG_DEBUG = 'Y' THEN
1688: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1689: ': '||'Refreshing BOM_LABOR ');
1690: END IF;
1691: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1692: to remove the GSCC Warning File.Sql.33 */

Line 1729: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1725:
1726: IF l_res_type_id=2 THEN
1727:
1728: IF PG_DEBUG = 'Y' THEN
1729: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1730: ': '||'Refreshing BOM_EQUIPMENT ');
1731: END IF;
1732: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1733: to remove the GSCC Warning File.Sql.33 */

Line 1771: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1767: --FOR res_type_id=3 Res_type_code=NAMED_PERSON
1768: IF l_res_type_id=3 THEN
1769: --dbms_output.put_line('For Res_Type_Id=3 NAMED_PERSON');
1770: IF PG_DEBUG = 'Y' THEN
1771: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1772: ': '||'Refreshing NAMED_PERSON ');
1773: END IF;
1774: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1775: to remove the GSCC Warning File.Sql.33 */

Line 1815: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1811: --FOR res_type_id=4 Res_type_code=EVENT_TYPE
1812: IF l_res_type_id=4 THEN
1813: --dbms_output.put_line('For Res_Type_Id=4 EVENT_TYPE');
1814: IF PG_DEBUG = 'Y' THEN
1815: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1816: ': '||'Refreshing EVENT_TYPE ');
1817: END IF;
1818: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1819: to remove the GSCC Warning File.Sql.33 */

Line 1857: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1853: IF l_res_type_id=5 THEN
1854: --dbms_output.put_line('For Res_Type_Id=5 EXPENDITURE_CATEGORY');
1855:
1856: IF PG_DEBUG = 'Y' THEN
1857: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1858: ': '||'Refreshing EXPENDITURE_CATEGORY ');
1859: END IF;
1860: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1861: to remove the GSCC Warning File.Sql.33 */

Line 1898: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Refreshing EXPENDITURE_TYPE ');

1894: --FOR res_type_id=6 Res_type_code=EXPENDITURE_TYPE
1895: IF l_res_type_id=6 THEN
1896: --dbms_output.put_line('For Res_Type_Id=6 EXPENDITURE_TYPE');
1897: IF PG_DEBUG = 'Y' THEN
1898: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Refreshing EXPENDITURE_TYPE ');
1899: END IF;
1900:
1901: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1902: to remove the GSCC Warning File.Sql.33 */

Line 1939: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1935: --FOR res_type_id=7 Res_type_code=ITEM_CATEGORY
1936: IF l_res_type_id=7 THEN
1937: --dbms_output.put_line('For Res_Type_Id=7 =ITEM_CATEGORY');
1938: IF PG_DEBUG = 'Y' THEN
1939: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1940: ': '||'Refreshing ITEM_CATEGORY ');
1941: END IF;
1942:
1943: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 1979: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

1975:
1976: --FOR res_type_id=8 Res_type_code=INVENTORY_ITEM
1977: IF l_res_type_id=8 THEN
1978: IF PG_DEBUG = 'Y' THEN
1979: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
1980: ': '||'Refreshing INVENTORY_ITEM ');
1981: END IF;
1982:
1983: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2022: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2018:
2019: --FOR res_type_id=9 Res_type_code=JOB
2020: IF l_res_type_id=9 THEN
2021: IF PG_DEBUG = 'Y' THEN
2022: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2023: ': '||'Refreshing JOB ');
2024: END IF;
2025:
2026: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2063: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,

2059:
2060: --FOR res_type_id=10 Res_type_code=ORGANIZATION
2061: IF l_res_type_id=10 THEN
2062: IF PG_DEBUG = 'Y' THEN
2063: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,
2064: 'HH:MI:SS')|| ': '||'Refreshing ORGANIZATION ');
2065: END IF;
2066:
2067: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2101: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2097:
2098: --FOR res_type_id=11 Res_type_code=PERSON_TYPE
2099: IF l_res_type_id=11 THEN
2100: IF PG_DEBUG = 'Y' THEN
2101: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2102: ': '||'Refreshing PERSON_TYPE ');
2103: END IF;
2104:
2105: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2142: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,

2138:
2139: --FOR res_type_id=12 Res_type_code=NON_LABOR_RESOURCE
2140: IF l_res_type_id=12 THEN
2141: IF PG_DEBUG = 'Y' THEN
2142: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,
2143: 'HH:MI:SS')||': '||'Refreshing NON_LABOR_RESOURCE ');
2144: END IF;
2145:
2146: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2183: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2179:
2180: --FOR res_type_id=13 Res_type_code=RESOURCE_CLASS
2181: IF l_res_type_id=13 THEN
2182: IF PG_DEBUG = 'Y' THEN
2183: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2184: ': '||'Refreshing RESOURCE_CLASS');
2185: END IF;
2186:
2187: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2220: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2216:
2217: --FOR res_type_id=14 Res_type_code=REVENUE_CATEGORY
2218: IF l_res_type_id=14 THEN
2219: IF PG_DEBUG = 'Y' THEN
2220: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2221: ': '||'Refreshing REVENUE_CATEGORY');
2222: END IF;
2223:
2224: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2260: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2256:
2257: --FOR res_type_id=15 Res_type_code=ROLE
2258: IF l_res_type_id=15 THEN
2259: IF PG_DEBUG = 'Y' THEN
2260: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2261: ': '||'Refreshing ROLE');
2262: END IF;
2263:
2264: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2297: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2293:
2294: --FOR res_type_id=16 Res_type_code=SUPPLIER
2295: IF l_res_type_id=16 THEN
2296: IF PG_DEBUG = 'Y' THEN
2297: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2298: ': '||'Refreshing SUPPLIER');
2299: END IF;
2300:
2301: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2338: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||

2334:
2335: --FOR res_type_id=18 Res_type_code=USER DEFINED
2336: IF l_res_type_id=18 THEN
2337: IF PG_DEBUG = 'Y' THEN
2338: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||
2339: ': '||'Refreshing USER DEFINED');
2340: END IF;
2341:
2342: /*Bug 4377886 : Included explicitly the column names in the INSERT statement

Line 2383: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||'Leaving Refresh_Resource_Names procedure');

2379:
2380: --dbms_output.put_line('Leaving Refresh_Resource_Names procedure');
2381:
2382: IF PG_DEBUG = 'Y' THEN
2383: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||'Leaving Refresh_Resource_Names procedure');
2384: END IF;
2385: Commit;
2386:
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Refresh_Resource_Names completed successfully.');

Line 3837: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
3836: 'Pa_RBS_Utils.Delete_Proj_Specific_RBS'
3837: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3838: x_msg_count := x_msg_count+1;
3839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3840: END Delete_Proj_Specific_RBS;
3841: