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_CI_IMPLEMENT_PKG dependencies on PA_FP_CI_IMPLEMENT_PKG

Line 1: package body pa_fp_ci_implement_pkg as

1: package body pa_fp_ci_implement_pkg as
2: /* $Header: PAFPCOMB.pls 120.3.12010000.3 2008/09/10 21:11:27 snizam ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: --3 new parameters are added as part of rounding changes.

Line 84: l_module_name VARCHAR2(100):='pa_fp_ci_implement_pkg.create_ci_impact_fund_lines';

80: l_tmp_amount NUMBER;
81: l_rounded_agr_sum NUMBER;
82: l_rounded_pc_sum NUMBER;
83: l_rounded_pfc_sum NUMBER;
84: l_module_name VARCHAR2(100):='pa_fp_ci_implement_pkg.create_ci_impact_fund_lines';
85:
86: l_budget_line_count NUMBER; --Bug 5509687
87: -- Bug 6772321
88: l_project_exchange_rate pa_project_fundings.project_exchange_rate%TYPE;

Line 99: PA_DEBUG.init_err_stack('pa_fp_ci_implement_pkg.create_ci_impact_fund_lines');

95: /* the above default is set for testing purpose only
96: need to set to 'N' after testing */
97: IF l_debug_mode = 'Y' THEN
98: IF P_PA_DEBUG_MODE = 'Y' THEN
99: PA_DEBUG.init_err_stack('pa_fp_ci_implement_pkg.create_ci_impact_fund_lines');
100: END IF;
101: END IF;
102: IF p_ci_id IS NULL OR
103: p_partial_factor IS NULL OR

Line 167: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

163: IF l_budget_line_count > 0 THEN --Bug 5509687: Prevent from creating funding lines if there are no impact lines
164:
165: IF l_debug_mode = 'Y' THEN
166: PA_DEBUG.write_log (x_module =>
167: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
168: ,x_msg => 'before getting CW REVENUE budget version id '
169: ,x_log_level => 5);
170: END IF;
171:

Line 194: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

190: END;
191:
192: IF l_debug_mode = 'Y' THEN
193: PA_DEBUG.write_log (x_module =>
194: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
195: ,x_msg => 'after getting CW REVENUE budget version id '||
196: TO_CHAR(l_bv_id)
197: ,x_log_level => 5);
198: END IF;

Line 252: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

248: agreement_id = l_agreement_id;
249:
250: IF l_debug_mode = 'Y' THEN
251: PA_DEBUG.write_log (x_module =>
252: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
253: ,x_msg => 'fund level chk begin '||
254: 'upd agr amt flag from page '||p_update_agr_amount_flag
255: ||' fund cate fr page '||p_funding_category
256: ,x_log_level => 5);

Line 258: => 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

254: 'upd agr amt flag from page '||p_update_agr_amount_flag
255: ||' fund cate fr page '||p_funding_category
256: ,x_log_level => 5);
257: PA_DEBUG.write_log (x_module
258: => 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
259: ,x_msg => 'prj id '||to_char(p_project_id) ||
260: 'ci id '||to_char(p_ci_id)
261: ,x_log_level => 5);
262: END IF;

Line 290: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

286: RETURN;
287: END IF;
288: IF l_debug_mode = 'Y' THEN
289: PA_DEBUG.write_log (x_module =>
290: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
291: ,x_msg => 'funding level '||l_funding_level
292: ,x_log_level => 5);
293: END IF;
294:

Line 302: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

298:
299: /* check for agreement amount update allowed */
300: IF l_debug_mode = 'Y' THEN
301: PA_DEBUG.write_log (x_module =>
302: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
303: ,x_msg => 'total fund amt '||ltrim(to_char(l_total_amount))
304: ,x_log_level => 5);
305: END IF;
306:

Line 329: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

325: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
326:
327: IF l_debug_mode = 'Y' THEN
328: PA_DEBUG.write_log (x_module =>
329: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
330: ,x_msg => 'upd agr allowed flag '||l_upd_agr_allowed
331: ,x_log_level => 5);
332: END IF;
333: IF l_upd_agr_allowed = 'N' THEN

Line 358: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

354: l_new_agr_amount := NVL(l_total_amount,0) + l_agr_amount;
355:
356: IF l_debug_mode = 'Y' THEN
357: PA_DEBUG.write_log (x_module =>
358: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
359: ,x_msg => 'new agr amt '||ltrim(to_char(l_new_agr_amount))
360: ||' Agr ID '||ltrim(to_char(l_agreement_id))
361: ,x_log_level => 5);
362: END IF;

Line 430: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

426: l_tmp_amount := 0;
427: END;
428: IF l_debug_mode = 'Y' THEN
429: PA_DEBUG.write_log (x_module =>
430: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
431: ,x_msg => 'aft upd agr api'||ltrim(to_char(l_tmp_amount))
432: ,x_log_level => 5);
433: END IF;
434:

Line 450: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

446: p_pm_funding_reference => NULL );
447:
448: IF l_debug_mode = 'Y' THEN
449: PA_DEBUG.write_log (x_module =>
450: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
451: ,x_msg => 'aft valid fund amt api call '||l_valid_funding_amt_flag
452: ,x_log_level => 5);
453: END IF;
454:

Line 492: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

488: l_amount_tab_in_pc(1) := l_total_proj_revenue;
489: l_task_id_tab(1) := NULL;
490: IF l_debug_mode = 'Y' THEN
491: PA_DEBUG.write_log (x_module =>
492: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
493: ,x_msg => 'inside fund : ci level PP PT'
494: ,x_log_level => 5);
495: END IF;
496:

Line 502: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

498: ELSIF l_ci_ver_planning_level = 'T' AND
499: l_funding_level = 'T' THEN
500: IF l_debug_mode = 'Y' THEN
501: PA_DEBUG.write_log (x_module =>
502: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
503: ,x_msg => 'inside fund : ci level TT'
504: ,x_log_level => 5);
505: END IF;
506: BEGIN

Line 666: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

662: p_calling_context => 'CI');
663:
664: IF l_debug_mode = 'Y' THEN
665: PA_DEBUG.write_log (x_module =>
666: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
667: ,x_msg => 'chk for add fund ok '||
668: ltrim(to_char(nvl(l_task_id_tab(i),-1)))
669: || ' amt '||to_char(l_amount_tab(i)) ||
670: ' flag '|| l_add_funding_ok_flag

Line 694: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

690: END IF;
691:
692: IF l_debug_mode = 'Y' THEN
693: PA_DEBUG.write_log (x_module =>
694: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
695: ,x_msg => 'bef create_funding api call'
696: ,x_log_level => 5);
697: END IF;
698:

Line 759: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

755: p_funding_category => p_funding_category );
756:
757: IF l_debug_mode = 'Y' THEN
758: PA_DEBUG.write_log (x_module =>
759: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
760: ,x_msg => 'aft create_funding api call ret code '||
761: to_char(l_err_code)
762: ,x_log_level => 5);
763: END IF;

Line 795: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

791: p_user_id => LTRIM(RTRIM(TO_CHAR(l_last_updated_by)))
792: );
793: IF l_debug_mode = 'Y' THEN
794: PA_DEBUG.write_log (x_module =>
795: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
796: ,x_msg => 'aft calling summary fund ins API '
797: ,x_log_level => 5);
798: END IF;
799: END LOOP;

Line 817: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'

813: );
814:
815: IF l_debug_mode = 'Y' THEN
816: PA_DEBUG.write_log (x_module =>
817: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
818: ,x_msg => 'aft calling link api : ret status '||
819: x_return_status
820: ,x_log_level => 5);
821: END IF;

Line 844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CI_IMPLEMENT_PKG',

840: PA_DEBUG.Reset_Err_Stack;
841: END IF;
842:
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CI_IMPLEMENT_PKG',
845: p_procedure_name => 'CREATE_CI_IMPACT_FUND_LINES',
846: p_error_text => SUBSTRB(SQLERRM,1,240));
847:
848: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1020: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CI_IMPLEMENT_PKG',

1016: EXCEPTION
1017: WHEN OTHERS THEN
1018:
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CI_IMPLEMENT_PKG',
1021: p_procedure_name => 'CHK_PLAN_VER_FOR_MERGE',
1022: p_error_text => SUBSTRB(SQLERRM,1,240));
1023:
1024: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1029: END pa_fp_ci_implement_pkg;

1025: p_data => x_msg_data);
1026:
1027: END chk_plan_ver_for_merge;
1028:
1029: END pa_fp_ci_implement_pkg;