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.5.12020000.2 2012/12/28 07:52:13 nisinha 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 85: l_module_name VARCHAR2(100):='pa_fp_ci_implement_pkg.create_ci_impact_fund_lines';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1032: END pa_fp_ci_implement_pkg;

1028: p_data => x_msg_data);
1029:
1030: END chk_plan_ver_for_merge;
1031:
1032: END pa_fp_ci_implement_pkg;