DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on FND_LOG

Line 128: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 168: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 199: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 230: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 269: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 312: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 408: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 528: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

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

Line 854: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

850: l_retStatus VARCHAR2(1);
851: l_params wip_logger.param_tbl_t;
852: i number;
853: l_maxEndDate date;
854: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
855: l_bool boolean;
856: begin
857: if (l_logLevel <= wip_constants.trace_logging) then
858: l_params(1).paramName := 'p_range(1)';

Line 928: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

924: x_shifts in out nocopy shift_recTbl_t,
925: x_overlap_exists in out nocopy boolean) is
926: l_retStatus VARCHAR2(1);
927: l_params wip_logger.param_tbl_t;
928: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
929: begin
930: if (l_logLevel <= wip_constants.trace_logging) then
931: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_shift',
932: p_params => l_params,

Line 1003: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

999: l_overlap_exists boolean := true;
1000: l_count number;
1001: l_count2 number;
1002: l_params wip_logger.param_tbl_t;
1003: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1004: l_shifts shift_recTbl_t;
1005: begin
1006: if (l_logLevel <= wip_constants.trace_logging) then
1007: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_overlap_shifts',

Line 1197: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1193: endDate date_tbl_t);
1194: end of fix bug 7027946 */
1195:
1196: l_shifts shift_recTbl_t;
1197: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1198: l_params wip_logger.param_tbl_t;
1199: l_retStatus VARCHAR2(1);
1200: l_resourceScheduled boolean := false;
1201: l_cursorStartDate date := trunc(p_startDate) - 1;--subtract 1 to make sure to get wraparound shifts (start on prev day)

Line 1592: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1588: type capacity_recTbl_t is table of capacity_rec_t index by binary_integer;
1589:
1590: l_capacity capacity_recTbl_t ;
1591: l_capacity_2 capacity_recTbl_t ;
1592: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1593: l_params wip_logger.param_tbl_t;
1594: l_retStatus VARCHAR2(1);
1595:
1596: l_firstRow NUMBER;

Line 2043: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2039: p_schedFlag in number,
2040: x_resTbls in out NOCOPY OP_RES_RECTBL_T,
2041: x_returnStatus OUT NOCOPY VARCHAR2) is
2042: l_resStartDate DATE; -- := p_startDate;
2043: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2044: l_params wip_logger.param_tbl_t;
2045: l_retStatus VARCHAR2(1);
2046: l_fromTime NUMBER;
2047: l_maxDate DATE;

Line 2167: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2163: l_retStatus VARCHAR2(1);
2164: l_params wip_logger.param_tbl_t;
2165: i number;
2166: l_minStartDate date;
2167: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2168: l_bool boolean;
2169: begin
2170: if (l_logLevel <= wip_constants.trace_logging) then
2171: l_params(1).paramName := 'p_range(1)';

Line 2319: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2315: startDate date_tbl_t,
2316: endDate date_tbl_t);*/
2317:
2318: l_shifts shift_recTbl_t;
2319: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2320: l_params wip_logger.param_tbl_t;
2321: l_retStatus VARCHAR2(1);
2322: l_resourceScheduled boolean := false;
2323: l_cursorEndDate date := p_endDate;

Line 2646: l_logLevel number := fnd_log.g_current_runtime_level;

2642: x_resTbls in out nocopy op_res_rectbl_t,
2643: x_returnStatus out nocopy varchar2) is
2644: j number;
2645: l_minStartDate DATE;
2646: l_logLevel number := fnd_log.g_current_runtime_level;
2647: l_params wip_logger.param_tbl_t;
2648: l_retStatus VARCHAR2(1);
2649: begin
2650: if (l_logLevel <= wip_constants.trace_logging) then

Line 2716: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2712: p_schedFlag in number,
2713: x_resTbls in out NOCOPY OP_RES_RECTBL_T,
2714: x_returnStatus OUT NOCOPY VARCHAR2) is
2715: l_resEndDate DATE;
2716: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2717: l_params wip_logger.param_tbl_t;
2718: l_retStatus VARCHAR2(1);
2719: l_fromTime NUMBER;
2720: l_minDate DATE;

Line 2880: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2876: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
2877: x_returnStatus OUT NOCOPY VARCHAR2) is
2878: l_retStatus VARCHAR2(1);
2879: l_params wip_logger.param_tbl_t;
2880: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2881: begin
2882: if(l_logLevel <= wip_constants.trace_logging) then
2883: l_params(1).paramName := 'p_orgID';
2884: l_params(1).paramValue := p_orgID;

Line 2943: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2939: x_returnStatus OUT NOCOPY VARCHAR2) is
2940:
2941: l_retStatus VARCHAR2(1);
2942: l_params wip_logger.param_tbl_t;
2943: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2944: begin
2945: if(l_logLevel <= wip_constants.trace_logging) then
2946: l_params(1).paramName := 'p_orgID';
2947: l_params(1).paramValue := p_orgID;

Line 3015: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3011: p_repLineID IN NUMBER,
3012: p_startDate IN DATE,
3013: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
3014: x_returnStatus OUT NOCOPY VARCHAR2) is
3015: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3016: l_params wip_logger.param_tbl_t;
3017: l_retStatus VARCHAR2(1);
3018: l_opSeqNum NUMBER := null;
3019: l_opStartDate DATE;

Line 3174: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3170: p_repLineID IN NUMBER,
3171: p_endDate IN DATE,
3172: x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
3173: x_returnStatus OUT NOCOPY VARCHAR2) is
3174: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3175: l_params wip_logger.param_tbl_t;
3176: l_retStatus VARCHAR2(1);
3177: l_opSeqNum NUMBER := null;
3178: l_opEndDate DATE;

Line 3337: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3333:
3334:
3335:
3336: procedure dumpResources(p_resTbls IN OP_RES_RECTBL_T) IS
3337: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3338: l_params wip_logger.param_tbl_t;
3339: l_retStatus VARCHAR2(1);
3340: l_resCode VARCHAR2(10);
3341: begin

Line 3411: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3407: l_nextRange num_tbl_t := num_tbl_t(null, x_resTbls.resID.count);
3408: i NUMBER;
3409: j NUMBER;
3410: k NUMBER; -- bug 8669295 (FP 8651554)
3411: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3412: l_retStatus VARCHAR2(1);
3413: l_params wip_logger.param_tbl_t;
3414:
3415: l_endDate DATE; --bug 8614399 (FP 8586766)