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.IBE_DSP_SECTION_ITEM_PVT dependencies on FND_MSG_PUB

Line 251: FND_MSG_PUB.initialize;

247: BEGIN
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: -- Initialize API return status to error, i.e, its not duplicate
255: x_return_status := FND_API.G_RET_STS_ERROR;

Line 278: FND_MSG_PUB.Add;

274: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
275: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
276: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
277: FND_MESSAGE.Set_Token('REASON', SQLERRM);
278: FND_MSG_PUB.Add;
279:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281:
282: END;

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

289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => 'F');
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

295: p_encoded => 'F');
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => 'F');
302:
303: WHEN OTHERS THEN

Line 308: FND_MSG_PUB.Add;

304: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
305: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
306: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
307: FND_MESSAGE.Set_Token('REASON', SQLERRM);
308: FND_MSG_PUB.Add;
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

308: FND_MSG_PUB.Add;
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
315: END IF;
316:

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

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
315: END IF;
316:
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data,

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

313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
315: END IF;
316:
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data,
319: p_encoded => 'F');
320:
321: END Check_Duplicate_Entry;

Line 375: FND_MSG_PUB.initialize;

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

Line 390: FND_MSG_PUB.Add;

386: IF ((p_section_id IS NULL) OR
387: (p_section_id = FND_API.G_MISS_NUM))
388: THEN
389: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_ID');
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- inventory item id

Line 399: FND_MSG_PUB.Add;

395: IF ((p_inventory_item_id IS NULL) OR
396: (p_inventory_item_id = FND_API.G_MISS_NUM))
397: THEN
398: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ITEM_ID');
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402:
403: -- organization id

Line 408: FND_MSG_PUB.Add;

404: IF ((p_organization_id IS NULL) OR
405: (p_organization_id = FND_API.G_MISS_NUM))
406: THEN
407: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ORG_ID');
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:
412: -- start_date_active

Line 417: FND_MSG_PUB.Add;

413: IF ((p_start_date_active IS NULL) OR
414: (p_start_date_active = FND_API.G_MISS_DATE))
415: THEN
416: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: --

Line 431: FND_MSG_PUB.Add;

427: (p_sort_order <> FND_API.G_MISS_NUM))
428: THEN
429: IF(p_sort_order < 0) THEN
430: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
431: FND_MSG_PUB.Add;
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434: END IF;
435:

Line 449: FND_MSG_PUB.Add;

445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
447: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
448: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
449: FND_MSG_PUB.Add;
450: RAISE FND_API.G_EXC_ERROR;
451: WHEN OTHERS THEN
452: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
453: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 456: FND_MSG_PUB.Add;

452: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
453: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
454: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
455: FND_MESSAGE.Set_Token('REASON', SQLERRM);
456: FND_MSG_PUB.Add;
457:
458: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
459: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
460: FND_MSG_PUB.Add;

Line 460: FND_MSG_PUB.Add;

456: FND_MSG_PUB.Add;
457:
458: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
459: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
460: FND_MSG_PUB.Add;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END;
463:
464: -- inventory item id and organization id

Line 482: FND_MSG_PUB.Add;

478: WHEN NO_DATA_FOUND THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_INV_ITEM_ID');
480: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
481: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: WHEN OTHERS THEN
485: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
486: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 489: FND_MSG_PUB.Add;

485: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
486: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
487: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
488: FND_MESSAGE.Set_Token('REASON', SQLERRM);
489: FND_MSG_PUB.Add;
490:
491: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_INV_ITEM_ID');
492: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
493: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

Line 494: FND_MSG_PUB.Add;

490:
491: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_INV_ITEM_ID');
492: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
493: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END;
497:
498: -- Validate if the entry is duplicate

Line 513: FND_MSG_PUB.Add;

509: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
515: END IF;
516:
517: --

Line 531: FND_MSG_PUB.Add;

527: FETCH c1 INTO l_tmp_id;
528: IF (c1%FOUND) THEN
529: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_HAS_CHILD_SCT');
530: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
531: FND_MSG_PUB.Add;
532: CLOSE c1;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE c1;

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

537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => 'F');
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

543: p_encoded => 'F');
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
548: p_data => x_msg_data,
549: p_encoded => 'F');
550:
551: WHEN OTHERS THEN

Line 556: FND_MSG_PUB.Add;

552: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
553: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
554: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
555: FND_MESSAGE.Set_Token('REASON', SQLERRM);
556: FND_MSG_PUB.Add;
557:
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

556: FND_MSG_PUB.Add;
557:
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
563: END IF;
564:

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

558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
563: END IF;
564:
565: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
566: p_data => x_msg_data,

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

561: THEN
562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
563: END IF;
564:
565: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
566: p_data => x_msg_data,
567: p_encoded => 'F');
568:
569: END Validate_Create;

Line 608: FND_MSG_PUB.initialize;

604: BEGIN
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean(p_init_msg_list) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- Initialize API return status to success
612: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 621: FND_MSG_PUB.Add;

617:
618: -- section_item_id
619: IF (p_section_item_id IS NULL) THEN
620: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_PRIMARY_KEY');
621: FND_MSG_PUB.Add;
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624:
625: -- start_date_active

Line 628: FND_MSG_PUB.Add;

624:
625: -- start_date_active
626: IF (p_start_date_active IS NULL) THEN
627: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
628: FND_MSG_PUB.Add;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:
632: --

Line 642: FND_MSG_PUB.Add;

638: (p_sort_order <> FND_API.G_MISS_NUM))
639: THEN
640: IF(p_sort_order < 0) THEN
641: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
642: FND_MSG_PUB.Add;
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: END IF;
646:

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

647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

653: p_encoded => 'F');
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
658: p_data => x_msg_data,
659: p_encoded => 'F');
660:
661: WHEN OTHERS THEN

Line 666: FND_MSG_PUB.Add;

662: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
663: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
664: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
665: FND_MESSAGE.Set_Token('REASON', SQLERRM);
666: FND_MSG_PUB.Add;
667:
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

666: FND_MSG_PUB.Add;
667:
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
673: END IF;
674:

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

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
673: END IF;
674:
675: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
676: p_data => x_msg_data,

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

671: THEN
672: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
673: END IF;
674:
675: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
676: p_data => x_msg_data,
677: p_encoded => 'F');
678:
679: END Validate_Update;

Line 729: FND_MSG_PUB.initialize;

725: END IF;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: IF FND_API.to_Boolean(p_init_msg_list) THEN
729: FND_MSG_PUB.initialize;
730: END IF;
731:
732: -- Initialize API return status to success
733: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 764: FND_MSG_PUB.Add;

760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');
764: FND_MSG_PUB.Add;
765: RAISE FND_API.G_EXC_ERROR; -- invalid
766: END IF;
767:
768: --

Line 795: FND_MSG_PUB.Add;

791: );
792: EXCEPTION
793: WHEN NO_DATA_FOUND THEN
794: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');
795: FND_MSG_PUB.Add;
796: RAISE FND_API.G_EXC_ERROR;
797: WHEN OTHERS THEN
798: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
799: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 802: FND_MSG_PUB.Add;

798: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
799: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
800: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
801: FND_MESSAGE.Set_Token('REASON', SQLERRM);
802: FND_MSG_PUB.Add;
803:
804: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');
805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 805: FND_MSG_PUB.Add;

801: FND_MESSAGE.Set_Token('REASON', SQLERRM);
802: FND_MSG_PUB.Add;
803:
804: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');
805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END;
808:
809: --

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

824: COMMIT WORK;
825: END IF;
826:
827: -- Standard call to get message count and if count is 1, get message info.
828: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
829: p_data => x_msg_data,
830: p_encoded => 'F');
831:
832: EXCEPTION

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

833:
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
838: p_data => x_msg_data,
839: p_encoded => 'F');
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
845: p_data => x_msg_data,
846: p_encoded => 'F');
847:
848: WHEN OTHERS THEN

Line 855: FND_MSG_PUB.Add;

851: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
852: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
853: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
854: FND_MESSAGE.Set_Token('REASON', SQLERRM);
855: FND_MSG_PUB.Add;
856:
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

855: FND_MSG_PUB.Add;
856:
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
862: END IF;
863:

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

857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
862: END IF;
863:
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
865: p_data => x_msg_data,

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

860: THEN
861: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
862: END IF;
863:
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
865: p_data => x_msg_data,
866: p_encoded => 'F');
867:
868: END Create_Section_Item;

Line 915: FND_MSG_PUB.initialize;

911: END IF;
912:
913: -- Initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(p_init_msg_list) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- Initialize API return status to success
919: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 958: FND_MSG_PUB.Add;

954: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
955: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
956: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
957: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
958: FND_MSG_PUB.Add;
959: RAISE FND_API.G_EXC_ERROR;
960: WHEN OTHERS THEN
961: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
962: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 965: FND_MSG_PUB.Add;

961: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
962: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
963: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
964: FND_MESSAGE.Set_Token('REASON', SQLERRM);
965: FND_MSG_PUB.Add;
966:
967: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
968: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
969: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

Line 971: FND_MSG_PUB.Add;

967: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
968: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
969: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
970: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
971: FND_MSG_PUB.Add;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: END;
974:
975: ELSE

Line 979: FND_MSG_PUB.Add;

975: ELSE
976: -- neither section_item_id nor combination of
977: -- section_id, inventory_item_id and organization_id is specified
978: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
982:
983: --

Line 1005: FND_MSG_PUB.Add;

1001: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');
1005: FND_MSG_PUB.Add;
1006: RAISE FND_API.G_EXC_ERROR; -- invalid
1007: END IF;
1008:
1009: -- 2. update row

Line 1027: FND_MSG_PUB.Add;

1023: );
1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');
1027: FND_MSG_PUB.Add;
1028: RAISE FND_API.G_EXC_ERROR;
1029: WHEN OTHERS THEN
1030: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1031: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1034: FND_MSG_PUB.Add;

1030: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1031: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1032: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1033: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1034: FND_MSG_PUB.Add;
1035:
1036: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');
1037: FND_MSG_PUB.Add;
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1037: FND_MSG_PUB.Add;

1033: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1034: FND_MSG_PUB.Add;
1035:
1036: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');
1037: FND_MSG_PUB.Add;
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END;
1040:
1041: --

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

1046: COMMIT WORK;
1047: END IF;
1048:
1049: -- Standard call to get message count and if count is 1, get message info.
1050: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1051: p_data => x_msg_data,
1052: p_encoded => 'F');
1053:
1054: EXCEPTION

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

1055:
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1060: p_data => x_msg_data,
1061: p_encoded => 'F');
1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => 'F');
1069:
1070: WHEN OTHERS THEN

Line 1077: FND_MSG_PUB.Add;

1073: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1074: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1075: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1076: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1077: FND_MSG_PUB.Add;
1078:
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080:
1081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1077: FND_MSG_PUB.Add;
1078:
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080:
1081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1084: END IF;
1085:

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

1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080:
1081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1084: END IF;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1087: p_data => x_msg_data,

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

1082: THEN
1083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1084: END IF;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1087: p_data => x_msg_data,
1088: p_encoded => 'F');
1089:
1090: END Update_Section_Item;

Line 1145: FND_MSG_PUB.initialize;

1141: END IF;
1142:
1143: -- Initialize message list if p_init_msg_list is set to TRUE.
1144: IF FND_API.to_Boolean(p_init_msg_list) THEN
1145: FND_MSG_PUB.initialize;
1146: END IF;
1147:
1148: -- Initialize API return status to success
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1170: FND_MSG_PUB.Add;

1166: IF (c2%NOTFOUND) THEN
1167: CLOSE c2;
1168: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SI_ID');
1169: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);
1170: FND_MSG_PUB.Add;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173: CLOSE c2;
1174:

Line 1202: FND_MSG_PUB.Add;

1198: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
1199: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1200: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1201: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1206: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1209: FND_MSG_PUB.Add;

1205: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1206: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1207: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1208: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1209: FND_MSG_PUB.Add;
1210:
1211: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
1212: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1213: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

Line 1215: FND_MSG_PUB.Add;

1211: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');
1212: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1213: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1214: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1215: FND_MSG_PUB.Add;
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END;
1218:
1219: ELSE

Line 1223: FND_MSG_PUB.Add;

1219: ELSE
1220: -- neither section_item_id nor combination of
1221: -- section_id, inventory_item_id and organization_id is specified
1222: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');
1223: FND_MSG_PUB.Add;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227: -- delete from ibe_dsp_msite_sct_items table

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

1266: IF (p_call_from_trigger = FALSE) THEN
1267: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1268: END IF;
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1271: p_data => x_msg_data,
1272: p_encoded => 'F');
1273:
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1275: IF (p_call_from_trigger = FALSE) THEN
1276: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1277: END IF;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1280: p_data => x_msg_data,
1281: p_encoded => 'F');
1282:
1283: WHEN OTHERS THEN

Line 1292: FND_MSG_PUB.Add;

1288: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1289: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1290: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1291: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1292: FND_MSG_PUB.Add;
1293:
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295:
1296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

1292: FND_MSG_PUB.Add;
1293:
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295:
1296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1299: END IF;
1300:

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

1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295:
1296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1299: END IF;
1300:
1301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1302: p_data => x_msg_data,

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

1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1299: END IF;
1300:
1301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1302: p_data => x_msg_data,
1303: p_encoded => 'F');
1304:
1305: END Delete_Section_Item;

Line 1404: FND_MSG_PUB.initialize;

1400: END IF;
1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean(p_init_msg_list) THEN
1404: FND_MSG_PUB.initialize;
1405: END IF;
1406:
1407: -- Initialize API return status to success
1408: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1477: COMMIT WORK;
1478: END IF;
1479:
1480: -- Standard call to get message count and if count is 1, get message info.
1481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1482: p_data => x_msg_data,
1483: p_encoded => 'F');
1484:
1485: EXCEPTION

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

1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1491: p_data => x_msg_data,
1492: p_encoded => 'F');
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1498: p_data => x_msg_data,
1499: p_encoded => 'F');
1500:
1501: WHEN OTHERS THEN

Line 1508: FND_MSG_PUB.Add;

1504: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1505: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1506: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1507: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1508: FND_MSG_PUB.Add;
1509:
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1508: FND_MSG_PUB.Add;
1509:
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1513: THEN
1514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1515: END IF;
1516:

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

1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1513: THEN
1514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1515: END IF;
1516:
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1518: p_data => x_msg_data,

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

1513: THEN
1514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1515: END IF;
1516:
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => 'F');
1520:
1521: END Update_Delete_Sct_Itms;