DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_ORDER_UTIL

Line 1166: OE_ORDER_UTIL.Update_Global_Picture

1162:
1163: WHILE l_loop_index IS NOT NULL LOOP
1164:
1165: -- call notification framework to get this line's index position
1166: OE_ORDER_UTIL.Update_Global_Picture
1167: (p_Upd_New_Rec_If_Exists =>FALSE
1168: , p_header_id => l_line_tbl(l_loop_index).header_id
1169: , p_line_rec => l_line_tbl(l_loop_index)
1170: , p_old_line_rec => l_old_line_tbl(l_loop_index)

Line 1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);

1185:
1186: IF l_notify_index is not null then
1187: -- modify Global Picture
1188: -- uncommented for bug 2934535
1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;

Line 1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

1188: -- uncommented for bug 2934535
1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;

Line 1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;

1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;

Line 1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;

1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;

Line 1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;

1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;

Line 1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;

1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;

Line 1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;

1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV

Line 1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;

1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;

Line 1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;

1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;

Line 1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;

1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;

Line 1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV

1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;

Line 1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;

1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489

Line 1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;

1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;

Line 1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;

1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:

Line 1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;

1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN

Line 1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;

1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;

Line 1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;

1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;

Line 1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;

1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV

Line 1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;

1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;

Line 1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;

1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;

Line 1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;

1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;

Line 1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV

1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;

Line 1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;

1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;

Line 1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;

1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;

Line 1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;

1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;

Line 1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;

1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;

Line 1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;

1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;

Line 1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;

1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:

Line 1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;

1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:
1226: END IF ; /* global entity index null check */

Line 1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;

1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:
1226: END IF ; /* global entity index null check */
1227:

Line 5029: OE_ORDER_UTIL.Update_Global_Picture

5025: oe_debug_pub.add
5026: ('update GLOBAL FLOW_STATUS is: '||l_line_rec.flow_status_code,3);
5027: END IF;
5028:
5029: OE_ORDER_UTIL.Update_Global_Picture
5030: (p_Upd_New_Rec_If_Exists => False,
5031: --p_header_id => l_line_rec.header_id,
5032: p_old_line_rec => l_old_line_rec,
5033: p_line_rec => l_line_rec,

Line 5052: OE_ORDER_UTIL.g_line_tbl(J)

5048: END IF;
5049:
5050: IF J IS NOT NULL THEN
5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;

Line 5053: := OE_ORDER_UTIL.g_old_line_tbl(J);

5049:
5050: IF J IS NOT NULL THEN
5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;

Line 5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;

5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;

Line 5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;

5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:

Line 5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;

5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:

Line 5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity

Line 5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;

5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;

Line 5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity

5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2

Line 5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2

5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity

Line 5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2

5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom

Line 5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity

5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2

Line 5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom

5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date

Line 5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2

5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code

Line 5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date

5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5077: := l_line_rec.flow_status_code;
5078:

Line 5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code

5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5077: := l_line_rec.flow_status_code;
5078:
5079: IF l_debug_level > 0 THEN
5080: oe_debug_pub.add

Line 5082: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);

5078:
5079: IF l_debug_level > 0 THEN
5080: oe_debug_pub.add
5081: ('AFTER UPDATE GLOBAL FLOW_STATUS_CODE IS: '
5082: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);
5083: END IF;
5084:
5085: END IF; -- if index is not null
5086: