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

Line 144: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

140: );
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
145: P_API_NAME => L_API_NAME
146: ,P_PKG_NAME => G_PKG_NAME
147: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

144: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
145: P_API_NAME => L_API_NAME
146: ,P_PKG_NAME => G_PKG_NAME
147: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
149: ,P_ROLLBACK_FLAG => l_Rollback
150: ,X_MSG_COUNT => X_MSG_COUNT
151: ,X_MSG_DATA => X_MSG_DATA
152: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 154: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

150: ,X_MSG_COUNT => X_MSG_COUNT
151: ,X_MSG_DATA => X_MSG_DATA
152: ,X_RETURN_STATUS => X_RETURN_STATUS);
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
155: P_API_NAME => L_API_NAME
156: ,P_PKG_NAME => G_PKG_NAME
157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
158: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 158: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

154: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
155: P_API_NAME => L_API_NAME
156: ,P_PKG_NAME => G_PKG_NAME
157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
158: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
159: ,P_ROLLBACK_FLAG => l_Rollback
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 166: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163: WHEN OTHERS THEN
164: l_sqlcode := SQLCODE;
165: l_sqlerrm := SQLERRM;
166: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
167: P_API_NAME => L_API_NAME
168: ,P_PKG_NAME => G_PKG_NAME
169: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
170: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 169: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

165: l_sqlerrm := SQLERRM;
166: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
167: P_API_NAME => L_API_NAME
168: ,P_PKG_NAME => G_PKG_NAME
169: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
170: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
171: ,P_SQLCODE => l_sqlcode
172: ,P_SQLERRM => l_sqlerrm
173: ,P_ROLLBACK_FLAG => l_Rollback

Line 170: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

166: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
167: P_API_NAME => L_API_NAME
168: ,P_PKG_NAME => G_PKG_NAME
169: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
170: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
171: ,P_SQLCODE => l_sqlcode
172: ,P_SQLERRM => l_sqlerrm
173: ,P_ROLLBACK_FLAG => l_Rollback
174: ,X_MSG_COUNT => X_MSG_COUNT

Line 858: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

854: WHEN FND_API.G_EXC_ERROR THEN
855: Add_Err_Msg;
856: retcode := 2;
857: errbuf := X_Msg_Data;
858: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
859: P_API_NAME => L_API_NAME
860: ,P_PKG_NAME => G_PKG_NAME
861: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
862: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 862: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

858: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
859: P_API_NAME => L_API_NAME
860: ,P_PKG_NAME => G_PKG_NAME
861: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
862: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
863: ,P_ROLLBACK_FLAG => l_Rollback
864: ,X_MSG_COUNT => X_MSG_COUNT
865: ,X_MSG_DATA => X_MSG_DATA
866: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 871: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: Add_Err_Msg;
869: retcode := 2;
870: errbuf := X_Msg_Data;
871: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
872: P_API_NAME => L_API_NAME
873: ,P_PKG_NAME => G_PKG_NAME
874: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
875: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 875: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

871: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
872: P_API_NAME => L_API_NAME
873: ,P_PKG_NAME => G_PKG_NAME
874: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
875: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
876: ,P_ROLLBACK_FLAG => l_Rollback
877: ,X_MSG_COUNT => X_MSG_COUNT
878: ,X_MSG_DATA => X_MSG_DATA
879: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

886: fnd_message.set_name('CSP','CSP_ASL_MSG');
887: fnd_message.set_token('VALUE',l_sqlcode || ' ' || l_sqlerrm);
888: fnd_msg_pub.add;
889: Add_Err_Msg;
890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
891: P_API_NAME => L_API_NAME
892: ,P_PKG_NAME => G_PKG_NAME
893: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
894: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 893: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

889: Add_Err_Msg;
890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
891: P_API_NAME => L_API_NAME
892: ,P_PKG_NAME => G_PKG_NAME
893: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
894: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
895: ,P_SQLCODE => l_sqlcode
896: ,P_SQLERRM => l_sqlerrm
897: ,P_ROLLBACK_FLAG => l_Rollback

Line 894: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
891: P_API_NAME => L_API_NAME
892: ,P_PKG_NAME => G_PKG_NAME
893: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
894: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
895: ,P_SQLCODE => l_sqlcode
896: ,P_SQLERRM => l_sqlerrm
897: ,P_ROLLBACK_FLAG => l_Rollback
898: ,X_MSG_COUNT => X_MSG_COUNT

Line 997: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

993: );
994:
995: EXCEPTION
996: WHEN FND_API.G_EXC_ERROR THEN
997: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
998: P_API_NAME => L_API_NAME
999: ,P_PKG_NAME => G_PKG_NAME
1000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1001: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1001: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

997: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
998: P_API_NAME => L_API_NAME
999: ,P_PKG_NAME => G_PKG_NAME
1000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1001: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1002: ,P_ROLLBACK_FLAG => 'N'
1003: ,X_MSG_COUNT => X_MSG_COUNT
1004: ,X_MSG_DATA => X_MSG_DATA
1005: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1008: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1004: ,X_MSG_DATA => X_MSG_DATA
1005: ,X_RETURN_STATUS => X_RETURN_STATUS);
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1012: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1012: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1008: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1012: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1013: ,P_ROLLBACK_FLAG => 'N'
1014: ,X_MSG_COUNT => X_MSG_COUNT
1015: ,X_MSG_DATA => X_MSG_DATA
1016: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1017:
1018: WHEN OTHERS THEN
1019: l_Sqlcode := SQLCODE;
1020: l_sqlerrm := SQLERRM;
1021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1022: P_API_NAME => L_API_NAME
1023: ,P_PKG_NAME => G_PKG_NAME
1024: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1024: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1020: l_sqlerrm := SQLERRM;
1021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1022: P_API_NAME => L_API_NAME
1023: ,P_PKG_NAME => G_PKG_NAME
1024: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1026: ,P_ROLLBACK_FLAG => 'N'
1027: ,P_SQLCODE => l_Sqlcode
1028: ,P_SQLERRM => l_Sqlerrm

Line 1025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1021: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1022: P_API_NAME => L_API_NAME
1023: ,P_PKG_NAME => G_PKG_NAME
1024: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1025: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1026: ,P_ROLLBACK_FLAG => 'N'
1027: ,P_SQLCODE => l_Sqlcode
1028: ,P_SQLERRM => l_Sqlerrm
1029: ,X_MSG_COUNT => X_MSG_COUNT

Line 1194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1190: EXCEPTION
1191: WHEN FND_API.G_EXC_ERROR THEN
1192: retcode := 2;
1193: errbuf := X_Msg_Data;
1194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1195: P_API_NAME => L_API_NAME
1196: ,P_PKG_NAME => G_PKG_NAME
1197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1195: P_API_NAME => L_API_NAME
1196: ,P_PKG_NAME => G_PKG_NAME
1197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1199: ,P_ROLLBACK_FLAG => 'Y'
1200: ,X_MSG_COUNT => X_MSG_COUNT
1201: ,X_MSG_DATA => X_MSG_DATA
1202: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1203: Add_Err_Msg;
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: retcode := 2;
1206: errbuf := X_Msg_Data;
1207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1208: P_API_NAME => L_API_NAME
1209: ,P_PKG_NAME => G_PKG_NAME
1210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1208: P_API_NAME => L_API_NAME
1209: ,P_PKG_NAME => G_PKG_NAME
1210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1212: ,P_ROLLBACK_FLAG => 'Y'
1213: ,X_MSG_COUNT => X_MSG_COUNT
1214: ,X_MSG_DATA => X_MSG_DATA
1215: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1219: l_Sqlcode := SQLCODE;
1220: l_Sqlerrm := SQLERRM;
1221: retcode := 2;
1222: errbuf := SQLERRM;
1223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1224: P_API_NAME => L_API_NAME
1225: ,P_PKG_NAME => G_PKG_NAME
1226: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1226: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1222: errbuf := SQLERRM;
1223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1224: P_API_NAME => L_API_NAME
1225: ,P_PKG_NAME => G_PKG_NAME
1226: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1228: ,P_ROLLBACK_FLAG => 'Y'
1229: ,P_SQLCODE => l_Sqlcode
1230: ,P_SQLERRM => l_Sqlerrm

