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

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

Line 865: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 878: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 893: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 896: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 897: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1000: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 1004: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1011: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 1015: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1024: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 1027: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 1028: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1170: EXCEPTION
1171: WHEN FND_API.G_EXC_ERROR THEN
1172: retcode := 2;
1173: errbuf := X_Msg_Data;
1174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME
1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1178: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1178: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME
1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1178: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1179: ,P_ROLLBACK_FLAG => 'Y'
1180: ,X_MSG_COUNT => X_MSG_COUNT
1181: ,X_MSG_DATA => X_MSG_DATA
1182: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1183: Add_Err_Msg;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: retcode := 2;
1186: errbuf := X_Msg_Data;
1187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1188: P_API_NAME => L_API_NAME
1189: ,P_PKG_NAME => G_PKG_NAME
1190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1188: P_API_NAME => L_API_NAME
1189: ,P_PKG_NAME => G_PKG_NAME
1190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1192: ,P_ROLLBACK_FLAG => 'Y'
1193: ,X_MSG_COUNT => X_MSG_COUNT
1194: ,X_MSG_DATA => X_MSG_DATA
1195: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1199: l_Sqlcode := SQLCODE;
1200: l_Sqlerrm := SQLERRM;
1201: retcode := 2;
1202: errbuf := SQLERRM;
1203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1204: P_API_NAME => L_API_NAME
1205: ,P_PKG_NAME => G_PKG_NAME
1206: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1207: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1206: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1202: errbuf := SQLERRM;
1203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1204: P_API_NAME => L_API_NAME
1205: ,P_PKG_NAME => G_PKG_NAME
1206: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1207: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1208: ,P_ROLLBACK_FLAG => 'Y'
1209: ,P_SQLCODE => l_Sqlcode
1210: ,P_SQLERRM => l_Sqlerrm

Line 1207: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1204: P_API_NAME => L_API_NAME
1205: ,P_PKG_NAME => G_PKG_NAME
1206: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1207: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1208: ,P_ROLLBACK_FLAG => 'Y'
1209: ,P_SQLCODE => l_Sqlcode
1210: ,P_SQLERRM => l_Sqlerrm
1211: ,X_MSG_COUNT => X_MSG_COUNT

Line 1631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1627: );
1628:
1629: EXCEPTION
1630: WHEN FND_API.G_EXC_ERROR THEN
1631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1632: P_API_NAME => L_API_NAME
1633: ,P_PKG_NAME => G_PKG_NAME
1634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1635: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1635: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1632: P_API_NAME => L_API_NAME
1633: ,P_PKG_NAME => G_PKG_NAME
1634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1635: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1636: ,P_ROLLBACK_FLAG => 'N'
1637: ,X_MSG_COUNT => X_MSG_COUNT
1638: ,X_MSG_DATA => X_MSG_DATA
1639: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1642: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1638: ,X_MSG_DATA => X_MSG_DATA
1639: ,X_RETURN_STATUS => X_RETURN_STATUS);
1640:
1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1643: P_API_NAME => L_API_NAME
1644: ,P_PKG_NAME => G_PKG_NAME
1645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1646: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1646: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1642: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1643: P_API_NAME => L_API_NAME
1644: ,P_PKG_NAME => G_PKG_NAME
1645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1646: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1647: ,P_ROLLBACK_FLAG => 'N'
1648: ,X_MSG_COUNT => X_MSG_COUNT
1649: ,X_MSG_DATA => X_MSG_DATA
1650: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1655: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1651:
1652: WHEN OTHERS THEN
1653: l_sqlcode := SQLCODE;
1654: l_sqlerrm := SQLERRM;
1655: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1656: P_API_NAME => L_API_NAME
1657: ,P_PKG_NAME => G_PKG_NAME
1658: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1659: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1658: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1654: l_sqlerrm := SQLERRM;
1655: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1656: P_API_NAME => L_API_NAME
1657: ,P_PKG_NAME => G_PKG_NAME
1658: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1659: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1660: ,P_SQLCODE => l_sqlcode
1661: ,P_SQLERRM => l_sqlerrm
1662: ,P_ROLLBACK_FLAG => 'N'

Line 1659: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1655: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1656: P_API_NAME => L_API_NAME
1657: ,P_PKG_NAME => G_PKG_NAME
1658: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1659: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1660: ,P_SQLCODE => l_sqlcode
1661: ,P_SQLERRM => l_sqlerrm
1662: ,P_ROLLBACK_FLAG => 'N'
1663: ,X_MSG_COUNT => X_MSG_COUNT

Line 1763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1759: );
1760:
1761: EXCEPTION
1762: WHEN FND_API.G_EXC_ERROR THEN
1763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1764: P_API_NAME => L_API_NAME
1765: ,P_PKG_NAME => G_PKG_NAME
1766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1764: P_API_NAME => L_API_NAME
1765: ,P_PKG_NAME => G_PKG_NAME
1766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1768: ,P_ROLLBACK_FLAG => 'N'
1769: ,X_MSG_COUNT => X_MSG_COUNT
1770: ,X_MSG_DATA => X_MSG_DATA
1771: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1774: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1770: ,X_MSG_DATA => X_MSG_DATA
1771: ,X_RETURN_STATUS => X_RETURN_STATUS);
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1778: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1778: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1774: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1778: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1779: ,P_ROLLBACK_FLAG => 'N'
1780: ,X_MSG_COUNT => X_MSG_COUNT
1781: ,X_MSG_DATA => X_MSG_DATA
1782: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1787: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1783:
1784: WHEN OTHERS THEN
1785: l_sqlcode := SQLCODE;
1786: l_sqlerrm := SQLERRM;
1787: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1788: P_API_NAME => L_API_NAME
1789: ,P_PKG_NAME => G_PKG_NAME
1790: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1791: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1790: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1786: l_sqlerrm := SQLERRM;
1787: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1788: P_API_NAME => L_API_NAME
1789: ,P_PKG_NAME => G_PKG_NAME
1790: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1791: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1792: ,P_SQLCODE => l_sqlcode
1793: ,P_SQLERRM => l_sqlerrm
1794: ,P_ROLLBACK_FLAG => 'N'

Line 1791: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1787: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1788: P_API_NAME => L_API_NAME
1789: ,P_PKG_NAME => G_PKG_NAME
1790: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1791: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1792: ,P_SQLCODE => l_sqlcode
1793: ,P_SQLERRM => l_sqlerrm
1794: ,P_ROLLBACK_FLAG => 'N'
1795: ,X_MSG_COUNT => X_MSG_COUNT

Line 1894: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1890: );
1891:
1892: EXCEPTION
1893: WHEN FND_API.G_EXC_ERROR THEN
1894: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1895: P_API_NAME => L_API_NAME
1896: ,P_PKG_NAME => G_PKG_NAME
1897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1898: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1898: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1894: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1895: P_API_NAME => L_API_NAME
1896: ,P_PKG_NAME => G_PKG_NAME
1897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1898: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1899: ,P_ROLLBACK_FLAG => 'N'
1900: ,X_MSG_COUNT => X_MSG_COUNT
1901: ,X_MSG_DATA => X_MSG_DATA
1902: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1905: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 1909: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1905: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1906: P_API_NAME => L_API_NAME
1907: ,P_PKG_NAME => G_PKG_NAME
1908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1909: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1910: ,P_ROLLBACK_FLAG => 'N'
1911: ,X_MSG_COUNT => X_MSG_COUNT
1912: ,X_MSG_DATA => X_MSG_DATA
1913: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1918: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1914:
1915: WHEN OTHERS THEN
1916: l_sqlcode := SQLCODE;
1917: l_sqlerrm := SQLERRM;
1918: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1919: P_API_NAME => L_API_NAME
1920: ,P_PKG_NAME => G_PKG_NAME
1921: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1922: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1921: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1917: l_sqlerrm := SQLERRM;
1918: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1919: P_API_NAME => L_API_NAME
1920: ,P_PKG_NAME => G_PKG_NAME
1921: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1922: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1923: ,P_SQLCODE => l_sqlcode
1924: ,P_SQLERRM => l_sqlerrm
1925: ,P_ROLLBACK_FLAG => 'N'

Line 1922: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1918: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1919: P_API_NAME => L_API_NAME
1920: ,P_PKG_NAME => G_PKG_NAME
1921: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1922: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1923: ,P_SQLCODE => l_sqlcode
1924: ,P_SQLERRM => l_sqlerrm
1925: ,P_ROLLBACK_FLAG => 'N'
1926: ,X_MSG_COUNT => X_MSG_COUNT

Line 2025: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2021: );
2022:
2023: EXCEPTION
2024: WHEN FND_API.G_EXC_ERROR THEN
2025: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2026: P_API_NAME => L_API_NAME
2027: ,P_PKG_NAME => G_PKG_NAME
2028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2029: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2029: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2025: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2026: P_API_NAME => L_API_NAME
2027: ,P_PKG_NAME => G_PKG_NAME
2028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2029: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2030: ,P_ROLLBACK_FLAG => 'N'
2031: ,X_MSG_COUNT => X_MSG_COUNT
2032: ,X_MSG_DATA => X_MSG_DATA
2033: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2036: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2032: ,X_MSG_DATA => X_MSG_DATA
2033: ,X_RETURN_STATUS => X_RETURN_STATUS);
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2037: P_API_NAME => L_API_NAME
2038: ,P_PKG_NAME => G_PKG_NAME
2039: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2040: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2040: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2036: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2037: P_API_NAME => L_API_NAME
2038: ,P_PKG_NAME => G_PKG_NAME
2039: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2040: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2041: ,P_ROLLBACK_FLAG => 'N'
2042: ,X_MSG_COUNT => X_MSG_COUNT
2043: ,X_MSG_DATA => X_MSG_DATA
2044: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2049: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2045:
2046: WHEN OTHERS THEN
2047: l_sqlcode := SQLCODE;
2048: l_sqlerrm := SQLERRM;
2049: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2050: P_API_NAME => L_API_NAME
2051: ,P_PKG_NAME => G_PKG_NAME
2052: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2053: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2052: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2048: l_sqlerrm := SQLERRM;
2049: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2050: P_API_NAME => L_API_NAME
2051: ,P_PKG_NAME => G_PKG_NAME
2052: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2053: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2054: ,P_SQLCODE => l_sqlcode
2055: ,P_SQLERRM => l_sqlerrm
2056: ,P_ROLLBACK_FLAG => 'N'

Line 2053: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2049: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2050: P_API_NAME => L_API_NAME
2051: ,P_PKG_NAME => G_PKG_NAME
2052: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2053: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2054: ,P_SQLCODE => l_sqlcode
2055: ,P_SQLERRM => l_sqlerrm
2056: ,P_ROLLBACK_FLAG => 'N'
2057: ,X_MSG_COUNT => X_MSG_COUNT

Line 2267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2263: );
2264:
2265: EXCEPTION
2266: WHEN FND_API.G_EXC_ERROR THEN
2267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2268: P_API_NAME => L_API_NAME
2269: ,P_PKG_NAME => G_PKG_NAME
2270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2268: P_API_NAME => L_API_NAME
2269: ,P_PKG_NAME => G_PKG_NAME
2270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2272: ,P_ROLLBACK_FLAG => 'N'
2273: ,X_MSG_COUNT => X_MSG_COUNT
2274: ,X_MSG_DATA => X_MSG_DATA
2275: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2273: ,X_MSG_COUNT => X_MSG_COUNT
2274: ,X_MSG_DATA => X_MSG_DATA
2275: ,X_RETURN_STATUS => X_RETURN_STATUS);
2276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2278: P_API_NAME => L_API_NAME
2279: ,P_PKG_NAME => G_PKG_NAME
2280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2278: P_API_NAME => L_API_NAME
2279: ,P_PKG_NAME => G_PKG_NAME
2280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2282: ,P_ROLLBACK_FLAG => 'N'
2283: ,X_MSG_COUNT => X_MSG_COUNT
2284: ,X_MSG_DATA => X_MSG_DATA
2285: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2289: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2285: ,X_RETURN_STATUS => X_RETURN_STATUS);
2286: WHEN OTHERS THEN
2287: l_sqlcode := SQLCODE;
2288: l_sqlerrm := SQLERRM;
2289: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2290: P_API_NAME => L_API_NAME
2291: ,P_PKG_NAME => G_PKG_NAME
2292: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2293: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2292: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2288: l_sqlerrm := SQLERRM;
2289: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2290: P_API_NAME => L_API_NAME
2291: ,P_PKG_NAME => G_PKG_NAME
2292: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2293: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2294: ,P_ROLLBACK_FLAG => 'N'
2295: ,P_SQLCODE => l_Sqlcode
2296: ,P_SQLERRM => l_Sqlerrm

Line 2293: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2289: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2290: P_API_NAME => L_API_NAME
2291: ,P_PKG_NAME => G_PKG_NAME
2292: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2293: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2294: ,P_ROLLBACK_FLAG => 'N'
2295: ,P_SQLCODE => l_Sqlcode
2296: ,P_SQLERRM => l_Sqlerrm
2297: ,X_MSG_COUNT => X_MSG_COUNT

Line 2523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2519: );
2520:
2521: EXCEPTION
2522: WHEN FND_API.G_EXC_ERROR THEN
2523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2524: P_API_NAME => L_API_NAME
2525: ,P_PKG_NAME => G_PKG_NAME
2526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2524: P_API_NAME => L_API_NAME
2525: ,P_PKG_NAME => G_PKG_NAME
2526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2528: ,P_ROLLBACK_FLAG => 'N'
2529: ,X_MSG_COUNT => X_MSG_COUNT
2530: ,X_MSG_DATA => X_MSG_DATA
2531: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2530: ,X_MSG_DATA => X_MSG_DATA
2531: ,X_RETURN_STATUS => X_RETURN_STATUS);
2532:
2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2535: P_API_NAME => L_API_NAME
2536: ,P_PKG_NAME => G_PKG_NAME
2537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2535: P_API_NAME => L_API_NAME
2536: ,P_PKG_NAME => G_PKG_NAME
2537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2539: ,P_ROLLBACK_FLAG => 'N'
2540: ,X_MSG_COUNT => X_MSG_COUNT
2541: ,X_MSG_DATA => X_MSG_DATA
2542: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2547: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2543:
2544: WHEN OTHERS THEN
2545: l_sqlcode := SQLCODE;
2546: l_sqlerrm := SQLERRM;
2547: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2548: P_API_NAME => L_API_NAME
2549: ,P_PKG_NAME => G_PKG_NAME
2550: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2551: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2550: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2546: l_sqlerrm := SQLERRM;
2547: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2548: P_API_NAME => L_API_NAME
2549: ,P_PKG_NAME => G_PKG_NAME
2550: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2551: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2552: ,P_ROLLBACK_FLAG => 'N'
2553: ,P_SQLCODE => l_Sqlcode
2554: ,P_SQLERRM => l_Sqlerrm

Line 2551: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2547: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2548: P_API_NAME => L_API_NAME
2549: ,P_PKG_NAME => G_PKG_NAME
2550: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2551: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2552: ,P_ROLLBACK_FLAG => 'N'
2553: ,P_SQLCODE => l_Sqlcode
2554: ,P_SQLERRM => l_Sqlerrm
2555: ,X_MSG_COUNT => X_MSG_COUNT

Line 2724: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2720: );
2721:
2722: EXCEPTION
2723: WHEN FND_API.G_EXC_ERROR THEN
2724: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2725: P_API_NAME => L_API_NAME
2726: ,P_PKG_NAME => G_PKG_NAME
2727: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2728: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2728: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2724: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2725: P_API_NAME => L_API_NAME
2726: ,P_PKG_NAME => G_PKG_NAME
2727: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2728: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2729: ,P_ROLLBACK_FLAG => 'N'
2730: ,X_MSG_COUNT => X_MSG_COUNT
2731: ,X_MSG_DATA => X_MSG_DATA
2732: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2731: ,X_MSG_DATA => X_MSG_DATA
2732: ,X_RETURN_STATUS => X_RETURN_STATUS);
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2736: P_API_NAME => L_API_NAME
2737: ,P_PKG_NAME => G_PKG_NAME
2738: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2736: P_API_NAME => L_API_NAME
2737: ,P_PKG_NAME => G_PKG_NAME
2738: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2740: ,P_ROLLBACK_FLAG => 'N'
2741: ,X_MSG_COUNT => X_MSG_COUNT
2742: ,X_MSG_DATA => X_MSG_DATA
2743: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2744:
2745: WHEN OTHERS THEN
2746: l_sqlcode := SQLCODE;
2747: l_sqlerrm := SQLERRM;
2748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2749: P_API_NAME => L_API_NAME
2750: ,P_PKG_NAME => G_PKG_NAME
2751: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2751: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

2747: l_sqlerrm := SQLERRM;
2748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2749: P_API_NAME => L_API_NAME
2750: ,P_PKG_NAME => G_PKG_NAME
2751: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2753: ,P_ROLLBACK_FLAG => 'N'
2754: ,P_SQLCODE => l_sqlcode
2755: ,P_SQLERRM => l_sqlerrm

Line 2752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2749: P_API_NAME => L_API_NAME
2750: ,P_PKG_NAME => G_PKG_NAME
2751: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
2752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2753: ,P_ROLLBACK_FLAG => 'N'
2754: ,P_SQLCODE => l_sqlcode
2755: ,P_SQLERRM => l_sqlerrm
2756: ,X_MSG_COUNT => X_MSG_COUNT

Line 3039: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3035: );
3036: EXCEPTION
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: retcode := 2;
3039: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3040: P_API_NAME => L_API_NAME
3041: ,P_PKG_NAME => G_PKG_NAME
3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3043: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3043: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3039: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3040: P_API_NAME => L_API_NAME
3041: ,P_PKG_NAME => G_PKG_NAME
3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3043: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3044: ,P_ROLLBACK_FLAG => 'N'
3045: ,X_MSG_COUNT => X_MSG_COUNT
3046: ,X_MSG_DATA => X_MSG_DATA
3047: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3051: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3047: ,X_RETURN_STATUS => X_RETURN_STATUS);
3048:
3049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3050: retcode := 2;
3051: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3052: P_API_NAME => L_API_NAME
3053: ,P_PKG_NAME => G_PKG_NAME
3054: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3055: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3055: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3051: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3052: P_API_NAME => L_API_NAME
3053: ,P_PKG_NAME => G_PKG_NAME
3054: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3055: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3056: ,P_ROLLBACK_FLAG => 'N'
3057: ,X_MSG_COUNT => X_MSG_COUNT
3058: ,X_MSG_DATA => X_MSG_DATA
3059: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3066: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3062: l_sqlcode := SQLCODE;
3063: l_sqlerrm := SQLERRM;
3064: retcode := 2;
3065: errbuf := SQLERRM;
3066: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3067: P_API_NAME => L_API_NAME
3068: ,P_PKG_NAME => G_PKG_NAME
3069: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3070: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3069: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

3065: errbuf := SQLERRM;
3066: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3067: P_API_NAME => L_API_NAME
3068: ,P_PKG_NAME => G_PKG_NAME
3069: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3070: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3071: ,P_ROLLBACK_FLAG => 'N'
3072: ,P_SQLCODE => l_sqlcode
3073: ,P_SQLERRM => l_sqlerrm

Line 3070: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3066: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3067: P_API_NAME => L_API_NAME
3068: ,P_PKG_NAME => G_PKG_NAME
3069: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3070: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3071: ,P_ROLLBACK_FLAG => 'N'
3072: ,P_SQLCODE => l_sqlcode
3073: ,P_SQLERRM => l_sqlerrm
3074: ,X_MSG_COUNT => X_MSG_COUNT

Line 3194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3190: );
3191:
3192: EXCEPTION
3193: WHEN FND_API.G_EXC_ERROR THEN
3194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3195: P_API_NAME => L_API_NAME
3196: ,P_PKG_NAME => G_PKG_NAME
3197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3195: P_API_NAME => L_API_NAME
3196: ,P_PKG_NAME => G_PKG_NAME
3197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3199: ,P_ROLLBACK_FLAG => 'N'
3200: ,X_MSG_COUNT => X_MSG_COUNT
3201: ,X_MSG_DATA => X_MSG_DATA
3202: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3205: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3201: ,X_MSG_DATA => X_MSG_DATA
3202: ,X_RETURN_STATUS => X_RETURN_STATUS);
3203:
3204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3205: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3206: P_API_NAME => L_API_NAME
3207: ,P_PKG_NAME => G_PKG_NAME
3208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3209: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3209: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3205: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3206: P_API_NAME => L_API_NAME
3207: ,P_PKG_NAME => G_PKG_NAME
3208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3209: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3210: ,P_ROLLBACK_FLAG => 'N'
3211: ,X_MSG_COUNT => X_MSG_COUNT
3212: ,X_MSG_DATA => X_MSG_DATA
3213: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3218: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3214:
3215: WHEN OTHERS THEN
3216: l_sqlcode := SQLCODE;
3217: l_sqlerrm := SQLERRM;
3218: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3219: P_API_NAME => L_API_NAME
3220: ,P_PKG_NAME => G_PKG_NAME
3221: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3222: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 3221: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

3217: l_sqlerrm := SQLERRM;
3218: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3219: P_API_NAME => L_API_NAME
3220: ,P_PKG_NAME => G_PKG_NAME
3221: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3222: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3223: ,P_ROLLBACK_FLAG => 'N'
3224: ,P_SQLCODE => l_sqlcode
3225: ,P_SQLERRM => l_sqlerrm

Line 3222: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

3218: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3219: P_API_NAME => L_API_NAME
3220: ,P_PKG_NAME => G_PKG_NAME
3221: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
3222: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3223: ,P_ROLLBACK_FLAG => 'N'
3224: ,P_SQLCODE => l_sqlcode
3225: ,P_SQLERRM => l_sqlerrm
3226: ,X_MSG_COUNT => X_MSG_COUNT