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

337: EXCEPTION
338: WHEN EXCP_USER_DEFINED THEN
339: Rollback to do_create_ship_to_location_PUB;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
346: ,X_MSG_COUNT => x_MSG_COUNT
347: ,X_MSG_DATA => x_MSG_DATA
348: ,X_RETURN_STATUS => x_RETURN_STATUS);
349: WHEN FND_API.G_EXC_ERROR THEN

Line 350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

346: ,X_MSG_COUNT => x_MSG_COUNT
347: ,X_MSG_DATA => x_MSG_DATA
348: ,X_RETURN_STATUS => x_RETURN_STATUS);
349: WHEN FND_API.G_EXC_ERROR THEN
350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
355: ,X_MSG_COUNT => x_MSG_COUNT
356: ,X_MSG_DATA => x_MSG_DATA
357: ,X_RETURN_STATUS => x_RETURN_STATUS);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 359: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

355: ,X_MSG_COUNT => x_MSG_COUNT
356: ,X_MSG_DATA => x_MSG_DATA
357: ,X_RETURN_STATUS => x_RETURN_STATUS);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
360: P_API_NAME => L_API_NAME
361: ,P_PKG_NAME => G_PKG_NAME
362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
363: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 363: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

359: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
360: P_API_NAME => L_API_NAME
361: ,P_PKG_NAME => G_PKG_NAME
362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
363: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
364: ,X_MSG_COUNT => x_MSG_COUNT
365: ,X_MSG_DATA => x_MSG_DATA
366: ,X_RETURN_STATUS => x_RETURN_STATUS);
367: WHEN OTHERS THEN

Line 597: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

593: EXCEPTION
594: WHEN EXCP_USER_DEFINED THEN
595: Rollback to do_update_ship_to_location_PUB;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

597: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
602: ,X_MSG_COUNT => x_MSG_COUNT
603: ,X_MSG_DATA => x_MSG_DATA
604: ,X_RETURN_STATUS => x_RETURN_STATUS);
605: WHEN FND_API.G_EXC_ERROR THEN

Line 606: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

602: ,X_MSG_COUNT => x_MSG_COUNT
603: ,X_MSG_DATA => x_MSG_DATA
604: ,X_RETURN_STATUS => x_RETURN_STATUS);
605: WHEN FND_API.G_EXC_ERROR THEN
606: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
607: P_API_NAME => L_API_NAME
608: ,P_PKG_NAME => G_PKG_NAME
609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
610: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 610: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

606: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
607: P_API_NAME => L_API_NAME
608: ,P_PKG_NAME => G_PKG_NAME
609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
610: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
611: ,X_MSG_COUNT => x_MSG_COUNT
612: ,X_MSG_DATA => x_MSG_DATA
613: ,X_RETURN_STATUS => x_RETURN_STATUS);
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 615: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

611: ,X_MSG_COUNT => x_MSG_COUNT
612: ,X_MSG_DATA => x_MSG_DATA
613: ,X_RETURN_STATUS => x_RETURN_STATUS);
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
616: P_API_NAME => L_API_NAME
617: ,P_PKG_NAME => G_PKG_NAME
618: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
619: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 619: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

615: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
616: P_API_NAME => L_API_NAME
617: ,P_PKG_NAME => G_PKG_NAME
618: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
619: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
620: ,X_MSG_COUNT => x_MSG_COUNT
621: ,X_MSG_DATA => x_MSG_DATA
622: ,X_RETURN_STATUS => x_RETURN_STATUS);
623: WHEN OTHERS THEN

Line 946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

942: EXCEPTION
943: WHEN EXCP_USER_DEFINED THEN
944: Rollback to do_create_site_use_PUB;
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
947: P_API_NAME => L_API_NAME
948: ,P_PKG_NAME => G_PKG_NAME
949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
947: P_API_NAME => L_API_NAME
948: ,P_PKG_NAME => G_PKG_NAME
949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
951: ,X_MSG_COUNT => x_MSG_COUNT
952: ,X_MSG_DATA => x_MSG_DATA
953: ,X_RETURN_STATUS => x_RETURN_STATUS);
954: WHEN FND_API.G_EXC_ERROR THEN

Line 955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

951: ,X_MSG_COUNT => x_MSG_COUNT
952: ,X_MSG_DATA => x_MSG_DATA
953: ,X_RETURN_STATUS => x_RETURN_STATUS);
954: WHEN FND_API.G_EXC_ERROR THEN
955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
956: P_API_NAME => L_API_NAME
957: ,P_PKG_NAME => G_PKG_NAME
958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
956: P_API_NAME => L_API_NAME
957: ,P_PKG_NAME => G_PKG_NAME
958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
960: ,X_MSG_COUNT => x_MSG_COUNT
961: ,X_MSG_DATA => x_MSG_DATA
962: ,X_RETURN_STATUS => x_RETURN_STATUS);
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

960: ,X_MSG_COUNT => x_MSG_COUNT
961: ,X_MSG_DATA => x_MSG_DATA
962: ,X_RETURN_STATUS => x_RETURN_STATUS);
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => L_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => L_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
969: ,X_MSG_COUNT => x_MSG_COUNT
970: ,X_MSG_DATA => x_MSG_DATA
971: ,X_RETURN_STATUS => x_RETURN_STATUS);
972: WHEN OTHERS THEN

Line 2097: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2093: EXCEPTION
2094: WHEN EXCP_USER_DEFINED THEN
2095: Rollback to do_update_site_use_PUB;
2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2098: P_API_NAME => L_API_NAME
2099: ,P_PKG_NAME => G_PKG_NAME
2100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2101: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2101: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2097: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2098: P_API_NAME => L_API_NAME
2099: ,P_PKG_NAME => G_PKG_NAME
2100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2101: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2102: ,X_MSG_COUNT => x_MSG_COUNT
2103: ,X_MSG_DATA => x_MSG_DATA
2104: ,X_RETURN_STATUS => x_RETURN_STATUS);
2105: WHEN FND_API.G_EXC_ERROR THEN

Line 2106: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2102: ,X_MSG_COUNT => x_MSG_COUNT
2103: ,X_MSG_DATA => x_MSG_DATA
2104: ,X_RETURN_STATUS => x_RETURN_STATUS);
2105: WHEN FND_API.G_EXC_ERROR THEN
2106: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2107: P_API_NAME => L_API_NAME
2108: ,P_PKG_NAME => G_PKG_NAME
2109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2110: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2110: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2106: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2107: P_API_NAME => L_API_NAME
2108: ,P_PKG_NAME => G_PKG_NAME
2109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2110: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2111: ,X_MSG_COUNT => x_MSG_COUNT
2112: ,X_MSG_DATA => x_MSG_DATA
2113: ,X_RETURN_STATUS => x_RETURN_STATUS);
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2115: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2111: ,X_MSG_COUNT => x_MSG_COUNT
2112: ,X_MSG_DATA => x_MSG_DATA
2113: ,X_RETURN_STATUS => x_RETURN_STATUS);
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2116: P_API_NAME => L_API_NAME
2117: ,P_PKG_NAME => G_PKG_NAME
2118: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2119: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 2119: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

2115: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2116: P_API_NAME => L_API_NAME
2117: ,P_PKG_NAME => G_PKG_NAME
2118: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2119: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2120: ,X_MSG_COUNT => x_MSG_COUNT
2121: ,X_MSG_DATA => x_MSG_DATA
2122: ,X_RETURN_STATUS => x_RETURN_STATUS);
2123: WHEN OTHERS THEN

Line 3730: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3726: EXCEPTION
3727: WHEN EXCP_USER_DEFINED THEN
3728: Rollback to ship_to_address_handler_PUB;
3729: x_return_status := FND_API.G_RET_STS_ERROR;
3730: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3731: P_API_NAME => L_API_NAME
3732: ,P_PKG_NAME => G_PKG_NAME
3733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3734: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 3734: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

3730: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3731: P_API_NAME => L_API_NAME
3732: ,P_PKG_NAME => G_PKG_NAME
3733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3734: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3735: ,X_MSG_COUNT => X_MSG_COUNT
3736: ,X_MSG_DATA => X_MSG_DATA
3737: ,X_RETURN_STATUS => X_RETURN_STATUS);
3738: WHEN FND_API.G_EXC_ERROR THEN

Line 3739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3735: ,X_MSG_COUNT => X_MSG_COUNT
3736: ,X_MSG_DATA => X_MSG_DATA
3737: ,X_RETURN_STATUS => X_RETURN_STATUS);
3738: WHEN FND_API.G_EXC_ERROR THEN
3739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3740: P_API_NAME => L_API_NAME
3741: ,P_PKG_NAME => G_PKG_NAME
3742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 3743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

3739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3740: P_API_NAME => L_API_NAME
3741: ,P_PKG_NAME => G_PKG_NAME
3742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3744: ,X_MSG_COUNT => X_MSG_COUNT
3745: ,X_MSG_DATA => X_MSG_DATA
3746: ,X_RETURN_STATUS => X_RETURN_STATUS);
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3744: ,X_MSG_COUNT => X_MSG_COUNT
3745: ,X_MSG_DATA => X_MSG_DATA
3746: ,X_RETURN_STATUS => X_RETURN_STATUS);
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3749: P_API_NAME => L_API_NAME
3750: ,P_PKG_NAME => G_PKG_NAME
3751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 3752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

3748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3749: P_API_NAME => L_API_NAME
3750: ,P_PKG_NAME => G_PKG_NAME
3751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3753: ,X_MSG_COUNT => X_MSG_COUNT
3754: ,X_MSG_DATA => X_MSG_DATA
3755: ,X_RETURN_STATUS => X_RETURN_STATUS);
3756: WHEN OTHERS THEN

Line 3946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3942: fnd_msg_pub.count_and_get
3943: ( p_count => x_msg_count
3944: , p_data => x_msg_data);
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3947: P_API_NAME => L_API_NAME
3948: ,P_PKG_NAME => G_PKG_NAME
3949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 3950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

3946: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3947: P_API_NAME => L_API_NAME
3948: ,P_PKG_NAME => G_PKG_NAME
3949: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3950: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3951: ,X_MSG_COUNT => x_MSG_COUNT
3952: ,X_MSG_DATA => x_MSG_DATA
3953: ,X_RETURN_STATUS => x_RETURN_STATUS);
3954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

3951: ,X_MSG_COUNT => x_MSG_COUNT
3952: ,X_MSG_DATA => x_MSG_DATA
3953: ,X_RETURN_STATUS => x_RETURN_STATUS);
3954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3956: P_API_NAME => L_API_NAME
3957: ,P_PKG_NAME => G_PKG_NAME
3958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 3959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

3955: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3956: P_API_NAME => L_API_NAME
3957: ,P_PKG_NAME => G_PKG_NAME
3958: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3959: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3960: ,X_MSG_COUNT => x_MSG_COUNT
3961: ,X_MSG_DATA => x_MSG_DATA
3962: ,X_RETURN_STATUS => x_RETURN_STATUS);
3963: WHEN OTHERS THEN

Line 4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4257: fnd_msg_pub.count_and_get
4258: ( p_count => x_msg_count
4259: , p_data => x_msg_data);
4260: WHEN FND_API.G_EXC_ERROR THEN
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4266: ,X_MSG_COUNT => x_MSG_COUNT
4267: ,X_MSG_DATA => x_MSG_DATA
4268: ,X_RETURN_STATUS => x_RETURN_STATUS);
4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4266: ,X_MSG_COUNT => x_MSG_COUNT
4267: ,X_MSG_DATA => x_MSG_DATA
4268: ,X_RETURN_STATUS => x_RETURN_STATUS);
4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4275: ,X_MSG_COUNT => x_MSG_COUNT
4276: ,X_MSG_DATA => x_MSG_DATA
4277: ,X_RETURN_STATUS => x_RETURN_STATUS);
4278: WHEN OTHERS THEN

Line 4572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4568: END IF;
4569: END If;
4570: EXCEPTION
4571: WHEN FND_API.G_EXC_ERROR THEN
4572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4577: ,X_MSG_COUNT => X_MSG_COUNT
4578: ,X_MSG_DATA => X_MSG_DATA
4579: ,X_RETURN_STATUS => X_RETURN_STATUS);
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4581: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

4577: ,X_MSG_COUNT => X_MSG_COUNT
4578: ,X_MSG_DATA => X_MSG_DATA
4579: ,X_RETURN_STATUS => X_RETURN_STATUS);
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4582: P_API_NAME => L_API_NAME
4583: ,P_PKG_NAME => G_PKG_NAME
4584: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4585: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 4585: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

4581: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4582: P_API_NAME => L_API_NAME
4583: ,P_PKG_NAME => G_PKG_NAME
4584: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4585: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4586: ,X_MSG_COUNT => X_MSG_COUNT
4587: ,X_MSG_DATA => X_MSG_DATA
4588: ,X_RETURN_STATUS => X_RETURN_STATUS);
4589: WHEN OTHERS THEN