DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on INV_VALIDATE

Line 37: l_org INV_Validate.ORG;

33: -- BUG#2867331 added inventory_item_id
34: IS
35: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_org INV_Validate.ORG;
38: l_sub INV_Validate.SUB;
39: l_locator INV_Validate.LOCATOR;
40: l_result NUMBER;
41: l_cycle_count_schedule_id NUMBER;

Line 38: l_sub INV_Validate.SUB;

34: IS
35: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_org INV_Validate.ORG;
38: l_sub INV_Validate.SUB;
39: l_locator INV_Validate.LOCATOR;
40: l_result NUMBER;
41: l_cycle_count_schedule_id NUMBER;
42: l_cycle_count_header_id NUMBER;

Line 39: l_locator INV_Validate.LOCATOR;

35: l_api_name CONSTANT VARCHAR2(30) := 'Create_Unscheduled_Counts';
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_org INV_Validate.ORG;
38: l_sub INV_Validate.SUB;
39: l_locator INV_Validate.LOCATOR;
40: l_result NUMBER;
41: l_cycle_count_schedule_id NUMBER;
42: l_cycle_count_header_id NUMBER;
43: l_unscheduled_count_entry NUMBER;

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

76: print_debug('Inventory Item ID: ' || p_inventory_item_id);
77: END IF;
78: /* Validate Organization ID */
79: l_org.organization_id := p_organization_id;
80: l_result := INV_Validate.Organization(l_org);
81: IF (l_result = INV_Validate.F) THEN
82: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;

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

77: END IF;
78: /* Validate Organization ID */
79: l_org.organization_id := p_organization_id;
80: l_result := INV_Validate.Organization(l_org);
81: IF (l_result = INV_Validate.F) THEN
82: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;

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

86:
87: /* Validate Subinventory */
88: IF (p_subinventory IS NOT NULL) THEN
89: l_sub.secondary_inventory_name := p_subinventory;
90: l_result := INV_Validate.subinventory(l_sub, l_org);
91: IF (l_result = INV_Validate.F) THEN
92: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
93: FND_MSG_PUB.ADD;
94: RAISE FND_API.G_EXC_ERROR;

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

87: /* Validate Subinventory */
88: IF (p_subinventory IS NOT NULL) THEN
89: l_sub.secondary_inventory_name := p_subinventory;
90: l_result := INV_Validate.subinventory(l_sub, l_org);
91: IF (l_result = INV_Validate.F) THEN
92: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
93: FND_MSG_PUB.ADD;
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;

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

103: FND_MSG_PUB.ADD;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: l_locator.inventory_location_id := p_locator_id;
107: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
108: IF (l_result = INV_Validate.F) THEN
109: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');
110: FND_MSG_PUB.ADD;
111: RAISE FND_API.G_EXC_ERROR;

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

104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: l_locator.inventory_location_id := p_locator_id;
107: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
108: IF (l_result = INV_Validate.F) THEN
109: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');
110: FND_MSG_PUB.ADD;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;