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_DSP_MSITE_SCT_ITEM_PVT dependencies on FND_MESSAGE

Line 335: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');

331: -- mini site id
332: IF ((p_mini_site_id IS NULL) OR
333: (p_mini_site_id = FND_API.G_MISS_NUM))
334: THEN
335: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
336: FND_MSG_PUB.Add;
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:

Line 344: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SI_ID');

340: -- section item id
341: IF ((p_section_item_id IS NULL) OR
342: (p_section_item_id = FND_API.G_MISS_NUM))
343: THEN
344: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SI_ID');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:

Line 353: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

349: -- start_date_active
350: IF ((p_start_date_active IS NULL) OR
351: (p_start_date_active = FND_API.G_MISS_DATE))
352: THEN
353: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
354: FND_MSG_PUB.Add;
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357:

Line 369: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');

365: SELECT msite_id INTO l_mini_site_id FROM jtf_msites_b
366: WHERE msite_id = p_mini_site_id;
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
370: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
371: FND_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN

Line 370: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

366: WHERE msite_id = p_mini_site_id;
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
370: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
371: FND_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');

Line 374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');

370: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
371: FND_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
375: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END;

Line 375: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

371: FND_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
375: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
376: FND_MSG_PUB.Add;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END;
379:

Line 387: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SI_ID');

383: SELECT section_item_id INTO l_section_item_id FROM jtf_dsp_section_items
384: WHERE section_item_id = p_section_item_id;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SI_ID');
388: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN

Line 388: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

384: WHERE section_item_id = p_section_item_id;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SI_ID');
388: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN
392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');

Line 392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');

388: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN
392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
393: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
394: FND_MSG_PUB.Add;
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END;

Line 393: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: WHEN OTHERS THEN
392: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
393: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
394: FND_MSG_PUB.Add;
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END;
397:

Line 409: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');

405:
406: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
409: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
410: FND_MSG_PUB.Add;
411: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
412: END IF;
413:

Line 488: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');

484: --
485:
486: -- mini_site_section_item_id
487: IF (p_mini_site_section_item_id IS NULL) THEN
488: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');
489: FND_MSG_PUB.Add;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:

Line 495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

491: END IF;
492:
493: -- start_date_active
494: IF (p_start_date_active IS NULL) THEN
495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:

Line 606: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_CREATE');

602:
603: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
606: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_CREATE');
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR; -- invalid
609: END IF;
610:

Line 633: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');

629: x_mini_site_section_item_id
630: );
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_ERROR;
636: WHEN OTHERS THEN
637: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');

Line 637: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');

633: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_ERROR;
636: WHEN OTHERS THEN
637: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INSERT_FAIL');
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END;
641:

Line 666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

662: p_encoded => 'F');
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');
668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;

Line 667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');

663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');
668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');
668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);

665: ROLLBACK TO CREATE_MSITE_SCT_ITEM_PVT;
666: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
667: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || 'xxx');
668: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
669: FND_MESSAGE.Set_Token('REASON', p_mini_site_id || ':' || p_section_item_id);
670: FND_MSG_PUB.Add;
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 769: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

765: AND section_item_id = p_section_item_id;
766:
767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
770: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;

Line 770: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

766:
767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
770: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN

Line 771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
770: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

Line 775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

771: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
777: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
778: FND_MSG_PUB.Add;
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
777: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
778: FND_MSG_PUB.Add;
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: END;

Line 777: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

773: RAISE FND_API.G_EXC_ERROR;
774: WHEN OTHERS THEN
775: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
776: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
777: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
778: FND_MSG_PUB.Add;
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: END;
781: ELSE

Line 784: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');

780: END;
781: ELSE
782: -- neither mini_site_section_item_id nor combination of
783: -- mini_site_id and section_item_id is specified
784: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');
785: FND_MSG_PUB.Add;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:

Line 808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_UPDATE');

804:
805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_INVALID_UPDATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid
811: END IF;
812:

Line 827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');

823: FND_GLOBAL.login_id
824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: WHEN OTHERS THEN
831: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');

Line 831: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');

827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: WHEN OTHERS THEN
831: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:

Line 951: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

947: AND section_item_id = p_section_item_id;
948:
949: EXCEPTION
950: WHEN NO_DATA_FOUND THEN
951: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
952: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;

Line 952: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

948:
949: EXCEPTION
950: WHEN NO_DATA_FOUND THEN
951: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
952: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN

Line 953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

949: EXCEPTION
950: WHEN NO_DATA_FOUND THEN
951: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
952: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

Line 957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');

953: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
959: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
960: FND_MSG_PUB.Add;
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
959: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
960: FND_MSG_PUB.Add;
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END;

Line 959: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);

955: RAISE FND_API.G_EXC_ERROR;
956: WHEN OTHERS THEN
957: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_ID');
958: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
959: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', p_section_item_id);
960: FND_MSG_PUB.Add;
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END;
963:

Line 967: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');

963:
964: ELSE
965: -- neither mini_site_section_item_id nor combination of
966: -- mini_site_id and section_item_id is specified
967: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSI_IDS_SPEC');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: