[Home] [Help]
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
138: l_temp_id number;
139:
140: l_params wip_logger.param_tbl_t;
141: l_returnStatus varchar2(1);
142: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
143: begin
144: p_ret_status := fnd_api.g_ret_sts_success;
145:
146: if (l_logLevel <= wip_constants.trace_logging) then
235: p_msg_data OUT NOCOPY VARCHAR2,
236: p_label_status OUT NOCOPY VARCHAR2) is
237: l_params wip_logger.param_tbl_t;
238: l_returnStatus varchar2(1);
239: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
240: begin
241: p_ret_status := fnd_api.g_ret_sts_success;
242:
243: if (l_logLevel <= wip_constants.trace_logging) then
768: l_org_id NUMBER;
769: l_item_id NUMBER;
770: l_label_status VARCHAR2(30);
771: l_returnStatus VARCHAR2(1);
772: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
773: l_params wip_logger.param_tbl_t;
774: l_msg_data VARCHAR2(100);
775:
776: CURSOR job_serials (p_org_id NUMBER, p_we_id NUMBER, p_item_id NUMBER)
908: l_item_id NUMBER;
909: l_label_status VARCHAR2(30);
910: l_msg_data VARCHAR2(100);
911: l_returnStatus VARCHAR2(1);
912: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
913: l_params wip_logger.param_tbl_t;
914:
915: -- Start : Changes to fix bug #6860138 --
916: l_lot_number VARCHAR2(80);
1036: )
1037: IS
1038: l_label_status VARCHAR2(30);
1039: l_returnStatus VARCHAR2(1);
1040: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1041: l_params wip_logger.param_tbl_t;
1042: l_msg_data VARCHAR2(100);
1043:
1044: BEGIN