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

Line 158: l_params wip_logger.param_tbl_t;

154: p_charges_exist in number default NULL,
155: p_new_job in number default NULL) is
156:
157: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
158: l_params wip_logger.param_tbl_t;
159: l_retStatus VARCHAR2(1);
160: l_resTbls wip_infResSched_grp.op_res_rectbl_t;
161: l_repLineID NUMBER;
162: l_opTbl num_tbl_t := num_tbl_t();

Line 207: wip_logger.entryPoint(

203: l_params(6).paramValue := p_opSeqNum;
204: l_params(7).paramName := 'p_resSeqNum';
205: l_params(7).paramValue := p_resSeqNum;
206:
207: wip_logger.entryPoint(
208: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
209: p_params => l_params,
210: x_returnStatus => x_returnStatus);
211: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 222: wip_logger.log('reading lot based job...', l_retStatus);

218: fnd_msg_pub.initialize;
219: end if;
220:
221: if (l_logLevel <= wip_constants.full_logging) then
222: wip_logger.log('reading lot based job...', l_retStatus);
223: end if;
224:
225: l_copy_type := WSMPUTIL.get_internal_copy_type(p_wipEntityID);
226: if(l_copy_type = 3) then

Line 384: wip_logger.log('schedule: g_update_current_op = true', l_retStatus);

380: end if;
381:
382: if (l_logLevel <= wip_constants.full_logging) then
383: if g_update_current_op then
384: wip_logger.log('schedule: g_update_current_op = true', l_retStatus);
385: else
386: wip_logger.log('schedule: g_update_current_op = false', l_retStatus);
387: end if;
388: end if;

Line 386: wip_logger.log('schedule: g_update_current_op = false', l_retStatus);

382: if (l_logLevel <= wip_constants.full_logging) then
383: if g_update_current_op then
384: wip_logger.log('schedule: g_update_current_op = true', l_retStatus);
385: else
386: wip_logger.log('schedule: g_update_current_op = false', l_retStatus);
387: end if;
388: end if;
389: -- end bug 6345672
390:

Line 420: wip_logger.log(x_errorMsg, l_retStatus);

416: end if;
417: -- BA: BUG3195950
418: if(l_retCode = 1) then
419: x_errorMsg := 'Skip infinite scheduling for this job, no quantity.';
420: wip_logger.log(x_errorMsg, l_retStatus);
421: raise e_skip_sche;
422: end if;
423: -- EA: BUG3195950
424:

Line 426: wip_logger.log('scheduling lot based job...', l_retStatus);

422: end if;
423: -- EA: BUG3195950
424:
425: if (l_logLevel <= wip_constants.full_logging) then
426: wip_logger.log('scheduling lot based job...', l_retStatus);
427: end if;
428:
429: if(l_resTbls.opSeqNum.count <> 0) then
430: l_stmt_num := 50;

Line 446: wip_logger.log('writing lot based job...', l_retStatus);

442: raise fnd_api.g_exc_unexpected_error;
443: end if;
444:
445: if (l_logLevel <= wip_constants.full_logging) then
446: wip_logger.log('writing lot based job...', l_retStatus);
447: end if;
448: end if;
449:
450: l_stmt_num := 60;

Line 473: wip_logger.exitPoint(

469: end if;
470:
471: l_stmt_num := 70;
472: if (l_logLevel <= wip_constants.trace_logging) then
473: wip_logger.exitPoint(
474: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
475: p_procReturnStatus => x_returnStatus,
476: p_msg => 'success',
477: x_returnStatus => l_retStatus);

Line 479: wip_logger.cleanup(l_retStatus);

475: p_procReturnStatus => x_returnStatus,
476: p_msg => 'success',
477: x_returnStatus => l_retStatus);
478: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
479: wip_logger.cleanup(l_retStatus);
480: end if;
481: end if;
482:
483: exception

Line 506: wip_logger.exitPoint(

502: wip_utilities.get_message_stack(
503: p_msg => x_errorMsg,
504: p_delete_stack => fnd_api.g_false);
505: if (l_logLevel <= wip_constants.trace_logging) then
506: wip_logger.exitPoint(
507: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
508: p_procReturnStatus => x_returnStatus,
509: p_msg => 'error: ' || x_errorMsg,
510: x_returnStatus => l_retStatus);

Line 512: wip_logger.cleanup(l_retStatus);

508: p_procReturnStatus => x_returnStatus,
509: p_msg => 'error: ' || x_errorMsg,
510: x_returnStatus => l_retStatus);
511: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
512: wip_logger.cleanup(l_retStatus);
513: end if;
514: end if;
515: if(mrp_debug = 'Y') then
516: x_errorMsg := x_errorMsg || ' (# ' || l_stmt_num || ')';

Line 530: wip_logger.exitPoint(

526: wip_utilities.get_message_stack(
527: p_msg => x_errorMsg,
528: p_delete_stack => fnd_api.g_false);
529: if (l_logLevel <= wip_constants.trace_logging) then
530: wip_logger.exitPoint(
531: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
532: p_procReturnStatus => x_returnStatus,
533: p_msg => 'unexp error: ' || x_errorMsg,
534: x_returnStatus => l_retStatus);

Line 536: wip_logger.cleanup(l_retStatus);

532: p_procReturnStatus => x_returnStatus,
533: p_msg => 'unexp error: ' || x_errorMsg,
534: x_returnStatus => l_retStatus);
535: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
536: wip_logger.cleanup(l_retStatus);
537: end if;
538: end if;
539: if(mrp_debug = 'Y') then
540: x_errorMsg := x_errorMsg || ' (# ' || l_stmt_num || ')';

Line 568: l_params wip_logger.param_tbl_t;

564: p_new_job in number
565: ) is
566:
567: l_loglevel NUMBER := fnd_log.g_current_runtime_level;
568: l_params wip_logger.param_tbl_t;
569: l_retStatus VARCHAR2(1);
570: l_hrUOM VARCHAR2(3);
571: l_hrVal NUMBER;
572: l_uomClass VARCHAR2(10);

Line 848: wip_logger.entryPoint(

844: l_params(8).paramValue := p_strRecoSeqNum;
845: l_params(9).paramName := 'p_endRecoSeqNum';
846: l_params(9).paramValue := p_endRecoSeqNum;
847:
848: wip_logger.entryPoint(
849: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
850: p_params => l_params,
851: x_returnStatus => l_retStatus);
852: end if;

Line 1205: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

1201: end if;
1202: end if;
1203:
1204: if (l_logLevel <= wip_constants.trace_logging) then
1205: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1206: p_procReturnStatus => x_returnStatus,
1207: p_msg => 'success',
1208: x_returnStatus => l_retStatus);
1209: end if;

Line 1215: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

1211: EXCEPTION
1212: -- BA: BUG3195950
1213: when e_skip_sche then
1214: if (l_logLevel <= wip_constants.trace_logging) then
1215: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1216: p_procReturnStatus => x_returnStatus,
1217: p_msg => 'success',
1218: x_returnStatus => l_retStatus);
1219: end if;

Line 1229: wip_logger.exitPoint(

1225: p_pkg_name => 'wsm_infinite_scheduler_pvt',
1226: p_procedure_name => 'wsmJobReader',
1227: p_error_text => SQLERRM || ' (reader #' || l_stat_num || ')' );
1228: if (l_logLevel <= wip_constants.trace_logging) then
1229: wip_logger.exitPoint(
1230: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1231: p_procReturnStatus => x_returnStatus,
1232: p_msg => 'unexp error: ' || SQLERRM || ' (reader #' || l_stat_num || ')',
1233: x_returnStatus => l_retStatus);

Line 1279: l_params wip_logger.param_tbl_t;

1275: l_op_seq_incr number;
1276: l_curOp number;
1277: l_retStatus VARCHAR2(1);
1278: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1279: l_params wip_logger.param_tbl_t;
1280:
1281: --standard who columns
1282: l_sysDate DATE := sysdate;
1283: l_userID NUMBER := fnd_global.user_id;

Line 1322: wip_logger.entryPoint(

1318: l_params(9).paramName := 'p_resSeqNum';
1319: l_params(9).paramValue := p_resSeqNum;
1320:
1321:
1322: wip_logger.entryPoint(
1323: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
1324: p_params => l_params,
1325: x_returnStatus => l_retStatus);
1326: end if;

Line 1588: wip_logger.log('wrote job', l_retStatus);

1584: where wip_entity_id = p_wipEntityID
1585: and organization_id = p_orgID;
1586:
1587: if(l_logLevel <= wip_constants.full_logging) then
1588: wip_logger.log('wrote job', l_retStatus);
1589: end if;
1590: end if;
1591:
1592:

Line 1614: wip_logger.log('wrote WO', l_retStatus);

1610: where wip_entity_id = p_wipEntityID
1611: and organization_id = p_orgID
1612: and operation_seq_num = -p_opTbl(i);
1613: if(l_logLevel <= wip_constants.full_logging) then
1614: wip_logger.log('wrote WO', l_retStatus);
1615: end if;
1616:
1617:
1618: l_stat_num := 80;

Line 1637: wip_logger.log('wrote WCO', l_retStatus);

1633: where wip_entity_id = p_wipEntityID
1634: and organization_id = p_orgID
1635: and operation_seq_num = p_opTbl(i);
1636: if(l_logLevel <= wip_constants.full_logging) then
1637: wip_logger.log('wrote WCO', l_retStatus);
1638: end if;
1639:
1640: --bug 6345672: begin
1641: l_stat_num := 85;

Line 1660: wip_logger.log('wrote WCO for current op', l_retStatus);

1656: and organization_id = p_orgID
1657: and operation_seq_num = -p_opTbl(l_cnt_wo);
1658:
1659: if(l_logLevel <= wip_constants.full_logging) then
1660: wip_logger.log('wrote WCO for current op', l_retStatus);
1661: end if;
1662: end if;
1663: --bug 6345672: end
1664:

Line 1683: wip_logger.log('wrote WRO', l_retStatus);

1679: where wip_entity_id = p_wipEntityID
1680: and organization_id = p_orgID
1681: and operation_seq_num = -p_opTbl(i);
1682: if(l_logLevel <= wip_constants.full_logging) then
1683: wip_logger.log('wrote WRO', l_retStatus);
1684: end if;
1685:
1686: l_stat_num := 100;
1687: --update mtl requirement dates WCRO

Line 1703: wip_logger.log('wrote WCRO', l_retStatus);

1699: where wip_entity_id = p_wipEntityID
1700: and organization_id = p_orgID
1701: and operation_seq_num = p_opTbl(i);
1702: if(l_logLevel <= wip_constants.full_logging) then
1703: wip_logger.log('wrote WCRO', l_retStatus);
1704: end if;
1705:
1706: --bug 6345672: begin
1707: l_stat_num := 105;

Line 1724: wip_logger.log('wrote WCRO for current op', l_retStatus);

1720: and organization_id = p_orgID
1721: and operation_seq_num = -p_opTbl(l_cnt_wo);
1722:
1723: if(l_logLevel <= wip_constants.full_logging) then
1724: wip_logger.log('wrote WCRO for current op', l_retStatus);
1725: end if;
1726: end if;
1727: --bug 6345672: end
1728:

Line 1759: wip_logger.log('wrote WOR', l_retStatus);

1755: and organization_id = p_orgID
1756: and operation_seq_num = -x_resTbls.opSeqNum(i)
1757: and resource_seq_num = x_resTbls.resSeqNum(i);
1758: if(l_logLevel <= wip_constants.full_logging) then
1759: wip_logger.log('wrote WOR', l_retStatus);
1760: end if;
1761:
1762: l_stat_num := 120;
1763: --update resources (WCOR)

Line 1781: wip_logger.log('wrote WCOR', l_retStatus);

1777: and organization_id = p_orgID
1778: and operation_seq_num = x_resTbls.opSeqNum(i)
1779: and resource_seq_num = x_resTbls.resSeqNum(i);
1780: if(l_logLevel <= wip_constants.full_logging) then
1781: wip_logger.log('wrote WCOR', l_retStatus);
1782: end if;
1783:
1784: --bug 6345672: begin
1785: l_stat_num := 125;

Line 1804: wip_logger.log('wrote WCOR for current op', l_retStatus);

1800: and operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
1801: and resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
1802:
1803: if(l_logLevel <= wip_constants.full_logging) then
1804: wip_logger.log('wrote WCOR for current op', l_retStatus);
1805: end if;
1806: end if;
1807: --bug 6345672: end
1808:

Line 1825: wip_logger.log('wrote WORI', l_retStatus);

1821: and organization_id = p_orgID
1822: and operation_seq_num = -x_resTbls.opSeqNum(i)
1823: and resource_seq_num = x_resTbls.resSeqNum(i);
1824: if(l_logLevel <= wip_constants.full_logging) then
1825: wip_logger.log('wrote WORI', l_retStatus);
1826: end if;
1827:
1828: l_stat_num := 140;
1829: --update resources instances (WCORI)

Line 1843: wip_logger.log('wrote WCORI', l_retStatus);

1839: and organization_id = p_orgID
1840: and operation_seq_num = x_resTbls.opSeqNum(i)
1841: and resource_seq_num = x_resTbls.resSeqNum(i);
1842: if(l_logLevel <= wip_constants.full_logging) then
1843: wip_logger.log('wrote WCORI', l_retStatus);
1844: end if;
1845:
1846: --bug 6345672: begin
1847: l_stat_num := 145;

Line 1861: wip_logger.log('wrote WCORI for current op', l_retStatus);

1857: and organization_id = p_orgID
1858: and operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
1859: and resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
1860: if(l_logLevel <= wip_constants.full_logging) then
1861: wip_logger.log('wrote WCORI for current op', l_retStatus);
1862: end if;
1863: end if;
1864: --bug 6345672: end
1865:

Line 1920: wip_logger.log('wrote WORU', l_retStatus);

1916: l_sysdate);
1917: end if;
1918: end loop;
1919: if(l_logLevel <= wip_constants.full_logging) then
1920: wip_logger.log('wrote WORU', l_retStatus);
1921: end if;
1922:
1923: l_stat_num := 170;
1924: forall i in 1..l_cnt_wor

Line 1976: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WROU', l_retStatus);

1972: and woru.organization_id = p_orgID
1973: and wori.operation_seq_num = -x_resTbls.opSeqNum(i)
1974: and wori.resource_seq_num = x_resTbls.resSeqNum(i);
1975: if(l_logLevel <= wip_constants.full_logging) then
1976: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WROU', l_retStatus);
1977: end if;
1978:
1979:
1980: l_stat_num := 180;

Line 2043: wip_logger.log('wrote WCORU', l_retStatus);

2039: l_sysdate);
2040: end if;
2041: end loop;
2042: if(l_logLevel <= wip_constants.full_logging) then
2043: wip_logger.log('wrote WCORU', l_retStatus);
2044: end if;
2045:
2046: --bug 6345672: begin
2047: l_stat_num := 195;

Line 2091: wip_logger.log('wrote WCORU for current op', l_retStatus);

2087: l_sysdate);
2088: end if;
2089:
2090: if(l_logLevel <= wip_constants.full_logging) then
2091: wip_logger.log('wrote WCORU for current op', l_retStatus);
2092: end if;
2093: end if;
2094: --bug 6345672: end
2095:

Line 2149: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU', l_retStatus);

2145: and wcoru.organization_id = p_orgID
2146: and wcori.operation_seq_num = x_resTbls.opSeqNum(i)
2147: and wcori.resource_seq_num = x_resTbls.resSeqNum(i);
2148: if(l_logLevel <= wip_constants.full_logging) then
2149: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU', l_retStatus);
2150: end if;
2151:
2152: --bug 6345672: begin
2153: l_stat_num := 205;

Line 2206: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU for current op', l_retStatus);

2202: and wcoru.organization_id = p_orgID
2203: and wcori.operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
2204: and wcori.resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
2205: if(l_logLevel <= wip_constants.full_logging) then
2206: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU for current op', l_retStatus);
2207: end if;
2208:
2209: end if;
2210: --bug 6345672: end

Line 2215: wip_logger.exitPoint(

2211:
2212: end if;
2213:
2214: if (l_logLevel <= wip_constants.trace_logging) then
2215: wip_logger.exitPoint(
2216: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2217: p_procReturnStatus => x_returnStatus,
2218: p_msg => 'success',
2219: x_returnStatus => l_retStatus);

Line 2231: wip_logger.exitPoint(

2227: p_pkg_name => 'wsm_infinite_scheduler_pvt',
2228: p_procedure_name => 'wsmJobWriter',
2229: p_error_text => SQLERRM || ' (writer #' || l_stat_num || ')' );
2230: if (l_logLevel <= wip_constants.trace_logging) then
2231: wip_logger.exitPoint(
2232: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2233: p_procReturnStatus => x_returnStatus,
2234: p_msg => 'unexp error: ' || SQLERRM || ' (writer #' || l_stat_num || ')',
2235: x_returnStatus => l_retStatus);