DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on PO_SUPPLY

Line 528: IF NOT po_supply.po_req_supply(

524: cancel_date = sysdate
525: where requisition_line_id = l_line_tbl(I).requisition_line_id;
526:
527: -- update mtl_supply data for the requisition
528: IF NOT po_supply.po_req_supply(
529: p_docid => null,
530: p_lineid => l_line_Tbl(I).requisition_line_id,
531: p_shipid => null,
532: p_action => 'Remove_Req_Line_Supply',

Line 539: value1 => 'PO_SUPPLY',

535: p_receipt_date => NULL) THEN
536:
537: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
538: token1 => 'FILE',
539: value1 => 'PO_SUPPLY',
540: token2 => 'ERR_NUMBER',
541: value2 => '035',
542: token3 => 'SUBROUTINE',
543: value3 => 'PO_REQ_SUPPLY()');

Line 765: /* IF NOT po_supply.po_req_supply(

761: where requisition_line_id = lx_oe_line_tbl(I).source_document_line_id;
762:
763:
764: -- update mtl_supply data for the requisition
765: /* IF NOT po_supply.po_req_supply(
766: p_docid => null,
767: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
768: p_shipid => null,
769: p_action => 'Remove_Req_Line_Supply',

Line 786: value1 => 'PO_SUPPLY',

782: when no_data_found THEN
783:
784: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
785: token1 => 'FILE',
786: value1 => 'PO_SUPPLY',
787: token2 => 'ERR_NUMBER',
788: value2 => '035',
789: token3 => 'SUBROUTINE',
790: value3 => 'PO_REQ_SUPPLY()');

Line 2383: IF NOT po_supply.po_req_supply(

2379: set req_line_quantity = l_line_tbl(i).ordered_quantity
2380: where requisition_line_id = l_line_tbl(i).requisition_line_id;
2381:
2382: -- update mtl_supply data for the requisition
2383: IF NOT po_supply.po_req_supply(
2384: p_docid => null,
2385: p_lineid => l_line_Tbl(I).requisition_line_id,
2386: p_shipid => null,
2387: p_action => 'Update_Req_Line_Qty',

Line 2394: value1 => 'PO_SUPPLY',

2390: p_receipt_date => NULL) THEN
2391:
2392: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2393: token1 => 'FILE',
2394: value1 => 'PO_SUPPLY',
2395: token2 => 'ERR_NUMBER',
2396: value2 => '035',
2397: token3 => 'SUBROUTINE',
2398: value3 => 'PO_REQ_SUPPLY()');

Line 2431: /*IF NOT po_supply.po_req_supply(

2427:
2428: -- create supply information for requisitions created
2429: IF (p_process_type in ('REQUISITION', 'BOTH') AND l_header_Rec.operation = G_OPR_CREATE) THEN
2430:
2431: /*IF NOT po_supply.po_req_supply(
2432: p_docid => l_header_rec.requisition_header_id,
2433: p_lineid => null,
2434: p_shipid => null,
2435: p_action => 'Approve_Req_Supply',

Line 2443: value1 => 'PO_SUPPLY',

2439:
2440:
2441: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2442: token1 => 'FILE',
2443: value1 => 'PO_SUPPLY',
2444: token2 => 'ERR_NUMBER',
2445: value2 => '005',
2446: token3 => 'SUBROUTINE',
2447: value3 => 'PO_REQ_SUPPLY()');

Line 2542: value1 => 'PO_SUPPLY',

2538: when no_data_found THEN
2539:
2540: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2541: token1 => 'FILE',
2542: value1 => 'PO_SUPPLY',
2543: token2 => 'ERR_NUMBER',
2544: value2 => '005',
2545: token3 => 'SUBROUTINE',
2546: value3 => 'PO_REQ_SUPPLY()');

Line 2741: IF NOT po_supply.po_req_supply(

2737: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
2738:
2739:
2740: -- update mtl_supply data for the requisition
2741: IF NOT po_supply.po_req_supply(
2742: p_docid => null,
2743: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
2744: p_shipid => null,
2745: p_action => 'Update_Req_Line_Qty',

Line 2752: value1 => 'PO_SUPPLY',

2748: p_receipt_date => NULL) THEN
2749:
2750: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2751: token1 => 'FILE',
2752: value1 => 'PO_SUPPLY',
2753: token2 => 'ERR_NUMBER',
2754: value2 => '035',
2755: token3 => 'SUBROUTINE',
2756: value3 => 'PO_REQ_SUPPLY()');