DBA Data[Home] [Help]

APPS.CLN_PO_CHG_ORDER_STATUS dependencies on STANDARD

Line 168: l_po_type := 'STANDARD';

164: cln_debug_pub.Add('l_error_id:' || l_error_id,1);
165: cln_debug_pub.Add('l_error_status:' || l_error_status,1);
166: END IF;
167: IF l_error_id IS NULL OR l_error_id = 0 THEN
168: l_po_type := 'STANDARD';
169: l_doc_no := p_po_id; --bug #4889717
170: IF (p_po_rel_num IS NOT NULL AND p_po_rel_num > 0) THEN
171: l_po_type := 'RELEASE';
172: l_doc_no := concat(concat(p_po_id,':'),p_po_rel_num); --bug #4889717

Line 393: l_po_type := 'STANDARD';

389: cln_debug_pub.Add('Since this an already processed line, Nothing to do', 1);
390: END IF;
391: RETURN;
392: END IF;
393: l_po_type := 'STANDARD';
394: l_doc_no := p_po_id; --bug #4889717
395: IF (p_po_rel_num IS NOT NULL AND p_po_rel_num > 0) THEN
396: l_po_type := 'RELEASE';
397: l_doc_no := concat(concat(p_po_id,':'),p_po_rel_num); --bug #4889717

Line 437: p_po_type => 'STANDARD',

433: p_tp_site_id => l_tp_site_id,
434: p_level => 'LINE',
435: p_po_number => p_po_id,
436: p_release_number => p_po_rel_num,
437: p_po_type => 'STANDARD',
438: p_revision_num => NULL,
439: p_line_num => p_po_line_num,
440: p_reason => p_reason,
441: p_shipment_num => NULL,

Line 467: END IF; -- if itz a standard po

463: cln_debug_pub.Add('store_supplier_request',1);
464: cln_debug_pub.Add('l_error_id:' || l_error_id,1);
465: cln_debug_pub.Add('l_error_status:' || l_error_status,1);
466: END IF;
467: END IF; -- if itz a standard po
468: IF l_error_id IS NULL OR l_error_id = 0 THEN
469: RAISE_ADD_MESSAGE(
470: x_return_status => l_return_status,
471: x_msg_data => l_return_msg,

Line 696: l_po_type := 'STANDARD';

692: cln_debug_pub.Add('p_supp_line_ref:' || p_supp_line_ref, 1);
693: cln_debug_pub.Add('p_supplier_shipment_ref:' || p_supplier_shipment_ref, 1);
694: cln_debug_pub.Add('p_parent_shipment_number:' || p_parent_shipment_number, 1);
695: END IF;
696: l_po_type := 'STANDARD';
697: l_doc_no := p_po_id; --bug #4889717
698: IF (p_po_rel_num IS NOT NULL AND p_po_rel_num > 0) THEN
699: l_po_type := 'RELEASE';
700: l_doc_no := concat(concat(p_po_id,':'),p_po_rel_num); --bug #4889717

Line 765: p_po_type => 'STANDARD',

761: p_tp_site_id => l_tp_site_id,
762: p_level => 'LINE',
763: p_po_number => p_po_id,
764: p_release_number => p_po_rel_num,
765: p_po_type => 'STANDARD',
766: p_revision_num => NULL,
767: p_line_num => p_po_line_num,
768: p_reason => p_reason,
769: p_shipment_num => NULL,

Line 808: p_po_type => 'STANDARD',

804: p_tp_site_id => l_tp_site_id,
805: p_level => 'SHIPMENT',
806: p_po_number => p_po_id,
807: p_release_number => p_po_rel_num,
808: p_po_type => 'STANDARD',
809: -- Should not pass revision nmumber, it keeps changing
810: p_revision_num => NULL,
811: p_line_num => p_po_line_num,
812: p_reason => p_reason,

Line 840: END IF; -- if itz a standard po

836: cln_debug_pub.Add('l_error_id:' || l_error_id,1);
837: cln_debug_pub.Add('l_error_status:' || l_error_status,1);
838: END IF;
839: END IF;
840: END IF; -- if itz a standard po
841: IF l_error_id IS NULL OR l_error_id = 0 THEN
842: RAISE_ADD_MESSAGE(
843: x_return_status => l_return_status,
844: x_msg_data => l_return_msg,