DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on ICX_CAT_POPULATE_BPA_GRP

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

680:
681: 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;
682:
683: IF (l_num_rows_is_gt > 0) THEN
684: 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;
685: -- Call iproc api for rebuild index for ReqTemplates
686: -- Pass in the key for PO_SESSION_GT table
687: l_progress := '040';
688:

Line 699: ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets

695: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
696: );
697: END IF;
698: /* Bug 14046925 : Changing p_commit parameter to false, to avoid commit during doApprove call */
699: ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets
700: (
701: p_api_version => 1.0, -- NUMBER IN
702: p_commit => FND_API.G_FALSE, -- VARCHAR2 IN
703: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

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

710: -- In case of error, just log in debug logs. There is no need to raise
711: -- it up, because rebuild_index errors have to be ignored by the calling
712: -- program.
713: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
714: 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;
715: END IF;
716: ELSE
717: 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;
718: END IF;

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

713: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
714: 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;
715: END IF;
716: ELSE
717: 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;
718: END IF;
719:
720: -- Finally, see if Org Assignments have changed, and call a separate
721: -- iProc API, to pass in Org Assignment information

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

1402:
1403: 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;
1404:
1405: IF (l_num_rows_is_gt > 0) THEN
1406: 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;
1407: -- Call iproc api for rebuild index for ReqTemplates
1408: -- Pass in the key for PO_SESSION_GT table
1409: l_progress := '040';
1410:

Line 1421: ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts

1417: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
1418: );
1419: END IF;
1420: /* Bug 14046925 : Changing p_commit parameter to false, to avoid commit during doApprove call */
1421: ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts
1422: (
1423: p_api_version => 1.0, -- NUMBER IN
1424: p_commit => FND_API.G_FALSE, -- VARCHAR2 IN
1425: p_init_msg_list => FND_API.G_FALSE, -- VARCHAR2 IN

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

1432: -- In case of error, just log in debug logs. There is no need to raise
1433: -- it up, because rebuild_index errors have to be ignored by the calling
1434: -- program.
1435: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1436: 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;
1437: END IF;
1438: ELSE
1439: 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;
1440: END IF;

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

1435: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1436: 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;
1437: END IF;
1438: ELSE
1439: 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;
1440: END IF;
1441:
1442: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1443: EXCEPTION