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 90: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

86: -- parameter for wip_logger.entryPoint.
87: wip_logger.entryPoint(p_procName => 'wip_utils.print_label_java',
88: p_params => l_params,
89: x_returnStatus => l_returnStatus);
90: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
91: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
92: -- we set p_ret_status := l_returnStatus
93: p_ret_status := l_returnStatus;
94: raise fnd_api.g_exc_unexpected_error;

Line 91: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,

87: wip_logger.entryPoint(p_procName => 'wip_utils.print_label_java',
88: p_params => l_params,
89: x_returnStatus => l_returnStatus);
90: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
91: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
92: -- we set p_ret_status := l_returnStatus
93: p_ret_status := l_returnStatus;
94: raise fnd_api.g_exc_unexpected_error;
95: end if;

Line 94: raise fnd_api.g_exc_unexpected_error;

90: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
91: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
92: -- we set p_ret_status := l_returnStatus
93: p_ret_status := l_returnStatus;
94: raise fnd_api.g_exc_unexpected_error;
95: end if;
96: end if;
97:
98: print_label(p_txn_id => p_txn_id,

Line 149: p_ret_status := fnd_api.g_ret_sts_success;

145: l_params wip_logger.param_tbl_t;
146: l_returnStatus varchar2(1);
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;

Line 162: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

158: --Fix bug 15904090, should not use p_ret_status as an output for wip_logger.entryPoint
159: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
160: p_params => l_params,
161: x_returnStatus => l_returnStatus);
162: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
163: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
164: -- we set p_ret_status := l_returnStatus
165: p_ret_status := l_returnStatus;
166: raise fnd_api.g_exc_unexpected_error;

Line 163: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,

159: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
160: p_params => l_params,
161: x_returnStatus => l_returnStatus);
162: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
163: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
164: -- we set p_ret_status := l_returnStatus
165: p_ret_status := l_returnStatus;
166: raise fnd_api.g_exc_unexpected_error;
167: end if;

Line 166: raise fnd_api.g_exc_unexpected_error;

162: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
163: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
164: -- we set p_ret_status := l_returnStatus
165: p_ret_status := l_returnStatus;
166: raise fnd_api.g_exc_unexpected_error;
167: end if;
168: end if;
169:
170: if (p_table_type = 1) then -- mti

Line 294: p_ret_status := fnd_api.g_ret_sts_success;

290: l_params wip_logger.param_tbl_t;
291: l_returnStatus varchar2(1);
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;

Line 331: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

327: --Fix bug 15904090, should not use p_ret_status as an output for wip_logger.entryPoint
328: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
329: p_params => l_params,
330: x_returnStatus => l_returnStatus);
331: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
332: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
333: -- we set p_ret_status := l_returnStatus
334: p_ret_status := l_returnStatus;
335: raise fnd_api.g_exc_unexpected_error;

Line 332: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,

328: wip_logger.entryPoint(p_procName => 'wip_utils.print_label',
329: p_params => l_params,
330: x_returnStatus => l_returnStatus);
331: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
332: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
333: -- we set p_ret_status := l_returnStatus
334: p_ret_status := l_returnStatus;
335: raise fnd_api.g_exc_unexpected_error;
336: end if;

Line 335: raise fnd_api.g_exc_unexpected_error;

331: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
332: -- Fix bug 15904090, only if l_returnStatus <> fnd_api.g_ret_sts_success,
333: -- we set p_ret_status := l_returnStatus
334: p_ret_status := l_returnStatus;
335: raise fnd_api.g_exc_unexpected_error;
336: end if;
337: end if;
338:
339: inv_label.print_label_manual_wrap(p_business_flow_code => p_business_flow_code,

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

370: l_curMsg VARCHAR2(2000) := '';
371: l_msgCount NUMBER;
372: l_separator VARCHAR2(30) := nvl(p_separator,' ');
373: begin
374: fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.g_false,
375: p_count => l_msgCount,
376: p_data => p_msg);
377:
378: IF(l_msgCount > 1) THEN

Line 381: p_encoded => FND_API.g_false);

377:
378: IF(l_msgCount > 1) THEN
379: FOR i IN 1..l_msgCount LOOP
380: l_curMsg := fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1,
381: p_encoded => FND_API.g_false);
382: if(nvl(length(p_msg), 0) + length(l_curMsg) + length(l_separator) < 2000) then
383: p_msg := p_msg || l_separator || l_curMsg;
384: end if;
385: END LOOP;

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

384: end if;
385: END LOOP;
386: END IF;
387:
388: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
389: fnd_msg_pub.delete_msg;
390: end if;
391:
392: EXCEPTION

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

393: WHEN OTHERS THEN
394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
395: p_procedure_name => 'get_message_stack',
396: p_error_text => SQLERRM);
397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
398: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
399: fnd_msg_pub.delete_msg;
400: end if;
401: END get_message_stack;

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

394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
395: p_procedure_name => 'get_message_stack',
396: p_error_text => SQLERRM);
397: p_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
398: if(fnd_api.to_boolean(nvl(p_delete_stack,fnd_api.g_true))) then
399: fnd_msg_pub.delete_msg;
400: end if;
401: END get_message_stack;
402:

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

591: p_operation_seq_num => p_operation_seq_num,
592: p_intraoperation_step_type => p_intraoperation_step_type,
593: p_line_mark_id => p_line_mark_id);
594:
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

Line 596: raise fnd_api.g_exc_unexpected_error;

592: p_intraoperation_step_type => p_intraoperation_step_type,
593: p_line_mark_id => p_line_mark_id);
594:
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;

Line 601: x_return_status := fnd_api.g_ret_sts_unexp_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;
604: when fnd_api.g_exc_unexpected_error then
605: rollback to wipupdserial0;

Line 604: when fnd_api.g_exc_unexpected_error 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;
604: when fnd_api.g_exc_unexpected_error then
605: rollback to wipupdserial0;
606: --status and message should have been set by inv api. set status
607: --just in case.
608: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 608: x_return_status := fnd_api.g_ret_sts_unexp_error;

604: when fnd_api.g_exc_unexpected_error then
605: rollback to wipupdserial0;
606: --status and message should have been set by inv api. set status
607: --just in case.
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: when others then
611: rollback to wipupdserial0;
612: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 612: x_return_status := fnd_api.g_ret_sts_unexp_error;

608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: when others then
611: rollback to wipupdserial0;
612: x_return_status := fnd_api.g_ret_sts_unexp_error;
613: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_utilities',
614: p_procedure_name => 'update_serial',
615: p_error_text => SQLERRM);
616: end update_serial;

Line 631: x_return_status := fnd_api.g_ret_sts_success;

627: x_err_msg OUT NOCOPY VARCHAR2) is
628: l_status NUMBER;
629: l_qty NUMBER := p_qty;
630: begin
631: x_return_status := fnd_api.g_ret_sts_success;
632: if(x_start_serial is null) then
633: l_status := inv_serial_number_pub.generate_serials(p_org_id => p_org_id,
634: p_item_id => p_item_id,
635: p_qty => p_qty,

Line 667: p_delete_stack => fnd_api.g_false,

663: l_status = 0) then
664: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
665: fnd_msg_pub.add;
666: get_message_stack(p_msg => x_err_msg,
667: p_delete_stack => fnd_api.g_false,
668: p_separator => ' ');
669: end if;
670: end if;
671: /* For Bug 5860709 : Returning 'W' for status 2-Warning*/

Line 676: x_return_status := fnd_api.g_ret_sts_error;

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;
678: exception
679: when others then
680: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 680: x_return_status := fnd_api.g_ret_sts_unexp_error;

676: x_return_status := fnd_api.g_ret_sts_error;
677: end if;
678: exception
679: when others then
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: x_err_msg := SQLERRM;
682: end generate_serials;
683:
684: FUNCTION require_lot_attributes(p_org_id IN NUMBER,

Line 764: RETURN fnd_api.g_true;

760: x_application_id => p_application_id,
761: x_desc_flex_name => p_dff_name);
762:
763: IF(l_dff_required) THEN
764: RETURN fnd_api.g_true;
765: ELSE
766: RETURN fnd_api.g_false;
767: END IF;
768: END is_dff_required;

Line 766: RETURN fnd_api.g_false;

762:
763: IF(l_dff_required) THEN
764: RETURN fnd_api.g_true;
765: ELSE
766: RETURN fnd_api.g_false;
767: END IF;
768: END is_dff_required;
769:
770: FUNCTION is_dff_setup(p_application_id IN NUMBER,

Line 781: RETURN fnd_api.g_true;

777: x_application_id => p_application_id,
778: x_desc_flex_name => p_dff_name);
779:
780: IF(l_dff_setup) THEN
781: RETURN fnd_api.g_true;
782: ELSE
783: RETURN fnd_api.g_false;
784: END IF;
785: END is_dff_setup;

Line 783: RETURN fnd_api.g_false;

779:
780: IF(l_dff_setup) THEN
781: RETURN fnd_api.g_true;
782: ELSE
783: RETURN fnd_api.g_false;
784: END IF;
785: END is_dff_setup;
786:
787: /*Added the following function for bug 7138983(FP 7028072)*/

Line 843: x_status := fnd_api.g_ret_sts_success;

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

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

855: l_params(4).paramValue := x_msg;
856: wip_logger.entryPoint(p_procName => 'wip_utils.print_job_labels',
857: p_params => l_params,
858: x_returnStatus => x_status);
859: if(x_status <> fnd_api.g_ret_sts_success) then
860: raise fnd_api.g_exc_unexpected_error;
861: end if;
862: end if;
863:

Line 860: raise fnd_api.g_exc_unexpected_error;

856: wip_logger.entryPoint(p_procName => 'wip_utils.print_job_labels',
857: p_params => l_params,
858: x_returnStatus => x_status);
859: if(x_status <> fnd_api.g_ret_sts_success) then
860: raise fnd_api.g_exc_unexpected_error;
861: end if;
862: end if;
863:
864: select organization_id, primary_item_id

Line 980: x_status := fnd_api.g_ret_sts_success;

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

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

994: l_params(6).paramValue := x_msg;
995: wip_logger.entryPoint(p_procName => 'wip_utils.print_serial_label',
996: p_params => l_params,
997: x_returnStatus => x_status);
998: if(x_status <> fnd_api.g_ret_sts_success) then
999: raise fnd_api.g_exc_unexpected_error;
1000: end if;
1001: end if;
1002:

Line 999: raise fnd_api.g_exc_unexpected_error;

995: wip_logger.entryPoint(p_procName => 'wip_utils.print_serial_label',
996: p_params => l_params,
997: x_returnStatus => x_status);
998: if(x_status <> fnd_api.g_ret_sts_success) then
999: raise fnd_api.g_exc_unexpected_error;
1000: end if;
1001: end if;
1002:
1003: l_item_id := p_item_id;

Line 1103: x_status := fnd_api.g_ret_sts_success;

1099: l_params wip_logger.param_tbl_t;
1100: l_msg_data VARCHAR2(100);
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;

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

1113: l_params(4).paramValue := x_msg;
1114: wip_logger.entryPoint(p_procName => 'wip_utils.print_move_txn_label',
1115: p_params => l_params,
1116: x_returnStatus => x_status);
1117: if(x_status <> fnd_api.g_ret_sts_success) then
1118: raise fnd_api.g_exc_unexpected_error;
1119: end if;
1120: end if;
1121:

Line 1118: raise fnd_api.g_exc_unexpected_error;

1114: wip_logger.entryPoint(p_procName => 'wip_utils.print_move_txn_label',
1115: p_params => l_params,
1116: x_returnStatus => x_status);
1117: if(x_status <> fnd_api.g_ret_sts_success) then
1118: raise fnd_api.g_exc_unexpected_error;
1119: end if;
1120: end if;
1121:
1122: INV_LABEL.PRINT_LABEL_WRAP (