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_MSG_PUB

Line 244: FND_MSG_PUB.initialize;

240: BEGIN
241:
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean(p_init_msg_list) THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: -- Initialize API return status to error, i.e, its not duplicate
248: x_return_status := FND_API.G_RET_STS_ERROR;

Line 280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

276: EXCEPTION
277:
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => 'F');
283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

282: p_encoded => 'F');
283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => 'F');
289:
290: WHEN OTHERS THEN

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

289:
290: WHEN OTHERS THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
296: END IF;
297:

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

291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
296: END IF;
297:
298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
299: p_data => x_msg_data,

Line 298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

294: THEN
295: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
296: END IF;
297:
298: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => 'F');
301:
302: END Check_Duplicate_Entry;

Line 350: FND_MSG_PUB.initialize;

346: BEGIN
347:
348: -- Initialize message list if p_init_msg_list is set to TRUE.
349: IF FND_API.to_Boolean(p_init_msg_list) THEN
350: FND_MSG_PUB.initialize;
351: END IF;
352:
353: -- Initialize API return status to success
354: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 365: FND_MSG_PUB.Add;

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:
369: -- inventory item id

Line 374: FND_MSG_PUB.Add;

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:
378: -- organization id

Line 383: FND_MSG_PUB.Add;

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:
387: -- start_date_active

Line 392: FND_MSG_PUB.Add;

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

Line 406: FND_MSG_PUB.Add;

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

Line 424: FND_MSG_PUB.Add;

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');
428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

Line 429: 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:
433: -- inventory item id and organization id

Line 451: FND_MSG_PUB.Add;

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');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

Line 457: FND_MSG_PUB.Add;

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:
461: -- Validate if the entry is duplicate

Line 476: FND_MSG_PUB.Add;

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

Line 489: FND_MSG_PUB.Add;

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;
493: CLOSE c1;

Line 499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => 'F');
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

501: p_encoded => 'F');
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
506: p_data => x_msg_data,
507: p_encoded => 'F');
508:
509: WHEN OTHERS THEN

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

508:
509: WHEN OTHERS THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
515: END IF;
516:

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

510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
515: END IF;
516:
517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
518: p_data => x_msg_data,

Line 517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

513: THEN
514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
515: END IF;
516:
517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
518: p_data => x_msg_data,
519: p_encoded => 'F');
520:
521: END Validate_Create;

Line 560: FND_MSG_PUB.initialize;

556: BEGIN
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE.
559: IF FND_API.to_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Initialize API return status to success
564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 573: FND_MSG_PUB.Add;

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:
577: -- start_date_active

Line 580: FND_MSG_PUB.Add;

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

Line 594: FND_MSG_PUB.Add;

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

Line 603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

599: EXCEPTION
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => 'F');
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

605: p_encoded => 'F');
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => 'F');
612:
613: WHEN OTHERS THEN

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

612:
613: WHEN OTHERS THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:

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

614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:
621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
622: p_data => x_msg_data,

Line 621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:
621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => 'F');
624:
625: END Validate_Update;

Line 675: FND_MSG_PUB.initialize;

671: END IF;
672:
673: -- Initialize message list if p_init_msg_list is set to TRUE.
674: IF FND_API.to_Boolean(p_init_msg_list) THEN
675: FND_MSG_PUB.initialize;
676: END IF;
677:
678: -- Initialize API return status to success
679: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 710: FND_MSG_PUB.Add;

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

Line 740: FND_MSG_PUB.Add;

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');
744: FND_MSG_PUB.Add;

Line 744: FND_MSG_PUB.Add;

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

Line 766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

762: COMMIT WORK;
763: END IF;
764:
765: -- Standard call to get message count and if count is 1, get message info.
766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => 'F');
769:
770: EXCEPTION

Line 775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
776: p_data => x_msg_data,
777: p_encoded => 'F');
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
783: p_data => x_msg_data,
784: p_encoded => 'F');
785:
786: WHEN OTHERS THEN

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

786: WHEN OTHERS THEN
787: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794:

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

788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794:
795: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
796: p_data => x_msg_data,

Line 795: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

791: THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794:
795: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
796: p_data => x_msg_data,
797: p_encoded => 'F');
798:
799: END Create_Section_Item;

Line 845: FND_MSG_PUB.initialize;

841: END IF;
842:
843: -- Initialize message list if p_init_msg_list is set to TRUE.
844: IF FND_API.to_Boolean(p_init_msg_list) THEN
845: FND_MSG_PUB.initialize;
846: END IF;
847:
848: -- Initialize API return status to success
849: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 888: FND_MSG_PUB.Add;

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');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

Line 895: FND_MSG_PUB.Add;

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

Line 903: FND_MSG_PUB.Add;

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

Line 929: FND_MSG_PUB.Add;

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:
933: -- 2. update row

Line 950: FND_MSG_PUB.Add;

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');
954: FND_MSG_PUB.Add;

Line 954: FND_MSG_PUB.Add;

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

Line 967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

963: COMMIT WORK;
964: END IF;
965:
966: -- Standard call to get message count and if count is 1, get message info.
967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
968: p_data => x_msg_data,
969: p_encoded => 'F');
970:
971: EXCEPTION

Line 976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

972:
973: WHEN FND_API.G_EXC_ERROR THEN
974: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => 'F');
979:
980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

979:
980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
981: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
984: p_data => x_msg_data,
985: p_encoded => 'F');
986:
987: WHEN OTHERS THEN

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

987: WHEN OTHERS THEN
988: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990:
991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
994: END IF;
995:

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

989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990:
991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
994: END IF;
995:
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
997: p_data => x_msg_data,

Line 996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

992: THEN
993: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
994: END IF;
995:
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
997: p_data => x_msg_data,
998: p_encoded => 'F');
999:
1000: END Update_Section_Item;

Line 1054: FND_MSG_PUB.initialize;

1050: END IF;
1051:
1052: -- Initialize message list if p_init_msg_list is set to TRUE.
1053: IF FND_API.to_Boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: -- Initialize API return status to success
1058: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1079: FND_MSG_PUB.Add;

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

Line 1111: FND_MSG_PUB.Add;

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');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

Line 1118: FND_MSG_PUB.Add;

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

Line 1126: FND_MSG_PUB.Add;

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:
1130: -- delete from jtf_dsp_msite_sct_items table

Line 1173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1169: IF (p_call_from_trigger = FALSE) THEN
1170: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1174: p_data => x_msg_data,
1175: p_encoded => 'F');
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1178: IF (p_call_from_trigger = FALSE) THEN
1179: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1180: END IF;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1183: p_data => x_msg_data,
1184: p_encoded => 'F');
1185:
1186: WHEN OTHERS THEN

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

1189: END IF;
1190:
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192:
1193: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1194: THEN
1195: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1196: END IF;
1197:

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

1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192:
1193: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1194: THEN
1195: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1196: END IF;
1197:
1198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1199: p_data => x_msg_data,

Line 1198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1194: THEN
1195: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1196: END IF;
1197:
1198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1199: p_data => x_msg_data,
1200: p_encoded => 'F');
1201:
1202: END Delete_Section_Item;

Line 1294: FND_MSG_PUB.initialize;

1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1371: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1367: COMMIT WORK;
1368: END IF;
1369:
1370: -- Standard call to get message count and if count is 1, get message info.
1371: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1372: p_data => x_msg_data,
1373: p_encoded => 'F');
1374:
1375: EXCEPTION

Line 1380: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1376:
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1381: p_data => x_msg_data,
1382: p_encoded => 'F');
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1388: p_data => x_msg_data,
1389: p_encoded => 'F');
1390:
1391: WHEN OTHERS THEN

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

1391: WHEN OTHERS THEN
1392: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1398: END IF;
1399:

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

1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1398: END IF;
1399:
1400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1401: p_data => x_msg_data,

Line 1400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1396: THEN
1397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1398: END IF;
1399:
1400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1401: p_data => x_msg_data,
1402: p_encoded => 'F');
1403:
1404: END Update_Delete_Sct_Itms;