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_FLEX_MAPPING_PVT dependencies on FND_MSG_PUB

Line 67: FND_MSG_PUB.initialize ;

63: END IF;
64: --
65:
66: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize ;
68: END IF;
69: --
70: p_return_status := FND_API.G_RET_STS_SUCCESS ;
71: --

Line 87: FND_MSG_PUB.Add ;

83: P_LAST_UPDATE_LOGIN := -1;
84: end if;
85: else
86: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
87: FND_MSG_PUB.Add ;
88: raise FND_API.G_EXC_ERROR;
89: end if;
90: --
91:

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

132: IF FND_API.To_Boolean ( p_commit ) THEN
133: COMMIT WORK;
134: END iF;
135: --
136: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
137: p_data => p_msg_data );
138: --
139: EXCEPTION
140: --

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

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

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

148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: --
150: ROLLBACK TO Insert_Row_Pvt ;
151: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
153: p_data => p_msg_data );
154: --
155: WHEN OTHERS THEN
156: --

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

156: --
157: ROLLBACK TO Insert_Row_Pvt ;
158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: --
160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
161: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
162: l_api_name);
163: END if;
164: --

Line 161: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

157: ROLLBACK TO Insert_Row_Pvt ;
158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: --
160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
161: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
162: l_api_name);
163: END if;
164: --
165: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

161: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
162: l_api_name);
163: END if;
164: --
165: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
166: p_data => p_msg_data );
167: --
168: END Insert_Row;
169: /*-------------------------------------------------------------------------*/

Line 232: FND_MSG_PUB.initialize ;

228: END IF;
229: --
230:
231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
232: FND_MSG_PUB.initialize ;
233: END IF;
234: --
235: p_return_status := FND_API.G_RET_STS_SUCCESS ;
236: p_row_locked := FND_API.G_TRUE ;

Line 244: FND_MSG_PUB.Add;

240: FETCH C INTO Recinfo;
241: IF (C%NOTFOUND) then
242: CLOSE C;
243: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
244: FND_MSG_PUB.Add;
245: CLOSE c;
246: RAISE FND_API.G_EXC_ERROR ;
247: END IF;
248: CLOSE C;

Line 270: FND_MSG_PUB.Add ;

266: THEN
267: NULL ;
268: ELSE
269: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED') ;
270: FND_MSG_PUB.Add ;
271: RAISE FND_API.G_EXC_ERROR ;
272: END IF;
273:
274: --

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

276: IF FND_API.To_Boolean ( p_commit ) THEN
277: COMMIT WORK;
278: END iF;
279: --
280: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
281: p_data => p_msg_data );
282: */
283: --
284: EXCEPTION

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

292: WHEN FND_API.G_EXC_ERROR THEN
293: --
294: ROLLBACK TO Lock_Row_Pvt ;
295: p_return_status := FND_API.G_RET_STS_ERROR;
296: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
297: p_data => p_msg_data );
298: --
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: --

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

299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: --
301: ROLLBACK TO Lock_Row_Pvt ;
302: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
304: p_data => p_msg_data );
305: --
306: WHEN OTHERS THEN
307: --

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

307: --
308: ROLLBACK TO Lock_Row_Pvt ;
309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: --
311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
313: l_api_name);
314: END if;
315: --

Line 312: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

308: ROLLBACK TO Lock_Row_Pvt ;
309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: --
311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
313: l_api_name);
314: END if;
315: --
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

312: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
313: l_api_name);
314: END if;
315: --
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
317: p_data => p_msg_data );
318: --
319: END Lock_Row;
320: /* ----------------------------------------------------------------------- */

Line 373: FND_MSG_PUB.initialize ;

369: END IF;
370: --
371:
372: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
373: FND_MSG_PUB.initialize ;
374: END IF;
375: --
376: p_return_status := FND_API.G_RET_STS_SUCCESS ;
377: --

Line 394: FND_MSG_PUB.Add ;

390: P_LAST_UPDATE_LOGIN := -1;
391: end if;
392: else
393: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
394: FND_MSG_PUB.Add ;
395: raise FND_API.G_EXC_ERROR ;
396: end if;
397: --
398: UPDATE psb_flex_mapping_set_values

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

421: COMMIT WORK;
422: END iF;
423: --
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
426: p_data => p_msg_data );
427: --
428: EXCEPTION
429:

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

430: WHEN FND_API.G_EXC_ERROR THEN
431: --
432: ROLLBACK TO Update_Row_Pvt ;
433: p_return_status := FND_API.G_RET_STS_ERROR;
434: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
435: p_data => p_msg_data );
436: --
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: --

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

437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: --
439: ROLLBACK TO Update_Row_Pvt ;
440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
442: p_data => p_msg_data );
443: --
444: WHEN OTHERS THEN
445: --

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

445: --
446: ROLLBACK TO Update_Row_Pvt ;
447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: --
449: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
450: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
451: l_api_name);
452: END if;
453: --

Line 450: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

446: ROLLBACK TO Update_Row_Pvt ;
447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: --
449: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
450: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
451: l_api_name);
452: END if;
453: --
454: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

450: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
451: l_api_name);
452: END if;
453: --
454: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
455: p_data => p_msg_data );
456: --
457: END Update_Row;
458: /* ----------------------------------------------------------------------- */

Line 498: FND_MSG_PUB.initialize ;

494: END IF;
495: --
496:
497: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
498: FND_MSG_PUB.initialize ;
499: END IF;
500: --
501: p_return_status := FND_API.G_RET_STS_SUCCESS ;
502: --

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

515: IF FND_API.To_Boolean ( p_commit ) THEN
516: COMMIT WORK;
517: END iF;
518: --
519: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
520: p_data => p_msg_data );
521:
522: EXCEPTION
523: --

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

524: WHEN FND_API.G_EXC_ERROR THEN
525: --
526: ROLLBACK TO Delete_Row_Pvt ;
527: p_return_status := FND_API.G_RET_STS_ERROR;
528: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
529: p_data => p_msg_data );
530: --
531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
532: --

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

531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
532: --
533: ROLLBACK TO Delete_Row_Pvt ;
534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
536: p_data => p_msg_data );
537: --
538: WHEN OTHERS THEN
539: --

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

539: --
540: ROLLBACK TO Delete_Row_Pvt ;
541: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: --
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
545: l_api_name);
546: END if;
547: --

Line 544: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

540: ROLLBACK TO Delete_Row_Pvt ;
541: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: --
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
545: l_api_name);
546: END if;
547: --
548: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

544: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
545: l_api_name);
546: END if;
547: --
548: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
549: p_data => p_msg_data );
550: --
551: END Delete_Row;
552: /* ----------------------------------------------------------------------- */

Line 610: FND_MSG_PUB.initialize ;

606: END IF;
607: --
608:
609: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
610: FND_MSG_PUB.initialize ;
611: END IF;
612: --
613: p_return_status := FND_API.G_RET_STS_SUCCESS ;
614: --

Line 630: FND_MSG_PUB.Add ;

626: P_LAST_UPDATE_LOGIN := -1;
627: end if;
628: else
629: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
630: FND_MSG_PUB.Add ;
631: raise FND_API.G_EXC_ERROR;
632: end if;
633: --
634:

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

668: IF FND_API.To_Boolean ( p_commit ) THEN
669: COMMIT WORK;
670: END iF;
671: --
672: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
673: p_data => p_msg_data );
674: --
675: EXCEPTION
676: --

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

677: WHEN FND_API.G_EXC_ERROR THEN
678: --
679: ROLLBACK TO Sets_Insert_Row_Pvt ;
680: p_return_status := FND_API.G_RET_STS_ERROR;
681: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
682: p_data => p_msg_data );
683: --
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: --

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

684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: --
686: ROLLBACK TO Sets_Insert_Row_Pvt ;
687: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
689: p_data => p_msg_data );
690: --
691: WHEN OTHERS THEN
692: --

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

692: --
693: ROLLBACK TO Sets_Insert_Row_Pvt ;
694: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: --
696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
697: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
698: l_api_name);
699: END if;
700: --

Line 697: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

693: ROLLBACK TO Sets_Insert_Row_Pvt ;
694: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: --
696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
697: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
698: l_api_name);
699: END if;
700: --
701: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

697: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
698: l_api_name);
699: END if;
700: --
701: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
702: p_data => p_msg_data );
703: --
704: END Sets_Insert_Row;
705: /*==========================================================================+

Line 741: FND_MSG_PUB.initialize ;

737: END IF;
738: --
739:
740: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
741: FND_MSG_PUB.initialize ;
742: END IF;
743: --
744: p_return_status := FND_API.G_RET_STS_SUCCESS ;
745: --

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

757: IF FND_API.To_Boolean ( p_commit ) THEN
758: COMMIT WORK;
759: END iF;
760: --
761: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
762: p_data => p_msg_data );
763:
764: EXCEPTION
765: --

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

766: WHEN FND_API.G_EXC_ERROR THEN
767: --
768: ROLLBACK TO Sets_Delete_Row_Pvt ;
769: p_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
771: p_data => p_msg_data );
772: --
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: --

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

773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: --
775: ROLLBACK TO Sets_Delete_Row_Pvt ;
776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
778: p_data => p_msg_data );
779: --
780: WHEN OTHERS THEN
781: --

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

781: --
782: ROLLBACK TO Sets_Delete_Row_Pvt ;
783: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: --
785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
786: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
787: l_api_name);
788: END if;
789: --

Line 786: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

782: ROLLBACK TO Sets_Delete_Row_Pvt ;
783: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: --
785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
786: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
787: l_api_name);
788: END if;
789: --
790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

786: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
787: l_api_name);
788: END if;
789: --
790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
791: p_data => p_msg_data );
792: --
793: END Sets_Delete_Row;
794:

Line 848: FND_MSG_PUB.initialize ;

844: END IF;
845: --
846:
847: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
848: FND_MSG_PUB.initialize ;
849: END IF;
850: --
851: p_return_status := FND_API.G_RET_STS_SUCCESS ;
852: p_row_locked := FND_API.G_TRUE ;

Line 860: FND_MSG_PUB.Add;

856: FETCH C INTO Recinfo;
857: IF (C%NOTFOUND) then
858: CLOSE C;
859: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
860: FND_MSG_PUB.Add;
861: CLOSE c;
862: RAISE FND_API.G_EXC_ERROR ;
863: END IF;
864: CLOSE C;

Line 879: FND_MSG_PUB.Add ;

875: THEN
876: NULL ;
877: ELSE
878: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED') ;
879: FND_MSG_PUB.Add ;
880: RAISE FND_API.G_EXC_ERROR ;
881: END IF;
882:
883: --

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

893: WHEN FND_API.G_EXC_ERROR THEN
894: --
895: ROLLBACK TO Lock_Row_Pvt ;
896: p_return_status := FND_API.G_RET_STS_ERROR;
897: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
898: p_data => p_msg_data );
899: --
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: --

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

900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: --
902: ROLLBACK TO Lock_Row_Pvt ;
903: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
905: p_data => p_msg_data );
906: --
907: WHEN OTHERS THEN
908: --

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

908: --
909: ROLLBACK TO Lock_Row_Pvt ;
910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: --
912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
914: l_api_name);
915: END if;
916: --

Line 913: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

909: ROLLBACK TO Lock_Row_Pvt ;
910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: --
912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
914: l_api_name);
915: END if;
916: --
917: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

913: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
914: l_api_name);
915: END if;
916: --
917: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
918: p_data => p_msg_data );
919: --
920: END Sets_Lock_Row;
921: /* ----------------------------------------------------------------------- */

Line 972: FND_MSG_PUB.initialize ;

968: END IF;
969: --
970:
971: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
972: FND_MSG_PUB.initialize ;
973: END IF;
974: --
975: p_return_status := FND_API.G_RET_STS_SUCCESS ;
976: --

Line 993: FND_MSG_PUB.Add ;

989: P_LAST_UPDATE_LOGIN := -1;
990: end if;
991: else
992: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
993: FND_MSG_PUB.Add ;
994: raise FND_API.G_EXC_ERROR ;
995: end if;
996: --
997: UPDATE psb_flex_mapping_sets

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

1017: COMMIT WORK;
1018: END iF;
1019: --
1020: -- Standard call to get message count and if count is 1, get message info.
1021: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1022: p_data => p_msg_data );
1023: --
1024: EXCEPTION
1025:

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

1026: WHEN FND_API.G_EXC_ERROR THEN
1027: --
1028: ROLLBACK TO Update_Row_Pvt ;
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1031: p_data => p_msg_data );
1032: --
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: --

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

1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: --
1035: ROLLBACK TO Update_Row_Pvt ;
1036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1037: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1038: p_data => p_msg_data );
1039: --
1040: WHEN OTHERS THEN
1041: --

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

1041: --
1042: ROLLBACK TO Update_Row_Pvt ;
1043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: --
1045: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1046: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1047: l_api_name);
1048: END if;
1049: --

Line 1046: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1042: ROLLBACK TO Update_Row_Pvt ;
1043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: --
1045: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1046: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1047: l_api_name);
1048: END if;
1049: --
1050: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

1046: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1047: l_api_name);
1048: END if;
1049: --
1050: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1051: p_data => p_msg_data );
1052: --
1053: END Sets_Update_Row;
1054:

Line 1225: FND_MSG_PUB.Add;

1221: combination_id => p_ccid,
1222: n_segments => g_num_segs,
1223: segments => l_seg_val ) then
1224:
1225: FND_MSG_PUB.Add;
1226: raise FND_API.G_EXC_ERROR;
1227: end if;
1228:
1229:

Line 1351: FND_MSG_PUB.Add;

1347: n_segments => g_num_segs,
1348: segments => l_seg_val,
1349: combination_id => l_ccid) then
1350:
1351: FND_MSG_PUB.Add;
1352: l_ccid := 0;
1353: raise FND_API.G_EXC_ERROR;
1354: end if;
1355:

Line 1546: FND_MSG_PUB.Add;

1542: combination_id => p_ccid,
1543: n_segments => g_num_segs,
1544: segments => l_seg_val ) then
1545:
1546: FND_MSG_PUB.Add;
1547: raise FND_API.G_EXC_ERROR;
1548: end if;
1549:
1550: