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 106: if (l_logLevel <= wip_constants.trace_logging) then

102: if (p_ret_status <> 'S') then
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

Line 131: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;

127: select transaction_temp_id, rowid
128: from mtl_material_transactions_temp
129: where transaction_header_id = x_txn_header_id
130: and transaction_source_type_id = 5
131: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
132: cursor get_mti(x_txn_header_id number) is
133: select transaction_interface_id, rowid
134: from mtl_transactions_interface
135: where transaction_header_id = x_txn_header_id

Line 137: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;

133: select transaction_interface_id, rowid
134: from mtl_transactions_interface
135: where transaction_header_id = x_txn_header_id
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);

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

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
147: l_params(1).paramName := 'p_txn_id';
148: l_params(1).paramValue := p_txn_id;
149: l_params(2).paramName := 'p_table_type';
150: l_params(2).paramValue := p_table_type;

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

205: p_transaction_identifier => 1); -- MMTT
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

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

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
244: l_params(1).paramName := 'p_business_flow_code';
245: l_params(1).paramValue := p_business_flow_code;
246: l_params(2).paramName := 'p_label_type_id';
247: l_params(2).paramValue := p_label_type_id;

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

298: x_msg_count => p_msg_count,
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

Line 541: when wip_constants.records_locked then

537: if(x_return_status <> fnd_api.g_ret_sts_success) then
538: raise fnd_api.g_exc_unexpected_error;
539: end if;
540: exception
541: when wip_constants.records_locked then
542: rollback to wipupdserial0;
543: x_return_status := fnd_api.g_ret_sts_unexp_error;
544: fnd_message.set_name('WIP', 'SERIAL_NUMBERS_LOCKED');
545: fnd_msg_pub.add;

Line 583: p_skip_serial => wip_constants.yes,

579: p_group_mark_id => p_wip_entity_id,
580: p_line_mark_id => null,
581: p_rev => p_revision,
582: p_lot => p_lot,
583: p_skip_serial => wip_constants.yes,
584: x_start_ser => x_start_serial,
585: x_end_ser => x_end_serial,
586: x_proc_msg => x_err_msg);
587: else

Line 615: x_return_status := WIP_CONSTANTS.WARN;

611: end if;
612: end if;
613: /* For Bug 5860709 : Returning 'W' for status 2-Warning*/
614: if(l_status = 2 ) then
615: x_return_status := WIP_CONSTANTS.WARN;
616: --if(l_status <> 0) then
617: elsif(l_status <> 0) then
618: x_return_status := fnd_api.g_ret_sts_error;
619: end if;

Line 647: RETURN WIP_CONSTANTS.YES;

643: AND mln.inventory_item_id = p_item_id
644: AND mln.lot_number = p_lot_number);
645:
646: IF(l_require_lot_attr = 2) THEN
647: RETURN WIP_CONSTANTS.YES;
648: ELSE
649: RETURN WIP_CONSTANTS.NO;
650: END IF;
651:

Line 649: RETURN WIP_CONSTANTS.NO;

645:
646: IF(l_require_lot_attr = 2) THEN
647: RETURN WIP_CONSTANTS.YES;
648: ELSE
649: RETURN WIP_CONSTANTS.NO;
650: END IF;
651:
652: EXCEPTION
653: WHEN others THEN -- include NO_DATA_FOUND exception too

Line 654: RETURN WIP_CONSTANTS.NO;

650: END IF;
651:
652: EXCEPTION
653: WHEN others THEN -- include NO_DATA_FOUND exception too
654: RETURN WIP_CONSTANTS.NO;
655: END require_lot_attributes;
656:
657: PROCEDURE get_locator(p_locator_id IN NUMBER,
658: p_org_id IN NUMBER,

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

680: WHERE mln.organization_id = p_org_id
681: AND mln.inventory_item_id = p_item_id
682: AND mln.lot_number = p_lot_number);
683:
684: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
685: RETURN WIP_CONSTANTS.YES;
686: ELSE
687: RETURN WIP_CONSTANTS.NO;
688: END IF;

Line 685: RETURN WIP_CONSTANTS.YES;

681: AND mln.inventory_item_id = p_item_id
682: AND mln.lot_number = p_lot_number);
683:
684: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
685: RETURN WIP_CONSTANTS.YES;
686: ELSE
687: RETURN WIP_CONSTANTS.NO;
688: END IF;
689:

Line 687: RETURN WIP_CONSTANTS.NO;

683:
684: IF(l_shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP) THEN
685: RETURN WIP_CONSTANTS.YES;
686: ELSE
687: RETURN WIP_CONSTANTS.NO;
688: END IF;
689:
690: EXCEPTION
691: WHEN others THEN -- include NO_DATA_FOUND exception too

Line 692: RETURN WIP_CONSTANTS.NO;

688: END IF;
689:
690: EXCEPTION
691: WHEN others THEN -- include NO_DATA_FOUND exception too
692: RETURN WIP_CONSTANTS.NO;
693: END is_user_defined_lot_exp;
694:
695: FUNCTION is_dff_required(p_application_id IN NUMBER,
696: p_dff_name IN VARCHAR2)

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

783:
784: BEGIN
785: x_status := fnd_api.g_ret_sts_success;
786:
787: if (l_logLevel <= wip_constants.trace_logging) then
788: l_params(1).paramName := 'p_wip_entity_id';
789: l_params(1).paramValue := p_wip_entity_id;
790: -- l_params(2).paramName := 'p_op_seq_num';
791: -- l_params(2).paramValue := p_op_seq_num;

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

828: X_RETURN_STATUS => x_status,
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

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

874: x_msg => l_msg_data
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

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

885: end if;
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

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

920:
921: BEGIN
922: x_status := fnd_api.g_ret_sts_success;
923:
924: if (l_logLevel <= wip_constants.trace_logging) then
925: l_params(1).paramName := 'p_org_id';
926: l_params(1).paramValue := p_org_id;
927: l_params(2).paramName := 'p_serial_number';
928: l_params(2).paramValue := p_serial_number;

Line 979: WIP_CONSTANTS.REV,

975: -- Start : Changes to fix bug #6860138 --
976: SELECT wdj.lot_number,
977: wdj.scheduled_start_date,
978: DECODE(msi.revision_qty_control_code,
979: WIP_CONSTANTS.REV,
980: NVL(wdj.bom_revision,
981: BOM_revisions.GET_ITEM_REVISION_FN
982: ('EXCLUDE_OPEN_HOLD',-- eco_status
983: 'ALL', -- examine_type

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

1018: X_MSG_COUNT => x_msg_count,
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

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

1043:
1044: BEGIN
1045: x_status := fnd_api.g_ret_sts_success;
1046:
1047: if (l_logLevel <= wip_constants.trace_logging) then
1048: l_params(1).paramName := 'p_txn_id';
1049: l_params(1).paramValue := p_txn_id;
1050: l_params(2).paramName := 'x_status';
1051: l_params(2).paramValue := x_status;

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

1069: P_BUSINESS_FLOW_CODE => 41,
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