DBA Data[Home] [Help]

APPS.JTF_PERZ_DATA_PVT dependencies on FND_MSG_PUB

Line 307: FND_MSG_PUB.initialize;

303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 453: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

449: COMMIT WORK;
450: END IF;
451:
452: -- Standard call to get message count and if count is 1, get message info.
453: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
454: p_data => x_msg_data );
455:
456: EXCEPTION
457:

Line 464: FND_MSG_PUB.Count_And_Get

460:
461: ROLLBACK TO SAVE_PERZ_DATA_PVT;
462: x_return_status := FND_API.G_RET_STS_ERROR ;
463:
464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
466: p_data => x_msg_data );
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 472: FND_MSG_PUB.Count_And_Get

468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: --dbms_output.put_line('stop 5 ');
470: ROLLBACK TO SAVE_PERZ_DATA_PVT;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count,
474: p_data => x_msg_data );
475:
476:

Line 482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

478: --dbms_output.put_line('stop 5 ');
479: ROLLBACK TO SAVE_PERZ_DATA_PVT;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481:
482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
485: END IF;
486:

Line 484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481:
482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
485: END IF;
486:
487: FND_MSG_PUB.Count_And_Get
488: ( p_count => x_msg_count,

Line 487: FND_MSG_PUB.Count_And_Get

483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
485: END IF;
486:
487: FND_MSG_PUB.Count_And_Get
488: ( p_count => x_msg_count,
489: p_data => x_msg_data );
490:
491:

Line 548: FND_MSG_PUB.initialize;

544:
545: -- Initialize message list if p_init_msg_list is set to TRUE.
546: IF FND_API.to_Boolean( p_init_msg_list )
547: THEN
548: FND_MSG_PUB.initialize;
549: END IF;
550:
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 631: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

627: COMMIT WORK;
628: END IF;
629:
630: -- Standard call to get message count and if count is 1, get message info.
631: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
632: p_data => x_msg_data );
633:
634: EXCEPTION
635:

Line 642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

638:
639: ROLLBACK TO CREATE_PERZ_DATA_PVT;
640: x_return_status := FND_API.G_RET_STS_ERROR ;
641:
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data );
644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: --dbms_output.put_line('stop 2 ');

Line 650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

646: --dbms_output.put_line('stop 2 ');
647: ROLLBACK TO CREATE_PERZ_DATA_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649:
650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
651: p_data => x_msg_data );
652:
653: WHEN OTHERS THEN
654: --dbms_output.put_line('stop 3 ');

Line 658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

654: --dbms_output.put_line('stop 3 ');
655: ROLLBACK TO CREATE_PERZ_DATA_PVT;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657:
658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
659: THEN
660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
661: END IF;
662:

Line 660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657:
658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
659: THEN
660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
661: END IF;
662:
663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
664: p_data => x_msg_data );

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

659: THEN
660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
661: END IF;
662:
663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
664: p_data => x_msg_data );
665:
666:
667: END Create_Perz_Data;

Line 734: FND_MSG_PUB.initialize;

730:
731: -- Initialize message list if p_init_msg_list is set to TRUE.
732: IF FND_API.to_Boolean( p_init_msg_list )
733: THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Initialize API return status to success
738: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

820:
821:
822: -- ******** Standard Ends ***********
823: -- Standard call to get message count and if count is 1, get message info.
824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
825: p_data => x_msg_data );
826:
827: EXCEPTION
828:

Line 833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

829: WHEN FND_API.G_EXC_ERROR THEN
830:
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832:
833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
834: p_data => x_msg_data );
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837:

Line 840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837:
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
841: p_data => x_msg_data );
842:
843: WHEN OTHERS THEN
844:

Line 847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

843: WHEN OTHERS THEN
844:
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846:
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
850: END IF;
851:

Line 849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846:
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
850: END IF;
851:
852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
853: p_data => x_msg_data );

Line 852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
850: END IF;
851:
852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
853: p_data => x_msg_data );
854:
855:
856:

Line 964: FND_MSG_PUB.initialize;

960:
961: -- Initialize message list if p_init_msg_list is set to TRUE.
962: IF FND_API.to_Boolean( p_init_msg_list )
963: THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Initialize API return status to success
968: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1186:
1187:
1188: -- ******** Standard Ends ***********
1189: -- Standard call to get message count and if count is 1, get message info.
1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1191: p_data => x_msg_data );
1192:
1193: EXCEPTION
1194:

Line 1199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1195: WHEN FND_API.G_EXC_ERROR THEN
1196:
1197: x_return_status := FND_API.G_RET_STS_ERROR ;
1198:
1199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1200: p_data => x_msg_data );
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:

Line 1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1207: p_data => x_msg_data );
1208:
1209: WHEN OTHERS THEN
1210:

Line 1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1209: WHEN OTHERS THEN
1210:
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212:
1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1216: END IF;
1217:

Line 1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212:
1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1219: p_data => x_msg_data );

Line 1218: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1219: p_data => x_msg_data );
1220:
1221:
1222: END Get_Perz_Data_Summary;

Line 1277: FND_MSG_PUB.initialize;

1273:
1274: -- Initialize message list if p_init_msg_list is set to TRUE.
1275: IF FND_API.to_Boolean( p_init_msg_list )
1276: THEN
1277: FND_MSG_PUB.initialize;
1278: END IF;
1279:
1280: -- Initialize API return status to success
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1356: COMMIT WORK;
1357: END IF;
1358:
1359: -- Standard call to get message count and if count is 1, get message info.
1360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1361: p_data => x_msg_data );
1362:
1363: EXCEPTION
1364:

Line 1370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1366:
1367: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1368: x_return_status := FND_API.G_RET_STS_ERROR ;
1369:
1370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1371: p_data => x_msg_data );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO UPDATE_PERZ_DATA_PVT;

Line 1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1376:
1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1378: p_data => x_msg_data );
1379:
1380: WHEN OTHERS THEN
1381: ROLLBACK TO UPDATE_PERZ_DATA_PVT;

Line 1384: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1380: WHEN OTHERS THEN
1381: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1387: END IF;
1388:

Line 1386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1387: END IF;
1388:
1389: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1390: p_data => x_msg_data );

Line 1389: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1387: END IF;
1388:
1389: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1390: p_data => x_msg_data );
1391:
1392: END Update_Perz_Data;
1393:

Line 1434: FND_MSG_PUB.initialize;

1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean( p_init_msg_list )
1433: THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437: -- Initialize API return status to success
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1457: COMMIT WORK;
1458: END IF;
1459:
1460: -- Standard call to get message count and if count is 1, get message info.
1461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1462: p_data => x_msg_data );
1463:
1464: EXCEPTION
1465:

Line 1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1467:
1468: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1469: x_return_status := FND_API.G_RET_STS_ERROR ;
1470:
1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1472: p_data => x_msg_data );
1473:
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO DELETE_PERZ_DATA_PVT;

Line 1478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477:
1478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1479: p_data => x_msg_data );
1480:
1481: WHEN OTHERS THEN
1482: ROLLBACK TO DELETE_PERZ_DATA_PVT;

Line 1485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1481: WHEN OTHERS THEN
1482: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484:
1485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1488: END IF;
1489:

Line 1487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484:
1485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1488: END IF;
1489:
1490: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1491: p_data => x_msg_data );

Line 1490: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1488: END IF;
1489:
1490: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1491: p_data => x_msg_data );
1492:
1493:
1494: END Delete_Perz_Data;