eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_UTILITIES dependencies on WIP_CONSTANTS

Line 78: if (l_logLevel <= wip_constants.trace_logging) then

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
79: l_params(1).paramName := 'p_txn_id';
80: l_params(1).paramValue := p_txn_id;
81: l_params(2).paramName := 'p_table_type';
82: l_params(2).paramValue := p_table_type;

Line 111: if (l_logLevel <= wip_constants.trace_logging) then

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

Line 136: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;

132: select transaction_temp_id, rowid
133: from mtl_material_transactions_temp
134: where transaction_header_id = x_txn_header_id
135: and transaction_source_type_id = 5
136: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
137: cursor get_mti(x_txn_header_id number) is
138: select transaction_interface_id, rowid
139: from mtl_transactions_interface
140: where transaction_header_id = x_txn_header_id

Line 142: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;

138: select transaction_interface_id, rowid
139: from mtl_transactions_interface
140: where transaction_header_id = x_txn_header_id
141: and transaction_source_type_id = 5
142: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
143: l_temp_id number;
144:
145: l_params wip_logger.param_tbl_t;
146: l_returnStatus varchar2(1);

Line 151: if (l_logLevel <= wip_constants.trace_logging) then

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
152: l_params(1).paramName := 'p_txn_id';
153: l_params(1).paramValue := p_txn_id;
154: l_params(2).paramName := 'p_table_type';
155: l_params(2).paramValue := p_table_type;

Line 184: if (l_logLevel <= wip_constants.trace_logging) then

180: where rowid = inv_rec.rowid;
181: else
182: l_temp_id := inv_rec.transaction_interface_id;
183: end if;
184: if (l_logLevel <= wip_constants.trace_logging) then
185: wip_logger.log(p_msg => 'Calling INV_LABEL.print_label_wrap',
186: x_returnStatus => l_returnStatus);
187: wip_logger.log(p_msg => 'p_label_status:'||p_label_status,
188: x_returnStatus => l_returnStatus);

Line 206: if (l_logLevel <= wip_constants.trace_logging) then

202: x_label_status => p_label_status,
203: p_business_flow_code => p_business_flow_code,
204: p_transaction_id => l_temp_id,
205: p_transaction_identifier => 2); -- interface
206: if (l_logLevel <= wip_constants.trace_logging) then
207: wip_logger.log(p_msg => 'After Calling INV_LABEL.print_label_wrap',
208: x_returnStatus => l_returnStatus);
209: wip_logger.log(p_msg => 'After Calling INV_LABEL p_label_status:'||p_label_status,
210: x_returnStatus => l_returnStatus);

Line 230: if (l_logLevel <= wip_constants.trace_logging) then

226: where rowid = inv_rec.rowid;
227: else
228: l_temp_id := inv_rec.transaction_temp_id;
229: end if;
230: if (l_logLevel <= wip_constants.trace_logging) then
231: wip_logger.log(p_msg => 'Calling2 INV_LABEL.print_label_wrap',
232: x_returnStatus => l_returnStatus);
233: wip_logger.log(p_msg => 'p_label_status:'||p_label_status,
234: x_returnStatus => l_returnStatus);

Line 249: if (l_logLevel <= wip_constants.trace_logging) then

245: x_label_status => p_label_status,
246: p_business_flow_code => p_business_flow_code,
247: p_transaction_id => l_temp_id,
248: p_transaction_identifier => 1); -- MMTT
249: if (l_logLevel <= wip_constants.trace_logging) then
250: wip_logger.log(p_msg => 'After Calling2 INV_LABEL.print_label_wrap',
251: x_returnStatus => l_returnStatus);
252: wip_logger.log(p_msg => 'After Calling INV_LABEL p_label_status:'||p_label_status,
253: x_returnStatus => l_returnStatus);

Line 262: if (l_logLevel <= wip_constants.trace_logging) then

258: end if;
259: end loop;
260: end if;
261:
262: if (l_logLevel <= wip_constants.trace_logging) then
263: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',
264: p_procReturnStatus => p_ret_status,
265: p_msg => p_msg_data,
266: x_returnStatus => l_returnStatus); --discard logging return status

Line 296: if (l_logLevel <= wip_constants.trace_logging) then

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
297: l_params(1).paramName := 'p_business_flow_code';
298: l_params(1).paramValue := p_business_flow_code;
299: l_params(2).paramName := 'p_label_type_id';
300: l_params(2).paramValue := p_label_type_id;

Line 359: if (l_logLevel <= wip_constants.trace_logging) then

355: x_msg_count => p_msg_count,
356: x_msg_data => p_msg_data,
357: x_label_status => p_label_status);
358:
359: if (l_logLevel <= wip_constants.trace_logging) then
360: wip_logger.exitPoint(p_procName => 'wip_utils.print_label',
361: p_procReturnStatus => p_ret_status,
362: p_msg => p_msg_data,
363: x_returnStatus => l_returnStatus); --discard logging return status

Line 599: when wip_constants.records_locked then

595: if(x_return_status <> fnd_api.g_ret_sts_success) then
596: raise fnd_api.g_exc_unexpected_error;
597: end if;
598: exception
599: when wip_constants.records_locked then
600: rollback to wipupdserial0;
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: fnd_message.set_name('WIP', 'SERIAL_NUMBERS_LOCKED');
603: fnd_msg_pub.add;

Line 641: p_skip_serial => wip_constants.yes,

637: p_group_mark_id => p_wip_entity_id,
638: p_line_mark_id => null,
639: p_rev => p_revision,
640: p_lot => p_lot,
641: p_skip_serial => wip_constants.yes,
642: x_start_ser => x_start_serial,
643: x_end_ser => x_end_serial,
644: x_proc_msg => x_err_msg);
645: else

Line 673: x_return_status := WIP_CONSTANTS.WARN;

669: end if;
670: end if;
671: /* For Bug 5860709 : Returning 'W' for status 2-Warning*/
672: if(l_status = 2 ) then
673: x_return_status := WIP_CONSTANTS.WARN;
674: --if(l_status <> 0) then
675: elsif(l_status <> 0) then
676: x_return_status := fnd_api.g_ret_sts_error;
677: end if;

Line 705: RETURN WIP_CONSTANTS.YES;

701: AND mln.inventory_item_id = p_item_id
702: AND mln.lot_number = p_lot_number);
703:
704: IF(l_require_lot_attr = 2) THEN
705: RETURN WIP_CONSTANTS.YES;
706: ELSE
707: RETURN WIP_CONSTANTS.NO;
708: END IF;
709:

Line 707: RETURN WIP_CONSTANTS.NO;

703:
704: IF(l_require_lot_attr = 2) THEN
705: RETURN WIP_CONSTANTS.YES;
706: ELSE
707: RETURN WIP_CONSTANTS.NO;
708: END IF;
709:
710: EXCEPTION
711: WHEN others THEN -- include NO_DATA_FOUND exception too

Line 712: RETURN WIP_CONSTANTS.NO;

708: END IF;
709:
710: EXCEPTION
711: WHEN others THEN -- include NO_DATA_FOUND exception too
712: RETURN WIP_CONSTANTS.NO;
713: END require_lot_attributes;
714:
715: PROCEDURE get_locator(p_locator_id IN NUMBER,
716: p_org_id IN NUMBER,

Line 742: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN

738: WHERE mln.organization_id = p_org_id
739: AND mln.inventory_item_id = p_item_id
740: AND mln.lot_number = p_lot_number);
741:
742: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
743: RETURN WIP_CONSTANTS.YES;
744: ELSE
745: RETURN WIP_CONSTANTS.NO;
746: END IF;

Line 743: RETURN WIP_CONSTANTS.YES;

739: AND mln.inventory_item_id = p_item_id
740: AND mln.lot_number = p_lot_number);
741:
742: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
743: RETURN WIP_CONSTANTS.YES;
744: ELSE
745: RETURN WIP_CONSTANTS.NO;
746: END IF;
747:

Line 745: RETURN WIP_CONSTANTS.NO;

741:
742: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
743: RETURN WIP_CONSTANTS.YES;
744: ELSE
745: RETURN WIP_CONSTANTS.NO;
746: END IF;
747:
748: EXCEPTION
749: WHEN others THEN -- include NO_DATA_FOUND exception too

Line 750: RETURN WIP_CONSTANTS.NO;

746: END IF;
747:
748: EXCEPTION
749: WHEN others THEN -- include NO_DATA_FOUND exception too
750: RETURN WIP_CONSTANTS.NO;
751: END is_user_defined_lot_exp;
752:
753: FUNCTION is_dff_required(p_application_id IN NUMBER,
754: p_dff_name IN VARCHAR2)

Line 845: if (l_logLevel <= wip_constants.trace_logging) then

841:
842: BEGIN
843: x_status := fnd_api.g_ret_sts_success;
844:
845: if (l_logLevel <= wip_constants.trace_logging) then
846: l_params(1).paramName := 'p_wip_entity_id';
847: l_params(1).paramValue := p_wip_entity_id;
848: -- l_params(2).paramName := 'p_op_seq_num';
849: -- l_params(2).paramValue := p_op_seq_num;

Line 890: if (l_logLevel <= wip_constants.trace_logging) then

886: X_RETURN_STATUS => x_status,
887: X_MSG_COUNT => x_msg_count,
888: X_MSG_DATA => l_msg_data,
889: X_LABEL_STATUS => l_label_status);
890: if (l_logLevel <= wip_constants.trace_logging) then
891: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results',
892: x_returnStatus => l_returnStatus); --discard logging return status
893: wip_logger.log(p_msg => x_status,
894: x_returnStatus => l_returnStatus); --discard logging return status

Line 936: if (l_logLevel <= wip_constants.trace_logging) then

932: x_msg => l_msg_data
933: );
934: -- End : Changes to fix bug #6860138 --
935:
936: if (l_logLevel <= wip_constants.trace_logging) then
937: wip_logger.log(p_msg => 'INV_LABEL.PRINT_LABEL_MANUAL_WRAP results for serial '||serial_num.serial_number,
938: x_returnStatus => l_returnStatus); --discard logging return status
939: wip_logger.log(p_msg => x_status,
940: x_returnStatus => l_returnStatus); --discard logging return status

Line 947: if (l_logLevel <= wip_constants.trace_logging) then

943: end if;
944:
945: END LOOP;
946:
947: if (l_logLevel <= wip_constants.trace_logging) then
948: wip_logger.exitPoint(p_procName => 'wip_utils.print_job_labels',
949: p_procReturnStatus => x_status,
950: p_msg => l_msg_data,
951: x_returnStatus => l_returnStatus); --discard logging return status

Line 982: if (l_logLevel <= wip_constants.trace_logging) then

978:
979: BEGIN
980: x_status := fnd_api.g_ret_sts_success;
981:
982: if (l_logLevel <= wip_constants.trace_logging) then
983: l_params(1).paramName := 'p_org_id';
984: l_params(1).paramValue := p_org_id;
985: l_params(2).paramName := 'p_serial_number';
986: l_params(2).paramValue := p_serial_number;

Line 1037: WIP_CONSTANTS.REV,

1033: -- Start : Changes to fix bug #6860138 --
1034: SELECT wdj.lot_number,
1035: wdj.scheduled_start_date,
1036: DECODE(msi.revision_qty_control_code,
1037: WIP_CONSTANTS.REV,
1038: NVL(wdj.bom_revision,
1039: BOM_revisions.GET_ITEM_REVISION_FN
1040: ('EXCLUDE_OPEN_HOLD',-- eco_status
1041: 'ALL', -- examine_type

Line 1080: if (l_logLevel <= wip_constants.trace_logging) then

1076: X_MSG_COUNT => x_msg_count,
1077: X_MSG_DATA => l_msg_data,
1078: X_LABEL_STATUS => l_label_status);
1079:
1080: if (l_logLevel <= wip_constants.trace_logging) then
1081: wip_logger.exitPoint(p_procName => 'wip_utils.print_serial_label',
1082: p_procReturnStatus => x_status,
1083: p_msg => l_msg_data,
1084: x_returnStatus => l_returnStatus); --discard logging return status

Line 1105: if (l_logLevel <= wip_constants.trace_logging) then

1101:
1102: BEGIN
1103: x_status := fnd_api.g_ret_sts_success;
1104:
1105: if (l_logLevel <= wip_constants.trace_logging) then
1106: l_params(1).paramName := 'p_txn_id';
1107: l_params(1).paramValue := p_txn_id;
1108: l_params(2).paramName := 'x_status';
1109: l_params(2).paramValue := x_status;

Line 1131: if (l_logLevel <= wip_constants.trace_logging) then

1127: P_BUSINESS_FLOW_CODE => 41,
1128: P_TRANSACTION_ID => p_txn_id, -- from WMT
1129: P_TRANSACTION_IDENTIFIER => 9);
1130:
1131: if (l_logLevel <= wip_constants.trace_logging) then
1132: wip_logger.exitPoint(p_procName => 'wip_utils.print_move_txn_label',
1133: p_procReturnStatus => x_status,
1134: p_msg => l_msg_data,
1135: x_returnStatus => l_returnStatus); --discard logging return status