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_UTILS dependencies on PA_FCK_UTIL

Line 907: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:Inside Get Budget CCID');

903: x_return_status := fnd_api.g_ret_sts_success;
904:
905: IF P_DEBUG_MODE = 'Y' THEN
906: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'Inside Get Budget CCID');
907: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:Inside Get Budget CCID');
908: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:P:T:TT:R:S:B:E = ' || p_project_id || ':' || p_task_id || ':' || p_top_task_id|| ':' || p_res_list_mem_id ||':'|| p_start_date || ':' || p_budget_version_id ||':'|| p_entry_level_code);
909: END IF;
910:
911: select pbl.code_combination_id, pbl.budget_line_id

Line 908: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:P:T:TT:R:S:B:E = ' || p_project_id || ':' || p_task_id || ':' || p_top_task_id|| ':' || p_res_list_mem_id ||':'|| p_start_date || ':' || p_budget_version_id ||':'|| p_entry_level_code);

904:
905: IF P_DEBUG_MODE = 'Y' THEN
906: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'Inside Get Budget CCID');
907: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:Inside Get Budget CCID');
908: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:P:T:TT:R:S:B:E = ' || p_project_id || ':' || p_task_id || ':' || p_top_task_id|| ':' || p_res_list_mem_id ||':'|| p_start_date || ':' || p_budget_version_id ||':'|| p_entry_level_code);
909: END IF;
910:
911: select pbl.code_combination_id, pbl.budget_line_id
912: into x_budget_ccid, x_budget_line_id

Line 928: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:End of Get Budget CCID = ' || x_budget_ccid||' Line id:'||x_budget_line_id);

924: and trunc(pbl.start_date) = trunc(p_start_date);
925:
926: IF P_DEBUG_MODE = 'Y' THEN
927: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'End of Get Budget CCID');
928: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:End of Get Budget CCID = ' || x_budget_ccid||' Line id:'||x_budget_line_id);
929: END IF;
930:
931: EXCEPTION
932: when no_data_found then

Line 951: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:Inside Get Time Phased Type Code');

947: x_return_status := fnd_api.g_ret_sts_success;
948:
949: IF P_DEBUG_MODE = 'Y' THEN
950: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'Inside Get Time Phased Type Code');
951: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:Inside Get Time Phased Type Code');
952: END IF;
953:
954: select time_phased_type_code
955: into x_time_phased_type_code

Line 963: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:End of Get Time Phased Type Code');

959: and b.budget_version_id = p_budget_version_id;
960:
961: IF P_DEBUG_MODE = 'Y' THEN
962: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'End of Get Time Phased Type Code');
963: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:End of Get Time Phased Type Code');
964: END IF;
965:
966: EXCEPTION
967: when no_data_found then

Line 991: pa_fck_util.debug_msg('PB:Inside Get_Baselined_Budget_Version');

987: x_return_status := fnd_api.g_ret_sts_success;
988:
989: IF P_DEBUG_MODE = 'Y' THEN
990: pa_funds_control_utils.print_message('Inside Get_Baselined_Budget_Version');
991: pa_fck_util.debug_msg('PB:Inside Get_Baselined_Budget_Version');
992: END IF;
993:
994: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code
995: into x_base_version_id,x_res_list_id,x_entry_level_code

Line 1017: pa_fck_util.debug_msg('Get_Baselined_Budget_Version: ' || 'PB:Output = '|| x_base_version_id || ':' || x_res_list_id || ':'|| x_entry_level_code);

1013: and pbv.budget_entry_method_code = pbm.budget_entry_method_code;
1014:
1015: IF P_DEBUG_MODE = 'Y' THEN
1016: pa_funds_control_utils.print_message('End of Get_Baselined_Budget_Version');
1017: pa_fck_util.debug_msg('Get_Baselined_Budget_Version: ' || 'PB:Output = '|| x_base_version_id || ':' || x_res_list_id || ':'|| x_entry_level_code);
1018: pa_fck_util.debug_msg('PB:End of Get_Baselined_Budget_Version');
1019: END IF;
1020:
1021: EXCEPTION

Line 1018: pa_fck_util.debug_msg('PB:End of Get_Baselined_Budget_Version');

