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.ICX_CAT_POPULATE_ITEM_PVT dependencies on FND_API

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

3637: l_err_loc := 4000;
3638: clearTables('ALL');
3639:
3640: l_err_loc := 4100;
3641: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3642: COMMIT;
3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3644: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3645: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

3757: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3758: END IF;
3759:
3760: l_err_loc := 1100;
3761: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3762: l_err_loc := 1200;
3763: COMMIT;
3764: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

3775: END IF;
3776: END LOOP;
3777:
3778: l_err_loc := 1300;
3779: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3780: l_err_loc := 1400;
3781: -- Call the rebuild index
3782: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3783: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3822: END IF;
3823: END IF;
3824:
3825: l_err_loc := 1900;
3826: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3827: l_err_loc := 2000;
3828: COMMIT;
3829: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3830: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4068: END IF;
4069: END IF;
4070:
4071: l_err_loc := 2600;
4072: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4073: l_err_loc := 2700;
4074: COMMIT;
4075: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4076: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4098: END IF;
4099: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4100:
4101: l_err_loc := 2900;
4102: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4103: l_err_loc := 3000;
4104: -- Call the rebuild index
4105: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4106:

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

4282: AND org_id = l_org_id_tbl(j)
4283: AND language = l_language_tbl(j);
4284:
4285: l_err_loc := 1100;
4286: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4287: l_err_loc := 1200;
4288: COMMIT;
4289: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4290: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4308: -- bulkload should be able to update the document line.
4309:
4310: l_err_loc := 1500;
4311:
4312: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4313: l_err_loc := 1600;
4314: COMMIT;
4315: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4464: AND org_id = l_org_id_tbl(j)
4465: AND language = l_language_tbl(j);
4466:
4467: l_err_loc := 600;
4468: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4469: l_err_loc := 700;
4470: COMMIT;
4471: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4472: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4585: AND org_id = l_org_id_tbl(j)
4586: AND language = l_language_tbl(j);
4587:
4588: l_err_loc := 600;
4589: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4590: l_err_loc := 700;
4591: COMMIT;
4592: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4593: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4720: AND org_id = l_org_id_tbl(j)
4721: AND language = l_language_tbl(j);
4722:
4723: l_err_loc := 600;
4724: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4725: l_err_loc := 700;
4726: COMMIT;
4727: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4728: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4779: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4780: END IF;
4781:
4782: l_err_loc := 200;
4783: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
4784:
4785: l_err_loc := 300;
4786: -- Set the batch_size if supplier needs to be updated
4787: ICX_CAT_UTIL_PVT.setBatchSize;

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

4798: l_err_loc := 700;
4799: purgeInvalidCategoryItems;
4800:
4801: l_err_loc := 800;
4802: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4803: l_err_loc := 900;
4804: -- Call the rebuild index
4805: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4806: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN