APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_SUPPLIES

Line 282: DELETE MSC_SUPPLIES MS

278:
279: IF a_plan_id.COUNT > 0 THEN
280: BEGIN
281: FORALL i in 1..a_plan_id.COUNT
282: DELETE MSC_SUPPLIES MS
283: WHERE
284: ms.plan_id = a_plan_id(i)
285: and ms.inventory_item_id = a_inventory_item_id(i)
286: and ms.supplier_id = a_supplier_id(i)

Line 305: LOG_MESSAGE('Error while deleting PO Acknowledgment records from msc_supplies');

301: */
302: COMMIT;
303:
304: EXCEPTION WHEN OTHERS THEN
305: LOG_MESSAGE('Error while deleting PO Acknowledgment records from msc_supplies');
306: RAISE;
307:
308: END;
309: END IF;

Line 462: lv_temp_supply_tbl := 'MSC_SUPPLIES';

458: -- we need to insert records in temporary table.
459: --=============================================================
460:
461: IF (p_is_incremental_refresh) THEN
462: lv_temp_supply_tbl := 'MSC_SUPPLIES';
463: ELSIF (p_is_partial_refresh OR p_is_complete_refresh) THEN
464: lv_temp_supply_tbl := p_temp_supply_table;
465: END IF;
466:

Line 498: ||' MSC_SUPPLIES_S.NEXTVAL, '

494: ||'ACCEPTANCE_REQUIRED_FLAG, '
495: ||'CREATED_BY )'
496: ||' VALUES '
497: ||'(:PLAN_ID, '
498: ||' MSC_SUPPLIES_S.NEXTVAL, '
499: ||' :INVENTORY_ITEM_ID, '
500: ||' :SR_INSTANCE_ID, '
501: ||' :ORGANIZATION_ID, '
502: ||' :DISPOSITION_ID, '

Line 552: LOG_MESSAGE('ERROR while inserting PO Acknowledgment Records in MSC_SUPPLIES');

548:
549: COMMIT;
550:
551: EXCEPTION WHEN OTHERS THEN
552: LOG_MESSAGE('ERROR while inserting PO Acknowledgment Records in MSC_SUPPLIES');
553: LOG_MESSAGE(SQLERRM);
554: RAISE;
555: RETURN;
556: END;

Line 609: msc_supplies ms

605: 0, null, substr(end_order_number, instr(end_order_number,'('))) */
606: ,ms.NEW_ORDER_PLACEMENT_DATE order_placement_date
607: ,ms.NEED_BY_DATE request_date
608: from
609: msc_supplies ms
610: -- Table to get org equivalent company_site_id
611: ,msc_companies mc
612: ,msc_company_sites mcs
613: ,msc_company_site_id_lid mcsil

Line 730: msc_supplies ms

726: 0, null,
727: substr(end_order_number, instr(end_order_number,'('))) end_order_rel_number
728: ,ms.NEED_BY_DATE request_date
729: from
730: msc_supplies ms
731: -- Table to get org equivalent company_site_id
732: ,msc_company_site_id_lid mcsil
733: -- Tables to get Supplier's company_id
734: ,msc_trading_partner_maps mtpm

Line 1389: LOG_MESSAGE('Error while updating msc_supplies for rejected PO Shipments');

1385:
1386: COMMIT;
1387:
1388: EXCEPTION WHEN OTHERS THEN
1389: LOG_MESSAGE('Error while updating msc_supplies for rejected PO Shipments');
1390: LOG_MESSAGE(SQLERRM);
1391: RAISE;
1392: END;
1393: