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_API

Line 166: RETCODE := FND_API.G_RET_STS_SUCCESS;

162: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping started');
163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
164:
165: -- Initialize retcode to success
166: RETCODE := FND_API.G_RET_STS_SUCCESS;
167:
168: -- Retrieve the category set id for SME Product Catalog
169: Retrieve_Category_Set(x_category_set_id => l_category_set_id,
170: x_warning_flag => l_warning_flag);

Line 364: RETCODE := FND_API.G_RET_STS_ERROR;

360: EXCEPTION
361: WHEN OTHERS THEN
362: Rollback;
363:
364: RETCODE := FND_API.G_RET_STS_ERROR;
365:
366: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
367: IF l_status = TRUE THEN
368: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, can not complete Concurrent Program') ;

Line 673: if (x_return_status = FND_API.G_FALSE) then

669: x_success => x_return_status,
670: x_errorcode => x_errorcode
671: );
672:
673: if (x_return_status = FND_API.G_FALSE) then
674: x_warning_flag := 'Y';
675:
676: -- Warning! Unable to grant access to catalog (Error code:' || x_errorcode || '). Please notify the administrator about this error.
677: FND_MESSAGE.Set_Name('AS', 'API_WARNING_GRANT_CATALOG');

Line 702: RAISE FND_API.G_EXC_ERROR;

698:
699: -- If nothing updated then this is an error
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;

Line 806: l_return_status := FND_API.G_RET_STS_SUCCESS;

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;
807:
808: IF p_level0_enabled_flag <> 'Y' OR p_level1_enabled_flag <> 'Y' OR p_level2_enabled_flag <> 'Y' then
809: l_exclude_user_view := 'Y';
810: END IF;

Line 836: x_return_status := FND_API.G_RET_STS_SUCCESS;

832: return;
833: END IF;
834:
835: -- Initialize API return status to success
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837: l_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- Create Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL
840: l_category_rec.segment1 := l_category_name;

Line 837: l_return_status := FND_API.G_RET_STS_SUCCESS;

833: END IF;
834:
835: -- Initialize API return status to success
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837: l_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- Create Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL
840: l_category_rec.segment1 := l_category_name;
841: l_category_rec.structure_id := p_structure_id;

Line 850: p_init_msg_list => FND_API.G_FALSE,

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,
853: x_errorcode => l_error_code,
854: x_msg_count => l_msg_count,

Line 851: p_commit => FND_API.G_FALSE,

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,
853: x_errorcode => l_error_code,
854: x_msg_count => l_msg_count,
855: x_msg_data => l_msg_data,

Line 860: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

856: p_category_rec => l_category_rec,
857: x_category_id => l_out_category_id
858: );
859:
860: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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

Line 861: l_return_status2 := FND_API.G_RET_STS_SUCCESS;

857: x_category_id => l_out_category_id
858: );
859:
860: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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

Line 864: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN

860: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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;

Line 868: RAISE FND_API.G_EXC_ERROR;

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(
871: p_structure_id => p_structure_id,
872: p_category_name => l_category_name,

Line 905: p_init_msg_list => FND_API.G_FALSE,

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,
908: p_category_id => l_out_category_id,
909: p_parent_category_id => p_parent_category_id,

Line 906: p_commit => FND_API.G_FALSE,

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,
908: p_category_id => l_out_category_id,
909: p_parent_category_id => p_parent_category_id,
910: x_return_status => l_return_status,

Line 916: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

912: x_msg_count => l_msg_count,
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:

Line 921: RAISE FND_API.G_EXC_ERROR;

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;
923: END IF;
924:
925: Open C_EXISTS_EXTN_ID(p_category_set_id,l_out_category_id);

Line 965: p_init_msg_list => FND_API.G_FALSE,

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,
968: x_errorcode => l_error_code,
969: x_msg_count => l_msg_count,

Line 966: p_commit => FND_API.G_FALSE,

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,
968: x_errorcode => l_error_code,
969: x_msg_count => l_msg_count,
970: x_msg_data => l_msg_data,

Line 975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

971: p_category_rec => l_category_rec,
972: x_category_id => l_out_legacy_category_id
973: );
974:
975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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

Line 976: l_return_status2 := FND_API.G_RET_STS_SUCCESS;

972: x_category_id => l_out_legacy_category_id
973: );
974:
975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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

Line 979: IF (l_return_status2 <> FND_API.G_RET_STS_SUCCESS) THEN

975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) 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;

Line 983: RAISE FND_API.G_EXC_ERROR;

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(
986: p_structure_id => p_structure_id,
987: p_category_name => l_legacy_category_name,

Line 1016: p_init_msg_list => FND_API.G_FALSE,

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,
1019: p_category_id => l_out_legacy_category_id,
1020: p_parent_category_id => l_out_category_id,

Line 1017: p_commit => FND_API.G_FALSE,

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,
1019: p_category_id => l_out_legacy_category_id,
1020: p_parent_category_id => l_out_category_id,
1021: x_return_status => l_return_status,

Line 1027: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1023: x_msg_count => l_msg_count,
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:

Line 1032: RAISE FND_API.G_EXC_ERROR;

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;
1034: END IF;
1035:
1036: Open C_EXISTS_EXTN_ID(p_category_set_id,l_out_legacy_category_id);

Line 1091: if l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1087: x_category_id := l_out_category_id;
1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1092: l_return_status := FND_API.G_RET_STS_ERROR;
1093: end if;
1094:
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in Process_Categories');

Line 1092: l_return_status := FND_API.G_RET_STS_ERROR;

1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1092: l_return_status := FND_API.G_RET_STS_ERROR;
1093: end if;
1094:
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in Process_Categories');
1096: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_Categories');

Line 1249: p_init_msg_list => FND_API.G_FALSE,

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,
1252: x_errorcode => x_errorcode,
1253: x_msg_count => x_msg_count,

Line 1250: p_commit => FND_API.G_FALSE,

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,
1252: x_errorcode => x_errorcode,
1253: x_msg_count => x_msg_count,
1254: x_msg_data => x_msg_data,

Line 1261: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1257: p_inventory_item_id => p_inventory_item_id,
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:

Line 1266: RAISE FND_API.G_EXC_ERROR;

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;
1268: END IF;
1269: END Assign_Item_To_Category;
1270:

Line 1281: x_return_status := FND_API.G_RET_STS_ERROR;

1277:
1278: l_msg_data VARCHAR2(2000);
1279: l_msg_count NUMBER;
1280: BEGIN
1281: x_return_status := FND_API.G_RET_STS_ERROR;
1282: fnd_msg_pub.count_and_get( p_encoded => 'F'
1283: , p_count => l_msg_count
1284: , p_data => l_msg_data);
1285: for k in 1 .. l_msg_count loop

Line 1292: x_return_status := FND_API.G_RET_STS_SUCCESS;

1288: );
1289: -- If this token is found in the message, it signifies a duplicate
1290: if (INSTR(l_msg_data,'Category Segment Combination')> 0)
1291: then
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293: FND_MSG_PUB.Delete_Msg(k);
1294: exit;
1295: end if;
1296: end loop;

Line 1342: RAISE FND_API.G_EXC_ERROR;

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