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

Line 1157: PO_LOG.proc_begin(l_log_head);

1153:
1154: -- Initialize OUT parameters
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF g_debug_stmt THEN
1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);

Line 1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);

1154: -- Initialize OUT parameters
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF g_debug_stmt THEN
1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);

Line 1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);

1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF g_debug_stmt THEN
1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);

Line 1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);

1156: IF g_debug_stmt THEN
1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);

Line 1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);

1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);

Line 1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);

1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);

Line 1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);

1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);

Line 1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);

1160: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_id', p_header_rec.supplier_id);
1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);

Line 1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);

1161: PO_LOG.proc_begin(l_log_head, 'p_header_rec.supplier_site_id', p_header_rec.supplier_site_id);
1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);

Line 1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);

1162: PO_LOG.proc_begin(l_log_head, 'p_header_rec.creation_date', p_header_rec.creation_date);
1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);

Line 1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);

1163: PO_LOG.proc_begin(l_log_head, 'p_header_rec.order_type', p_header_rec.order_type);
1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);

Line 1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);

1164: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_location_id', p_header_rec.ship_to_location_id);
1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);

Line 1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);

1165: PO_LOG.proc_begin(l_log_head, 'p_header_rec.ship_to_org_id', p_header_rec.ship_to_org_id);
1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);

Line 1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);

1166: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);

Line 1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);

1167: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_class', p_header_rec.hazard_class);
1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);

Line 1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);

1168: PO_LOG.proc_begin(l_log_head, 'p_header_rec.hazard_code', p_header_rec.hazard_code);
1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);

Line 1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);

1169: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipped_date', p_header_rec.shipped_date);
1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);
1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);

Line 1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);

1170: PO_LOG.proc_begin(l_log_head, 'p_header_rec.shipment_num', p_header_rec.shipment_num);
1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);
1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);
1178:

Line 1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);

1171: PO_LOG.proc_begin(l_log_head, 'p_header_rec.carrier_method', p_header_rec.carrier_method);
1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);
1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);
1178:
1179:

Line 1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);

1172: PO_LOG.proc_begin(l_log_head, 'p_header_rec.packaging_code', p_header_rec.packaging_code);
1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);
1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);
1178:
1179:
1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP

Line 1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);

1173: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_carrier_code', p_header_rec.freight_carrier_code);
1174: PO_LOG.proc_begin(l_log_head, 'p_header_rec.freight_terms', p_header_rec.freight_terms);
1175: PO_LOG.proc_begin(l_log_head, 'p_header_rec.currency_code', p_header_rec.currency_code);
1176: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate', p_header_rec.rate);
1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);
1178:
1179:
1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP
1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);

Line 1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);

1177: PO_LOG.proc_begin(l_log_head, 'p_header_rec.rate_type', p_header_rec.rate_type);
1178:
1179:
1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP
1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);
1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);

Line 1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing

1178:
1179:
1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP
1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);
1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);

Line 1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);

1179:
1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP
1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);
1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);

Line 1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);

1180: FOR i IN 1..p_line_rec_tbl.COUNT LOOP
1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);
1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);

Line 1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);

1181: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_line_id', p_line_rec_tbl(i).order_line_id);
1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);

Line 1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);

1182: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').order_type', p_line_rec_tbl(i).order_type); --Enhanced Pricing
1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);

Line 1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);

1183: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_type', p_line_rec_tbl(i).agreement_type);
1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);

Line 1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);

1184: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_id', p_line_rec_tbl(i).agreement_id);
1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);

Line 1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);

1185: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').agreement_line_id', p_line_rec_tbl(i).agreement_line_id);
1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);

Line 1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);

1186: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_id', p_line_rec_tbl(i).supplier_id);
1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);

Line 1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);

1187: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_site_id', p_line_rec_tbl(i).supplier_site_id);
1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);

Line 1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);

1188: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_location_id', p_line_rec_tbl(i). ship_to_location_id);
1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);

Line 1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);

1189: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').ship_to_org_id', p_line_rec_tbl(i).ship_to_org_id);
1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);

Line 1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);

1190: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').supplier_item_num', p_line_rec_tbl(i).supplier_item_num);
1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);

Line 1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);

1191: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_revision', p_line_rec_tbl(i).item_revision);
1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);

Line 1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);

1192: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').item_id', p_line_rec_tbl(i).item_id);
1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);

Line 1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);

1193: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').category_id', p_line_rec_tbl(i).category_id);
1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);

Line 1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);

1194: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate', p_line_rec_tbl(i).rate);
1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);

Line 1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);

1195: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').rate_type', p_line_rec_tbl(i).rate_type);
1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);

Line 1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);

1196: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').currency_code', p_line_rec_tbl(i).currency_code);
1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);

Line 1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);

1197: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').need_by_date', p_line_rec_tbl(i).need_by_date);
1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;

Line 1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);

1198: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').shipment_line_id', p_line_rec_tbl(i).shipment_line_id);
1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;
1206:

Line 1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);

1199: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').primary_unit_of_measure', p_line_rec_tbl(i).primary_unit_of_measure);
1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;
1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);

Line 1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);

1200: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').to_organization_id', p_line_rec_tbl(i).to_organization_id);
1201: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_of_measure', p_line_rec_tbl(i).unit_of_measure);
1202: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').source_document_code', p_line_rec_tbl(i).source_document_code);
1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;
1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);

Line 1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);

1203: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').unit_price', p_line_rec_tbl(i).unit_price);
1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;
1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);
1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);
1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);
1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);

Line 1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);

1204: PO_LOG.proc_begin(l_log_head, 'p_line_rec_tbl(' || i || ').quantity', p_line_rec_tbl(i).quantity);
1205: END LOOP;
1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);
1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);
1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);
1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);
1212: END IF;

Line 1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);

1205: END LOOP;
1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);
1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);
1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);
1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);
1212: END IF;
1213:

Line 1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);

1206:
1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);
1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);
1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);
1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);
1212: END IF;
1213:
1214: x_price_tbl := Qp_Price_Result_Rec_Tbl_Type();

Line 1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);

1207: PO_LOG.proc_begin(l_log_head, 'p_request_type', p_request_type);
1208: PO_LOG.proc_begin(l_log_head, 'p_pricing_event', p_pricing_event);
1209: PO_LOG.proc_begin(l_log_head, 'p_has_header_pricing', p_has_header_pricing);
1210: PO_LOG.proc_begin(l_log_head, 'p_return_price_flag', p_return_price_flag);
1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);
1212: END IF;
1213:
1214: x_price_tbl := Qp_Price_Result_Rec_Tbl_Type();
1215: PO_LOG.stmt(l_log_head, d_pos,'Check Advanced Pricing License');

Line 1215: PO_LOG.stmt(l_log_head, d_pos,'Check Advanced Pricing License');

1211: PO_LOG.proc_begin(l_log_head, 'p_return_freight_flag', p_return_freight_flag);
1212: END IF;
1213:
1214: x_price_tbl := Qp_Price_Result_Rec_Tbl_Type();
1215: PO_LOG.stmt(l_log_head, d_pos,'Check Advanced Pricing License');
1216: FND_PROFILE.get('QP_LICENSED_FOR_PRODUCT', l_qp_license);
1217: d_pos := 20;
1218: IF g_debug_stmt THEN
1219: PO_LOG.stmt(l_log_head, d_pos, 'l_qp_license', l_qp_license);

Line 1219: PO_LOG.stmt(l_log_head, d_pos, 'l_qp_license', l_qp_license);

1215: PO_LOG.stmt(l_log_head, d_pos,'Check Advanced Pricing License');
1216: FND_PROFILE.get('QP_LICENSED_FOR_PRODUCT', l_qp_license);
1217: d_pos := 20;
1218: IF g_debug_stmt THEN
1219: PO_LOG.stmt(l_log_head, d_pos, 'l_qp_license', l_qp_license);
1220: END IF;
1221:
1222: IF (l_qp_license IS NULL OR l_qp_license <> 'PO') THEN
1223: RETURN;

Line 1228: PO_LOG.stmt(l_log_head, d_pos,'Set Price Request ID');

1224: END IF;
1225:
1226: d_pos := 40;
1227: IF g_debug_stmt THEN
1228: PO_LOG.stmt(l_log_head, d_pos,'Set Price Request ID');
1229: END IF;
1230:
1231: QP_PRICE_REQUEST_CONTEXT.set_request_id;
1232:

Line 1235: PO_LOG.stmt(l_log_head, d_pos,'Populate Global Header Structure');

1231: QP_PRICE_REQUEST_CONTEXT.set_request_id;
1232:
1233: d_pos := 60;
1234: IF g_debug_stmt THEN
1235: PO_LOG.stmt(l_log_head, d_pos,'Populate Global Header Structure');
1236: END IF;
1237:
1238: populate_header_record(
1239: p_org_id => p_header_rec.org_id,

Line 1265: PO_LOG.stmt(l_log_head, d_pos ,'Populate Global Line Structure');

1261: p_expected_receipt_date => p_header_rec.expected_receipt_date);
1262:
1263: d_pos := 80;
1264: IF g_debug_stmt THEN
1265: PO_LOG.stmt(l_log_head, d_pos ,'Populate Global Line Structure');
1266: END IF;
1267:
1268: i := 1;
1269:

Line 1272: PO_LOG.stmt(l_log_head, d_pos,'Set OE Debug');

1268: i := 1;
1269:
1270: d_pos := 90;
1271: IF g_debug_stmt THEN
1272: PO_LOG.stmt(l_log_head, d_pos,'Set OE Debug');
1273: OE_DEBUG_PUB.SetDebugLevel(10);
1274: PO_LOG.stmt(l_log_head, d_pos, 'Debug File Location: '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
1275: OE_DEBUG_PUB.Initialize;
1276: OE_DEBUG_PUB.Debug_On;

Line 1274: PO_LOG.stmt(l_log_head, d_pos, 'Debug File Location: '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));

1270: d_pos := 90;
1271: IF g_debug_stmt THEN
1272: PO_LOG.stmt(l_log_head, d_pos,'Set OE Debug');
1273: OE_DEBUG_PUB.SetDebugLevel(10);
1274: PO_LOG.stmt(l_log_head, d_pos, 'Debug File Location: '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
1275: OE_DEBUG_PUB.Initialize;
1276: OE_DEBUG_PUB.Debug_On;
1277: END IF;
1278:

Line 1284: PO_LOG.stmt(l_log_head, d_pos,'Build Attributes Mapping Contexts for header');

1280:
1281: IF(p_has_header_pricing) THEN
1282: d_pos := 110;
1283: IF g_debug_stmt THEN
1284: PO_LOG.stmt(l_log_head, d_pos,'Build Attributes Mapping Contexts for header');
1285: END IF;
1286: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => p_request_type,
1287: p_line_index => i,
1288: p_pricing_type_code => 'H',

Line 1378: PO_LOG.stmt(l_log_head, d_pos,'Build Attributes Mapping Contexts for Line('|| j || ')');

1374: END IF;
1375:
1376: d_pos := 150;
1377: IF g_debug_stmt THEN
1378: PO_LOG.stmt(l_log_head, d_pos,'Build Attributes Mapping Contexts for Line('|| j || ')');
1379: END IF;
1380:
1381: QP_Attr_Mapping_PUB.Build_Contexts(
1382: p_request_type_code => p_request_type,

Line 1391: PO_LOG.stmt(l_log_head, d_pos,'Get UOM Code');

1387: x_pass_line => l_pass_line);
1388:
1389: d_pos := 160;
1390: IF g_debug_stmt THEN
1391: PO_LOG.stmt(l_log_head, d_pos,'Get UOM Code');
1392: END IF;
1393:
1394: BEGIN
1395: -- Make sure we pass uom_code instead of unit_of_measure.

Line 1407: PO_LOG.stmt(l_log_head, d_pos, 'l_uom_code', l_uom_code);

1403: END;
1404:
1405: d_pos := 170;
1406: IF g_debug_stmt THEN
1407: PO_LOG.stmt(l_log_head, d_pos, 'l_uom_code', l_uom_code);
1408: PO_LOG.stmt(l_log_head, d_pos,'Directly Insert into Temp table');
1409: END IF;
1410:
1411: l_request_type_code_tbl(i) := p_request_type;

Line 1408: PO_LOG.stmt(l_log_head, d_pos,'Directly Insert into Temp table');

1404:
1405: d_pos := 170;
1406: IF g_debug_stmt THEN
1407: PO_LOG.stmt(l_log_head, d_pos, 'l_uom_code', l_uom_code);
1408: PO_LOG.stmt(l_log_head, d_pos,'Directly Insert into Temp table');
1409: END IF;
1410:
1411: l_request_type_code_tbl(i) := p_request_type;
1412: l_line_id_tbl(i) := nvl(p_line_rec_tbl(j).order_line_id, p_line_rec_tbl(j).shipment_line_id); -- order line id

Line 1463: PO_LOG.stmt(l_log_head, d_pos,'Call INSERT_LINES2');

1459: END LOOP;
1460:
1461: d_pos := 180;
1462: IF g_debug_stmt THEN
1463: PO_LOG.stmt(l_log_head, d_pos,'Call INSERT_LINES2');
1464: END IF;
1465:
1466: QP_PREQ_GRP.INSERT_LINES2
1467: (p_line_index => l_line_index_tbl,

Line 1507: PO_LOG.stmt(l_log_head, d_pos,'After Calling INSERT_LINES2');

1503: x_status_text => l_return_status_text);
1504:
1505: d_pos := 190;
1506: IF g_debug_stmt THEN
1507: PO_LOG.stmt(l_log_head, d_pos,'After Calling INSERT_LINES2');
1508: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1509: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1510: END IF;
1511:

Line 1508: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);

1504:
1505: d_pos := 190;
1506: IF g_debug_stmt THEN
1507: PO_LOG.stmt(l_log_head, d_pos,'After Calling INSERT_LINES2');
1508: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1509: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1510: END IF;
1511:
1512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1509: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);

1505: d_pos := 190;
1506: IF g_debug_stmt THEN
1507: PO_LOG.stmt(l_log_head, d_pos,'After Calling INSERT_LINES2');
1508: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1509: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1510: END IF;
1511:
1512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');

Line 1529: PO_LOG.stmt(l_log_head, d_pos,'Populate Control Record for Pricing Request Call');

1525: -- ASK_FOR attributes
1526:
1527: d_pos := 200;
1528: IF g_debug_stmt THEN
1529: PO_LOG.stmt(l_log_head, d_pos,'Populate Control Record for Pricing Request Call');
1530: END IF;
1531:
1532: l_control_rec.calculate_flag := 'Y';
1533: l_control_rec.simulation_flag := 'N';

Line 1549: PO_LOG.stmt(l_log_head, d_pos,'Call PRICE_REQUEST');

1545: l_control_rec.get_freight_flag := 'N';
1546:
1547: d_pos := 200;
1548: IF g_debug_stmt THEN
1549: PO_LOG.stmt(l_log_head, d_pos,'Call PRICE_REQUEST');
1550: END IF;
1551:
1552: QP_PREQ_PUB.PRICE_REQUEST(
1553: p_control_rec => l_control_rec,

Line 1559: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);

1555: x_return_status_Text => l_return_status_Text);
1556:
1557: d_pos := 220;
1558: IF g_debug_stmt THEN
1559: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1560: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1561: END IF;
1562:
1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1560: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);

1556:
1557: d_pos := 220;
1558: IF g_debug_stmt THEN
1559: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1560: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1561: END IF;
1562:
1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');

Line 1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');

1597: */
1598:
1599: d_pos := 240;
1600: IF g_debug_stmt THEN
1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');
1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);
1605: END IF;

Line 1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);

1598:
1599: d_pos := 240;
1600: IF g_debug_stmt THEN
1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');
1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);
1605: END IF;
1606:

Line 1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);

1599: d_pos := 240;
1600: IF g_debug_stmt THEN
1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');
1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);
1605: END IF;
1606:
1607: IF p_return_price_flag THEN

Line 1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);

1600: IF g_debug_stmt THEN
1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');
1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);
1605: END IF;
1606:
1607: IF p_return_price_flag THEN
1608: --Access the QP views to retrieve the values for price

Line 1672: PO_LOG.proc_end(l_log_head);

1668:
1669:
1670: d_pos := 300;
1671: IF g_debug_stmt THEN
1672: PO_LOG.proc_end(l_log_head);
1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);
1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);

Line 1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);

1669:
1670: d_pos := 300;
1671: IF g_debug_stmt THEN
1672: PO_LOG.proc_end(l_log_head);
1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);
1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);

Line 1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);

1671: IF g_debug_stmt THEN
1672: PO_LOG.proc_end(l_log_head);
1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);
1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);
1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP

Line 1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);

1672: PO_LOG.proc_end(l_log_head);
1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);
1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);
1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP
1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'

Line 1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);

1673: PO_LOG.proc_end(l_log_head, 'x_return_status', x_return_status);
1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);
1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP
1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'
1681: , x_price_tbl(j).freight_charge_rec_tbl(k).charge_type_code);

Line 1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);

1674: FOR j IN 1..x_price_tbl.COUNT LOOP
1675: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_index', x_price_tbl(j).line_index);
1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);
1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP
1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'
1681: , x_price_tbl(j).freight_charge_rec_tbl(k).charge_type_code);
1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'

Line 1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'

1676: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').line_id', x_price_tbl(j).line_id);
1677: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').base_unit_price', x_price_tbl(j).base_unit_price);
1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP
1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'
1681: , x_price_tbl(j).freight_charge_rec_tbl(k).charge_type_code);
1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'
1683: , x_price_tbl(j).freight_charge_rec_tbl(k).freight_charge);
1684: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_code'

Line 1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'

1678: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').adjusted_price', x_price_tbl(j).adjusted_price);
1679: FOR k IN 1..x_price_tbl(j).freight_charge_rec_tbl.COUNT LOOP
1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'
1681: , x_price_tbl(j).freight_charge_rec_tbl(k).charge_type_code);
1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'
1683: , x_price_tbl(j).freight_charge_rec_tbl(k).freight_charge);
1684: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_code'
1685: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_code);
1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'

Line 1684: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_code'

1680: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').charge_type_code'
1681: , x_price_tbl(j).freight_charge_rec_tbl(k).charge_type_code);
1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'
1683: , x_price_tbl(j).freight_charge_rec_tbl(k).freight_charge);
1684: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_code'
1685: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_code);
1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'
1687: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_text);
1688: END LOOP;

Line 1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'

1682: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').freight_charge'
1683: , x_price_tbl(j).freight_charge_rec_tbl(k).freight_charge);
1684: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_code'
1685: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_code);
1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'
1687: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_text);
1688: END LOOP;
1689: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_code', x_price_tbl(j).pricing_status_code);
1690: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_text', x_price_tbl(j).pricing_status_text);

Line 1689: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_code', x_price_tbl(j).pricing_status_code);

1685: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_code);
1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'
1687: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_text);
1688: END LOOP;
1689: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_code', x_price_tbl(j).pricing_status_code);
1690: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_text', x_price_tbl(j).pricing_status_text);
1691: END LOOP;
1692: END IF;
1693: EXCEPTION

Line 1690: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_text', x_price_tbl(j).pricing_status_text);

1686: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').freight_charge_rec_tbl(' || k || ').pricing_status_text'
1687: , x_price_tbl(j).freight_charge_rec_tbl(k).pricing_status_text);
1688: END LOOP;
1689: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_code', x_price_tbl(j).pricing_status_code);
1690: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_text', x_price_tbl(j).pricing_status_text);
1691: END LOOP;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN

Line 1701: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);

1697: p_msg_index => FND_MSG_PUB.G_LAST
1698: , p_encoded => 'F'
1699: );
1700: IF g_debug_unexp THEN
1701: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1702: END IF;
1703: x_return_status := FND_API.g_ret_sts_error;
1704: -- Push the po_return_msg onto msg list and message stack
1705: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');

Line 1715: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);

1711: p_msg_index => FND_MSG_PUB.G_LAST
1712: , p_encoded => 'F'
1713: );
1714: IF g_debug_unexp THEN
1715: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1716: END IF;
1717: x_return_status := FND_API.g_ret_sts_unexp_error;
1718: -- Push the po_return_msg onto msg list and message stack
1719: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');

Line 1724: PO_LOG.exc(l_log_head, d_pos);

1720: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
1721:
1722: WHEN OTHERS THEN
1723: IF g_debug_unexp THEN
1724: PO_LOG.exc(l_log_head, d_pos);
1725: END IF;
1726: --unexpected error from this procedure: get SQLERRM
1727: po_message_s.sql_error(g_pkg_name, l_api_name, d_pos, SQLCODE, SQLERRM);
1728: l_exception_msg := FND_MESSAGE.get;

Line 1730: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);

1726: --unexpected error from this procedure: get SQLERRM
1727: po_message_s.sql_error(g_pkg_name, l_api_name, d_pos, SQLCODE, SQLERRM);
1728: l_exception_msg := FND_MESSAGE.get;
1729: IF g_debug_unexp THEN
1730: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1731: END IF;
1732: x_return_status := FND_API.g_ret_sts_unexp_error;
1733: -- Push the po_return_msg onto msg list and message stack
1734: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');