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_FM_REQUEST_GRP dependencies on FND_MSG_PUB

Line 227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

223:
224: OPEN crequest_path;
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;

Line 231: FND_MSG_PUB.Add;

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
235: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');

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

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

Line 237: FND_MSG_PUB.Add;

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 (
241: p_encoded => FND_API.g_false,

Line 240: FND_MSG_PUB.Count_And_Get (

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 (
241: p_encoded => FND_API.g_false,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );

Line 246: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

242: p_count => x_msg_count,
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);

Line 248: FND_MSG_PUB.Add;

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
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 256: FND_MSG_PUB.Count_And_Get (

252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.g_false,
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );

Line 266: FND_MSG_PUB.Count_And_Get (

262: WHEN FND_API.G_EXC_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.g_false,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );

Line 276: IF FND_MSG_PUB.Check_Msg_Level

272: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
273: WHEN OTHERS THEN
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
276: IF FND_MSG_PUB.Check_Msg_Level
277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME, l_api_name);

Line 277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

273: WHEN OTHERS THEN
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
276: IF FND_MSG_PUB.Check_Msg_Level
277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME, l_api_name);
281: END IF;

Line 279: FND_MSG_PUB.Add_Exc_Msg

275: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
276: IF FND_MSG_PUB.Check_Msg_Level
277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME, l_api_name);
281: END IF;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (

Line 283: FND_MSG_PUB.Count_And_Get (

279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME, l_api_name);
281: END IF;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );

Line 345: FND_MSG_PUB.initialize;

341: END IF;
342:
343: --Initialize message list if p_init_msg_list is TRUE.
344: IF FND_API.To_Boolean (p_init_msg_list) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Debug Message
349: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

345: FND_MSG_PUB.initialize;
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;

Line 352: FND_MSG_PUB.Add;

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
356: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

372: where REQUEST_ID = p_request_id ;
373: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
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;

Line 380: FND_MSG_PUB.Add;

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;

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

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;

Line 390: FND_MSG_PUB.Add;

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 (
394: p_encoded => FND_API.g_false,

Line 393: FND_MSG_PUB.Count_And_Get (

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 (
394: p_encoded => FND_API.g_false,
395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );

Line 399: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

395: p_count => x_msg_count,
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);

Line 401: FND_MSG_PUB.Add;

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
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 410: FND_MSG_PUB.Count_And_Get (

406: ROLLBACK TO new_cancel;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
409: -- Standard call to get message count and if count=1, get the message
410: FND_MSG_PUB.Count_And_Get (
411: p_encoded => FND_API.g_false,
412: p_count => x_msg_count,
413: p_data => x_msg_data
414: );

Line 421: FND_MSG_PUB.Count_And_Get (

417: ROLLBACK TO new_cancel;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
420: -- Standard call to get message count and if count=1, get the message
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.g_false,
423: p_count => x_msg_count,
424: p_data => x_msg_data
425: );

Line 432: IF FND_MSG_PUB.Check_Msg_Level

428: WHEN OTHERS THEN
429: ROLLBACK TO new_cancel;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
432: IF FND_MSG_PUB.Check_Msg_Level
433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg
436: (G_PKG_NAME, l_api_name);

Line 433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

429: ROLLBACK TO new_cancel;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
432: IF FND_MSG_PUB.Check_Msg_Level
433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg
436: (G_PKG_NAME, l_api_name);
437: END IF;

Line 435: FND_MSG_PUB.Add_Exc_Msg

431: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
432: IF FND_MSG_PUB.Check_Msg_Level
433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg
436: (G_PKG_NAME, l_api_name);
437: END IF;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (

Line 439: FND_MSG_PUB.Count_And_Get (

435: FND_MSG_PUB.Add_Exc_Msg
436: (G_PKG_NAME, l_api_name);
437: END IF;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );

Line 2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2345: EXCEPTION
2346: WHEN NO_DATA_FOUND
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);

Line 2354: FND_MSG_PUB.Add;

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;
2358: END;

Line 2435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2431: THEN
2432: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER';
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

Line 2438: FND_MSG_PUB.Add;

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

Line 2439: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
2442:
2443: END IF; -- IF (l_temp = 0)

Line 3067: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3063:
3064: x_citem_name := NULL;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: -- Standard call to get message count and if count=1, get the message
3067: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3068: p_count => x_msg_count,
3069: p_data => x_msg_data
3070: );
3071: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3080: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3076: x_citem_name := NULL;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: -- Standard call to get message count and if count=1, get the message
3080: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3081: p_count => x_msg_count,
3082: p_data => x_msg_data
3083: );
3084: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3089: x_citem_name := NULL;
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN
3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:

Line 3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );

3091: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN
3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN
3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3100: p_count => x_msg_count,

Line 3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3100: p_count => x_msg_count,
3101: p_data => x_msg_data
3102: );
3103: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3106: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

3102: );
3103: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3104:
3105: for i in 0..x_msg_count loop
3106: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
3107:
3108: end loop;
3109:
3110:

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

3279: IF ((INSTR(UPPER(p_media_type), 'E') > 0) OR (INSTR(UPPER(p_media_type), 'F') > 0)) THEN-- If Email or Fax
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;

Line 3285: FND_MSG_PUB.Add;

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
3289: l_Error_Msg := 'Cant send a PDF through Email or Fax';

Line 3286: END IF; -- IF FND_MSG_PUB.check_msg_level

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
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);

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

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

Line 3293: FND_MSG_PUB.Add;

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
3297: x_html := x_html ||'

Line 3294: END IF; -- IF FND_MSG_PUB.check_msg_level

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
3297: x_html := x_html ||' 3298: l_count_total := l_count_total +1;

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

3314: ELSE -- Some other Content Type
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;

Line 3320: FND_MSG_PUB.Add;

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:
3324: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML

Line 3321: END IF; -- IF FND_MSG_PUB.check_msg_level

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:
3324: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML
3325:

Line 3382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3378: ELSE -- If the File is of some other format
3379:
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

Line 3385: FND_MSG_PUB.Add;

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:
3389: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML

Line 3386: END IF; -- IF FND_MSG_PUB.check_msg_level

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:
3389: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML
3390: END IF; -- EMAIL, PRINTER, FAX

Line 3533: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3529: x_citem_name := NULL;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3531: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3532: -- Standard call to get message count and if count=1, get the message
3533: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3534: p_count => x_msg_count,
3535: p_data => x_msg_data
3536: );
3537: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3545: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3541: x_citem_name := NULL;
3542: x_return_status := FND_API.G_RET_STS_ERROR;
3543: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3544: -- Standard call to get message count and if count=1, get the message
3545: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3546: p_count => x_msg_count,
3547: p_data => x_msg_data
3548: );
3549: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3554: x_citem_name := NULL;
3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: JTF_FM_UTL_V.PRINT_MESSAGE(SQLERRM ,JTF_FM_UTL_V.G_LEVEL_ERROR ,l_full_name);
3557:
3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3559: THEN
3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:

Line 3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);

3556: JTF_FM_UTL_V.PRINT_MESSAGE(SQLERRM ,JTF_FM_UTL_V.G_LEVEL_ERROR ,l_full_name);
3557:
3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3559: THEN
3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:
3563: -- Standard call to get message count and if count=1, get the message
3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

3557:
3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3559: THEN
3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:
3563: -- Standard call to get message count and if count=1, get the message
3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3565: p_count => x_msg_count,

Line 3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:
3563: -- Standard call to get message count and if count=1, get the message
3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3565: p_count => x_msg_count,
3566: p_data => x_msg_data
3567: );
3568: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3619: FND_MSG_PUB.initialize;

3615: END IF;
3616:
3617: --Initialize message list if p_init_msg_list is TRUE.
3618: IF FND_API.To_Boolean (p_init_msg_list) THEN
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');

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

3618: IF FND_API.To_Boolean (p_init_msg_list) THEN
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;

Line 3625: FND_MSG_PUB.Add;

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
3629: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3636: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

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

Line 3639: FND_MSG_PUB.Add;

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
3643: IF FND_API.To_Boolean ( p_commit ) THEN

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

3645: END IF;
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;

Line 3652: FND_MSG_PUB.Add;

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
3656: FND_MSG_PUB.count_and_get(

Line 3656: FND_MSG_PUB.count_and_get(

3652: FND_MSG_PUB.Add;
3653: END IF;
3654:
3655: --Standard call to get message count and if count=1, get the message
3656: FND_MSG_PUB.count_and_get(
3657: p_encoded => FND_API.g_false,
3658: p_count => x_msg_count,
3659: p_data => x_msg_data
3660: );

Line 3667: FND_MSG_PUB.count_and_get(

3663: ROLLBACK TO Start_Request;
3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3666: -- Standard call to get message count and if count=1, get the message
3667: FND_MSG_PUB.count_and_get(
3668: p_encoded => FND_API.g_false,
3669: p_count => x_msg_count,
3670: p_data => x_msg_data
3671: );

Line 3678: FND_MSG_PUB.count_and_get(

3674: ROLLBACK TO Start_Request;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3677: -- Standard call to get message count and if count=1, get the message
3678: FND_MSG_PUB.count_and_get(
3679: p_encoded => FND_API.g_false,
3680: p_count => x_msg_count,
3681: p_data => x_msg_data
3682: );

Line 3688: IF FND_MSG_PUB.Check_Msg_Level

3684: WHEN OTHERS THEN
3685: ROLLBACK TO Start_Request;
3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3687: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3688: IF FND_MSG_PUB.Check_Msg_Level
3689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN
3691: FND_MSG_PUB.Add_Exc_Msg
3692: (G_PKG_NAME, l_api_name);

Line 3689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3685: ROLLBACK TO Start_Request;
3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3687: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3688: IF FND_MSG_PUB.Check_Msg_Level
3689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN
3691: FND_MSG_PUB.Add_Exc_Msg
3692: (G_PKG_NAME, l_api_name);
3693: END IF;

Line 3691: FND_MSG_PUB.Add_Exc_Msg

3687: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3688: IF FND_MSG_PUB.Check_Msg_Level
3689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN
3691: FND_MSG_PUB.Add_Exc_Msg
3692: (G_PKG_NAME, l_api_name);
3693: END IF;
3694: -- Standard call to get message count and if count=1, get the message
3695: FND_MSG_PUB.count_and_get(

Line 3695: FND_MSG_PUB.count_and_get(

3691: FND_MSG_PUB.Add_Exc_Msg
3692: (G_PKG_NAME, l_api_name);
3693: END IF;
3694: -- Standard call to get message count and if count=1, get the message
3695: FND_MSG_PUB.count_and_get(
3696: p_encoded => FND_API.g_false,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data
3699: );

Line 3797: FND_MSG_PUB.initialize;

3793:
3794: --Initialize message list if p_init_msg_list is TRUE.
3795: IF FND_API.To_Boolean (p_init_msg_list)
3796: THEN
3797: FND_MSG_PUB.initialize;
3798: END IF; -- FND_API.To_Boolean
3799:
3800: -- Debug Message
3801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 3801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

3797: FND_MSG_PUB.initialize;
3798: END IF; -- FND_API.To_Boolean
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;

Line 3805: FND_MSG_PUB.Add;

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
3809: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3806: END IF; -- FND_MSG_PUB.Check_Msg_level

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
3809: x_return_status := FND_API.G_RET_STS_SUCCESS;
3810:

Line 3818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3814: THEN
3815: l_Error_Msg := 'Must pass p_content_id parameter';
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

Line 3821: FND_MSG_PUB.Add;

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

Line 3822: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
3825:
3826: -- check if the media_type paramater is NULL. No point in processing a

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

3829: THEN
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:

Line 3835: FND_MSG_PUB.Add;

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;
3839: -- Must pass a request_type

Line 3836: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
3839: -- Must pass a request_type
3840: ELSIF (p_content_type IS NULL) -- IF (p_content_id IS NULL)

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

3841: THEN
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:

Line 3847: FND_MSG_PUB.Add;

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;
3851: ELSIF (p_request_id IS NULL) -- IF (p_request_id IS NULL)

Line 3848: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
3851: ELSIF (p_request_id IS NULL) -- IF (p_request_id IS NULL)
3852: THEN

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

3852: THEN
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:

Line 3858: FND_MSG_PUB.Add;

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;
3862: ELSE -- IF (p_content_id IS NULL)

Line 3859: END IF; -- IF _FND_MSG_PUB.check_msg_level

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;
3862: ELSE -- IF (p_content_id IS NULL)
3863:

Line 3916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3912: THEN
3913: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER';
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

Line 3919: FND_MSG_PUB.Add;

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

Line 3920: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
3923:
3924: END IF; -- IF (l_temp = 0)

Line 4095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

4091:
4092: END IF; -- IF (p_content_id IS NULL)
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;

Line 4099: FND_MSG_PUB.Add;

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
4103:

Line 4100: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

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
4103:
4104: IF FND_API.To_Boolean ( p_commit )

Line 4110: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4106: COMMIT WORK;
4107: END IF; -- IF FND_API.To_Boolean
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;

Line 4114: FND_MSG_PUB.Add;

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
4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 4115: END IF; -- IF FND_MSG_PUB.Check_Msg_level

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
4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4119: p_count => x_msg_count,

Line 4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

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
4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4119: p_count => x_msg_count,
4120: p_data => x_msg_data
4121: );
4122:

Line 4131: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4127: x_content_xml := NULL;
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4130: -- Standard call to get message count and if count=1, get the message
4131: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4132: p_count => x_msg_count,
4133: p_data => x_msg_data
4134: );
4135: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4140: x_content_xml := NULL;
4141: x_return_status := FND_API.G_RET_STS_ERROR;
4142: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4143: -- Standard call to get message count and if count=1, get the message
4144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4145: p_count => x_msg_count,
4146: p_data => x_msg_data
4147: );
4148: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4153: x_content_xml := NULL;
4154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4155: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4156:
4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4158: THEN
4159: FND_MSG_PUB.Add_Exc_Msg
4160: (G_PKG_NAME, l_api_name);
4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

Line 4159: FND_MSG_PUB.Add_Exc_Msg

4155: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4156:
4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4158: THEN
4159: FND_MSG_PUB.Add_Exc_Msg
4160: (G_PKG_NAME, l_api_name);
4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4162:
4163: -- Standard call to get message count and if count=1, get the message

Line 4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4158: THEN
4159: FND_MSG_PUB.Add_Exc_Msg
4160: (G_PKG_NAME, l_api_name);
4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4162:
4163: -- Standard call to get message count and if count=1, get the message
4164: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4165: p_count => x_msg_count,

Line 4164: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4160: (G_PKG_NAME, l_api_name);
4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4162:
4163: -- Standard call to get message count and if count=1, get the message
4164: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4165: p_count => x_msg_count,
4166: p_data => x_msg_data
4167: );
4168: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

4380: );
4381:
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;

Line 4388: FND_MSG_PUB.Add;

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
4392: IF FND_API.To_Boolean ( p_commit )

Line 4389: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

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
4392: IF FND_API.To_Boolean ( p_commit )
4393: THEN

Line 4406: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4402:
4403: END IF;
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;

Line 4410: FND_MSG_PUB.Add;

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
4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 4411: END IF; -- IF FND_MSG.PUB.Check_Msg_level

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
4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4415: p_count => x_msg_count,

Line 4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

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
4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4415: p_count => x_msg_count,
4416: p_data => x_msg_data
4417: );
4418: EXCEPTION

Line 4426: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4422: ROLLBACK TO Send_Request;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4425: -- Standard call to get message count and if count=1, get the message
4426: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4427: p_count => x_msg_count,
4428: p_data => x_msg_data
4429: );
4430: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4439: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4437: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
4438: -- Standard call to get message count and if count=1, get the message
4439: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4440: p_count => x_msg_count,
4441: p_data => x_msg_data
4442: );
4443: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4447: ROLLBACK TO Send_Request;
4448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4449: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4450:
4451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4452: THEN
4453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4455:

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

4449: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4450:
4451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4452: THEN
4453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4455:
4456: -- Standard call to get message count and if count=1, get the message
4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level

4450:
4451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4452: THEN
4453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4455:
4456: -- Standard call to get message count and if count=1, get the message
4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
4458: p_count => x_msg_count,

Line 4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

4453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4455:
4456: -- Standard call to get message count and if count=1, get the message
4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data
4460: );
4461: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4618: FND_MSG_PUB.initialize;

4614:
4615: --Initialize message list if p_init_msg_list is TRUE.
4616: IF FND_API.To_Boolean (p_init_msg_list)
4617: THEN
4618: FND_MSG_PUB.initialize;
4619: END IF; -- IF FND_API.To_Boolean (p_init_msg_list)
4620:
4621: -- Debug Message
4622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 4622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4618: FND_MSG_PUB.initialize;
4619: END IF; -- IF FND_API.To_Boolean (p_init_msg_list)
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;

Line 4626: FND_MSG_PUB.Add;

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
4630: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4627: END IF; -- 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
4630: x_return_status := FND_API.G_RET_STS_SUCCESS;
4631:

Line 4635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4631:
4632: IF (p_request_id IS NULL)
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)

Line 4638: FND_MSG_PUB.Add;

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
4642:

Line 4639: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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
4642:
4643: OPEN GETREQUEST;

Line 4693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4689: -- Already has a status of 'PREVIEWED' in the XML.
4690: IF (INSTR(l_status, 'PREVIEWED') > 0)
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)

Line 4696: FND_MSG_PUB.Add;

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

Line 4697: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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;
4700:
4701: -- Has a status of 'PREVIEW' in the XML. This is the one that will be

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

4756: IF FND_API.To_Boolean ( p_commit ) THEN
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;

Line 4763: FND_MSG_PUB.Add;

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)
4767: THEN

Line 4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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)
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;

Line 4770: FND_MSG_PUB.Add;

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
4774: FND_MSG_PUB.Count_And_Get (

Line 4774: FND_MSG_PUB.Count_And_Get (

4770: FND_MSG_PUB.Add;
4771: END IF;
4772:
4773: --Standard call to get message count and if count=1, get the message
4774: FND_MSG_PUB.Count_And_Get (
4775: p_encoded => FND_API.g_false,
4776: p_count => x_msg_count,
4777: p_data => x_msg_data
4778: );

Line 4780: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

4776: p_count => x_msg_count,
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:

Line 4782: FND_MSG_PUB.Add;

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
4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4791: FND_MSG_PUB.Count_And_Get (

4787: ROLLBACK TO Previewed;
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4790: -- Standard call to get message count and if count=1, get the message
4791: FND_MSG_PUB.Count_And_Get (
4792: p_encoded => FND_API.g_false,
4793: p_count => x_msg_count,
4794: p_data => x_msg_data
4795: );

Line 4802: FND_MSG_PUB.Count_And_Get (

4798: ROLLBACK TO Previewed;
4799: x_return_status := FND_API.G_RET_STS_ERROR;
4800: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4801: -- Standard call to get message count and if count=1, get the message
4802: FND_MSG_PUB.Count_And_Get (
4803: p_encoded => FND_API.g_false,
4804: p_count => x_msg_count,
4805: p_data => x_msg_data
4806: );

Line 4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4808: WHEN OTHERS THEN
4809: ROLLBACK TO Previewed;
4810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4811: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4813: THEN
4814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4815: END IF;
4816: -- Standard call to get message count and if count=1, get the message

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

4810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4811: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4813: THEN
4814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4815: END IF;
4816: -- Standard call to get message count and if count=1, get the message
4817: FND_MSG_PUB.Count_And_Get (
4818: p_encoded => FND_API.g_false,

Line 4817: FND_MSG_PUB.Count_And_Get (

4813: THEN
4814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4815: END IF;
4816: -- Standard call to get message count and if count=1, get the message
4817: FND_MSG_PUB.Count_And_Get (
4818: p_encoded => FND_API.g_false,
4819: p_count => x_msg_count,
4820: p_data => x_msg_data
4821: );

Line 4941: FND_MSG_PUB.initialize;

4937: END IF;
4938:
4939: --Initialize message list if p_init_msg_list is TRUE.
4940: IF FND_API.To_Boolean (p_init_msg_list) THEN
4941: FND_MSG_PUB.initialize;
4942: END IF;
4943:
4944: -- Debug Message
4945: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

4941: FND_MSG_PUB.initialize;
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;

Line 4948: FND_MSG_PUB.Add;

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
4952: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4957: from dual;
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;

Line 4963: FND_MSG_PUB.Add;

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
4967: -- Get data from request_history for the request_id passed.

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

5180: IF FND_API.To_Boolean ( p_commit ) THEN
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;

Line 5187: FND_MSG_PUB.Add;

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)
5191: THEN

Line 5190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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)
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;

Line 5194: FND_MSG_PUB.Add;

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 (
5198: p_encoded => FND_API.g_false,

Line 5197: FND_MSG_PUB.Count_And_Get (

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 (
5198: p_encoded => FND_API.g_false,
5199: p_count => x_msg_count,
5200: p_data => x_msg_data
5201: );

Line 5202: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

5198: p_encoded => FND_API.g_false,
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);

Line 5204: FND_MSG_PUB.Add;

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
5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5213: FND_MSG_PUB.Count_And_Get (

5209: ROLLBACK TO Resubmit;
5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5211: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5212: -- Standard call to get message count and if count=1, get the message
5213: FND_MSG_PUB.Count_And_Get (
5214: p_encoded => FND_API.g_false,
5215: p_count => x_msg_count,
5216: p_data => x_msg_data
5217: );

Line 5224: FND_MSG_PUB.Count_And_Get (

5220: ROLLBACK TO Resubmit;
5221: x_return_status := FND_API.G_RET_STS_ERROR;
5222: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5223: -- Standard call to get message count and if count=1, get the message
5224: FND_MSG_PUB.Count_And_Get (
5225: p_encoded => FND_API.g_false,
5226: p_count => x_msg_count,
5227: p_data => x_msg_data
5228: );

Line 5234: IF FND_MSG_PUB.Check_Msg_Level

5230: WHEN OTHERS THEN
5231: ROLLBACK TO Resubmit;
5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5233: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5234: IF FND_MSG_PUB.Check_Msg_Level
5235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5236: THEN
5237: FND_MSG_PUB.Add_Exc_Msg
5238: (G_PKG_NAME, l_api_name);

Line 5235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5231: ROLLBACK TO Resubmit;
5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5233: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5234: IF FND_MSG_PUB.Check_Msg_Level
5235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5236: THEN
5237: FND_MSG_PUB.Add_Exc_Msg
5238: (G_PKG_NAME, l_api_name);
5239: END IF;

Line 5237: FND_MSG_PUB.Add_Exc_Msg

5233: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5234: IF FND_MSG_PUB.Check_Msg_Level
5235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5236: THEN
5237: FND_MSG_PUB.Add_Exc_Msg
5238: (G_PKG_NAME, l_api_name);
5239: END IF;
5240: -- Standard call to get message count and if count=1, get the message
5241: FND_MSG_PUB.Count_And_Get (

Line 5241: FND_MSG_PUB.Count_And_Get (

5237: FND_MSG_PUB.Add_Exc_Msg
5238: (G_PKG_NAME, l_api_name);
5239: END IF;
5240: -- Standard call to get message count and if count=1, get the message
5241: FND_MSG_PUB.Count_And_Get (
5242: p_encoded => FND_API.g_false,
5243: p_count => x_msg_count,
5244: p_data => x_msg_data
5245: );

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

5436: END IF;
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;

Line 5443: FND_MSG_PUB.Add;

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
5447: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5479: END IF;
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;

Line 5485: FND_MSG_PUB.Add;

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
5489: GET_MEDIA(p_media_type,p_media_address,l_media);

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

5814: COMMIT WORK;
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;

Line 5821: FND_MSG_PUB.Add;

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)
5825: THEN

Line 5824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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)
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;

Line 5828: FND_MSG_PUB.Add;

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 (
5832: p_encoded => FND_API.g_false,

Line 5831: FND_MSG_PUB.Count_And_Get (

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 (
5832: p_encoded => FND_API.g_false,
5833: p_count => x_msg_count,
5834: p_data => x_msg_data
5835: );

Line 5836: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

5832: p_encoded => FND_API.g_false,
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);

Line 5838: FND_MSG_PUB.Add;

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
5842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5847: FND_MSG_PUB.Count_And_Get (

5843: ROLLBACK TO Resubmit_job;
5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5845: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5846: -- Standard call to get message count and if count=1, get the message
5847: FND_MSG_PUB.Count_And_Get (
5848: p_encoded => FND_API.g_false,
5849: p_count => x_msg_count,
5850: p_data => x_msg_data
5851: );

Line 5858: FND_MSG_PUB.Count_And_Get (

5854: ROLLBACK TO Resubmit_job;
5855: x_return_status := FND_API.G_RET_STS_ERROR;
5856: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5857: -- Standard call to get message count and if count=1, get the message
5858: FND_MSG_PUB.Count_And_Get (
5859: p_encoded => FND_API.g_false,
5860: p_count => x_msg_count,
5861: p_data => x_msg_data
5862: );

Line 5868: IF FND_MSG_PUB.Check_Msg_Level

5864: WHEN OTHERS THEN
5865: ROLLBACK TO Resubmit_job;
5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5867: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5868: IF FND_MSG_PUB.Check_Msg_Level
5869: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5870: THEN
5871: FND_MSG_PUB.Add_Exc_Msg
5872: (G_PKG_NAME, l_api_name);

Line 5869: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5865: ROLLBACK TO Resubmit_job;
5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5867: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5868: IF FND_MSG_PUB.Check_Msg_Level
5869: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5870: THEN
5871: FND_MSG_PUB.Add_Exc_Msg
5872: (G_PKG_NAME, l_api_name);
5873: END IF;

Line 5871: FND_MSG_PUB.Add_Exc_Msg

5867: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5868: IF FND_MSG_PUB.Check_Msg_Level
5869: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5870: THEN
5871: FND_MSG_PUB.Add_Exc_Msg
5872: (G_PKG_NAME, l_api_name);
5873: END IF;
5874: -- Standard call to get message count and if count=1, get the message
5875: FND_MSG_PUB.Count_And_Get (

Line 5875: FND_MSG_PUB.Count_And_Get (

5871: FND_MSG_PUB.Add_Exc_Msg
5872: (G_PKG_NAME, l_api_name);
5873: END IF;
5874: -- Standard call to get message count and if count=1, get the message
5875: FND_MSG_PUB.Count_And_Get (
5876: p_encoded => FND_API.g_false,
5877: p_count => x_msg_count,
5878: p_data => x_msg_data
5879: );

Line 5914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

5910: and FAILURE = 'MALFORMED_ADDRESS';
5911:
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;

Line 5918: FND_MSG_PUB.Add;

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
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5936: IF FND_MSG_PUB.Check_Msg_Level

5932: WHEN OTHERS THEN
5933: ROLLBACK TO pre_correction;
5934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5935: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5936: IF FND_MSG_PUB.Check_Msg_Level
5937: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: FND_MSG_PUB.Add_Exc_Msg
5940: (G_PKG_NAME, l_api_name);

Line 5937: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5933: ROLLBACK TO pre_correction;
5934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5935: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5936: IF FND_MSG_PUB.Check_Msg_Level
5937: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: FND_MSG_PUB.Add_Exc_Msg
5940: (G_PKG_NAME, l_api_name);
5941: END IF;

Line 5939: FND_MSG_PUB.Add_Exc_Msg

5935: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5936: IF FND_MSG_PUB.Check_Msg_Level
5937: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: FND_MSG_PUB.Add_Exc_Msg
5940: (G_PKG_NAME, l_api_name);
5941: END IF;
5942:
5943: JTF_FM_UTL_V.PRINT_MESSAGE('END '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 5982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

5978: -- If not throw an error
5979: l_Error_Msg := 'Should pass corrected address for each job in the list';
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

Line 5985: FND_MSG_PUB.Add;

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;
5989: ELSE

Line 5986: END IF; -- IF FND_MSG_PUB.check_msg_level

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;
5989: ELSE
5990:

Line 6004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

6000: THEN
6001: COMMIT WORK;
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;

Line 6008: FND_MSG_PUB.Add;

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,
6012: p_count => x_msg_count,

Line 6011: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

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,
6012: p_count => x_msg_count,
6013: p_data => x_msg_data
6014: );
6015:

Line 6031: IF FND_MSG_PUB.Check_Msg_Level

6027: WHEN OTHERS THEN
6028: ROLLBACK TO pre_correction;
6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6030: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6031: IF FND_MSG_PUB.Check_Msg_Level
6032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: FND_MSG_PUB.Add_Exc_Msg
6035: (G_PKG_NAME, l_api_name);

Line 6032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6028: ROLLBACK TO pre_correction;
6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6030: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6031: IF FND_MSG_PUB.Check_Msg_Level
6032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: FND_MSG_PUB.Add_Exc_Msg
6035: (G_PKG_NAME, l_api_name);
6036: END IF;

Line 6034: FND_MSG_PUB.Add_Exc_Msg

6030: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6031: IF FND_MSG_PUB.Check_Msg_Level
6032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: FND_MSG_PUB.Add_Exc_Msg
6035: (G_PKG_NAME, l_api_name);
6036: END IF;
6037:
6038: JTF_FM_UTL_V.PRINT_MESSAGE('END '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 6137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

6133: THEN
6134: COMMIT WORK;
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;

Line 6141: FND_MSG_PUB.Add;

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
6145: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 6145: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

6141: FND_MSG_PUB.Add;
6142: END IF;
6143:
6144: --Standard call to get message count and if count=1, get the message
6145: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
6146: p_count => x_msg_count,
6147: p_data => x_msg_data
6148: );
6149:

Line 6165: IF FND_MSG_PUB.Check_Msg_Level

6161: WHEN OTHERS THEN
6162: ROLLBACK TO pre_resubmit;
6163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6164: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6165: IF FND_MSG_PUB.Check_Msg_Level
6166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: FND_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME, l_api_name);

Line 6166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6162: ROLLBACK TO pre_resubmit;
6163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6164: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6165: IF FND_MSG_PUB.Check_Msg_Level
6166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: FND_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME, l_api_name);
6170: END IF;

Line 6168: FND_MSG_PUB.Add_Exc_Msg

6164: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6165: IF FND_MSG_PUB.Check_Msg_Level
6166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: FND_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME, l_api_name);
6170: END IF;
6171:
6172: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 6265: FND_MSG_PUB.initialize;

6261: END IF;
6262:
6263: --Initialize message list if p_init_msg_list is TRUE.
6264: IF FND_API.To_Boolean (p_init_msg_list) THEN
6265: FND_MSG_PUB.initialize;
6266: END IF;
6267:
6268: -- Debug Message
6269: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

6265: FND_MSG_PUB.initialize;
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;

Line 6272: FND_MSG_PUB.Add;

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
6276: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6276: x_return_status := FND_API.G_RET_STS_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;

Line 6282: FND_MSG_PUB.Add;

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:
6286: ELSE

Line 6410: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

6406: END IF;
6407:
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;

Line 6414: FND_MSG_PUB.Add;

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;

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

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;

Line 6424: FND_MSG_PUB.Add;

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 (
6428: p_encoded => FND_API.g_false,

Line 6427: FND_MSG_PUB.Count_And_Get (

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 (
6428: p_encoded => FND_API.g_false,
6429: p_count => x_msg_count,
6430: p_data => x_msg_data
6431: );

Line 6433: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

6429: p_count => x_msg_count,
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);

Line 6435: FND_MSG_PUB.Add;

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
6439: WHEN L_MESSAGE_NOT_FOUND OR L_NO_MESSAGES THEN

Line 6445: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

6441: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 6447: FND_MSG_PUB.Add;

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';
6451: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

Line 6452: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

6448: END IF;
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;

Line 6454: FND_MSG_PUB.Add;

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
6458: FND_MSG_PUB.Count_And_Get (

Line 6458: FND_MSG_PUB.Count_And_Get (

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
6458: FND_MSG_PUB.Count_And_Get (
6459: p_encoded => FND_API.g_false,
6460: p_count => x_msg_count,
6461: p_data => x_msg_data
6462: );

Line 6469: FND_MSG_PUB.Count_And_Get (

6465: ROLLBACK TO Cancel;
6466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6467: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6468: -- Standard call to get message count and if count=1, get the message
6469: FND_MSG_PUB.Count_And_Get (
6470: p_encoded => FND_API.g_false,
6471: p_count => x_msg_count,
6472: p_data => x_msg_data
6473: );

Line 6480: FND_MSG_PUB.Count_And_Get (

6476: ROLLBACK TO Cancel;
6477: x_return_status := FND_API.G_RET_STS_ERROR;
6478: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6479: -- Standard call to get message count and if count=1, get the message
6480: FND_MSG_PUB.Count_And_Get (
6481: p_encoded => FND_API.g_false,
6482: p_count => x_msg_count,
6483: p_data => x_msg_data
6484: );

Line 6491: IF FND_MSG_PUB.Check_Msg_Level

6487: WHEN OTHERS THEN
6488: ROLLBACK TO Cancel;
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6490: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6491: IF FND_MSG_PUB.Check_Msg_Level
6492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6493: THEN
6494: FND_MSG_PUB.Add_Exc_Msg
6495: (G_PKG_NAME, l_api_name);

Line 6492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6488: ROLLBACK TO Cancel;
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6490: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6491: IF FND_MSG_PUB.Check_Msg_Level
6492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6493: THEN
6494: FND_MSG_PUB.Add_Exc_Msg
6495: (G_PKG_NAME, l_api_name);
6496: END IF;

Line 6494: FND_MSG_PUB.Add_Exc_Msg

6490: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6491: IF FND_MSG_PUB.Check_Msg_Level
6492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6493: THEN
6494: FND_MSG_PUB.Add_Exc_Msg
6495: (G_PKG_NAME, l_api_name);
6496: END IF;
6497: -- Standard call to get message count and if count=1, get the message
6498: FND_MSG_PUB.Count_And_Get (

Line 6498: FND_MSG_PUB.Count_And_Get (

6494: FND_MSG_PUB.Add_Exc_Msg
6495: (G_PKG_NAME, l_api_name);
6496: END IF;
6497: -- Standard call to get message count and if count=1, get the message
6498: FND_MSG_PUB.Count_And_Get (
6499: p_encoded => FND_API.g_false,
6500: p_count => x_msg_count,
6501: p_data => x_msg_data
6502: );

Line 6583: FND_MSG_PUB.initialize;

6579: END IF;
6580:
6581: --Initialize message list if p_init_msg_list is TRUE.
6582: IF FND_API.To_Boolean (p_init_msg_list) THEN
6583: FND_MSG_PUB.initialize;
6584: END IF;
6585:
6586: -- Debug Message
6587: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

6583: FND_MSG_PUB.initialize;
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;

Line 6590: FND_MSG_PUB.Add;

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
6594: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6594: x_return_status := FND_API.G_RET_STS_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;

Line 6600: FND_MSG_PUB.Add;

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
6604: l_Error_Msg := 'Must specify content_type for all contents passed';

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

6601: END IF;
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;

Line 6607: FND_MSG_PUB.Add;

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
6611: l_Error_Msg := 'Must specify media_type for all contents passed';

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

6608: END IF;
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;

Line 6614: FND_MSG_PUB.Add;

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
6618: -- l_Error_Msg := 'Must specify document_type for all contents passed';

Line 6619: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6615: END IF;
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;

Line 6622: -- FND_MSG_PUB.Add;

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
6626: -- l_Error_Msg := 'Must specify content_name for all contents passed';

Line 6627: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6623: -- END IF;
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;

Line 6630: -- FND_MSG_PUB.Add;

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
6634: l_email_count := p_email.count;

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

6681: JTF_FM_UTL_V.PRINT_MESSAGE('Forming the Content XML3',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
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;

Line 6689: FND_MSG_PUB.Add;

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
6693: l_Error_Msg := 'Only one of the media_types EMAIL, FAX, PRINTER can be sent per request';

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

6690: END IF;
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;

Line 6697: FND_MSG_PUB.Add;

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
6701: null;

Line 6746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

6742:
6743: END IF;
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;

Line 6750: FND_MSG_PUB.Add;

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;

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

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;

Line 6760: FND_MSG_PUB.Add;

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 (
6764: p_encoded => FND_API.g_false,

Line 6763: FND_MSG_PUB.Count_And_Get (

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 (
6764: p_encoded => FND_API.g_false,
6765: p_count => x_msg_count,
6766: p_data => x_msg_data
6767: );

Line 6774: FND_MSG_PUB.Count_And_Get (

6770: ROLLBACK TO Attachment_XML;
6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6772: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6773: -- Standard call to get message count and if count=1, get the message
6774: FND_MSG_PUB.Count_And_Get (
6775: p_encoded => FND_API.g_false,
6776: p_count => x_msg_count,
6777: p_data => x_msg_data
6778: );

Line 6785: FND_MSG_PUB.Count_And_Get (

6781: ROLLBACK TO Attachment_XML;
6782: x_return_status := FND_API.G_RET_STS_ERROR;
6783: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6784: -- Standard call to get message count and if count=1, get the message
6785: FND_MSG_PUB.Count_And_Get (
6786: p_encoded => FND_API.g_false,
6787: p_count => x_msg_count,
6788: p_data => x_msg_data
6789: );

Line 6795: IF FND_MSG_PUB.Check_Msg_Level

6791: WHEN OTHERS THEN
6792: ROLLBACK TO Attachment_XML;
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6795: IF FND_MSG_PUB.Check_Msg_Level
6796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6797: THEN
6798: FND_MSG_PUB.Add_Exc_Msg
6799: (G_PKG_NAME, l_api_name);

Line 6796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6792: ROLLBACK TO Attachment_XML;
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6795: IF FND_MSG_PUB.Check_Msg_Level
6796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6797: THEN
6798: FND_MSG_PUB.Add_Exc_Msg
6799: (G_PKG_NAME, l_api_name);
6800: END IF;

Line 6798: FND_MSG_PUB.Add_Exc_Msg

6794: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6795: IF FND_MSG_PUB.Check_Msg_Level
6796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6797: THEN
6798: FND_MSG_PUB.Add_Exc_Msg
6799: (G_PKG_NAME, l_api_name);
6800: END IF;
6801: -- Standard call to get message count and if count=1, get the message
6802: FND_MSG_PUB.Count_And_Get (

Line 6802: FND_MSG_PUB.Count_And_Get (

6798: FND_MSG_PUB.Add_Exc_Msg
6799: (G_PKG_NAME, l_api_name);
6800: END IF;
6801: -- Standard call to get message count and if count=1, get the message
6802: FND_MSG_PUB.Count_And_Get (
6803: p_encoded => FND_API.g_false,
6804: p_count => x_msg_count,
6805: p_data => x_msg_data
6806: );

Line 6887: FND_MSG_PUB.initialize;

6883: END IF;
6884:
6885: --Initialize message list if p_init_msg_list is TRUE.
6886: IF FND_API.To_Boolean (p_init_msg_list) THEN
6887: FND_MSG_PUB.initialize;
6888: END IF;
6889:
6890: -- Debug Message
6891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

6887: FND_MSG_PUB.initialize;
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;

Line 6894: FND_MSG_PUB.Add;

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
6898: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6898: x_return_status := FND_API.G_RET_STS_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;

Line 6904: FND_MSG_PUB.Add;

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
6908: l_Error_Msg := 'Must pass p_content_xml parameter';

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

6905: END IF;
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;

Line 6912: FND_MSG_PUB.Add;

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

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

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

Line 6925: FND_MSG_PUB.Add;

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
6929: JTF_FM_UTL_V.PRINT_MESSAGE('Creating View XML ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

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

6956: --INTO l_index FROM DUAL;
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;

Line 6962: FND_MSG_PUB.Add;

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
6966: l_message := l_message||'';

Line 7046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

7042: p_request_id => p_request_id
7043: );
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;

Line 7050: FND_MSG_PUB.Add;

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;

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

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;

Line 7060: FND_MSG_PUB.Add;

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 (
7064: p_encoded => FND_API.g_false,

Line 7063: FND_MSG_PUB.Count_And_Get (

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 (
7064: p_encoded => FND_API.g_false,
7065: p_count => x_msg_count,
7066: p_data => x_msg_data
7067: );

Line 7074: FND_MSG_PUB.Count_And_Get (

7070: ROLLBACK TO Batch_Request;
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7073: -- Standard call to get message count and if count=1, get the message
7074: FND_MSG_PUB.Count_And_Get (
7075: p_encoded => FND_API.g_false,
7076: p_count => x_msg_count,
7077: p_data => x_msg_data
7078: );

Line 7085: FND_MSG_PUB.Count_And_Get (

7081: ROLLBACK TO Batch_Request;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7084: -- Standard call to get message count and if count=1, get the message
7085: FND_MSG_PUB.Count_And_Get (
7086: p_encoded => FND_API.g_false,
7087: p_count => x_msg_count,
7088: p_data => x_msg_data
7089: );

Line 7095: IF FND_MSG_PUB.Check_Msg_Level

7091: WHEN OTHERS THEN
7092: ROLLBACK TO Batch_Request;
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7095: IF FND_MSG_PUB.Check_Msg_Level
7096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7097: THEN
7098: FND_MSG_PUB.Add_Exc_Msg
7099: (G_PKG_NAME, l_api_name);

Line 7096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7092: ROLLBACK TO Batch_Request;
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7095: IF FND_MSG_PUB.Check_Msg_Level
7096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7097: THEN
7098: FND_MSG_PUB.Add_Exc_Msg
7099: (G_PKG_NAME, l_api_name);
7100: END IF;

Line 7098: FND_MSG_PUB.Add_Exc_Msg

7094: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7095: IF FND_MSG_PUB.Check_Msg_Level
7096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7097: THEN
7098: FND_MSG_PUB.Add_Exc_Msg
7099: (G_PKG_NAME, l_api_name);
7100: END IF;
7101: -- Standard call to get message count and if count=1, get the message
7102: FND_MSG_PUB.Count_And_Get (

Line 7102: FND_MSG_PUB.Count_And_Get (

7098: FND_MSG_PUB.Add_Exc_Msg
7099: (G_PKG_NAME, l_api_name);
7100: END IF;
7101: -- Standard call to get message count and if count=1, get the message
7102: FND_MSG_PUB.Count_And_Get (
7103: p_encoded => FND_API.g_false,
7104: p_count => x_msg_count,
7105: p_data => x_msg_data
7106: );

Line 7202: FND_MSG_PUB.initialize;

7198: END IF;
7199:
7200: --Initialize message list if p_init_msg_list is TRUE.
7201: IF FND_API.To_Boolean (p_init_msg_list) THEN
7202: FND_MSG_PUB.initialize;
7203: END IF;
7204:
7205: -- Debug Message
7206: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

7202: FND_MSG_PUB.initialize;
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;

Line 7209: FND_MSG_PUB.Add;

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
7213: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 7221: FND_MSG_PUB.Add;

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:
7225: ELSE

Line 7280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

7276: p_request_id => p_request_id
7277: );
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;

Line 7284: FND_MSG_PUB.Add;

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;

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

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;

Line 7294: FND_MSG_PUB.Add;

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 (
7298: p_encoded => FND_API.g_false,

Line 7297: FND_MSG_PUB.Count_And_Get (

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 (
7298: p_encoded => FND_API.g_false,
7299: p_count => x_msg_count,
7300: p_data => x_msg_data
7301: );

Line 7308: FND_MSG_PUB.Count_And_Get (

7304: ROLLBACK TO Mass_Request;
7305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7306: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7307: -- Standard call to get message count and if count=1, get the message
7308: FND_MSG_PUB.Count_And_Get (
7309: p_encoded => FND_API.g_false,
7310: p_count => x_msg_count,
7311: p_data => x_msg_data
7312: );

Line 7319: FND_MSG_PUB.Count_And_Get (

7315: ROLLBACK TO Mass_Request;
7316: x_return_status := FND_API.G_RET_STS_ERROR;
7317: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7318: -- Standard call to get message count and if count=1, get the message
7319: FND_MSG_PUB.Count_And_Get (
7320: p_encoded => FND_API.g_false,
7321: p_count => x_msg_count,
7322: p_data => x_msg_data
7323: );

Line 7329: IF FND_MSG_PUB.Check_Msg_Level

7325: WHEN OTHERS THEN
7326: ROLLBACK TO Mass_Request;
7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7328: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7329: IF FND_MSG_PUB.Check_Msg_Level
7330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7331: THEN
7332: FND_MSG_PUB.Add_Exc_Msg
7333: (G_PKG_NAME, l_api_name);

Line 7330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7326: ROLLBACK TO Mass_Request;
7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7328: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7329: IF FND_MSG_PUB.Check_Msg_Level
7330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7331: THEN
7332: FND_MSG_PUB.Add_Exc_Msg
7333: (G_PKG_NAME, l_api_name);
7334: END IF;

Line 7332: FND_MSG_PUB.Add_Exc_Msg

7328: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7329: IF FND_MSG_PUB.Check_Msg_Level
7330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7331: THEN
7332: FND_MSG_PUB.Add_Exc_Msg
7333: (G_PKG_NAME, l_api_name);
7334: END IF;
7335: -- Standard call to get message count and if count=1, get the message
7336: FND_MSG_PUB.Count_And_Get (

Line 7336: FND_MSG_PUB.Count_And_Get (

7332: FND_MSG_PUB.Add_Exc_Msg
7333: (G_PKG_NAME, l_api_name);
7334: END IF;
7335: -- Standard call to get message count and if count=1, get the message
7336: FND_MSG_PUB.Count_And_Get (
7337: p_encoded => FND_API.g_false,
7338: p_count => x_msg_count,
7339: p_data => x_msg_data
7340: );

Line 7584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

7580:
7581: -- Success message
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;

Line 7588: FND_MSG_PUB.Add;

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
7592: IF FND_API.To_Boolean ( p_commit )

Line 7598: FND_MSG_PUB.Count_And_Get (

7594: COMMIT WORK;
7595: END IF;
7596:
7597: --Standard call to get message count and if count=1, get the message
7598: FND_MSG_PUB.Count_And_Get (
7599: p_encoded => FND_API.g_false,
7600: p_count => x_msg_count,
7601: p_data => x_msg_data
7602: );

Line 7604: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success)

7600: p_count => x_msg_count,
7601: p_data => x_msg_data
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;

Line 7607: FND_MSG_PUB.Add;

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
7611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7616: FND_MSG_PUB.Count_And_Get (

7612: ROLLBACK TO PAUSE_RESUME;
7613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7614: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7615: -- Standard call to get message count and if count=1, get the message
7616: FND_MSG_PUB.Count_And_Get (
7617: p_encoded => FND_API.g_false,
7618: p_count => x_msg_count,
7619: p_data => x_msg_data
7620: );

Line 7627: FND_MSG_PUB.Count_And_Get (

7623: ROLLBACK TO PAUSE_RESUME;
7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7626: -- Standard call to get message count and if count=1, get the message
7627: FND_MSG_PUB.Count_And_Get (
7628: p_encoded => FND_API.g_false,
7629: p_count => x_msg_count,
7630: p_data => x_msg_data
7631: );

Line 7637: IF FND_MSG_PUB.Check_Msg_Level

7633: WHEN OTHERS THEN
7634: ROLLBACK TO PAUSE_RESUME;
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7637: IF FND_MSG_PUB.Check_Msg_Level
7638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7639: THEN
7640: FND_MSG_PUB.Add_Exc_Msg
7641: (G_PKG_NAME, l_api_name);

Line 7638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7634: ROLLBACK TO PAUSE_RESUME;
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7637: IF FND_MSG_PUB.Check_Msg_Level
7638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7639: THEN
7640: FND_MSG_PUB.Add_Exc_Msg
7641: (G_PKG_NAME, l_api_name);
7642: END IF;

Line 7640: FND_MSG_PUB.Add_Exc_Msg

7636: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7637: IF FND_MSG_PUB.Check_Msg_Level
7638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7639: THEN
7640: FND_MSG_PUB.Add_Exc_Msg
7641: (G_PKG_NAME, l_api_name);
7642: END IF;
7643: -- Standard call to get message count and if count=1, get the message
7644: FND_MSG_PUB.Count_And_Get (

Line 7644: FND_MSG_PUB.Count_And_Get (

7640: FND_MSG_PUB.Add_Exc_Msg
7641: (G_PKG_NAME, l_api_name);
7642: END IF;
7643: -- Standard call to get message count and if count=1, get the message
7644: FND_MSG_PUB.Count_And_Get (
7645: p_encoded => FND_API.g_false,
7646: p_count => x_msg_count,
7647: p_data => x_msg_data
7648: );