DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on FND_API

Line 3666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

3662: l_err_loc := 4000;
3663: clearTables('ALL');
3664:
3665: l_err_loc := 4100;
3666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3667: COMMIT;
3668: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 3786: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

3782: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3783: END IF;
3784:
3785: l_err_loc := 1100;
3786: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3787: l_err_loc := 1200;
3788: COMMIT;
3789: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 3804: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

3800: END IF;
3801: END LOOP;
3802:
3803: l_err_loc := 1300;
3804: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3805: l_err_loc := 1400;
3806: -- Call the rebuild index
3807: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3808: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3851: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

3847: END IF;
3848: END IF;
3849:
3850: l_err_loc := 1900;
3851: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3852: l_err_loc := 2000;
3853: COMMIT;
3854: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3855: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4097: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4093: END IF;
4094: END IF;
4095:
4096: l_err_loc := 2600;
4097: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4098: l_err_loc := 2700;
4099: COMMIT;
4100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4127: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4123: END IF;
4124: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4125:
4126: l_err_loc := 2900;
4127: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4128: l_err_loc := 3000;
4129: -- Call the rebuild index
4130: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4131:

Line 4311: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4307: AND org_id = l_org_id_tbl(j)
4308: AND language = l_language_tbl(j);
4309:
4310: l_err_loc := 1100;
4311: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4312: l_err_loc := 1200;
4313: COMMIT;
4314: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4337: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4333: -- bulkload should be able to update the document line.
4334:
4335: l_err_loc := 1500;
4336:
4337: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4338: l_err_loc := 1600;
4339: COMMIT;
4340: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4341: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4493: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4489: AND org_id = l_org_id_tbl(j)
4490: AND language = l_language_tbl(j);
4491:
4492: l_err_loc := 600;
4493: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4494: l_err_loc := 700;
4495: COMMIT;
4496: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4497: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4614: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4610: AND org_id = l_org_id_tbl(j)
4611: AND language = l_language_tbl(j);
4612:
4613: l_err_loc := 600;
4614: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4615: l_err_loc := 700;
4616: COMMIT;
4617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4745: AND org_id = l_org_id_tbl(j)
4746: AND language = l_language_tbl(j);
4747:
4748: l_err_loc := 600;
4749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4750: l_err_loc := 700;
4751: COMMIT;
4752: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4753: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

4804: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4805: END IF;
4806:
4807: l_err_loc := 200;
4808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
4809:
4810: l_err_loc := 300;
4811: -- Set the batch_size if supplier needs to be updated
4812: ICX_CAT_UTIL_PVT.setBatchSize;

Line 4827: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

4823: l_err_loc := 700;
4824: purgeInvalidCategoryItems;
4825:
4826: l_err_loc := 800;
4827: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4828: l_err_loc := 900;
4829: -- Call the rebuild index
4830: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4831: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN