DBA Data[Home] [Help]

APPS.IGC_CC_BC_ENABLE_PKG dependencies on FND_MSG_PUB

Line 55: FND_MSG_PUB.initialize ;

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

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

91: IF FND_API.To_Boolean ( p_commit ) THEN
92: COMMIT WORK;
93: END iF;
94:
95: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
96: p_data => x_msg_data );
97:
98: EXCEPTION
99:

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

100: WHEN FND_API.G_EXC_ERROR THEN
101:
102: ROLLBACK TO Insert_Row_Pvt ;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
105: p_data => x_msg_data );
106:
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108:

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

107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108:
109: ROLLBACK TO Insert_Row_Pvt ;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
112: p_data => x_msg_data );
113:
114: WHEN OTHERS THEN
115:

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

115:
116: ROLLBACK TO Insert_Row_Pvt ;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
121: l_api_name);
122: END if;
123:

Line 120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

116: ROLLBACK TO Insert_Row_Pvt ;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
121: l_api_name);
122: END if;
123:
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
121: l_api_name);
122: END if;
123:
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data );
126:
127: END Insert_Row;
128: /*-------------------------------------------------------------------------*/

Line 179: FND_MSG_PUB.initialize ;

175: END IF;
176:
177:
178: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
179: FND_MSG_PUB.initialize ;
180: END IF;
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS ;
183: p_row_locked := FND_API.G_TRUE ;

Line 191: FND_MSG_PUB.Add;

187: FETCH C INTO Recinfo;
188: IF (C%NOTFOUND) then
189: CLOSE C;
190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
191: FND_MSG_PUB.Add;
192: RAISE FND_API.G_EXC_ERROR ;
193: END IF;
194: CLOSE C;
195: IF ( (Recinfo.set_of_books_id = p_set_of_books_id)

Line 206: FND_MSG_PUB.Add;

202: ) THEN
203: Null;
204: ELSE
205: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
206: FND_MSG_PUB.Add;
207: RAISE FND_API.G_EXC_ERROR ;
208: END IF;
209:
210:

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

211: IF FND_API.To_Boolean ( p_commit ) THEN
212: COMMIT WORK;
213: END iF;
214:
215: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
216: p_data => x_msg_data );
217:
218: EXCEPTION
219:

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

221:
222: ROLLBACK TO Lock_Row_Pvt ;
223: p_row_locked := FND_API.G_FALSE;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_ERROR THEN
229:

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

228: WHEN FND_API.G_EXC_ERROR THEN
229:
230: ROLLBACK TO Lock_Row_Pvt ;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
233: p_data => x_msg_data );
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:

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

235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: ROLLBACK TO Lock_Row_Pvt ;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
240: p_data => x_msg_data );
241:
242: WHEN OTHERS THEN
243:

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

243:
244: ROLLBACK TO Lock_Row_Pvt ;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
248: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
249: l_api_name);
250: END if;
251:

Line 248: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

244: ROLLBACK TO Lock_Row_Pvt ;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
248: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
249: l_api_name);
250: END if;
251:
252: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

248: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
249: l_api_name);
250: END if;
251:
252: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
253: p_data => x_msg_data );
254:
255: END Lock_Row;
256: /* ----------------------------------------------------------------------- */

Line 301: FND_MSG_PUB.initialize ;

297: END IF;
298:
299:
300: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
301: FND_MSG_PUB.initialize ;
302: END IF;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS ;
305:

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

322: IF FND_API.To_Boolean ( p_commit ) THEN
323: COMMIT WORK;
324: END iF;
325:
326: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
327: p_data => x_msg_data );
328:
329: EXCEPTION
330:

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

331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: ROLLBACK TO Update_Row_Pvt ;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
336: p_data => x_msg_data );
337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339:

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

338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339:
340: ROLLBACK TO Update_Row_Pvt ;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
343: p_data => x_msg_data );
344:
345: WHEN OTHERS THEN
346:

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

346:
347: ROLLBACK TO Update_Row_Pvt ;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349:
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
352: l_api_name);
353: END if;
354:

Line 351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

347: ROLLBACK TO Update_Row_Pvt ;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349:
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
352: l_api_name);
353: END if;
354:
355: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
352: l_api_name);
353: END if;
354:
355: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
356: p_data => x_msg_data );
357:
358: END Update_Row;
359: /* ----------------------------------------------------------------------- */

Line 402: FND_MSG_PUB.initialize ;

398: END IF;
399:
400:
401: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize ;
403: END IF ;
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS ;
406:

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

418: IF FND_API.To_Boolean ( p_commit ) THEN
419: COMMIT WORK;
420: END iF;
421:
422: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
423: p_data => x_msg_data );
424:
425: EXCEPTION
426:

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

427: WHEN FND_API.G_EXC_ERROR THEN
428:
429: ROLLBACK TO Delete_Row_Pvt ;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
432: p_data => x_msg_data );
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:

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

434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: ROLLBACK TO Delete_Row_Pvt ;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
439: p_data => x_msg_data );
440:
441: WHEN OTHERS THEN
442:

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

442:
443: ROLLBACK TO Delete_Row_Pvt ;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
447: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
448: l_api_name);
449: END if;
450:

Line 447: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

443: ROLLBACK TO Delete_Row_Pvt ;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
447: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
448: l_api_name);
449: END if;
450:
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

447: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
448: l_api_name);
449: END if;
450:
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
452: p_data => x_msg_data );
453:
454: END Delete_Row;
455:

Line 507: FND_MSG_PUB.initialize ;

503: END IF;
504:
505:
506: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize ;
508: END IF;
509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS ;
511:

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

525: IF FND_API.To_Boolean ( p_commit ) THEN
526: COMMIT WORK;
527: END iF;
528:
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
530: p_data => x_msg_data );
531:
532: EXCEPTION
533:

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

534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: ROLLBACK TO Check_Unique_Pvt ;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
539: p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542:

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

541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542:
543: ROLLBACK TO Check_Unique_Pvt ;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
546: p_data => x_msg_data );
547:
548: WHEN OTHERS THEN
549:

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

549:
550: ROLLBACK TO Check_Unique_Pvt ;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552:
553: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
554: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
555: l_api_name);
556: END if;
557:

Line 554: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

550: ROLLBACK TO Check_Unique_Pvt ;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552:
553: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
554: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
555: l_api_name);
556: END if;
557:
558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

554: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
555: l_api_name);
556: END if;
557:
558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
559: p_data => x_msg_data );
560:
561: END Check_Unique;
562: /* ----------------------------------------------------------------------- */