DBA Data[Home] [Help]

APPS.QA_RESULT_GRP dependencies on FND_MSG_PUB

Line 44: FND_MSG_PUB.initialize;

40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46: -- Initialize API return status to success
47: p_return_status := FND_API.G_RET_STS_SUCCESS;
48:

Line 76: FND_MSG_PUB.Count_And_Get

72: IF FND_API.To_Boolean( p_commit ) THEN
73: COMMIT WORK;
74: END IF;
75: -- Standard call to get message count and if count is 1, get message info.
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => p_msg_count ,
78: p_data => p_msg_data
79: );
80:

Line 85: FND_MSG_PUB.Count_And_Get

81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO Purge_GRP;
84: p_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.Count_And_Get
86: ( p_count => p_msg_count ,
87: p_data => p_msg_data
88: );
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 92: FND_MSG_PUB.Count_And_Get

88: );
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO Purge_GRP;
91: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: ( p_count => p_msg_count ,
94: p_data => p_msg_data
95: );
96: WHEN OTHERS THEN

Line 99: IF FND_MSG_PUB.Check_Msg_Level

95: );
96: WHEN OTHERS THEN
97: ROLLBACK TO Purge_GRP;
98: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: IF FND_MSG_PUB.Check_Msg_Level
100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg
103: ( G_PKG_NAME ,

Line 100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

96: WHEN OTHERS THEN
97: ROLLBACK TO Purge_GRP;
98: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: IF FND_MSG_PUB.Check_Msg_Level
100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg
103: ( G_PKG_NAME ,
104: l_api_name

Line 102: FND_MSG_PUB.Add_Exc_Msg

98: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: IF FND_MSG_PUB.Check_Msg_Level
100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg
103: ( G_PKG_NAME ,
104: l_api_name
105: );
106: END IF;

Line 107: FND_MSG_PUB.Count_And_Get

103: ( G_PKG_NAME ,
104: l_api_name
105: );
106: END IF;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => p_msg_count ,
109: p_data => p_msg_data
110: );
111: END Purge;

Line 161: FND_MSG_PUB.initialize;

157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163: -- Initialize API return status to success
164: p_return_status := FND_API.G_RET_STS_SUCCESS;
165:

Line 254: FND_MSG_PUB.Count_And_Get

250: COMMIT WORK;
251: END IF;
252:
253: -- Standard call to get message count and if count is 1, get message info.
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => p_msg_count ,
256: p_data => p_msg_data
257: );
258:

Line 263: FND_MSG_PUB.Count_And_Get

259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Enable_GRP;
262: p_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => p_msg_count ,
265: p_data => p_msg_data
266: );
267:

Line 271: FND_MSG_PUB.Count_And_Get

267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO Enable_GRP;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: FND_MSG_PUB.Count_And_Get
272: ( p_count => p_msg_count ,
273: p_data => p_msg_data
274: );
275: WHEN OTHERS THEN

Line 278: IF FND_MSG_PUB.Check_Msg_Level

274: );
275: WHEN OTHERS THEN
276: -- ROLLBACK TO Enable_GRP;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME ,

Line 279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

275: WHEN OTHERS THEN
276: -- ROLLBACK TO Enable_GRP;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME ,
283: l_api_name

Line 281: FND_MSG_PUB.Add_Exc_Msg

277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME ,
283: l_api_name
284: );
285: END IF;

Line 286: FND_MSG_PUB.Count_And_Get

282: ( G_PKG_NAME ,
283: l_api_name
284: );
285: END IF;
286: FND_MSG_PUB.Count_And_Get
287: ( p_count => p_msg_count ,
288: p_data => p_msg_data
289: );
290: END Enable;

Line 381: FND_MSG_PUB.initialize;

377: END IF;
378:
379: -- Initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- Initialize API return status to error
385: x_return_status := FND_API.G_RET_STS_ERROR;

Line 403: FND_MSG_PUB.Count_And_Get

399:
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO enable_and_fire_action_grp;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407:

Line 411: FND_MSG_PUB.Count_And_Get

407:
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
409: ROLLBACK TO enable_and_fire_action_grp;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: (p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415:

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

415:
416: WHEN OTHERS THEN
417: ROLLBACK TO enable_and_fire_action_grp;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
420: FND_MSG_PUB.Add_Exc_Msg
421: (G_PKG_NAME,
422: l_api_name
423: );

Line 420: FND_MSG_PUB.Add_Exc_Msg

416: WHEN OTHERS THEN
417: ROLLBACK TO enable_and_fire_action_grp;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
420: FND_MSG_PUB.Add_Exc_Msg
421: (G_PKG_NAME,
422: l_api_name
423: );
424: END IF;

Line 425: FND_MSG_PUB.Count_And_Get

421: (G_PKG_NAME,
422: l_api_name
423: );
424: END IF;
425: FND_MSG_PUB.Count_And_Get
426: (p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429:

Line 537: FND_MSG_PUB.initialize;

533: END IF;
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 634: FND_MSG_PUB.Count_And_Get

630:
631: END LOOP;
632:
633: -- Standard call to get message count and if count is 1, get message info.
634: FND_MSG_PUB.Count_And_Get
635: (
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );

Line 653: FND_MSG_PUB.Count_And_Get

649: EXCEPTION
650:
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get
654: (
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );

Line 670: FND_MSG_PUB.Count_And_Get

666: END IF;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get
671: (
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );

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

683: END IF;
684:
685: WHEN OTHERS THEN
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
688: FND_MSG_PUB.Add_Exc_Msg
689: (
690: p_pkg_name => g_pkg_name,
691: p_procedure_name => l_api_name,

Line 688: FND_MSG_PUB.Add_Exc_Msg

684:
685: WHEN OTHERS THEN
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
688: FND_MSG_PUB.Add_Exc_Msg
689: (
690: p_pkg_name => g_pkg_name,
691: p_procedure_name => l_api_name,
692: p_error_text => SUBSTR(SQLERRM,1,240)

Line 696: FND_MSG_PUB.Count_And_Get

692: p_error_text => SUBSTR(SQLERRM,1,240)
693: );
694: END IF;
695:
696: FND_MSG_PUB.Count_And_Get
697: (
698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );

Line 836: FND_MSG_PUB.initialize;

832: END IF;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838:
839: -- Initialize API return status to success
840: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1006: FND_MSG_PUB.count_and_get

1002: COMMIT WORK;
1003: END IF;
1004:
1005: -- Standard call to get message count and if count is 1, get message info.
1006: FND_MSG_PUB.count_and_get
1007: (
1008: p_count => x_msg_count,
1009: p_data => x_msg_data
1010: );

Line 1026: FND_MSG_PUB.Count_And_Get

1022:
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO enable_results_erecords_GRP;
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: FND_MSG_PUB.Count_And_Get
1027: (
1028: p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );

Line 1044: FND_MSG_PUB.Count_And_Get

1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO enable_results_erecords_GRP;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get
1045: (
1046: p_count => x_msg_count,
1047: p_data => x_msg_data
1048: );

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

1058:
1059: WHEN OTHERS THEN
1060: ROLLBACK TO enable_results_erecords_GRP;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1063: FND_MSG_PUB.Add_Exc_Msg
1064: (
1065: p_pkg_name => g_pkg_name,
1066: p_procedure_name => l_api_name,

Line 1063: FND_MSG_PUB.Add_Exc_Msg

1059: WHEN OTHERS THEN
1060: ROLLBACK TO enable_results_erecords_GRP;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1063: FND_MSG_PUB.Add_Exc_Msg
1064: (
1065: p_pkg_name => g_pkg_name,
1066: p_procedure_name => l_api_name,
1067: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1071: FND_MSG_PUB.Count_And_Get

1067: p_error_text => SUBSTR(SQLERRM,1,240)
1068: );
1069: END IF;
1070:
1071: FND_MSG_PUB.Count_And_Get
1072: (
1073: p_count => x_msg_count,
1074: p_data => x_msg_data
1075: );

Line 1142: FND_MSG_PUB.initialize;

1138: END IF;
1139:
1140: -- Initialize message list if p_init_msg_list is set to TRUE.
1141: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1142: FND_MSG_PUB.initialize;
1143: END IF;
1144:
1145: -- Initialize API return status to success
1146: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1243: FND_MSG_PUB.Count_And_Get

1239: COMMIT WORK;
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (
1245: p_count => x_msg_count,
1246: p_data => x_msg_data
1247: );

Line 1263: FND_MSG_PUB.Count_And_Get

1259:
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO purge_results_erecords_GRP;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: FND_MSG_PUB.Count_And_Get
1264: (
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );

Line 1281: FND_MSG_PUB.Count_And_Get

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

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

1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO purge_results_erecords_GRP;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1300: FND_MSG_PUB.Add_Exc_Msg
1301: (
1302: p_pkg_name => g_pkg_name,
1303: p_procedure_name => l_api_name,

Line 1300: FND_MSG_PUB.Add_Exc_Msg

1296: WHEN OTHERS THEN
1297: ROLLBACK TO purge_results_erecords_GRP;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1300: FND_MSG_PUB.Add_Exc_Msg
1301: (
1302: p_pkg_name => g_pkg_name,
1303: p_procedure_name => l_api_name,
1304: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1308: FND_MSG_PUB.Count_And_Get

1304: p_error_text => SUBSTR(SQLERRM,1,240)
1305: );
1306: END IF;
1307:
1308: FND_MSG_PUB.Count_And_Get
1309: (
1310: p_count => x_msg_count,
1311: p_data => x_msg_data
1312: );