DBA Data[Home] [Help]

APPS.WSH_SC_TRX_INTERFACE dependencies on WSH_OI_VALIDATE

Line 1034: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, oirec.warehouse_id, 'WAREHOUSE', error_code);

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);
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(' ');

Line 1055: wsh_oi_validate.not_equal(oirec.sopld_warehouse_id, x_warehouse_id, 'WAREHOUSE', error_code);

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);
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(' ');

Line 1084: wsh_oi_validate.inventory_item(oirec.item_id, oirec.item_concat_segments,

1080: seg_array(11) := oirec.item_segment11; seg_array(12) := oirec.item_segment12;
1081: seg_array(13) := oirec.item_segment13; seg_array(14) := oirec.item_segment14;
1082: seg_array(15) := oirec.item_segment15;
1083:
1084: wsh_oi_validate.inventory_item(oirec.item_id, oirec.item_concat_segments,
1085: oirec.warehouse_id, oirec.sopld_item_id,
1086: valid_item_id, seg_array, error_code);
1087:
1088: if error_code <> '0' then

Line 1106: wsh_oi_validate.changed_item_org(oirec.warehouse_id,

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,
1108: valid_item_id,
1109: last_item_id,
1110: X_subinv_restricted_flag,

Line 1134: wsh_oi_validate.qty(oirec.shipped_quantity, error_code);

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:
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 ');

Line 1174: wsh_oi_validate.res_inv_ctrl_change(oirec.lot_number, oirec.sopld_lot_number,

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,
1175: oirec.revision, oirec.sopld_revision,
1176: oirec.subinventory, oirec.sopld_subinventory,
1177: oirec.locator_id, oirec.sopld_locator_id,
1178: error_code);

Line 1243: wsh_oi_validate.pld_subinventory(oirec.subinventory,

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,
1245: valid_warehouse_id,
1246: valid_item_id,
1247: X_subinv_restricted_flag,

Line 1268: wsh_oi_validate.pld_lot_number(oirec.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,
1270: oirec.sopld_lot_number,
1271: valid_warehouse_id,
1272: valid_item_id,

Line 1293: wsh_oi_validate.pld_revision(oirec.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,
1295: valid_warehouse_id,
1296: valid_item_id,
1297: valid_revision,

Line 1319: wsh_oi_validate.pld_item_location(valid_warehouse_id,

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,
1321: valid_item_id,
1322: last_item_id,
1323: valid_sub,

Line 1358: wsh_oi_validate.pld_locator(oirec.locator_id,

1354: seg_array(13) := oirec.loc_segment13; seg_array(14) := oirec.loc_segment14;
1355: seg_array(15) := oirec.loc_segment15;
1356:
1357: dbms_output.enable(1000000);
1358: wsh_oi_validate.pld_locator(oirec.locator_id,
1359: oirec.sopld_locator_id,
1360: valid_loc,
1361: default_loc,
1362: oirec.locator_concat_segments,

Line 1394: wsh_oi_validate.pld_serial_number(oirec.sn,

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,
1396: oirec.shipped_quantity,
1397: valid_warehouse_id,
1398: valid_item_id,

Line 1427: wsh_oi_validate.container(oirec.container_id,

1423: wsh_del_oi_core.println(' ');
1424: error_line := 220;
1425: error_code := '0';
1426:
1427: wsh_oi_validate.container(oirec.container_id,
1428: oirec.container_sequence,
1429: x_delivery_id,
1430: x_container_id,
1431: error_code);

Line 1449: wsh_oi_validate.pld_line_add(x_delivery_id,

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,
1451: del_status,
1452: result,
1453: result_num,

Line 1858: wsh_oi_validate.if_ar_intfaced(x_delivery_id, error_code );

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:
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');

Line 1880: wsh_oi_validate.freight_charge_type(fcrec.freight_charge_type_id ,

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
1883: error_code );
1884:

Line 1902: wsh_oi_validate.frt_currency_code(fcrec.currency_code ,

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,
1905: valid_cur_code, -- Return valid Currency Code
1906: valid_cur_name,

Line 1950: wsh_oi_validate.container(fcrec.container_id,

1946: wsh_del_oi_core.println(' ');
1947: error_code := '0' ;
1948: x_container_id := NULL ;
1949:
1950: wsh_oi_validate.container(fcrec.container_id,
1951: fcrec.container_sequence,
1952: x_delivery_id,
1953: x_container_id,
1954: error_code);

Line 1972: wsh_oi_validate.qty(fcrec.amount, error_code );

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
1975: wsh_del_oi_core.println(' ');
1976: wsh_del_oi_core.println('Invalid Freight Charge Amount. Either Negative or Zero');

Line 1990: wsh_oi_validate.duplicate_aetc(fcrec.ac_attribute_category ,

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:
1993: if error_code <> '0' then
1994: wsh_del_oi_core.println(' ');