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.JTF_PREFAB_CACHE_PUB dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.initialize;

64: END IF;
65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.To_Boolean( p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Initialize API return status to success
72: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 189: FND_MSG_PUB.Count_And_Get(

185: COMMIT WORK;
186: END IF;
187:
188: -- Standard call to get message count and if count is 1, get message info.
189: FND_MSG_PUB.Count_And_Get(
190: p_count => x_msg_count,
191: p_data => x_msg_data );
192:
193: EXCEPTION

Line 198: FND_MSG_PUB.Count_And_Get(

194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO INSERT_HOST_APP;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197:
198: FND_MSG_PUB.Count_And_Get(
199: p_count => x_msg_count,
200: p_data => x_msg_data );
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 206: FND_MSG_PUB.Count_And_Get(

202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO INSERT_HOST_APP;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205:
206: FND_MSG_PUB.Count_And_Get(
207: p_count => x_msg_count,
208: p_data => x_msg_data );
209:
210: WHEN OTHERS THEN

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

210: WHEN OTHERS THEN
211: ROLLBACK TO INSERT_HOST_APP;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213:
214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
216: END IF;
217:
218: FND_MSG_PUB.Count_And_Get(

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

211: ROLLBACK TO INSERT_HOST_APP;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213:
214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
216: END IF;
217:
218: FND_MSG_PUB.Count_And_Get(
219: p_count => x_msg_count,

Line 218: FND_MSG_PUB.Count_And_Get(

214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
216: END IF;
217:
218: FND_MSG_PUB.Count_And_Get(
219: p_count => x_msg_count,
220: p_data => x_msg_data );
221:
222: END INSERT_HOST_APP;

Line 261: FND_MSG_PUB.initialize;

257: END IF;
258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.To_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: -- Initialize API return status to success
265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 290: FND_MSG_PUB.Count_And_Get(

286: COMMIT WORK;
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,
292: p_data => x_msg_data );
293:
294: EXCEPTION

Line 299: FND_MSG_PUB.Count_And_Get(

295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO UPDATE_HOST_APP;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298:
299: FND_MSG_PUB.Count_And_Get(
300: p_count => x_msg_count,
301: p_data => x_msg_data );
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 307: FND_MSG_PUB.Count_And_Get(

303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO UPDATE_HOST_APP;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306:
307: FND_MSG_PUB.Count_And_Get(
308: p_count => x_msg_count,
309: p_data => x_msg_data );
310:
311: WHEN OTHERS THEN

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

311: WHEN OTHERS THEN
312: ROLLBACK TO UPDATE_HOST_APP;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314:
315: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
316: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
317: END IF;
318:
319: FND_MSG_PUB.Count_And_Get(

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

312: ROLLBACK TO UPDATE_HOST_APP;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314:
315: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
316: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
317: END IF;
318:
319: FND_MSG_PUB.Count_And_Get(
320: p_count => x_msg_count,

Line 319: FND_MSG_PUB.Count_And_Get(

315: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
316: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
317: END IF;
318:
319: FND_MSG_PUB.Count_And_Get(
320: p_count => x_msg_count,
321: p_data => x_msg_data );
322:
323: END UPDATE_HOST_APP;

Line 367: FND_MSG_PUB.initialize;

363: END IF;
364:
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.To_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369:
370: -- Initialize API return status to success
371: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 438: FND_MSG_PUB.initialize;

434: END IF;
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.To_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success
442: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 477: FND_MSG_PUB.Count_And_Get(

473: COMMIT WORK;
474: END IF;
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get(
478: p_count => x_msg_count,
479: p_data => x_msg_data );
480:
481: EXCEPTION

Line 486: FND_MSG_PUB.Count_And_Get(

482: WHEN FND_API.G_EXC_ERROR THEN
483: ROLLBACK TO DELETE_HOST_APP;
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485:
486: FND_MSG_PUB.Count_And_Get(
487: p_count => x_msg_count,
488: p_data => x_msg_data );
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 494: FND_MSG_PUB.Count_And_Get(

490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: ROLLBACK TO DELETE_HOST_APP;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493:
494: FND_MSG_PUB.Count_And_Get(
495: p_count => x_msg_count,
496: p_data => x_msg_data );
497:
498: WHEN OTHERS THEN

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

498: WHEN OTHERS THEN
499: ROLLBACK TO DELETE_HOST_APP;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
503: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
504: END IF;
505:
506: FND_MSG_PUB.Count_And_Get(

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

499: ROLLBACK TO DELETE_HOST_APP;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
503: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
504: END IF;
505:
506: FND_MSG_PUB.Count_And_Get(
507: p_count => x_msg_count,

Line 506: FND_MSG_PUB.Count_And_Get(

502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
503: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
504: END IF;
505:
506: FND_MSG_PUB.Count_And_Get(
507: p_count => x_msg_count,
508: p_data => x_msg_data );
509:
510: END DELETE_HOST_APP;

Line 549: FND_MSG_PUB.initialize;

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

Line 584: FND_MSG_PUB.Count_And_Get(

580: COMMIT WORK;
581: END IF;
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get(
585: p_count => x_msg_count,
586: p_data => x_msg_data );
587:
588: EXCEPTION

Line 593: FND_MSG_PUB.Count_And_Get(

589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO DELETE_HOST_APPS_FOR_HOST;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592:
593: FND_MSG_PUB.Count_And_Get(
594: p_count => x_msg_count,
595: p_data => x_msg_data );
596:
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 601: FND_MSG_PUB.Count_And_Get(

597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: ROLLBACK TO DELETE_HOST_APPS_FOR_HOST;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
600:
601: FND_MSG_PUB.Count_And_Get(
602: p_count => x_msg_count,
603: p_data => x_msg_data );
604:
605: WHEN OTHERS THEN

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

605: WHEN OTHERS THEN
606: ROLLBACK TO DELETE_HOST_APPS_FOR_HOST;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
608:
609: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
611: END IF;
612:
613: FND_MSG_PUB.Count_And_Get(

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

606: ROLLBACK TO DELETE_HOST_APPS_FOR_HOST;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
608:
609: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
611: END IF;
612:
613: FND_MSG_PUB.Count_And_Get(
614: p_count => x_msg_count,

Line 613: FND_MSG_PUB.Count_And_Get(

609: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
611: END IF;
612:
613: FND_MSG_PUB.Count_And_Get(
614: p_count => x_msg_count,
615: p_data => x_msg_data );
616:
617: END DELETE_HOST_APPS_FOR_HOST;

Line 678: FND_MSG_PUB.initialize;

674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF FND_API.To_Boolean( p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: -- Initialize API return status to success
682: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 818: FND_MSG_PUB.Count_And_Get(

814: COMMIT WORK;
815: END IF;
816:
817: -- Standard call to get message count and if count is 1, get message info.
818: FND_MSG_PUB.Count_And_Get(
819: p_count => x_msg_count,
820: p_data => x_msg_data );
821:
822: EXCEPTION

Line 827: FND_MSG_PUB.Count_And_Get(

823: WHEN FND_API.G_EXC_ERROR THEN
824: ROLLBACK TO INSERT_CACHE_COMP;
825: x_return_status := FND_API.G_RET_STS_ERROR ;
826:
827: FND_MSG_PUB.Count_And_Get(
828: p_count => x_msg_count,
829: p_data => x_msg_data );
830:
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 835: FND_MSG_PUB.Count_And_Get(

831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO INSERT_CACHE_COMP;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834:
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,
837: p_data => x_msg_data );
838:
839: WHEN OTHERS THEN

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

839: WHEN OTHERS THEN
840: ROLLBACK TO INSERT_CACHE_COMP;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842:
843: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
845: END IF;
846:
847: FND_MSG_PUB.Count_And_Get(

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

840: ROLLBACK TO INSERT_CACHE_COMP;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842:
843: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
845: END IF;
846:
847: FND_MSG_PUB.Count_And_Get(
848: p_count => x_msg_count,

Line 847: FND_MSG_PUB.Count_And_Get(

843: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
845: END IF;
846:
847: FND_MSG_PUB.Count_And_Get(
848: p_count => x_msg_count,
849: p_data => x_msg_data );
850:
851: END INSERT_CACHE_COMP;

Line 899: FND_MSG_PUB.initialize;

895: END IF;
896:
897: -- Initialize message list if p_init_msg_list is set to TRUE.
898: IF FND_API.To_Boolean( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901:
902: -- Initialize API return status to success
903: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 956: FND_MSG_PUB.Count_And_Get(

952: COMMIT WORK;
953: END IF;
954:
955: -- Standard call to get message count and if count is 1, get message info.
956: FND_MSG_PUB.Count_And_Get(
957: p_count => x_msg_count,
958: p_data => x_msg_data );
959:
960: EXCEPTION

Line 965: FND_MSG_PUB.Count_And_Get(

961: WHEN FND_API.G_EXC_ERROR THEN
962: ROLLBACK TO UPDATE_CACHE_COMP;
963: x_return_status := FND_API.G_RET_STS_ERROR ;
964:
965: FND_MSG_PUB.Count_And_Get(
966: p_count => x_msg_count,
967: p_data => x_msg_data );
968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 973: FND_MSG_PUB.Count_And_Get(

969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO UPDATE_CACHE_COMP;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
972:
973: FND_MSG_PUB.Count_And_Get(
974: p_count => x_msg_count,
975: p_data => x_msg_data );
976:
977: WHEN OTHERS THEN

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

977: WHEN OTHERS THEN
978: ROLLBACK TO UPDATE_CACHE_COMP;
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
980:
981: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
983: END IF;
984:
985: FND_MSG_PUB.Count_And_Get(

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

978: ROLLBACK TO UPDATE_CACHE_COMP;
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
980:
981: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
983: END IF;
984:
985: FND_MSG_PUB.Count_And_Get(
986: p_count => x_msg_count,

Line 985: FND_MSG_PUB.Count_And_Get(

981: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
983: END IF;
984:
985: FND_MSG_PUB.Count_And_Get(
986: p_count => x_msg_count,
987: p_data => x_msg_data );
988:
989: END UPDATE_CACHE_COMP;

Line 1024: FND_MSG_PUB.initialize;

1020: END IF;
1021:
1022: -- Initialize message list if p_init_msg_list is set to TRUE.
1023: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1024: FND_MSG_PUB.initialize;
1025: END IF;
1026:
1027: -- Initialize API return status to success
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1046: FND_MSG_PUB.Count_And_Get(

1042: COMMIT WORK;
1043: END IF;
1044:
1045: -- Standard call to get message count and if count is 1, get message info.
1046: FND_MSG_PUB.Count_And_Get(
1047: p_count => x_msg_count,
1048: p_data => x_msg_data );
1049:
1050: EXCEPTION

Line 1055: FND_MSG_PUB.Count_And_Get(

1051: WHEN FND_API.G_EXC_ERROR THEN
1052: ROLLBACK TO UPDATE_CACHE_COMP_1;
1053: x_return_status := FND_API.G_RET_STS_ERROR ;
1054:
1055: FND_MSG_PUB.Count_And_Get(
1056: p_count => x_msg_count,
1057: p_data => x_msg_data );
1058:
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1063: FND_MSG_PUB.Count_And_Get(

1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO UPDATE_CACHE_COMP_1;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062:
1063: FND_MSG_PUB.Count_And_Get(
1064: p_count => x_msg_count,
1065: p_data => x_msg_data );
1066:
1067: WHEN OTHERS THEN

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

1067: WHEN OTHERS THEN
1068: ROLLBACK TO UPDATE_CACHE_COMP_1;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1073: END IF;
1074:
1075: FND_MSG_PUB.Count_And_Get(

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

1068: ROLLBACK TO UPDATE_CACHE_COMP_1;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1073: END IF;
1074:
1075: FND_MSG_PUB.Count_And_Get(
1076: p_count => x_msg_count,

Line 1075: FND_MSG_PUB.Count_And_Get(

1071: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1073: END IF;
1074:
1075: FND_MSG_PUB.Count_And_Get(
1076: p_count => x_msg_count,
1077: p_data => x_msg_data );
1078:
1079: END UPDATE_CACHE_COMP_1;

Line 1113: FND_MSG_PUB.initialize;

1109: END IF;
1110:
1111: -- Initialize message list if p_init_msg_list is set to TRUE.
1112: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1113: FND_MSG_PUB.initialize;
1114: END IF;
1115:
1116: -- Initialize API return status to success
1117: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1148: FND_MSG_PUB.Count_And_Get(

1144: COMMIT WORK;
1145: END IF;
1146:
1147: -- Standard call to get message count and if count is 1, get message info.
1148: FND_MSG_PUB.Count_And_Get(
1149: p_count => x_msg_count,
1150: p_data => x_msg_data );
1151:
1152: EXCEPTION

Line 1157: FND_MSG_PUB.Count_And_Get(

1153: WHEN FND_API.G_EXC_ERROR THEN
1154: ROLLBACK TO DELETE_CACHE_COMP;
1155: x_return_status := FND_API.G_RET_STS_ERROR ;
1156:
1157: FND_MSG_PUB.Count_And_Get(
1158: p_count => x_msg_count,
1159: p_data => x_msg_data );
1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1165: FND_MSG_PUB.Count_And_Get(

1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO DELETE_CACHE_COMP;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1164:
1165: FND_MSG_PUB.Count_And_Get(
1166: p_count => x_msg_count,
1167: p_data => x_msg_data );
1168:
1169: WHEN OTHERS THEN

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

1169: WHEN OTHERS THEN
1170: ROLLBACK TO DELETE_CACHE_COMP;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172:
1173: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1175: END IF;
1176:
1177: FND_MSG_PUB.Count_And_Get(

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

1170: ROLLBACK TO DELETE_CACHE_COMP;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172:
1173: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1175: END IF;
1176:
1177: FND_MSG_PUB.Count_And_Get(
1178: p_count => x_msg_count,

Line 1177: FND_MSG_PUB.Count_And_Get(

1173: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1175: END IF;
1176:
1177: FND_MSG_PUB.Count_And_Get(
1178: p_count => x_msg_count,
1179: p_data => x_msg_data );
1180:
1181: END DELETE_CACHE_COMP;

Line 1223: FND_MSG_PUB.initialize;

1219: END IF;
1220:
1221: -- Initialize message list if p_init_msg_list is set to TRUE.
1222: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1223: FND_MSG_PUB.initialize;
1224: END IF;
1225:
1226: -- Initialize API return status to success
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1273: FND_MSG_PUB.Count_And_Get(

1269: COMMIT WORK;
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get(
1274: p_count => x_msg_count,
1275: p_data => x_msg_data );
1276:
1277: EXCEPTION

Line 1282: FND_MSG_PUB.Count_And_Get(

1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO INSERT_HA_COMP;
1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281:
1282: FND_MSG_PUB.Count_And_Get(
1283: p_count => x_msg_count,
1284: p_data => x_msg_data );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1290: FND_MSG_PUB.Count_And_Get(

1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: ROLLBACK TO INSERT_HA_COMP;
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1289:
1290: FND_MSG_PUB.Count_And_Get(
1291: p_count => x_msg_count,
1292: p_data => x_msg_data );
1293:
1294: WHEN OTHERS THEN

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

1294: WHEN OTHERS THEN
1295: ROLLBACK TO INSERT_HA_COMP;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1297:
1298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1300: END IF;
1301:
1302: FND_MSG_PUB.Count_And_Get(

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

1295: ROLLBACK TO INSERT_HA_COMP;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1297:
1298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1300: END IF;
1301:
1302: FND_MSG_PUB.Count_And_Get(
1303: p_count => x_msg_count,

Line 1302: FND_MSG_PUB.Count_And_Get(

1298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1300: END IF;
1301:
1302: FND_MSG_PUB.Count_And_Get(
1303: p_count => x_msg_count,
1304: p_data => x_msg_data );
1305:
1306: END INSERT_HA_COMP;

Line 1344: FND_MSG_PUB.initialize;

1340: END IF;
1341:
1342: -- Initialize message list if p_init_msg_list is set to TRUE.
1343: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1344: FND_MSG_PUB.initialize;
1345: END IF;
1346:
1347: -- Initialize API return status to success
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1372: FND_MSG_PUB.Count_And_Get(

1368: COMMIT WORK;
1369: END IF;
1370:
1371: -- Standard call to get message count and if count is 1, get message info.
1372: FND_MSG_PUB.Count_And_Get(
1373: p_count => x_msg_count,
1374: p_data => x_msg_data );
1375:
1376: EXCEPTION

Line 1381: FND_MSG_PUB.Count_And_Get(

1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO UPDATE_HA_COMP;
1379: x_return_status := FND_API.G_RET_STS_ERROR ;
1380:
1381: FND_MSG_PUB.Count_And_Get(
1382: p_count => x_msg_count,
1383: p_data => x_msg_data );
1384:
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1389: FND_MSG_PUB.Count_And_Get(

1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: ROLLBACK TO UPDATE_HA_COMP;
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1388:
1389: FND_MSG_PUB.Count_And_Get(
1390: p_count => x_msg_count,
1391: p_data => x_msg_data );
1392:
1393: WHEN OTHERS THEN

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

1393: WHEN OTHERS THEN
1394: ROLLBACK TO UPDATE_HA_COMP;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1399: END IF;
1400:
1401: FND_MSG_PUB.Count_And_Get(

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

1394: ROLLBACK TO UPDATE_HA_COMP;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1399: END IF;
1400:
1401: FND_MSG_PUB.Count_And_Get(
1402: p_count => x_msg_count,

Line 1401: FND_MSG_PUB.Count_And_Get(

1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1399: END IF;
1400:
1401: FND_MSG_PUB.Count_And_Get(
1402: p_count => x_msg_count,
1403: p_data => x_msg_data );
1404:
1405: END UPDATE_HA_COMP;

Line 1439: FND_MSG_PUB.initialize;

1435: END IF;
1436:
1437: -- Initialize message list if p_init_msg_list is set to TRUE.
1438: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441:
1442: -- Initialize API return status to success
1443: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1460: FND_MSG_PUB.Count_And_Get(

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

Line 1469: FND_MSG_PUB.Count_And_Get(

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

Line 1477: FND_MSG_PUB.Count_And_Get(

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

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

1481: WHEN OTHERS THEN
1482: ROLLBACK TO DELETE_HA_COMPS_FOR_HOST_APP;
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 ) THEN
1486: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1487: END IF;
1488:
1489: FND_MSG_PUB.Count_And_Get(

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

1482: ROLLBACK TO DELETE_HA_COMPS_FOR_HOST_APP;
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 ) THEN
1486: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1487: END IF;
1488:
1489: FND_MSG_PUB.Count_And_Get(
1490: p_count => x_msg_count,

Line 1489: FND_MSG_PUB.Count_And_Get(

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

Line 1527: FND_MSG_PUB.initialize;

1523: END IF;
1524:
1525: -- Initialize message list if p_init_msg_list is set to TRUE.
1526: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:
1530: -- Initialize API return status to success
1531: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1548: FND_MSG_PUB.Count_And_Get(

1544: COMMIT WORK;
1545: END IF;
1546:
1547: -- Standard call to get message count and if count is 1, get message info.
1548: FND_MSG_PUB.Count_And_Get(
1549: p_count => x_msg_count,
1550: p_data => x_msg_data );
1551:
1552: EXCEPTION

Line 1557: FND_MSG_PUB.Count_And_Get(

1553: WHEN FND_API.G_EXC_ERROR THEN
1554: ROLLBACK TO DELETE_HA_COMPS_FOR_CACHE_COMP;
1555: x_return_status := FND_API.G_RET_STS_ERROR ;
1556:
1557: FND_MSG_PUB.Count_And_Get(
1558: p_count => x_msg_count,
1559: p_data => x_msg_data );
1560:
1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1565: FND_MSG_PUB.Count_And_Get(

1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1562: ROLLBACK TO DELETE_HA_COMPS_FOR_CACHE_COMP;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564:
1565: FND_MSG_PUB.Count_And_Get(
1566: p_count => x_msg_count,
1567: p_data => x_msg_data );
1568:
1569: WHEN OTHERS THEN

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

1569: WHEN OTHERS THEN
1570: ROLLBACK TO DELETE_HA_COMPS_FOR_CACHE_COMP;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1572:
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1575: END IF;
1576:
1577: FND_MSG_PUB.Count_And_Get(

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

1570: ROLLBACK TO DELETE_HA_COMPS_FOR_CACHE_COMP;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1572:
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1575: END IF;
1576:
1577: FND_MSG_PUB.Count_And_Get(
1578: p_count => x_msg_count,

Line 1577: FND_MSG_PUB.Count_And_Get(

1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1575: END IF;
1576:
1577: FND_MSG_PUB.Count_And_Get(
1578: p_count => x_msg_count,
1579: p_data => x_msg_data );
1580:
1581: END DELETE_HA_COMPS_FOR_CACHE_COMP;

Line 1631: FND_MSG_PUB.initialize;

1627: END IF;
1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1631: FND_MSG_PUB.initialize;
1632: END IF;
1633:
1634: -- Initialize API return status to success
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1696: FND_MSG_PUB.Count_And_Get(

1692: COMMIT WORK;
1693: END IF;
1694:
1695: -- Standard call to get message count and if count is 1, get message info.
1696: FND_MSG_PUB.Count_And_Get(
1697: p_count => x_msg_count,
1698: p_data => x_msg_data );
1699:
1700: EXCEPTION

Line 1705: FND_MSG_PUB.Count_And_Get(

1701: WHEN FND_API.G_EXC_ERROR THEN
1702: ROLLBACK TO INSERT_CACHE_STAT;
1703: x_return_status := FND_API.G_RET_STS_ERROR ;
1704:
1705: FND_MSG_PUB.Count_And_Get(
1706: p_count => x_msg_count,
1707: p_data => x_msg_data );
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1713: FND_MSG_PUB.Count_And_Get(

1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710: ROLLBACK TO INSERT_CACHE_STAT;
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712:
1713: FND_MSG_PUB.Count_And_Get(
1714: p_count => x_msg_count,
1715: p_data => x_msg_data );
1716:
1717: WHEN OTHERS THEN

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

1717: WHEN OTHERS THEN
1718: ROLLBACK TO INSERT_CACHE_STAT;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1720:
1721: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1723: END IF;
1724:
1725: FND_MSG_PUB.Count_And_Get(

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

1718: ROLLBACK TO INSERT_CACHE_STAT;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1720:
1721: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1723: END IF;
1724:
1725: FND_MSG_PUB.Count_And_Get(
1726: p_count => x_msg_count,

Line 1725: FND_MSG_PUB.Count_And_Get(

1721: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1723: END IF;
1724:
1725: FND_MSG_PUB.Count_And_Get(
1726: p_count => x_msg_count,
1727: p_data => x_msg_data );
1728: END INSERT_CACHE_STAT;
1729:

Line 1776: FND_MSG_PUB.initialize;

1772: END IF;
1773:
1774: -- Initialize message list if p_init_msg_list is set to TRUE.
1775: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1776: FND_MSG_PUB.initialize;
1777: END IF;
1778:
1779: -- Initialize API return status to success
1780: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1816: FND_MSG_PUB.Count_And_Get(

1812: COMMIT WORK;
1813: END IF;
1814:
1815: -- Standard call to get message count and if count is 1, get message info.
1816: FND_MSG_PUB.Count_And_Get(
1817: p_count => x_msg_count,
1818: p_data => x_msg_data );
1819:
1820: EXCEPTION

Line 1825: FND_MSG_PUB.Count_And_Get(

1821: WHEN FND_API.G_EXC_ERROR THEN
1822: ROLLBACK TO UPDATE_CACHE_STAT;
1823: x_return_status := FND_API.G_RET_STS_ERROR ;
1824:
1825: FND_MSG_PUB.Count_And_Get(
1826: p_count => x_msg_count,
1827: p_data => x_msg_data );
1828:
1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1833: FND_MSG_PUB.Count_And_Get(

1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1830: ROLLBACK TO UPDATE_CACHE_STAT;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832:
1833: FND_MSG_PUB.Count_And_Get(
1834: p_count => x_msg_count,
1835: p_data => x_msg_data );
1836:
1837: WHEN OTHERS THEN

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

1837: WHEN OTHERS THEN
1838: ROLLBACK TO UPDATE_CACHE_STAT;
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1840:
1841: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1843: END IF;
1844:
1845: FND_MSG_PUB.Count_And_Get(

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

1838: ROLLBACK TO UPDATE_CACHE_STAT;
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1840:
1841: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1843: END IF;
1844:
1845: FND_MSG_PUB.Count_And_Get(
1846: p_count => x_msg_count,

Line 1845: FND_MSG_PUB.Count_And_Get(

1841: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1843: END IF;
1844:
1845: FND_MSG_PUB.Count_And_Get(
1846: p_count => x_msg_count,
1847: p_data => x_msg_data );
1848:
1849: END UPDATE_CACHE_STAT;

Line 1879: FND_MSG_PUB.initialize;

1875: END IF;
1876:
1877: -- Initialize message list if p_init_msg_list is set to TRUE.
1878: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1879: FND_MSG_PUB.initialize;
1880: END IF;
1881:
1882: -- Initialize API return status to success
1883: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1902: FND_MSG_PUB.Count_And_Get(

1898: COMMIT WORK;
1899: END IF;
1900:
1901: -- Standard call to get message count and if count is 1, get message info.
1902: FND_MSG_PUB.Count_And_Get(
1903: p_count => x_msg_count,
1904: p_data => x_msg_data );
1905:
1906: EXCEPTION

Line 1911: FND_MSG_PUB.Count_And_Get(

1907: WHEN FND_API.G_EXC_ERROR THEN
1908: ROLLBACK TO DELETE_CACHE_STAT;
1909: x_return_status := FND_API.G_RET_STS_ERROR ;
1910:
1911: FND_MSG_PUB.Count_And_Get(
1912: p_count => x_msg_count,
1913: p_data => x_msg_data );
1914:
1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1919: FND_MSG_PUB.Count_And_Get(

1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: ROLLBACK TO DELETE_CACHE_STAT;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1918:
1919: FND_MSG_PUB.Count_And_Get(
1920: p_count => x_msg_count,
1921: p_data => x_msg_data );
1922:
1923: WHEN OTHERS THEN

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

1923: WHEN OTHERS THEN
1924: ROLLBACK TO DELETE_CACHE_STAT;
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1926:
1927: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1929: END IF;
1930:
1931: FND_MSG_PUB.Count_And_Get(

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

1924: ROLLBACK TO DELETE_CACHE_STAT;
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1926:
1927: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1929: END IF;
1930:
1931: FND_MSG_PUB.Count_And_Get(
1932: p_count => x_msg_count,

Line 1931: FND_MSG_PUB.Count_And_Get(

1927: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1929: END IF;
1930:
1931: FND_MSG_PUB.Count_And_Get(
1932: p_count => x_msg_count,
1933: p_data => x_msg_data );
1934:
1935: END DELETE_CACHE_STAT;

Line 1968: FND_MSG_PUB.initialize;

1964: END IF;
1965:
1966: -- Initialize message list if p_init_msg_list is set to TRUE.
1967: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1968: FND_MSG_PUB.initialize;
1969: END IF;
1970:
1971: -- Initialize API return status to success
1972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1998: FND_MSG_PUB.Count_And_Get(

1994: COMMIT WORK;
1995: END IF;
1996:
1997: -- Standard call to get message count and if count is 1, get message info.
1998: FND_MSG_PUB.Count_And_Get(
1999: p_count => x_msg_count,
2000: p_data => x_msg_data );
2001:
2002: EXCEPTION

Line 2007: FND_MSG_PUB.Count_And_Get(

2003: WHEN FND_API.G_EXC_ERROR THEN
2004: ROLLBACK TO RESET_CACHE_STAT;
2005: x_return_status := FND_API.G_RET_STS_ERROR ;
2006:
2007: FND_MSG_PUB.Count_And_Get(
2008: p_count => x_msg_count,
2009: p_data => x_msg_data );
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2015: FND_MSG_PUB.Count_And_Get(

2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO RESET_CACHE_STAT;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2014:
2015: FND_MSG_PUB.Count_And_Get(
2016: p_count => x_msg_count,
2017: p_data => x_msg_data );
2018:
2019: WHEN OTHERS THEN

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

2019: WHEN OTHERS THEN
2020: ROLLBACK TO RESET_CACHE_STAT;
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2022:
2023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2024: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2025: END IF;
2026:
2027: FND_MSG_PUB.Count_And_Get(

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

2020: ROLLBACK TO RESET_CACHE_STAT;
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2022:
2023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2024: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2025: END IF;
2026:
2027: FND_MSG_PUB.Count_And_Get(
2028: p_count => x_msg_count,

Line 2027: FND_MSG_PUB.Count_And_Get(

2023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2024: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2025: END IF;
2026:
2027: FND_MSG_PUB.Count_And_Get(
2028: p_count => x_msg_count,
2029: p_data => x_msg_data );
2030:
2031: END RESET_CACHE_STAT;

Line 2079: FND_MSG_PUB.initialize;

2075: END IF;
2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.
2078: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2079: FND_MSG_PUB.initialize;
2080: END IF;
2081:
2082: -- Initialize API return status to success
2083: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2137: FND_MSG_PUB.Count_And_Get(

2133: COMMIT WORK;
2134: END IF;
2135:
2136: -- Standard call to get message count and if count is 1, get message info.
2137: FND_MSG_PUB.Count_And_Get(
2138: p_count => x_msg_count,
2139: p_data => x_msg_data );
2140:
2141: EXCEPTION

Line 2146: FND_MSG_PUB.Count_And_Get(

2142: WHEN FND_API.G_EXC_ERROR THEN
2143: ROLLBACK TO INSERT_CA_FILTER;
2144: x_return_status := FND_API.G_RET_STS_ERROR ;
2145:
2146: FND_MSG_PUB.Count_And_Get(
2147: p_count => x_msg_count,
2148: p_data => x_msg_data );
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2154: FND_MSG_PUB.Count_And_Get(

2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: ROLLBACK TO INSERT_CA_FILTER;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2153:
2154: FND_MSG_PUB.Count_And_Get(
2155: p_count => x_msg_count,
2156: p_data => x_msg_data );
2157:
2158: WHEN OTHERS THEN

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

2158: WHEN OTHERS THEN
2159: ROLLBACK TO INSERT_CA_FILTER;
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2161:
2162: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2164: END IF;
2165:
2166: FND_MSG_PUB.Count_And_Get(

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

2159: ROLLBACK TO INSERT_CA_FILTER;
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2161:
2162: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2164: END IF;
2165:
2166: FND_MSG_PUB.Count_And_Get(
2167: p_count => x_msg_count,

Line 2166: FND_MSG_PUB.Count_And_Get(

2162: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2164: END IF;
2165:
2166: FND_MSG_PUB.Count_And_Get(
2167: p_count => x_msg_count,
2168: p_data => x_msg_data );
2169:
2170: END INSERT_CA_FILTER;

Line 2208: FND_MSG_PUB.initialize;

2204: END IF;
2205:
2206: -- Initialize message list if p_init_msg_list is set to TRUE.
2207: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2208: FND_MSG_PUB.initialize;
2209: END IF;
2210:
2211: -- Initialize API return status to success
2212: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2236: FND_MSG_PUB.Count_And_Get(

2232: COMMIT WORK;
2233: END IF;
2234:
2235: -- Standard call to get message count and if count is 1, get message info.
2236: FND_MSG_PUB.Count_And_Get(
2237: p_count => x_msg_count,
2238: p_data => x_msg_data );
2239:
2240: EXCEPTION

Line 2245: FND_MSG_PUB.Count_And_Get(

2241: WHEN FND_API.G_EXC_ERROR THEN
2242: ROLLBACK TO UPDATE_CA_FILTER;
2243: x_return_status := FND_API.G_RET_STS_ERROR ;
2244:
2245: FND_MSG_PUB.Count_And_Get(
2246: p_count => x_msg_count,
2247: p_data => x_msg_data );
2248:
2249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2253: FND_MSG_PUB.Count_And_Get(

2249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2250: ROLLBACK TO UPDATE_CA_FILTER;
2251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2252:
2253: FND_MSG_PUB.Count_And_Get(
2254: p_count => x_msg_count,
2255: p_data => x_msg_data );
2256:
2257: WHEN OTHERS THEN

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

2257: WHEN OTHERS THEN
2258: ROLLBACK TO UPDATE_CA_FILTER;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2260:
2261: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2263: END IF;
2264:
2265: FND_MSG_PUB.Count_And_Get(

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

2258: ROLLBACK TO UPDATE_CA_FILTER;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2260:
2261: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2263: END IF;
2264:
2265: FND_MSG_PUB.Count_And_Get(
2266: p_count => x_msg_count,

Line 2265: FND_MSG_PUB.Count_And_Get(

2261: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2263: END IF;
2264:
2265: FND_MSG_PUB.Count_And_Get(
2266: p_count => x_msg_count,
2267: p_data => x_msg_data );
2268:
2269: END UPDATE_CA_FILTER;

Line 2303: FND_MSG_PUB.initialize;

2299: END IF;
2300:
2301: -- Initialize message list if p_init_msg_list is set to TRUE.
2302: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2303: FND_MSG_PUB.initialize;
2304: END IF;
2305:
2306: -- Initialize API return status to success
2307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2348: FND_MSG_PUB.Count_And_Get(

2344: COMMIT WORK;
2345: END IF;
2346:
2347: -- Standard call to get message count and if count is 1, get message info.
2348: FND_MSG_PUB.Count_And_Get(
2349: p_count => x_msg_count,
2350: p_data => x_msg_data );
2351:
2352: EXCEPTION

Line 2357: FND_MSG_PUB.Count_And_Get(

2353: WHEN FND_API.G_EXC_ERROR THEN
2354: ROLLBACK TO DELETE_CA_FILTER;
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356:
2357: FND_MSG_PUB.Count_And_Get(
2358: p_count => x_msg_count,
2359: p_data => x_msg_data );
2360:
2361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2365: FND_MSG_PUB.Count_And_Get(

2361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2362: ROLLBACK TO DELETE_CA_FILTER;
2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2364:
2365: FND_MSG_PUB.Count_And_Get(
2366: p_count => x_msg_count,
2367: p_data => x_msg_data );
2368:
2369: WHEN OTHERS THEN

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

2369: WHEN OTHERS THEN
2370: ROLLBACK TO DELETE_CA_FILTER;
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2372:
2373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2375: END IF;
2376:
2377: FND_MSG_PUB.Count_And_Get(

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

2370: ROLLBACK TO DELETE_CA_FILTER;
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2372:
2373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2375: END IF;
2376:
2377: FND_MSG_PUB.Count_And_Get(
2378: p_count => x_msg_count,

Line 2377: FND_MSG_PUB.Count_And_Get(

2373: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2375: END IF;
2376:
2377: FND_MSG_PUB.Count_And_Get(
2378: p_count => x_msg_count,
2379: p_data => x_msg_data );
2380:
2381: END DELETE_CA_FILTER;

Line 2421: FND_MSG_PUB.initialize;

2417: END IF;
2418:
2419: -- Initialize message list if p_init_msg_list is set to TRUE.
2420: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2421: FND_MSG_PUB.initialize;
2422: END IF;
2423:
2424: -- Initialize API return status to success
2425: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2467: FND_MSG_PUB.Count_And_Get(

2463: COMMIT WORK;
2464: END IF;
2465:
2466: -- Standard call to get message count and if count is 1, get message info.
2467: FND_MSG_PUB.Count_And_Get(
2468: p_count => x_msg_count,
2469: p_data => x_msg_data );
2470:
2471: EXCEPTION

Line 2476: FND_MSG_PUB.Count_And_Get(

2472: WHEN FND_API.G_EXC_ERROR THEN
2473: ROLLBACK TO INSERT_HA_FILTER;
2474: x_return_status := FND_API.G_RET_STS_ERROR ;
2475:
2476: FND_MSG_PUB.Count_And_Get(
2477: p_count => x_msg_count,
2478: p_data => x_msg_data );
2479:
2480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2484: FND_MSG_PUB.Count_And_Get(

2480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2481: ROLLBACK TO INSERT_HA_FILTER;
2482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2483:
2484: FND_MSG_PUB.Count_And_Get(
2485: p_count => x_msg_count,
2486: p_data => x_msg_data );
2487:
2488: WHEN OTHERS THEN

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

2488: WHEN OTHERS THEN
2489: ROLLBACK TO INSERT_HA_FILTER;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491:
2492: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2494: END IF;
2495:
2496: FND_MSG_PUB.Count_And_Get(

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

2489: ROLLBACK TO INSERT_HA_FILTER;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491:
2492: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2494: END IF;
2495:
2496: FND_MSG_PUB.Count_And_Get(
2497: p_count => x_msg_count,

Line 2496: FND_MSG_PUB.Count_And_Get(

2492: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2494: END IF;
2495:
2496: FND_MSG_PUB.Count_And_Get(
2497: p_count => x_msg_count,
2498: p_data => x_msg_data );
2499:
2500: END INSERT_HA_FILTER;

Line 2536: FND_MSG_PUB.initialize;

2532: END IF;
2533:
2534: -- Initialize message list if p_init_msg_list is set to TRUE.
2535: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2536: FND_MSG_PUB.initialize;
2537: END IF;
2538:
2539: -- Initialize API return status to success
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2562: FND_MSG_PUB.Count_And_Get(

2558: COMMIT WORK;
2559: END IF;
2560:
2561: -- Standard call to get message count and if count is 1, get message info.
2562: FND_MSG_PUB.Count_And_Get(
2563: p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:
2566: EXCEPTION

Line 2571: FND_MSG_PUB.Count_And_Get(

2567: WHEN FND_API.G_EXC_ERROR THEN
2568: ROLLBACK TO UPDATE_HA_FILTER;
2569: x_return_status := FND_API.G_RET_STS_ERROR ;
2570:
2571: FND_MSG_PUB.Count_And_Get(
2572: p_count => x_msg_count,
2573: p_data => x_msg_data );
2574:
2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2579: FND_MSG_PUB.Count_And_Get(

2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2576: ROLLBACK TO UPDATE_HA_FILTER;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2578:
2579: FND_MSG_PUB.Count_And_Get(
2580: p_count => x_msg_count,
2581: p_data => x_msg_data );
2582:
2583: WHEN OTHERS THEN

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

2583: WHEN OTHERS THEN
2584: ROLLBACK TO UPDATE_HA_FILTER;
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2586:
2587: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2589: END IF;
2590:
2591: FND_MSG_PUB.Count_And_Get(

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

2584: ROLLBACK TO UPDATE_HA_FILTER;
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2586:
2587: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2589: END IF;
2590:
2591: FND_MSG_PUB.Count_And_Get(
2592: p_count => x_msg_count,

Line 2591: FND_MSG_PUB.Count_And_Get(

2587: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2589: END IF;
2590:
2591: FND_MSG_PUB.Count_And_Get(
2592: p_count => x_msg_count,
2593: p_data => x_msg_data );
2594:
2595: END UPDATE_HA_FILTER;

Line 2629: FND_MSG_PUB.initialize;

2625: END IF;
2626:
2627: -- Initialize message list if p_init_msg_list is set to TRUE.
2628: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2629: FND_MSG_PUB.initialize;
2630: END IF;
2631:
2632: -- Initialize API return status to success
2633: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2650: FND_MSG_PUB.Count_And_Get(

2646: COMMIT WORK;
2647: END IF;
2648:
2649: -- Standard call to get message count and if count is 1, get message info.
2650: FND_MSG_PUB.Count_And_Get(
2651: p_count => x_msg_count,
2652: p_data => x_msg_data );
2653:
2654: EXCEPTION

Line 2659: FND_MSG_PUB.Count_And_Get(

2655: WHEN FND_API.G_EXC_ERROR THEN
2656: ROLLBACK TO DELETE_HA_FILTERS_F_HOST_APP;
2657: x_return_status := FND_API.G_RET_STS_ERROR ;
2658:
2659: FND_MSG_PUB.Count_And_Get(
2660: p_count => x_msg_count,
2661: p_data => x_msg_data );
2662:
2663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2667: FND_MSG_PUB.Count_And_Get(

2663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2664: ROLLBACK TO DELETE_HA_FILTERS_F_HOST_APP;
2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2666:
2667: FND_MSG_PUB.Count_And_Get(
2668: p_count => x_msg_count,
2669: p_data => x_msg_data );
2670:
2671: WHEN OTHERS THEN

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

2671: WHEN OTHERS THEN
2672: ROLLBACK TO DELETE_HA_FILTERS_F_HOST_APP;
2673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2674:
2675: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678:
2679: FND_MSG_PUB.Count_And_Get(

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

2672: ROLLBACK TO DELETE_HA_FILTERS_F_HOST_APP;
2673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2674:
2675: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678:
2679: FND_MSG_PUB.Count_And_Get(
2680: p_count => x_msg_count,

Line 2679: FND_MSG_PUB.Count_And_Get(

2675: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678:
2679: FND_MSG_PUB.Count_And_Get(
2680: p_count => x_msg_count,
2681: p_data => x_msg_data );
2682:
2683: END DELETE_HA_FILTERS_F_HOST_APP;

Line 2717: FND_MSG_PUB.initialize;

2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2738: FND_MSG_PUB.Count_And_Get(

2734: COMMIT WORK;
2735: END IF;
2736:
2737: -- Standard call to get message count and if count is 1, get message info.
2738: FND_MSG_PUB.Count_And_Get(
2739: p_count => x_msg_count,
2740: p_data => x_msg_data );
2741:
2742: EXCEPTION

Line 2747: FND_MSG_PUB.Count_And_Get(

2743: WHEN FND_API.G_EXC_ERROR THEN
2744: ROLLBACK TO DELETE_HA_FILTERS_F_CA_FILTER;
2745: x_return_status := FND_API.G_RET_STS_ERROR ;
2746:
2747: FND_MSG_PUB.Count_And_Get(
2748: p_count => x_msg_count,
2749: p_data => x_msg_data );
2750:
2751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2755: FND_MSG_PUB.Count_And_Get(

2751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2752: ROLLBACK TO DELETE_HA_FILTERS_F_CA_FILTER;
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2754:
2755: FND_MSG_PUB.Count_And_Get(
2756: p_count => x_msg_count,
2757: p_data => x_msg_data );
2758:
2759: WHEN OTHERS THEN

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

2759: WHEN OTHERS THEN
2760: ROLLBACK TO DELETE_HA_FILTERS_F_CA_FILTER;
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762:
2763: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2765: END IF;
2766:
2767: FND_MSG_PUB.Count_And_Get(

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

2760: ROLLBACK TO DELETE_HA_FILTERS_F_CA_FILTER;
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762:
2763: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2765: END IF;
2766:
2767: FND_MSG_PUB.Count_And_Get(
2768: p_count => x_msg_count,

Line 2767: FND_MSG_PUB.Count_And_Get(

2763: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2765: END IF;
2766:
2767: FND_MSG_PUB.Count_And_Get(
2768: p_count => x_msg_count,
2769: p_data => x_msg_data );
2770:
2771: END DELETE_HA_FILTERS_F_CA_FILTER;

Line 2811: FND_MSG_PUB.initialize;

2807: END IF;
2808:
2809: -- Initialize message list if p_init_msg_list is set to TRUE.
2810: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2811: FND_MSG_PUB.initialize;
2812: END IF;
2813:
2814: -- Initialize API return status to success
2815: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2855: FND_MSG_PUB.Count_And_Get(

2851: COMMIT WORK;
2852: END IF;
2853:
2854: -- Standard call to get message count and if count is 1, get message info.
2855: FND_MSG_PUB.Count_And_Get(
2856: p_count => x_msg_count,
2857: p_data => x_msg_data );
2858:
2859: EXCEPTION

Line 2864: FND_MSG_PUB.Count_And_Get(

2860: WHEN FND_API.G_EXC_ERROR THEN
2861: ROLLBACK TO INSERT_CA_FL_RESP;
2862: x_return_status := FND_API.G_RET_STS_ERROR ;
2863:
2864: FND_MSG_PUB.Count_And_Get(
2865: p_count => x_msg_count,
2866: p_data => x_msg_data );
2867:
2868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2872: FND_MSG_PUB.Count_And_Get(

2868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2869: ROLLBACK TO INSERT_CA_FL_RESP;
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2871:
2872: FND_MSG_PUB.Count_And_Get(
2873: p_count => x_msg_count,
2874: p_data => x_msg_data );
2875:
2876: WHEN OTHERS THEN

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

2876: WHEN OTHERS THEN
2877: ROLLBACK TO INSERT_CA_FL_RESP;
2878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2879:
2880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2882: END IF;
2883:
2884: FND_MSG_PUB.Count_And_Get(

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

2877: ROLLBACK TO INSERT_CA_FL_RESP;
2878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2879:
2880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2882: END IF;
2883:
2884: FND_MSG_PUB.Count_And_Get(
2885: p_count => x_msg_count,

Line 2884: FND_MSG_PUB.Count_And_Get(

2880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2882: END IF;
2883:
2884: FND_MSG_PUB.Count_And_Get(
2885: p_count => x_msg_count,
2886: p_data => x_msg_data );
2887:
2888: END INSERT_CA_FL_RESP;

Line 2922: FND_MSG_PUB.initialize;

2918: END IF;
2919:
2920: -- Initialize message list if p_init_msg_list is set to TRUE.
2921: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2922: FND_MSG_PUB.initialize;
2923: END IF;
2924:
2925: -- Initialize API return status to success
2926: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2943: FND_MSG_PUB.Count_And_Get(

2939: COMMIT WORK;
2940: END IF;
2941:
2942: -- Standard call to get message count and if count is 1, get message info.
2943: FND_MSG_PUB.Count_And_Get(
2944: p_count => x_msg_count,
2945: p_data => x_msg_data );
2946:
2947: EXCEPTION

Line 2952: FND_MSG_PUB.Count_And_Get(

2948: WHEN FND_API.G_EXC_ERROR THEN
2949: ROLLBACK TO DELETE_CA_FL_RESP;
2950: x_return_status := FND_API.G_RET_STS_ERROR ;
2951:
2952: FND_MSG_PUB.Count_And_Get(
2953: p_count => x_msg_count,
2954: p_data => x_msg_data );
2955:
2956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2960: FND_MSG_PUB.Count_And_Get(

2956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2957: ROLLBACK TO DELETE_CA_FL_RESP;
2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2959:
2960: FND_MSG_PUB.Count_And_Get(
2961: p_count => x_msg_count,
2962: p_data => x_msg_data );
2963:
2964: WHEN OTHERS THEN

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

2964: WHEN OTHERS THEN
2965: ROLLBACK TO DELETE_CA_FL_RESP;
2966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2967:
2968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2970: END IF;
2971:
2972: FND_MSG_PUB.Count_And_Get(

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

2965: ROLLBACK TO DELETE_CA_FL_RESP;
2966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2967:
2968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2970: END IF;
2971:
2972: FND_MSG_PUB.Count_And_Get(
2973: p_count => x_msg_count,

Line 2972: FND_MSG_PUB.Count_And_Get(

2968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2970: END IF;
2971:
2972: FND_MSG_PUB.Count_And_Get(
2973: p_count => x_msg_count,
2974: p_data => x_msg_data );
2975:
2976: END DELETE_CA_FL_RESP;

Line 3011: FND_MSG_PUB.initialize;

3007: END IF;
3008:
3009: -- Initialize message list if p_init_msg_list is set to TRUE.
3010: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3011: FND_MSG_PUB.initialize;
3012: END IF;
3013:
3014: -- Initialize API return status to success
3015: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3033: FND_MSG_PUB.Count_And_Get(

3029: COMMIT WORK;
3030: END IF;
3031:
3032: -- Standard call to get message count and if count is 1, get message info.
3033: FND_MSG_PUB.Count_And_Get(
3034: p_count => x_msg_count,
3035: p_data => x_msg_data );
3036:
3037: EXCEPTION

Line 3042: FND_MSG_PUB.Count_And_Get(

3038: WHEN FND_API.G_EXC_ERROR THEN
3039: ROLLBACK TO DELETE_CA_FL_RESP;
3040: x_return_status := FND_API.G_RET_STS_ERROR ;
3041:
3042: FND_MSG_PUB.Count_And_Get(
3043: p_count => x_msg_count,
3044: p_data => x_msg_data );
3045:
3046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3050: FND_MSG_PUB.Count_And_Get(

3046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3047: ROLLBACK TO DELETE_CA_FL_RESP;
3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3049:
3050: FND_MSG_PUB.Count_And_Get(
3051: p_count => x_msg_count,
3052: p_data => x_msg_data );
3053:
3054: WHEN OTHERS THEN

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

3054: WHEN OTHERS THEN
3055: ROLLBACK TO DELETE_CA_FL_RESP;
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057:
3058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3060: END IF;
3061:
3062: FND_MSG_PUB.Count_And_Get(

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

3055: ROLLBACK TO DELETE_CA_FL_RESP;
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057:
3058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3060: END IF;
3061:
3062: FND_MSG_PUB.Count_And_Get(
3063: p_count => x_msg_count,

Line 3062: FND_MSG_PUB.Count_And_Get(

3058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3060: END IF;
3061:
3062: FND_MSG_PUB.Count_And_Get(
3063: p_count => x_msg_count,
3064: p_data => x_msg_data );
3065:
3066: END DELETE_CA_FL_RESP;

Line 3106: FND_MSG_PUB.initialize;

3102: END IF;
3103:
3104: -- Initialize message list if p_init_msg_list is set to TRUE.
3105: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3106: FND_MSG_PUB.initialize;
3107: END IF;
3108:
3109: -- Initialize API return status to success
3110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3150: FND_MSG_PUB.Count_And_Get(

3146: COMMIT WORK;
3147: END IF;
3148:
3149: -- Standard call to get message count and if count is 1, get message info.
3150: FND_MSG_PUB.Count_And_Get(
3151: p_count => x_msg_count,
3152: p_data => x_msg_data );
3153:
3154: EXCEPTION

Line 3159: FND_MSG_PUB.Count_And_Get(

3155: WHEN FND_API.G_EXC_ERROR THEN
3156: ROLLBACK TO INSERT_CA_FL_LANG;
3157: x_return_status := FND_API.G_RET_STS_ERROR ;
3158:
3159: FND_MSG_PUB.Count_And_Get(
3160: p_count => x_msg_count,
3161: p_data => x_msg_data );
3162:
3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3167: FND_MSG_PUB.Count_And_Get(

3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3164: ROLLBACK TO INSERT_CA_FL_LANG;
3165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3166:
3167: FND_MSG_PUB.Count_And_Get(
3168: p_count => x_msg_count,
3169: p_data => x_msg_data );
3170:
3171: WHEN OTHERS THEN

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

3171: WHEN OTHERS THEN
3172: ROLLBACK TO INSERT_CA_FL_LANG;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174:
3175: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3177: END IF;
3178:
3179: FND_MSG_PUB.Count_And_Get(

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

3172: ROLLBACK TO INSERT_CA_FL_LANG;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174:
3175: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3177: END IF;
3178:
3179: FND_MSG_PUB.Count_And_Get(
3180: p_count => x_msg_count,

Line 3179: FND_MSG_PUB.Count_And_Get(

3175: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3177: END IF;
3178:
3179: FND_MSG_PUB.Count_And_Get(
3180: p_count => x_msg_count,
3181: p_data => x_msg_data );
3182:
3183: END INSERT_CA_FL_LANG;

Line 3217: FND_MSG_PUB.initialize;

3213: END IF;
3214:
3215: -- Initialize message list if p_init_msg_list is set to TRUE.
3216: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3217: FND_MSG_PUB.initialize;
3218: END IF;
3219:
3220: -- Initialize API return status to success
3221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3238: FND_MSG_PUB.Count_And_Get(

3234: COMMIT WORK;
3235: END IF;
3236:
3237: -- Standard call to get message count and if count is 1, get message info.
3238: FND_MSG_PUB.Count_And_Get(
3239: p_count => x_msg_count,
3240: p_data => x_msg_data );
3241:
3242: EXCEPTION

Line 3247: FND_MSG_PUB.Count_And_Get(

3243: WHEN FND_API.G_EXC_ERROR THEN
3244: ROLLBACK TO DELETE_CA_FL_LANG;
3245: x_return_status := FND_API.G_RET_STS_ERROR ;
3246:
3247: FND_MSG_PUB.Count_And_Get(
3248: p_count => x_msg_count,
3249: p_data => x_msg_data );
3250:
3251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3255: FND_MSG_PUB.Count_And_Get(

3251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3252: ROLLBACK TO DELETE_CA_FL_LANG;
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3254:
3255: FND_MSG_PUB.Count_And_Get(
3256: p_count => x_msg_count,
3257: p_data => x_msg_data );
3258:
3259: WHEN OTHERS THEN

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

3259: WHEN OTHERS THEN
3260: ROLLBACK TO DELETE_CA_FL_LANG;
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3262:
3263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3265: END IF;
3266:
3267: FND_MSG_PUB.Count_And_Get(

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

3260: ROLLBACK TO DELETE_CA_FL_LANG;
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3262:
3263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3265: END IF;
3266:
3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,

Line 3267: FND_MSG_PUB.Count_And_Get(

3263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3265: END IF;
3266:
3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data );
3270:
3271: END DELETE_CA_FL_LANG;

Line 3306: FND_MSG_PUB.initialize;

3302: END IF;
3303:
3304: -- Initialize message list if p_init_msg_list is set to TRUE.
3305: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3306: FND_MSG_PUB.initialize;
3307: END IF;
3308:
3309: -- Initialize API return status to success
3310: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3328: FND_MSG_PUB.Count_And_Get(

3324: COMMIT WORK;
3325: END IF;
3326:
3327: -- Standard call to get message count and if count is 1, get message info.
3328: FND_MSG_PUB.Count_And_Get(
3329: p_count => x_msg_count,
3330: p_data => x_msg_data );
3331:
3332: EXCEPTION

Line 3337: FND_MSG_PUB.Count_And_Get(

3333: WHEN FND_API.G_EXC_ERROR THEN
3334: ROLLBACK TO DELETE_CA_FL_LANG;
3335: x_return_status := FND_API.G_RET_STS_ERROR ;
3336:
3337: FND_MSG_PUB.Count_And_Get(
3338: p_count => x_msg_count,
3339: p_data => x_msg_data );
3340:
3341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3345: FND_MSG_PUB.Count_And_Get(

3341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3342: ROLLBACK TO DELETE_CA_FL_LANG;
3343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3344:
3345: FND_MSG_PUB.Count_And_Get(
3346: p_count => x_msg_count,
3347: p_data => x_msg_data );
3348:
3349: WHEN OTHERS THEN

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

3349: WHEN OTHERS THEN
3350: ROLLBACK TO DELETE_CA_FL_LANG;
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352:
3353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3355: END IF;
3356:
3357: FND_MSG_PUB.Count_And_Get(

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

3350: ROLLBACK TO DELETE_CA_FL_LANG;
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352:
3353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3355: END IF;
3356:
3357: FND_MSG_PUB.Count_And_Get(
3358: p_count => x_msg_count,

Line 3357: FND_MSG_PUB.Count_And_Get(

3353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3355: END IF;
3356:
3357: FND_MSG_PUB.Count_And_Get(
3358: p_count => x_msg_count,
3359: p_data => x_msg_data );
3360:
3361: END DELETE_CA_FL_LANG;