eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_SUBSET_PVT dependencies on FND_API

Line 129: RAISE fnd_api.g_exc_unexpected_error;

125: WHEN OTHERS THEN
126: Log( 'Get_AppsSchemaName'
127: , 'MAIN'
128: , SQLERRM);
129: RAISE fnd_api.g_exc_unexpected_error;
130:
131: END Get_AppsSchemaName;
132:
133: -----------------------------++++++-------------------------------

Line 179: RAISE fnd_api.g_exc_unexpected_error;

175: -- module
176: Log( 'LOCK_SCHEDULE'
177: , 'MAIN.SCHEDULE_' || P_SCHED_ID
178: );
179: RAISE fnd_api.g_exc_unexpected_error;
180:
181: END LOCK_SCHEDULE;
182:
183: FUNCTION Get_ListName

Line 199: RAISE fnd_api.g_exc_unexpected_error;

195: -- FND_MESSAGE is initialized but not logged in IEC_COMMON_UTIL_PVT
196: -- if an exception is thrown, so we log it here with current
197: -- module
198: Log('Get_ListName', 'MAIN.LIST_' || p_list_id);
199: RAISE fnd_api.g_exc_unexpected_error;
200: END Get_ListName;
201:
202: FUNCTION Get_SubsetName
203: (p_subset_id IN NUMBER)

Line 218: RAISE fnd_api.g_exc_unexpected_error;

214: -- FND_MESSAGE is initialized but not logged in IEC_COMMON_UTIL_PVT
215: -- if an exception is thrown, so we log it here with current
216: -- module
217: Log('Get_ListName', 'MAIN.SUBSET_' || p_subset_id);
218: RAISE fnd_api.g_exc_unexpected_error;
219: END Get_SubsetName;
220:
221:
222: -----------------------------++++++-------------------------------

Line 258: RAISE fnd_api.g_exc_unexpected_error;

254: -- module
255: Log( 'GET_SOURCETYPE_VIEW_NAME'
256: , 'MAIN.LIST_' || p_target_group_id
257: );
258: RAISE fnd_api.g_exc_unexpected_error;
259:
260: END GET_SOURCETYPE_VIEW_NAME;
261:
262: PROCEDURE UPDATE_SUBSET_COUNTS

Line 425: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

421: l_status_code VARCHAR2(1);
422:
423: BEGIN
424: TRACELOG( 'STARTING CREATE SUBSET VIEW');
425: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
426:
427: ----------------------------------------------------------------
428: -- If this is a default subset, then we need to call the get
429: -- default subset criteria procedure.

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479:
480: EXCEPTION
481: -- Fixme add logic to handle if entry does not exist.
482: -- This should no happen.
483: WHEN FND_API.G_EXC_ERROR THEN
484: IF DBMS_SQL.IS_OPEN(l_work_cursor) THEN
485: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
486: END IF;
487: X_RETURN_CODE := 'E';

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: IF DBMS_SQL.IS_OPEN(l_work_cursor) THEN
485: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
486: END IF;
487: X_RETURN_CODE := 'E';
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: IF DBMS_SQL.IS_OPEN(l_work_cursor) THEN
490: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
491: END IF;
492: X_RETURN_CODE := 'U';

Line 537: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

533: l_ignore NUMBER;
534:
535: BEGIN
536: TRACELOG('STARTING DROP SUBSET VIEW');
537: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
538:
539: /*
540: DROP VIEW IEC_SUBSET__V
541: */

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: EXCEPTION
556: WHEN NO_DATA_FOUND THEN
557: NULL;
558: WHEN OTHERS THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END;
561:
562: TRACELOG('STOP DROP SUBSET VIEW');
563:

Line 567: WHEN FND_API.G_EXC_ERROR THEN

563:
564: EXCEPTION
565: -- Fixme add logic to handle if entry does not exist.
566: -- This should no happen.
567: WHEN FND_API.G_EXC_ERROR THEN
568: X_RETURN_CODE := 'E';
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: X_RETURN_CODE := 'U';
571: WHEN OTHERS THEN

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

565: -- Fixme add logic to handle if entry does not exist.
566: -- This should no happen.
567: WHEN FND_API.G_EXC_ERROR THEN
568: X_RETURN_CODE := 'E';
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: X_RETURN_CODE := 'U';
571: WHEN OTHERS THEN
572: TRACELOG('SQLERRM: ' || SQLERRM);
573: X_RETURN_CODE := 'U';

Line 609: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

605: l_status_code VARCHAR2(1);
606:
607: BEGIN
608: TRACELOG('STARTING DROP TARGET GROUP VIEWS');
609: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
610:
611: FOR subset_rec IN (SELECT LIST_SUBSET_ID
612: FROM IEC_G_LIST_SUBSETS
613: WHERE LIST_HEADER_ID = P_TARGET_GROUP_ID

Line 626: WHEN FND_API.G_EXC_ERROR THEN

622:
623: EXCEPTION
624: -- Fixme add logic to handle if entry does not exist.
625: -- This should no happen.
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_CODE := 'E';
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: X_RETURN_CODE := 'U';
630: WHEN OTHERS THEN

Line 628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

624: -- Fixme add logic to handle if entry does not exist.
625: -- This should no happen.
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_CODE := 'E';
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: X_RETURN_CODE := 'U';
630: WHEN OTHERS THEN
631: TRACELOG('SQLERRM: ' || SQLERRM);
632: X_RETURN_CODE := 'U';

Line 672: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

668: L_RETURN_CODE VARCHAR2(1);
669:
670: BEGIN
671: TRACELOG('STARTING VERIFY SUBSET VIEW');
672: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
673: X_VIEW_NAME := NULL;
674: X_VIEW_EXISTS := 'N';
675:
676: L_VIEW_NAME := 'IEC_SUBSET_' || P_SUBSET_ID || '_V';

Line 706: RAISE FND_API.G_EXC_ERROR;

702: , 'RECOMPILE_SUBSET_VIW'
703: , Get_SubsetName(p_subset_id)
704: , Get_ListName(p_target_group_id)
705: );
706: RAISE FND_API.G_EXC_ERROR;
707: END;
708:
709: ELSE
710: X_VIEW_EXISTS := 'Y';

Line 727: WHEN FND_API.G_EXC_ERROR THEN

723: TRACELOG('END VERIFY SUBSET VIEW ' || X_VIEW_EXISTS);
724: TRACELOG('END VERIFY SUBSET VIEWNAME ' || X_VIEW_NAME);
725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: X_RETURN_CODE := 'E';
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: X_RETURN_CODE := 'U';
731: WHEN OTHERS THEN

Line 729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: X_RETURN_CODE := 'E';
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: X_RETURN_CODE := 'U';
731: WHEN OTHERS THEN
732: TRACELOG('SQLERRM: ' || SQLERRM);
733: LOG( 'VERIFY_SUBSET_VIEW'

Line 942: l_return_code := FND_API.G_RET_STS_SUCCESS;

938: l_view_exists VARCHAR2(1);
939: l_default_subset_flag VARCHAR2(1);
940:
941: BEGIN
942: l_return_code := FND_API.G_RET_STS_SUCCESS;
943: l_view_exists := 'N';
944: l_default_subset_flag := 'N';
945:
946: TRACELOG('BEGIN GET SUBSET VIEW');

Line 950: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

946: TRACELOG('BEGIN GET SUBSET VIEW');
947: ----------------------------------------------------------------
948: -- Initialize the return code.
949: ----------------------------------------------------------------
950: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
951:
952: ----------------------------------------------------------------
953: -- Create save point for this procedure.
954: ----------------------------------------------------------------

Line 990: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'N') THEN

986: );
987:
988: TRACELOG('AFTER VERIFY SUBSET VIEW ' || l_return_code || ' : ' || l_view_exists);
989:
990: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'N') THEN
991:
992: CREATE_SUBSET_VIEW( P_SOURCE_ID => P_SOURCE_ID
993: , P_SUBSET_ID => P_SUBSET_ID
994: , P_VIEW_NAME => l_subset_view_name

Line 1001: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

997: , P_DEFAULT_SUBSET_FLAG => l_default_Subset_Flag
998: , X_RETURN_CODE => l_return_code
999: );
1000:
1001: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

998: , X_RETURN_CODE => l_return_code
999: );
1000:
1001: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1005: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

1001: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1007: END IF;
1008: ELSE
1009: l_subset_view_name := 'DEFAULT';

Line 1006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1007: END IF;
1008: ELSE
1009: l_subset_view_name := 'DEFAULT';
1010: END IF;

Line 1018: X_RETURN_CODE := FND_API.G_RET_STS_UNEXP_ERROR;

1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: ROLLBACK TO GET_SUBSET_VIEW_SAVE;
1018: X_RETURN_CODE := FND_API.G_RET_STS_UNEXP_ERROR;
1019:
1020: END GET_SUBSET_VIEW;
1021:
1022: -----------------------------++++++-------------------------------

