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.PA_PURGE_PJR_TXNS dependencies on PA_PROJECT_UTILS2

Line 324: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

320:
321: x_err_stack := l_old_err_stack; -- Added for bug 4227589
322:
323: EXCEPTION
324: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );

Line 325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

321: x_err_stack := l_old_err_stack; -- Added for bug 4227589
322:
323: EXCEPTION
324: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );

Line 332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
333:
334: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
335:
336:

Line 334: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
333:
334: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
335:
336:
337: END PA_REQUIREMENTS_PURGE;
338:

Line 650: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

646:
647: x_err_stack := l_old_err_stack; -- Added for bug 4227589
648:
649: EXCEPTION
650: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );

Line 651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

647: x_err_stack := l_old_err_stack; -- Added for bug 4227589
648:
649: EXCEPTION
650: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );

Line 658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
659:
660: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
661:
662: end PA_ASSIGNMENTS_PURGE;

Line 660: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
659:
660: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
661:
662: end PA_ASSIGNMENTS_PURGE;
663:
664: -- Start of comments

Line 1251: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1247:
1248: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1249:
1250: EXCEPTION
1251: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );

Line 1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1248: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1249:
1250: EXCEPTION
1251: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );

Line 1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1260:
1261: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1262:
1263:

Line 1261: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1260:
1261: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1262:
1263:
1264: end pa_forecast_items_purge;
1265:

Line 1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1652:
1653: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1654:
1655: EXCEPTION
1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );

Line 1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1653: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1654:
1655: EXCEPTION
1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );

Line 1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1665:
1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1667:
1668:

Line 1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1665:
1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1667:
1668:
1669: end Pa_schedules_purge;
1670:

Line 1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1962:
1963: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1964:
1965: EXCEPTION
1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');

Line 1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1963: x_err_stack := l_old_err_stack; -- Added for bug 4227589
1964:
1965: EXCEPTION
1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );

Line 1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:
1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1977:
1978: End pa_candidates_purge;

Line 1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:
1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1977:
1978: End pa_candidates_purge;
1979:
1980:

Line 2166: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2162: -----------------End of Logic added to purge data from Workflow related tables-----------------
2163:
2164: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2165: EXCEPTION
2166: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );

Line 2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2163:
2164: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2165: EXCEPTION
2166: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );

Line 2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2175:
2176: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2177:
2178: end PA_ASSIGNMENT_CONFLICTS_PURGE;

Line 2176: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2175:
2176: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2177:
2178: end PA_ASSIGNMENT_CONFLICTS_PURGE;
2179:
2180:

Line 2736: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2732:
2733: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2734:
2735: EXCEPTION
2736: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );

Line 2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2733: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2734:
2735: EXCEPTION
2736: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );

Line 2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2745:
2746: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2747:
2748:

Line 2746: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2745:
2746: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2747:
2748:
2749: END PA_PROJECT_ASSIGNMENT_PURGE ;
2750:

Line 2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2871:
2872: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2873:
2874: EXCEPTION
2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );

Line 2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2872: x_err_stack := l_old_err_stack; -- Added for bug 4227589
2873:
2874: EXCEPTION
2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );

Line 2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:
2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2886:
2887: End Pa_Project_Parties_Purge;

Line 2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:
2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2886:
2887: End Pa_Project_Parties_Purge;
2888:
2889:

Line 3364: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

3360:
3361: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3362:
3363: EXCEPTION
3364: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );

Line 3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3361: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3362:
3363: EXCEPTION
3364: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );

Line 3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3373:
3374: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3375:
3376:

Line 3374: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3373:
3374: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3375:
3376:
3377:
3378:

Line 3728: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN

3724: ) ;
3725:
3726: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3727: EXCEPTION
3728: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');

Line 3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

3725:
3726: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3727: EXCEPTION
3728: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

Line 3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3737:
3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3739:
3740:

Line 3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3737:
3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3739:
3740:
3741: END PA_WF_PURGE;
3742:

Line 3983: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN

3979: ) ;
3980:
3981: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3982: EXCEPTION
3983: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');

Line 3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

3980:
3981: x_err_stack := l_old_err_stack; -- Added for bug 4227589
3982: EXCEPTION
3983: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

Line 3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3992:
3993: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3994:
3995:

Line 3993: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3992:
3993: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3994:
3995:
3996: END PA_WF_MASS_PURGE;
3997:

Line 4251: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN

4247: ) ;
4248:
4249: x_err_stack := l_old_err_stack; -- Added for bug 4227589
4250: EXCEPTION
4251: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');

Line 4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

4248:
4249: x_err_stack := l_old_err_stack; -- Added for bug 4227589
4250: EXCEPTION
4251: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

Line 4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4260:
4261: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4262:
4263:

Line 4261: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4260:
4261: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4262:
4263:
4264: END PA_WF_MASS_ASGN_PURGE;
4265:

Line 4424: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN

4420: ) ;
4421:
4422: x_err_stack := l_old_err_stack; -- Added for bug 4227589
4423: EXCEPTION
4424: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');

Line 4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

4421:
4422: x_err_stack := l_old_err_stack; -- Added for bug 4227589
4423: EXCEPTION
4424: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

Line 4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4433:
4434: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4435:
4436:

Line 4434: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4433:
4434: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4435:
4436:
4437: END PA_WF_KEY_PURGE;
4438: