APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on FND_API

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

96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;
98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
99: l_err_loc := 1700;
100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
101: l_err_loc := 1800;
102: COMMIT;
103: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;
220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
221: l_err_loc := 1700;
222: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
223: l_err_loc := 1800;
224: COMMIT;
225: -- Must log
226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;
367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
368: l_err_loc := 2000;
369: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
370: l_err_loc := 2100;
371: COMMIT;
372: -- Must log
373: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

423: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
424: END IF;
425:
426: l_err_loc := 2800;
427: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
428: l_err_loc := 2900;
429: COMMIT;
430: -- Must log
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
537: END LOOP;
538:
539: l_err_loc := 1600;
540: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
541: l_err_loc := 1700;
542: COMMIT;
543: -- Must log
544: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

594: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
595: END IF;
596:
597: l_err_loc := 2400;
598: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
599: l_err_loc := 2500;
600: COMMIT;
601: -- Must log
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
746: END LOOP;
747:
748: l_err_loc := 2500;
749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
750: l_err_loc := 2600;
751: COMMIT;
752: -- Must log
753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
917: END LOOP; -- l_all_ctx_sql_tbl LOOP
918:
919: l_err_loc := 2500;
920: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
921: l_err_loc := 2600;
922: COMMIT;
923: -- Must log
924: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

981: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
982: END IF;
983:
984: l_err_loc := 3300;
985: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
986: l_err_loc := 3400;
987: COMMIT;
988: -- Must log
989: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1427: internal_request_id = l_internal_request_id
1428: WHERE rowid = l_rowid_tbl(i);
1429:
1430: l_err_loc := 2800;
1431: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1432: l_err_loc := 2900;
1433: COMMIT;
1434: -- Must log
1435: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1733: l_err_loc := 200;
1734: ICX_CAT_UTIL_PVT.setBatchSize;
1735:
1736: l_err_loc := 300;
1737: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1738:
1739: l_err_loc := 400;
1740: IF (p_category_id = 0) THEN
1741: l_err_loc := 500;

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

1804: l_err_loc := 200;
1805: ICX_CAT_UTIL_PVT.setBatchSize;
1806:
1807: l_err_loc := 300;
1808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1809:
1810: l_err_loc := 400;
1811: -- Update ctx_desc and internal_request_id for all items belonging to p_category_id and p_language in hdrs tlp
1812: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;

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

1894: internal_request_id = l_internal_request_id
1895: WHERE rowid = l_rowid_tbl(i);
1896:
1897: l_err_loc := 1400;
1898: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1899: l_err_loc := 1500;
1900: COMMIT;
1901: -- Must log
1902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN