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_EDIT_LINE_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 175: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

171: IF P_PA_DEBUG_MODE = 'Y' THEN
172: pa_debug.g_err_stage := 'Call to derive_pd_sd_start_end_dates errored... ';
173: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
174: END IF;
175: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
176: END IF;
177: END IF;
178:
179: /* This program assumes that in case time phased is by PA or GL

Line 221: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

217:
218: pa_debug.reset_err_stack; /* Bug 2699888 */
219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: l_msg_count := FND_MSG_PUB.count_msg;
224: IF l_msg_count = 1 THEN
225: PA_INTERFACE_UTILS_PUB.get_messages

Line 315: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

311:
312: IF p_pa_debug_mode = 'Y' THEN
313: pa_debug.g_err_stage:= 'Validating input parameters';
314: pa_debug.write(l_module_name,pa_debug.g_err_stage,
315: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
316: END IF;
317:
318: IF p_calling_context IS NULL or
319: p_pp_st_dt IS NULL or

Line 327: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

323:
324: IF p_pa_debug_mode = 'Y' THEN
325: pa_debug.g_err_stage:= 'p_calling_context = '|| p_calling_context;
326: pa_debug.write(l_module_name,pa_debug.g_err_stage,
327: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
328: pa_debug.g_err_stage:= 'p_pp_st_dt = '|| p_pp_st_dt;
329: pa_debug.write(l_module_name,pa_debug.g_err_stage,
330: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
331: pa_debug.g_err_stage:= 'p_pp_end_dt = '|| p_pp_end_dt;

Line 330: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

326: pa_debug.write(l_module_name,pa_debug.g_err_stage,
327: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
328: pa_debug.g_err_stage:= 'p_pp_st_dt = '|| p_pp_st_dt;
329: pa_debug.write(l_module_name,pa_debug.g_err_stage,
330: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
331: pa_debug.g_err_stage:= 'p_pp_end_dt = '|| p_pp_end_dt;
332: pa_debug.write(l_module_name,pa_debug.g_err_stage,
333: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
334: pa_debug.g_err_stage:= 'p_plan_period_type = '|| p_plan_period_type;

Line 333: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

329: pa_debug.write(l_module_name,pa_debug.g_err_stage,
330: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
331: pa_debug.g_err_stage:= 'p_pp_end_dt = '|| p_pp_end_dt;
332: pa_debug.write(l_module_name,pa_debug.g_err_stage,
333: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
334: pa_debug.g_err_stage:= 'p_plan_period_type = '|| p_plan_period_type;
335: pa_debug.write(l_module_name,pa_debug.g_err_stage,
336: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
337: pa_debug.g_err_stage:= 'p_resource_assignment_id = '|| p_resource_assignment_id;

Line 336: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

332: pa_debug.write(l_module_name,pa_debug.g_err_stage,
333: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
334: pa_debug.g_err_stage:= 'p_plan_period_type = '|| p_plan_period_type;
335: pa_debug.write(l_module_name,pa_debug.g_err_stage,
336: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
337: pa_debug.g_err_stage:= 'p_resource_assignment_id = '|| p_resource_assignment_id;
338: pa_debug.write(l_module_name,pa_debug.g_err_stage,
339: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
340: pa_debug.g_err_stage:= 'p_transaction_currency_code = '|| p_transaction_currency_code;

Line 339: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

335: pa_debug.write(l_module_name,pa_debug.g_err_stage,
336: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
337: pa_debug.g_err_stage:= 'p_resource_assignment_id = '|| p_resource_assignment_id;
338: pa_debug.write(l_module_name,pa_debug.g_err_stage,
339: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
340: pa_debug.g_err_stage:= 'p_transaction_currency_code = '|| p_transaction_currency_code;
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,
342: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
343:

Line 342: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

338: pa_debug.write(l_module_name,pa_debug.g_err_stage,
339: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
340: pa_debug.g_err_stage:= 'p_transaction_currency_code = '|| p_transaction_currency_code;
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,
342: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
343:
344: PA_UTILS.ADD_MESSAGE
345: (p_app_short_name => 'PA',
346: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 347: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

343:
344: PA_UTILS.ADD_MESSAGE
345: (p_app_short_name => 'PA',
346: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
347: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
348: END IF;
349: END IF;
350:
351:

Line 355: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR and

351:
352: /* Txn currency code can be Null when the context is G_CALLING_CONTEXT_OTHER_CURR and
353: so checking txn curr code only for other cases */
354:
355: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR and
356: p_transaction_currency_code IS NULL THEN
357: IF p_pa_debug_mode = 'Y' THEN
358: pa_debug.g_err_stage:= 'p_calling_context = ' || p_calling_context;
359: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 359: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

355: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR and
356: p_transaction_currency_code IS NULL THEN
357: IF p_pa_debug_mode = 'Y' THEN
358: pa_debug.g_err_stage:= 'p_calling_context = ' || p_calling_context;
359: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
360: pa_debug.g_err_stage:= 'p_transaction_currency_code is NULL';
361: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
362: END IF;
363: PA_UTILS.ADD_MESSAGE

Line 361: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

357: IF p_pa_debug_mode = 'Y' THEN
358: pa_debug.g_err_stage:= 'p_calling_context = ' || p_calling_context;
359: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
360: pa_debug.g_err_stage:= 'p_transaction_currency_code is NULL';
361: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
362: END IF;
363: PA_UTILS.ADD_MESSAGE
364: (p_app_short_name => 'PA',
365: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 366: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

362: END IF;
363: PA_UTILS.ADD_MESSAGE
364: (p_app_short_name => 'PA',
365: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
366: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
367: END IF;
368:
369: BEGIN
370: SELECT project_id, budget_version_id

Line 380: pa_debug.write(l_module_name,pa_debug.g_err_stage || SQLERRM,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

376: WHEN OTHERS THEN
377: IF p_pa_debug_mode = 'Y' THEN
378: pa_debug.g_err_stage:= 'Error while selecting for the input resource assignment id ' ||
379: p_resource_assignment_id;
380: pa_debug.write(l_module_name,pa_debug.g_err_stage || SQLERRM,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
381: END IF;
382: RAISE;
383: END;
384:

Line 389: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

385: /* In case of calling context being G_CALLING_CONTEXT_OTHER_CURR, get_peceding_suceeding_pd_info
386: need not be called since in this context we are sure there would no budget lines for the resource
387: assignment id and also the txn curr code would be Null */
388:
389: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
390:
391: IF P_PA_DEBUG_MODE = 'Y' THEN
392: pa_debug.g_err_stage := 'Calling get_peceding_suceeding_pd_info ... ';
393: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 412: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

408: IF P_PA_DEBUG_MODE = 'Y' THEN
409: pa_debug.g_err_stage := 'Call to get_peceding_suceeding_pd_info errored... ';
410: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
411: END IF;
412: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
413: END IF;
414:
415: END IF; /* IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN */
416:

Line 415: END IF; /* IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN */

411: END IF;
412: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
413: END IF;
414:
415: END IF; /* IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN */
416:
417:
418: /* In following block we will be deriving PD SD start and end date when these are not available in
419: budget lines table. This needs to be done only when mode is not view because in view mode only

Line 422: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN

418: /* In following block we will be deriving PD SD start and end date when these are not available in
419: budget lines table. This needs to be done only when mode is not view because in view mode only
420: those lines need to be displayed which are in budget lines table. */
421:
422: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
423:
424: /* In this block we will be deriving start/end date of the period in which project start/end
425: date falls. These dates are required later to derive PD/SD start dates */
426:

Line 499: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

495: /* In the context of G_CALLING_CONTEXT_OTHER_CURR, p_txn_curr_code would be Null and
496: we are sure there would be no budget lines and hence the following update need not
497: be done */
498:
499: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
500: UPDATE PA_BUDGET_LINES
501: SET BUCKETING_PERIOD_CODE = NULL
502: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
503: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id

Line 505: AND BUCKETING_PERIOD_CODE = PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PE;

501: SET BUCKETING_PERIOD_CODE = NULL
502: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
503: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id
504: AND BUDGET_VERSION_ID = l_budget_version_id
505: AND BUCKETING_PERIOD_CODE = PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PE;
506: END IF;
507:
508: IF P_PA_DEBUG_MODE = 'Y' THEN
509: pa_debug.g_err_stage := 'calling get_period_info ...';

Line 514: (p_bucketing_period_code => PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD

510: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
511: END IF;
512:
513: PA_PLAN_MATRIX.GET_PERIOD_INFO
514: (p_bucketing_period_code => PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD
515: ,p_st_dt_4_st_pd => p_pp_st_dt
516: ,p_st_dt_4_end_pd => p_pp_end_dt
517: ,p_plan_period_type => p_plan_period_type
518: ,p_project_id => l_project_id

Line 534: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

530: IF P_PA_DEBUG_MODE = 'Y' THEN
531: pa_debug.g_err_stage := 'calling get_period_info - FAILED...';
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
533: END IF;
534: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
535: END IF;
536:
537: END IF; /* l_proj_start_prd_start_dt IS NULL OR p_pp_st_dt > l_proj_start_prd_start_dt */
538:

Line 559: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

555: /* In the context of G_CALLING_CONTEXT_OTHER_CURR, p_txn_curr_code would be Null and
556: we are sure there would be no budget lines and hence the following update need not
557: be done */
558:
559: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
560: UPDATE PA_BUDGET_LINES
561: SET BUCKETING_PERIOD_CODE = NULL
562: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
563: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id

Line 565: AND BUCKETING_PERIOD_CODE = PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SE;

561: SET BUCKETING_PERIOD_CODE = NULL
562: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
563: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id
564: AND BUDGET_VERSION_ID = l_budget_version_id
565: AND BUCKETING_PERIOD_CODE = PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SE;
566: END IF;
567:
568: IF P_PA_DEBUG_MODE = 'Y' THEN
569: pa_debug.g_err_stage := 'calling get_period_info ...';

Line 574: (p_bucketing_period_code => PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD

570: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
571: END IF;
572:
573: PA_PLAN_MATRIX.GET_PERIOD_INFO
574: (p_bucketing_period_code => PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD
575: ,p_st_dt_4_st_pd => p_pp_st_dt
576: ,p_st_dt_4_end_pd => p_pp_end_dt
577: ,p_plan_period_type => p_plan_period_type
578: ,p_project_id => l_project_id

Line 594: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

590: IF P_PA_DEBUG_MODE = 'Y' THEN
591: pa_debug.g_err_stage := 'calling get_period_info - FAILED...';
592: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
593: END IF;
594: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
595: END IF;
596:
597: END IF; /* l_proj_end_prd_end_dt IS NULL OR p_pp_end_dt < l_proj_end_prd_end_dt */
598:

Line 601: END IF; /* p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW */

597: END IF; /* l_proj_end_prd_end_dt IS NULL OR p_pp_end_dt < l_proj_end_prd_end_dt */
598:
599: END IF; /* x_sd_st_dt IS NULL */
600:
601: END IF; /* p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW */
602:
603: IF p_pa_debug_mode = 'Y' THEN
604: pa_debug.g_err_stage:= 'Exiting DERIVE_PD_SD_START_END_DATES';
605: pa_debug.write(l_module_name,pa_debug.g_err_stage,

Line 606: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

602:
603: IF p_pa_debug_mode = 'Y' THEN
604: pa_debug.g_err_stage:= 'Exiting DERIVE_PD_SD_START_END_DATES';
605: pa_debug.write(l_module_name,pa_debug.g_err_stage,
606: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
607: pa_debug.reset_err_stack;
608: END IF;
609:
610: EXCEPTION

Line 612: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

608: END IF;
609:
610: EXCEPTION
611:
612: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
613:
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: l_msg_count := FND_MSG_PUB.count_msg;
616:

Line 649: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

645:
646: IF p_pa_debug_mode = 'Y' THEN
647: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
648: pa_debug.write(l_module_name,pa_debug.g_err_stage,
649: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
650: pa_debug.reset_err_stack;
651: END IF;
652: RAISE;
653:

Line 867: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

863:
864: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
865: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
866:
867: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
868:
869: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
870:
871: IF p_resource_assignment_id IS NULL THEN

Line 869: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

865: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
866:
867: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
868:
869: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
870:
871: IF p_resource_assignment_id IS NULL THEN
872:
873: pa_debug.g_err_stage := 'resource assignment id is null in edit in another currency.';

Line 883: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

879:
880: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
881: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
882:
883: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
884: END IF;
885: ELSE
886:
887: IF p_resource_assignment_id IS NULL OR

Line 912: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

908:
909: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
910: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
911:
912: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
913: END IF;
914: END IF;
915:
916: pa_debug.g_err_stage := 'p_calling_context = ' || p_calling_context;

Line 969: IF l_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN

965: IF P_PA_DEBUG_MODE = 'Y' THEN
966: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);
967: END IF;
968:
969: IF l_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
970:
971: IF l_period_profile_id IS NULL THEN
972: pa_debug.g_err_stage := 'period_profile_id is null when time phasing is PA or GL ';
973: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 979: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

975: END IF;
976: /* Bug # 2617990 */
977: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
978: p_msg_name => 'PA_FP_PERIODPROFILE_UNDEFINED');
979: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
980: END IF;
981:
982: ELSE /* if time phasing is none then */
983:

Line 984: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN

980: END IF;
981:
982: ELSE /* if time phasing is none then */
983:
984: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
985: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
986: IF l_project_start_date IS NULL or l_project_end_date IS NULL THEN
987: pa_debug.g_err_stage := 'for time phase none and entry level project, project start date and end date must be not null';
988: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 985: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

981:
982: ELSE /* if time phasing is none then */
983:
984: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
985: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
986: IF l_project_start_date IS NULL or l_project_end_date IS NULL THEN
987: pa_debug.g_err_stage := 'for time phase none and entry level project, project start date and end date must be not null';
988: IF P_PA_DEBUG_MODE = 'Y' THEN
989: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);

Line 991: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

987: pa_debug.g_err_stage := 'for time phase none and entry level project, project start date and end date must be not null';
988: IF P_PA_DEBUG_MODE = 'Y' THEN
989: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);
990: END IF;
991: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
992: END IF;
993: ELSE
994: /*bug 3182883 if calling context is 'VIEW' do not throw error*/
995: IF (l_task_start_date IS NULL or l_task_end_date IS NULL)

Line 1001: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

997: pa_debug.g_err_stage := 'for time phase none and entry level task, task start date and end date must be not null';
998: IF P_PA_DEBUG_MODE = 'Y' THEN
999: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);
1000: END IF;
1001: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1002: END IF;
1003: END IF;
1004: END IF;
1005: END IF;

Line 1013: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

1009: /* Since in the context of G_CALLING_CONTEXT_OTHER_CURR, there would be no records
1010: in budget lines for the resource assignment and also since p_txn_curr_code would
1011: be null, we need not call get_preceding_succeeding_amt */
1012:
1013: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
1014:
1015: pa_debug.g_err_stage := 'calling get_preceding_succeeding_amt';
1016: IF P_PA_DEBUG_MODE = 'Y' THEN
1017: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1061: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1057: ,x_msg_count => l_msg_count
1058: ,x_msg_data => l_msg_data);
1059:
1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1062: END IF;
1063: END IF;
1064:
1065: /* Fix for enhancement bug # 2604957 starts */

Line 1071: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN

1067: /* In the context of view, we need to show only the records that are present in the
1068: budget lines and that from first avaiable period to the last available period in
1069: pa_budget_lines */
1070:
1071: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
1072:
1073: SELECT MIN(start_date), MAX(start_date)
1074: INTO l_min_start_date,l_max_start_date
1075: FROM pa_budget_lines

Line 1109: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1105: ,x_msg_count => l_msg_count
1106: ,x_msg_data => l_msg_data);
1107:
1108: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1109: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1110: END IF;
1111:
1112: /* Fix for enhancement bug # 2604957 ends*/
1113:

Line 1120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1116: DELETE FROM PA_FP_ROLLUP_TMP;
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from PA_FP_ROLLUP_TMP table' ;
1120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1121: END IF;
1122:
1123:
1124: OPEN MC_CUR(l_fin_plan_version_id,p_txn_currency_code);

Line 1133: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1129:
1130: IF P_PA_DEBUG_MODE = 'Y' THEN
1131: pa_debug.g_err_stage:='time phasing is '|| l_time_phased_code ||
1132: ' before getting project start / end date period start / end dates';
1133: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1134: END IF;
1135:
1136: IF l_period_profile_id IS NOT NULL THEN
1137:

Line 1230: l_preceding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,

1226: tmp.PERIOD_NAME) PERIOD_NAME
1227: ,pbl.CHANGE_REASON_CODE
1228: ,pbl.DESCRIPTION
1229: ,decode(tmp.start_date,
1230: l_preceding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,
1231: l_succeeding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD)
1232: BUCKETING_PERIOD_CODE
1233: ,P_TXN_CURRENCY_CODE
1234: ,pra.PARENT_ASSIGNMENT_ID

Line 1231: l_succeeding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD)

1227: ,pbl.CHANGE_REASON_CODE
1228: ,pbl.DESCRIPTION
1229: ,decode(tmp.start_date,
1230: l_preceding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,
1231: l_succeeding_prd_start_date,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD)
1232: BUCKETING_PERIOD_CODE
1233: ,P_TXN_CURRENCY_CODE
1234: ,pra.PARENT_ASSIGNMENT_ID
1235: ,nvl(pbl.PROJECT_CURRENCY_CODE,l_project_currency_code)

Line 1390: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN

1386: based upon planning level.
1387: in case time phasing is date range. insert a row with these values as null
1388: User will enter the required start and end dates.
1389: */
1390: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
1391: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
1392: l_start_date := l_project_start_date;
1393: l_end_date := l_project_end_date;
1394: ELSE

Line 1391: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

1387: in case time phasing is date range. insert a row with these values as null
1388: User will enter the required start and end dates.
1389: */
1390: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
1391: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
1392: l_start_date := l_project_start_date;
1393: l_end_date := l_project_end_date;
1394: ELSE
1395: l_start_date := l_task_start_date;

Line 1569: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN

1565: );
1566:
1567: l_count := SQL%ROWCOUNT;
1568: /* Bug found during Unit Testing. Do the insert only in EDIT / EDIT ANOTHER CURRENCY modes */
1569: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
1570: IF nvl(l_count,0) = 0 THEN
1571: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_R THEN
1572: FOR i IN 1..5 LOOP
1573: insert_dummy_record_pvt(mc_cur_rec);

Line 1571: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_R THEN

1567: l_count := SQL%ROWCOUNT;
1568: /* Bug found during Unit Testing. Do the insert only in EDIT / EDIT ANOTHER CURRENCY modes */
1569: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
1570: IF nvl(l_count,0) = 0 THEN
1571: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_R THEN
1572: FOR i IN 1..5 LOOP
1573: insert_dummy_record_pvt(mc_cur_rec);
1574: END LOOP;
1575: ELSE

Line 1602: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1598:
1599: pa_debug.reset_err_stack; /* Bug 2699888 */
1600:
1601: EXCEPTION
1602: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: l_msg_count := FND_MSG_PUB.count_msg;
1605: IF l_msg_count = 1 THEN
1606: PA_INTERFACE_UTILS_PUB.get_messages

Line 1732: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1728:
1729: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1730: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1731:
1732: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1733:
1734: END IF;
1735:
1736: l_calling_context := p_calling_context; /* Bug# 2674353 */

Line 1780: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD);

1776: ,txn_revenue = DECODE(old_txn_revenue,NULL,NULL,0)
1777: ,quantity = DECODE(old_quantity,NULL,NULL,0)
1778: WHERE delete_flag = 'Y'
1779: AND bucketing_period_code IN
1780: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD);
1781: *********************/
1782:
1783: IF P_PA_DEBUG_MODE = 'Y' THEN
1784: pa_debug.g_err_stage := TO_CHAR(l_stage)||': updated '||sql%rowcount||' records ';

Line 1807: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_EDIT_PLAN_LINE_PAGE THEN

1803: IF P_PA_DEBUG_MODE = 'Y' THEN
1804: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,5);
1805: END IF;
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_EDIT_PLAN_LINE_PAGE THEN
1808: x_msg_data := 'PA_FP_EPL_TASK_UPDATED';
1809: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1810: ELSE
1811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1809: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1805: END IF;
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_EDIT_PLAN_LINE_PAGE THEN
1808: x_msg_data := 'PA_FP_EPL_TASK_UPDATED';
1809: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1810: ELSE
1811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1812: p_msg_name => 'PA_FP_EPL_TASK_UPDATED');
1813: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1813: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1809: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1810: ELSE
1811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1812: p_msg_name => 'PA_FP_EPL_TASK_UPDATED');
1813: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1814: END IF;
1815:
1816:
1817: END;

Line 1830: IF nvl(l_calling_context,-99) <> PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE THEN

1826: sent the converted amounts in pc and pfc and hence we should not
1827: be calling mc api. This might do a revaluation based on finplan setup
1828: which is wrong */
1829:
1830: IF nvl(l_calling_context,-99) <> PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE THEN
1831:
1832: pa_debug.g_err_stage := ': calling convert_txn_currency';
1833: IF P_PA_DEBUG_MODE = 'Y' THEN
1834: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1852: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_WEBADI THEN --WEBADI UT

1848: pa_debug.g_err_stage := 'calling context : '|| p_calling_context; -- WEBADI UT
1849: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1850: END IF;
1851:
1852: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_WEBADI THEN --WEBADI UT
1853: --This exception needs to be raised only in webadi context.
1854: Raise PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc;
1855: END IF;
1856:

Line 1854: Raise PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc;

1850: END IF;
1851:
1852: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_WEBADI THEN --WEBADI UT
1853: --This exception needs to be raised only in webadi context.
1854: Raise PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc;
1855: END IF;
1856:
1857: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1858: END IF;

Line 1857: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1853: --This exception needs to be raised only in webadi context.
1854: Raise PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc;
1855: END IF;
1856:
1857: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1858: END IF;
1859:
1860: END IF; /* l_calling_context <> PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE */
1861:

Line 1860: END IF; /* l_calling_context <> PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE */

1856:
1857: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1858: END IF;
1859:
1860: END IF; /* l_calling_context <> PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE */
1861:
1862: -- Delete the lines which have delete_flag = 'Y'
1863: -- in the temp table
1864:

Line 2039: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2035: ,PROJECT_REV_RATE_DATE
2036: ,PROJECT_REV_RATE_TYPE
2037: ,PROJECT_REV_EXCHANGE_RATE
2038: ,PROJECT_REV_RATE_DATE_TYPE
2039: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2040: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */

Line 2040: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2036: ,PROJECT_REV_RATE_TYPE
2037: ,PROJECT_REV_EXCHANGE_RATE
2038: ,PROJECT_REV_RATE_DATE_TYPE
2039: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2040: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */
2044: ,sysdate

Line 2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2037: ,PROJECT_REV_EXCHANGE_RATE
2038: ,PROJECT_REV_RATE_DATE_TYPE
2039: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2040: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */
2044: ,sysdate
2045: ,FND_GLOBAL.USER_ID

Line 2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2038: ,PROJECT_REV_RATE_DATE_TYPE
2039: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2040: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */
2044: ,sysdate
2045: ,FND_GLOBAL.USER_ID
2046: ,FND_GLOBAL.LOGIN_ID

Line 2092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2088: END IF;
2089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2090: p_msg_name => 'PA_FP_DISABLED_RES_PLANNE');
2091:
2092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2093: END IF;
2094: /* End of code fix for bug 3289243 */
2095:
2096: -- insert into budget lines table those

Line 2200: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2196: ,ATTRIBUTE12
2197: ,ATTRIBUTE13
2198: ,ATTRIBUTE14
2199: ,ATTRIBUTE15
2200: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2201: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2202: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2203: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2204: ,PROJFUNC_CURRENCY_CODE

Line 2201: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2197: ,ATTRIBUTE13
2198: ,ATTRIBUTE14
2199: ,ATTRIBUTE15
2200: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2201: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2202: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2203: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2204: ,PROJFUNC_CURRENCY_CODE
2205: ,PROJFUNC_COST_RATE_TYPE

Line 2202: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2198: ,ATTRIBUTE14
2199: ,ATTRIBUTE15
2200: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2201: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2202: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2203: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2204: ,PROJFUNC_CURRENCY_CODE
2205: ,PROJFUNC_COST_RATE_TYPE
2206: ,PROJFUNC_COST_EXCHANGE_RATE

Line 2203: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

2199: ,ATTRIBUTE15
2200: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2201: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2202: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2203: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2204: ,PROJFUNC_CURRENCY_CODE
2205: ,PROJFUNC_COST_RATE_TYPE
2206: ,PROJFUNC_COST_EXCHANGE_RATE
2207: ,PROJFUNC_COST_RATE_DATE_TYPE

Line 2240: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD) */

2236: WHERE tmp.budget_line_id IS NULL
2237: /* manokuma: added following as PD and SD should not be inserted in this procedure */
2238: /* Bug 2779688 - PD/SD can be inserted in this procedure and hence commenting the where clause
2239: AND nvl(tmp.bucketing_period_code,'XYZ') NOT IN
2240: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD) */
2241: AND (tmp.txn_raw_cost IS NOT NULL
2242: or tmp.txn_burdened_cost IS NOT NULL
2243: or tmp.quantity IS NOT NULL
2244: or tmp.txn_revenue IS NOT NULL));

Line 2259: IF nvl(p_calling_context,'-99') <> PA_FP_CONSTANTS_PKG.G_WEBADI THEN

2255: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Increasing record version no. for Budget Version.';
2256: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
2257: END IF;
2258:
2259: IF nvl(p_calling_context,'-99') <> PA_FP_CONSTANTS_PKG.G_WEBADI THEN
2260: UPDATE pa_budget_versions
2261: SET record_version_number = nvl(record_version_number,0) + 1
2262: WHERE budget_version_id = l_budget_version_id;
2263: END IF;

Line 2323: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2319:
2320: pa_debug.reset_err_stack; /* 2641475 */
2321:
2322: EXCEPTION
2323: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2324: x_return_status := FND_API.G_RET_STS_ERROR;
2325: l_msg_count := FND_MSG_PUB.count_msg;
2326: IF l_msg_count = 1 THEN
2327: PA_INTERFACE_UTILS_PUB.get_messages

Line 2349: WHEN PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc THEN --WEBADI UT.

2345: pa_debug.reset_err_stack;
2346:
2347: RETURN;
2348:
2349: WHEN PA_FP_CONSTANTS_PKG.MC_Conversion_Failed_Exc THEN --WEBADI UT.
2350: -- No processing is required here. The processing will be done in WEBADI PKG.
2351: RAISE;
2352: WHEN DUP_VAL_ON_INDEX THEN --Added this handler for AMG.
2353: -- Call the api that adds the error messages for duplicate rows

Line 2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2499:
2500: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2501: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2502:
2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504:
2505: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
2506:
2507: IF p_resource_assignment_id IS NULL THEN

Line 2505: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

2501: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2502:
2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504:
2505: ELSIF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
2506:
2507: IF p_resource_assignment_id IS NULL THEN
2508:
2509: pa_debug.g_err_stage := 'resource assignment id is null in edit in another currency.';

Line 2519: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2515:
2516: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2517: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2518:
2519: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2520: END IF;
2521: ELSE
2522:
2523: IF p_resource_assignment_id IS NULL OR

Line 2548: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2544:
2545: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2546: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2547:
2548: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2549: END IF;
2550: END IF;
2551:
2552:

Line 2585: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN

2581: l_amount_set_id := pa_fin_plan_utils.Get_Amount_Set_Id(
2582: p_fin_plan_version_id => l_fin_plan_version_id);
2583:
2584:
2585: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
2586:
2587: pa_debug.g_err_stage := TO_CHAR(l_stage)||':calling PA_FIN_PLAN_UTILS.Get_Element_Proj_PF_Amounts ';
2588: IF P_PA_DEBUG_MODE = 'Y' THEN
2589: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2656: /* p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN */

2652: IF P_PA_DEBUG_MODE = 'Y' THEN
2653: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,3);
2654: END IF;
2655: END IF ;
2656: /* p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN */
2657:
2658: pa_debug.g_err_stage := TO_CHAR(l_stage)||':calling PA_FIN_PLAN_UTILS.GET_PLAN_AMOUNT_FLAGS ';
2659: IF P_PA_DEBUG_MODE = 'Y' THEN
2660: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2704: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2700:
2701: pa_debug.reset_err_stack; /* Bug 2699888 */
2702:
2703: EXCEPTION
2704: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706: l_msg_count := FND_MSG_PUB.count_msg;
2707: IF l_msg_count = 1 THEN
2708: PA_INTERFACE_UTILS_PUB.get_messages

Line 2808: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2804: END IF;
2805: x_return_status := FND_API.G_RET_STS_ERROR;
2806: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2807: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2808: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2809: END IF;
2810:
2811: IF l_debug_mode = 'Y' THEN
2812: pa_debug.g_err_stage := 'before extending p_start_date_tbl.last = ' || p_start_date_tbl.last;

Line 2863: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2859: ) ;
2860:
2861:
2862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2863: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2864: END IF ;
2865:
2866: IF l_debug_mode = 'Y' THEN
2867: pa_debug.g_err_stage:= 'Exiting CALL_CLIENT_EXTENSION' ;

Line 2873: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2869: pa_debug.reset_curr_function;
2870: END IF;
2871:
2872: EXCEPTION
2873: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2874: x_return_status := FND_API.G_RET_STS_ERROR;
2875: l_msg_count := FND_MSG_PUB.count_msg;
2876: IF l_debug_mode = 'Y' THEN
2877: pa_debug.g_err_stage := 'inside invalid arg exception of call_client_extensions';

Line 2948: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2944: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2945:
2946: pa_debug.g_err_stage := TO_CHAR(l_stage)||':In PA_FP_EDIT_LINE_PKG.POPULATE_ELIGIBLE_PERIODS ';
2947: IF P_PA_DEBUG_MODE = 'Y' THEN
2948: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2949: END IF;
2950:
2951: IF (p_fin_plan_version_id IS NULL) THEN
2952: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Invalid Input Parameters';

Line 2959: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2955: END IF;
2956: x_return_status := FND_API.G_RET_STS_ERROR;
2957: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2958: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2959: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2960: END IF;
2961:
2962: l_stage := 200;
2963: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Starting the main processing. Inserting into temp table';

Line 2965: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2961:
2962: l_stage := 200;
2963: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Starting the main processing. Inserting into temp table';
2964: IF P_PA_DEBUG_MODE = 'Y' THEN
2965: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2966: END IF;
2967:
2968: l_time_phased_code := pa_fin_plan_utils.get_time_phased_code(
2969: p_fin_plan_version_id => p_fin_plan_version_id);

Line 2973: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2969: p_fin_plan_version_id => p_fin_plan_version_id);
2970:
2971: pa_debug.g_err_stage:='l_time_phased_code is '|| l_time_phased_code;
2972: IF P_PA_DEBUG_MODE = 'Y' THEN
2973: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2974: END IF;
2975:
2976: pa_debug.g_err_stage:='l_start_period_start_date is '||to_char(p_period_profile_start_date);
2977: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2978: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2974: END IF;
2975:
2976: pa_debug.g_err_stage:='l_start_period_start_date is '||to_char(p_period_profile_start_date);
2977: IF P_PA_DEBUG_MODE = 'Y' THEN
2978: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2979: END IF;
2980:
2981: pa_debug.g_err_stage:='l_end_period_end_date is '||to_char(p_period_profile_end_date) ;
2982: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2983: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2979: END IF;
2980:
2981: pa_debug.g_err_stage:='l_end_period_end_date is '||to_char(p_period_profile_end_date) ;
2982: IF P_PA_DEBUG_MODE = 'Y' THEN
2983: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2984: END IF;
2985:
2986: pa_debug.g_err_stage:='p_preceding_prd_start_date is '||to_char(p_preceding_prd_start_date);
2987: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2988: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2984: END IF;
2985:
2986: pa_debug.g_err_stage:='p_preceding_prd_start_date is '||to_char(p_preceding_prd_start_date);
2987: IF P_PA_DEBUG_MODE = 'Y' THEN
2988: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2989: END IF;
2990:
2991: pa_debug.g_err_stage:='p_succeeding_prd_start_date is '||to_char(p_succeeding_prd_start_date) ;
2992: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2993: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2989: END IF;
2990:
2991: pa_debug.g_err_stage:='p_succeeding_prd_start_date is '||to_char(p_succeeding_prd_start_date) ;
2992: IF P_PA_DEBUG_MODE = 'Y' THEN
2993: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2994: END IF;
2995:
2996: delete from pa_fp_cpy_periods_tmp;
2997:

Line 3000: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2996: delete from pa_fp_cpy_periods_tmp;
2997:
2998: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from tmp table' ;
2999: IF P_PA_DEBUG_MODE = 'Y' THEN
3000: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3001: END IF;
3002:
3003:
3004: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN

Line 3004: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN

3000: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3001: END IF;
3002:
3003:
3004: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
3005:
3006: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of pa_period time phasing';
3007: IF P_PA_DEBUG_MODE = 'Y' THEN
3008: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 3008: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3004: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
3005:
3006: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of pa_period time phasing';
3007: IF P_PA_DEBUG_MODE = 'Y' THEN
3008: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3009: END IF;
3010:
3011: IF p_preceding_prd_start_date IS NOT NULL THEN
3012:

Line 3015: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3011: IF p_preceding_prd_start_date IS NOT NULL THEN
3012:
3013: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3014: IF P_PA_DEBUG_MODE = 'Y' THEN
3015: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3016: END IF;
3017:
3018: INSERT INTO pa_fp_cpy_periods_tmp
3019: ( start_date

Line 3050: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3046: WHERE start_date BETWEEN p_period_profile_start_date AND p_period_profile_end_date;
3047:
3048: pa_debug.g_err_stage := TO_CHAR(l_stage)||'inserted ' || sql%rowcount || ' records';
3049: IF P_PA_DEBUG_MODE = 'Y' THEN
3050: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3051: END IF;
3052:
3053: IF p_succeeding_prd_start_date IS NOT NULL THEN
3054:

Line 3057: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3053: IF p_succeeding_prd_start_date IS NOT NULL THEN
3054:
3055: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for succeeding period' ;
3056: IF P_PA_DEBUG_MODE = 'Y' THEN
3057: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3058: END IF;
3059:
3060: INSERT INTO pa_fp_cpy_periods_tmp
3061: ( start_date

Line 3076: ELSIF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN

3072: WHERE start_date = p_succeeding_prd_start_date;
3073:
3074: END IF;
3075:
3076: ELSIF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN
3077:
3078: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of gl_period time phasing';
3079: IF P_PA_DEBUG_MODE = 'Y' THEN
3080: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3088: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3084: IF p_preceding_prd_start_date IS NOT NULL THEN
3085:
3086: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3087: IF P_PA_DEBUG_MODE = 'Y' THEN
3088: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3089: END IF;
3090:
3091: INSERT INTO pa_fp_cpy_periods_tmp
3092: ( start_date

Line 3131: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3127: AND g.start_date BETWEEN p_period_profile_start_date AND p_period_profile_end_date;
3128:
3129: pa_debug.g_err_stage := TO_CHAR(l_stage)||'inserted ' || sql%rowcount || ' records';
3130: IF P_PA_DEBUG_MODE = 'Y' THEN
3131: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3132: END IF;
3133:
3134: IF p_succeeding_prd_start_date IS NOT NULL THEN
3135:

Line 3138: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3134: IF p_succeeding_prd_start_date IS NOT NULL THEN
3135:
3136: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3137: IF P_PA_DEBUG_MODE = 'Y' THEN
3138: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3139: END IF;
3140:
3141: INSERT INTO pa_fp_cpy_periods_tmp
3142: ( start_date

Line 3165: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3161: END IF;
3162:
3163: pa_debug.g_err_stage := TO_CHAR(l_stage)||'end of PA_FP_EDIT_LINE_PKG.POPULATE_ELIGIBLE_PERIODS';
3164: IF P_PA_DEBUG_MODE = 'Y' THEN
3165: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3166: END IF;
3167:
3168: pa_debug.reset_err_stack; /* Bug 2699888 */
3169:

Line 3171: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3167:
3168: pa_debug.reset_err_stack; /* Bug 2699888 */
3169:
3170: EXCEPTION
3171: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3172:
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: l_msg_count := FND_MSG_PUB.count_msg;
3175: IF l_msg_count = 1 THEN

Line 3283: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3279: END IF;
3280: PA_UTILS.ADD_MESSAGE
3281: (p_app_short_name => 'PA',
3282: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3283: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3284:
3285: END IF;
3286:
3287: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3308: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PE);

3304: FROM pa_budget_lines
3305: WHERE resource_assignment_id = p_resource_assignment_id
3306: AND txn_currency_code = p_txn_currency_code
3307: AND bucketing_period_code in
3308: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PE);
3309: EXCEPTION
3310: WHEN NO_DATA_FOUND THEN
3311: x_pd_pfc_raw_cost := null ;
3312: x_pd_pfc_burdened_cost := null ;

Line 3336: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SE);

3332: FROM pa_budget_lines
3333: WHERE resource_assignment_id = p_resource_assignment_id
3334: AND txn_currency_code = p_txn_currency_code
3335: AND bucketing_period_code in
3336: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SE);
3337: EXCEPTION
3338: WHEN NO_DATA_FOUND THEN
3339: x_sd_pfc_raw_cost := null ;
3340: x_sd_pfc_burdened_cost := null ;

Line 3356: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3352: pa_debug.reset_curr_function;
3353:
3354: EXCEPTION
3355:
3356: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3357:
3358: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS THEN
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END IF;

Line 3430: AND object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT

3426: ,succeeding_periods_amount
3427: FROM pa_proj_periods_denorm
3428: WHERE budget_version_id = p_budget_version_id
3429: AND resource_assignment_id = p_resource_assignment_id
3430: AND object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT
3431: AND object_id = p_resource_assignment_id
3432: AND currency_code = p_txn_currency_code
3433: AND period_profile_id = p_period_profile_id
3434: AND currency_type = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_TRANSACTION ;

Line 3434: AND currency_type = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_TRANSACTION ;

3430: AND object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT
3431: AND object_id = p_resource_assignment_id
3432: AND currency_code = p_txn_currency_code
3433: AND period_profile_id = p_period_profile_id
3434: AND currency_type = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_TRANSACTION ;
3435:
3436: l_period_denorm_cur_rec period_denorm_cur%ROWTYPE ;
3437:
3438: BEGIN

Line 3463: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY

3459: pa_debug.write('GET_PRECEDING_SUCCEEDING_AMT: ' || l_module_name,'getting preceding succeeding period amounts',3);
3460: END IF;
3461:
3462: FOR l_period_denorm_cur_rec IN period_denorm_cur LOOP
3463: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
3464: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) THEN
3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;

Line 3464: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) THEN

3460: END IF;
3461:
3462: FOR l_period_denorm_cur_rec IN period_denorm_cur LOOP
3463: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
3464: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) THEN
3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3468: x_succeeding_raw_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;

Line 3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

3461:
3462: FOR l_period_denorm_cur_rec IN period_denorm_cur LOOP
3463: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
3464: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) THEN
3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3468: x_succeeding_raw_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3469: ELSIF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

Line 3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN

3462: FOR l_period_denorm_cur_rec IN period_denorm_cur LOOP
3463: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
3464: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) THEN
3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3468: x_succeeding_raw_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3469: ELSIF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3470: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST ) THEN

Line 3469: ELSIF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

3465: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3468: x_succeeding_raw_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3469: ELSIF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3470: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST ) THEN
3471: x_preceding_burdened_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3472: x_succeeding_burdened_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3473: END IF;

Line 3470: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST ) THEN

3466: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST ) THEN
3467: x_preceding_raw_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3468: x_succeeding_raw_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3469: ELSIF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
3470: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST ) THEN
3471: x_preceding_burdened_cost := l_period_denorm_cur_rec.preceding_periods_amount ;
3472: x_succeeding_burdened_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3473: END IF;
3474: END IF ;

Line 3476: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY

3472: x_succeeding_burdened_cost := l_period_denorm_cur_rec.succeeding_periods_amount ;
3473: END IF;
3474: END IF ;
3475:
3476: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY
3477: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) then
3478: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE
3479: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE ) THEN
3480: x_preceding_revenue := l_period_denorm_cur_rec.preceding_periods_amount ;

Line 3477: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) then

3473: END IF;
3474: END IF ;
3475:
3476: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY
3477: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) then
3478: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE
3479: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE ) THEN
3480: x_preceding_revenue := l_period_denorm_cur_rec.preceding_periods_amount ;
3481: x_succeeding_revenue := l_period_denorm_cur_rec.succeeding_periods_amount ;

Line 3478: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE

3474: END IF ;
3475:
3476: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY
3477: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) then
3478: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE
3479: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE ) THEN
3480: x_preceding_revenue := l_period_denorm_cur_rec.preceding_periods_amount ;
3481: x_succeeding_revenue := l_period_denorm_cur_rec.succeeding_periods_amount ;
3482: END IF;

Line 3479: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE ) THEN

3475:
3476: IF (l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY
3477: OR l_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) then
3478: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE
3479: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE ) THEN
3480: x_preceding_revenue := l_period_denorm_cur_rec.preceding_periods_amount ;
3481: x_succeeding_revenue := l_period_denorm_cur_rec.succeeding_periods_amount ;
3482: END IF;
3483: END IF ;

Line 3485: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY

3481: x_succeeding_revenue := l_period_denorm_cur_rec.succeeding_periods_amount ;
3482: END IF;
3483: END IF ;
3484:
3485: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY
3486: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY ) THEN
3487: x_preceding_quantity := l_period_denorm_cur_rec.preceding_periods_amount ;
3488: x_succeeding_quantity := l_period_denorm_cur_rec.succeeding_periods_amount ;
3489: END IF;

Line 3486: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY ) THEN

3482: END IF;
3483: END IF ;
3484:
3485: IF ( l_period_denorm_cur_rec.amount_type_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY
3486: AND l_period_denorm_cur_rec.amount_subtype_code = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY ) THEN
3487: x_preceding_quantity := l_period_denorm_cur_rec.preceding_periods_amount ;
3488: x_succeeding_quantity := l_period_denorm_cur_rec.succeeding_periods_amount ;
3489: END IF;
3490: END LOOP;

Line 3570: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3566: END IF;
3567: x_return_status := FND_API.G_RET_STS_ERROR;
3568: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3569: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3570: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3571: END IF;
3572:
3573:
3574: IF l_debug_mode = 'Y' THEN

Line 3634: IF l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN

3630: pa_debug.g_err_stage := TO_CHAR(l_stage)||':inside FOR loop and before calling cal_raw_cost';
3631: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.g_err_stage,3);
3632: END IF;
3633:
3634: IF l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
3635:
3636: PA_CLIENT_EXTN_BUDGET.CALC_RAW_COST
3637: (x_budget_version_id => p_budget_version_id,
3638: x_project_id => p_project_id,

Line 3750: IF l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN

3746:
3747: END IF;
3748: END IF; -- preference code is cost only or cost and rev same
3749:
3750: IF l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
3751:
3752: PA_CLIENT_EXTN_BUDGET.CALC_REVENUE
3753: (x_budget_version_id => p_budget_version_id,
3754: x_project_id => p_project_id,

Line 3830: WHEN FND_API.G_EXC_ERROR OR PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3826: pa_debug.reset_curr_function;
3827: END IF;
3828:
3829: EXCEPTION
3830: WHEN FND_API.G_EXC_ERROR OR PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3831:
3832: ROLLBACK to call_client_extns;
3833: x_return_status := FND_API.G_RET_STS_ERROR;
3834: l_msg_count := FND_MSG_PUB.count_msg;

Line 4096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4092: END IF;
4093: PA_UTILS.ADD_MESSAGE
4094: (p_app_short_name => 'PA',
4095: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4097: END IF;
4098:
4099: /* Call PA_FP_MULTI_CURRENCY_PKG.CONVERT_TXN_CURRENCY for the MC conversions. */
4100:

Line 4113: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4109: IF P_PA_DEBUG_MODE = 'Y' THEN
4110: pa_debug.g_err_stage := 'Call to PA_FP_MULTI_CURRENCY_PKG.CONVERT_TXN_CURRENCY errored... ';
4111: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
4112: END IF;
4113: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4114: END IF;
4115:
4116: /* Increasing the Record Version Number, similar to the one being done in the API
4117: Process_Modified_Lines. The parameter p_calling_context is not being used as of now.

Line 4195: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4191: IF P_PA_DEBUG_MODE = 'Y' THEN
4192: pa_debug.g_err_stage := 'Call to PA_FP_ROLLUP_PKG errored... ';
4193: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
4194: END IF;
4195: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4196: END IF;
4197:
4198:
4199: IF l_debug_mode = 'Y' THEN

Line 4207: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4203: END IF;
4204: pa_debug.reset_curr_function;
4205: EXCEPTION
4206:
4207: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4208:
4209: x_return_status := FND_API.G_RET_STS_ERROR;
4210: l_msg_count := FND_MSG_PUB.count_msg;
4211: