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_M_AUTOPLACEMENT_PVT dependencies on FND_API

Line 495: p_init_msg_list => FND_API.G_FALSE,

491: printDebuglog('inventory_item_id='||to_char(l_inventory_item_ids(1)));
492: printDebuglog('organization_id='||to_char(l_organization_ids(1)));
493: IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Items_To_Section(
494: p_api_version => 1.0,
495: p_init_msg_list => FND_API.G_FALSE,
496: p_commit => FND_API.G_FALSE,
497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
498: p_section_id => p_section_id,
499: p_inventory_item_ids => l_inventory_item_ids,

Line 496: p_commit => FND_API.G_FALSE,

492: printDebuglog('organization_id='||to_char(l_organization_ids(1)));
493: IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Items_To_Section(
494: p_api_version => 1.0,
495: p_init_msg_list => FND_API.G_FALSE,
496: p_commit => FND_API.G_FALSE,
497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
498: p_section_id => p_section_id,
499: p_inventory_item_ids => l_inventory_item_ids,
500: p_organization_ids => l_organization_ids,

Line 497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

493: IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Items_To_Section(
494: p_api_version => 1.0,
495: p_init_msg_list => FND_API.G_FALSE,
496: p_commit => FND_API.G_FALSE,
497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
498: p_section_id => p_section_id,
499: p_inventory_item_ids => l_inventory_item_ids,
500: p_organization_ids => l_organization_ids,
501: p_start_date_actives => l_start_date_actives,

Line 512: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

508: x_msg_count => l_msg_count,
509: x_msg_data => l_msg_data);
510: printDebuglog('after calling Associate_Items_To_Section:'
511: ||l_return_status);
512: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
513: COMMIT;
514: printDebuglog('Commit the section_item association');
515: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
516: printDebuglog('G_RET_STS_ERROR in Associate_Items_To_Section');

Line 515: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

511: ||l_return_status);
512: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
513: COMMIT;
514: printDebuglog('Commit the section_item association');
515: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
516: printDebuglog('G_RET_STS_ERROR in Associate_Items_To_Section');
517: FOR i IN 1..l_msg_count LOOP
518: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
519: printDebuglog(l_msg_data);

Line 518: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

514: printDebuglog('Commit the section_item association');
515: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
516: printDebuglog('G_RET_STS_ERROR in Associate_Items_To_Section');
517: FOR i IN 1..l_msg_count LOOP
518: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
519: printDebuglog(l_msg_data);
520: END LOOP;
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 521: RAISE FND_API.G_EXC_ERROR;

517: FOR i IN 1..l_msg_count LOOP
518: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
519: printDebuglog(l_msg_data);
520: END LOOP;
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: printDebuglog('G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');
524: FOR i IN 1..l_msg_count LOOP
525: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 522: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

518: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
519: printDebuglog(l_msg_data);
520: END LOOP;
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: printDebuglog('G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');
524: FOR i IN 1..l_msg_count LOOP
525: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
526: printDebuglog(l_msg_data);

Line 525: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: printDebuglog('G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');
524: FOR i IN 1..l_msg_count LOOP
525: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
526: printDebuglog(l_msg_data);
527: END LOOP;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

524: FOR i IN 1..l_msg_count LOOP
525: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
526: printDebuglog(l_msg_data);
527: END LOOP;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: END IF;
531: ELSE
532: printDebuglog('Inventory item id='||to_char(l_inventory_item_id)

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS;

566: l_end_date_actives.delete;
567: l_sort_orders.delete;
568: l_association_reason_codes.delete;
569: x_section_item_ids.delete;
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 572: WHEN FND_API.G_EXC_ERROR THEN

568: l_association_reason_codes.delete;
569: x_section_item_ids.delete;
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data);
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: x_section_item_ids.delete;
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data);
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

572: WHEN FND_API.G_EXC_ERROR THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data);
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
579: p_data => x_msg_data);
580: WHEN OTHERS THEN

Line 577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

573: x_return_status := FND_API.G_RET_STS_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data);
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
579: p_data => x_msg_data);
580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
579: p_data => x_msg_data);
580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
584: END IF;
585: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 730: p_init_msg_list => FND_API.G_FALSE,

726: -- table and IBE_DSP_MSITE_SCT_ITEMS
727: -- For fixing bug 2771549
728: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
729: (p_api_version => 1.0,
730: p_init_msg_list => FND_API.G_FALSE,
731: p_commit => FND_API.G_FALSE,
732: p_section_id => p_section_id,
733: p_inventory_item_id => l_inventory_item_id,
734: p_organization_id => p_organization_id,

Line 731: p_commit => FND_API.G_FALSE,

727: -- For fixing bug 2771549
728: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
729: (p_api_version => 1.0,
730: p_init_msg_list => FND_API.G_FALSE,
731: p_commit => FND_API.G_FALSE,
732: p_section_id => p_section_id,
733: p_inventory_item_id => l_inventory_item_id,
734: p_organization_id => p_organization_id,
735: x_return_status => l_return_status,

Line 738: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

734: p_organization_id => p_organization_id,
735: x_return_status => l_return_status,
736: x_msg_count => l_msg_count,
737: x_msg_data => l_msg_data);
738: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
739: COMMIT;
740: printDebuglog('Commit the delete section_item assoication');
741: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
742: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');

Line 741: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

737: x_msg_data => l_msg_data);
738: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
739: COMMIT;
740: printDebuglog('Commit the delete section_item assoication');
741: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
742: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');
743: printOutput('G_RET_STS_ERROR in Delete_Section_Item');
744: FOR i IN 1..l_msg_count LOOP
745: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 745: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

741: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
742: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');
743: printOutput('G_RET_STS_ERROR in Delete_Section_Item');
744: FOR i IN 1..l_msg_count LOOP
745: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
746: printDebuglog(l_msg_data);
747: printOutput(l_msg_data);
748: END LOOP;
749: RAISE FND_API.G_EXC_ERROR;

Line 749: RAISE FND_API.G_EXC_ERROR;

745: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
746: printDebuglog(l_msg_data);
747: printOutput(l_msg_data);
748: END LOOP;
749: RAISE FND_API.G_EXC_ERROR;
750: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
752: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
753: FOR i IN 1..l_msg_count LOOP

Line 750: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

746: printDebuglog(l_msg_data);
747: printOutput(l_msg_data);
748: END LOOP;
749: RAISE FND_API.G_EXC_ERROR;
750: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
752: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
753: FOR i IN 1..l_msg_count LOOP
754: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 754: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

750: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
752: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
753: FOR i IN 1..l_msg_count LOOP
754: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
755: printDebuglog(l_msg_data);
756: printOutput(l_msg_data);
757: END LOOP;
758: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 758: raise FND_API.G_EXC_UNEXPECTED_ERROR;

754: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
755: printDebuglog(l_msg_data);
756: printOutput(l_msg_data);
757: END LOOP;
758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760: /*
761: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Items_For_Item
762: (p_inventory_item_id => l_inventory_item_id,

Line 775: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

771: -- section
772: add_only(p_mode, p_category_set_id, p_organization_id, p_section_id,
773: p_product_name, p_product_number, p_publish_flag,
774: p_start_date, p_end_date, l_return_status, l_msg_count, l_msg_data);
775: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: printDebuglog('G_RET_STS_ERROR in add_only');
777: printOutput('G_RET_STS_ERROR in add_only');
778: FOR i IN 1..l_msg_count LOOP
779: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 779: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

775: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: printDebuglog('G_RET_STS_ERROR in add_only');
777: printOutput('G_RET_STS_ERROR in add_only');
778: FOR i IN 1..l_msg_count LOOP
779: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
780: printDebuglog(l_msg_data);
781: printOutput(l_msg_data);
782: END LOOP;
783: RAISE FND_API.G_EXC_ERROR;

Line 783: RAISE FND_API.G_EXC_ERROR;

779: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
780: printDebuglog(l_msg_data);
781: printOutput(l_msg_data);
782: END LOOP;
783: RAISE FND_API.G_EXC_ERROR;
784: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
785: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
786: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
787: FOR i IN 1..l_msg_count LOOP

Line 784: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

780: printDebuglog(l_msg_data);
781: printOutput(l_msg_data);
782: END LOOP;
783: RAISE FND_API.G_EXC_ERROR;
784: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
785: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
786: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
787: FOR i IN 1..l_msg_count LOOP
788: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 788: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

784: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
785: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
786: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
787: FOR i IN 1..l_msg_count LOOP
788: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
789: printDebuglog(l_msg_data);
790: printOutput(l_msg_data);
791: END LOOP;
792: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 792: raise FND_API.G_EXC_UNEXPECTED_ERROR;

788: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
789: printDebuglog(l_msg_data);
790: printOutput(l_msg_data);
791: END LOOP;
792: raise FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

790: printOutput(l_msg_data);
791: END LOOP;
792: raise FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: raise FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
799: p_data => x_msg_data);
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: END IF;
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
799: p_data => x_msg_data);
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
799: p_data => x_msg_data);
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN OTHERS THEN

Line 801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
799: p_data => x_msg_data);
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
808: END IF;
809: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 880: RAISE FND_API.G_EXC_ERROR;

876: l_organization_id_str
877: := FND_PROFILE.VALUE_SPECIFIC('IBE_ITEM_VALIDATION_ORGANIZATION',
878: null, null, 671);
879: IF (l_organization_id_str IS NULL) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: ELSE
882: l_organization_id := to_number(l_organization_id_str);
883: END IF;
884: printDebuglog('Organization id='||l_organization_id_str);

Line 923: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

919: l_return_status, l_msg_count, l_msg_data);
920: printDebuglog('after calling add_remove, return status:'||l_return_status);
921: END IF;
922: -- Check status
923: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
924: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
925: printOutput('G_RET_STS_ERROR in add_remove/add_only');
926: FOR i IN 1..l_msg_count LOOP
927: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 927: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

923: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
924: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
925: printOutput('G_RET_STS_ERROR in add_remove/add_only');
926: FOR i IN 1..l_msg_count LOOP
927: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
928: printDebuglog(l_msg_data);
929: printOutput(l_msg_data);
930: END LOOP;
931: RAISE FND_API.G_EXC_ERROR;

Line 931: RAISE FND_API.G_EXC_ERROR;

927: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
928: printDebuglog(l_msg_data);
929: printOutput(l_msg_data);
930: END LOOP;
931: RAISE FND_API.G_EXC_ERROR;
932: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
933: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
934: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
935: FOR i IN 1..l_msg_count LOOP

Line 932: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

928: printDebuglog(l_msg_data);
929: printOutput(l_msg_data);
930: END LOOP;
931: RAISE FND_API.G_EXC_ERROR;
932: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
933: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
934: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
935: FOR i IN 1..l_msg_count LOOP
936: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 936: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

932: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
933: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
934: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
935: FOR i IN 1..l_msg_count LOOP
936: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
937: printDebuglog(l_msg_data);
938: printOutput(l_msg_data);
939: END LOOP;
940: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 940: raise FND_API.G_EXC_UNEXPECTED_ERROR;

936: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
937: printDebuglog(l_msg_data);
938: printOutput(l_msg_data);
939: END LOOP;
940: raise FND_API.G_EXC_UNEXPECTED_ERROR;
941: END IF;
942: -- Commit product autoplacement for each section
943: COMMIT;
944: ELSE

Line 972: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

968: p_publish_flag, p_start_date, p_end_date,
969: l_return_status, l_msg_count, l_msg_data);
970: END IF;
971: -- Check status
972: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
973: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
974: printOutput('G_RET_STS_ERROR in add_remove/add_only');
975: FOR i IN 1..l_msg_count LOOP
976: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 976: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

972: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
973: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
974: printOutput('G_RET_STS_ERROR in add_remove/add_only');
975: FOR i IN 1..l_msg_count LOOP
976: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
977: printDebuglog(l_msg_data);
978: printOutput(l_msg_data);
979: END LOOP;
980: RAISE FND_API.G_EXC_ERROR;

Line 980: RAISE FND_API.G_EXC_ERROR;

976: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
977: printDebuglog(l_msg_data);
978: printOutput(l_msg_data);
979: END LOOP;
980: RAISE FND_API.G_EXC_ERROR;
981: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
983: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
984: FOR i IN 1..l_msg_count LOOP

Line 981: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

977: printDebuglog(l_msg_data);
978: printOutput(l_msg_data);
979: END LOOP;
980: RAISE FND_API.G_EXC_ERROR;
981: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
983: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
984: FOR i IN 1..l_msg_count LOOP
985: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 985: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

981: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
983: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
984: FOR i IN 1..l_msg_count LOOP
985: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
986: printDebuglog(l_msg_data);
987: printOutput(l_msg_data);
988: END LOOP;
989: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 989: raise FND_API.G_EXC_UNEXPECTED_ERROR;

985: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
986: printDebuglog(l_msg_data);
987: printOutput(l_msg_data);
988: END LOOP;
989: raise FND_API.G_EXC_UNEXPECTED_ERROR;
990: END IF;
991: -- Commit product autoplacement for each section
992: COMMIT;
993: ELSE

Line 997: x_return_status := FND_API.G_RET_STS_SUCCESS;

993: ELSE
994: printDebuglog('The target section is not featured or leaf section!');
995: END IF;
996: END IF;
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: END IF;
996: END IF;
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1002: p_data => x_msg_data);
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: END IF;
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1002: p_data => x_msg_data);
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1002: p_data => x_msg_data);
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1006: p_data => x_msg_data);
1007: WHEN OTHERS THEN

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1002: p_data => x_msg_data);
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1006: p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1006: p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1010: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1011: END IF;
1012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1157: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1153: p_end_date => l_end_date,
1154: x_return_status => l_return_status,
1155: x_msg_count => l_msg_count,
1156: x_msg_data => l_msg_data);
1157: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1158: printDebuglog('G_RET_STS_ERROR in prod_autoplacement');
1159: printOutput('G_RET_STS_ERROR in prod_autoplacement');
1160: FOR i IN 1..l_msg_count LOOP
1161: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 1161: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1157: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1158: printDebuglog('G_RET_STS_ERROR in prod_autoplacement');
1159: printOutput('G_RET_STS_ERROR in prod_autoplacement');
1160: FOR i IN 1..l_msg_count LOOP
1161: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1162: printDebuglog(l_msg_data);
1163: printOutput(l_msg_data);
1164: END LOOP;
1165: RAISE FND_API.G_EXC_ERROR;

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1162: printDebuglog(l_msg_data);
1163: printOutput(l_msg_data);
1164: END LOOP;
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1167: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1168: FOR i IN 1..l_msg_count LOOP
1169: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 1166: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1162: printDebuglog(l_msg_data);
1163: printOutput(l_msg_data);
1164: END LOOP;
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1167: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1168: FOR i IN 1..l_msg_count LOOP
1169: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1170: printDebuglog(l_msg_data);

Line 1169: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1167: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1168: FOR i IN 1..l_msg_count LOOP
1169: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1170: printDebuglog(l_msg_data);
1171: printOutput(l_msg_data);
1172: END LOOP;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1169: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1170: printDebuglog(l_msg_data);
1171: printOutput(l_msg_data);
1172: END LOOP;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: END IF;
1175: printReport;
1176: retcode := 0;
1177: errbuf := 'SUCCESS';