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_FIN_PLAN_UTILS2 dependencies on PA_DEBUG

Line 8: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4: G_FpTaskBillable_Tab PA_FIN_PLAN_UTILS2.BillableTab;
5:
6: g_debug_flag Varchar2(1);
7: /** Forward declaration */
8: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
9: PROCEDURE checkUserRateAllowed
10: (p_From_curr_code IN Varchar2
11: ,p_To_curr_code IN Varchar2
12: ,p_Conversion_Date IN Date

Line 27: --IF P_PA_DEBUG_MODE = 'Y' Then

23:
24: pragma autonomous_transaction ;
25: BEGIN
26: --dbms_output.put_line(p_msg);
27: --IF P_PA_DEBUG_MODE = 'Y' Then
28: NULL;
29: INSERT INTO PA_FP_CALCULATE_LOG
30: (SESSIONID
31: ,SEQ_NUMBER

Line 52: PA_DEBUG.write

48:
49: BEGIN
50: --calc_log(p_msg);
51: If p_debug_flag = 'Y' Then
52: PA_DEBUG.write
53: (x_Module => l_module
54: ,x_Msg => substr('LOG:'||p_msg,1,240)
55: ,x_Log_Level => 3);
56: End If;

Line 123: IF p_pa_debug_mode = 'Y' THEN

119:
120:
121: BEGIN
122: --- Initialize the error statck
123: IF p_pa_debug_mode = 'Y' THEN
124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');
125: END IF;
126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');

Line 124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');

120:
121: BEGIN
122: --- Initialize the error statck
123: IF p_pa_debug_mode = 'Y' THEN
124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');
125: END IF;
126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');
128:

Line 126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);

122: --- Initialize the error statck
123: IF p_pa_debug_mode = 'Y' THEN
124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');
125: END IF;
126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');
128:
129: IF p_pa_debug_mode = 'Y' THEN
130: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 129: IF p_pa_debug_mode = 'Y' THEN

125: END IF;
126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');
128:
129: IF p_pa_debug_mode = 'Y' THEN
130: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
131: ,x_write_file => 'LOG'
132: ,x_debug_mode => l_debug_flag
133: );

Line 130: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');
128:
129: IF p_pa_debug_mode = 'Y' THEN
130: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
131: ,x_write_file => 'LOG'
132: ,x_debug_mode => l_debug_flag
133: );
134: END IF;

Line 240: IF p_pa_debug_mode = 'Y' THEN

236: x_return_status := l_return_status;
237: l_stage := 'End of Get_UOM_RateBasedFlag RetnSts['||x_return_status||']';
238: print_msg(l_debug_flag,l_proc_name,l_stage);
239:
240: IF p_pa_debug_mode = 'Y' THEN
241: PA_DEBUG.reset_err_stack;
242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN

Line 241: PA_DEBUG.reset_err_stack;

237: l_stage := 'End of Get_UOM_RateBasedFlag RetnSts['||x_return_status||']';
238: print_msg(l_debug_flag,l_proc_name,l_stage);
239:
240: IF p_pa_debug_mode = 'Y' THEN
241: PA_DEBUG.reset_err_stack;
242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF p_pa_debug_mode = 'Y' THEN

Line 245: IF p_pa_debug_mode = 'Y' THEN

241: PA_DEBUG.reset_err_stack;
242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF p_pa_debug_mode = 'Y' THEN
246: PA_DEBUG.write_file('LOG','Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
247: END IF;
248: print_msg(l_debug_flag,l_proc_name,'Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
249: IF p_pa_debug_mode = 'Y' THEN

Line 246: PA_DEBUG.write_file('LOG','Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);

242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF p_pa_debug_mode = 'Y' THEN
246: PA_DEBUG.write_file('LOG','Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
247: END IF;
248: print_msg(l_debug_flag,l_proc_name,'Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
249: IF p_pa_debug_mode = 'Y' THEN
250: PA_DEBUG.reset_err_stack;

Line 249: IF p_pa_debug_mode = 'Y' THEN

245: IF p_pa_debug_mode = 'Y' THEN
246: PA_DEBUG.write_file('LOG','Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
247: END IF;
248: print_msg(l_debug_flag,l_proc_name,'Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
249: IF p_pa_debug_mode = 'Y' THEN
250: PA_DEBUG.reset_err_stack;
251: END IF;
252: Raise;
253:

Line 250: PA_DEBUG.reset_err_stack;

246: PA_DEBUG.write_file('LOG','Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
247: END IF;
248: print_msg(l_debug_flag,l_proc_name,'Failed in Get_UOM_RateBasedFlag['||SQLCODE||SQLERRM);
249: IF p_pa_debug_mode = 'Y' THEN
250: PA_DEBUG.reset_err_stack;
251: END IF;
252: Raise;
253:
254: END Get_UOM_RateBasedFlag;

Line 1105: IF p_pa_debug_mode = 'Y' THEN

1101:
1102: END getMsgtext ;
1103: BEGIN
1104: --- Initialize the error statck
1105: IF p_pa_debug_mode = 'Y' THEN
1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');
1107: END IF;
1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');

Line 1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');

1102: END getMsgtext ;
1103: BEGIN
1104: --- Initialize the error statck
1105: IF p_pa_debug_mode = 'Y' THEN
1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');
1107: END IF;
1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');
1110:

Line 1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

1104: --- Initialize the error statck
1105: IF p_pa_debug_mode = 'Y' THEN
1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');
1107: END IF;
1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');
1110:
1111: IF p_pa_debug_mode = 'Y' THEN
1112: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 1111: IF p_pa_debug_mode = 'Y' THEN

1107: END IF;
1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');
1110:
1111: IF p_pa_debug_mode = 'Y' THEN
1112: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1113: ,x_write_file => 'LOG'
1114: ,x_debug_mode => g_debug_flag
1115: );

Line 1112: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');
1110:
1111: IF p_pa_debug_mode = 'Y' THEN
1112: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1113: ,x_write_file => 'LOG'
1114: ,x_debug_mode => g_debug_flag
1115: );
1116: END IF;

Line 1526: IF p_pa_debug_mode = 'Y' THEN

1522: COMMIT;
1523: Else
1524: ROLLBACK;
1525: End If;
1526: IF p_pa_debug_mode = 'Y' THEN
1527: pa_debug.reset_err_stack;
1528: END IF;
1529: Return;
1530:

Line 1527: pa_debug.reset_err_stack;

1523: Else
1524: ROLLBACK;
1525: End If;
1526: IF p_pa_debug_mode = 'Y' THEN
1527: pa_debug.reset_err_stack;
1528: END IF;
1529: Return;
1530:
1531: EXCEPTION

Line 1540: IF p_pa_debug_mode = 'Y' THEN

1536: print_msg('Y',l_proc_name,l_stage||SQLCODE||SQLERRM);
1537: FND_MSG_PUB.add_exc_msg
1538: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1539: ,p_procedure_name => 'validateAndUpdateBdgtLine');
1540: IF p_pa_debug_mode = 'Y' THEN
1541: PA_DEBUG.reset_err_stack;
1542: END IF;
1543: Raise;
1544:

Line 1541: PA_DEBUG.reset_err_stack;

1537: FND_MSG_PUB.add_exc_msg
1538: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1539: ,p_procedure_name => 'validateAndUpdateBdgtLine');
1540: IF p_pa_debug_mode = 'Y' THEN
1541: PA_DEBUG.reset_err_stack;
1542: END IF;
1543: Raise;
1544:
1545:

Line 1800: IF p_pa_debug_mode = 'Y' THEN

1796: );
1797:
1798: BEGIN
1799: --- Initialize the error statck
1800: IF p_pa_debug_mode = 'Y' THEN
1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');
1802: END IF;
1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');

Line 1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');

1797:
1798: BEGIN
1799: --- Initialize the error statck
1800: IF p_pa_debug_mode = 'Y' THEN
1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');
1802: END IF;
1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');
1805:

Line 1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);

1799: --- Initialize the error statck
1800: IF p_pa_debug_mode = 'Y' THEN
1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');
1802: END IF;
1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');
1805:
1806: IF p_pa_debug_mode = 'Y' THEN
1807: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 1806: IF p_pa_debug_mode = 'Y' THEN

1802: END IF;
1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');
1805:
1806: IF p_pa_debug_mode = 'Y' THEN
1807: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1808: ,x_write_file => 'LOG'
1809: ,x_debug_mode => l_debug_flag
1810: );

Line 1807: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');
1805:
1806: IF p_pa_debug_mode = 'Y' THEN
1807: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1808: ,x_write_file => 'LOG'
1809: ,x_debug_mode => l_debug_flag
1810: );
1811: END IF;

Line 1823: IF p_pa_debug_mode = 'Y' THEN

1819: IF p_project_id is NULL OR p_proj_str_version_id is NULL Then
1820: x_return_status := 'E';
1821: l_stage := 'Insufficent params to get the Bdgt Rejections';
1822: print_msg(l_debug_flag,l_proc_name,l_stage);
1823: IF p_pa_debug_mode = 'Y' THEN
1824: pa_debug.reset_err_stack;
1825: END IF;
1826: Return;
1827: END IF;

Line 1824: pa_debug.reset_err_stack;

1820: x_return_status := 'E';
1821: l_stage := 'Insufficent params to get the Bdgt Rejections';
1822: print_msg(l_debug_flag,l_proc_name,l_stage);
1823: IF p_pa_debug_mode = 'Y' THEN
1824: pa_debug.reset_err_stack;
1825: END IF;
1826: Return;
1827: END IF;
1828: If p_budget_version_id is NULL then --Bug 5611909

Line 1878: IF p_pa_debug_mode = 'Y' THEN

1874: l_stage := 'OUT Params CstRej['||x_cost_rejn_flag||']BdRej['||x_burden_rejn_flag||
1875: ']RevRej['||x_revenue_rejn_flag||']PcRej['||x_pc_conv_rejn_flag||
1876: ']PfcRej['||x_pfc_conv_rejn_flag||']ProjStrRej['||x_projstrlvl_rejn_flag||']';
1877: print_msg(l_debug_flag,l_proc_name,l_stage);
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_debug.reset_err_stack;
1880: END IF;
1881: Return;
1882:

Line 1879: pa_debug.reset_err_stack;

1875: ']RevRej['||x_revenue_rejn_flag||']PcRej['||x_pc_conv_rejn_flag||
1876: ']PfcRej['||x_pfc_conv_rejn_flag||']ProjStrRej['||x_projstrlvl_rejn_flag||']';
1877: print_msg(l_debug_flag,l_proc_name,l_stage);
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_debug.reset_err_stack;
1880: END IF;
1881: Return;
1882:
1883: EXCEPTION

Line 1891: IF p_pa_debug_mode = 'Y' THEN

1887: print_msg('Y',l_proc_name,l_stage);
1888: FND_MSG_PUB.add_exc_msg
1889: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1890: ,p_procedure_name => 'Get_WbsBdgtLineRejns');
1891: IF p_pa_debug_mode = 'Y' THEN
1892: PA_DEBUG.reset_err_stack;
1893: END IF;
1894: Raise;
1895:

Line 1892: PA_DEBUG.reset_err_stack;

1888: FND_MSG_PUB.add_exc_msg
1889: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1890: ,p_procedure_name => 'Get_WbsBdgtLineRejns');
1891: IF p_pa_debug_mode = 'Y' THEN
1892: PA_DEBUG.reset_err_stack;
1893: END IF;
1894: Raise;
1895:
1896: END Get_WbsBdgtLineRejns;

Line 2058: IF p_pa_debug_mode = 'Y' THEN

2054: G_AGR_CONV_REQD_FLAG varchar2(1) := 'N';
2055: G_AGR_CURRENCY_CODE varchar2(100);
2056:
2057: BEGIN
2058: IF p_pa_debug_mode = 'Y' THEN
2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2060: END IF;
2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');

Line 2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');

2055: G_AGR_CURRENCY_CODE varchar2(100);
2056:
2057: BEGIN
2058: IF p_pa_debug_mode = 'Y' THEN
2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2060: END IF;
2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');
2063:

Line 2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);

2057: BEGIN
2058: IF p_pa_debug_mode = 'Y' THEN
2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2060: END IF;
2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');
2063:
2064: IF p_pa_debug_mode = 'Y' THEN
2065: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 2064: IF p_pa_debug_mode = 'Y' THEN

2060: END IF;
2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');
2063:
2064: IF p_pa_debug_mode = 'Y' THEN
2065: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2066: ,x_write_file => 'LOG'
2067: ,x_debug_mode => l_debug_flag
2068: );

Line 2065: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');
2063:
2064: IF p_pa_debug_mode = 'Y' THEN
2065: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2066: ,x_write_file => 'LOG'
2067: ,x_debug_mode => l_debug_flag
2068: );
2069: END IF;

Line 2122: IF p_pa_debug_mode = 'Y' THEN

2118: /* set the output variables */
2119: x_agr_curr_code := G_AGR_CURRENCY_CODE;
2120: x_AGR_CONV_REQD_FLAG := G_AGR_CONV_REQD_FLAG;
2121: -- reset error stack
2122: IF p_pa_debug_mode = 'Y' THEN
2123: pa_debug.reset_err_stack;
2124: END IF;
2125: EXCEPTION
2126: WHEN INVALID_EXCEPTION THEN

Line 2123: pa_debug.reset_err_stack;

2119: x_agr_curr_code := G_AGR_CURRENCY_CODE;
2120: x_AGR_CONV_REQD_FLAG := G_AGR_CONV_REQD_FLAG;
2121: -- reset error stack
2122: IF p_pa_debug_mode = 'Y' THEN
2123: pa_debug.reset_err_stack;
2124: END IF;
2125: EXCEPTION
2126: WHEN INVALID_EXCEPTION THEN
2127: If p_calling_mode = 'CALCULATE_API' Then

Line 2153: IF p_pa_debug_mode = 'Y' THEN

2149: fnd_msg_pub.add_exc_msg
2150: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2151: ,p_procedure_name => 'Get_Agreement_Details' );
2152: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2153: IF p_pa_debug_mode = 'Y' THEN
2154: pa_debug.reset_err_stack;
2155: END IF;
2156: RAISE;
2157: END Get_Agreement_Details;

Line 2154: pa_debug.reset_err_stack;

2150: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2151: ,p_procedure_name => 'Get_Agreement_Details' );
2152: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2153: IF p_pa_debug_mode = 'Y' THEN
2154: pa_debug.reset_err_stack;
2155: END IF;
2156: RAISE;
2157: END Get_Agreement_Details;
2158:

Line 2338: print_msg(p_pa_debug_mode,'populate_res_details','Calling get_resource_defaults');

2334: BEGIN
2335: x_return_status := 'S';
2336: --This api derives the resource defaults
2337: IF p_resource_list_member_Id_tab.COUNT > 0 THEN --{
2338: print_msg(p_pa_debug_mode,'populate_res_details','Calling get_resource_defaults');
2339: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults(
2340: p_resource_list_members => p_resource_list_member_Id_tab
2341: ,p_project_id => p_project_id
2342: ,x_resource_class_flag => l_resource_class_flag_tbl

Line 2378: print_msg(p_pa_debug_mode,'populate_res_details','RetunSts['||l_return_status||']MsgData['||l_msg_data||']');

2374: ,x_msg_data => l_msg_data
2375: ,x_msg_count => l_msg_count
2376: ,x_return_status => l_return_status
2377: );
2378: print_msg(p_pa_debug_mode,'populate_res_details','RetunSts['||l_return_status||']MsgData['||l_msg_data||']');
2379:
2380: IF NVL(l_return_status,'S') = 'S' Then
2381: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2382: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST

Line 2381: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');

2377: );
2378: print_msg(p_pa_debug_mode,'populate_res_details','RetunSts['||l_return_status||']MsgData['||l_msg_data||']');
2379:
2380: IF NVL(l_return_status,'S') = 'S' Then
2381: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2382: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2383: INSERT INTO pa_fp_res_assignments_tmp
2384: (project_id
2385: ,budget_version_id

Line 2454: print_msg(p_pa_debug_mode,'populate_res_details','End of populate_res_details retSts['||x_return_status||']');

2450: END IF;
2451:
2452: END IF; --}
2453: x_return_status := l_return_status;
2454: print_msg(p_pa_debug_mode,'populate_res_details','End of populate_res_details retSts['||x_return_status||']');
2455:
2456: EXCEPTION
2457: WHEN OTHERS THEN
2458: print_msg('Y','populate_res_details','Error occured at populate_res_details: '||sqlcode||sqlerrm);

Line 2485: print_msg(p_pa_debug_mode,'populate_ra_details','bulk insert to res_assignments_tmp table');

2481:
2482: BEGIN
2483: x_return_status := 'S';
2484: IF p_resource_assignment_id_tab.COUNT > 0 Then
2485: print_msg(p_pa_debug_mode,'populate_ra_details','bulk insert to res_assignments_tmp table');
2486: FORALL i IN p_resource_assignment_id_tab.FIRST .. p_resource_assignment_id_tab.LAST
2487: INSERT INTO pa_fp_res_assignments_tmp
2488: (project_id
2489: ,budget_version_id

Line 2551: print_msg(p_pa_debug_mode,'populate_ra_details','End of populate_ra_details retSts['||x_return_status||']');

2547: FROM pa_resource_assignments ra
2548: WHERE ra.resource_assignment_id = p_resource_assignment_id_tab(i);
2549:
2550: END IF;
2551: print_msg(p_pa_debug_mode,'populate_ra_details','End of populate_ra_details retSts['||x_return_status||']');
2552: EXCEPTION
2553: WHEN OTHERS THEN
2554: x_return_status := 'U';
2555: print_msg('Y','populate_ra_details','Error occured at populate_ra_details: '||sqlcode||sqlerrm);

Line 2871: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);

2867: BEGIN
2868:
2869: l_return_status := 'S';
2870: x_return_status := 'S';
2871: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2872: l_debug_flag := NVL(l_debug_flag, 'N');
2873:
2874: l_stage := '10:Entered Get_Res_Rates API:ProjId['||p_project_id||']BdgtVer['||p_budget_version_id||']CallingModule['||p_calling_module||']';
2875: l_stage := l_stage||' SourceContext['||p_source_context||']';

Line 3654: pa_debug.set_err_stack('PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP');

3650:
3651: BEGIN
3652:
3653: -- Set the error stack.
3654: pa_debug.set_err_stack('PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP');
3655:
3656: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3657: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3658: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 3657: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3653: -- Set the error stack.
3654: pa_debug.set_err_stack('PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP');
3655:
3656: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3657: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3658: l_debug_mode := NVL(l_debug_mode, 'Y');
3659:
3660: -- Initialize the return status to success
3661: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

3658: l_debug_mode := NVL(l_debug_mode, 'Y');
3659:
3660: -- Initialize the return status to success
3661: x_return_status := FND_API.G_RET_STS_SUCCESS;
3662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3663:
3664: IF P_PA_DEBUG_MODE = 'Y' THEN
3665: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3666: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3664: IF P_PA_DEBUG_MODE = 'Y' THEN

3660: -- Initialize the return status to success
3661: x_return_status := FND_API.G_RET_STS_SUCCESS;
3662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3663:
3664: IF P_PA_DEBUG_MODE = 'Y' THEN
3665: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3666: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3667: END IF;
3668:

Line 3665: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';

3661: x_return_status := FND_API.G_RET_STS_SUCCESS;
3662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3663:
3664: IF P_PA_DEBUG_MODE = 'Y' THEN
3665: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3666: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3667: END IF;
3668:
3669: -- Validate the input parameters.

Line 3666: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);

3662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3663:
3664: IF P_PA_DEBUG_MODE = 'Y' THEN
3665: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3666: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3667: END IF;
3668:
3669: -- Validate the input parameters.
3670:

Line 3673: IF P_PA_DEBUG_MODE = 'Y' THEN

3669: -- Validate the input parameters.
3670:
3671: IF p_source_fin_plan_version_id IS NULL THEN
3672:
3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3676:
3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;

Line 3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';

3670:
3671: IF p_source_fin_plan_version_id IS NULL THEN
3672:
3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3676:
3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3678: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);

Line 3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);

3671: IF p_source_fin_plan_version_id IS NULL THEN
3672:
3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3676:
3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3678: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3679: END IF;

Line 3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;

3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3676:
3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3678: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3679: END IF;
3680:
3681: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3678: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);

3674: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3675: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3676:
3677: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3678: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3679: END IF;
3680:
3681: x_return_status := FND_API.G_RET_STS_ERROR;
3682:

Line 3730: pa_debug.reset_err_stack;

3726:
3727: END LOOP;
3728: CLOSE C_TMP_BUDGET_LINE; -- Added for bug#6320022
3729: --Bug 2628051:- stack should be reset at the end of the api
3730: pa_debug.reset_err_stack;
3731:
3732: EXCEPTION
3733:
3734: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3750: IF P_PA_DEBUG_MODE = 'Y' THEN

3746: ELSE
3747: x_msg_count := l_msg_count;
3748: END IF;
3749: x_return_status := FND_API.G_RET_STS_ERROR;
3750: IF P_PA_DEBUG_MODE = 'Y' THEN
3751: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3752: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3753: END IF;
3754: pa_debug.reset_err_stack;

Line 3751: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);

3747: x_msg_count := l_msg_count;
3748: END IF;
3749: x_return_status := FND_API.G_RET_STS_ERROR;
3750: IF P_PA_DEBUG_MODE = 'Y' THEN
3751: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3752: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3753: END IF;
3754: pa_debug.reset_err_stack;
3755: RAISE;

Line 3752: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);

3748: END IF;
3749: x_return_status := FND_API.G_RET_STS_ERROR;
3750: IF P_PA_DEBUG_MODE = 'Y' THEN
3751: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3752: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3753: END IF;
3754: pa_debug.reset_err_stack;
3755: RAISE;
3756:

Line 3754: pa_debug.reset_err_stack;

3750: IF P_PA_DEBUG_MODE = 'Y' THEN
3751: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3752: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3753: END IF;
3754: pa_debug.reset_err_stack;
3755: RAISE;
3756:
3757: WHEN Others THEN
3758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3764: IF P_PA_DEBUG_MODE = 'Y' THEN

3760: x_msg_data := SQLERRM;
3761: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MRC_FINPLAN'
3762: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3763: ,p_error_text => SQLERRM);
3764: IF P_PA_DEBUG_MODE = 'Y' THEN
3765: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3766: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3767: END IF;
3768: pa_debug.reset_err_stack;

Line 3765: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);

3761: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MRC_FINPLAN'
3762: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3763: ,p_error_text => SQLERRM);
3764: IF P_PA_DEBUG_MODE = 'Y' THEN
3765: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3766: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3767: END IF;
3768: pa_debug.reset_err_stack;
3769: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3766: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);

3762: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3763: ,p_error_text => SQLERRM);
3764: IF P_PA_DEBUG_MODE = 'Y' THEN
3765: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3766: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3767: END IF;
3768: pa_debug.reset_err_stack;
3769: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3770:

Line 3768: pa_debug.reset_err_stack;

3764: IF P_PA_DEBUG_MODE = 'Y' THEN
3765: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3766: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3767: END IF;
3768: pa_debug.reset_err_stack;
3769: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3770:
3771: END POPULATE_BL_MAP_TMP ;
3772: