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_COPY_ACTUALS_PUB dependencies on PA_DEBUG

Line 3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE body PA_FP_COPY_ACTUALS_PUB as
2: /* $Header: PAFPCAPB.pls 120.6.12010000.2 2008/08/20 11:42:30 sugupta ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /**This procedure is called to copy actuals to budget version lines**/
6: PROCEDURE COPY_ACTUALS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

Line 535: IF P_PA_DEBUG_MODE = 'Y' THEN

531: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%TYPE;
532:
533: l_etc_start_date DATE;
534: BEGIN
535: IF P_PA_DEBUG_MODE = 'Y' THEN
536: pa_debug.set_curr_function( p_function => 'COPY_ACTUALS',
537: p_debug_mode => p_pa_debug_mode );
538: END IF;
539:

Line 536: pa_debug.set_curr_function( p_function => 'COPY_ACTUALS',

532:
533: l_etc_start_date DATE;
534: BEGIN
535: IF P_PA_DEBUG_MODE = 'Y' THEN
536: pa_debug.set_curr_function( p_function => 'COPY_ACTUALS',
537: p_debug_mode => p_pa_debug_mode );
538: END IF;
539:
540: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 537: p_debug_mode => p_pa_debug_mode );

533: l_etc_start_date DATE;
534: BEGIN
535: IF P_PA_DEBUG_MODE = 'Y' THEN
536: pa_debug.set_curr_function( p_function => 'COPY_ACTUALS',
537: p_debug_mode => p_pa_debug_mode );
538: END IF;
539:
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541: x_msg_count := 0;

Line 630: IF P_PA_DEBUG_MODE = 'Y' THEN

626: ELSE
627: l_record_type := l_record_type||'N';
628: END IF;
629: l_record_type := l_record_type||'N';
630: IF P_PA_DEBUG_MODE = 'Y' THEN
631: pa_fp_gen_amount_utils.fp_debug
632: (p_msg => 'Before calling pji_fm_xbs_accum_tmp1',
633: p_module_name => l_module_name,
634: p_log_level => 5);

Line 666: IF P_PA_DEBUG_MODE = 'Y' THEN

662:
663: --hr_utility.trace('after entering get_sum:'||x_return_status);
664: --delete from get_sum_test;
665: --insert into get_sum_test (select * from pji_fm_xbs_accum_tmp1);
666: IF P_PA_DEBUG_MODE = 'Y' THEN
667: pa_fp_gen_amount_utils.fp_debug
668: (p_msg => 'After calling pji_fm_xbs_accum_tmp1,return status is: '||x_return_status,
669: p_module_name => l_module_name,
670: p_log_level => 5);

Line 678: IF P_PA_DEBUG_MODE = 'Y' THEN

674: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
675: END IF;
676:
677: IF l_count = 0 THEN
678: IF P_PA_DEBUG_MODE = 'Y' THEN
679: pa_fp_gen_amount_utils.fp_debug
680: (p_msg => 'no actual data as of '||
681: to_char(p_end_date,'dd-mon-rrrr'),
682: p_module_name => l_module_name,

Line 684: PA_DEBUG.RESET_CURR_FUNCTION;

680: (p_msg => 'no actual data as of '||
681: to_char(p_end_date,'dd-mon-rrrr'),
682: p_module_name => l_module_name,
683: p_log_level => 5);
684: PA_DEBUG.RESET_CURR_FUNCTION;
685: END IF;
686: RETURN;
687: END IF;
688:

Line 741: IF P_PA_DEBUG_MODE = 'Y' THEN

737: FROM PJI_FM_XBS_ACCUM_TMP1);
738: -- select count(*) into l_count from pa_resource_assignments where
739: -- budget_version_id = p_budget_version_id;
740: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_fp_gen_amount_utils.fp_debug
743: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
744: p_module_name => l_module_name,
745: p_log_level => 5);

Line 755: IF P_PA_DEBUG_MODE = 'Y' THEN

751: X_RETURN_STATUS => x_return_status,
752: X_MSG_COUNT => x_msg_count,
753: X_MSG_DATA => x_msg_data );
754: --dbms_output.put_line('Status after calling cre res asg api: '||x_return_status);
755: IF P_PA_DEBUG_MODE = 'Y' THEN
756: pa_fp_gen_amount_utils.fp_debug
757: (p_msg => 'After calling create_res_asg,return status is: '||x_return_status,
758: p_module_name => l_module_name,
759: p_log_level => 5);

Line 768: IF P_PA_DEBUG_MODE = 'Y' THEN

764:
765: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
766: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
767: **/
768: IF P_PA_DEBUG_MODE = 'Y' THEN
769: pa_fp_gen_amount_utils.fp_debug
770: (p_msg => 'Before calling update_res_asg',
771: p_module_name => l_module_name,
772: p_log_level => 5);

Line 782: IF P_PA_DEBUG_MODE = 'Y' THEN

778: X_RETURN_STATUS => x_return_status,
779: X_MSG_COUNT => x_msg_count,
780: X_MSG_DATA => x_msg_data);
781: --dbms_output.put_line('Status after calling upd res asg api: '||x_return_status);
782: IF P_PA_DEBUG_MODE = 'Y' THEN
783: pa_fp_gen_amount_utils.fp_debug
784: (p_msg => 'After calling update_res_asg,return status is: '||x_return_status,
785: p_module_name => l_module_name,
786: p_log_level => 5);

Line 810: IF P_PA_DEBUG_MODE = 'Y' THEN

806: l_txn_currency_code_tab;
807: CLOSE distinct_ra_curr_cursor;
808: --dbms_output.put_line('Closing distinct_ra_curr_cursor');
809: IF l_res_asg_id_tab.count = 0 THEN
810: IF P_PA_DEBUG_MODE = 'Y' THEN
811: PA_DEBUG.RESET_CURR_FUNCTION;
812: END IF;
813: RETURN;
814: END IF;

Line 811: PA_DEBUG.RESET_CURR_FUNCTION;

807: CLOSE distinct_ra_curr_cursor;
808: --dbms_output.put_line('Closing distinct_ra_curr_cursor');
809: IF l_res_asg_id_tab.count = 0 THEN
810: IF P_PA_DEBUG_MODE = 'Y' THEN
811: PA_DEBUG.RESET_CURR_FUNCTION;
812: END IF;
813: RETURN;
814: END IF;
815:

Line 1004: IF P_PA_DEBUG_MODE = 'Y' THEN

1000: END IF; */
1001:
1002: END LOOP;
1003:
1004: IF P_PA_DEBUG_MODE = 'Y' THEN
1005: pa_fp_gen_amount_utils.fp_debug
1006: (p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA',
1007: p_module_name => l_module_name,
1008: p_log_level => 5);

Line 1025: IF P_PA_DEBUG_MODE = 'Y' THEN

1021: X_RETURN_STATUS => x_return_Status,
1022: X_MSG_COUNT => x_msg_count,
1023: X_MSG_DATA => x_msg_data );
1024: --dbms_output.put_line('Status after calling MAINTAIN_ACTUAL_AMT_RA api: '||x_return_status);
1025: IF P_PA_DEBUG_MODE = 'Y' THEN
1026: pa_fp_gen_amount_utils.fp_debug
1027: (p_msg => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA,
1028: return status is: '||x_return_status,
1029: p_module_name => l_module_name,

Line 1041: IF p_pa_debug_mode = 'Y' THEN

1037:
1038: /* the planning start date and end date in pa_resource assignments table
1039: * should be synched up with the budget lines after copying the actual
1040: * data for all the planning resources. */
1041: IF p_pa_debug_mode = 'Y' THEN
1042: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1043: ( p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1044: 'SYNC_UP_PLANNING_DATES',
1045: p_module_name => l_module_name,

Line 1056: IF p_pa_debug_mode = 'Y' THEN

1052: X_RETURN_STATUS => x_return_Status,
1053: X_MSG_COUNT => x_msg_count,
1054: X_MSG_DATA => x_msg_data );
1055: --dbms_output.put_line('Status after calling SYNC_UP_PLANNING_DATES api: '||x_return_status);
1056: IF p_pa_debug_mode = 'Y' THEN
1057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1058: ( p_msg => 'Aft calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1059: 'SYNC_UP_PLANNING_DATES return status ' ||
1060: x_return_status,

Line 1096: IF p_pa_debug_mode = 'Y' THEN

1092: WHERE tmp.resource_assignment_id = rbc.resource_assignment_id
1093: AND tmp.txn_currency_code = rbc.txn_currency_code );
1094:
1095: -- Call the maintenance api in ROLLUP mode
1096: IF p_pa_debug_mode = 'Y' THEN
1097: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1098: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
1099: 'MAINTAIN_DATA',
1100: --P_CALLED_MODE => p_called_mode,

Line 1113: IF p_pa_debug_mode = 'Y' THEN

1109: X_RETURN_STATUS => x_return_status,
1110:
1111: X_MSG_COUNT => x_msg_count,
1112: X_MSG_DATA => x_msg_data );
1113: IF p_pa_debug_mode = 'Y' THEN
1114: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1115: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
1116: 'MAINTAIN_DATA: '||x_return_status,
1117: --P_CALLED_MODE => p_called_mode,

Line 1130: IF P_PA_DEBUG_MODE = 'Y' THEN

1126:
1127: IF P_COMMIT_FLAG = 'Y' THEN
1128: COMMIT;
1129: END IF;
1130: IF P_PA_DEBUG_MODE = 'Y' THEN
1131: PA_DEBUG.RESET_CURR_FUNCTION;
1132: END IF;
1133: EXCEPTION
1134: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1131: PA_DEBUG.RESET_CURR_FUNCTION;

1127: IF P_COMMIT_FLAG = 'Y' THEN
1128: COMMIT;
1129: END IF;
1130: IF P_PA_DEBUG_MODE = 'Y' THEN
1131: PA_DEBUG.RESET_CURR_FUNCTION;
1132: END IF;
1133: EXCEPTION
1134: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1135: l_msg_count := FND_MSG_PUB.count_msg;

Line 1153: IF P_PA_DEBUG_MODE = 'Y' THEN

1149:
1150: ROLLBACK;
1151:
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: IF P_PA_DEBUG_MODE = 'Y' THEN
1154: pa_fp_gen_amount_utils.fp_debug
1155: (p_msg => 'Invalid Arguments Passed',
1156: p_module_name => l_module_name,
1157: p_log_level => 5);

Line 1158: PA_DEBUG.RESET_CURR_FUNCTION;

1154: pa_fp_gen_amount_utils.fp_debug
1155: (p_msg => 'Invalid Arguments Passed',
1156: p_module_name => l_module_name,
1157: p_log_level => 5);
1158: PA_DEBUG.RESET_CURR_FUNCTION;
1159: END IF;
1160: RAISE;
1161: WHEN OTHERS THEN
1162: rollback;

Line 1172: IF P_PA_DEBUG_MODE = 'Y' THEN

1168: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1169: p_procedure_name => 'COPY_ACTUALS',
1170: p_error_text => substr(sqlerrm,1,240));
1171:
1172: IF P_PA_DEBUG_MODE = 'Y' THEN
1173: pa_fp_gen_amount_utils.fp_debug
1174: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1175: p_module_name => l_module_name,
1176: p_log_level => 5);

Line 1177: PA_DEBUG.RESET_CURR_FUNCTION;

1173: pa_fp_gen_amount_utils.fp_debug
1174: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1175: p_module_name => l_module_name,
1176: p_log_level => 5);
1177: PA_DEBUG.RESET_CURR_FUNCTION;
1178: END IF;
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180:
1181: END COPY_ACTUALS;

Line 1343: IF P_PA_DEBUG_MODE = 'Y' THEN

1339: l_rec_ver_number_1 NUMBER:=1;
1340:
1341: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1342: BEGIN
1343: IF P_PA_DEBUG_MODE = 'Y' THEN
1344: pa_debug.set_curr_function( p_function => 'CREATE_RES_ASG',
1345: p_debug_mode => p_pa_debug_mode );
1346: END IF;
1347:

Line 1344: pa_debug.set_curr_function( p_function => 'CREATE_RES_ASG',

1340:
1341: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1342: BEGIN
1343: IF P_PA_DEBUG_MODE = 'Y' THEN
1344: pa_debug.set_curr_function( p_function => 'CREATE_RES_ASG',
1345: p_debug_mode => p_pa_debug_mode );
1346: END IF;
1347:
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1345: p_debug_mode => p_pa_debug_mode );

1341: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1342: BEGIN
1343: IF P_PA_DEBUG_MODE = 'Y' THEN
1344: pa_debug.set_curr_function( p_function => 'CREATE_RES_ASG',
1345: p_debug_mode => p_pa_debug_mode );
1346: END IF;
1347:
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349: x_msg_count := 0;

Line 1352: IF P_PA_DEBUG_MODE = 'Y' THEN

1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349: x_msg_count := 0;
1350:
1351: IF (P_FP_COLS_REC.X_BUDGET_VERSION_ID IS NULL) THEN
1352: IF P_PA_DEBUG_MODE = 'Y' THEN
1353: pa_fp_gen_amount_utils.fp_debug
1354: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1355: p_module_name => l_module_name,
1356: p_log_level => 5);

Line 1365: IF P_PA_DEBUG_MODE = 'Y' THEN

1361: X_FP_COLS_REC => l_fp_cols_rec,
1362: X_RETURN_STATUS => x_return_status,
1363: X_MSG_COUNT => x_msg_count,
1364: X_MSG_DATA => x_msg_data);
1365: IF P_PA_DEBUG_MODE = 'Y' THEN
1366: pa_fp_gen_amount_utils.fp_debug
1367: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,
1368: return status:'||x_return_status,
1369: p_module_name => l_module_name,

Line 1454: IF P_PA_DEBUG_MODE = 'Y' THEN

1450: CLOSE topTask_res_asg_cur;
1451: END IF;
1452: -- hr_utility.trace('in create res asg tab count '||l_task_id_tab.count);
1453: IF (l_task_id_tab.count = 0 ) THEN
1454: IF P_PA_DEBUG_MODE = 'Y' THEN
1455: PA_DEBUG.RESET_CURR_FUNCTION;
1456: END IF;
1457: RETURN;
1458: END IF;

Line 1455: PA_DEBUG.RESET_CURR_FUNCTION;

1451: END IF;
1452: -- hr_utility.trace('in create res asg tab count '||l_task_id_tab.count);
1453: IF (l_task_id_tab.count = 0 ) THEN
1454: IF P_PA_DEBUG_MODE = 'Y' THEN
1455: PA_DEBUG.RESET_CURR_FUNCTION;
1456: END IF;
1457: RETURN;
1458: END IF;
1459:

Line 1496: IF P_PA_DEBUG_MODE = 'Y' THEN

1492: l_res_as_type_USER_ENTERED,
1493: l_rec_ver_number_1,
1494: l_etc_src_code_tab(i)
1495: );
1496: IF P_PA_DEBUG_MODE = 'Y' THEN
1497: pa_fp_gen_amount_utils.fp_debug
1498: (p_msg => 'Before calling update_res_defaults',
1499: p_module_name => l_module_name,
1500: p_log_level => 5);

Line 1508: IF P_PA_DEBUG_MODE = 'Y' THEN

1504: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1505: X_RETURN_STATUS => x_return_status,
1506: X_MSG_COUNT => x_msg_count,
1507: X_MSG_DATA => x_msg_data );
1508: IF P_PA_DEBUG_MODE = 'Y' THEN
1509: pa_fp_gen_amount_utils.fp_debug
1510: (p_msg => 'Before calling update_res_defaults',
1511: p_module_name => l_module_name,
1512: p_log_level => 5);

Line 1529: IF P_PA_DEBUG_MODE = 'Y' THEN

1525: WHERE SP_FIXED_DATE IS NULL
1526: AND SPREAD_CURVE_ID = l_spread_curve_id
1527: AND BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
1528:
1529: IF P_PA_DEBUG_MODE = 'Y' THEN
1530: PA_DEBUG.RESET_CURR_FUNCTION;
1531: END IF;
1532: EXCEPTION
1533: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1530: PA_DEBUG.RESET_CURR_FUNCTION;

1526: AND SPREAD_CURVE_ID = l_spread_curve_id
1527: AND BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
1528:
1529: IF P_PA_DEBUG_MODE = 'Y' THEN
1530: PA_DEBUG.RESET_CURR_FUNCTION;
1531: END IF;
1532: EXCEPTION
1533: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1534: l_msg_count := FND_MSG_PUB.count_msg;

Line 1552: IF P_PA_DEBUG_MODE = 'Y' THEN

1548:
1549: ROLLBACK;
1550:
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: IF P_PA_DEBUG_MODE = 'Y' THEN
1553: pa_fp_gen_amount_utils.fp_debug
1554: (p_msg => 'Invalid Arguments Passed',
1555: p_module_name => l_module_name,
1556: p_log_level => 5);

Line 1557: PA_DEBUG.RESET_CURR_FUNCTION;

1553: pa_fp_gen_amount_utils.fp_debug
1554: (p_msg => 'Invalid Arguments Passed',
1555: p_module_name => l_module_name,
1556: p_log_level => 5);
1557: PA_DEBUG.RESET_CURR_FUNCTION;
1558: END IF;
1559: RAISE;
1560: WHEN OTHERS THEN
1561: rollback;

Line 1571: IF P_PA_DEBUG_MODE = 'Y' THEN

1567: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1568: p_procedure_name => 'CREATE_RES_ASG',
1569: p_error_text => substr(sqlerrm,1,240));
1570:
1571: IF P_PA_DEBUG_MODE = 'Y' THEN
1572: pa_fp_gen_amount_utils.fp_debug
1573: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1574: p_module_name => l_module_name,
1575: p_log_level => 5);

Line 1576: PA_DEBUG.RESET_CURR_FUNCTION;

1572: pa_fp_gen_amount_utils.fp_debug
1573: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1574: p_module_name => l_module_name,
1575: p_log_level => 5);
1576: PA_DEBUG.RESET_CURR_FUNCTION;
1577: END IF;
1578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1579: END CREATE_RES_ASG;
1580:

Line 1602: IF P_PA_DEBUG_MODE = 'Y' THEN

1598: l_msg_index_out NUMBER;
1599:
1600: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1601: BEGIN
1602: IF P_PA_DEBUG_MODE = 'Y' THEN
1603: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',
1604: p_debug_mode => p_pa_debug_mode );
1605: END IF;
1606:

Line 1603: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',

1599:
1600: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1601: BEGIN
1602: IF P_PA_DEBUG_MODE = 'Y' THEN
1603: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',
1604: p_debug_mode => p_pa_debug_mode );
1605: END IF;
1606:
1607: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1604: p_debug_mode => p_pa_debug_mode );

1600: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1601: BEGIN
1602: IF P_PA_DEBUG_MODE = 'Y' THEN
1603: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',
1604: p_debug_mode => p_pa_debug_mode );
1605: END IF;
1606:
1607: x_return_status := FND_API.G_RET_STS_SUCCESS;
1608: x_msg_count := 0;

Line 1688: IF P_PA_DEBUG_MODE = 'Y' THEN

1684: WHERE nvl(tmp1.task_id,0) = 0;
1685:
1686: END IF;
1687:
1688: IF P_PA_DEBUG_MODE = 'Y' THEN
1689: PA_DEBUG.RESET_CURR_FUNCTION;
1690: END IF;
1691: EXCEPTION
1692: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1689: PA_DEBUG.RESET_CURR_FUNCTION;

1685:
1686: END IF;
1687:
1688: IF P_PA_DEBUG_MODE = 'Y' THEN
1689: PA_DEBUG.RESET_CURR_FUNCTION;
1690: END IF;
1691: EXCEPTION
1692: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1693: l_msg_count := FND_MSG_PUB.count_msg;

Line 1712: IF P_PA_DEBUG_MODE = 'Y' THEN

1708: ROLLBACK;
1709:
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711:
1712: IF P_PA_DEBUG_MODE = 'Y' THEN
1713: pa_fp_gen_amount_utils.fp_debug
1714: (p_msg => 'Invalid Arguments Passed',
1715: p_module_name => l_module_name,
1716: p_log_level => 5);

Line 1717: PA_DEBUG.RESET_CURR_FUNCTION;

1713: pa_fp_gen_amount_utils.fp_debug
1714: (p_msg => 'Invalid Arguments Passed',
1715: p_module_name => l_module_name,
1716: p_log_level => 5);
1717: PA_DEBUG.RESET_CURR_FUNCTION;
1718: END IF;
1719: RAISE;
1720: WHEN OTHERS THEN
1721: rollback;

Line 1731: IF P_PA_DEBUG_MODE = 'Y' THEN

1727: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1728: p_procedure_name => 'UPDATE_RES_ASG',
1729: p_error_text => substr(sqlerrm,1,240));
1730:
1731: IF P_PA_DEBUG_MODE = 'Y' THEN
1732: pa_fp_gen_amount_utils.fp_debug
1733: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1734: p_module_name => l_module_name,
1735: p_log_level => 5);

Line 1736: PA_DEBUG.RESET_CURR_FUNCTION;

1732: pa_fp_gen_amount_utils.fp_debug
1733: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1734: p_module_name => l_module_name,
1735: p_log_level => 5);
1736: PA_DEBUG.RESET_CURR_FUNCTION;
1737: END IF;
1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END UPDATE_RES_ASG;
1740: