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.WSH_SC_TRX_INTERFACE dependencies on WSH_DEL_OI_CORE

Line 389: wsh_del_oi_core.println('updating pld with pld_id:'||to_char(X_picking_line_detail_id)||

385: -- this is called with either picking line detail id and no inventory controls
386: -- or the opposite. Either way, it can update a record.
387: -- Only one record should fit this criteria but to be sure, use rownum.
388: --------------------------------------------------------------------------
389: wsh_del_oi_core.println('updating pld with pld_id:'||to_char(X_picking_line_detail_id)||
390: ' pl_id:'||to_char(X_picking_line_id)||
391: ' req_qty:'||to_char(X_requested_quantity)||
392: ' shp_qty:'||to_char(X_shipped_quantity)||
393: ' warehouse:'||to_char(X_warehouse)||

Line 461: wsh_del_oi_core.println('BUT could not update so_picking_line_details.');

457: APP_EXCEPTION.Raise_Exception;
458: END;
459:
460: if sql%notfound then
461: wsh_del_oi_core.println('BUT could not update so_picking_line_details.');
462: error_code := '1';
463: end if;
464:
465: END;

Line 521: wsh_del_oi_core.println('creating pld with pld_id:'||to_char(new_pld_id)||

517: BEGIN
518:
519: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL into new_pld_id from DUAL;
520:
521: wsh_del_oi_core.println('creating pld with pld_id:'||to_char(new_pld_id)||
522: 'pick_slip_number:'||to_char(X_pick_slip_number)||
523: ' parent_id:'||to_char(X_parent_detail_id)||
524: ' req_qty:'||to_char(X_requested_quantity)||
525: ' shp_qty:'||to_char(X_shipped_quantity)||

Line 678: wsh_del_oi_core.println('Update requested_quantity will NULL out the dep & del in sopld.');

674: BEGIN
675: error_code:='0';
676: IF ( X_backorder_flag = TRUE ) THEN
677: X_bo := 'TRUE';
678: wsh_del_oi_core.println('Update requested_quantity will NULL out the dep & del in sopld.');
679: END IF;
680: BEGIN
681: UPDATE SO_PICKING_LINE_DETAILS pld
682: SET requested_quantity = requested_quantity - X_shipped_quantity,

Line 689: wsh_del_oi_core.println('Reduced req_qty in pl:'|| to_char(X_picking_line_detail_id)||

685: departure_id = decode(X_bo, 'FALSE' ,NULL, departure_id),
686: dpw_assigned_flag = decode(X_bo, 'FALSE' ,'N',dpw_assigned_flag)
687: WHERE pld.picking_line_detail_id = X_picking_line_detail_id;
688:
689: wsh_del_oi_core.println('Reduced req_qty in pl:'|| to_char(X_picking_line_detail_id)||
690: ' by:'||to_char(X_shipped_quantity));
691:
692: EXCEPTION when others then
693: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 700: wsh_del_oi_core.println('Unexpected error on picking detail '||to_char(x_picking_line_detail_id));

696: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
697: APP_EXCEPTION.Raise_Exception;
698: END;
699: if sql%notfound then
700: wsh_del_oi_core.println('Unexpected error on picking detail '||to_char(x_picking_line_detail_id));
701: error_code := '1';
702: end if;
703: END;
704: END;

Line 747: wsh_del_oi_core.println('Inside Split_SOPLD_Row: x_shipped_qty:'||to_char(X_shipped_quantity));

743:
744: BEGIN
745: error_code := '0';
746:
747: wsh_del_oi_core.println('Inside Split_SOPLD_Row: x_shipped_qty:'||to_char(X_shipped_quantity));
748:
749: --------------------------------------------------------------------------
750: -- decrement the requested qty on the original detail line by the ship qty
751: -- of the detail line we are trying to insert/update

Line 999: wsh_del_oi_core.println('profile option SO_RESERVATIONS:'||X_Reservations );

995: ------------------------------------------------------------------------------
996: -- Get reservations profile
997: ------------------------------------------------------------------------------
998: fnd_profile.get( 'SO_RESERVATIONS', X_Reservations);
999: wsh_del_oi_core.println('profile option SO_RESERVATIONS:'||X_Reservations );
1000:
1001:
1002: ------------------------------------------------------------------------------
1003: -- Define local variables

Line 1010: wsh_del_oi_core.println('START OF PROCESS_SOPLD_INTERFACE' );

1006: last_warehouse_id := -1 ;
1007: last_sub := 'a';
1008: processed_records := FALSE;
1009:
1010: wsh_del_oi_core.println('START OF PROCESS_SOPLD_INTERFACE' );
1011:
1012: ------------------------------------------------------------------------------
1013: -- Loop on interface records
1014: ------------------------------------------------------------------------------

Line 1020: wsh_del_oi_core.println('START OF LOOP oirec.sopld_subinventory: '||oirec.sopld_subinventory||

1016:
1017: X_rowid := oirec.row_id;
1018: processed_records := TRUE;
1019:
1020: wsh_del_oi_core.println('START OF LOOP oirec.sopld_subinventory: '||oirec.sopld_subinventory||
1021: ' pld_id: '|| to_char(oirec.picking_line_detail_id) );
1022:
1023: ------------------------------------------------------------------------------
1024: -- VALIDATE WAREHOUSE

Line 1027: wsh_del_oi_core.println(' ');

1023: ------------------------------------------------------------------------------
1024: -- VALIDATE WAREHOUSE
1025: -- Warehouse will never be null.
1026: ------------------------------------------------------------------------------
1027: wsh_del_oi_core.println(' ');
1028: wsh_del_oi_core.println('Validating warehouse IDs: warehouse: '|| to_char(oirec.warehouse_id) ||
1029: ' sopld_warehouse: '||to_char(oirec.sopld_warehouse_id) );
1030: wsh_del_oi_core.println(' ');
1031: error_line := 100;

Line 1028: wsh_del_oi_core.println('Validating warehouse IDs: warehouse: '|| to_char(oirec.warehouse_id) ||

1024: -- VALIDATE WAREHOUSE
1025: -- Warehouse will never be null.
1026: ------------------------------------------------------------------------------
1027: wsh_del_oi_core.println(' ');
1028: wsh_del_oi_core.println('Validating warehouse IDs: warehouse: '|| to_char(oirec.warehouse_id) ||
1029: ' sopld_warehouse: '||to_char(oirec.sopld_warehouse_id) );
1030: wsh_del_oi_core.println(' ');
1031: error_line := 100;
1032: error_code := '0';

Line 1030: wsh_del_oi_core.println(' ');

1026: ------------------------------------------------------------------------------
1027: wsh_del_oi_core.println(' ');
1028: wsh_del_oi_core.println('Validating warehouse IDs: warehouse: '|| to_char(oirec.warehouse_id) ||
1029: ' sopld_warehouse: '||to_char(oirec.sopld_warehouse_id) );
1030: wsh_del_oi_core.println(' ');
1031: error_line := 100;
1032: error_code := '0';
1033:
1034: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, oirec.warehouse_id, 'WAREHOUSE', error_code);

Line 1036: wsh_del_oi_core.println(' ');

1032: error_code := '0';
1033:
1034: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, oirec.warehouse_id, 'WAREHOUSE', error_code);
1035: if error_code <> '0' then
1036: wsh_del_oi_core.println(' ');
1037: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 100 ');
1038: wsh_del_oi_core.println(' ');
1039: FND_MESSAGE.SET_NAME('OE', error_code);
1040: raise stop_pld_processing;

Line 1037: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 100 ');

1033:
1034: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, oirec.warehouse_id, 'WAREHOUSE', error_code);
1035: if error_code <> '0' then
1036: wsh_del_oi_core.println(' ');
1037: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 100 ');
1038: wsh_del_oi_core.println(' ');
1039: FND_MESSAGE.SET_NAME('OE', error_code);
1040: raise stop_pld_processing;
1041: end if;

Line 1038: wsh_del_oi_core.println(' ');

1034: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, oirec.warehouse_id, 'WAREHOUSE', error_code);
1035: if error_code <> '0' then
1036: wsh_del_oi_core.println(' ');
1037: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 100 ');
1038: wsh_del_oi_core.println(' ');
1039: FND_MESSAGE.SET_NAME('OE', error_code);
1040: raise stop_pld_processing;
1041: end if;
1042:

Line 1048: wsh_del_oi_core.println(' ');

1044: ------------------------------------------------------------------------------
1045: -- VALIDATE LINES WITH WAREHOUSE
1046: -- Ensure lines belong with this delivery's warehouse
1047: ------------------------------------------------------------------------------
1048: wsh_del_oi_core.println(' ');
1049: wsh_del_oi_core.println('Validating lines belong with this delivery warehouse '||
1050: ' x_warehouse: '|| to_char(x_warehouse_id) );
1051: wsh_del_oi_core.println(' ');
1052: error_line := 110;

Line 1049: wsh_del_oi_core.println('Validating lines belong with this delivery warehouse '||

1045: -- VALIDATE LINES WITH WAREHOUSE
1046: -- Ensure lines belong with this delivery's warehouse
1047: ------------------------------------------------------------------------------
1048: wsh_del_oi_core.println(' ');
1049: wsh_del_oi_core.println('Validating lines belong with this delivery warehouse '||
1050: ' x_warehouse: '|| to_char(x_warehouse_id) );
1051: wsh_del_oi_core.println(' ');
1052: error_line := 110;
1053: error_code := '0';

Line 1051: wsh_del_oi_core.println(' ');

1047: ------------------------------------------------------------------------------
1048: wsh_del_oi_core.println(' ');
1049: wsh_del_oi_core.println('Validating lines belong with this delivery warehouse '||
1050: ' x_warehouse: '|| to_char(x_warehouse_id) );
1051: wsh_del_oi_core.println(' ');
1052: error_line := 110;
1053: error_code := '0';
1054:
1055: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, x_warehouse_id, 'WAREHOUSE', error_code);

Line 1057: wsh_del_oi_core.println(' ');

1053: error_code := '0';
1054:
1055: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, x_warehouse_id, 'WAREHOUSE', error_code);
1056: if error_code <> '0' then
1057: wsh_del_oi_core.println(' ');
1058: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 110 ');
1059: wsh_del_oi_core.println(' ');
1060: error_code := 'WSH_OI_LINES_NOT_IN_WHS';
1061: FND_MESSAGE.SET_NAME('OE', error_code);

Line 1058: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 110 ');

1054:
1055: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, x_warehouse_id, 'WAREHOUSE', error_code);
1056: if error_code <> '0' then
1057: wsh_del_oi_core.println(' ');
1058: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 110 ');
1059: wsh_del_oi_core.println(' ');
1060: error_code := 'WSH_OI_LINES_NOT_IN_WHS';
1061: FND_MESSAGE.SET_NAME('OE', error_code);
1062: raise stop_pld_processing;

Line 1059: wsh_del_oi_core.println(' ');

1055: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, x_warehouse_id, 'WAREHOUSE', error_code);
1056: if error_code <> '0' then
1057: wsh_del_oi_core.println(' ');
1058: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 110 ');
1059: wsh_del_oi_core.println(' ');
1060: error_code := 'WSH_OI_LINES_NOT_IN_WHS';
1061: FND_MESSAGE.SET_NAME('OE', error_code);
1062: raise stop_pld_processing;
1063: end if;

Line 1069: wsh_del_oi_core.println(' ');

1065:
1066: ------------------------------------------------------------------------------
1067: -- VALIDATE INVENTORY ITEM
1068: ------------------------------------------------------------------------------
1069: wsh_del_oi_core.println(' ');
1070: wsh_del_oi_core.println('Validating item id: '|| to_char(oirec.item_id) );
1071: wsh_del_oi_core.println(' ');
1072: error_line := 120;
1073: error_code := '0';

Line 1070: wsh_del_oi_core.println('Validating item id: '|| to_char(oirec.item_id) );

1066: ------------------------------------------------------------------------------
1067: -- VALIDATE INVENTORY ITEM
1068: ------------------------------------------------------------------------------
1069: wsh_del_oi_core.println(' ');
1070: wsh_del_oi_core.println('Validating item id: '|| to_char(oirec.item_id) );
1071: wsh_del_oi_core.println(' ');
1072: error_line := 120;
1073: error_code := '0';
1074:

Line 1071: wsh_del_oi_core.println(' ');

1067: -- VALIDATE INVENTORY ITEM
1068: ------------------------------------------------------------------------------
1069: wsh_del_oi_core.println(' ');
1070: wsh_del_oi_core.println('Validating item id: '|| to_char(oirec.item_id) );
1071: wsh_del_oi_core.println(' ');
1072: error_line := 120;
1073: error_code := '0';
1074:
1075: seg_array(1) := oirec.item_segment1; seg_array(2) := oirec.item_segment2;

Line 1089: wsh_del_oi_core.println(' ');

1085: oirec.warehouse_id, oirec.sopld_item_id,
1086: valid_item_id, seg_array, error_code);
1087:
1088: if error_code <> '0' then
1089: wsh_del_oi_core.println(' ');
1090: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 120 ');
1091: wsh_del_oi_core.println(' ');
1092: FND_MESSAGE.SET_NAME('OE', error_code);
1093: raise stop_pld_processing;

Line 1090: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 120 ');

1086: valid_item_id, seg_array, error_code);
1087:
1088: if error_code <> '0' then
1089: wsh_del_oi_core.println(' ');
1090: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 120 ');
1091: wsh_del_oi_core.println(' ');
1092: FND_MESSAGE.SET_NAME('OE', error_code);
1093: raise stop_pld_processing;
1094: end if;

Line 1091: wsh_del_oi_core.println(' ');

1087:
1088: if error_code <> '0' then
1089: wsh_del_oi_core.println(' ');
1090: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 120 ');
1091: wsh_del_oi_core.println(' ');
1092: FND_MESSAGE.SET_NAME('OE', error_code);
1093: raise stop_pld_processing;
1094: end if;
1095:

Line 1101: wsh_del_oi_core.println(' ');

1097: ------------------------------------------------------------------------------
1098: -- VALIDATE VARIABLES
1099: -- Validate reseting variables if org/item have changed
1100: ------------------------------------------------------------------------------
1101: wsh_del_oi_core.println(' ');
1102: wsh_del_oi_core.println('Validating reseting variables if org/item changed ');
1103: wsh_del_oi_core.println(' ');
1104: error_line := 130;
1105: error_code := '0';

Line 1102: wsh_del_oi_core.println('Validating reseting variables if org/item changed ');

1098: -- VALIDATE VARIABLES
1099: -- Validate reseting variables if org/item have changed
1100: ------------------------------------------------------------------------------
1101: wsh_del_oi_core.println(' ');
1102: wsh_del_oi_core.println('Validating reseting variables if org/item changed ');
1103: wsh_del_oi_core.println(' ');
1104: error_line := 130;
1105: error_code := '0';
1106: wsh_oi_validate.changed_item_org(oirec.warehouse_id,

Line 1103: wsh_del_oi_core.println(' ');

1099: -- Validate reseting variables if org/item have changed
1100: ------------------------------------------------------------------------------
1101: wsh_del_oi_core.println(' ');
1102: wsh_del_oi_core.println('Validating reseting variables if org/item changed ');
1103: wsh_del_oi_core.println(' ');
1104: error_line := 130;
1105: error_code := '0';
1106: wsh_oi_validate.changed_item_org(oirec.warehouse_id,
1107: last_warehouse_id,

Line 1116: wsh_del_oi_core.println(' ');

1112: X_lot_control_flag,
1113: X_serial_number_control_flag,
1114: error_code);
1115: if error_code <> '0' then
1116: wsh_del_oi_core.println(' ');
1117: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 130 ');
1118: wsh_del_oi_core.println(' ');
1119: FND_MESSAGE.SET_NAME('OE', error_code);
1120: raise stop_pld_processing;

Line 1117: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 130 ');

1113: X_serial_number_control_flag,
1114: error_code);
1115: if error_code <> '0' then
1116: wsh_del_oi_core.println(' ');
1117: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 130 ');
1118: wsh_del_oi_core.println(' ');
1119: FND_MESSAGE.SET_NAME('OE', error_code);
1120: raise stop_pld_processing;
1121: end if;

Line 1118: wsh_del_oi_core.println(' ');

1114: error_code);
1115: if error_code <> '0' then
1116: wsh_del_oi_core.println(' ');
1117: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 130 ');
1118: wsh_del_oi_core.println(' ');
1119: FND_MESSAGE.SET_NAME('OE', error_code);
1120: raise stop_pld_processing;
1121: end if;
1122:

Line 1128: wsh_del_oi_core.println(' ');

1124: ------------------------------------------------------------------------------
1125: -- VALIDATE SHIPPED QUANTITIES
1126: -- Validate negative or decimal shipped quantities
1127: ------------------------------------------------------------------------------
1128: wsh_del_oi_core.println(' ');
1129: wsh_del_oi_core.println('Validating negative or decimal shipped quantities: '||
1130: to_char( oirec.shipped_quantity) );
1131: wsh_del_oi_core.println(' ');
1132: error_line := 140;

Line 1129: wsh_del_oi_core.println('Validating negative or decimal shipped quantities: '||

1125: -- VALIDATE SHIPPED QUANTITIES
1126: -- Validate negative or decimal shipped quantities
1127: ------------------------------------------------------------------------------
1128: wsh_del_oi_core.println(' ');
1129: wsh_del_oi_core.println('Validating negative or decimal shipped quantities: '||
1130: to_char( oirec.shipped_quantity) );
1131: wsh_del_oi_core.println(' ');
1132: error_line := 140;
1133: error_code := '0';

Line 1131: wsh_del_oi_core.println(' ');

1127: ------------------------------------------------------------------------------
1128: wsh_del_oi_core.println(' ');
1129: wsh_del_oi_core.println('Validating negative or decimal shipped quantities: '||
1130: to_char( oirec.shipped_quantity) );
1131: wsh_del_oi_core.println(' ');
1132: error_line := 140;
1133: error_code := '0';
1134: wsh_oi_validate.qty(oirec.shipped_quantity, error_code);
1135:

Line 1137: wsh_del_oi_core.println(' ');

1133: error_code := '0';
1134: wsh_oi_validate.qty(oirec.shipped_quantity, error_code);
1135:
1136: if error_code <> '0' then
1137: wsh_del_oi_core.println(' ');
1138: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 140 ');
1139: wsh_del_oi_core.println(' ');
1140: FND_MESSAGE.SET_NAME('OE', error_code);
1141: raise stop_pld_processing;

Line 1138: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 140 ');

1134: wsh_oi_validate.qty(oirec.shipped_quantity, error_code);
1135:
1136: if error_code <> '0' then
1137: wsh_del_oi_core.println(' ');
1138: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 140 ');
1139: wsh_del_oi_core.println(' ');
1140: FND_MESSAGE.SET_NAME('OE', error_code);
1141: raise stop_pld_processing;
1142: end if;

Line 1139: wsh_del_oi_core.println(' ');

1135:
1136: if error_code <> '0' then
1137: wsh_del_oi_core.println(' ');
1138: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 140 ');
1139: wsh_del_oi_core.println(' ');
1140: FND_MESSAGE.SET_NAME('OE', error_code);
1141: raise stop_pld_processing;
1142: end if;
1143:

Line 1168: wsh_del_oi_core.println(' ');

1164: -- Validate if a reservation, ensure no interface controls, if input are
1165: -- the same if any inventory controls have changed from the reservation
1166: -- then raise error
1167: --------------------------------------------------------------------------
1168: wsh_del_oi_core.println(' ');
1169: wsh_del_oi_core.println('Validating if any inventory controls have changed');
1170: wsh_del_oi_core.println(' ');
1171: error_line := 150;
1172: error_code := '0';

Line 1169: wsh_del_oi_core.println('Validating if any inventory controls have changed');

1165: -- the same if any inventory controls have changed from the reservation
1166: -- then raise error
1167: --------------------------------------------------------------------------
1168: wsh_del_oi_core.println(' ');
1169: wsh_del_oi_core.println('Validating if any inventory controls have changed');
1170: wsh_del_oi_core.println(' ');
1171: error_line := 150;
1172: error_code := '0';
1173:

Line 1170: wsh_del_oi_core.println(' ');

1166: -- then raise error
1167: --------------------------------------------------------------------------
1168: wsh_del_oi_core.println(' ');
1169: wsh_del_oi_core.println('Validating if any inventory controls have changed');
1170: wsh_del_oi_core.println(' ');
1171: error_line := 150;
1172: error_code := '0';
1173:
1174: wsh_oi_validate.res_inv_ctrl_change(oirec.lot_number, oirec.sopld_lot_number,

Line 1180: wsh_del_oi_core.println(' ');

1176: oirec.subinventory, oirec.sopld_subinventory,
1177: oirec.locator_id, oirec.sopld_locator_id,
1178: error_code);
1179: if error_code <> '0' then
1180: wsh_del_oi_core.println(' ');
1181: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 150 ');
1182: wsh_del_oi_core.println(' ');
1183: FND_MESSAGE.SET_NAME('OE', error_code);
1184: raise stop_pld_processing;

Line 1181: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 150 ');

1177: oirec.locator_id, oirec.sopld_locator_id,
1178: error_code);
1179: if error_code <> '0' then
1180: wsh_del_oi_core.println(' ');
1181: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 150 ');
1182: wsh_del_oi_core.println(' ');
1183: FND_MESSAGE.SET_NAME('OE', error_code);
1184: raise stop_pld_processing;
1185: end if;

Line 1182: wsh_del_oi_core.println(' ');

1178: error_code);
1179: if error_code <> '0' then
1180: wsh_del_oi_core.println(' ');
1181: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 150 ');
1182: wsh_del_oi_core.println(' ');
1183: FND_MESSAGE.SET_NAME('OE', error_code);
1184: raise stop_pld_processing;
1185: end if;
1186:

Line 1202: WSH_DEL_OI_CORE.get_locator_controls

1198: if valid_warehouse_id <> last_warehouse_id
1199: or valid_item_id <> last_item_id
1200: or valid_sub <> last_sub
1201: then
1202: WSH_DEL_OI_CORE.get_locator_controls
1203: ( valid_warehouse_id,
1204: valid_item_id,
1205: valid_sub,
1206: X_location_control_flag,

Line 1212: wsh_del_oi_core.println('Loc Ctrl:'||X_location_control_flag||

1208: error_code);
1209: if error_code <> '0' then
1210: EXIT;
1211: end if;
1212: wsh_del_oi_core.println('Loc Ctrl:'||X_location_control_flag||
1213: ' loc restricted:'||X_location_restricted_flag);
1214: end if;
1215: -- Bug: 916149 (701829)
1216:

Line 1217: wsh_del_oi_core.println('Reservation is set, Inv Controls set as Sub '||valid_sub||

1213: ' loc restricted:'||X_location_restricted_flag);
1214: end if;
1215: -- Bug: 916149 (701829)
1216:
1217: wsh_del_oi_core.println('Reservation is set, Inv Controls set as Sub '||valid_sub||
1218: ' revison='||valid_revision||' loc='||to_char(valid_loc)
1219: ||' lot='||valid_lot);
1220:
1221:

Line 1232: wsh_del_oi_core.println(' ');

1228:
1229: --------------------------------------------------------------------------
1230: -- VALIDATE PLD SUBINVENTORY
1231: --------------------------------------------------------------------------
1232: wsh_del_oi_core.println(' ');
1233: wsh_del_oi_core.println('Validating Picking Line subinventory'||
1234: ' sub: '|| oirec.subinventory||
1235: ' warehouse:'||to_char(valid_warehouse_id)||
1236: ' restrict_flag:'||X_subinv_restricted_flag||

Line 1233: wsh_del_oi_core.println('Validating Picking Line subinventory'||

1229: --------------------------------------------------------------------------
1230: -- VALIDATE PLD SUBINVENTORY
1231: --------------------------------------------------------------------------
1232: wsh_del_oi_core.println(' ');
1233: wsh_del_oi_core.println('Validating Picking Line subinventory'||
1234: ' sub: '|| oirec.subinventory||
1235: ' warehouse:'||to_char(valid_warehouse_id)||
1236: ' restrict_flag:'||X_subinv_restricted_flag||
1237: ' item:'||to_char(valid_item_id)||

Line 1240: wsh_del_oi_core.println(' ');

1236: ' restrict_flag:'||X_subinv_restricted_flag||
1237: ' item:'||to_char(valid_item_id)||
1238: ' valid_sub:'||valid_sub||
1239: ' default_sub:'||valid_sub);
1240: wsh_del_oi_core.println(' ');
1241: error_line := 160;
1242: error_code := '0';
1243: wsh_oi_validate.pld_subinventory(oirec.subinventory,
1244: oirec.sopld_subinventory,

Line 1252: wsh_del_oi_core.println(' ');

1248: valid_sub,
1249: default_sub,
1250: error_code);
1251: if error_code <> '0' then
1252: wsh_del_oi_core.println(' ');
1253: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 160 ');
1254: wsh_del_oi_core.println(' ');
1255: FND_MESSAGE.SET_NAME('OE', error_code);
1256: raise stop_pld_processing;

Line 1253: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 160 ');

1249: default_sub,
1250: error_code);
1251: if error_code <> '0' then
1252: wsh_del_oi_core.println(' ');
1253: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 160 ');
1254: wsh_del_oi_core.println(' ');
1255: FND_MESSAGE.SET_NAME('OE', error_code);
1256: raise stop_pld_processing;
1257: end if;

Line 1254: wsh_del_oi_core.println(' ');

1250: error_code);
1251: if error_code <> '0' then
1252: wsh_del_oi_core.println(' ');
1253: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 160 ');
1254: wsh_del_oi_core.println(' ');
1255: FND_MESSAGE.SET_NAME('OE', error_code);
1256: raise stop_pld_processing;
1257: end if;
1258:

Line 1262: wsh_del_oi_core.println(' ');

1258:
1259: --------------------------------------------------------------------------
1260: -- VALIDATE PLD LOT NUMBER
1261: --------------------------------------------------------------------------
1262: wsh_del_oi_core.println(' ');
1263: wsh_del_oi_core.println('Validating Picking Line Lot Number'||
1264: ' valid_lot: '||valid_lot);
1265: wsh_del_oi_core.println(' ');
1266: error_line := 170;

Line 1263: wsh_del_oi_core.println('Validating Picking Line Lot Number'||

1259: --------------------------------------------------------------------------
1260: -- VALIDATE PLD LOT NUMBER
1261: --------------------------------------------------------------------------
1262: wsh_del_oi_core.println(' ');
1263: wsh_del_oi_core.println('Validating Picking Line Lot Number'||
1264: ' valid_lot: '||valid_lot);
1265: wsh_del_oi_core.println(' ');
1266: error_line := 170;
1267: error_code := '0';

Line 1265: wsh_del_oi_core.println(' ');

1261: --------------------------------------------------------------------------
1262: wsh_del_oi_core.println(' ');
1263: wsh_del_oi_core.println('Validating Picking Line Lot Number'||
1264: ' valid_lot: '||valid_lot);
1265: wsh_del_oi_core.println(' ');
1266: error_line := 170;
1267: error_code := '0';
1268: wsh_oi_validate.pld_lot_number(oirec.lot_number,
1269: X_lot_control_flag,

Line 1277: wsh_del_oi_core.println(' ');

1273: valid_sub,
1274: valid_lot,
1275: error_code);
1276: if error_code <> '0' then
1277: wsh_del_oi_core.println(' ');
1278: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 170 ');
1279: wsh_del_oi_core.println(' ');
1280: FND_MESSAGE.SET_NAME('OE', error_code);
1281: raise stop_pld_processing;

Line 1278: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 170 ');

1274: valid_lot,
1275: error_code);
1276: if error_code <> '0' then
1277: wsh_del_oi_core.println(' ');
1278: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 170 ');
1279: wsh_del_oi_core.println(' ');
1280: FND_MESSAGE.SET_NAME('OE', error_code);
1281: raise stop_pld_processing;
1282: end if;

Line 1279: wsh_del_oi_core.println(' ');

1275: error_code);
1276: if error_code <> '0' then
1277: wsh_del_oi_core.println(' ');
1278: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 170 ');
1279: wsh_del_oi_core.println(' ');
1280: FND_MESSAGE.SET_NAME('OE', error_code);
1281: raise stop_pld_processing;
1282: end if;
1283:

Line 1287: wsh_del_oi_core.println(' ');

1283:
1284: --------------------------------------------------------------------------
1285: -- VALIDATE PLD REVISION
1286: --------------------------------------------------------------------------
1287: wsh_del_oi_core.println(' ');
1288: wsh_del_oi_core.println('Validating Picking Line Revision' ||
1289: ' revision:'|| valid_revision);
1290: wsh_del_oi_core.println(' ');
1291: error_line := 180;

Line 1288: wsh_del_oi_core.println('Validating Picking Line Revision' ||

1284: --------------------------------------------------------------------------
1285: -- VALIDATE PLD REVISION
1286: --------------------------------------------------------------------------
1287: wsh_del_oi_core.println(' ');
1288: wsh_del_oi_core.println('Validating Picking Line Revision' ||
1289: ' revision:'|| valid_revision);
1290: wsh_del_oi_core.println(' ');
1291: error_line := 180;
1292: error_code := '0';

Line 1290: wsh_del_oi_core.println(' ');

1286: --------------------------------------------------------------------------
1287: wsh_del_oi_core.println(' ');
1288: wsh_del_oi_core.println('Validating Picking Line Revision' ||
1289: ' revision:'|| valid_revision);
1290: wsh_del_oi_core.println(' ');
1291: error_line := 180;
1292: error_code := '0';
1293: wsh_oi_validate.pld_revision(oirec.revision,
1294: oirec.sopld_revision,

Line 1301: wsh_del_oi_core.println(' ');

1297: valid_revision,
1298: x_revision_control_flag,
1299: error_code);
1300: if error_code <> '0' then
1301: wsh_del_oi_core.println(' ');
1302: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 180 ');
1303: wsh_del_oi_core.println(' ');
1304: FND_MESSAGE.SET_NAME('OE', error_code);
1305: raise stop_pld_processing;

Line 1302: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 180 ');

1298: x_revision_control_flag,
1299: error_code);
1300: if error_code <> '0' then
1301: wsh_del_oi_core.println(' ');
1302: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 180 ');
1303: wsh_del_oi_core.println(' ');
1304: FND_MESSAGE.SET_NAME('OE', error_code);
1305: raise stop_pld_processing;
1306: end if;

Line 1303: wsh_del_oi_core.println(' ');

1299: error_code);
1300: if error_code <> '0' then
1301: wsh_del_oi_core.println(' ');
1302: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 180 ');
1303: wsh_del_oi_core.println(' ');
1304: FND_MESSAGE.SET_NAME('OE', error_code);
1305: raise stop_pld_processing;
1306: end if;
1307:

Line 1312: wsh_del_oi_core.println(' ');

1308:
1309: --------------------------------------------------------------------------
1310: -- VALIDATE PLD ITEM LOCATION
1311: --------------------------------------------------------------------------
1312: wsh_del_oi_core.println(' ');
1313: wsh_del_oi_core.println('Validating Picking Line Item Loc'||
1314: ' loc_control_flag: '||X_location_control_flag||
1315: ' valid_loc:'||valid_loc);
1316: wsh_del_oi_core.println(' ');

Line 1313: wsh_del_oi_core.println('Validating Picking Line Item Loc'||

1309: --------------------------------------------------------------------------
1310: -- VALIDATE PLD ITEM LOCATION
1311: --------------------------------------------------------------------------
1312: wsh_del_oi_core.println(' ');
1313: wsh_del_oi_core.println('Validating Picking Line Item Loc'||
1314: ' loc_control_flag: '||X_location_control_flag||
1315: ' valid_loc:'||valid_loc);
1316: wsh_del_oi_core.println(' ');
1317: error_line := 190;

Line 1316: wsh_del_oi_core.println(' ');

1312: wsh_del_oi_core.println(' ');
1313: wsh_del_oi_core.println('Validating Picking Line Item Loc'||
1314: ' loc_control_flag: '||X_location_control_flag||
1315: ' valid_loc:'||valid_loc);
1316: wsh_del_oi_core.println(' ');
1317: error_line := 190;
1318: error_code := '0';
1319: wsh_oi_validate.pld_item_location(valid_warehouse_id,
1320: last_warehouse_id,

Line 1332: wsh_del_oi_core.println(' ');

1328: error_code);
1329:
1330:
1331: if error_code <> '0' then
1332: wsh_del_oi_core.println(' ');
1333: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 190 ');
1334: wsh_del_oi_core.println(' ');
1335: FND_MESSAGE.SET_NAME('OE', error_code);
1336: raise stop_pld_processing;

Line 1333: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 190 ');

1329:
1330:
1331: if error_code <> '0' then
1332: wsh_del_oi_core.println(' ');
1333: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 190 ');
1334: wsh_del_oi_core.println(' ');
1335: FND_MESSAGE.SET_NAME('OE', error_code);
1336: raise stop_pld_processing;
1337: end if;

Line 1334: wsh_del_oi_core.println(' ');

1330:
1331: if error_code <> '0' then
1332: wsh_del_oi_core.println(' ');
1333: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 190 ');
1334: wsh_del_oi_core.println(' ');
1335: FND_MESSAGE.SET_NAME('OE', error_code);
1336: raise stop_pld_processing;
1337: end if;
1338:

Line 1342: wsh_del_oi_core.println(' ');

1338:
1339: --------------------------------------------------------------------------
1340: -- VALIDATE PLD LOCATOR
1341: --------------------------------------------------------------------------
1342: wsh_del_oi_core.println(' ');
1343: wsh_del_oi_core.println('Validating Picking Line Locator');
1344: wsh_del_oi_core.println(' ');
1345: error_line := 200;
1346: error_code := '0';

Line 1343: wsh_del_oi_core.println('Validating Picking Line Locator');

1339: --------------------------------------------------------------------------
1340: -- VALIDATE PLD LOCATOR
1341: --------------------------------------------------------------------------
1342: wsh_del_oi_core.println(' ');
1343: wsh_del_oi_core.println('Validating Picking Line Locator');
1344: wsh_del_oi_core.println(' ');
1345: error_line := 200;
1346: error_code := '0';
1347:

Line 1344: wsh_del_oi_core.println(' ');

1340: -- VALIDATE PLD LOCATOR
1341: --------------------------------------------------------------------------
1342: wsh_del_oi_core.println(' ');
1343: wsh_del_oi_core.println('Validating Picking Line Locator');
1344: wsh_del_oi_core.println(' ');
1345: error_line := 200;
1346: error_code := '0';
1347:
1348: seg_array(1) := oirec.loc_segment1; seg_array(2) := oirec.loc_segment2;

Line 1373: wsh_del_oi_core.println(' ');

1369: seg_array,
1370: error_code);
1371:
1372: if error_code <> '0' then
1373: wsh_del_oi_core.println(' ');
1374: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 200 ');
1375: wsh_del_oi_core.println(' ');
1376: FND_MESSAGE.SET_NAME('OE', error_code);
1377: raise stop_pld_processing;

Line 1374: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 200 ');

1370: error_code);
1371:
1372: if error_code <> '0' then
1373: wsh_del_oi_core.println(' ');
1374: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 200 ');
1375: wsh_del_oi_core.println(' ');
1376: FND_MESSAGE.SET_NAME('OE', error_code);
1377: raise stop_pld_processing;
1378: end if;

Line 1375: wsh_del_oi_core.println(' ');

1371:
1372: if error_code <> '0' then
1373: wsh_del_oi_core.println(' ');
1374: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 200 ');
1375: wsh_del_oi_core.println(' ');
1376: FND_MESSAGE.SET_NAME('OE', error_code);
1377: raise stop_pld_processing;
1378: end if;
1379: -------------------------------------------------------------------------

Line 1389: wsh_del_oi_core.println(' ');

1385: --------------------------------------------------------------------------
1386: -- VALIDATE PLD SERIAL NUMBER
1387: -- If present irrespective of reservations
1388: --------------------------------------------------------------------------
1389: wsh_del_oi_core.println(' ');
1390: wsh_del_oi_core.println('Validating Picking Line Serial Numbers:'||oirec.sn);
1391: wsh_del_oi_core.println(' ');
1392: error_line := 210;
1393: error_code := '0';

Line 1390: wsh_del_oi_core.println('Validating Picking Line Serial Numbers:'||oirec.sn);

1386: -- VALIDATE PLD SERIAL NUMBER
1387: -- If present irrespective of reservations
1388: --------------------------------------------------------------------------
1389: wsh_del_oi_core.println(' ');
1390: wsh_del_oi_core.println('Validating Picking Line Serial Numbers:'||oirec.sn);
1391: wsh_del_oi_core.println(' ');
1392: error_line := 210;
1393: error_code := '0';
1394: wsh_oi_validate.pld_serial_number(oirec.sn,

Line 1391: wsh_del_oi_core.println(' ');

1387: -- If present irrespective of reservations
1388: --------------------------------------------------------------------------
1389: wsh_del_oi_core.println(' ');
1390: wsh_del_oi_core.println('Validating Picking Line Serial Numbers:'||oirec.sn);
1391: wsh_del_oi_core.println(' ');
1392: error_line := 210;
1393: error_code := '0';
1394: wsh_oi_validate.pld_serial_number(oirec.sn,
1395: X_serial_number_control_flag,

Line 1410: wsh_del_oi_core.println(' ');

1406: oirec.picking_line_id,
1407: oirec.picking_line_detail_id,
1408: error_code);
1409: if error_code <> '0' then
1410: wsh_del_oi_core.println(' ');
1411: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 210 ');
1412: wsh_del_oi_core.println(' ');
1413: FND_MESSAGE.SET_NAME('OE', error_code);
1414: raise stop_pld_processing;

Line 1411: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 210 ');

1407: oirec.picking_line_detail_id,
1408: error_code);
1409: if error_code <> '0' then
1410: wsh_del_oi_core.println(' ');
1411: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 210 ');
1412: wsh_del_oi_core.println(' ');
1413: FND_MESSAGE.SET_NAME('OE', error_code);
1414: raise stop_pld_processing;
1415: end if;

Line 1412: wsh_del_oi_core.println(' ');

1408: error_code);
1409: if error_code <> '0' then
1410: wsh_del_oi_core.println(' ');
1411: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 210 ');
1412: wsh_del_oi_core.println(' ');
1413: FND_MESSAGE.SET_NAME('OE', error_code);
1414: raise stop_pld_processing;
1415: end if;
1416:

Line 1420: wsh_del_oi_core.println(' ');

1416:
1417: --------------------------------------------------------------------------
1418: -- VALIDATE PLD CONTAINER
1419: --------------------------------------------------------------------------
1420: wsh_del_oi_core.println(' ');
1421: wsh_del_oi_core.println('Validating Picking Line Container:'|| to_char(oirec.container_id)||
1422: ' seq:'||to_char(oirec.container_sequence) );
1423: wsh_del_oi_core.println(' ');
1424: error_line := 220;

Line 1421: wsh_del_oi_core.println('Validating Picking Line Container:'|| to_char(oirec.container_id)||

1417: --------------------------------------------------------------------------
1418: -- VALIDATE PLD CONTAINER
1419: --------------------------------------------------------------------------
1420: wsh_del_oi_core.println(' ');
1421: wsh_del_oi_core.println('Validating Picking Line Container:'|| to_char(oirec.container_id)||
1422: ' seq:'||to_char(oirec.container_sequence) );
1423: wsh_del_oi_core.println(' ');
1424: error_line := 220;
1425: error_code := '0';

Line 1423: wsh_del_oi_core.println(' ');

1419: --------------------------------------------------------------------------
1420: wsh_del_oi_core.println(' ');
1421: wsh_del_oi_core.println('Validating Picking Line Container:'|| to_char(oirec.container_id)||
1422: ' seq:'||to_char(oirec.container_sequence) );
1423: wsh_del_oi_core.println(' ');
1424: error_line := 220;
1425: error_code := '0';
1426:
1427: wsh_oi_validate.container(oirec.container_id,

Line 1433: wsh_del_oi_core.println(' ');

1429: x_delivery_id,
1430: x_container_id,
1431: error_code);
1432: if error_code <> '0' then
1433: wsh_del_oi_core.println(' ');
1434: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 220 ');
1435: wsh_del_oi_core.println(' ');
1436: FND_MESSAGE.SET_NAME('OE', error_code);
1437: raise stop_pld_processing;

Line 1434: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 220 ');

1430: x_container_id,
1431: error_code);
1432: if error_code <> '0' then
1433: wsh_del_oi_core.println(' ');
1434: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 220 ');
1435: wsh_del_oi_core.println(' ');
1436: FND_MESSAGE.SET_NAME('OE', error_code);
1437: raise stop_pld_processing;
1438: end if;

Line 1435: wsh_del_oi_core.println(' ');

1431: error_code);
1432: if error_code <> '0' then
1433: wsh_del_oi_core.println(' ');
1434: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 220 ');
1435: wsh_del_oi_core.println(' ');
1436: FND_MESSAGE.SET_NAME('OE', error_code);
1437: raise stop_pld_processing;
1438: end if;
1439:

Line 1444: wsh_del_oi_core.println(' ');

1440:
1441: --------------------------------------------------------------------------
1442: -- VALIDATE PLD LINE ADDITION
1443: --------------------------------------------------------------------------
1444: wsh_del_oi_core.println(' ');
1445: wsh_del_oi_core.println('Validating Picking Line Addition of Line');
1446: wsh_del_oi_core.println(' ');
1447: error_line := 230;
1448: error_code := '0';

Line 1445: wsh_del_oi_core.println('Validating Picking Line Addition of Line');

1441: --------------------------------------------------------------------------
1442: -- VALIDATE PLD LINE ADDITION
1443: --------------------------------------------------------------------------
1444: wsh_del_oi_core.println(' ');
1445: wsh_del_oi_core.println('Validating Picking Line Addition of Line');
1446: wsh_del_oi_core.println(' ');
1447: error_line := 230;
1448: error_code := '0';
1449: wsh_oi_validate.pld_line_add(x_delivery_id,

Line 1446: wsh_del_oi_core.println(' ');

1442: -- VALIDATE PLD LINE ADDITION
1443: --------------------------------------------------------------------------
1444: wsh_del_oi_core.println(' ');
1445: wsh_del_oi_core.println('Validating Picking Line Addition of Line');
1446: wsh_del_oi_core.println(' ');
1447: error_line := 230;
1448: error_code := '0';
1449: wsh_oi_validate.pld_line_add(x_delivery_id,
1450: oirec.sopld_delivery_id,

Line 1458: wsh_del_oi_core.println(' ');

1454: oirec.picking_line_detail_id,
1455: token_name,
1456: error_code);
1457: if error_code <> '0' then
1458: wsh_del_oi_core.println(' ');
1459: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 230 ');
1460: wsh_del_oi_core.println(' ');
1461: FND_MESSAGE.SET_NAME('OE', error_code);
1462: raise stop_pld_processing;

Line 1459: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 230 ');

1455: token_name,
1456: error_code);
1457: if error_code <> '0' then
1458: wsh_del_oi_core.println(' ');
1459: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 230 ');
1460: wsh_del_oi_core.println(' ');
1461: FND_MESSAGE.SET_NAME('OE', error_code);
1462: raise stop_pld_processing;
1463: end if;

Line 1460: wsh_del_oi_core.println(' ');

1456: error_code);
1457: if error_code <> '0' then
1458: wsh_del_oi_core.println(' ');
1459: wsh_del_oi_core.println('Validation Error in PROCESS_SOPLD_INTERFACE Error Line = 230 ');
1460: wsh_del_oi_core.println(' ');
1461: FND_MESSAGE.SET_NAME('OE', error_code);
1462: raise stop_pld_processing;
1463: end if;
1464:

Line 1477: wsh_del_oi_core.println('-----After selection from pld');

1473: INTO pl_pld_id, pl_shp_qty, pl_req_qty, pl_del, pl_cont
1474: FROM SO_PICKING_LINE_DETAILS
1475: WHERE picking_line_detail_id = oirec.picking_line_detail_id;
1476:
1477: wsh_del_oi_core.println('-----After selection from pld');
1478:
1479: -- if oirec.picking_line_detail_id = pl_pld_id then
1480: if ((oirec.shipped_quantity + NVL(pl_shp_qty, 0)) > pl_req_qty) then
1481: error_code := '1';

Line 1482: wsh_del_oi_core.println('Shipped Quantity > Requested Quantity');

1478:
1479: -- if oirec.picking_line_detail_id = pl_pld_id then
1480: if ((oirec.shipped_quantity + NVL(pl_shp_qty, 0)) > pl_req_qty) then
1481: error_code := '1';
1482: wsh_del_oi_core.println('Shipped Quantity > Requested Quantity');
1483: raise stop_pld_processing;
1484: elsif oirec.shipped_quantity = pl_req_qty then
1485: wsh_del_oi_core.println('Going to update_line label');
1486: goto update_line;

Line 1485: wsh_del_oi_core.println('Going to update_line label');

1481: error_code := '1';
1482: wsh_del_oi_core.println('Shipped Quantity > Requested Quantity');
1483: raise stop_pld_processing;
1484: elsif oirec.shipped_quantity = pl_req_qty then
1485: wsh_del_oi_core.println('Going to update_line label');
1486: goto update_line;
1487: else -- Split Lines
1488: wsh_del_oi_core.println('Going for split_line');
1489: if x_backorder_flag = false then

Line 1488: wsh_del_oi_core.println('Going for split_line');

1484: elsif oirec.shipped_quantity = pl_req_qty then
1485: wsh_del_oi_core.println('Going to update_line label');
1486: goto update_line;
1487: else -- Split Lines
1488: wsh_del_oi_core.println('Going for split_line');
1489: if x_backorder_flag = false then
1490: wsh_del_oi_core.println('BACKORDER FLAG is FALSE.Going for split of:'||
1491: ' pld:'|| to_char(oirec.picking_line_detail_id));
1492: WSH_SC_TRX_INTERFACE.split_sopld_row

Line 1490: wsh_del_oi_core.println('BACKORDER FLAG is FALSE.Going for split of:'||

1486: goto update_line;
1487: else -- Split Lines
1488: wsh_del_oi_core.println('Going for split_line');
1489: if x_backorder_flag = false then
1490: wsh_del_oi_core.println('BACKORDER FLAG is FALSE.Going for split of:'||
1491: ' pld:'|| to_char(oirec.picking_line_detail_id));
1492: WSH_SC_TRX_INTERFACE.split_sopld_row
1493: (oirec.picking_line_id,
1494: oirec.picking_line_detail_id,

Line 1520: wsh_del_oi_core.println('Calling Reservations transfer 1');

1516: -- Reservations transfer
1517:
1518: COMMIT;
1519:
1520: wsh_del_oi_core.println('Calling Reservations transfer 1');
1521: ret_val := Fnd_Transaction.synchronous( 1000,
1522: outcome,
1523: message,
1524: 'OE',

Line 1546: wsh_del_oi_core.println('CALLING goto_end_processing');

1542: RAISE cannot_transfer;
1543: end if;
1544: end if;
1545: else
1546: wsh_del_oi_core.println('CALLING goto_end_processing');
1547: goto end_processing;
1548: end if; -- Reservations transfer
1549:
1550: -- After reservation transfer the departure & Delivery_id dpw_assigned_flag

Line 1554: wsh_del_oi_core.println('Into reseting pld after reservation split. pld:'||

1550: -- After reservation transfer the departure & Delivery_id dpw_assigned_flag
1551: -- and the serial_number in the new pld is NULLED,
1552:
1553: BEGIN
1554: wsh_del_oi_core.println('Into reseting pld after reservation split. pld:'||
1555: to_char(new_pld_id) );
1556: UPDATE SO_PICKING_LINE_DETAILS SET
1557: DELIVERY_ID = nvl(DELIVERY_ID,x_delivery_id),
1558: DEPARTURE_ID = nvl(DEPARTURE_ID,x_departure_id),

Line 1570: wsh_del_oi_core.println('Could not find record in PLD. pld:'||

1566: LAST_UPDATE_LOGIN = fnd_global.user_id
1567: WHERE PICKING_LINE_DETAIL_ID = new_pld_id;
1568:
1569: if sql%notfound then
1570: wsh_del_oi_core.println('Could not find record in PLD. pld:'||
1571: to_char(new_pld_id) );
1572: error_code := '1';
1573: FND_MESSAGE.SET_NAME('OE' , error_code);
1574: raise stop_pld_processing;

Line 1598: wsh_del_oi_core.println('Into the Update_line label.');

1594:
1595:
1596: <>
1597:
1598: wsh_del_oi_core.println('Into the Update_line label.');
1599: wsh_del_oi_core.println('Going for update of pld:'||
1600: to_char(oirec.picking_line_detail_id) );
1601:
1602: -- Control will reach here ONLY in case of backorder_flag=TRUE

Line 1599: wsh_del_oi_core.println('Going for update of pld:'||

1595:
1596: <>
1597:
1598: wsh_del_oi_core.println('Into the Update_line label.');
1599: wsh_del_oi_core.println('Going for update of pld:'||
1600: to_char(oirec.picking_line_detail_id) );
1601:
1602: -- Control will reach here ONLY in case of backorder_flag=TRUE
1603: -- this update will fail only if the inventory controls are different & the

Line 1640: wsh_del_oi_core.println('Shipped qty equal to ZERO.');

1636: -- we're probably trying to reset it to zero
1637: --------------------------------------------------------------------------
1638: if nvl(oirec.shipped_quantity,0) = 0 then
1639: error_code := 'WSH_OI_USE_FORM';
1640: wsh_del_oi_core.println('Shipped qty equal to ZERO.');
1641: EXIT;
1642: end if;
1643:
1644: wsh_del_oi_core.println(substr(('Could not update SOPLD using detail_id:: splitting row '||

Line 1644: wsh_del_oi_core.println(substr(('Could not update SOPLD using detail_id:: splitting row '||

1640: wsh_del_oi_core.println('Shipped qty equal to ZERO.');
1641: EXIT;
1642: end if;
1643:
1644: wsh_del_oi_core.println(substr(('Could not update SOPLD using detail_id:: splitting row '||
1645: to_char(oirec.picking_line_id)||','||to_char(oirec.picking_line_detail_id)||','||
1646: to_char(valid_warehouse_id)||','||
1647: valid_lot||','||valid_revision||','||
1648: valid_sub||','||valid_loc),1,2000));

Line 1701: wsh_del_oi_core.println('PLD Process EXCEPTION stop_pld_processing');

1697: --------------------------------------------------------------------------
1698: EXCEPTION
1699:
1700: WHEN stop_pld_processing then
1701: wsh_del_oi_core.println('PLD Process EXCEPTION stop_pld_processing');
1702: x_error_code := error_code;
1703: -- at this point error_code should be set and an error is on the stack
1704: -- it will be handled by the calling program.
1705: null;

Line 1708: wsh_del_oi_core.println('PLD Process EXCEPTION online_no_manager');

1704: -- it will be handled by the calling program.
1705: null;
1706:
1707: WHEN online_no_manager THEN
1708: wsh_del_oi_core.println('PLD Process EXCEPTION online_no_manager');
1709: --FND_MESSAGE.SET_NAME('OE','SHP_ONLINE_NO_MANAGER');
1710: x_error_code := error_code;
1711:
1712: WHEN online_error THEN

Line 1713: wsh_del_oi_core.println('PLD Process EXCEPTION online_error');

1709: --FND_MESSAGE.SET_NAME('OE','SHP_ONLINE_NO_MANAGER');
1710: x_error_code := error_code;
1711:
1712: WHEN online_error THEN
1713: wsh_del_oi_core.println('PLD Process EXCEPTION online_error');
1714: --FND_MESSAGE.SET_NAME('OE','SHP_ONLINE_NO_MANAGER');
1715: --FND_MESSAGE.SET_NAME('OE','SHP_AOL_ONLINE_FAILED');
1716: --FND_MESSAGE.SET_TOKEN('PROGRAM', 'WSHURTF');
1717: x_error_code := error_code;

Line 1720: wsh_del_oi_core.println('PLD Process EXCEPTION cannot_transfer');

1716: --FND_MESSAGE.SET_TOKEN('PROGRAM', 'WSHURTF');
1717: x_error_code := error_code;
1718:
1719: WHEN cannot_transfer THEN
1720: wsh_del_oi_core.println('PLD Process EXCEPTION cannot_transfer');
1721: ret_val := Fnd_Transaction.get_values( a1, a2, a3, a4, a5, a6,
1722: a7, a8, a9, a10, a11, a12, a13, a14,
1723: a15, a16, a17, a18, a19, a20);
1724: --FND_MESSAGE.Set_Name('OE','WSH_SC_CANNOT_TRANSFER_PLD');

Line 1731: wsh_del_oi_core.println('msg ='|| return_msg1);

1727: x_error_code := error_code;
1728:
1729: WHEN others then
1730: return_msg1 := FND_MESSAGE.get;
1731: wsh_del_oi_core.println('msg ='|| return_msg1);
1732: x_error_code := 'OE_QUERY_ERROR';
1733: FND_MESSAGE.SET_NAME('OE', x_error_code);
1734: wsh_del_oi_core.println('PLD Process EXCEPTION others ');
1735: --FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 1734: wsh_del_oi_core.println('PLD Process EXCEPTION others ');

1730: return_msg1 := FND_MESSAGE.get;
1731: wsh_del_oi_core.println('msg ='|| return_msg1);
1732: x_error_code := 'OE_QUERY_ERROR';
1733: FND_MESSAGE.SET_NAME('OE', x_error_code);
1734: wsh_del_oi_core.println('PLD Process EXCEPTION others ');
1735: --FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1736: --FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.process_sopld_interface');
1737: --FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1738: --FND_MESSAGE.Set_Token('ORA_TEXT','Insert statement');

Line 1832: wsh_del_oi_core.println(' ');

1828: OPEN Freight_Charge_Cursor ;
1829:
1830: LOOP
1831:
1832: wsh_del_oi_core.println(' ');
1833: wsh_del_oi_core.println('Fetching a record from Freight Charge Interface table');
1834: wsh_del_oi_core.println(' ');
1835:
1836: fetch Freight_Charge_cursor into fcrec;

Line 1833: wsh_del_oi_core.println('Fetching a record from Freight Charge Interface table');

1829:
1830: LOOP
1831:
1832: wsh_del_oi_core.println(' ');
1833: wsh_del_oi_core.println('Fetching a record from Freight Charge Interface table');
1834: wsh_del_oi_core.println(' ');
1835:
1836: fetch Freight_Charge_cursor into fcrec;
1837:

Line 1834: wsh_del_oi_core.println(' ');

1830: LOOP
1831:
1832: wsh_del_oi_core.println(' ');
1833: wsh_del_oi_core.println('Fetching a record from Freight Charge Interface table');
1834: wsh_del_oi_core.println(' ');
1835:
1836: fetch Freight_Charge_cursor into fcrec;
1837:
1838: exit when Freight_Charge_Cursor%notfound;

Line 1853: wsh_del_oi_core.println(' ');

1849: -- status set to Not Null and have the AR Interfaced Flag ( s5 ) set to either 5 =
1850: -- A/R Interfaced Partial, 8 = A/R Interfaced Not Applicable or 9 = A/R Interfaced.
1851: --------------------------------------------------------------------------------------
1852:
1853: wsh_del_oi_core.println(' ');
1854: wsh_del_oi_core.println('Validating if the Delivery is already A/R Interfaced');
1855: wsh_del_oi_core.println(' ');
1856: error_code := '0';
1857: if first_time then

Line 1854: wsh_del_oi_core.println('Validating if the Delivery is already A/R Interfaced');

1850: -- A/R Interfaced Partial, 8 = A/R Interfaced Not Applicable or 9 = A/R Interfaced.
1851: --------------------------------------------------------------------------------------
1852:
1853: wsh_del_oi_core.println(' ');
1854: wsh_del_oi_core.println('Validating if the Delivery is already A/R Interfaced');
1855: wsh_del_oi_core.println(' ');
1856: error_code := '0';
1857: if first_time then
1858: wsh_oi_validate.if_ar_intfaced(x_delivery_id, error_code );

Line 1855: wsh_del_oi_core.println(' ');

1851: --------------------------------------------------------------------------------------
1852:
1853: wsh_del_oi_core.println(' ');
1854: wsh_del_oi_core.println('Validating if the Delivery is already A/R Interfaced');
1855: wsh_del_oi_core.println(' ');
1856: error_code := '0';
1857: if first_time then
1858: wsh_oi_validate.if_ar_intfaced(x_delivery_id, error_code );
1859:

Line 1861: wsh_del_oi_core.println(' ');

1857: if first_time then
1858: wsh_oi_validate.if_ar_intfaced(x_delivery_id, error_code );
1859:
1860: if error_code <> '0' then
1861: wsh_del_oi_core.println(' ');
1862: wsh_del_oi_core.println('This Delivery is already A/R Interfaced');
1863: wsh_del_oi_core.println(' ');
1864: FND_MESSAGE.set_name('OE', error_code);
1865: raise stop_fc_processing;

Line 1862: wsh_del_oi_core.println('This Delivery is already A/R Interfaced');

1858: wsh_oi_validate.if_ar_intfaced(x_delivery_id, error_code );
1859:
1860: if error_code <> '0' then
1861: wsh_del_oi_core.println(' ');
1862: wsh_del_oi_core.println('This Delivery is already A/R Interfaced');
1863: wsh_del_oi_core.println(' ');
1864: FND_MESSAGE.set_name('OE', error_code);
1865: raise stop_fc_processing;
1866: end if;

Line 1863: wsh_del_oi_core.println(' ');

1859:
1860: if error_code <> '0' then
1861: wsh_del_oi_core.println(' ');
1862: wsh_del_oi_core.println('This Delivery is already A/R Interfaced');
1863: wsh_del_oi_core.println(' ');
1864: FND_MESSAGE.set_name('OE', error_code);
1865: raise stop_fc_processing;
1866: end if;
1867: first_time := FALSE;

Line 1876: wsh_del_oi_core.println(' ');

1872: -- Validate the freight charge type id and desc , if either one or both of them are
1873: -- specified
1874: --------------------------------------------------------------------------------------
1875:
1876: wsh_del_oi_core.println(' ');
1877: wsh_del_oi_core.println('Validating Freight Charge Type');
1878: wsh_del_oi_core.println(' ');
1879: error_code := '0';
1880: wsh_oi_validate.freight_charge_type(fcrec.freight_charge_type_id ,

Line 1877: wsh_del_oi_core.println('Validating Freight Charge Type');

1873: -- specified
1874: --------------------------------------------------------------------------------------
1875:
1876: wsh_del_oi_core.println(' ');
1877: wsh_del_oi_core.println('Validating Freight Charge Type');
1878: wsh_del_oi_core.println(' ');
1879: error_code := '0';
1880: wsh_oi_validate.freight_charge_type(fcrec.freight_charge_type_id ,
1881: fcrec.freight_charge_type_desc ,

Line 1878: wsh_del_oi_core.println(' ');

1874: --------------------------------------------------------------------------------------
1875:
1876: wsh_del_oi_core.println(' ');
1877: wsh_del_oi_core.println('Validating Freight Charge Type');
1878: wsh_del_oi_core.println(' ');
1879: error_code := '0';
1880: wsh_oi_validate.freight_charge_type(fcrec.freight_charge_type_id ,
1881: fcrec.freight_charge_type_desc ,
1882: x_type_id , -- Return valid Freight Charge Type ID

Line 1886: wsh_del_oi_core.println(' ');

1882: x_type_id , -- Return valid Freight Charge Type ID
1883: error_code );
1884:
1885: if (error_code <> '0' ) then
1886: wsh_del_oi_core.println(' ');
1887: wsh_del_oi_core.println('Invalid Freight Charge');
1888: wsh_del_oi_core.println(' ');
1889: FND_MESSAGE.set_name('OE', error_code);
1890: raise stop_fc_processing;

Line 1887: wsh_del_oi_core.println('Invalid Freight Charge');

1883: error_code );
1884:
1885: if (error_code <> '0' ) then
1886: wsh_del_oi_core.println(' ');
1887: wsh_del_oi_core.println('Invalid Freight Charge');
1888: wsh_del_oi_core.println(' ');
1889: FND_MESSAGE.set_name('OE', error_code);
1890: raise stop_fc_processing;
1891: end if;

Line 1888: wsh_del_oi_core.println(' ');

1884:
1885: if (error_code <> '0' ) then
1886: wsh_del_oi_core.println(' ');
1887: wsh_del_oi_core.println('Invalid Freight Charge');
1888: wsh_del_oi_core.println(' ');
1889: FND_MESSAGE.set_name('OE', error_code);
1890: raise stop_fc_processing;
1891: end if;
1892:

Line 1898: wsh_del_oi_core.println(' ');

1894: -- Validate the currency code, when at least the currency code or name, have
1895: -- to be specified
1896: ----------------------------------------------------------------------------
1897:
1898: wsh_del_oi_core.println(' ');
1899: wsh_del_oi_core.println('Validating Freight Charge Currency');
1900: wsh_del_oi_core.println(' ');
1901: error_code := '0' ;
1902: wsh_oi_validate.frt_currency_code(fcrec.currency_code ,

Line 1899: wsh_del_oi_core.println('Validating Freight Charge Currency');

1895: -- to be specified
1896: ----------------------------------------------------------------------------
1897:
1898: wsh_del_oi_core.println(' ');
1899: wsh_del_oi_core.println('Validating Freight Charge Currency');
1900: wsh_del_oi_core.println(' ');
1901: error_code := '0' ;
1902: wsh_oi_validate.frt_currency_code(fcrec.currency_code ,
1903: fcrec.currency_name ,

Line 1900: wsh_del_oi_core.println(' ');

1896: ----------------------------------------------------------------------------
1897:
1898: wsh_del_oi_core.println(' ');
1899: wsh_del_oi_core.println('Validating Freight Charge Currency');
1900: wsh_del_oi_core.println(' ');
1901: error_code := '0' ;
1902: wsh_oi_validate.frt_currency_code(fcrec.currency_code ,
1903: fcrec.currency_name ,
1904: fcrec.amount,

Line 1910: wsh_del_oi_core.println(' ');

1906: valid_cur_name,
1907: error_code );
1908:
1909: if error_code <> '0' then
1910: wsh_del_oi_core.println(' ');
1911: wsh_del_oi_core.println('Invalid Freight Charge Currency');
1912: wsh_del_oi_core.println(' ');
1913: -- message already on the error stack
1914: raise stop_fc_processing;

Line 1911: wsh_del_oi_core.println('Invalid Freight Charge Currency');

1907: error_code );
1908:
1909: if error_code <> '0' then
1910: wsh_del_oi_core.println(' ');
1911: wsh_del_oi_core.println('Invalid Freight Charge Currency');
1912: wsh_del_oi_core.println(' ');
1913: -- message already on the error stack
1914: raise stop_fc_processing;
1915: end if;

Line 1912: wsh_del_oi_core.println(' ');

1908:
1909: if error_code <> '0' then
1910: wsh_del_oi_core.println(' ');
1911: wsh_del_oi_core.println('Invalid Freight Charge Currency');
1912: wsh_del_oi_core.println(' ');
1913: -- message already on the error stack
1914: raise stop_fc_processing;
1915: end if;
1916:

Line 1922: wsh_del_oi_core.println(' ');

1918: -- Validate if the Freight Charge Currency is the same as the Delivery
1919: -- Currency
1920: ----------------------------------------------------------------------------
1921:
1922: wsh_del_oi_core.println(' ');
1923: wsh_del_oi_core.println('Validating if Delivery Currency is same as Freight Charge Currency');
1924: wsh_del_oi_core.println(' ');
1925: error_code := '0';
1926:

Line 1923: wsh_del_oi_core.println('Validating if Delivery Currency is same as Freight Charge Currency');

1919: -- Currency
1920: ----------------------------------------------------------------------------
1921:
1922: wsh_del_oi_core.println(' ');
1923: wsh_del_oi_core.println('Validating if Delivery Currency is same as Freight Charge Currency');
1924: wsh_del_oi_core.println(' ');
1925: error_code := '0';
1926:
1927: if nvl(valid_cur_code,'') <> nvl(x_del_currency,'') then

Line 1924: wsh_del_oi_core.println(' ');

1920: ----------------------------------------------------------------------------
1921:
1922: wsh_del_oi_core.println(' ');
1923: wsh_del_oi_core.println('Validating if Delivery Currency is same as Freight Charge Currency');
1924: wsh_del_oi_core.println(' ');
1925: error_code := '0';
1926:
1927: if nvl(valid_cur_code,'') <> nvl(x_del_currency,'') then
1928: wsh_del_oi_core.println(' ');

Line 1928: wsh_del_oi_core.println(' ');

1924: wsh_del_oi_core.println(' ');
1925: error_code := '0';
1926:
1927: if nvl(valid_cur_code,'') <> nvl(x_del_currency,'') then
1928: wsh_del_oi_core.println(' ');
1929: wsh_del_oi_core.println('Delivery Currency is not the same as Freight Charge Currency');
1930: wsh_del_oi_core.println(' ');
1931: fnd_message.set_name('OE','WSH_OI_CURRENCY_NOT_SAME'); -- Error Message Not Defined
1932: raise stop_fc_processing;

Line 1929: wsh_del_oi_core.println('Delivery Currency is not the same as Freight Charge Currency');

1925: error_code := '0';
1926:
1927: if nvl(valid_cur_code,'') <> nvl(x_del_currency,'') then
1928: wsh_del_oi_core.println(' ');
1929: wsh_del_oi_core.println('Delivery Currency is not the same as Freight Charge Currency');
1930: wsh_del_oi_core.println(' ');
1931: fnd_message.set_name('OE','WSH_OI_CURRENCY_NOT_SAME'); -- Error Message Not Defined
1932: raise stop_fc_processing;
1933: end if;

Line 1930: wsh_del_oi_core.println(' ');

1926:
1927: if nvl(valid_cur_code,'') <> nvl(x_del_currency,'') then
1928: wsh_del_oi_core.println(' ');
1929: wsh_del_oi_core.println('Delivery Currency is not the same as Freight Charge Currency');
1930: wsh_del_oi_core.println(' ');
1931: fnd_message.set_name('OE','WSH_OI_CURRENCY_NOT_SAME'); -- Error Message Not Defined
1932: raise stop_fc_processing;
1933: end if;
1934:

Line 1944: wsh_del_oi_core.println(' ');

1940: -- only the sequence_number of the container has been specified, and it does not
1941: -- exist in WSH_PACKED_CONTAINERS table, then it is a validation error as well.
1942: ----------------------------------------------------------------------------------
1943:
1944: wsh_del_oi_core.println(' ');
1945: wsh_del_oi_core.println('Validating Freight Charge Container');
1946: wsh_del_oi_core.println(' ');
1947: error_code := '0' ;
1948: x_container_id := NULL ;

Line 1945: wsh_del_oi_core.println('Validating Freight Charge Container');

1941: -- exist in WSH_PACKED_CONTAINERS table, then it is a validation error as well.
1942: ----------------------------------------------------------------------------------
1943:
1944: wsh_del_oi_core.println(' ');
1945: wsh_del_oi_core.println('Validating Freight Charge Container');
1946: wsh_del_oi_core.println(' ');
1947: error_code := '0' ;
1948: x_container_id := NULL ;
1949:

Line 1946: wsh_del_oi_core.println(' ');

1942: ----------------------------------------------------------------------------------
1943:
1944: wsh_del_oi_core.println(' ');
1945: wsh_del_oi_core.println('Validating Freight Charge Container');
1946: wsh_del_oi_core.println(' ');
1947: error_code := '0' ;
1948: x_container_id := NULL ;
1949:
1950: wsh_oi_validate.container(fcrec.container_id,

Line 1957: wsh_del_oi_core.println(' ');

1953: x_container_id,
1954: error_code);
1955:
1956: if error_code <> '0' then
1957: wsh_del_oi_core.println(' ');
1958: wsh_del_oi_core.println('Invalid Freight Charge Container');
1959: wsh_del_oi_core.println(' ');
1960: fnd_message.set_name('OE',error_code);
1961: raise stop_fc_processing;

Line 1958: wsh_del_oi_core.println('Invalid Freight Charge Container');

1954: error_code);
1955:
1956: if error_code <> '0' then
1957: wsh_del_oi_core.println(' ');
1958: wsh_del_oi_core.println('Invalid Freight Charge Container');
1959: wsh_del_oi_core.println(' ');
1960: fnd_message.set_name('OE',error_code);
1961: raise stop_fc_processing;
1962: end if;

Line 1959: wsh_del_oi_core.println(' ');

1955:
1956: if error_code <> '0' then
1957: wsh_del_oi_core.println(' ');
1958: wsh_del_oi_core.println('Invalid Freight Charge Container');
1959: wsh_del_oi_core.println(' ');
1960: fnd_message.set_name('OE',error_code);
1961: raise stop_fc_processing;
1962: end if;
1963:

Line 1968: wsh_del_oi_core.println(' ');

1964: ----------------------------------------------------------------------------------
1965: -- Validate if the Freight Charge Amount is Negative or Zero
1966: ----------------------------------------------------------------------------------
1967:
1968: wsh_del_oi_core.println(' ');
1969: wsh_del_oi_core.println('Validating Freight Charge Amount');
1970: wsh_del_oi_core.println(' ');
1971: error_code := '0' ;
1972: wsh_oi_validate.qty(fcrec.amount, error_code );

Line 1969: wsh_del_oi_core.println('Validating Freight Charge Amount');

1965: -- Validate if the Freight Charge Amount is Negative or Zero
1966: ----------------------------------------------------------------------------------
1967:
1968: wsh_del_oi_core.println(' ');
1969: wsh_del_oi_core.println('Validating Freight Charge Amount');
1970: wsh_del_oi_core.println(' ');
1971: error_code := '0' ;
1972: wsh_oi_validate.qty(fcrec.amount, error_code );
1973:

Line 1970: wsh_del_oi_core.println(' ');

1966: ----------------------------------------------------------------------------------
1967:
1968: wsh_del_oi_core.println(' ');
1969: wsh_del_oi_core.println('Validating Freight Charge Amount');
1970: wsh_del_oi_core.println(' ');
1971: error_code := '0' ;
1972: wsh_oi_validate.qty(fcrec.amount, error_code );
1973:
1974: if error_code <> '0' then

Line 1975: wsh_del_oi_core.println(' ');

1971: error_code := '0' ;
1972: wsh_oi_validate.qty(fcrec.amount, error_code );
1973:
1974: if error_code <> '0' then
1975: wsh_del_oi_core.println(' ');
1976: wsh_del_oi_core.println('Invalid Freight Charge Amount. Either Negative or Zero');
1977: wsh_del_oi_core.println(' ');
1978: fnd_message.set_name('OE',error_code);
1979: raise stop_fc_processing;

Line 1976: wsh_del_oi_core.println('Invalid Freight Charge Amount. Either Negative or Zero');

1972: wsh_oi_validate.qty(fcrec.amount, error_code );
1973:
1974: if error_code <> '0' then
1975: wsh_del_oi_core.println(' ');
1976: wsh_del_oi_core.println('Invalid Freight Charge Amount. Either Negative or Zero');
1977: wsh_del_oi_core.println(' ');
1978: fnd_message.set_name('OE',error_code);
1979: raise stop_fc_processing;
1980: end if;

Line 1977: wsh_del_oi_core.println(' ');

1973:
1974: if error_code <> '0' then
1975: wsh_del_oi_core.println(' ');
1976: wsh_del_oi_core.println('Invalid Freight Charge Amount. Either Negative or Zero');
1977: wsh_del_oi_core.println(' ');
1978: fnd_message.set_name('OE',error_code);
1979: raise stop_fc_processing;
1980: end if;
1981:

Line 1986: wsh_del_oi_core.println(' ');

1982: --------------------------------------------------------------------------------
1983: -- Validate for Duplicate AETCs, this is a check specifically for Automotive
1984: --------------------------------------------------------------------------------
1985:
1986: wsh_del_oi_core.println(' ');
1987: wsh_del_oi_core.println('Validating if this Delivery has a Duplicate AETC');
1988: wsh_del_oi_core.println(' ');
1989: error_code := '0' ;
1990: wsh_oi_validate.duplicate_aetc(fcrec.ac_attribute_category ,

Line 1987: wsh_del_oi_core.println('Validating if this Delivery has a Duplicate AETC');

1983: -- Validate for Duplicate AETCs, this is a check specifically for Automotive
1984: --------------------------------------------------------------------------------
1985:
1986: wsh_del_oi_core.println(' ');
1987: wsh_del_oi_core.println('Validating if this Delivery has a Duplicate AETC');
1988: wsh_del_oi_core.println(' ');
1989: error_code := '0' ;
1990: wsh_oi_validate.duplicate_aetc(fcrec.ac_attribute_category ,
1991: x_delivery_id, error_code );

Line 1988: wsh_del_oi_core.println(' ');

1984: --------------------------------------------------------------------------------
1985:
1986: wsh_del_oi_core.println(' ');
1987: wsh_del_oi_core.println('Validating if this Delivery has a Duplicate AETC');
1988: wsh_del_oi_core.println(' ');
1989: error_code := '0' ;
1990: wsh_oi_validate.duplicate_aetc(fcrec.ac_attribute_category ,
1991: x_delivery_id, error_code );
1992:

Line 1994: wsh_del_oi_core.println(' ');

1990: wsh_oi_validate.duplicate_aetc(fcrec.ac_attribute_category ,
1991: x_delivery_id, error_code );
1992:
1993: if error_code <> '0' then
1994: wsh_del_oi_core.println(' ');
1995: wsh_del_oi_core.println('This Delivery has a Duplicate AETC');
1996: wsh_del_oi_core.println(' ');
1997: fnd_message.set_name('OE',error_code);
1998: raise stop_fc_processing;

Line 1995: wsh_del_oi_core.println('This Delivery has a Duplicate AETC');

1991: x_delivery_id, error_code );
1992:
1993: if error_code <> '0' then
1994: wsh_del_oi_core.println(' ');
1995: wsh_del_oi_core.println('This Delivery has a Duplicate AETC');
1996: wsh_del_oi_core.println(' ');
1997: fnd_message.set_name('OE',error_code);
1998: raise stop_fc_processing;
1999: end if;

Line 1996: wsh_del_oi_core.println(' ');

1992:
1993: if error_code <> '0' then
1994: wsh_del_oi_core.println(' ');
1995: wsh_del_oi_core.println('This Delivery has a Duplicate AETC');
1996: wsh_del_oi_core.println(' ');
1997: fnd_message.set_name('OE',error_code);
1998: raise stop_fc_processing;
1999: end if;
2000:

Line 2021: wsh_del_oi_core.println(' ');

2017: and h.header_id = x_order_header_id;
2018:
2019: if SQL%NOTFOUND then
2020: -- fail transaction
2021: wsh_del_oi_core.println(' ');
2022: wsh_del_oi_core.println('Process failed while selecting order header id');
2023: wsh_del_oi_core.println(' ');
2024: fnd_message.set_name('OE',error_code);
2025: raise stop_fc_processing;

Line 2022: wsh_del_oi_core.println('Process failed while selecting order header id');

2018:
2019: if SQL%NOTFOUND then
2020: -- fail transaction
2021: wsh_del_oi_core.println(' ');
2022: wsh_del_oi_core.println('Process failed while selecting order header id');
2023: wsh_del_oi_core.println(' ');
2024: fnd_message.set_name('OE',error_code);
2025: raise stop_fc_processing;
2026: end if;

Line 2023: wsh_del_oi_core.println(' ');

2019: if SQL%NOTFOUND then
2020: -- fail transaction
2021: wsh_del_oi_core.println(' ');
2022: wsh_del_oi_core.println('Process failed while selecting order header id');
2023: wsh_del_oi_core.println(' ');
2024: fnd_message.set_name('OE',error_code);
2025: raise stop_fc_processing;
2026: end if;
2027: end if;

Line 2030: wsh_del_oi_core.println(' ');

2026: end if;
2027: end if;
2028:
2029: --------------------------------------------------------------------------------
2030: wsh_del_oi_core.println(' ');
2031: wsh_del_oi_core.println('Creating a new Freight Charges record');
2032: wsh_del_oi_core.println(' ');
2033: --------------------------------------------------------------------------------
2034:

Line 2031: wsh_del_oi_core.println('Creating a new Freight Charges record');

2027: end if;
2028:
2029: --------------------------------------------------------------------------------
2030: wsh_del_oi_core.println(' ');
2031: wsh_del_oi_core.println('Creating a new Freight Charges record');
2032: wsh_del_oi_core.println(' ');
2033: --------------------------------------------------------------------------------
2034:
2035: begin

Line 2032: wsh_del_oi_core.println(' ');

2028:
2029: --------------------------------------------------------------------------------
2030: wsh_del_oi_core.println(' ');
2031: wsh_del_oi_core.println('Creating a new Freight Charges record');
2032: wsh_del_oi_core.println(' ');
2033: --------------------------------------------------------------------------------
2034:
2035: begin
2036: INSERT INTO SO_FREIGHT_CHARGES(

Line 2097: wsh_del_oi_core.println(' ');

2093: APP_EXCEPTION.Raise_Exception;
2094: EXIT;
2095:
2096: if ( sql%found ) then
2097: wsh_del_oi_core.println(' ');
2098: wsh_del_oi_core.println('Freight Charge record created successfully');
2099: wsh_del_oi_core.println(' ');
2100: end if ;
2101:

Line 2098: wsh_del_oi_core.println('Freight Charge record created successfully');

2094: EXIT;
2095:
2096: if ( sql%found ) then
2097: wsh_del_oi_core.println(' ');
2098: wsh_del_oi_core.println('Freight Charge record created successfully');
2099: wsh_del_oi_core.println(' ');
2100: end if ;
2101:
2102: end;

Line 2099: wsh_del_oi_core.println(' ');

2095:
2096: if ( sql%found ) then
2097: wsh_del_oi_core.println(' ');
2098: wsh_del_oi_core.println('Freight Charge record created successfully');
2099: wsh_del_oi_core.println(' ');
2100: end if ;
2101:
2102: end;
2103:

Line 2107: wsh_del_oi_core.println('DELETED freight_charge_type_id = '||to_char(fcrec.freight_charge_type_id));

2103:
2104: DELETE from wsh_freight_charges_interface
2105: WHERE freight_charge_type_id = fcrec.freight_charge_type_id and rowid = fcrec.char_rowid;
2106:
2107: wsh_del_oi_core.println('DELETED freight_charge_type_id = '||to_char(fcrec.freight_charge_type_id));
2108:
2109: COMMIT;
2110:
2111: END LOOP;

Line 2125: wsh_del_oi_core.println('msg ='|| return_msg1);

2121: null;
2122:
2123: when others then
2124: return_msg1 := FND_MESSAGE.get;
2125: wsh_del_oi_core.println('msg ='|| return_msg1);
2126: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
2127: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.insert_freight_charges');
2128: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
2129: FND_MESSAGE.Set_Token('ORA_TEXT','Insert statement');