DBA Data[Home] [Help]

APPS.IES_SVY_DEPLOYMENT_PVT dependencies on FND_MESSAGE

Line 391: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');

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;
395:

Line 392: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');

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;
395:
396: -- Initialize API return status to success

Line 406: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');

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;
410: RAISE FND_API.G_EXC_ERROR;

Line 421: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');

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;
425: RAISE FND_API.G_EXC_ERROR;

Line 520: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');

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;
524: x_message := l_Error_Msg;

Line 521: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));

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;
524: x_message := l_Error_Msg;
525: RAISE FND_API.G_EXC_ERROR;

Line 557: FND_MESSAGE.Set_Name('IES','IES_SVY_SUCCESS_REMINDER');

553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556:
557: FND_MESSAGE.Set_Name('IES','IES_SVY_SUCCESS_REMINDER');
558: x_message := FND_MESSAGE.Get();
559: x_message := x_message || TO_CHAR(l_request_id);
560:
561:

Line 558: x_message := FND_MESSAGE.Get();

554: END IF;
555:
556:
557: FND_MESSAGE.Set_Name('IES','IES_SVY_SUCCESS_REMINDER');
558: x_message := FND_MESSAGE.Get();
559: x_message := x_message || TO_CHAR(l_request_id);
560:
561:
562: --get the survey_list_entry_id to be inserted into ies_svy_entrs_remind_hst

Line 790: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');

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;
794:

Line 791: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');

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;
794:
795: -- Initialize API return status to success

Line 800: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_DEPLOYMENT_ID');

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;
804: RAISE FND_API.G_EXC_ERROR;

Line 810: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_TEMPLATE_ID');

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;
814: RAISE FND_API.G_EXC_ERROR;

Line 829: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');

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;
833: RAISE FND_API.G_EXC_ERROR;

Line 920: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');

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;
924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';

Line 921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));

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;
924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
925: RAISE FND_API.G_EXC_ERROR;

Line 1173: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');

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;
1177: -- Initialize API return status to success

Line 1174: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');

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;
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1183: FND_MESSAGE.set_name('IES', 'IES__SVY_API_MISSING_DEPLOYMENT_ID');

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;
1187: RAISE FND_API.G_EXC_ERROR;

Line 1199: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');

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;
1203: RAISE FND_API.G_EXC_ERROR;

Line 1215: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');

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;
1219: RAISE FND_API.G_EXC_ERROR;