DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on FND_LOG

Line 205: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

201: l_params wip_logger.param_tbl_t;
202: l_returnStatus VARCHAR2(1);
203: l_errMsg VARCHAR(240);
204: l_msg VARCHAR(240);
205: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
206: l_bf_required NUMBER; -- throw away value
207: l_ls_required NUMBER;
208: -- New variable to pass to OSFM new backflush API.
209: l_error_msg VARCHAR2(1000);

Line 428: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

424:
425: l_params wip_logger.param_tbl_t;
426: l_returnStatus VARCHAR(1);
427: l_msg VARCHAR(240);
428: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
429: BEGIN
430: -- write parameter value to log file
431: IF (l_logLevel <= wip_constants.trace_logging) THEN
432: l_params(1).paramName := 'p_mtl_header_id';

Line 616: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

612: l_mtl_errors c_mtl_errors%ROWTYPE;
613: l_params wip_logger.param_tbl_t;
614: l_returnStatus VARCHAR(1);
615: l_errMsg VARCHAR2(240);
616: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
617: l_count NUMBER;
618: BEGIN
619: -- write parameter value to log file
620: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 717: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

713: l_wipops c_wipops%ROWTYPE;
714: l_returnStatus VARCHAR(1);
715: l_errMsg VARCHAR2(240);
716: l_params wip_logger.param_tbl_t;
717: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
718:
719: BEGIN
720: -- write parameter value to log file
721: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 869: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

865: l_quantity NUMBER := p_quantity;
866: l_recordFound NUMBER := 0;
867: l_need_more BOOLEAN := TRUE;
868: l_dummy NUMBER := 0;
869: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
870:
871: BEGIN
872: -- write parameter value to log file
873: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1096: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1092: l_first_dept_code VARCHAR2(10);
1093: l_first_dept_id NUMBER := 0;
1094: l_first_op_seq_num NUMBER := 0;
1095: l_oc_txn_id NUMBER := 0;
1096: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1097:
1098: BEGIN
1099: -- write parameter value to log file
1100: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1243: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1239:
1240: l_params wip_logger.param_tbl_t;
1241: l_returnStatus VARCHAR(1);
1242: l_errMsg VARCHAR2(240);
1243: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1244: l_forward_move NUMBER;
1245: BEGIN
1246: FOR i IN 1..p_scheCount LOOP
1247: -- write parameter value to log file

Line 1446: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1442:
1443: l_params wip_logger.param_tbl_t;
1444: l_returnStatus VARCHAR2(1);
1445: l_errMsg VARCHAR2(240);
1446: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1447:
1448: BEGIN
1449: -- write parameter values to log file
1450: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1603: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

1599: l_sche_count NUMBER;
1600: l_oc_fm_op NUMBER;
1601: l_rec_count NUMBER :=0;
1602: l_proc_status NUMBER;
1603: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1604: l_msg_data VARCHAR2(2000);
1605: l_propagate_job_change_to_po NUMBER;
1606: BEGIN
1607: -- write parameter value to log file

Line 2020: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2016:
2017: l_params wip_logger.param_tbl_t;
2018: l_returnStatus VARCHAR(1);
2019: l_errMsg VARCHAR2(240);
2020: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2021: l_forward_move NUMBER;
2022:
2023: BEGIN
2024: -- write parameter value to log file

Line 2300: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2296: -- Fixed bug 4406536. We should initialized l_notenough at the beginning of
2297: -- for loop, not the declaration part.
2298: -- l_notenough BOOLEAN := FALSE;
2299: l_notenough BOOLEAN;
2300: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2301: -- new variables added for serial location check
2302: l_opSeq NUMBER;
2303: l_step NUMBER;
2304: l_msg_data VARCHAR2(2000);

Line 2698: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2694: l_po_lot NUMBER;
2695: l_completion NUMBER;
2696: l_return NUMBER;
2697: l_move move_profile_rec_t;
2698: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2699:
2700: BEGIN
2701: -- initialize l_move
2702: l_move := p_gib.move_profile;

Line 2900: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

2896: l_params wip_logger.param_tbl_t;
2897: l_returnStatus VARCHAR(1);
2898: l_msg VARCHAR(240);
2899: l_errMsg VARCHAR2(240);
2900: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2901:
2902: BEGIN
2903: -- write parameter value to log file
2904: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 3277: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3273: l_params wip_logger.param_tbl_t;
3274: l_returnStatus VARCHAR(1);
3275: l_errMsg VARCHAR2(240);
3276: l_outcome NUMBER := -1;
3277: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3278:
3279: BEGIN
3280: -- write parameter value to log file
3281: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 3343: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

3339: l_returnStatus VARCHAR(1);
3340: l_msg VARCHAR(240);
3341: l_errMsg VARCHAR2(240);
3342: l_move move_profile_rec_t;
3343: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3344:
3345: BEGIN
3346: l_move := p_gib.move_profile;
3347:

Line 4497: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

4493: l_params wip_logger.param_tbl_t;
4494: l_returnStatus VARCHAR(1);
4495: l_msg VARCHAR(240);
4496: l_errMsg VARCHAR2(240);
4497: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
4498:
4499: BEGIN
4500: -- write parameter value to log file
4501: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 4635: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

4631: l_returnStatus VARCHAR(1);
4632: l_msg VARCHAR(240);
4633: l_errMsg VARCHAR2(240);
4634: l_move move_profile_rec_t;
4635: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
4636:
4637: BEGIN
4638: l_move := p_gib.move_profile;
4639:

Line 5765: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

5761: l_params wip_logger.param_tbl_t;
5762: l_returnStatus VARCHAR(1);
5763: l_msg VARCHAR(240);
5764: l_errMsg VARCHAR2(240);
5765: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
5766:
5767: BEGIN
5768: -- write parameter value to log file
5769: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 5898: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

5894: l_msg VARCHAR(240);
5895: l_errMsg VARCHAR2(240);
5896: l_additional_reqs c_additional_reqs%ROWTYPE;
5897: l_move move_profile_rec_t;
5898: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
5899:
5900: BEGIN
5901: l_move := p_gib.move_profile;
5902:

Line 6957: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

6953: l_returnStatus VARCHAR(1);
6954: l_errMsg VARCHAR2(240);
6955: l_wmti_txn c_wmti_txn%ROWTYPE;
6956: l_itemkey VARCHAR2(80) := NULL;
6957: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
6958: l_success NUMBER := 0;
6959: l_org_id number;
6960: l_ou_id number;
6961: l_org_acct_ctxt VARCHAR2(30):= 'Accounting Information';

Line 7141: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7137: l_params wip_logger.param_tbl_t;
7138: l_returnStatus VARCHAR(1);
7139: l_msg VARCHAR(240);
7140: l_errMsg VARCHAR2(240);
7141: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7142:
7143: BEGIN
7144: -- write parameter value to log file
7145: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7353: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7349: l_returnValue NUMBER;
7350: l_msgCount NUMBER;
7351: l_errCode VARCHAR(240);
7352: l_errMsg VARCHAR(240);
7353: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7354:
7355: BEGIN
7356: -- write parameter value to log file
7357: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7442: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7438: l_errMsg VARCHAR(240);
7439: l_pri_cost_method NUMBER;
7440: l_mandatory_scrap_flag NUMBER;
7441: l_mmtt c_mmtt%ROWTYPE;
7442: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7443:
7444: BEGIN
7445: -- write parameter value to log file
7446: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7619: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7615: l_num_snapshot NUMBER;
7616: l_returnValue NUMBER;
7617: l_interface_table NUMBER;
7618: l_msgCount NUMBER;
7619: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7620:
7621: BEGIN
7622: -- write parameter value to log file
7623: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 7777: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7773: l_move_rec c_move_rec%ROWTYPE;
7774: l_returnStatus VARCHAR(1);
7775: l_errMsg VARCHAR(240);
7776: l_params wip_logger.param_tbl_t;
7777: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7778: BEGIN
7779: IF (l_logLevel <= wip_constants.trace_logging) THEN
7780: l_params(1).paramName := 'p_gib.group_id';
7781: l_params(1).paramValue := p_gib.group_id;

Line 7940: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

7936: l_scrap_flag NUMBER := -1;
7937: l_step NUMBER;
7938: l_transaction_mode NUMBER;
7939: l_move move_profile_rec_t;
7940: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
7941: l_update_po c_update_po%ROWTYPE;
7942: l_osp_op_seq_num NUMBER; --fix bug 6607192
7943: l_update_po_qty NUMBER;
7944: BEGIN

Line 8659: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

8655: l_txn_direction NUMBER;
8656: l_mti_lot_rec NUMBER; -- number of record under lot control
8657: l_mti_ser_rec NUMBER; -- number of record under serial control
8658: l_move move_profile_rec_t;
8659: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
8660: l_bf_required NUMBER; -- throw away value
8661: l_ls_required NUMBER;
8662: l_addMsgToStack VARCHAR2(1);
8663: BEGIN

Line 9463: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9459:
9460: l_params wip_logger.param_tbl_t;
9461: l_returnStatus VARCHAR(1);
9462: l_errMsg VARCHAR2(240);
9463: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9464:
9465: BEGIN
9466: IF (l_logLevel <= wip_constants.trace_logging) THEN
9467: l_params(1).paramName := 'p_group_id';

Line 9578: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9574: l_po BOOLEAN;
9575: l_poStatus VARCHAR(1);
9576: l_poIndustry VARCHAR(1);
9577: l_poSchema VARCHAR(10);
9578: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9579:
9580: BEGIN
9581: l_move := p_gib.move_profile;
9582:

Line 9965: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

9961: l_last_bf_op NUMBER := -1;
9962: l_bf_qty NUMBER;
9963: l_forward NUMBER;
9964: l_mov_txn_id NUMBER;
9965: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
9966: l_bf_required NUMBER; -- throw away value
9967: l_ls_required NUMBER;
9968: -- New variable to pass to OSFM new backflush API.
9969: l_error_msg VARCHAR2(1000);

Line 11004: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

11000:
11001: l_params wip_logger.param_tbl_t;
11002: l_returnStatus VARCHAR2(1);
11003: l_msg VARCHAR(240);
11004: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
11005: BEGIN
11006: -- write parameter value to log file
11007: IF (l_logLevel <= wip_constants.trace_logging) THEN
11008: l_params(1).paramName := 'p_tmp_id';

Line 11338: l_log_level NUMBER := fnd_log.g_current_runtime_level;

11334: wmt.to_operation_seq_num to_op
11335: FROM wip_move_transactions wmt
11336: WHERE wmt.transaction_id = p_group_id;
11337:
11338: l_log_level NUMBER := fnd_log.g_current_runtime_level;
11339: l_error_msg VARCHAR2(1000);
11340: l_mti_lot_rec NUMBER;
11341: l_process_phase VARCHAR2(3);
11342: l_return_status VARCHAR(1);