DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.initialize;

137: l_display_qty_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
138:
139: BEGIN
140: IF p_init_msg_flag = 'Y' THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: X_MSG_COUNT := 0;
145: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 646: l_msg_count := FND_MSG_PUB.count_msg;

642: END IF;
643:
644: EXCEPTION
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,

Line 682: FND_MSG_PUB.add_exc_msg

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
683: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
684: p_procedure_name => 'MAINTAIN_ACTUAL_AMT_WRP',
685: p_error_text => substr(sqlerrm,1,240));
686: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 781: l_msg_count := FND_MSG_PUB.count_msg;

777: END IF;
778:
779: EXCEPTION
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,

Line 812: FND_MSG_PUB.add_exc_msg

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
813: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
814: p_procedure_name => 'UPD_REPORTING_LINES_WRP',
815: p_error_text => substr(sqlerrm,1,240));
816: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2496: FND_MSG_PUB.add_exc_msg

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
2497: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
2498: p_procedure_name => 'MAINTAIN_ACTUAL_AMT_RA',
2499: p_error_text => substr(sqlerrm,1,240));
2500: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3106: FND_MSG_PUB.add_exc_msg

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
3107: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
3108: p_procedure_name => 'SYNC_UP_PLANNING_DATES',
3109: p_error_text => substr(sqlerrm,1,240));
3110: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3494: l_msg_count := FND_MSG_PUB.count_msg;

3490: END IF;
3491:
3492: EXCEPTION
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,

Line 3524: FND_MSG_PUB.add_exc_msg

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',
3526: p_procedure_name => 'BLK_UPD_REPORTING_LINES_WRP',
3527: p_error_text => substr(sqlerrm,1,240));
3528: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3666: l_msg_count := FND_MSG_PUB.count_msg;

3662: PA_DEBUG.Reset_Curr_Function;
3663: END IF;
3664: EXCEPTION
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,

Line 3696: FND_MSG_PUB.add_exc_msg

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',
3698: p_procedure_name => 'SYNC_UP_PLANNING_DATES_NONE_TP',
3699: p_error_text => substr(sqlerrm,1,240));
3700: IF P_PA_DEBUG_MODE = 'Y' THEN