DBA Data[Home] [Help]

APPS.IGC_CC_SEC_GROUP_PKG dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize ;

57: END IF;
58:
59:
60: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize ;
62: END IF;
63:
64: p_return_status := FND_API.G_RET_STS_SUCCESS ;
65:

Line 131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

127: IF FND_API.To_Boolean ( p_commit ) THEN
128: COMMIT WORK;
129: END iF;
130:
131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
132: p_data => p_msg_data );
133: EXCEPTION
134:
135: WHEN FND_API.G_EXC_ERROR THEN

Line 139: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

135: WHEN FND_API.G_EXC_ERROR THEN
136:
137: ROLLBACK TO Insert_Row_Pvt ;
138: p_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
140: p_data => p_msg_data );
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143:

Line 146: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143:
144: ROLLBACK TO Insert_Row_Pvt ;
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
147: p_data => p_msg_data );
148:
149: WHEN OTHERS THEN
150:

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

150:
151: ROLLBACK TO Insert_Row_Pvt ;
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
155: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
156: l_api_name);
157: END if;
158:

Line 155: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

151: ROLLBACK TO Insert_Row_Pvt ;
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
155: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
156: l_api_name);
157: END if;
158:
159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

155: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
156: l_api_name);
157: END if;
158:
159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
160: p_data => p_msg_data );
161:
162:
163: END Insert_Row;

Line 215: FND_MSG_PUB.initialize ;

211: END IF;
212:
213:
214: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
215: FND_MSG_PUB.initialize ;
216: END IF;
217:
218: p_return_status := FND_API.G_RET_STS_SUCCESS ;
219:

Line 255: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

251: IF FND_API.To_Boolean ( p_commit ) THEN
252: COMMIT WORK;
253: END iF;
254:
255: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
256: p_data => p_msg_data );
257:
258: EXCEPTION
259:

Line 264: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

260: WHEN FND_API.G_EXC_ERROR THEN
261:
262: ROLLBACK TO Update_Row_Pvt ;
263: p_return_status := FND_API.G_RET_STS_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
265: p_data => p_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268:

Line 271: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268:
269: ROLLBACK TO Update_Row_Pvt ;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
272: p_data => p_msg_data );
273:
274: WHEN OTHERS THEN
275:

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

275:
276: ROLLBACK TO Update_Row_Pvt ;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
281: l_api_name);
282: END if;
283:

Line 280: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

276: ROLLBACK TO Update_Row_Pvt ;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
281: l_api_name);
282: END if;
283:
284: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 284: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

280: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
281: l_api_name);
282: END if;
283:
284: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
285: p_data => p_msg_data );
286:
287: END Update_Row;
288:

Line 366: FND_MSG_PUB.initialize ;

362: END IF;
363:
364:
365: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
366: FND_MSG_PUB.initialize ;
367: END IF;
368:
369: p_return_status := FND_API.G_RET_STS_SUCCESS ;
370: p_row_locked := FND_API.G_TRUE ;

Line 440: FND_MSG_PUB.Add;

436: ) THEN
437: RETURN;
438: ELSE
439: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
440: FND_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_ERROR ;
442: -- APP_EXCEPTION.RAISE_EXCEPTION;
443: END IF;
444:

Line 449: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

445: IF FND_API.To_Boolean ( p_commit ) THEN
446: COMMIT WORK;
447: END iF;
448:
449: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
450: p_data => p_msg_data );
451:
452: EXCEPTION
453:

Line 459: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

455:
456: ROLLBACK TO Lock_Row_Pvt ;
457: p_row_locked := FND_API.G_FALSE;
458: p_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
460: p_data => p_msg_data );
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463:

Line 466: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: ROLLBACK TO Lock_Row_Pvt ;
465: p_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
467: p_data => p_msg_data );
468:
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470:

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

469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470:
471: ROLLBACK TO Lock_Row_Pvt ;
472: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
474: p_data => p_msg_data );
475:
476: WHEN OTHERS THEN
477:

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

477:
478: ROLLBACK TO Lock_Row_Pvt ;
479: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480:
481: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
483: l_api_name);
484: END if;
485:

Line 482: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

478: ROLLBACK TO Lock_Row_Pvt ;
479: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480:
481: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
483: l_api_name);
484: END if;
485:
486: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 486: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

482: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
483: l_api_name);
484: END if;
485:
486: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
487: p_data => p_msg_data );
488:
489: END Lock_Row;
490:

Line 526: FND_MSG_PUB.initialize ;

522: END IF;
523:
524:
525: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
526: FND_MSG_PUB.initialize ;
527: END IF ;
528:
529: p_return_status := FND_API.G_RET_STS_SUCCESS ;
530:

Line 563: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

559: IF FND_API.To_Boolean ( p_commit ) THEN
560: COMMIT WORK;
561: END iF;
562:
563: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
564: p_data => p_msg_data );
565:
566: EXCEPTION
567:

Line 572: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

568: WHEN FND_API.G_EXC_ERROR THEN
569:
570: ROLLBACK TO Delete_Row_Pvt ;
571: p_return_status := FND_API.G_RET_STS_ERROR;
572: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
573: p_data => p_msg_data );
574:
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576:

Line 579: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576:
577: ROLLBACK TO Delete_Row_Pvt ;
578: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
580: p_data => p_msg_data );
581:
582: WHEN OTHERS THEN
583:

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

583:
584: ROLLBACK TO Delete_Row_Pvt ;
585: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586:
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
588: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
589: l_api_name);
590: END IF;
591:

Line 588: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

584: ROLLBACK TO Delete_Row_Pvt ;
585: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586:
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
588: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
589: l_api_name);
590: END IF;
591:
592: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 592: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

588: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
589: l_api_name);
590: END IF;
591:
592: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
593: p_data => p_msg_data );
594:
595:
596: END DELETE_ROW;

Line 634: -- FND_MSG_PUB.initialize ;

630: -- END IF;
631:
632:
633: -- IF FND_API.to_Boolean ( p_init_msg_list ) THEN
634: -- FND_MSG_PUB.initialize ;
635: -- END IF;
636:
637: -- p_return_status := FND_API.G_RET_STS_SUCCESS ;
638:

Line 660: -- FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

656: -- COMMIT WORK;
657:
658: -- END IF;
659:
660: -- FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
661: -- p_data => p_msg_data );
662: --
663:
664: /* EXCEPTION

Line 670: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

666: WHEN FND_API.G_EXC_ERROR THEN
667:
668: ROLLBACK TO Check_Unique_Pvt ;
669: p_return_status := FND_API.G_RET_STS_ERROR;
670: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
671: p_data => p_msg_data );
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674:

Line 677: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674:
675: ROLLBACK TO Check_Unique_Pvt ;
676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
678: p_data => p_msg_data );
679:
680: WHEN OTHERS THEN
681:

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

681:
682: ROLLBACK TO Check_Unique_Pvt ;
683: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684:
685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
686: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
687: l_api_name);
688: END if;
689:

Line 686: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

682: ROLLBACK TO Check_Unique_Pvt ;
683: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684:
685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
686: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
687: l_api_name);
688: END if;
689:
690: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 690: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

686: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
687: l_api_name);
688: END if;
689:
690: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
691: p_data => p_msg_data );
692: */
693:
694: END CHECK_UNIQUE;