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

582:
583: COMMIT;
584: EXCEPTION
585: WHEN FND_API.G_EXC_ERROR THEN
586: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
587: P_API_NAME => L_API_NAME
588: ,P_PKG_NAME => G_PKG_NAME
589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
590: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 590: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

586: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
587: P_API_NAME => L_API_NAME
588: ,P_PKG_NAME => G_PKG_NAME
589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
590: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
591: ,X_MSG_COUNT => X_MSG_COUNT
592: ,X_MSG_DATA => X_MESSAGE
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594:

Line 604: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

600: po_moac_utils_pvt.set_org_context(l_org_org_id);
601: end if;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
605: P_API_NAME => L_API_NAME
606: ,P_PKG_NAME => G_PKG_NAME
607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
608: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 608: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

604: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
605: P_API_NAME => L_API_NAME
606: ,P_PKG_NAME => G_PKG_NAME
607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
608: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
609: ,X_MSG_COUNT => X_MSG_COUNT
610: ,X_MSG_DATA => X_MESSAGE
611: ,X_RETURN_STATUS => X_RETURN_STATUS);
612:

Line 627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

623: fnd_message.set_token('ROUTINE',l_api_name,false);
624: fnd_message.set_token('SQLERRM',sqlerrm,false);
625: fnd_msg_pub.add;
626: get_messages(x_msg_data);
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 630: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

626: get_messages(x_msg_data);
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MESSAGE
634: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MESSAGE
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:

Line 807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

803: x_group_id := l_group_id;
804:
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
812: ,X_MSG_COUNT => X_MSG_COUNT
813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

812: ,X_MSG_COUNT => X_MSG_COUNT
813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
817: P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
820: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 820: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
817: P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
820: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824: WHEN OTHERS THEN

Line 829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

825: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: fnd_message.set_token('ROUTINE',l_api_name,false);
827: fnd_message.set_token('SQLERRM',sqlerrm,false);
828: fnd_msg_pub.add;
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 832: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

828: fnd_msg_pub.add;
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
834: ,X_MSG_COUNT => X_MSG_COUNT
835: ,X_MSG_DATA => X_MSG_DATA
836: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
834: ,X_MSG_COUNT => X_MSG_COUNT
835: ,X_MSG_DATA => X_MSG_DATA
836: ,X_RETURN_STATUS => X_RETURN_STATUS);
837: END;

Line 1537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1533:
1534: x_interface_transaction_id := l_interface_transaction_id;
1535: EXCEPTION
1536: WHEN FND_API.G_EXC_ERROR THEN
1537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1538: P_API_NAME => L_API_NAME
1539: ,P_PKG_NAME => G_PKG_NAME
1540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1538: P_API_NAME => L_API_NAME
1539: ,P_PKG_NAME => G_PKG_NAME
1540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1542: ,X_MSG_COUNT => X_MSG_COUNT
1543: ,X_MSG_DATA => X_MESSAGE
1544: ,X_RETURN_STATUS => X_RETURN_STATUS);
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1546: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1542: ,X_MSG_COUNT => X_MSG_COUNT
1543: ,X_MSG_DATA => X_MESSAGE
1544: ,X_RETURN_STATUS => X_RETURN_STATUS);
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1547: P_API_NAME => L_API_NAME
1548: ,P_PKG_NAME => G_PKG_NAME
1549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1550: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1550: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1546: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1547: P_API_NAME => L_API_NAME
1548: ,P_PKG_NAME => G_PKG_NAME
1549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1550: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1551: ,X_MSG_COUNT => X_MSG_COUNT
1552: ,X_MSG_DATA => X_MESSAGE
1553: ,X_RETURN_STATUS => X_RETURN_STATUS);
1554: WHEN OTHERS THEN

Line 1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1555: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1556: fnd_message.set_token('ROUTINE',l_api_name,false);
1557: fnd_message.set_token('SQLERRM',sqlerrm,false);
1558: fnd_msg_pub.add;
1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1560: P_API_NAME => L_API_NAME
1561: ,P_PKG_NAME => G_PKG_NAME
1562: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1563: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1562: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1558: fnd_msg_pub.add;
1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1560: P_API_NAME => L_API_NAME
1561: ,P_PKG_NAME => G_PKG_NAME
1562: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1563: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1564: ,X_MSG_COUNT => X_MSG_COUNT
1565: ,X_MSG_DATA => X_MESSAGE
1566: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1563: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1560: P_API_NAME => L_API_NAME
1561: ,P_PKG_NAME => G_PKG_NAME
1562: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1563: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1564: ,X_MSG_COUNT => X_MSG_COUNT
1565: ,X_MSG_DATA => X_MESSAGE
1566: ,X_RETURN_STATUS => X_RETURN_STATUS);
1567: END;

Line 2012: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2008: );
2009:
2010: EXCEPTION
2011: WHEN FND_API.G_EXC_ERROR THEN
2012: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2013: P_API_NAME => L_API_NAME
2014: ,P_PKG_NAME => G_PKG_NAME
2015: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2016: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2016: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2012: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2013: P_API_NAME => L_API_NAME
2014: ,P_PKG_NAME => G_PKG_NAME
2015: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2016: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2017: ,X_MSG_COUNT => X_MSG_COUNT
2018: ,X_MSG_DATA => X_MESSAGE
2019: ,X_RETURN_STATUS => X_RETURN_STATUS);
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2017: ,X_MSG_COUNT => X_MSG_COUNT
2018: ,X_MSG_DATA => X_MESSAGE
2019: ,X_RETURN_STATUS => X_RETURN_STATUS);
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2022: P_API_NAME => L_API_NAME
2023: ,P_PKG_NAME => G_PKG_NAME
2024: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2022: P_API_NAME => L_API_NAME
2023: ,P_PKG_NAME => G_PKG_NAME
2024: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2026: ,X_MSG_COUNT => X_MSG_COUNT
2027: ,X_MSG_DATA => X_MESSAGE
2028: ,X_RETURN_STATUS => X_RETURN_STATUS);
2029: WHEN OTHERS THEN

Line 2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2030: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2031: fnd_message.set_token('ROUTINE',l_api_name,false);
2032: fnd_message.set_token('SQLERRM',sqlerrm,false);
2033: fnd_msg_pub.add;
2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2035: P_API_NAME => L_API_NAME
2036: ,P_PKG_NAME => G_PKG_NAME
2037: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2038: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2037: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2033: fnd_msg_pub.add;
2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2035: P_API_NAME => L_API_NAME
2036: ,P_PKG_NAME => G_PKG_NAME
2037: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2038: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2039: ,X_MSG_COUNT => X_MSG_COUNT
2040: ,X_MSG_DATA => X_MSG_DATA
2041: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2038: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2035: P_API_NAME => L_API_NAME
2036: ,P_PKG_NAME => G_PKG_NAME
2037: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2038: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2039: ,X_MSG_COUNT => X_MSG_COUNT
2040: ,X_MSG_DATA => X_MSG_DATA
2041: ,X_RETURN_STATUS => X_RETURN_STATUS);
2042: END;

Line 2170: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2166:
2167:
2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN
2170: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2171: P_API_NAME => L_API_NAME
2172: ,P_PKG_NAME => G_PKG_NAME
2173: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2174: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2174: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2170: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2171: P_API_NAME => L_API_NAME
2172: ,P_PKG_NAME => G_PKG_NAME
2173: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2174: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2175: ,X_MSG_COUNT => X_MSG_COUNT
2176: ,X_MSG_DATA => X_MESSAGE
2177: ,X_RETURN_STATUS => X_RETURN_STATUS);
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2179: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2175: ,X_MSG_COUNT => X_MSG_COUNT
2176: ,X_MSG_DATA => X_MESSAGE
2177: ,X_RETURN_STATUS => X_RETURN_STATUS);
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2180: P_API_NAME => L_API_NAME
2181: ,P_PKG_NAME => G_PKG_NAME
2182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2183: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2183: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2179: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2180: P_API_NAME => L_API_NAME
2181: ,P_PKG_NAME => G_PKG_NAME
2182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2183: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2184: ,X_MSG_COUNT => X_MSG_COUNT
2185: ,X_MSG_DATA => X_MESSAGE
2186: ,X_RETURN_STATUS => X_RETURN_STATUS);
2187: WHEN OTHERS THEN

Line 2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2188: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2189: fnd_message.set_token('ROUTINE',l_api_name,false);
2190: fnd_message.set_token('SQLERRM',sqlerrm,false);
2191: fnd_msg_pub.add;
2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2193: P_API_NAME => L_API_NAME
2194: ,P_PKG_NAME => G_PKG_NAME
2195: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2195: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2191: fnd_msg_pub.add;
2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2193: P_API_NAME => L_API_NAME
2194: ,P_PKG_NAME => G_PKG_NAME
2195: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2197: ,X_MSG_COUNT => X_MSG_COUNT
2198: ,X_MSG_DATA => X_MESSAGE
2199: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2193: P_API_NAME => L_API_NAME
2194: ,P_PKG_NAME => G_PKG_NAME
2195: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2197: ,X_MSG_COUNT => X_MSG_COUNT
2198: ,X_MSG_DATA => X_MESSAGE
2199: ,X_RETURN_STATUS => X_RETURN_STATUS);
2200: END;