[Home] [Help]
225: FETCH crequest_path INTO x_determined_path;
226: close crequest_path;
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
228: THEN
229: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
230: FND_MESSAGE.Set_Token('ARG1', l_full_name);
231: FND_MSG_PUB.Add;
232: END IF;
233: -- Debug Message
226: close crequest_path;
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
228: THEN
229: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
230: FND_MESSAGE.Set_Token('ARG1', l_full_name);
231: FND_MSG_PUB.Add;
232: END IF;
233: -- Debug Message
234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
231: FND_MSG_PUB.Add;
232: END IF;
233: -- Debug Message
234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
235: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
236: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
237: FND_MSG_PUB.Add;
238: END IF;
239: --Standard call to get message count and if count=1, get the message
232: END IF;
233: -- Debug Message
234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
235: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
236: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
237: FND_MSG_PUB.Add;
238: END IF;
239: --Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
243: p_data => x_msg_data
244: );
245:
246: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
247: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_CANCEL_SUCCESS');
248: FND_MSG_PUB.Add;
249: END IF;
250: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
251: EXCEPTION
346: END IF;
347:
348: -- Debug Message
349: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
350: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
351: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
352: FND_MSG_PUB.Add;
353: END IF;
354:
347:
348: -- Debug Message
349: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
350: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
351: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
352: FND_MSG_PUB.Add;
353: END IF;
354:
355: -- Initialize API return status to success
374:
375: -- Success message
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
377: THEN
378: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
379: FND_MESSAGE.Set_Token('ARG1', l_full_name);
380: FND_MSG_PUB.Add;
381: END IF;
382: --Standard check of commit
375: -- Success message
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
377: THEN
378: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
379: FND_MESSAGE.Set_Token('ARG1', l_full_name);
380: FND_MSG_PUB.Add;
381: END IF;
382: --Standard check of commit
383: IF FND_API.To_Boolean ( p_commit ) THEN
384: COMMIT WORK;
385: END IF;
386: -- Debug Message
387: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
388: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
389: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
390: FND_MSG_PUB.Add;
391: END IF;
392: --Standard call to get message count and if count=1, get the message
385: END IF;
386: -- Debug Message
387: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
388: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
389: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
390: FND_MSG_PUB.Add;
391: END IF;
392: --Standard call to get message count and if count=1, get the message
393: FND_MSG_PUB.Count_And_Get (
396: p_data => x_msg_data
397: );
398:
399: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
400: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_CANCEL_SUCCESS');
401: FND_MSG_PUB.Add;
402: END IF;
403: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
404: EXCEPTION
2347: THEN
2348: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_JOB_NOT_FOUND', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_FILE_ID');
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('JTF', 'JTF_FM_JOB_NOT_FOUND');
2352: FND_MESSAGE.Set_Token('ARG1',p_job_id);
2353: FND_MESSAGE.Set_Token('ARG2',p_request_id);
2354: FND_MSG_PUB.Add;
2355: END IF;
2348: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_JOB_NOT_FOUND', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_FILE_ID');
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('JTF', 'JTF_FM_JOB_NOT_FOUND');
2352: FND_MESSAGE.Set_Token('ARG1',p_job_id);
2353: FND_MESSAGE.Set_Token('ARG2',p_request_id);
2354: FND_MSG_PUB.Add;
2355: END IF;
2356:
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('JTF', 'JTF_FM_JOB_NOT_FOUND');
2352: FND_MESSAGE.Set_Token('ARG1',p_job_id);
2353: FND_MESSAGE.Set_Token('ARG2',p_request_id);
2354: FND_MSG_PUB.Add;
2355: END IF;
2356:
2357: RAISE FND_API.G_EXC_ERROR;
2433: JTF_FM_UTL_V.PRINT_MESSAGE('Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2434:
2435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2436: THEN
2437: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
2438: FND_MSG_PUB.Add;
2439: END IF; -- IF FND_MSG_PUB.check_msg_level
2440:
2441: RAISE FND_API.G_EXC_ERROR;
3280: IF (JTF_FM_UTL_V.CONFIRM_RTF(l_file_id)) THEN -- If RTF
3281: l_Error_Msg := 'Cant send an RTF through Email or Fax';
3282: JTF_FM_UTL_V.PRINT_MESSAGE('Cant send an RTF through Email or Fax' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3284: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_RTF_EMAIL_FAX');
3285: FND_MSG_PUB.Add;
3286: END IF; -- IF FND_MSG_PUB.check_msg_level
3287: RAISE FND_API.G_EXC_ERROR;
3288: ELSIF(JTF_FM_UTL_V.CONFIRM_PDF(l_file_id)) THEN -- IF PDF
3288: ELSIF(JTF_FM_UTL_V.CONFIRM_PDF(l_file_id)) THEN -- IF PDF
3289: l_Error_Msg := 'Cant send a PDF through Email or Fax';
3290: JTF_FM_UTL_V.PRINT_MESSAGE('Cant send a PDF through Email or Fax' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3292: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_PDF_EMAIL_FAX');
3293: FND_MSG_PUB.Add;
3294: END IF; -- IF FND_MSG_PUB.check_msg_level
3295: RAISE FND_API.G_EXC_ERROR;
3296: ELSIF(JTF_FM_UTL_V.CONFIRM_TEXT_HTML(l_file_id)) THEN -- If it is a Text or HTML
3315:
3316: l_Error_Msg := 'The Content Type of the document is not supported';
3317: JTF_FM_UTL_V.PRINT_MESSAGE('The Content Type of the document is not supported' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name );
3318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3319: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_CONTENT_TYPE');
3320: FND_MSG_PUB.Add;
3321: END IF; -- IF FND_MSG_PUB.check_msg_level
3322: RAISE FND_API.G_EXC_ERROR;
3323:
3380: l_Error_Msg := 'The Content Type of the document is not supported';
3381: JTF_FM_UTL_V.PRINT_MESSAGE('The Content Type of the document is not supported' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name );
3382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3383: THEN
3384: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_CONTENT_TYPE');
3385: FND_MSG_PUB.Add;
3386: END IF; -- IF FND_MSG_PUB.check_msg_level
3387: RAISE FND_API.G_EXC_ERROR;
3388:
3619: FND_MSG_PUB.initialize;
3620: END IF;
3621:
3622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3623: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
3624: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
3625: FND_MSG_PUB.Add;
3626: END IF;
3627:
3620: END IF;
3621:
3622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3623: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
3624: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
3625: FND_MSG_PUB.Add;
3626: END IF;
3627:
3628: -- Initialize API return status to success
3633: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
3634:
3635: -- Success message
3636: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3637: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
3638: FND_MESSAGE.Set_Token('ARG1', l_full_name);
3639: FND_MSG_PUB.Add;
3640: END IF;
3641:
3634:
3635: -- Success message
3636: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3637: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
3638: FND_MESSAGE.Set_Token('ARG1', l_full_name);
3639: FND_MSG_PUB.Add;
3640: END IF;
3641:
3642: --Standard check of commit
3646: JTF_FM_UTL_V.PRINT_MESSAGE('End procedure start_request ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3647:
3648: -- Debug Message
3649: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3650: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
3651: FND_MESSAGE.Set_Token('ARG1', l_full_name||': End');
3652: FND_MSG_PUB.Add;
3653: END IF;
3654:
3647:
3648: -- Debug Message
3649: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3650: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
3651: FND_MESSAGE.Set_Token('ARG1', l_full_name||': End');
3652: FND_MSG_PUB.Add;
3653: END IF;
3654:
3655: --Standard call to get message count and if count=1, get the message
3799:
3800: -- Debug Message
3801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3802: THEN
3803: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
3804: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
3805: FND_MSG_PUB.Add;
3806: END IF; -- FND_MSG_PUB.Check_Msg_level
3807:
3800: -- Debug Message
3801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3802: THEN
3803: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
3804: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
3805: FND_MSG_PUB.Add;
3806: END IF; -- FND_MSG_PUB.Check_Msg_level
3807:
3808: -- Initialize API return status to success
3816: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_content_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3817:
3818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3819: THEN
3820: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_ID');
3821: FND_MSG_PUB.Add;
3822: END IF; -- IF FND_MSG_PUB.check_msg_level
3823:
3824: RAISE FND_API.G_EXC_ERROR;
3830: l_Error_Msg := 'Must pass p_media_type parameters';
3831: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_media_type parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3832:
3833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3834: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');
3835: FND_MSG_PUB.Add;
3836: END IF; -- IF FND_MSG_PUB.check_msg_level
3837:
3838: RAISE FND_API.G_EXC_ERROR;
3842: l_Error_Msg := 'Must pass p_content_type parameters';
3843: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_content_type parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3844:
3845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3846: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENTTYPE');
3847: FND_MSG_PUB.Add;
3848: END IF; -- IF FND_MSG_PUB.check_msg_level
3849:
3850: RAISE FND_API.G_EXC_ERROR;
3853: l_Error_Msg := 'Must pass p_request_id parameters';
3854: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_request_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3855:
3856: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3857: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
3858: FND_MSG_PUB.Add;
3859: END IF; -- IF _FND_MSG_PUB.check_msg_level
3860:
3861: RAISE FND_API.G_EXC_ERROR;
3914: JTF_FM_UTL_V.PRINT_MESSAGE('Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3915:
3916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3917: THEN
3918: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
3919: FND_MSG_PUB.Add;
3920: END IF; -- IF FND_MSG_PUB.check_msg_level
3921:
3922: RAISE FND_API.G_EXC_ERROR;
4093:
4094: -- Success message
4095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4096: THEN
4097: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4098: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4099: FND_MSG_PUB.Add;
4100: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4101:
4094: -- Success message
4095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4096: THEN
4097: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4098: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4099: FND_MSG_PUB.Add;
4100: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4101:
4102: --Standard check of commit
4108:
4109: -- Debug Message
4110: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4111: THEN
4112: FND_MESSAGE.Set_Name('FFM','JTF_FM_API_DEBUG_MESSAGE');
4113: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4114: FND_MSG_PUB.Add;
4115: END IF; -- IF FND_MSG_PUB.Check_Msg_level
4116:
4109: -- Debug Message
4110: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4111: THEN
4112: FND_MESSAGE.Set_Name('FFM','JTF_FM_API_DEBUG_MESSAGE');
4113: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4114: FND_MSG_PUB.Add;
4115: END IF; -- IF FND_MSG_PUB.Check_Msg_level
4116:
4117: --Standard call to get message count and if count=1, get the message
4382: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4383:
4384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4385: THEN
4386: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4387: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4388: FND_MSG_PUB.Add;
4389: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4390:
4383:
4384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4385: THEN
4386: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4387: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4388: FND_MSG_PUB.Add;
4389: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4390:
4391: --Standard check of commit
4404:
4405: -- Debug Message
4406: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4407: THEN
4408: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4409: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
4410: FND_MSG_PUB.Add;
4411: END IF; -- IF FND_MSG.PUB.Check_Msg_level
4412:
4405: -- Debug Message
4406: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4407: THEN
4408: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4409: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
4410: FND_MSG_PUB.Add;
4411: END IF; -- IF FND_MSG.PUB.Check_Msg_level
4412:
4413: --Standard call to get message count and if count=1, get the message
4620:
4621: -- Debug Message
4622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4623: THEN
4624: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4625: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
4626: FND_MSG_PUB.Add;
4627: END IF; -- IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4628:
4621: -- Debug Message
4622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4623: THEN
4624: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4625: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
4626: FND_MSG_PUB.Add;
4627: END IF; -- IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4628:
4629: -- Initialize API return status to success
4633: THEN
4634: l_Error_Msg := 'Must pass p_request_id parameter';
4635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4636: THEN
4637: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
4638: FND_MSG_PUB.Add;
4639: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4640: RAISE FND_API.G_EXC_ERROR;
4641: ELSE
4691: THEN
4692: l_Error_Msg := 'Preview has already been submitted';
4693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4694: THEN
4695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_ALREADY_PREVIEWED');
4696: FND_MSG_PUB.Add;
4697: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4698:
4699: RAISE FND_API.G_EXC_ERROR;
4757: COMMIT WORK;
4758: END IF;
4759: -- Debug Message
4760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4761: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4762: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
4763: FND_MSG_PUB.Add;
4764: END IF;
4765: -- Success message
4758: END IF;
4759: -- Debug Message
4760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4761: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4762: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
4763: FND_MSG_PUB.Add;
4764: END IF;
4765: -- Success message
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4764: END IF;
4765: -- Success message
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4767: THEN
4768: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4769: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4770: FND_MSG_PUB.Add;
4771: END IF;
4772:
4765: -- Success message
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4767: THEN
4768: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
4769: FND_MESSAGE.Set_Token('ARG1', l_full_name);
4770: FND_MSG_PUB.Add;
4771: END IF;
4772:
4773: --Standard call to get message count and if count=1, get the message
4777: p_data => x_msg_data
4778: );
4779:
4780: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN
4781: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_PREVIEWED_SUBMITTED');
4782: FND_MSG_PUB.Add;
4783: END IF;
4784:
4785: EXCEPTION
4942: END IF;
4943:
4944: -- Debug Message
4945: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4946: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4947: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
4948: FND_MSG_PUB.Add;
4949: END IF;
4950:
4943:
4944: -- Debug Message
4945: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4946: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
4947: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
4948: FND_MSG_PUB.Add;
4949: END IF;
4950:
4951: -- Initialize API return status to success
4958:
4959: IF (p_request_id IS NULL) THEN
4960: l_Error_Msg := 'Must pass p_request_id parameter';
4961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4962: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
4963: FND_MSG_PUB.Add;
4964: END IF;
4965: RAISE FND_API.G_EXC_ERROR;
4966: ELSE
5181: COMMIT WORK;
5182: END IF;
5183: -- Debug Message
5184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5185: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5186: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
5187: FND_MSG_PUB.Add;
5188: END IF;
5189: -- Success message
5182: END IF;
5183: -- Debug Message
5184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5185: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5186: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
5187: FND_MSG_PUB.Add;
5188: END IF;
5189: -- Success message
5190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5188: END IF;
5189: -- Success message
5190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5191: THEN
5192: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5193: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5194: FND_MSG_PUB.Add;
5195: END IF;
5196: --Standard call to get message count and if count=1, get the message
5189: -- Success message
5190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5191: THEN
5192: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5193: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5194: FND_MSG_PUB.Add;
5195: END IF;
5196: --Standard call to get message count and if count=1, get the message
5197: FND_MSG_PUB.Count_And_Get (
5199: p_count => x_msg_count,
5200: p_data => x_msg_data
5201: );
5202: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN
5203: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_RESUBMIT_SUCCESS');
5204: FND_MSG_PUB.Add;
5205: END IF;
5206: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5207: EXCEPTION
5437:
5438:
5439: -- Debug Message
5440: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5441: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5442: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
5443: FND_MSG_PUB.Add;
5444: END IF;
5445:
5438:
5439: -- Debug Message
5440: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5441: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5442: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
5443: FND_MSG_PUB.Add;
5444: END IF;
5445:
5446: -- Initialize API return status to success
5480:
5481: IF (p_request_id IS NULL) THEN
5482: l_Error_Msg := 'Must pass p_request_id parameter';
5483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5484: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
5485: FND_MSG_PUB.Add;
5486: END IF;
5487: RAISE FND_API.G_EXC_ERROR;
5488: ELSE
5815: END IF;
5816:
5817: -- Debug Message
5818: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5819: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5820: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
5821: FND_MSG_PUB.Add;
5822: END IF;
5823: -- Success message
5816:
5817: -- Debug Message
5818: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5819: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
5820: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
5821: FND_MSG_PUB.Add;
5822: END IF;
5823: -- Success message
5824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5822: END IF;
5823: -- Success message
5824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5825: THEN
5826: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5827: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5828: FND_MSG_PUB.Add;
5829: END IF;
5830: --Standard call to get message count and if count=1, get the message
5823: -- Success message
5824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5825: THEN
5826: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5827: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5828: FND_MSG_PUB.Add;
5829: END IF;
5830: --Standard call to get message count and if count=1, get the message
5831: FND_MSG_PUB.Count_And_Get (
5833: p_count => x_msg_count,
5834: p_data => x_msg_data
5835: );
5836: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN
5837: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_RESUBMIT_SUCCESS');
5838: FND_MSG_PUB.Add;
5839: END IF;
5840: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5841: EXCEPTION
5912: COMMIT WORK;
5913: -- Success message
5914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5915: THEN
5916: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5917: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5918: FND_MSG_PUB.Add;
5919: END IF;
5920:
5913: -- Success message
5914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5915: THEN
5916: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
5917: FND_MESSAGE.Set_Token('ARG1', l_full_name);
5918: FND_MSG_PUB.Add;
5919: END IF;
5920:
5921: EXCEPTION
5980: JTF_FM_UTL_V.PRINT_MESSAGE('The number of JOB IDs must be the same as the list of addrsses ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
5981:
5982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
5983: THEN
5984: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQ_INFO');
5985: FND_MSG_PUB.Add;
5986: END IF; -- IF FND_MSG_PUB.check_msg_level
5987:
5988: RAISE FND_API.G_EXC_ERROR;
6002: END IF;
6003: -- Success message
6004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6005: THEN
6006: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6007: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6008: FND_MSG_PUB.Add;
6009: END IF;
6010: --Standard call to get message count and if count=1, get the message
6003: -- Success message
6004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6005: THEN
6006: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6007: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6008: FND_MSG_PUB.Add;
6009: END IF;
6010: --Standard call to get message count and if count=1, get the message
6011: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
6135: END IF;
6136: -- Success message
6137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6138: THEN
6139: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6140: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6141: FND_MSG_PUB.Add;
6142: END IF;
6143:
6136: -- Success message
6137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6138: THEN
6139: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6140: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6141: FND_MSG_PUB.Add;
6142: END IF;
6143:
6144: --Standard call to get message count and if count=1, get the message
6266: END IF;
6267:
6268: -- Debug Message
6269: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6270: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6271: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6272: FND_MSG_PUB.Add;
6273: END IF;
6274:
6267:
6268: -- Debug Message
6269: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6270: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6271: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6272: FND_MSG_PUB.Add;
6273: END IF;
6274:
6275: -- Initialize API return status to success
6277: JTF_FM_UTL_V.PRINT_MESSAGE('Entering If condition',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6278: IF (p_request_id IS NULL) THEN
6279: l_Error_Msg := 'Must pass p_request_id parameter';
6280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6281: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
6282: FND_MSG_PUB.Add;
6283: END IF;
6284: RAISE FND_API.G_EXC_ERROR;
6285:
6408:
6409: -- Success message
6410: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6411: THEN
6412: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6413: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: --Standard check of commit
6409: -- Success message
6410: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6411: THEN
6412: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6413: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: --Standard check of commit
6417: IF FND_API.To_Boolean ( p_commit ) THEN
6418: COMMIT WORK;
6419: END IF;
6420: -- Debug Message
6421: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6422: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6423: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
6424: FND_MSG_PUB.Add;
6425: END IF;
6426: --Standard call to get message count and if count=1, get the message
6419: END IF;
6420: -- Debug Message
6421: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6422: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6423: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
6424: FND_MSG_PUB.Add;
6425: END IF;
6426: --Standard call to get message count and if count=1, get the message
6427: FND_MSG_PUB.Count_And_Get (
6430: p_data => x_msg_data
6431: );
6432:
6433: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
6434: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_CANCEL_SUCCESS');
6435: FND_MSG_PUB.Add;
6436: END IF;
6437: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6438: EXCEPTION
6442: IF l_count > 0 THEN
6443: l_Error_Msg := 'Successfully cancelled some messages';
6444: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6445: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN
6446: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_CANCEL_SUCCESS');
6447: FND_MSG_PUB.Add;
6448: END IF;
6449: ELSE
6450: l_Error_Msg := 'Message not found in the request queue';
6449: ELSE
6450: l_Error_Msg := 'Message not found in the request queue';
6451: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6452: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
6453: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_CANCEL_FAILED');
6454: FND_MSG_PUB.Add;
6455: END IF;
6456: END IF;
6457: -- Standard call to get message count and if count=1, get the message
6584: END IF;
6585:
6586: -- Debug Message
6587: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6588: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6589: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6590: FND_MSG_PUB.Add;
6591: END IF;
6592:
6585:
6586: -- Debug Message
6587: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6588: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6589: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6590: FND_MSG_PUB.Add;
6591: END IF;
6592:
6593: -- Initialize API return status to success
6595:
6596: IF (p_request_id IS NULL) THEN
6597: l_Error_Msg := 'Must pass p_request_id parameter';
6598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6599: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
6600: FND_MSG_PUB.Add;
6601: END IF;
6602: RAISE FND_API.G_EXC_ERROR;
6603: ELSIF p_content_id.count > p_content_type.count THEN
6602: RAISE FND_API.G_EXC_ERROR;
6603: ELSIF p_content_id.count > p_content_type.count THEN
6604: l_Error_Msg := 'Must specify content_type for all contents passed';
6605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6606: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_ID');
6607: FND_MSG_PUB.Add;
6608: END IF;
6609: RAISE FND_API.G_EXC_ERROR;
6610: ELSIF p_content_id.count > p_media_type.count THEN
6609: RAISE FND_API.G_EXC_ERROR;
6610: ELSIF p_content_id.count > p_media_type.count THEN
6611: l_Error_Msg := 'Must specify media_type for all contents passed';
6612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6613: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');
6614: FND_MSG_PUB.Add;
6615: END IF;
6616: RAISE FND_API.G_EXC_ERROR;
6617: -- ELSIF p_content_id.count > p_document_type.count THEN
6616: RAISE FND_API.G_EXC_ERROR;
6617: -- ELSIF p_content_id.count > p_document_type.count THEN
6618: -- l_Error_Msg := 'Must specify document_type for all contents passed';
6619: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6620: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6621: -- FND_MESSAGE.Set_Token('ARG1','p_document_type');
6622: -- FND_MSG_PUB.Add;
6623: -- END IF;
6624: -- RAISE FND_API.G_EXC_ERROR;
6617: -- ELSIF p_content_id.count > p_document_type.count THEN
6618: -- l_Error_Msg := 'Must specify document_type for all contents passed';
6619: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6620: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6621: -- FND_MESSAGE.Set_Token('ARG1','p_document_type');
6622: -- FND_MSG_PUB.Add;
6623: -- END IF;
6624: -- RAISE FND_API.G_EXC_ERROR;
6625: -- ELSIF p_content_id.count > p_content_nm.count THEN
6624: -- RAISE FND_API.G_EXC_ERROR;
6625: -- ELSIF p_content_id.count > p_content_nm.count THEN
6626: -- l_Error_Msg := 'Must specify content_name for all contents passed';
6627: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6628: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6629: -- FND_MESSAGE.Set_Token('ARG1','p_content_nm');
6630: -- FND_MSG_PUB.Add;
6631: -- END IF;
6632: -- RAISE FND_API.G_EXC_ERROR;
6625: -- ELSIF p_content_id.count > p_content_nm.count THEN
6626: -- l_Error_Msg := 'Must specify content_name for all contents passed';
6627: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6628: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6629: -- FND_MESSAGE.Set_Token('ARG1','p_content_nm');
6630: -- FND_MSG_PUB.Add;
6631: -- END IF;
6632: -- RAISE FND_API.G_EXC_ERROR;
6633: ELSE
6682: -- Check if atleast one valid media type has been specified
6683: IF (l_temp = 0) THEN
6684: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER ';
6685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6686: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
6687: FND_MESSAGE.Set_Token('ARG1', p_media_type(i));
6688: FND_MESSAGE.Set_Token('ARG2', p_content_id(i));
6689: FND_MSG_PUB.Add;
6690: END IF;
6683: IF (l_temp = 0) THEN
6684: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER ';
6685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6686: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
6687: FND_MESSAGE.Set_Token('ARG1', p_media_type(i));
6688: FND_MESSAGE.Set_Token('ARG2', p_content_id(i));
6689: FND_MSG_PUB.Add;
6690: END IF;
6691: RAISE FND_API.G_EXC_ERROR;
6684: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER ';
6685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6686: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
6687: FND_MESSAGE.Set_Token('ARG1', p_media_type(i));
6688: FND_MESSAGE.Set_Token('ARG2', p_content_id(i));
6689: FND_MSG_PUB.Add;
6690: END IF;
6691: RAISE FND_API.G_EXC_ERROR;
6692: ELSIF l_temp > 1 THEN
6691: RAISE FND_API.G_EXC_ERROR;
6692: ELSIF l_temp > 1 THEN
6693: l_Error_Msg := 'Only one of the media_types EMAIL, FAX, PRINTER can be sent per request';
6694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MULTIPLE_MEDIATYPE');
6696: FND_MESSAGE.Set_Token('ARG1', to_char(p_content_id(i)));
6697: FND_MSG_PUB.Add;
6698: END IF;
6699: RAISE FND_API.G_EXC_ERROR;
6692: ELSIF l_temp > 1 THEN
6693: l_Error_Msg := 'Only one of the media_types EMAIL, FAX, PRINTER can be sent per request';
6694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MULTIPLE_MEDIATYPE');
6696: FND_MESSAGE.Set_Token('ARG1', to_char(p_content_id(i)));
6697: FND_MSG_PUB.Add;
6698: END IF;
6699: RAISE FND_API.G_EXC_ERROR;
6700: ELSE
6744:
6745: -- Success message
6746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6747: THEN
6748: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6749: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6750: FND_MSG_PUB.Add;
6751: END IF;
6752: --Standard check of commit
6745: -- Success message
6746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6747: THEN
6748: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
6749: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6750: FND_MSG_PUB.Add;
6751: END IF;
6752: --Standard check of commit
6753: IF FND_API.To_Boolean ( p_commit ) THEN
6754: COMMIT WORK;
6755: END IF;
6756: -- Debug Message
6757: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6758: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6759: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
6760: FND_MSG_PUB.Add;
6761: END IF;
6762: --Standard call to get message count and if count=1, get the message
6755: END IF;
6756: -- Debug Message
6757: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6758: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6759: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
6760: FND_MSG_PUB.Add;
6761: END IF;
6762: --Standard call to get message count and if count=1, get the message
6763: FND_MSG_PUB.Count_And_Get (
6888: END IF;
6889:
6890: -- Debug Message
6891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6892: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6893: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6894: FND_MSG_PUB.Add;
6895: END IF;
6896:
6889:
6890: -- Debug Message
6891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6892: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
6893: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
6894: FND_MSG_PUB.Add;
6895: END IF;
6896:
6897: -- Initialize API return status to success
6899:
6900: IF (p_list_type IS NULL) THEN
6901: l_Error_Msg := 'Must pass p_list_type parameter';
6902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6903: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_LIST_TYPE');
6904: FND_MSG_PUB.Add;
6905: END IF;
6906: RAISE FND_API.G_EXC_ERROR;
6907: ELSIF (p_content_xml IS NULL) THEN
6906: RAISE FND_API.G_EXC_ERROR;
6907: ELSIF (p_content_xml IS NULL) THEN
6908: l_Error_Msg := 'Must pass p_content_xml parameter';
6909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6910: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
6911: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
6912: FND_MSG_PUB.Add;
6913: END IF;
6914: RAISE FND_API.G_EXC_ERROR;
6907: ELSIF (p_content_xml IS NULL) THEN
6908: l_Error_Msg := 'Must pass p_content_xml parameter';
6909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6910: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
6911: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
6912: FND_MSG_PUB.Add;
6913: END IF;
6914: RAISE FND_API.G_EXC_ERROR;
6915: END IF;
6920: IF (upper(p_list_type) = 'VIEW') THEN
6921: IF (p_view_nm IS NULL) THEN
6922: l_Error_Msg := 'Must pass p_view_name parameter';
6923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6924: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_VIEW_NAME');
6925: FND_MSG_PUB.Add;
6926: END IF;
6927: RAISE FND_API.G_EXC_ERROR;
6928: ELSE
6957:
6958: IF (l_index = 0) THEN
6959: l_Error_Msg := 'Must pass batch address list';
6960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6961: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_BATCH_LIST');
6962: FND_MSG_PUB.Add;
6963: END IF;
6964: RAISE FND_API.G_EXC_ERROR;
6965: ELSE
7044:
7045: -- Success message
7046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7047: THEN
7048: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7049: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7050: FND_MSG_PUB.Add;
7051: END IF;
7052: --Standard check of commit
7045: -- Success message
7046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7047: THEN
7048: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7049: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7050: FND_MSG_PUB.Add;
7051: END IF;
7052: --Standard check of commit
7053: IF FND_API.To_Boolean ( p_commit ) THEN
7054: COMMIT WORK;
7055: END IF;
7056: -- Debug Message
7057: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7058: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7059: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
7060: FND_MSG_PUB.Add;
7061: END IF;
7062: --Standard call to get message count and if count=1, get the message
7055: END IF;
7056: -- Debug Message
7057: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7058: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7059: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
7060: FND_MSG_PUB.Add;
7061: END IF;
7062: --Standard call to get message count and if count=1, get the message
7063: FND_MSG_PUB.Count_And_Get (
7203: END IF;
7204:
7205: -- Debug Message
7206: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7207: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7208: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
7209: FND_MSG_PUB.Add;
7210: END IF;
7211:
7204:
7205: -- Debug Message
7206: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7207: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7208: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
7209: FND_MSG_PUB.Add;
7210: END IF;
7211:
7212: -- Initialize API return status to success
7215: IF (p_content_xml IS NULL) THEN
7216: l_Error_Msg := 'Must pass p_content_xml parameter';
7217:
7218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7219: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
7220: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
7221: FND_MSG_PUB.Add;
7222: END IF;
7223: RAISE FND_API.G_EXC_ERROR;
7216: l_Error_Msg := 'Must pass p_content_xml parameter';
7217:
7218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7219: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
7220: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
7221: FND_MSG_PUB.Add;
7222: END IF;
7223: RAISE FND_API.G_EXC_ERROR;
7224:
7278:
7279: -- Success message
7280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7281: THEN
7282: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7283: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7284: FND_MSG_PUB.Add;
7285: END IF;
7286: --Standard check of commit
7279: -- Success message
7280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7281: THEN
7282: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7283: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7284: FND_MSG_PUB.Add;
7285: END IF;
7286: --Standard check of commit
7287: IF FND_API.To_Boolean ( p_commit ) THEN
7288: COMMIT WORK;
7289: END IF;
7290: -- Debug Message
7291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7292: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7293: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
7294: FND_MSG_PUB.Add;
7295: END IF;
7296: --Standard call to get message count and if count=1, get the message
7289: END IF;
7290: -- Debug Message
7291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7292: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
7293: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
7294: FND_MSG_PUB.Add;
7295: END IF;
7296: --Standard call to get message count and if count=1, get the message
7297: FND_MSG_PUB.Count_And_Get (
7582:
7583: -- Success message
7584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7585: THEN
7586: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7587: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7588: FND_MSG_PUB.Add;
7589: END IF;
7590: --JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_SUCCESS_MESSAGE', l_full_name);
7583: -- Success message
7584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7585: THEN
7586: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
7587: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7588: FND_MSG_PUB.Add;
7589: END IF;
7590: --JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_SUCCESS_MESSAGE', l_full_name);
7591: --Standard check of commit
7602: );
7603:
7604: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success)
7605: THEN
7606: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_PAUSE_RESUME_SUCCES');
7607: FND_MSG_PUB.Add;
7608: END IF;
7609: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7610: EXCEPTION