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.WIP_WS_EMBEDDED_ANALYTICS_PK dependencies on WIP_LOGGER

Line 26: RETURN wip_logger.param_tbl_t IS

22:
23: FUNCTION set_calc_param(p_execution_date IN DATE,
24: p_cutoff_date IN DATE,
25: p_org_id IN NUMBER)
26: RETURN wip_logger.param_tbl_t IS
27: l_params wip_logger.param_tbl_t;
28: BEGIN
29: l_params (1).paramName := 'p_execution_date';
30: l_params (1).paramValue := p_execution_date;

Line 27: l_params wip_logger.param_tbl_t;

23: FUNCTION set_calc_param(p_execution_date IN DATE,
24: p_cutoff_date IN DATE,
25: p_org_id IN NUMBER)
26: RETURN wip_logger.param_tbl_t IS
27: l_params wip_logger.param_tbl_t;
28: BEGIN
29: l_params (1).paramName := 'p_execution_date';
30: l_params (1).paramValue := p_execution_date;
31: l_params (2).paramName := 'p_cutoff_date';

Line 38: PROCEDURE begin_log(p_params wip_logger.param_tbl_t,

34: l_params (3).paramValue := p_org_id;
35: RETURN l_params;
36: END set_calc_param;
37:
38: PROCEDURE begin_log(p_params wip_logger.param_tbl_t,
39: p_proc_name VARCHAR2,
40: p_return_status OUT NOCOPY VARCHAR2
41: ) IS
42: BEGIN

Line 44: wip_logger.entryPoint(p_procName => p_proc_name,

40: p_return_status OUT NOCOPY VARCHAR2
41: ) IS
42: BEGIN
43: IF (g_logLevel <= wip_constants.trace_logging) THEN
44: wip_logger.entryPoint(p_procName => p_proc_name,
45: p_params => p_params,
46: x_returnStatus => p_return_status);
47:
48: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

Line 54: wip_logger.exitPoint(p_procName => p_proc_name,

50: END IF;
51: END IF;
52:
53: IF (g_logLevel <= wip_constants.trace_logging) then
54: wip_logger.exitPoint(p_procName => p_proc_name,
55: p_procReturnStatus => p_return_status,
56: p_msg => 'procedure success.',
57: x_returnStatus => p_return_Status);
58: END IF;

Line 68: wip_logger.exitPoint(p_procName => p_proc_name,

64: BEGIN
65: wip_ws_util.trace_log('Error in ' || p_proc_name);
66: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: IF (g_logLevel <= wip_constants.trace_logging) then
68: wip_logger.exitPoint(p_procName => p_proc_name,
69: p_procReturnStatus => l_return_status,
70: p_msg => 'unexpected error: ' || SQLERRM,
71: x_returnStatus => l_return_Status);
72: END IF;

Line 82: l_params wip_logger.param_tbl_t;

78: p_org_id IN NUMBER,
79: x_return_status OUT NOCOPY VARCHAR2) IS
80:
81: l_return_status varchar2(1);
82: l_params wip_logger.param_tbl_t;
83:
84: BEGIN
85:
86: IF (g_logLevel <= wip_constants.trace_logging) THEN

Line 95: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',

91: l_params(2).paramValue := p_cutoff_date;
92: l_params(3).paramName := 'p_org_id';
93: l_params(3).paramValue := p_org_id;
94:
95: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',
96: p_params => l_params,
97: x_returnStatus => l_return_status);
98:
99: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 614: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',

610: */
611: -------------------------------------- end of population logic -------------------------------------------------------
612:
613: IF (g_logLevel <= wip_constants.trace_logging) then
614: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',
615: p_procReturnStatus => l_return_status,
616: p_msg => 'procedure success.',
617: x_returnStatus => l_return_Status);
618: END IF;

Line 625: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',

621: WHEN others THEN
622: wip_ws_util.trace_log('Error in populate_fpy_raw_data');
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF (g_logLevel <= wip_constants.trace_logging) then
625: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',
626: p_procReturnStatus => l_return_status,
627: p_msg => 'unexpected error: ' || SQLERRM,
628: x_returnStatus => l_return_Status);
629: END IF;

Line 644: l_params wip_logger.param_tbl_t;

640: p_org_id NUMBER,
641: x_return_status OUT NOCOPY VARCHAR2) IS
642:
643: l_return_status VARCHAR2(1);
644: l_params wip_logger.param_tbl_t;
645: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_day_shift';
646: BEGIN
647:
648: begin_log (p_params => set_calc_param(p_execution_date => p_execution_date,p_cutoff_date => p_cutoff_date,p_org_id => p_org_id),

Line 2196: l_params wip_logger.param_tbl_t;

2192: l_calc_start_date DATE;
2193: l_last_calculation_date DATE;
2194: l_department_id NUMBER;
2195:
2196: l_params wip_logger.param_tbl_t;
2197: l_return_status VARCHAR2(1);
2198: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.get_start_shift_date_to_calc';
2199: BEGIN
2200:

Line 2407: l_params wip_logger.param_tbl_t;

2403: l_retention_boundary DATE;
2404: l_calc_start_date DATE;
2405:
2406: l_return_status VARCHAR2(1);
2407: l_params wip_logger.param_tbl_t;
2408: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.wip_ws_fpykpi_conc_prog';
2409:
2410: l_concurrent_count NUMBER;
2411: l_conc_status boolean;

Line 2490: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_fpykpi_conc_prog',

2486: wip_ws_util.trace_log('populate_fpy_raw_data is successfull');
2487: END IF;
2488:
2489: IF (g_logLevel <= wip_constants.trace_logging) then
2490: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_fpykpi_conc_prog',
2491: p_procReturnStatus => l_return_status,
2492: p_msg => 'processed successfully',
2493: x_returnStatus => l_return_status);
2494: END IF;

Line 2644: l_params wip_logger.param_tbl_t;

2640: l_concurrent_execution_date DATE;
2641: l_msg_data VARCHAR2(1000);
2642: l_msg_count NUMBER;
2643: l_lock_status NUMBER;
2644: l_params wip_logger.param_tbl_t;
2645: l_shift_seq NUMBER;
2646: l_shift_num NUMBER;
2647: l_shift_start_date DATE;
2648: l_shift_end_date DATE;

Line 2664: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

2660:
2661: l_params(1).paramName := 'p_org_id';
2662: l_params(1).paramValue := p_org_id;
2663:
2664: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2665: p_params => l_params,
2666: x_returnStatus => l_return_status);
2667:
2668: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 2672: wip_logger.log(' Start Time : = '||to_char(l_concurrent_execution_date),l_return_status);

2668: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2669: RAISE fnd_api.g_exc_unexpected_error;
2670: END IF;
2671:
2672: wip_logger.log(' Start Time : = '||to_char(l_concurrent_execution_date),l_return_status);
2673:
2674: END IF;
2675:
2676: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));

Line 2716: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

2712: wip_ws_util.trace_log('populate_fpy_raw_data is successful');
2713: END IF;
2714:
2715: IF (g_logLevel <= wip_constants.trace_logging) then
2716: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2717: p_procReturnStatus => l_return_status,
2718: p_msg => 'processed successfully',
2719: x_returnStatus => l_return_status);
2720: END IF;

Line 2729: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

2725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2726: wip_ws_util.trace_log('Came to unexpected error in wip_ws_ppmdkpi_conc_prog');
2727:
2728: IF (g_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2730: p_procReturnStatus => 2,
2731: p_msg => 'unexpected error FND_API.G_EXC_UNEXPECTED_ERROR' || SQLERRM,
2732: x_returnStatus => l_return_status);
2733: END IF;

Line 2740: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

2736: WHEN FND_API.G_EXC_ERROR THEN
2737: retcode := 1;
2738: wip_ws_util.trace_log('Came to expected error in wip_ws_ppmdkpi_conc_prog');
2739: IF (g_logLevel <= wip_constants.trace_logging) then
2740: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2741: p_procReturnStatus => 1,
2742: p_msg => 'unexpected error FND_API.G_EXC_ERROR' || SQLERRM,
2743: x_returnStatus => l_return_status);
2744: END IF;

Line 2751: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

2747: WHEN others THEN
2748: wip_ws_util.trace_log('Came to others error in wip_ws_ppmdkpi_conc_prog');
2749:
2750: IF (g_logLevel <= wip_constants.trace_logging) then
2751: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2752: p_procReturnStatus => 2,
2753: p_msg => 'unexpected error OTHERS' || SQLERRM,
2754: x_returnStatus => l_return_status);
2755: END IF;

Line 2765: l_params wip_logger.param_tbl_t;

2761: p_start_date DATE,
2762: p_org_id NUMBER,
2763: x_return_status OUT NOCOPY VARCHAR2) IS
2764:
2765: l_params wip_logger.param_tbl_t;
2766: l_return_status VARCHAR2(1);
2767:
2768: BEGIN
2769:

Line 2777: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',

2773: l_params(1).paramValue := p_start_date;
2774: l_params(2).paramName := 'p_org_id';
2775: l_params(2).paramValue := p_org_id;
2776:
2777: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',
2778: p_params => l_params,
2779: x_returnStatus => l_return_status);
2780:
2781: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 2837: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',

2833: and wdj1.status_type in (WIP_CONSTANTS.CLOSED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.COMP_NOCHRG)
2834: and wdj1.quantity_completed > 0) wdj;
2835:
2836: IF (g_logLevel <= wip_constants.trace_logging) then
2837: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',
2838: p_procReturnStatus => l_return_status,
2839: p_msg => 'processed successfully',
2840: x_returnStatus => l_return_status);
2841: END IF;

Line 2849: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',

2845: WHEN others THEN
2846: wip_ws_util.trace_log('Error in populate_ppm_defects_data');
2847:
2848: IF (g_logLevel <= wip_constants.trace_logging) then
2849: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',
2850: p_procReturnStatus => l_return_status,
2851: p_msg => 'processed error' || SQLERRM,
2852: x_returnStatus => l_return_status);
2853: END IF;