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 1383: fnd_msg_pub.add_exc_msg

1379: COMMIT;
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: x_return_status := 'U';
1383: fnd_msg_pub.add_exc_msg
1384: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
1385: ,p_procedure_name => 'SetGatherTmpTblIndxStats' );
1386: print_msg('Failed in SetGatherTmpTblIndxStats substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
1387: ROLLBACK;

Line 1488: fnd_msg_pub.add_exc_msg

1484:
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: x_return_status := 'U';
1488: fnd_msg_pub.add_exc_msg
1489: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
1490: ,p_procedure_name => 'initialize_fp_cur_details' );
1491: print_msg('Failed in initialize_fp_cur_details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
1492: RAISE;

Line 2543: fnd_msg_pub.add_exc_msg

2539: WHEN OTHERS THEN
2540: print_msg('Failed in Update_PCPFCrounding_diff API ['||sqlcode||sqlerrm);
2541: x_return_status := 'U';
2542: x_msg_data := sqlcode||sqlerrm;
2543: fnd_msg_pub.add_exc_msg
2544: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
2545: ,p_procedure_name => 'Update_PCPFC_rounding_diff' );
2546: print_msg('Failed in Update_PCPFC_rounding_diff substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2547: IF p_pa_debug_mode = 'Y' Then

Line 2773: fnd_msg_pub.add_exc_msg

2769: WHEN OTHERS THEN
2770: print_msg('Failed in Update_rounding_diff API ['||sqlcode||sqlerrm);
2771: x_return_status := 'U';
2772: x_msg_data := sqlcode||sqlerrm;
2773: fnd_msg_pub.add_exc_msg
2774: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
2775: ,p_procedure_name => 'Update_rounding_diff' );
2776: print_msg('Failed in Update_rounding_diff substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2777: IF p_pa_debug_mode = 'Y' Then

Line 3302: fnd_msg_pub.add_exc_msg

3298: WHEN OTHERS THEN
3299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3300: x_msg_count := 1;
3301: x_msg_data := SQLCODE||SQLERRM;
3302: fnd_msg_pub.add_exc_msg
3303: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3304: ,p_procedure_name => 'validate_inputs' );
3305: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3306: IF p_pa_debug_mode = 'Y' Then

Line 3398: fnd_msg_pub.add_exc_msg

3394: WHEN OTHERS THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3396: x_msg_data := SQLCODE||SQLERRM;
3397: print_msg('Errored in Reset_Planning_end_date API ['||x_msg_data||']');
3398: fnd_msg_pub.add_exc_msg
3399: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3400: ,p_procedure_name => 'Reset_Planning_end_date');
3401: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3402: RAISE;

Line 3767: fnd_msg_pub.add_exc_msg

3763: EXCEPTION
3764:
3765: WHEN OTHERS THEN
3766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3767: fnd_msg_pub.add_exc_msg
3768: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
3769: ,p_procedure_name => 'Get_Agreement_Details' );
3770: print_msg('Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
3771: IF p_pa_debug_mode = 'Y' Then

Line 4573: fnd_msg_pub.add_exc_msg

4569:
4570: EXCEPTION
4571: WHEN OTHERS THEN
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4573: fnd_msg_pub.add_exc_msg
4574: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
4575: ,p_procedure_name => 'clear_closed_period_etcs' );
4576: IF p_pa_debug_mode = 'Y' Then
4577: pa_debug.reset_err_stack;

Line 4689: fnd_msg_pub.add_exc_msg

4685:
4686: EXCEPTION
4687: WHEN OTHERS THEN
4688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4689: fnd_msg_pub.add_exc_msg
4690: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
4691: ,p_procedure_name => 'Upd_spread_calc_tmp' );
4692: RAISE;
4693:

Line 5618: fnd_msg_pub.add_exc_msg

5614: WHEN OTHERS THEN
5615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5616: x_msg_count := 1;
5617: x_msg_data := 'Stage['||l_stage||SQLCODE||SQLERRM;
5618: fnd_msg_pub.add_exc_msg
5619: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
5620: ,p_procedure_name => 'delete_budget_lines' );
5621: IF p_pa_debug_mode = 'Y' Then
5622: pa_debug.reset_err_stack;

Line 5739: fnd_msg_pub.add_exc_msg

5735: EXCEPTION
5736: WHEN OTHERS THEN
5737:
5738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5739: fnd_msg_pub.add_exc_msg
5740: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
5741: ,p_procedure_name => 'chk_req_rate_api_inputs' );
5742: IF p_pa_debug_mode = 'Y' Then
5743: pa_debug.reset_err_stack;

Line 6271: fnd_msg_pub.add_exc_msg

6267: EXCEPTION
6268: WHEN OTHERS THEN
6269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6270: x_msg_data := sqlcode||sqlerrm;
6271: fnd_msg_pub.add_exc_msg
6272: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6273: ,p_procedure_name => 'populate_rollup_tmp' );
6274: l_stage := 2120;
6275: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));

Line 6705: fnd_msg_pub.add_exc_msg

6701: EXCEPTION
6702: WHEN OTHERS THEN
6703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6704: x_msg_data := sqlcode||sqlerrm;
6705: fnd_msg_pub.add_exc_msg
6706: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6707: ,p_procedure_name => 'mass_adjust' );
6708: print_msg(g_stage||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
6709: IF p_pa_debug_mode = 'Y' Then

Line 6931: fnd_msg_pub.add_exc_msg

6927:
6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: x_return_status := 'U';
6931: fnd_msg_pub.add_exc_msg
6932: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
6933: ,p_procedure_name => 'rollup_pf_pfc_to_ra' );
6934: l_stage := 5140;
6935: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));

Line 7102: fnd_msg_pub.add_exc_msg

7098:
7099: EXCEPTION WHEN OTHERS THEN
7100:
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: fnd_msg_pub.add_exc_msg
7103: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7104: ,p_procedure_name => 'rollup_pf_pfc_to_bv' );
7105: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
7106: l_stage := 6140;

Line 7223: fnd_msg_pub.add_exc_msg

7219: EXCEPTION
7220: WHEN OTHERS THEN
7221: print_msg('Unexpected error from populate_spreadRecs['||sqlcode||sqlerrm);
7222: x_return_status := 'U';
7223: fnd_msg_pub.add_exc_msg
7224: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7225: ,p_procedure_name => 'populate_spreadRecs');
7226: RAISE;
7227: END populate_spreadRecs;

Line 7593: fnd_msg_pub.add_exc_msg

7589: WHEN OTHERS THEN
7590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7591: x_msg_count := 1;
7592: x_msg_data := sqlcode||sqlerrm;
7593: fnd_msg_pub.add_exc_msg
7594: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
7595: ,p_procedure_name => 'convert_ra_txn_currency' );
7596: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
7597: print_msg('PA_FP_CALC_PLAN_PKG.convert_ra_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));

Line 8299: FND_MSG_PUB.initialize;

8295: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
8296: x_return_status := FND_API.G_RET_STS_SUCCESS;
8297:
8298: /* Initialize the msg stack */
8299: FND_MSG_PUB.initialize;
8300:
8301: SAVEPOINT start_of_calculate_api;
8302:
8303: /* Bug fix: 4078623 Set curr and init err stack both are calling but reset curr function is not done.

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

8964: l_stage := 210;
8965: If P_PA_DEBUG_MODE = 'Y' Then
8966: print_msg(to_char(l_stage)||' Entering loop using the l_resource_assignment_tab.resource_assignment_id');
8967: print_msg('l_resource_assignment_tab.first['||l_resource_assignment_tab.first||']Last['||l_resource_assignment_tab.last);
8968: print_msg(l_stage||':Count of Errors:MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
8969: End If;
8970: l_pls_start_time := dbms_utility.get_time;
8971: --print_plsql_time('Start of MainLoop2:['||l_pls_start_time);
8972: --MAIN CODE STARTS HERE

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

10588: FROM dual;
10589: x_return_status := l_return_status;
10590: l_entire_return_status := l_return_status;
10591: If P_PA_DEBUG_MODE = 'Y' Then
10592: print_msg('Final Return Status['||x_return_status||']MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
10593: End If;
10594: End IF;
10595:
10596: /* Added for bug 5028631 for populating pa_roll_up_tmp table with skipped lines*/

Line 11148: FND_MSG_PUB.initialize;

11144: WHEN OTHERS THEN
11145: NULL;
11146: END;
11147: IF NVL(l_locked,'X') = 'P' THEN
11148: FND_MSG_PUB.initialize;
11149: l_return_status := FND_API.G_RET_STS_ERROR;
11150:
11151: FND_MESSAGE.SET_NAME('PA', 'PA_FP_LOCKED_BY_PROCESSING');
11152: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);

Line 11152: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);

11148: FND_MSG_PUB.initialize;
11149: l_return_status := FND_API.G_RET_STS_ERROR;
11150:
11151: FND_MESSAGE.SET_NAME('PA', 'PA_FP_LOCKED_BY_PROCESSING');
11152: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);
11153: END IF;
11154: END IF;
11155: END;
11156:

Line 11409: x_msg_count := fnd_msg_pub.count_msg;

11405: End If;
11406: ROLLBACK TO start_of_calculate_api;
11407:
11408: ElsIf x_return_status <> 'S' Then
11409: x_msg_count := fnd_msg_pub.count_msg;
11410: IF x_msg_count = 1 THEN
11411: pa_interface_utils_pub.get_messages
11412: ( p_encoded => FND_API.G_TRUE
11413: ,p_msg_index => 1

Line 11441: FND_MSG_PUB.initialize;

11437: */
11438: IF x_return_status = 'S' Then
11439: x_msg_data := NULL;
11440: x_msg_count := 0;
11441: FND_MSG_PUB.initialize;
11442: End If;
11443: /* Bug fix: 4343985 */
11444: IF cur_avgBlrts%ISOPEN then
11445: CLOSE cur_avgBlrts;

Line 11473: fnd_msg_pub.add_exc_msg

11469: End If;
11470: If x_msg_data is NULL Then
11471: x_msg_data := sqlcode||sqlerrm;
11472: End If;
11473: fnd_msg_pub.add_exc_msg
11474: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
11475: ,p_procedure_name => 'calculate:'||substr(l_stage,1,240) );
11476: pa_debug.write_file('LOG: '||substr(l_stage||':'||sqlcode||sqlerrm,1,240));
11477:

Line 11718: fnd_msg_pub.add_exc_msg

11714: End If;
11715: IF p_pa_debug_mode = 'Y' Then
11716: pa_debug.reset_err_stack;
11717: End If;
11718: fnd_msg_pub.add_exc_msg
11719: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
11720: ,p_procedure_name => 'Convert_Final_Txn_Cur_Amts' );
11721: print_msg('Unexpected Error from Convert_Final_Txn_Cur_Amts :'||x_msg_data);
11722: RAISE;

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

12857: ,x_msg_count => x_msg_count
12858: );
12859: If P_PA_DEBUG_MODE = 'Y' Then
12860: print_msg('Return status of the RATE API['||l_return_status||']msgData['||x_msg_data||']');
12861: print_msg('get_plannig_rateAPIMsgCtinErrStack['||fnd_msg_pub.count_msg||']');
12862: End if;
12863: If l_return_status = 'U' Then
12864: x_raw_cost_rejection_code := substr('PA_FP_ERROR_FROM_RATE_API_CALL',1,30);
12865: x_burden_cost_rejection_code := substr(SQLERRM,1,30);

Line 14327: fnd_msg_pub.add_exc_msg

14323: pa_debug.reset_err_stack;
14324: End If;
14325: EXCEPTION
14326: WHEN RATEAPI_UNEXPECTED_ERRORS THEN
14327: fnd_msg_pub.add_exc_msg
14328: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14329: ,p_procedure_name => 'Get_Res_Rates.pa_plan_revenue.Get_planning_Rates');
14330: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14331: IF p_pa_debug_mode = 'Y' Then

Line 14338: fnd_msg_pub.add_exc_msg

14334: x_return_status := 'U';
14335: RAISE;
14336:
14337: WHEN UNEXPECTED_ERRORS THEN
14338: fnd_msg_pub.add_exc_msg
14339: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14340: ,p_procedure_name => 'Get_Res_Rates:Update_rollupTmp_OvrRates');
14341: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14342: IF p_pa_debug_mode = 'Y' Then

Line 14348: fnd_msg_pub.add_exc_msg

14344: End If;
14345: x_return_status := 'U';
14346: RAISE;
14347: WHEN OTHERS THEN
14348: fnd_msg_pub.add_exc_msg
14349: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
14350: ,p_procedure_name => 'Get_Res_Rates');
14351: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
14352: IF p_pa_debug_mode = 'Y' Then

Line 15963: fnd_msg_pub.add_exc_msg

15959: EXCEPTION
15960: WHEN OTHERS THEN
15961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15962: x_msg_data := sqlcode||sqlerrm;
15963: fnd_msg_pub.add_exc_msg
15964: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
15965: ,p_procedure_name => 'Process_skipped_records' );
15966: l_stage := 2120;
15967: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));