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_FP_CALC_PLAN_PKG dependencies on FND_MSG_PUB

Line 1353: fnd_msg_pub.add_exc_msg

1349: COMMIT;
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: x_return_status := 'U';
1353: fnd_msg_pub.add_exc_msg
1354: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
1355: ,p_procedure_name => 'SetGatherTmpTblIndxStats' );
1356: print_msg('Failed in SetGatherTmpTblIndxStats substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
1357: ROLLBACK;

Line 1458: fnd_msg_pub.add_exc_msg

1454:
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: x_return_status := 'U';
1458: fnd_msg_pub.add_exc_msg
1459: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
1460: ,p_procedure_name => 'initialize_fp_cur_details' );
1461: print_msg('Failed in initialize_fp_cur_details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
1462: RAISE;

Line 2513: fnd_msg_pub.add_exc_msg

2509: WHEN OTHERS THEN
2510: print_msg('Failed in Update_PCPFCrounding_diff API ['||sqlcode||sqlerrm);
2511: x_return_status := 'U';
2512: x_msg_data := sqlcode||sqlerrm;
2513: fnd_msg_pub.add_exc_msg
2514: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
2515: ,p_procedure_name => 'Update_PCPFC_rounding_diff' );
2516: print_msg('Failed in Update_PCPFC_rounding_diff substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2517: IF p_pa_debug_mode = 'Y' Then

Line 2743: fnd_msg_pub.add_exc_msg

2739: WHEN OTHERS THEN
2740: print_msg('Failed in Update_rounding_diff API ['||sqlcode||sqlerrm);
2741: x_return_status := 'U';
2742: x_msg_data := sqlcode||sqlerrm;
2743: fnd_msg_pub.add_exc_msg
2744: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
2745: ,p_procedure_name => 'Update_rounding_diff' );
2746: print_msg('Failed in Update_rounding_diff substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2747: IF p_pa_debug_mode = 'Y' Then

Line 3272: fnd_msg_pub.add_exc_msg

3268: WHEN OTHERS THEN
3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270: x_msg_count := 1;
3271: x_msg_data := SQLCODE||SQLERRM;
3272: fnd_msg_pub.add_exc_msg
3273: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3274: ,p_procedure_name => 'validate_inputs' );
3275: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3276: IF p_pa_debug_mode = 'Y' Then

Line 3366: fnd_msg_pub.add_exc_msg

3362: WHEN OTHERS THEN
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3364: x_msg_data := SQLCODE||SQLERRM;
3365: print_msg('Errored in Reset_Planning_end_date API ['||x_msg_data||']');
3366: fnd_msg_pub.add_exc_msg
3367: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3368: ,p_procedure_name => 'Reset_Planning_end_date');
3369: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3370: RAISE;

Line 3735: fnd_msg_pub.add_exc_msg

3731: EXCEPTION
3732:
3733: WHEN OTHERS THEN
3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: fnd_msg_pub.add_exc_msg
3736: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3737: ,p_procedure_name => 'Get_Agreement_Details' );
3738: print_msg('Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3739: IF p_pa_debug_mode = 'Y' Then

Line 4538: fnd_msg_pub.add_exc_msg

4534:
4535: EXCEPTION
4536: WHEN OTHERS THEN
4537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4538: fnd_msg_pub.add_exc_msg
4539: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
4540: ,p_procedure_name => 'clear_closed_period_etcs' );
4541: IF p_pa_debug_mode = 'Y' Then
4542: pa_debug.reset_err_stack;

Line 4654: fnd_msg_pub.add_exc_msg

4650:
4651: EXCEPTION
4652: WHEN OTHERS THEN
4653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4654: fnd_msg_pub.add_exc_msg
4655: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
4656: ,p_procedure_name => 'Upd_spread_calc_tmp' );
4657: RAISE;
4658:

Line 5583: fnd_msg_pub.add_exc_msg

5579: WHEN OTHERS THEN
5580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5581: x_msg_count := 1;
5582: x_msg_data := 'Stage['||l_stage||SQLCODE||SQLERRM;
5583: fnd_msg_pub.add_exc_msg
5584: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
5585: ,p_procedure_name => 'delete_budget_lines' );
5586: IF p_pa_debug_mode = 'Y' Then
5587: pa_debug.reset_err_stack;

Line 5704: fnd_msg_pub.add_exc_msg

5700: EXCEPTION
5701: WHEN OTHERS THEN
5702:
5703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5704: fnd_msg_pub.add_exc_msg
5705: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
5706: ,p_procedure_name => 'chk_req_rate_api_inputs' );
5707: IF p_pa_debug_mode = 'Y' Then
5708: pa_debug.reset_err_stack;

Line 6236: fnd_msg_pub.add_exc_msg

6232: EXCEPTION
6233: WHEN OTHERS THEN
6234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6235: x_msg_data := sqlcode||sqlerrm;
6236: fnd_msg_pub.add_exc_msg
6237: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6238: ,p_procedure_name => 'populate_rollup_tmp' );
6239: l_stage := 2120;
6240: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));

Line 6670: fnd_msg_pub.add_exc_msg

6666: EXCEPTION
6667: WHEN OTHERS THEN
6668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6669: x_msg_data := sqlcode||sqlerrm;
6670: fnd_msg_pub.add_exc_msg
6671: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6672: ,p_procedure_name => 'mass_adjust' );
6673: print_msg(g_stage||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
6674: IF p_pa_debug_mode = 'Y' Then

Line 6841: fnd_msg_pub.add_exc_msg

6837:
6838: EXCEPTION
6839: WHEN OTHERS THEN
6840: x_return_status := 'U';
6841: fnd_msg_pub.add_exc_msg
6842: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6843: ,p_procedure_name => 'rollup_pf_pfc_to_ra' );
6844: l_stage := 5140;
6845: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));

Line 7012: fnd_msg_pub.add_exc_msg

7008:
7009: EXCEPTION WHEN OTHERS THEN
7010:
7011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7012: fnd_msg_pub.add_exc_msg
7013: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7014: ,p_procedure_name => 'rollup_pf_pfc_to_bv' );
7015: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
7016: l_stage := 6140;

Line 7133: fnd_msg_pub.add_exc_msg

7129: EXCEPTION
7130: WHEN OTHERS THEN
7131: print_msg('Unexpected error from populate_spreadRecs['||sqlcode||sqlerrm);
7132: x_return_status := 'U';
7133: fnd_msg_pub.add_exc_msg
7134: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7135: ,p_procedure_name => 'populate_spreadRecs');
7136: RAISE;
7137: END populate_spreadRecs;

Line 7503: fnd_msg_pub.add_exc_msg

7499: WHEN OTHERS THEN
7500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7501: x_msg_count := 1;
7502: x_msg_data := sqlcode||sqlerrm;
7503: fnd_msg_pub.add_exc_msg
7504: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7505: ,p_procedure_name => 'convert_ra_txn_currency' );
7506: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
7507: print_msg('PA_FP_CALC_PLAN_PKG.convert_ra_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));

Line 8192: FND_MSG_PUB.initialize;

8188: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
8189: x_return_status := FND_API.G_RET_STS_SUCCESS;
8190:
8191: /* Initialize the msg stack */
8192: FND_MSG_PUB.initialize;
8193:
8194: SAVEPOINT start_of_calculate_api;
8195:
8196: /* Bug fix: 4078623 Set curr and init err stack both are calling but reset curr function is not done.

Line 8861: print_msg(l_stage||':Count of Errors:MsgCtinErrStack['||fnd_msg_pub.count_msg||']');

8857: l_stage := 210;
8858: If P_PA_DEBUG_MODE = 'Y' Then
8859: print_msg(to_char(l_stage)||' Entering loop using the l_resource_assignment_tab.resource_assignment_id');
8860: print_msg('l_resource_assignment_tab.first['||l_resource_assignment_tab.first||']Last['||l_resource_assignment_tab.last);
8861: print_msg(l_stage||':Count of Errors:MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
8862: End If;
8863: l_pls_start_time := dbms_utility.get_time;
8864: --print_plsql_time('Start of MainLoop2:['||l_pls_start_time);
8865: --MAIN CODE STARTS HERE

Line 10485: print_msg('Final Return Status['||x_return_status||']MsgCtinErrStack['||fnd_msg_pub.count_msg||']');

10481: FROM dual;
10482: x_return_status := l_return_status;
10483: l_entire_return_status := l_return_status;
10484: If P_PA_DEBUG_MODE = 'Y' Then
10485: print_msg('Final Return Status['||x_return_status||']MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
10486: End If;
10487: End IF;
10488:
10489: /* Added for bug 5028631 for populating pa_roll_up_tmp table with skipped lines*/

Line 11229: x_msg_count := fnd_msg_pub.count_msg;

11225: End If;
11226: ROLLBACK TO start_of_calculate_api;
11227:
11228: ElsIf x_return_status <> 'S' Then
11229: x_msg_count := fnd_msg_pub.count_msg;
11230: IF x_msg_count = 1 THEN
11231: pa_interface_utils_pub.get_messages
11232: ( p_encoded => FND_API.G_TRUE
11233: ,p_msg_index => 1

Line 11261: FND_MSG_PUB.initialize;

11257: */
11258: IF x_return_status = 'S' Then
11259: x_msg_data := NULL;
11260: x_msg_count := 0;
11261: FND_MSG_PUB.initialize;
11262: End If;
11263: /* Bug fix: 4343985 */
11264: IF cur_avgBlrts%ISOPEN then
11265: CLOSE cur_avgBlrts;

Line 11293: fnd_msg_pub.add_exc_msg

11289: End If;
11290: If x_msg_data is NULL Then
11291: x_msg_data := sqlcode||sqlerrm;
11292: End If;
11293: fnd_msg_pub.add_exc_msg
11294: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
11295: ,p_procedure_name => 'calculate:'||substr(l_stage,1,240) );
11296: pa_debug.write_file('LOG: '||substr(l_stage||':'||sqlcode||sqlerrm,1,240));
11297:

Line 11538: fnd_msg_pub.add_exc_msg

11534: End If;
11535: IF p_pa_debug_mode = 'Y' Then
11536: pa_debug.reset_err_stack;
11537: End If;
11538: fnd_msg_pub.add_exc_msg
11539: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
11540: ,p_procedure_name => 'Convert_Final_Txn_Cur_Amts' );
11541: print_msg('Unexpected Error from Convert_Final_Txn_Cur_Amts :'||x_msg_data);
11542: RAISE;

Line 12670: print_msg('get_plannig_rateAPIMsgCtinErrStack['||fnd_msg_pub.count_msg||']');

12666: ,x_msg_count => x_msg_count
12667: );
12668: If P_PA_DEBUG_MODE = 'Y' Then
12669: print_msg('Return status of the RATE API['||l_return_status||']msgData['||x_msg_data||']');
12670: print_msg('get_plannig_rateAPIMsgCtinErrStack['||fnd_msg_pub.count_msg||']');
12671: End if;
12672: If l_return_status = 'U' Then
12673: x_raw_cost_rejection_code := substr('PA_FP_ERROR_FROM_RATE_API_CALL',1,30);
12674: x_burden_cost_rejection_code := substr(SQLERRM,1,30);

Line 14115: fnd_msg_pub.add_exc_msg

14111: pa_debug.reset_err_stack;
14112: End If;
14113: EXCEPTION
14114: WHEN RATEAPI_UNEXPECTED_ERRORS THEN
14115: fnd_msg_pub.add_exc_msg
14116: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14117: ,p_procedure_name => 'Get_Res_Rates.pa_plan_revenue.Get_planning_Rates');
14118: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14119: IF p_pa_debug_mode = 'Y' Then

Line 14126: fnd_msg_pub.add_exc_msg

14122: x_return_status := 'U';
14123: RAISE;
14124:
14125: WHEN UNEXPECTED_ERRORS THEN
14126: fnd_msg_pub.add_exc_msg
14127: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14128: ,p_procedure_name => 'Get_Res_Rates:Update_rollupTmp_OvrRates');
14129: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14130: IF p_pa_debug_mode = 'Y' Then

Line 14136: fnd_msg_pub.add_exc_msg

14132: End If;
14133: x_return_status := 'U';
14134: RAISE;
14135: WHEN OTHERS THEN
14136: fnd_msg_pub.add_exc_msg
14137: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14138: ,p_procedure_name => 'Get_Res_Rates');
14139: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14140: IF p_pa_debug_mode = 'Y' Then

Line 15751: fnd_msg_pub.add_exc_msg

15747: EXCEPTION
15748: WHEN OTHERS THEN
15749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15750: x_msg_data := sqlcode||sqlerrm;
15751: fnd_msg_pub.add_exc_msg
15752: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
15753: ,p_procedure_name => 'Process_skipped_records' );
15754: l_stage := 2120;
15755: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));