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_PL_SHIP_UTIL dependencies on FND_MSG_PUB

Line 194: FND_MSG_PUB.initialize;

190: BEGIN
191: SAVEPOINT Confirm_Ship_PUB;
192: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
193: -- initialize message list
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- Standard call to check for call compatibility.
198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 212: FND_MSG_PUB.ADD;

208: -- validate p_organization_id
209: IF p_organization_id IS NULL THEN
210: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
211: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: ELSE
215: IF p_validation_level = fnd_api.g_valid_level_full THEN
216: BEGIN

Line 223: FND_MSG_PUB.ADD;

219: where organization_id = p_organization_id;
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
223: FND_MSG_PUB.ADD;
224: RAISE EXCP_USER_DEFINED;
225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 230: FND_MSG_PUB.ADD;

226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END;
233: END IF;
234: NULL;

Line 241: FND_MSG_PUB.ADD;

237: -- validate packlist_header_id
238: IF p_packlist_header_id IS NULL THEN
239: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
240: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: ELSE
244: IF p_validation_level = fnd_api.g_valid_level_full THEN
245: BEGIN

Line 254: FND_MSG_PUB.ADD;

250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
253: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
254: FND_MSG_PUB.ADD;
255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);

Line 261: FND_MSG_PUB.ADD;

257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: END;
264: END IF;
265: NULL;

Line 277: fnd_msg_pub.add;

273: IF C_Get_Packlist_Headers%NOTFOUND THEN
274: CLOSE C_Get_Packlist_Headers;
275: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
276: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
277: fnd_msg_pub.add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: CLOSE C_Get_Packlist_Headers;
281: l_packlist_headers_rec.date_shipped := sysdate;

Line 359: fnd_msg_pub.add;

355: IF C_Get_Temp_ID%NOTFOUND THEN
356: CLOSE C_Get_Temp_ID;
357: fnd_message.set_name ('CSP', 'CSP_NO_TXN_RECORD');
358: fnd_message.set_token ('PICKLIST_ID', to_char(l_packlist_line_rec.picklist_line_id), TRUE);
359: fnd_msg_pub.add;
360: RAISE EXCP_USER_DEFINED;
361: END IF;
362:
363: CLOSE C_Get_Temp_ID;

Line 372: fnd_msg_pub.add;

368: IF C_Get_Move_Order_Line_ID%NOTFOUND THEN
369: CLOSE C_Get_Move_Order_Line_ID;
370: fnd_message.set_name ('CSP', 'CSP_PACKLIST_MOVEORDER_ERRORS');
371: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
372: fnd_msg_pub.add;
373: RAISE EXCP_USER_DEFINED;
374: END IF;
375:
376: CLOSE C_Get_Move_Order_Line_ID;

Line 444: fnd_msg_pub.add;

440: END IF;
441: ELSE
442: fnd_message.set_name ('CSP', 'CSP_INVALID_MO_RECEIPT_TYPE');
443: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
444: fnd_msg_pub.add;
445: IF C_Get_packlist_lines%ISOPEN THEN
446: CLOSE C_Get_packlist_lines;
447: END IF;
448: RAISE EXCP_USER_DEFINED;

Line 458: fnd_msg_pub.add;

454: RAISE EXCP_NOSAVEPOINT;
455: WHEN NO_DATA_FOUND THEN
456: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER');
457: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
458: fnd_msg_pub.add;
459: RAISE EXCP_USER_DEFINED;
460: WHEN EXCP_USER_DEFINED THEN
461: RAISE EXCP_USER_DEFINED;
462: WHEN OTHERS THEN

Line 466: fnd_msg_pub.add;

462: WHEN OTHERS THEN
463: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
464: fnd_message.set_token('SQLEERM', sqlerrm, TRUE);
465: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
466: fnd_msg_pub.add;
467: RAISE EXCP_USER_DEFINED;
468:
469: END;
470: END;

Line 478: FND_MSG_PUB.ADD;

474: IF C_Get_packlist_lines%rowcount = 0 THEN
475: CLOSE C_Get_packlist_lines;
476: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
477: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
478: FND_MSG_PUB.ADD;
479: RAISE EXCP_USER_DEFINED;
480: END IF;
481:
482: IF C_Get_packlist_lines%ISOPEN THEN

Line 490: fnd_msg_pub.count_and_get

486: IF l_transaction_header_id IS NOT NULL THEN
487: IF NOT CSP_Mo_Mtltxns_Util.Call_Online (p_transaction_header_id => l_transaction_header_id) THEN
488: l_outcome := FALSE;
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: fnd_msg_pub.count_and_get
491: ( p_count => x_msg_count
492: , p_data => x_msg_data);
493: Return;
494: END IF;

Line 501: fnd_msg_pub.count_and_get

497: IF fnd_api.to_boolean(p_commit) THEN
498: commit work;
499: END IF;
500:
501: fnd_msg_pub.count_and_get
502: ( p_count => x_msg_count
503: , p_data => x_msg_data);
504: x_return_status := fnd_api.g_ret_sts_success;
505:

Line 509: fnd_msg_pub.count_and_get

505:
506: EXCEPTION
507: WHEN EXCP_NOSAVEPOINT THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: fnd_msg_pub.count_and_get
510: ( p_count => x_msg_count
511: , p_data => x_msg_data);
512: WHEN EXCP_USER_DEFINED THEN
513: Rollback to Confirm_Ship_PUB;

Line 515: fnd_msg_pub.count_and_get

511: , p_data => x_msg_data);
512: WHEN EXCP_USER_DEFINED THEN
513: Rollback to Confirm_Ship_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: fnd_msg_pub.count_and_get
516: ( p_count => x_msg_count
517: , p_data => x_msg_data);
518: WHEN FND_API.G_EXC_ERROR THEN
519: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

518: WHEN FND_API.G_EXC_ERROR THEN
519: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
520: P_API_NAME => L_API_NAME
521: ,P_PKG_NAME => G_PKG_NAME
522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
523: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
524: ,X_MSG_COUNT => X_MSG_COUNT
525: ,X_MSG_DATA => X_MSG_DATA
526: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
533: ,X_MSG_COUNT => X_MSG_COUNT
534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 541: fnd_msg_pub.add;

537: Rollback to Confirm_Ship_PUB;
538: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
540: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
541: fnd_msg_pub.add;
542: fnd_msg_pub.count_and_get
543: ( p_count => x_msg_count
544: , p_data => x_msg_data);
545: x_return_status := fnd_api.g_ret_sts_error;

Line 542: fnd_msg_pub.count_and_get

538: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
540: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
541: fnd_msg_pub.add;
542: fnd_msg_pub.count_and_get
543: ( p_count => x_msg_count
544: , p_data => x_msg_data);
545: x_return_status := fnd_api.g_ret_sts_error;
546: END Confirm_Ship;

Line 619: FND_MSG_PUB.initialize;

615:
616: SAVEPOINT Update_Packlist_Sts_Qty_PUB;
617: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
618: -- initialize message list
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Standard call to check for call compatibility.
623: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 635: FND_MSG_PUB.ADD;

631: -- validate p_organization_id
632: IF p_organization_id IS NULL THEN
633: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
634: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
635: FND_MSG_PUB.ADD;
636: RAISE EXCP_USER_DEFINED;
637: ELSE
638: IF p_validation_level = fnd_api.g_valid_level_full THEN
639: BEGIN

Line 646: FND_MSG_PUB.ADD;

642: where organization_id = p_organization_id;
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN
645: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
646: FND_MSG_PUB.ADD;
647: RAISE EXCP_USER_DEFINED;
648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 653: FND_MSG_PUB.ADD;

649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;
654: RAISE EXCP_USER_DEFINED;
655: END;
656: END IF;
657: NULL;

Line 664: FND_MSG_PUB.ADD;

660: -- validate the p_packlist_line_id
661: IF p_packlist_line_id IS NULL THEN
662: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
663: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);
664: FND_MSG_PUB.ADD;
665: RAISE EXCP_USER_DEFINED;
666: ELSE
667: IF p_validation_level = fnd_api.g_valid_level_full THEN
668: BEGIN

Line 676: FND_MSG_PUB.ADD;

672: and packlist_line_id = p_packlist_line_id;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
675: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');
676: FND_MSG_PUB.ADD;
677: RAISE EXCP_USER_DEFINED;
678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);

Line 683: fnd_msg_pub.add;

679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;
684: RAISE EXCP_USER_DEFINED;
685:
686: END;
687: END IF;

Line 698: FND_MSG_PUB.ADD;

694: FETCH C_Get_packlist_lines INTO l_packlist_line_rec;
695: IF C_Get_packlist_lines%NOTFOUND THEN
696: CLOSE C_Get_packlist_lines;
697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');
698: FND_MSG_PUB.ADD;
699: RAISE EXCP_USER_DEFINED;
700: ELSE
701:
702: IF p_line_status IS NOT NULL THEN

Line 737: fnd_msg_pub.count_and_get

733: EXCEPTION
734: WHEN EXCP_USER_DEFINED THEN
735: Rollback to Update_Packlist_Sts_Qty_PUB;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: fnd_msg_pub.count_and_get
738: ( p_count => x_msg_count
739: , p_data => x_msg_data);
740: WHEN FND_API.G_EXC_ERROR THEN
741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

740: WHEN FND_API.G_EXC_ERROR THEN
741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
742: P_API_NAME => L_API_NAME
743: ,P_PKG_NAME => G_PKG_NAME
744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
746: ,X_MSG_COUNT => X_MSG_COUNT
747: ,X_MSG_DATA => X_MSG_DATA
748: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 753: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
751: P_API_NAME => L_API_NAME
752: ,P_PKG_NAME => G_PKG_NAME
753: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
754: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
755: ,X_MSG_COUNT => X_MSG_COUNT
756: ,X_MSG_DATA => X_MSG_DATA
757: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 763: fnd_msg_pub.add;

759: Rollback to Update_Packlist_Sts_Qty_PUB;
760: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
762: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
763: fnd_msg_pub.add;
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count
766: , p_data => x_msg_data);
767: x_return_status := fnd_api.g_ret_sts_error;

Line 764: fnd_msg_pub.count_and_get

760: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
762: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
763: fnd_msg_pub.add;
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count
766: , p_data => x_msg_data);
767: x_return_status := fnd_api.g_ret_sts_error;
768:

Line 917: FND_MSG_PUB.initialize;

913: SAVEPOINT Update_Packlist_Sts_Qty_PUB;
914:
915: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
916: -- initialize message list
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 934: FND_MSG_PUB.ADD;

930: -- validate the p_organization_id
931: IF p_organization_id IS NULL THEN
932: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
933: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
934: FND_MSG_PUB.ADD;
935: RAISE EXCP_USER_DEFINED;
936: ELSE
937: IF p_validation_level = fnd_api.g_valid_level_full THEN
938: BEGIN

Line 945: FND_MSG_PUB.ADD;

941: where organization_id = p_organization_id;
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN
944: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
945: FND_MSG_PUB.ADD;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 952: FND_MSG_PUB.ADD;

948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;
956: NULL;

Line 962: FND_MSG_PUB.ADD;

958:
959: IF p_packlist_header_id IS NULL THEN
960: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
961: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
962: FND_MSG_PUB.ADD;
963: RAISE EXCP_USER_DEFINED;
964: ELSE
965: -- IF p_validation_level = fnd_api.g_valid_level_full THEN
966: BEGIN

Line 975: fnd_msg_pub.add;

971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
974: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
975: fnd_msg_pub.add;
976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);

Line 982: FND_MSG_PUB.ADD;

978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;
983: RAISE EXCP_USER_DEFINED;
984: END;
985: --END IF;
986: END IF;

Line 996: fnd_msg_pub.add;

992: IF C_Get_Packlist_Headers%NOTFOUND THEN
993: CLOSE C_Get_Packlist_Headers;
994: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
995: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
996: fnd_msg_pub.add;
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: CLOSE C_Get_Packlist_Headers;
1000:

Line 1036: fnd_msg_pub.count_and_get

1032: EXCEPTION
1033: WHEN EXCP_USER_DEFINED THEN
1034: Rollback to Update_Packlist_Sts_Qty_PUB;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: fnd_msg_pub.count_and_get
1037: ( p_count => x_msg_count
1038: , p_data => x_msg_data);
1039:
1040: --for debugging purpose

Line 1047: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1043: WHEN FND_API.G_EXC_ERROR THEN
1044: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1045: P_API_NAME => L_API_NAME
1046: ,P_PKG_NAME => G_PKG_NAME
1047: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1048: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1049: ,X_MSG_COUNT => X_MSG_COUNT
1050: ,X_MSG_DATA => X_MSG_DATA
1051: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1057: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1055: P_API_NAME => L_API_NAME
1056: ,P_PKG_NAME => G_PKG_NAME
1057: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1058: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1059: ,X_MSG_COUNT => X_MSG_COUNT
1060: ,X_MSG_DATA => X_MSG_DATA
1061: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1068: fnd_msg_pub.add;

1064: Rollback to Update_Packlist_Sts_Qty_PUB;
1065: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1067: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1068: fnd_msg_pub.add;
1069: fnd_msg_pub.count_and_get
1070: ( p_count => x_msg_count
1071: , p_data => x_msg_data);
1072: x_return_status := fnd_api.g_ret_sts_error;

Line 1069: fnd_msg_pub.count_and_get

1065: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1067: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1068: fnd_msg_pub.add;
1069: fnd_msg_pub.count_and_get
1070: ( p_count => x_msg_count
1071: , p_data => x_msg_data);
1072: x_return_status := fnd_api.g_ret_sts_error;
1073: