[Home] [Help]
512: l_ind_lci NUMBER := 1; --Bug#8971617
513: l_po_UOM_code VARCHAR2(25); --Bug#9884458
514:
515: --Bug#10381495
516: l_previous_access_mode VARCHAR2(1) :=mo_global.get_access_mode();
517: l_previous_org_id NUMBER(15) :=mo_global.get_current_org_id();
518: l_current_org_id NUMBER(15);
519: --Bug#10381495
520:
513: l_po_UOM_code VARCHAR2(25); --Bug#9884458
514:
515: --Bug#10381495
516: l_previous_access_mode VARCHAR2(1) :=mo_global.get_access_mode();
517: l_previous_org_id NUMBER(15) :=mo_global.get_current_org_id();
518: l_current_org_id NUMBER(15);
519: --Bug#10381495
520:
521: BEGIN
594: p_procedure_name => l_proc_name,
595: p_debug_info => 'Seting a new context from '||l_current_org_id||' to '||p_int_rec(i).org_id
596: );
597: l_current_org_id:=p_int_rec(i).org_id;
598: mo_global.set_policy_context( 'S', l_current_org_id);
599: INL_LOGGING_PVT.Log_Statement(
600: p_module_name => g_module_name,
601: p_procedure_name => l_proc_name,
602: p_debug_info => 'l_current_org_id: '||l_current_org_id
1394: p_module_name => g_module_name,
1395: p_procedure_name => l_proc_name,
1396: p_debug_info => 'Restore previous context: from '||l_current_org_id||' to '||l_previous_org_id
1397: );
1398: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1399: END IF;
1400: --Bug#10381495
1401:
1402: -- Standard call to get message count and if count is 1, get message info.
1427: p_module_name => g_module_name,
1428: p_procedure_name => l_proc_name,
1429: p_debug_info => 'Restore previous context: from '||l_current_org_id||' to '||l_previous_org_id
1430: );
1431: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1432: END IF;
1433: --Bug#10381495
1434: FND_MSG_PUB.Count_And_Get (
1435: p_encoded => FND_API.g_false,
1451: p_module_name => g_module_name,
1452: p_procedure_name => l_proc_name,
1453: p_debug_info => 'Restore previous context: from '||l_current_org_id||' to '||l_previous_org_id
1454: );
1455: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1456: END IF;
1457: --Bug#10381495
1458: FND_MSG_PUB.Count_And_Get (
1459: p_encoded => FND_API.g_false,
1475: p_module_name => g_module_name,
1476: p_procedure_name => l_proc_name,
1477: p_debug_info => 'Restore previous context: from '||l_current_org_id||' to '||l_previous_org_id
1478: );
1479: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1480: END IF;
1481: --Bug#10381495
1482: FND_MSG_PUB.Count_And_Get (
1483: p_encoded => FND_API.g_false,
1724: WHERE processing_status_code = 'RUNNING'
1725: AND transaction_status_code = 'PENDING'
1726: AND processing_mode_code = p_processing_mode
1727: AND group_id = nvl(p_group_id, group_id)
1728: AND mo_global.check_access(org_id) = 'Y'
1729: AND processing_mode_code = p_processing_mode
1730: AND source_document_code = 'PO'
1731: -- SCM-051 AND transaction_type NOT IN('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1732: AND lcm_shipment_line_id IS NOT NULL
1749: AND transaction_status_code = 'PENDING'
1750: AND processing_mode_code = p_processing_mode
1751: AND group_id = nvl(p_group_id, group_id)
1752: AND processing_mode_code = p_processing_mode
1753: AND mo_global.check_access(org_id) = 'Y'
1754: AND source_document_code = 'PO'
1755: -- SCM-051 AND transaction_type NOT IN('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1756: AND lcm_shipment_line_id IS NOT NULL
1757: AND lcm_shipment_line_id = p_rti_rec(i).line_id;
1771: UPDATE rcv_transactions_interface
1772: SET processing_status_code = 'ERROR'
1773: WHERE processing_status_code = 'RUNNING'
1774: AND transaction_status_code = 'PENDING'
1775: AND mo_global.check_access(org_id) = 'Y'
1776: AND processing_mode_code = p_processing_mode
1777: AND group_id = nvl(p_group_id, group_id)
1778: AND source_document_code = 'PO'
1779: -- SCM-051 AND transaction_type NOT IN ('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')