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.CSP_PARTS_REQUIREMENT dependencies on JTF_PLSQL_API

Line 739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

735: x_msg_data := x_msg_data || ' ' || l_order_msg;
736: END IF;
737: EXCEPTION
738: WHEN FND_API.G_EXC_ERROR THEN
739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
753: ,X_MSG_COUNT => X_MSG_COUNT
754: ,X_MSG_DATA => X_MSG_DATA
755: ,X_RETURN_STATUS => X_RETURN_STATUS);
756: WHEN OTHERS THEN

Line 1080: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1076: END IF;
1077:
1078: EXCEPTION
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1084: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1084: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1080: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1084: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1085: ,X_MSG_COUNT => X_MSG_COUNT
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1089: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1085: ,X_MSG_COUNT => X_MSG_COUNT
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1093: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1089: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1094: ,X_MSG_COUNT => X_MSG_COUNT
1095: ,X_MSG_DATA => X_MSG_DATA
1096: ,X_RETURN_STATUS => X_RETURN_STATUS);
1097: WHEN OTHERS THEN

Line 1304: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1300: END IF;
1301: END IF;
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1305: P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1308: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1308: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1304: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1305: P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1308: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1313: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1313: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1317: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1317: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1313: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1317: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1318: ,X_MSG_COUNT => X_MSG_COUNT
1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321: WHEN OTHERS THEN

Line 1400: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1396: ( p_count => x_msg_count
1397: , p_data => x_msg_data);
1398:
1399: WHEN FND_API.G_EXC_ERROR THEN
1400: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1401: P_API_NAME => L_API_NAME
1402: ,P_PKG_NAME => G_PKG_NAME
1403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1404: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1404: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1400: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1401: P_API_NAME => L_API_NAME
1402: ,P_PKG_NAME => G_PKG_NAME
1403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1404: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1405: ,X_MSG_COUNT => X_MSG_COUNT
1406: ,X_MSG_DATA => X_MSG_DATA
1407: ,X_RETURN_STATUS => X_RETURN_STATUS);
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1405: ,X_MSG_COUNT => X_MSG_COUNT
1406: ,X_MSG_DATA => X_MSG_DATA
1407: ,X_RETURN_STATUS => X_RETURN_STATUS);
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1410: P_API_NAME => L_API_NAME
1411: ,P_PKG_NAME => G_PKG_NAME
1412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1410: P_API_NAME => L_API_NAME
1411: ,P_PKG_NAME => G_PKG_NAME
1412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1414: ,X_MSG_COUNT => X_MSG_COUNT
1415: ,X_MSG_DATA => X_MSG_DATA
1416: ,X_RETURN_STATUS => X_RETURN_STATUS);
1417: WHEN OTHERS THEN

Line 1888: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1884: ( p_count => x_msg_count
1885: , p_data => x_msg_data);
1886:
1887: WHEN FND_API.G_EXC_ERROR THEN
1888: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1889: P_API_NAME => L_API_NAME
1890: ,P_PKG_NAME => G_PKG_NAME
1891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1892: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1892: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1888: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1889: P_API_NAME => L_API_NAME
1890: ,P_PKG_NAME => G_PKG_NAME
1891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1892: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1893: ,X_MSG_COUNT => X_MSG_COUNT
1894: ,X_MSG_DATA => X_MSG_DATA
1895: ,X_RETURN_STATUS => X_RETURN_STATUS);
1896:

Line 1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1894: ,X_MSG_DATA => X_MSG_DATA
1895: ,X_RETURN_STATUS => X_RETURN_STATUS);
1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MSG_DATA
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN OTHERS THEN

Line 1965: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1961:
1962: EXCEPTION
1963:
1964: WHEN FND_API.G_EXC_ERROR THEN
1965: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1966: P_API_NAME => L_API_NAME
1967: ,P_PKG_NAME => G_PKG_NAME
1968: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1965: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1966: P_API_NAME => L_API_NAME
1967: ,P_PKG_NAME => G_PKG_NAME
1968: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1970: ,X_MSG_COUNT => X_MSG_COUNT
1971: ,X_MSG_DATA => X_MSG_DATA
1972: ,X_RETURN_STATUS => X_RETURN_STATUS);
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1974: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1970: ,X_MSG_COUNT => X_MSG_COUNT
1971: ,X_MSG_DATA => X_MSG_DATA
1972: ,X_RETURN_STATUS => X_RETURN_STATUS);
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1975: P_API_NAME => L_API_NAME
1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1978: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1978: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1974: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1975: P_API_NAME => L_API_NAME
1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1978: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1979: ,X_MSG_COUNT => X_MSG_COUNT
1980: ,X_MSG_DATA => X_MSG_DATA
1981: ,X_RETURN_STATUS => X_RETURN_STATUS);
1982: WHEN OTHERS THEN

Line 2217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2213: ( p_count => x_msg_count
2214: , p_data => x_msg_data);
2215:
2216: WHEN FND_API.G_EXC_ERROR THEN
2217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2218: P_API_NAME => L_API_NAME
2219: ,P_PKG_NAME => G_PKG_NAME
2220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2218: P_API_NAME => L_API_NAME
2219: ,P_PKG_NAME => G_PKG_NAME
2220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2222: ,X_MSG_COUNT => X_MSG_COUNT
2223: ,X_MSG_DATA => X_MSG_DATA
2224: ,X_RETURN_STATUS => X_RETURN_STATUS);
2225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2222: ,X_MSG_COUNT => X_MSG_COUNT
2223: ,X_MSG_DATA => X_MSG_DATA
2224: ,X_RETURN_STATUS => X_RETURN_STATUS);
2225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2231: ,X_MSG_COUNT => X_MSG_COUNT
2232: ,X_MSG_DATA => X_MSG_DATA
2233: ,X_RETURN_STATUS => X_RETURN_STATUS);
2234: WHEN OTHERS THEN

Line 2598: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2594: ( p_count => x_msg_count
2595: , p_data => x_msg_data);
2596:
2597: WHEN FND_API.G_EXC_ERROR THEN
2598: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2599: P_API_NAME => L_API_NAME
2600: ,P_PKG_NAME => G_PKG_NAME
2601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2602: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2602: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2598: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2599: P_API_NAME => L_API_NAME
2600: ,P_PKG_NAME => G_PKG_NAME
2601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2602: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2603: ,X_MSG_COUNT => X_MSG_COUNT
2604: ,X_MSG_DATA => X_MSG_DATA
2605: ,X_RETURN_STATUS => X_RETURN_STATUS);
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2607: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2603: ,X_MSG_COUNT => X_MSG_COUNT
2604: ,X_MSG_DATA => X_MSG_DATA
2605: ,X_RETURN_STATUS => X_RETURN_STATUS);
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2608: P_API_NAME => L_API_NAME
2609: ,P_PKG_NAME => G_PKG_NAME
2610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2611: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2611: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2607: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2608: P_API_NAME => L_API_NAME
2609: ,P_PKG_NAME => G_PKG_NAME
2610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2611: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2612: ,X_MSG_COUNT => X_MSG_COUNT
2613: ,X_MSG_DATA => X_MSG_DATA
2614: ,X_RETURN_STATUS => X_RETURN_STATUS);
2615: WHEN OTHERS THEN