70: l_label_status varchar2(30);
71: l_msg_data varchar2(240);
72: l_params wip_logger.param_tbl_t;
73: l_returnStatus varchar2(1);
74: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
75: begin
76: p_ret_status := fnd_api.g_ret_sts_success;
77:
78: if (l_logLevel <= wip_constants.trace_logging) then
143: l_temp_id number;
144:
145: l_params wip_logger.param_tbl_t;
146: l_returnStatus varchar2(1);
147: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
148: begin
149: p_ret_status := fnd_api.g_ret_sts_success;
150:
151: if (l_logLevel <= wip_constants.trace_logging) then
288: p_msg_data OUT NOCOPY VARCHAR2,
289: p_label_status OUT NOCOPY VARCHAR2) is
290: l_params wip_logger.param_tbl_t;
291: l_returnStatus varchar2(1);
292: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
293: begin
294: p_ret_status := fnd_api.g_ret_sts_success;
295:
296: if (l_logLevel <= wip_constants.trace_logging) then
826: l_org_id NUMBER;
827: l_item_id NUMBER;
828: l_label_status VARCHAR2(30);
829: l_returnStatus VARCHAR2(1);
830: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
831: l_params wip_logger.param_tbl_t;
832: l_msg_data VARCHAR2(100);
833:
834: CURSOR job_serials (p_org_id NUMBER, p_we_id NUMBER, p_item_id NUMBER)
966: l_item_id NUMBER;
967: l_label_status VARCHAR2(30);
968: l_msg_data VARCHAR2(100);
969: l_returnStatus VARCHAR2(1);
970: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
971: l_params wip_logger.param_tbl_t;
972:
973: -- Start : Changes to fix bug #6860138 --
974: l_lot_number VARCHAR2(80);
1094: )
1095: IS
1096: l_label_status VARCHAR2(30);
1097: l_returnStatus VARCHAR2(1);
1098: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1099: l_params wip_logger.param_tbl_t;
1100: l_msg_data VARCHAR2(100);
1101:
1102: BEGIN