eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_YEAR_TYPE_PVT dependencies on FND_MSG_PUB

Line 44: FND_MSG_PUB.initialize;

40:
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42:
43: if FND_API.to_Boolean (p_init_msg_list) then
44: FND_MSG_PUB.initialize;
45: end if;
46:
47: -- Initialize API return status to success
48:

Line 61: FND_MSG_PUB.Add;

57: ( budget_year_type_id <> p_year_type_id)) ;
58: --
59: if l_seq_count > 0 then
60: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_YEAR_TYPE_SEQ');
61: FND_MSG_PUB.Add;
62: RAISE FND_API.G_EXC_ERROR;
63: end if;
64: --
65:

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

70: end if;
71:
72: -- Standard call to get message count and if count is 1, get message info.
73:
74: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
75: p_data => p_msg_data);
76:
77: EXCEPTION
78:

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

81: rollback to Check_Unique_Sequence;
82:
83: p_return_status := FND_API.G_RET_STS_ERROR;
84:
85: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
86: p_data => p_msg_data);
87:
88:
89: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

91: rollback to Check_Unique_Sequence ;
92:
93: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94:
95: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
96: p_data => p_msg_data);
97:
98:
99: when OTHERS then

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

101: rollback to Check_Unique_Sequence;
102:
103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:
105: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
106:
107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
108: l_api_name);
109: end if;

Line 107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:
105: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
106:
107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
108: l_api_name);
109: end if;
110:
111: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
108: l_api_name);
109: end if;
110:
111: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
112: p_data => p_msg_data);
113:
114: END Check_Unique_Sequence;
115: --

Line 162: FND_MSG_PUB.initialize;

158:
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160:
161: if FND_API.to_Boolean (p_init_msg_list) then
162: FND_MSG_PUB.initialize;
163: end if;
164:
165: -- Initialize API return status to success
166:

Line 177: FND_MSG_PUB.Add;

173: --
174: if p_year_type = 'PY' then
175: if p_year_type_seq > l_cy_min then
176: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');
177: FND_MSG_PUB.Add;
178: RAISE FND_API.G_EXC_ERROR;
179: end if;
180: --
181: if p_year_type_seq > l_pp_min then

Line 183: FND_MSG_PUB.Add;

179: end if;
180: --
181: if p_year_type_seq > l_pp_min then
182: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: end if;
186: end if;
187: --

Line 192: FND_MSG_PUB.Add;

188: --
189: if p_year_type = 'CY' then
190: if p_year_type_seq < l_py_max then
191: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');
192: FND_MSG_PUB.Add;
193: RAISE FND_API.G_EXC_ERROR;
194: end if;
195: --
196: if p_year_type_seq > l_pp_min then

Line 198: FND_MSG_PUB.Add;

194: end if;
195: --
196: if p_year_type_seq > l_pp_min then
197: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: end if;
201: end if;
202: --

Line 207: FND_MSG_PUB.Add;

203: --
204: if p_year_type = 'PP' then
205: if p_year_type_seq < l_cy_min then
206: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210: --
211: if p_year_type_seq < l_py_max then

Line 213: FND_MSG_PUB.Add;

209: end if;
210: --
211: if p_year_type_seq < l_py_max then
212: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');
213: FND_MSG_PUB.Add;
214: RAISE FND_API.G_EXC_ERROR;
215: end if;
216: end if;
217: --

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

224: end if;
225:
226: -- Standard call to get message count and if count is 1, get message info.
227:
228: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
229: p_data => p_msg_data);
230:
231: EXCEPTION
232:

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

235: rollback to Check_Sequence ;
236:
237: p_return_status := FND_API.G_RET_STS_ERROR;
238:
239: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
240: p_data => p_msg_data);
241:
242: when FND_API.G_EXC_UNEXPECTED_ERROR then
243:

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

244: rollback to Check_Sequence;
245:
246: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247:
248: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
249: p_data => p_msg_data);
250:
251:
252: when OTHERS then

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

254: rollback to Check_Sequence;
255:
256: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
259:
260: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
261: l_api_name);
262: end if;

Line 260: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

256: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
259:
260: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
261: l_api_name);
262: end if;
263:
264: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

260: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
261: l_api_name);
262: end if;
263:
264: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
265: p_data => p_msg_data);
266:
267: END Check_Sequence;
268: --

Line 304: FND_MSG_PUB.initialize;

300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302:
303: if FND_API.to_Boolean (p_init_msg_list) then
304: FND_MSG_PUB.initialize;
305: end if;
306:
307: -- Initialize API return status to success
308:

Line 321: FND_MSG_PUB.Add;

317: (budget_year_type_id <> p_year_type_id));
318: --
319: if l_cy_count > 0 then
320: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_CY_TYPE');
321: FND_MSG_PUB.Add;
322: RAISE FND_API.G_EXC_ERROR ;
323: end if;
324: -- End of API body.
325:

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

330: end if;
331:
332: -- Standard call to get message count and if count is 1, get message info.
333:
334: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
335: p_data => p_msg_data);
336:
337: EXCEPTION
338:

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

341: rollback to Check_CY_Count;
342:
343: p_return_status := FND_API.G_RET_STS_ERROR;
344:
345: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
346: p_data => p_msg_data);
347:
348:
349: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

351: rollback to Check_CY_Count;
352:
353: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
356: p_data => p_msg_data);
357:
358:
359: when OTHERS then

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

361: rollback to Check_CY_Count;
362:
363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364:
365: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
366:
367: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
368: l_api_name);
369: end if;

Line 367: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364:
365: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
366:
367: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
368: l_api_name);
369: end if;
370:
371: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

367: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
368: l_api_name);
369: end if;
370:
371: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
372: p_data => p_msg_data);
373:
374: END Check_CY_Count;
375: --

Line 411: FND_MSG_PUB.initialize;

407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.
409:
410: if FND_API.to_Boolean (p_init_msg_list) then
411: FND_MSG_PUB.initialize;
412: end if;
413:
414: -- Initialize API return status to success
415:

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

432: end if;
433:
434: -- Standard call to get message count and if count is 1, get message info.
435:
436: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
437: p_data => p_msg_data);
438:
439: EXCEPTION
440:

Line 444: FND_MSG_PUB.Add;

440:
441: when NO_DATA_FOUND then
442:
443: FND_MESSAGE.Set_Name('PSB', 'PSB_CANNOT_DELETE_YTP');
444: FND_MSG_PUB.Add;
445:
446: p_return_status := FND_API.G_RET_STS_ERROR;
447:
448: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

444: FND_MSG_PUB.Add;
445:
446: p_return_status := FND_API.G_RET_STS_ERROR;
447:
448: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
449: p_data => p_msg_data);
450:
451:
452: when FND_API.G_EXC_ERROR then

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

454: rollback to Check_Ref_Integrity;
455:
456: p_return_status := FND_API.G_RET_STS_ERROR;
457:
458: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
459: p_data => p_msg_data);
460:
461:
462: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

464: rollback to Check_Ref_Integrity;
465:
466: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
469: p_data => p_msg_data);
470:
471:
472: when OTHERS then

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

474: rollback to Check_Ref_Integrity;
475:
476: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
479:
480: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
481: l_api_name);
482: end if;

Line 480: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

476: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
479:
480: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
481: l_api_name);
482: end if;
483:
484:

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

481: l_api_name);
482: end if;
483:
484:
485: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
486: p_data => p_msg_data);
487:
488: END Check_Reference ;
489: --

Line 526: FND_MSG_PUB.initialize;

522:
523: -- Initialize message list if p_init_msg_list is set to TRUE.
524:
525: if FND_API.to_Boolean (p_init_msg_list) then
526: FND_MSG_PUB.initialize;
527: end if;
528:
529: -- Initialize API return status to success
530:

Line 543: FND_MSG_PUB.Add;

539: ( budget_year_type_id <> p_year_type_id)) ;
540: --
541: if l_seq_count > 0 then
542: FND_MESSAGE.Set_Name('PSB', 'PSB_DUPLICATE_NAME');
543: FND_MSG_PUB.Add;
544: RAISE FND_API.G_EXC_ERROR;
545: end if;
546: --
547:

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

552: end if;
553:
554: -- Standard call to get message count and if count is 1, get message info.
555:
556: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
557: p_data => p_msg_data);
558:
559: EXCEPTION
560:

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

563: rollback to Check_Unique_Name;
564:
565: p_return_status := FND_API.G_RET_STS_ERROR;
566:
567: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
568: p_data => p_msg_data);
569:
570:
571: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

573: rollback to Check_Unique_Name ;
574:
575: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576:
577: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
578: p_data => p_msg_data);
579:
580:
581: when OTHERS then

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

583: rollback to Check_Unique_Name;
584:
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:
589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
590: l_api_name);
591: end if;

Line 589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

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:
589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
590: l_api_name);
591: end if;
592:
593: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
590: l_api_name);
591: end if;
592:
593: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
594: p_data => p_msg_data);
595:
596: END Check_Unique_Name;
597: --

Line 668: FND_MSG_PUB.initialize;

664:
665: -- Initialize message list if p_init_msg_list is set to TRUE.
666:
667: if FND_API.to_Boolean (p_init_msg_list) then
668: FND_MSG_PUB.initialize;
669: end if;
670:
671: -- Initialize API return status to success
672:

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

739: end if;
740:
741: -- Standard call to get message count and if count is 1, get message info.
742:
743: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
744: p_data => p_msg_data);
745:
746: EXCEPTION
747:

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

750: rollback to Check_Unique_Name;
751:
752: p_return_status := FND_API.G_RET_STS_ERROR;
753:
754: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
755: p_data => p_msg_data);
756:
757:
758: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

760: rollback to Check_Unique_Name ;
761:
762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763:
764: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
765: p_data => p_msg_data);
766:
767:
768: when OTHERS then

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

770: rollback to Check_Unique_Name;
771:
772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
775:
776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
777: l_api_name);
778: end if;

Line 776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
775:
776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
777: l_api_name);
778: end if;
779:
780: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
777: l_api_name);
778: end if;
779:
780: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
781: p_data => p_msg_data);
782:
783: end INSERT_ROW;
784:

Line 840: FND_MSG_PUB.initialize;

836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838:
839: if FND_API.to_Boolean (p_init_msg_list) then
840: FND_MSG_PUB.initialize;
841: end if;
842:
843: -- Initialize API return status to success
844:

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

882: end if;
883:
884: -- Standard call to get message count and if count is 1, get message info.
885:
886: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
887: p_data => p_msg_data);
888:
889: EXCEPTION
890:

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

893: rollback to Check_Unique_Name;
894:
895: p_return_status := FND_API.G_RET_STS_ERROR;
896:
897: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
898: p_data => p_msg_data);
899:
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

903: rollback to Check_Unique_Name ;
904:
905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906:
907: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
908: p_data => p_msg_data);
909:
910:
911: when OTHERS then

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

913: rollback to Check_Unique_Name;
914:
915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:
917: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
918:
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
920: l_api_name);
921: end if;

Line 919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:
917: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
918:
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
920: l_api_name);
921: end if;
922:
923: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
920: l_api_name);
921: end if;
922:
923: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
924: p_data => p_msg_data);
925:
926: end LOCK_ROW;
927:

Line 971: FND_MSG_PUB.initialize;

967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969:
970: if FND_API.to_Boolean (p_init_msg_list) then
971: FND_MSG_PUB.initialize;
972: end if;
973:
974: -- Initialize API return status to success
975:

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

1008: end if;
1009:
1010: -- Standard call to get message count and if count is 1, get message info.
1011:
1012: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1013: p_data => p_msg_data);
1014:
1015: EXCEPTION
1016:

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

1019: rollback to Check_Unique_Name;
1020:
1021: p_return_status := FND_API.G_RET_STS_ERROR;
1022:
1023: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1024: p_data => p_msg_data);
1025:
1026:
1027: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

1029: rollback to Check_Unique_Name ;
1030:
1031: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032:
1033: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1034: p_data => p_msg_data);
1035:
1036:
1037: when OTHERS then

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

1039: rollback to Check_Unique_Name;
1040:
1041: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1042:
1043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1044:
1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1046: l_api_name);
1047: end if;

Line 1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1041: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1042:
1043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1044:
1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1046: l_api_name);
1047: end if;
1048:
1049: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1046: l_api_name);
1047: end if;
1048:
1049: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1050: p_data => p_msg_data);
1051:
1052: end UPDATE_ROW;
1053:

Line 1087: FND_MSG_PUB.initialize;

1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE.
1085:
1086: if FND_API.to_Boolean (p_init_msg_list) then
1087: FND_MSG_PUB.initialize;
1088: end if;
1089:
1090: -- Initialize API return status to success
1091:

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

1112: end if;
1113:
1114: -- Standard call to get message count and if count is 1, get message info.
1115:
1116: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1117: p_data => p_msg_data);
1118:
1119: EXCEPTION
1120:

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

1123: rollback to Check_Unique_Name;
1124:
1125: p_return_status := FND_API.G_RET_STS_ERROR;
1126:
1127: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1128: p_data => p_msg_data);
1129:
1130:
1131: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

1133: rollback to Check_Unique_Name ;
1134:
1135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1136:
1137: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1138: p_data => p_msg_data);
1139:
1140:
1141: when OTHERS then

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

1143: rollback to Check_Unique_Name;
1144:
1145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146:
1147: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1148:
1149: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1150: l_api_name);
1151: end if;

Line 1149: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146:
1147: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1148:
1149: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1150: l_api_name);
1151: end if;
1152:
1153: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

1149: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1150: l_api_name);
1151: end if;
1152:
1153: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1154: p_data => p_msg_data);
1155:
1156: end DELETE_ROW;
1157: