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_SPREAD_AMTS_PKG dependencies on PA_FP_SPREAD_AMTS_PKG

Line 1: PACKAGE BODY PA_FP_SPREAD_AMTS_PKG AS

1: PACKAGE BODY PA_FP_SPREAD_AMTS_PKG AS
2: --$Header: PAFPSCPB.pls 120.11 2010/09/13 09:35:45 bifernan ship $
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_SPREAD_AMTS_PKG';
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_SPREAD_AMTS_PKG';

1: PACKAGE BODY PA_FP_SPREAD_AMTS_PKG AS
2: --$Header: PAFPSCPB.pls 120.11 2010/09/13 09:35:45 bifernan ship $
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_SPREAD_AMTS_PKG';
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6: G_rate_based_flag Varchar2(10) := NULL;
7: G_Curr_code Varchar2(80) := NULL;
8: G_User_Id Number:= fnd_global.user_id;

Line 286: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

282:
283: WHEN OTHERS THEN
284: print_msg('Unexpected error in Process_Rounding_Diff ['||sqlcode||sqlerrm||']');
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
287: p_procedure_name => 'Process_Rounding_Diff'||l_stage);
288: If p_pa_debug_mode = 'Y' Then
289: pa_debug.reset_err_stack;
290: End If;

Line 428: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

424:
425: WHEN OTHERS THEN
426: print_msg('Unexpected error in blkInsertBudgetLines['||sqlcode||sqlerrm||']');
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
429: p_procedure_name => 'blkInsertBudgetLines'||l_stage);
430: If p_pa_debug_mode = 'Y' Then
431: pa_debug.reset_err_stack;
432: End If;

Line 507: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

503:
504: WHEN OTHERS THEN
505: print_msg('Unexpected error in blkInsertFpLines['||sqlcode||sqlerrm||']');
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
508: p_procedure_name => 'blkInsertFpLines'||l_stage);
509: If p_pa_debug_mode = 'Y' Then
510: pa_debug.reset_err_stack;
511: End If;

Line 806: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

802:
803: WHEN OTHERS THEN
804: print_msg('Unexpected error in blkInsertBlFpLines['||sqlcode||sqlerrm||']');
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
807: p_procedure_name => 'blkInsertBlFpLines'||l_stage);
808: If p_pa_debug_mode = 'Y' Then
809: pa_debug.reset_err_stack;
810: End If;

Line 864: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

860: EXCEPTION
861: WHEN OTHERS THEN
862: print_msg(l_stage||sqlcode||sqlerrm);
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
865: p_procedure_name => 'insert_budget_line'||l_stage);
866: If p_pa_debug_mode = 'Y' Then
867: pa_debug.reset_err_stack;
868: End If;

Line 922: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

918: EXCEPTION
919: WHEN OTHERS THEN
920:
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
923: p_procedure_name => 'insert_rollup_tmp()'||l_stage);
924: If p_pa_debug_mode = 'Y' Then
925: pa_debug.reset_err_stack;
926: End If;

Line 981: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

977:
978: EXCEPTION
979: WHEN OTHERS THEN
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
982: p_procedure_name => 'insert_rollup_tmp_with_bl()'||l_stage);
983: If p_pa_debug_mode = 'Y' Then
984: pa_debug.reset_err_stack;
985: End If;

Line 1019: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

1015: RETURN l_return_Amounts;
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: print_msg('Unexpected error in Round_Qty_Amts['||sqlcode||sqlerrm||']');
1019: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
1020: p_procedure_name => 'spread');
1021: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END Round_Qty_Amts;
1023:

Line 1079: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread');

1075: l_stage := 10;
1076: print_msg(' '||l_stage||' enter spread()');
1077: x_return_status := FND_API.G_RET_STS_SUCCESS;
1078: If p_pa_debug_mode = 'Y' Then
1079: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread');
1080: End If;
1081:
1082: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
1083: pa_debug.set_process('PLSQL', 'LOG', l_debug_mode);

Line 1085: pa_debug.g_err_stage := 'Entered PA_FP_SPREAD_AMTS_PKG.spread';

1081:
1082: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
1083: pa_debug.set_process('PLSQL', 'LOG', l_debug_mode);
1084:
1085: pa_debug.g_err_stage := 'Entered PA_FP_SPREAD_AMTS_PKG.spread';
1086: IF P_PA_DEBUG_MODE = 'Y' THEN
1087: pa_debug.write('spread: '||g_module_name,
1088: pa_debug.g_err_stage,
1089: 3);

Line 1888: pa_debug.g_err_stage := 'Leaving PA_FP_SPREAD_AMTS_PKG.spread';

1884: END IF;
1885:
1886: END LOOP;
1887:
1888: pa_debug.g_err_stage := 'Leaving PA_FP_SPREAD_AMTS_PKG.spread';
1889: IF P_PA_DEBUG_MODE = 'Y' THEN
1890: pa_debug.write('spread: '||g_module_name,
1891: pa_debug.g_err_stage,
1892: 3);

Line 1905: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

1901:
1902: WHEN OTHERS THEN
1903: print_msg('Unexpected error in Spread['||sqlcode||sqlerrm||']');
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
1906: p_procedure_name => 'spread');
1907: If p_pa_debug_mode = 'Y' Then
1908: pa_debug.reset_err_stack;
1909: End If;

Line 1964: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread_daily_level');

1960: l_stage := 10.1;
1961: print_msg(' '||l_stage||' enter spread_daily_level()');
1962: x_return_status := FND_API.G_RET_STS_SUCCESS;
1963: If p_pa_debug_mode = 'Y' Then
1964: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread_daily_level');
1965: End If;
1966:
1967: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
1968: pa_debug.set_process('PLSQL', 'LOG', l_debug_mode);

Line 1970: pa_debug.g_err_stage := 'Entered PA_FP_SPREAD_AMTS_PKG.spread_daily_level';

1966:
1967: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
1968: pa_debug.set_process('PLSQL', 'LOG', l_debug_mode);
1969:
1970: pa_debug.g_err_stage := 'Entered PA_FP_SPREAD_AMTS_PKG.spread_daily_level';
1971: IF P_PA_DEBUG_MODE = 'Y' THEN
1972: pa_debug.write('spread: '||g_module_name,
1973: pa_debug.g_err_stage,
1974: 3);

Line 2703: pa_debug.init_err_stack( 'PA_FP_SPREAD_AMTS_PKG.get_options');

2699: print_msg(' '||l_stage||' enter get_options()');
2700:
2701: x_return_status := FND_API.G_RET_STS_SUCCESS;
2702: If p_pa_debug_mode = 'Y' Then
2703: pa_debug.init_err_stack( 'PA_FP_SPREAD_AMTS_PKG.get_options');
2704: pa_debug.set_process('PLSQL', 'LOG', p_pa_debug_mode);
2705: End If;
2706:
2707: l_stage := 205;

Line 2761: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

2757:
2758: WHEN OTHERS THEN
2759:
2760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2761: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
2762: p_procedure_name => 'get_options');
2763: If p_pa_debug_mode = 'Y' Then
2764: pa_debug.reset_err_stack;
2765: End If;

Line 2873: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.get_periods');

2869: print_msg(' '||l_stage||' enter get_periods()');
2870:
2871: x_return_status := FND_API.G_RET_STS_SUCCESS;
2872: If p_pa_debug_mode = 'Y' Then
2873: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.get_periods');
2874: pa_debug.set_process('PLSQL', 'LOG', p_pa_debug_mode);
2875: End If;
2876:
2877: l_stage := 255;

Line 2950: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

2946:
2947: WHEN OTHERS THEN
2948:
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
2951: p_procedure_name => 'get_periods');
2952: If p_pa_debug_mode = 'Y' Then
2953: pa_debug.reset_err_stack;
2954: End If;

Line 3275: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread_amounts');

3271: print_msg(l_stage||' *** ENTERED SPREAD AMOUNTS API***');
3272: x_return_status := 'S';
3273: L_FINAL_RETURN_STATUS := 'S';
3274: If p_pa_debug_mode = 'Y' Then
3275: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread_amounts');
3276: End If;
3277: /* Bug fix: 4078623 Both set_curr_fun and Init_err_stack are similar, since reset_curr_function is not called
3278: * This might have been causing the plsql numeric or value error. Not sure because of this. Just to avoid
3279: * confusions commenting out this call

Line 3280: * PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_SPREAD_AMTS_PKG.spread_amounts' ,p_debug_mode => 'Y');

3276: End If;
3277: /* Bug fix: 4078623 Both set_curr_fun and Init_err_stack are similar, since reset_curr_function is not called
3278: * This might have been causing the plsql numeric or value error. Not sure because of this. Just to avoid
3279: * confusions commenting out this call
3280: * PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_SPREAD_AMTS_PKG.spread_amounts' ,p_debug_mode => 'Y');
3281: */
3282:
3283: -- validation
3284: IF ( p_budget_version_id IS NULL ) THEN

Line 4735: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',

4731:
4732: print_msg('Encountered Unexpected error from Spread API['||SQLCODE||SQLERRM);
4733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4734: L_FINAL_RETURN_STATUS := 'U';
4735: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
4736: p_procedure_name => 'spread_amounts');
4737: If p_pa_debug_mode = 'Y' Then
4738: pa_debug.reset_err_stack;
4739: End If;

Line 4745: END PA_FP_SPREAD_AMTS_PKG;

4741:
4742: END spread_amounts;
4743:
4744:
4745: END PA_FP_SPREAD_AMTS_PKG;