eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SHIPMENTS_SV4 dependencies on PO_LOG

Line 948: IF (PO_LOG.d_proc) THEN

944: d_pos NUMBER := 0;
945: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
946: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
947: BEGIN
948: IF (PO_LOG.d_proc) THEN
949: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type);
950: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
951: END IF;
952:

Line 949: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type);

945: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
946: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
947: BEGIN
948: IF (PO_LOG.d_proc) THEN
949: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type);
950: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
951: END IF;
952:
953: SELECT shipment_type,

Line 950: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);

946: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
947: BEGIN
948: IF (PO_LOG.d_proc) THEN
949: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type);
950: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
951: END IF;
952:
953: SELECT shipment_type,
954: approved_flag

Line 961: IF (PO_LOG.d_stmt) THEN

957: FROM po_line_locations_all
958: WHERE line_location_id = p_line_loc_id;
959:
960: d_pos := 10;
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type); PO_LOG.stmt(d_module,d_pos,'l_approved_flag', l_approved_flag);
963: END IF;
964:
965: -- Do not allow deletion for Approved PO/PA

Line 962: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type); PO_LOG.stmt(d_module,d_pos,'l_approved_flag', l_approved_flag);

958: WHERE line_location_id = p_line_loc_id;
959:
960: d_pos := 10;
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type); PO_LOG.stmt(d_module,d_pos,'l_approved_flag', l_approved_flag);
963: END IF;
964:
965: -- Do not allow deletion for Approved PO/PA
966: IF (l_approved_flag IN ('Y', 'R'))

Line 1016: IF (PO_LOG.d_proc) THEN

1012: --If there are multiple viable shipments then we can allow the deletion of this shipment
1013: NULL;
1014: END ;
1015:
1016: IF (PO_LOG.d_proc) THEN
1017: PO_LOG.proc_end(d_module);
1018: END IF;
1019:
1020: EXCEPTION

Line 1017: PO_LOG.proc_end(d_module);

1013: NULL;
1014: END ;
1015:
1016: IF (PO_LOG.d_proc) THEN
1017: PO_LOG.proc_end(d_module);
1018: END IF;
1019:
1020: EXCEPTION
1021: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

Line 1022: IF (PO_LOG.d_stmt) THEN

1018: END IF;
1019:
1020: EXCEPTION
1021: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1022: IF (PO_LOG.d_stmt) THEN
1023: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1024: END IF;
1025: WHEN OTHERS THEN
1026: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

Line 1023: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);

1019:
1020: EXCEPTION
1021: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1022: IF (PO_LOG.d_stmt) THEN
1023: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1024: END IF;
1025: WHEN OTHERS THEN
1026: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1027: IF PO_LOG.d_exc THEN

Line 1027: IF PO_LOG.d_exc THEN

1023: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1024: END IF;
1025: WHEN OTHERS THEN
1026: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1027: IF PO_LOG.d_exc THEN
1028: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1029: END IF;
1030: RAISE;
1031: END validate_delete_line_loc;

Line 1028: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);

1024: END IF;
1025: WHEN OTHERS THEN
1026: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1027: IF PO_LOG.d_exc THEN
1028: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1029: END IF;
1030: RAISE;
1031: END validate_delete_line_loc;
1032:

Line 1099: IF (PO_LOG.d_proc) THEN

1095: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_line_loc';
1096: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.process_delete_line_loc';
1097:
1098: BEGIN
1099: IF (PO_LOG.d_proc) THEN
1100: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_line_loc_row_id', p_line_loc_row_id); PO_LOG.proc_begin(d_module,'p_po_header_id', p_po_header_id);
1101: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1102: END IF;
1103:

Line 1100: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_line_loc_row_id', p_line_loc_row_id); PO_LOG.proc_begin(d_module,'p_po_header_id', p_po_header_id);

1096: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.process_delete_line_loc';
1097:
1098: BEGIN
1099: IF (PO_LOG.d_proc) THEN
1100: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_line_loc_row_id', p_line_loc_row_id); PO_LOG.proc_begin(d_module,'p_po_header_id', p_po_header_id);
1101: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1102: END IF;
1103:
1104: d_pos := 10;

Line 1101: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);

1097:
1098: BEGIN
1099: IF (PO_LOG.d_proc) THEN
1100: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_line_loc_row_id', p_line_loc_row_id); PO_LOG.proc_begin(d_module,'p_po_header_id', p_po_header_id);
1101: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1102: END IF;
1103:
1104: d_pos := 10;
1105: --get the required data of shipment's header and line

Line 1118: IF (PO_LOG.d_stmt) THEN

1114: p_po_header_id,
1115: l_shipment_type);
1116:
1117: d_pos := 30;
1118: IF (PO_LOG.d_stmt) THEN
1119: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type);
1120: END IF;
1121:
1122: SELECT *

Line 1119: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type);

1115: l_shipment_type);
1116:
1117: d_pos := 30;
1118: IF (PO_LOG.d_stmt) THEN
1119: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type);
1120: END IF;
1121:
1122: SELECT *
1123: INTO l_po_lines_rec

Line 1128: IF (PO_LOG.d_stmt) THEN

1124: FROM po_lines_all
1125: WHERE po_line_id = p_po_line_id;
1126:
1127: d_pos := 40;
1128: IF (PO_LOG.d_stmt) THEN
1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);

Line 1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);

1125: WHERE po_line_id = p_po_line_id;
1126:
1127: d_pos := 40;
1128: IF (PO_LOG.d_stmt) THEN
1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);

Line 1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);

1126:
1127: d_pos := 40;
1128: IF (PO_LOG.d_stmt) THEN
1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);

Line 1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);

1127: d_pos := 40;
1128: IF (PO_LOG.d_stmt) THEN
1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);

Line 1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);

1128: IF (PO_LOG.d_stmt) THEN
1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);
1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);

Line 1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);

1129: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.price_break_lookup_code', l_po_lines_rec.price_break_lookup_code); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.base_unit_price', l_po_lines_rec.base_unit_price);
1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);
1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1137: END IF;

Line 1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);

1130: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.category_id', l_po_lines_rec.category_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.contract_id', l_po_lines_rec.contract_id);
1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);
1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1137: END IF;
1138:

Line 1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);

1131: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.creation_date', l_po_lines_rec.creation_date); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_header_id', l_po_lines_rec.from_header_id);
1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);
1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1137: END IF;
1138:
1139: SELECT poh.vendor_id,

Line 1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);

1132: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.from_line_id', l_po_lines_rec.from_line_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_id', l_po_lines_rec.item_id);
1133: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.item_revision', l_po_lines_rec.item_revision); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.line_type_id', l_po_lines_rec.line_type_id);
1134: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_header_id', l_po_lines_rec.po_header_id); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.po_line_id', l_po_lines_rec.po_line_id);
1135: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.quantity', l_po_lines_rec.quantity); PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.unit_meas_lookup_code', l_po_lines_rec.unit_meas_lookup_code);
1136: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1137: END IF;
1138:
1139: SELECT poh.vendor_id,
1140: poh.vendor_site_id,

Line 1149: IF (PO_LOG.d_stmt) THEN

1145: FROM po_headers_all poh
1146: WHERE poh.po_header_id = l_po_lines_rec.po_header_id;
1147:
1148: d_pos := 50;
1149: IF (PO_LOG.d_stmt) THEN
1150: PO_LOG.stmt(d_module,d_pos,'l_vendor_id',l_vendor_id); PO_LOG.stmt(d_module,d_pos,'l_vendor_site_id',l_vendor_site_id); PO_LOG.stmt(d_module,d_pos,'l_currency_code',l_currency_code);
1151: END IF;
1152:
1153: --Deleting price break is a retroactive change. Call the

Line 1150: PO_LOG.stmt(d_module,d_pos,'l_vendor_id',l_vendor_id); PO_LOG.stmt(d_module,d_pos,'l_vendor_site_id',l_vendor_site_id); PO_LOG.stmt(d_module,d_pos,'l_currency_code',l_currency_code);

1146: WHERE poh.po_header_id = l_po_lines_rec.po_header_id;
1147:
1148: d_pos := 50;
1149: IF (PO_LOG.d_stmt) THEN
1150: PO_LOG.stmt(d_module,d_pos,'l_vendor_id',l_vendor_id); PO_LOG.stmt(d_module,d_pos,'l_vendor_site_id',l_vendor_site_id); PO_LOG.stmt(d_module,d_pos,'l_currency_code',l_currency_code);
1151: END IF;
1152:
1153: --Deleting price break is a retroactive change. Call the
1154: -- API to update po_lines.retroactive_date. This needs to be

Line 1177: IF (PO_LOG.d_stmt) THEN

1173: PO_SOURCING2_SV.get_min_shipment_num(l_po_lines_rec.po_line_id,
1174: l_min_shipment_num);
1175:
1176: d_pos := 90;
1177: IF (PO_LOG.d_stmt) THEN
1178: PO_LOG.stmt(d_module,d_pos,'l_min_shipment_num', l_min_shipment_num);
1179: END IF;
1180: -- Call the API to obtain the new price based on the 1st shipment of the
1181: -- standard PO.

Line 1178: PO_LOG.stmt(d_module,d_pos,'l_min_shipment_num', l_min_shipment_num);

1174: l_min_shipment_num);
1175:
1176: d_pos := 90;
1177: IF (PO_LOG.d_stmt) THEN
1178: PO_LOG.stmt(d_module,d_pos,'l_min_shipment_num', l_min_shipment_num);
1179: END IF;
1180: -- Call the API to obtain the new price based on the 1st shipment of the
1181: -- standard PO.
1182: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

Line 1184: IF (PO_LOG.d_stmt) THEN

1180: -- Call the API to obtain the new price based on the 1st shipment of the
1181: -- standard PO.
1182: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
1183: d_pos := 100;
1184: IF (PO_LOG.d_stmt) THEN
1185: PO_LOG.stmt(d_module,d_pos,'l_org_id', l_org_id);
1186: END IF;
1187:
1188: PO_SOURCING2_SV.get_shipment_price(

Line 1185: PO_LOG.stmt(d_module,d_pos,'l_org_id', l_org_id);

1181: -- standard PO.
1182: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
1183: d_pos := 100;
1184: IF (PO_LOG.d_stmt) THEN
1185: PO_LOG.stmt(d_module,d_pos,'l_org_id', l_org_id);
1186: END IF;
1187:
1188: PO_SOURCING2_SV.get_shipment_price(
1189: p_po_line_id => l_po_lines_rec.po_line_id,

Line 1213: IF (PO_LOG.d_stmt) THEN

1209: x_price => l_price,
1210: x_from_line_location_id => l_from_line_location_id);
1211:
1212: d_pos := 100;
1213: IF (PO_LOG.d_stmt) THEN
1214: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price); PO_LOG.stmt(d_module, 'l_from_line_location_id', l_from_line_location_id);
1215: END IF;
1216:
1217: -- Check whether the above call to the Pricing API returned a

Line 1214: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price); PO_LOG.stmt(d_module, 'l_from_line_location_id', l_from_line_location_id);

1210: x_from_line_location_id => l_from_line_location_id);
1211:
1212: d_pos := 100;
1213: IF (PO_LOG.d_stmt) THEN
1214: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price); PO_LOG.stmt(d_module, 'l_from_line_location_id', l_from_line_location_id);
1215: END IF;
1216:
1217: -- Check whether the above call to the Pricing API returned a
1218: -- price break that is different than what is currently

Line 1230: IF (PO_LOG.d_stmt) THEN

1226: --Reinitialise the price values to original values if pricing
1227: --call returns null
1228: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1229: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1230: IF (PO_LOG.d_stmt) THEN
1231: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1232: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));
1233: END IF;
1234:

Line 1231: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);

1227: --call returns null
1228: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1229: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1230: IF (PO_LOG.d_stmt) THEN
1231: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1232: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));
1233: END IF;
1234:
1235: d_pos := 120;

Line 1232: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));

1228: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1229: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1230: IF (PO_LOG.d_stmt) THEN
1231: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1232: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));
1233: END IF;
1234:
1235: d_pos := 120;
1236: -- Update the line price and from_line_location_id in PO_LINES_ALL

Line 1262: IF (PO_LOG.d_stmt) THEN

1258: l_ga_entity_type := 'BLANKET LINE';
1259: l_ga_entity_id := l_po_lines_rec.from_line_id;
1260: END IF;
1261: d_pos := 130;
1262: IF (PO_LOG.d_stmt) THEN
1263: PO_LOG.stmt(d_module, 'l_ga_entity_type', l_ga_entity_type); PO_LOG.stmt(d_module, 'l_ga_entity_id', l_ga_entity_id);
1264: END IF;
1265: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
1266: p_entity_type => 'PO LINE',

Line 1263: PO_LOG.stmt(d_module, 'l_ga_entity_type', l_ga_entity_type); PO_LOG.stmt(d_module, 'l_ga_entity_id', l_ga_entity_id);

1259: l_ga_entity_id := l_po_lines_rec.from_line_id;
1260: END IF;
1261: d_pos := 130;
1262: IF (PO_LOG.d_stmt) THEN
1263: PO_LOG.stmt(d_module, 'l_ga_entity_type', l_ga_entity_type); PO_LOG.stmt(d_module, 'l_ga_entity_id', l_ga_entity_id);
1264: END IF;
1265: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
1266: p_entity_type => 'PO LINE',
1267: p_entity_id => l_po_lines_rec.po_line_id);

Line 1287: IF (PO_LOG.d_proc) THEN

1283: last_updated_by = fnd_global.user_id
1284: WHERE po_line_id = l_po_lines_rec.po_line_id;
1285: END IF; --l_type_lookup_code = 'STANDARD'
1286:
1287: IF (PO_LOG.d_proc) THEN
1288: PO_LOG.proc_end(d_module);
1289: END IF;
1290:
1291: EXCEPTION

Line 1288: PO_LOG.proc_end(d_module);

1284: WHERE po_line_id = l_po_lines_rec.po_line_id;
1285: END IF; --l_type_lookup_code = 'STANDARD'
1286:
1287: IF (PO_LOG.d_proc) THEN
1288: PO_LOG.proc_end(d_module);
1289: END IF;
1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN

Line 1294: IF PO_LOG.d_exc THEN

1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1294: IF PO_LOG.d_exc THEN
1295: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1296: END IF;
1297: RAISE;
1298: END process_delete_line_loc;

Line 1295: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);

1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1294: IF PO_LOG.d_exc THEN
1295: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1296: END IF;
1297: RAISE;
1298: END process_delete_line_loc;
1299: