DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on PO_SUPPLY

Line 551: IF NOT po_supply.po_req_supply(

547: cancel_date = sysdate
548: where requisition_line_id = l_line_tbl(I).requisition_line_id;
549:
550: -- update mtl_supply data for the requisition
551: IF NOT po_supply.po_req_supply(
552: p_docid => null,
553: p_lineid => l_line_Tbl(I).requisition_line_id,
554: p_shipid => null,
555: p_action => 'Remove_Req_Line_Supply',

Line 562: value1 => 'PO_SUPPLY',

558: p_receipt_date => NULL) THEN
559:
560: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
561: token1 => 'FILE',
562: value1 => 'PO_SUPPLY',
563: token2 => 'ERR_NUMBER',
564: value2 => '035',
565: token3 => 'SUBROUTINE',
566: value3 => 'PO_REQ_SUPPLY()');

Line 844: /* IF NOT po_supply.po_req_supply(

840: where requisition_line_id = lx_oe_line_tbl(I).source_document_line_id;
841:
842:
843: -- update mtl_supply data for the requisition
844: /* IF NOT po_supply.po_req_supply(
845: p_docid => null,
846: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
847: p_shipid => null,
848: p_action => 'Remove_Req_Line_Supply',

Line 865: value1 => 'PO_SUPPLY',

861: when no_data_found THEN
862:
863: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
864: token1 => 'FILE',
865: value1 => 'PO_SUPPLY',
866: token2 => 'ERR_NUMBER',
867: value2 => '035',
868: token3 => 'SUBROUTINE',
869: value3 => 'PO_REQ_SUPPLY()');

Line 3648: IF NOT po_supply.po_req_supply(

3644: set req_line_quantity = l_line_tbl(i).ordered_quantity
3645: where requisition_line_id = l_line_tbl(i).requisition_line_id;
3646:
3647: -- update mtl_supply data for the requisition
3648: IF NOT po_supply.po_req_supply(
3649: p_docid => null,
3650: p_lineid => l_line_Tbl(I).requisition_line_id,
3651: p_shipid => null,
3652: p_action => 'Update_Req_Line_Qty',

Line 3659: value1 => 'PO_SUPPLY',

3655: p_receipt_date => NULL) THEN
3656:
3657: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
3658: token1 => 'FILE',
3659: value1 => 'PO_SUPPLY',
3660: token2 => 'ERR_NUMBER',
3661: value2 => '035',
3662: token3 => 'SUBROUTINE',
3663: value3 => 'PO_REQ_SUPPLY()');

Line 3696: /*IF NOT po_supply.po_req_supply(

3692:
3693: -- create supply information for requisitions created
3694: IF (p_process_type in ('REQUISITION', 'BOTH') AND l_header_Rec.operation = G_OPR_CREATE) THEN
3695:
3696: /*IF NOT po_supply.po_req_supply(
3697: p_docid => l_header_rec.requisition_header_id,
3698: p_lineid => null,
3699: p_shipid => null,
3700: p_action => 'Approve_Req_Supply',

Line 3708: value1 => 'PO_SUPPLY',

3704:
3705:
3706: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
3707: token1 => 'FILE',
3708: value1 => 'PO_SUPPLY',
3709: token2 => 'ERR_NUMBER',
3710: value2 => '005',
3711: token3 => 'SUBROUTINE',
3712: value3 => 'PO_REQ_SUPPLY()');

Line 3807: value1 => 'PO_SUPPLY',

3803: when no_data_found THEN
3804:
3805: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
3806: token1 => 'FILE',
3807: value1 => 'PO_SUPPLY',
3808: token2 => 'ERR_NUMBER',
3809: value2 => '005',
3810: token3 => 'SUBROUTINE',
3811: value3 => 'PO_REQ_SUPPLY()');

Line 4205: IF NOT po_supply.po_req_supply(

4201: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
4202:
4203:
4204: -- update mtl_supply data for the requisition
4205: IF NOT po_supply.po_req_supply(
4206: p_docid => null,
4207: p_lineid => lx_oe_line_Tbl(I).source_document_line_id,
4208: p_shipid => null,
4209: p_action => 'Update_Req_Line_Qty',

Line 4216: value1 => 'PO_SUPPLY',

4212: p_receipt_date => NULL) THEN
4213:
4214: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
4215: token1 => 'FILE',
4216: value1 => 'PO_SUPPLY',
4217: token2 => 'ERR_NUMBER',
4218: value2 => '035',
4219: token3 => 'SUBROUTINE',
4220: value3 => 'PO_REQ_SUPPLY()');