DBA Data[Home] [Help]

APPS.IGC_CC_ROUTING_CTRLS_PKG dependencies on FND_MSG_PUB

Line 56: FND_MSG_PUB.initialize ;

52: END IF;
53:
54:
55: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize ;
57: END IF;
58:
59: x_return_status := FND_API.G_RET_STS_SUCCESS ;
60:

Line 105: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

101: IF FND_API.To_Boolean ( p_commit ) THEN
102: COMMIT WORK;
103: END iF;
104:
105: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
106: p_data => x_msg_data );
107:
108: EXCEPTION
109:

Line 114: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

110: WHEN FND_API.G_EXC_ERROR THEN
111:
112: ROLLBACK TO Insert_Row_Pvt ;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
115: p_data => x_msg_data );
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118:

Line 121: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118:
119: ROLLBACK TO Insert_Row_Pvt ;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
122: p_data => x_msg_data );
123:
124: WHEN OTHERS THEN
125:

Line 129: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

125:
126: ROLLBACK TO Insert_Row_Pvt ;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128:
129: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
131: l_api_name);
132: END if;
133:

Line 130: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

126: ROLLBACK TO Insert_Row_Pvt ;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128:
129: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
131: l_api_name);
132: END if;
133:
134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

130: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
131: l_api_name);
132: END if;
133:
134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
135: p_data => x_msg_data );
136:
137:
138: END Insert_Row;

Line 190: FND_MSG_PUB.initialize ;

186: END IF;
187:
188:
189: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
190: FND_MSG_PUB.initialize ;
191: END IF;
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS ;
194: p_row_locked := FND_API.G_TRUE ;

Line 203: FND_MSG_PUB.Add;

199: FETCH C INTO Recinfo;
200: if (C%NOTFOUND) then
201: CLOSE C;
202: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR ;
205: end if;
206: CLOSE C;
207: if (

Line 241: FND_MSG_PUB.Add;

237: ) then
238: return;
239: else
240: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_ERROR ;
243: end if;
244:
245: IF FND_API.To_Boolean ( p_commit ) THEN

Line 249: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

245: IF FND_API.To_Boolean ( p_commit ) THEN
246: COMMIT WORK;
247: END iF;
248:
249: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
250: p_data => x_msg_data );
251:
252: EXCEPTION
253:

Line 259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

255:
256: ROLLBACK TO Lock_Row_Pvt ;
257: p_row_locked := FND_API.G_FALSE;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: WHEN FND_API.G_EXC_ERROR THEN
263:

Line 266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

262: WHEN FND_API.G_EXC_ERROR THEN
263:
264: ROLLBACK TO Lock_Row_Pvt ;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
267: p_data => x_msg_data );
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:

Line 273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:
271: ROLLBACK TO Lock_Row_Pvt ;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
274: p_data => x_msg_data );
275:
276: WHEN OTHERS THEN
277:

Line 281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

277:
278: ROLLBACK TO Lock_Row_Pvt ;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
283: l_api_name);
284: END if;
285:

Line 282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

278: ROLLBACK TO Lock_Row_Pvt ;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
283: l_api_name);
284: END if;
285:
286: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 286: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
283: l_api_name);
284: END if;
285:
286: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
287: p_data => x_msg_data );
288:
289: END Lock_Row;
290:

Line 335: FND_MSG_PUB.initialize ;

331: END IF;
332:
333:
334: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
335: FND_MSG_PUB.initialize ;
336: END IF;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS ;
339:

Line 365: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

361: IF FND_API.To_Boolean ( p_commit ) THEN
362: COMMIT WORK;
363: END iF;
364:
365: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
366: p_data => x_msg_data );
367:
368: EXCEPTION
369:

Line 374: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

370: WHEN FND_API.G_EXC_ERROR THEN
371:
372: ROLLBACK TO Update_Row_Pvt ;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
375: p_data => x_msg_data );
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378:

Line 381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378:
379: ROLLBACK TO Update_Row_Pvt ;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data );
383:
384: WHEN OTHERS THEN
385:

Line 389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

385:
386: ROLLBACK TO Update_Row_Pvt ;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388:
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
390: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
391: l_api_name);
392: END if;
393:

Line 390: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

386: ROLLBACK TO Update_Row_Pvt ;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388:
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
390: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
391: l_api_name);
392: END if;
393:
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

390: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
391: l_api_name);
392: END if;
393:
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
395: p_data => x_msg_data );
396:
397:
398: END Update_Row;

Line 429: FND_MSG_PUB.initialize ;

425: END IF;
426:
427:
428: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
429: FND_MSG_PUB.initialize ;
430: END IF ;
431:
432: x_return_status := FND_API.G_RET_STS_SUCCESS ;
433:

Line 444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

440: IF FND_API.To_Boolean ( p_commit ) THEN
441: COMMIT WORK;
442: END iF;
443:
444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
445: p_data => x_msg_data );
446:
447: EXCEPTION
448:

Line 453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

449: WHEN FND_API.G_EXC_ERROR THEN
450:
451: ROLLBACK TO Delete_Row_Pvt ;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data );
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457:

Line 460: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457:
458: ROLLBACK TO Delete_Row_Pvt ;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
461: p_data => x_msg_data );
462:
463: WHEN OTHERS THEN
464:

Line 468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

464:
465: ROLLBACK TO Delete_Row_Pvt ;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
470: l_api_name);
471: END if;
472:

Line 469: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

465: ROLLBACK TO Delete_Row_Pvt ;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
470: l_api_name);
471: END if;
472:
473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

469: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
470: l_api_name);
471: END if;
472:
473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
474: p_data => x_msg_data );
475:
476:
477: END Delete_Row;