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_WS_UTIL

Line 65: wip_ws_util.trace_log('Error in ' || p_proc_name);

61: PROCEDURE exception_log(p_proc_name VARCHAR2,
62: p_return_status OUT NOCOPY VARCHAR2) IS
63: l_return_status varchar2(1);
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,

Line 354: wip_ws_util.trace_log('Finish Inserting QUANTITY_COMPLETED');

350:
351: WHERE wdj.wip_entity_id = completed_info.wip_entity_id
352: AND wdj.organization_id = p_org_id;
353:
354: wip_ws_util.trace_log('Finish Inserting QUANTITY_COMPLETED');
355: --------------------------- Update QUANTITY_SCRAPPED ------------------------------------
356: UPDATE
357: wip_ws_fpy fpy
358: SET

Line 412: wip_ws_util.trace_log('Finish Updating QUANTITY_SCRAPPED');

408: AND fpy.organization_id = p_org_id
409:
410: GROUP BY wmt.shift_start_date, wmt.shift_num, wop.wip_entity_id, wop.operation_seq_num),0);
411:
412: wip_ws_util.trace_log('Finish Updating QUANTITY_SCRAPPED');
413:
414: /* This QUERY works too, if the above SQL turn bad in performance try this one
415: SELECT
416: NVL(SUM(DECODE(operation_seq_num,to_operation_seq_num,DECODE(to_intraoperation_step_type,WIP_CONSTANTS.SCRAP, primary_quantity,0),0)

Line 598: wip_ws_util.trace_log('Finish Updating QUANTITY_REJECTED');

594: AND fpy.shift_date = post_cal.shift_start_date
595: AND fpy.organization_id = p_org_id
596: GROUP BY post_cal.shift_start_date, post_cal.shift_num, wop.wip_entity_id, wop.operation_seq_num),0);
597: */
598: wip_ws_util.trace_log('Finish Updating QUANTITY_REJECTED');
599: ------------------------------------ update QUANTITY_FIRST_PASS ------------------------------------
600: /*
601: UPDATE
602: wip_ws_fpy fpy

Line 609: wip_ws_util.trace_log('Finish Updating QUANTITY_FIRST_PASS');

605: WHERE
606: LAST_UPDATE_DATE = p_execution_date
607: AND organization_id = p_org_id;
608:
609: wip_ws_util.trace_log('Finish Updating QUANTITY_FIRST_PASS');
610: */
611: -------------------------------------- end of population logic -------------------------------------------------------
612:
613: IF (g_logLevel <= wip_constants.trace_logging) then

Line 622: wip_ws_util.trace_log('Error in populate_fpy_raw_data');

618: END IF;
619:
620: EXCEPTION
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,

Line 2320: wip_ws_util.retrieve_first_shift(

2316: WHEN others THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END;
2319:
2320: wip_ws_util.retrieve_first_shift(
2321: p_org_id,
2322: p_department_id,
2323: null,
2324: l_start_move_tran_date_to_calc,

Line 2425: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));

2421: p_proc_name => l_proc_name,
2422: p_return_status => l_return_status);
2423:
2424:
2425: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));
2426: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));
2427:
2428: SAVEPOINT wip_ws_fpykpi_calc;
2429:

Line 2426: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));

2422: p_return_status => l_return_status);
2423:
2424:
2425: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));
2426: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));
2427:
2428: SAVEPOINT wip_ws_fpykpi_calc;
2429:
2430:

Line 2431: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(

2427:
2428: SAVEPOINT wip_ws_fpykpi_calc;
2429:
2430:
2431: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(
2432: p_program_application_id => fnd_global.prog_appl_id,
2433: p_concurrent_program_id => fnd_global.conc_program_id,
2434: p_org_id => p_org_id);
2435:

Line 2437: wip_ws_util.log_for_duplicate_concurrent (

2433: p_concurrent_program_id => fnd_global.conc_program_id,
2434: p_org_id => p_org_id);
2435:
2436: if l_concurrent_count > 1 then
2437: wip_ws_util.log_for_duplicate_concurrent (
2438: p_org_id => p_org_id,
2439: p_program_name => 'First Pass Yield KPI');
2440: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Errors encountered in calculation program, please check the log file.');
2441: return;

Line 2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');

2476: x_return_status => l_return_status);
2477:
2478:
2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;

Line 2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');

2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSE
2486: wip_ws_util.trace_log('populate_fpy_raw_data is successfull');
2487: END IF;

Line 2486: wip_ws_util.trace_log('populate_fpy_raw_data is successfull');

2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSE
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',

Line 2505: wip_ws_util.trace_log('Came to expected error in wip_ws_fpykpi_conc_prog');

2501: ROLLBACK TO wip_ws_fpykpi_calc;
2502: retcode := 2; -- End with error
2503: WHEN FND_API.G_EXC_ERROR THEN
2504: retcode := 1;
2505: wip_ws_util.trace_log('Came to expected error in wip_ws_fpykpi_conc_prog');
2506: ROLLBACK TO wip_ws_fpykpi_calc;
2507: WHEN others THEN
2508: wip_ws_util.trace_log('Came to others error in wip_ws_fpykpi_conc_prog');
2509: ROLLBACK TO wip_ws_fpykpi_calc;

Line 2508: wip_ws_util.trace_log('Came to others error in wip_ws_fpykpi_conc_prog');

2504: retcode := 1;
2505: wip_ws_util.trace_log('Came to expected error in wip_ws_fpykpi_conc_prog');
2506: ROLLBACK TO wip_ws_fpykpi_calc;
2507: WHEN others THEN
2508: wip_ws_util.trace_log('Came to others error in wip_ws_fpykpi_conc_prog');
2509: ROLLBACK TO wip_ws_fpykpi_calc;
2510: retcode := 2; -- End with error
2511: END wip_ws_fpykpi_conc_prog;
2512:

Line 2526: wip_ws_util.retrieve_first_shift(

2522: l_shift_string VARCHAR2(100);
2523: l_date_diff NUMBER;
2524: l_return NUMBER;
2525: BEGIN
2526: wip_ws_util.retrieve_first_shift(
2527: p_org_id => p_org_id,
2528: p_dept_id => p_department_id,
2529: p_resource_id => null,
2530: p_date => p_transaction_date,

Line 2557: shift definition as defined in the wip_ws_util package.

2553: /*
2554: Description:
2555: Given the organization, department, resource, and a timestamp,
2556: find out which shift the timestamp belongs to. It uses the existing
2557: shift definition as defined in the wip_ws_util package.
2558: Parameters:
2559: p_org_id - the organization id
2560: p_dept_id - the department id
2561: p_resource_id - the resource id

Line 2585: wip_ws_util.retrieve_first_shift(

2581: x_shift_start_date date;
2582: x_shift_end_date date;
2583: x_shift_string varchar2(100);
2584: begin
2585: wip_ws_util.retrieve_first_shift(
2586: p_org_id => p_org_id,
2587: p_dept_id => p_dept_id,
2588: p_resource_id => p_resource_id,
2589: p_date => p_date,

Line 2676: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));

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));
2677: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));
2678:
2679:
2680: SAVEPOINT wip_ws_ppmdkpi_calc;

Line 2677: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));

2673:
2674: END IF;
2675:
2676: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));
2677: wip_ws_util.trace_log('Start time = '||to_char(l_concurrent_execution_date));
2678:
2679:
2680: SAVEPOINT wip_ws_ppmdkpi_calc;
2681:

Line 2683: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(

2679:
2680: SAVEPOINT wip_ws_ppmdkpi_calc;
2681:
2682:
2683: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(
2684: p_program_application_id => fnd_global.prog_appl_id,
2685: p_concurrent_program_id => fnd_global.conc_program_id,
2686: p_org_id => p_org_id);
2687:

Line 2689: wip_ws_util.log_for_duplicate_concurrent (

2685: p_concurrent_program_id => fnd_global.conc_program_id,
2686: p_org_id => p_org_id);
2687:
2688: if l_concurrent_count > 1 then
2689: wip_ws_util.log_for_duplicate_concurrent (
2690: p_org_id => p_org_id,
2691: p_program_name => 'Parts Per Million Defects KPI');
2692: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Errors encountered in calculation program, please check the log file.');
2693: return;

Line 2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');

2702: p_org_id => p_org_id,
2703: x_return_status => l_return_status);
2704:
2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;

Line 2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');

2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;
2711: ELSE
2712: wip_ws_util.trace_log('populate_fpy_raw_data is successful');
2713: END IF;

Line 2712: wip_ws_util.trace_log('populate_fpy_raw_data is successful');

2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;
2711: ELSE
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',

Line 2726: wip_ws_util.trace_log('Came to unexpected error in wip_ws_ppmdkpi_conc_prog');

2722: EXCEPTION
2723:
2724:
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,

Line 2738: wip_ws_util.trace_log('Came to expected error in wip_ws_ppmdkpi_conc_prog');

2734: ROLLBACK TO wip_ws_ppmdkpi_calc;
2735: retcode := 2; -- End with error
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,

Line 2748: wip_ws_util.trace_log('Came to others error in wip_ws_ppmdkpi_conc_prog');

2744: END IF;
2745:
2746: ROLLBACK TO wip_ws_ppmdkpi_calc;
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,

Line 2846: wip_ws_util.trace_log('Error in populate_ppm_defects_data');

2842:
2843: EXCEPTION
2844:
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,