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.AS_CATALOG_MIGRATION dependencies on FND_LOG

Line 176: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

172: if (l_warning_flag = 'Y') then
173: l_warning := 'Y';
174: end if;
175:
176: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Parameters are as below:');
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(a) New Category Set Id = ' || l_category_set_id);
179: end if;
180:

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Parameters are as below:');

173: l_warning := 'Y';
174: end if;
175:
176: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Parameters are as below:');
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(a) New Category Set Id = ' || l_category_set_id);
179: end if;
180:
181: BEGIN

Line 178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(a) New Category Set Id = ' || l_category_set_id);

174: end if;
175:
176: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Parameters are as below:');
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(a) New Category Set Id = ' || l_category_set_id);
179: end if;
180:
181: BEGIN
182: -- Get structure id corresponding to Product Catalog

Line 193: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

189: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to Product Catalog');
190: RAISE;
191: END;
192:
193: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(b) New Control Level = ' || l_control_level);
195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(c) New Structure Id = ' || l_structure_id);
196: end if;
197:

Line 194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(b) New Control Level = ' || l_control_level);

190: RAISE;
191: END;
192:
193: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(b) New Control Level = ' || l_control_level);
195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(c) New Structure Id = ' || l_structure_id);
196: end if;
197:
198: BEGIN

Line 195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(c) New Structure Id = ' || l_structure_id);

191: END;
192:
193: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(b) New Control Level = ' || l_control_level);
195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(c) New Structure Id = ' || l_structure_id);
196: end if;
197:
198: BEGIN
199: -- Get structure id corresponding to sales and marketing category set

Line 209: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to sales and marketing category set');
206: RAISE;
207: END;
208:
209: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(d) Old Structure Id = ' || l_old_structure_id);
211: end if;
212:
213: BEGIN

Line 210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(d) Old Structure Id = ' || l_old_structure_id);

206: RAISE;
207: END;
208:
209: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(d) Old Structure Id = ' || l_old_structure_id);
211: end if;
212:
213: BEGIN
214: -- EGO Application Id is 431

Line 222: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find attribute group for Sales and Marketing');
219: RAISE;
220: END;
221:
222: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(e) Attribute Group Id = ' || l_attr_group_id);
224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(f) Multiple Item Category Assignment Flag = ' || l_mult_item_cat_assign_flag);
225: end if;
226:

Line 223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(e) Attribute Group Id = ' || l_attr_group_id);

219: RAISE;
220: END;
221:
222: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(e) Attribute Group Id = ' || l_attr_group_id);
224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(f) Multiple Item Category Assignment Flag = ' || l_mult_item_cat_assign_flag);
225: end if;
226:
227: BEGIN

Line 224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(f) Multiple Item Category Assignment Flag = ' || l_mult_item_cat_assign_flag);

220: END;
221:
222: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(e) Attribute Group Id = ' || l_attr_group_id);
224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','(f) Multiple Item Category Assignment Flag = ' || l_mult_item_cat_assign_flag);
225: end if;
226:
227: BEGIN
228: -- For each interest type

Line 269: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

265:
266: -- For each primary interest code corresponding to selected interest type
267: FOR scr2 in C_Get_Pri_Int_Code(scr.interest_type_id)
268: LOOP
269: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing primary interest code '||scr2.code);
271: end if;
272:
273: -- Create Mtl categories and associate to inventory items

Line 270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing primary interest code '||scr2.code);

266: -- For each primary interest code corresponding to selected interest type
267: FOR scr2 in C_Get_Pri_Int_Code(scr.interest_type_id)
268: LOOP
269: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing primary interest code '||scr2.code);
271: end if;
272:
273: -- Create Mtl categories and associate to inventory items
274: Process_Categories(p_int_typ_cod_id => scr2.interest_code_id,

Line 307: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

303:
304: -- For each secondary interest code corresponding to selected primary interest code
305: FOR scr3 in C_Get_Sec_Int_Code(scr2.interest_code_id)
306: LOOP
307: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing secondary interest code '||scr3.code);
309: end if;
310:
311: -- Create Mtl categories and associate to inventory items

Line 308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing secondary interest code '||scr3.code);

304: -- For each secondary interest code corresponding to selected primary interest code
305: FOR scr3 in C_Get_Sec_Int_Code(scr2.interest_code_id)
306: LOOP
307: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Now processing secondary interest code '||scr3.code);
309: end if;
310:
311: -- Create Mtl categories and associate to inventory items
312: Process_Categories(p_int_typ_cod_id => scr3.interest_code_id,

Line 585: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

581: l_control_level NUMBER;
582: l_row_id VARCHAR2(100);
583: l_next_val NUMBER;
584: BEGIN
585: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Creating Category Set');
587: end if;
588:
589: -- Get structure id and control level associated with functional area 11

Line 586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Creating Category Set');

582: l_row_id VARCHAR2(100);
583: l_next_val NUMBER;
584: BEGIN
585: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Creating Category Set');
587: end if;
588:
589: -- Get structure id and control level associated with functional area 11
590: select C.structure_id, C.control_level into l_structure_id, l_control_level

Line 617: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

613: X_CREATED_BY => 0,
614: X_LAST_UPDATE_LOGIN => 0 );
615:
616: x_category_set_id := l_next_val;
617: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
618: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Finished Creating Category Set');
619: end if;
620: END Create_SME_Category_Set;
621:

Line 618: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Finished Creating Category Set');

614: X_LAST_UPDATE_LOGIN => 0 );
615:
616: x_category_set_id := l_next_val;
617: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
618: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Finished Creating Category Set');
619: end if;
620: END Create_SME_Category_Set;
621:
622: -- Grant catalog manager role for all users to SME Product Catalog

Line 647: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

643:
644:
645: IF l_num_cat_set_grants = 0 THEN
646:
647: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Granting Access to Catalog');
649: end if;
650:
651: fnd_grants_pkg.grant_function(

Line 648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Granting Access to Catalog');

644:
645: IF l_num_cat_set_grants = 0 THEN
646:
647: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Granting Access to Catalog');
649: end if;
650:
651: fnd_grants_pkg.grant_function(
652: p_api_version => 1.0,

Line 682: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

678: FND_MESSAGE.Set_Token('ERRORCODE', x_errorcode);
679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
680: end if;
681:
682: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Grant guid=' || x_grant_guid);
684: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Granting Access to Catalog');
685: end if;
686: END IF;

Line 683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Grant guid=' || x_grant_guid);

679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
680: end if;
681:
682: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Grant guid=' || x_grant_guid);
684: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Granting Access to Catalog');
685: end if;
686: END IF;
687: END Grant_Access_To_Catalog;

Line 684: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Granting Access to Catalog');

680: end if;
681:
682: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Grant guid=' || x_grant_guid);
684: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Granting Access to Catalog');
685: end if;
686: END IF;
687: END Grant_Access_To_Catalog;
688:

Line 691: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

687: END Grant_Access_To_Catalog;
688:
689: PROCEDURE Attach_SME_Set_To_Func_Area(p_category_set_id IN NUMBER) IS
690: BEGIN
691: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Attaching Category Set to functional area 11');
693: end if;
694:
695: Update MTL_DEFAULT_CATEGORY_SETS

Line 692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Attaching Category Set to functional area 11');

688:
689: PROCEDURE Attach_SME_Set_To_Func_Area(p_category_set_id IN NUMBER) IS
690: BEGIN
691: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Attaching Category Set to functional area 11');
693: end if;
694:
695: Update MTL_DEFAULT_CATEGORY_SETS
696: set category_set_id = p_category_set_id

Line 704: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

700: IF (SQL%NOTFOUND) THEN
701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No functional area found corresponding to product catalog');
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Attaching Category Set to functional area 11');
706: end if;
707: END Attach_SME_Set_To_Func_Area;
708:

Line 705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Attaching Category Set to functional area 11');

701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No functional area found corresponding to product catalog');
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Attaching Category Set to functional area 11');
706: end if;
707: END Attach_SME_Set_To_Func_Area;
708:
709: PROCEDURE Make_SME_Set_Hierarchical(p_category_set_id IN NUMBER) IS

Line 711: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

707: END Attach_SME_Set_To_Func_Area;
708:
709: PROCEDURE Make_SME_Set_Hierarchical(p_category_set_id IN NUMBER) IS
710: BEGIN
711: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Making SME set hierarchical');
713: end if;
714:
715: Update Mtl_Category_Sets

Line 712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Making SME set hierarchical');

708:
709: PROCEDURE Make_SME_Set_Hierarchical(p_category_set_id IN NUMBER) IS
710: BEGIN
711: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Making SME set hierarchical');
713: end if;
714:
715: Update Mtl_Category_Sets
716: set hierarchy_enabled = 'Y'

Line 801: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

797: l_item_found_flag VARCHAR2(1) := 'N';
798: l_exclude_user_view VARCHAR2(1) := 'N';
799:
800: BEGIN
801: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Inside process categories for interest type/code:' || p_category_name || ',interest type/code id:' || p_int_typ_cod_id || ',parent category id:' || p_parent_category_id);
803: end if;
804:
805: x_warning_flag := 'N';

Line 802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Inside process categories for interest type/code:' || p_category_name || ',interest type/code id:' || p_int_typ_cod_id || ',parent category id:' || p_parent_category_id);

798: l_exclude_user_view VARCHAR2(1) := 'N';
799:
800: BEGIN
801: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Inside process categories for interest type/code:' || p_category_name || ',interest type/code id:' || p_int_typ_cod_id || ',parent category id:' || p_parent_category_id);
803: end if;
804:
805: x_warning_flag := 'N';
806: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 844: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

840: l_category_rec.segment1 := l_category_name;
841: l_category_rec.structure_id := p_structure_id;
842: l_category_rec.description := p_category_name; -- This is the original non-truncated name
843:
844: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);
846: end if;
847:
848: INV_ITEM_CATEGORY_PUB.Create_Category (

Line 845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);

841: l_category_rec.structure_id := p_structure_id;
842: l_category_rec.description := p_category_name; -- This is the original non-truncated name
843:
844: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);
846: end if;
847:
848: INV_ITEM_CATEGORY_PUB.Create_Category (
849: p_api_version => G_CREATE_CAT_API_VER,

Line 865: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

861: l_return_status2 := FND_API.G_RET_STS_SUCCESS;
862: -- check if error is due to duplicate category
863: Check_Duplicate_Category(x_return_status => l_return_status2);
864: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN
865: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category');
867: end if;
868: RAISE FND_API.G_EXC_ERROR;
869: ELSE -- if duplicate found

Line 866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category');

862: -- check if error is due to duplicate category
863: Check_Duplicate_Category(x_return_status => l_return_status2);
864: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN
865: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category');
867: end if;
868: RAISE FND_API.G_EXC_ERROR;
869: ELSE -- if duplicate found
870: Find_Duplicate_Category_Id(

Line 875: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

871: p_structure_id => p_structure_id,
872: p_category_name => l_category_name,
873: x_category_id => l_dup_category_id
874: );
875: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate category found with id:' || l_dup_category_id);
877: end if;
878: -- Assign duplicate category id to category id (that otherwise should have been created)
879: l_out_category_id := l_dup_category_id;

Line 876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate category found with id:' || l_dup_category_id);

872: p_category_name => l_category_name,
873: x_category_id => l_dup_category_id
874: );
875: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate category found with id:' || l_dup_category_id);
877: end if;
878: -- Assign duplicate category id to category id (that otherwise should have been created)
879: l_out_category_id := l_dup_category_id;
880: END IF;

Line 883: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

879: l_out_category_id := l_dup_category_id;
880: END IF;
881: END IF;
882:
883: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Category Id:' || l_out_category_id);
885: END IF;
886:
887: l_skip_valid_cat := 'N';

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Category Id:' || l_out_category_id);

