DBA Data[Home] [Help]

APPS.PA_PURGE_BILLING dependencies on PA_PROJECT_UTILS2

Line 139: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

135: pa_debug.debug( ' ->After insert into PA_Revenue_Distribution_Lines_AR') ;
136: x_err_stack := l_old_err_stack ;
137:
138: EXCEPTION
139: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
140: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
141:
142: WHEN OTHERS THEN
143: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_CUSTREVDISTLINES' );

Line 140: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

136: x_err_stack := l_old_err_stack ;
137:
138: EXCEPTION
139: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
140: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
141:
142: WHEN OTHERS THEN
143: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_CUSTREVDISTLINES' );
144: pa_debug.debug('Error stage is '||x_err_stage );

Line 147: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

143: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_CUSTREVDISTLINES' );
144: pa_debug.debug('Error stage is '||x_err_stage );
145: pa_debug.debug('Error stack is '||x_err_stack );
146: pa_debug.debug(SQLERRM);
147: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
148:
149: /* ATG NOCOPY changes */
150: p_mcnoofrecordsins := null;
151: x_err_stack := l_old_err_stack ;

Line 153: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

149: /* ATG NOCOPY changes */
150: p_mcnoofrecordsins := null;
151: x_err_stack := l_old_err_stack ;
152:
153: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
154:
155: end PA_MC_CUSTREVDISTLINES ;
156:
157: -- Start of comments

Line 542: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

538:
539: x_err_stack := l_old_err_stack ;
540:
541: EXCEPTION
542: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
543: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
544:
545: WHEN OTHERS THEN
546: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_CUSTREVDISTLINES' );

Line 543: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

539: x_err_stack := l_old_err_stack ;
540:
541: EXCEPTION
542: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
543: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
544:
545: WHEN OTHERS THEN
546: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_CUSTREVDISTLINES' );
547: pa_debug.debug('Error stage is '||x_err_stage );

Line 550: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

546: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_CUSTREVDISTLINES' );
547: pa_debug.debug('Error stage is '||x_err_stage );
548: pa_debug.debug('Error stack is '||x_err_stack );
549: pa_debug.debug(SQLERRM);
550: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
551:
552: /* ATG NOCOPY changes */
553: x_err_stack := l_old_err_stack ;
554:

Line 556: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

552: /* ATG NOCOPY changes */
553: x_err_stack := l_old_err_stack ;
554:
555:
556: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
557:
558: end PA_CUSTREVDISTLINES ;
559:
560: -- Start of comments

Line 657: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

653: pa_debug.debug( ' ->After insert into Pa_MC_Cust_Event_Rdl_AR') ;
654: x_err_stack := l_old_err_stack ;
655:
656: EXCEPTION
657: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
658: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
659:
660: WHEN OTHERS THEN
661: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_EventRevDistLines');

Line 658: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

654: x_err_stack := l_old_err_stack ;
655:
656: EXCEPTION
657: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
658: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
659:
660: WHEN OTHERS THEN
661: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_EventRevDistLines');
662: pa_debug.debug('Error stage is '||x_err_stage );

Line 665: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;

661: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_EventRevDistLines');
662: pa_debug.debug('Error stage is '||x_err_stage );
663: pa_debug.debug('Error stack is '||x_err_stack );
664: pa_debug.debug(SQLERRM);
665: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;
666:
667: /* ATG Changes */
668: p_mcnoofrecordsins := null;
669: x_err_stack := l_old_err_stack ;

Line 671: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

667: /* ATG Changes */
668: p_mcnoofrecordsins := null;
669: x_err_stack := l_old_err_stack ;
670:
671: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
672:
673: end PA_MC_EventRevDistLines ;
674:
675: -- Start of comments

Line 1028: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1024:
1025:
1026: x_err_stack := l_old_err_stack ;
1027: EXCEPTION
1028: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1029: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1030:
1031: WHEN OTHERS THEN
1032: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_EventRevDistLines' );

Line 1029: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1025:
1026: x_err_stack := l_old_err_stack ;
1027: EXCEPTION
1028: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1029: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1030:
1031: WHEN OTHERS THEN
1032: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_EventRevDistLines' );
1033: pa_debug.debug('Error stage is '||x_err_stage );

Line 1036: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1032: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_EventRevDistLines' );
1033: pa_debug.debug('Error stage is '||x_err_stage );
1034: pa_debug.debug('Error stack is '||x_err_stack );
1035: pa_debug.debug(SQLERRM);
1036: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1037:
1038: /* ATG NOCOPY changes */
1039: x_err_stack := l_old_err_stack ;
1040:

Line 1041: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1037:
1038: /* ATG NOCOPY changes */
1039: x_err_stack := l_old_err_stack ;
1040:
1041: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1042:
1043: end PA_EventRevDistLines ;
1044:
1045: -- Start of comments

Line 1130: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1126: pa_debug.debug( ' ->After insert into PA_MC_Events_AR') ;
1127: x_err_stack := l_old_err_stack ;
1128:
1129: EXCEPTION
1130: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1131: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1132:
1133: WHEN OTHERS THEN
1134: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_Events_Trx');

Line 1131: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1127: x_err_stack := l_old_err_stack ;
1128:
1129: EXCEPTION
1130: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1131: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1132:
1133: WHEN OTHERS THEN
1134: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_Events_Trx');
1135: pa_debug.debug('Error stage is '||x_err_stage );

Line 1138: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;

1134: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_Events_Trx');
1135: pa_debug.debug('Error stage is '||x_err_stage );
1136: pa_debug.debug('Error stack is '||x_err_stack );
1137: pa_debug.debug(SQLERRM);
1138: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;
1139:
1140: /* ATG NOCOPY changes */
1141: p_mcnoofrecordsins := null;
1142: x_err_stack := l_old_err_stack ;

Line 1144: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1140: /* ATG NOCOPY changes */
1141: p_mcnoofrecordsins := null;
1142: x_err_stack := l_old_err_stack ;
1143:
1144: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1145:
1146: end PA_MC_Events_Trx ;
1147:
1148: -- Start of comments

Line 1566: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1562:
1563:
1564: x_err_stack := l_old_err_stack ;
1565: EXCEPTION
1566: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1567: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1568:
1569: WHEN OTHERS THEN
1570: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_Event' );

Line 1567: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1563:
1564: x_err_stack := l_old_err_stack ;
1565: EXCEPTION
1566: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1567: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1568:
1569: WHEN OTHERS THEN
1570: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_Event' );
1571: pa_debug.debug('Error stage is '||x_err_stage );

Line 1574: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1570: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_Event' );
1571: pa_debug.debug('Error stage is '||x_err_stage );
1572: pa_debug.debug('Error stack is '||x_err_stack );
1573: pa_debug.debug(SQLERRM);
1574: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1575:
1576: /* ATG NOCOPY changes */
1577: x_err_stack := l_old_err_stack ;
1578:

Line 1579: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1575:
1576: /* ATG NOCOPY changes */
1577: x_err_stack := l_old_err_stack ;
1578:
1579: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1580:
1581: end PA_Event ;
1582:
1583: -- Start of comments

Line 1797: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1793:
1794:
1795: x_err_stack := l_old_err_stack ;
1796: EXCEPTION
1797: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1798: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1799:
1800: WHEN OTHERS THEN
1801: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevItems' );

Line 1798: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1794:
1795: x_err_stack := l_old_err_stack ;
1796: EXCEPTION
1797: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1798: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1799:
1800: WHEN OTHERS THEN
1801: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevItems' );
1802: pa_debug.debug('Error stage is '||x_err_stage );

Line 1805: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1801: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevItems' );
1802: pa_debug.debug('Error stage is '||x_err_stage );
1803: pa_debug.debug('Error stack is '||x_err_stack );
1804: pa_debug.debug(SQLERRM);
1805: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1806:
1807: /* ATG NOCOPY changes */
1808: x_err_stack := l_old_err_stack ;
1809:

Line 1810: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1806:
1807: /* ATG NOCOPY changes */
1808: x_err_stack := l_old_err_stack ;
1809:
1810: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1811:
1812: end PA_DraftRevItems ;
1813:
1814: -- Start of comments

Line 1894: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

1890: pa_debug.debug( ' ->After insert into PA_MC_DRAFT_INV_ITMS_AR') ;
1891: x_err_stack := l_old_err_stack ;
1892:
1893: EXCEPTION
1894: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1895: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1896:
1897: WHEN OTHERS THEN
1898: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTINVOICEITEMS' );

Line 1895: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1891: x_err_stack := l_old_err_stack ;
1892:
1893: EXCEPTION
1894: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1895: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1896:
1897: WHEN OTHERS THEN
1898: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTINVOICEITEMS' );
1899: pa_debug.debug('Error stage is '||x_err_stage );

Line 1902: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

1898: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTINVOICEITEMS' );
1899: pa_debug.debug('Error stage is '||x_err_stage );
1900: pa_debug.debug('Error stack is '||x_err_stack );
1901: pa_debug.debug(SQLERRM);
1902: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1903:
1904: /* ATG NOCOPY changes */
1905: p_mcnoofrecordsins := null;
1906: x_err_stack := l_old_err_stack ;

Line 1909: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

1905: p_mcnoofrecordsins := null;
1906: x_err_stack := l_old_err_stack ;
1907:
1908:
1909: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1910:
1911: end PA_MC_DRAFTINVOICEITEMS ;
1912:
1913: -- Start of comments

Line 2226: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2222:
2223:
2224: x_err_stack := l_old_err_stack ;
2225: EXCEPTION
2226: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2227: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2228:
2229: WHEN OTHERS THEN
2230: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvItems' );

Line 2227: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2223:
2224: x_err_stack := l_old_err_stack ;
2225: EXCEPTION
2226: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2227: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2228:
2229: WHEN OTHERS THEN
2230: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvItems' );
2231: pa_debug.debug('Error stage is '||x_err_stage );

Line 2234: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2230: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvItems' );
2231: pa_debug.debug('Error stage is '||x_err_stage );
2232: pa_debug.debug('Error stack is '||x_err_stack );
2233: pa_debug.debug(SQLERRM);
2234: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2235:
2236: /* ATG NOCOPY changes */
2237: x_err_stack := l_old_err_stack ;
2238:

Line 2240: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2236: /* ATG NOCOPY changes */
2237: x_err_stack := l_old_err_stack ;
2238:
2239:
2240: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2241:
2242: end PA_DraftInvItems ;
2243:
2244: -- Start of comments

Line 2336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2332: pa_debug.debug( ' ->After insert into PA_MC_RETN_INV_DETLS_AR') ;
2333: x_err_stack := l_old_err_stack ;
2334:
2335: EXCEPTION
2336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2338:
2339: WHEN OTHERS THEN
2340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_RETNINVDETAILS' );

Line 2337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2333: x_err_stack := l_old_err_stack ;
2334:
2335: EXCEPTION
2336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2338:
2339: WHEN OTHERS THEN
2340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_RETNINVDETAILS' );
2341: pa_debug.debug('Error stage is '||x_err_stage );

Line 2344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_RETNINVDETAILS' );
2341: pa_debug.debug('Error stage is '||x_err_stage );
2342: pa_debug.debug('Error stack is '||x_err_stack );
2343: pa_debug.debug(SQLERRM);
2344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2345:
2346: /* ATG NOCOPY changes */
2347: p_mcnoofrecordsins := null;
2348: x_err_stack := l_old_err_stack ;

Line 2350: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2346: /* ATG NOCOPY changes */
2347: p_mcnoofrecordsins := null;
2348: x_err_stack := l_old_err_stack ;
2349:
2350: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2351:
2352: end PA_MC_RETNINVDETAILS;
2353:
2354: -- Start of comments

Line 2607: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2603:
2604:
2605: x_err_stack := l_old_err_stack ;
2606: EXCEPTION
2607: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2608: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2609:
2610: WHEN OTHERS THEN
2611: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_RetnInvDetails' );

Line 2608: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2604:
2605: x_err_stack := l_old_err_stack ;
2606: EXCEPTION
2607: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2608: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2609:
2610: WHEN OTHERS THEN
2611: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_RetnInvDetails' );
2612: pa_debug.debug('Error stage is '||x_err_stage );

Line 2615: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2611: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_RetnInvDetails' );
2612: pa_debug.debug('Error stage is '||x_err_stage );
2613: pa_debug.debug('Error stack is '||x_err_stack );
2614: pa_debug.debug(SQLERRM);
2615: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2616:
2617: /* ATG NOCOPY changes */
2618: x_err_stack := l_old_err_stack ;
2619:

Line 2621: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2617: /* ATG NOCOPY changes */
2618: x_err_stack := l_old_err_stack ;
2619:
2620:
2621: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2622:
2623: end PA_RetnInvDetails;
2624:
2625: -- Start of comments

Line 2722: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2718: pa_debug.debug( ' ->After insert into Pa_MC_Draft_Revs_AR') ;
2719: x_err_stack := l_old_err_stack ;
2720:
2721: EXCEPTION
2722: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2723: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2724:
2725: WHEN OTHERS THEN
2726: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTREVENUES' );

Line 2723: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2719: x_err_stack := l_old_err_stack ;
2720:
2721: EXCEPTION
2722: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2723: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2724:
2725: WHEN OTHERS THEN
2726: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTREVENUES' );
2727: pa_debug.debug('Error stage is '||x_err_stage );

Line 2730: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

2726: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTREVENUES' );
2727: pa_debug.debug('Error stage is '||x_err_stage );
2728: pa_debug.debug('Error stack is '||x_err_stack );
2729: pa_debug.debug(SQLERRM);
2730: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2731:
2732: /* ATG NOCOPY CHANGES */
2733: p_mcnoofrecordsins := NULL;
2734: x_err_stack := l_old_err_stack ;

Line 2736: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2732: /* ATG NOCOPY CHANGES */
2733: p_mcnoofrecordsins := NULL;
2734: x_err_stack := l_old_err_stack ;
2735:
2736: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2737:
2738: end PA_MC_DRAFTREVENUES;
2739:
2740: -- Start of comments

Line 3001: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

2997:
2998:
2999: x_err_stack := l_old_err_stack ;
3000: EXCEPTION
3001: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3002: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3003:
3004: WHEN OTHERS THEN
3005: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevenues' );

Line 3002: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

2998:
2999: x_err_stack := l_old_err_stack ;
3000: EXCEPTION
3001: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3002: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3003:
3004: WHEN OTHERS THEN
3005: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevenues' );
3006: pa_debug.debug('Error stage is '||x_err_stage );

Line 3009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3005: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevenues' );
3006: pa_debug.debug('Error stage is '||x_err_stage );
3007: pa_debug.debug('Error stack is '||x_err_stack );
3008: pa_debug.debug(SQLERRM);
3009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3010:
3011: /* ATG NOPCOPY changes */
3012:
3013: x_err_stack := l_old_err_stack ;

Line 3015: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3011: /* ATG NOPCOPY changes */
3012:
3013: x_err_stack := l_old_err_stack ;
3014:
3015: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3016:
3017: end PA_DraftRevenues ;
3018:
3019: -- Start of comments

Line 3336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

3332:
3333:
3334: x_err_stack := l_old_err_stack ;
3335: EXCEPTION
3336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3338:
3339: WHEN OTHERS THEN
3340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvoices' );

Line 3337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3333:
3334: x_err_stack := l_old_err_stack ;
3335: EXCEPTION
3336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3338:
3339: WHEN OTHERS THEN
3340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvoices' );
3341: pa_debug.debug('Error stage is '||x_err_stage );

Line 3344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvoices' );
3341: pa_debug.debug('Error stage is '||x_err_stage );
3342: pa_debug.debug('Error stack is '||x_err_stack );
3343: pa_debug.debug(SQLERRM);
3344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3345:
3346: /* ATG NOCOPY CHANGES */
3347: x_err_stack := l_old_err_stack;
3348:

Line 3349: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3345:
3346: /* ATG NOCOPY CHANGES */
3347: x_err_stack := l_old_err_stack;
3348:
3349: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3350:
3351: end PA_DraftInvoices ;
3352:
3353: -- Start of comments

Line 3548: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

3544:
3545:
3546: x_err_stack := l_old_err_stack ;
3547: EXCEPTION
3548: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3549: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3550:
3551: WHEN OTHERS THEN
3552: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DistWarnings' );

Line 3549: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3545:
3546: x_err_stack := l_old_err_stack ;
3547: EXCEPTION
3548: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3549: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3550:
3551: WHEN OTHERS THEN
3552: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DistWarnings' );
3553: pa_debug.debug('Error stage is '||x_err_stage );

Line 3556: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3552: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DistWarnings' );
3553: pa_debug.debug('Error stage is '||x_err_stage );
3554: pa_debug.debug('Error stack is '||x_err_stack );
3555: pa_debug.debug(SQLERRM);
3556: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3557:
3558: /* ATG NOCOPY changes */
3559: x_err_stack := l_old_err_stack ;
3560:

Line 3562: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3558: /* ATG NOCOPY changes */
3559: x_err_stack := l_old_err_stack ;
3560:
3561:
3562: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3563:
3564: end PA_DistWarnings ;
3565:
3566: -- Start of comments

Line 3789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

3785:
3786:
3787: x_err_stack := l_old_err_stack ;
3788: EXCEPTION
3789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3791:
3792: WHEN OTHERS THEN
3793: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_BillingMessages' );

Line 3790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3786:
3787: x_err_stack := l_old_err_stack ;
3788: EXCEPTION
3789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3791:
3792: WHEN OTHERS THEN
3793: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_BillingMessages' );
3794: pa_debug.debug('Error stage is '||x_err_stage );

Line 3797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3793: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_BillingMessages' );
3794: pa_debug.debug('Error stage is '||x_err_stage );
3795: pa_debug.debug('Error stack is '||x_err_stack );
3796: pa_debug.debug(SQLERRM);
3797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3798:
3799: /* ATG NOCOPY changes */
3800: x_err_stack := l_old_err_stack ;
3801:

Line 3802: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3798:
3799: /* ATG NOCOPY changes */
3800: x_err_stack := l_old_err_stack ;
3801:
3802: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3803:
3804: end PA_BillingMessages;
3805:
3806: -- Start of comments

Line 3984: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

3980:
3981: x_err_stack := l_old_err_stack;
3982:
3983: exception
3984: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3985: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3986:
3987: WHEN OTHERS THEN
3988: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.pa_billing_main_purge' );

Line 3985: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3981: x_err_stack := l_old_err_stack;
3982:
3983: exception
3984: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3985: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3986:
3987: WHEN OTHERS THEN
3988: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.pa_billing_main_purge' );
3989: pa_debug.debug('Error stage is '||x_err_stage );

Line 3992: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

3988: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.pa_billing_main_purge' );
3989: pa_debug.debug('Error stage is '||x_err_stage );
3990: pa_debug.debug('Error stack is '||x_err_stack );
3991: pa_debug.debug(SQLERRM);
3992: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3993:
3994: /* ATG NOCOPY changes */
3995: x_err_stack := l_old_err_stack;
3996:

Line 3998: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

3994: /* ATG NOCOPY changes */
3995: x_err_stack := l_old_err_stack;
3996:
3997:
3998: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3999:
4000: END pa_billing_main_purge ;
4001:
4002: