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_JOBCLOSE_PRIV dependencies on FND_LOG

Line 31: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

27:
28: l_params wip_logger.param_tbl_t;
29: l_return_Status VARCHAR2(1);
30: l_msg VARCHAR(240);
31: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
32: l_number_temp NUMBER ;
33:
34: BEGIN
35: x_returnStatus := fnd_api.g_ret_sts_success;

Line 172: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

168:
169: --
170: -- Bug 5345660 exitPoint for normal exit.
171: --
172: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
173: wip_logger.exitPoint(
174: p_procName => 'wip_close_priv.populate_close_temp',
175: p_procReturnStatus => x_returnStatus,
176: p_msg => 'procedure normal exit',

Line 218: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

214: x_act_close_date OUT NOCOPY DATE ,
215: x_returnstatus OUT NOCOPY VARCHAR2
216: )IS
217: l_params wip_logger.param_tbl_t;
218: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
219: l_return_status VARCHAR2(1) ;
220: l_msg_count NUMBER ;
221: l_msg_data VARCHAR2(200);
222: l_msg VARCHAR(240);

Line 344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:
344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
345: wip_logger.exitPoint(
346: p_procName => 'wip_close_priv.time_zone_conversions',
347: p_procReturnStatus => x_returnStatus,
348: p_msg => 'procedure normal exit',

Line 356: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
355:
356: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
357: wip_logger.exitPoint(
358: p_procName=>'wip_close_priv.time_zone_conversions',
359: p_procReturnStatus => x_returnStatus,
360: p_msg => l_msg,

Line 388: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

384: l_failed_ids dbms_sql.number_table;
385:
386: BEGIN
387:
388: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
389: l_params(1).paramName := 'p_organization_id';
390: l_params(1).paramValue := p_organization_id;
391: l_params(2).paramName := 'p_group_id';
392: l_params(2).paramValue := p_group_id;

Line 443: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

439:
440: --
441: -- Bug 5345660 exitPoint for normal exit.
442: --
443: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
444: wip_logger.exitPoint(
445: p_procName => 'wip_close_priv.prior_date_release',
446: p_procReturnStatus => x_returnStatus,
447: p_msg => 'procedure normal exit',

Line 456: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

452: WHEN others THEN
453: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
454: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
455:
456: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
457: wip_logger.exitPoint(
458: p_procName=>'wip_close_priv.prior_date_release',
459: p_procReturnStatus => x_returnStatus,
460: p_msg => l_msg,

Line 480: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

476: IS
477: l_params wip_logger.param_tbl_t;
478: l_return_Status VARCHAR2(1);
479: l_msg VARCHAR(240);
480: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
481:
482: CURSOR c_pending_txns IS
483: SELECT WIP_ENTITY_NAME
484: FROM WIP_DJ_CLOSE_TEMP

Line 585: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

581:
582: --
583: -- Bug 5345660 exitPoint for normal exit.
584: --
585: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
586: wip_logger.exitPoint(
587: p_procName => 'wip_close_priv.pending_txns',
588: p_procReturnStatus => x_returnStatus,
589: p_msg => 'procedure normal exit',

Line 677: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

673: l_msg_data VARCHAR2(2000);
674: l_params wip_logger.param_tbl_t;
675: l_return_Status VARCHAR2(1);
676: l_msg VARCHAR(240);
677: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
678: l_failed_counter NUMBER ;
679: BEGIN
680: IF (l_logLevel <= wip_constants.trace_logging) THEN
681: l_params(1).paramName := 'p_organization_id';

Line 727: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

723:
724: --
725: -- Bug 5345660 exitPoint for normal exit.
726: --
727: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
728: wip_logger.exitPoint(
729: p_procName => 'wip_close_priv.pending_clocks',
730: p_procReturnStatus => x_returnStatus,
731: p_msg => 'procedure normal exit',

Line 871: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

867:
868: l_params wip_logger.param_tbl_t;
869: l_return_Status VARCHAR2(1);
870: l_msg VARCHAR(240);
871: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
872:
873: CURSOR c_pending_txns IS
874: SELECT WIP_ENTITY_NAME
875: FROM WIP_DJ_CLOSE_TEMP

Line 952: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

948:
949: --
950: -- Bug 5345660 exitPoint for normal exit.
951: --
952: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
953: wip_logger.exitPoint(
954: p_procName => 'wip_close_priv.past_close_date',
955: p_procReturnStatus => x_returnStatus,
956: p_msg => 'procedure normal exit',

Line 989: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

985:
986: l_params wip_logger.param_tbl_t;
987: l_return_Status VARCHAR2(1);
988: l_msg VARCHAR(240);
989: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
990:
991: CURSOR c_open_po IS
992: SELECT WIP_ENTITY_NAME
993: FROM WIP_DJ_CLOSE_TEMP WDCT

Line 1075: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1071:
1072: --
1073: -- Bug 5345660 exitPoint for normal exit.
1074: --
1075: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1076: wip_logger.exitPoint(
1077: p_procName => 'wip_close_priv.check_open_po',
1078: p_procReturnStatus => x_returnStatus,
1079: p_msg => 'procedure normal exit',

Line 1117: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1113: l_wsm_org number ;
1114: l_return_status Varchar2(1);
1115: l_params wip_logger.param_tbl_t;
1116: l_msg VARCHAR(240);
1117: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1118:
1119: BEGIN
1120: x_returnStatus := fnd_api.g_ret_sts_success;
1121: fnd_file.put_line(FND_FILE.LOG,'lot validate');

Line 1146: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1142:
1143: --
1144: -- Bug 5345660 exitPoint for normal exit.
1145: --
1146: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1147: wip_logger.exitPoint(
1148: p_procName => 'wip_close_priv.lot_validate',
1149: p_procReturnStatus => x_returnStatus,
1150: p_msg => 'procedure normal exit',

Line 1182: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1178: IS
1179: l_params wip_logger.param_tbl_t;
1180: l_return_Status VARCHAR2(1);
1181: l_msg VARCHAR(240);
1182: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1183: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1184: l_serialnumber inv_reservation_global.serial_number_tbl_type;
1185: l_status VARCHAR2(1) ;
1186: l_msg_count NUMBER;

Line 1235: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1231:
1232: --
1233: -- Bug 5345660 exitPoint for normal exit.
1234: --
1235: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1236: wip_logger.exitPoint(
1237: p_procName => 'wip_close_priv.delete_reservation',
1238: p_procReturnStatus => x_returnStatus,
1239: p_msg => 'procedure normal exit',

Line 1640: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1636: l_msg VARCHAR2(2000);
1637: l_req_id NUMBER;
1638: l_params wip_logger.param_tbl_t;
1639: l_errMsg VARCHAR2(240);
1640: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1641:
1642: BEGIN
1643:
1644: l_at_submission_time := 1 ; ---SRS

Line 1702: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1698: x_act_close_date => l_act_close_date ,
1699: x_returnstatus => l_return_status
1700: );
1701: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1702: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1703: wip_logger.log(p_msg => 'time zone conversion failed',
1704: x_returnStatus => l_return_Status);
1705: END IF;
1706: RAISE FND_API.G_EXC_ERROR ;

Line 1779: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1775: x_group_id => l_group_id ,
1776: x_ReturnStatus => l_return_status
1777: );
1778: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1779: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1780: wip_logger.log(p_msg => 'populate_close_temp',
1781: x_returnStatus => l_return_Status);
1782: END IF;
1783: RAISE FND_API.G_EXC_ERROR ;

Line 1795: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1791: RETCODE => l_return_status
1792: );
1793:
1794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1795: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1796: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
1797: x_returnStatus => l_return_Status);
1798: END IF;
1799: RAISE FND_API.G_EXC_ERROR ;

Line 1827: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1823: RETCODE => l_return_status
1824: );
1825:
1826: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1827: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1828: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
1829: x_returnStatus => l_return_Status);
1830: END IF;
1831: RAISE FND_API.G_EXC_ERROR ;

Line 1870: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1866: x_warning := 1 ;
1867: --
1868: -- Bug 5345660 Added profile check before invoking wip_logger
1869: --
1870: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1871: wip_logger.log(p_msg => l_msg,
1872: x_returnStatus => l_return_Status);
1873: END IF;
1874: END IF;

Line 1912: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1908: x_warning := 1 ;
1909: --
1910: -- Bug 5345660 Added profile check before invoking wip_logger
1911: --
1912: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1913: wip_logger.log(p_msg => l_msg,
1914: x_returnStatus => l_return_Status);
1915: END IF;
1916: END IF;

Line 1938: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1934: x_warning := 1 ;
1935: --
1936: -- Bug 5345660 Added profile check before invoking wip_logger
1937: --
1938: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1939: wip_logger.log(p_msg => l_msg,
1940: x_returnStatus => l_return_Status);
1941: END IF;
1942: END IF;

Line 1965: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1961: x_warning := 1 ;
1962: --
1963: -- Bug 5345660 Added profile check before invoking wip_logger
1964: --
1965: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1966: wip_logger.log(p_msg => l_msg,
1967: x_returnStatus => l_return_Status);
1968: END IF;
1969: END IF;

Line 1991: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1987: x_warning := 1 ;
1988: --
1989: -- Bug 5345660 Added profile check before invoking wip_logger
1990: --
1991: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1992: wip_logger.log(p_msg => l_msg,
1993: x_returnStatus => l_return_Status);
1994: END IF;
1995: END IF;

Line 2018: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2014: l_msg := fnd_message.get;
2015: --
2016: -- Bug 5345660 Added profile check before invoking wip_logger
2017: --
2018: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2019: wip_logger.log(p_msg => l_msg,
2020: x_returnStatus => l_return_Status);
2021: END IF;
2022: END IF;

Line 2036: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2032: x_returnstatus => l_return_status,
2033: p_organization_id => p_organization_id,
2034: p_group_id => l_group_id );
2035: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2036: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2037: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2038: x_returnStatus => l_return_Status);
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR ;

Line 2056: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2052: p_organization_id => p_organization_id,
2053: p_group_id => l_group_id );
2054:
2055: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2057: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2058: x_returnStatus => l_return_Status);
2059: END IF;
2060: END IF;

Line 2174: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2170: p_org_id => p_organization_id
2171: );
2172: -- Bug 5370550
2173: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2174: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2175: wip_logger.log(p_msg => 'costing function error',
2176: x_returnStatus => l_return_Status);
2177: END IF;
2178: RAISE FND_API.G_EXC_ERROR ;

Line 2193: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2189: RETCODE => l_return_Status
2190: );
2191:
2192: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2193: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2194: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2195: x_returnStatus => l_return_Status);
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR ;

Line 2209: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2205: RETCODE => l_return_status
2206: );
2207:
2208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2209: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2210: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2211: x_returnStatus => l_return_Status);
2212: END IF;
2213: RAISE FND_API.G_EXC_ERROR ;

Line 2308: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2304:
2305: --
2306: -- Bug 5345660 exitPoint for normal exit.
2307: --
2308: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2309: wip_logger.exitPoint(
2310: p_procName => 'wip_close_priv.wip_close',
2311: p_procReturnStatus => x_returnStatus,
2312: p_msg => 'procedure normal exit',

Line 2334: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2330: RETCODE => l_return_Status
2331: );
2332:
2333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2334: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2335: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2336: x_returnStatus => l_return_Status);
2337: END IF;
2338: RAISE FND_API.G_EXC_ERROR ;

Line 2350: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2346: RETCODE => l_return_status
2347: );
2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2351: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2352: x_returnStatus => l_return_Status);
2353: END IF;
2354: RAISE FND_API.G_EXC_ERROR ;

Line 2381: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2377: --
2378: -- Bug 5345660 exitPoint for exception exit.
2379: --
2380: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2381: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2382: wip_logger.exitPoint(
2383: p_procName => 'wip_close_priv.wip_close',
2384: p_procReturnStatus => x_returnStatus,
2385: p_msg => l_msg,