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 FND_API

Line 76: p_ret_status := fnd_api.g_ret_sts_success;

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

Line 88: if(p_ret_status <> fnd_api.g_ret_sts_success) then

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;
90: end if;
91: end if;
92:

Line 89: raise fnd_api.g_exc_unexpected_error;

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;
90: end if;
91: end if;
92:
93: print_label(p_txn_id => p_txn_id,

Line 144: p_ret_status := fnd_api.g_ret_sts_success;

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

Line 156: if(p_ret_status <> fnd_api.g_ret_sts_success) then

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;
158: end if;
159: end if;
160:

Line 157: raise fnd_api.g_exc_unexpected_error;

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;
158: end if;
159: end if;
160:
161: if (p_table_type = 1) then -- mti

Line 241: p_ret_status := fnd_api.g_ret_sts_success;

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

Line 277: if(p_ret_status <> fnd_api.g_ret_sts_success) then

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;
279: end if;
280: end if;
281:

Line 278: raise fnd_api.g_exc_unexpected_error;

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;
279: end if;
280: end if;
281:
282: inv_label.print_label_manual_wrap(p_business_flow_code => p_business_flow_code,

Line 317: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,

313: l_curMsg VARCHAR2(2000) := '';
314: l_msgCount NUMBER;
315: l_separator VARCHAR2(30) := nvl(p_separator,' ');
316: begin
317: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,
318: p_count => l_msgCount,
319: p_data => p_msg);
320:
321: IF(l_msgCount > 1) THEN

Line 324: p_encoded => FND_API.g_false);

320:
321: IF(l_msgCount > 1) THEN
322: FOR i IN 1..l_msgCount LOOP
323: l_curMsg := fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1,
324: p_encoded => FND_API.g_false);
325: if(nvl(length(p_msg), 0) + length(l_curMsg) + length(l_separator) < 2000) then
326: p_msg := p_msg || l_separator || l_curMsg;
327: end if;
328: END LOOP;

Line 331: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then

327: end if;
328: END LOOP;
329: END IF;
330:
331: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
332: fnd_msg_pub.delete_msg;
333: end if;
334:
335: EXCEPTION

Line 340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

336: WHEN OTHERS THEN
337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
338: p_procedure_name => 'get_message_stack',
339: p_error_text => SQLERRM);
340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
342: fnd_msg_pub.delete_msg;
343: end if;
344: END get_message_stack;

Line 341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then

337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
338: p_procedure_name => 'get_message_stack',
339: p_error_text => SQLERRM);
340: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
341: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
342: fnd_msg_pub.delete_msg;
343: end if;
344: END get_message_stack;
345:

Line 537: if(x_return_status <> fnd_api.g_ret_sts_success) then

533: p_operation_seq_num => p_operation_seq_num,
534: p_intraoperation_step_type => p_intraoperation_step_type,
535: p_line_mark_id => p_line_mark_id);
536:
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

Line 538: raise fnd_api.g_exc_unexpected_error;

534: p_intraoperation_step_type => p_intraoperation_step_type,
535: p_line_mark_id => p_line_mark_id);
536:
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;

Line 543: x_return_status := fnd_api.g_ret_sts_unexp_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;
546: when fnd_api.g_exc_unexpected_error then
547: rollback to wipupdserial0;

Line 546: when fnd_api.g_exc_unexpected_error 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;
546: when fnd_api.g_exc_unexpected_error then
547: rollback to wipupdserial0;
548: --status and message should have been set by inv api. set status
549: --just in case.
550: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 550: x_return_status := fnd_api.g_ret_sts_unexp_error;

546: when fnd_api.g_exc_unexpected_error then
547: rollback to wipupdserial0;
548: --status and message should have been set by inv api. set status
549: --just in case.
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: when others then
553: rollback to wipupdserial0;
554: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 554: x_return_status := fnd_api.g_ret_sts_unexp_error;

550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: when others then
553: rollback to wipupdserial0;
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
556: p_procedure_name => 'update_serial',
557: p_error_text => SQLERRM);
558: end update_serial;

Line 573: x_return_status := fnd_api.g_ret_sts_success;

569: x_err_msg OUT NOCOPY VARCHAR2) is
570: l_status NUMBER;
571: l_qty NUMBER := p_qty;
572: begin
573: x_return_status := fnd_api.g_ret_sts_success;
574: if(x_start_serial is null) then
575: l_status := inv_serial_number_pub.generate_serials(p_org_id => p_org_id,
576: p_item_id => p_item_id,
577: p_qty => p_qty,

Line 609: p_delete_stack => fnd_api.g_false,

605: l_status = 0) then
606: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
607: fnd_msg_pub.add;
608: get_message_stack(p_msg => x_err_msg,
609: p_delete_stack => fnd_api.g_false,
610: p_separator => ' ');
611: end if;
612: end if;
613: /* For Bug 5860709 : Returning 'W' for status 2-Warning*/

Line 618: x_return_status := fnd_api.g_ret_sts_error;

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;
620: exception
621: when others then
622: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 622: x_return_status := fnd_api.g_ret_sts_unexp_error;

618: x_return_status := fnd_api.g_ret_sts_error;
619: end if;
620: exception
621: when others then
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: x_err_msg := SQLERRM;
624: end generate_serials;
625:
626: FUNCTION require_lot_attributes(p_org_id IN NUMBER,

Line 706: RETURN fnd_api.g_true;

702: x_application_id => p_application_id,
703: x_desc_flex_name => p_dff_name);
704:
705: IF(l_dff_required) THEN
706: RETURN fnd_api.g_true;
707: ELSE
708: RETURN fnd_api.g_false;
709: END IF;
710: END is_dff_required;

Line 708: RETURN fnd_api.g_false;

704:
705: IF(l_dff_required) THEN
706: RETURN fnd_api.g_true;
707: ELSE
708: RETURN fnd_api.g_false;
709: END IF;
710: END is_dff_required;
711:
712: FUNCTION is_dff_setup(p_application_id IN NUMBER,

Line 723: RETURN fnd_api.g_true;

719: x_application_id => p_application_id,
720: x_desc_flex_name => p_dff_name);
721:
722: IF(l_dff_setup) THEN
723: RETURN fnd_api.g_true;
724: ELSE
725: RETURN fnd_api.g_false;
726: END IF;
727: END is_dff_setup;

Line 725: RETURN fnd_api.g_false;

721:
722: IF(l_dff_setup) THEN
723: RETURN fnd_api.g_true;
724: ELSE
725: RETURN fnd_api.g_false;
726: END IF;
727: END is_dff_setup;
728:
729: /*Added the following function for bug 7138983(FP 7028072)*/

Line 785: x_status := fnd_api.g_ret_sts_success;

781: and wip_entity_id = p_we_id
782: AND inventory_item_id = p_item_id;
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;

Line 801: if(x_status <> fnd_api.g_ret_sts_success) then

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;
803: end if;
804: end if;
805:

Line 802: raise fnd_api.g_exc_unexpected_error;

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;
803: end if;
804: end if;
805:
806: select organization_id, primary_item_id

Line 922: x_status := fnd_api.g_ret_sts_success;

918: l_item_rev VARCHAR2(3);
919: -- End : Changes to fix bug #6860138 --
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;

Line 940: if(x_status <> fnd_api.g_ret_sts_success) then

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;
942: end if;
943: end if;
944:

Line 941: raise fnd_api.g_exc_unexpected_error;

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;
942: end if;
943: end if;
944:
945: l_item_id := p_item_id;

Line 1045: x_status := fnd_api.g_ret_sts_success;

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;
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;

Line 1059: if(x_status <> fnd_api.g_ret_sts_success) then

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;
1061: end if;
1062: end if;
1063:

Line 1060: raise fnd_api.g_exc_unexpected_error;

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;
1061: end if;
1062: end if;
1063:
1064: INV_LABEL.PRINT_LABEL_WRAP (