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_EMBEDDED_ANALYTICS_PK

Line 1: PACKAGE BODY wip_ws_embedded_analytics_pk AS

1: PACKAGE BODY wip_ws_embedded_analytics_pk AS
2: /* $Header: wipwseab.pls 120.18 2008/05/29 23:59:37 ankohli noship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 2007 Oracle Corporation Redwood Shore, California, USA |

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 182: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id, wmt.transaction_date) as shift_info,

178: fm_intraoperation_step_type
179: FROM
180: (
181: SELECT
182: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id, wmt.transaction_date) as shift_info,
183: wmt.*
184: FROM
185: wip_move_transactions wmt
186: WHERE

Line 314: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,wop.department_id, wmt.transaction_date) as shift_info

310: wmt.fm_intraoperation_step_type,
311: wmt.to_intraoperation_step_type,
312: wmt.primary_quantity,
313: wmt.transaction_date,
314: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,wop.department_id, wmt.transaction_date) as shift_info
315: FROM
316: wip_move_transactions wmt,
317: wip_operations wop
318: WHERE

Line 377: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id

373: fm_intraoperation_step_type
374: FROM
375: (
376: SELECT
377: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id
378: ,(case when wmt.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP then wmt.to_department_id else wmt.fm_department_id end)
379: ,wmt.transaction_date) as shift_info,
380: transaction_date,
381: wip_entity_id,

Line 426: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,(

422: abs(mod(trunc(shift_info),100)) as shift_num,
423: wip_entity_id,operation_seq_num
424: FROM (
425: SELECT
426: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,(
427: case when (wmt.TO_DEPARTMENT_ID =WIP_CONSTANTS.SCRAP AND wop.operation_seq_num = wmt.fm_operation_seq_num) then wmt.to_department_id else wmt.fm_department_id end),wmt.transaction_date) as shift_info,
428: wop.wip_entity_id, wop.operation_seq_num,
429: wmt.transaction_date,wmt.primary_quantity,wmt.to_intraoperation_step_type,wmt.fm_intraoperation_step_type,fm_operation_seq_num,to_operation_seq_num
430: FROM

Line 481: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id

477: fm_intraoperation_step_type
478: FROM
479: (
480: SELECT
481: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id
482: ,(case when wmt.to_intraoperation_step_type = WIP_CONSTANTS.REJECT then wmt.to_department_id else wmt.fm_department_id end)
483: ,wmt.transaction_date) as shift_info ,
484: wmt.*
485: FROM

Line 549: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,null, wmt.transaction_date) as shift_info

545: wmt.fm_intraoperation_step_type,
546: wmt.to_intraoperation_step_type,
547: wmt.primary_quantity,
548: wmt.transaction_date,
549: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,null, wmt.transaction_date) as shift_info
550: FROM
551: wip_move_transactions wmt,
552: wip_operations wop
553: WHERE

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 645: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_day_shift';

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),
649: p_proc_name => l_proc_name,

Line 681: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_day';

677: p_org_id NUMBER,
678: x_return_status OUT NOCOPY VARCHAR2) IS
679:
680: l_return_status VARCHAR2(1);
681: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_day';
682: BEGIN
683:
684: 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),
685: p_proc_name => l_proc_name,

Line 743: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_week';

739: p_org_id NUMBER,
740: x_return_status OUT NOCOPY VARCHAR2) IS
741:
742: l_return_status VARCHAR2(1);
743: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_week';
744: BEGIN
745:
746: 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),
747: p_proc_name => l_proc_name,

Line 805: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_week_shift';

801: p_org_id NUMBER,
802: x_return_status OUT NOCOPY VARCHAR2) IS
803:
804: l_return_status VARCHAR2(1);
805: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_jobop_week_shift';
806: BEGIN
807:
808: 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),
809: p_proc_name => l_proc_name,

Line 867: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day';

863: p_org_id NUMBER,
864: x_return_status OUT NOCOPY VARCHAR2) IS
865:
866: l_return_status VARCHAR2(1);
867: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day';
868: BEGIN
869:
870: 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),
871: p_proc_name => l_proc_name,

Line 892: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day';

888: p_org_id NUMBER,
889: x_return_status OUT NOCOPY VARCHAR2) IS
890:
891: l_return_status VARCHAR2(1);
892: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day';
893: BEGIN
894:
895: 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),
896: p_proc_name => l_proc_name,

Line 974: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day_shift';

970: p_org_id NUMBER,
971: x_return_status OUT NOCOPY VARCHAR2) IS
972:
973: l_return_status VARCHAR2(1);
974: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_day_shift';
975: BEGIN
976:
977: 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),
978: p_proc_name => l_proc_name,

Line 1096: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_week';

1092: p_org_id NUMBER,
1093: x_return_status OUT NOCOPY VARCHAR2) IS
1094:
1095: l_return_status VARCHAR2(1);
1096: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_week';
1097: BEGIN
1098:
1099: 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),
1100: p_proc_name => l_proc_name,

Line 1177: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_week_shift';

1173: p_org_id NUMBER,
1174: x_return_status OUT NOCOPY VARCHAR2) IS
1175:
1176: l_return_status VARCHAR2(1);
1177: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_job_week_shift';
1178: BEGIN
1179:
1180: 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),
1181: p_proc_name => l_proc_name,

Line 1258: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_day_shift';

1254: p_org_id NUMBER,
1255: x_return_status OUT NOCOPY VARCHAR2) IS
1256:
1257: l_return_status VARCHAR2(1);
1258: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_day_shift';
1259: BEGIN
1260:
1261: 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),
1262: p_proc_name => l_proc_name,

Line 1312: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_day';

1308: p_org_id NUMBER,
1309: x_return_status OUT NOCOPY VARCHAR2) IS
1310:
1311: l_return_status VARCHAR2(1);
1312: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_day';
1313: BEGIN
1314:
1315: 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),
1316: p_proc_name => l_proc_name,

Line 1365: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_week_shift';

1361: p_org_id NUMBER,
1362: x_return_status OUT NOCOPY VARCHAR2) IS
1363:
1364: l_return_status VARCHAR2(1);
1365: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_week_shift';
1366: BEGIN
1367:
1368: 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),
1369: p_proc_name => l_proc_name,

Line 1417: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_week';

1413: p_org_id NUMBER,
1414: x_return_status OUT NOCOPY VARCHAR2) IS
1415:
1416: l_return_status VARCHAR2(1);
1417: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_assm_week';
1418: BEGIN
1419:
1420: 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),
1421: p_proc_name => l_proc_name,

Line 1470: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_day_shift';

1466: p_org_id NUMBER,
1467: x_return_status OUT NOCOPY VARCHAR2) IS
1468:
1469: l_return_status VARCHAR2(1);
1470: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_day_shift';
1471: BEGIN
1472:
1473: 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),
1474: p_proc_name => l_proc_name,

Line 1528: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_day';

1524: p_org_id NUMBER,
1525: x_return_status OUT NOCOPY VARCHAR2) IS
1526:
1527: l_return_status VARCHAR2(1);
1528: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_day';
1529: BEGIN
1530:
1531: 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),
1532: p_proc_name => l_proc_name,

Line 1587: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_week_shift';

1583: p_org_id NUMBER,
1584: x_return_status OUT NOCOPY VARCHAR2) IS
1585:
1586: l_return_status VARCHAR2(1);
1587: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_week_shift';
1588: BEGIN
1589:
1590: 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),
1591: p_proc_name => l_proc_name,

Line 1644: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_week';

1640: p_org_id NUMBER,
1641: x_return_status OUT NOCOPY VARCHAR2) IS
1642:
1643: l_return_status VARCHAR2(1);
1644: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_per_dept_week';
1645: BEGIN
1646:
1647: 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),
1648: p_proc_name => l_proc_name,

Line 1701: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_day_shift';

1697: p_org_id NUMBER,
1698: x_return_status OUT NOCOPY VARCHAR2) IS
1699:
1700: l_return_status VARCHAR2(1);
1701: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_day_shift';
1702: BEGIN
1703:
1704: 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),
1705: p_proc_name => l_proc_name,

Line 1760: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_day';

1756: p_org_id NUMBER,
1757: x_return_status OUT NOCOPY VARCHAR2) IS
1758:
1759: l_return_status VARCHAR2(1);
1760: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_day';
1761: BEGIN
1762:
1763: 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),
1764: p_proc_name => l_proc_name,

Line 1821: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_week_shift';

1817: p_org_id NUMBER,
1818: x_return_status OUT NOCOPY VARCHAR2) IS
1819:
1820: l_return_status VARCHAR2(1);
1821: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_week_shift';
1822: BEGIN
1823:
1824: 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),
1825: p_proc_name => l_proc_name,

Line 1880: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_week';

1876: p_org_id NUMBER,
1877: x_return_status OUT NOCOPY VARCHAR2) IS
1878:
1879: l_return_status VARCHAR2(1);
1880: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_all_depts_week';
1881: BEGIN
1882:
1883: 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),
1884: p_proc_name => l_proc_name,

Line 1938: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_jobop_all';

1934: p_cutoff_date DATE,
1935: p_org_id NUMBER,
1936: x_return_status OUT NOCOPY VARCHAR2) IS
1937:
1938: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_jobop_all';
1939: BEGIN
1940:
1941: 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),
1942: p_proc_name => l_proc_name,

Line 1992: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_job_all';

1988: p_cutoff_date DATE,
1989: p_org_id NUMBER,
1990: x_return_status OUT NOCOPY VARCHAR2) IS
1991:
1992: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_job_all';
1993: BEGIN
1994:
1995: 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),
1996: p_proc_name => l_proc_name,

Line 2040: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_assm_all';

2036: p_cutoff_date DATE,
2037: p_org_id NUMBER,
2038: x_return_status OUT NOCOPY VARCHAR2) IS
2039:
2040: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_assm_all';
2041: BEGIN
2042:
2043: 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),
2044: p_proc_name => l_proc_name,

Line 2088: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_dept_all';

2084: p_cutoff_date DATE,
2085: p_org_id NUMBER,
2086: x_return_status OUT NOCOPY VARCHAR2) IS
2087:
2088: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_dept_all';
2089:
2090: BEGIN
2091:
2092: 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 2136: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_all_depts_all';

2132: p_cutoff_date DATE,
2133: p_org_id NUMBER,
2134: x_return_status OUT NOCOPY VARCHAR2) IS
2135:
2136: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.calc_fpy_for_all_depts_all';
2137: BEGIN
2138:
2139: 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),
2140: p_proc_name => l_proc_name,

Line 2198: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.get_start_shift_date_to_calc';

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:
2201: l_params(1).paramName := 'p_org_id';
2202: l_params(1).paramValue := p_org_id;

Line 2353: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.delete_old_and_replacing_data';

2349: p_org_id NUMBER,
2350: x_return_status OUT NOCOPY VARCHAR2) IS
2351:
2352: l_return_status VARCHAR2(1);
2353: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.delete_old_and_replacing_data';
2354: BEGIN
2355:
2356: begin_log (p_params => set_calc_param(p_execution_date => p_calc_start_date,p_cutoff_date => p_retention_boundary,p_org_id => p_org_id),
2357: p_proc_name => l_proc_name,

Line 2408: l_proc_name VARCHAR2(60) :='wip_ws_embedded_analytics_pk.wip_ws_fpykpi_conc_prog';

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;
2412:

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 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 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 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 2811: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_num(shift_info) shift_num, -- SHIFT_NUM

2807: select
2808: wdj.organization_id, -- ORGANIZATION_ID
2809: wdj.wip_entity_id, -- WIP_ENTITY_ID
2810: wdj.primary_item_id, -- INVENTORY_ITEM_ID
2811: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_num(shift_info) shift_num, -- SHIFT_NUM
2812: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_start_date(shift_info) shift_date, -- SHIFT_DATE
2813: wdj.quantity_scrapped, -- qty_defected
2814: wdj.quantity_completed + wdj.quantity_scrapped, -- qty_produced
2815: sysdate, --LAST_UPDATE_DATE,

Line 2812: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_start_date(shift_info) shift_date, -- SHIFT_DATE

2808: wdj.organization_id, -- ORGANIZATION_ID
2809: wdj.wip_entity_id, -- WIP_ENTITY_ID
2810: wdj.primary_item_id, -- INVENTORY_ITEM_ID
2811: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_num(shift_info) shift_num, -- SHIFT_NUM
2812: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_start_date(shift_info) shift_date, -- SHIFT_DATE
2813: wdj.quantity_scrapped, -- qty_defected
2814: wdj.quantity_completed + wdj.quantity_scrapped, -- qty_produced
2815: sysdate, --LAST_UPDATE_DATE,
2816: g_user_id, --LAST_UPDATED_BY,

Line 2826: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_info_for_date(

2822: g_prog_appid,--PROGRAM_APPLICATION_ID,
2823: sysdate --PROGRAM_UPDATE_DATE
2824: from
2825: (select
2826: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_info_for_date(
2827: wdj1.organization_id, null, null,
2828: nvl(wdj1.date_completed, wdj1.date_closed)) shift_info,
2829: wdj1.*
2830: from wip_discrete_jobs wdj1

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;

Line 2858: END wip_ws_embedded_analytics_pk;

2854:
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: END populate_ppm_defects_data;
2857:
2858: END wip_ws_embedded_analytics_pk;
2859: