[Home] [Help]
8461:
8462: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ'
8463: ,'TRXIMPORT','RESERVE_BASELINE') then
8464:
8465: -- Note: For commitment Funds check, derive_rlmi is called in pa_funds_control_pkg1
8466: -- R12: BC-SLA Integration ..
8467:
8468: IF g_debug_mode = 'Y' THEN
8469: log_message(p_msg_token1 => 'inside the fundscheck setup api Calling Derive_rlmi ');
8882: /* ========================================================================================+
8883: Following code is incorrect ..not required.
8884: -- If p_mode is 'B' and 'S', use the period_name stamped on the txn. being funds checked
8885: -- to get the start and end date
8886: -- In normal FC mode, call pa_funds_control_pkg1.setup_start_end_date to derive dates
8887: log_message(p_msg_token1 =>'Mode ['||p_mode||'] Period name['||g_tab_period_name(i)||']');
8888:
8889: If p_mode in ('B','S') then -- Mode check
8890: Begin
8919: trunc(l_trx_item_date) NOT BETWEEN l_pre_fc_sdate AND l_pre_fc_edate) OR
8920: (to_char(nvl(l_pre_ei_date,g_tab_exp_item_date(i)),'YYYY')<>to_char(g_tab_exp_item_date(i),'YYYY') AND g_tab_exp_item_date(i) is not NULL ) /*Bug 8562406 */
8921: THEN -- call date API
8922: If g_debug_mode = 'Y' THEN
8923: log_message(p_msg_token1 => 'Calling pa_funds_control_pkg1.setup_start_end_date API');
8924: End if;
8925:
8926: /*PAM changes derive start and end dates */
8927: pa_funds_control_pkg1.setup_start_end_date (
8923: log_message(p_msg_token1 => 'Calling pa_funds_control_pkg1.setup_start_end_date API');
8924: End if;
8925:
8926: /*PAM changes derive start and end dates */
8927: pa_funds_control_pkg1.setup_start_end_date (
8928: p_packet_id => p_packet_id
8929: ,p_bc_packet_id => g_tab_bc_packet_id(i)
8930: ,p_project_id => g_tab_project_id(i)
8931: ,p_budget_version_id => g_tab_budget_version_id(i)
12141: If g_debug_mode = 'Y' then
12142: log_message(p_stage => 10,p_msg_token1 => 'For CBC calling copy_gl_pkt_to_pa_pkt in mode ='||l_mode);
12143: end if;
12144:
12145: -- PA_FUNDS_CONTROL_PKG1.copy_gl_pkt_to_pa_pkt
12146: -- (p_packet_id => l_packet_id
12147: -- ,p_calling_module => p_calling_module
12148: -- ,p_return_code => l_return_status
12149: -- ,p_reference1 => p_reference1
12315: If l_mode in ('U') and p_calling_module in ('GL','CBC') then
12316: If g_debug_mode = 'Y' then
12317: log_message(p_msg_token1 => ' calling create_unrsvd_lines api');
12318: end if;
12319: If NOT PA_FUNDS_CONTROL_PKG1.create_unrsvd_lines
12320: ( x_packet_id => l_packet_id
12321: ,p_mode => l_mode
12322: ,p_calling_module => p_calling_module
12323: ,p_reference1 => p_reference1
12385: If g_debug_mode = 'Y' then
12386: log_message(p_msg_token1 => 'calling populate plsql tabs api');
12387: end if;
12388:
12389: PA_FUNDS_CONTROL_PKG1.populate_plsql_tabs_CBC
12390: (p_packet_id => l_packet_id
12391: ,p_calling_module => p_calling_module
12392: ,p_reference1 => p_reference1
12393: ,p_reference2 => p_reference2
12459: END IF;
12460:
12461: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ','TRXIMPORT') then
12462:
12463: -- Note: For commitment Funds check, populate_burden_cost is called in pa_funds_control_pkg1
12464: -- R12: BC-SLA Integration ..
12465:
12466: -----------------------------------------------------------------------------------------------------
12467: -- Populate the Burden cost for each record in packet if project type is of burden on same EI
12472: If g_debug_mode = 'Y' then
12473: log_message(p_stage => 50,p_msg_token1 => p_calling_module||':Calling Populate_burden_cost API');
12474: end if;
12475:
12476: PA_FUNDS_CONTROL_PKG1.Populate_burden_cost
12477: (p_packet_id => l_packet_id
12478: ,p_calling_module => p_calling_module
12479: ,x_return_status => l_return_status
12480: ,x_err_msg_code => l_err_msg_code);
12479: ,x_return_status => l_return_status
12480: ,x_err_msg_code => l_err_msg_code);
12481:
12482: If g_debug_mode = 'Y' then
12483: log_message(p_msg_token1 => 'After calling PA_FUNDS_CONTROL_PKG1.Populate_burden_cost api');
12484: end if;
12485:
12486: IF l_return_status <> 'S' then
12487: If g_debug_mode = 'Y' then
13556:
13557: /* PAM changes */
13558: If p_calling_module = 'GL' Then
13559: -- update the cwk attributes for the passed transactions
13560: pa_funds_control_pkg1.upd_cwk_attributes
13561: (p_calling_module => p_calling_module
13562: ,p_packet_id => l_packet_id
13563: ,p_mode => l_mode
13564: ,p_reference => 'UPD_AMTS'
13565: ,x_return_status => l_return_status
13566: );
13567:
13568: -- update the cwk compiled_multiplier
13569: pa_funds_control_pkg1.upd_cwk_attributes(
13570: p_calling_module => p_calling_module
13571: ,p_packet_id => l_packet_id
13572: ,p_mode => l_mode
13573: ,p_reference => 'UPD_MULTIPLIER'
13788: /* PAM changes */
13789: If p_calling_module in ('DISTCWKST') Then
13790: log_message(p_msg_token1 => 'Calling upd_cwk_attributes API');
13791: -- update the cwk attributes for the passed transactions
13792: pa_funds_control_pkg1.upd_cwk_attributes
13793: (p_calling_module => p_calling_module
13794: ,p_packet_id => l_packet_id
13795: ,p_mode => l_mode
13796: ,p_reference => 'UPD_AMTS'