DBA Data[Home] [Help]

APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on FND_MSG_PUB

Line 85: FND_MSG_PUB.initialize;

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;
89: l_abc_class_id := p_abc_class_id;

Line 99: fnd_msg_pub.ADD;

95: END IF;
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

Line 110: fnd_msg_pub.ADD;

106: END IF;
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

Line 121: fnd_msg_pub.ADD;

117: END IF;
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:

Line 137: fnd_msg_pub.ADD;

133: IF ( l_debug = 1 ) THEN
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;

Line 155: fnd_msg_pub.ADD;

151: IF ( l_debug = 1 ) THEN
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;

Line 173: fnd_msg_pub.ADD;

169: IF ( l_debug = 1 ) THEN
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;

Line 205: fnd_msg_pub.ADD;

201: END IF;
202: fnd_message.Set_name('INV', 'INV_DUP');
203: -- this combination is already defined
204: fnd_message.set_token('VALUE1','This combination');
205: fnd_msg_pub.ADD;
206: ELSE
207: IF ( l_debug = 1 ) THEN
208: Mydebug(l_api_name || ' Updating existing record in the system with new class_id :'
209: || l_abc_class_id);

Line 238: FND_MSG_PUB.Count_And_Get

234: END IF;
235:
236: CLOSE chk_abc_assignments;
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:

Line 247: FND_MSG_PUB.Count_And_Get

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,
251: p_encoded => FND_API.G_FALSE

Line 254: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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');
256: END IF;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: FND_MSG_PUB.Count_And_Get

Line 255: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'create_abc_assignments');

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');
256: END IF;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: FND_MSG_PUB.Count_And_Get
259: (

Line 258: FND_MSG_PUB.Count_And_Get

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,
262: p_encoded => FND_API.G_FALSE

Line 310: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

306: , p_created_by);
307: EXCEPTION
308:
309: WHEN OTHERS THEN
310: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
311: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'insert_abc_assignments');
312: END IF;
313:
314: END insert_abc_assignments;

Line 311: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'insert_abc_assignments');

307: EXCEPTION
308:
309: WHEN OTHERS THEN
310: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
311: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'insert_abc_assignments');
312: END IF;
313:
314: END insert_abc_assignments;
315:

Line 348: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

344: AND inventory_item_id = p_inventory_item_id;
345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
349: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'update_abc_assignments');
350: END IF;
351:
352: END update_abc_assignments;

Line 349: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'update_abc_assignments');

345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
349: fnd_msg_pub.Add_exc_msg (g_pkg_name, 'update_abc_assignments');
350: END IF;
351:
352: END update_abc_assignments;
353: