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_RECEIVE_PVT dependencies on JTF_PLSQL_API

Line 72: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

68: END IF;
69:
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
73: P_API_NAME => L_API_NAME
74: ,P_PKG_NAME => G_PKG_NAME
75: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
76: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 76: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

72: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
73: P_API_NAME => L_API_NAME
74: ,P_PKG_NAME => G_PKG_NAME
75: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
76: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
77: ,X_MSG_COUNT => X_MSG_COUNT
78: ,X_MSG_DATA => X_MSG_DATA
79: ,X_RETURN_STATUS => X_RETURN_STATUS);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 81: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

77: ,X_MSG_COUNT => X_MSG_COUNT
78: ,X_MSG_DATA => X_MSG_DATA
79: ,X_RETURN_STATUS => X_RETURN_STATUS);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
82: P_API_NAME => L_API_NAME
83: ,P_PKG_NAME => G_PKG_NAME
84: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
85: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 85: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

81: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
82: P_API_NAME => L_API_NAME
83: ,P_PKG_NAME => G_PKG_NAME
84: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
85: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
86: ,X_MSG_COUNT => X_MSG_COUNT
87: ,X_MSG_DATA => X_MSG_DATA
88: ,X_RETURN_STATUS => X_RETURN_STATUS);
89: WHEN OTHERS THEN

Line 94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

90: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
91: fnd_message.set_token('ROUTINE',l_api_name,false);
92: fnd_message.set_token('SQLERRM',sqlerrm,false);
93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
96: ,P_PKG_NAME => G_PKG_NAME
97: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
98: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 97: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
96: ,P_PKG_NAME => G_PKG_NAME
97: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
98: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
99: ,X_MSG_COUNT => X_MSG_COUNT
100: ,X_MSG_DATA => X_MSG_DATA
101: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 98: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
96: ,P_PKG_NAME => G_PKG_NAME
97: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
98: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
99: ,X_MSG_COUNT => X_MSG_COUNT
100: ,X_MSG_DATA => X_MSG_DATA
101: ,X_RETURN_STATUS => X_RETURN_STATUS);
102: END gen_receipt_num;

Line 235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

231:
232: return(TRUE);
233: exception
234: WHEN FND_API.G_EXC_ERROR THEN
235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
240: ,X_MSG_COUNT => X_MSG_COUNT
241: ,X_MSG_DATA => X_MSG_DATA
242: ,X_RETURN_STATUS => X_RETURN_STATUS);
243: return FALSE;

Line 245: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

241: ,X_MSG_DATA => X_MSG_DATA
242: ,X_RETURN_STATUS => X_RETURN_STATUS);
243: return FALSE;
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
246: P_API_NAME => L_API_NAME
247: ,P_PKG_NAME => G_PKG_NAME
248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
249: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 249: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

245: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
246: P_API_NAME => L_API_NAME
247: ,P_PKG_NAME => G_PKG_NAME
248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
249: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
250: ,X_MSG_COUNT => X_MSG_COUNT
251: ,X_MSG_DATA => X_MSG_DATA
252: ,X_RETURN_STATUS => X_RETURN_STATUS);
253: return FALSE;

Line 259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

255: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
256: fnd_message.set_token('ROUTINE',l_api_name,false);
257: fnd_message.set_token('SQLERRM',sqlerrm,false);
258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
263: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 262: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
263: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
264: ,X_MSG_COUNT => X_MSG_COUNT
265: ,X_MSG_DATA => X_MSG_DATA
266: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 263: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
263: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
264: ,X_MSG_COUNT => X_MSG_COUNT
265: ,X_MSG_DATA => X_MSG_DATA
266: ,X_RETURN_STATUS => X_RETURN_STATUS);
267: return FALSE;

Line 499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

495: --- Commit;
496: COMMIT;
497: EXCEPTION
498: WHEN FND_API.G_EXC_ERROR THEN
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MESSAGE
506: ,X_RETURN_STATUS => X_RETURN_STATUS);
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 508: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MESSAGE
506: ,X_RETURN_STATUS => X_RETURN_STATUS);
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
512: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 512: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

508: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
512: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MESSAGE
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516: WHEN OTHERS THEN

Line 522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

518: fnd_message.set_token('ROUTINE',l_api_name,false);
519: fnd_message.set_token('SQLERRM',sqlerrm,false);
520: fnd_msg_pub.add;
521: get_messages(x_msg_data);
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

521: get_messages(x_msg_data);
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MESSAGE
529: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MESSAGE
529: ,X_RETURN_STATUS => X_RETURN_STATUS);
530: END;

Line 693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

689: x_group_id := l_group_id;
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
698: ,X_MSG_COUNT => X_MSG_COUNT
699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 702: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

698: ,X_MSG_COUNT => X_MSG_COUNT
699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
703: P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME
705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
706: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 706: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

702: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
703: P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME
705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
706: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
707: ,X_MSG_COUNT => X_MSG_COUNT
708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);
710: WHEN OTHERS THEN

Line 715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

711: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
712: fnd_message.set_token('ROUTINE',l_api_name,false);
713: fnd_message.set_token('SQLERRM',sqlerrm,false);
714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
720: ,X_MSG_COUNT => X_MSG_COUNT
721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
720: ,X_MSG_COUNT => X_MSG_COUNT
721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);
723: END;

Line 1423: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1419:
1420: x_interface_transaction_id := l_interface_transaction_id;
1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1424: P_API_NAME => L_API_NAME
1425: ,P_PKG_NAME => G_PKG_NAME
1426: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1427: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1427: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1432: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1428: ,X_MSG_COUNT => X_MSG_COUNT
1429: ,X_MSG_DATA => X_MESSAGE
1430: ,X_RETURN_STATUS => X_RETURN_STATUS);
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1433: P_API_NAME => L_API_NAME
1434: ,P_PKG_NAME => G_PKG_NAME
1435: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1436: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1436: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1432: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1433: P_API_NAME => L_API_NAME
1434: ,P_PKG_NAME => G_PKG_NAME
1435: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1436: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1437: ,X_MSG_COUNT => X_MSG_COUNT
1438: ,X_MSG_DATA => X_MESSAGE
1439: ,X_RETURN_STATUS => X_RETURN_STATUS);
1440: WHEN OTHERS THEN

Line 1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1441: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1442: fnd_message.set_token('ROUTINE',l_api_name,false);
1443: fnd_message.set_token('SQLERRM',sqlerrm,false);
1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME
1447: ,P_PKG_NAME => G_PKG_NAME
1448: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1449: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1448: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME
1447: ,P_PKG_NAME => G_PKG_NAME
1448: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1449: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1450: ,X_MSG_COUNT => X_MSG_COUNT
1451: ,X_MSG_DATA => X_MESSAGE
1452: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1449: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME
1447: ,P_PKG_NAME => G_PKG_NAME
1448: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1449: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1450: ,X_MSG_COUNT => X_MSG_COUNT
1451: ,X_MSG_DATA => X_MESSAGE
1452: ,X_RETURN_STATUS => X_RETURN_STATUS);
1453: END;

Line 1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1894: );
1895:
1896: EXCEPTION
1897: WHEN FND_API.G_EXC_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_PVT

Line 1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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_PVT
1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MESSAGE
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MESSAGE
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MESSAGE
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915: WHEN OTHERS THEN

Line 1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1916: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1917: fnd_message.set_token('ROUTINE',l_api_name,false);
1918: fnd_message.set_token('SQLERRM',sqlerrm,false);
1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME
1922: ,P_PKG_NAME => G_PKG_NAME
1923: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1924: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1923: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME
1922: ,P_PKG_NAME => G_PKG_NAME
1923: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1924: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1925: ,X_MSG_COUNT => X_MSG_COUNT
1926: ,X_MSG_DATA => X_MSG_DATA
1927: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1924: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME
1922: ,P_PKG_NAME => G_PKG_NAME
1923: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1924: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1925: ,X_MSG_COUNT => X_MSG_COUNT
1926: ,X_MSG_DATA => X_MSG_DATA
1927: ,X_RETURN_STATUS => X_RETURN_STATUS);
1928: END;

Line 2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2052:
2053:
2054: EXCEPTION
2055: WHEN FND_API.G_EXC_ERROR THEN
2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MESSAGE
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2065: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MESSAGE
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2066: P_API_NAME => L_API_NAME
2067: ,P_PKG_NAME => G_PKG_NAME
2068: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2069: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2069: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2065: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2066: P_API_NAME => L_API_NAME
2067: ,P_PKG_NAME => G_PKG_NAME
2068: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2069: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2070: ,X_MSG_COUNT => X_MSG_COUNT
2071: ,X_MSG_DATA => X_MESSAGE
2072: ,X_RETURN_STATUS => X_RETURN_STATUS);
2073: WHEN OTHERS THEN

Line 2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2074: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2075: fnd_message.set_token('ROUTINE',l_api_name,false);
2076: fnd_message.set_token('SQLERRM',sqlerrm,false);
2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME
2080: ,P_PKG_NAME => G_PKG_NAME
2081: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2081: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME
2080: ,P_PKG_NAME => G_PKG_NAME
2081: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2083: ,X_MSG_COUNT => X_MSG_COUNT
2084: ,X_MSG_DATA => X_MESSAGE
2085: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME
2080: ,P_PKG_NAME => G_PKG_NAME
2081: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2083: ,X_MSG_COUNT => X_MSG_COUNT
2084: ,X_MSG_DATA => X_MESSAGE
2085: ,X_RETURN_STATUS => X_RETURN_STATUS);
2086: END;