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 67: x_return_status := fnd_api.g_ret_sts_success;

63: l_null_date_val DATE;
64: l_global_nsegments NUMBER := 0;
65: col NUMBER;
66: BEGIN
67: x_return_status := fnd_api.g_ret_sts_success;
68: SAVEPOINT get_lot_attr_information;
69:
70: /* Populate the flex field record */
71:

Line 115: RAISE fnd_api.g_exc_error;

111: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
112: fnd_message.set_token('CONTEXT', 'NULL');
113: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
114: fnd_msg_pub.ADD;
115: RAISE fnd_api.g_exc_error;
116: END IF;
117:
118: FOR i IN 1 .. l_nsegments LOOP
119: l_enabled_seg_name(v_index) := l_segments_dr.application_column_name(i);

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

120: IF l_segments_dr.is_required(i) THEN
121: col := SUBSTR(l_segments_dr.application_column_name(i)
122: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9);
123: --DBMS_output.put_line('col is ' || col);
124: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR
125: NOT p_attributes_tbl.EXISTS(col))
126: THEN
127: --DBMS_output.put_line('y r we here');
128: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');

Line 131: RAISE fnd_api.g_exc_error;

127: --DBMS_output.put_line('y r we here');
128: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
129: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
130: fnd_msg_pub.ADD;
131: RAISE fnd_api.g_exc_error;
132: END IF;
133: ELSE
134: --DBMS_output.put_line('This segment is not required');
135: NULL;

Line 204: RAISE fnd_api.g_exc_error;

200: THEN
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: --DBMS_output.put_line('Req segment is not populated');
206: END IF;
207: END IF;
208:

Line 251: x_return_status := fnd_api.g_ret_sts_error;

247: --END IF; /* p_attribute_category IS NOT NULL */
248:
249: EXCEPTION
250: WHEN errors_received THEN
251: x_return_status := fnd_api.g_ret_sts_error;
252: error_msg := fnd_flex_descval.error_message;
253: s := 1;
254: e := 200;
255:

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

264: e := e + 200;
265: END LOOP;
266:
267: ROLLBACK TO get_lot_attr_information;
268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 269: WHEN fnd_api.g_exc_error THEN

265: END LOOP;
266:
267: ROLLBACK TO get_lot_attr_information;
268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN

Line 270: x_return_status := fnd_api.g_ret_sts_error;

266:
267: ROLLBACK TO get_lot_attr_information;
268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 273: WHEN fnd_api.g_exc_unexpected_error THEN

269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN

Line 274: x_return_status := fnd_api.g_ret_sts_unexp_error;

270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: ROLLBACK TO get_lot_attr_information;
280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 278: x_return_status := fnd_api.g_ret_sts_unexp_error;

274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: ROLLBACK TO get_lot_attr_information;
280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
281: --DBMS_output.put_line('Error ' || SQLERRM);
282: END validate_loc_attr_info;

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

276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: ROLLBACK TO get_lot_attr_information;
280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
281: --DBMS_output.put_line('Error ' || SQLERRM);
282: END validate_loc_attr_info;
283:
284:

Line 472: x_return_status := fnd_api.g_ret_sts_success;

468:
469: SAVEPOINT locator_insert;
470:
471: -- Initialize return status to success
472: x_return_status := fnd_api.g_ret_sts_success;
473:
474: IF l_debug = 1 THEN
475: debug(l_procedure_name);
476: END IF;

Line 503: RAISE fnd_api.g_exc_error;

499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_error;
504: END;
505:
506: ELSE -- p_organization_id is NULL
507:

Line 512: RAISE fnd_api.g_exc_error;

508: IF p_organization_code IS NULL THEN
509:
510: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
511: fnd_msg_pub.ADD;
512: RAISE fnd_api.g_exc_error;
513:
514: ELSE -- p_organization_code is NULL
515:
516: BEGIN

Line 529: RAISE fnd_api.g_exc_error;

525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
528: fnd_msg_pub.ADD;
529: RAISE fnd_api.g_exc_error;
530: END;
531:
532: END IF; -- p_organization_code is NULL
533:

Line 550: RAISE fnd_api.g_exc_error;

546: IF p_subinventory_code IS NULL THEN
547:
548: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
549: fnd_msg_pub.ADD;
550: RAISE fnd_api.g_exc_error;
551:
552: ELSE -- p_subinventory_code is NULL
553:
554: BEGIN

Line 573: RAISE fnd_api.g_exc_error;

569:
570: WHEN NO_DATA_FOUND THEN
571: fnd_message.set_name('INV', 'INVALID_SUB');
572: fnd_msg_pub.ADD;
573: RAISE fnd_api.g_exc_error;
574:
575: END;
576:
577: END IF; -- p_subinventory_code is NULL

Line 587: RAISE fnd_api.g_exc_error;

583: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
584: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
585: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END IF;
589:
590: /*
591: * Valiate Loator alias

Line 603: RAISE fnd_api.g_exc_error;

599: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
600:
601: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
602: fnd_msg_pub.ADD;
603: RAISE fnd_api.g_exc_error;
604:
605: END IF;
606:
607: IF NVL(l_alias_enabled, 'N') <> 'Y' THEN

Line 629: RAISE fnd_api.g_exc_error;

625:
626: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
627: fnd_message.set_token('LOCATOR', l_locator);
628: fnd_msg_pub.ADD;
629: RAISE fnd_api.g_exc_error;
630:
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: NULL;

Line 653: RAISE fnd_api.g_exc_error;

649:
650: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
651: fnd_message.set_token('LOCATOR', l_locator);
652: fnd_msg_pub.ADD;
653: RAISE fnd_api.g_exc_error;
654:
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: NULL;

Line 675: RAISE fnd_api.g_exc_error;

671: IF p_concatenated_segments IS NULL THEN
672:
673: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
674: fnd_msg_pub.ADD;
675: RAISE fnd_api.g_exc_error;
676:
677: END IF;
678:
679: /*

Line 693: ( p_encoded => FND_API.G_FALSE,

689: x_locator_exists:= 'Y';
690: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
691: fnd_msg_pub.add;
692: fnd_msg_pub.count_and_get
693: ( p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );
697: return;

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

717: x_locator_exists := 'Y';
718: x_inventory_location_id := fnd_flex_keyval.combination_id;
719: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
720: fnd_msg_pub.ADD;
721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
722: RETURN;
723: END IF;
724: END;
725:

Line 741: RAISE fnd_api.g_exc_error;

737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
740: fnd_msg_pub.ADD;
741: RAISE fnd_api.g_exc_error;
742: END;
743: END IF;
744:
745: IF (p_location_weight_uom_code IS NOT NULL) THEN

Line 755: RAISE fnd_api.g_exc_error;

751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
754: fnd_msg_pub.ADD;
755: RAISE fnd_api.g_exc_error;
756: END;
757: END IF;
758:
759: /* Validate Location volume uom code */

Line 772: RAISE fnd_api.g_exc_error;

768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
771: fnd_msg_pub.ADD;
772: RAISE fnd_api.g_exc_error;
773: END;
774: END IF;
775:
776: --DBMS_output.put_line('Before validating the pick uom ');

Line 787: RAISE fnd_api.g_exc_error;

783: EXCEPTION
784: WHEN NO_DATA_FOUND THEN
785: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
786: fnd_msg_pub.ADD;
787: RAISE fnd_api.g_exc_error;
788: END;
789: END IF;
790:
791: /* Validate Dimension uom code */

Line 804: RAISE fnd_api.g_exc_error;

800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
803: fnd_msg_pub.ADD;
804: RAISE fnd_api.g_exc_error;
805: END;
806: END IF;
807:
808: --DBMS_output.put_line('Before check whether locator exists ');

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

832: --DBMS_output.put_line('In validity check in no data found ');
833: NULL;
834: END;
835:
836: /* If the value of l_validity_check is PASSED, call FND API to
837: create locator
838: */
839: IF l_validity_check = 'PASSED' THEN
840: --DBMS_output.put_line('Org id:' || to_char(l_organization_id));

Line 864: RAISE fnd_api.g_exc_unexpected_error;

860: IF (l_keystat_val = FALSE) THEN
861: --DBMS_output.put_line('validate segment failed ');
862: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
863: fnd_msg_pub.ADD;
864: RAISE fnd_api.g_exc_unexpected_error;
865: ELSE
866: x_inventory_location_id := fnd_flex_keyval.combination_id;
867:
868: IF fnd_flex_keyval.new_combination THEN

Line 906: RAISE fnd_api.g_exc_unexpected_error;

902: ELSE
903: --DBMS_output.put_line('Wms installed check failed ');
904: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
905: fnd_msg_pub.ADD;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;
908:
909: --Bug Number 5606275
910: BEGIN

Line 928: RAISE fnd_api.g_exc_error;

924: IF( l_project_control_level =2 AND l_segment20 IS NULL) THEN
925:
926: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
927: fnd_msg_pub.ADD;
928: RAISE fnd_api.g_exc_error;
929: END IF;
930: END IF;
931:
932: EXCEPTION

Line 1016: RAISE fnd_api.g_exc_error;

1012: IF l_return_status = 'E' THEN
1013: --DBMS_output.put_line('Error from validate_loc_attr_info');
1014: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1015: fnd_msg_pub.ADD;
1016: RAISE fnd_api.g_exc_error;
1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1019: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1020: fnd_msg_pub.ADD;

Line 1021: RAISE fnd_api.g_exc_unexpected_error;

1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1019: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1020: fnd_msg_pub.ADD;
1021: RAISE fnd_api.g_exc_unexpected_error;
1022: END IF;
1023: /* End locator DFF attributes validation */
1024:
1025: --DBMS_output.put_line('finished calling validate_loc_attr_info');

Line 1097: RAISE fnd_api.g_exc_error;

1093: END IF; -- (l_keystat_val = FALSE)
1094: ELSE
1095: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1096: fnd_msg_pub.ADD;
1097: RAISE fnd_api.g_exc_error;
1098: END IF; -- (l_validility = passed)
1099:
1100: EXCEPTION
1101: WHEN fnd_api.g_exc_error THEN

Line 1101: WHEN fnd_api.g_exc_error THEN

1097: RAISE fnd_api.g_exc_error;
1098: END IF; -- (l_validility = passed)
1099:
1100: EXCEPTION
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := 'E';
1103: ROLLBACK TO locator_insert;
1104: debug(l_procedure_name ||' Expected Error ');
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := 'E';
1103: ROLLBACK TO locator_insert;
1104: debug(l_procedure_name ||' Expected Error ');
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1106: WHEN fnd_api.g_exc_unexpected_error THEN
1107: x_return_status := 'U';
1108: ROLLBACK TO locator_insert;
1109: debug(l_procedure_name ||' Unxpected Error ');

Line 1106: WHEN fnd_api.g_exc_unexpected_error THEN

1102: x_return_status := 'E';
1103: ROLLBACK TO locator_insert;
1104: debug(l_procedure_name ||' Expected Error ');
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1106: WHEN fnd_api.g_exc_unexpected_error THEN
1107: x_return_status := 'U';
1108: ROLLBACK TO locator_insert;
1109: debug(l_procedure_name ||' Unxpected Error ');
1110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1106: WHEN fnd_api.g_exc_unexpected_error THEN
1107: x_return_status := 'U';
1108: ROLLBACK TO locator_insert;
1109: debug(l_procedure_name ||' Unxpected Error ');
1110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN OTHERS THEN
1112: x_return_status := 'U';
1113: --DBMS_output.put_line('In others '||sqlerrm);
1114: ROLLBACK TO locator_insert;

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

1116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1118: END IF;
1119: debug(l_procedure_name ||' Others '||SQLERRM);
1120: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1121: END create_locator;
1122:
1123: /*
1124: ** ---------------------------------------------------------------------------

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

1196: ** For ordering drop-off locators and also to order by putaway
1197: ** drop-off operations (bug 2681871)
1198: ** For the DFF attributes mentioned below, to update correctly use the following strategy
1199: ** To retain the value in the table, do not pass any value OR pass NULL as i/p
1200: ** To update the attribute with NULL, pass fnd_api.g_miss_char
1201: ** To update with any other value, pass the appropriate value
1202: ** p_attribute_category Holds the Context of the Descriptive FlexField for the Locator
1203: ** p_attribute1 Holds the Descriptive FlexField attribute for the Locator
1204: ** p_attribute2 Holds the Descriptive FlexField attribute for the Locator

Line 1315: x_return_status := fnd_api.g_ret_sts_success;

1311: l_procedure_name := 'UPDATE_LOCATOR';
1312: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1313:
1314:
1315: x_return_status := fnd_api.g_ret_sts_success;
1316:
1317: IF l_debug = 1 THEN
1318: debug(l_procedure_name);
1319: END IF;

Line 1338: RAISE fnd_api.g_exc_error;

1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1337: fnd_msg_pub.ADD;
1338: RAISE fnd_api.g_exc_error;
1339: END;
1340:
1341: ELSE -- p_organization_id IS NULL
1342:

Line 1347: RAISE fnd_api.g_exc_error;

1343: IF p_organization_code IS NULL THEN
1344:
1345: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1346: fnd_msg_pub.ADD;
1347: RAISE fnd_api.g_exc_error;
1348:
1349: ELSE -- p_organization_code is NULL
1350:
1351: BEGIN

Line 1362: RAISE fnd_api.g_exc_error;

1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN
1360: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1361: fnd_msg_pub.ADD;
1362: RAISE fnd_api.g_exc_error;
1363: END;
1364:
1365: END IF; -- p_organization_code is NULL
1366:

Line 1378: RAISE fnd_api.g_exc_error;

1374: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1375:
1376: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1377: fnd_msg_pub.ADD;
1378: RAISE fnd_api.g_exc_error;
1379:
1380: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1381:
1382: /* BEGIN

Line 1405: RAISE fnd_api.g_exc_error;

1401:
1402: IF l_val = FALSE THEN
1403: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1404: fnd_msg_pub.ADD;
1405: RAISE fnd_api.g_exc_error;
1406: ELSE
1407: l_inventory_location_id := fnd_flex_keyval.combination_id;
1408: END IF;
1409:

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

1419: /*
1420: * Validate Inventory_Location_Type
1421: */
1422:
1423: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1424: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1425:
1426: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1427: fnd_msg_pub.ADD;

Line 1428: RAISE fnd_api.g_exc_error;

1424: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1425:
1426: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1427: fnd_msg_pub.ADD;
1428: RAISE fnd_api.g_exc_error;
1429:
1430: END IF;
1431:
1432: -- Bug# 4903036: Check that the sub type and locator type are compatible.

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

1430: END IF;
1431:
1432: -- Bug# 4903036: Check that the sub type and locator type are compatible.
1433: -- Do this check only if the inventory location type is being updated for the locator.
1434: IF (p_inventory_location_type <> fnd_api.g_miss_num) THEN
1435: -- Retrieve the subinventory type for the sub that the locator is in.
1436: BEGIN
1437: SELECT NVL(msi.subinventory_type, 1)
1438: INTO l_subinventory_type

Line 1448: RAISE fnd_api.g_exc_error;

1444: EXCEPTION
1445: WHEN NO_DATA_FOUND THEN
1446: fnd_message.set_name('INV', 'INVALID_SUB');
1447: fnd_msg_pub.ADD;
1448: RAISE fnd_api.g_exc_error;
1449: END;
1450:
1451: -- If the sub is of type 'Storage', then the locator cannot be of type 'Receiving'.
1452: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.

Line 1458: RAISE fnd_api.g_exc_error;

1454: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1455: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1456: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1457: fnd_msg_pub.ADD;
1458: RAISE fnd_api.g_exc_error;
1459: END IF;
1460: END IF;
1461:
1462:

Line 1499: RAISE fnd_api.g_exc_error;

1495: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1496:
1497: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1498: fnd_msg_pub.ADD;
1499: RAISE fnd_api.g_exc_error;
1500:
1501: END IF;
1502:
1503: IF NVL(l_alias_enabled, 'N') <> 'Y' THEN

Line 1522: RAISE fnd_api.g_exc_error;

1518:
1519: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1520: fnd_message.set_token('LOCATOR', l_locator);
1521: fnd_msg_pub.ADD;
1522: RAISE fnd_api.g_exc_error;
1523:
1524: EXCEPTION
1525: WHEN NO_DATA_FOUND THEN
1526: NULL;

Line 1545: RAISE fnd_api.g_exc_error;

1541:
1542: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1543: fnd_message.set_token('LOCATOR', l_locator);
1544: fnd_msg_pub.ADD;
1545: RAISE fnd_api.g_exc_error;
1546:
1547: EXCEPTION
1548: WHEN NO_DATA_FOUND THEN
1549: NULL;

Line 1562: IF (p_location_weight_uom_code <> fnd_api.g_miss_char

1558:
1559: /* Validate Location weight uom code */
1560:
1561: --DBMS_output.put_line('Before validating the weight uom ');
1562: IF (p_location_weight_uom_code <> fnd_api.g_miss_char
1563: AND p_location_weight_uom_code IS NOT NULL) THEN
1564: BEGIN
1565: SELECT 1
1566: INTO l_chkflg

Line 1573: RAISE fnd_api.g_exc_error;

1569: EXCEPTION
1570: WHEN NO_DATA_FOUND THEN
1571: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1572: fnd_msg_pub.ADD;
1573: RAISE fnd_api.g_exc_error;
1574: END;
1575: END IF;
1576:
1577: /* Validate Location volume uom code */

Line 1580: IF (p_volume_uom_code <> fnd_api.g_miss_char

1576:
1577: /* Validate Location volume uom code */
1578: --DBMS_output.put_line('Before validating the volume uom ');
1579:
1580: IF (p_volume_uom_code <> fnd_api.g_miss_char
1581: AND p_volume_uom_code IS NOT NULL) THEN
1582: BEGIN
1583: SELECT 1
1584: INTO l_chkflg

Line 1591: RAISE fnd_api.g_exc_error;

1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1590: fnd_msg_pub.ADD;
1591: RAISE fnd_api.g_exc_error;
1592: END;
1593: END IF;
1594:
1595: /* Validate Location Pick uom code */

Line 1597: IF (p_pick_uom_code <> fnd_api.g_miss_char

1593: END IF;
1594:
1595: /* Validate Location Pick uom code */
1596: --DBMS_output.put_line('Before validating the pick uom ');
1597: IF (p_pick_uom_code <> fnd_api.g_miss_char
1598: AND p_pick_uom_code IS NOT NULL) THEN
1599: BEGIN
1600: SELECT 1
1601: INTO l_chkflg

Line 1608: RAISE fnd_api.g_exc_error;

1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1607: fnd_msg_pub.ADD;
1608: RAISE fnd_api.g_exc_error;
1609: END;
1610: END IF;
1611:
1612: /* Validate Dimension uom code */

Line 1615: IF (p_dimension_uom_code <> fnd_api.g_miss_char

1611:
1612: /* Validate Dimension uom code */
1613: --DBMS_output.put_line('Before validating the dim uom ');
1614:
1615: IF (p_dimension_uom_code <> fnd_api.g_miss_char
1616: AND p_dimension_uom_code IS NOT NULL) THEN
1617: BEGIN
1618: SELECT 1
1619: INTO l_chkflg

Line 1626: RAISE fnd_api.g_exc_error;

1622: EXCEPTION
1623: WHEN NO_DATA_FOUND THEN
1624: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1625: fnd_msg_pub.ADD;
1626: RAISE fnd_api.g_exc_error;
1627: END;
1628: END IF;
1629:
1630: /* Validate Status code */

Line 1632: IF (p_status_id <> fnd_api.g_miss_num

1628: END IF;
1629:
1630: /* Validate Status code */
1631: -- --DBMS_output.put_line('Before validating the status ');
1632: IF (p_status_id <> fnd_api.g_miss_num
1633: AND p_status_id IS NOT NULL) THEN
1634: BEGIN
1635: SELECT 1
1636: INTO l_chkflg

Line 1644: RAISE fnd_api.g_exc_error;

1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN
1642: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: END;
1646: END IF;
1647: --DBMS_output.put_line('setting attribs');
1648: /* Validate the locator attributes passed by the user */

Line 1696: IF p_attribute1 = fnd_api.g_miss_char THEN

1692: IF p_attribute15 IS NOT NULL THEN
1693: cnt:=cnt+1;
1694: END IF;
1695:
1696: IF p_attribute1 = fnd_api.g_miss_char THEN
1697: l_inv_attributes_tbl (1) := NULL;
1698: ELSE
1699: l_inv_attributes_tbl (1) := p_attribute1;
1700: END IF;

Line 1701: IF p_attribute2 = fnd_api.g_miss_char THEN

1697: l_inv_attributes_tbl (1) := NULL;
1698: ELSE
1699: l_inv_attributes_tbl (1) := p_attribute1;
1700: END IF;
1701: IF p_attribute2 = fnd_api.g_miss_char THEN
1702: l_inv_attributes_tbl (2) := NULL;
1703: ELSE
1704: l_inv_attributes_tbl (2) := p_attribute2;
1705: END IF;

Line 1707: IF p_attribute3 = fnd_api.g_miss_char THEN

1703: ELSE
1704: l_inv_attributes_tbl (2) := p_attribute2;
1705: END IF;
1706:
1707: IF p_attribute3 = fnd_api.g_miss_char THEN
1708: l_inv_attributes_tbl (3) := NULL;
1709: ELSE
1710: l_inv_attributes_tbl (3) := p_attribute3;
1711: END IF;

Line 1713: IF p_attribute4 = fnd_api.g_miss_char THEN

1709: ELSE
1710: l_inv_attributes_tbl (3) := p_attribute3;
1711: END IF;
1712:
1713: IF p_attribute4 = fnd_api.g_miss_char THEN
1714: l_inv_attributes_tbl (4) := NULL;
1715: ELSE
1716: l_inv_attributes_tbl (4) := p_attribute4;
1717: END IF;

Line 1719: IF p_attribute5 = fnd_api.g_miss_char THEN

1715: ELSE
1716: l_inv_attributes_tbl (4) := p_attribute4;
1717: END IF;
1718:
1719: IF p_attribute5 = fnd_api.g_miss_char THEN
1720: l_inv_attributes_tbl (5) := NULL;
1721: ELSE
1722: l_inv_attributes_tbl (5) := p_attribute5;
1723: END IF;

Line 1725: IF p_attribute6 = fnd_api.g_miss_char THEN

1721: ELSE
1722: l_inv_attributes_tbl (5) := p_attribute5;
1723: END IF;
1724:
1725: IF p_attribute6 = fnd_api.g_miss_char THEN
1726: l_inv_attributes_tbl (6) := NULL;
1727: ELSE
1728: l_inv_attributes_tbl (6) := p_attribute6;
1729: END IF;

Line 1730: IF p_attribute7 = fnd_api.g_miss_char THEN

1726: l_inv_attributes_tbl (6) := NULL;
1727: ELSE
1728: l_inv_attributes_tbl (6) := p_attribute6;
1729: END IF;
1730: IF p_attribute7 = fnd_api.g_miss_char THEN
1731: l_inv_attributes_tbl (7) := NULL;
1732: ELSE
1733: l_inv_attributes_tbl (7) := p_attribute7;
1734: END IF;

Line 1735: IF p_attribute8 = fnd_api.g_miss_char THEN

1731: l_inv_attributes_tbl (7) := NULL;
1732: ELSE
1733: l_inv_attributes_tbl (7) := p_attribute7;
1734: END IF;
1735: IF p_attribute8 = fnd_api.g_miss_char THEN
1736: l_inv_attributes_tbl (8) := NULL;
1737: ELSE
1738: l_inv_attributes_tbl (8) := p_attribute8;
1739: END IF;

Line 1741: IF p_attribute9 = fnd_api.g_miss_char THEN

1737: ELSE
1738: l_inv_attributes_tbl (8) := p_attribute8;
1739: END IF;
1740:
1741: IF p_attribute9 = fnd_api.g_miss_char THEN
1742: l_inv_attributes_tbl (9) := NULL;
1743: ELSE
1744: l_inv_attributes_tbl (9) := p_attribute9;
1745: END IF;

Line 1746: IF p_attribute10 = fnd_api.g_miss_char THEN

1742: l_inv_attributes_tbl (9) := NULL;
1743: ELSE
1744: l_inv_attributes_tbl (9) := p_attribute9;
1745: END IF;
1746: IF p_attribute10 = fnd_api.g_miss_char THEN
1747: l_inv_attributes_tbl (10) := NULL;
1748: ELSE
1749: l_inv_attributes_tbl (10) := p_attribute10;
1750: END IF;

Line 1751: IF p_attribute11 = fnd_api.g_miss_char THEN

1747: l_inv_attributes_tbl (10) := NULL;
1748: ELSE
1749: l_inv_attributes_tbl (10) := p_attribute10;
1750: END IF;
1751: IF p_attribute11 = fnd_api.g_miss_char THEN
1752: l_inv_attributes_tbl (11) := NULL;
1753: ELSE
1754: l_inv_attributes_tbl (11) := p_attribute11;
1755: END IF;

Line 1756: IF p_attribute12 = fnd_api.g_miss_char THEN

1752: l_inv_attributes_tbl (11) := NULL;
1753: ELSE
1754: l_inv_attributes_tbl (11) := p_attribute11;
1755: END IF;
1756: IF p_attribute12 = fnd_api.g_miss_char THEN
1757: l_inv_attributes_tbl (12) := NULL;
1758: ELSE
1759: l_inv_attributes_tbl (12) := p_attribute12;
1760: END IF;

Line 1762: IF p_attribute13 = fnd_api.g_miss_char THEN

1758: ELSE
1759: l_inv_attributes_tbl (12) := p_attribute12;
1760: END IF;
1761:
1762: IF p_attribute13 = fnd_api.g_miss_char THEN
1763: l_inv_attributes_tbl (13) := NULL;
1764: ELSE
1765: l_inv_attributes_tbl (13) := p_attribute13;
1766: END IF;

Line 1768: IF p_attribute14 = fnd_api.g_miss_char THEN

1764: ELSE
1765: l_inv_attributes_tbl (13) := p_attribute13;
1766: END IF;
1767:
1768: IF p_attribute14 = fnd_api.g_miss_char THEN
1769: l_inv_attributes_tbl (14) := NULL;
1770: ELSE
1771: l_inv_attributes_tbl (14) := p_attribute14;
1772: END IF;

Line 1774: IF p_attribute15 = fnd_api.g_miss_char THEN

1770: ELSE
1771: l_inv_attributes_tbl (14) := p_attribute14;
1772: END IF;
1773:
1774: IF p_attribute15 = fnd_api.g_miss_char THEN
1775: l_inv_attributes_tbl (15) := NULL;
1776: ELSE
1777: l_inv_attributes_tbl (15) := p_attribute15;
1778: END IF;

Line 1794: RAISE fnd_api.g_exc_error;

1790: IF l_return_status = 'E' THEN
1791: --DBMS_output.put_line('Error from validate_loc_attr_info');
1792: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1797: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1798: fnd_msg_pub.ADD;

Line 1799: RAISE fnd_api.g_exc_unexpected_error;

1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1797: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1798: fnd_msg_pub.ADD;
1799: RAISE fnd_api.g_exc_unexpected_error;
1800: END IF;
1801: /* End locator DFF attributes validation */
1802:
1803: /* When the control is at this point, data supplied are valid.

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

1807:
1808: --DBMS_output.put_line('Before update ');
1809:
1810: UPDATE mtl_item_locations
1811: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1812: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1813: , inventory_location_type =
1814: DECODE(
1815: p_inventory_location_type

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

1808: --DBMS_output.put_line('Before update ');
1809:
1810: UPDATE mtl_item_locations
1811: SET description = DECODE(p_description, fnd_api.g_miss_char, description, p_description)
1812: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1813: , inventory_location_type =
1814: DECODE(
1815: p_inventory_location_type
1816: , fnd_api.g_miss_num, inventory_location_type

Line 1816: , fnd_api.g_miss_num, inventory_location_type

1812: , disable_date = DECODE(p_disabled_date, fnd_api.g_miss_date, disable_date, p_disabled_date)
1813: , inventory_location_type =
1814: DECODE(
1815: p_inventory_location_type
1816: , fnd_api.g_miss_num, inventory_location_type
1817: , p_inventory_location_type
1818: )
1819: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1820: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)

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

1815: p_inventory_location_type
1816: , fnd_api.g_miss_num, inventory_location_type
1817: , p_inventory_location_type
1818: )
1819: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1820: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1821: , location_weight_uom_code =
1822: DECODE(
1823: p_location_weight_uom_code

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

1816: , fnd_api.g_miss_num, inventory_location_type
1817: , p_inventory_location_type
1818: )
1819: , picking_order = DECODE(p_picking_order, fnd_api.g_miss_num, picking_order, p_picking_order)
1820: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1821: , location_weight_uom_code =
1822: DECODE(
1823: p_location_weight_uom_code
1824: , fnd_api.g_miss_char, location_weight_uom_code

Line 1824: , fnd_api.g_miss_char, location_weight_uom_code

1820: , location_maximum_units = DECODE(p_location_maximum_units, fnd_api.g_miss_num, location_maximum_units, p_location_maximum_units)
1821: , location_weight_uom_code =
1822: DECODE(
1823: p_location_weight_uom_code
1824: , fnd_api.g_miss_char, location_weight_uom_code
1825: , p_location_weight_uom_code
1826: )
1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)

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

1823: p_location_weight_uom_code
1824: , fnd_api.g_miss_char, location_weight_uom_code
1825: , p_location_weight_uom_code
1826: )
1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)

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

1824: , fnd_api.g_miss_char, location_weight_uom_code
1825: , p_location_weight_uom_code
1826: )
1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)

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

1825: , p_location_weight_uom_code
1826: )
1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)

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

1826: )
1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)

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

1827: , max_weight = DECODE(p_max_weight, fnd_api.g_miss_num, max_weight, p_max_weight)
1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)

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

1828: , volume_uom_code = DECODE(p_volume_uom_code, fnd_api.g_miss_char, volume_uom_code, p_volume_uom_code)
1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)

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

1829: , max_cubic_area = DECODE(p_max_cubic_area, fnd_api.g_miss_num, max_cubic_area, p_max_cubic_area)
1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)

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

1830: , x_coordinate = DECODE(p_x_coordinate, fnd_api.g_miss_num, x_coordinate, p_x_coordinate)
1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)

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

1831: , y_coordinate = DECODE(p_y_coordinate, fnd_api.g_miss_num, y_coordinate, p_y_coordinate)
1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)

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

1832: , z_coordinate = DECODE(p_z_coordinate, fnd_api.g_miss_num, z_coordinate, p_z_coordinate)
1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id

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

1833: , pick_uom_code = DECODE(p_pick_uom_code, fnd_api.g_miss_char, pick_uom_code, p_pick_uom_code)
1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE

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

1834: , dimension_uom_code = DECODE(p_dimension_uom_code, fnd_api.g_miss_char, dimension_uom_code, p_dimension_uom_code)
1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)

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

1835: , LENGTH = DECODE(p_length, fnd_api.g_miss_num, LENGTH, p_length)
1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)

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

1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)

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

1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)

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

1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)

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

1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)

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

1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)

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

1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)

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

1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)
1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)

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

1845: , attribute3 = decode(p_attribute3, NULL, attribute3, fnd_api.g_miss_char, NULL, p_attribute3)
1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)

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

1846: , attribute4 = decode(p_attribute4, NULL, attribute4, fnd_api.g_miss_char, NULL, p_attribute4)
1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)

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

1847: , attribute5 = decode(p_attribute5, NULL, attribute5, fnd_api.g_miss_char, NULL, p_attribute5)
1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)

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

1848: , attribute6 = decode(p_attribute6, NULL, attribute6, fnd_api.g_miss_char, NULL, p_attribute6)
1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)

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

1849: , attribute7 = decode(p_attribute7, NULL, attribute7, fnd_api.g_miss_char, NULL, p_attribute7)
1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1857: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)

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

1850: , attribute8 = decode(p_attribute8, NULL, attribute8, fnd_api.g_miss_char, NULL, p_attribute8)
1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1857: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1858: , alias = l_alias

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

1851: , attribute9 = decode(p_attribute9, NULL, attribute9, fnd_api.g_miss_char, NULL, p_attribute9)
1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1857: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1858: , alias = l_alias
1859: WHERE inventory_location_id = l_inventory_location_id

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

1852: , attribute10 = decode(p_attribute10, NULL, attribute10, fnd_api.g_miss_char, NULL, p_attribute10)
1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1857: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1858: , alias = l_alias
1859: WHERE inventory_location_id = l_inventory_location_id
1860: AND organization_id = l_organization_id;

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

1853: , attribute11 = decode(p_attribute11, NULL, attribute11, fnd_api.g_miss_char, NULL, p_attribute11)
1854: , attribute12 = decode(p_attribute12, NULL, attribute12, fnd_api.g_miss_char, NULL, p_attribute12)
1855: , attribute13 = decode(p_attribute13, NULL, attribute13, fnd_api.g_miss_char, NULL, p_attribute13)
1856: , attribute14 = decode(p_attribute14, NULL, attribute14, fnd_api.g_miss_char, NULL, p_attribute14)
1857: , attribute15 = decode(p_attribute15, NULL, attribute15, fnd_api.g_miss_char, NULL, p_attribute15)
1858: , alias = l_alias
1859: WHERE inventory_location_id = l_inventory_location_id
1860: AND organization_id = l_organization_id;
1861:

Line 1864: AND p_status_id <> fnd_api.g_miss_num

1860: AND organization_id = l_organization_id;
1861:
1862: /* If the p_status_id is not null then,stamp the new status in the status history table */
1863: IF (p_status_id IS NOT NULL
1864: AND p_status_id <> fnd_api.g_miss_num
1865: AND p_status_id <> l_status_id) THEN
1866:
1867: l_status_rec.organization_id := l_organization_id;
1868: l_status_rec.inventory_item_id := NULL;

Line 1886: WHEN fnd_api.g_exc_error THEN

1882: inv_material_status_pkg.insert_status_history(l_status_rec);
1883: END IF;
1884: --DBMS_output.put_line('End of procedure ');
1885: EXCEPTION
1886: WHEN fnd_api.g_exc_error THEN
1887: x_return_status := 'E';
1888: ROLLBACK TO locator_update;
1889: debug(l_procedure_name ||' Expected Error ');
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1886: WHEN fnd_api.g_exc_error THEN
1887: x_return_status := 'E';
1888: ROLLBACK TO locator_update;
1889: debug(l_procedure_name ||' Expected Error ');
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: WHEN fnd_api.g_exc_unexpected_error THEN
1892: x_return_status := 'U';
1893: ROLLBACK TO locator_update;
1894: debug(l_procedure_name ||'Unexpected Error ');

Line 1891: WHEN fnd_api.g_exc_unexpected_error THEN

1887: x_return_status := 'E';
1888: ROLLBACK TO locator_update;
1889: debug(l_procedure_name ||' Expected Error ');
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: WHEN fnd_api.g_exc_unexpected_error THEN
1892: x_return_status := 'U';
1893: ROLLBACK TO locator_update;
1894: debug(l_procedure_name ||'Unexpected Error ');
1895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1891: WHEN fnd_api.g_exc_unexpected_error THEN
1892: x_return_status := 'U';
1893: ROLLBACK TO locator_update;
1894: debug(l_procedure_name ||'Unexpected Error ');
1895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1896: WHEN OTHERS THEN
1897: x_return_status := 'U';
1898: ROLLBACK TO locator_update;
1899:

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

1900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1902: END IF;
1903: debug(l_procedure_name ||' Others '||SQLERRM);
1904: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1905: END update_locator;
1906:
1907: /*
1908: ** ---------------------------------------------------------------------------

Line 1977: x_return_status := fnd_api.g_ret_sts_success;

1973: BEGIN
1974: -- declare a savepoint
1975:
1976: SAVEPOINT location_item_restrict;
1977: x_return_status := fnd_api.g_ret_sts_success;
1978:
1979: /* If organization id passed use it, else use organization code */
1980: IF p_organization_id IS NOT NULL THEN
1981: l_organization_id := p_organization_id;

Line 1987: RAISE fnd_api.g_exc_error;

1983: IF p_organization_code IS NULL THEN
1984: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1985: /* Organization is required */
1986: fnd_msg_pub.ADD;
1987: RAISE fnd_api.g_exc_error;
1988: ELSE
1989: BEGIN
1990: SELECT organization_id
1991: INTO l_organization_id

Line 1999: RAISE fnd_api.g_exc_error;

1995: WHEN NO_DATA_FOUND THEN
1996: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1997: /* The Organization Code provided is invalid */
1998: fnd_msg_pub.ADD;
1999: RAISE fnd_api.g_exc_error;
2000: END;
2001: END IF;
2002: END IF;
2003:

Line 2012: RAISE fnd_api.g_exc_error;

2008: IF p_item IS NULL THEN
2009: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2010: /* Invalid item segments */
2011: fnd_msg_pub.ADD;
2012: RAISE fnd_api.g_exc_error;
2013: ELSE
2014: BEGIN
2015: SELECT inventory_item_id
2016: INTO l_inventory_item_id

Line 2025: RAISE fnd_api.g_exc_error;

2021: WHEN NO_DATA_FOUND THEN
2022: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2023: /* The Item provided is invalid */
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;
2026: END;
2027: END IF;
2028: END IF;
2029:

Line 2035: RAISE fnd_api.g_exc_error;

2031: IF p_subinventory_code IS NULL THEN
2032: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2033: /* Please enter a subinventory before proceeding */
2034: fnd_msg_pub.ADD;
2035: RAISE fnd_api.g_exc_error;
2036: ELSE
2037: BEGIN
2038: SELECT NVL(planning_level, 2)
2039: INTO l_planning_level

Line 2048: RAISE fnd_api.g_exc_error;

2044: WHEN NO_DATA_FOUND THEN
2045: fnd_message.set_name('INV', 'INVALID_SUB');
2046: /* The subinventory provided is invalid */
2047: fnd_msg_pub.ADD;
2048: RAISE fnd_api.g_exc_error;
2049: END;
2050: END IF;
2051:
2052: /* Validate The locator */

Line 2060: RAISE fnd_api.g_exc_error;

2056: IF p_locator IS NULL THEN
2057: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2058: /* Invalid locator segments */
2059: fnd_msg_pub.ADD;
2060: RAISE fnd_api.g_exc_error;
2061: ELSE
2062: BEGIN
2063: SELECT inventory_location_id
2064: INTO l_locator_id

Line 2073: RAISE fnd_api.g_exc_error;

2069: WHEN NO_DATA_FOUND THEN
2070: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2071: /* The Locator provided is invalid */
2072: fnd_msg_pub.ADD;
2073: RAISE fnd_api.g_exc_error;
2074: END;
2075: END IF;
2076: END IF;
2077:

Line 2090: RAISE fnd_api.g_exc_error;

2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: fnd_message.set_name('INV', 'INV_INT_LOCSEGEXP');
2089: /* The Locator segments are invalid for the given subinventory, organization combination */
2090: RAISE fnd_api.g_exc_error;
2091: END;
2092:
2093: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2094: BEGIN

Line 2118: RAISE fnd_api.g_exc_error;

2114: WHEN NO_DATA_FOUND THEN
2115: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2116: /* Invalid status ID. */
2117: fnd_msg_pub.ADD;
2118: RAISE fnd_api.g_exc_error;
2119: END;
2120: END IF;
2121:
2122: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */

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

2208: ELSE
2209: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2210: /* Locator selected has already been assigned to this item and subinventory */
2211: fnd_msg_pub.ADD;
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: END IF;
2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';

Line 2215: WHEN fnd_api.g_exc_error THEN

2211: fnd_msg_pub.ADD;
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: END IF;
2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';
2217: ROLLBACK TO location_item_restrict;
2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN

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

2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';
2217: ROLLBACK TO location_item_restrict;
2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: x_return_status := 'U';
2221: ROLLBACK TO location_item_restrict;
2222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2219: WHEN fnd_api.g_exc_unexpected_error THEN

2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';
2217: ROLLBACK TO location_item_restrict;
2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: x_return_status := 'U';
2221: ROLLBACK TO location_item_restrict;
2222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2223: WHEN OTHERS THEN

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

2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: x_return_status := 'U';
2221: ROLLBACK TO location_item_restrict;
2222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2223: WHEN OTHERS THEN
2224: x_return_status := 'U';
2225: --DBMS_output.put_line('In others '||sqlerrm);
2226: ROLLBACK TO location_item_restrict;

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

2228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2229: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2230: END IF;
2231:
2232: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2233: END create_loc_item_tie;
2234:
2235: /*
2236: **-----------------------------------------------------------------------------------

Line 2291: x_return_status := fnd_api.g_ret_sts_success;

2287: l_physical_locator_id NUMBER;
2288: l_val BOOLEAN;
2289: BEGIN
2290: SAVEPOINT del_loc_api;
2291: x_return_status := fnd_api.g_ret_sts_success;
2292:
2293: /* Check if the organization_id passed,otherwise get the organisation_id corresponding to the
2294: Non null organisation_code passed */
2295: IF p_organization_id IS NOT NULL THEN

Line 2309: RAISE fnd_api.g_exc_error;

2305: IF p_organization_code IS NULL THEN
2306: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2307: /* Organisation is required */
2308: fnd_msg_pub.ADD;
2309: RAISE fnd_api.g_exc_error;
2310: ELSE
2311: SELECT organization_id
2312: INTO l_organization_id
2313: FROM mtl_parameters

Line 2356: RAISE fnd_api.g_exc_error;

2352: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2353: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2354: /* LOCATOR does not exist */
2355: fnd_msg_pub.ADD;
2356: RAISE fnd_api.g_exc_error;
2357: ELSE
2358: l_locator := p_concatenated_segments;
2359: l_inventory_location_id := fnd_flex_keyval.combination_id;
2360: END IF;

Line 2384: RAISE fnd_api.g_exc_error;

2380: fnd_message.set_name('INV', 'INV_LOC_PHY');
2381: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2382: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2383: fnd_msg_pub.ADD;
2384: RAISE fnd_api.g_exc_error;
2385: EXCEPTION
2386: WHEN NO_DATA_FOUND THEN
2387: NULL;
2388: END;

Line 2409: RAISE fnd_api.g_exc_error;

2405: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2406: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2407: /*Locator locator cannot be deleted as it is active */
2408: fnd_msg_pub.ADD;
2409: RAISE fnd_api.g_exc_error;
2410: EXCEPTION
2411: WHEN NO_DATA_FOUND THEN
2412: NULL;
2413: END;

Line 2435: RAISE fnd_api.g_exc_error;

2431: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2432: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2433: /*Locator locator cannot be deleted as items exist in it*/
2434: fnd_msg_pub.ADD;
2435: RAISE fnd_api.g_exc_error;
2436: EXCEPTION
2437: WHEN NO_DATA_FOUND THEN
2438: NULL;
2439: END;

Line 2457: RAISE fnd_api.g_exc_error;

2453: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2454: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2455: /*The locator locator cannot be deleted as reservations exist against it*/
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: EXCEPTION
2459: WHEN NO_DATA_FOUND THEN
2460: NULL;
2461: END;

Line 2478: RAISE fnd_api.g_exc_error;

2474: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2475: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2476: /*Locator locator cannot be deleted as LPNs reside in it*/
2477: fnd_msg_pub.ADD;
2478: RAISE fnd_api.g_exc_error;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN
2481: NULL;
2482: END;

Line 2499: RAISE fnd_api.g_exc_error;

2495: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2496: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2497: /*Locator locator cannot be deleted as it is tied to an item */
2498: fnd_msg_pub.ADD;
2499: RAISE fnd_api.g_exc_error;
2500: EXCEPTION
2501: WHEN NO_DATA_FOUND THEN
2502: NULL;
2503: END;

Line 2520: RAISE fnd_api.g_exc_error;

2516: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2517: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2518: /*Locator locator cannot be deleted as there are pending transactions against it*/
2519: fnd_msg_pub.ADD;
2520: RAISE fnd_api.g_exc_error;
2521: EXCEPTION
2522: WHEN NO_DATA_FOUND THEN
2523: NULL;
2524: END;

Line 2547: RAISE fnd_api.g_exc_error;

2543: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2544: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2545: /*Locator locator cannot be deleted as there are pending transactions against it*/
2546: fnd_msg_pub.ADD;
2547: RAISE fnd_api.g_exc_error;
2548: EXCEPTION
2549: WHEN NO_DATA_FOUND THEN
2550: NULL;
2551: END;

Line 2568: RAISE fnd_api.g_exc_error;

2564: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2565: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2566: /*Locator locator cannot be deleted as there are pending transactions against it*/
2567: fnd_msg_pub.ADD;
2568: RAISE fnd_api.g_exc_error;
2569: EXCEPTION
2570: WHEN NO_DATA_FOUND THEN
2571: NULL;
2572: END;

Line 2582: WHEN fnd_api.g_exc_error THEN

2578: DELETE mtl_item_locations
2579: WHERE inventory_location_id = l_inventory_location_id
2580: AND organization_id = l_organization_id;
2581: EXCEPTION
2582: WHEN fnd_api.g_exc_error THEN
2583: x_return_status := fnd_api.g_ret_sts_error;
2584: ROLLBACK TO del_loc_api;
2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2583: x_return_status := fnd_api.g_ret_sts_error;

2579: WHERE inventory_location_id = l_inventory_location_id
2580: AND organization_id = l_organization_id;
2581: EXCEPTION
2582: WHEN fnd_api.g_exc_error THEN
2583: x_return_status := fnd_api.g_ret_sts_error;
2584: ROLLBACK TO del_loc_api;
2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2586: WHEN fnd_api.g_exc_unexpected_error THEN

2582: WHEN fnd_api.g_exc_error THEN
2583: x_return_status := fnd_api.g_ret_sts_error;
2584: ROLLBACK TO del_loc_api;
2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: ROLLBACK TO del_loc_api;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN NO_DATA_FOUND THEN

Line 2587: x_return_status := fnd_api.g_ret_sts_unexp_error;

2583: x_return_status := fnd_api.g_ret_sts_error;
2584: ROLLBACK TO del_loc_api;
2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: ROLLBACK TO del_loc_api;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN NO_DATA_FOUND THEN
2591: ROLLBACK TO del_loc_api;

Line 2592: x_return_status := fnd_api.g_ret_sts_error;

2588: ROLLBACK TO del_loc_api;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN NO_DATA_FOUND THEN
2591: ROLLBACK TO del_loc_api;
2592: x_return_status := fnd_api.g_ret_sts_error;
2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: ROLLBACK TO del_loc_api;
2596:

Line 2594: x_return_status := fnd_api.g_ret_sts_unexp_error;

2590: WHEN NO_DATA_FOUND THEN
2591: ROLLBACK TO del_loc_api;
2592: x_return_status := fnd_api.g_ret_sts_error;
2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: ROLLBACK TO del_loc_api;
2596:
2597: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2598: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');