DBA Data[Home] [Help]

APPS.PSB_ELEMENT_POS_SET_GROUPS_PVT dependencies on FND_MSG_PUB

Line 55: FND_MSG_PUB.initialize;

51:
52: -- Initialize message list if p_init_msg_list is set to TRUE.
53:
54: if FND_API.to_Boolean (p_init_msg_list) then
55: FND_MSG_PUB.initialize;
56: end if;
57:
58: -- Initialize API return status to success
59:

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

99: end if;
100:
101: -- Standard call to get message count and if count is 1, get message info.
102:
103: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
104: p_data => p_msg_data);
105:
106: EXCEPTION
107:

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

110: rollback to INSERT_ROW_PVT;
111:
112: p_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
115: p_data => p_msg_data);
116:
117:
118: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

120: rollback to INSERT_ROW_PVT;
121:
122: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123:
124: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
125: p_data => p_msg_data);
126:
127:
128: when OTHERS then

Line 134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

130: rollback to INSERT_ROW_PVT;
131:
132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133:
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
135:
136: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
137: l_api_name);
138: end if;

Line 136: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133:
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
135:
136: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
137: l_api_name);
138: end if;
139:
140: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

136: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
137: l_api_name);
138: end if;
139:
140: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
141: p_data => p_msg_data);
142:
143: END INSERT_ROW;
144:

Line 184: FND_MSG_PUB.initialize;

180:
181: -- Initialize message list if p_init_msg_list is set to TRUE.
182:
183: if FND_API.to_Boolean (p_init_msg_list) then
184: FND_MSG_PUB.initialize;
185: end if;
186:
187: -- Initialize API return status to success
188:

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

210: end if;
211:
212: -- Standard call to get message count and if count is 1, get message info.
213:
214: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
215: p_data => p_msg_data);
216:
217: EXCEPTION
218:

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

221: rollback to UPDATE_ROW_PVT;
222:
223: p_return_status := FND_API.G_RET_STS_ERROR;
224:
225: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
226: p_data => p_msg_data);
227:
228:
229: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

231: rollback to UPDATE_ROW_PVT;
232:
233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234:
235: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
236: p_data => p_msg_data);
237:
238:
239: when OTHERS then

Line 245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

241: rollback to UPDATE_ROW_PVT;
242:
243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244:
245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
246:
247: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
248: l_api_name);
249: end if;

Line 247: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244:
245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
246:
247: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
248: l_api_name);
249: end if;
250:
251: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

247: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
248: l_api_name);
249: end if;
250:
251: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
252: p_data => p_msg_data);
253:
254: END UPDATE_ROW;
255:

Line 292: FND_MSG_PUB.initialize;

288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290:
291: if FND_API.to_Boolean (p_init_msg_list) then
292: FND_MSG_PUB.initialize;
293: end if;
294:
295: --Deleting detail record from psb_pay_element_distributions and
296: --to maintain the isolated delete

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

310: end if;
311:
312: -- Standard call to get message count and if count is 1, get message info.
313:
314: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
315: p_data => p_msg_data);
316:
317: -- Standard check of p_commit.
318:

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

328: rollback to DELETE_ROW_PVT;
329:
330: p_return_status := FND_API.G_RET_STS_ERROR;
331:
332: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
333: p_data => p_msg_data);
334:
335:
336: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

338: rollback to DELETE_ROW_PVT;
339:
340: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341:
342: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
343: p_data => p_msg_data);
344:
345:
346: when OTHERS then

Line 352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

348: rollback to DELETE_ROW_PVT;
349:
350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351:
352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
353:
354: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
355: l_api_name);
356: end if;

Line 354: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351:
352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
353:
354: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
355: l_api_name);
356: end if;
357:
358: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

354: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
355: l_api_name);
356: end if;
357:
358: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
359: p_data => p_msg_data);
360: END DELETE_ROW;
361:
362: PROCEDURE LOCK_ROW(

Line 404: FND_MSG_PUB.initialize ;

400: END IF;
401: --
402:
403: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
404: FND_MSG_PUB.initialize ;
405: END IF;
406: --
407: p_return_status := FND_API.G_RET_STS_SUCCESS ;
408: p_row_locked := FND_API.G_TRUE ;

Line 416: FND_MSG_PUB.Add;

412: FETCH C INTO Recinfo;
413: IF (C%NOTFOUND) then
414: CLOSE C;
415: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
416: FND_MSG_PUB.Add;
417: RAISE FND_API.G_EXC_ERROR ;
418: END IF;
419:
420: IF

Line 432: FND_MSG_PUB.Add;

428: THEN
429: Null;
430: ELSE
431: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
432: FND_MSG_PUB.Add;
433: RAISE FND_API.G_EXC_ERROR ;
434: END IF;
435:
436: --

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

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

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

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

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

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

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

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

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

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

Line 474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END if;
477: --
478: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
479: p_data => p_msg_data );
480: END LOCK_ROW;
481:
482:

Line 537: FND_MSG_PUB.initialize ;

533: END IF;
534: --
535:
536: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
537: FND_MSG_PUB.initialize ;
538: END IF;
539: --
540: p_return_status := FND_API.G_RET_STS_SUCCESS ;
541: --

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 Check_Unique_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 Check_Unique_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 Check_Unique_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 Check_Unique_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: END Check_Unique;
596: /*---------------------------------------------------------------------------*/

Line 639: FND_MSG_PUB.initialize ;

635: END IF;
636: --
637:
638: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
639: FND_MSG_PUB.initialize ;
640: END IF;
641: --
642: p_return_status := FND_API.G_RET_STS_SUCCESS ;
643: --

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

659: IF FND_API.To_Boolean ( p_commit ) THEN
660: COMMIT WORK;
661: END iF;
662: --
663: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
664: p_data => p_msg_data );
665:
666: EXCEPTION
667: --

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

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

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

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

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

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

Line 688: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

688: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
689: l_api_name);
690: END if;
691: --
692: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
693: p_data => p_msg_data );
694: --
695: END Check_References;
696: