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

Line 259: FND_MSG_PUB.initialize;

255: END IF;
256:
257: --Initialize message list if p_init_msg_list is TRUE.
258: IF FND_API.To_Boolean (p_init_msg_list) THEN
259: FND_MSG_PUB.initialize;
260: END IF;
261:
262: -- Initialize API return status to success
263: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 280: FND_MSG_PUB.count_and_get(

276: COMMIT WORK;
277: END IF;
278:
279: --Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );

Line 290: FND_MSG_PUB.count_and_get(

286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: ROLLBACK TO Start_Request;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.count_and_get(
291: p_encoded => FND_API.g_false,
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );

Line 299: FND_MSG_PUB.count_and_get(

295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO Start_Request;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: -- Standard call to get message count and if count=1, get the message
299: FND_MSG_PUB.count_and_get(
300: p_encoded => FND_API.g_false,
301: p_count => x_msg_count,
302: p_data => x_msg_data
303: );

Line 307: IF FND_MSG_PUB.Check_Msg_Level

303: );
304: WHEN OTHERS THEN
305: ROLLBACK TO Start_Request;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: (G_PKG_NAME, l_api_name);

Line 308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

304: WHEN OTHERS THEN
305: ROLLBACK TO Start_Request;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: (G_PKG_NAME, l_api_name);
312: END IF;

Line 310: FND_MSG_PUB.Add_Exc_Msg

306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level
308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg
311: (G_PKG_NAME, l_api_name);
312: END IF;
313: -- Standard call to get message count and if count=1, get the message
314: FND_MSG_PUB.count_and_get(

Line 314: FND_MSG_PUB.count_and_get(

310: FND_MSG_PUB.Add_Exc_Msg
311: (G_PKG_NAME, l_api_name);
312: END IF;
313: -- Standard call to get message count and if count=1, get the message
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );

Line 373: FND_MSG_PUB.initialize;

369: END IF;
370:
371: --Initialize message list if p_init_msg_list is TRUE.
372: IF FND_API.To_Boolean (p_init_msg_list) THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:
376: -- Initialize API return status to success
377: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

376: -- Initialize API return status to success
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379:
380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
381: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
382: IF (p_arg1 IS NOT NULL) THEN
383: FND_MESSAGE.Set_Token('ARG1', p_arg1);
384: END IF;

Line 388: FND_MSG_PUB.Add;

384: END IF;
385: IF (p_arg2 IS NOT NULL) THEN
386: FND_MESSAGE.Set_Token('ARG2', p_arg2);
387: END IF;
388: FND_MSG_PUB.Add;
389: END IF;
390:
391: --Standard check of commit
392: IF FND_API.To_Boolean ( p_commit ) THEN

Line 397: FND_MSG_PUB.count_and_get(

393: COMMIT WORK;
394: END IF;
395:
396: --Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.count_and_get(
398: p_encoded => FND_API.g_false,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

Line 407: FND_MSG_PUB.count_and_get(

403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: ROLLBACK TO Post_Message;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: -- Standard call to get message count and if count=1, get the message
407: FND_MSG_PUB.count_and_get(
408: p_encoded => FND_API.g_false,
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );

Line 416: FND_MSG_PUB.count_and_get(

412: WHEN FND_API.G_EXC_ERROR THEN
413: ROLLBACK TO Post_Message;
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: -- Standard call to get message count and if count=1, get the message
416: FND_MSG_PUB.count_and_get(
417: p_encoded => FND_API.g_false,
418: p_count => x_msg_count,
419: p_data => x_msg_data
420: );

Line 424: IF FND_MSG_PUB.Check_Msg_Level

420: );
421: WHEN OTHERS THEN
422: ROLLBACK TO Post_Message;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
426: THEN
427: FND_MSG_PUB.Add_Exc_Msg
428: (G_PKG_NAME, l_api_name);

Line 425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

421: WHEN OTHERS THEN
422: ROLLBACK TO Post_Message;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
426: THEN
427: FND_MSG_PUB.Add_Exc_Msg
428: (G_PKG_NAME, l_api_name);
429: END IF;

Line 427: FND_MSG_PUB.Add_Exc_Msg

423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
426: THEN
427: FND_MSG_PUB.Add_Exc_Msg
428: (G_PKG_NAME, l_api_name);
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.count_and_get(

Line 431: FND_MSG_PUB.count_and_get(

427: FND_MSG_PUB.Add_Exc_Msg
428: (G_PKG_NAME, l_api_name);
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.count_and_get(
432: p_encoded => FND_API.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );

Line 493: FND_MSG_PUB.initialize;

489: END IF;
490:
491: --Initialize message list if p_init_msg_list is TRUE.
492: IF FND_API.To_Boolean (p_init_msg_list) THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499:
500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
501: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
502: IF (p_arg1 IS NOT NULL) THEN
503: FND_MESSAGE.Set_Token('ARG1', p_arg1);
504: END IF;

Line 508: FND_MSG_PUB.Add;

504: END IF;
505: IF (p_arg2 IS NOT NULL) THEN
506: FND_MESSAGE.Set_Token('ARG2', p_arg2);
507: END IF;
508: FND_MSG_PUB.Add;
509: END IF;
510:
511: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
512: IF (p_arg1 IS NOT NULL) THEN

Line 526: FND_MSG_PUB.count_and_get(

522: COMMIT WORK;
523: END IF;
524:
525: --Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.count_and_get(
527: p_encoded => FND_API.g_false,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 536: FND_MSG_PUB.count_and_get(

532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO Get_Post_Message;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.count_and_get(
537: p_encoded => FND_API.g_false,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 545: FND_MSG_PUB.count_and_get(

541: WHEN FND_API.G_EXC_ERROR THEN
542: ROLLBACK TO Get_Post_Message;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: -- Standard call to get message count and if count=1, get the message
545: FND_MSG_PUB.count_and_get(
546: p_encoded => FND_API.g_false,
547: p_count => x_msg_count,
548: p_data => x_msg_data
549: );

Line 553: IF FND_MSG_PUB.Check_Msg_Level

549: );
550: WHEN OTHERS THEN
551: ROLLBACK TO Get_Post_Message;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: IF FND_MSG_PUB.Check_Msg_Level
554: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: FND_MSG_PUB.Add_Exc_Msg
557: (G_PKG_NAME, l_api_name);

Line 554: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

550: WHEN OTHERS THEN
551: ROLLBACK TO Get_Post_Message;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: IF FND_MSG_PUB.Check_Msg_Level
554: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: FND_MSG_PUB.Add_Exc_Msg
557: (G_PKG_NAME, l_api_name);
558: END IF;

Line 556: FND_MSG_PUB.Add_Exc_Msg

552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: IF FND_MSG_PUB.Check_Msg_Level
554: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: FND_MSG_PUB.Add_Exc_Msg
557: (G_PKG_NAME, l_api_name);
558: END IF;
559: -- Standard call to get message count and if count=1, get the message
560: FND_MSG_PUB.count_and_get(

Line 560: FND_MSG_PUB.count_and_get(

556: FND_MSG_PUB.Add_Exc_Msg
557: (G_PKG_NAME, l_api_name);
558: END IF;
559: -- Standard call to get message count and if count=1, get the message
560: FND_MSG_PUB.count_and_get(
561: p_encoded => FND_API.g_false,
562: p_count => x_msg_count,
563: p_data => x_msg_data
564: );

Line 673: l_count := FND_MSG_PUB.Count_Msg;

669: l_msg_index_out NUMBER := 0;
670: j NUMBER;
671: BEGIN
672: x_msg_data := NULL;
673: l_count := FND_MSG_PUB.Count_Msg;
674: IF l_count > 0 THEN
675: FND_MSG_PUB.Get(p_msg_index => l_count,
676: p_encoded => FND_API.G_FALSE,
677: p_data => x_msg_data,

Line 675: FND_MSG_PUB.Get(p_msg_index => l_count,

671: BEGIN
672: x_msg_data := NULL;
673: l_count := FND_MSG_PUB.Count_Msg;
674: IF l_count > 0 THEN
675: FND_MSG_PUB.Get(p_msg_index => l_count,
676: p_encoded => FND_API.G_FALSE,
677: p_data => x_msg_data,
678: p_msg_index_out => l_msg_index_out);
679: END IF;

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

703: )
704: IS
705:
706: BEGIN
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
708: THEN
709: FND_MESSAGE.set_name('JTF', p_name);
710: FND_MESSAGE.Set_Token('ARG1',p_token);
711: FND_MSG_PUB.Add;

Line 711: FND_MSG_PUB.Add;

707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
708: THEN
709: FND_MESSAGE.set_name('JTF', p_name);
710: FND_MESSAGE.Set_Token('ARG1',p_token);
711: FND_MSG_PUB.Add;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;
714:
715: END HANDLE_ERROR;

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

719: )
720: IS
721:
722: BEGIN
723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
724: THEN
725: FND_MESSAGE.set_name('JTF', p_name);
726: FND_MSG_PUB.Add;
727: END IF;

Line 726: FND_MSG_PUB.Add;

722: BEGIN
723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
724: THEN
725: FND_MESSAGE.set_name('JTF', p_name);
726: FND_MSG_PUB.Add;
727: END IF;
728: RAISE FND_API.G_EXC_ERROR;
729:
730: END HANDLE_ERROR;

Line 1290: FND_MSG_PUB.initialize;

1286: --Initialize message list if p_init_msg_list is TRUE.
1287:
1288: IF FND_API.To_Boolean (p_init_msg_list)
1289: THEN
1290: FND_MSG_PUB.initialize;
1291: END IF; -- FND_API.To_Boolean
1292:
1293: -- Debug Message
1294:

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

1291: END IF; -- FND_API.To_Boolean
1292:
1293: -- Debug Message
1294:
1295: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1296: THEN
1297: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1298: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1299: FND_MSG_PUB.Add;

Line 1299: FND_MSG_PUB.Add;

1295: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1296: THEN
1297: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1298: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1299: FND_MSG_PUB.Add;
1300: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1301:
1302: -- Initialize API return status to success
1303:

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

1296: THEN
1297: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1298: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1299: FND_MSG_PUB.Add;
1300: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1301:
1302: -- Initialize API return status to success
1303:
1304: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1306:
1307: IF (p_fulfill_electronic_rec.requestor_id IS NULL)
1308: THEN
1309: l_Error_Msg := 'Must pass p_user_id parameter';
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_USER_ID');
1313: FND_MSG_PUB.Add;
1314: END IF; -- FND_MSG_PUB.check_msg_level

Line 1313: FND_MSG_PUB.Add;

1309: l_Error_Msg := 'Must pass p_user_id parameter';
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_USER_ID');
1313: FND_MSG_PUB.Add;
1314: END IF; -- FND_MSG_PUB.check_msg_level
1315: RAISE FND_API.G_EXC_ERROR;
1316:
1317: -- Check if the Content_XML is NULL

Line 1314: END IF; -- FND_MSG_PUB.check_msg_level

1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_USER_ID');
1313: FND_MSG_PUB.Add;
1314: END IF; -- FND_MSG_PUB.check_msg_level
1315: RAISE FND_API.G_EXC_ERROR;
1316:
1317: -- Check if the Content_XML is NULL
1318: ELSIF(fm_pvt_rec.content_XML IS NULL) -- IF (p_user_id IS NULL

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

1317: -- Check if the Content_XML is NULL
1318: ELSIF(fm_pvt_rec.content_XML IS NULL) -- IF (p_user_id IS NULL
1319: THEN
1320: l_Error_Msg := 'Must pass a valid Content_XML parameter';
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1322: THEN
1323: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
1324: FND_MSG_PUB.Add;
1325: END IF; -- IF FND_MSG_PUB.check_msg_level

Line 1324: FND_MSG_PUB.Add;

1320: l_Error_Msg := 'Must pass a valid Content_XML parameter';
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1322: THEN
1323: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
1324: FND_MSG_PUB.Add;
1325: END IF; -- IF FND_MSG_PUB.check_msg_level
1326: RAISE FND_API.G_EXC_ERROR;
1327:
1328: ELSIF(fm_pvt_rec.request_id IS NULL) -- IF (p_user_id IS NULL

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

1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1322: THEN
1323: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
1324: FND_MSG_PUB.Add;
1325: END IF; -- IF FND_MSG_PUB.check_msg_level
1326: RAISE FND_API.G_EXC_ERROR;
1327:
1328: ELSIF(fm_pvt_rec.request_id IS NULL) -- IF (p_user_id IS NULL
1329: THEN

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

1327:
1328: ELSIF(fm_pvt_rec.request_id IS NULL) -- IF (p_user_id IS NULL
1329: THEN
1330: l_Error_Msg := 'Must pass p_request_id parameter';
1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1332: THEN
1333: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
1334: FND_MSG_PUB.Add;
1335: END IF; -- IF FND_MSG_PUB.check_msg_level

Line 1334: FND_MSG_PUB.Add;

1330: l_Error_Msg := 'Must pass p_request_id parameter';
1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1332: THEN
1333: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
1334: FND_MSG_PUB.Add;
1335: END IF; -- IF FND_MSG_PUB.check_msg_level
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSE -- IF (p_user_id IS NULL)
1338: OPEN CREQID;

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

1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1332: THEN
1333: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
1334: FND_MSG_PUB.Add;
1335: END IF; -- IF FND_MSG_PUB.check_msg_level
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSE -- IF (p_user_id IS NULL)
1338: OPEN CREQID;
1339: FETCH CREQID INTO l_count;

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

1342: THEN
1343: l_Error_Msg := 'A request with the request_id passed already'
1344: || 'exists in the JTF_FM_REQUEST_HISTORY table';
1345:
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1347: THEN
1348: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_REQUESTID_REUSED');
1349: FND_MSG_PUB.Add;
1350: END IF; -- IF FND_MSG_PUB.check_msg_level

Line 1349: FND_MSG_PUB.Add;

1345:
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1347: THEN
1348: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_REQUESTID_REUSED');
1349: FND_MSG_PUB.Add;
1350: END IF; -- IF FND_MSG_PUB.check_msg_level
1351:
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF; -- IF l_count >= 1

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

1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1347: THEN
1348: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_REQUESTID_REUSED');
1349: FND_MSG_PUB.Add;
1350: END IF; -- IF FND_MSG_PUB.check_msg_level
1351:
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF; -- IF l_count >= 1
1354:

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

1801:
1802: -- END IF; -- IF (l_request_queue is NULL)
1803: END IF; -- IF (p_user_id IS NULL)
1804:
1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1806: THEN
1807: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
1808: FND_MESSAGE.Set_Token('ARG1', l_full_name);
1809: FND_MSG_PUB.Add;

Line 1809: FND_MSG_PUB.Add;

1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1806: THEN
1807: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
1808: FND_MESSAGE.Set_Token('ARG1', l_full_name);
1809: FND_MSG_PUB.Add;
1810: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1811:
1812: --Standard check of commit
1813:

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

1806: THEN
1807: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
1808: FND_MESSAGE.Set_Token('ARG1', l_full_name);
1809: FND_MSG_PUB.Add;
1810: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1811:
1812: --Standard check of commit
1813:
1814: IF FND_API.To_Boolean(p_commit)

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

1816: COMMIT WORK;
1817: END IF; -- IF FND_API.To_Boolean
1818:
1819: -- Debug Message
1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1821: THEN
1822: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1823: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
1824: FND_MSG_PUB.Add;

Line 1824: FND_MSG_PUB.Add;

1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1821: THEN
1822: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1823: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
1824: FND_MSG_PUB.Add;
1825: END IF; -- IF FND_MSG.PUB.Check_Msg_level
1826:
1827: --Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

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

1821: THEN
1822: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1823: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
1824: FND_MSG_PUB.Add;
1825: END IF; -- IF FND_MSG.PUB.Check_Msg_level
1826:
1827: --Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1829: p_count => x_msg_count,

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

1824: FND_MSG_PUB.Add;
1825: END IF; -- IF FND_MSG.PUB.Check_Msg_level
1826:
1827: --Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1829: p_count => x_msg_count,
1830: p_data => x_msg_data
1831: );
1832: EXCEPTION

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

1837: ROLLBACK TO FM_SUBMIT_REQ_V1;
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data
1844: );
1845: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

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

1851: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||
1853: l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1854: -- Standard call to get message count and if count=1, get the message
1855: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1856: p_count => x_msg_count,
1857: p_data => x_msg_data
1858: );
1859: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

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

1863: ROLLBACK TO FM_SUBMIT_REQ_V1;
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1868: THEN
1869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1870: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1871:

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

1865: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1868: THEN
1869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1870: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1871:
1872: -- Standard call to get message count and if count=1, get the message
1873: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1868: THEN
1869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1870: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1871:
1872: -- Standard call to get message count and if count=1, get the message
1873: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1874: p_count => x_msg_count,

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

1869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1870: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1871:
1872: -- Standard call to get message count and if count=1, get the message
1873: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data
1876: );
1877: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);