DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on INV_VALIDATE

Line 43: l_org INV_Validate.ORG;

39: -- BUG#2867331 added inventory_item_id
40: IS
41: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_org INV_Validate.ORG;
44: l_sub INV_Validate.SUB;
45: l_locator INV_Validate.LOCATOR;
46: l_result NUMBER;
47: l_cycle_count_schedule_id NUMBER;

Line 44: l_sub INV_Validate.SUB;

40: IS
41: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_org INV_Validate.ORG;
44: l_sub INV_Validate.SUB;
45: l_locator INV_Validate.LOCATOR;
46: l_result NUMBER;
47: l_cycle_count_schedule_id NUMBER;
48: l_cycle_count_header_id NUMBER;

Line 45: l_locator INV_Validate.LOCATOR;

41: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_org INV_Validate.ORG;
44: l_sub INV_Validate.SUB;
45: l_locator INV_Validate.LOCATOR;
46: l_result NUMBER;
47: l_cycle_count_schedule_id NUMBER;
48: l_cycle_count_header_id NUMBER;
49: l_unscheduled_count_entry NUMBER;

Line 95: l_result := INV_Validate.Organization(l_org);

91: print_debug('Opp Cycle Count Header Id: ' || p_cycle_count_header_id); -- For bug # 9751256
92: END IF;
93: /* Validate Organization ID */
94: l_org.organization_id := p_organization_id;
95: l_result := INV_Validate.Organization(l_org);
96: IF (l_result = INV_Validate.F) THEN
97: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;

Line 96: IF (l_result = INV_Validate.F) THEN

92: END IF;
93: /* Validate Organization ID */
94: l_org.organization_id := p_organization_id;
95: l_result := INV_Validate.Organization(l_org);
96: IF (l_result = INV_Validate.F) THEN
97: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;

Line 105: l_result := INV_Validate.subinventory(l_sub, l_org);

101:
102: /* Validate Subinventory */
103: IF (p_subinventory IS NOT NULL) THEN
104: l_sub.secondary_inventory_name := p_subinventory;
105: l_result := INV_Validate.subinventory(l_sub, l_org);
106: IF (l_result = INV_Validate.F) THEN
107: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;

Line 106: IF (l_result = INV_Validate.F) THEN

102: /* Validate Subinventory */
103: IF (p_subinventory IS NOT NULL) THEN
104: l_sub.secondary_inventory_name := p_subinventory;
105: l_result := INV_Validate.subinventory(l_sub, l_org);
106: IF (l_result = INV_Validate.F) THEN
107: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;

Line 122: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);

118: FND_MSG_PUB.ADD;
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: l_locator.inventory_location_id := p_locator_id;
122: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
123: IF (l_result = INV_Validate.F) THEN
124: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_ERROR;

Line 123: IF (l_result = INV_Validate.F) THEN

119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: l_locator.inventory_location_id := p_locator_id;
122: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
123: IF (l_result = INV_Validate.F) THEN
124: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;