1014:
1015: IF P_DEBUG_MODE = 'Y' THEN
1016: pa_funds_control_utils.print_message('End of Get_Baselined_Budget_Version');
1017: pa_fck_util.debug_msg('Get_Baselined_Budget_Version: ' || 'PB:Output = '|| x_base_version_id || ':' || x_res_list_id || ':'|| x_entry_level_code);
1018: pa_fck_util.debug_msg('PB:End of Get_Baselined_Budget_Version');
1019: END IF;
1020:
1021: EXCEPTION
1022: when no_data_found then

Line 1046: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:Inside Get Acct Line Balance');

1042: x_avail_balance number;
1043: BEGIN
1044: IF P_DEBUG_MODE = 'Y' THEN
1045: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'Inside Get Acct Line Balance');
1046: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:Inside Get Acct Line Balance');
1047: END IF;
1048: /*
1049: --select bal.Curr_Ver_Available_Amount
1050: --into x_avail_balance

Line 1075: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:End of Get Acct Line Balance');

1071: AND end_date between trunc(p_start_date) and trunc(p_end_date);
1072:
1073: IF P_DEBUG_MODE = 'Y' THEN
1074: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'End of Get Acct Line Balance');
1075: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:End of Get Acct Line Balance');
1076: END IF;
1077: return nvl(x_avail_balance,0);
1078: EXCEPTION
1079: WHEN NO_DATA_FOUND THEN

Line 1093: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');

1089: BEGIN
1090:
1091: IF P_DEBUG_MODE = 'Y' THEN
1092: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'Inside Is budget baselined before');
1093: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');
1094: END IF;
1095:
1096: select 1 into l_count
1097: from pa_budget_versions pbv,

Line 1113: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:After Is budget baselined before = ' || x_baselined);

1109: end if;
1110:
1111: IF P_DEBUG_MODE = 'Y' THEN
1112: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'After Is budget baselined before = ' || x_baselined);
1113: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:After Is budget baselined before = ' || x_baselined);
1114: END IF;
1115: return x_baselined;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN

Line 1169: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code||

1165: l_budget_entry_level_code := P_budget_entry_level_code;
1166: l_period_name := p_period_name;
1167:
1168: IF P_DEBUG_MODE = 'Y' THEN
1169: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code||
1170: ']P_budget_version_id['||P_budget_version_id||']P_resource_assignment_id['||
1171: P_resource_assignment_id||']P_period_name['||l_period_name||
1172: ']pa_budget_fund_pkg.g_processing_mode['||pa_budget_fund_pkg.g_processing_mode||']'
1173: );

Line 1203: pa_fck_util.debug_msg('Is_account_change_allowed: No baseline budget exists');

1199: and pbv.current_flag = 'Y';
1200: Exception
1201: When no_Data_found then
1202: IF P_DEBUG_MODE = 'Y' THEN
1203: pa_fck_util.debug_msg('Is_account_change_allowed: No baseline budget exists');
1204: END IF;
1205:
1206: g_current_baseline_bvid := -2;
1207: g_api_project_id := -2;

Line 1258: pa_fck_util.debug_msg('Is_account_change_allowed: g_current_baseline_bvid['

1254:
1255: End If; -- I
1256:
1257: IF P_DEBUG_MODE = 'Y' THEN
1258: pa_fck_util.debug_msg('Is_account_change_allowed: g_current_baseline_bvid['
1259: ||g_current_baseline_bvid||'] g_api_project_id ['
1260: ||g_api_project_id||'] g_txn_exists_for_bvid ['
1261: || g_txn_exists_for_bvid ||']');
1262: END IF;

Line 1270: pa_fck_util.debug_msg('Is_account_change_allowed: No txn. exists - return Y');

1266: -- This can only happen if this API is called before first time baseline ..
1267: -- ------------------------------------------------------------------------------------------+
1268: If nvl(g_txn_exists_for_bvid,'N') = 'N' then
1269: IF P_DEBUG_MODE = 'Y' THEN
1270: pa_fck_util.debug_msg('Is_account_change_allowed: No txn. exists - return Y');
1271: END IF;
1272: RETURN 'Y';
1273: End If;
1274:

Line 1289: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code);

1285: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
1286:
1287:
1288: IF P_DEBUG_MODE = 'Y' THEN
1289: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code);
1290: END IF;
1291:
1292: End If;
1293:

Line 1311: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code(L/T?)['||l_budget_entry_level_code);

1307: l_budget_entry_level_code := 'L';
1308: End;
1309:
1310: IF P_DEBUG_MODE = 'Y' THEN
1311: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code(L/T?)['||l_budget_entry_level_code);
1312: END IF;
1313:
1314: End If; -- If l_budget_entry_level_code = 'M'
1315:

Line 1318: pa_fck_util.debug_msg('Is_account_change_allowed: get task/rlmi from resource assignments');

1314: End If; -- If l_budget_entry_level_code = 'M'
1315:
1316: -- Derive values reqd. for "Is_Account_change_allowed2 API"..
1317: IF P_DEBUG_MODE = 'Y' THEN
1318: pa_fck_util.debug_msg('Is_account_change_allowed: get task/rlmi from resource assignments');
1319: END IF;
1320:
1321: select task_id,resource_list_member_id
1322: into l_task_id,l_rlmi

Line 1327: pa_fck_util.debug_msg('Is_account_change_allowed: get parent rlmi');

1323: from pa_resource_assignments pra
1324: where pra.resource_assignment_id = P_resource_assignment_id;
1325:
1326: IF P_DEBUG_MODE = 'Y' THEN
1327: pa_fck_util.debug_msg('Is_account_change_allowed: get parent rlmi');
1328: END IF;
1329:
1330: If nvl(g_api_rlmi,-1) <> l_rlmi then
1331:

Line 1339: pa_fck_util.debug_msg('Is_account_change_allowed: get top task');

1335: g_api_rlmi := l_rlmi;
1336: End If;
1337:
1338: IF P_DEBUG_MODE = 'Y' THEN
1339: pa_fck_util.debug_msg('Is_account_change_allowed: get top task');
1340: END IF;
1341:
1342: If nvl(g_api_task_id,-1) <> l_task_id then
1343: If l_budget_entry_level_code = 'P' then

Line 1354: pa_fck_util.debug_msg('Is_account_change_allowed: get start date');

1350: End if;
1351: End If;
1352:
1353: IF P_DEBUG_MODE = 'Y' THEN
1354: pa_fck_util.debug_msg('Is_account_change_allowed: get start date');
1355: END IF;
1356:
1357: select distinct start_date into l_start_date from pa_budget_lines
1358: where budget_version_id = p_budget_version_id

Line 1363: pa_fck_util.debug_msg('Is_account_change_allowed: l_top_task_id['

1359: and resource_assignment_id = P_resource_assignment_id
1360: and period_name = l_period_name;
1361:
1362: IF P_DEBUG_MODE = 'Y' THEN
1363: pa_fck_util.debug_msg('Is_account_change_allowed: l_top_task_id['
1364: ||g_api_top_task_id||'] l_task_id ['
1365: ||l_task_id||'] l_rlmi ['||l_rlmi||']l_parent_rlmi['
1366: ||g_api_parent_rlmi||']l_start_date['||l_start_date
1367: ||'] l_period_name['||l_period_name ||']');

Line 1368: pa_fck_util.debug_msg('Is_account_change_allowed: Calling Is_Account_change_allowed2');

1364: ||g_api_top_task_id||'] l_task_id ['
1365: ||l_task_id||'] l_rlmi ['||l_rlmi||']l_parent_rlmi['
1366: ||g_api_parent_rlmi||']l_start_date['||l_start_date
1367: ||'] l_period_name['||l_period_name ||']');
1368: pa_fck_util.debug_msg('Is_account_change_allowed: Calling Is_Account_change_allowed2');
1369: END IF;
1370:
1371:
1372: If Is_Account_change_allowed2

Line 1385: pa_fck_util.debug_msg('Is_account_change_allowed: Is_Account_change_allowed2 -> N');

1381: p_entry_level_code => l_budget_entry_level_code,
1382: p_mode => 'FORM') = 'N' then
1383:
1384: IF P_DEBUG_MODE = 'Y' THEN
1385: pa_fck_util.debug_msg('Is_account_change_allowed: Is_Account_change_allowed2 -> N');
1386: End If;
1387:
1388: return 'N';
1389: Else

Line 1391: pa_fck_util.debug_msg('Is_account_change_allowed: Is_Account_change_allowed2 -> Y');

1387:
1388: return 'N';
1389: Else
1390: IF P_DEBUG_MODE = 'Y' THEN
1391: pa_fck_util.debug_msg('Is_account_change_allowed: Is_Account_change_allowed2 -> Y');
1392: End If;
1393:
1394: return'Y';
1395: End If;

Line 1689: pa_fck_util.debug_msg('In Is_account_change_allowed2:');

1685: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1686: l_allowed_flag varchar2(1);
1687: Begin
1688: IF P_DEBUG_MODE = 'Y' THEN
1689: pa_fck_util.debug_msg('In Is_account_change_allowed2:');
1690: END IF;
1691:
1692: l_allowed_flag := 'Y';
1693:

Line 1709: pa_fck_util.debug_msg('Is_account_change_allowed2: l_budget_entry_level_code::'||l_budget_entry_level_code);

1705: l_budget_entry_level_code := p_entry_level_code;
1706: End if;
1707:
1708: IF P_DEBUG_MODE = 'Y' THEN
1709: pa_fck_util.debug_msg('Is_account_change_allowed2: l_budget_entry_level_code::'||l_budget_entry_level_code);
1710: END IF;
1711:
1712: If p_mode = 'FORM' then -- ------------------------------+ FORM
1713: -- ------------------------------------------------------------------------+

Line 1914: pa_fck_util.debug_msg('In Is_account_change_allowed2:l_allowed_flag::'||l_allowed_flag);

1910: -- ------------------------------------------------------------------------+
1911: End If; --If p_mode = 'FORM' then -- ------------------------------+ BASELINE
1912:
1913: IF P_DEBUG_MODE = 'Y' THEN
1914: pa_fck_util.debug_msg('In Is_account_change_allowed2:l_allowed_flag::'||l_allowed_flag);
1915: END IF;
1916:
1917: RETURN l_allowed_flag;
1918:

Line 1922: pa_fck_util.debug_msg('In Is_account_change_allowed2:l_allowed_flag::'||'Y');

1918:
1919: Exception
1920: When no_data_found then
1921: IF P_DEBUG_MODE = 'Y' THEN
1922: pa_fck_util.debug_msg('In Is_account_change_allowed2:l_allowed_flag::'||'Y');
1923: END IF;
1924:
1925: RETURN 'Y';
1926: End Is_account_change_allowed2;

Line 2160: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );

2156: BEGIN
2157:
2158:
2159: IF P_DEBUG_MODE = 'Y' THEN
2160: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );
2161: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_calling_mode ='||p_calling_mode );
2162: END IF;
2163:
2164: -- Bug 5206341 : Check if closed GL periods exists for this baseline run.

Line 2161: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_calling_mode ='||p_calling_mode );

2157:
2158:
2159: IF P_DEBUG_MODE = 'Y' THEN
2160: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );
2161: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_calling_mode ='||p_calling_mode );
2162: END IF;
2163:
2164: -- Bug 5206341 : Check if closed GL periods exists for this baseline run.
2165: -- If exists we need to have additional logic to stamp latest budget version id and

Line 2172: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start l_closed_prd_exists ='||l_closed_prd_exists );

2168:
2169: l_closed_prd_exists := PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_bud_ver_id);
2170:
2171: IF P_DEBUG_MODE = 'Y' THEN
2172: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start l_closed_prd_exists ='||l_closed_prd_exists );
2173: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );
2174: END IF;
2175:
2176: IF p_calling_mode = 'RESERVE_BASELINE' THEN

Line 2173: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );

2169: l_closed_prd_exists := PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_bud_ver_id);
2170:
2171: IF P_DEBUG_MODE = 'Y' THEN
2172: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start l_closed_prd_exists ='||l_closed_prd_exists );
2173: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );
2174: END IF;
2175:
2176: IF p_calling_mode = 'RESERVE_BASELINE' THEN
2177:

Line 2182: pa_fck_util.debug_msg('Clearing local plsql tabs');

2178: OPEN c_bc_packets;
2179: LOOP
2180:
2181: IF P_DEBUG_MODE = 'Y' THEN
2182: pa_fck_util.debug_msg('Clearing local plsql tabs');
2183: END IF;
2184:
2185: Intialize_plsql_tables;
2186:

Line 2204: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);

2200: l_glprdstatustab
2201: LIMIT 500;
2202:
2203: IF P_DEBUG_MODE = 'Y' THEN
2204: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2205: END IF;
2206:
2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

Line 2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

2204: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2205: END IF;
2206:
2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));

Line 2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));

2205: END IF;
2206:
2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));

Line 2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));

2206:
2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));

Line 2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));

2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));

Line 2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));

2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));

Line 2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));

2209: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));

Line 2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));

2210: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));

Line 2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));

2211: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));

Line 2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));

2212: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2220: END LOOP;

Line 2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));

2213: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2220: END LOOP;
2221:

Line 2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));

2214: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2220: END LOOP;
2221:
2222: IF l_DocHdrTab.count = 0 THEN

Line 2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));

2215: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2216: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2217: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2218: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2219: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2220: END LOOP;
2221:
2222: IF l_DocHdrTab.count = 0 THEN
2223: IF P_DEBUG_MODE = 'Y' THEN

Line 2224: pa_fck_util.debug_msg('No more records to process');

2220: END LOOP;
2221:
2222: IF l_DocHdrTab.count = 0 THEN
2223: IF P_DEBUG_MODE = 'Y' THEN
2224: pa_fck_util.debug_msg('No more records to process');
2225: END IF;
2226: EXIT;
2227: END IF;
2228:

Line 2239: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Deriving budget details for closed period txns');

2235:
2236: IF l_glprdstatustab(i) = 'C' THEN
2237:
2238: IF P_DEBUG_MODE = 'Y' THEN
2239: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Deriving budget details for closed period txns');
2240: END IF;
2241:
2242: Get_Budget_CCID (
2243: p_project_id => l_projidTab(i),

Line 2258: pa_fck_util.debug_msg( 'Value of l_blidTab(i) '||l_blidTab(i));

2254:
2255: END IF;
2256:
2257: IF P_DEBUG_MODE = 'Y' THEN
2258: pa_fck_util.debug_msg( 'Value of l_blidTab(i) '||l_blidTab(i));
2259: END IF;
2260:
2261: END LOOP;
2262:

Line 2266: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');

2262:
2263: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2264:
2265: IF P_DEBUG_MODE = 'Y' THEN
2266: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');
2267: END IF;
2268:
2269: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2270: UPDATE pa_cost_distribution_lines_all cdl

Line 2285: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2281: AND xev.process_status_code <> 'P' )
2282: );
2283:
2284: IF P_DEBUG_MODE = 'Y' THEN
2285: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2286: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2287: END IF;
2288:
2289: -- Bug 5206341 : Logic to stamp new budget_line_id for transactions which are falling with in

Line 2286: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');

2282: );
2283:
2284: IF P_DEBUG_MODE = 'Y' THEN
2285: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2286: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2287: END IF;
2288:
2289: -- Bug 5206341 : Logic to stamp new budget_line_id for transactions which are falling with in
2290: -- closed periods.For transactions falling in open/future periods ,sweeper process will be updating

Line 2304: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);

2300: AND l_glprdstatustab(i) = 'C'
2301: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;
2302:
2303: IF P_DEBUG_MODE = 'Y' THEN
2304: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);
2305: END IF;
2306:
2307: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2308:

Line 2321: pa_fck_util.debug_msg('Clearing local plsql tabs');

2317: OPEN c_bccom_packets;
2318: LOOP
2319:
2320: IF P_DEBUG_MODE = 'Y' THEN
2321: pa_fck_util.debug_msg('Clearing local plsql tabs');
2322: END IF;
2323:
2324: Intialize_plsql_tables;
2325:

Line 2343: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);

2339: l_glprdstatustab
2340: LIMIT 500;
2341:
2342: IF P_DEBUG_MODE = 'Y' THEN
2343: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2344: END IF;
2345:
2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

Line 2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

2343: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2344: END IF;
2345:
2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));

Line 2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));

2344: END IF;
2345:
2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));

Line 2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));

2345:
2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));

Line 2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));

2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));

Line 2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));

2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));
2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));

Line 2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));

2348: pa_fck_util.debug_msg('Value of l_DocDistTab('||i||')='||l_DocDistTab(i));
2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));

Line 2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));

2349: pa_fck_util.debug_msg('Value of l_bccomidTab ('||i||')='||l_bccomidTab(i));
2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));

Line 2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));

2350: pa_fck_util.debug_msg('Value of l_projidTab ('||i||')='||l_projidTab(i));
2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));

Line 2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));

2351: pa_fck_util.debug_msg('Value of l_taskidTab ('||i||')='||l_taskidTab(i));
2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2359: END LOOP;

Line 2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));

2352: pa_fck_util.debug_msg('Value of l_toptaskidTab ('||i||')='||l_toptaskidTab(i));
2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2359: END LOOP;
2360:

Line 2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));

2353: pa_fck_util.debug_msg('Value of l_rlmidTab ('||i||')='||l_rlmidTab(i));
2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2359: END LOOP;
2360:
2361: IF l_DocHdrTab.count = 0 THEN

Line 2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));

2354: pa_fck_util.debug_msg('Value of l_startdateTab ('||i||')='||l_startdateTab(i));
2355: pa_fck_util.debug_msg('Value of l_entrylevelcode ('||i||')='||l_entrylevelcode(i));
2356: pa_fck_util.debug_msg('Value of l_burcodeTab ('||i||')='||l_burcodeTab(i));
2357: pa_fck_util.debug_msg('Value of l_bvidTab ('||i||')='||l_bvidTab(i));
2358: pa_fck_util.debug_msg('Value of l_glprdstatustab ('||i||')='||l_glprdstatustab(i));
2359: END LOOP;
2360:
2361: IF l_DocHdrTab.count = 0 THEN
2362: IF P_DEBUG_MODE = 'Y' THEN

Line 2363: pa_fck_util.debug_msg('No more records to process');

2359: END LOOP;
2360:
2361: IF l_DocHdrTab.count = 0 THEN
2362: IF P_DEBUG_MODE = 'Y' THEN
2363: pa_fck_util.debug_msg('No more records to process');
2364: END IF;
2365: EXIT;
2366: END IF;
2367:

Line 2369: pa_fck_util.debug_msg( 'deriving budget_version_id and budget_line_id ');

2365: EXIT;
2366: END IF;
2367:
2368: IF P_DEBUG_MODE = 'Y' THEN
2369: pa_fck_util.debug_msg( 'deriving budget_version_id and budget_line_id ');
2370: END IF;
2371:
2372: FOR i in l_DocHdrTab.first..l_DocHdrTab.last LOOP
2373:

Line 2388: pa_fck_util.debug_msg( 'Value of l_blidTab(i) '||l_blidTab(i));

2384: x_return_status => l_return_status,
2385: x_error_message_code => l_error_message_code );
2386:
2387: IF P_DEBUG_MODE = 'Y' THEN
2388: pa_fck_util.debug_msg( 'Value of l_blidTab(i) '||l_blidTab(i));
2389: END IF;
2390:
2391: END LOOP;
2392:

Line 2394: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');

2390:
2391: END LOOP;
2392:
2393: IF P_DEBUG_MODE = 'Y' THEN
2394: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');
2395: END IF;
2396:
2397: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2398: UPDATE pa_cost_distribution_lines_all cdl

Line 2415: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2411: AND xev.process_status_code <> 'P' )
2412: );
2413:
2414: IF P_DEBUG_MODE = 'Y' THEN
2415: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2417: END IF;
2418:
2419: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last

Line 2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');

2412: );
2413:
2414: IF P_DEBUG_MODE = 'Y' THEN
2415: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2417: END IF;
2418:
2419: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2420: UPDATE pa_cost_distribution_lines_all cdl

Line 2441: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2437: AND xev.process_status_code <> 'P' )
2438: );
2439:
2440: IF P_DEBUG_MODE = 'Y' THEN
2441: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2442: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2443: END IF;
2444:
2445: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last

Line 2442: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');

2438: );
2439:
2440: IF P_DEBUG_MODE = 'Y' THEN
2441: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2442: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2443: END IF;
2444:
2445: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2446: UPDATE pa_bc_commitments_all bccom

Line 2452: pa_fck_util.debug_msg( 'Number of pa_bc_commitments updated'||SQL%ROWCOUNT);

2448: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2449: WHERE bccom.bc_commitment_id = l_bccomidTab(i);
2450:
2451: IF P_DEBUG_MODE = 'Y' THEN
2452: pa_fck_util.debug_msg( 'Number of pa_bc_commitments updated'||SQL%ROWCOUNT);
2453: END IF;
2454:
2455: END LOOP;
2456: CLOSE c_bccom_packets;

Line 2461: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: End' );

2457:
2458: END IF; --IF p_calling_mode = 'YEAR END ROLLOVER' THEN
2459:
2460: IF P_DEBUG_MODE = 'Y' THEN
2461: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: End' );
2462: END IF;
2463:
2464: Exception
2465: When OTHERS then

Line 2467: pa_fck_util.debug_msg('EXCEPTION: '||SQLERRM);

2463:
2464: Exception
2465: When OTHERS then
2466: IF P_DEBUG_MODE = 'Y' THEN
2467: pa_fck_util.debug_msg('EXCEPTION: '||SQLERRM);
2468: END IF;
2469: RAISE;
2470: END Update_bvid_blid_on_cdl_bccom;
2471: