DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on ICX_CAT_POPULATE_BPA_GRP

Line 676: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() to rebuild index'); END IF;

672:
673: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||l_num_rows_is_gt); END IF;
674:
675: IF (l_num_rows_is_gt > 0) THEN
676: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() to rebuild index'); END IF;
677: -- Call iproc api for rebuild index for ReqTemplates
678: -- Pass in the key for PO_SESSION_GT table
679: l_progress := '040';
680:

Line 691: ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets

687: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
688: );
689: END IF;
690:
691: ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets
692: (
693: p_api_version => 1.0, -- NUMBER IN
694: p_commit => FND_API.G_TRUE, -- VARCHAR2 IN
695: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

Line 706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;

702: -- In case of error, just log in debug logs. There is no need to raise
703: -- it up, because rebuild_index errors have to be ignored by the calling
704: -- program.
705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;
707: END IF;
708: ELSE
709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;
710: END IF;

Line 709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;

705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;
707: END IF;
708: ELSE
709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;
710: END IF;
711:
712: -- Finally, see if Org Assignments have changed, and call a separate
713: -- iProc API, to pass in Org Assignment information

Line 1370: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() to rebuild index'); END IF;

1366:
1367: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of recs inserted into GT table='||l_num_rows_is_gt); END IF;
1368:
1369: IF (l_num_rows_is_gt > 0) THEN
1370: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() to rebuild index'); END IF;
1371: -- Call iproc api for rebuild index for ReqTemplates
1372: -- Pass in the key for PO_SESSION_GT table
1373: l_progress := '040';
1374:

Line 1385: ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts

1381: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
1382: );
1383: END IF;
1384:
1385: ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts
1386: (
1387: p_api_version => 1.0, -- NUMBER IN
1388: p_commit => FND_API.G_TRUE, -- VARCHAR2 IN
1389: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

Line 1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;

1396: -- In case of error, just log in debug logs. There is no need to raise
1397: -- it up, because rebuild_index errors have to be ignored by the calling
1398: -- program.
1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;
1401: END IF;
1402: ELSE
1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;
1404: END IF;

Line 1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;

1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;
1401: END IF;
1402: ELSE
1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;
1404: END IF;
1405:
1406: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1407: EXCEPTION