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

Line 145: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: X_MSG_COUNT := 0;
145: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
146:
147: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
148: PA_DEBUG.init_err_stack('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP');
149: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231: X_FP_COLS_REC => l_fp_cols_rec,
232: X_RETURN_STATUS => x_return_status,
233: X_MSG_COUNT => x_msg_count,
234: X_MSG_DATA => x_msg_data);
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
237: END IF;
238: IF p_pa_debug_mode = 'Y' THEN
239: pa_fp_gen_amount_utils.fp_debug

Line 296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

292: ||'BLK_UPD_REPORTING_LINES_WRP:'||x_return_status,
293: p_module_name => l_module_name,
294: p_log_level => 5);
295: END IF;
296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
298: END IF;
299: END IF; --P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'INCREMENTAL'
300:

Line 448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

444: P_OPEN_PD_END_DATE => l_open_pd_end_date,
445: X_RETURN_STATUS => x_return_Status,
446: X_MSG_COUNT => x_msg_count,
447: X_MSG_DATA => x_msg_data );
448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
450: END IF;
451: IF p_pa_debug_mode = 'Y' THEN
452: pa_fp_gen_amount_utils.fp_debug

Line 516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

512: 'POPULATE_DISPLAY_QTY: '||x_return_status,
513: --P_CALLED_MODE => p_called_mode,
514: P_MODULE_NAME => l_module_name);
515: END IF;
516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
518: END IF;
519:
520: -- Call the maintenance api in ROLLUP mode

Line 544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

540: 'MAINTAIN_DATA: '||x_return_status,
541: P_CALLED_MODE => p_calling_mode,
542: P_MODULE_NAME => l_module_name);
543: END IF;
544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
545: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
546: END IF;
547:
548: -- END OF IPM: New Entity and Display Quantity ERs --------------------

Line 584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

580: ||'BLK_UPD_REPORTING_LINES_WRP:'||x_return_status,
581: p_module_name => l_module_name,
582: p_log_level => 5);
583: END IF;
584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
586: END IF;
587: END IF; --P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'INCREMENTAL'
588:

