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_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_LOG

Line 1133: IF (PO_LOG.d_proc) THEN

1129: payitem_rcv_ctl_rec rcv_controls_type;
1130:
1131: BEGIN
1132:
1133: IF (PO_LOG.d_proc) THEN
1134: PO_LOG.proc_begin(d_module);
1135: END IF;
1136:
1137: d_progress := 0;

Line 1134: PO_LOG.proc_begin(d_module);

1130:
1131: BEGIN
1132:
1133: IF (PO_LOG.d_proc) THEN
1134: PO_LOG.proc_begin(d_module);
1135: END IF;
1136:
1137: d_progress := 0;
1138:

Line 1156: IF (PO_LOG.d_stmt) THEN

1152: l_req_tax_code_id := NULL;
1153: l_req_tax_user_override_flag := NULL;
1154: l_req_tax_status_indicator := NULL;
1155:
1156: IF (PO_LOG.d_stmt) THEN
1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));
1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));
1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));
1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));

Line 1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));

1153: l_req_tax_user_override_flag := NULL;
1154: l_req_tax_status_indicator := NULL;
1155:
1156: IF (PO_LOG.d_stmt) THEN
1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));
1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));
1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));
1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));
1161: END IF;

Line 1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));

1154: l_req_tax_status_indicator := NULL;
1155:
1156: IF (PO_LOG.d_stmt) THEN
1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));
1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));
1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));
1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));
1161: END IF;
1162:

Line 1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));

1155:
1156: IF (PO_LOG.d_stmt) THEN
1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));
1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));
1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));
1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));
1161: END IF;
1162:
1163: IF p_lines.clm_info_flag_tbl(i)='N' AND p_lines.shipment_num_tbl(i) IS NOT NULL THEN

Line 1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));

1156: IF (PO_LOG.d_stmt) THEN
1157: PO_LOG.stmt(d_module, d_progress, 'Interface_line_id', p_lines.intf_line_id_tbl(i));
1158: PO_LOG.stmt(d_module, d_progress, 'Po_line_id', p_lines.po_line_id_tbl(i));
1159: PO_LOG.stmt(d_module, d_progress, 'Clm Info Flag', p_lines.clm_info_flag_tbl(i));
1160: po_Log.stmt(d_module, d_progress, 'Shipment Num', p_lines.shipment_num_tbl(i));
1161: END IF;
1162:
1163: IF p_lines.clm_info_flag_tbl(i)='N' AND p_lines.shipment_num_tbl(i) IS NOT NULL THEN
1164: d_progress := 20;

Line 1188: IF (PO_LOG.d_stmt) THEN

1184: d_progress := 30;
1185: l_isFinancing := PO_COMPLEX_WORK_PVT.is_financing_po( p_po_header_id => l_po_header_id,
1186: p_draft_id => po_autocreate_params.g_draft_id );
1187:
1188: IF (PO_LOG.d_stmt) THEN
1189: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);
1190: END IF;
1191:
1192: d_progress := 40;

Line 1189: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);

1185: l_isFinancing := PO_COMPLEX_WORK_PVT.is_financing_po( p_po_header_id => l_po_header_id,
1186: p_draft_id => po_autocreate_params.g_draft_id );
1187:
1188: IF (PO_LOG.d_stmt) THEN
1189: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);
1190: END IF;
1191:
1192: d_progress := 40;
1193:

Line 1299: IF(PO_LOG.d_stmt) THEN

1295: );
1296: END IF; -- if l_isFinancing
1297:
1298: d_progress := 80;
1299: IF(PO_LOG.d_stmt) THEN
1300: PO_LOG.stmt(d_module, d_progress, 'has_advance_flag', p_lines.has_advance_flag_tbl(i));
1301: END IF;
1302:
1303: IF(p_lines.has_advance_flag_tbl(i) = 'Y') THEN

Line 1300: PO_LOG.stmt(d_module, d_progress, 'has_advance_flag', p_lines.has_advance_flag_tbl(i));

1296: END IF; -- if l_isFinancing
1297:
1298: d_progress := 80;
1299: IF(PO_LOG.d_stmt) THEN
1300: PO_LOG.stmt(d_module, d_progress, 'has_advance_flag', p_lines.has_advance_flag_tbl(i));
1301: END IF;
1302:
1303: IF(p_lines.has_advance_flag_tbl(i) = 'Y') THEN
1304:

Line 1426: IF (PO_LOG.d_stmt) THEN

1422: WHEN poll_interface_cursor%NOTFOUND;
1423:
1424: d_progress := 160;
1425:
1426: IF (PO_LOG.d_stmt) THEN
1427: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');
1428: END IF;
1429:
1430: RCV_CORE_S.get_receiving_controls( p_order_type_lookup_code => line_location_rec.value_basis ,

Line 1427: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');

1423:
1424: d_progress := 160;
1425:
1426: IF (PO_LOG.d_stmt) THEN
1427: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');
1428: END IF;
1429:
1430: RCV_CORE_S.get_receiving_controls( p_order_type_lookup_code => line_location_rec.value_basis ,
1431: p_purchase_basis => l_line_purchase_basis ,

Line 1449: IF (PO_LOG.d_stmt) THEN

1445: x_days_late_receipt_allowed => payitem_rcv_ctl_rec.days_late_receipt_allowed ,
1446: x_receipt_days_exception_code => payitem_rcv_ctl_rec.receipt_days_exception_code );
1447:
1448: d_progress := 200;
1449: IF (PO_LOG.d_stmt) THEN
1450: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');
1451: END IF;
1452:
1453: po_coo_s.get_default_country_of_origin( x_item_id => p_lines.item_id_tbl(i) ,

Line 1450: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');

1446: x_receipt_days_exception_code => payitem_rcv_ctl_rec.receipt_days_exception_code );
1447:
1448: d_progress := 200;
1449: IF (PO_LOG.d_stmt) THEN
1450: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');
1451: END IF;
1452:
1453: po_coo_s.get_default_country_of_origin( x_item_id => p_lines.item_id_tbl(i) ,
1454: x_ship_to_org_id => line_location_rec.ship_to_organization_id ,

Line 1461: IF (PO_LOG.d_stmt) THEN

1457: x_country_of_origin => l_country_of_origin_code );
1458:
1459: d_progress := 210;
1460:
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
1463: END IF;
1464:
1465: -- insert payitem into po_line_locations_all

Line 1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');

1458:
1459: d_progress := 210;
1460:
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
1463: END IF;
1464:
1465: -- insert payitem into po_line_locations_all
1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface

Line 1699: IF(PO_LOG.d_stmt) THEN

1695: RETURNING line_location_id
1696: INTO l_line_loc_id;
1697:
1698: d_progress := 220;
1699: IF(PO_LOG.d_stmt) THEN
1700: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
1701: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1702: END IF;
1703:

Line 1700: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');

1696: INTO l_line_loc_id;
1697:
1698: d_progress := 220;
1699: IF(PO_LOG.d_stmt) THEN
1700: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
1701: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1702: END IF;
1703:
1704: d_progress := 230;

Line 1701: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);

1697:
1698: d_progress := 220;
1699: IF(PO_LOG.d_stmt) THEN
1700: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
1701: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1702: END IF;
1703:
1704: d_progress := 230;
1705:

Line 1745: IF (PO_LOG.d_proc) THEN

1741:
1742: END IF;
1743: END LOOP;
1744:
1745: IF (PO_LOG.d_proc) THEN
1746: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1747: PO_LOG.proc_end(d_module);
1748: END IF;
1749: EXCEPTION

Line 1746: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);

1742: END IF;
1743: END LOOP;
1744:
1745: IF (PO_LOG.d_proc) THEN
1746: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1747: PO_LOG.proc_end(d_module);
1748: END IF;
1749: EXCEPTION
1750: WHEN OTHERS THEN

Line 1747: PO_LOG.proc_end(d_module);

1743: END LOOP;
1744:
1745: IF (PO_LOG.d_proc) THEN
1746: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1747: PO_LOG.proc_end(d_module);
1748: END IF;
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: IF (PO_LOG.d_exc) THEN

Line 1751: IF (PO_LOG.d_exc) THEN

1747: PO_LOG.proc_end(d_module);
1748: END IF;
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: IF (PO_LOG.d_exc) THEN
1752: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1753: END IF;
1754: IF (poll_interface_cursor%ISOPEN) THEN
1755: CLOSE poll_interface_cursor;

Line 1752: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1748: END IF;
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: IF (PO_LOG.d_exc) THEN
1752: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1753: END IF;
1754: IF (poll_interface_cursor%ISOPEN) THEN
1755: CLOSE poll_interface_cursor;
1756: END IF;