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_FUNDS_CONTROL_PKG dependencies on PA_BUDGET_FUND_PKG

Line 7240: if pa_budget_fund_pkg.Is_bdgt_intg_enabled(p_project_id => p_project_id, p_mode => p_mode) then

7236: IF g_debug_mode = 'Y' THEN
7237: log_message(p_msg_token1 =>'selecting gl date');
7238: End if;
7239:
7240: if pa_budget_fund_pkg.Is_bdgt_intg_enabled(p_project_id => p_project_id, p_mode => p_mode) then
7241:
7242: SELECT gl.end_date,
7243: gl.start_date
7244: INTO l_gl_date,l_gl_start_date

Line 10415: log_message(p_msg_token1 => 'calling pa_budget_fund_pkg.UPD_BDGT_ACCT_BAL api ');

10411: log_message(p_msg_token1 => 'Calling UPD_BDGT_ACCT_BAL api in Loop');
10412: FOR i IN g_tab_budget_ccid.FIRST .. g_tab_budget_ccid.LAST LOOP
10413: l_bdgt_acct_amt := (nvl(g_tab_accounted_dr(i),0) - nvl(g_tab_accounted_cr(i),0));
10414: IF g_debug_mode = 'Y' THEN
10415: log_message(p_msg_token1 => 'calling pa_budget_fund_pkg.UPD_BDGT_ACCT_BAL api ');
10416: l_debug_stage := 'p_gl_period_name ['||g_tab_period_name(i)||']p_budget_version_id [';
10417: l_debug_stage := l_debug_stage||g_tab_budget_version_id(i)||']p_ccid [';
10418: l_debug_stage := l_debug_stage||g_tab_budget_ccid(i)||']p_amount [';
10419: l_debug_stage := l_debug_stage||l_bdgt_acct_amt||']' ;

Line 10423: pa_budget_fund_pkg.UPD_BDGT_ACCT_BAL

10419: l_debug_stage := l_debug_stage||l_bdgt_acct_amt||']' ;
10420: log_message(p_msg_token1 => l_debug_stage);
10421: End if;
10422: If NVL(l_bdgt_acct_amt,0) <> 0 Then
10423: pa_budget_fund_pkg.UPD_BDGT_ACCT_BAL
10424: (p_gl_period_name => g_tab_period_name(i),
10425: p_budget_version_id => g_tab_budget_version_id(i),
10426: p_ccid => g_tab_budget_ccid(i),
10427: p_amount => l_bdgt_acct_amt,

Line 14582: If nvl(pa_budget_fund_pkg.g_processing_mode,'FC') in ('YEAR_END','BASELINE','CHECK_FUNDS') then

14578: When no_data_found then
14579:
14580: -- Is it a budget baseline /year-end/budget check funds related FC call ..
14581:
14582: If nvl(pa_budget_fund_pkg.g_processing_mode,'FC') in ('YEAR_END','BASELINE','CHECK_FUNDS') then
14583:
14584: p_return_code := 'BUD_FC';
14585:
14586: Else

Line 14825: If (pa_budget_fund_pkg.g_processing_mode in ('BASELINE','CHECK_FUNDS') and pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') then

14821: If g_debug_mode = 'Y' then
14822: log_message(p_msg_token1=>'Any_txns_against_project:p_project_id:'||p_project_id);
14823: End If;
14824:
14825: If (pa_budget_fund_pkg.g_processing_mode in ('BASELINE','CHECK_FUNDS') and pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') then
14826:
14827: If g_debug_mode = 'Y' then
14828: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_packets');
14829: End If;

Line 15060: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_current_bvid

15056: where exists (Select 1
15057: from gl_bc_packets glbc,
15058: pa_budget_lines pbl
15059: where glbc.packet_id = p_packet_id
15060: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_current_bvid
15061: and pbl.budget_line_id = glbc.source_distribution_id_num_1);
15062:
15063: Exception
15064: When no_data_found then

Line 15099: l_current_budget_version_id := pa_budget_fund_pkg.g_cost_current_bvid;

15095: -- 1.2: initalize limit var. used for bulk ..
15096: l_limit := 500;
15097:
15098: -- 1.3: Get latest budget version being baselined
15099: l_current_budget_version_id := pa_budget_fund_pkg.g_cost_current_bvid;
15100:
15101: -- 1.4: Get draft version ...
15102: -- This is required to udpate the account summary table (we will be updating acct.
15103: -- summary table for the draft version, except for 'Year end' where we will be updating

Line 15110: --If (pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') then

15106: If g_debug_mode = 'Y' then
15107: log_message(p_msg_token1=>l_program_name||'Get Draft Budget');
15108: End If;
15109:
15110: --If (pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') then
15111: If pa_budget_fund_pkg.g_processing_mode in ('YEAR_END','BASELINE') then
15112:
15113: -- Get the draft or working budget ..
15114:

Line 15111: If pa_budget_fund_pkg.g_processing_mode in ('YEAR_END','BASELINE') then

15107: log_message(p_msg_token1=>l_program_name||'Get Draft Budget');
15108: End If;
15109:
15110: --If (pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') then
15111: If pa_budget_fund_pkg.g_processing_mode in ('YEAR_END','BASELINE') then
15112:
15113: -- Get the draft or working budget ..
15114:
15115: Select pbv.budget_version_id

Line 15122: and pbv.budget_status_code = decode(pa_budget_fund_pkg.g_processing_mode,

15118: where (pbv.project_id,pbv.budget_type_code) in
15119: (select project_id,budget_type_code
15120: from pa_budget_versions
15121: where budget_version_id = l_current_budget_version_id)
15122: and pbv.budget_status_code = decode(pa_budget_fund_pkg.g_processing_mode,
15123: 'YEAR_END','W','S');
15124:
15125: If g_debug_mode = 'Y' then
15126: log_message(p_msg_token1=>l_program_name||'Yr End/Base Draft Budget:'||l_draft_budget_version_id);

Line 15134: If pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS' then

15130:
15131: -- End If;
15132:
15133:
15134: If pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS' then
15135:
15136: l_draft_budget_version_id := l_current_budget_version_id;
15137:
15138: If g_debug_mode = 'Y' then

Line 15145: If (pa_budget_fund_pkg.g_balance_type = 'E' /Top Down/ and

15141:
15142: End If;
15143:
15144: -- 1.5: Derive budget entry level code
15145: If (pa_budget_fund_pkg.g_balance_type = 'E' /*Top Down*/ and
15146: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' ) then
15147:
15148: If g_debug_mode = 'Y' then
15149: log_message(p_msg_token1=>l_program_name||'Get Budget Entry Method');

Line 15146: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' ) then

15142: End If;
15143:
15144: -- 1.5: Derive budget entry level code
15145: If (pa_budget_fund_pkg.g_balance_type = 'E' /*Top Down*/ and
15146: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' ) then
15147:
15148: If g_debug_mode = 'Y' then
15149: log_message(p_msg_token1=>l_program_name||'Get Budget Entry Method');
15150: End If;

Line 15162: log_message(p_msg_token1=>l_program_name||':g_processing_mode:'||pa_budget_fund_pkg.g_processing_mode||

15158:
15159: End If;
15160:
15161: If g_debug_mode = 'Y' then
15162: log_message(p_msg_token1=>l_program_name||':g_processing_mode:'||pa_budget_fund_pkg.g_processing_mode||
15163: ':Balance type:'||pa_budget_fund_pkg.g_balance_type||
15164: ':Budget Amount Code:'||pa_budget_fund_pkg.g_budget_amount_code||
15165: ':Rebaseline Flag:'||pa_budget_fund_pkg.g_cost_rebaseline_flag);
15166:

Line 15163: ':Balance type:'||pa_budget_fund_pkg.g_balance_type||

15159: End If;
15160:
15161: If g_debug_mode = 'Y' then
15162: log_message(p_msg_token1=>l_program_name||':g_processing_mode:'||pa_budget_fund_pkg.g_processing_mode||
15163: ':Balance type:'||pa_budget_fund_pkg.g_balance_type||
15164: ':Budget Amount Code:'||pa_budget_fund_pkg.g_budget_amount_code||
15165: ':Rebaseline Flag:'||pa_budget_fund_pkg.g_cost_rebaseline_flag);
15166:
15167: log_message(p_msg_token1=>l_program_name||':Current budget version:'||l_current_budget_version_id||

Line 15164: ':Budget Amount Code:'||pa_budget_fund_pkg.g_budget_amount_code||

15160:
15161: If g_debug_mode = 'Y' then
15162: log_message(p_msg_token1=>l_program_name||':g_processing_mode:'||pa_budget_fund_pkg.g_processing_mode||
15163: ':Balance type:'||pa_budget_fund_pkg.g_balance_type||
15164: ':Budget Amount Code:'||pa_budget_fund_pkg.g_budget_amount_code||
15165: ':Rebaseline Flag:'||pa_budget_fund_pkg.g_cost_rebaseline_flag);
15166:
15167: log_message(p_msg_token1=>l_program_name||':Current budget version:'||l_current_budget_version_id||
15168: ':Draft version:'||l_draft_budget_version_id||':budget entry level code:' || l_budget_entry_level_code);

Line 15165: ':Rebaseline Flag:'||pa_budget_fund_pkg.g_cost_rebaseline_flag);

15161: If g_debug_mode = 'Y' then
15162: log_message(p_msg_token1=>l_program_name||':g_processing_mode:'||pa_budget_fund_pkg.g_processing_mode||
15163: ':Balance type:'||pa_budget_fund_pkg.g_balance_type||
15164: ':Budget Amount Code:'||pa_budget_fund_pkg.g_budget_amount_code||
15165: ':Rebaseline Flag:'||pa_budget_fund_pkg.g_cost_rebaseline_flag);
15166:
15167: log_message(p_msg_token1=>l_program_name||':Current budget version:'||l_current_budget_version_id||
15168: ':Draft version:'||l_draft_budget_version_id||':budget entry level code:' || l_budget_entry_level_code);
15169: End If;

Line 15179: --If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') or

15175: -- existing status ... if there is any failure ..
15176: -- 8/22/06: This step should be carried out for CF/baseline/rebaseline for E/B balance_type
15177: -- Failures can happen for first time baseline and also for bottom up budgets too
15178:
15179: --If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') or
15180: --(pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15183: --then

Line 15180: --(pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down

15176: -- 8/22/06: This step should be carried out for CF/baseline/rebaseline for E/B balance_type
15177: -- Failures can happen for first time baseline and also for bottom up budgets too
15178:
15179: --If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') or
15180: --(pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15183: --then
15184:

Line 15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing

15177: -- Failures can happen for first time baseline and also for bottom up budgets too
15178:
15179: --If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') or
15180: --(pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15183: --then
15184:
15185: If (pa_budget_fund_pkg.g_processing_mode in ('CHECK_FUNDS','BASELINE')) then

Line 15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')

15178:
15179: --If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') or
15180: --(pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15183: --then
15184:
15185: If (pa_budget_fund_pkg.g_processing_mode in ('CHECK_FUNDS','BASELINE')) then
15186:

Line 15185: If (pa_budget_fund_pkg.g_processing_mode in ('CHECK_FUNDS','BASELINE')) then

15181: -- pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15182: -- pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15183: --then
15184:
15185: If (pa_budget_fund_pkg.g_processing_mode in ('CHECK_FUNDS','BASELINE')) then
15186:
15187: If g_debug_mode = 'Y' then
15188: --log_message(p_msg_token1=>l_program_name||'Nullify failure status from draft version - Check funds');
15189: log_message(p_msg_token1=>l_program_name||' Rebuild Draft summary');

Line 15198: x_balance_type =>pa_budget_fund_pkg.g_balance_type,

15194: End If;
15195:
15196: --RESET_STATUS_CODE_ON_SUMMARY(l_draft_budget_version_id);
15197: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
15198: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
15199: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
15200: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
15201: x_mode=>'PASS');
15202: If g_debug_mode = 'Y' then

Line 15199: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,

15195:
15196: --RESET_STATUS_CODE_ON_SUMMARY(l_draft_budget_version_id);
15197: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
15198: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
15199: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
15200: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
15201: x_mode=>'PASS');
15202: If g_debug_mode = 'Y' then
15203: log_message(p_msg_token1=>l_program_name||'After BUILD_ACCOUNT_SUMMARY_AUTO call');

Line 15200: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,

15196: --RESET_STATUS_CODE_ON_SUMMARY(l_draft_budget_version_id);
15197: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
15198: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
15199: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
15200: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
15201: x_mode=>'PASS');
15202: If g_debug_mode = 'Y' then
15203: log_message(p_msg_token1=>l_program_name||'After BUILD_ACCOUNT_SUMMARY_AUTO call');
15204: End If;

Line 15233: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down

15229: l_txn_exists_bc_pkt_flag := 'N';
15230: l_txn_exists_bc_cmt_flag := 'N';
15231:
15232: -- 8/22: This should fire for re-baseline/top-down only ..
15233: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15234: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') --and -- Re-costing
15235: --pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15236: then
15237:

Line 15234: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') --and -- Re-costing

15230: l_txn_exists_bc_cmt_flag := 'N';
15231:
15232: -- 8/22: This should fire for re-baseline/top-down only ..
15233: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15234: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') --and -- Re-costing
15235: --pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15236: then
15237:
15238: If g_debug_mode = 'Y' then

Line 15235: --pa_budget_fund_pkg.g_processing_mode = 'BASELINE')

15231:
15232: -- 8/22: This should fire for re-baseline/top-down only ..
15233: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15234: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y') --and -- Re-costing
15235: --pa_budget_fund_pkg.g_processing_mode = 'BASELINE')
15236: then
15237:
15238: If g_debug_mode = 'Y' then
15239: log_message(p_msg_token1=>l_program_name||'Before ANY_TXNS_AGAINST_PROJECT call');

Line 15264: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down

15260: -- calculated here as during the regular flow the zero $ lines created
15261: -- during baseline are not visible ...
15262: -- Call procedure update_budget_ccid, this has to be autonomous ...
15263: -- ---------------------------------------------------------------------------+
15264: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15265: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15266: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and -- Baseline
15267: l_txn_exists_bc_pkt_flag = 'Y') -- Txn. exists against the project
15268: then -- (2.0 Main If)

Line 15265: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing

15261: -- during baseline are not visible ...
15262: -- Call procedure update_budget_ccid, this has to be autonomous ...
15263: -- ---------------------------------------------------------------------------+
15264: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15265: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15266: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and -- Baseline
15267: l_txn_exists_bc_pkt_flag = 'Y') -- Txn. exists against the project
15268: then -- (2.0 Main If)
15269:

Line 15266: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and -- Baseline

15262: -- Call procedure update_budget_ccid, this has to be autonomous ...
15263: -- ---------------------------------------------------------------------------+
15264: If (pa_budget_fund_pkg.g_balance_type = 'E' and -- Top Down
15265: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and -- Re-costing
15266: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and -- Baseline
15267: l_txn_exists_bc_pkt_flag = 'Y') -- Txn. exists against the project
15268: then -- (2.0 Main If)
15269:
15270: -- Get set of books

Line 15384: If (pa_budget_fund_pkg.g_balance_type = 'E' and

15380: log_message(p_msg_token1=>l_program_name||': GL failed case exists');
15381: End If;
15382: -- ----------------------------------------------------------------------------------+
15383:
15384: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15385: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15386: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15387: l_txn_exists_bc_pkt_flag = 'Y') then
15388: -- ----------------------------------------------------------------------------------+

Line 15385: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and

15381: End If;
15382: -- ----------------------------------------------------------------------------------+
15383:
15384: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15385: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15386: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15387: l_txn_exists_bc_pkt_flag = 'Y') then
15388: -- ----------------------------------------------------------------------------------+
15389: -- ## Fail pa_bc_packets:

Line 15386: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15382: -- ----------------------------------------------------------------------------------+
15383:
15384: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15385: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15386: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15387: l_txn_exists_bc_pkt_flag = 'Y') then
15388: -- ----------------------------------------------------------------------------------+
15389: -- ## Fail pa_bc_packets:
15390: If g_debug_mode = 'Y' then

Line 15415: If pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS' then

15411: -- ----------------------------------------------------------------------------------+
15412: -- Update Draft version (account summary table) to failure ..
15413: -- Note: in case of 'Year End' the working budget will be updated ..
15414:
15415: If pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS' then
15416: l_result_code := 'F150';
15417: Else
15418: l_result_code := 'F155';
15419: End If;

Line 15426: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then

15422: -- so, we need to derive the account that exists on the draft version ..
15423: -- else issue was that baseline had acct A2 and draft had A1 and then the call
15424: -- to UPDATE_FAILURE_IN_ACCT_SUMMARY would not udpate any records ...
15425:
15426: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then
15427:
15428: If g_debug_mode = 'Y' then
15429: log_message(p_msg_token1=>l_program_name||': Derive draft ccid');
15430: End If;

Line 15463: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then

15459: -- ----------------------------------------------------------------------------------+
15460: -- Following if condition is required as t_draft_ccid is calcualted for non-CF mode only ...
15461: -- as for CF mode, t_bud_ccid is the draft ccid ...
15462: -- ----------------------------------------------------------------------------------+
15463: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then
15464:
15465: If g_debug_mode = 'Y' then
15466: log_message(p_msg_token1=>l_program_name||': <> CF, Calling Update_failure_in_acct_summary');
15467: End If;

Line 15516: If (pa_budget_fund_pkg.g_balance_type = 'E' and

15512: End Loop;
15513:
15514: close c_gl_failure;
15515: -- -------------------------------------------------------------------------------------------------------+
15516: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15517: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15518: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15519: p_return_status = 'F' and
15520: l_txn_exists_bc_pkt_flag = 'Y') then

Line 15517: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and

15513:
15514: close c_gl_failure;
15515: -- -------------------------------------------------------------------------------------------------------+
15516: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15517: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15518: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15519: p_return_status = 'F' and
15520: l_txn_exists_bc_pkt_flag = 'Y') then
15521:

Line 15518: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15514: close c_gl_failure;
15515: -- -------------------------------------------------------------------------------------------------------+
15516: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15517: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15518: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15519: p_return_status = 'F' and
15520: l_txn_exists_bc_pkt_flag = 'Y') then
15521:
15522: If g_debug_mode = 'Y' then

Line 15558: If (--pa_budget_fund_pkg.g_balance_type = 'E' /Top Down/ and

15554: -- Note: We however have to synch data for all modes and all budget types ..
15555: -- ---------------------------------------------------------------------------+
15556:
15557:
15558: If (--pa_budget_fund_pkg.g_balance_type = 'E' /*Top Down*/ and
15559: --pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15560: p_return_status = 'S' ) then -- I
15561:
15562: If g_debug_mode = 'Y' then

Line 15559: --pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15555: -- ---------------------------------------------------------------------------+
15556:
15557:
15558: If (--pa_budget_fund_pkg.g_balance_type = 'E' /*Top Down*/ and
15559: --pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15560: p_return_status = 'S' ) then -- I
15561:
15562: If g_debug_mode = 'Y' then
15563: log_message(p_msg_token1=>l_program_name||':Executing account validation');

Line 15615: If (pa_budget_fund_pkg.g_balance_type = 'E' and

15611:
15612: -- ----------------------------------------------------------------------------------+
15613: -- ## B. Get prev. version budget ccid
15614: -- ----------------------------------------------------------------------------------+
15615: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15616: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15617: (l_txn_exists_bc_pkt_flag ='Y' OR l_txn_exists_bc_cmt_flag = 'Y'))
15618: then -- B
15619:

Line 15616: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15612: -- ----------------------------------------------------------------------------------+
15613: -- ## B. Get prev. version budget ccid
15614: -- ----------------------------------------------------------------------------------+
15615: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15616: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15617: (l_txn_exists_bc_pkt_flag ='Y' OR l_txn_exists_bc_cmt_flag = 'Y'))
15618: then -- B
15619:
15620: If g_debug_mode = 'Y' then

Line 15649: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid

15645: from pa_budget_lines pbl,
15646: pa_resource_assignments pra
15647: where pbl.start_date = t_budget_start_date(x)
15648: and pbl.txn_currency_code = t_txn_currency_code(x)
15649: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid
15650: and pbl.budget_version_id = pra.budget_version_id
15651: and pbl.resource_assignment_id = pra.resource_assignment_id
15652: and pra.project_id = t_project_id(x)
15653: and (pra.task_id = t_task_id(x) OR

Line 15679: If (pa_budget_fund_pkg.g_balance_type = 'E' and

15675:
15676: -- ----------------------------------------------------------------------------------+
15677: -- ## C. Call API for validation (if account change allowed)
15678: -- ----------------------------------------------------------------------------------+
15679: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15680: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15681: (l_txn_exists_bc_pkt_flag ='Y' OR l_txn_exists_bc_cmt_flag = 'Y')
15682: )
15683: then -- API If

Line 15680: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15676: -- ----------------------------------------------------------------------------------+
15677: -- ## C. Call API for validation (if account change allowed)
15678: -- ----------------------------------------------------------------------------------+
15679: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15680: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15681: (l_txn_exists_bc_pkt_flag ='Y' OR l_txn_exists_bc_cmt_flag = 'Y')
15682: )
15683: then -- API If
15684: -- ----------------------------------------------------------------------------------------------------+

Line 15700: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then

15696: end loop;
15697: End If;
15698: -- ----------------------------------------------------------------------------------------------------+
15699:
15700: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then
15701: l_bvid_for_acct_changed_API := l_current_budget_version_id;
15702: Else
15703: l_bvid_for_acct_changed_API := pa_budget_fund_pkg.g_cost_prev_bvid;
15704: End if;

Line 15703: l_bvid_for_acct_changed_API := pa_budget_fund_pkg.g_cost_prev_bvid;

15699:
15700: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then
15701: l_bvid_for_acct_changed_API := l_current_budget_version_id;
15702: Else
15703: l_bvid_for_acct_changed_API := pa_budget_fund_pkg.g_cost_prev_bvid;
15704: End if;
15705:
15706: If g_debug_mode = 'Y' then
15707: log_message(p_msg_token1=>l_program_name||': For acct. change API, bvid being used:'

Line 15775: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then -- CF

15771: If g_debug_mode = 'Y' then
15772: log_message(p_msg_token1=>l_program_name||': Derive draft rowid and draft ccid');
15773: End If;
15774:
15775: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then -- CF
15776: for x in t_project_id.FIRST..t_project_id.LAST
15777: loop
15778:
15779: -- If draft needs update then we need to get the draft rowid for updating

Line 15850: If (pa_budget_fund_pkg.g_balance_type = 'E' and

15846: If g_debug_mode = 'Y' then
15847: log_message(p_msg_token1=>l_program_name||SQL%ROWCOUNT||' GL line updated');
15848: End If;
15849:
15850: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15851: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15852: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15853: l_txn_exists_bc_pkt_flag = 'Y') then
15854:

Line 15851: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and

15847: log_message(p_msg_token1=>l_program_name||SQL%ROWCOUNT||' GL line updated');
15848: End If;
15849:
15850: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15851: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15852: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15853: l_txn_exists_bc_pkt_flag = 'Y') then
15854:
15855: -- ----------------------------------------------------------------------------------+

Line 15852: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

15848: End If;
15849:
15850: If (pa_budget_fund_pkg.g_balance_type = 'E' and
15851: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
15852: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
15853: l_txn_exists_bc_pkt_flag = 'Y') then
15854:
15855: -- ----------------------------------------------------------------------------------+
15856: -- ## Fail pa_bc_packets:

Line 15883: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then

15879: -- Note: in case of 'Year End' the working budget will be updated ..
15880: -- ----------------------------------------------------------------------------------+
15881: -- Following if condition being used as for = 'CF' ..t_draft_ccid is not calculated ..
15882:
15883: If pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' then
15884:
15885: -- -------------------------------------------------------------------------------------------------+
15886: If g_debug_mode = 'Y' then
15887: log_message(p_msg_token1=>l_program_name||': Upd acct. summ - <> CF:l_draft_budget_version_id['

Line 15946: If (l_validation_failed = 'N' or pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then

15942: End If;
15943: -- --------------------------------------------------------------------------------+
15944: If l_acct_changed = 'Y' then
15945:
15946: If (l_validation_failed = 'N' or pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then
15947: -- update budget lines only if there is no failure
15948: -- reason: because if there is any failure, baseline/yearend/checkfunds fails ..
15949: -- and a rollback is issued for the 1st 2 ..
15950: -- However for CF, we will update the account change for the records

Line 15964: If (sql%rowcount > 0 and pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then

15960: where pbl.rowid = t_budget_rowid(x)
15961: and t_bud_ccid(x) <> t_ccid(x)
15962: and g_tab_allow_flag(x) = 'Y';
15963:
15964: If (sql%rowcount > 0 and pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then
15965: l_draft_acct_changed_flag := 'Y';
15966: End If;
15967:
15968: If g_debug_mode = 'Y' then

Line 15975: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS') then

15971: End If;
15972:
15973: End If; -- If l_validation_failed = 'N' then
15974:
15975: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS') then
15976:
15977: -- We also need to update the draft version account information ..atleast for the ones
15978: -- where account change is allowed .. AUTONOMOUS Update ..
15979:

Line 16057: If (pa_budget_fund_pkg.g_balance_type = 'E' and

16053:
16054: End If; -- I , Top-Down Check, re-baseline
16055:
16056: -- --------------------------------------------------------------------------+
16057: If (pa_budget_fund_pkg.g_balance_type = 'E' and
16058: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
16059: p_return_status = 'F' and
16060: l_txn_exists_bc_pkt_flag = 'Y') then
16061:

Line 16058: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and

16054: End If; -- I , Top-Down Check, re-baseline
16055:
16056: -- --------------------------------------------------------------------------+
16057: If (pa_budget_fund_pkg.g_balance_type = 'E' and
16058: pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
16059: p_return_status = 'F' and
16060: l_txn_exists_bc_pkt_flag = 'Y') then
16061:
16062: If g_debug_mode = 'Y' then

Line 16095: x_balance_type =>pa_budget_fund_pkg.g_balance_type,

16091: log_message(p_msg_token1=>l_program_name||': Failure case - Rebuild draft acct. sumamry');
16092: End If;
16093:
16094: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16095: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16096: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16097: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16098: x_mode=>'FAIL');
16099: End If;

Line 16096: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,

16092: End If;
16093:
16094: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16095: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16096: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16097: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16098: x_mode=>'FAIL');
16099: End If;
16100: -- ------------------------- END STEP 4 --------------------------------------+

Line 16097: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,

16093:
16094: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16095: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16096: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16097: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16098: x_mode=>'FAIL');
16099: End If;
16100: -- ------------------------- END STEP 4 --------------------------------------+
16101:

Line 16107: log_message(p_msg_token1=>l_program_name||':Processing Mode:'||pa_budget_fund_pkg.g_processing_mode);

16103: -- ------------------------------------------------------------------------+
16104: -- 5.0: Build account summary for the current version ..
16105: -- ------------------------------------------------------------------------+
16106: If g_debug_mode = 'Y' then
16107: log_message(p_msg_token1=>l_program_name||':Processing Mode:'||pa_budget_fund_pkg.g_processing_mode);
16108: log_message(p_msg_token1=>l_program_name||':Build account summary for the current version');
16109: End If;
16110:
16111: -- ACCOUNT SUMMARY SHOULD ALWAYS BE GENERATED .. CASE WHERE USER MANUALLY UPDATED

Line 16115: p_balance_type =>pa_budget_fund_pkg.g_balance_type,

16111: -- ACCOUNT SUMMARY SHOULD ALWAYS BE GENERATED .. CASE WHERE USER MANUALLY UPDATED
16112: -- ACCOUNT, IN THIS CASE, ACCT. SUMMARY IS DIFF. THAN ACTUAL SUMMARY
16113:
16114: BUILD_ACCOUNT_SUMMARY(p_budget_version_id => l_current_budget_version_id,
16115: p_balance_type =>pa_budget_fund_pkg.g_balance_type,
16116: p_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16117: p_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid);
16118:
16119: If g_debug_mode = 'Y' then

Line 16116: p_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,

16112: -- ACCOUNT, IN THIS CASE, ACCT. SUMMARY IS DIFF. THAN ACTUAL SUMMARY
16113:
16114: BUILD_ACCOUNT_SUMMARY(p_budget_version_id => l_current_budget_version_id,
16115: p_balance_type =>pa_budget_fund_pkg.g_balance_type,
16116: p_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16117: p_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid);
16118:
16119: If g_debug_mode = 'Y' then
16120: log_message(p_msg_token1=>l_program_name||': Done building account summary for the current version');

Line 16117: p_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid);

16113:
16114: BUILD_ACCOUNT_SUMMARY(p_budget_version_id => l_current_budget_version_id,
16115: p_balance_type =>pa_budget_fund_pkg.g_balance_type,
16116: p_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16117: p_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid);
16118:
16119: If g_debug_mode = 'Y' then
16120: log_message(p_msg_token1=>l_program_name||': Done building account summary for the current version');
16121: End If;

Line 16126: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and l_draft_acct_changed_flag = 'Y')

16122: -- ------------------------- END STEP 5 -----------------------------------+
16123: -- 6.0: Build account summary for the draf version .. <> CF mode ..
16124: -- 'Cause in CF mode, we build for the draft version :)
16125: -- ------------------------------------------------------------------------+
16126: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and l_draft_acct_changed_flag = 'Y')
16127: then
16128:
16129: If g_debug_mode = 'Y' then
16130: log_message(p_msg_token1=>l_program_name||':Build account summary for the draft version');

Line 16134: x_balance_type =>pa_budget_fund_pkg.g_balance_type,

16130: log_message(p_msg_token1=>l_program_name||':Build account summary for the draft version');
16131: End If;
16132:
16133: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16134: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16135: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16136: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16137: x_mode=>'PASS');
16138:

Line 16135: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,

16131: End If;
16132:
16133: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16134: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16135: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16136: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16137: x_mode=>'PASS');
16138:
16139: If g_debug_mode = 'Y' then

Line 16136: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,

16132:
16133: BUILD_ACCOUNT_SUMMARY_AUTO(x_budget_version_id => l_draft_budget_version_id,
16134: x_balance_type =>pa_budget_fund_pkg.g_balance_type,
16135: x_budget_amount_code=> pa_budget_fund_pkg.g_budget_amount_code,
16136: x_prev_budget_version_id=>pa_budget_fund_pkg.g_cost_prev_bvid,
16137: x_mode=>'PASS');
16138:
16139: If g_debug_mode = 'Y' then
16140: log_message(p_msg_token1=>l_program_name||': Done building account summary for the draft version');

Line 16150: If (pa_budget_fund_pkg.g_balance_type = 'E' and

16146: -- 7.0: Top Down (but not "Year-End") and re-baseline, carry out
16147: -- "Account level" FC
16148: -- ------------------------------------------------------------------------+
16149:
16150: If (pa_budget_fund_pkg.g_balance_type = 'E' and
16151: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
16152: pa_budget_fund_pkg.g_processing_mode = 'BASELINE') then
16153: --l_txn_exists_bc_pkt_flag = 'Y') then
16154:

Line 16151: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and

16147: -- "Account level" FC
16148: -- ------------------------------------------------------------------------+
16149:
16150: If (pa_budget_fund_pkg.g_balance_type = 'E' and
16151: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
16152: pa_budget_fund_pkg.g_processing_mode = 'BASELINE') then
16153: --l_txn_exists_bc_pkt_flag = 'Y') then
16154:
16155: -- Account level FC .. ONLY for BASELINE mode

Line 16152: pa_budget_fund_pkg.g_processing_mode = 'BASELINE') then

16148: -- ------------------------------------------------------------------------+
16149:
16150: If (pa_budget_fund_pkg.g_balance_type = 'E' and
16151: pa_budget_fund_pkg.g_cost_rebaseline_flag = 'Y' and
16152: pa_budget_fund_pkg.g_processing_mode = 'BASELINE') then
16153: --l_txn_exists_bc_pkt_flag = 'Y') then
16154:
16155: -- Account level FC .. ONLY for BASELINE mode
16156:

Line 16277: If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') OR

16273: -- Step 8.1: Update Pass status/result code on current version (CF/Baseline/Yearend)
16274: /* ==============================================================================================+
16275: -- STEP NOT REQUIRED AS acct. summary initialized/build with 'P101' and 'A' ...
16276:
16277: If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') OR
16278: (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and p_return_status = 'S')
16279: ) then
16280:
16281: If g_debug_mode = 'Y' then

Line 16278: (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and p_return_status = 'S')

16274: /* ==============================================================================================+
16275: -- STEP NOT REQUIRED AS acct. summary initialized/build with 'P101' and 'A' ...
16276:
16277: If ((pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') OR
16278: (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and p_return_status = 'S')
16279: ) then
16280:
16281: If g_debug_mode = 'Y' then
16282: log_message(p_msg_token1=>'End:'||l_program_name||'Update Pass status/result code on pa_budget_acct_lines - Current');

Line 16299: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and p_return_status = 'S')

16295: End If;
16296:
16297: -- Step 8.2: Update Pass status/result code on draft version for Baseline/year End mode
16298:
16299: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and p_return_status = 'S')
16300: then
16301:
16302: If g_debug_mode = 'Y' then
16303: log_message(p_msg_token1=>'End:'||l_program_name||'Update Pass status/result code on pa_budget_acct_lines - Draft');

Line 16323: If (pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and

16319:
16320: -- ------------------------- STEP 9 -----------------------------------+
16321: -- Step 9.0: Update project_acct_result_code/result_code on pa_bc_packets
16322:
16323: If (pa_budget_fund_pkg.g_processing_mode = 'BASELINE' and
16324: p_return_status = 'S' and
16325: l_txn_exists_bc_pkt_flag = 'Y') then
16326:
16327: If g_debug_mode = 'Y' then

Line 16339: If (p_return_status = 'F' and pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then

16335:
16336: -- -------------------------- STEP 10 --------------------------------------+
16337: -- Step 10.0: We need to fail all records in case of Check funds/reserve ..
16338:
16339: If (p_return_status = 'F' and pa_budget_fund_pkg.g_processing_mode = 'CHECK_FUNDS') then
16340: -- Filtering reserve_baseline as during baseline if there is a failure everything rolls back ..
16341:
16342: g_packet_debit_processed := 'Y';
16343:

Line 16587: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and

16583: If g_debug_mode = 'Y' then
16584: log_message(p_msg_token1=>l_program_name||':Creating missing records');
16585: End If;
16586:
16587: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and
16588: P_budget_version_id = pa_budget_fund_pkg.g_cost_current_bvid )then
16589:
16590: -- This IF..END IF ..is reqd. as this procedure is called for the draft version
16591: -- during <> 'CF' mode ..to rebuild the acct. sumamry for the draft version

Line 16588: P_budget_version_id = pa_budget_fund_pkg.g_cost_current_bvid )then

16584: log_message(p_msg_token1=>l_program_name||':Creating missing records');
16585: End If;
16586:
16587: If (pa_budget_fund_pkg.g_processing_mode <> 'CHECK_FUNDS' and
16588: P_budget_version_id = pa_budget_fund_pkg.g_cost_current_bvid )then
16589:
16590: -- This IF..END IF ..is reqd. as this procedure is called for the draft version
16591: -- during <> 'CF' mode ..to rebuild the acct. sumamry for the draft version
16592: -- In this case, the else part should fire ..

Line 16939: glbc.status_code = decode(pa_budget_fund_pkg.g_processing_mode,

16935: -- -------------------------------------------------------------------------- +
16936: forall i in t_glrowid.FIRST..t_glrowid.LAST
16937: Update gl_bc_packets glbc
16938: set glbc.result_code = decode(substr(glbc.result_code,1,1),'F',glbc.result_code,'F35'),
16939: glbc.status_code = decode(pa_budget_fund_pkg.g_processing_mode,
16940: 'CHECK_FUNDS','F','R')
16941: where rowid = t_glrowid(i);
16942:
16943: If g_debug_mode = 'Y' then

Line 16952: SET funds_status_code = decode(pa_budget_fund_pkg.g_processing_mode,

16948: -- Fail xla_ae_headers_gt records ...
16949: -- -------------------------------------------------------------------------- +
16950: forall i in t_ae_header_id.FIRST..t_ae_header_id.LAST
16951: UPDATE xla_ae_headers_gt
16952: SET funds_status_code = decode(pa_budget_fund_pkg.g_processing_mode,
16953: 'CHECK_FUNDS','F','R')
16954: WHERE ae_header_id = t_ae_header_id(i)
16955: AND ledger_id = t_ledger_id(i);
16956: