DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PUB dependencies on FND_API

Line 45: IF (p_do_backflush = fnd_api.g_false) THEN

41: AND process_phase = WIP_CONSTANTS.MOVE_VAL
42: AND process_status = WIP_CONSTANTS.RUNNING
43: AND group_id IS NOT NULL;
44:
45: IF (p_do_backflush = fnd_api.g_false) THEN
46: l_do_backflush := fnd_api.g_false;
47: ELSE
48: l_do_backflush := fnd_api.g_true;
49: END IF;

Line 46: l_do_backflush := fnd_api.g_false;

42: AND process_status = WIP_CONSTANTS.RUNNING
43: AND group_id IS NOT NULL;
44:
45: IF (p_do_backflush = fnd_api.g_false) THEN
46: l_do_backflush := fnd_api.g_false;
47: ELSE
48: l_do_backflush := fnd_api.g_true;
49: END IF;
50:

Line 48: l_do_backflush := fnd_api.g_true;

44:
45: IF (p_do_backflush = fnd_api.g_false) THEN
46: l_do_backflush := fnd_api.g_false;
47: ELSE
48: l_do_backflush := fnd_api.g_true;
49: END IF;
50:
51: wip_movProc_priv.processIntf(p_group_id => l_groupID,
52: p_child_txn_id => -1,

Line 59: p_endDebug => fnd_api.g_false,

55: p_time_out => 0,
56: p_move_mode => WIP_CONSTANTS.BACKGROUND,
57: p_bf_mode => WIP_CONSTANTS.ONLINE,
58: p_mtl_mode => WIP_CONSTANTS.ONLINE,
59: p_endDebug => fnd_api.g_false,
60: p_initMsgList => fnd_api.g_true,
61: p_insertAssy => fnd_api.g_true,
62: p_do_backflush => l_do_backflush,
63: x_returnStatus => x_returnStatus);

Line 60: p_initMsgList => fnd_api.g_true,

56: p_move_mode => WIP_CONSTANTS.BACKGROUND,
57: p_bf_mode => WIP_CONSTANTS.ONLINE,
58: p_mtl_mode => WIP_CONSTANTS.ONLINE,
59: p_endDebug => fnd_api.g_false,
60: p_initMsgList => fnd_api.g_true,
61: p_insertAssy => fnd_api.g_true,
62: p_do_backflush => l_do_backflush,
63: x_returnStatus => x_returnStatus);
64:

Line 61: p_insertAssy => fnd_api.g_true,

57: p_bf_mode => WIP_CONSTANTS.ONLINE,
58: p_mtl_mode => WIP_CONSTANTS.ONLINE,
59: p_endDebug => fnd_api.g_false,
60: p_initMsgList => fnd_api.g_true,
61: p_insertAssy => fnd_api.g_true,
62: p_do_backflush => l_do_backflush,
63: x_returnStatus => x_returnStatus);
64:
65: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 65: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

61: p_insertAssy => fnd_api.g_true,
62: p_do_backflush => l_do_backflush,
63: x_returnStatus => x_returnStatus);
64:
65: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
66: raise fnd_api.g_exc_error;
67: END IF;
68:
69: IF(fnd_api.to_boolean(p_commit)) THEN

Line 66: raise fnd_api.g_exc_error;

62: p_do_backflush => l_do_backflush,
63: x_returnStatus => x_returnStatus);
64:
65: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
66: raise fnd_api.g_exc_error;
67: END IF;
68:
69: IF(fnd_api.to_boolean(p_commit)) THEN
70: COMMIT;

Line 69: IF(fnd_api.to_boolean(p_commit)) THEN

65: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
66: raise fnd_api.g_exc_error;
67: END IF;
68:
69: IF(fnd_api.to_boolean(p_commit)) THEN
70: COMMIT;
71: END IF;
72:
73: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 81: WHEN fnd_api.g_exc_error THEN

77: x_returnStatus => l_returnStatus);
78: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
79: END IF;
80: EXCEPTION
81: WHEN fnd_api.g_exc_error THEN
82: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
83:
84: FOR l_errors IN c_errors(p_transaction_id => p_txn_id) LOOP
85: x_errorMsg := x_errorMsg || l_errors.error_column ||':' ||

Line 82: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

78: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
79: END IF;
80: EXCEPTION
81: WHEN fnd_api.g_exc_error THEN
82: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
83:
84: FOR l_errors IN c_errors(p_transaction_id => p_txn_id) LOOP
85: x_errorMsg := x_errorMsg || l_errors.error_column ||':' ||
86: l_errors.error_message || '; ';

Line 99: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

95: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
96: END IF;
97:
98: WHEN TOO_MANY_ROWS THEN
99: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
100: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
101: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
102: x_errorMsg := substr(fnd_message.get, 1, 1000);
103:

Line 113: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

109: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
110: END IF;
111:
112: WHEN NO_DATA_FOUND THEN
113: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
114: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
115: fnd_message.set_token('ENTITY',
116: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
117: x_errorMsg := substr(fnd_message.get, 1, 1000);

Line 128: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

124: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
125: END IF;
126:
127: WHEN others THEN
128: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
129: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
130: IF (l_logLevel <= wip_constants.trace_logging) THEN
131: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
132: p_procReturnStatus => x_returnStatus,

Line 164: IF (p_do_backflush = fnd_api.g_false) THEN

160: x_returnStatus => l_returnStatus);
161:
162: END IF;
163:
164: IF (p_do_backflush = fnd_api.g_false) THEN
165: l_do_backflush := fnd_api.g_false;
166: ELSE
167: l_do_backflush := fnd_api.g_true;
168: END IF;

Line 165: l_do_backflush := fnd_api.g_false;

161:
162: END IF;
163:
164: IF (p_do_backflush = fnd_api.g_false) THEN
165: l_do_backflush := fnd_api.g_false;
166: ELSE
167: l_do_backflush := fnd_api.g_true;
168: END IF;
169:

Line 167: l_do_backflush := fnd_api.g_true;

163:
164: IF (p_do_backflush = fnd_api.g_false) THEN
165: l_do_backflush := fnd_api.g_false;
166: ELSE
167: l_do_backflush := fnd_api.g_true;
168: END IF;
169:
170: wip_movProc_priv.processIntf(p_group_id => p_group_id,
171: p_child_txn_id => -1,

Line 178: p_endDebug => fnd_api.g_false,

174: p_time_out => 0,
175: p_move_mode => WIP_CONSTANTS.BACKGROUND,
176: p_bf_mode => WIP_CONSTANTS.ONLINE,
177: p_mtl_mode => WIP_CONSTANTS.ONLINE,
178: p_endDebug => fnd_api.g_false,
179: p_initMsgList => fnd_api.g_true,
180: p_insertAssy => fnd_api.g_true,
181: p_do_backflush => l_do_backflush,
182: x_returnStatus => x_returnStatus);

Line 179: p_initMsgList => fnd_api.g_true,

175: p_move_mode => WIP_CONSTANTS.BACKGROUND,
176: p_bf_mode => WIP_CONSTANTS.ONLINE,
177: p_mtl_mode => WIP_CONSTANTS.ONLINE,
178: p_endDebug => fnd_api.g_false,
179: p_initMsgList => fnd_api.g_true,
180: p_insertAssy => fnd_api.g_true,
181: p_do_backflush => l_do_backflush,
182: x_returnStatus => x_returnStatus);
183:

Line 180: p_insertAssy => fnd_api.g_true,

176: p_bf_mode => WIP_CONSTANTS.ONLINE,
177: p_mtl_mode => WIP_CONSTANTS.ONLINE,
178: p_endDebug => fnd_api.g_false,
179: p_initMsgList => fnd_api.g_true,
180: p_insertAssy => fnd_api.g_true,
181: p_do_backflush => l_do_backflush,
182: x_returnStatus => x_returnStatus);
183:
184: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 184: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

180: p_insertAssy => fnd_api.g_true,
181: p_do_backflush => l_do_backflush,
182: x_returnStatus => x_returnStatus);
183:
184: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
185: raise fnd_api.g_exc_error;
186: END IF;
187:
188: IF(fnd_api.to_boolean(p_commit)) THEN

Line 185: raise fnd_api.g_exc_error;

181: p_do_backflush => l_do_backflush,
182: x_returnStatus => x_returnStatus);
183:
184: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
185: raise fnd_api.g_exc_error;
186: END IF;
187:
188: IF(fnd_api.to_boolean(p_commit)) THEN
189: COMMIT;

Line 188: IF(fnd_api.to_boolean(p_commit)) THEN

184: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
185: raise fnd_api.g_exc_error;
186: END IF;
187:
188: IF(fnd_api.to_boolean(p_commit)) THEN
189: COMMIT;
190: END IF;
191:
192: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 201: WHEN fnd_api.g_exc_error THEN

197: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
198: END IF;
199: EXCEPTION
200:
201: WHEN fnd_api.g_exc_error THEN
202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
203:
204: IF (l_logLevel <= wip_constants.trace_logging) THEN
205: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

Line 202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

198: END IF;
199: EXCEPTION
200:
201: WHEN fnd_api.g_exc_error THEN
202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
203:
204: IF (l_logLevel <= wip_constants.trace_logging) THEN
205: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
206: p_procReturnStatus => x_returnStatus,

Line 213: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

209: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
210: END IF;
211:
212: WHEN others THEN
213: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
214:
215: IF (l_logLevel <= wip_constants.trace_logging) THEN
216: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
217: p_procReturnStatus => x_returnStatus,