DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on FND_API

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282: BEGIN
283: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
284: x_msg_count := 0;
285: l_module_name:='pa_fp_view_plans_txn_pub';
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: pa_debug.set_err_stack('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize');
288: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
289: l_debug_mode := NVL(l_debug_mode, 'Y');
290: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 619: if l_return_status = FND_API.G_RET_STS_SUCCESS then

615: x_resource_level => l_resource_level,
616: x_return_status => l_return_status,
617: x_msg_count => l_msg_count,
618: x_msg_data => l_msg_data);
619: if l_return_status = FND_API.G_RET_STS_SUCCESS then
620: if l_resource_level = 'R' then
621: x_display_res_flag := 'Y';
622: x_display_resgp_flag := 'N';
623: elsif l_resource_level = 'G' then

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

630: x_display_res_flag := 'N';
631: x_display_resgp_flag := 'N';
632: end if;
633: else
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: x_msg_count := FND_MSG_PUB.Count_Msg;
636: if x_msg_count = 1 then
637: PA_INTERFACE_UTILS_PUB.get_messages
638: (p_encoded => FND_API.G_TRUE,

Line 638: (p_encoded => FND_API.G_TRUE,

634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: x_msg_count := FND_MSG_PUB.Count_Msg;
636: if x_msg_count = 1 then
637: PA_INTERFACE_UTILS_PUB.get_messages
638: (p_encoded => FND_API.G_TRUE,
639: p_msg_index => 1,
640: p_data => x_msg_data,
641: p_msg_index_out => l_msg_index_out);
642: end if;

Line 672: if l_return_status = FND_API.G_RET_STS_SUCCESS then

668: x_resource_level => l_resource_level,
669: x_return_status => l_return_status,
670: x_msg_count => l_msg_count,
671: x_msg_data => l_msg_data);
672: if l_return_status = FND_API.G_RET_STS_SUCCESS then
673: if l_resource_level = 'R' then
674: x_display_res_flag := 'Y';
675: x_display_resgp_flag := 'N';
676: elsif l_resource_level = 'G' then

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683: x_display_res_flag := 'N';
684: x_display_resgp_flag := 'N';
685: end if;
686: else
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: x_msg_count := FND_MSG_PUB.Count_Msg;
689: if x_msg_count = 1 then
690: PA_INTERFACE_UTILS_PUB.get_messages
691: (p_encoded => FND_API.G_TRUE,

Line 691: (p_encoded => FND_API.G_TRUE,

687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: x_msg_count := FND_MSG_PUB.Count_Msg;
689: if x_msg_count = 1 then
690: PA_INTERFACE_UTILS_PUB.get_messages
691: (p_encoded => FND_API.G_TRUE,
692: p_msg_index => 1,
693: p_data => x_msg_data,
694: p_msg_index_out => l_msg_index_out);
695: end if;

Line 725: if l_return_status = FND_API.G_RET_STS_SUCCESS then

721: x_resource_level => l_resource_level,
722: x_return_status => l_return_status,
723: x_msg_count => l_msg_count,
724: x_msg_data => l_msg_data);
725: if l_return_status = FND_API.G_RET_STS_SUCCESS then
726: if l_resource_level = 'R' then
727: x_display_res_flag := 'Y';
728: x_display_resgp_flag := 'N';
729: elsif l_resource_level = 'G' then

Line 740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

736: x_display_res_flag := 'N';
737: x_display_resgp_flag := 'N';
738: end if;
739: else
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: x_msg_count := FND_MSG_PUB.Count_Msg;
742: if x_msg_count = 1 then
743: PA_INTERFACE_UTILS_PUB.get_messages
744: (p_encoded => FND_API.G_TRUE,

Line 744: (p_encoded => FND_API.G_TRUE,

740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: x_msg_count := FND_MSG_PUB.Count_Msg;
742: if x_msg_count = 1 then
743: PA_INTERFACE_UTILS_PUB.get_messages
744: (p_encoded => FND_API.G_TRUE,
745: p_msg_index => 1,
746: p_data => x_msg_data,
747: p_msg_index_out => l_msg_index_out);
748: end if;

Line 780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

776: x_resource_level => l_cost_resource_level,
777: x_return_status => l_return_status,
778: x_msg_count => l_msg_count,
779: x_msg_data => l_msg_data);
780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: x_msg_count := FND_MSG_PUB.Count_Msg;
783: if x_msg_count = 1 then
784: PA_INTERFACE_UTILS_PUB.get_messages

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: x_return_status => l_return_status,
778: x_msg_count => l_msg_count,
779: x_msg_data => l_msg_data);
780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: x_msg_count := FND_MSG_PUB.Count_Msg;
783: if x_msg_count = 1 then
784: PA_INTERFACE_UTILS_PUB.get_messages
785: (p_encoded => FND_API.G_TRUE,

Line 785: (p_encoded => FND_API.G_TRUE,

781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: x_msg_count := FND_MSG_PUB.Count_Msg;
783: if x_msg_count = 1 then
784: PA_INTERFACE_UTILS_PUB.get_messages
785: (p_encoded => FND_API.G_TRUE,
786: p_msg_index => 1,
787: p_data => x_msg_data,
788: p_msg_index_out => l_msg_index_out);
789: end if;

Line 819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

815: x_resource_level => l_revenue_resource_level,
816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,
818: x_msg_data => l_msg_data);
819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: x_msg_count := FND_MSG_PUB.Count_Msg;
822: if x_msg_count = 1 then
823: PA_INTERFACE_UTILS_PUB.get_messages

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,
818: x_msg_data => l_msg_data);
819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: x_msg_count := FND_MSG_PUB.Count_Msg;
822: if x_msg_count = 1 then
823: PA_INTERFACE_UTILS_PUB.get_messages
824: (p_encoded => FND_API.G_TRUE,

Line 824: (p_encoded => FND_API.G_TRUE,

820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: x_msg_count := FND_MSG_PUB.Count_Msg;
822: if x_msg_count = 1 then
823: PA_INTERFACE_UTILS_PUB.get_messages
824: (p_encoded => FND_API.G_TRUE,
825: p_msg_index => 1,
826: p_data => x_msg_data,
827: p_msg_index_out => l_msg_index_out);
828: end if;

Line 927: x_return_status := FND_API.G_RET_STS_SUCCESS;

923:
924: BEGIN
925: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '100: entered procedure', 2);
926: x_msg_count := 0;
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: -- get AUTO BASELINED FLAG
930: x_auto_baselined_flag :=
931: Pa_Fp_Control_Items_Utils.IsFpAutoBaselineEnabled(p_project_id);

Line 1173: if l_return_status = FND_API.G_RET_STS_SUCCESS then

1169: x_resource_level => l_resource_level,
1170: x_return_status => l_return_status,
1171: x_msg_count => l_msg_count,
1172: x_msg_data => l_msg_data);
1173: if l_return_status = FND_API.G_RET_STS_SUCCESS then
1174: if l_resource_level = 'R' then
1175: x_display_res_flag := 'Y';
1176: x_display_resgp_flag := 'N';
1177: elsif l_resource_level = 'G' then

Line 1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1184: x_display_res_flag := 'N';
1185: x_display_resgp_flag := 'N';
1186: end if;
1187: else
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: /*
1190: PA_UTILS.Add_Message(p_app_short_name => 'PA',
1191: p_msg_name => l_msg_data);
1192: */

Line 1196: (p_encoded => FND_API.G_TRUE,

1192: */
1193: x_msg_count := FND_MSG_PUB.Count_Msg;
1194: if x_msg_count = 1 then
1195: PA_INTERFACE_UTILS_PUB.get_messages
1196: (p_encoded => FND_API.G_TRUE,
1197: p_msg_index => 1,
1198: p_data => x_msg_data,
1199: p_msg_index_out => l_msg_index_out);
1200: end if;

Line 1874: x_return_status := FND_API.G_RET_STS_SUCCESS;

1870: FND_MSG_PUB.initialize;
1871: IF P_PA_DEBUG_MODE = 'Y' THEN
1872: pa_debug.init_err_stack('nonhgrid_view_initialize: ' || 'PA_FIN_PLAN_PUB.Submit_Current_Working');
1873: END IF;
1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875: x_msg_count := 0;
1876: SAVEPOINT PA_FIN_PLAN_VIEWPLANS_TXN;
1877: -- flush out any existing data in PA_FP_TXN_LINES_TMP
1878: delete from PA_FP_TXN_LINES_TMP where project_id is not null;

Line 2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2339:
2340: exception
2341: when others then
2342: rollback to PA_FIN_PLAN_VIEWPLANS_TXN;
2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: x_msg_count := 1;
2345: x_msg_data := SQLERRM;
2346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_view_plans_txn_pub',
2347: p_procedure_name => 'view_plans_txn_populate_tmp');

Line 2349: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2345: x_msg_data := SQLERRM;
2346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_view_plans_txn_pub',
2347: p_procedure_name => 'view_plans_txn_populate_tmp');
2348: pa_debug.reset_err_stack;
2349: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2350: END view_plans_txn_populate_tmp;
2351:
2352: ---------------------------------------------------------------
2353: ----------- BEGIN OF CHANGE ORDER / CONTROL ITEM -------------

Line 2456: x_return_status := FND_API.G_RET_STS_SUCCESS;

2452: BEGIN
2453: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
2454: --hr_utility.trace_on(null, 'dlai');
2455: x_msg_count := 0;
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: -- GET AUTO BASELINED FLAG
2459: x_auto_baselined_flag :=
2460: Pa_Fp_Control_Items_Utils.IsFpAutoBaselineEnabled(p_project_id);

Line 2973: if l_return_status = FND_API.G_RET_STS_SUCCESS then

2969: x_resource_level => l_resource_level,
2970: x_return_status => l_return_status,
2971: x_msg_count => l_msg_count,
2972: x_msg_data => l_msg_data);
2973: if l_return_status = FND_API.G_RET_STS_SUCCESS then
2974: if l_resource_level = 'R' then
2975: x_display_res_flag := 'Y';
2976: x_display_resgp_flag := 'N';
2977: elsif l_resource_level = 'G' then

Line 2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2984: x_display_res_flag := 'N';
2985: x_display_resgp_flag := 'N';
2986: end if;
2987: else
2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2989: x_msg_count := FND_MSG_PUB.Count_Msg;
2990: if x_msg_count = 1 then
2991: PA_INTERFACE_UTILS_PUB.get_messages
2992: (p_encoded => FND_API.G_TRUE,

Line 2992: (p_encoded => FND_API.G_TRUE,

2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2989: x_msg_count := FND_MSG_PUB.Count_Msg;
2990: if x_msg_count = 1 then
2991: PA_INTERFACE_UTILS_PUB.get_messages
2992: (p_encoded => FND_API.G_TRUE,
2993: p_msg_index => 1,
2994: p_data => x_msg_data,
2995: p_msg_index_out => l_msg_index_out);
2996: end if;

Line 3026: if l_return_status = FND_API.G_RET_STS_SUCCESS then

3022: x_resource_level => l_resource_level,
3023: x_return_status => l_return_status,
3024: x_msg_count => l_msg_count,
3025: x_msg_data => l_msg_data);
3026: if l_return_status = FND_API.G_RET_STS_SUCCESS then
3027: if l_resource_level = 'R' then
3028: x_display_res_flag := 'Y';
3029: x_display_resgp_flag := 'N';
3030: elsif l_resource_level = 'G' then

Line 3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3037: x_display_res_flag := 'N';
3038: x_display_resgp_flag := 'N';
3039: end if;
3040: else
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: x_msg_count := FND_MSG_PUB.Count_Msg;
3043: if x_msg_count = 1 then
3044: PA_INTERFACE_UTILS_PUB.get_messages
3045: (p_encoded => FND_API.G_TRUE,

Line 3045: (p_encoded => FND_API.G_TRUE,

3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: x_msg_count := FND_MSG_PUB.Count_Msg;
3043: if x_msg_count = 1 then
3044: PA_INTERFACE_UTILS_PUB.get_messages
3045: (p_encoded => FND_API.G_TRUE,
3046: p_msg_index => 1,
3047: p_data => x_msg_data,
3048: p_msg_index_out => l_msg_index_out);
3049: end if;

Line 3079: if l_return_status = FND_API.G_RET_STS_SUCCESS then

3075: x_resource_level => l_resource_level,
3076: x_return_status => l_return_status,
3077: x_msg_count => l_msg_count,
3078: x_msg_data => l_msg_data);
3079: if l_return_status = FND_API.G_RET_STS_SUCCESS then
3080: if l_resource_level = 'R' then
3081: x_display_res_flag := 'Y';
3082: x_display_resgp_flag := 'N';
3083: elsif l_resource_level = 'G' then

Line 3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3090: x_display_res_flag := 'N';
3091: x_display_resgp_flag := 'N';
3092: end if;
3093: else
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: x_msg_count := FND_MSG_PUB.Count_Msg;
3096: if x_msg_count = 1 then
3097: PA_INTERFACE_UTILS_PUB.get_messages
3098: (p_encoded => FND_API.G_TRUE,

Line 3098: (p_encoded => FND_API.G_TRUE,

3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: x_msg_count := FND_MSG_PUB.Count_Msg;
3096: if x_msg_count = 1 then
3097: PA_INTERFACE_UTILS_PUB.get_messages
3098: (p_encoded => FND_API.G_TRUE,
3099: p_msg_index => 1,
3100: p_data => x_msg_data,
3101: p_msg_index_out => l_msg_index_out);
3102: end if;

Line 3133: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3129: x_resource_level => l_cost_resource_level,
3130: x_return_status => l_return_status,
3131: x_msg_count => l_msg_count,
3132: x_msg_data => l_msg_data);
3133: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3135: x_msg_count := FND_MSG_PUB.Count_Msg;
3136: if x_msg_count = 1 then
3137: PA_INTERFACE_UTILS_PUB.get_messages

Line 3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3130: x_return_status => l_return_status,
3131: x_msg_count => l_msg_count,
3132: x_msg_data => l_msg_data);
3133: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3135: x_msg_count := FND_MSG_PUB.Count_Msg;
3136: if x_msg_count = 1 then
3137: PA_INTERFACE_UTILS_PUB.get_messages
3138: (p_encoded => FND_API.G_TRUE,

Line 3138: (p_encoded => FND_API.G_TRUE,

3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3135: x_msg_count := FND_MSG_PUB.Count_Msg;
3136: if x_msg_count = 1 then
3137: PA_INTERFACE_UTILS_PUB.get_messages
3138: (p_encoded => FND_API.G_TRUE,
3139: p_msg_index => 1,
3140: p_data => x_msg_data,
3141: p_msg_index_out => l_msg_index_out);
3142: end if;

Line 3171: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3167: x_resource_level => l_revenue_resource_level,
3168: x_return_status => l_return_status,
3169: x_msg_count => l_msg_count,
3170: x_msg_data => l_msg_data);
3171: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3173: x_msg_count := FND_MSG_PUB.Count_Msg;
3174: if x_msg_count = 1 then
3175: PA_INTERFACE_UTILS_PUB.get_messages

Line 3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3168: x_return_status => l_return_status,
3169: x_msg_count => l_msg_count,
3170: x_msg_data => l_msg_data);
3171: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3173: x_msg_count := FND_MSG_PUB.Count_Msg;
3174: if x_msg_count = 1 then
3175: PA_INTERFACE_UTILS_PUB.get_messages
3176: (p_encoded => FND_API.G_TRUE,

Line 3176: (p_encoded => FND_API.G_TRUE,

3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3173: x_msg_count := FND_MSG_PUB.Count_Msg;
3174: if x_msg_count = 1 then
3175: PA_INTERFACE_UTILS_PUB.get_messages
3176: (p_encoded => FND_API.G_TRUE,
3177: p_msg_index => 1,
3178: p_data => x_msg_data,
3179: p_msg_index_out => l_msg_index_out);
3180: end if;

Line 3265: x_return_status := FND_API.G_RET_STS_SUCCESS;

3261:
3262: BEGIN
3263:
3264: x_msg_count := 0;
3265: x_return_status := FND_API.G_RET_STS_SUCCESS;
3266: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3267:
3268: pa_debug.set_curr_function( p_function => 'CALCULATE_AMOUNTS_FOR_VERSION',
3269: p_debug_mode => l_debug_mode );

Line 3409: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3405: ,x_return_status => x_return_status
3406: ,x_msg_count => x_msg_count
3407: ,x_msg_data => x_msg_data );
3408:
3409: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3410: IF P_PA_DEBUG_MODE = 'Y' THEN
3411: pa_debug.g_err_stage := 'Call to PA_FP_EDIT_LINE_PKG.CALL_CLIENT_EXTENSIONS errored... ';
3412: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
3413: END IF;

Line 3461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3457: ,x_return_status => x_return_status
3458: ,x_msg_count => x_msg_count
3459: ,x_msg_data => x_msg_data);
3460:
3461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3462: IF P_PA_DEBUG_MODE = 'Y' THEN
3463: pa_debug.g_err_stage := 'Call to PA_FP_EDIT_LINE_PKG.PROCESS_BDGTLINES_FOR_VERSION errored... ';
3464: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3465: END IF;

Line 3480: x_return_status := FND_API.G_RET_STS_ERROR;

3476: EXCEPTION
3477:
3478: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3479:
3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: /* Rollback in case of any exceptions in the process. */
3482: ROLLBACK;
3483: l_msg_count := FND_MSG_PUB.count_msg;
3484:

Line 3491: (p_encoded => FND_API.G_TRUE

3487: END IF;
3488:
3489: IF l_msg_count = 1 and x_msg_data IS NULL THEN
3490: PA_INTERFACE_UTILS_PUB.get_messages
3491: (p_encoded => FND_API.G_TRUE
3492: ,p_msg_index => 1
3493: ,p_msg_count => l_msg_count
3494: ,p_msg_data => l_msg_data
3495: ,p_data => l_data

Line 3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3503: RETURN;
3504:
3505: WHEN others THEN
3506:
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3508: /* Rollback in case of any exceptions in the process. */
3509: ROLLBACK;
3510: x_msg_count := 1;
3511: x_msg_data := SQLERRM;