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 INV_ITEM_CATEGORY_PUB

Line 778: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;

774: where category_set_id = c_category_set_id
775: and category_id = c_category_id;
776:
777:
778: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
779: l_out_category_id NUMBER := 0;
780: l_out_legacy_category_id NUMBER := 0;
781: l_val1 NUMBER;
782: l_val2 NUMBER;

Line 848: INV_ITEM_CATEGORY_PUB.Create_Category (

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,
850: p_init_msg_list => FND_API.G_FALSE,
851: p_commit => FND_API.G_FALSE,
852: x_return_status => l_return_status,

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 903: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (

899: END IF;
900:
901: IF (l_skip_valid_cat = 'N') THEN
902: -- Create Record in MTL_CATEGORY_SET_VALID_CATS
903: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (
904: p_api_version => G_CREATE_CAT_API_VER,
905: p_init_msg_list => FND_API.G_FALSE,
906: p_commit => FND_API.G_FALSE,
907: p_category_set_id => p_category_set_id,

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 963: INV_ITEM_CATEGORY_PUB.Create_Category (

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,
965: p_init_msg_list => FND_API.G_FALSE,
966: p_commit => FND_API.G_FALSE,
967: x_return_status => l_return_status,

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 1014: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (

1010: END IF;
1011:
1012: IF (l_skip_valid_cat = 'N') THEN
1013: -- Create Legacy Records in MTL_CATEGORY_SET_VALID_CATS
1014: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (
1015: p_api_version => G_CREATE_CAT_API_VER,
1016: p_init_msg_list => FND_API.G_FALSE,
1017: p_commit => FND_API.G_FALSE,
1018: p_category_set_id => p_category_set_id,

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 1205: -- This validation required here otherwise INV_ITEM_CATEGORY_PUB.Create_Category_Assignment

1201:
1202: -- Following validation ensures that the below mentioned business rule is satisfied:
1203: -- 'Cannot Create/Delete Item Controlled category set from Organization Items.'
1204: -- Basically, if the control level is 'Master', items can be created only for master org
1205: -- This validation required here otherwise INV_ITEM_CATEGORY_PUB.Create_Category_Assignment
1206: -- throws this as an error
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;

Line 1247: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment (

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,
1250: p_commit => FND_API.G_FALSE,
1251: x_return_status => x_return_status,

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;