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

Line 132: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

128: l_curSch NUMBER := x_resTbls.schedSeqNum(1);
129: l_priorExists boolean := x_resTbls.schedFlag(1) = wip_constants.sched_prior;
130: l_otherExists boolean := x_resTbls.schedFlag(1) in (wip_constants.sched_yes, wip_constants.sched_next);
131: l_startIdx NUMBER := 1;
132: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
133: l_retStatus VARCHAR2(1);
134: l_params wip_logger.param_tbl_t;
135: begin
136: if(l_logLevel <= wip_constants.trace_logging) then

Line 172: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

168:
169: procedure removePriors(x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T) is
170: l_curOp NUMBER:= x_resTbls.opSeqNum(1);
171: l_nonPriorExists boolean := false;
172: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
173: l_retStatus VARCHAR2(1);
174: l_params wip_logger.param_tbl_t;
175: begin
176: if(l_logLevel <= wip_constants.trace_logging) then

Line 203: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

199:
200: procedure removeNexts(x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T) is
201: l_curOp NUMBER:= x_resTbls.opSeqNum(x_resTbls.resID.count);
202: l_nonNextExists boolean := false;
203: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
204: l_retStatus VARCHAR2(1);
205: l_params wip_logger.param_tbl_t;
206: begin
207: if(l_logLevel <= wip_constants.trace_logging) then

Line 234: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

230: end removeNexts;
231:
232: procedure verifyResources(x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T) is
233:
234: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
235: l_retStatus VARCHAR2(1);
236: l_params wip_logger.param_tbl_t;
237: begin
238: if(l_logLevel <= wip_constants.trace_logging) then

Line 273: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

269: end if;
270: end verifyResources;
271:
272: procedure dumpOps(p_opTbl in op_tbl_t) is
273: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
274: l_retStatus VARCHAR2(1);
275: l_params wip_logger.param_tbl_t;
276: begin
277: if(l_logLevel <= wip_constants.trace_logging) then

Line 316: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

312: l_startRange NUMBER := 1;
313: l_endRange NUMBER := 1;
314: j number := 1;
315: l_firstYesOpIdx NUMBER;
316: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
317: l_retStatus VARCHAR2(1);
318: l_params wip_logger.param_tbl_t;
319: begin
320: if(l_logLevel <= wip_constants.trace_logging) then

Line 405: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

401: x_midPntFwdIdx OUT NOCOPY NUMBER,
402: x_midPntBkwdIdx OUT NOCOPY NUMBER) is
403: l_retStatus VARCHAR2(1);
404: l_params wip_logger.param_tbl_t;
405: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
406: l_foundMidPntOp boolean := false;
407: begin
408: if(l_logLevel <= wip_constants.trace_logging) then
409: l_params(1).paramName := 'p_opSeqNum';

Line 525: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

521: p_resSeqNum NUMBER := null,
522: p_endDebug IN VARCHAR2 := null,
523: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
524: x_returnStatus OUT NOCOPY VARCHAR2) is
525: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
526: l_params wip_logger.param_tbl_t;
527: l_retStatus VARCHAR2(1);
528:
529: l_fwdStIdx NUMBER;--resource to start forward scheduling from

Line 833: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

829: l_retStatus VARCHAR2(1);
830: l_params wip_logger.param_tbl_t;
831: i number;
832: l_maxEndDate date;
833: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
834: l_bool boolean;
835: begin
836: if (l_logLevel <= wip_constants.trace_logging) then
837: l_params(1).paramName := 'p_range(1)';

Line 978: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

974: endDate date_tbl_t);
975: /* end of fix bug 7027946 */
976:
977: l_shifts shift_recTbl_t;
978: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
979: l_params wip_logger.param_tbl_t;
980: l_retStatus VARCHAR2(1);
981: l_resourceScheduled boolean := false;
982: l_cursorStartDate date := trunc(p_startDate) - 1;--subtract 1 to make sure to get wraparound shifts (start on prev day)

Line 1342: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1338:
1339: type capacity_recTbl_t is table of capacity_rec_t index by binary_integer;
1340:
1341: l_capacity capacity_recTbl_t ;
1342: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1343: l_params wip_logger.param_tbl_t;
1344: l_retStatus VARCHAR2(1);
1345:
1346: l_firstRow NUMBER;

