1574: FROM po_requisition_headers_all
1575: WHERE requisition_header_id = p_req_hdr_id;
1576:
1577: -- set org context back to req's org
1578: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
1580: IF(l_return_status = fnd_api.g_ret_sts_error) THEN
1581: x_retmsg := 'VC0d31:' || l_return_msg;
1582: l_err_count := l_doc_check_rec_type.online_report_id.count;
3185: -- save current org id
3186: l_req_org_id := mo_global.get_current_org_id();
3187:
3188: -- Set the org context before calling the cancel api
3189: po_moac_utils_pvt.set_org_context(l_po_org_id) ; --
3191: l_progress := '012';
3192:
3193: po_document_control_grp.check_control_action(
3208:
3209: l_progress := '013';
3210:
3211: -- set org context to the original value
3212: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
3214: IF (g_fnd_debug = 'Y') THEN
3215: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3216: fnd_log.string(fnd_log.level_statement,
5120: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5121: END IF;
5122:
5123: IF l_orgid is NOT NULL THEN
5124: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5126:
5127: l_progress := '002';
5128: -- OM_API.is_req_line_cancellable(l_req_header_id,l_req_line_id,x_return_status);
5145: po_debug.debug_var(l_log_head, l_progress, 'requisition l_orgid', l_orgid);
5146: END IF;
5147:
5148: IF l_orgid is NOT NULL THEN
5149: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5151:
5152: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5176: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5177: END IF;
5178:
5179: IF l_orgid is NOT NULL THEN
5180: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5182:
5183: l_progress := '003';
5184: -- OM_API.is_req_line_cancellable(l_req_header_id,l_req_line_id,x_return_status);
5201: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
5202: END IF;
5203:
5204: IF l_orgid is NOT NULL THEN
5205: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5207:
5208: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5292: END IF;
5293:
5294: IF l_orgid is NOT NULL THEN
5295: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5297:
5298:
5299: -- OM_API.is_req_line_changeable(l_req_header_id,l_req_line_id,x_return_status);
5315: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
5316: END IF;
5317:
5318: IF l_orgid is NOT NULL THEN
5319: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5321:
5322: x_update_allowed := POR_UTIL_PKG.bool_to_varchar(l_update_allowed);
5323: x_cancel_allowed := POR_UTIL_PKG.bool_to_varchar(l_cancel_allowed);
6880: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
6881: END IF;
6882:
6883: IF l_orgid is NOT NULL THEN
6884: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6886:
6887: IF g_debug_stmt THEN
6888: po_debug.debug_stmt(l_log_head, l_progress, 'Calling OM API Validating the changes');
6911: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
6912: END IF;
6913:
6914: IF l_orgid is NOT NULL THEN
6915: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6917:
6918:
6919: IF g_debug_stmt THEN