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.6.12010000.2 2008/10/14 13:34:56 spaladug 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.6.12010000.2 2008/10/14 13:34:56 spaladug 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 1973: pa_debug.init_err_stack( 'PA_FP_SPREAD_AMTS_PKG.get_options');

1969: print_msg(' '||l_stage||' enter get_options()');
1970:
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: If p_pa_debug_mode = 'Y' Then
1973: pa_debug.init_err_stack( 'PA_FP_SPREAD_AMTS_PKG.get_options');
1974: pa_debug.set_process('PLSQL', 'LOG', p_pa_debug_mode);
1975: End If;
1976:
1977: l_stage := 205;

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

2027:
2028: WHEN OTHERS THEN
2029:
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
2032: p_procedure_name => 'get_options');
2033: If p_pa_debug_mode = 'Y' Then
2034: pa_debug.reset_err_stack;
2035: End If;

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

2139: print_msg(' '||l_stage||' enter get_periods()');
2140:
2141: x_return_status := FND_API.G_RET_STS_SUCCESS;
2142: If p_pa_debug_mode = 'Y' Then
2143: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.get_periods');
2144: pa_debug.set_process('PLSQL', 'LOG', p_pa_debug_mode);
2145: End If;
2146:
2147: l_stage := 255;

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

2216:
2217: WHEN OTHERS THEN
2218:
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2220: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
2221: p_procedure_name => 'get_periods');
2222: If p_pa_debug_mode = 'Y' Then
2223: pa_debug.reset_err_stack;
2224: End If;

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

2541: print_msg(l_stage||' *** ENTERED SPREAD AMOUNTS API***');
2542: x_return_status := 'S';
2543: L_FINAL_RETURN_STATUS := 'S';
2544: If p_pa_debug_mode = 'Y' Then
2545: pa_debug.init_err_stack('PA_FP_SPREAD_AMTS_PKG.spread_amounts');
2546: End If;
2547: /* Bug fix: 4078623 Both set_curr_fun and Init_err_stack are similar, since reset_curr_function is not called
2548: * This might have been causing the plsql numeric or value error. Not sure because of this. Just to avoid
2549: * confusions commenting out this call

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

2546: End If;
2547: /* Bug fix: 4078623 Both set_curr_fun and Init_err_stack are similar, since reset_curr_function is not called
2548: * This might have been causing the plsql numeric or value error. Not sure because of this. Just to avoid
2549: * confusions commenting out this call
2550: * PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_SPREAD_AMTS_PKG.spread_amounts' ,p_debug_mode => 'Y');
2551: */
2552:
2553: -- validation
2554: IF ( p_budget_version_id IS NULL ) THEN

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

3967:
3968: print_msg('Encountered Unexpected error from Spread API['||SQLCODE||SQLERRM);
3969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3970: L_FINAL_RETURN_STATUS := 'U';
3971: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FP_SPREAD_AMTS_PKG',
3972: p_procedure_name => 'spread_amounts');
3973: If p_pa_debug_mode = 'Y' Then
3974: pa_debug.reset_err_stack;
3975: End If;

Line 3981: END PA_FP_SPREAD_AMTS_PKG;

3977:
3978: END spread_amounts;
3979:
3980:
3981: END PA_FP_SPREAD_AMTS_PKG;