[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;
1040: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: begin.. ');
1041: print_time ( 'UPDATE_PRIMARY_PVT_ACT_ETC: p_plan_version_id ' || p_plan_version_id );
1042: print_time ( ' p_prev_pub_version_id ' || p_prev_pub_version_id );
1043:
1044: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1045: ( p_package_name => g_package_name
1046: , x_return_status => x_return_status );
1047:
1048:
1067: print_time('UPDATE_PRIMARY_PVT_ACT_ETC: end. successful.. ');
1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1072: ( p_package_name => g_package_name
1073: , p_procedure_name => 'UPDATE_PRIMARY_PVT_ACT_ETC'
1074: , x_return_status => x_return_status ) ;
1075:
1575:
1576: print_time(' PULL_PLANS_FOR_PR : begin.. ');
1577:
1578:
1579: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK
1580: ( p_package_name => g_package_name
1581: , x_return_status => x_return_status );
1582:
1583: 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 );
1639: print_time('CREATE_PRIMARY_PVT 2 : end.. ');
1640:
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1644: ( p_package_name => g_package_name
1645: , p_procedure_name => ' PULL_PLANS_FOR_PR '
1646: , x_return_status => x_return_status ) ;
1647:
1665: print_time('GET_ACTUALS_SUMM : start.. ');
1666:
1667: print_time ( 'GET_ACTUALS_SUMM : extrn type is: ' || NVL(p_extr_type, 'AA'));
1668:
1669: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1670: ( p_package_name => g_package_name
1671: , x_return_status => x_return_status ) ;
1672:
1673: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1669: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1670: ( p_package_name => g_package_name
1671: , x_return_status => x_return_status ) ;
1672:
1673: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1674:
1675: print_time ( ' p_extr_type = ' || p_extr_type || ' g_worker_id = ' || g_worker_id );
1676:
1677: IF (p_extr_type NOT IN ('FULL', 'INCREMENTAL')) THEN
1728: print_time('GET_ACTUALS_SUMM : end.. ');
1729:
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1733: ( p_package_name => g_package_name
1734: , p_procedure_name => 'GET_ACTUALS_SUMM'
1735: , x_return_status => x_return_status ) ;
1736:
1765: END IF;
1766:
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1770: ( p_package_name => g_package_name
1771: , p_procedure_name => 'CHECK_VER3_NOT_EMPTY'
1772: , x_return_status => l_return_status ) ;
1773:
1922: BEGIN
1923:
1924: print_time('POPULATE_FIN8 : start.. ');
1925:
1926: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1927: ( p_package_name => g_package_name
1928: , x_return_status => x_return_status ) ;
1929:
1930:
2061: print_time('POPULATE_FIN8 : end.. ');
2062:
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
2066: ( p_package_name => g_package_name
2067: , p_procedure_name => 'POPULATE_FIN8'
2068: , x_return_status => x_return_status ) ;
2069:
2076: PROCEDURE PRINT_TIME(
2077: p_tag IN VARCHAR2
2078: ) IS
2079: BEGIN
2080: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2084: p_procedure_name => 'PRINT_TIME');