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 32: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

28:
29: l_params wip_logger.param_tbl_t;
30: l_return_Status VARCHAR2(1);
31: l_msg VARCHAR(240);
32: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
33: l_number_temp NUMBER ;
34: TYPE l_close_temp_typ IS TABLE OF WIP_DJ_CLOSE_TEMP%ROWTYPE;
35: l_close_temp_tbl1 l_close_temp_typ:=l_close_temp_typ();
36: l_close_temp_tbl2 l_close_temp_typ:=l_close_temp_typ();

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

431:
432: --
433: -- Bug 5345660 exitPoint for normal exit.
434: --
435: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
436: wip_logger.exitPoint(
437: p_procName => 'wip_close_priv.populate_close_temp',
438: p_procReturnStatus => x_returnStatus,
439: p_msg => 'procedure normal exit',

Line 481: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

477: x_act_close_date OUT NOCOPY DATE ,
478: x_returnstatus OUT NOCOPY VARCHAR2
479: )IS
480: l_params wip_logger.param_tbl_t;
481: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
482: l_return_status VARCHAR2(1) ;
483: l_msg_count NUMBER ;
484: l_msg_data VARCHAR2(200);
485: l_msg VARCHAR(240);

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

607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
612: wip_logger.exitPoint(
613: p_procName => 'wip_close_priv.time_zone_conversions',
614: p_procReturnStatus => x_returnStatus,
615: p_msg => 'procedure normal exit',

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

619: WHEN others THEN
620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
621: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
622:
623: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
624: wip_logger.exitPoint(
625: p_procName=>'wip_close_priv.time_zone_conversions',
626: p_procReturnStatus => x_returnStatus,
627: p_msg => l_msg,

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

651: l_failed_ids dbms_sql.number_table;
652:
653: BEGIN
654:
655: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
656: l_params(1).paramName := 'p_organization_id';
657: l_params(1).paramValue := p_organization_id;
658: l_params(2).paramName := 'p_group_id';
659: l_params(2).paramValue := p_group_id;

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

706:
707: --
708: -- Bug 5345660 exitPoint for normal exit.
709: --
710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
711: wip_logger.exitPoint(
712: p_procName => 'wip_close_priv.prior_date_release',
713: p_procReturnStatus => x_returnStatus,
714: p_msg => 'procedure normal exit',

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

719: WHEN others THEN
720: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
721: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
722:
723: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
724: wip_logger.exitPoint(
725: p_procName=>'wip_close_priv.prior_date_release',
726: p_procReturnStatus => x_returnStatus,
727: p_msg => l_msg,

Line 747: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

743: IS
744: l_params wip_logger.param_tbl_t;
745: l_return_Status VARCHAR2(1);
746: l_msg VARCHAR(240);
747: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
748:
749: CURSOR c_pending_txns IS
750: SELECT WIP_ENTITY_NAME
751: FROM WIP_DJ_CLOSE_TEMP

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

848:
849: --
850: -- Bug 5345660 exitPoint for normal exit.
851: --
852: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
853: wip_logger.exitPoint(
854: p_procName => 'wip_close_priv.pending_txns',
855: p_procReturnStatus => x_returnStatus,
856: p_msg => 'procedure normal exit',

Line 944: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

940: l_msg_data VARCHAR2(2000);
941: l_params wip_logger.param_tbl_t;
942: l_return_Status VARCHAR2(1);
943: l_msg VARCHAR(240);
944: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
945: l_failed_counter NUMBER ;
946: BEGIN
947: IF (l_logLevel <= wip_constants.trace_logging) THEN
948: l_params(1).paramName := 'p_organization_id';

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

990:
991: --
992: -- Bug 5345660 exitPoint for normal exit.
993: --
994: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
995: wip_logger.exitPoint(
996: p_procName => 'wip_close_priv.pending_clocks',
997: p_procReturnStatus => x_returnStatus,
998: p_msg => 'procedure normal exit',

Line 1138: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1134:
1135: l_params wip_logger.param_tbl_t;
1136: l_return_Status VARCHAR2(1);
1137: l_msg VARCHAR(240);
1138: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1139:
1140: CURSOR c_pending_txns IS
1141: SELECT WIP_ENTITY_NAME
1142: FROM WIP_DJ_CLOSE_TEMP

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

1215:
1216: --
1217: -- Bug 5345660 exitPoint for normal exit.
1218: --
1219: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1220: wip_logger.exitPoint(
1221: p_procName => 'wip_close_priv.past_close_date',
1222: p_procReturnStatus => x_returnStatus,
1223: p_msg => 'procedure normal exit',

Line 1256: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1252:
1253: l_params wip_logger.param_tbl_t;
1254: l_return_Status VARCHAR2(1);
1255: l_msg VARCHAR(240);
1256: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1257:
1258: CURSOR c_open_po IS
1259: SELECT WIP_ENTITY_NAME
1260: FROM WIP_DJ_CLOSE_TEMP WDCT

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

1339:
1340: --
1341: -- Bug 5345660 exitPoint for normal exit.
1342: --
1343: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1344: wip_logger.exitPoint(
1345: p_procName => 'wip_close_priv.check_open_po',
1346: p_procReturnStatus => x_returnStatus,
1347: p_msg => 'procedure normal exit',

Line 1383: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1379:
1380: l_params wip_logger.param_tbl_t;
1381: l_return_Status VARCHAR2(1);
1382: l_msg VARCHAR(240);
1383: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1384:
1385: /*Bug 9877786(FP of 9791544)*/
1386: CURSOR c_delivered_qty IS
1387: SELECT WIP_ENTITY_NAME

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

1461: IF (c_delivered_qty%ISOPEN) THEN
1462: CLOSE c_delivered_qty ;
1463: END IF;
1464:
1465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1466: wip_logger.exitPoint(
1467: p_procName => 'wip_close_priv.check_delivery_qty',
1468: p_procReturnStatus => x_returnStatus,
1469: p_msg => 'procedure normal exit',

Line 1507: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1503: l_wsm_org number ;
1504: l_return_status Varchar2(1);
1505: l_params wip_logger.param_tbl_t;
1506: l_msg VARCHAR(240);
1507: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1508:
1509: BEGIN
1510: x_returnStatus := fnd_api.g_ret_sts_success;
1511: fnd_file.put_line(FND_FILE.LOG,'lot validate');

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

1532:
1533: --
1534: -- Bug 5345660 exitPoint for normal exit.
1535: --
1536: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1537: wip_logger.exitPoint(
1538: p_procName => 'wip_close_priv.lot_validate',
1539: p_procReturnStatus => x_returnStatus,
1540: p_msg => 'procedure normal exit',

Line 1572: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1568: IS
1569: l_params wip_logger.param_tbl_t;
1570: l_return_Status VARCHAR2(1);
1571: l_msg VARCHAR(240);
1572: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1573: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1574: l_serialnumber inv_reservation_global.serial_number_tbl_type;
1575: l_status VARCHAR2(1) ;
1576: l_msg_count NUMBER;

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

1638:
1639: --
1640: -- Bug 5345660 exitPoint for normal exit.
1641: --
1642: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1643: wip_logger.exitPoint(
1644: p_procName => 'wip_close_priv.delete_reservation',
1645: p_procReturnStatus => x_returnStatus,
1646: p_msg => 'procedure normal exit',

Line 2047: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2043: l_msg VARCHAR2(2000);
2044: l_req_id NUMBER;
2045: l_params wip_logger.param_tbl_t;
2046: l_errMsg VARCHAR2(240);
2047: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2048: l_acct_period_close_date DATE; -- Added for bug : 8262844(FP of 8215957)
2049: l_jobs_to_close NUMBER; --fix bug 9250439
2050: deadlock EXCEPTION; --Fix bug 15874569
2051: PRAGMA EXCEPTION_INIT(deadlock, -60); --Fix bug 15874569

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

2132: x_act_close_date => l_act_close_date ,
2133: x_returnstatus => l_return_status
2134: );
2135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2136: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2137: wip_logger.log(p_msg => 'time zone conversion failed',
2138: x_returnStatus => l_return_Status);
2139: END IF;
2140: RAISE FND_API.G_EXC_ERROR ;

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

2210: x_group_id => l_group_id ,
2211: x_ReturnStatus => l_return_status
2212: );
2213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2214: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2215: wip_logger.log(p_msg => 'populate_close_temp',
2216: x_returnStatus => l_return_Status);
2217: END IF;
2218: RAISE FND_API.G_EXC_ERROR ;

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

2226: RETCODE => l_return_status
2227: );
2228:
2229: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2231: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
2232: x_returnStatus => l_return_Status);
2233: END IF;
2234: RAISE FND_API.G_EXC_ERROR ;

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

2258: RETCODE => l_return_status
2259: );
2260:
2261: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2262: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2263: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
2264: x_returnStatus => l_return_Status);
2265: END IF;
2266: RAISE FND_API.G_EXC_ERROR ;

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

2313: x_warning := 1 ;
2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger
2316: --
2317: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2318: wip_logger.log(p_msg => l_msg,
2319: x_returnStatus => l_return_Status);
2320: END IF;
2321: END IF;

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

2355: x_warning := 1 ;
2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger
2358: --
2359: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2360: wip_logger.log(p_msg => l_msg,
2361: x_returnStatus => l_return_Status);
2362: END IF;
2363: END IF;

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

2381: x_warning := 1 ;
2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger
2384: --
2385: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2386: wip_logger.log(p_msg => l_msg,
2387: x_returnStatus => l_return_Status);
2388: END IF;
2389: END IF;

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

2408: x_warning := 1 ;
2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger
2411: --
2412: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2413: wip_logger.log(p_msg => l_msg,
2414: x_returnStatus => l_return_Status);
2415: END IF;
2416: END IF;

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

2434: x_warning := 1 ;
2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger
2437: --
2438: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2439: wip_logger.log(p_msg => l_msg,
2440: x_returnStatus => l_return_Status);
2441: END IF;
2442: END IF;

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

2461: l_msg := fnd_message.get;
2462: --
2463: -- Bug 5345660 Added profile check before invoking wip_logger
2464: --
2465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2466: wip_logger.log(p_msg => l_msg,
2467: x_returnStatus => l_return_Status);
2468: END IF;
2469: END IF;

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

2484: /*Bug 13625290*/
2485: x_warning := 1 ;
2486: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED');
2487: l_msg := fnd_message.get;
2488: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2489: wip_logger.log(p_msg => 'CHECK_DELIVERY_QTY procedure failed',
2490: x_returnStatus => l_return_Status);
2491: END IF;
2492: END IF;

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

2501: x_returnstatus => l_return_status,
2502: p_organization_id => p_organization_id,
2503: p_group_id => l_group_id );
2504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2505: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2506: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2507: x_returnStatus => l_return_Status);
2508: END IF;
2509: RAISE FND_API.G_EXC_ERROR ;

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

2521: p_organization_id => p_organization_id,
2522: p_group_id => l_group_id );
2523:
2524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2525: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2526: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2527: x_returnStatus => l_return_Status);
2528: END IF;
2529: END IF;

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

2671: p_org_id => p_organization_id
2672: );
2673: -- Bug 5370550
2674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2675: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2676: wip_logger.log(p_msg => 'costing function error',
2677: x_returnStatus => l_return_Status);
2678: END IF;
2679: RAISE FND_API.G_EXC_ERROR ;

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

2690: RETCODE => l_return_Status
2691: );
2692:
2693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2695: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2696: x_returnStatus => l_return_Status);
2697: END IF;
2698: RAISE FND_API.G_EXC_ERROR ;

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

2706: RETCODE => l_return_status
2707: );
2708:
2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2711: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2712: x_returnStatus => l_return_Status);
2713: END IF;
2714: RAISE FND_API.G_EXC_ERROR ;

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

2817: <>
2818: --
2819: -- Bug 5345660 exitPoint for normal exit.
2820: --
2821: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2822: wip_logger.exitPoint(
2823: p_procName => 'wip_close_priv.wip_close',
2824: p_procReturnStatus => x_returnStatus,
2825: p_msg => 'procedure normal exit',

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

2844: RETCODE => l_return_Status
2845: );
2846:
2847: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2848: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2849: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2850: x_returnStatus => l_return_Status);
2851: END IF;
2852: RAISE FND_API.G_EXC_ERROR ;

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

2860: RETCODE => l_return_status
2861: );
2862:
2863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2864: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2865: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2866: x_returnStatus => l_return_Status);
2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR ;

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

2891: --
2892: -- Bug 5345660 exitPoint for exception exit.
2893: --
2894: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2895: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2896: wip_logger.exitPoint(
2897: p_procName => 'wip_close_priv.wip_close',
2898: p_procReturnStatus => x_returnStatus,
2899: p_msg => l_msg,