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 676: p_init_msg_list => FND_API.G_FALSE,

672: -- table and IBE_DSP_MSITE_SCT_ITEMS
673: -- For fixing bug 2771549
674: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
675: (p_api_version => 1.0,
676: p_init_msg_list => FND_API.G_FALSE,
677: p_commit => FND_API.G_FALSE,
678: p_section_id => p_section_id,
679: p_inventory_item_id => l_inventory_item_id,
680: p_organization_id => p_organization_id,

Line 677: p_commit => FND_API.G_FALSE,

673: -- For fixing bug 2771549
674: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
675: (p_api_version => 1.0,
676: p_init_msg_list => FND_API.G_FALSE,
677: p_commit => FND_API.G_FALSE,
678: p_section_id => p_section_id,
679: p_inventory_item_id => l_inventory_item_id,
680: p_organization_id => p_organization_id,
681: x_return_status => l_return_status,

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

680: p_organization_id => p_organization_id,
681: x_return_status => l_return_status,
682: x_msg_count => l_msg_count,
683: x_msg_data => l_msg_data);
684: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
685: COMMIT;
686: printDebuglog('Commit the delete section_item assoication');
687: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
688: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');

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

683: x_msg_data => l_msg_data);
684: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
685: COMMIT;
686: printDebuglog('Commit the delete section_item assoication');
687: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
688: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');
689: printOutput('G_RET_STS_ERROR in Delete_Section_Item');
690: FOR i IN 1..l_msg_count LOOP
691: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

687: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
688: printDebuglog('G_RET_STS_ERROR in Delete_Section_Item');
689: printOutput('G_RET_STS_ERROR in Delete_Section_Item');
690: FOR i IN 1..l_msg_count LOOP
691: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
692: printDebuglog(l_msg_data);
693: printOutput(l_msg_data);
694: END LOOP;
695: RAISE FND_API.G_EXC_ERROR;

Line 695: RAISE FND_API.G_EXC_ERROR;

691: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
692: printDebuglog(l_msg_data);
693: printOutput(l_msg_data);
694: END LOOP;
695: RAISE FND_API.G_EXC_ERROR;
696: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
697: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
698: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
699: FOR i IN 1..l_msg_count LOOP

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

692: printDebuglog(l_msg_data);
693: printOutput(l_msg_data);
694: END LOOP;
695: RAISE FND_API.G_EXC_ERROR;
696: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
697: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
698: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
699: FOR i IN 1..l_msg_count LOOP
700: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

696: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
697: printDebuglog('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
698: printOutput('G_RET_STS_UNEXP_ERROR in Delete_Section_Item');
699: FOR i IN 1..l_msg_count LOOP
700: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
701: printDebuglog(l_msg_data);
702: printOutput(l_msg_data);
703: END LOOP;
704: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 704: raise FND_API.G_EXC_UNEXPECTED_ERROR;

700: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
701: printDebuglog(l_msg_data);
702: printOutput(l_msg_data);
703: END LOOP;
704: raise FND_API.G_EXC_UNEXPECTED_ERROR;
705: END IF;
706: /*
707: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Items_For_Item
708: (p_inventory_item_id => l_inventory_item_id,

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

717: -- section
718: add_only(p_mode, p_category_set_id, p_organization_id, p_section_id,
719: p_product_name, p_product_number, p_publish_flag,
720: p_start_date, p_end_date, l_return_status, l_msg_count, l_msg_data);
721: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
722: printDebuglog('G_RET_STS_ERROR in add_only');
723: printOutput('G_RET_STS_ERROR in add_only');
724: FOR i IN 1..l_msg_count LOOP
725: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

721: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
722: printDebuglog('G_RET_STS_ERROR in add_only');
723: printOutput('G_RET_STS_ERROR in add_only');
724: FOR i IN 1..l_msg_count LOOP
725: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
726: printDebuglog(l_msg_data);
727: printOutput(l_msg_data);
728: END LOOP;
729: RAISE FND_API.G_EXC_ERROR;

Line 729: RAISE FND_API.G_EXC_ERROR;

725: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
726: printDebuglog(l_msg_data);
727: printOutput(l_msg_data);
728: END LOOP;
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
732: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
733: FOR i IN 1..l_msg_count LOOP

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

726: printDebuglog(l_msg_data);
727: printOutput(l_msg_data);
728: END LOOP;
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
732: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
733: FOR i IN 1..l_msg_count LOOP
734: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: printDebuglog('G_RET_STS_UNEXP_ERROR in add_only');
732: printOutput('G_RET_STS_UNEXP_ERROR in add_only');
733: FOR i IN 1..l_msg_count LOOP
734: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
735: printDebuglog(l_msg_data);
736: printOutput(l_msg_data);
737: END LOOP;
738: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 738: raise FND_API.G_EXC_UNEXPECTED_ERROR;

734: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
735: printDebuglog(l_msg_data);
736: printOutput(l_msg_data);
737: END LOOP;
738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: printOutput(l_msg_data);
737: END LOOP;
738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 742: WHEN FND_API.G_EXC_ERROR THEN

738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
745: p_data => x_msg_data);
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
745: p_data => x_msg_data);
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

742: WHEN FND_API.G_EXC_ERROR THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
745: p_data => x_msg_data);
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
749: p_data => x_msg_data);
750: WHEN OTHERS THEN

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
745: p_data => x_msg_data);
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
749: p_data => x_msg_data);
750: WHEN OTHERS THEN
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
749: p_data => x_msg_data);
750: WHEN OTHERS THEN
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
754: END IF;
755: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 826: RAISE FND_API.G_EXC_ERROR;

822: l_organization_id_str
823: := FND_PROFILE.VALUE_SPECIFIC('IBE_ITEM_VALIDATION_ORGANIZATION',
824: null, null, 671);
825: IF (l_organization_id_str IS NULL) THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSE
828: l_organization_id := to_number(l_organization_id_str);
829: END IF;
830: printDebuglog('Organization id='||l_organization_id_str);

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

865: l_return_status, l_msg_count, l_msg_data);
866: printDebuglog('after calling add_remove, return status:'||l_return_status);
867: END IF;
868: -- Check status
869: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
870: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
871: printOutput('G_RET_STS_ERROR in add_remove/add_only');
872: FOR i IN 1..l_msg_count LOOP
873: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

869: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
870: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
871: printOutput('G_RET_STS_ERROR in add_remove/add_only');
872: FOR i IN 1..l_msg_count LOOP
873: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
874: printDebuglog(l_msg_data);
875: printOutput(l_msg_data);
876: END LOOP;
877: RAISE FND_API.G_EXC_ERROR;

Line 877: RAISE FND_API.G_EXC_ERROR;

873: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
874: printDebuglog(l_msg_data);
875: printOutput(l_msg_data);
876: END LOOP;
877: RAISE FND_API.G_EXC_ERROR;
878: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
879: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
880: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
881: FOR i IN 1..l_msg_count LOOP

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

874: printDebuglog(l_msg_data);
875: printOutput(l_msg_data);
876: END LOOP;
877: RAISE FND_API.G_EXC_ERROR;
878: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
879: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
880: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
881: FOR i IN 1..l_msg_count LOOP
882: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

878: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
879: printDebuglog('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
880: printOutput('G_RET_STS_UNEXP_ERROR in add_remove/add_only');
881: FOR i IN 1..l_msg_count LOOP
882: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
883: printDebuglog(l_msg_data);
884: printOutput(l_msg_data);
885: END LOOP;
886: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 886: raise FND_API.G_EXC_UNEXPECTED_ERROR;

882: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
883: printDebuglog(l_msg_data);
884: printOutput(l_msg_data);
885: END LOOP;
886: raise FND_API.G_EXC_UNEXPECTED_ERROR;
887: END IF;
888: -- Commit product autoplacement for each section
889: COMMIT;
890: ELSE

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

914: p_publish_flag, p_start_date, p_end_date,
915: l_return_status, l_msg_count, l_msg_data);
916: END IF;
917: -- Check status
918: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
919: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
920: printOutput('G_RET_STS_ERROR in add_remove/add_only');
921: FOR i IN 1..l_msg_count LOOP
922: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

918: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
919: printDebuglog('G_RET_STS_ERROR in add_remove/add_only');
920: printOutput('G_RET_STS_ERROR in add_remove/add_only');
921: FOR i IN 1..l_msg_count LOOP
922: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
923: printDebuglog(l_msg_data);
924: printOutput(l_msg_data);
925: END LOOP;
926: RAISE FND_API.G_EXC_ERROR;

Line 926: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

Line 935: raise FND_API.G_EXC_UNEXPECTED_ERROR;

931: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
932: printDebuglog(l_msg_data);
933: printOutput(l_msg_data);
934: END LOOP;
935: raise FND_API.G_EXC_UNEXPECTED_ERROR;
936: END IF;
937: -- Commit product autoplacement for each section
938: COMMIT;
939: ELSE

Line 943: x_return_status := FND_API.G_RET_STS_SUCCESS;

939: ELSE
940: printDebuglog('The target section is not featured or leaf section!');
941: END IF;
942: END IF;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941: END IF;
942: END IF;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data);
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: END IF;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data);
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data);
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
952: p_data => x_msg_data);
953: WHEN OTHERS THEN

Line 950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data);
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
952: p_data => x_msg_data);
953: WHEN OTHERS THEN
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
952: p_data => x_msg_data);
953: WHEN OTHERS THEN
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
957: END IF;
958: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1099: p_end_date => l_end_date,
1100: x_return_status => l_return_status,
1101: x_msg_count => l_msg_count,
1102: x_msg_data => l_msg_data);
1103: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1104: printDebuglog('G_RET_STS_ERROR in prod_autoplacement');
1105: printOutput('G_RET_STS_ERROR in prod_autoplacement');
1106: FOR i IN 1..l_msg_count LOOP
1107: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

1103: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1104: printDebuglog('G_RET_STS_ERROR in prod_autoplacement');
1105: printOutput('G_RET_STS_ERROR in prod_autoplacement');
1106: FOR i IN 1..l_msg_count LOOP
1107: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1108: printDebuglog(l_msg_data);
1109: printOutput(l_msg_data);
1110: END LOOP;
1111: RAISE FND_API.G_EXC_ERROR;

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1108: printDebuglog(l_msg_data);
1109: printOutput(l_msg_data);
1110: END LOOP;
1111: RAISE FND_API.G_EXC_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1113: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1114: FOR i IN 1..l_msg_count LOOP
1115: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

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

1108: printDebuglog(l_msg_data);
1109: printOutput(l_msg_data);
1110: END LOOP;
1111: RAISE FND_API.G_EXC_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1113: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1114: FOR i IN 1..l_msg_count LOOP
1115: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1116: printDebuglog(l_msg_data);

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

1111: RAISE FND_API.G_EXC_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1113: printDebuglog('G_RET_STS_UNEXP_ERROR in prod_autoplacement');
1114: FOR i IN 1..l_msg_count LOOP
1115: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1116: printDebuglog(l_msg_data);
1117: printOutput(l_msg_data);
1118: END LOOP;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1116: printDebuglog(l_msg_data);
1117: printOutput(l_msg_data);
1118: END LOOP;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121: printReport;
1122: retcode := 0;
1123: errbuf := 'SUCCESS';