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_FUND_REVAL_PVT dependencies on PA_FUND_REVAL_PVT

Line 1: PACKAGE BODY PA_FUND_REVAL_PVT AS

1: PACKAGE BODY PA_FUND_REVAL_PVT AS
2: --$Header: PAXFRPPB.pls 120.3.12010000.2 2008/10/07 09:04:15 dbudhwar ship $
3:
4: /*----------------------------------------------------------------------------------------+
5: | Procedure : revaluate_funding |

Line 69: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.revaluate_funding-----------' ;

65:
66:
67: IF G_DEBUG_MODE = 'Y' THEN
68:
69: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.revaluate_funding-----------' ;
70: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
71:
72: l_LogMsg := 'Parameters : Project Id:' || p_project_id ||
73: ' Project Type Id:' || p_project_type_id ||

Line 196: pa_debug.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.revaluate_funding-----------' ;

192: G_REVAL_FLAG := 'N';
193:
194: IF G_DEBUG_MODE = 'Y' THEN
195:
196: pa_debug.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.revaluate_funding-----------' ;
197: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
198:
199: END IF;
200:

Line 294: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.validate_project_eligibility-----------' ;

290:
291:
292: IF G_DEBUG_MODE = 'Y' THEN
293:
294: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.validate_project_eligibility-----------' ;
295: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
296:
297: END IF;
298:

Line 410: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.validate_project_eligibility-----------' ;

406: END IF;
407:
408: IF G_DEBUG_MODE = 'Y' THEN
409:
410: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.validate_project_eligibility-----------' ;
411: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
412:
413: END IF;
414:

Line 535: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_rsob_ids-----------' ;

531: x_msg_count := 0;
532:
533: IF G_DEBUG_MODE = 'Y' THEN
534:
535: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_rsob_ids-----------' ;
536: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
537:
538: END IF;
539:

Line 631: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_rsob_ids-----------' ;

627: END LOOP;
628:
629: IF G_DEBUG_MODE = 'Y' THEN
630:
631: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_rsob_ids-----------' ;
632: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
633:
634: END IF;
635:

Line 725: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_start_end_proj_num-----------' ;

721: x_msg_count := 0;
722:
723: IF G_DEBUG_MODE = 'Y' THEN
724:
725: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_start_end_proj_num-----------' ;
726: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
727:
728: END IF;
729:

Line 835: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_start_end_proj_num-----------' ;

831: ' End Proj No:' || x_to_proj_number ||
832: ' Proj Type Id:' || x_Project_type_id;
833: PA_FUND_REVAL_UTIL.Log_Message(p_message => l_LogMsg);
834:
835: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_start_end_proj_num-----------' ;
836: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
837:
838: END IF;
839:

Line 906: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Check_Unrel_invoice_revenue-----------' ;

902: x_reason_code := NULL;
903:
904: IF G_DEBUG_MODE = 'Y' THEN
905:
906: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Check_Unrel_invoice_revenue-----------' ;
907: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
908:
909: END IF;
910:

Line 970: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Check_Unrel_invoice_revenue-----------' ;

966: END IF;
967:
968: IF G_DEBUG_MODE = 'Y' THEN
969:
970: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Check_Unrel_invoice_revenue-----------' ;
971: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
972:
973: END IF;
974:

Line 1013: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Check_reval_unbaseline_funds-----------' ;

1009: BEGIN
1010:
1011: IF G_DEBUG_MODE = 'Y' THEN
1012:
1013: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Check_reval_unbaseline_funds-----------' ;
1014: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1015:
1016: END IF;
1017:

Line 1028: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Check_reval_unbaseline_funds-----------' ;

1024: AND budget_type_code = 'DRAFT');
1025:
1026: IF G_DEBUG_MODE = 'Y' THEN
1027:
1028: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Check_reval_unbaseline_funds-----------' ;
1029: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1030:
1031: END IF;
1032:

Line 1100: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Delete_Unbaselined_Adjmts-----------' ;

1096: x_msg_count := 0;
1097:
1098: IF G_DEBUG_MODE = 'Y' THEN
1099:
1100: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Delete_Unbaselined_Adjmts-----------' ;
1101: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1102:
1103: END IF;
1104:

Line 1202: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Delete_Unbaselined_Adjmts-----------' ;

1198: CLOSE fund_recs;
1199:
1200: IF G_DEBUG_MODE = 'Y' THEN
1201:
1202: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Delete_Unbaselined_Adjmts-----------' ;
1203: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1204:
1205: END IF;
1206:

Line 1278: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Insert_distribution_warnings-----------' ;

1274: x_msg_count := 0;
1275:
1276: IF G_DEBUG_MODE = 'Y' THEN
1277:
1278: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.Insert_distribution_warnings-----------' ;
1279: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1280:
1281: l_LogMsg := 'Reason :' || p_reason_code;
1282: PA_FUND_REVAL_UTIL.Log_Message(l_LogMsg);

Line 1309: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Insert_distribution_warnings-----------' ;

1305: );
1306:
1307: IF G_DEBUG_MODE = 'Y' THEN
1308:
1309: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.Insert_distribution_warnings-----------' ;
1310: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1311:
1312: END IF;
1313:

Line 1467: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_reval_projects-----------' ;

1463: x_msg_count := 0;
1464:
1465: IF G_DEBUG_MODE = 'Y' THEN
1466:
1467: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_reval_projects-----------' ;
1468: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1469:
1470: l_LogMsg := 'From prj:' || p_from_proj_number ||
1471: ' To prj:' || p_to_proj_number ||

Line 1651: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_reval_projects-----------' ;

1647: END LOOP ; /* Open_projects*/
1648:
1649: IF G_DEBUG_MODE = 'Y' THEN
1650:
1651: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_reval_projects-----------' ;
1652: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1653:
1654: END IF;
1655:

Line 1706: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

1702: /* This CURSOR selects the summary project funding lines with non-zero baselined amount
1703: for the given project in primary set of book id only*/
1704:
1705: CURSOR get_spf_lines (l_ProjectId NUMBER) is
1706: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
1707: SPF.agreement_id agreement_id,
1708: SPF.task_id task_id,
1709: SPF.funding_currency_code funding_currency_code,
1710: SPF.project_currency_code project_currency_code,

Line 1739: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

1735: new table gl_alc_ledger_rships_v and corresponding columns */
1736:
1737: /* mrc migration to SLA bug 4571438
1738: CURSOR get_all_spf_lines (l_ProjectId NUMBER) is
1739: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
1740: SPF.agreement_id agrmt_id,
1741: SPF.task_id task_id,
1742: SPF.funding_currency_code funding_currency_code,
1743: SPF.project_currency_code project_currency_code,

Line 1835: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_spf_lines-----------' ;

1831: x_msg_count := 0;
1832:
1833: IF G_DEBUG_MODE = 'Y' THEN
1834:
1835: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_spf_lines-----------' ;
1836: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
1837:
1838: END IF;
1839:

Line 2136: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_spf_lines-----------' ;

2132: END IF;
2133:
2134: IF G_DEBUG_MODE = 'Y' THEN
2135:
2136: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_spf_lines-----------' ;
2137: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2138:
2139: END IF;
2140:

Line 2206: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.process_spf_lines-----------' ;

2202: x_msg_count := 0;
2203:
2204: IF G_DEBUG_MODE = 'Y' THEN
2205:
2206: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.process_spf_lines-----------' ;
2207: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2208:
2209: l_LogMsg := 'Agreement Id:' || p_agreement_id ||
2210: ' Task Id:' || p_task_id ||

Line 2428: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.process_spf_lines-----------' ;

2424: END IF;
2425:
2426: IF G_DEBUG_MODE = 'Y' THEN
2427:
2428: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.process_spf_lines-----------' ;
2429: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2430:
2431: END IF;
2432:

Line 2503: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

2499: /* This CURSOR fetches all retention invoice amount for a given project/agreement_id in
2500: primary sob */
2501:
2502: CURSOR get_retn_invoices IS
2503: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
2504: di.draft_invoice_num,
2505: dii.projfunc_currency_code,
2506: dii.funding_currency_code,
2507: di.inv_currency_code,

Line 2540: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

2536: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
2537: new table gl_alc_ledger_rships_v and corresponding columns */
2538: /* mrc migration to SLA bug 4571438
2539: CURSOR get_all_retn_invoices IS
2540: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
2541: di.draft_invoice_num drft_inv_num,
2542: dii.projfunc_currency_code,
2543: dii.funding_currency_code,
2544: di.inv_currency_code,

Line 2646: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_retn_appl_amount-----------' ;

2642: x_msg_count := 0;
2643:
2644: IF G_DEBUG_MODE = 'Y' THEN
2645:
2646: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_retn_appl_amount-----------' ;
2647: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2648:
2649: END IF;
2650:

Line 2903: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_retn_appl_amount-----------' ;

2899: END IF;
2900:
2901: IF G_DEBUG_MODE = 'Y' THEN
2902:
2903: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_retn_appl_amount-----------' ;
2904: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2905:
2906: END IF;
2907:

Line 2990: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.process_retention_invoice-----------' ;

2986: x_msg_count := 0;
2987:
2988: IF G_DEBUG_MODE = 'Y' THEN
2989:
2990: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.process_retention_invoice-----------' ;
2991: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
2992:
2993: END IF;
2994:

Line 3210: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.process_retention_invoices-----------' ;

3206: END LOOP;
3207:
3208: IF G_DEBUG_MODE = 'Y' THEN
3209:
3210: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.process_retention_invoices-----------' ;
3211: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
3212:
3213: END IF;
3214:

Line 3280: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3276: */
3277:
3278: CURSOR get_proj_invoices IS
3279: (SELECT 'REGULAR-PROJ' invoice_type,
3280: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3281: 0 task_id,
3282: di.draft_invoice_num drft_inv_num,
3283: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3284: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3313: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3309: canceled_flag, cancel_credit_memo_flag, write_off_flag,
3310: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y')
3311: UNION
3312: SELECT 'RETENTION-PROJ' invoice_type,
3313: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3314: 0 task_id,
3315: di.draft_invoice_num drft_inv_num,
3316: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3317: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3355: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3351:
3352: /* mrc migration to SLA bug 4571438
3353: CURSOR get_all_proj_invoices IS
3354: (SELECT 'REGULAR-PROJ' invoice_type,
3355: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3356: 0 task_id,
3357: di.draft_invoice_num drft_inv_num,
3358: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3359: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3388: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3384: canceled_flag, cancel_credit_memo_flag, write_off_flag,
3385: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y')
3386: UNION
3387: SELECT 'RETENTION-PROJ' invoice_type,
3388: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3389: 0 task_id,
3390: di.draft_invoice_num drft_inv_num,
3391: dii.invproc_currency_code,
3392: dii.projfunc_currency_code,

Line 3525: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3521: from RDL ERDL DII. These are eliminated by the check nvl(dii.task_id,0) <> 0
3522: */
3523: CURSOR get_task_invoices IS
3524: (SELECT 'REGULAR-TASK' invoice_type,
3525: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3526: dii.task_id,
3527: di.draft_invoice_num drft_inv_num,
3528: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3529: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3596: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3592: canceled_flag, cancel_credit_memo_flag, write_off_flag,
3593: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y')
3594: UNION
3595: SELECT 'RETENTION-TASK' invoice_type,
3596: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3597: dii.task_id,
3598: di.draft_invoice_num drft_inv_num,
3599: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3600: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3638: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3634: new table gl_alc_ledger_rships_v and corresponding columns */
3635:
3636: /* mrc migration to SLA bug 4571438 CURSOR get_all_task_invoices IS
3637: (SELECT 'REGULAR-TASK' invoice_type,
3638: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3639: dii.task_id,
3640: di.draft_invoice_num drft_inv_num,
3641: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3642: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3680: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

3676: canceled_flag, cancel_credit_memo_flag, write_off_flag,
3677: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y')
3678: UNION
3679: SELECT 'RETENTION-TASK' invoice_type,
3680: PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
3681: dii.task_id,
3682: di.draft_invoice_num drft_inv_num,
3683: dii.invproc_currency_code, dii.projfunc_currency_code, dii.funding_currency_code,
3684: di.inv_currency_code, di.system_reference, di.transfer_status_code,

Line 3861: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_invoice_components-----------' ;

3857: x_msg_count := 0;
3858:
3859: IF G_DEBUG_MODE = 'Y' THEN
3860:
3861: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_invoice_components-----------' ;
3862: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
3863:
3864: END IF;
3865:

Line 4540: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_invoice_components-----------' ;

4536: END IF ;/* G_PRIMARY_ONLY */
4537:
4538: IF G_DEBUG_MODE = 'Y' THEN
4539:
4540: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_invoice_components-----------' ;
4541: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
4542:
4543: END IF;
4544:

Line 4702: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.derive_reval_components-----------' ;

4698:
4699:
4700: IF G_DEBUG_MODE = 'Y' THEN
4701:
4702: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.derive_reval_components-----------' ;
4703: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
4704:
4705: END IF;
4706:

Line 5810: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.derive_reval_components-----------' ;

5806: END IF; /* project level funding */
5807:
5808: IF G_DEBUG_MODE = 'Y' THEN
5809:
5810: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.derive_reval_components-----------' ;
5811: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
5812:
5813: END IF;
5814:

Line 5876: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

5872:
5873: l_LogMsg VARCHAR2(250);
5874:
5875: CURSOR get_inv_total IS
5876: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
5877: sum(dii.amount) amount,
5878: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5879: sum(dii.funding_bill_amount) funding_bill_amount,
5880: sum(dii.inv_amount) inv_amount

Line 5894: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

5890: new table gl_alc_ledger_rships_v and corresponding columns */
5891:
5892: /* mrc migration to SLA bug 4571438
5893: CURSOR get_all_inv_total IS
5894: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
5895: sum(dii.amount) amount,
5896: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5897: sum(dii.funding_bill_amount) funding_bill_amount,
5898: sum(dii.inv_amount) inv_amount

Line 5942: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_invoice_total-----------' ;

5938: x_msg_count := 0;
5939:
5940: IF G_DEBUG_MODE = 'Y' THEN
5941:
5942: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_invoice_total-----------' ;
5943: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
5944:
5945: END IF;
5946:

Line 6064: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_invoice_total-----------' ;

6060: END IF;
6061:
6062: IF G_DEBUG_MODE = 'Y' THEN
6063:
6064: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_invoice_total-----------' ;
6065: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6066:
6067: END IF;
6068:

Line 6135: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6131: Since retained amount is stored only in invoice processing currency, it is prorated to get in
6132: project functional and funding currency */
6133:
6134: CURSOR rdl_amount IS
6135: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6136: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6137: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6138: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6139: WHERE DII.project_id = p_project_id

Line 6150: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6146: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
6147: new table gl_alc_ledger_rships_v and corresponding columns */
6148:
6149: /* mrc migration to SLA bug 4571438 CURSOR rdl_amount_all IS
6150: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6151: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6152: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6153: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6154: WHERE DII.project_id = p_project_id

Line 6184: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6180: )
6181: ORDER by set_of_books_id; */
6182:
6183: CURSOR erdl_amount IS
6184: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6185: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6186: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6187: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6188: WHERE DII.project_id = p_project_id

Line 6200: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6196: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
6197: new table gl_alc_ledger_rships_v and corresponding columns */
6198:
6199: /* mrc migration to SLA bug 4571438 CURSOR erdl_amount_all IS
6200: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6201: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6202: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6203: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6204: WHERE DII.project_id = p_project_id

Line 6237: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6233: )
6234: ORDER by set_of_books_id; */
6235:
6236: CURSOR dii_amount IS
6237: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6238: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6239: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6240: FROM pa_draft_invoice_items DII
6241: WHERE DII.project_id = p_project_id

Line 6250: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

6246: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
6247: new table gl_alc_ledger_rships_v and corresponding columns */
6248:
6249: /* mrc migration to SLA bug 4571438 CURSOR dii_amount_all IS
6250: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6251: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6252: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6253: FROM pa_draft_invoice_items DII
6254: WHERE DII.project_id = p_project_id

Line 6307: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_retained_amount-----------' ;

6303: x_msg_count := 0;
6304:
6305: IF G_DEBUG_MODE = 'Y' THEN
6306:
6307: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_retained_amount-----------' ;
6308: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6309:
6310: l_LogMsg := 'Project Id:' || p_project_id ||
6311: ' Task Id:' || p_task_id ||

Line 6668: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_retained_amount-----------' ;

6664: x_RetainedAmtTab := l_RetainedAmtTab;
6665:
6666: IF G_DEBUG_MODE = 'Y' THEN
6667:
6668: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_retained_amount-----------' ;
6669: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6670:
6671: END IF;
6672:

Line 6749: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.sum_retained_amount-----------' ;

6745: x_msg_count := 0;
6746:
6747: IF G_DEBUG_MODE = 'Y' THEN
6748:
6749: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.sum_retained_amount-----------' ;
6750: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6751:
6752: END IF;
6753:

Line 6787: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.sum_retained_amount-----------' ;

6783: END LOOP;
6784:
6785: IF G_DEBUG_MODE = 'Y' THEN
6786:
6787: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.sum_retained_amount-----------' ;
6788: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6789:
6790: END IF;
6791:

Line 6888: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.adjust_appl_amount-----------' ;

6884: the current retained amount is adjusted */
6885:
6886: IF G_DEBUG_MODE = 'Y' THEN
6887:
6888: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.adjust_appl_amount-----------' ;
6889: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6890:
6891: l_LogMsg := 'Sob Id:' || p_SobId ;
6892: PA_FUND_REVAL_UTIL.Log_Message(p_message =>l_LogMsg);

Line 6963: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.adjust_appl_amount-----------' ;

6959: ' PFC Retn loss Amt:' || round(x_retn_loss_amt_pfc,4) ;
6960:
6961: PA_FUND_REVAL_UTIL.Log_Message(p_message =>l_LogMsg);
6962:
6963: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.adjust_appl_amount-----------' ;
6964: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
6965:
6966: END IF;
6967:

Line 7029: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

7025: a) project level funding
7026: */
7027:
7028: CURSOR get_proj_invoices IS
7029: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
7030: 0 task_id,
7031: sum(dii.amount) amount,
7032: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7033: sum(dii.funding_bill_amount) funding_bill_amount

Line 7051: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

7047: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
7048: new table gl_alc_ledger_rships_v and corresponding columns */
7049:
7050: /* mrc migration to SLA bug 4571438 CURSOR get_all_proj_invoices IS
7051: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
7052: 0 task_id,
7053: sum(dii.amount) amount,
7054: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7055: sum(dii.funding_bill_amount) funding_bill_amount

Line 7099: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

7095: a) task level funding
7096: */
7097:
7098: CURSOR get_task_invoices IS
7099: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
7100: dii.task_id,
7101: sum(dii.amount) amount,
7102: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7103: sum(dii.funding_bill_amount) funding_bill_amount

Line 7122: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,

7118:
7119: /* This CURSOR is same as previous CURSOR except that ti will select for both primary and reporting set of
7120: books isd */
7121: /* mrc migration to SLA bug 4571438 CURSOR get_all_task_invoices IS
7122: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
7123: dii.task_id,
7124: sum(dii.amount) amount,
7125: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7126: sum(dii.funding_bill_amount) funding_bill_amount

Line 7187: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_sum_invoice_components-----------' ;

7183: x_msg_count := 0;
7184:
7185: IF G_DEBUG_MODE = 'Y' THEN
7186:
7187: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_sum_invoice_components-----------' ;
7188: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7189:
7190: END IF;
7191:

Line 7464: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_sum_invoice_components-----------' ;

7460: END IF ;/* G_PRIMARY_ONLY */
7461:
7462: IF G_DEBUG_MODE = 'Y' THEN
7463:
7464: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_sum_invoice_components-----------' ;
7465: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7466:
7467: END IF;
7468:

Line 7549: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.populate_invoice_amount-----------' ;

7545: x_msg_count := 0;
7546:
7547: IF G_DEBUG_MODE = 'Y' THEN
7548:
7549: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.populate_invoice_amount-----------' ;
7550: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7551:
7552: END IF;
7553:

Line 7732: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.populate_invoice_amount-----------' ;

7728: END IF;
7729:
7730: IF G_DEBUG_MODE = 'Y' THEN
7731:
7732: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.populate_invoice_amount-----------' ;
7733: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7734:
7735: END IF;
7736:

Line 7869: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.compute_adjustment_amounts-----------' ;

7865: x_msg_count := 0;
7866:
7867: IF G_DEBUG_MODE = 'Y' THEN
7868:
7869: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.compute_adjustment_amounts-----------' ;
7870: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
7871:
7872: END IF;
7873:

Line 8998: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.compute_adjustment_amounts-----------' ;

8994: END LOOP; /* l_SobIdIdx loop */
8995:
8996: IF G_DEBUG_MODE = 'Y' THEN
8997:
8998: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.compute_adjustment_amounts-----------' ;
8999: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9000:
9001: END IF;
9002:

Line 9066: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.insert_rejection_reason_spf-----------' ;

9062: x_msg_count := 0;
9063:
9064: IF G_DEBUG_MODE = 'Y' THEN
9065:
9066: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.insert_rejection_reason_spf-----------' ;
9067: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9068:
9069: END IF;
9070:

Line 9106: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.insert_rejection_reason_spf-----------' ;

9102: END IF;
9103:
9104: IF G_DEBUG_MODE = 'Y' THEN
9105:
9106: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.insert_rejection_reason_spf-----------' ;
9107: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9108:
9109: END IF;
9110:

Line 9188: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.create_adustment_line-----------' ;

9184: x_msg_count := 0;
9185:
9186: IF G_DEBUG_MODE = 'Y' THEN
9187:
9188: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.create_adustment_line-----------' ;
9189: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9190:
9191: END IF;
9192:

Line 9456: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.create_adustment_line-----------' ;

9452: END IF; /* ((G_PRIMARY_ONLY = 'N') OR ( G_RevalCompTab(l_SobId).projfunc_allocated_amount <> 0) */
9453:
9454: IF G_DEBUG_MODE = 'Y' THEN
9455:
9456: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.create_adustment_line-----------' ;
9457: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9458:
9459: END IF;
9460:

Line 9551: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.insert_event_record-----------' ;

9547: x_msg_count := 0;
9548:
9549: IF G_DEBUG_MODE = 'Y' THEN
9550:
9551: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.insert_event_record-----------' ;
9552: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9553:
9554: END IF;
9555:

Line 9690: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.insert_event_record-----------' ;

9686: END IF; /* ((p_bill_trans_rev_amount <> 0) OR (G_PRIMARY_ONLY = 'N')) */
9687:
9688: IF G_DEBUG_MODE = 'Y' THEN
9689:
9690: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.insert_event_record-----------' ;
9691: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9692:
9693: END IF;
9694:

Line 9765: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_ar_amounts-----------' ;

9761: x_msg_count := 0;
9762:
9763: IF G_DEBUG_MODE = 'Y' THEN
9764:
9765: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_ar_amounts-----------' ;
9766: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9767:
9768: END IF;
9769:

Line 9870: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_ar_amounts-----------' ;

9866: x_ArAmtsTab := l_ArAmtsTab;
9867:
9868: IF G_DEBUG_MODE = 'Y' THEN
9869:
9870: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_ar_amounts-----------' ;
9871: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9872:
9873: END IF;
9874:

Line 9933: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.clear_distribution_warnings-----------' ;

9929: x_msg_count := 0;
9930:
9931: IF G_DEBUG_MODE = 'Y' THEN
9932:
9933: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.clear_distribution_warnings-----------' ;
9934: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9935:
9936: END IF;
9937:

Line 9945: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.clear_distribution_warnings-----------' ;

9941: COMMIT;
9942:
9943: IF G_DEBUG_MODE = 'Y' THEN
9944:
9945: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.clear_distribution_warnings-----------' ;
9946: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9947:
9948: END IF;
9949:

Line 10013: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.check_accrued_billed_level-----------' ;

10009: x_msg_count := 0;
10010:
10011: IF G_DEBUG_MODE = 'Y' THEN
10012:
10013: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.check_accrued_billed_level-----------' ;
10014: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
10015:
10016: END IF;
10017:

Line 10092: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.check_accrued_billed_level-----------' ;

10088: END IF;
10089:
10090: IF G_DEBUG_MODE = 'Y' THEN
10091:
10092: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.check_accrued_billed_level-----------' ;
10093: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
10094:
10095: END IF;
10096:

Line 10188: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_delete_projects-----------' ;

10184: x_msg_count := 0;
10185:
10186: IF G_DEBUG_MODE = 'Y' THEN
10187:
10188: PA_DEBUG.g_err_stage := '-----------Entering PA_FUND_REVAL_PVT.get_delete_projects-----------' ;
10189: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
10190:
10191: l_LogMsg := 'From prj:' || p_from_proj_number ||
10192: ' To prj:' || p_to_proj_number ||

Line 10232: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_delete_projects-----------' ;

10228: END LOOP;
10229:
10230: IF G_DEBUG_MODE = 'Y' THEN
10231:
10232: PA_DEBUG.g_err_stage := '-----------Exiting PA_FUND_REVAL_PVT.get_delete_projects-----------' ;
10233: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
10234:
10235: END IF;
10236:

Line 10263: END PA_FUND_REVAL_PVT;

10259: END IF;
10260:
10261: END get_delete_projects;
10262:
10263: END PA_FUND_REVAL_PVT;