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',
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()');
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',
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()');
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',
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()');
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',
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()');
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()');
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',
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()');