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.INV_LOC_WMS_PUB dependencies on FND_API

Line 119: x_return_status := fnd_api.g_ret_sts_success;

115: l_null_date_val DATE;
116: l_global_nsegments NUMBER := 0;
117: col NUMBER;
118: BEGIN
119: x_return_status := fnd_api.g_ret_sts_success;
120: SAVEPOINT get_lot_attr_information;
121:
122: /* Populate the flex field record */
123:

Line 167: RAISE fnd_api.g_exc_error;

163: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
164: fnd_message.set_token('CONTEXT', 'NULL');
165: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
166: fnd_msg_pub.ADD;
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
170: FOR i IN 1 .. l_nsegments LOOP
171: l_enabled_seg_name(v_index) := l_segments_dr.application_column_name(i);

Line 176: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR

172: IF l_segments_dr.is_required(i) THEN
173: col := SUBSTR(l_segments_dr.application_column_name(i)
174: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9);
175: --DBMS_output.put_line('col is ' || col);
176: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR
177: NOT p_attributes_tbl.EXISTS(col))
178: THEN
179: --DBMS_output.put_line('y r we here');
180: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');

Line 183: RAISE fnd_api.g_exc_error;

179: --DBMS_output.put_line('y r we here');
180: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
181: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: END IF;
185: ELSE
186: --DBMS_output.put_line('This segment is not required');
187: NULL;

Line 256: RAISE fnd_api.g_exc_error;

252: THEN
253: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
254: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
255: fnd_msg_pub.ADD;
256: RAISE fnd_api.g_exc_error;
257: --DBMS_output.put_line('Req segment is not populated');
258: END IF;
259: END IF;
260:

Line 303: x_return_status := fnd_api.g_ret_sts_error;

299: --END IF; /* p_attribute_category IS NOT NULL */
300:
301: EXCEPTION
302: WHEN errors_received THEN
303: x_return_status := fnd_api.g_ret_sts_error;
304: error_msg := fnd_flex_descval.error_message;
305: s := 1;
306: e := 200;
307:

Line 320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

316: e := e + 200;
317: END LOOP;
318:
319: ROLLBACK TO get_lot_attr_information;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 321: WHEN fnd_api.g_exc_error THEN

317: END LOOP;
318:
319: ROLLBACK TO get_lot_attr_information;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN

Line 322: x_return_status := fnd_api.g_ret_sts_error;

318:
319: ROLLBACK TO get_lot_attr_information;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 325: WHEN fnd_api.g_exc_unexpected_error THEN

321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN

Line 326: x_return_status := fnd_api.g_ret_sts_unexp_error;

322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: ROLLBACK TO get_lot_attr_information;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 330: x_return_status := fnd_api.g_ret_sts_unexp_error;

326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: ROLLBACK TO get_lot_attr_information;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
333: --DBMS_output.put_line('Error ' || SQLERRM);
334: END validate_loc_attr_info;

Line 332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: ROLLBACK TO get_lot_attr_information;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
333: --DBMS_output.put_line('Error ' || SQLERRM);
334: END validate_loc_attr_info;
335:
336:

Line 530: x_return_status := fnd_api.g_ret_sts_success;

526:
527: SAVEPOINT locator_insert;
528:
529: -- Initialize return status to success
530: x_return_status := fnd_api.g_ret_sts_success;
531:
532: IF l_debug = 1 THEN
533: debug(l_procedure_name);
534: END IF;

Line 561: RAISE fnd_api.g_exc_error;

557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
560: fnd_msg_pub.ADD;
561: RAISE fnd_api.g_exc_error;
562: END;
563:
564: ELSE -- p_organization_id is NULL
565:

Line 570: RAISE fnd_api.g_exc_error;

566: IF p_organization_code IS NULL THEN
567:
568: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
569: fnd_msg_pub.ADD;
570: RAISE fnd_api.g_exc_error;
571:
572: ELSE -- p_organization_code is NULL
573:
574: BEGIN

Line 587: RAISE fnd_api.g_exc_error;

583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END;
589:
590: END IF; -- p_organization_code is NULL
591:

Line 608: RAISE fnd_api.g_exc_error;

604: IF p_subinventory_code IS NULL THEN
605:
606: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
607: fnd_msg_pub.ADD;
608: RAISE fnd_api.g_exc_error;
609:
610: ELSE -- p_subinventory_code is NULL
611:
612: BEGIN

Line 631: RAISE fnd_api.g_exc_error;

627:
628: WHEN NO_DATA_FOUND THEN
629: fnd_message.set_name('INV', 'INVALID_SUB');
630: fnd_msg_pub.ADD;
631: RAISE fnd_api.g_exc_error;
632:
633: END;
634:
635: END IF; -- p_subinventory_code is NULL

Line 645: RAISE fnd_api.g_exc_error;

641: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
642: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
643: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
644: fnd_msg_pub.ADD;
645: RAISE fnd_api.g_exc_error;
646: END IF;
647:
648: /*
649: * Valiate Loator alias

Line 661: RAISE fnd_api.g_exc_error;

657: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
658:
659: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
660: fnd_msg_pub.ADD;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
664:
665: IF NVL(l_alias_enabled, 'N') <> 'Y' THEN

Line 687: RAISE fnd_api.g_exc_error;

683:
684: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
685: fnd_message.set_token('LOCATOR', l_locator);
686: fnd_msg_pub.ADD;
687: RAISE fnd_api.g_exc_error;
688:
689: EXCEPTION
690: WHEN NO_DATA_FOUND THEN
691: NULL;

Line 711: RAISE fnd_api.g_exc_error;

707:
708: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
709: fnd_message.set_token('LOCATOR', l_locator);
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_error;
712:
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN
715: NULL;

Line 733: RAISE fnd_api.g_exc_error;

729: IF p_concatenated_segments IS NULL THEN
730:
731: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
732: fnd_msg_pub.ADD;
733: RAISE fnd_api.g_exc_error;
734:
735: END IF;
736:
737: /*

Line 751: ( p_encoded => FND_API.G_FALSE,

747: x_locator_exists:= 'Y';
748: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
749: fnd_msg_pub.add;
750: fnd_msg_pub.count_and_get
751: ( p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755: return;

Line 779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

775: x_locator_exists := 'Y';
776: x_inventory_location_id := fnd_flex_keyval.combination_id;
777: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
782: END;
783:

Line 799: RAISE fnd_api.g_exc_error;

795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN
797: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
798: fnd_msg_pub.ADD;
799: RAISE fnd_api.g_exc_error;
800: END;
801: END IF;
802:
803: IF (p_location_weight_uom_code IS NOT NULL) THEN

Line 813: RAISE fnd_api.g_exc_error;

809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
812: fnd_msg_pub.ADD;
813: RAISE fnd_api.g_exc_error;
814: END;
815: END IF;
816:
817: /* Validate Location volume uom code */

Line 830: RAISE fnd_api.g_exc_error;

826: EXCEPTION
827: WHEN NO_DATA_FOUND THEN
828: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
829: fnd_msg_pub.ADD;
830: RAISE fnd_api.g_exc_error;
831: END;
832: END IF;
833:
834: --DBMS_output.put_line('Before validating the pick uom ');

Line 845: RAISE fnd_api.g_exc_error;

841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
844: fnd_msg_pub.ADD;
845: RAISE fnd_api.g_exc_error;
846: END;
847: END IF;
848:
849: /* Validate Dimension uom code */

Line 862: RAISE fnd_api.g_exc_error;

858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
860: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
861: fnd_msg_pub.ADD;
862: RAISE fnd_api.g_exc_error;
863: END;
864: END IF;
865:
866: --DBMS_output.put_line('Before check whether locator exists ');

Line 904: /* If the value of l_validity_check is PASSED, call FND API to

900: --DBMS_output.put_line('In validity check in no data found ');
901: NULL;
902: END;
903:
904: /* If the value of l_validity_check is PASSED, call FND API to
905: create locator
906: */
907: IF l_validity_check = 'PASSED' THEN
908: --DBMS_output.put_line('Org id:' || to_char(l_organization_id));

Line 932: RAISE fnd_api.g_exc_unexpected_error;

928: IF (l_keystat_val = FALSE) THEN
929: --DBMS_output.put_line('validate segment failed ');
930: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
931: fnd_msg_pub.ADD;
932: RAISE fnd_api.g_exc_unexpected_error;
933: ELSE
934: x_inventory_location_id := fnd_flex_keyval.combination_id;
935:
936: IF fnd_flex_keyval.new_combination THEN

Line 974: RAISE fnd_api.g_exc_unexpected_error;

970: ELSE
971: --DBMS_output.put_line('Wms installed check failed ');
972: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
973: fnd_msg_pub.ADD;
974: RAISE fnd_api.g_exc_unexpected_error;
975: END IF;
976:
977: --Bug Number 5606275
978: BEGIN

Line 998: RAISE fnd_api.g_exc_error;

994: IF( l_project_control_level =2 AND l_segment20 IS NULL AND l_segment19 is NOT NULL) THEN
995:
996: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
997: fnd_msg_pub.ADD;
998: RAISE fnd_api.g_exc_error;
999: END IF;
1000: END IF;
1001: /*bug14298387,added the validation for logic locator without the physical locator id passed*/
1002: IF(l_project_reference_enabled = 'Y' AND (l_segment19 IS NOT NULL OR l_segment20 IS NOT NULL)) THEN

Line 1006: RAISE fnd_api.g_exc_error;

1002: IF(l_project_reference_enabled = 'Y' AND (l_segment19 IS NOT NULL OR l_segment20 IS NOT NULL)) THEN
1003: IF (Nvl(p_physical_location_id,-1) = -1) THEN
1004: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1005: fnd_msg_pub.ADD;
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: --validate the phy locator id
1009: l_phy_loc_concat_segments := INV_PROJECT.GET_LOCSEGS(p_physical_location_id,l_organization_id);
1010: IF (l_phy_loc_concat_segments <> l_physical_concat_seg) THEN

Line 1013: RAISE fnd_api.g_exc_error;

1009: l_phy_loc_concat_segments := INV_PROJECT.GET_LOCSEGS(p_physical_location_id,l_organization_id);
1010: IF (l_phy_loc_concat_segments <> l_physical_concat_seg) THEN
1011: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1012: fnd_msg_pub.ADD;
1013: RAISE fnd_api.g_exc_error;
1014: END IF;
1015: END IF;
1016: END IF;
1017: --bug14298387 end

Line 1102: RAISE fnd_api.g_exc_error;

1098: IF l_return_status = 'E' THEN
1099: --DBMS_output.put_line('Error from validate_loc_attr_info');
1100: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1101: fnd_msg_pub.ADD;
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1105: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1106: fnd_msg_pub.ADD;

Line 1107: RAISE fnd_api.g_exc_unexpected_error;

1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1105: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1106: fnd_msg_pub.ADD;
1107: RAISE fnd_api.g_exc_unexpected_error;
1108: END IF;
1109: /* End locator DFF attributes validation */
1110:
1111: --DBMS_output.put_line('finished calling validate_loc_attr_info');

Line 1183: RAISE fnd_api.g_exc_error;

1179: END IF; -- (l_keystat_val = FALSE)
1180: ELSE
1181: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1182: fnd_msg_pub.ADD;
1183: RAISE fnd_api.g_exc_error;
1184: END IF; -- (l_validility = passed)
1185:
1186: EXCEPTION
1187: WHEN fnd_api.g_exc_error THEN

Line 1187: WHEN fnd_api.g_exc_error THEN

1183: RAISE fnd_api.g_exc_error;
1184: END IF; -- (l_validility = passed)
1185:
1186: EXCEPTION
1187: WHEN fnd_api.g_exc_error THEN
1188: x_return_status := 'E';
1189: ROLLBACK TO locator_insert;
1190: debug(l_procedure_name ||' Expected Error ');
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1187: WHEN fnd_api.g_exc_error THEN
1188: x_return_status := 'E';
1189: ROLLBACK TO locator_insert;
1190: debug(l_procedure_name ||' Expected Error ');
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1192: WHEN fnd_api.g_exc_unexpected_error THEN
1193: x_return_status := 'U';
1194: ROLLBACK TO locator_insert;
1195: debug(l_procedure_name ||' Unxpected Error ');

Line 1192: WHEN fnd_api.g_exc_unexpected_error THEN

1188: x_return_status := 'E';
1189: ROLLBACK TO locator_insert;
1190: debug(l_procedure_name ||' Expected Error ');
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1192: WHEN fnd_api.g_exc_unexpected_error THEN
1193: x_return_status := 'U';
1194: ROLLBACK TO locator_insert;
1195: debug(l_procedure_name ||' Unxpected Error ');
1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1192: WHEN fnd_api.g_exc_unexpected_error THEN
1193: x_return_status := 'U';
1194: ROLLBACK TO locator_insert;
1195: debug(l_procedure_name ||' Unxpected Error ');
1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1197: WHEN OTHERS THEN
1198: x_return_status := 'U';
1199: --DBMS_output.put_line('In others '||sqlerrm);
1200: ROLLBACK TO locator_insert;

Line 1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1204: END IF;
1205: debug(l_procedure_name ||' Others '||SQLERRM);
1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1207: END create_locator;
1208:
1209: /*
1210: ** ---------------------------------------------------------------------------

Line 1286: ** To update the attribute with NULL, pass fnd_api.g_miss_char

1282: ** For ordering drop-off locators and also to order by putaway
1283: ** drop-off operations (bug 2681871)
1284: ** For the DFF attributes mentioned below, to update correctly use the following strategy
1285: ** To retain the value in the table, do not pass any value OR pass NULL as i/p
1286: ** To update the attribute with NULL, pass fnd_api.g_miss_char
1287: ** To update with any other value, pass the appropriate value
1288: ** p_attribute_category Holds the Context of the Descriptive FlexField for the Locator
1289: ** p_attribute1 Holds the Descriptive FlexField attribute for the Locator
1290: ** p_attribute2 Holds the Descriptive FlexField attribute for the Locator

Line 1398: x_return_status := fnd_api.g_ret_sts_success;

1394: l_procedure_name := 'UPDATE_LOCATOR';
1395: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1396:
1397:
1398: x_return_status := fnd_api.g_ret_sts_success;
1399:
1400: IF l_debug = 1 THEN
1401: debug(l_procedure_name);
1402: END IF;

Line 1421: RAISE fnd_api.g_exc_error;

1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1420: fnd_msg_pub.ADD;
1421: RAISE fnd_api.g_exc_error;
1422: END;
1423:
1424: ELSE -- p_organization_id IS NULL
1425:

Line 1430: RAISE fnd_api.g_exc_error;

1426: IF p_organization_code IS NULL THEN
1427:
1428: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1429: fnd_msg_pub.ADD;
1430: RAISE fnd_api.g_exc_error;
1431:
1432: ELSE -- p_organization_code is NULL
1433:
1434: BEGIN

Line 1445: RAISE fnd_api.g_exc_error;

1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN
1443: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1444: fnd_msg_pub.ADD;
1445: RAISE fnd_api.g_exc_error;
1446: END;
1447:
1448: END IF; -- p_organization_code is NULL
1449:

Line 1461: RAISE fnd_api.g_exc_error;

1457: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1458:
1459: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1460: fnd_msg_pub.ADD;
1461: RAISE fnd_api.g_exc_error;
1462:
1463: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1464:
1465: /* BEGIN

Line 1488: RAISE fnd_api.g_exc_error;

1484:
1485: IF l_val = FALSE THEN
1486: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1487: fnd_msg_pub.ADD;
1488: RAISE fnd_api.g_exc_error;
1489: ELSE
1490: l_inventory_location_id := fnd_flex_keyval.combination_id;
1491: END IF;
1492:

Line 1506: IF (p_inventory_location_type <> fnd_api.g_miss_num AND

1502: /*
1503: * Validate Inventory_Location_Type
1504: */
1505:
1506: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1507: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1508:
1509: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1510: fnd_msg_pub.ADD;

Line 1511: RAISE fnd_api.g_exc_error;

1507: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1508:
1509: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1510: fnd_msg_pub.ADD;
1511: RAISE fnd_api.g_exc_error;
1512:
1513: END IF;
1514:
1515: -- Bug# 4903036: Check that the sub type and locator type are compatible.

Line 1517: IF (p_inventory_location_type <> fnd_api.g_miss_num) THEN

1513: END IF;
1514:
1515: -- Bug# 4903036: Check that the sub type and locator type are compatible.
1516: -- Do this check only if the inventory location type is being updated for the locator.
1517: IF (p_inventory_location_type <> fnd_api.g_miss_num) THEN
1518: -- Retrieve the subinventory type for the sub that the locator is in.
1519: BEGIN
1520: SELECT NVL(msi.subinventory_type, 1)
1521: INTO l_subinventory_type

Line 1531: RAISE fnd_api.g_exc_error;

1527: EXCEPTION
1528: WHEN NO_DATA_FOUND THEN
1529: fnd_message.set_name('INV', 'INVALID_SUB');
1530: fnd_msg_pub.ADD;
1531: RAISE fnd_api.g_exc_error;
1532: END;
1533:
1534: -- If the sub is of type 'Storage', then the locator cannot be of type 'Receiving'.
1535: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.

Line 1541: RAISE fnd_api.g_exc_error;

1537: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1538: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1539: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1540: fnd_msg_pub.ADD;
1541: RAISE fnd_api.g_exc_error;
1542: END IF;
1543: END IF;
1544:
1545:

Line 1582: RAISE fnd_api.g_exc_error;

1578: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1579:
1580: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1581: fnd_msg_pub.ADD;
1582: RAISE fnd_api.g_exc_error;
1583:
1584: END IF;
1585:
1586: IF NVL(l_alias_enabled, 'N') <> 'Y' THEN

Line 1605: RAISE fnd_api.g_exc_error;

1601:
1602: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1603: fnd_message.set_token('LOCATOR', l_locator);
1604: fnd_msg_pub.ADD;
1605: RAISE fnd_api.g_exc_error;
1606:
1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN
1609: NULL;

Line 1628: RAISE fnd_api.g_exc_error;

1624:
1625: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1626: fnd_message.set_token('LOCATOR', l_locator);
1627: fnd_msg_pub.ADD;
1628: RAISE fnd_api.g_exc_error;
1629:
1630: EXCEPTION
1631: WHEN NO_DATA_FOUND THEN
1632: NULL;

Line 1645: IF (p_location_weight_uom_code <> fnd_api.g_miss_char

1641:
1642: /* Validate Location weight uom code */
1643:
1644: --DBMS_output.put_line('Before validating the weight uom ');
1645: IF (p_location_weight_uom_code <> fnd_api.g_miss_char
1646: AND p_location_weight_uom_code IS NOT NULL) THEN
1647: BEGIN
1648: SELECT 1
1649: INTO l_chkflg

Line 1656: RAISE fnd_api.g_exc_error;

1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1655: fnd_msg_pub.ADD;
1656: RAISE fnd_api.g_exc_error;
1657: END;
1658: END IF;
1659:
1660: /* Validate Location volume uom code */

Line 1663: IF (p_volume_uom_code <> fnd_api.g_miss_char

1659:
1660: /* Validate Location volume uom code */
1661: --DBMS_output.put_line('Before validating the volume uom ');
1662:
1663: IF (p_volume_uom_code <> fnd_api.g_miss_char
1664: AND p_volume_uom_code IS NOT NULL) THEN
1665: BEGIN
1666: SELECT 1
1667: INTO l_chkflg

Line 1674: RAISE fnd_api.g_exc_error;

1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1673: fnd_msg_pub.ADD;
1674: RAISE fnd_api.g_exc_error;
1675: END;
1676: END IF;
1677:
1678: /* Validate Location Pick uom code */

Line 1680: IF (p_pick_uom_code <> fnd_api.g_miss_char

1676: END IF;
1677:
1678: /* Validate Location Pick uom code */
1679: --DBMS_output.put_line('Before validating the pick uom ');
1680: IF (p_pick_uom_code <> fnd_api.g_miss_char
1681: AND p_pick_uom_code IS NOT NULL) THEN
1682: BEGIN
1683: SELECT 1
1684: INTO l_chkflg

Line 1691: RAISE fnd_api.g_exc_error;

1687: EXCEPTION
1688: WHEN NO_DATA_FOUND THEN
1689: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1690: fnd_msg_pub.ADD;
1691: RAISE fnd_api.g_exc_error;
1692: END;
1693: END IF;
1694:
1695: /* Validate Dimension uom code */

Line 1698: IF (p_dimension_uom_code <> fnd_api.g_miss_char

1694:
1695: /* Validate Dimension uom code */
1696: --DBMS_output.put_line('Before validating the dim uom ');
1697:
1698: IF (p_dimension_uom_code <> fnd_api.g_miss_char
1699: AND p_dimension_uom_code IS NOT NULL) THEN
1700: BEGIN
1701: SELECT 1
1702: INTO l_chkflg

Line 1709: RAISE fnd_api.g_exc_error;

1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1708: fnd_msg_pub.ADD;
1709: RAISE fnd_api.g_exc_error;
1710: END;
1711: END IF;
1712:
1713: /* Validate Status code */

Line 1715: IF (p_status_id <> fnd_api.g_miss_num

1711: END IF;
1712:
1713: /* Validate Status code */
1714: -- --DBMS_output.put_line('Before validating the status ');
1715: IF (p_status_id <> fnd_api.g_miss_num
1716: AND p_status_id IS NOT NULL) THEN
1717: BEGIN
1718: SELECT 1
1719: INTO l_chkflg

Line 1727: RAISE fnd_api.g_exc_error;

1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN
1725: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1726: fnd_msg_pub.ADD;
1727: RAISE fnd_api.g_exc_error;
1728: END;
1729: END IF;
1730: --DBMS_output.put_line('setting attribs');
1731: /* Validate the locator attributes passed by the user */

Line 1779: IF p_attribute1 = fnd_api.g_miss_char THEN

1775: IF p_attribute15 IS NOT NULL THEN
1776: cnt:=cnt+1;
1777: END IF;
1778:
1779: IF p_attribute1 = fnd_api.g_miss_char THEN
1780: l_inv_attributes_tbl (1) := NULL;
1781: ELSE
1782: l_inv_attributes_tbl (1) := p_attribute1;
1783: END IF;

Line 1784: IF p_attribute2 = fnd_api.g_miss_char THEN

1780: l_inv_attributes_tbl (1) := NULL;
1781: ELSE
1782: l_inv_attributes_tbl (1) := p_attribute1;
1783: END IF;
1784: IF p_attribute2 = fnd_api.g_miss_char THEN
1785: l_inv_attributes_tbl (2) := NULL;
1786: ELSE
1787: l_inv_attributes_tbl (2) := p_attribute2;
1788: END IF;

Line 1790: IF p_attribute3 = fnd_api.g_miss_char THEN

1786: ELSE
1787: l_inv_attributes_tbl (2) := p_attribute2;
1788: END IF;
1789:
1790: IF p_attribute3 = fnd_api.g_miss_char THEN
1791: l_inv_attributes_tbl (3) := NULL;
1792: ELSE
1793: l_inv_attributes_tbl (3) := p_attribute3;
1794: END IF;

Line 1796: IF p_attribute4 = fnd_api.g_miss_char THEN

1792: ELSE
1793: l_inv_attributes_tbl (3) := p_attribute3;
1794: END IF;
1795:
1796: IF p_attribute4 = fnd_api.g_miss_char THEN
1797: l_inv_attributes_tbl (4) := NULL;
1798: ELSE
1799: l_inv_attributes_tbl (4) := p_attribute4;
1800: END IF;

Line 1802: IF p_attribute5 = fnd_api.g_miss_char THEN

1798: ELSE
1799: l_inv_attributes_tbl (4) := p_attribute4;
1800: END IF;
1801:
1802: IF p_attribute5 = fnd_api.g_miss_char THEN
1803: l_inv_attributes_tbl (5) := NULL;
1804: ELSE
1805: l_inv_attributes_tbl (5) := p_attribute5;
1806: END IF;

Line 1808: IF p_attribute6 = fnd_api.g_miss_char THEN

1804: ELSE
1805: l_inv_attributes_tbl (5) := p_attribute5;
1806: END IF;
1807:
1808: IF p_attribute6 = fnd_api.g_miss_char THEN
1809: l_inv_attributes_tbl (6) := NULL;
1810: ELSE
1811: l_inv_attributes_tbl (6) := p_attribute6;
1812: END IF;

Line 1813: IF p_attribute7 = fnd_api.g_miss_char THEN

1809: l_inv_attributes_tbl (6) := NULL;
1810: ELSE
1811: l_inv_attributes_tbl (6) := p_attribute6;
1812: END IF;
1813: IF p_attribute7 = fnd_api.g_miss_char THEN
1814: l_inv_attributes_tbl (7) := NULL;
1815: ELSE
1816: l_inv_attributes_tbl (7) := p_attribute7;
1817: END IF;

Line 1818: IF p_attribute8 = fnd_api.g_miss_char THEN

1814: l_inv_attributes_tbl (7) := NULL;
1815: ELSE
1816: l_inv_attributes_tbl (7) := p_attribute7;
1817: END IF;
1818: IF p_attribute8 = fnd_api.g_miss_char THEN
1819: l_inv_attributes_tbl (8) := NULL;
1820: ELSE
1821: l_inv_attributes_tbl (8) := p_attribute8;
1822: END IF;

Line 1824: IF p_attribute9 = fnd_api.g_miss_char THEN

1820: ELSE
1821: l_inv_attributes_tbl (8) := p_attribute8;
1822: END IF;
1823:
1824: IF p_attribute9 = fnd_api.g_miss_char THEN
1825: l_inv_attributes_tbl (9) := NULL;
1826: ELSE
1827: l_inv_attributes_tbl (9) := p_attribute9;
1828: END IF;

Line 1829: IF p_attribute10 = fnd_api.g_miss_char THEN

1825: l_inv_attributes_tbl (9) := NULL;
1826: ELSE
1827: l_inv_attributes_tbl (9) := p_attribute9;
1828: END IF;
1829: IF p_attribute10 = fnd_api.g_miss_char THEN
1830: l_inv_attributes_tbl (10) := NULL;
1831: ELSE
1832: l_inv_attributes_tbl (10) := p_attribute10;
1833: END IF;

Line 1834: IF p_attribute11 = fnd_api.g_miss_char THEN

1830: l_inv_attributes_tbl (10) := NULL;
1831: ELSE
1832: l_inv_attributes_tbl (10) := p_attribute10;
1833: END IF;
1834: IF p_attribute11 = fnd_api.g_miss_char THEN
1835: l_inv_attributes_tbl (11) := NULL;
1836: ELSE
1837: l_inv_attributes_tbl (11) := p_attribute11;
1838: END IF;

Line 1839: IF p_attribute12 = fnd_api.g_miss_char THEN

1835: l_inv_attributes_tbl (11) := NULL;
1836: ELSE
1837: l_inv_attributes_tbl (11) := p_attribute11;
1838: END IF;
1839: IF p_attribute12 = fnd_api.g_miss_char THEN
1840: l_inv_attributes_tbl (12) := NULL;
1841: ELSE
1842: l_inv_attributes_tbl (12) := p_attribute12;
1843: END IF;

Line 1845: IF p_attribute13 = fnd_api.g_miss_char THEN

1841: ELSE
1842: l_inv_attributes_tbl (12) := p_attribute12;
1843: END IF;
1844:
1845: IF p_attribute13 = fnd_api.g_miss_char THEN
1846: l_inv_attributes_tbl (13) := NULL;
1847: ELSE
1848: l_inv_attributes_tbl (13) := p_attribute13;
1849: END IF;

Line 1851: IF p_attribute14 = fnd_api.g_miss_char THEN

1847: ELSE
1848: l_inv_attributes_tbl (13) := p_attribute13;
1849: END IF;
1850:
1851: IF p_attribute14 = fnd_api.g_miss_char THEN
1852: l_inv_attributes_tbl (14) := NULL;
1853: ELSE
1854: l_inv_attributes_tbl (14) := p_attribute14;
1855: END IF;

Line 1857: IF p_attribute15 = fnd_api.g_miss_char THEN

1853: ELSE
1854: l_inv_attributes_tbl (14) := p_attribute14;
1855: END IF;
1856:
1857: IF p_attribute15 = fnd_api.g_miss_char THEN
1858: l_inv_attributes_tbl (15) := NULL;
1859: ELSE
1860: l_inv_attributes_tbl (15) := p_attribute15;
1861: END IF;

Line 1877: RAISE fnd_api.g_exc_error;

1873: IF l_return_status = 'E' THEN
1874: --DBMS_output.put_line('Error from validate_loc_attr_info');
1875: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1876: fnd_msg_pub.ADD;
1877: RAISE fnd_api.g_exc_error;
1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1880: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1881: fnd_msg_pub.ADD;

Line 1882: RAISE fnd_api.g_exc_unexpected_error;

1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1880: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1881: fnd_msg_pub.ADD;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;
1884: /* End locator DFF attributes validation */
1885:
1886: /* When the control is at this point, data supplied are valid.

Line 1899: RAISE fnd_api.g_exc_error;

1895: );
1896: IF (l_is_disable_allow = false) THEN
1897: fnd_message.set_name('INV','INV_LOCATOR_DISABLE_WARN');
1898: fnd_msg_pub.ADD;
1899: RAISE fnd_api.g_exc_error;
1900: END IF;
1901: END IF;
1902: -- end of bug 7297065
1903:

Line 1907: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)

1903:
1904: --DBMS_output.put_line('Before update ');
1905:
1906: UPDATE mtl_item_locations
1907: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1908: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1909: , inventory_location_type =
1910: DECODE(
1911: p_inventory_location_type

Line 1908: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)

1904: --DBMS_output.put_line('Before update ');
1905:
1906: UPDATE mtl_item_locations
1907: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1908: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1909: , inventory_location_type =
1910: DECODE(
1911: p_inventory_location_type
1912: , fnd_api.g_miss_num, inventory_location_type

Line 1912: , fnd_api.g_miss_num, inventory_location_type

1908: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1909: , inventory_location_type =
1910: DECODE(
1911: p_inventory_location_type
1912: , fnd_api.g_miss_num, inventory_location_type
1913: , p_inventory_location_type
1914: )
1915: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1916: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)

Line 1915: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)

1911: p_inventory_location_type
1912: , fnd_api.g_miss_num, inventory_location_type
1913: , p_inventory_location_type
1914: )
1915: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1916: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1917: , location_weight_uom_code =
1918: DECODE(
1919: p_location_weight_uom_code

Line 1916: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)

1912: , fnd_api.g_miss_num, inventory_location_type
1913: , p_inventory_location_type
1914: )
1915: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1916: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1917: , location_weight_uom_code =
1918: DECODE(
1919: p_location_weight_uom_code
1920: , fnd_api.g_miss_char, location_weight_uom_code

Line 1920: , fnd_api.g_miss_char, location_weight_uom_code

1916: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1917: , location_weight_uom_code =
1918: DECODE(
1919: p_location_weight_uom_code
1920: , fnd_api.g_miss_char, location_weight_uom_code
1921: , p_location_weight_uom_code
1922: )
1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)

Line 1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)

1919: p_location_weight_uom_code
1920: , fnd_api.g_miss_char, location_weight_uom_code
1921: , p_location_weight_uom_code
1922: )
1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)

Line 1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)

1920: , fnd_api.g_miss_char, location_weight_uom_code
1921: , p_location_weight_uom_code
1922: )
1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)

Line 1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)

1921: , p_location_weight_uom_code
1922: )
1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)

Line 1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)

1922: )
1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)

Line 1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)

1923: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)

Line 1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)

1924: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)

Line 1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)

1925: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)

Line 1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)

1926: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)

Line 1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)

1927: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)

Line 1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)

1928: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id

Line 1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)

1929: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE

Line 1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)

1930: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)

Line 1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)

1931: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)

Line 1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)

1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)

Line 1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)

1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)

Line 1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)

1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)

Line 1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)

1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)

Line 1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)

1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)

Line 1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)

1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)

Line 1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)

1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)

Line 1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)

1941: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)

Line 1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)

1942: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)

Line 1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)

1943: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)

Line 1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)

1944: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)

Line 1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)

1945: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)

Line 1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)

1946: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1954: , alias = l_alias

Line 1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)

1947: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1954: , alias = l_alias
1955: WHERE inventory_location_id = l_inventory_location_id

Line 1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)

1948: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1954: , alias = l_alias
1955: WHERE inventory_location_id = l_inventory_location_id
1956: AND organization_id = l_organization_id;

Line 1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)

1949: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1950: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1951: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1952: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1953: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1954: , alias = l_alias
1955: WHERE inventory_location_id = l_inventory_location_id
1956: AND organization_id = l_organization_id;
1957:

Line 1960: AND p_status_id <> fnd_api.g_miss_num

1956: AND organization_id = l_organization_id;
1957:
1958: /* If the p_status_id is not null then,stamp the new status in the status history table */
1959: IF (p_status_id IS NOT NULL
1960: AND p_status_id <> fnd_api.g_miss_num
1961: AND p_status_id <> l_status_id) THEN
1962:
1963: l_status_rec.organization_id := l_organization_id;
1964: l_status_rec.inventory_item_id := NULL;

Line 1982: WHEN fnd_api.g_exc_error THEN

1978: inv_material_status_pkg.insert_status_history(l_status_rec);
1979: END IF;
1980: --DBMS_output.put_line('End of procedure ');
1981: EXCEPTION
1982: WHEN fnd_api.g_exc_error THEN
1983: x_return_status := 'E';
1984: ROLLBACK TO locator_update;
1985: debug(l_procedure_name ||' Expected Error ');
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1982: WHEN fnd_api.g_exc_error THEN
1983: x_return_status := 'E';
1984: ROLLBACK TO locator_update;
1985: debug(l_procedure_name ||' Expected Error ');
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := 'U';
1989: ROLLBACK TO locator_update;
1990: debug(l_procedure_name ||'Unexpected Error ');

Line 1987: WHEN fnd_api.g_exc_unexpected_error THEN

1983: x_return_status := 'E';
1984: ROLLBACK TO locator_update;
1985: debug(l_procedure_name ||' Expected Error ');
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := 'U';
1989: ROLLBACK TO locator_update;
1990: debug(l_procedure_name ||'Unexpected Error ');
1991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := 'U';
1989: ROLLBACK TO locator_update;
1990: debug(l_procedure_name ||'Unexpected Error ');
1991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1992: WHEN OTHERS THEN
1993: x_return_status := 'U';
1994: ROLLBACK TO locator_update;
1995:

Line 2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1998: END IF;
1999: debug(l_procedure_name ||' Others '||SQLERRM);
2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2001: END update_locator;
2002:
2003: /*
2004: ** ---------------------------------------------------------------------------

Line 2073: x_return_status := fnd_api.g_ret_sts_success;

2069: BEGIN
2070: -- declare a savepoint
2071:
2072: SAVEPOINT location_item_restrict;
2073: x_return_status := fnd_api.g_ret_sts_success;
2074:
2075: /* If organization id passed use it, else use organization code */
2076: IF p_organization_id IS NOT NULL THEN
2077: l_organization_id := p_organization_id;

Line 2083: RAISE fnd_api.g_exc_error;

2079: IF p_organization_code IS NULL THEN
2080: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2081: /* Organization is required */
2082: fnd_msg_pub.ADD;
2083: RAISE fnd_api.g_exc_error;
2084: ELSE
2085: BEGIN
2086: SELECT organization_id
2087: INTO l_organization_id

Line 2095: RAISE fnd_api.g_exc_error;

2091: WHEN NO_DATA_FOUND THEN
2092: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2093: /* The Organization Code provided is invalid */
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_error;
2096: END;
2097: END IF;
2098: END IF;
2099:

Line 2108: RAISE fnd_api.g_exc_error;

2104: IF p_item IS NULL THEN
2105: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2106: /* Invalid item segments */
2107: fnd_msg_pub.ADD;
2108: RAISE fnd_api.g_exc_error;
2109: ELSE
2110: BEGIN
2111: SELECT inventory_item_id
2112: INTO l_inventory_item_id

Line 2121: RAISE fnd_api.g_exc_error;

2117: WHEN NO_DATA_FOUND THEN
2118: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2119: /* The Item provided is invalid */
2120: fnd_msg_pub.ADD;
2121: RAISE fnd_api.g_exc_error;
2122: END;
2123: END IF;
2124: END IF;
2125:

Line 2131: RAISE fnd_api.g_exc_error;

2127: IF p_subinventory_code IS NULL THEN
2128: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2129: /* Please enter a subinventory before proceeding */
2130: fnd_msg_pub.ADD;
2131: RAISE fnd_api.g_exc_error;
2132: ELSE
2133: BEGIN
2134: SELECT NVL(planning_level, 2)
2135: INTO l_planning_level

Line 2144: RAISE fnd_api.g_exc_error;

2140: WHEN NO_DATA_FOUND THEN
2141: fnd_message.set_name('INV', 'INVALID_SUB');
2142: /* The subinventory provided is invalid */
2143: fnd_msg_pub.ADD;
2144: RAISE fnd_api.g_exc_error;
2145: END;
2146: END IF;
2147:
2148: /* Validate The locator */

Line 2156: RAISE fnd_api.g_exc_error;

2152: IF p_locator IS NULL THEN
2153: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2154: /* Invalid locator segments */
2155: fnd_msg_pub.ADD;
2156: RAISE fnd_api.g_exc_error;
2157: ELSE
2158: BEGIN
2159: SELECT inventory_location_id
2160: INTO l_locator_id

Line 2169: RAISE fnd_api.g_exc_error;

2165: WHEN NO_DATA_FOUND THEN
2166: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2167: /* The Locator provided is invalid */
2168: fnd_msg_pub.ADD;
2169: RAISE fnd_api.g_exc_error;
2170: END;
2171: END IF;
2172: END IF;
2173:

Line 2186: RAISE fnd_api.g_exc_error;

2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN
2184: fnd_message.set_name('INV', 'INV_INT_LOCSEGEXP');
2185: /* The Locator segments are invalid for the given subinventory, organization combination */
2186: RAISE fnd_api.g_exc_error;
2187: END;
2188:
2189: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2190: BEGIN

Line 2214: RAISE fnd_api.g_exc_error;

2210: WHEN NO_DATA_FOUND THEN
2211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2212: /* Invalid status ID. */
2213: fnd_msg_pub.ADD;
2214: RAISE fnd_api.g_exc_error;
2215: END;
2216: END IF;
2217:
2218: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */

Line 2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2304: ELSE
2305: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2306: /* Locator selected has already been assigned to this item and subinventory */
2307: fnd_msg_pub.ADD;
2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2309: END IF;
2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';

Line 2311: WHEN fnd_api.g_exc_error THEN

2307: fnd_msg_pub.ADD;
2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2309: END IF;
2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';
2313: ROLLBACK TO location_item_restrict;
2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';
2313: ROLLBACK TO location_item_restrict;
2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN
2316: x_return_status := 'U';
2317: ROLLBACK TO location_item_restrict;
2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2315: WHEN fnd_api.g_exc_unexpected_error THEN

2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';
2313: ROLLBACK TO location_item_restrict;
2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN
2316: x_return_status := 'U';
2317: ROLLBACK TO location_item_restrict;
2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2319: WHEN OTHERS THEN

Line 2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN
2316: x_return_status := 'U';
2317: ROLLBACK TO location_item_restrict;
2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2319: WHEN OTHERS THEN
2320: x_return_status := 'U';
2321: --DBMS_output.put_line('In others '||sqlerrm);
2322: ROLLBACK TO location_item_restrict;

Line 2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2324: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2325: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2326: END IF;
2327:
2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2329: END create_loc_item_tie;
2330:
2331: /*
2332: **-----------------------------------------------------------------------------------

Line 2387: x_return_status := fnd_api.g_ret_sts_success;

2383: l_physical_locator_id NUMBER;
2384: l_val BOOLEAN;
2385: BEGIN
2386: SAVEPOINT del_loc_api;
2387: x_return_status := fnd_api.g_ret_sts_success;
2388:
2389: /* Check if the organization_id passed,otherwise get the organisation_id corresponding to the
2390: Non null organisation_code passed */
2391: IF p_organization_id IS NOT NULL THEN

Line 2405: RAISE fnd_api.g_exc_error;

2401: IF p_organization_code IS NULL THEN
2402: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2403: /* Organisation is required */
2404: fnd_msg_pub.ADD;
2405: RAISE fnd_api.g_exc_error;
2406: ELSE
2407: SELECT organization_id
2408: INTO l_organization_id
2409: FROM mtl_parameters

Line 2452: RAISE fnd_api.g_exc_error;

2448: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2449: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2450: /* LOCATOR does not exist */
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_error;
2453: ELSE
2454: l_locator := p_concatenated_segments;
2455: l_inventory_location_id := fnd_flex_keyval.combination_id;
2456: END IF;

Line 2480: RAISE fnd_api.g_exc_error;

2476: fnd_message.set_name('INV', 'INV_LOC_PHY');
2477: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2478: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2479: fnd_msg_pub.ADD;
2480: RAISE fnd_api.g_exc_error;
2481: EXCEPTION
2482: WHEN NO_DATA_FOUND THEN
2483: NULL;
2484: END;

Line 2505: RAISE fnd_api.g_exc_error;

2501: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2502: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2503: /*Locator locator cannot be deleted as it is active */
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2506: EXCEPTION
2507: WHEN NO_DATA_FOUND THEN
2508: NULL;
2509: END;

Line 2531: RAISE fnd_api.g_exc_error;

2527: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2528: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2529: /*Locator locator cannot be deleted as items exist in it*/
2530: fnd_msg_pub.ADD;
2531: RAISE fnd_api.g_exc_error;
2532: EXCEPTION
2533: WHEN NO_DATA_FOUND THEN
2534: NULL;
2535: END;

Line 2553: RAISE fnd_api.g_exc_error;

2549: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2550: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2551: /*The locator locator cannot be deleted as reservations exist against it*/
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: EXCEPTION
2555: WHEN NO_DATA_FOUND THEN
2556: NULL;
2557: END;

Line 2574: RAISE fnd_api.g_exc_error;

2570: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2571: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2572: /*Locator locator cannot be deleted as LPNs reside in it*/
2573: fnd_msg_pub.ADD;
2574: RAISE fnd_api.g_exc_error;
2575: EXCEPTION
2576: WHEN NO_DATA_FOUND THEN
2577: NULL;
2578: END;

Line 2595: RAISE fnd_api.g_exc_error;

2591: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2592: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2593: /*Locator locator cannot be deleted as it is tied to an item */
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: EXCEPTION
2597: WHEN NO_DATA_FOUND THEN
2598: NULL;
2599: END;

Line 2616: RAISE fnd_api.g_exc_error;

2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2613: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2614: /*Locator locator cannot be deleted as there are pending transactions against it*/
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_error;
2617: EXCEPTION
2618: WHEN NO_DATA_FOUND THEN
2619: NULL;
2620: END;

Line 2643: RAISE fnd_api.g_exc_error;

2639: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2640: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2641: /*Locator locator cannot be deleted as there are pending transactions against it*/
2642: fnd_msg_pub.ADD;
2643: RAISE fnd_api.g_exc_error;
2644: EXCEPTION
2645: WHEN NO_DATA_FOUND THEN
2646: NULL;
2647: END;

Line 2664: RAISE fnd_api.g_exc_error;

2660: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2661: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2662: /*Locator locator cannot be deleted as there are pending transactions against it*/
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: EXCEPTION
2666: WHEN NO_DATA_FOUND THEN
2667: NULL;
2668: END;

Line 2678: WHEN fnd_api.g_exc_error THEN

2674: DELETE mtl_item_locations
2675: WHERE inventory_location_id = l_inventory_location_id
2676: AND organization_id = l_organization_id;
2677: EXCEPTION
2678: WHEN fnd_api.g_exc_error THEN
2679: x_return_status := fnd_api.g_ret_sts_error;
2680: ROLLBACK TO del_loc_api;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2679: x_return_status := fnd_api.g_ret_sts_error;

2675: WHERE inventory_location_id = l_inventory_location_id
2676: AND organization_id = l_organization_id;
2677: EXCEPTION
2678: WHEN fnd_api.g_exc_error THEN
2679: x_return_status := fnd_api.g_ret_sts_error;
2680: ROLLBACK TO del_loc_api;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2682: WHEN fnd_api.g_exc_unexpected_error THEN

2678: WHEN fnd_api.g_exc_error THEN
2679: x_return_status := fnd_api.g_ret_sts_error;
2680: ROLLBACK TO del_loc_api;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684: ROLLBACK TO del_loc_api;
2685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2686: WHEN NO_DATA_FOUND THEN

Line 2683: x_return_status := fnd_api.g_ret_sts_unexp_error;

2679: x_return_status := fnd_api.g_ret_sts_error;
2680: ROLLBACK TO del_loc_api;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684: ROLLBACK TO del_loc_api;
2685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2686: WHEN NO_DATA_FOUND THEN
2687: ROLLBACK TO del_loc_api;

Line 2688: x_return_status := fnd_api.g_ret_sts_error;

2684: ROLLBACK TO del_loc_api;
2685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2686: WHEN NO_DATA_FOUND THEN
2687: ROLLBACK TO del_loc_api;
2688: x_return_status := fnd_api.g_ret_sts_error;
2689: WHEN OTHERS THEN
2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691: ROLLBACK TO del_loc_api;
2692:

Line 2690: x_return_status := fnd_api.g_ret_sts_unexp_error;

2686: WHEN NO_DATA_FOUND THEN
2687: ROLLBACK TO del_loc_api;
2688: x_return_status := fnd_api.g_ret_sts_error;
2689: WHEN OTHERS THEN
2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691: ROLLBACK TO del_loc_api;
2692:
2693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2694: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');