Line 1491: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1487: p_schedFlag in number,
1488: x_resTbls in out NOCOPY OP_RES_RECTBL_T,
1489: x_returnStatus OUT NOCOPY VARCHAR2) is
1490: l_resStartDate DATE; -- := p_startDate;
1491: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1492: l_params wip_logger.param_tbl_t;
1493: l_retStatus VARCHAR2(1);
1494: l_fromTime NUMBER;
1495: l_maxDate DATE;

Line 1615: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1611: l_retStatus VARCHAR2(1);
1612: l_params wip_logger.param_tbl_t;
1613: i number;
1614: l_minStartDate date;
1615: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1616: l_bool boolean;
1617: begin
1618: if (l_logLevel <= wip_constants.trace_logging) then
1619: l_params(1).paramName := 'p_range(1)';

Line 1759: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1755: startDate date_tbl_t,
1756: endDate date_tbl_t);
1757:
1758: l_shifts shift_recTbl_t;
1759: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1760: l_params wip_logger.param_tbl_t;
1761: l_retStatus VARCHAR2(1);
1762: l_resourceScheduled boolean := false;
1763: l_cursorEndDate date := p_endDate;

Line 2075: l_logLevel number := fnd_log.g_current_runtime_level;

2071: x_resTbls in out nocopy op_res_rectbl_t,
2072: x_returnStatus out nocopy varchar2) is
2073: j number;
2074: l_minStartDate DATE;
2075: l_logLevel number := fnd_log.g_current_runtime_level;
2076: l_params wip_logger.param_tbl_t;
2077: l_retStatus VARCHAR2(1);
2078: begin
2079: if (l_logLevel <= wip_constants.trace_logging) then

Line 2145: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2141: p_schedFlag in number,
2142: x_resTbls in out NOCOPY OP_RES_RECTBL_T,
2143: x_returnStatus OUT NOCOPY VARCHAR2) is
2144: l_resEndDate DATE;
2145: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2146: l_params wip_logger.param_tbl_t;
2147: l_retStatus VARCHAR2(1);
2148: l_fromTime NUMBER;
2149: l_minDate DATE;

Line 2309: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2305: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
2306: x_returnStatus OUT NOCOPY VARCHAR2) is
2307: l_retStatus VARCHAR2(1);
2308: l_params wip_logger.param_tbl_t;
2309: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2310: begin
2311: if(l_logLevel <= wip_constants.trace_logging) then
2312: l_params(1).paramName := 'p_orgID';
2313: l_params(1).paramValue := p_orgID;

Line 2372: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2368: x_returnStatus OUT NOCOPY VARCHAR2) is
2369:
2370: l_retStatus VARCHAR2(1);
2371: l_params wip_logger.param_tbl_t;
2372: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2373: begin
2374: if(l_logLevel <= wip_constants.trace_logging) then
2375: l_params(1).paramName := 'p_orgID';
2376: l_params(1).paramValue := p_orgID;

Line 2437: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2433: p_repLineID IN NUMBER,
2434: p_startDate IN DATE,
2435: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
2436: x_returnStatus OUT NOCOPY VARCHAR2) is
2437: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2438: l_params wip_logger.param_tbl_t;
2439: l_retStatus VARCHAR2(1);
2440: l_opSeqNum NUMBER := null;
2441: l_opStartDate DATE;

Line 2596: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2592: p_repLineID IN NUMBER,
2593: p_endDate IN DATE,
2594: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
2595: x_returnStatus OUT NOCOPY VARCHAR2) is
2596: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2597: l_params wip_logger.param_tbl_t;
2598: l_retStatus VARCHAR2(1);
2599: l_opSeqNum NUMBER := null;
2600: l_opEndDate DATE;

Line 2759: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2755:
2756:
2757:
2758: procedure dumpResources(p_resTbls IN OP_RES_RECTBL_T) IS
2759: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2760: l_params wip_logger.param_tbl_t;
2761: l_retStatus VARCHAR2(1);
2762: l_resCode VARCHAR2(10);
2763: begin

Line 2832: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2828: l_prevRange num_tbl_t := num_tbl_t(1, null);
2829: l_nextRange num_tbl_t := num_tbl_t(null, x_resTbls.resID.count);
2830: i NUMBER;
2831: j NUMBER;
2832: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2833: l_retStatus VARCHAR2(1);
2834: l_params wip_logger.param_tbl_t;
2835: begin
2836: if(l_logLevel <= wip_constants.trace_logging) then