DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on ICX_CAT_POPULATE_REQTMPL_GRP

Line 486: 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;

482: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
483: );
484: END IF;
485:
486: 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;
487: -- Call iproc api for rebuild index for ReqTemplates
488: -- Pass in the key for PO_SESSION_GT table
489: l_progress := '040';
490:

Line 491: ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates

487: -- Call iproc api for rebuild index for ReqTemplates
488: -- Pass in the key for PO_SESSION_GT table
489: l_progress := '040';
490:
491: ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates
492: (
493: p_api_version => 1.0, -- NUMBER IN
494: p_commit => FND_API.G_TRUE, -- VARCHAR2 IN
495: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

Line 506: 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;

502: -- In case of error, just log in debug logs. There is no need to raise
503: -- it up, because rebuild_index errors have to be ignored by the calling
504: -- program.
505: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
506: 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;
507: END IF;
508: ELSE
509: 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;
510: END IF;

Line 509: 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;

505: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
506: 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;
507: END IF;
508: ELSE
509: 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;
510: END IF;
511:
512: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
513: EXCEPTION