880: END IF;
881: END IF;
882:
883: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Category Id:' || l_out_category_id);
885: END IF;
886:
887: l_skip_valid_cat := 'N';
888: -- If a duplicate category was found, there is a chance that a record for this category

Line 917: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

913: x_msg_data => l_msg_data
914: );
915:
916: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
917: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category');
919: end if;
920:
921: RAISE FND_API.G_EXC_ERROR;

Line 918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category');

914: );
915:
916: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
917: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category');
919: end if;
920:
921: RAISE FND_API.G_EXC_ERROR;
922: END IF;

Line 945: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

941: Close C_EXISTS_EXTN_ID;
942:
943: IF (l_item_found_flag = 'Y')
944: THEN
945: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Items found for category:' || p_category_name || ',interest type/code:' || p_int_typ_cod_id );
947: end if;
948:
949: -- For secondary interest codes don't create legacy categories

Line 946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Items found for category:' || p_category_name || ',interest type/code:' || p_int_typ_cod_id );

942:
943: IF (l_item_found_flag = 'Y')
944: THEN
945: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Items found for category:' || p_category_name || ',interest type/code:' || p_int_typ_cod_id );
947: end if;
948:
949: -- For secondary interest codes don't create legacy categories
950: IF l_create_legacy = 'Y' THEN

Line 959: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

955: l_category_rec.segment1 := l_legacy_category_name;
956: l_category_rec.structure_id := p_structure_id;
957: l_category_rec.description := p_category_name || ' LEGACY';
958:
959: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
960: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating legacy category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);
961: end if;
962:
963: INV_ITEM_CATEGORY_PUB.Create_Category (

Line 960: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating legacy category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);

956: l_category_rec.structure_id := p_structure_id;
957: l_category_rec.description := p_category_name || ' LEGACY';
958:
959: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
960: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating legacy category with name:' || l_category_rec.segment1 || ' and description:' || l_category_rec.description);
961: end if;
962:
963: INV_ITEM_CATEGORY_PUB.Create_Category (
964: p_api_version => G_CREATE_CAT_API_VER,

Line 980: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

976: l_return_status2 := FND_API.G_RET_STS_SUCCESS;
977: -- check if error is due to duplicate legacy category
978: Check_Duplicate_Category(x_return_status => l_return_status2);
979: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN
980: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category for legacy category');
982: end if;
983: RAISE FND_API.G_EXC_ERROR;
984: ELSE -- if duplicate found

Line 981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category for legacy category');

977: -- check if error is due to duplicate legacy category
978: Check_Duplicate_Category(x_return_status => l_return_status2);
979: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN
980: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category for legacy category');
982: end if;
983: RAISE FND_API.G_EXC_ERROR;
984: ELSE -- if duplicate found
985: Find_Duplicate_Category_Id(

Line 990: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

986: p_structure_id => p_structure_id,
987: p_category_name => l_legacy_category_name,
988: x_category_id => l_dup_legacy_category_id
989: );
990: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate legacy category found with id:' || l_dup_legacy_category_id);
992: end if;
993: -- Assign duplicate category id to category id (that otherwise should have been created)
994: l_out_legacy_category_id := l_dup_legacy_category_id;

Line 991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate legacy category found with id:' || l_dup_legacy_category_id);

987: p_category_name => l_legacy_category_name,
988: x_category_id => l_dup_legacy_category_id
989: );
990: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Duplicate legacy category found with id:' || l_dup_legacy_category_id);
992: end if;
993: -- Assign duplicate category id to category id (that otherwise should have been created)
994: l_out_legacy_category_id := l_dup_legacy_category_id;
995: END IF;

Line 1028: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1024: x_msg_data => l_msg_data
1025: );
1026:
1027: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1028: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category for legacy category');
1030: end if;
1031:
1032: RAISE FND_API.G_EXC_ERROR;

Line 1029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category for legacy category');

1025: );
1026:
1027: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1028: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Valid_Category for legacy category');
1030: end if;
1031:
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;

Line 1083: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1079:
1080:
1081: END LOOP;
1082: END IF;
1083: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Finished Process_Categories, Returning category_id ' || l_out_category_id);
1085: end if;
1086:
1087: x_category_id := l_out_category_id;

Line 1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Finished Process_Categories, Returning category_id ' || l_out_category_id);

1080:
1081: END LOOP;
1082: END IF;
1083: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Finished Process_Categories, Returning category_id ' || l_out_category_id);
1085: end if;
1086:
1087: x_category_id := l_out_category_id;
1088:

Line 1159: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1155: WHERE category_id = p_category_id
1156: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE;
1157:
1158: BEGIN
1159: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Associating item ' || p_inventory_item_id || ' with category ' || p_category_id || ' for org id ' || p_organization_id || ' and set id ' || p_category_set_id);
1161: end if;
1162:
1163: /*

Line 1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Associating item ' || p_inventory_item_id || ' with category ' || p_category_id || ' for org id ' || p_organization_id || ' and set id ' || p_category_set_id);

1156: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE;
1157:
1158: BEGIN
1159: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Associating item ' || p_inventory_item_id || ' with category ' || p_category_id || ' for org id ' || p_organization_id || ' and set id ' || p_category_set_id);
1161: end if;
1162:
1163: /*
1164: -- Update MTL_ITEM_CATEGORIES

Line 1181: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1177: -- Check if item exists for that org
1178: OPEN org_item_exists_csr (p_inventory_item_id, p_organization_id);
1179: FETCH org_item_exists_csr INTO l_exists;
1180: IF (org_item_exists_csr%NOTFOUND) THEN
1181: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Ignoring item ' || p_inventory_item_id || ' as this item is not associated with organization ' || p_organization_id);
1183: end if;
1184:
1185: l_create_item_rec := 'N';

Line 1182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Ignoring item ' || p_inventory_item_id || ' as this item is not associated with organization ' || p_organization_id);

1178: OPEN org_item_exists_csr (p_inventory_item_id, p_organization_id);
1179: FETCH org_item_exists_csr INTO l_exists;
1180: IF (org_item_exists_csr%NOTFOUND) THEN
1181: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Ignoring item ' || p_inventory_item_id || ' as this item is not associated with organization ' || p_organization_id);
1183: end if;
1184:
1185: l_create_item_rec := 'N';
1186: END IF;

Line 1194: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1190: IF (l_create_item_rec = 'Y') THEN
1191: OPEN category_exists_csr (p_category_id);
1192: FETCH category_exists_csr INTO l_exists;
1193: IF (category_exists_csr%NOTFOUND) THEN
1194: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Unable to associate items to category ' || p_category_id || ' as the category is disabled');
1196: end if;
1197: l_create_item_rec := 'N';
1198: END IF;

Line 1195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Unable to associate items to category ' || p_category_id || ' as the category is disabled');

1191: OPEN category_exists_csr (p_category_id);
1192: FETCH category_exists_csr INTO l_exists;
1193: IF (category_exists_csr%NOTFOUND) THEN
1194: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1195: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Warning! Unable to associate items to category ' || p_category_id || ' as the category is disabled');
1196: end if;
1197: l_create_item_rec := 'N';
1198: END IF;
1199: CLOSE category_exists_csr;

Line 1211: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1207: IF (l_create_item_rec = 'Y' AND p_control_level = G_CONTROL_LEVEL_MASTER) THEN
1208: open C_Check_Master_Org(p_organization_id);
1209: fetch C_Check_Master_Org into l_val;
1210: IF C_Check_Master_Org%NOTFOUND THEN
1211: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Organization ' || p_organization_id || ' is not a master org');
1213: end if;
1214: l_create_item_rec := 'N';
1215: END IF;

Line 1212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Organization ' || p_organization_id || ' is not a master org');

1208: open C_Check_Master_Org(p_organization_id);
1209: fetch C_Check_Master_Org into l_val;
1210: IF C_Check_Master_Org%NOTFOUND THEN
1211: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Organization ' || p_organization_id || ' is not a master org');
1213: end if;
1214: l_create_item_rec := 'N';
1215: END IF;
1216: Close C_Check_Master_Org;

Line 1234: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1230: -- then an Item may be assigned to only one Category in the Category Set.
1231: -- if more categories are assigned, then delete those associations first
1232: IF (p_mult_item_cat_assign_flag = 'N'
1233: AND (l_the_item_assign_count - l_the_cat_assign_count) > 0 ) THEN
1234: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting existing item associations');
1236: end if;
1237:
1238: DELETE FROM mtl_item_categories

Line 1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting existing item associations');

1231: -- if more categories are assigned, then delete those associations first
1232: IF (p_mult_item_cat_assign_flag = 'N'
1233: AND (l_the_item_assign_count - l_the_cat_assign_count) > 0 ) THEN
1234: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting existing item associations');
1236: end if;
1237:
1238: DELETE FROM mtl_item_categories
1239: WHERE organization_id = p_organization_id

Line 1244: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1240: AND inventory_item_id = p_inventory_item_id
1241: AND category_set_id = p_category_set_id;
1242: END IF;
1243:
1244: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating new item associations');
1246: end if;
1247: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment (
1248: p_api_version => G_CREATE_CAT_API_VER,

Line 1245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating new item associations');

1241: AND category_set_id = p_category_set_id;
1242: END IF;
1243:
1244: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Creating new item associations');
1246: end if;
1247: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment (
1248: p_api_version => G_CREATE_CAT_API_VER,
1249: p_init_msg_list => FND_API.G_FALSE,

Line 1262: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1258: p_organization_id => p_organization_id
1259: );
1260:
1261: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1262: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category_Assignment for inventory_item_id=' || p_inventory_item_id);
1264: end if;
1265:
1266: RAISE FND_API.G_EXC_ERROR;

Line 1263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category_Assignment for inventory_item_id=' || p_inventory_item_id);

1259: );
1260:
1261: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1262: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Error occured while calling INV_ITEM_CATEGORY_PUB.Create_Category_Assignment for inventory_item_id=' || p_inventory_item_id);
1264: end if;
1265:
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;

Line 1339: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1335: OPEN C_Get_Category_Id(p_structure_id, p_category_name);
1336: FETCH C_Get_Category_Id into l_category_id;
1337: IF (C_Get_Category_Id%NOTFOUND) THEN
1338: CLOSE C_Get_Category_Id;
1339: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Unable to find category with name ' || p_category_name);
1341: end if;
1342: RAISE FND_API.G_EXC_ERROR;
1343: ELSE

Line 1340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Unable to find category with name ' || p_category_name);

1336: FETCH C_Get_Category_Id into l_category_id;
1337: IF (C_Get_Category_Id%NOTFOUND) THEN
1338: CLOSE C_Get_Category_Id;
1339: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Unable to find category with name ' || p_category_name);
1341: end if;
1342: RAISE FND_API.G_EXC_ERROR;
1343: ELSE
1344: CLOSE C_Get_Category_Id;

Line 1362: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1358: --and B.segment1 like '%LEGACY';
1359: BEGIN
1360: FOR scr in C_Get_Legacy_Category_Id(p_category_set_id, p_category_id)
1361: LOOP
1362: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting unused legacy category with id:' || scr.category_id || ' and name:' || scr.category_name);
1364: end if;
1365: -- No need to update transaction tables since they are handled in a seperate migration program.
1366: update mtl_item_categories

Line 1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting unused legacy category with id:' || scr.category_id || ' and name:' || scr.category_name);

1359: BEGIN
1360: FOR scr in C_Get_Legacy_Category_Id(p_category_set_id, p_category_id)
1361: LOOP
1362: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting unused legacy category with id:' || scr.category_id || ' and name:' || scr.category_name);
1364: end if;
1365: -- No need to update transaction tables since they are handled in a seperate migration program.
1366: update mtl_item_categories
1367: set category_id=p_category_id