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 FND_API

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: EXCEPTION
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;

Line 291: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
291: raise FND_API.G_EXC_UNEXPECTED_ERROR;
292:
293: END Process_Rounding_Diff;
294:
295: PROCEDURE Initialize_spread_plsqlTabs IS

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: EXCEPTION
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;

Line 433: raise FND_API.G_EXC_UNEXPECTED_ERROR;

429: p_procedure_name => 'blkInsertBudgetLines'||l_stage);
430: If p_pa_debug_mode = 'Y' Then
431: pa_debug.reset_err_stack;
432: End If;
433: raise FND_API.G_EXC_UNEXPECTED_ERROR;
434: END blkInsertBudgetLines;
435:
436: /* This API bulk inserts the lines into pa_fp_rollup_tmp from plsql tables */
437: PROCEDURE blkInsertFpLines(x_return_status OUT NOCOPY Varchar2) IS

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: EXCEPTION
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;

Line 512: raise FND_API.G_EXC_UNEXPECTED_ERROR;

508: p_procedure_name => 'blkInsertFpLines'||l_stage);
509: If p_pa_debug_mode = 'Y' Then
510: pa_debug.reset_err_stack;
511: End If;
512: raise FND_API.G_EXC_UNEXPECTED_ERROR;
513:
514: END blkInsertFpLines;
515:
516: /* This API bulk inserts lines into pa_fp_rollup_tmp from pa_budget_lines */

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

801: EXCEPTION
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;

Line 811: raise FND_API.G_EXC_UNEXPECTED_ERROR;

807: p_procedure_name => 'blkInsertBlFpLines'||l_stage);
808: If p_pa_debug_mode = 'Y' Then
809: pa_debug.reset_err_stack;
810: End If;
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812:
813: END blkInsertBlFpLines;
814:
815: /* This API populates the plsql tables with budget lines for bulk insert */

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

859:
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;

Line 869: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
869: raise FND_API.G_EXC_UNEXPECTED_ERROR;
870:
871: END insert_budget_line;
872:
873: /* This API populates the plsql tables with rollup tmp lines for bulk insert */

Line 921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

917:
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;

Line 927: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
927: raise FND_API.G_EXC_UNEXPECTED_ERROR;
928:
929: END insert_rollup_tmp;
930:
931: /* This API populates the plsql tables with rollup tmp lines for bulk insert */

Line 980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

976:
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;

Line 986: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
986: raise FND_API.G_EXC_UNEXPECTED_ERROR;
987:
988: END insert_rollup_tmp_with_bl;
989:
990: /* This API rounds the given amount/quantity to following precision level

Line 1021: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1024: PROCEDURE spread ( p_number_of_amounts IN INTEGER,
1025: p_amount1 IN NUMBER,

Line 1077: x_return_status := FND_API.G_RET_STS_SUCCESS;

1073:
1074: BEGIN
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:

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR;

1130: print_msg(' '||l_stage||' before validate p_number_of_amounts');
1131: -- p_number_of_amounts cannot overflow
1132: IF NOT p_number_of_amounts BETWEEN 1 AND 10 THEN
1133:
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: x_msg_data := 'PA_FP_NUM_OF_AMTS_OVERFLOW';
1136: If p_pa_debug_mode = 'Y' Then
1137: pa_debug.reset_err_stack;
1138: End If;

Line 1148: x_return_status := FND_API.G_RET_STS_ERROR;

1144: -- p_start_end_date cannot be null and
1145: -- each start_date must earlier than end_date in p_start_end_date,
1146: -- and they cannot overlap each other.
1147: IF p_start_end_date IS NULL THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149: x_msg_data := 'PA_FP_PLAN_START_END_DATE_NULL';
1150: If p_pa_debug_mode = 'Y' Then
1151: pa_debug.reset_err_stack;
1152: End If;

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR;

1162: k < p_start_end_date.COUNT() AND
1163: p_start_end_date(k + 1).start_date <=
1164: p_start_end_date(k).end_date THEN
1165:
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: x_msg_data := 'PA_FP_START_END_DATE_OVERLAP';
1168: If p_pa_debug_mode = 'Y' Then
1169: pa_debug.reset_err_stack;
1170: End If;

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

1186: print_msg(' '||l_stage||' before validate x_spread_amounts');
1187: -- x_spread_amounts cannot be NULL and
1188: -- x_spread_amounts' start end date must match with p_start_end_date.
1189: IF (x_spread_amounts IS NULL OR x_spread_amounts.COUNT() = 0 ) THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: x_msg_data := 'PA_FP_PERIODS_IS_NULL';
1192: print_msg('x_msg_data['||x_msg_data||']');
1193: If p_pa_debug_mode = 'Y' Then
1194: pa_debug.reset_err_stack;

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR;

1206: k < x_spread_amounts.COUNT() AND
1207: x_spread_amounts(k + 1).start_date <=
1208: x_spread_amounts(k).end_date THEN
1209:
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211: x_msg_data := 'PA_FP_START_END_DATE_NOT_MATCH';
1212: If p_pa_debug_mode = 'Y' Then
1213: pa_debug.reset_err_stack;
1214: End If;

Line 1224: x_return_status := FND_API.G_RET_STS_ERROR;

1220: x_spread_amounts(1).end_date OR
1221: p_start_end_date(p_start_end_date.COUNT()).end_date <
1222: x_spread_amounts(x_spread_amounts.COUNT()).start_date THEN
1223:
1224: x_return_status := FND_API.G_RET_STS_ERROR;
1225: x_msg_data := 'PA_FP_START_END_DATE_NOT_MATCH';
1226: --print_msg('x_msg_data['||x_msg_data||']');
1227: If p_pa_debug_mode = 'Y' Then
1228: pa_debug.reset_err_stack;

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: -- p_start_period = 0 AND
1245: -- p_end_period BETWEEN 1 AND x_spread_amounts.COUNT() OR
1246: -- p_start_period = 0 AND p_end_period = 0) THEN
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: x_msg_data := 'PA_FP_PERIOD_NO_MATCH';
1250: print_msg('x_msg_data['||x_msg_data||']');
1251: If p_pa_debug_mode = 'Y' Then
1252: pa_debug.reset_err_stack;

Line 1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1900: EXCEPTION
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;

Line 1910: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1906: p_procedure_name => 'spread');
1907: If p_pa_debug_mode = 'Y' Then
1908: pa_debug.reset_err_stack;
1909: End If;
1910: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END spread;
1912:
1913: PROCEDURE get_options (
1914: p_budget_version_id IN pa_budget_versions.

Line 1971: x_return_status := FND_API.G_RET_STS_SUCCESS;

1967: BEGIN
1968: l_stage := 200;
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;

Line 1990: x_return_status := FND_API.G_RET_STS_ERROR;

1986: IF get_name_and_type_csr%NOTFOUND THEN
1987:
1988: CLOSE get_name_and_type_csr;
1989:
1990: x_return_status := FND_API.G_RET_STS_ERROR;
1991: x_msg_data := 'PA_FP_CANNOT_GET_TIME_PHASE';
1992: If p_pa_debug_mode = 'Y' Then
1993: pa_debug.reset_err_stack;
1994: End If;

Line 2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2026: EXCEPTION
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;

Line 2036: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2032: p_procedure_name => 'get_options');
2033: If p_pa_debug_mode = 'Y' Then
2034: pa_debug.reset_err_stack;
2035: End If;
2036: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2037:
2038: END get_options;
2039:
2040: PROCEDURE get_periods (

Line 2141: x_return_status := FND_API.G_RET_STS_SUCCESS;

2137: BEGIN
2138: l_stage := 250;
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;

Line 2158: x_return_status := FND_API.G_RET_STS_ERROR;

2154: print_msg(' '||l_stage||' before validate p_start/end_date');
2155: -- p_start_date must less than p_end_date
2156: IF p_start_date > p_end_date THEN
2157:
2158: x_return_status := FND_API.G_RET_STS_ERROR;
2159: x_msg_data := 'PA_FP_START_END_DATE_OVERLAP';
2160: If p_pa_debug_mode = 'Y' Then
2161: pa_debug.reset_err_stack;
2162: End If;

Line 2202: x_return_status := FND_API.G_RET_STS_ERROR;

2198: x_spread_amounts(n) := tmp_rec;
2199: END LOOP;
2200:
2201: IF n = 0 AND (l_time_phase_code = 'G' OR l_time_phase_code = 'P') THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: x_msg_data := 'PA_FP_PERIODS_IS_NULL';
2204: If p_pa_debug_mode = 'Y' Then
2205: pa_debug.reset_err_stack;
2206: End If;

Line 2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2215: EXCEPTION
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;

Line 2225: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2221: p_procedure_name => 'get_periods');
2222: If p_pa_debug_mode = 'Y' Then
2223: pa_debug.reset_err_stack;
2224: End If;
2225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2226:
2227: END get_periods;
2228:
2229:

Line 2572: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2568: v_msg_data);
2569:
2570: l_stage := 805;
2571: print_msg(l_stage||'after get_options');
2572: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2573: l_stage := 806;
2574: print_msg(l_stage||' get_options() err MsgData['||v_msg_data||']');
2575: l_err_msg := v_msg_data;
2576: RAISE SPREAD_AMOUNTS_EXCEPTION;

Line 2741: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2737: v_return_status,
2738: v_msg_count,
2739: v_msg_data);
2740: print_msg(l_stage||' after get periods retSts['||v_return_status||']v_spread_amounts.coount['||v_spread_amounts.COUNT||']');
2741: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2742: l_err_msg := v_msg_data;
2743: RAISE SPREAD_AMOUNTS_EXCEPTION;
2744: END IF;
2745:

Line 3337: FND_API.G_RET_STS_SUCCESS THEN

3333: v_msg_count,
3334: v_msg_data);
3335:
3336: IF v_return_status <>
3337: FND_API.G_RET_STS_SUCCESS THEN
3338: l_err_msg := v_msg_data;
3339: RAISE SPREAD_AMOUNTS_EXCEPTION;
3340:
3341: END IF;

Line 3364: FND_API.G_RET_STS_SUCCESS THEN

3360: v_msg_count,
3361: v_msg_data);
3362:
3363: IF v_return_status <>
3364: FND_API.G_RET_STS_SUCCESS THEN
3365: l_err_msg := v_msg_data;
3366: RAISE SPREAD_AMOUNTS_EXCEPTION;
3367:
3368: END IF;

Line 3422: FND_API.G_RET_STS_SUCCESS THEN

3418: v_msg_count,
3419: v_msg_data);
3420:
3421: IF v_return_status <>
3422: FND_API.G_RET_STS_SUCCESS THEN
3423:
3424: l_err_msg := v_msg_data;
3425: RAISE SPREAD_AMOUNTS_EXCEPTION;
3426:

Line 3660: FND_API.G_RET_STS_SUCCESS THEN

3656: v_msg_count,
3657: v_msg_data);
3658:
3659: IF v_return_status <>
3660: FND_API.G_RET_STS_SUCCESS THEN
3661: l_err_msg := v_msg_data;
3662: RAISE SPREAD_AMOUNTS_EXCEPTION;
3663:
3664: END IF;

Line 3686: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3682: v_return_status,
3683: v_msg_count,
3684: v_msg_data);
3685:
3686: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3687: l_err_msg := v_msg_data;
3688: RAISE SPREAD_AMOUNTS_EXCEPTION;
3689:
3690: END IF;

Line 3719: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3715: v_return_status,
3716: v_msg_count,
3717: v_msg_data);
3718:
3719: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3720: l_err_msg := v_msg_data;
3721: RAISE SPREAD_AMOUNTS_EXCEPTION;
3722:
3723: END IF;

Line 3777: FND_API.G_RET_STS_SUCCESS THEN

3773: v_msg_count,
3774: v_msg_data);
3775:
3776: IF v_return_status <>
3777: FND_API.G_RET_STS_SUCCESS THEN
3778: l_err_msg := v_msg_data;
3779: RAISE SPREAD_AMOUNTS_EXCEPTION;
3780:
3781: END IF;

Line 3802: FND_API.G_RET_STS_SUCCESS THEN

3798: v_msg_count,
3799: v_msg_data);
3800:
3801: IF v_return_status <>
3802: FND_API.G_RET_STS_SUCCESS THEN
3803: l_err_msg := v_msg_data;
3804: RAISE SPREAD_AMOUNTS_EXCEPTION;
3805:
3806: END IF;

Line 3912: x_return_status := FND_API.G_RET_STS_ERROR;

3908: EXCEPTION
3909:
3910: WHEN SPREAD_AMOUNTS_EXCEPTION THEN
3911:
3912: x_return_status := FND_API.G_RET_STS_ERROR;
3913: L_FINAL_RETURN_STATUS := 'E';
3914: /* bug fix:4194475 open the cursor only when error msg needs to populated */
3915: print_msg(l_stage||' get project_name, task_name and resource_name');
3916: OPEN get_line_info(v_resource_assignment_id);

Line 3947: ( p_encoded => FND_API.G_TRUE

3943: /* BUG FIX 3632873 Retrive the msg from stack */
3944: print_msg('Retrive the msg from stack MsgCt['||x_msg_count||']');
3945: If x_msg_count = 1 then
3946: pa_interface_utils_pub.get_messages
3947: ( p_encoded => FND_API.G_TRUE
3948: ,p_msg_index => 1
3949: ,p_data => x_msg_data
3950: ,p_msg_index_out => l_msg_index_out
3951: );

Line 3969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3965:
3966: WHEN OTHERS THEN
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

Line 3976: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3972: p_procedure_name => 'spread_amounts');
3973: If p_pa_debug_mode = 'Y' Then
3974: pa_debug.reset_err_stack;
3975: End If;
3976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3977:
3978: END spread_amounts;
3979:
3980: