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_GEN_FCST_PG_PKG dependencies on FND_API

Line 96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

92: X_FP_COLS_REC => l_fp_cols_rec,
93: X_RETURN_STATUS => L_RET_STATUS,
94: X_MSG_COUNT => L_MSG_COUNT,
95: X_MSG_DATA => L_MSG_DATA);
96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
97: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
98: END IF;
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug

Line 320: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

316: X_FP_COLS_REC => l_fp_cols_rec,
317: X_RETURN_STATUS => l_RETURN_STATUS,
318: X_MSG_COUNT => l_MSG_COUNT,
319: X_MSG_DATA => l_MSG_DATA);
320: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
322: END IF;
323: IF p_pa_debug_mode = 'Y' THEN
324: pa_fp_gen_amount_utils.fp_debug

Line 412: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

408: X_FP_COLS_REC => l_fp_cols_rec,
409: X_RETURN_STATUS => l_RETURN_STATUS,
410: X_MSG_COUNT => l_MSG_COUNT,
411: X_MSG_DATA => l_MSG_DATA);
412: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
413: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
414: END IF;
415:
416: IF p_pa_debug_mode = 'Y' THEN

Line 529: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

525: X_FP_COLS_REC => l_fp_cols_rec,
526: X_RETURN_STATUS => l_RETURN_STATUS,
527: X_MSG_COUNT => l_MSG_COUNT,
528: X_MSG_DATA => l_MSG_DATA);
529: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
531: END IF;
532:
533: IF p_pa_debug_mode = 'Y' THEN

Line 589: (p_encoded => FND_API.G_TRUE

585: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
586: l_msg_count := FND_MSG_PUB.count_msg;
587: IF l_msg_count = 1 THEN
588: PA_INTERFACE_UTILS_PUB.get_messages
589: (p_encoded => FND_API.G_TRUE
590: ,p_msg_index => 1
591: ,p_msg_count => l_msg_count
592: ,p_msg_data => l_msg_data
593: ,p_data => l_data

Line 603: l_return_status := FND_API.G_RET_STS_ERROR;

599: x_msg_count := l_msg_count; */
600: END IF;
601: ROLLBACK;
602:
603: l_return_status := FND_API.G_RET_STS_ERROR;
604:
605: IF p_pa_debug_mode = 'Y' THEN
606: PA_DEBUG.Reset_Curr_Function;
607: END IF;

Line 648: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

644: X_FP_COLS_REC => l_fp_cols_rec,
645: X_RETURN_STATUS => l_RETURN_STATUS,
646: X_MSG_COUNT => l_MSG_COUNT,
647: X_MSG_DATA => l_MSG_DATA);
648: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
649: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
650: END IF;
651: IF p_pa_debug_mode = 'Y' THEN
652: pa_fp_gen_amount_utils.fp_debug

Line 747: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

743:
744: BEGIN
745: --Setting initial values
746: X_MSG_COUNT := 0;
747: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
748:
749: IF p_pa_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'
751: ,p_debug_mode => p_pa_debug_mode);

Line 770: (p_encoded => FND_API.G_TRUE

766: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
767: l_msg_count := FND_MSG_PUB.count_msg;
768: IF l_msg_count = 1 THEN
769: PA_INTERFACE_UTILS_PUB.get_messages
770: (p_encoded => FND_API.G_TRUE
771: ,p_msg_index => 1
772: ,p_msg_count => l_msg_count
773: ,p_msg_data => l_msg_data
774: ,p_data => l_data

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

779: x_msg_count := l_msg_count;
780: END IF;
781: ROLLBACK;
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: IF P_PA_DEBUG_MODE = 'Y' THEN
785: pa_fp_gen_amount_utils.fp_debug
786: (p_msg => 'Invalid Arguments Passed',
787: p_module_name => l_module_name,

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: END IF;
791: RAISE;
792:
793: WHEN OTHERS THEN
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: x_msg_data := SUBSTR(SQLERRM,1,240);
796: FND_MSG_PUB.add_exc_msg
797: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
798: ,p_procedure_name => 'GET_VERSION_DETAILS');

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: p_module_name => l_module_name,
803: p_log_level => 5);
804: PA_DEBUG.Reset_Curr_Function;
805: END IF;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807:
808: END GET_VERSION_DETAILS;
809:
810: -- gboomina added for AAI requirement 8318932 - start

Line 840: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

836:
837: l_gen_etc_source_code get_etc_source_code_csr%ROWTYPE;
838:
839: BEGIN
840: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
841:
842: IF p_pa_debug_mode = 'Y' THEN
843: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
844: ,p_debug_mode => p_pa_debug_mode);

Line 863: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

859: X_FP_COLS_REC => l_fp_cols_rec,
860: X_RETURN_STATUS => X_RETURN_STATUS,
861: X_MSG_COUNT => X_MSG_COUNT,
862: X_MSG_DATA => X_MSG_DATA);
863: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
864: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
865: END IF;
866: IF p_pa_debug_mode = 'Y' THEN
867: pa_fp_gen_amount_utils.fp_debug

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874:
875: -- Check whether work plan is non time phased. if so, throw an error
876: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
877: IF l_fp_cols_rec.x_time_phased_code = 'N' THEN
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
880: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
881: p_token1 => 'PLAN_TYPE',
882: p_value1 => 'Work Plan');

Line 904: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

900: X_FP_COLS_REC => l_fp_cols_rec,
901: X_RETURN_STATUS => X_RETURN_STATUS,
902: X_MSG_COUNT => X_MSG_COUNT,
903: X_MSG_DATA => X_MSG_DATA);
904: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
905: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
906: END IF;
907: IF p_pa_debug_mode = 'Y' THEN
908: pa_fp_gen_amount_utils.fp_debug

Line 919: x_return_status := FND_API.G_RET_STS_ERROR;

915:
916: -- Check whether work plan is non time phased. if so, throw an error.
917: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
918: IF l_fp_cols_rec.x_time_phased_code = 'N' THEN
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
921: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
922: p_token1 => 'PLAN_TYPE',
923: p_value1 => 'Source Financial Plan');

Line 954: (p_encoded => FND_API.G_TRUE

950: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
951: l_msg_count := FND_MSG_PUB.count_msg;
952: IF l_msg_count = 1 THEN
953: PA_INTERFACE_UTILS_PUB.get_messages
954: (p_encoded => FND_API.G_TRUE
955: ,p_msg_index => 1
956: ,p_msg_count => l_msg_count
957: ,p_msg_data => l_msg_data
958: ,p_data => l_data

Line 967: x_return_status := FND_API.G_RET_STS_ERROR;

963: x_msg_count := l_msg_count;
964: END IF;
965: ROLLBACK;
966:
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: IF P_PA_DEBUG_MODE = 'Y' THEN
969: pa_fp_gen_amount_utils.fp_debug
970: (p_msg => 'Validation failed',
971: p_module_name => l_module_name,

Line 977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

973: PA_DEBUG.Reset_Curr_Function;
974: END IF;
975: RAISE;
976: WHEN OTHERS THEN
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_msg_data := SUBSTR(SQLERRM,1,240);
979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
981: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

985: p_module_name => l_module_name,
986: p_log_level => 5);
987: PA_DEBUG.Reset_Curr_Function;
988: END IF;
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990:
991: END VALIDATION_FOR_COPY_ETC_FLAG;
992: -- gboomina added for AAI requirement 8318932 - end
993:

Line 1083: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1079: --hr_utility.trace('wp str ver id : '|| P_WP_STRUCTURE_VERSION_ID);
1080:
1081: FND_MSG_PUB.initialize;
1082: X_MSG_COUNT := 0;
1083: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1084: l_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: IF p_pa_debug_mode = 'Y' THEN
1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'

Line 1084: l_return_status := FND_API.G_RET_STS_SUCCESS;

1080:
1081: FND_MSG_PUB.initialize;
1082: X_MSG_COUNT := 0;
1083: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1084: l_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: IF p_pa_debug_mode = 'Y' THEN
1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
1088: ,p_debug_mode => p_pa_debug_mode);

Line 1097: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1093: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1094: X_RETURN_STATUS => X_RETURN_STATUS,
1095: X_MSG_COUNT => X_MSG_COUNT,
1096: X_MSG_DATA => X_MSG_DATA);
1097: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1098: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1099: p_msg_name => x_msg_data);
1100: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1101: END IF;

Line 1131: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1127: ||x_return_status,
1128: p_module_name => l_module_name);
1129: END IF;
1130:
1131: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1132: IF p_pa_debug_mode = 'Y' THEN
1133: PA_DEBUG.Reset_Curr_Function;
1134: END IF;
1135: RETURN;

Line 1156: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1152: (P_PLAN_VERSION_ID => P_BUDGET_VERSION_ID,
1153: X_RETURN_STATUS => X_RETURN_STATUS,
1154: X_MSG_COUNT => X_MSG_COUNT,
1155: X_MSG_DATA => X_MSG_DATA);
1156: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1157: --If can't acquire lock, customized message is thrown from within
1158: -- the API, so we should suppress exception error
1159: IF p_pa_debug_mode = 'Y' THEN
1160: PA_DEBUG.Reset_Curr_Function;

Line 1192: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1188: X_FP_COLS_REC => l_fp_cols_rec,
1189: X_RETURN_STATUS => X_RETURN_STATUS,
1190: X_MSG_COUNT => X_MSG_COUNT,
1191: X_MSG_DATA => X_MSG_DATA);
1192: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1193: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1194: END IF;
1195: IF p_pa_debug_mode = 'Y' THEN
1196: pa_fp_gen_amount_utils.fp_debug

Line 1222: x_return_status := FND_API.G_RET_STS_ERROR;

1218: -- Check whether the target version type is 'COST' and
1219: -- ETC Source is 'Task Level Selection'. Only this combo is supported for
1220: -- Copy ETC from plan flow.
1221: IF ( P_VERSION_TYPE <> 'COST' ) THEN
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1224: p_msg_name => 'PA_FP_COST_PLAN_TYPE_ONLY_SUPP');
1225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1226: END IF;

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224: p_msg_name => 'PA_FP_COST_PLAN_TYPE_ONLY_SUPP');
1225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1226: END IF;
1227: IF ( L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'TASK_LEVEL_SEL' ) THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1230: p_msg_name => 'PA_FP_TASK_LEVEL_SEL_ONLY');
1231: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1232: END IF;

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR;

1233: -- Check whether destination financial plan is non time phased.
1234: -- if so, throw an error.
1235: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
1236: IF L_FP_COLS_REC.X_TIME_PHASED_CODE = 'N' THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1239: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
1240: p_token1 => 'PLAN_TYPE',
1241: p_value1 => 'Financial Plan');

Line 1262: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1258: P_ETC_PLAN_VERSION_ID => L_ETC_PLAN_VERSION_ID,
1259: X_RETURN_STATUS => X_RETURN_STATUS,
1260: X_MSG_COUNT => X_MSG_COUNT,
1261: X_MSG_DATA => X_MSG_DATA);
1262: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1263: l_return_status := X_RETURN_STATUS;
1264: END IF;
1265: IF p_pa_debug_mode = 'Y' THEN
1266: pa_fp_gen_amount_utils.fp_debug

Line 1301: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1297: P_ETC_TO_PERIOD => P_ETC_TO_PERIOD,
1298: X_RETURN_STATUS => X_RETURN_STATUS,
1299: X_MSG_COUNT => X_MSG_COUNT,
1300: X_MSG_DATA => X_MSG_DATA);
1301: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1302: l_return_status := X_RETURN_STATUS;
1303: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1304: END IF;
1305: IF p_pa_debug_mode = 'Y' THEN

Line 1335: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1331: P_CALLING_CONTEXT => 'ETC_GENERATION_SOURCE',
1332: X_RETURN_STATUS => X_RETURN_STATUS,
1333: X_MSG_COUNT => X_MSG_COUNT,
1334: X_MSG_DATA => X_MSG_DATA);
1335: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1336: l_return_status := X_RETURN_STATUS;
1337: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1338: END IF;
1339: IF p_pa_debug_mode = 'Y' THEN

Line 1388: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1384: --P_CALLED_MODE => p_called_mode,
1385: P_MODULE_NAME => l_module_name,
1386: P_LOG_LEVEL => 5 );
1387: END IF;
1388: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1389: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1390: END IF;
1391: -- END OF IPM: New Entity ER ------------------------------------------
1392:

Line 1469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1465: --P_CALLED_MODE => p_called_mode,
1466: P_MODULE_NAME => l_module_name,
1467: P_LOG_LEVEL => 5 );
1468: END IF;
1469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1470: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1471: END IF;
1472: -- END OF IPM: New Entity ER ------------------------------------------
1473:

Line 1579: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1575: X_RETURN_STATUS => X_RETURN_STATUS,
1576: X_MSG_COUNT => X_MSG_COUNT,
1577: X_MSG_DATA => X_MSG_DATA );
1578:
1579: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1580: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1581: END IF;
1582: IF p_pa_debug_mode = 'Y' THEN
1583: pa_fp_gen_amount_utils.fp_debug

Line 1617: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1613: ||x_return_status,
1614: p_module_name => l_module_name,
1615: p_log_level => 5 );
1616: END IF;
1617: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1618: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1619: END IF;
1620:
1621: /* When VALIDATE_SUPPORT_CASES returns a non-null warning message,

Line 1673: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1669: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,
1670: X_RETURN_STATUS => X_RETURN_STATUS,
1671: X_MSG_COUNT => X_MSG_COUNT,
1672: X_MSG_DATA => X_MSG_DATA);
1673: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1674: l_return_status := X_RETURN_STATUS;
1675: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1676: END IF;
1677: IF p_pa_debug_mode = 'Y' THEN

Line 1689: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1685: --dbms_output.put_line('Status of gen_fcst_amt_wrp api: '||X_RETURN_STATUS);
1686:
1687: x_return_status := l_return_status;
1688:
1689: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1690: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1691: END IF;
1692:
1693: IF p_pa_debug_mode = 'Y' THEN

Line 1704: (p_encoded => FND_API.G_TRUE

1700: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1701: l_msg_count := FND_MSG_PUB.count_msg;
1702: IF l_msg_count = 1 THEN
1703: PA_INTERFACE_UTILS_PUB.get_messages
1704: (p_encoded => FND_API.G_TRUE
1705: ,p_msg_index => 1
1706: ,p_msg_count => l_msg_count
1707: ,p_msg_data => l_msg_data
1708: ,p_data => l_data

Line 1717: x_return_status := FND_API.G_RET_STS_ERROR;

1713: x_msg_count := l_msg_count;
1714: END IF;
1715: ROLLBACK;
1716:
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: IF P_PA_DEBUG_MODE = 'Y' THEN
1720: pa_fp_gen_amount_utils.fp_debug
1721: (p_msg => 'Invalid Arguments Passed',

Line 1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1727:
1728: WHEN OTHERS THEN
1729: --dbms_output.put_line('inside excep');
1730: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: x_msg_data := SUBSTR(SQLERRM,1,240);
1733:
1734: FND_MSG_PUB.add_exc_msg
1735: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

Line 1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1740: p_module_name => l_module_name,
1741: p_log_level => 5);
1742: PA_DEBUG.Reset_Curr_Function;
1743: END IF;
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745:
1746: END UPD_VER_DTLS_AND_GEN_AMT;
1747:
1748:

Line 1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1780: BEGIN
1781: --Setting initial values
1782: --FND_MSG_PUB.initialize;
1783: --X_MSG_COUNT := 0;
1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1786:
1787: IF p_pa_debug_mode = 'Y' THEN
1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'

Line 1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1781: --Setting initial values
1782: --FND_MSG_PUB.initialize;
1783: --X_MSG_COUNT := 0;
1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1786:
1787: IF p_pa_debug_mode = 'Y' THEN
1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1789: ,p_debug_mode => p_pa_debug_mode);

Line 1796: l_return_status := FND_API.G_RET_STS_ERROR;

1792: --Validating unspent amount period
1793: IF P_FP_COLS_REC.X_TIME_PHASED_CODE <> 'N'
1794: AND P_UNSPENT_AMT_FLAG = 'Y'
1795: AND P_UNSPENT_AMT_PERIOD IS NULL THEN
1796: l_return_status := FND_API.G_RET_STS_ERROR;
1797: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1798: p_msg_name => 'PA_FP_NO_UNSPENT_PERIOD');
1799: END IF;
1800:

Line 1831: x_return_status := FND_API.G_RET_STS_ERROR;

1827: --dbms_output.put_line('Status of validate_pa_gl_period api(unspent date): '||X_RETURN_STATUS);
1828: END IF;
1829: /* --Validating actuals from period
1830: IF P_ACTUALS_FROM_PERIOD IS NULL THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1833: p_msg_name => 'PA_FP_NO_ACTUALS_FROM_PERIOD');
1834: ELSE*/
1835:

Line 1871: x_return_status := FND_API.G_RET_STS_ERROR;

1867: END IF;
1868: END IF;
1869: /* --Validating actuals to period
1870: IF P_ACTUALS_TO_PERIOD IS NULL THEN
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1873: p_msg_name => 'PA_FP_NO_ACTUALS_TO_PERIOD');
1874: ELSE */
1875:

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

1907: END IF;
1908: END IF;
1909: /* --Validating ETC from period
1910: IF P_ETC_FROM_PERIOD IS NULL THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1913: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1914: ELSE*/
1915: IF P_ETC_FROM_PERIOD IS NOT NULL THEN

Line 1951: x_return_status := FND_API.G_RET_STS_ERROR;

1947: END IF;
1948:
1949: /* --Validating ETC to period
1950: IF P_ETC_TO_PERIOD IS NULL THEN
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1953: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1954: ELSE */
1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api

Line 1997: l_return_status := FND_API.G_RET_STS_ERROR;

1993: --dbms_output.put_line('all flags are Y');
1994: --dbms_output.put_line('act_to_date:'||l_act_to_date);
1995: --dbms_output.put_line('act_frm_date:'||l_act_frm_date);
1996: IF l_act_to_date < l_act_frm_date THEN
1997: l_return_status := FND_API.G_RET_STS_ERROR;
1998: --dbms_output.put_line(l_return_status);
1999: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2000: p_msg_name => 'PA_FP_INV_ACT_PD_RANGE');
2001: END IF;

Line 2009: l_return_status := FND_API.G_RET_STS_ERROR;

2005: --dbms_output.put_line('Value of valid etc to flag: '||l_valid_etc_to_flag);
2006:
2007: IF l_valid_etc_frm_flag = 'Y' AND l_valid_etc_to_flag = 'Y' THEN
2008: IF l_etc_to_date < l_etc_frm_date THEN
2009: l_return_status := FND_API.G_RET_STS_ERROR;
2010: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2011: p_msg_name => 'PA_FP_INV_ETC_PD_RANGE');
2012: END IF;
2013: END IF;

Line 2037: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2033: END IF;
2034:
2035: x_return_status := l_return_status;
2036:
2037: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2038: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2039: END IF;
2040:
2041: IF p_pa_debug_mode = 'Y' THEN

Line 2052: (p_encoded => FND_API.G_TRUE

2048: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
2049: l_msg_count := FND_MSG_PUB.count_msg;
2050: IF l_msg_count = 1 THEN
2051: PA_INTERFACE_UTILS_PUB.get_messages
2052: (p_encoded => FND_API.G_TRUE
2053: ,p_msg_index => 1
2054: ,p_msg_count => l_msg_count
2055: ,p_msg_data => l_msg_data
2056: ,p_data => l_data

Line 2065: x_return_status := FND_API.G_RET_STS_ERROR;

2061: x_msg_count := l_msg_count;
2062: END IF;
2063: ROLLBACK;
2064:
2065: x_return_status := FND_API.G_RET_STS_ERROR;
2066: IF P_PA_DEBUG_MODE = 'Y' THEN
2067: pa_fp_gen_amount_utils.fp_debug
2068: (p_msg => 'Invalid Arguments Passed',
2069: p_module_name => l_module_name,

Line 2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2072: END IF;
2073: RAISE;
2074:
2075: WHEN OTHERS THEN
2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2077: x_msg_data := SUBSTR(SQLERRM,1,240);
2078: FND_MSG_PUB.add_exc_msg
2079: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2080: ,p_procedure_name => 'VALIDATE_PERIODS');

Line 2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2084: p_module_name => l_module_name,
2085: p_log_level => 5);
2086: PA_DEBUG.Reset_Curr_Function;
2087: END IF;
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2089: END VALIDATE_PERIODS;
2090:
2091:
2092: PROCEDURE VALIDATE_PA_GL_PERIODS

Line 2113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2109: BEGIN
2110: --Setting initial values
2111: --FND_MSG_PUB.initialize;
2112: --X_MSG_COUNT := 0;
2113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2114:
2115: IF p_pa_debug_mode = 'Y' THEN
2116: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
2117: ,p_debug_mode => p_pa_debug_mode);

Line 2147: x_return_status := FND_API.G_RET_STS_ERROR;

2143:
2144: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);
2145: EXCEPTION
2146: WHEN NO_DATA_FOUND THEN
2147: x_return_status := FND_API.G_RET_STS_ERROR;
2148:
2149: IF P_CONTEXT = 'UNSPENT_PERIOD' THEN
2150: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2151: p_msg_name => 'PA_FP_INV_UNSPENT_PERIOD');

Line 2171: (p_encoded => FND_API.G_TRUE

2167: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
2168: l_msg_count := FND_MSG_PUB.count_msg;
2169: IF l_msg_count = 1 THEN
2170: PA_INTERFACE_UTILS_PUB.get_messages
2171: (p_encoded => FND_API.G_TRUE
2172: ,p_msg_index => 1
2173: ,p_msg_count => l_msg_count
2174: ,p_msg_data => l_msg_data
2175: ,p_data => l_data

Line 2184: x_return_status := FND_API.G_RET_STS_ERROR;

2180: x_msg_count := l_msg_count;
2181: END IF;
2182: ROLLBACK;
2183:
2184: x_return_status := FND_API.G_RET_STS_ERROR;
2185: IF P_PA_DEBUG_MODE = 'Y' THEN
2186: pa_fp_gen_amount_utils.fp_debug
2187: (p_msg => 'Invalid periods',
2188: p_module_name => l_module_name,

Line 2201: (p_encoded => FND_API.G_TRUE

2197: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
2198: l_msg_count := FND_MSG_PUB.count_msg;
2199: IF l_msg_count = 1 THEN
2200: PA_INTERFACE_UTILS_PUB.get_messages
2201: (p_encoded => FND_API.G_TRUE
2202: ,p_msg_index => 1
2203: ,p_msg_count => l_msg_count
2204: ,p_msg_data => l_msg_data
2205: ,p_data => l_data

Line 2214: x_return_status := FND_API.G_RET_STS_ERROR;

2210: x_msg_count := l_msg_count;
2211: END IF;
2212: ROLLBACK;
2213:
2214: x_return_status := FND_API.G_RET_STS_ERROR;
2215: IF P_PA_DEBUG_MODE = 'Y' THEN
2216: pa_fp_gen_amount_utils.fp_debug
2217: (p_msg => 'Invalid Arguments Passed',
2218: p_module_name => l_module_name,

Line 2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2221: END IF;
2222: RAISE;
2223:
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: x_msg_data := SUBSTR(SQLERRM,1,240);
2227: FND_MSG_PUB.add_exc_msg
2228: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2229: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');

Line 2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2233: p_module_name => l_module_name,
2234: p_log_level => 5);
2235: PA_DEBUG.Reset_Curr_Function;
2236: END IF;
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: --dbms_output.put_line('return status from pa_gl_periods api inside exception(O): '||x_return_status);
2239:
2240: END VALIDATE_PA_GL_PERIODS;
2241:

Line 2263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2259: BEGIN
2260: --Setting initial values
2261: --FND_MSG_PUB.initialize;
2262: --X_MSG_COUNT := 0;
2263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2264:
2265: IF p_pa_debug_mode = 'Y' THEN
2266: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
2267: ,p_debug_mode => p_pa_debug_mode);

Line 2272: x_return_status := FND_API.G_RET_STS_ERROR;

2268: END IF;
2269:
2270: IF p_plan_type_id IS NULL THEN
2271: IF p_calling_context = 'GENERATION_SOURCE' THEN
2272: x_return_status := FND_API.G_RET_STS_ERROR;
2273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2274: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
2275: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2276: x_return_status := FND_API.G_RET_STS_ERROR;

2272: x_return_status := FND_API.G_RET_STS_ERROR;
2273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2274: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
2275: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2278: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_ETC_SRC');
2279: END IF;
2280: END IF;

Line 2290: x_return_status := FND_API.G_RET_STS_ERROR;

2286: RETURN;
2287: END IF;
2288:
2289: IF p_plan_version_name IS NULL THEN
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2292: p_msg_name => 'PA_FP_NO_PLAN_VERSION_NAME');
2293: END IF;
2294:

Line 2313: x_return_status := FND_API.G_RET_STS_ERROR;

2309:
2310:
2311: EXCEPTION
2312: WHEN NO_DATA_FOUND THEN
2313: x_return_status := FND_API.G_RET_STS_ERROR;
2314: IF p_calling_context = 'GENERATION_SOURCE' THEN
2315: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2316: p_msg_name => 'PA_FP_INV_GEN_BV');
2317: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN

Line 2334: (p_encoded => FND_API.G_TRUE

2330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2331: l_msg_count := FND_MSG_PUB.count_msg;
2332: IF l_msg_count = 1 THEN
2333: PA_INTERFACE_UTILS_PUB.get_messages
2334: (p_encoded => FND_API.G_TRUE
2335: ,p_msg_index => 1
2336: ,p_msg_count => l_msg_count
2337: ,p_msg_data => l_msg_data
2338: ,p_data => l_data

Line 2347: x_return_status := FND_API.G_RET_STS_ERROR;

2343: x_msg_count := l_msg_count;
2344: END IF;
2345: ROLLBACK;
2346:
2347: x_return_status := FND_API.G_RET_STS_ERROR;
2348: IF P_PA_DEBUG_MODE = 'Y' THEN
2349: pa_fp_gen_amount_utils.fp_debug
2350: (p_msg => 'Invalid Arguments Passed',
2351: p_module_name => l_module_name,

Line 2358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2354: END IF;
2355: RAISE;
2356:
2357: WHEN OTHERS THEN
2358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2359: x_msg_data := SUBSTR(SQLERRM,1,240);
2360: FND_MSG_PUB.add_exc_msg
2361: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2362: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');

Line 2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2366: p_module_name => l_module_name,
2367: p_log_level => 5);
2368: PA_DEBUG.Reset_Curr_Function;
2369: END IF;
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371:
2372: END VALIDATE_PLAN_TYPE_OR_VERSION;
2373:
2374: END PA_FP_GEN_FCST_PG_PKG;