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_DRAFT_MERGE_PKG dependencies on FND_API

Line 637: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL) THEN

633:
634: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous - Return Status: '|| l_return_status ;
635: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress );
636:
637: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL) THEN
638: -- copying message from po_online_report_text_gt
639: g_action:= 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : ';
640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id
641: and rownum =1;

Line 644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id
641: and rownum =1;
642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );
643: g_result := l_return_status;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645:
646: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
647: IF (l_Encumbrance_on) AND (l_po_return_code NOT IN ( po_document_funds_pvt.g_return_success, PO_DOCUMENT_FUNDS_PVT.g_return_WARNING))
648: THEN

Line 646: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );
643: g_result := l_return_status;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645:
646: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
647: IF (l_Encumbrance_on) AND (l_po_return_code NOT IN ( po_document_funds_pvt.g_return_success, PO_DOCUMENT_FUNDS_PVT.g_return_WARNING))
648: THEN
649: x_progress := 'MergeReserve_Autonomous - Po Return Code: '|| l_po_return_code;
650: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );

Line 795: p_init_msg_list => FND_API.G_TRUE,

791: If l_control_action = 'CANCEL' then
792: v_doc_line_id := null; --bug 13004199
793: PO_Document_Control_GRP.control_document(
794: p_api_version => 1.0,
795: p_init_msg_list => FND_API.G_TRUE,
796: p_commit => FND_API.G_FALSE,
797: x_return_status => x_return_status,
798: p_doc_type => v_document_type,
799: p_doc_subtype => v_document_subtype,

Line 796: p_commit => FND_API.G_FALSE,

792: v_doc_line_id := null; --bug 13004199
793: PO_Document_Control_GRP.control_document(
794: p_api_version => 1.0,
795: p_init_msg_list => FND_API.G_TRUE,
796: p_commit => FND_API.G_FALSE,
797: x_return_status => x_return_status,
798: p_doc_type => v_document_type,
799: p_doc_subtype => v_document_subtype,
800: p_doc_id => p_document_id,

Line 840: p_init_msg_list => FND_API.G_TRUE,

836:
837: If control_action_line_rec.control_action = 'CANCEL' then
838: PO_Document_Control_GRP.control_document(
839: p_api_version => 1.0,
840: p_init_msg_list => FND_API.G_TRUE,
841: p_commit => FND_API.G_FALSE,
842: x_return_status => x_return_status,
843: p_doc_type => v_document_type,
844: p_doc_subtype => v_document_subtype,

Line 841: p_commit => FND_API.G_FALSE,

837: If control_action_line_rec.control_action = 'CANCEL' then
838: PO_Document_Control_GRP.control_document(
839: p_api_version => 1.0,
840: p_init_msg_list => FND_API.G_TRUE,
841: p_commit => FND_API.G_FALSE,
842: x_return_status => x_return_status,
843: p_doc_type => v_document_type,
844: p_doc_subtype => v_document_subtype,
845: p_doc_id => p_document_id,

Line 887: p_init_msg_list => FND_API.G_TRUE,

883:
884: If control_action_line_loc_rec.control_action = 'CANCEL' then
885: PO_Document_Control_GRP.control_document(
886: p_api_version => 1.0,
887: p_init_msg_list => FND_API.G_TRUE,
888: p_commit => FND_API.G_FALSE,
889: x_return_status => x_return_status,
890: p_doc_type => v_document_type,
891: p_doc_subtype => v_document_subtype,

Line 888: p_commit => FND_API.G_FALSE,

884: If control_action_line_loc_rec.control_action = 'CANCEL' then
885: PO_Document_Control_GRP.control_document(
886: p_api_version => 1.0,
887: p_init_msg_list => FND_API.G_TRUE,
888: p_commit => FND_API.G_FALSE,
889: x_return_status => x_return_status,
890: p_doc_type => v_document_type,
891: p_doc_subtype => v_document_subtype,
892: p_doc_id => p_document_id,

Line 1046: p_init_msg_list => FND_API.G_TRUE ,

1042: -- Bug 14277142 : Adding parameter p_caller => 'MERGE' so that ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index
1043: -- done as a part of bug fix is not called.
1044: PO_DRAFTS_PVT.TRANSFER_DRAFT_TO_TXN(
1045: p_api_version => 1.0,
1046: p_init_msg_list => FND_API.G_TRUE ,
1047: p_draft_id => p_draft_id,
1048: p_po_header_id => P_Document_Id,
1049: p_delete_processed_draft => FND_API.G_FALSE ,
1050: p_acceptance_action => NULL,

Line 1049: p_delete_processed_draft => FND_API.G_FALSE ,

1045: p_api_version => 1.0,
1046: p_init_msg_list => FND_API.G_TRUE ,
1047: p_draft_id => p_draft_id,
1048: p_po_header_id => P_Document_Id,
1049: p_delete_processed_draft => FND_API.G_FALSE ,
1050: p_acceptance_action => NULL,
1051: x_return_status => l_return_status,
1052: p_caller => 'MERGE');
1053:

Line 1057: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1053:
1054: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Return Status: '||l_return_status;
1055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1056:
1057: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1058: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1059: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1060: ELSE
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1058: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1059: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1060: ELSE
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063:
1064: -- Update the approved_date of the header draft
1065: -- which is used as the signed date of the modification

Line 1098: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1094:
1095: x_progress := 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag;
1096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1097:
1098: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1099: THEN
1100: g_result := l_return_status;
1101: g_error_message := l_msg_data ;
1102: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: THEN
1100: g_result := l_return_status;
1101: g_error_message := l_msg_data ;
1102: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END IF;
1105:
1106: IF l_enabled_flag = 'Y' THEN
1107:

Line 1118: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1114:
1115: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Uda Merge Return Status: '||l_return_status;
1116: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1117:
1118: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- TODO : THIS CHECK IS IRRELAVENT AS TRANSFER TO DRAFT DOESN'T RETURN TRUE/FALSE

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Uda Merge Return Status: '||l_return_status;
1116: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1117:
1118: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- TODO : THIS CHECK IS IRRELAVENT AS TRANSFER TO DRAFT DOESN'T RETURN TRUE/FALSE
1123: If l_return_status <> FND_API.G_FALSE THEN

Line 1123: If l_return_status <> FND_API.G_FALSE THEN

1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121:
1122: -- TODO : THIS CHECK IS IRRELAVENT AS TRANSFER TO DRAFT DOESN'T RETURN TRUE/FALSE
1123: If l_return_status <> FND_API.G_FALSE THEN
1124: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1125: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1126: End If;
1127:

Line 1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1137: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1138: delete_entity_locks(p_draft_id => p_draft_id
1139: ,x_return_status => l_return_status);
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: Deleting entity locks failed';
1143: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;

Line 1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: Deleting entity locks failed';
1143: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;
1146:
1147: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: deleting entity locks successful';
1148: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

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

1159: , p_approval_path_id => p_approval_path_id
1160: , x_return_status => x_return_status
1161: , x_exception_msg => x_exception_msg
1162: );
1163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1164: g_result := l_return_status;
1165: g_error_message := x_exception_msg || 'Exception while call to PO_DOCUMENT_ACTION_PVT.do_approve failed';
1166: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1164: g_result := l_return_status;
1165: g_error_message := x_exception_msg || 'Exception while call to PO_DOCUMENT_ACTION_PVT.do_approve failed';
1166: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : MANAGE_ATTACHMENTS_MERGE';
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 1215: -- IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1211:
1212: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Do Reserve Return Status: '||x_return_status;
1213: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress);
1214: -- bug 13709183 Autonomous transaction must rollback in case of any error (expected, unexpected)
1215: -- IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1217: -- fetch error message
1218: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = x_online_report_id
1219: and rownum=1;

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

1212: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Do Reserve Return Status: '||x_return_status;
1213: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress);
1214: -- bug 13709183 Autonomous transaction must rollback in case of any error (expected, unexpected)
1215: -- IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1217: -- fetch error message
1218: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = x_online_report_id
1219: and rownum=1;
1220: g_result := x_return_status;

Line 1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1217: -- fetch error message
1218: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = x_online_report_id
1219: and rownum=1;
1220: g_result := x_return_status;
1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1222: END IF;
1223: END IF;-- PA Check
1224: END IF; --Enc On Check
1225:

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

1234: , p_approval_path_id => p_approval_path_id
1235: , x_return_status => x_return_status
1236: , x_exception_msg => x_exception_msg
1237: );
1238: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1239: -- fetch error message
1240: g_result := x_return_status;
1241: g_error_message := x_exception_msg || 'Exception while call for base doc PO_DOCUMENT_ACTION_PVT.do_approve failed';
1242: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);

Line 1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1239: -- fetch error message
1240: g_result := x_return_status;
1241: g_error_message := x_exception_msg || 'Exception while call for base doc PO_DOCUMENT_ACTION_PVT.do_approve failed';
1242: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: END IF;
1246:
1247: --

Line 1278: x_return_status := FND_API.G_RET_STS_SUCCESS;

1274: END IF;
1275:
1276: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Approve Action Successful.';
1277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279: COMMIT;
1280: EXCEPTION
1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279: COMMIT;
1280: EXCEPTION
1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: g_error_message := g_error_message || ' erorr encountered is ' ||SQLCODE||' -ERROR- '||SQLERRM ;
1284: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: in exception block with error ' || g_error_message;
1285: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1286: ROLLBACK TO MergeReserve_Autonomous_SP;

Line 1456: x_return_status := FND_API.G_RET_STS_SUCCESS;

1452: WHERE lock_by_draft_id = p_draft_id;
1453:
1454: -- TODO: Add call to OKC procedure to delete OKC locks for the Modification
1455:
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461: END delete_entity_locks;
1462:
1463: -------------------------------------------------------------------------------
1464: --Bug 13938456 : Concurrent Mod Attachments

Line 1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: l_is_par_enabled := 'N';
1972: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: END;
1975:
1976: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Is PAR Enabled : ' || l_is_par_enabled );
1977:

Line 1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1990:
1991: EXCEPTION
1992: WHEN OTHERS THEN
1993: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END update_par_line_status;
1996:
1997: /**
1998: *

Line 2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2360: IF (PO_LOG.d_stmt) THEN
2361: PO_LOG.stmt(d_module, d_progress, 'Exception in update_delivery_event_attr ' || sqlerrm);
2362: END IF;
2363:
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365:
2366: END update_delivery_event_attr;
2367:
2368: