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

Line 797: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

793: end if;
794:
795: Rollback to do_create_ship_to_location_PUB;
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
798: P_API_NAME => L_API_NAME
799: ,P_PKG_NAME => G_PKG_NAME
800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
801: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 801: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

797: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
798: P_API_NAME => L_API_NAME
799: ,P_PKG_NAME => G_PKG_NAME
800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
801: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
802: ,X_MSG_COUNT => x_MSG_COUNT
803: ,X_MSG_DATA => x_MSG_DATA
804: ,X_RETURN_STATUS => x_RETURN_STATUS);
805: WHEN FND_API.G_EXC_ERROR THEN

Line 813: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

809: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
810: 'In FND_API.G_EXC_ERROR block');
811: end if;
812:
813: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
814: P_API_NAME => L_API_NAME
815: ,P_PKG_NAME => G_PKG_NAME
816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
817: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 817: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

813: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
814: P_API_NAME => L_API_NAME
815: ,P_PKG_NAME => G_PKG_NAME
816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
817: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
818: ,X_MSG_COUNT => x_MSG_COUNT
819: ,X_MSG_DATA => x_MSG_DATA
820: ,X_RETURN_STATUS => x_RETURN_STATUS);
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

825: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
826: 'In FND_API.G_EXC_UNEXPECTED_ERROR block');
827: end if;
828:
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
834: ,X_MSG_COUNT => x_MSG_COUNT
835: ,X_MSG_DATA => x_MSG_DATA
836: ,X_RETURN_STATUS => x_RETURN_STATUS);
837: WHEN OTHERS THEN

Line 1077: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1073: EXCEPTION
1074: WHEN EXCP_USER_DEFINED THEN
1075: Rollback to do_update_ship_to_location_PUB;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME
1079: ,P_PKG_NAME => G_PKG_NAME
1080: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1081: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1081: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1077: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME
1079: ,P_PKG_NAME => G_PKG_NAME
1080: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1081: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1082: ,X_MSG_COUNT => x_MSG_COUNT
1083: ,X_MSG_DATA => x_MSG_DATA
1084: ,X_RETURN_STATUS => x_RETURN_STATUS);
1085: WHEN FND_API.G_EXC_ERROR THEN

Line 1086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1082: ,X_MSG_COUNT => x_MSG_COUNT
1083: ,X_MSG_DATA => x_MSG_DATA
1084: ,X_RETURN_STATUS => x_RETURN_STATUS);
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1087: P_API_NAME => L_API_NAME
1088: ,P_PKG_NAME => G_PKG_NAME
1089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1086: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1087: P_API_NAME => L_API_NAME
1088: ,P_PKG_NAME => G_PKG_NAME
1089: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1090: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1091: ,X_MSG_COUNT => x_MSG_COUNT
1092: ,X_MSG_DATA => x_MSG_DATA
1093: ,X_RETURN_STATUS => x_RETURN_STATUS);
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1091: ,X_MSG_COUNT => x_MSG_COUNT
1092: ,X_MSG_DATA => x_MSG_DATA
1093: ,X_RETURN_STATUS => x_RETURN_STATUS);
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 1448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1444: EXCEPTION
1445: WHEN EXCP_USER_DEFINED THEN
1446: Rollback to do_create_site_use_PUB;
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1453: ,X_MSG_COUNT => x_MSG_COUNT
1454: ,X_MSG_DATA => x_MSG_DATA
1455: ,X_RETURN_STATUS => x_RETURN_STATUS);
1456: WHEN FND_API.G_EXC_ERROR THEN

Line 1457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1453: ,X_MSG_COUNT => x_MSG_COUNT
1454: ,X_MSG_DATA => x_MSG_DATA
1455: ,X_RETURN_STATUS => x_RETURN_STATUS);
1456: WHEN FND_API.G_EXC_ERROR THEN
1457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1458: P_API_NAME => L_API_NAME
1459: ,P_PKG_NAME => G_PKG_NAME
1460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1461: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1461: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1458: P_API_NAME => L_API_NAME
1459: ,P_PKG_NAME => G_PKG_NAME
1460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1461: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1462: ,X_MSG_COUNT => x_MSG_COUNT
1463: ,X_MSG_DATA => x_MSG_DATA
1464: ,X_RETURN_STATUS => x_RETURN_STATUS);
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1466: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1462: ,X_MSG_COUNT => x_MSG_COUNT
1463: ,X_MSG_DATA => x_MSG_DATA
1464: ,X_RETURN_STATUS => x_RETURN_STATUS);
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1467: P_API_NAME => L_API_NAME
1468: ,P_PKG_NAME => G_PKG_NAME
1469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1470: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1470: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1466: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1467: P_API_NAME => L_API_NAME
1468: ,P_PKG_NAME => G_PKG_NAME
1469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1470: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1471: ,X_MSG_COUNT => x_MSG_COUNT
1472: ,X_MSG_DATA => x_MSG_DATA
1473: ,X_RETURN_STATUS => x_RETURN_STATUS);
1474: WHEN OTHERS THEN

