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 176: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173:
174: -- Standard call to check for call compatibility
175: l_progress := '010';
176: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: SAVEPOINT PO_OM_GRP_UPDATE_REQ_PO_SP;
181:

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

434: x_return_status => x_return_status );
435: END IF; -- Bug 3639067
436: -- Bug 3248723 END
437:
438: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
439: RAISE FND_API.g_exc_error;
440: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;

Line 439: RAISE FND_API.g_exc_error;

435: END IF; -- Bug 3639067
436: -- Bug 3248723 END
437:
438: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
439: RAISE FND_API.g_exc_error;
440: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:

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

436: -- Bug 3248723 END
437:
438: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
439: RAISE FND_API.g_exc_error;
440: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: END LOOP;

Line 441: RAISE FND_API.g_exc_unexpected_error;

437:
438: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
439: RAISE FND_API.g_exc_error;
440: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: END LOOP;
445:

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

687: x_return_status => x_return_status,
688: x_msg_count => x_msg_count,
689: x_msg_data => x_msg_data );
690:
691: IF (x_return_status = FND_API.g_ret_sts_error) THEN
692: RAISE FND_API.g_exc_error;
693: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;

Line 692: RAISE FND_API.g_exc_error;

688: x_msg_count => x_msg_count,
689: x_msg_data => x_msg_data );
690:
691: IF (x_return_status = FND_API.g_ret_sts_error) THEN
692: RAISE FND_API.g_exc_error;
693: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;
696:

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

689: x_msg_data => x_msg_data );
690:
691: IF (x_return_status = FND_API.g_ret_sts_error) THEN
692: RAISE FND_API.g_exc_error;
693: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;
696:
697: END IF; -- l_req_changes... - Bug 3639067

Line 694: RAISE FND_API.g_exc_unexpected_error;

690:
691: IF (x_return_status = FND_API.g_ret_sts_error) THEN
692: RAISE FND_API.g_exc_error;
693: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;
696:
697: END IF; -- l_req_changes... - Bug 3639067
698:

Line 706: x_return_status := FND_API.G_RET_STS_SUCCESS;

702: l_progress := '900';
703: -- Set the org context back to the original operating unit.
704: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
705:
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: EXCEPTION
709: WHEN FND_API.G_EXC_ERROR THEN
710: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 709: WHEN FND_API.G_EXC_ERROR THEN

705:
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: EXCEPTION
709: WHEN FND_API.G_EXC_ERROR THEN
710: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: -- Set the org context back to the original operating unit.

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: EXCEPTION
709: WHEN FND_API.G_EXC_ERROR THEN
710: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: -- Set the org context back to the original operating unit.
714: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: -- Set the org context back to the original operating unit.
714: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: -- Set the org context back to the original operating unit.

Line 718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: -- Set the org context back to the original operating unit.
720: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
721: WHEN OTHERS THEN
722: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

723: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
724: p_proc_name => l_api_name,
725: p_progress => l_progress );
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: -- Set the org context back to the original operating unit.
729: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
730:
731: END update_req_po;

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

830: END IF;
831:
832: -- Standard call to check for call compatibility
833: l_progress := '010';
834: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: -- Cancel PO/Release Shipments

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831:
832: -- Standard call to check for call compatibility
833: l_progress := '010';
834: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: -- Cancel PO/Release Shipments
839: l_progress := '020';

Line 902: p_init_msg_list => FND_API.G_FALSE,

898: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
899:
900: PO_Document_Control_GRP.control_document
901: (p_api_version => 1.0,
902: p_init_msg_list => FND_API.G_FALSE,
903: p_commit => FND_API.G_FALSE,
904: x_return_status => x_return_status,
905: p_doc_type => l_doc_type,
906: p_doc_subtype => l_doc_subtype,

Line 903: p_commit => FND_API.G_FALSE,

899:
900: PO_Document_Control_GRP.control_document
901: (p_api_version => 1.0,
902: p_init_msg_list => FND_API.G_FALSE,
903: p_commit => FND_API.G_FALSE,
904: x_return_status => x_return_status,
905: p_doc_type => l_doc_type,
906: p_doc_subtype => l_doc_subtype,
907: p_doc_id => p_po_header_id(i),

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

920: p_print_flag => 'N',
921: p_note_to_vendor => null);
922: END IF; -- l_approved_date
923:
924: IF (x_return_status = FND_API.g_ret_sts_error) THEN
925: RAISE FND_API.g_exc_error;
926: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: END IF;

Line 925: RAISE FND_API.g_exc_error;

921: p_note_to_vendor => null);
922: END IF; -- l_approved_date
923:
924: IF (x_return_status = FND_API.g_ret_sts_error) THEN
925: RAISE FND_API.g_exc_error;
926: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: END IF;
929:

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

922: END IF; -- l_approved_date
923:
924: IF (x_return_status = FND_API.g_ret_sts_error) THEN
925: RAISE FND_API.g_exc_error;
926: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: END IF;
929:
930: -- Bug 3639067 START

Line 927: RAISE FND_API.g_exc_unexpected_error;

923:
924: IF (x_return_status = FND_API.g_ret_sts_error) THEN
925: RAISE FND_API.g_exc_error;
926: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: END IF;
929:
930: -- Bug 3639067 START
931: ELSE -- l_drop_ship_flag is not Y

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

1018: x_return_status => x_return_status,
1019: x_msg_count => x_msg_count,
1020: x_msg_data => x_msg_data);
1021:
1022: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1023: RAISE FND_API.g_exc_error;
1024: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;

Line 1023: RAISE FND_API.g_exc_error;

1019: x_msg_count => x_msg_count,
1020: x_msg_data => x_msg_data);
1021:
1022: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1023: RAISE FND_API.g_exc_error;
1024: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;
1027:

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

1020: x_msg_data => x_msg_data);
1021:
1022: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1023: RAISE FND_API.g_exc_error;
1024: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;
1027:
1028: END IF; -- l_req_header_id - Bug 3639067

Line 1025: RAISE FND_API.g_exc_unexpected_error;

1021:
1022: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1023: RAISE FND_API.g_exc_error;
1024: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;
1027:
1028: END IF; -- l_req_header_id - Bug 3639067
1029:

Line 1032: x_return_status := FND_API.G_RET_STS_SUCCESS;

1028: END IF; -- l_req_header_id - Bug 3639067
1029:
1030: l_progress := '050';
1031:
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;
1033:
1034: -- Set the org context back to the original operating unit.
1035: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1036:

Line 1038: WHEN FND_API.G_EXC_ERROR THEN

1034: -- Set the org context back to the original operating unit.
1035: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_ERROR THEN
1039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: -- Set the org context back to the original operating unit.
1042: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

Line 1040: x_return_status := FND_API.G_RET_STS_ERROR;

1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_ERROR THEN
1039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: -- Set the org context back to the original operating unit.
1042: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: -- Set the org context back to the original operating unit.
1042: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Set the org context back to the original operating unit.
1047: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041: -- Set the org context back to the original operating unit.
1042: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Set the org context back to the original operating unit.
1047: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1048: WHEN OTHERS THEN
1049: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

Line 1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1049: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1050: p_proc_name => l_api_name,
1051: p_progress => l_progress );
1052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: -- Set the org context back to the original operating unit.
1055: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1056:
1057: END cancel_req_po;

Line 1116: l_run_submission_checks := FND_API.G_TRUE;

1112: -- If the PO was in Approved status before the change, then perform
1113: -- submission checks and launch the PO Approval workflow to re-approve
1114: -- the PO after making the changes.
1115: IF l_authorization_status = 'APPROVED' THEN
1116: l_run_submission_checks := FND_API.G_TRUE;
1117: l_launch_approvals_flag := FND_API.G_TRUE;
1118: ELSE
1119: l_run_submission_checks := FND_API.G_FALSE;
1120: l_launch_approvals_flag := FND_API.G_FALSE;

Line 1117: l_launch_approvals_flag := FND_API.G_TRUE;

1113: -- submission checks and launch the PO Approval workflow to re-approve
1114: -- the PO after making the changes.
1115: IF l_authorization_status = 'APPROVED' THEN
1116: l_run_submission_checks := FND_API.G_TRUE;
1117: l_launch_approvals_flag := FND_API.G_TRUE;
1118: ELSE
1119: l_run_submission_checks := FND_API.G_FALSE;
1120: l_launch_approvals_flag := FND_API.G_FALSE;
1121: END IF;

Line 1119: l_run_submission_checks := FND_API.G_FALSE;

1115: IF l_authorization_status = 'APPROVED' THEN
1116: l_run_submission_checks := FND_API.G_TRUE;
1117: l_launch_approvals_flag := FND_API.G_TRUE;
1118: ELSE
1119: l_run_submission_checks := FND_API.G_FALSE;
1120: l_launch_approvals_flag := FND_API.G_FALSE;
1121: END IF;
1122:
1123: l_progress := '020';

Line 1120: l_launch_approvals_flag := FND_API.G_FALSE;

1116: l_run_submission_checks := FND_API.G_TRUE;
1117: l_launch_approvals_flag := FND_API.G_TRUE;
1118: ELSE
1119: l_run_submission_checks := FND_API.G_FALSE;
1120: l_launch_approvals_flag := FND_API.G_FALSE;
1121: END IF;
1122:
1123: l_progress := '020';
1124: PO_DOCUMENT_UPDATE_GRP.update_document (

Line 1126: p_init_msg_list => FND_API.G_FALSE,

1122:
1123: l_progress := '020';
1124: PO_DOCUMENT_UPDATE_GRP.update_document (
1125: p_api_version => 1.0,
1126: p_init_msg_list => FND_API.G_FALSE,
1127: x_return_status => x_return_status,
1128: p_changes => p_chg,
1129: p_run_submission_checks => l_run_submission_checks,
1130: p_launch_approvals_flag => l_launch_approvals_flag,

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

1135: p_approval_background_flag => PO_DOCUMENT_UPDATE_GRP.G_PARAMETER_NO
1136: );
1137:
1138: l_progress := '030';
1139: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1140: -- If non success status, transfer l_errors to FND Message Stack
1141: FOR j IN 1..l_errors.message_text.count LOOP
1142: FND_MESSAGE.set_name('PO', 'PO_WRAPPER_MESSAGE');
1143: FND_MESSAGE.set_token('MESSAGE', l_errors.message_text(j));

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1149: WHEN OTHERS THEN
1150: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1151: p_proc_name => l_proc_name,
1152: p_progress => l_progress );
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: END call_po_change_api;
1155: -- Bug 3248723 END
1156:
1157: --

Line 1218: x_return_status := FND_API.G_RET_STS_SUCCESS;

1214: BEGIN
1215:
1216: l_progress := '000';
1217:
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219:
1220: IF (g_fnd_debug = 'Y') THEN
1221: PO_DEBUG.debug_begin
1222: ( p_log_head => l_log_head

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

1222: ( p_log_head => l_log_head
1223: );
1224: END IF;
1225:
1226: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1227: FND_MSG_PUB.initialize;
1228: END IF;
1229:
1230: IF (NOT FND_API.Compatible_API_Call

Line 1230: IF (NOT FND_API.Compatible_API_Call

1226: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1227: FND_MSG_PUB.initialize;
1228: END IF;
1229:
1230: IF (NOT FND_API.Compatible_API_Call
1231: ( p_current_version_number => l_api_version,
1232: p_caller_version_number => p_api_version,
1233: p_api_name => l_api_name,
1234: p_pkg_name => g_pkg_name

Line 1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1235: )
1236: ) THEN
1237:
1238: l_progress := '010';
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1240: END IF;
1241:
1242: IF (p_entity_id_tbl IS NULL) THEN
1243: l_progress := '020';

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299: p_procedure_name => l_api_name || '.' || l_progress,
1300: p_error_text => 'Unknown entity: ' || p_entity
1301: );
1302:
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304:
1305: END IF;
1306:
1307: l_progress := '060';

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

1305: END IF;
1306:
1307: l_progress := '060';
1308:
1309: IF (FND_API.to_boolean(p_commit)) THEN
1310:
1311: l_progress := '070';
1312: COMMIT;
1313:

Line 1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1320: END IF;
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1326: p_proc_name => l_api_name,
1327: p_progress => l_progress );
1328: FND_MSG_PUB.count_and_get

Line 1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

1401: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1402: BEGIN
1403: l_progress := '000';
1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407: IF (g_fnd_debug = 'Y') THEN
1408: PO_DEBUG.debug_begin
1409: ( p_log_head => l_log_head

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

1409: ( p_log_head => l_log_head
1410: );
1411: END IF;
1412:
1413: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: IF (NOT FND_API.Compatible_API_Call

Line 1417: IF (NOT FND_API.Compatible_API_Call

1413: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: IF (NOT FND_API.Compatible_API_Call
1418: ( p_current_version_number => l_api_version,
1419: p_caller_version_number => p_api_version,
1420: p_api_name => l_api_name,
1421: p_pkg_name => g_pkg_name

Line 1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1422: )
1423: ) THEN
1424:
1425: l_progress := '010';
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: END IF;
1428:
1429: IF (p_entity_id_tbl IS NULL) THEN
1430: l_progress := '020';

Line 1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1533: p_procedure_name => l_api_name || '.' || l_progress,
1534: p_error_text => 'Unknown entity: ' || p_entity
1535: );
1536:
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538:
1539: END IF;
1540:
1541: l_progress := '070';

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

1540:
1541: l_progress := '070';
1542: DELETE FROM po_session_gt WHERE key = l_seq_id;
1543:
1544: IF (FND_API.to_boolean(p_commit)) THEN
1545:
1546: l_progress := '080';
1547: COMMIT;
1548:

Line 1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1556:
1557:
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1562: p_proc_name => l_api_name,
1563: p_progress => l_progress );
1564: FND_MSG_PUB.count_and_get

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

1595: -- Message returned by the API
1596: --x_msg_count
1597: -- Number of error messages
1598: --x_ret_status
1599: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1600: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1602: --Testing:
1603: -- None.

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

1596: --x_msg_count
1597: -- Number of error messages
1598: --x_ret_status
1599: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1600: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1602: --Testing:
1603: -- None.
1604: --End of Comments

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

1597: -- Number of error messages
1598: --x_ret_status
1599: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
1600: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
1601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
1602: --Testing:
1603: -- None.
1604: --End of Comments
1605: -------------------------------------------------------------------------------

Line 1632: x_return_status := FND_API.G_RET_STS_SUCCESS;

1628: l_order_line_info_rec OE_DROP_SHIP_GRP.Order_Line_Info_Rec_Type;
1629:
1630: BEGIN
1631: -- Initialise the return status
1632: x_return_status := FND_API.G_RET_STS_SUCCESS;
1633:
1634: -- check for API version
1635: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1636: THEN

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

1631: -- Initialise the return status
1632: x_return_status := FND_API.G_RET_STS_SUCCESS;
1633:
1634: -- check for API version
1635: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1636: THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: return;
1639: END IF;

Line 1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1633:
1634: -- check for API version
1635: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
1636: THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: return;
1639: END IF;
1640:
1641: -- Call the OM API to get the drop ship info

Line 1654: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

1650: X_MSG_DATA => x_msg_data,
1651: X_MSG_COUNT => x_msg_count,
1652: X_RETURN_STATUS => x_return_status );
1653:
1654: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
1655: x_customer_name := l_order_line_info_rec.SHIP_TO_CUSTOMER_NAME;
1656: x_customer_contact := l_order_line_info_rec.SHIP_TO_CONTACT_NAME;
1657: x_shipping_method := l_order_line_info_rec.SHIPPING_METHOD;
1658: x_shipping_instructions := l_order_line_info_rec.SHIPPING_INSTRUCTIONS;

Line 1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1669: END IF;
1670:
1671: EXCEPTION
1672: When Others then
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: END;
1675:
1676: END PO_OM_INTEGRATION_GRP;