Line 1227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1224: P_API_NAME => L_API_NAME
1225: ,P_PKG_NAME => G_PKG_NAME
1226: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1228: ,P_ROLLBACK_FLAG => 'Y'
1229: ,P_SQLCODE => l_Sqlcode
1230: ,P_SQLERRM => l_Sqlerrm
1231: ,X_MSG_COUNT => X_MSG_COUNT

Line 1651: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1647: );
1648:
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1652: P_API_NAME => L_API_NAME
1653: ,P_PKG_NAME => G_PKG_NAME
1654: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1655: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1655: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1651: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1652: P_API_NAME => L_API_NAME
1653: ,P_PKG_NAME => G_PKG_NAME
1654: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1655: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1656: ,P_ROLLBACK_FLAG => 'N'
1657: ,X_MSG_COUNT => X_MSG_COUNT
1658: ,X_MSG_DATA => X_MSG_DATA
1659: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1658: ,X_MSG_DATA => X_MSG_DATA
1659: ,X_RETURN_STATUS => X_RETURN_STATUS);
1660:
1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1663: P_API_NAME => L_API_NAME
1664: ,P_PKG_NAME => G_PKG_NAME
1665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1663: P_API_NAME => L_API_NAME
1664: ,P_PKG_NAME => G_PKG_NAME
1665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1667: ,P_ROLLBACK_FLAG => 'N'
1668: ,X_MSG_COUNT => X_MSG_COUNT
1669: ,X_MSG_DATA => X_MSG_DATA
1670: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1675: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1671:
1672: WHEN OTHERS THEN
1673: l_sqlcode := SQLCODE;
1674: l_sqlerrm := SQLERRM;
1675: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1676: P_API_NAME => L_API_NAME
1677: ,P_PKG_NAME => G_PKG_NAME
1678: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1679: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1678: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1674: l_sqlerrm := SQLERRM;
1675: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1676: P_API_NAME => L_API_NAME
1677: ,P_PKG_NAME => G_PKG_NAME
1678: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1679: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1680: ,P_SQLCODE => l_sqlcode
1681: ,P_SQLERRM => l_sqlerrm
1682: ,P_ROLLBACK_FLAG => 'N'

Line 1679: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1675: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1676: P_API_NAME => L_API_NAME
1677: ,P_PKG_NAME => G_PKG_NAME
1678: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1679: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1680: ,P_SQLCODE => l_sqlcode
1681: ,P_SQLERRM => l_sqlerrm
1682: ,P_ROLLBACK_FLAG => 'N'
1683: ,X_MSG_COUNT => X_MSG_COUNT

Line 1783: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1779: );
1780:
1781: EXCEPTION
1782: WHEN FND_API.G_EXC_ERROR THEN
1783: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1784: P_API_NAME => L_API_NAME
1785: ,P_PKG_NAME => G_PKG_NAME
1786: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1787: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1787: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1783: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1784: P_API_NAME => L_API_NAME
1785: ,P_PKG_NAME => G_PKG_NAME
1786: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1787: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1788: ,P_ROLLBACK_FLAG => 'N'
1789: ,X_MSG_COUNT => X_MSG_COUNT
1790: ,X_MSG_DATA => X_MSG_DATA
1791: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1790: ,X_MSG_DATA => X_MSG_DATA
1791: ,X_RETURN_STATUS => X_RETURN_STATUS);
1792:
1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1795: P_API_NAME => L_API_NAME
1796: ,P_PKG_NAME => G_PKG_NAME
1797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1795: P_API_NAME => L_API_NAME
1796: ,P_PKG_NAME => G_PKG_NAME
1797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1799: ,P_ROLLBACK_FLAG => 'N'
1800: ,X_MSG_COUNT => X_MSG_COUNT
1801: ,X_MSG_DATA => X_MSG_DATA
1802: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1803:
1804: WHEN OTHERS THEN
1805: l_sqlcode := SQLCODE;
1806: l_sqlerrm := SQLERRM;
1807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1808: P_API_NAME => L_API_NAME
1809: ,P_PKG_NAME => G_PKG_NAME
1810: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1810: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1806: l_sqlerrm := SQLERRM;
1807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1808: P_API_NAME => L_API_NAME
1809: ,P_PKG_NAME => G_PKG_NAME
1810: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1812: ,P_SQLCODE => l_sqlcode
1813: ,P_SQLERRM => l_sqlerrm
1814: ,P_ROLLBACK_FLAG => 'N'

Line 1811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1808: P_API_NAME => L_API_NAME
1809: ,P_PKG_NAME => G_PKG_NAME
1810: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1812: ,P_SQLCODE => l_sqlcode
1813: ,P_SQLERRM => l_sqlerrm
1814: ,P_ROLLBACK_FLAG => 'N'
1815: ,X_MSG_COUNT => X_MSG_COUNT

Line 1914: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1910: );
1911:
1912: EXCEPTION
1913: WHEN FND_API.G_EXC_ERROR THEN
1914: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME
1916: ,P_PKG_NAME => G_PKG_NAME
1917: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1918: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1918: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1914: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME
1916: ,P_PKG_NAME => G_PKG_NAME
1917: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1918: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1919: ,P_ROLLBACK_FLAG => 'N'
1920: ,X_MSG_COUNT => X_MSG_COUNT
1921: ,X_MSG_DATA => X_MSG_DATA
1922: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1925: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1921: ,X_MSG_DATA => X_MSG_DATA
1922: ,X_RETURN_STATUS => X_RETURN_STATUS);
1923:
1924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1925: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1926: P_API_NAME => L_API_NAME
1927: ,P_PKG_NAME => G_PKG_NAME
1928: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1925: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1926: P_API_NAME => L_API_NAME
1927: ,P_PKG_NAME => G_PKG_NAME
1928: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1930: ,P_ROLLBACK_FLAG => 'N'
1931: ,X_MSG_COUNT => X_MSG_COUNT
1932: ,X_MSG_DATA => X_MSG_DATA
1933: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1938: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1934:
1935: WHEN OTHERS THEN
1936: l_sqlcode := SQLCODE;
1937: l_sqlerrm := SQLERRM;
1938: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1942: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1941: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1937: l_sqlerrm := SQLERRM;
1938: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1942: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1943: ,P_SQLCODE => l_sqlcode
1944: ,P_SQLERRM => l_sqlerrm
1945: ,P_ROLLBACK_FLAG => 'N'

Line 1942: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1938: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1942: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1943: ,P_SQLCODE => l_sqlcode
1944: ,P_SQLERRM => l_sqlerrm
1945: ,P_ROLLBACK_FLAG => 'N'
1946: ,X_MSG_COUNT => X_MSG_COUNT

Line 2045: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2041: );
2042:
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2046: P_API_NAME => L_API_NAME
2047: ,P_PKG_NAME => G_PKG_NAME
2048: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2049: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2049: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2045: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2046: P_API_NAME => L_API_NAME
2047: ,P_PKG_NAME => G_PKG_NAME
2048: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2049: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2050: ,P_ROLLBACK_FLAG => 'N'
2051: ,X_MSG_COUNT => X_MSG_COUNT
2052: ,X_MSG_DATA => X_MSG_DATA
2053: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2052: ,X_MSG_DATA => X_MSG_DATA
2053: ,X_RETURN_STATUS => X_RETURN_STATUS);
2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_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_UNEXP_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_UNEXP_ERROR
2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2061: ,P_ROLLBACK_FLAG => 'N'
2062: ,X_MSG_COUNT => X_MSG_COUNT
2063: ,X_MSG_DATA => X_MSG_DATA
2064: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2069: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2065:
2066: WHEN OTHERS THEN
2067: l_sqlcode := SQLCODE;
2068: l_sqlerrm := SQLERRM;
2069: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2070: P_API_NAME => L_API_NAME
2071: ,P_PKG_NAME => G_PKG_NAME
2072: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2073: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2072: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2068: l_sqlerrm := SQLERRM;
2069: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2070: P_API_NAME => L_API_NAME
2071: ,P_PKG_NAME => G_PKG_NAME
2072: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2073: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2074: ,P_SQLCODE => l_sqlcode
2075: ,P_SQLERRM => l_sqlerrm
2076: ,P_ROLLBACK_FLAG => 'N'

Line 2073: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2069: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2070: P_API_NAME => L_API_NAME
2071: ,P_PKG_NAME => G_PKG_NAME
2072: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2073: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2074: ,P_SQLCODE => l_sqlcode
2075: ,P_SQLERRM => l_sqlerrm
2076: ,P_ROLLBACK_FLAG => 'N'
2077: ,X_MSG_COUNT => X_MSG_COUNT

Line 2287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2283: );
2284:
2285: EXCEPTION
2286: WHEN FND_API.G_EXC_ERROR THEN
2287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2288: P_API_NAME => L_API_NAME
2289: ,P_PKG_NAME => G_PKG_NAME
2290: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2288: P_API_NAME => L_API_NAME
2289: ,P_PKG_NAME => G_PKG_NAME
2290: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2292: ,P_ROLLBACK_FLAG => 'N'
2293: ,X_MSG_COUNT => X_MSG_COUNT
2294: ,X_MSG_DATA => X_MSG_DATA
2295: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2297: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2293: ,X_MSG_COUNT => X_MSG_COUNT
2294: ,X_MSG_DATA => X_MSG_DATA
2295: ,X_RETURN_STATUS => X_RETURN_STATUS);
2296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2297: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2298: P_API_NAME => L_API_NAME
2299: ,P_PKG_NAME => G_PKG_NAME
2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2301: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2301: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2297: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2298: P_API_NAME => L_API_NAME
2299: ,P_PKG_NAME => G_PKG_NAME
2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2301: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2302: ,P_ROLLBACK_FLAG => 'N'
2303: ,X_MSG_COUNT => X_MSG_COUNT
2304: ,X_MSG_DATA => X_MSG_DATA
2305: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2305: ,X_RETURN_STATUS => X_RETURN_STATUS);
2306: WHEN OTHERS THEN
2307: l_sqlcode := SQLCODE;
2308: l_sqlerrm := SQLERRM;
2309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2310: P_API_NAME => L_API_NAME
2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2312: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2308: l_sqlerrm := SQLERRM;
2309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2310: P_API_NAME => L_API_NAME
2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2314: ,P_ROLLBACK_FLAG => 'N'
2315: ,P_SQLCODE => l_Sqlcode
2316: ,P_SQLERRM => l_Sqlerrm

Line 2313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2310: P_API_NAME => L_API_NAME
2311: ,P_PKG_NAME => G_PKG_NAME
2312: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2314: ,P_ROLLBACK_FLAG => 'N'
2315: ,P_SQLCODE => l_Sqlcode
2316: ,P_SQLERRM => l_Sqlerrm
2317: ,X_MSG_COUNT => X_MSG_COUNT

Line 2543: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2539: );
2540:
2541: EXCEPTION
2542: WHEN FND_API.G_EXC_ERROR THEN
2543: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2544: P_API_NAME => L_API_NAME
2545: ,P_PKG_NAME => G_PKG_NAME
2546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2547: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2547: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2543: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2544: P_API_NAME => L_API_NAME
2545: ,P_PKG_NAME => G_PKG_NAME
2546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2547: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2548: ,P_ROLLBACK_FLAG => 'N'
2549: ,X_MSG_COUNT => X_MSG_COUNT
2550: ,X_MSG_DATA => X_MSG_DATA
2551: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2550: ,X_MSG_DATA => X_MSG_DATA
2551: ,X_RETURN_STATUS => X_RETURN_STATUS);
2552:
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2555: P_API_NAME => L_API_NAME
2556: ,P_PKG_NAME => G_PKG_NAME
2557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2555: P_API_NAME => L_API_NAME
2556: ,P_PKG_NAME => G_PKG_NAME
2557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2559: ,P_ROLLBACK_FLAG => 'N'
2560: ,X_MSG_COUNT => X_MSG_COUNT
2561: ,X_MSG_DATA => X_MSG_DATA
2562: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2567: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2563:
2564: WHEN OTHERS THEN
2565: l_sqlcode := SQLCODE;
2566: l_sqlerrm := SQLERRM;
2567: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2568: P_API_NAME => L_API_NAME
2569: ,P_PKG_NAME => G_PKG_NAME
2570: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2571: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2570: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2566: l_sqlerrm := SQLERRM;
2567: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2568: P_API_NAME => L_API_NAME
2569: ,P_PKG_NAME => G_PKG_NAME
2570: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2571: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2572: ,P_ROLLBACK_FLAG => 'N'
2573: ,P_SQLCODE => l_Sqlcode
2574: ,P_SQLERRM => l_Sqlerrm

Line 2571: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2567: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2568: P_API_NAME => L_API_NAME
2569: ,P_PKG_NAME => G_PKG_NAME
2570: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2571: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2572: ,P_ROLLBACK_FLAG => 'N'
2573: ,P_SQLCODE => l_Sqlcode
2574: ,P_SQLERRM => l_Sqlerrm
2575: ,X_MSG_COUNT => X_MSG_COUNT

Line 2744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2740: );
2741:
2742: EXCEPTION
2743: WHEN FND_API.G_EXC_ERROR THEN
2744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2745: P_API_NAME => L_API_NAME
2746: ,P_PKG_NAME => G_PKG_NAME
2747: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2745: P_API_NAME => L_API_NAME
2746: ,P_PKG_NAME => G_PKG_NAME
2747: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2749: ,P_ROLLBACK_FLAG => 'N'
2750: ,X_MSG_COUNT => X_MSG_COUNT
2751: ,X_MSG_DATA => X_MSG_DATA
2752: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2755: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2751: ,X_MSG_DATA => X_MSG_DATA
2752: ,X_RETURN_STATUS => X_RETURN_STATUS);
2753:
2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2755: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2756: P_API_NAME => L_API_NAME
2757: ,P_PKG_NAME => G_PKG_NAME
2758: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2759: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2759: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2755: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2756: P_API_NAME => L_API_NAME
2757: ,P_PKG_NAME => G_PKG_NAME
2758: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2759: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2760: ,P_ROLLBACK_FLAG => 'N'
2761: ,X_MSG_COUNT => X_MSG_COUNT
2762: ,X_MSG_DATA => X_MSG_DATA
2763: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2768: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2764:
2765: WHEN OTHERS THEN
2766: l_sqlcode := SQLCODE;
2767: l_sqlerrm := SQLERRM;
2768: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2769: P_API_NAME => L_API_NAME
2770: ,P_PKG_NAME => G_PKG_NAME
2771: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2772: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2771: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2767: l_sqlerrm := SQLERRM;
2768: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2769: P_API_NAME => L_API_NAME
2770: ,P_PKG_NAME => G_PKG_NAME
2771: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2772: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2773: ,P_ROLLBACK_FLAG => 'N'
2774: ,P_SQLCODE => l_sqlcode
2775: ,P_SQLERRM => l_sqlerrm

Line 2772: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2768: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2769: P_API_NAME => L_API_NAME
2770: ,P_PKG_NAME => G_PKG_NAME
2771: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2772: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2773: ,P_ROLLBACK_FLAG => 'N'
2774: ,P_SQLCODE => l_sqlcode
2775: ,P_SQLERRM => l_sqlerrm
2776: ,X_MSG_COUNT => X_MSG_COUNT

