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 2062: IF p_pa_debug_mode = 'Y' THEN

2058: --Bug 5845142
2059: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2060:
2061: BEGIN
2062: IF p_pa_debug_mode = 'Y' THEN
2063: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2064: END IF;
2065: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2066: l_debug_flag := NVL(l_debug_flag, 'N');

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

2059: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2060:
2061: BEGIN
2062: IF p_pa_debug_mode = 'Y' THEN
2063: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2064: END IF;
2065: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2066: l_debug_flag := NVL(l_debug_flag, 'N');
2067:

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

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

Line 2068: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 2129: IF p_pa_debug_mode = 'Y' THEN

2125: /* set the output variables */
2126: x_agr_curr_code := G_AGR_CURRENCY_CODE;
2127: x_AGR_CONV_REQD_FLAG := G_AGR_CONV_REQD_FLAG;
2128: -- reset error stack
2129: IF p_pa_debug_mode = 'Y' THEN
2130: pa_debug.reset_err_stack;
2131: END IF;
2132: EXCEPTION
2133: WHEN INVALID_EXCEPTION THEN

Line 2130: pa_debug.reset_err_stack;

2126: x_agr_curr_code := G_AGR_CURRENCY_CODE;
2127: x_AGR_CONV_REQD_FLAG := G_AGR_CONV_REQD_FLAG;
2128: -- reset error stack
2129: IF p_pa_debug_mode = 'Y' THEN
2130: pa_debug.reset_err_stack;
2131: END IF;
2132: EXCEPTION
2133: WHEN INVALID_EXCEPTION THEN
2134: If p_calling_mode = 'CALCULATE_API' Then

Line 2160: IF p_pa_debug_mode = 'Y' THEN

2156: fnd_msg_pub.add_exc_msg
2157: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2158: ,p_procedure_name => 'Get_Agreement_Details' );
2159: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2160: IF p_pa_debug_mode = 'Y' THEN
2161: pa_debug.reset_err_stack;
2162: END IF;
2163: RAISE;
2164: END Get_Agreement_Details;

Line 2161: pa_debug.reset_err_stack;

2157: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2158: ,p_procedure_name => 'Get_Agreement_Details' );
2159: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2160: IF p_pa_debug_mode = 'Y' THEN
2161: pa_debug.reset_err_stack;
2162: END IF;
2163: RAISE;
2164: END Get_Agreement_Details;
2165:

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

2341: BEGIN
2342: x_return_status := 'S';
2343: --This api derives the resource defaults
2344: IF p_resource_list_member_Id_tab.COUNT > 0 THEN --{
2345: print_msg(p_pa_debug_mode,'populate_res_details','Calling get_resource_defaults');
2346: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults(
2347: p_resource_list_members => p_resource_list_member_Id_tab
2348: ,p_project_id => p_project_id
2349: ,x_resource_class_flag => l_resource_class_flag_tbl

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

2381: ,x_msg_data => l_msg_data
2382: ,x_msg_count => l_msg_count
2383: ,x_return_status => l_return_status
2384: );
2385: print_msg(p_pa_debug_mode,'populate_res_details','RetunSts['||l_return_status||']MsgData['||l_msg_data||']');
2386:
2387: IF NVL(l_return_status,'S') = 'S' Then
2388: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2389: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST

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

2384: );
2385: print_msg(p_pa_debug_mode,'populate_res_details','RetunSts['||l_return_status||']MsgData['||l_msg_data||']');
2386:
2387: IF NVL(l_return_status,'S') = 'S' Then
2388: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2389: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2390: INSERT INTO pa_fp_res_assignments_tmp
2391: (project_id
2392: ,budget_version_id

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

2457: END IF;
2458:
2459: END IF; --}
2460: x_return_status := l_return_status;
2461: print_msg(p_pa_debug_mode,'populate_res_details','End of populate_res_details retSts['||x_return_status||']');
2462:
2463: EXCEPTION
2464: WHEN OTHERS THEN
2465: print_msg('Y','populate_res_details','Error occured at populate_res_details: '||sqlcode||sqlerrm);

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

2488:
2489: BEGIN
2490: x_return_status := 'S';
2491: IF p_resource_assignment_id_tab.COUNT > 0 Then
2492: print_msg(p_pa_debug_mode,'populate_ra_details','bulk insert to res_assignments_tmp table');
2493: FORALL i IN p_resource_assignment_id_tab.FIRST .. p_resource_assignment_id_tab.LAST
2494: INSERT INTO pa_fp_res_assignments_tmp
2495: (project_id
2496: ,budget_version_id

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

2554: FROM pa_resource_assignments ra
2555: WHERE ra.resource_assignment_id = p_resource_assignment_id_tab(i);
2556:
2557: END IF;
2558: print_msg(p_pa_debug_mode,'populate_ra_details','End of populate_ra_details retSts['||x_return_status||']');
2559: EXCEPTION
2560: WHEN OTHERS THEN
2561: x_return_status := 'U';
2562: print_msg('Y','populate_ra_details','Error occured at populate_ra_details: '||sqlcode||sqlerrm);

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

2874: BEGIN
2875:
2876: l_return_status := 'S';
2877: x_return_status := 'S';
2878: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2879: l_debug_flag := NVL(l_debug_flag, 'N');
2880:
2881: l_stage := '10:Entered Get_Res_Rates API:ProjId['||p_project_id||']BdgtVer['||p_budget_version_id||']CallingModule['||p_calling_module||']';
2882: l_stage := l_stage||' SourceContext['||p_source_context||']';

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

3657:
3658: BEGIN
3659:
3660: -- Set the error stack.
3661: pa_debug.set_err_stack('PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP');
3662:
3663: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3664: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3665: l_debug_mode := NVL(l_debug_mode, 'Y');

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

3660: -- Set the error stack.
3661: pa_debug.set_err_stack('PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP');
3662:
3663: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3664: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3665: l_debug_mode := NVL(l_debug_mode, 'Y');
3666:
3667: -- Initialize the return status to success
3668: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3665: l_debug_mode := NVL(l_debug_mode, 'Y');
3666:
3667: -- Initialize the return status to success
3668: x_return_status := FND_API.G_RET_STS_SUCCESS;
3669: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3670:
3671: IF P_PA_DEBUG_MODE = 'Y' THEN
3672: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3673: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3671: IF P_PA_DEBUG_MODE = 'Y' THEN

3667: -- Initialize the return status to success
3668: x_return_status := FND_API.G_RET_STS_SUCCESS;
3669: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3670:
3671: IF P_PA_DEBUG_MODE = 'Y' THEN
3672: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3673: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3674: END IF;
3675:

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

3668: x_return_status := FND_API.G_RET_STS_SUCCESS;
3669: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3670:
3671: IF P_PA_DEBUG_MODE = 'Y' THEN
3672: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3673: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3674: END IF;
3675:
3676: -- Validate the input parameters.

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

3669: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3670:
3671: IF P_PA_DEBUG_MODE = 'Y' THEN
3672: pa_debug.g_err_stage := 'In PA_MRC_FINPLAN.POPULATE_BL_MAP_TMP ';
3673: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,3);
3674: END IF;
3675:
3676: -- Validate the input parameters.
3677:

Line 3680: IF P_PA_DEBUG_MODE = 'Y' THEN

3676: -- Validate the input parameters.
3677:
3678: IF p_source_fin_plan_version_id IS NULL THEN
3679:
3680: IF P_PA_DEBUG_MODE = 'Y' THEN
3681: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3682: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3683:
3684: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;

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

3677:
3678: IF p_source_fin_plan_version_id IS NULL THEN
3679:
3680: IF P_PA_DEBUG_MODE = 'Y' THEN
3681: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3682: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3683:
3684: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3685: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);

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

3678: IF p_source_fin_plan_version_id IS NULL THEN
3679:
3680: IF P_PA_DEBUG_MODE = 'Y' THEN
3681: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3682: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3683:
3684: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3685: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3686: END IF;

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

3680: IF P_PA_DEBUG_MODE = 'Y' THEN
3681: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3682: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3683:
3684: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3685: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3686: END IF;
3687:
3688: x_return_status := FND_API.G_RET_STS_ERROR;

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

3681: pa_debug.g_err_stage := 'Mandatory input parameter is null.';
3682: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3683:
3684: pa_debug.g_err_stage := 'Source Budget Version Id = ' || p_source_fin_plan_version_id;
3685: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,pa_debug.g_err_stage,5);
3686: END IF;
3687:
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689:

Line 3737: pa_debug.reset_err_stack;

3733:
3734: END LOOP;
3735: CLOSE C_TMP_BUDGET_LINE; -- Added for bug#6320022
3736: --Bug 2628051:- stack should be reset at the end of the api
3737: pa_debug.reset_err_stack;
3738:
3739: EXCEPTION
3740:
3741: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3757: IF P_PA_DEBUG_MODE = 'Y' THEN

3753: ELSE
3754: x_msg_count := l_msg_count;
3755: END IF;
3756: x_return_status := FND_API.G_RET_STS_ERROR;
3757: IF P_PA_DEBUG_MODE = 'Y' THEN
3758: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3759: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3760: END IF;
3761: pa_debug.reset_err_stack;

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

3754: x_msg_count := l_msg_count;
3755: END IF;
3756: x_return_status := FND_API.G_RET_STS_ERROR;
3757: IF P_PA_DEBUG_MODE = 'Y' THEN
3758: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3759: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3760: END IF;
3761: pa_debug.reset_err_stack;
3762: RAISE;

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

3755: END IF;
3756: x_return_status := FND_API.G_RET_STS_ERROR;
3757: IF P_PA_DEBUG_MODE = 'Y' THEN
3758: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3759: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3760: END IF;
3761: pa_debug.reset_err_stack;
3762: RAISE;
3763:

Line 3761: pa_debug.reset_err_stack;

3757: IF P_PA_DEBUG_MODE = 'Y' THEN
3758: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,'Invalid Arguments Passed. ' || x_msg_data,5);
3759: pa_debug.write_file('POPULATE_BL_MAP_TMP: Invalid Arguments Passed. ' || x_msg_data);
3760: END IF;
3761: pa_debug.reset_err_stack;
3762: RAISE;
3763:
3764: WHEN Others THEN
3765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3771: IF P_PA_DEBUG_MODE = 'Y' THEN

3767: x_msg_data := SQLERRM;
3768: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MRC_FINPLAN'
3769: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3770: ,p_error_text => SQLERRM);
3771: IF P_PA_DEBUG_MODE = 'Y' THEN
3772: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3773: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3774: END IF;
3775: pa_debug.reset_err_stack;

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

3768: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MRC_FINPLAN'
3769: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3770: ,p_error_text => SQLERRM);
3771: IF P_PA_DEBUG_MODE = 'Y' THEN
3772: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3773: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3774: END IF;
3775: pa_debug.reset_err_stack;
3776: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;

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

3769: ,p_procedure_name => 'POPULATE_BL_MAP_TMP'
3770: ,p_error_text => SQLERRM);
3771: IF P_PA_DEBUG_MODE = 'Y' THEN
3772: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3773: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3774: END IF;
3775: pa_debug.reset_err_stack;
3776: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3777:

Line 3775: pa_debug.reset_err_stack;

3771: IF P_PA_DEBUG_MODE = 'Y' THEN
3772: pa_debug.write('POPULATE_BL_MAP_TMP: ' || g_module_name,x_msg_data,4);
3773: pa_debug.write_file('POPULATE_BL_MAP_TMP: ' || x_msg_data);
3774: END IF;
3775: pa_debug.reset_err_stack;
3776: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3777:
3778: END POPULATE_BL_MAP_TMP ;
3779: