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

Line 364: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_ID');

360: -- section id
361: IF ((p_section_id IS NULL) OR
362: (p_section_id = FND_API.G_MISS_NUM))
363: THEN
364: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_ID');
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:

Line 373: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ITEM_ID');

369: -- inventory item id
370: IF ((p_inventory_item_id IS NULL) OR
371: (p_inventory_item_id = FND_API.G_MISS_NUM))
372: THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ITEM_ID');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:

Line 382: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ORG_ID');

378: -- organization id
379: IF ((p_organization_id IS NULL) OR
380: (p_organization_id = FND_API.G_MISS_NUM))
381: THEN
382: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ORG_ID');
383: FND_MSG_PUB.Add;
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:

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

387: -- start_date_active
388: IF ((p_start_date_active IS NULL) OR
389: (p_start_date_active = FND_API.G_MISS_DATE))
390: THEN
391: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
392: FND_MSG_PUB.Add;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:

Line 405: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');

401: IF ((p_sort_order IS NOT NULL) AND
402: (p_sort_order <> FND_API.G_MISS_NUM))
403: THEN
404: IF(p_sort_order < 0) THEN
405: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409: END IF;

Line 422: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');

418: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b
419: WHERE section_id = p_section_id;
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
423: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: WHEN OTHERS THEN

Line 423: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

419: WHERE section_id = p_section_id;
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
423: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: WHEN OTHERS THEN
427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

Line 427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

423: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: WHEN OTHERS THEN
427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END;

Line 428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: WHEN OTHERS THEN
427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END;
432:

Line 448: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_INV_ITEM_ID');

444: AND organization_id = p_organization_id;
445:
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_INV_ITEM_ID');
449: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;

Line 449: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

445:
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_INV_ITEM_ID');
449: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN

Line 450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_INV_ITEM_ID');
449: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');

Line 454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');

450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END;

Line 456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END;
460:

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

471:
472: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
478: END IF;
479:

Line 487: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_HAS_CHILD_SCT');

483: --
484: OPEN c1(p_section_id);
485: FETCH c1 INTO l_tmp_id;
486: IF (c1%FOUND) THEN
487: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_HAS_CHILD_SCT');
488: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
489: FND_MSG_PUB.Add;
490: CLOSE c1;
491: RAISE FND_API.G_EXC_ERROR;

Line 488: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

484: OPEN c1(p_section_id);
485: FETCH c1 INTO l_tmp_id;
486: IF (c1%FOUND) THEN
487: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_HAS_CHILD_SCT');
488: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
489: FND_MSG_PUB.Add;
490: CLOSE c1;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

Line 572: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_PRIMARY_KEY');

568: --
569:
570: -- section_item_id
571: IF (p_section_item_id IS NULL) THEN
572: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_PRIMARY_KEY');
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:

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

575: END IF;
576:
577: -- start_date_active
578: IF (p_start_date_active IS NULL) THEN
579: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
580: FND_MSG_PUB.Add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:

Line 593: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');

589: IF ((p_sort_order IS NOT NULL) AND
590: (p_sort_order <> FND_API.G_MISS_NUM))
591: THEN
592: IF(p_sort_order < 0) THEN
593: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
594: FND_MSG_PUB.Add;
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597: END IF;

Line 709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');

705:
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR; -- invalid
712: END IF;
713:

Line 739: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');

735: x_section_item_id
736: );
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');

Line 743: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');

739: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
744: FND_MSG_PUB.Add;
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: END;
747:

Line 884: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

880: AND organization_id = p_organization_id;
881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;

Line 885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;

Line 886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN

Line 887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

883: WHEN NO_DATA_FOUND THEN
884: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

Line 891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
895: FND_MSG_PUB.Add;

Line 892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END;

Line 894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END;
898:

Line 902: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');

898:
899: ELSE
900: -- neither section_item_id nor combination of
901: -- section_id, inventory_item_id and organization_id is specified
902: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');
903: FND_MSG_PUB.Add;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:

Line 928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');

924:
925: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR; -- invalid
931: END IF;
932:

Line 949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');

945: FND_GLOBAL.login_id
946: );
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
950: FND_MSG_PUB.Add;
951: RAISE FND_API.G_EXC_ERROR;
952: WHEN OTHERS THEN
953: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');

Line 953: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');

949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
950: FND_MSG_PUB.Add;
951: RAISE FND_API.G_EXC_ERROR;
952: WHEN OTHERS THEN
953: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956: END;
957:

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

1073: OPEN c2(l_section_item_id);
1074: FETCH c2 INTO l_section_id, l_inventory_item_id, l_organization_id;
1075: IF (c2%NOTFOUND) THEN
1076: CLOSE c2;
1077: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
1078: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);
1079: FND_MSG_PUB.Add;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;

Line 1078: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);

1074: FETCH c2 INTO l_section_id, l_inventory_item_id, l_organization_id;
1075: IF (c2%NOTFOUND) THEN
1076: CLOSE c2;
1077: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
1078: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);
1079: FND_MSG_PUB.Add;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: CLOSE c2;

Line 1107: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

1103: AND organization_id = p_organization_id;
1104:
1105: EXCEPTION
1106: WHEN NO_DATA_FOUND THEN
1107: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;

Line 1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

1104:
1105: EXCEPTION
1106: WHEN NO_DATA_FOUND THEN
1107: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;

Line 1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

1105: EXCEPTION
1106: WHEN NO_DATA_FOUND THEN
1107: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN

Line 1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

1106: WHEN NO_DATA_FOUND THEN
1107: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

Line 1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');

1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1118: FND_MSG_PUB.Add;

Line 1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1118: FND_MSG_PUB.Add;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1118: FND_MSG_PUB.Add;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END;

Line 1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1118: FND_MSG_PUB.Add;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END;
1121:

Line 1125: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');

1121:
1122: ELSE
1123: -- neither section_item_id nor combination of
1124: -- section_id, inventory_item_id and organization_id is specified
1125: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: