DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on FND_LOG

Line 172: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

168: l_params wip_logger.param_tbl_t;
169: l_returnStatus VARCHAR2(1);
170: l_errMsg VARCHAR(240);
171: l_msg VARCHAR(240);
172: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
173: l_bf_required NUMBER; -- throw away value
174: l_ls_required NUMBER;
175: -- New variable to pass to OSFM new backflush API.
176: l_error_msg VARCHAR2(1000);

Line 346: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

342:
343: l_params wip_logger.param_tbl_t;
344: l_returnStatus VARCHAR(1);
345: l_msg VARCHAR(240);
346: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
347: BEGIN
348: -- write parameter value to log file
349: IF (l_logLevel <= wip_constants.trace_logging) THEN
350: l_params(1).paramName := 'p_mtl_header_id';

Line 495: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

491: l_mtl_errors c_mtl_errors%ROWTYPE;
492: l_params wip_logger.param_tbl_t;
493: l_returnStatus VARCHAR(1);
494: l_errMsg VARCHAR2(240);
495: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
496: l_count NUMBER;
497: BEGIN
498: -- write parameter value to log file
499: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 596: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

592: l_wipops c_wipops%ROWTYPE;
593: l_returnStatus VARCHAR(1);
594: l_errMsg VARCHAR2(240);
595: l_params wip_logger.param_tbl_t;
596: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
597:
598: BEGIN
599: -- write parameter value to log file
600: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 748: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

744: l_quantity NUMBER := p_quantity;
745: l_recordFound NUMBER := 0;
746: l_need_more BOOLEAN := TRUE;
747: l_dummy NUMBER := 0;
748: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
749:
750: BEGIN
751: -- write parameter value to log file
752: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 975: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

971: l_first_dept_code VARCHAR2(10);
972: l_first_dept_id NUMBER := 0;
973: l_first_op_seq_num NUMBER := 0;
974: l_oc_txn_id NUMBER := 0;
975: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
976:
977: BEGIN
978: -- write parameter value to log file
979: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1122: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1118:
1119: l_params wip_logger.param_tbl_t;
1120: l_returnStatus VARCHAR(1);
1121: l_errMsg VARCHAR2(240);
1122: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1123: l_forward_move NUMBER;
1124: BEGIN
1125: FOR i IN 1..p_scheCount LOOP
1126: -- write parameter value to log file

Line 1325: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1321:
1322: l_params wip_logger.param_tbl_t;
1323: l_returnStatus VARCHAR2(1);
1324: l_errMsg VARCHAR2(240);
1325: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1326:
1327: BEGIN
1328: -- write parameter values to log file
1329: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1482: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1478: l_sche_count NUMBER;
1479: l_oc_fm_op NUMBER;
1480: l_rec_count NUMBER :=0;
1481: l_proc_status NUMBER;
1482: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1483: l_msg_data VARCHAR2(2000);
1484: l_propagate_job_change_to_po NUMBER;
1485: BEGIN
1486: -- write parameter value to log file

Line 1899: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1895:
1896: l_params wip_logger.param_tbl_t;
1897: l_returnStatus VARCHAR(1);
1898: l_errMsg VARCHAR2(240);
1899: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1900: l_forward_move NUMBER;
1901:
1902: BEGIN
1903: -- write parameter value to log file

Line 2179: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2175: -- Fixed bug 4406536. We should initialized l_notenough at the beginning of
2176: -- for loop, not the declaration part.
2177: -- l_notenough BOOLEAN := FALSE;
2178: l_notenough BOOLEAN;
2179: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2180: -- new variables added for serial location check
2181: l_opSeq NUMBER;
2182: l_step NUMBER;
2183: l_msg_data VARCHAR2(2000);

Line 2569: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2565: l_po_lot NUMBER;
2566: l_completion NUMBER;
2567: l_return NUMBER;
2568: l_move move_profile_rec_t;
2569: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2570:
2571: BEGIN
2572: -- initialize l_move
2573: l_move := p_gib.move_profile;

Line 2771: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2767: l_params wip_logger.param_tbl_t;
2768: l_returnStatus VARCHAR(1);
2769: l_msg VARCHAR(240);
2770: l_errMsg VARCHAR2(240);
2771: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2772:
2773: BEGIN
2774: -- write parameter value to log file
2775: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 3148: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3144: l_params wip_logger.param_tbl_t;
3145: l_returnStatus VARCHAR(1);
3146: l_errMsg VARCHAR2(240);
3147: l_outcome NUMBER := -1;
3148: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3149:
3150: BEGIN
3151: -- write parameter value to log file
3152: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 3214: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3210: l_returnStatus VARCHAR(1);
3211: l_msg VARCHAR(240);
3212: l_errMsg VARCHAR2(240);
3213: l_move move_profile_rec_t;
3214: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3215:
3216: BEGIN
3217: l_move := p_gib.move_profile;
3218:

Line 4368: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

4364: l_params wip_logger.param_tbl_t;
4365: l_returnStatus VARCHAR(1);
4366: l_msg VARCHAR(240);
4367: l_errMsg VARCHAR2(240);
4368: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
4369:
4370: BEGIN
4371: -- write parameter value to log file
4372: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 4506: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

4502: l_returnStatus VARCHAR(1);
4503: l_msg VARCHAR(240);
4504: l_errMsg VARCHAR2(240);
4505: l_move move_profile_rec_t;
4506: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
4507:
4508: BEGIN
4509: l_move := p_gib.move_profile;
4510:

Line 5636: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

5632: l_params wip_logger.param_tbl_t;
5633: l_returnStatus VARCHAR(1);
5634: l_msg VARCHAR(240);
5635: l_errMsg VARCHAR2(240);
5636: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
5637:
5638: BEGIN
5639: -- write parameter value to log file
5640: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 5769: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

5765: l_msg VARCHAR(240);
5766: l_errMsg VARCHAR2(240);
5767: l_additional_reqs c_additional_reqs%ROWTYPE;
5768: l_move move_profile_rec_t;
5769: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
5770:
5771: BEGIN
5772: l_move := p_gib.move_profile;
5773:

Line 6800: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

6796: l_returnStatus VARCHAR(1);
6797: l_errMsg VARCHAR2(240);
6798: l_wmti_txn c_wmti_txn%ROWTYPE;
6799: l_itemkey VARCHAR2(80) := NULL;
6800: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
6801: l_success NUMBER := 0;
6802: l_org_id number;
6803: l_ou_id number;
6804: l_org_acct_ctxt VARCHAR2(30):= 'Accounting Information';

Line 6942: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

6938: l_params wip_logger.param_tbl_t;
6939: l_returnStatus VARCHAR(1);
6940: l_msg VARCHAR(240);
6941: l_errMsg VARCHAR2(240);
6942: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
6943:
6944: BEGIN
6945: -- write parameter value to log file
6946: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7152: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7148: l_returnValue NUMBER;
7149: l_msgCount NUMBER;
7150: l_errCode VARCHAR(240);
7151: l_errMsg VARCHAR(240);
7152: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7153:
7154: BEGIN
7155: -- write parameter value to log file
7156: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7240: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7236: l_errMsg VARCHAR(240);
7237: l_pri_cost_method NUMBER;
7238: l_mandatory_scrap_flag NUMBER;
7239: l_mmtt c_mmtt%ROWTYPE;
7240: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7241:
7242: BEGIN
7243: -- write parameter value to log file
7244: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7417: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7413: l_num_snapshot NUMBER;
7414: l_returnValue NUMBER;
7415: l_interface_table NUMBER;
7416: l_msgCount NUMBER;
7417: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7418:
7419: BEGIN
7420: -- write parameter value to log file
7421: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7576: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7572: l_move_rec c_move_rec%ROWTYPE;
7573: l_returnStatus VARCHAR(1);
7574: l_errMsg VARCHAR(240);
7575: l_params wip_logger.param_tbl_t;
7576: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7577: BEGIN
7578: IF (l_logLevel <= wip_constants.trace_logging) THEN
7579: l_params(1).paramName := 'p_gib.group_id';
7580: l_params(1).paramValue := p_gib.group_id;

Line 7739: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7735: l_scrap_flag NUMBER := -1;
7736: l_step NUMBER;
7737: l_transaction_mode NUMBER;
7738: l_move move_profile_rec_t;
7739: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7740: l_update_po c_update_po%ROWTYPE;
7741: BEGIN
7742: l_move := p_gib.move_profile;
7743:

Line 8416: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

8412: l_txn_direction NUMBER;
8413: l_mti_lot_rec NUMBER; -- number of record under lot control
8414: l_mti_ser_rec NUMBER; -- number of record under serial control
8415: l_move move_profile_rec_t;
8416: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
8417: l_bf_required NUMBER; -- throw away value
8418: l_ls_required NUMBER;
8419: l_addMsgToStack VARCHAR2(1);
8420: BEGIN

Line 9190: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9186:
9187: l_params wip_logger.param_tbl_t;
9188: l_returnStatus VARCHAR(1);
9189: l_errMsg VARCHAR2(240);
9190: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9191:
9192: BEGIN
9193: IF (l_logLevel <= wip_constants.trace_logging) THEN
9194: l_params(1).paramName := 'p_group_id';

Line 9305: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9301: l_po BOOLEAN;
9302: l_poStatus VARCHAR(1);
9303: l_poIndustry VARCHAR(1);
9304: l_poSchema VARCHAR(10);
9305: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9306:
9307: BEGIN
9308: l_move := p_gib.move_profile;
9309:

Line 9679: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9675: l_last_bf_op NUMBER := -1;
9676: l_bf_qty NUMBER;
9677: l_forward NUMBER;
9678: l_mov_txn_id NUMBER;
9679: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9680: l_bf_required NUMBER; -- throw away value
9681: l_ls_required NUMBER;
9682: -- New variable to pass to OSFM new backflush API.
9683: l_error_msg VARCHAR2(1000);

Line 10647: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

10643:
10644: l_params wip_logger.param_tbl_t;
10645: l_returnStatus VARCHAR2(1);
10646: l_msg VARCHAR(240);
10647: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
10648: BEGIN
10649: -- write parameter value to log file
10650: IF (l_logLevel <= wip_constants.trace_logging) THEN
10651: l_params(1).paramName := 'p_tmp_id';

Line 10980: l_log_level NUMBER := fnd_log.g_current_runtime_level;

10976: wmt.to_operation_seq_num to_op
10977: FROM wip_move_transactions wmt
10978: WHERE wmt.transaction_id = p_group_id;
10979:
10980: l_log_level NUMBER := fnd_log.g_current_runtime_level;
10981: l_error_msg VARCHAR2(1000);
10982: l_process_phase VARCHAR2(3);
10983: l_return_status VARCHAR(1);
10984: l_errors c_errors%ROWTYPE;