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 928: IF (PO_LOG.d_proc) THEN

924: d_pos NUMBER := 0;
925: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
926: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
927: BEGIN
928: IF (PO_LOG.d_proc) THEN
929: 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);
930: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
931: END IF;
932:

Line 929: 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);

925: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_line_loc';
926: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
927: BEGIN
928: IF (PO_LOG.d_proc) THEN
929: 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);
930: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
931: END IF;
932:
933: SELECT shipment_type,

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

926: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.validate_delete_line_loc';
927: BEGIN
928: IF (PO_LOG.d_proc) THEN
929: 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);
930: PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
931: END IF;
932:
933: SELECT shipment_type,
934: approved_flag

Line 941: IF (PO_LOG.d_stmt) THEN

937: FROM po_line_locations_all
938: WHERE line_location_id = p_line_loc_id;
939:
940: d_pos := 10;
941: IF (PO_LOG.d_stmt) THEN
942: 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);
943: END IF;
944:
945: -- Do not allow deletion for Approved PO/PA

Line 942: 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);

938: WHERE line_location_id = p_line_loc_id;
939:
940: d_pos := 10;
941: IF (PO_LOG.d_stmt) THEN
942: 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);
943: END IF;
944:
945: -- Do not allow deletion for Approved PO/PA
946: IF (l_approved_flag IN ('Y', 'R'))

Line 996: IF (PO_LOG.d_proc) THEN

992: --If there are multiple viable shipments then we can allow the deletion of this shipment
993: NULL;
994: END ;
995:
996: IF (PO_LOG.d_proc) THEN
997: PO_LOG.proc_end(d_module);
998: END IF;
999:
1000: EXCEPTION

Line 997: PO_LOG.proc_end(d_module);

993: NULL;
994: END ;
995:
996: IF (PO_LOG.d_proc) THEN
997: PO_LOG.proc_end(d_module);
998: END IF;
999:
1000: EXCEPTION
1001: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

Line 1002: IF (PO_LOG.d_stmt) THEN

998: END IF;
999:
1000: EXCEPTION
1001: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1002: IF (PO_LOG.d_stmt) THEN
1003: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1004: END IF;
1005: WHEN OTHERS THEN
1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

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

999:
1000: EXCEPTION
1001: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1002: IF (PO_LOG.d_stmt) THEN
1003: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1004: END IF;
1005: WHEN OTHERS THEN
1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1007: IF PO_LOG.d_exc THEN

Line 1007: IF PO_LOG.d_exc THEN

1003: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1004: END IF;
1005: WHEN OTHERS THEN
1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1007: IF PO_LOG.d_exc THEN
1008: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1009: END IF;
1010: RAISE;
1011: END validate_delete_line_loc;

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

1004: END IF;
1005: WHEN OTHERS THEN
1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1007: IF PO_LOG.d_exc THEN
1008: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1009: END IF;
1010: RAISE;
1011: END validate_delete_line_loc;
1012:

Line 1079: IF (PO_LOG.d_proc) THEN

1075: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_line_loc';
1076: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.process_delete_line_loc';
1077:
1078: BEGIN
1079: IF (PO_LOG.d_proc) THEN
1080: 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);
1081: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1082: END IF;
1083:

Line 1080: 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);

1076: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SHIPMENTS_SV4.process_delete_line_loc';
1077:
1078: BEGIN
1079: IF (PO_LOG.d_proc) THEN
1080: 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);
1081: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1082: END IF;
1083:
1084: d_pos := 10;

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

1077:
1078: BEGIN
1079: IF (PO_LOG.d_proc) THEN
1080: 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);
1081: PO_LOG.proc_begin(d_module,'p_doc_subtype', p_doc_subtype);
1082: END IF;
1083:
1084: d_pos := 10;
1085: --get the required data of shipment's header and line

Line 1098: IF (PO_LOG.d_stmt) THEN

1094: p_po_header_id,
1095: l_shipment_type);
1096:
1097: d_pos := 30;
1098: IF (PO_LOG.d_stmt) THEN
1099: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type);
1100: END IF;
1101:
1102: SELECT *

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

1095: l_shipment_type);
1096:
1097: d_pos := 30;
1098: IF (PO_LOG.d_stmt) THEN
1099: PO_LOG.stmt(d_module,d_pos,'l_shipment_type',l_shipment_type);
1100: END IF;
1101:
1102: SELECT *
1103: INTO l_po_lines_rec

Line 1108: IF (PO_LOG.d_stmt) THEN

1104: FROM po_lines_all
1105: WHERE po_line_id = p_po_line_id;
1106:
1107: d_pos := 40;
1108: IF (PO_LOG.d_stmt) THEN
1109: 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);
1110: 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);
1111: 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);
1112: 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 1109: 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);

1105: WHERE po_line_id = p_po_line_id;
1106:
1107: d_pos := 40;
1108: IF (PO_LOG.d_stmt) THEN
1109: 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);
1110: 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);
1111: 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);
1112: 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);
1113: 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 1110: 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);

1106:
1107: d_pos := 40;
1108: IF (PO_LOG.d_stmt) THEN
1109: 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);
1110: 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);
1111: 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);
1112: 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);
1113: 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);
1114: 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 1111: 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);

1107: d_pos := 40;
1108: IF (PO_LOG.d_stmt) THEN
1109: 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);
1110: 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);
1111: 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);
1112: 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);
1113: 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);
1114: 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);
1115: 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 1112: 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);

1108: IF (PO_LOG.d_stmt) THEN
1109: 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);
1110: 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);
1111: 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);
1112: 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);
1113: 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);
1114: 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);
1115: 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);
1116: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);

Line 1113: 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);

1109: 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);
1110: 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);
1111: 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);
1112: 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);
1113: 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);
1114: 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);
1115: 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);
1116: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1117: END IF;

Line 1114: 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);

1110: 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);
1111: 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);
1112: 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);
1113: 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);
1114: 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);
1115: 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);
1116: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1117: END IF;
1118:

Line 1115: 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);

1111: 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);
1112: 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);
1113: 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);
1114: 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);
1115: 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);
1116: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1117: END IF;
1118:
1119: SELECT poh.vendor_id,

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

1112: 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);
1113: 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);
1114: 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);
1115: 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);
1116: PO_LOG.stmt(d_module, d_pos, 'l_po_lines_rec.vendor_product_num', l_po_lines_rec.vendor_product_num);
1117: END IF;
1118:
1119: SELECT poh.vendor_id,
1120: poh.vendor_site_id,

Line 1129: IF (PO_LOG.d_stmt) THEN

1125: FROM po_headers_all poh
1126: WHERE poh.po_header_id = l_po_lines_rec.po_header_id;
1127:
1128: d_pos := 50;
1129: IF (PO_LOG.d_stmt) THEN
1130: 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);
1131: END IF;
1132:
1133: --Deleting price break is a retroactive change. Call the

Line 1130: 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);

1126: WHERE poh.po_header_id = l_po_lines_rec.po_header_id;
1127:
1128: d_pos := 50;
1129: IF (PO_LOG.d_stmt) THEN
1130: 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);
1131: END IF;
1132:
1133: --Deleting price break is a retroactive change. Call the
1134: -- API to update po_lines.retroactive_date. This needs to be

Line 1157: IF (PO_LOG.d_stmt) THEN

1153: PO_SOURCING2_SV.get_min_shipment_num(l_po_lines_rec.po_line_id,
1154: l_min_shipment_num);
1155:
1156: d_pos := 90;
1157: IF (PO_LOG.d_stmt) THEN
1158: PO_LOG.stmt(d_module,d_pos,'l_min_shipment_num', l_min_shipment_num);
1159: END IF;
1160: -- Call the API to obtain the new price based on the 1st shipment of the
1161: -- standard PO.

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

1154: l_min_shipment_num);
1155:
1156: d_pos := 90;
1157: IF (PO_LOG.d_stmt) THEN
1158: PO_LOG.stmt(d_module,d_pos,'l_min_shipment_num', l_min_shipment_num);
1159: END IF;
1160: -- Call the API to obtain the new price based on the 1st shipment of the
1161: -- standard PO.
1162: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

Line 1164: IF (PO_LOG.d_stmt) THEN

