APPS.INV_LOC_WMS_PUB dependencies on FND_FLEX_KEYVAL

Line 764: fnd_flex_keyval.validate_segs(

760: */
761:
762: BEGIN
763: l_val :=
764: fnd_flex_keyval.validate_segs(
765: operation => 'FIND_COMBINATION'
766: , appl_short_name => 'INV'
767: , key_flex_code => 'MTLL'
768: , structure_number => 101

Line 776: x_inventory_location_id := fnd_flex_keyval.combination_id;

772: );
773:
774: IF l_val = TRUE THEN
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;

Line 912: fnd_flex_keyval.validate_segs(

908: --DBMS_output.put_line('Org id:' || to_char(l_organization_id));
909: --DBMS_output.put_line('Concat :' || p_concatenated_segments);
910:
911: l_keystat_val :=
912: fnd_flex_keyval.validate_segs(
913: operation => 'CREATE_COMB_NO_AT'
914: , appl_short_name => 'INV'
915: , key_flex_code => 'MTLL'
916: , structure_number => 101

Line 934: x_inventory_location_id := fnd_flex_keyval.combination_id;

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
937: x_locator_exists := 'N';
938:

Line 936: IF fnd_flex_keyval.new_combination THEN

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
937: x_locator_exists := 'N';
938:
939: --DBMS_output.put_line('in new combination loop ');
940:

Line 1158: END IF; -- IF FND_FLEX_KEYVAL.new_combination

1154: , attribute15 =p_attribute15
1155: , alias = l_alias
1156: WHERE organization_id = l_organization_id
1157: AND inventory_location_id = x_inventory_location_id;
1158: END IF; -- IF FND_FLEX_KEYVAL.new_combination
1159:
1160: IF x_locator_exists = 'N' THEN
1161: -- Stamp material status history
1162: --DBMS_output.put_line('locator_exists = N, populating history');

Line 1475: fnd_flex_keyval.validate_segs(

1471: END;
1472: */
1473: BEGIN
1474: l_val :=
1475: fnd_flex_keyval.validate_segs(
1476: operation => 'FIND_COMBINATION'
1477: , appl_short_name => 'INV'
1478: , key_flex_code => 'MTLL'
1479: , structure_number => 101

Line 1490: l_inventory_location_id := fnd_flex_keyval.combination_id;

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:
1493: END;
1494:

Line 2417: If the concatenated segments is not null and If it is valid,fnd_flex_keyval.combination_id

2413:
2414: /* Check the validity of p_inventory_location_id is not null.
2415: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.
2416: Validate if concatenated_segment passed is valid or not.
2417: If the concatenated segments is not null and If it is valid,fnd_flex_keyval.combination_id
2418: will return the inventory_location_id for the Concatenated_segment combination.
2419: Otherwise the concatenated_segment passed is not a valid one.
2420: */
2421: IF p_inventory_location_id IS NOT NULL THEN

Line 2435: fnd_flex_keyval.validate_segs(

2431: l_locator := p_inventory_location_id;
2432: ELSE
2433: IF p_concatenated_segments IS NOT NULL THEN
2434: l_val :=
2435: fnd_flex_keyval.validate_segs(
2436: operation => 'FIND_COMBINATION'
2437: , appl_short_name => 'INV'
2438: , key_flex_code => 'MTLL'
2439: , structure_number => 101

Line 2455: l_inventory_location_id := fnd_flex_keyval.combination_id;

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;
2457: END IF;
2458:
2459: /*