Line 3086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3082: );
3083: EXCEPTION
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: retcode := 2;
3086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3087: P_API_NAME => L_API_NAME
3088: ,P_PKG_NAME => G_PKG_NAME
3089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3087: P_API_NAME => L_API_NAME
3088: ,P_PKG_NAME => G_PKG_NAME
3089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3091: ,P_ROLLBACK_FLAG => 'N'
3092: ,X_MSG_COUNT => X_MSG_COUNT
3093: ,X_MSG_DATA => X_MSG_DATA
3094: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3098: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3094: ,X_RETURN_STATUS => X_RETURN_STATUS);
3095:
3096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3097: retcode := 2;
3098: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3099: P_API_NAME => L_API_NAME
3100: ,P_PKG_NAME => G_PKG_NAME
3101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3102: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3102: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3098: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3099: P_API_NAME => L_API_NAME
3100: ,P_PKG_NAME => G_PKG_NAME
3101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3102: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3103: ,P_ROLLBACK_FLAG => 'N'
3104: ,X_MSG_COUNT => X_MSG_COUNT
3105: ,X_MSG_DATA => X_MSG_DATA
3106: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3113: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3109: l_sqlcode := SQLCODE;
3110: l_sqlerrm := SQLERRM;
3111: retcode := 2;
3112: errbuf := SQLERRM;
3113: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3114: P_API_NAME => L_API_NAME
3115: ,P_PKG_NAME => G_PKG_NAME
3116: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3117: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3116: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

3112: errbuf := SQLERRM;
3113: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3114: P_API_NAME => L_API_NAME
3115: ,P_PKG_NAME => G_PKG_NAME
3116: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3117: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3118: ,P_ROLLBACK_FLAG => 'N'
3119: ,P_SQLCODE => l_sqlcode
3120: ,P_SQLERRM => l_sqlerrm

Line 3117: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3113: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3114: P_API_NAME => L_API_NAME
3115: ,P_PKG_NAME => G_PKG_NAME
3116: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3117: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3118: ,P_ROLLBACK_FLAG => 'N'
3119: ,P_SQLCODE => l_sqlcode
3120: ,P_SQLERRM => l_sqlerrm
3121: ,X_MSG_COUNT => X_MSG_COUNT

Line 3241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3237: );
3238:
3239: EXCEPTION
3240: WHEN FND_API.G_EXC_ERROR THEN
3241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3242: P_API_NAME => L_API_NAME
3243: ,P_PKG_NAME => G_PKG_NAME
3244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3242: P_API_NAME => L_API_NAME
3243: ,P_PKG_NAME => G_PKG_NAME
3244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3246: ,P_ROLLBACK_FLAG => 'N'
3247: ,X_MSG_COUNT => X_MSG_COUNT
3248: ,X_MSG_DATA => X_MSG_DATA
3249: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3252: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3248: ,X_MSG_DATA => X_MSG_DATA
3249: ,X_RETURN_STATUS => X_RETURN_STATUS);
3250:
3251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3252: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3253: P_API_NAME => L_API_NAME
3254: ,P_PKG_NAME => G_PKG_NAME
3255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3256: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3256: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3252: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3253: P_API_NAME => L_API_NAME
3254: ,P_PKG_NAME => G_PKG_NAME
3255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3256: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3257: ,P_ROLLBACK_FLAG => 'N'
3258: ,X_MSG_COUNT => X_MSG_COUNT
3259: ,X_MSG_DATA => X_MSG_DATA
3260: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3265: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3261:
3262: WHEN OTHERS THEN
3263: l_sqlcode := SQLCODE;
3264: l_sqlerrm := SQLERRM;
3265: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3266: P_API_NAME => L_API_NAME
3267: ,P_PKG_NAME => G_PKG_NAME
3268: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3269: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3268: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

3264: l_sqlerrm := SQLERRM;
3265: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3266: P_API_NAME => L_API_NAME
3267: ,P_PKG_NAME => G_PKG_NAME
3268: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3269: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3270: ,P_ROLLBACK_FLAG => 'N'
3271: ,P_SQLCODE => l_sqlcode
3272: ,P_SQLERRM => l_sqlerrm

Line 3269: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3265: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3266: P_API_NAME => L_API_NAME
3267: ,P_PKG_NAME => G_PKG_NAME
3268: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3269: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3270: ,P_ROLLBACK_FLAG => 'N'
3271: ,P_SQLCODE => l_sqlcode
3272: ,P_SQLERRM => l_sqlerrm
3273: ,X_MSG_COUNT => X_MSG_COUNT