1160: -- Call the API to obtain the new price based on the 1st shipment of the
1161: -- standard PO.
1162: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
1163: d_pos := 100;
1164: IF (PO_LOG.d_stmt) THEN
1165: PO_LOG.stmt(d_module,d_pos,'l_org_id', l_org_id);
1166: END IF;
1167:
1168: PO_SOURCING2_SV.get_shipment_price(

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

1161: -- standard PO.
1162: l_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
1163: d_pos := 100;
1164: IF (PO_LOG.d_stmt) THEN
1165: PO_LOG.stmt(d_module,d_pos,'l_org_id', l_org_id);
1166: END IF;
1167:
1168: PO_SOURCING2_SV.get_shipment_price(
1169: p_po_line_id => l_po_lines_rec.po_line_id,

Line 1193: IF (PO_LOG.d_stmt) THEN

1189: x_price => l_price,
1190: x_from_line_location_id => l_from_line_location_id);
1191:
1192: d_pos := 100;
1193: IF (PO_LOG.d_stmt) THEN
1194: 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);
1195: END IF;
1196:
1197: -- Check whether the above call to the Pricing API returned a

Line 1194: 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);

1190: x_from_line_location_id => l_from_line_location_id);
1191:
1192: d_pos := 100;
1193: IF (PO_LOG.d_stmt) THEN
1194: 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);
1195: END IF;
1196:
1197: -- Check whether the above call to the Pricing API returned a
1198: -- price break that is different than what is currently

Line 1210: IF (PO_LOG.d_stmt) THEN

1206: --Reinitialise the price values to original values if pricing
1207: --call returns null
1208: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1209: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1210: IF (PO_LOG.d_stmt) THEN
1211: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1212: 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));
1213: END IF;
1214:

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

1207: --call returns null
1208: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1209: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1210: IF (PO_LOG.d_stmt) THEN
1211: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1212: 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));
1213: END IF;
1214:
1215: d_pos := 120;

Line 1212: 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));

1208: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1209: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1210: IF (PO_LOG.d_stmt) THEN
1211: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1212: 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));
1213: END IF;
1214:
1215: d_pos := 120;
1216: -- Update the line price and from_line_location_id in PO_LINES_ALL

Line 1242: IF (PO_LOG.d_stmt) THEN

1238: l_ga_entity_type := 'BLANKET LINE';
1239: l_ga_entity_id := l_po_lines_rec.from_line_id;
1240: END IF;
1241: d_pos := 130;
1242: IF (PO_LOG.d_stmt) THEN
1243: 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);
1244: END IF;
1245: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
1246: p_entity_type => 'PO LINE',

Line 1243: 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);

1239: l_ga_entity_id := l_po_lines_rec.from_line_id;
1240: END IF;
1241: d_pos := 130;
1242: IF (PO_LOG.d_stmt) THEN
1243: 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);
1244: END IF;
1245: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
1246: p_entity_type => 'PO LINE',
1247: p_entity_id => l_po_lines_rec.po_line_id);

Line 1267: IF (PO_LOG.d_proc) THEN

1263: last_updated_by = fnd_global.user_id
1264: WHERE po_line_id = l_po_lines_rec.po_line_id;
1265: END IF; --l_type_lookup_code = 'STANDARD'
1266:
1267: IF (PO_LOG.d_proc) THEN
1268: PO_LOG.proc_end(d_module);
1269: END IF;
1270:
1271: EXCEPTION

Line 1268: PO_LOG.proc_end(d_module);

1264: WHERE po_line_id = l_po_lines_rec.po_line_id;
1265: END IF; --l_type_lookup_code = 'STANDARD'
1266:
1267: IF (PO_LOG.d_proc) THEN
1268: PO_LOG.proc_end(d_module);
1269: END IF;
1270:
1271: EXCEPTION
1272: WHEN OTHERS THEN

Line 1274: IF PO_LOG.d_exc THEN

1270:
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1274: IF PO_LOG.d_exc THEN
1275: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1276: END IF;
1277: RAISE;
1278: END process_delete_line_loc;

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

1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
1274: IF PO_LOG.d_exc THEN
1275: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1276: END IF;
1277: RAISE;
1278: END process_delete_line_loc;
1279: