APPS.IBE_DSP_SECTION_ITEM_PVT dependencies on FND_MESSAGE

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

270: -- do nothing
271: NULL;
272:
273: WHEN OTHERS THEN
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;

Line 275: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

271: NULL;
272:
273: WHEN OTHERS THEN
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:

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

272:
273: WHEN OTHERS THEN
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;

Line 277: FND_MESSAGE.Set_Token('REASON', SQLERRM);

273: WHEN OTHERS THEN
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:

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

300: p_data => x_msg_data,
301: p_encoded => 'F');
302:
303: WHEN OTHERS THEN
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;

Line 305: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

301: p_encoded => 'F');
302:
303: WHEN OTHERS THEN
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:

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

302:
303: WHEN OTHERS THEN
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;

Line 307: FND_MESSAGE.Set_Token('REASON', SQLERRM);

303: WHEN OTHERS THEN
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:

Line 389: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_ID');

385: -- section id
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:

Line 398: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ITEM_ID');

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

Line 407: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ORG_ID');

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

Line 416: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

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

Line 430: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');

426: IF ((p_sort_order IS NOT NULL) AND
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;

Line 447: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');

443: SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b
444: WHERE section_id = p_section_id;
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

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

444: WHERE section_id = p_section_id;
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');

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

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);
454: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
455: FND_MESSAGE.Set_Token('REASON', SQLERRM);
456: FND_MSG_PUB.Add;

Line 453: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
454: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
455: FND_MESSAGE.Set_Token('REASON', SQLERRM);
456: FND_MSG_PUB.Add;
457:

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

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);
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');

Line 455: FND_MESSAGE.Set_Token('REASON', SQLERRM);

451: WHEN OTHERS THEN
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);

Line 458: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');

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;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END;

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

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;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END;
463:

Line 479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_INV_ITEM_ID');

475: AND organization_id = p_organization_id;
476:
477: EXCEPTION
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;

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

476:
477: EXCEPTION
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

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

477: EXCEPTION
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');

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

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);
487: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
488: FND_MESSAGE.Set_Token('REASON', SQLERRM);
489: FND_MSG_PUB.Add;

Line 486: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
487: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
488: FND_MESSAGE.Set_Token('REASON', SQLERRM);
489: FND_MSG_PUB.Add;
490:

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

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);
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');

Line 488: FND_MESSAGE.Set_Token('REASON', SQLERRM);

484: WHEN OTHERS THEN
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);

Line 491: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_INV_ITEM_ID');

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);
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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);
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END;

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

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);
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END;
497:

Line 512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');

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

Line 529: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_HAS_CHILD_SCT');

525: -- OPEN c1(p_section_id);
526: OPEN c1(p_section_id, l_master_mini_site_id);
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;

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

526: OPEN c1(p_section_id, l_master_mini_site_id);
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;

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

548: p_data => x_msg_data,
549: p_encoded => 'F');
550:
551: WHEN OTHERS THEN
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;

Line 553: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

549: p_encoded => 'F');
550:
551: WHEN OTHERS THEN
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:

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

550:
551: WHEN OTHERS THEN
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;

Line 555: FND_MESSAGE.Set_Token('REASON', SQLERRM);

551: WHEN OTHERS THEN
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:

Line 620: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_PRIMARY_KEY');

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

Line 627: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

623: END IF;
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:

Line 641: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');

637: IF ((p_sort_order IS NOT NULL) AND
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;

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

658: p_data => x_msg_data,
659: p_encoded => 'F');
660:
661: WHEN OTHERS THEN
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;

Line 663: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

659: p_encoded => 'F');
660:
661: WHEN OTHERS THEN
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:

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

660:
661: WHEN OTHERS THEN
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;

Line 665: FND_MESSAGE.Set_Token('REASON', SQLERRM);

661: WHEN OTHERS THEN
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:

Line 763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');

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

Line 794: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');

790: x_section_item_id
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');

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

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);
800: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
801: FND_MESSAGE.Set_Token('REASON', SQLERRM);
802: FND_MSG_PUB.Add;

Line 799: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
800: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
801: FND_MESSAGE.Set_Token('REASON', SQLERRM);
802: FND_MSG_PUB.Add;
803:

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

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);
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');

Line 801: FND_MESSAGE.Set_Token('REASON', SQLERRM);

797: WHEN OTHERS THEN
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;

Line 804: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');

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;
807: END;
808:

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

847:
848: WHEN OTHERS THEN
849: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
850:
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;

Line 852: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

848: WHEN OTHERS THEN
849: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
850:
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:

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

849: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
850:
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;

Line 854: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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

Line 954: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');

950: AND organization_id = p_organization_id;
951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN
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;

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

951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN
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;

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

952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN
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

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

953: WHEN NO_DATA_FOUND THEN
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');

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

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);
963: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
964: FND_MESSAGE.Set_Token('REASON', SQLERRM);
965: FND_MSG_PUB.Add;

Line 962: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
963: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
964: FND_MESSAGE.Set_Token('REASON', SQLERRM);
965: FND_MSG_PUB.Add;
966:

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

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);
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');

Line 964: FND_MESSAGE.Set_Token('REASON', SQLERRM);

960: WHEN OTHERS THEN
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);

Line 967: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');

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);
970: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
971: FND_MSG_PUB.Add;

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

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);
970: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
971: FND_MSG_PUB.Add;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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);
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;

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

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

Line 978: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');

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

Line 1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');

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

Line 1026: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');

1022: FND_GLOBAL.login_id
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');

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

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);
1032: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1033: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1034: FND_MSG_PUB.Add;

Line 1031: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
1032: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1033: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1034: FND_MSG_PUB.Add;
1035:

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

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);
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');

Line 1033: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1029: WHEN OTHERS THEN
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;

Line 1036: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');

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;
1039: END;
1040:

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

1069:
1070: WHEN OTHERS THEN
1071: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1072:
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;

Line 1074: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1070: WHEN OTHERS THEN
1071: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1072:
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:

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

1071: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1072:
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;

Line 1076: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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

Line 1168: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SI_ID');

1164: OPEN c2(l_section_item_id);
1165: FETCH c2 INTO l_section_id, l_inventory_item_id, l_organization_id;
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;

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

1165: FETCH c2 INTO l_section_id, l_inventory_item_id, l_organization_id;
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;

Line 1198: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');

1194: AND organization_id = p_organization_id;
1195:
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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;

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

1195:
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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;

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

1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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

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

1197: WHEN NO_DATA_FOUND THEN
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');

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

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);
1207: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1208: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1209: FND_MSG_PUB.Add;

Line 1206: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
1207: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1208: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1209: FND_MSG_PUB.Add;
1210:

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

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);
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');

Line 1208: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1204: WHEN OTHERS THEN
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);

Line 1211: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_ID');

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);
1214: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1215: FND_MSG_PUB.Add;

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

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);
1214: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1215: FND_MSG_PUB.Add;
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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);
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;

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

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

Line 1222: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');

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

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

1284: IF (p_call_from_trigger = FALSE) THEN
1285: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1286: END IF;
1287:
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;

Line 1289: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1285: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1286: END IF;
1287:
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:

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

1286: END IF;
1287:
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;

Line 1291: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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

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

1500:
1501: WHEN OTHERS THEN
1502: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1503:
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;

Line 1505: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1501: WHEN OTHERS THEN
1502: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1503:
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:

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

1502: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1503:
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;

Line 1507: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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