Line 1058: l_return_code := FND_API.G_RET_STS_SUCCESS;

1054: l_view_exists := 'N';
1055: ----------------------------------------------------------------
1056: -- Initialize the return code.
1057: ----------------------------------------------------------------
1058: l_return_code := FND_API.G_RET_STS_SUCCESS;
1059:
1060: X_SUBSET_VIEW_NAME := 'ERROR';
1061:
1062: ----------------------------------------------------------------

Line 1095: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'Y')

1091:
1092: ----------------------------------------------------------------
1093: -- If the view already exists then drop the view.
1094: ----------------------------------------------------------------
1095: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'Y')
1096: THEN
1097: DROP_SUBSET_VIEW( P_SOURCE_ID => P_SOURCE_ID
1098: , P_SUBSET_ID => P_SUBSET_ID
1099: , X_RETURN_CODE => l_return_code);

Line 1101: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS)

1097: DROP_SUBSET_VIEW( P_SOURCE_ID => P_SOURCE_ID
1098: , P_SUBSET_ID => P_SUBSET_ID
1099: , X_RETURN_CODE => l_return_code);
1100:
1101: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS)
1102: THEN
1103: Log( 'RECREATE_SUBSET_VIEW'
1104: , 'VERIFY_SUBSET_VIEW.SUBSET_' || p_subset_id
1105: , SQLERRM);

Line 1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1102: THEN
1103: Log( 'RECREATE_SUBSET_VIEW'
1104: , 'VERIFY_SUBSET_VIEW.SUBSET_' || p_subset_id
1105: , SQLERRM);
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1107:
1108: END IF;
1109:
1110: ----------------------------------------------------------------

Line 1114: IF (l_return_code = FND_API.G_RET_STS_SUCCESS)

1110: ----------------------------------------------------------------
1111: -- If everything was successful up to this point then we
1112: -- create the subset view.
1113: ----------------------------------------------------------------
1114: IF (l_return_code = FND_API.G_RET_STS_SUCCESS)
1115: THEN
1116: CREATE_SUBSET_VIEW( P_SOURCE_ID => P_SOURCE_ID
1117: , P_SUBSET_ID => P_SUBSET_ID
1118: , P_VIEW_NAME => l_subset_view_name

Line 1125: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

1121: , P_DEFAULT_SUBSET_FLAG => 'N'
1122: , X_RETURN_CODE => l_return_code
1123: );
1124:
1125: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1126: Log( 'RECREATE_SUBSET_VIEW'
1127: , 'CREATE_SUBSET_VIEW.SUBSET_' || p_subset_id
1128: , SQLERRM);
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1125: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
1126: Log( 'RECREATE_SUBSET_VIEW'
1127: , 'CREATE_SUBSET_VIEW.SUBSET_' || p_subset_id
1128: , SQLERRM);
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;
1131:
1132: X_SUBSET_VIEW_NAME := l_subset_view_name;
1133:

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134: ELSE
1135: Log( 'RECREATE_SUBSET_VIEW'
1136: , 'DROP_SUBSET_VIEW.SUBSET_' || p_subset_id
1137: , SQLERRM);
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1143: THEN
1144: -- ROLLBACK TO RECREATE_SUBSET_VIEW_SAVE;
1145: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1146: WHEN OTHERS THEN

Line 1387: WHEN FND_API.G_EXC_ERROR THEN

1383:
1384: EXCEPTION
1385: -- Fixme add logic to handle if entry does not exist.
1386: -- This should no happen.
1387: WHEN FND_API.G_EXC_ERROR THEN
1388: ROLLBACK;
1389: RAISE;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: ROLLBACK;

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386: -- This should no happen.
1387: WHEN FND_API.G_EXC_ERROR THEN
1388: ROLLBACK;
1389: RAISE;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: ROLLBACK;
1392: RAISE;
1393: WHEN OTHERS THEN
1394: ROLLBACK;

Line 1483: WHEN FND_API.G_EXC_ERROR THEN

1479: RAISE;
1480: END; -- end locating new xref block.
1481: END IF;
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: ROLLBACK;
1485: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1487: ROLLBACK;

Line 1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: ROLLBACK;
1485: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1487: ROLLBACK;
1488: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1489: WHEN OTHERS THEN
1490: ROLLBACK;

Line 1813: WHEN FND_API.G_EXC_ERROR THEN

1809:
1810: END IF; -- end of if we could find the source type view name.
1811:
1812: EXCEPTION
1813: WHEN FND_API.G_EXC_ERROR THEN
1814: ROLLBACK;
1815: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1817: ROLLBACK;

Line 1816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1812: EXCEPTION
1813: WHEN FND_API.G_EXC_ERROR THEN
1814: ROLLBACK;
1815: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1817: ROLLBACK;
1818: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1819: WHEN OTHERS THEN
1820: Log( 'CONTINUAL_TRANSITION'

Line 1862: RAISE fnd_api.g_exc_unexpected_error;

1858: -- FND_MESSAGE is initialized but not logged in IEC_COMMON_UTIL_PVT
1859: -- if an exception is thrown, so we log it here with current
1860: -- module
1861: Log( 'GET_LIST_SCHEDULE_ID', 'MAIN.LIST_' || p_target_group_id);
1862: RAISE fnd_api.g_exc_unexpected_error;
1863:
1864: END GET_LIST_SCHEDULE_ID;
1865:
1866: -----------------------------++++++-------------------------------

Line 2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2045: , P_SCHED_ID => P_SCHED_ID
2046: , P_SERVER_ID => P_SERVER_ID
2047: , P_LOCK_FLAG => 'N'
2048: , X_SUCCESS_FLAG => l_locked_flag);
2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2050: END;
2051:
2052: ----------------------------------------------------------------
2053: -- We can now unlock the schedule.

Line 2361: WHEN FND_API.G_EXC_ERROR THEN

2357: ----------------------------------------------------------------
2358: CLOSE l_subset_entry_cursor;
2359:
2360: EXCEPTION
2361: WHEN FND_API.G_EXC_ERROR THEN
2362: IF l_subset_entry_cursor%ISOPEN
2363: THEN
2364: CLOSE l_subset_entry_cursor;
2365: END IF;

Line 2368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2364: CLOSE l_subset_entry_cursor;
2365: END IF;
2366: ROLLBACK;
2367: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
2368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2369: IF l_subset_entry_cursor%ISOPEN
2370: THEN
2371: CLOSE l_subset_entry_cursor;
2372: END IF;

Line 2514: L_STATUS_CODE := FND_API.G_RET_STS_SUCCESS;

2510: ----------------------------------------------------------------
2511: L_USE_CALLABLE_FLAG BOOLEAN := TRUE;
2512:
2513: BEGIN
2514: L_STATUS_CODE := FND_API.G_RET_STS_SUCCESS;
2515: l_return_code := FND_API.G_RET_STS_SUCCESS;
2516:
2517: X_NUM_PENDING := 0;
2518: X_ACTION_ID := 0;

Line 2515: l_return_code := FND_API.G_RET_STS_SUCCESS;

2511: L_USE_CALLABLE_FLAG BOOLEAN := TRUE;
2512:
2513: BEGIN
2514: L_STATUS_CODE := FND_API.G_RET_STS_SUCCESS;
2515: l_return_code := FND_API.G_RET_STS_SUCCESS;
2516:
2517: X_NUM_PENDING := 0;
2518: X_ACTION_ID := 0;
2519:

Line 2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2605: WHEN OTHERS THEN
2606: Log( 'Subset_Transition'
2607: , 'GET_TOTAL_ENTRY_COUNT.SUBSET_' || P_FROM_SUBSETS(1)
2608: , SQLERRM);
2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END;
2611:
2612: ----------------------------------------------------------------
2613: -- Calculate the number of entries left in the current subset that the entries

Line 2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2623: WHEN OTHERS THEN
2624: Log( 'Subset_Transition'
2625: , 'GET_REMAINING_ENTRY_COUNT.SUBSET_' || P_FROM_SUBSETS(1)
2626: , SQLERRM);
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END;
2629:
2630: ----------------------------------------------------------------
2631: -- Calculate the number of entries callable in the current subset that the entries

Line 2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2644: WHEN OTHERS THEN
2645: Log( 'Subset_Transition'
2646: , 'GET_CALLABLE_ENTRY_COUNT.SUBSET_' || P_FROM_SUBSETS(1)
2647: , SQLERRM);
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2649: END;
2650:
2651: ----------------------------------------------------------------
2652: -- Determine the max batch size for moving entries that are

Line 2851: WHEN FND_API.G_EXC_ERROR THEN

2847: END LOOP; -- end loop thru into collection to apply views
2848:
2849: COMMIT;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_ERROR THEN
2852: ROLLBACK;
2853: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK;

Line 2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2850: EXCEPTION
2851: WHEN FND_API.G_EXC_ERROR THEN
2852: ROLLBACK;
2853: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK;
2856: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
2857: WHEN OTHERS THEN
2858: ROLLBACK;