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

Line 135: FND_MSG_PUB.initialize;

131: END IF;
132:
133: --Initialize message list if p_init_msg_list is TRUE.
134: IF FND_API.To_Boolean (p_init_msg_list) THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:
138: -- Initialize API return status to success
139:

Line 266: FND_MSG_PUB.Count_And_Get

262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO Submit_Deployment;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: x_message := SQLERRM;
266: FND_MSG_PUB.Count_And_Get
267: ( p_count => x_msg_count,
268: p_data => x_msg_data
269: );
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 274: FND_MSG_PUB.Count_And_Get

270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ROLLBACK TO Submit_Deployment;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: x_message := SQLERRM;
274: FND_MSG_PUB.Count_And_Get
275: ( p_count => x_msg_count ,
276: p_data => x_msg_data
277: );
278: WHEN OTHERS THEN

Line 282: FND_MSG_PUB.Count_And_Get

278: WHEN OTHERS THEN
279: rollback to Submit_Deployment;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: x_message := SQLERRM;
282: FND_MSG_PUB.Count_And_Get
283: (p_count => x_msg_count ,
284: p_data => x_msg_data
285: );
286: End Submit_Deployment;

Line 386: FND_MSG_PUB.initialize;

382: END IF;
383:
384: --Initialize message list if p_init_msg_list is TRUE.
385: IF FND_API.To_Boolean (p_init_msg_list) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: -- Debug Message
390: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 390: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: -- Debug Message
390: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
391: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
392: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
393: FND_MSG_PUB.Add;
394: END IF;

Line 393: FND_MSG_PUB.Add;

389: -- Debug Message
390: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
391: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
392: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
393: FND_MSG_PUB.Add;
394: END IF;
395:
396: -- Initialize API return status to success
397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

401: FETCH CEMAILADD into l_email;
402: IF (CEMAILADD%NOTFOUND) THEN
403: CLOSE CEMAILADD;
404: l_Error_Msg := 'No e-mail address for this p_list_entry_id';
405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
406: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
407: FND_MSG_PUB.Add;
408: END IF;
409: x_message := l_Error_Msg;

Line 407: FND_MSG_PUB.Add;

403: CLOSE CEMAILADD;
404: l_Error_Msg := 'No e-mail address for this p_list_entry_id';
405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
406: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
407: FND_MSG_PUB.Add;
408: END IF;
409: x_message := l_Error_Msg;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;

Line 420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

416: FETCH CEMAILSUBJECTHEADING into l_subject;
417: IF (CEMAILSUBJECTHEADING%NOTFOUND) THEN
418: CLOSE CEMAILSUBJECTHEADING;
419: l_Error_Msg := 'No e-mail subject heading for this p_deployment_id';
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
421: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_message := l_Error_Msg;

Line 422: FND_MSG_PUB.Add;

418: CLOSE CEMAILSUBJECTHEADING;
419: l_Error_Msg := 'No e-mail subject heading for this p_deployment_id';
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
421: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_message := l_Error_Msg;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;

Line 519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

515: END LOOP;
516:
517: IF(CCONTENT%NOTFOUND) AND ( v_count = 0)THEN
518: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
520: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
521: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
522: FND_MSG_PUB.Add;
523: END IF;

Line 522: FND_MSG_PUB.Add;

518: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
520: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
521: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
522: FND_MSG_PUB.Add;
523: END IF;
524: x_message := l_Error_Msg;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;

Line 606: l_msg_data :=FND_MSG_PUB.Get(

602: -- write the error msg to log, if conc request is executing this code then
603: -- the log is viewable in concurrent manger log for that specific request
604: if(l_msg_count is not null) then
605: for l_index IN 1..l_msg_count loop
606: l_msg_data :=FND_MSG_PUB.Get(
607: p_msg_index => l_index,
608: p_encoded => FND_API.G_FALSE);
609: x_msg_data := l_msg_data;
610: end loop;

Line 628: l_msg_data :=FND_MSG_PUB.Get(

624: -- write the error msg to log, if conc request is executing this code then
625: -- the log is viewable in concurrent manger log for that specific request
626: if(l_msg_count is not null) then
627: for l_index IN 1..l_msg_count loop
628: l_msg_data :=FND_MSG_PUB.Get(
629: p_msg_index => l_index,
630: p_encoded => FND_API.G_FALSE);
631: x_msg_data := l_msg_data;
632: end loop;

Line 652: l_msg_data :=FND_MSG_PUB.Get(

648: -- write the error msg to log, if conc request is executing this code then
649: -- the log is viewable in concurrent manger log for that specific request
650: if(l_msg_count is not null) then
651: for l_index IN 1..l_msg_count loop
652: l_msg_data :=FND_MSG_PUB.Get(
653: p_msg_index => l_index,
654: p_encoded => FND_API.G_FALSE);
655: x_msg_data := l_msg_data;
656: end loop;

Line 785: FND_MSG_PUB.initialize;

781: END IF;
782:
783: --Initialize message list if p_init_msg_list is TRUE.
784: IF FND_API.To_Boolean (p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Debug Message
789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Debug Message
789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
790: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
791: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
792: FND_MSG_PUB.Add;
793: END IF;

Line 792: FND_MSG_PUB.Add;

788: -- Debug Message
789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
790: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
791: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
792: FND_MSG_PUB.Add;
793: END IF;
794:
795: -- Initialize API return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

795: -- Initialize API return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: IF (p_deployment_id IS NULL) THEN
798: l_Error_Msg := 'Must pass p_deployment_id parameter';
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_DEPLOYMENT_ID');
801: FND_MSG_PUB.Add;
802: END IF;
803: x_message := l_Error_Msg;

Line 801: FND_MSG_PUB.Add;

797: IF (p_deployment_id IS NULL) THEN
798: l_Error_Msg := 'Must pass p_deployment_id parameter';
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_DEPLOYMENT_ID');
801: FND_MSG_PUB.Add;
802: END IF;
803: x_message := l_Error_Msg;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;

Line 809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

805: END IF;
806:
807: IF (p_template_id IS NULL) THEN
808: l_Error_Msg := 'Must pass p_template_id parameter';
809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
810: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_TEMPLATE_ID');
811: FND_MSG_PUB.Add;
812: END IF;
813: x_message := l_Error_Msg;

Line 811: FND_MSG_PUB.Add;

807: IF (p_template_id IS NULL) THEN
808: l_Error_Msg := 'Must pass p_template_id parameter';
809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
810: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_TEMPLATE_ID');
811: FND_MSG_PUB.Add;
812: END IF;
813: x_message := l_Error_Msg;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;

Line 828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

824: FETCH CEMAILSUBJECTHEADING into l_subject;
825: IF (CEMAILSUBJECTHEADING%NOTFOUND) THEN
826: CLOSE CEMAILSUBJECTHEADING;
827: l_Error_Msg := 'No e-mail subject heading for this p_deployment_id';
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
830: FND_MSG_PUB.Add;
831: END IF;
832: x_message := l_Error_Msg;

Line 830: FND_MSG_PUB.Add;

826: CLOSE CEMAILSUBJECTHEADING;
827: l_Error_Msg := 'No e-mail subject heading for this p_deployment_id';
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
830: FND_MSG_PUB.Add;
831: END IF;
832: x_message := l_Error_Msg;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;

Line 919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

915: END LOOP;
916:
917: IF(CCONTENT%NOTFOUND) AND ( v_count = 0)THEN
918: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
922: FND_MSG_PUB.Add;
923: END IF;

Line 922: FND_MSG_PUB.Add;

918: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
922: FND_MSG_PUB.Add;
923: END IF;
924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;

Line 1016: l_msg_data :=FND_MSG_PUB.Get(

1012: -- write the error msg to log, if conc request is executing this code then
1013: -- the log is viewable in concurrent manger log for that specific request
1014: if(l_msg_count is not null) then
1015: for l_index IN 1..l_msg_count loop
1016: l_msg_data :=FND_MSG_PUB.Get(
1017: p_msg_index => l_index,
1018: p_encoded => FND_API.G_FALSE);
1019: x_msg_data := l_msg_data;
1020: fnd_file.put_line(fnd_file.log, l_msg_data);

Line 1024: FND_MSG_PUB.Count_And_Get

1020: fnd_file.put_line(fnd_file.log, l_msg_data);
1021: end loop;
1022: end if;
1023: fnd_file.put_line(fnd_file.log, SQLERRM);
1024: FND_MSG_PUB.Count_And_Get
1025: (p_count => x_msg_count ,
1026: p_data => x_msg_data
1027: );
1028: JTF_FM_REQUEST_GRP.Cancel_Request

Line 1049: l_msg_data :=FND_MSG_PUB.Get(

1045: -- write the error msg to log, if conc request is executing this code then
1046: -- the log is viewable in concurrent manger log for that specific request
1047: if(l_msg_count is not null) then
1048: for l_index IN 1..l_msg_count loop
1049: l_msg_data :=FND_MSG_PUB.Get(
1050: p_msg_index => l_index,
1051: p_encoded => FND_API.G_FALSE);
1052: x_msg_data := l_msg_data;
1053: fnd_file.put_line(fnd_file.log, l_msg_data);

Line 1079: l_msg_data :=FND_MSG_PUB.Get(

1075: -- write the error msg to log, if conc request is executing this code then
1076: -- the log is viewable in concurrent manger log for that specific request
1077: if(l_msg_count is not null) then
1078: for l_index IN 1..l_msg_count loop
1079: l_msg_data :=FND_MSG_PUB.Get(
1080: p_msg_index => l_index,
1081: p_encoded => FND_API.G_FALSE);
1082: x_msg_data := l_msg_data;
1083: fnd_file.put_line(fnd_file.log, l_msg_data);

Line 1169: FND_MSG_PUB.initialize;

1165: END IF;
1166:
1167: --Initialize message list if p_init_msg_list is TRUE.
1168: IF FND_API.To_Boolean (p_init_msg_list) THEN
1169: FND_MSG_PUB.initialize;
1170: END IF;
1171: -- Debug Message
1172: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1173: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');

Line 1172: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1168: IF FND_API.To_Boolean (p_init_msg_list) THEN
1169: FND_MSG_PUB.initialize;
1170: END IF;
1171: -- Debug Message
1172: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1173: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1174: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1175: FND_MSG_PUB.Add;
1176: END IF;

Line 1175: FND_MSG_PUB.Add;

1171: -- Debug Message
1172: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1173: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1174: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1175: FND_MSG_PUB.Add;
1176: END IF;
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179:

Line 1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: IF (p_survey_deployment_id IS NULL) THEN
1181: l_Error_Msg := 'Must pass p_survey_deployment_id parameter';
1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1183: FND_MESSAGE.set_name('IES', 'IES__SVY_API_MISSING_DEPLOYMENT_ID');
1184: FND_MSG_PUB.Add;
1185: END IF;
1186: x_message := l_Error_Msg;

Line 1184: FND_MSG_PUB.Add;

1180: IF (p_survey_deployment_id IS NULL) THEN
1181: l_Error_Msg := 'Must pass p_survey_deployment_id parameter';
1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1183: FND_MESSAGE.set_name('IES', 'IES__SVY_API_MISSING_DEPLOYMENT_ID');
1184: FND_MSG_PUB.Add;
1185: END IF;
1186: x_message := l_Error_Msg;
1187: RAISE FND_API.G_EXC_ERROR;
1188: END IF;

Line 1198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1194:
1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN
1197: l_Error_Msg := 'Deployment doesn''t have list_header_id';
1198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1199: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: x_message := l_Error_Msg;

Line 1200: FND_MSG_PUB.Add;

1196: WHEN NO_DATA_FOUND THEN
1197: l_Error_Msg := 'Deployment doesn''t have list_header_id';
1198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1199: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: x_message := l_Error_Msg;
1203: RAISE FND_API.G_EXC_ERROR;
1204: END;

Line 1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1210:
1211: EXCEPTION
1212: WHEN NO_DATA_FOUND THEN
1213: l_Error_Msg := 'AMS_LIST_ENTRIES doesn''t have list_header_id';
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1215: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1216: FND_MSG_PUB.Add;
1217: END IF;
1218: x_message := l_Error_Msg;

Line 1216: FND_MSG_PUB.Add;

1212: WHEN NO_DATA_FOUND THEN
1213: l_Error_Msg := 'AMS_LIST_ENTRIES doesn''t have list_header_id';
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1215: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1216: FND_MSG_PUB.Add;
1217: END IF;
1218: x_message := l_Error_Msg;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END;

Line 1292: FND_MSG_PUB.Count_And_Get

1288: ROLLBACK TO Populate_Survey_List_Entries;
1289: x_return_status := FND_API.G_RET_STS_ERROR ;
1290: --vacharya: Commented out until the message 'IES_SVY_EMPTY_AMS_LIST' is inserted in the FND_NEW_MESSAGES table
1291: x_message := x_message || SQLERRM;
1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,
1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1300: FND_MSG_PUB.Count_And_Get

1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Populate_Survey_List_Entries;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1299: x_message := x_message || SQLERRM;
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count ,
1302: p_data => x_msg_data
1303: );
1304: WHEN OTHERS THEN

Line 1309: FND_MSG_PUB.Count_And_Get

1305: rollback to Populate_Survey_List_Entries;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: x_message := x_message || SQLERRM;
1308:
1309: FND_MSG_PUB.Count_And_Get
1310: ( p_count => x_msg_count ,
1311: p_data => x_msg_data
1312: );
1313: