668: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
669: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
670: ||', Total processeded batches:' ||l_batch_count
671: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
672: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
673: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
674: --Closing and reopen of cursor will be done by called procedures
675: l_err_loc := 1700;
676: IF (g_current_cursor = 'ORG_ASSIGNMENT_CSR') THEN
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1455: ||', Total processed batches:' ||l_batch_count
1456: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1457: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1458: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1459: -- Closing and reopen of cursor will be done by called procedures
1460: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1461: l_err_loc := 1600;
2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count
2206: ||', Cursor will be reopened;';
2207: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2208: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2209: --Closing and reopen of cursor will be done by called procedures
2210: l_err_loc := 1600;
2211: openR12UpgradeBPAQuoteCursor;
2676: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2677: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2678: ||', Total processed batches:' ||l_batch_count
2679: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2680: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2681: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2682: --Closing and reopen of cursor will be done by called procedures
2683: openQuotesCursor(g_key, l_start_po_line_id);
2684: ELSE