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

Line 43: FND_MSG_PUB.initialize;

39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41:
42: if FND_API.to_Boolean (p_init_msg_list) then
43: FND_MSG_PUB.initialize;
44: end if;
45:
46:
47: -- Call Private Function

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

59:
60:
61: -- Standard call to get message count and if count is 1, get message info.
62:
63: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
64: p_data => p_msg_data);
65:
66: EXCEPTION
67:

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

68: when FND_API.G_EXC_ERROR then
69: rollback to Consolidate_Worksheets_Pvt;
70: p_return_status := FND_API.G_RET_STS_ERROR;
71:
72: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
73: p_data => p_msg_data);
74:
75: when FND_API.G_EXC_UNEXPECTED_ERROR then
76: rollback to Consolidate_Worksheets_Pvt;

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

75: when FND_API.G_EXC_UNEXPECTED_ERROR then
76: rollback to Consolidate_Worksheets_Pvt;
77: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
80: p_data => p_msg_data);
81:
82: when OTHERS then
83: rollback to Consolidate_Worksheets_Pvt;

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

82: when OTHERS then
83: rollback to Consolidate_Worksheets_Pvt;
84: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
87: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
88: l_api_name);
89: end if;
90:

Line 87: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

83: rollback to Consolidate_Worksheets_Pvt;
84: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
87: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
88: l_api_name);
89: end if;
90:
91: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

87: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
88: l_api_name);
89: end if;
90:
91: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
92: p_data => p_msg_data);
93:
94: END Consolidate_Worksheets;
95:

Line 127: FND_MSG_PUB.initialize;

123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125:
126: if FND_API.to_Boolean (p_init_msg_list) then
127: FND_MSG_PUB.initialize;
128: end if;
129:
130:
131: -- Call Private Function

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

136: p_global_worksheet_id => p_global_worksheet_id);
137:
138: -- Standard call to get message count and if count is 1, get message info.
139:
140: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
141: p_data => p_msg_data);
142:
143: EXCEPTION
144:

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

144:
145: when FND_API.G_EXC_ERROR then
146: p_return_status := FND_API.G_RET_STS_ERROR;
147:
148: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
149: p_data => p_msg_data);
150:
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

150:
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
155: p_data => p_msg_data);
156:
157: when OTHERS then
158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

156:
157: when OTHERS then
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: when OTHERS then
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 Validate_Consolidation;
169:

Line 227: FND_MSG_PUB.initialize ;

223: END IF;
224:
225:
226: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
227: FND_MSG_PUB.initialize ;
228: END IF;
229:
230: p_return_status := FND_API.G_RET_STS_SUCCESS ;
231:

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

281: IF FND_API.To_Boolean ( p_commit ) THEN
282: COMMIT WORK;
283: END iF;
284:
285: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
286: p_data => p_msg_data );
287:
288: EXCEPTION
289:

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

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

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

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

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

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

Line 310: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

310: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
311: l_api_name);
312: END if;
313:
314: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
315: p_data => p_msg_data );
316:
317: END Insert_Row;
318:

Line 374: FND_MSG_PUB.initialize ;

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

Line 386: FND_MSG_PUB.Add;

382: FETCH C INTO Recinfo;
383: IF (C%NOTFOUND) then
384: CLOSE C;
385: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
386: FND_MSG_PUB.Add;
387: RAISE FND_API.G_EXC_ERROR ;
388: END IF;
389: CLOSE C;
390: IF

Line 443: FND_MSG_PUB.Add;

439: THEN
440: Null;
441: ELSE
442: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
443: FND_MSG_PUB.Add;
444: RAISE FND_API.G_EXC_ERROR ;
445: END IF;
446:
447:

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

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

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

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

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

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

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

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

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

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

Line 485: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

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

Line 542: FND_MSG_PUB.initialize ;

538: END IF;
539:
540:
541: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
542: FND_MSG_PUB.initialize ;
543: END IF;
544:
545: p_return_status := FND_API.G_RET_STS_SUCCESS ;
546:

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

573: IF FND_API.To_Boolean ( p_commit ) THEN
574: COMMIT WORK;
575: END iF;
576:
577: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
578: p_data => p_msg_data );
579:
580: EXCEPTION
581:

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

582: WHEN FND_API.G_EXC_ERROR THEN
583:
584: ROLLBACK TO Update_Row_Pvt ;
585: p_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
587: p_data => p_msg_data );
588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590:

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

589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590:
591: ROLLBACK TO Update_Row_Pvt ;
592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
594: p_data => p_msg_data );
595:
596: WHEN OTHERS THEN
597:

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

597:
598: ROLLBACK TO Update_Row_Pvt ;
599: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
602: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
603: l_api_name);
604: END if;
605:

Line 602: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

598: ROLLBACK TO Update_Row_Pvt ;
599: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
602: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
603: l_api_name);
604: END if;
605:
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

602: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
603: l_api_name);
604: END if;
605:
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608:
609: END Update_Row;
610:

Line 647: FND_MSG_PUB.initialize ;

643: END IF;
644:
645:
646: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
647: FND_MSG_PUB.initialize ;
648: END IF ;
649:
650: p_return_status := FND_API.G_RET_STS_SUCCESS ;
651:

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

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

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

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

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

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

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

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

Line 690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
691: l_api_name);
692: END if;
693:
694: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
695: p_data => p_msg_data );
696:
697: END Delete_Row;
698:

Line 742: FND_MSG_PUB.initialize ;

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

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

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

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

769: WHEN FND_API.G_EXC_ERROR THEN
770:
771: ROLLBACK TO Check_Unique_Pvt ;
772: p_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
774: p_data => p_msg_data );
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777:

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

776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777:
778: ROLLBACK TO Check_Unique_Pvt ;
779: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
781: p_data => p_msg_data );
782:
783: WHEN OTHERS THEN
784:

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

784:
785: ROLLBACK TO Check_Unique_Pvt ;
786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:
788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
790: l_api_name);
791: END if;
792:

Line 789: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

785: ROLLBACK TO Check_Unique_Pvt ;
786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:
788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
790: l_api_name);
791: END if;
792:
793: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

789: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
790: l_api_name);
791: END if;
792:
793: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
794: p_data => p_msg_data );
795:
796: END Check_Unique;
797:

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

870: COMMIT WORK ;
871: --
872: WHEN OTHERS THEN
873: --
874: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
875: --
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
877: l_api_name ) ;
878: END IF ;

Line 876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

872: WHEN OTHERS THEN
873: --
874: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
875: --
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
877: l_api_name ) ;
878: END IF ;
879: --
880: l_return_status := FND_API.G_RET_STS_ERROR;