DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on WIP_LOGGER

Line 72: l_params wip_logger.param_tbl_t;

68: p_business_flow_code IN NUMBER) IS
69: l_msg_count number;
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;

Line 85: wip_logger.entryPoint(p_procName => 'wip_utils.print_label_java',

81: l_params(2).paramName := 'p_table_type';
82: l_params(2).paramValue := p_table_type;
83: l_params(3).paramName := 'p_business_flow_code';
84: l_params(3).paramValue := p_business_flow_code;
85: wip_logger.entryPoint(p_procName => 'wip_utils.print_label_java',
86: p_params => l_params,
87: x_returnStatus => p_ret_status);
88: if(p_ret_status <> fnd_api.g_ret_sts_success) then
89: raise fnd_api.g_exc_unexpected_error;

Line 107: wip_logger.exitPoint(p_procName => 'wip_utils.print_label_java',

103: get_message_stack(p_msg => p_err_msg);
104: end if;
105:
106: if (l_logLevel <= wip_constants.trace_logging) then
107: wip_logger.exitPoint(p_procName => 'wip_utils.print_label_java',
108: p_procReturnStatus => p_ret_status,
109: p_msg => p_err_msg,
110: x_returnStatus => l_returnStatus); --discard logging return status
111: end if;

Line 140: l_params wip_logger.param_tbl_t;

136: and transaction_source_type_id = 5
137: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
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;

Line 153: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',

149: l_params(2).paramName := 'p_table_type';
150: l_params(2).paramValue := p_table_type;
151: l_params(3).paramName := 'p_business_flow_code';
152: l_params(3).paramValue := p_business_flow_code;
153: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
154: p_params => l_params,
155: x_returnStatus => p_ret_status);
156: if(p_ret_status <> fnd_api.g_ret_sts_success) then
157: raise fnd_api.g_exc_unexpected_error;

Line 210: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',

206: end loop;
207: end if;
208:
209: if (l_logLevel <= wip_constants.trace_logging) then
210: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',
211: p_procReturnStatus => p_ret_status,
212: p_msg => p_msg_data,
213: x_returnStatus => l_returnStatus); --discard logging return status
214: end if;

Line 237: l_params wip_logger.param_tbl_t;

233: p_ret_status OUT NOCOPY VARCHAR2,
234: p_msg_count OUT NOCOPY NUMBER,
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;

Line 274: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',

270: l_params(14).paramName := 'p_uom';
271: l_params(14).paramValue := p_uom;
272: l_params(15).paramName := 'p_no_of_copies';
273: l_params(15).paramValue := p_no_of_copies;
274: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
275: p_params => l_params,
276: x_returnStatus => p_ret_status);
277: if(p_ret_status <> fnd_api.g_ret_sts_success) then
278: raise fnd_api.g_exc_unexpected_error;

Line 303: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',

299: x_msg_data => p_msg_data,
300: x_label_status => p_label_status);
301:
302: if (l_logLevel <= wip_constants.trace_logging) then
303: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',
304: p_procReturnStatus => p_ret_status,
305: p_msg => p_msg_data,
306: x_returnStatus => l_returnStatus); --discard logging return status
307: end if;

Line 773: l_params wip_logger.param_tbl_t;

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)
777: IS

Line 798: wip_logger.entryPoint(p_procName => 'wip_utils.print_job_labels',

794: l_params(3).paramName := 'x_msg_count';
795: l_params(3).paramValue := x_msg_count;
796: l_params(4).paramName := 'x_msg';
797: l_params(4).paramValue := x_msg;
798: wip_logger.entryPoint(p_procName => 'wip_utils.print_job_labels',
799: p_params => l_params,
800: x_returnStatus => x_status);
801: if(x_status <> fnd_api.g_ret_sts_success) then
802: raise fnd_api.g_exc_unexpected_error;

Line 833: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results',

829: X_MSG_COUNT => x_msg_count,
830: X_MSG_DATA => l_msg_data,
831: X_LABEL_STATUS => l_label_status);
832: if (l_logLevel <= wip_constants.trace_logging) then
833: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results',
834: x_returnStatus => l_returnStatus); --discard logging return status
835: wip_logger.log(p_msg => x_status,
836: x_returnStatus => l_returnStatus); --discard logging return status
837: wip_logger.log(p_msg => l_msg_data,

Line 835: wip_logger.log(p_msg => x_status,

831: X_LABEL_STATUS => l_label_status);
832: if (l_logLevel <= wip_constants.trace_logging) then
833: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results',
834: x_returnStatus => l_returnStatus); --discard logging return status
835: wip_logger.log(p_msg => x_status,
836: x_returnStatus => l_returnStatus); --discard logging return status
837: wip_logger.log(p_msg => l_msg_data,
838: x_returnStatus => l_returnStatus); --discard logging return status
839: end if;

Line 837: wip_logger.log(p_msg => l_msg_data,

833: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results',
834: x_returnStatus => l_returnStatus); --discard logging return status
835: wip_logger.log(p_msg => x_status,
836: x_returnStatus => l_returnStatus); --discard logging return status
837: wip_logger.log(p_msg => l_msg_data,
838: x_returnStatus => l_returnStatus); --discard logging return status
839: end if;
840:
841:

Line 879: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results for serial '||serial_num.serial_number,

875: );
876: -- End : Changes to fix bug #6860138 --
877:
878: if (l_logLevel <= wip_constants.trace_logging) then
879: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results for serial '||serial_num.serial_number,
880: x_returnStatus => l_returnStatus); --discard logging return status
881: wip_logger.log(p_msg => x_status,
882: x_returnStatus => l_returnStatus); --discard logging return status
883: wip_logger.log(p_msg => l_msg_data,

Line 881: wip_logger.log(p_msg => x_status,

877:
878: if (l_logLevel <= wip_constants.trace_logging) then
879: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results for serial '||serial_num.serial_number,
880: x_returnStatus => l_returnStatus); --discard logging return status
881: wip_logger.log(p_msg => x_status,
882: x_returnStatus => l_returnStatus); --discard logging return status
883: wip_logger.log(p_msg => l_msg_data,
884: x_returnStatus => l_returnStatus); --discard logging return status
885: end if;

Line 883: wip_logger.log(p_msg => l_msg_data,

879: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results for serial '||serial_num.serial_number,
880: x_returnStatus => l_returnStatus); --discard logging return status
881: wip_logger.log(p_msg => x_status,
882: x_returnStatus => l_returnStatus); --discard logging return status
883: wip_logger.log(p_msg => l_msg_data,
884: x_returnStatus => l_returnStatus); --discard logging return status
885: end if;
886:
887: END LOOP;

Line 890: wip_logger.exitPoint(p_procName => 'wip_utils.print_job_labels',

886:
887: END LOOP;
888:
889: if (l_logLevel <= wip_constants.trace_logging) then
890: wip_logger.exitPoint(p_procName => 'wip_utils.print_job_labels',
891: p_procReturnStatus => x_status,
892: p_msg => l_msg_data,
893: x_returnStatus => l_returnStatus); --discard logging return status
894: end if;

Line 913: l_params wip_logger.param_tbl_t;

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);
917: l_sch_st_date DATE;

Line 937: wip_logger.entryPoint(p_procName => 'wip_utils.print_serial_label',

933: l_params(5).paramName := 'x_msg_count';
934: l_params(5).paramValue := x_msg_count;
935: l_params(6).paramName := 'x_msg';
936: l_params(6).paramValue := x_msg;
937: wip_logger.entryPoint(p_procName => 'wip_utils.print_serial_label',
938: p_params => l_params,
939: x_returnStatus => x_status);
940: if(x_status <> fnd_api.g_ret_sts_success) then
941: raise fnd_api.g_exc_unexpected_error;

Line 1023: wip_logger.exitPoint(p_procName => 'wip_utils.print_serial_label',

1019: X_MSG_DATA => l_msg_data,
1020: X_LABEL_STATUS => l_label_status);
1021:
1022: if (l_logLevel <= wip_constants.trace_logging) then
1023: wip_logger.exitPoint(p_procName => 'wip_utils.print_serial_label',
1024: p_procReturnStatus => x_status,
1025: p_msg => l_msg_data,
1026: x_returnStatus => l_returnStatus); --discard logging return status
1027: end if;

Line 1041: l_params wip_logger.param_tbl_t;

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
1045: x_status := fnd_api.g_ret_sts_success;

Line 1056: wip_logger.entryPoint(p_procName => 'wip_utils.print_move_txn_label',

1052: l_params(3).paramName := 'x_msg_count';
1053: l_params(3).paramValue := x_msg_count;
1054: l_params(4).paramName := 'x_msg';
1055: l_params(4).paramValue := x_msg;
1056: wip_logger.entryPoint(p_procName => 'wip_utils.print_move_txn_label',
1057: p_params => l_params,
1058: x_returnStatus => x_status);
1059: if(x_status <> fnd_api.g_ret_sts_success) then
1060: raise fnd_api.g_exc_unexpected_error;

Line 1074: wip_logger.exitPoint(p_procName => 'wip_utils.print_move_txn_label',

1070: P_TRANSACTION_ID => p_txn_id, -- from WMT
1071: P_TRANSACTION_IDENTIFIER => 9);
1072:
1073: if (l_logLevel <= wip_constants.trace_logging) then
1074: wip_logger.exitPoint(p_procName => 'wip_utils.print_move_txn_label',
1075: p_procReturnStatus => x_status,
1076: p_msg => l_msg_data,
1077: x_returnStatus => l_returnStatus); --discard logging return status
1078: end if;