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 1585: wip_logger.log('wrote job', l_retStatus);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2212: wip_logger.exitPoint(

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

Line 2228: wip_logger.exitPoint(

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