Line 649: ( p_encoded => FND_API.G_TRUE,

645: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
646: l_msg_count := FND_MSG_PUB.count_msg;
647: IF l_msg_count = 1 THEN
648: PA_INTERFACE_UTILS_PUB.get_messages
649: ( p_encoded => FND_API.G_TRUE,
650: p_msg_index => 1,
651: p_msg_count => l_msg_count,
652: p_msg_data => l_msg_data,
653: p_data => l_data,

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

658: x_msg_count := l_msg_count;
659: END IF;
660: -- Bug 4621171: Removed ROLLBACK statement.
661:
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: IF P_PA_DEBUG_MODE = 'Y' THEN
664: pa_fp_gen_amount_utils.fp_debug
665: (p_called_mode => p_calling_mode,
666: p_msg => 'Invalid Arguments Passed',

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: END IF;
675: -- Bug 4621171: Removed RAISE statement.
676: WHEN OTHERS THEN
677: -- Bug 4621171: Removed ROLLBACK statement.
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: x_msg_count := 1;
680: x_msg_data := substr(sqlerrm,1,240);
681: -- dbms_output.put_line('error msg :'||x_msg_data);
682: FND_MSG_PUB.add_exc_msg

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

694: ELSIF p_init_msg_flag = 'N' THEN
695: PA_DEBUG.Reset_Curr_Function;
696: END IF;
697: END IF;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699:
700: END MAINTAIN_ACTUAL_AMT_WRP;
701:
702:

Line 723: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

719: l_msg_data VARCHAR2(2000);
720: l_msg_index_out NUMBER;
721: BEGIN
722: X_MSG_COUNT := 0;
723: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
724:
725: IF p_pa_debug_mode = 'Y' THEN
726: pa_debug.set_curr_function( p_function => 'UPD_REPORTING_LINES_WRP'
727: ,p_debug_mode => p_pa_debug_mode);

Line 784: ( p_encoded => FND_API.G_TRUE,

780: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
781: l_msg_count := FND_MSG_PUB.count_msg;
782: IF l_msg_count = 1 THEN
783: PA_INTERFACE_UTILS_PUB.get_messages
784: ( p_encoded => FND_API.G_TRUE,
785: p_msg_index => 1,
786: p_msg_count => l_msg_count,
787: p_msg_data => l_msg_data,
788: p_data => l_data,

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: x_msg_count := l_msg_count;
794: END IF;
795: -- Bug 4621171: Removed ROLLBACK statement.
796:
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: IF P_PA_DEBUG_MODE = 'Y' THEN
799: pa_fp_gen_amount_utils.fp_debug
800: (p_msg => 'Invalid Arguments Passed',
801: p_module_name => l_module_name,

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: END IF;
805: -- Bug 4621171: Removed RAISE statement.
806: WHEN OTHERS THEN
807: -- Bug 4621171: Removed ROLLBACK statement.
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := 1;
810: x_msg_data := substr(sqlerrm,1,240);
811: -- dbms_output.put_line('error msg :'||x_msg_data);
812: FND_MSG_PUB.add_exc_msg

Line 823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

819: p_module_name => l_module_name,
820: p_log_level => 5);
821: PA_DEBUG.Reset_Curr_Function;
822: END IF;
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824:
825: END UPD_REPORTING_LINES_WRP;
826:
827:

Line 998: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

994:
995: BEGIN
996: --Setting initial values
997: X_MSG_COUNT := 0;
998: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
999:
1000: IF p_pa_debug_mode = 'Y' THEN
1001: pa_debug.set_curr_function( p_function => 'MAINTAIN_ACTUAL_AMT_RA'
1002: ,p_debug_mode => p_pa_debug_mode);

Line 2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2488:
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: -- Bug 4621171: Removed ROLLBACK statement.
2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2493: x_msg_count := 1;
2494: x_msg_data := substr(sqlerrm,1,240);
2495: -- dbms_output.put_line('error msg :'||x_msg_data);
2496: FND_MSG_PUB.add_exc_msg

Line 2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2504: p_module_name => l_module_name,
2505: p_log_level => 5);
2506: PA_DEBUG.Reset_Curr_Function;
2507: END IF;
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509:
2510: END MAINTAIN_ACTUAL_AMT_RA;
2511:
2512:

Line 2801: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2797:
2798: BEGIN
2799: /* Setting initial values */
2800: X_MSG_COUNT := 0;
2801: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2802:
2803: IF p_pa_debug_mode = 'Y' THEN
2804: PA_DEBUG.SET_CURR_FUNCTION
2805: ( p_function => 'SYNC_UP_PLANNING_DATES',

Line 2831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2827: ||x_return_status,
2828: p_module_name => l_module_name,
2829: p_log_level => 5 );
2830: END IF;
2831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2832: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2833: END IF;
2834:
2835: SELECT NVL(wp_version_flag,'N') INTO l_wp_version_flag FROM

Line 3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3098:
3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: -- Bug 4621171: Removed ROLLBACK statement.
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: x_msg_count := 1;
3104: x_msg_data := substr(sqlerrm,1,240);
3105: -- dbms_output.put_line('error msg :'||x_msg_data);
3106: FND_MSG_PUB.add_exc_msg

Line 3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3113: p_module_name => l_module_name,
3114: p_log_level => 5);
3115: PA_DEBUG.Reset_Curr_Function;
3116: END IF;
3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3118:
3119: END SYNC_UP_PLANNING_DATES;
3120:
3121: /** Valid values for parameter P_ENTIRE_VERSION_FLAG:

Line 3181: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3177: l_msg_index_out NUMBER;
3178:
3179: BEGIN
3180: X_MSG_COUNT := 0;
3181: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3182:
3183: IF p_pa_debug_mode = 'Y' THEN
3184: PA_DEBUG.SET_CURR_FUNCTION
3185: ( p_function => 'BLK_UPD_REPORTING_LINES_WRP',

Line 3484: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3480: ||x_return_status,
3481: p_module_name => l_module_name,
3482: p_log_level => 5);
3483: END IF;
3484: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3485: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3486: END IF;
3487:
3488: IF p_pa_debug_mode = 'Y' THEN

Line 3497: ( p_encoded => FND_API.G_TRUE,

3493: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3494: l_msg_count := FND_MSG_PUB.count_msg;
3495: IF l_msg_count = 1 THEN
3496: PA_INTERFACE_UTILS_PUB.get_messages
3497: ( p_encoded => FND_API.G_TRUE,
3498: p_msg_index => 1,
3499: p_msg_count => l_msg_count,
3500: p_msg_data => l_msg_data,
3501: p_data => l_data,

Line 3510: x_return_status := FND_API.G_RET_STS_ERROR;

3506: x_msg_count := l_msg_count;
3507: END IF;
3508: -- Bug 4621171: Removed ROLLBACK statement.
3509:
3510: x_return_status := FND_API.G_RET_STS_ERROR;
3511: IF P_PA_DEBUG_MODE = 'Y' THEN
3512: pa_fp_gen_amount_utils.fp_debug
3513: (p_msg => 'Invalid Arguments Passed',
3514: p_module_name => l_module_name,

Line 3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3517: END IF;
3518: -- Bug 4621171: Removed RAISE statement.
3519: WHEN OTHERS THEN
3520: -- Bug 4621171: Removed ROLLBACK statement.
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: x_msg_count := 1;
3523: x_msg_data := substr(sqlerrm,1,240);
3524: FND_MSG_PUB.add_exc_msg
3525: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

Line 3535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3531: p_module_name => l_module_name,
3532: p_log_level => 5);
3533: PA_DEBUG.Reset_Curr_Function;
3534: END IF;
3535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3536:
3537: END BLK_UPD_REPORTING_LINES_WRP;
3538:
3539: PROCEDURE SYNC_UP_PLANNING_DATES_NONE_TP

Line 3573: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3569: l_upd_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3570: l_upd_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3571: BEGIN
3572: X_MSG_COUNT := 0;
3573: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3574:
3575: IF p_pa_debug_mode = 'Y' THEN
3576: PA_DEBUG.SET_CURR_FUNCTION
3577: ( p_function => 'SYNC_UP_PLANNING_DATES_NONE_TP',

Line 3669: ( p_encoded => FND_API.G_TRUE,

3665: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3666: l_msg_count := FND_MSG_PUB.count_msg;
3667: IF l_msg_count = 1 THEN
3668: PA_INTERFACE_UTILS_PUB.get_messages
3669: ( p_encoded => FND_API.G_TRUE,
3670: p_msg_index => 1,
3671: p_msg_count => l_msg_count,
3672: p_msg_data => l_msg_data,
3673: p_data => l_data,

Line 3682: x_return_status := FND_API.G_RET_STS_ERROR;

3678: x_msg_count := l_msg_count;
3679: END IF;
3680: ROLLBACK;
3681:
3682: x_return_status := FND_API.G_RET_STS_ERROR;
3683: IF P_PA_DEBUG_MODE = 'Y' THEN
3684: pa_fp_gen_amount_utils.fp_debug
3685: (p_msg => 'Invalid Arguments Passed',
3686: p_module_name => l_module_name,

Line 3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3689: END IF;
3690: RAISE;
3691: WHEN OTHERS THEN
3692: rollback;
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: x_msg_count := 1;
3695: x_msg_data := substr(sqlerrm,1,240);
3696: FND_MSG_PUB.add_exc_msg
3697: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

Line 3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3703: p_module_name => l_module_name,
3704: p_log_level => 5);
3705: PA_DEBUG.Reset_Curr_Function;
3706: END IF;
3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3708:
3709: END SYNC_UP_PLANNING_DATES_NONE_TP;
3710:
3711: