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.PO_OM_INTEGRATION_GRP dependencies on FND_API

Line 171: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

167: END IF;
168:
169: -- Standard call to check for call compatibility
170: l_progress := '010';
171: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: SAVEPOINT PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168:
169: -- Standard call to check for call compatibility
170: l_progress := '010';
171: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: SAVEPOINT PO_OM_GRP_UPDATE_REQ_PO_SP;
176:

Line 433: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

429: x_return_status => x_return_status );
430: END IF; -- Bug 3639067
431: -- Bug 3248723 END
432:
433: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
434: RAISE FND_API.g_exc_error;
435: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.g_exc_unexpected_error;
437: END IF;

Line 434: RAISE FND_API.g_exc_error;

430: END IF; -- Bug 3639067
431: -- Bug 3248723 END
432:
433: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
434: RAISE FND_API.g_exc_error;
435: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.g_exc_unexpected_error;
437: END IF;
438:

Line 435: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

431: -- Bug 3248723 END
432:
433: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
434: RAISE FND_API.g_exc_error;
435: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.g_exc_unexpected_error;
437: END IF;
438:
439: END LOOP;

Line 436: RAISE FND_API.g_exc_unexpected_error;

432:
433: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
434: RAISE FND_API.g_exc_error;
435: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.g_exc_unexpected_error;
437: END IF;
438:
439: END LOOP;
440:

Line 565: IF (x_return_status = FND_API.g_ret_sts_error) THEN

561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data );
564:
565: IF (x_return_status = FND_API.g_ret_sts_error) THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;

Line 566: RAISE FND_API.g_exc_error;

562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data );
564:
565: IF (x_return_status = FND_API.g_ret_sts_error) THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:

Line 567: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

563: x_msg_data => x_msg_data );
564:
565: IF (x_return_status = FND_API.g_ret_sts_error) THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:
571: END IF; -- l_req_changes... - Bug 3639067

Line 568: RAISE FND_API.g_exc_unexpected_error;

564:
565: IF (x_return_status = FND_API.g_ret_sts_error) THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:
571: END IF; -- l_req_changes... - Bug 3639067
572:

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: l_progress := '900';
577: -- Set the org context back to the original operating unit.
578: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
579:
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579:
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: -- Set the org context back to the original operating unit.

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: -- Set the org context back to the original operating unit.
588: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: -- Set the org context back to the original operating unit.
588: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: -- Set the org context back to the original operating unit.

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: -- Set the org context back to the original operating unit.
594: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
595: WHEN OTHERS THEN
596: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
598: p_proc_name => l_api_name,
599: p_progress => l_progress );
600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: -- Set the org context back to the original operating unit.
603: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
604:
605: END update_req_po;

Line 708: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

704: END IF;
705:
706: -- Standard call to check for call compatibility
707: l_progress := '010';
708: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Cancel PO/Release Shipments

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

705:
706: -- Standard call to check for call compatibility
707: l_progress := '010';
708: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Cancel PO/Release Shipments
713: l_progress := '020';

Line 776: p_init_msg_list => FND_API.G_FALSE,

772: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
773:
774: PO_Document_Control_GRP.control_document
775: (p_api_version => 1.0,
776: p_init_msg_list => FND_API.G_FALSE,
777: p_commit => FND_API.G_FALSE,
778: x_return_status => x_return_status,
779: p_doc_type => l_doc_type,
780: p_doc_subtype => l_doc_subtype,

Line 777: p_commit => FND_API.G_FALSE,

773:
774: PO_Document_Control_GRP.control_document
775: (p_api_version => 1.0,
776: p_init_msg_list => FND_API.G_FALSE,
777: p_commit => FND_API.G_FALSE,
778: x_return_status => x_return_status,
779: p_doc_type => l_doc_type,
780: p_doc_subtype => l_doc_subtype,
781: p_doc_id => p_po_header_id(i),

Line 798: IF (x_return_status = FND_API.g_ret_sts_error) THEN

794: p_print_flag => 'N',
795: p_note_to_vendor => null);
796: END IF; -- l_approved_date
797:
798: IF (x_return_status = FND_API.g_ret_sts_error) THEN
799: RAISE FND_API.g_exc_error;
800: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
801: RAISE FND_API.g_exc_unexpected_error;
802: END IF;

Line 799: RAISE FND_API.g_exc_error;

795: p_note_to_vendor => null);
796: END IF; -- l_approved_date
797:
798: IF (x_return_status = FND_API.g_ret_sts_error) THEN
799: RAISE FND_API.g_exc_error;
800: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
801: RAISE FND_API.g_exc_unexpected_error;
802: END IF;
803:

Line 800: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

796: END IF; -- l_approved_date
797:
798: IF (x_return_status = FND_API.g_ret_sts_error) THEN
799: RAISE FND_API.g_exc_error;
800: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
801: RAISE FND_API.g_exc_unexpected_error;
802: END IF;
803:
804: -- Bug 3639067 START

Line 801: RAISE FND_API.g_exc_unexpected_error;

797:
798: IF (x_return_status = FND_API.g_ret_sts_error) THEN
799: RAISE FND_API.g_exc_error;
800: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
801: RAISE FND_API.g_exc_unexpected_error;
802: END IF;
803:
804: -- Bug 3639067 START
805: ELSE -- l_drop_ship_flag is not Y

Line 896: IF (x_return_status = FND_API.g_ret_sts_error) THEN

892: x_return_status => x_return_status,
893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data);
895:
896: IF (x_return_status = FND_API.g_ret_sts_error) THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;

Line 897: RAISE FND_API.g_exc_error;

893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data);
895:
896: IF (x_return_status = FND_API.g_ret_sts_error) THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901:

Line 898: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

894: x_msg_data => x_msg_data);
895:
896: IF (x_return_status = FND_API.g_ret_sts_error) THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901:
902: END IF; -- l_req_header_id - Bug 3639067

Line 899: RAISE FND_API.g_exc_unexpected_error;

895:
896: IF (x_return_status = FND_API.g_ret_sts_error) THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901:
902: END IF; -- l_req_header_id - Bug 3639067
903:

Line 906: x_return_status := FND_API.G_RET_STS_SUCCESS;

902: END IF; -- l_req_header_id - Bug 3639067
903:
904: l_progress := '050';
905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: -- Set the org context back to the original operating unit.
909: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
910:

Line 912: WHEN FND_API.G_EXC_ERROR THEN

908: -- Set the org context back to the original operating unit.
909: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
910:
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: -- Set the org context back to the original operating unit.
916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910:
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: -- Set the org context back to the original operating unit.
916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: -- Set the org context back to the original operating unit.
916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: -- Set the org context back to the original operating unit.
921: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915: -- Set the org context back to the original operating unit.
916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: -- Set the org context back to the original operating unit.
921: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
922: WHEN OTHERS THEN
923: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

Line 927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

923: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
924: p_proc_name => l_api_name,
925: p_progress => l_progress );
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: -- Set the org context back to the original operating unit.
929: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
930:
931: END cancel_req_po;

Line 990: l_run_submission_checks := FND_API.G_TRUE;

986: -- If the PO was in Approved status before the change, then perform
987: -- submission checks and launch the PO Approval workflow to re-approve
988: -- the PO after making the changes.
989: IF l_authorization_status = 'APPROVED' THEN
990: l_run_submission_checks := FND_API.G_TRUE;
991: l_launch_approvals_flag := FND_API.G_TRUE;
992: ELSE
993: l_run_submission_checks := FND_API.G_FALSE;
994: l_launch_approvals_flag := FND_API.G_FALSE;

Line 991: l_launch_approvals_flag := FND_API.G_TRUE;

987: -- submission checks and launch the PO Approval workflow to re-approve
988: -- the PO after making the changes.
989: IF l_authorization_status = 'APPROVED' THEN
990: l_run_submission_checks := FND_API.G_TRUE;
991: l_launch_approvals_flag := FND_API.G_TRUE;
992: ELSE
993: l_run_submission_checks := FND_API.G_FALSE;
994: l_launch_approvals_flag := FND_API.G_FALSE;
995: END IF;

Line 993: l_run_submission_checks := FND_API.G_FALSE;

989: IF l_authorization_status = 'APPROVED' THEN
990: l_run_submission_checks := FND_API.G_TRUE;
991: l_launch_approvals_flag := FND_API.G_TRUE;
992: ELSE
993: l_run_submission_checks := FND_API.G_FALSE;
994: l_launch_approvals_flag := FND_API.G_FALSE;
995: END IF;
996:
997: l_progress := '020';

Line 994: l_launch_approvals_flag := FND_API.G_FALSE;

990: l_run_submission_checks := FND_API.G_TRUE;
991: l_launch_approvals_flag := FND_API.G_TRUE;
992: ELSE
993: l_run_submission_checks := FND_API.G_FALSE;
994: l_launch_approvals_flag := FND_API.G_FALSE;
995: END IF;
996:
997: l_progress := '020';
998: PO_DOCUMENT_UPDATE_GRP.update_document (

Line 1000: p_init_msg_list => FND_API.G_FALSE,

996:
997: l_progress := '020';
998: PO_DOCUMENT_UPDATE_GRP.update_document (
999: p_api_version => 1.0,
1000: p_init_msg_list => FND_API.G_FALSE,
1001: x_return_status => x_return_status,
1002: p_changes => p_chg,
1003: p_run_submission_checks => l_run_submission_checks,
1004: p_launch_approvals_flag => l_launch_approvals_flag,

Line 1013: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1009: p_approval_background_flag => PO_DOCUMENT_UPDATE_GRP.G_PARAMETER_NO
1010: );
1011:
1012: l_progress := '030';
1013: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1014: -- If non success status, transfer l_errors to FND Message Stack
1015: FOR j IN 1..l_errors.message_text.count LOOP
1016: FND_MESSAGE.set_name('PO', 'PO_WRAPPER_MESSAGE');
1017: FND_MESSAGE.set_token('MESSAGE', l_errors.message_text(j));

Line 1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1023: WHEN OTHERS THEN
1024: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1025: p_proc_name => l_proc_name,
1026: p_progress => l_progress );
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: END call_po_change_api;
1029: -- Bug 3248723 END
1030:
1031: --

Line 1092: x_return_status := FND_API.G_RET_STS_SUCCESS;

1088: BEGIN
1089:
1090: l_progress := '000';
1091:
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: IF (g_fnd_debug = 'Y') THEN
1095: PO_DEBUG.debug_begin
1096: ( p_log_head => l_log_head

Line 1100: IF (FND_API.to_boolean(p_init_msg_list)) THEN

1096: ( p_log_head => l_log_head
1097: );
1098: END IF;
1099:
1100: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103:
1104: IF (NOT FND_API.Compatible_API_Call

Line 1104: IF (NOT FND_API.Compatible_API_Call

1100: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103:
1104: IF (NOT FND_API.Compatible_API_Call
1105: ( p_current_version_number => l_api_version,
1106: p_caller_version_number => p_api_version,
1107: p_api_name => l_api_name,
1108: p_pkg_name => g_pkg_name

Line 1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1109: )
1110: ) THEN
1111:
1112: l_progress := '010';
1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: END IF;
1115:
1116: IF (p_entity_id_tbl IS NULL) THEN
1117: l_progress := '020';

Line 1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1173: p_procedure_name => l_api_name || '.' || l_progress,
1174: p_error_text => 'Unknown entity: ' || p_entity
1175: );
1176:
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178:
1179: END IF;
1180:
1181: l_progress := '060';

Line 1183: IF (FND_API.to_boolean(p_commit)) THEN

1179: END IF;
1180:
1181: l_progress := '060';
1182:
1183: IF (FND_API.to_boolean(p_commit)) THEN
1184:
1185: l_progress := '070';
1186: COMMIT;
1187:

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1194: END IF;
1195:
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1200: p_proc_name => l_api_name,
1201: p_progress => l_progress );
1202: FND_MSG_PUB.count_and_get

Line 1279: x_return_status := FND_API.G_RET_STS_SUCCESS;

1275: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1276: BEGIN
1277: l_progress := '000';
1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281: IF (g_fnd_debug = 'Y') THEN
1282: PO_DEBUG.debug_begin
1283: ( p_log_head => l_log_head

Line 1287: IF (FND_API.to_boolean(p_init_msg_list)) THEN

1283: ( p_log_head => l_log_head
1284: );
1285: END IF;
1286:
1287: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1288: FND_MSG_PUB.initialize;
1289: END IF;
1290:
1291: IF (NOT FND_API.Compatible_API_Call

Line 1291: IF (NOT FND_API.Compatible_API_Call

1287: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1288: FND_MSG_PUB.initialize;
1289: END IF;
1290:
1291: IF (NOT FND_API.Compatible_API_Call
1292: ( p_current_version_number => l_api_version,
1293: p_caller_version_number => p_api_version,
1294: p_api_name => l_api_name,
1295: p_pkg_name => g_pkg_name

Line 1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1296: )
1297: ) THEN
1298:
1299: l_progress := '010';
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;
1302:
1303: IF (p_entity_id_tbl IS NULL) THEN
1304: l_progress := '020';

Line 1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1407: p_procedure_name => l_api_name || '.' || l_progress,
1408: p_error_text => 'Unknown entity: ' || p_entity
1409: );
1410:
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412:
1413: END IF;
1414:
1415: l_progress := '070';

Line 1418: IF (FND_API.to_boolean(p_commit)) THEN

1414:
1415: l_progress := '070';
1416: DELETE FROM po_session_gt WHERE key = l_seq_id;
1417:
1418: IF (FND_API.to_boolean(p_commit)) THEN
1419:
1420: l_progress := '080';
1421: COMMIT;
1422:

Line 1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1430:
1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1436: p_proc_name => l_api_name,
1437: p_progress => l_progress );
1438: FND_MSG_PUB.count_and_get

Line 1473: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful

1469: -- Message returned by the API
1470: --x_msg_count
1471: -- Number of error messages
1472: --x_ret_status
1473: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1474: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1475: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1476: --Testing:
1477: -- None.

Line 1474: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs

1470: --x_msg_count
1471: -- Number of error messages
1472: --x_ret_status
1473: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1474: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1475: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1476: --Testing:
1477: -- None.
1478: --End of Comments

Line 1475: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs

1471: -- Number of error messages
1472: --x_ret_status
1473: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1474: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1475: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1476: --Testing:
1477: -- None.
1478: --End of Comments
1479: -------------------------------------------------------------------------------

Line 1506: x_return_status := FND_API.G_RET_STS_SUCCESS;

1502: l_order_line_info_rec OE_DROP_SHIP_GRP.Order_Line_Info_Rec_Type;
1503:
1504: BEGIN
1505: -- Initialise the return status
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: -- check for API version
1509: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1510: THEN

Line 1509: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )

1505: -- Initialise the return status
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: -- check for API version
1509: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1510: THEN
1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512: return;
1513: END IF;

Line 1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1507:
1508: -- check for API version
1509: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1510: THEN
1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512: return;
1513: END IF;
1514:
1515: -- Call the OM API to get the drop ship info

Line 1528: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

1524: X_MSG_DATA => x_msg_data,
1525: X_MSG_COUNT => x_msg_count,
1526: X_RETURN_STATUS => x_return_status );
1527:
1528: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
1529: x_customer_name := l_order_line_info_rec.SHIP_TO_CUSTOMER_NAME;
1530: x_customer_contact := l_order_line_info_rec.SHIP_TO_CONTACT_NAME;
1531: x_shipping_method := l_order_line_info_rec.SHIPPING_METHOD;
1532: x_shipping_instructions := l_order_line_info_rec.SHIPPING_INSTRUCTIONS;

Line 1547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1543: END IF;
1544:
1545: EXCEPTION
1546: When Others then
1547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1548: END;
1549:
1550: END PO_OM_INTEGRATION_GRP;