DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PLANNING_TRANSACTION_UTILS

Line 2312: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;

2308: l_trace_stage := 80;
2309: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2310:
2311: IF l_debug_mode = 'Y' THEN
2312: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;
2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2315: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2316: END IF;

Line 2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;

2310:
2311: IF l_debug_mode = 'Y' THEN
2312: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;
2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2315: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2316: END IF;
2317:
2318: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);

Line 2318: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);

2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2315: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2316: END IF;
2317:
2318: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);
2319:
2320: l_trace_stage := 90;
2321: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2322: pa_fp_planning_transaction_pub.add_wp_plan_type

Line 2540: pa_debug.g_err_stage:='Calling API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids';

2536: l_trace_stage := 220;
2537: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2538:
2539: IF l_debug_mode = 'Y' THEN
2540: pa_debug.g_err_stage:='Calling API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids';
2541: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2542: END IF;
2543:
2544: pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids

Line 2544: pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids

2540: pa_debug.g_err_stage:='Calling API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids';
2541: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2542: END IF;
2543:
2544: pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids
2545: (p_project_id => p_project_id,
2546: p_resource_list_id => l_resource_list_id,
2547: x_people_res_class_rlm_id => l_people_res_class_rlm_id,
2548: x_equip_res_class_rlm_id => l_equip_res_class_rlm_id,

Line 2558: pa_debug.g_err_stage:='Called API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids api returned error';

2554: l_trace_stage := 230;
2555: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2556: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2557: IF l_debug_mode = 'Y' THEN
2558: pa_debug.g_err_stage:='Called API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids api returned error';
2559: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2560: END IF;
2561: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2562: END IF;

Line 3973: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates

3969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3970: END IF;
3971:
3972: -- Bug 3793623 - Added new params p_planning_start_date_tbl and p_planning_end_date_tbl
3973: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates
3974: ( p_project_id => p_project_id
3975: ,p_element_version_id_tbl => p_task_elem_version_id_tbl
3976: ,p_project_structure_version_id => PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id => p_project_id )
3977: ,p_planning_start_date_tbl => p_planning_start_date_tbl

Line 6355: l_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_wp_budget_version_id(p_struct_elem_version_id);

6351: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6352: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6353: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6354: ELSE
6355: l_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_wp_budget_version_id(p_struct_elem_version_id);
6356: IF l_budget_version_id IS NULL THEN
6357: IF l_debug_mode = 'Y' THEN
6358: pa_debug.g_err_stage:='Calling add plan txn to create the version';
6359: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 6397: l_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_wp_budget_version_id(p_struct_elem_version_id);

6393: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6394: END IF;
6395: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6396: END IF;
6397: l_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_wp_budget_version_id(p_struct_elem_version_id);
6398: END IF;
6399:
6400: END IF;
6401: /* If the calling Context is BUDGET or FORECAST, the budget version Id can't be null

Line 9125: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api

9121:
9122: --Added the if condition for the bug 4200168
9123: IF l_pji_rollup_required = 'Y' THEN
9124:
9125: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api
9126: ( p_source => 'PA_FP_RA_MAP_TMP'
9127: ,p_budget_version_id => l_targ_budget_version_id
9128: ,x_return_status => x_return_status
9129: ,x_msg_data => x_msg_data

Line 9135: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';

9131:
9132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9133:
9134: IF l_debug_mode = 'Y' THEN
9135: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
9136: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
9137: END IF;
9138: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
9139: END IF;

Line 10713: pa_planning_transaction_utils.call_update_rep_lines_api

10709: END IF;
10710:
10711:
10712:
10713: pa_planning_transaction_utils.call_update_rep_lines_api
10714: ( p_source => 'PL-SQL'
10715: ,p_budget_Version_id => l_budget_version_id
10716: ,p_resource_assignment_id_tbl => l_resource_assignment_id_tbl
10717: ,p_cbs_element_id_tbl => l_cbs_element_id_tbl

Line 10748: pa_debug.g_err_stage:='The API pa_planning_transaction_utils.call_update_rep_lines_api returned error';

10744: ,x_msg_count => x_msg_count );
10745:
10746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10747: IF l_debug_mode = 'Y' THEN
10748: pa_debug.g_err_stage:='The API pa_planning_transaction_utils.call_update_rep_lines_api returned error';
10749: print_msg(pa_debug.g_err_stage,l_module_name);
10750: END IF;
10751: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10752: END IF;

Line 11929: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids

11925:
11926:
11927: -- Fetch rlm id of FINANCIAL ELEMENT resource class for new resource list id
11928:
11929: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
11930: ( p_project_id => budget_version_info_rec.project_id
11931: ,p_resource_list_id => budget_version_info_rec.resource_list_id
11932: ,x_people_res_class_rlm_id => l_people_res_class_rlm_id
11933: ,x_equip_res_class_rlm_id => l_equip_res_class_rlm_id

Line 11942: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

11938: ,x_msg_data => l_msg_data);
11939:
11940: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11941: IF l_debug_mode = 'Y' THEN
11942: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11943: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
11944: END IF;
11945: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11946: END IF;

Line 12343: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids

12339: RAISE;
12340: END;
12341:
12342:
12343: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
12344: (p_project_id => version_info_rec.project_id,
12345: p_resource_list_id => version_info_rec.resource_list_id,
12346: x_people_res_class_rlm_id => l_people_res_class_rlm_id,
12347: x_equip_res_class_rlm_id => l_equip_res_class_rlm_id ,

Line 12357: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

12353: --hr_utility.trace('G_BUDGET_ENTRY_LEVEL_LOWEST -> rlmids'|| l_people_res_class_rlm_id || 'x' || l_equip_res_class_rlm_id || 'x' || l_fin_res_class_rlm_id || 'x' || l_mat_res_class_rlm_id);
12354:
12355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12356: IF l_debug_mode = 'Y' THEN
12357: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12359: END IF;
12360: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12361: END IF;

Line 12427: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

12423: ,x_msg_data => l_msg_data );
12424:
12425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12426: IF l_debug_mode = 'Y' THEN
12427: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12428: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12429: END IF;
12430: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12431: END IF;

Line 12466: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

12462: END IF;
12463:
12464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12465: IF l_debug_mode = 'Y' THEN
12466: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12468: END IF;
12469: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12470: END IF;

Line 12512: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

12508: ,x_msg_data => l_msg_data );
12509:
12510: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12511: IF l_debug_mode = 'Y' THEN
12512: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12513: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12514: END IF;
12515: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12516: END IF;

Line 12852: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api

12848: pa_debug.g_err_stage:='Calling call_update_rep_lines' || l_budget_version_id_tbl(i);
12849: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
12850: END IF;
12851:
12852: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api
12853: --( p_source => 'POPULATE_PJI_TABLE' --Commented for bug 5073350.
12854: ( p_source => 'REFRESH_WP_SETTINGS'
12855: ,p_budget_version_id => l_budget_version_id_tbl(i)
12856: ,p_qty_sign => -1

Line 12864: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';

12860:
12861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12862:
12863: IF l_debug_mode = 'Y' THEN
12864: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
12865: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
12866: END IF;
12867: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
12868: END IF;

Line 12889: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids

12885: CLOSE published_versions_cur;
12886:
12887: IF l_pub_budget_version_id_tbl.COUNT > 0 THEN
12888:
12889: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
12890: ( p_project_id => p_project_id
12891: ,p_resource_list_id => parent_plan_type_rec.cost_resource_list_id
12892: ,x_people_res_class_rlm_id => l_people_res_class_rlm_id
12893: ,x_equip_res_class_rlm_id => l_equip_res_class_rlm_id

Line 12902: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

12898: ,x_msg_data => x_msg_data);
12899:
12900: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12901: IF l_debug_mode = 'Y' THEN
12902: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12903: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
12904: END IF;
12905: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12906: END IF;

Line 13021: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids

13017: -- If resource list has changed task level resource assignments
13018: -- should be re-mapped with new People resource class rlmid
13019: -- Fetching the resource class rlm only if not fetched already during published version processing
13020: IF nvl(p_resource_list_change, 'N') = 'Y' AND l_people_res_class_rlm_id IS NULL THEN
13021: PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
13022: ( p_project_id => p_project_id
13023: ,p_resource_list_id => parent_plan_type_rec.cost_resource_list_id
13024: ,x_people_res_class_rlm_id => l_people_res_class_rlm_id
13025: ,x_equip_res_class_rlm_id => l_equip_res_class_rlm_id

Line 13034: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';

13030: ,x_msg_data => x_msg_data);
13031:
13032: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13033: IF l_debug_mode = 'Y' THEN
13034: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
13035: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13036: END IF;
13037: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13038: END IF;

Line 13283: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';

13279:
13280: -- Check return status
13281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13282: IF l_debug_mode = 'Y' THEN
13283: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
13284: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13285: END IF;
13286: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13287: ELSE

Line 13293: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api

13289: IF l_txn_source_id_tbl.count <> l_rbs_element_id_tbl.count OR
13290: l_txn_source_id_tbl.count <> l_txn_accum_header_id_tbl.count
13291: THEN
13292: IF l_debug_mode = 'Y' THEN
13293: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api
13294: returned out tables with different count';
13295: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
13296: pa_debug.g_err_stage:='l_txn_source_id_tbl.count = ' || l_txn_source_id_tbl.count;
13297: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);

Line 13367: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api

13363:
13364:
13365: FOR i IN l_budget_version_id_tbl.FIRST .. l_budget_version_id_tbl.LAST
13366: LOOP
13367: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api
13368: --( p_source => 'POPULATE_PJI_TABLE' --Commented for bug 5073350.
13369: ( p_source => 'REFRESH_WP_SETTINGS'
13370: ,p_budget_version_id => l_budget_version_id_tbl(i)
13371: ,p_qty_sign => 1

Line 13378: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';

13374: ,x_msg_count => x_msg_count);
13375:
13376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13377: IF l_debug_mode = 'Y' THEN
13378: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
13379: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
13380: END IF; RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13381: END IF;
13382: END LOOP;

Line 13389: in PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api.

13385: This call will update all the plan versions of a project which are affected due to the
13386: workplan paln settings change.If any of those versions is in pending processing status,
13387: as per the PJI design error will be thrown.So, commenting out this code.
13388: The PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE api will be called seperately for each plan version
13389: in PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api.
13390:
13391: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (
13392: x_return_status => x_return_status,
13393: x_msg_code => l_error_msg_code);

Line 13679: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';

13675:
13676: -- Check return status
13677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13678: IF l_debug_mode = 'Y' THEN
13679: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
13680: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13681: END IF;
13682: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13683: ELSE

Line 13689: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api

13685: IF l_txn_source_id_tbl.count <> l_rbs_element_id_tbl.count OR
13686: l_txn_source_id_tbl.count <> l_txn_accum_header_id_tbl.count
13687: THEN
13688: IF l_debug_mode = 'Y' THEN
13689: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api
13690: returned out tables with different count';
13691: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
13692: pa_debug.g_err_stage:='l_txn_source_id_tbl.count = ' || l_txn_source_id_tbl.count;
13693: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);