eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on FND_API

Line 20: PROCEDURE Create_abc_assignments (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

16: This procedure is to validate and check whether to insert/update
17: for the input values assignment_group_id ,abc_class_id and item_id combination
18: ** */
19:
20: PROCEDURE Create_abc_assignments (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_api_version_number IN NUMBER,
23: p_assignment_group_id IN NUMBER,
24: p_inventory_item_id IN NUMBER,

Line 21: p_commit IN VARCHAR2 := fnd_api.g_false,

17: for the input values assignment_group_id ,abc_class_id and item_id combination
18: ** */
19:
20: PROCEDURE Create_abc_assignments (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_api_version_number IN NUMBER,
23: p_assignment_group_id IN NUMBER,
24: p_inventory_item_id IN NUMBER,
25: p_abc_class_id IN NUMBER,

Line 84: IF FND_API.to_Boolean(p_init_msg_list) THEN

80: Mydebug(l_api_name ||' : Begin create abc assignments API');
81: END IF;
82:
83: -- Initialize message list.
84: IF FND_API.to_Boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: l_item_id := p_inventory_item_id;

Line 100: RAISE fnd_api.g_exc_error;

96: fnd_message.Set_name('INV', 'INV_INVALID_PARAMETER_TYPE'); -- Need to create
97: fnd_message.set_token('VALUE1', 'Assignment Group id');
98: -- error when group id is null
99: fnd_msg_pub.ADD;
100: RAISE fnd_api.g_exc_error;
101: END IF;
102:
103: IF ( l_item_id IS NULL ) THEN
104: IF ( l_debug = 1 ) THEN

Line 111: RAISE fnd_api.g_exc_error;

107: fnd_message.Set_name('INV', 'INV_INVALID_PARAMETER_TYPE');
108: fnd_message.set_token('VALUE1', 'Inventory item id');
109: -- error when item id is null
110: fnd_msg_pub.ADD;
111: RAISE fnd_api.g_exc_error;
112: END IF;
113:
114: IF ( l_abc_class_id IS NULL ) THEN
115: IF ( l_debug = 1 ) THEN

Line 122: RAISE fnd_api.g_exc_error;

118: fnd_message.Set_name('INV', 'INV_INVALID_PARAMETER_TYPE'); -- Need to create
119: fnd_message.set_token('VALUE1', 'ABC Class id');
120: -- error when class id is null
121: fnd_msg_pub.ADD;
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:
125:
126: -- check_assignment_group : This cursor checks assignment_group_id

Line 138: RAISE fnd_api.g_exc_error;

134: Mydebug(l_api_name ||' Error : ABC Group id='|| l_assignment_group_id || ' not defined');
135: END IF;
136: fnd_message.Set_name('INV', 'INV_ABC_GROUP_NOT_EXISTS');
137: fnd_msg_pub.ADD;
138: RAISE fnd_api.g_exc_error;
139: END IF;
140:
141: CLOSE check_assignment_group;
142:

Line 156: RAISE fnd_api.g_exc_error;

152: Mydebug(l_api_name ||' Error : Inventory item id='|| l_item_id ||' not exists/active in the organization of ABC group ');
153: END IF;
154: fnd_message.Set_name('INV', 'INV_NO_ITEM_ORG');
155: fnd_msg_pub.ADD;
156: RAISE fnd_api.g_exc_error;
157: END IF;
158:
159: CLOSE check_item_exists;
160:

Line 174: RAISE fnd_api.g_exc_error;

170: Mydebug(l_api_name ||' Error : ABC Class='|| l_abc_class_id || ' not defined in the ABC Assignment group');
171: END IF;
172: fnd_message.Set_name('INV', 'INV_ABC_ITEM_ASSGN_NO_CLASSES');
173: fnd_msg_pub.ADD;
174: RAISE fnd_api.g_exc_error;
175: END IF;
176:
177: CLOSE check_abc_group_class_id;
178:

Line 241: p_encoded => FND_API.G_FALSE );

237:
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count,
240: p_data => x_msg_data,
241: p_encoded => FND_API.G_FALSE );
242:
243: EXCEPTION
244:
245: WHEN fnd_api.g_exc_error THEN

Line 245: WHEN fnd_api.g_exc_error THEN

241: p_encoded => FND_API.G_FALSE );
242:
243: EXCEPTION
244:
245: WHEN fnd_api.g_exc_error THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get
248: (
249: p_count => x_msg_count,

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242:
243: EXCEPTION
244:
245: WHEN fnd_api.g_exc_error THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get
248: (
249: p_count => x_msg_count,
250: p_data => x_msg_data,

Line 251: p_encoded => FND_API.G_FALSE

247: FND_MSG_PUB.Count_And_Get
248: (
249: p_count => x_msg_count,
250: p_data => x_msg_data,
251: p_encoded => FND_API.G_FALSE
252: );
253: WHEN OTHERS THEN
254: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
255: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'create_abc_assignments');

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

253: WHEN OTHERS THEN
254: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
255: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'create_abc_assignments');
256: END IF;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count,
261: p_data => x_msg_data,

Line 262: p_encoded => FND_API.G_FALSE

258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count,
261: p_data => x_msg_data,
262: p_encoded => FND_API.G_FALSE
263: );
264:
265: END create_abc_assignments;
266: