APPS.WMS_OP_DEST_SYS_APIS dependencies on INV_VALIDATE

Line 47: l_locator_rec inv_validate.LOCATOR;

43: IS
44: PRAGMA AUTONOMOUS_TRANSACTION;
45:
46: l_locator_id NUMBER;
47: l_locator_rec inv_validate.LOCATOR;
48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: l_success NUMBER;
50: l_organization_id inv_validate.org;
51: l_subinventory_code inv_validate.sub;

Line 50: l_organization_id inv_validate.org;

46: l_locator_id NUMBER;
47: l_locator_rec inv_validate.LOCATOR;
48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: l_success NUMBER;
50: l_organization_id inv_validate.org;
51: l_subinventory_code inv_validate.sub;
52: BEGIN
53: IF (l_debug = 1) THEN
54: print_debug('Entering create_pjm_locator ', 1);

Line 51: l_subinventory_code inv_validate.sub;

47: l_locator_rec inv_validate.LOCATOR;
48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: l_success NUMBER;
50: l_organization_id inv_validate.org;
51: l_subinventory_code inv_validate.sub;
52: BEGIN
53: IF (l_debug = 1) THEN
54: print_debug('Entering create_pjm_locator ', 1);
55: print_debug('x_Locator_Id : '|| x_Locator_Id, 4);

Line 109: print_debug('Before calling inv_validate.validatelocator', 4);

105: l_locator_rec.task_id := p_task_id;
106: l_locator_rec.segment19 := p_project_id;
107: l_locator_rec.segment20 := p_task_id;
108:
109: print_debug('Before calling inv_validate.validatelocator', 4);
110:
111: SELECT *
112: INTO l_organization_id
113: FROM mtl_parameters

Line 123: l_success := inv_validate.validatelocator

119: WHERE secondary_inventory_name = l_locator_rec.subinventory_code
120: AND organization_id = l_locator_rec.organization_id;
121:
122:
123: l_success := inv_validate.validatelocator
124: (
125: p_locator => l_locator_rec
126: , p_org => l_organization_id
127: , p_sub => l_subinventory_code

Line 128: , p_validation_mode => inv_validate.exists_or_create

124: (
125: p_locator => l_locator_rec
126: , p_org => l_organization_id
127: , p_sub => l_subinventory_code
128: , p_validation_mode => inv_validate.exists_or_create
129: , p_value_or_id => 'I'
130: );
131:
132: print_debug('After calling inv_validate.validatelocator', 4);

Line 132: print_debug('After calling inv_validate.validatelocator', 4);

128: , p_validation_mode => inv_validate.exists_or_create
129: , p_value_or_id => 'I'
130: );
131:
132: print_debug('After calling inv_validate.validatelocator', 4);
133:
134: COMMIT;
135:
136: IF (l_success = inv_validate.t

Line 136: IF (l_success = inv_validate.t

132: print_debug('After calling inv_validate.validatelocator', 4);
133:
134: COMMIT;
135:
136: IF (l_success = inv_validate.t
137: AND fnd_flex_keyval.new_combination
138: ) THEN
139:
140: print_debug('Created new logical locator ' || l_locator_rec.inventory_location_id, 4);