DBA Data[Home] [Help]

APPS.PSB_GL_BUDGET_SET_PVT dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.initialize ;

79: END IF;
80: --
81:
82: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize ;
84: END IF;
85: --
86: p_return_status := FND_API.G_RET_STS_SUCCESS ;
87: --

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

149: IF FND_API.To_Boolean ( p_commit ) THEN
150: COMMIT WORK;
151: END iF;
152: --
153: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
154: p_data => p_msg_data );
155: --
156: EXCEPTION
157: --

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

158: WHEN FND_API.G_EXC_ERROR THEN
159: --
160: ROLLBACK TO Insert_Row_Pvt ;
161: p_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
163: p_data => p_msg_data );
164: --
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: --

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

165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: --
167: ROLLBACK TO Insert_Row_Pvt ;
168: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
170: p_data => p_msg_data );
171: --
172: WHEN OTHERS THEN
173: --

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

173: --
174: ROLLBACK TO Insert_Row_Pvt ;
175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: --
177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
179: l_api_name);
180: END if;
181: --

Line 178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

174: ROLLBACK TO Insert_Row_Pvt ;
175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: --
177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
179: l_api_name);
180: END if;
181: --
182: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
179: l_api_name);
180: END if;
181: --
182: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
183: p_data => p_msg_data );
184: --
185: END Insert_Row;
186: /*-------------------------------------------------------------------------*/

Line 248: FND_MSG_PUB.initialize ;

244: END IF;
245: --
246:
247: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
248: FND_MSG_PUB.initialize ;
249: END IF;
250: --
251: p_return_status := FND_API.G_RET_STS_SUCCESS ;
252: p_row_locked := FND_API.G_TRUE ;

Line 260: FND_MSG_PUB.Add;

256: FETCH C INTO Recinfo;
257: IF (C%NOTFOUND) then
258: CLOSE C;
259: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
260: FND_MSG_PUB.Add;
261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;
263: CLOSE C;
264: IF

Line 324: FND_MSG_PUB.Add;

320: THEN
321: Null;
322: ELSE
323: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
324: FND_MSG_PUB.Add;
325: RAISE FND_API.G_EXC_ERROR ;
326: END IF;
327:
328: --

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

329: IF FND_API.To_Boolean ( p_commit ) THEN
330: COMMIT WORK;
331: END iF;
332: --
333: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
334: p_data => p_msg_data );
335: --
336: EXCEPTION
337: --

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

339: --
340: ROLLBACK TO Lock_Row_Pvt ;
341: p_row_locked := FND_API.G_FALSE;
342: p_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
344: p_data => p_msg_data );
345: --
346: WHEN FND_API.G_EXC_ERROR THEN
347: --

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

346: WHEN FND_API.G_EXC_ERROR THEN
347: --
348: ROLLBACK TO Lock_Row_Pvt ;
349: p_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
351: p_data => p_msg_data );
352: --
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: --

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

353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: --
355: ROLLBACK TO Lock_Row_Pvt ;
356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
358: p_data => p_msg_data );
359: --
360: WHEN OTHERS THEN
361: --

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

361: --
362: ROLLBACK TO Lock_Row_Pvt ;
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: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
367: l_api_name);
368: END if;
369: --

Line 366: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

362: ROLLBACK TO Lock_Row_Pvt ;
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: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
367: l_api_name);
368: END if;
369: --
370: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

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

Line 428: FND_MSG_PUB.initialize ;

424: END IF;
425: --
426:
427: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize ;
429: END IF;
430: --
431: p_return_status := FND_API.G_RET_STS_SUCCESS ;
432: --

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

458: IF FND_API.To_Boolean ( p_commit ) THEN
459: COMMIT WORK;
460: END iF;
461: --
462: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
463: p_data => p_msg_data );
464: --
465: EXCEPTION
466: --

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

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

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

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

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

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

Line 487: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

487: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
488: l_api_name);
489: END if;
490: --
491: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
492: p_data => p_msg_data );
493: --
494: END Update_Row;
495: /* ----------------------------------------------------------------------- */

Line 539: FND_MSG_PUB.initialize ;

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

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

597: IF FND_API.To_Boolean ( p_commit ) THEN
598: COMMIT WORK;
599: END iF;
600: --
601: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
602: p_data => p_msg_data );
603:
604: EXCEPTION
605: --

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

606: WHEN FND_API.G_EXC_ERROR THEN
607: --
608: ROLLBACK TO Delete_Row_Pvt ;
609: p_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
611: p_data => p_msg_data );
612: --
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: --

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

613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: --
615: ROLLBACK TO Delete_Row_Pvt ;
616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
618: p_data => p_msg_data );
619: --
620: WHEN OTHERS THEN
621: --

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

621: --
622: ROLLBACK TO Delete_Row_Pvt ;
623: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: --
625: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
627: l_api_name);
628: END if;
629: --

Line 626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

622: ROLLBACK TO Delete_Row_Pvt ;
623: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: --
625: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
627: l_api_name);
628: END if;
629: --
630: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
627: l_api_name);
628: END if;
629: --
630: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
631: p_data => p_msg_data );
632: --
633: END Delete_Row;
634: /* ----------------------------------------------------------------------- */

Line 688: FND_MSG_PUB.initialize ;

684: END IF;
685: --
686:
687: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
688: FND_MSG_PUB.initialize ;
689: END IF;
690: --
691: p_return_status := FND_API.G_RET_STS_SUCCESS ;
692: --

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

707: IF FND_API.To_Boolean ( p_commit ) THEN
708: COMMIT WORK;
709: END iF;
710: --
711: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
712: p_data => p_msg_data );
713: --
714: EXCEPTION
715: --

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

716: WHEN FND_API.G_EXC_ERROR THEN
717: --
718: ROLLBACK TO Check_Unique_Pvt ;
719: p_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
721: p_data => p_msg_data );
722: --
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
724: --

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

723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
724: --
725: ROLLBACK TO Check_Unique_Pvt ;
726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
728: p_data => p_msg_data );
729: --
730: WHEN OTHERS THEN
731: --

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

731: --
732: ROLLBACK TO Check_Unique_Pvt ;
733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: --
735: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
736: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
737: l_api_name);
738: END if;
739: --

Line 736: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

732: ROLLBACK TO Check_Unique_Pvt ;
733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: --
735: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
736: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
737: l_api_name);
738: END if;
739: --
740: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

736: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
737: l_api_name);
738: END if;
739: --
740: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
741: p_data => p_msg_data );
742: --
743: END Check_Unique;
744: /* ----------------------------------------------------------------------- */

Line 792: FND_MSG_PUB.initialize ;

788: END IF;
789: --
790:
791: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
792: FND_MSG_PUB.initialize ;
793: END IF ;
794: --
795: p_return_status := FND_API.G_RET_STS_SUCCESS ;
796: --

Line 877: FND_MSG_PUB.Add;

873: --
874: FND_MESSAGE.SET_NAME ('PSB', 'PSB_GL_BUDGET_NAME_FOR_OVERLAP');
875: FND_MESSAGE.SET_TOKEN('BUDGET_NAME' ,
876: l_gl_budget_rec.gl_budget_name);
877: FND_MSG_PUB.Add;
878: END IF;
879:
880: -- Setup the error message for the current code_combination_id.
881: FND_MESSAGE.SET_NAME ('PSB', 'PSB_GBS_OVERLAP_ACCOUNTS');

Line 888: FND_MSG_PUB.Add;

884: FND_MESSAGE.SET_TOKEN('ACCOUNT_SET' ,
885: l_ccid_rec.account_position_set_id);
886: FND_MESSAGE.SET_TOKEN('BUDGET_NAME' ,
887: l_dup_gl_budget_id.gl_budget_name);
888: FND_MSG_PUB.Add;
889:
890: pd('CCID ' || l_ccid_rec.code_combination_id || ' found ' ||
891: 'Budget : ' || l_dup_gl_budget_id.gl_budget_name ) ;
892:

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

901: IF FND_API.To_Boolean ( p_commit ) THEN
902: COMMIT WORK;
903: END iF;
904: --
905: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
906: p_data => p_msg_data );
907:
908: EXCEPTION
909: --

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

910: WHEN FND_API.G_EXC_ERROR THEN
911: --
912: ROLLBACK TO Validate_Account_Overlap_Pvt ;
913: p_return_status := FND_API.G_RET_STS_ERROR;
914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
915: p_data => p_msg_data );
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: --

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

917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: --
919: ROLLBACK TO Validate_Account_Overlap_Pvt ;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
922: p_data => p_msg_data );
923: --
924: --
925: WHEN OTHERS THEN

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

926: --
927: ROLLBACK TO Validate_Account_Overlap_Pvt ;
928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: --
930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
932: l_api_name);
933: END if;
934: --

Line 931: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

927: ROLLBACK TO Validate_Account_Overlap_Pvt ;
928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: --
930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
932: l_api_name);
933: END if;
934: --
935: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

931: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
932: l_api_name);
933: END if;
934: --
935: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
936: p_data => p_msg_data );
937: --
938: END Validate_Account_Overlap ;
939: /* ----------------------------------------------------------------------- */

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

1021: retcode := 2 ;
1022: --
1023: WHEN OTHERS THEN
1024: --
1025: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1026: --
1027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1028: l_api_name ) ;
1029: END IF ;

Line 1027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1023: WHEN OTHERS THEN
1024: --
1025: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1026: --
1027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1028: l_api_name ) ;
1029: END IF ;
1030: --
1031: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 1084: FND_MSG_PUB.initialize ;

1080: END IF;
1081: --
1082:
1083: IF ( p_init_msg_list='T') THEN
1084: FND_MSG_PUB.initialize ;
1085: END IF;
1086: --
1087: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1088: --

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

1103: IF ( p_commit='T' ) THEN
1104: COMMIT WORK;
1105: END IF;
1106: --
1107: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1108: p_data => p_msg_data );
1109: p_return_status:=l_return_status;
1110: --
1111: EXCEPTION

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

1113: WHEN FND_API.G_EXC_ERROR THEN
1114: --
1115: ROLLBACK TO Check_References_Pvt ;
1116: p_return_status := FND_API.G_RET_STS_ERROR;
1117: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1118: p_data => p_msg_data );
1119: --
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: --

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

1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: --
1122: ROLLBACK TO Check_References_Pvt ;
1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1125: p_data => p_msg_data );
1126: --
1127: --
1128: WHEN OTHERS THEN

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

1129: --
1130: ROLLBACK TO Check_References_Pvt ;
1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1132: --
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1135: l_api_name);
1136: END IF;
1137: --

Line 1134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1130: ROLLBACK TO Check_References_Pvt ;
1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1132: --
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1135: l_api_name);
1136: END IF;
1137: --
1138: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

1134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1135: l_api_name);
1136: END IF;
1137: --
1138: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1139: p_data => p_msg_data );
1140: --
1141: END Check_References;
1142: