DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_FLEX_KEYVAL

Line 706: fnd_flex_keyval.validate_segs(

702: */
703:
704: BEGIN
705: l_val :=
706: fnd_flex_keyval.validate_segs(
707: operation => 'FIND_COMBINATION'
708: , appl_short_name => 'INV'
709: , key_flex_code => 'MTLL'
710: , structure_number => 101

Line 718: x_inventory_location_id := fnd_flex_keyval.combination_id;

714: );
715:
716: IF l_val = TRUE THEN
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;

Line 844: fnd_flex_keyval.validate_segs(

840: --DBMS_output.put_line('Org id:' || to_char(l_organization_id));
841: --DBMS_output.put_line('Concat :' || p_concatenated_segments);
842:
843: l_keystat_val :=
844: fnd_flex_keyval.validate_segs(
845: operation => 'CREATE_COMB_NO_AT'
846: , appl_short_name => 'INV'
847: , key_flex_code => 'MTLL'
848: , structure_number => 101

Line 866: x_inventory_location_id := fnd_flex_keyval.combination_id;

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
869: x_locator_exists := 'N';
870:

Line 868: IF fnd_flex_keyval.new_combination THEN

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
869: x_locator_exists := 'N';
870:
871: --DBMS_output.put_line('in new combination loop ');
872:

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

1068: , attribute15 =p_attribute15
1069: , alias = l_alias
1070: WHERE organization_id = l_organization_id
1071: AND inventory_location_id = x_inventory_location_id;
1072: END IF; -- IF FND_FLEX_KEYVAL.new_combination
1073:
1074: IF x_locator_exists = 'N' THEN
1075: -- Stamp material status history
1076: --DBMS_output.put_line('locator_exists = N, populating history');

Line 1392: fnd_flex_keyval.validate_segs(

1388: END;
1389: */
1390: BEGIN
1391: l_val :=
1392: fnd_flex_keyval.validate_segs(
1393: operation => 'FIND_COMBINATION'
1394: , appl_short_name => 'INV'
1395: , key_flex_code => 'MTLL'
1396: , structure_number => 101

Line 1407: l_inventory_location_id := fnd_flex_keyval.combination_id;

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:
1410: END;
1411:

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

2317:
2318: /* Check the validity of p_inventory_location_id is not null.
2319: Check if this inventory_location_id exists in MTL_ITEM_LOCATIONS.
2320: Validate if concatenated_segment passed is valid or not.
2321: If the concatenated segments is not null and If it is valid,fnd_flex_keyval.combination_id
2322: will return the inventory_location_id for the Concatenated_segment combination.
2323: Otherwise the concatenated_segment passed is not a valid one.
2324: */
2325: IF p_inventory_location_id IS NOT NULL THEN

Line 2339: fnd_flex_keyval.validate_segs(

2335: l_locator := p_inventory_location_id;
2336: ELSE
2337: IF p_concatenated_segments IS NOT NULL THEN
2338: l_val :=
2339: fnd_flex_keyval.validate_segs(
2340: operation => 'FIND_COMBINATION'
2341: , appl_short_name => 'INV'
2342: , key_flex_code => 'MTLL'
2343: , structure_number => 101

Line 2359: l_inventory_location_id := fnd_flex_keyval.combination_id;

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;
2361: END IF;
2362:
2363: /*