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 754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

750: x_msg_data := x_msg_data || ' ' || l_order_msg;
751: END IF;
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
755: P_API_NAME => L_API_NAME
756: ,P_PKG_NAME => G_PKG_NAME
757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
755: P_API_NAME => L_API_NAME
756: ,P_PKG_NAME => G_PKG_NAME
757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
764: P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
764: P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
768: ,X_MSG_COUNT => X_MSG_COUNT
769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);
771: WHEN OTHERS THEN

Line 1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1091: END IF;
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1100: ,X_MSG_COUNT => X_MSG_COUNT
1101: ,X_MSG_DATA => X_MSG_DATA
1102: ,X_RETURN_STATUS => X_RETURN_STATUS);
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1104: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1100: ,X_MSG_COUNT => X_MSG_COUNT
1101: ,X_MSG_DATA => X_MSG_DATA
1102: ,X_RETURN_STATUS => X_RETURN_STATUS);
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1105: P_API_NAME => L_API_NAME
1106: ,P_PKG_NAME => G_PKG_NAME
1107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1108: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1108: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1104: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1105: P_API_NAME => L_API_NAME
1106: ,P_PKG_NAME => G_PKG_NAME
1107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1108: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1109: ,X_MSG_COUNT => X_MSG_COUNT
1110: ,X_MSG_DATA => X_MSG_DATA
1111: ,X_RETURN_STATUS => X_RETURN_STATUS);
1112: WHEN OTHERS THEN

Line 1417: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1413: px_line_table := l_line_tbl;
1414:
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1418: P_API_NAME => L_API_NAME
1419: ,P_PKG_NAME => G_PKG_NAME
1420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1421: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1421: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1417: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1418: P_API_NAME => L_API_NAME
1419: ,P_PKG_NAME => G_PKG_NAME
1420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1421: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1422: ,X_MSG_COUNT => X_MSG_COUNT
1423: ,X_MSG_DATA => X_MSG_DATA
1424: ,X_RETURN_STATUS => X_RETURN_STATUS);
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1422: ,X_MSG_COUNT => X_MSG_COUNT
1423: ,X_MSG_DATA => X_MSG_DATA
1424: ,X_RETURN_STATUS => X_RETURN_STATUS);
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1427: P_API_NAME => L_API_NAME
1428: ,P_PKG_NAME => G_PKG_NAME
1429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1430: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1430: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1427: P_API_NAME => L_API_NAME
1428: ,P_PKG_NAME => G_PKG_NAME
1429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1430: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1431: ,X_MSG_COUNT => X_MSG_COUNT
1432: ,X_MSG_DATA => X_MSG_DATA
1433: ,X_RETURN_STATUS => X_RETURN_STATUS);
1434: WHEN OTHERS THEN

Line 1513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1509: ( p_count => x_msg_count
1510: , p_data => x_msg_data);
1511:
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1514: P_API_NAME => L_API_NAME
1515: ,P_PKG_NAME => G_PKG_NAME
1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1514: P_API_NAME => L_API_NAME
1515: ,P_PKG_NAME => G_PKG_NAME
1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);
1521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);
1521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1523: P_API_NAME => L_API_NAME
1524: ,P_PKG_NAME => G_PKG_NAME
1525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1523: P_API_NAME => L_API_NAME
1524: ,P_PKG_NAME => G_PKG_NAME
1525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1527: ,X_MSG_COUNT => X_MSG_COUNT
1528: ,X_MSG_DATA => X_MSG_DATA
1529: ,X_RETURN_STATUS => X_RETURN_STATUS);
1530: WHEN OTHERS THEN

Line 2004: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2000: ( p_count => x_msg_count
2001: , p_data => x_msg_data);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2005: P_API_NAME => L_API_NAME
2006: ,P_PKG_NAME => G_PKG_NAME
2007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2008: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2008: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2004: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2005: P_API_NAME => L_API_NAME
2006: ,P_PKG_NAME => G_PKG_NAME
2007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2008: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2009: ,X_MSG_COUNT => X_MSG_COUNT
2010: ,X_MSG_DATA => X_MSG_DATA
2011: ,X_RETURN_STATUS => X_RETURN_STATUS);
2012:

Line 2014: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2010: ,X_MSG_DATA => X_MSG_DATA
2011: ,X_RETURN_STATUS => X_RETURN_STATUS);
2012:
2013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2014: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2015: P_API_NAME => L_API_NAME
2016: ,P_PKG_NAME => G_PKG_NAME
2017: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2018: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2018: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2014: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2015: P_API_NAME => L_API_NAME
2016: ,P_PKG_NAME => G_PKG_NAME
2017: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2018: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2019: ,X_MSG_COUNT => X_MSG_COUNT
2020: ,X_MSG_DATA => X_MSG_DATA
2021: ,X_RETURN_STATUS => X_RETURN_STATUS);
2022: WHEN OTHERS THEN

Line 2081: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2077:
2078: EXCEPTION
2079:
2080: WHEN FND_API.G_EXC_ERROR THEN
2081: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2082: P_API_NAME => L_API_NAME
2083: ,P_PKG_NAME => G_PKG_NAME
2084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2085: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2085: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2081: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2082: P_API_NAME => L_API_NAME
2083: ,P_PKG_NAME => G_PKG_NAME
2084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2085: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2086: ,X_MSG_COUNT => X_MSG_COUNT
2087: ,X_MSG_DATA => X_MSG_DATA
2088: ,X_RETURN_STATUS => X_RETURN_STATUS);
2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2090: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2086: ,X_MSG_COUNT => X_MSG_COUNT
2087: ,X_MSG_DATA => X_MSG_DATA
2088: ,X_RETURN_STATUS => X_RETURN_STATUS);
2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2090: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2091: P_API_NAME => L_API_NAME
2092: ,P_PKG_NAME => G_PKG_NAME
2093: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2094: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2094: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2090: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2091: P_API_NAME => L_API_NAME
2092: ,P_PKG_NAME => G_PKG_NAME
2093: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2094: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2095: ,X_MSG_COUNT => X_MSG_COUNT
2096: ,X_MSG_DATA => X_MSG_DATA
2097: ,X_RETURN_STATUS => X_RETURN_STATUS);
2098: WHEN OTHERS THEN

Line 2337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2333: ( p_count => x_msg_count
2334: , p_data => x_msg_data);
2335:
2336: WHEN FND_API.G_EXC_ERROR THEN
2337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2338: P_API_NAME => L_API_NAME
2339: ,P_PKG_NAME => G_PKG_NAME
2340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2338: P_API_NAME => L_API_NAME
2339: ,P_PKG_NAME => G_PKG_NAME
2340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2342: ,X_MSG_COUNT => X_MSG_COUNT
2343: ,X_MSG_DATA => X_MSG_DATA
2344: ,X_RETURN_STATUS => X_RETURN_STATUS);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2342: ,X_MSG_COUNT => X_MSG_COUNT
2343: ,X_MSG_DATA => X_MSG_DATA
2344: ,X_RETURN_STATUS => X_RETURN_STATUS);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2350: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2350: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2350: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2351: ,X_MSG_COUNT => X_MSG_COUNT
2352: ,X_MSG_DATA => X_MSG_DATA
2353: ,X_RETURN_STATUS => X_RETURN_STATUS);
2354: WHEN OTHERS THEN

Line 2718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2714: ( p_count => x_msg_count
2715: , p_data => x_msg_data);
2716:
2717: WHEN FND_API.G_EXC_ERROR THEN
2718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2719: P_API_NAME => L_API_NAME
2720: ,P_PKG_NAME => G_PKG_NAME
2721: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2719: P_API_NAME => L_API_NAME
2720: ,P_PKG_NAME => G_PKG_NAME
2721: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2723: ,X_MSG_COUNT => X_MSG_COUNT
2724: ,X_MSG_DATA => X_MSG_DATA
2725: ,X_RETURN_STATUS => X_RETURN_STATUS);
2726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2727: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2723: ,X_MSG_COUNT => X_MSG_COUNT
2724: ,X_MSG_DATA => X_MSG_DATA
2725: ,X_RETURN_STATUS => X_RETURN_STATUS);
2726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2727: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2728: P_API_NAME => L_API_NAME
2729: ,P_PKG_NAME => G_PKG_NAME
2730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2731: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2731: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2727: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2728: P_API_NAME => L_API_NAME
2729: ,P_PKG_NAME => G_PKG_NAME
2730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2731: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2732: ,X_MSG_COUNT => X_MSG_COUNT
2733: ,X_MSG_DATA => X_MSG_DATA
2734: ,X_RETURN_STATUS => X_RETURN_STATUS);
2735: WHEN OTHERS THEN