DBA Data[Home] [Help]

APPS.IGC_CC_SEC_GROUP_USERS_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 127: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

123: IF FND_API.To_Boolean ( p_commit ) THEN
124: COMMIT WORK;
125: END iF;
126:
127: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
128: p_data => p_msg_data );
129:
130: EXCEPTION
131:

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

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

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

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

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

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

Line 152: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

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

Line 212: FND_MSG_PUB.initialize ;

208: END IF;
209:
210:
211: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
212: FND_MSG_PUB.initialize ;
213: END IF;
214:
215: p_return_status := FND_API.G_RET_STS_SUCCESS ;
216:

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

247: IF FND_API.To_Boolean ( p_commit ) THEN
248: COMMIT WORK;
249: END iF;
250:
251: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
252: p_data => p_msg_data );
253:
254: EXCEPTION
255:

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

256: WHEN FND_API.G_EXC_ERROR THEN
257:
258: ROLLBACK TO Update_Row_Pvt ;
259: p_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
261: p_data => p_msg_data );
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:

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

263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: ROLLBACK TO Update_Row_Pvt ;
266: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
268: p_data => p_msg_data );
269:
270: WHEN OTHERS THEN
271:

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

271:
272: ROLLBACK TO Update_Row_Pvt ;
273: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:
275: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
277: l_api_name);
278: END if;
279:

Line 276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
277: l_api_name);
278: END if;
279:
280: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
281: p_data => p_msg_data );
282:
283: END Update_Row;
284:

Line 358: FND_MSG_PUB.initialize ;

354: END IF;
355:
356:
357: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
358: FND_MSG_PUB.initialize ;
359: END IF;
360:
361: p_return_status := FND_API.G_RET_STS_SUCCESS ;
362: p_row_locked := FND_API.G_TRUE ;

Line 428: FND_MSG_PUB.Add;

424: ) THEN
425: RETURN;
426: ELSE
427: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
428: FND_MSG_PUB.Add;
429: RAISE FND_API.G_EXC_ERROR ;
430:
431: -- APP_EXCEPTION.RAISE_EXCEPTION;
432: END IF;

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

434: IF FND_API.To_Boolean ( p_commit ) THEN
435: COMMIT WORK;
436: END iF;
437:
438: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
439: p_data => p_msg_data );
440:
441: EXCEPTION
442:

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

444:
445: ROLLBACK TO Lock_Row_Pvt ;
446: p_row_locked := FND_API.G_FALSE;
447: p_return_status := FND_API.G_RET_STS_ERROR;
448: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
449: p_data => p_msg_data );
450:
451: WHEN FND_API.G_EXC_ERROR THEN
452:

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

451: WHEN FND_API.G_EXC_ERROR THEN
452:
453: ROLLBACK TO Lock_Row_Pvt ;
454: p_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
456: p_data => p_msg_data );
457:
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459:

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

458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459:
460: ROLLBACK TO Lock_Row_Pvt ;
461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
463: p_data => p_msg_data );
464:
465: WHEN OTHERS THEN
466:

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

466:
467: ROLLBACK TO Lock_Row_Pvt ;
468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
472: l_api_name);
473: END if;
474:

Line 471: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

467: ROLLBACK TO Lock_Row_Pvt ;
468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
472: l_api_name);
473: END if;
474:
475: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

471: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
472: l_api_name);
473: END if;
474:
475: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
476: p_data => p_msg_data );
477:
478: END Lock_Row;
479:

Line 515: FND_MSG_PUB.initialize ;

511: END IF;
512:
513:
514: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
515: FND_MSG_PUB.initialize ;
516: END IF ;
517:
518: p_return_status := FND_API.G_RET_STS_SUCCESS ;
519:

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

541: IF FND_API.To_Boolean ( p_commit ) THEN
542: COMMIT WORK;
543: END iF;
544:
545: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
546: p_data => p_msg_data );
547:
548: EXCEPTION
549:

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

550: WHEN FND_API.G_EXC_ERROR THEN
551:
552: ROLLBACK TO Delete_Row_Pvt ;
553: p_return_status := FND_API.G_RET_STS_ERROR;
554: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
555: p_data => p_msg_data );
556:
557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558:

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

557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558:
559: ROLLBACK TO Delete_Row_Pvt ;
560: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
562: p_data => p_msg_data );
563:
564: WHEN OTHERS THEN
565:

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

565:
566: ROLLBACK TO Delete_Row_Pvt ;
567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568:
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END if;
573:

Line 570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

566: ROLLBACK TO Delete_Row_Pvt ;
567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568:
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END if;
573:
574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END if;
573:
574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
575: p_data => p_msg_data );
576:
577: END DELETE_ROW;
578: