[Home] [Help]
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT';
6:
7: g_worker_id NUMBER := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID; -- NULL;
8: g_event_rec PA_PJI_PROJ_EVENTS_LOG%ROWTYPE;
9: g_process_update_wbs_flag VARCHAR2(1) := 'N' ;
10:
11:
652: print_time(' p_Copy_mode ' || p_copy_mode );
653:
654: print_time('CREATE_PRIMARY_PVT 2 : l_count is ... ' || p_fp_version_ids.COUNT );
655:
656: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T',10,10,10); -- Seeding the table Ver3_t
657:
658: IF (p_is_primary_rbs NOT IN ('T', 'F')) THEN
659: RETURN;
660: END IF;
1076: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: begin.. ');
1077: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: p_plan_version_id ' || p_plan_version_id );
1078: print_time ( ' p_prev_pub_version_id ' || p_prev_pub_version_id );
1079:
1080: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1081: ( p_package_name => g_package_name
1082: , x_return_status => x_return_status );
1083:
1084:
1103: print_time('UPDATE_PRIMARY_PVT_ACT_ETC: end. successful.. ');
1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1108: ( p_package_name => g_package_name
1109: , p_procedure_name => 'UPDATE_PRIMARY_PVT_ACT_ETC'
1110: , x_return_status => x_return_status ) ;
1111:
1629:
1630: print_time(' PULL_PLANS_FOR_PR : begin.. ');
1631:
1632:
1633: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK
1634: ( p_package_name => g_package_name
1635: , x_return_status => x_return_status );
1636:
1637: print_time(' PULL_PLANS_FOR_PR value of p_plan_type_id is ' || p_plan_type_id || ' and p_rbs_version_id is ' || p_rbs_version_id );
1699: print_time('CREATE_PRIMARY_PVT 2 : end.. ');
1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1704: ( p_package_name => g_package_name
1705: , p_procedure_name => ' PULL_PLANS_FOR_PR '
1706: , x_return_status => x_return_status ) ;
1707:
1725: print_time('GET_ACTUALS_SUMM : start.. ');
1726:
1727: print_time ( 'GET_ACTUALS_SUMM : extrn type is: ' || NVL(p_extr_type, 'AA'));
1728:
1729: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1730: ( p_package_name => g_package_name
1731: , x_return_status => x_return_status ) ;
1732:
1733: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1729: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1730: ( p_package_name => g_package_name
1731: , x_return_status => x_return_status ) ;
1732:
1733: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1734:
1735: print_time ( ' p_extr_type = ' || p_extr_type || ' g_worker_id = ' || g_worker_id );
1736:
1737: IF (p_extr_type NOT IN ('FULL', 'INCREMENTAL')) THEN
1788: print_time('GET_ACTUALS_SUMM : end.. ');
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1793: ( p_package_name => g_package_name
1794: , p_procedure_name => 'GET_ACTUALS_SUMM'
1795: , x_return_status => x_return_status ) ;
1796:
1825: END IF;
1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1830: ( p_package_name => g_package_name
1831: , p_procedure_name => 'CHECK_VER3_NOT_EMPTY'
1832: , x_return_status => l_return_status ) ;
1833:
1982: BEGIN
1983:
1984: print_time('POPULATE_FIN8 : start.. ');
1985:
1986: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1987: ( p_package_name => g_package_name
1988: , x_return_status => x_return_status ) ;
1989:
1990:
2125: print_time('POPULATE_FIN8 : end.. ');
2126:
2127: EXCEPTION
2128: WHEN OTHERS THEN
2129: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
2130: ( p_package_name => g_package_name
2131: , p_procedure_name => 'POPULATE_FIN8'
2132: , x_return_status => x_return_status ) ;
2133:
2140: PROCEDURE PRINT_TIME(
2141: p_tag IN VARCHAR2
2142: ) IS
2143: BEGIN
2144: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
2145: EXCEPTION
2146: WHEN OTHERS THEN
2147: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2148: p_procedure_name => 'PRINT_TIME');