[Home] [Help]
498: created_by, creation_date, last_updated_by, last_update_date,
499: last_update_login)
500: SELECT 1, 1, 'CONTENT_ZONE', 1, NULL, fnd_global.user_id, sysdate,
501: fnd_global.user_id, sysdate, fnd_global.login_id
502: FROM dual;
503: l_err_loc := 100;
504:
505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, 'End');
537: created_by, creation_date, last_updated_by, last_update_date,
538: last_update_login)
539: SELECT 2, 10000000, 'SMART_FORM', 1, 'N', fnd_global.user_id, sysdate,
540: fnd_global.user_id, sysdate, fnd_global.login_id
541: FROM dual;
542: l_err_loc := 100;
543:
544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
545: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, 'End');
1480: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1481: 'Local Catalog MUST be migrated WITH realms.');
1482: END IF;
1483:
1484: -- migrate this individual local catalog with realms consideration
1485: migrate_catalog_with_realms(l_old_content_ids(i),
1486: l_old_store_ids(i),
1487: l_resp_with_catr_realms);
1488: l_err_loc := 500;
2304: BEGIN
2305:
2306: SELECT 1
2307: INTO l_exists_local_catalogs
2308: FROM dual
2309: WHERE exists (SELECT item_source_id
2310: FROM icx_por_item_sources
2311: WHERE type = 'LOCAL');
2312: l_err_loc := 100;
2354: BEGIN
2355:
2356: SELECT 1
2357: INTO l_exists_item_sources
2358: FROM dual
2359: WHERE exists (SELECT item_source_id
2360: FROM icx_por_item_sources
2361: WHERE type IN ('EXTERNAL', 'DISTSRCH', 'INFO'));
2362: l_err_loc := 100;
3050: l_err_loc := 100;
3051:
3052: SELECT ICX_CAT_CONTENT_ZONES_S.NEXTVAL
3053: INTO l_new_zone_ids(i)
3054: FROM dual;
3055:
3056: END LOOP;
3057:
3058: l_err_loc := 200;
3460: last_updated_by, last_update_date, last_update_login)
3461: SELECT l_zones_to_insert(i), 'CATEGORY', l_categories_to_insert(i),
3462: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3463: fnd_global.login_id
3464: FROM dual;
3465:
3466: -- for statement-level logging, print out values inserted
3467: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3468: FOR i IN 1..l_zones_to_insert.COUNT LOOP
3950: last_updated_by, last_update_date, last_update_login)
3951: SELECT p_new_zone_ids(i), p_resp_ids(i), 'RESPONSIBILITY',
3952: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3953: fnd_global.login_id
3954: FROM dual;
3955:
3956: -- note how many pairs secured
3957: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3958: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,