Line 2599: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2595: EXCEPTION
2596: WHEN EXCP_USER_DEFINED THEN
2597: Rollback to do_update_site_use_PUB;
2598: x_return_status := FND_API.G_RET_STS_ERROR;
2599: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2600: P_API_NAME => L_API_NAME
2601: ,P_PKG_NAME => G_PKG_NAME
2602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2603: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2603: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2599: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2600: P_API_NAME => L_API_NAME
2601: ,P_PKG_NAME => G_PKG_NAME
2602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2603: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2604: ,X_MSG_COUNT => x_MSG_COUNT
2605: ,X_MSG_DATA => x_MSG_DATA
2606: ,X_RETURN_STATUS => x_RETURN_STATUS);
2607: WHEN FND_API.G_EXC_ERROR THEN

Line 2608: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2604: ,X_MSG_COUNT => x_MSG_COUNT
2605: ,X_MSG_DATA => x_MSG_DATA
2606: ,X_RETURN_STATUS => x_RETURN_STATUS);
2607: WHEN FND_API.G_EXC_ERROR THEN
2608: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2609: P_API_NAME => L_API_NAME
2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2612: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2612: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2608: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2609: P_API_NAME => L_API_NAME
2610: ,P_PKG_NAME => G_PKG_NAME
2611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2612: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2613: ,X_MSG_COUNT => x_MSG_COUNT
2614: ,X_MSG_DATA => x_MSG_DATA
2615: ,X_RETURN_STATUS => x_RETURN_STATUS);
2616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2613: ,X_MSG_COUNT => x_MSG_COUNT
2614: ,X_MSG_DATA => x_MSG_DATA
2615: ,X_RETURN_STATUS => x_RETURN_STATUS);
2616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2618: P_API_NAME => L_API_NAME
2619: ,P_PKG_NAME => G_PKG_NAME
2620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2618: P_API_NAME => L_API_NAME
2619: ,P_PKG_NAME => G_PKG_NAME
2620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2622: ,X_MSG_COUNT => x_MSG_COUNT
2623: ,X_MSG_DATA => x_MSG_DATA
2624: ,X_RETURN_STATUS => x_RETURN_STATUS);
2625: WHEN OTHERS THEN

Line 4312: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4308: EXCEPTION
4309: WHEN EXCP_USER_DEFINED THEN
4310: Rollback to ship_to_address_handler_PUB;
4311: x_return_status := FND_API.G_RET_STS_ERROR;
4312: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4313: P_API_NAME => L_API_NAME
4314: ,P_PKG_NAME => G_PKG_NAME
4315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4316: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4316: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4312: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4313: P_API_NAME => L_API_NAME
4314: ,P_PKG_NAME => G_PKG_NAME
4315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4316: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4317: ,X_MSG_COUNT => X_MSG_COUNT
4318: ,X_MSG_DATA => X_MSG_DATA
4319: ,X_RETURN_STATUS => X_RETURN_STATUS);
4320: WHEN FND_API.G_EXC_ERROR THEN

Line 4321: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4317: ,X_MSG_COUNT => X_MSG_COUNT
4318: ,X_MSG_DATA => X_MSG_DATA
4319: ,X_RETURN_STATUS => X_RETURN_STATUS);
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4322: P_API_NAME => L_API_NAME
4323: ,P_PKG_NAME => G_PKG_NAME
4324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4325: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4325: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4321: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4322: P_API_NAME => L_API_NAME
4323: ,P_PKG_NAME => G_PKG_NAME
4324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4325: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4326: ,X_MSG_COUNT => X_MSG_COUNT
4327: ,X_MSG_DATA => X_MSG_DATA
4328: ,X_RETURN_STATUS => X_RETURN_STATUS);
4329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4330: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4326: ,X_MSG_COUNT => X_MSG_COUNT
4327: ,X_MSG_DATA => X_MSG_DATA
4328: ,X_RETURN_STATUS => X_RETURN_STATUS);
4329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4330: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4331: P_API_NAME => L_API_NAME
4332: ,P_PKG_NAME => G_PKG_NAME
4333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4334: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4334: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4330: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4331: P_API_NAME => L_API_NAME
4332: ,P_PKG_NAME => G_PKG_NAME
4333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4334: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4335: ,X_MSG_COUNT => X_MSG_COUNT
4336: ,X_MSG_DATA => X_MSG_DATA
4337: ,X_RETURN_STATUS => X_RETURN_STATUS);
4338: WHEN OTHERS THEN

Line 4528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4524: fnd_msg_pub.count_and_get
4525: ( p_count => x_msg_count
4526: , p_data => x_msg_data);
4527: WHEN FND_API.G_EXC_ERROR THEN
4528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4529: P_API_NAME => L_API_NAME
4530: ,P_PKG_NAME => G_PKG_NAME
4531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4529: P_API_NAME => L_API_NAME
4530: ,P_PKG_NAME => G_PKG_NAME
4531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4533: ,X_MSG_COUNT => x_MSG_COUNT
4534: ,X_MSG_DATA => x_MSG_DATA
4535: ,X_RETURN_STATUS => x_RETURN_STATUS);
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4533: ,X_MSG_COUNT => x_MSG_COUNT
4534: ,X_MSG_DATA => x_MSG_DATA
4535: ,X_RETURN_STATUS => x_RETURN_STATUS);
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4538: P_API_NAME => L_API_NAME
4539: ,P_PKG_NAME => G_PKG_NAME
4540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4537: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4538: P_API_NAME => L_API_NAME
4539: ,P_PKG_NAME => G_PKG_NAME
4540: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4541: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4542: ,X_MSG_COUNT => x_MSG_COUNT
4543: ,X_MSG_DATA => x_MSG_DATA
4544: ,X_RETURN_STATUS => x_RETURN_STATUS);
4545: WHEN OTHERS THEN

Line 5079: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

5075: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5076: 'In EXCP_USER_DEFINED block');
5077: end if;
5078: WHEN FND_API.G_EXC_ERROR THEN
5079: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5080: P_API_NAME => L_API_NAME
5081: ,P_PKG_NAME => G_PKG_NAME
5082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5083: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 5083: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

5079: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5080: P_API_NAME => L_API_NAME
5081: ,P_PKG_NAME => G_PKG_NAME
5082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5083: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5084: ,X_MSG_COUNT => x_MSG_COUNT
5085: ,X_MSG_DATA => x_MSG_DATA
5086: ,X_RETURN_STATUS => x_RETURN_STATUS);
5087: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 5093: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

5089: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5090: 'In FND_API.G_EXC_ERROR block');
5091: end if;
5092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5093: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5094: P_API_NAME => L_API_NAME
5095: ,P_PKG_NAME => G_PKG_NAME
5096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5097: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 5097: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

5093: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5094: P_API_NAME => L_API_NAME
5095: ,P_PKG_NAME => G_PKG_NAME
5096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5097: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5098: ,X_MSG_COUNT => x_MSG_COUNT
5099: ,X_MSG_DATA => x_MSG_DATA
5100: ,X_RETURN_STATUS => x_RETURN_STATUS);
5101: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 5473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

5469: END IF;
5470: END If;
5471: EXCEPTION
5472: WHEN FND_API.G_EXC_ERROR THEN
5473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5474: P_API_NAME => L_API_NAME
5475: ,P_PKG_NAME => G_PKG_NAME
5476: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5477: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 5477: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

5473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5474: P_API_NAME => L_API_NAME
5475: ,P_PKG_NAME => G_PKG_NAME
5476: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5477: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5478: ,X_MSG_COUNT => X_MSG_COUNT
5479: ,X_MSG_DATA => X_MSG_DATA
5480: ,X_RETURN_STATUS => X_RETURN_STATUS);
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5482: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

5478: ,X_MSG_COUNT => X_MSG_COUNT
5479: ,X_MSG_DATA => X_MSG_DATA
5480: ,X_RETURN_STATUS => X_RETURN_STATUS);
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5483: P_API_NAME => L_API_NAME
5484: ,P_PKG_NAME => G_PKG_NAME
5485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5486: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 5486: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

5482: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5483: P_API_NAME => L_API_NAME
5484: ,P_PKG_NAME => G_PKG_NAME
5485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5486: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5487: ,X_MSG_COUNT => X_MSG_COUNT
5488: ,X_MSG_DATA => X_MSG_DATA
5489: ,X_RETURN_STATUS => X_RETURN_STATUS);
5490: WHEN OTHERS THEN