DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on ICX_CAT_POPULATE_REQTMPL_GRP

Line 478: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() to rebuild index'); END IF;

474: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
475: );
476: END IF;
477:
478: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() to rebuild index'); END IF;
479: -- Call iproc api for rebuild index for ReqTemplates
480: -- Pass in the key for PO_SESSION_GT table
481: l_progress := '040';
482:

Line 483: ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates

479: -- Call iproc api for rebuild index for ReqTemplates
480: -- Pass in the key for PO_SESSION_GT table
481: l_progress := '040';
482:
483: ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates
484: (
485: p_api_version => 1.0, -- NUMBER IN
486: p_commit => FND_API.G_TRUE, -- VARCHAR2 IN
487: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

Line 498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;

494: -- In case of error, just log in debug logs. There is no need to raise
495: -- it up, because rebuild_index errors have to be ignored by the calling
496: -- program.
497: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;
499: END IF;
500: ELSE
501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;
502: END IF;

Line 501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;

497: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;
499: END IF;
500: ELSE
501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;
502: END IF;
503:
504: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
505: EXCEPTION