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.CSI_PROCESS_TXN_GRP dependencies on FND_API

Line 22: p_commit IN VARCHAR2 := fnd_api.g_false,

18: /*-------------------------------------------------------------------*/
19:
20: PROCEDURE process_transaction(
21: p_api_version IN NUMBER,
22: p_commit IN VARCHAR2 := fnd_api.g_false,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
24: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
25: p_validate_only_flag IN VARCHAR2,
26: p_in_out_flag IN VARCHAR2, -- valid values are 'IN','OUT'

Line 23: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

19:
20: PROCEDURE process_transaction(
21: p_api_version IN NUMBER,
22: p_commit IN VARCHAR2 := fnd_api.g_false,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
24: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
25: p_validate_only_flag IN VARCHAR2,
26: p_in_out_flag IN VARCHAR2, -- valid values are 'IN','OUT'
27: p_dest_location_rec IN OUT NOCOPY dest_location_rec,

Line 24: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

20: PROCEDURE process_transaction(
21: p_api_version IN NUMBER,
22: p_commit IN VARCHAR2 := fnd_api.g_false,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
24: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
25: p_validate_only_flag IN VARCHAR2,
26: p_in_out_flag IN VARCHAR2, -- valid values are 'IN','OUT'
27: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
28: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 49: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

45: g_sysdate DATE := sysdate;
46:
47: l_api_name CONSTANT VARCHAR2(30) := 'process_transaction';
48: l_api_version CONSTANT NUMBER := 1.0;
49: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
50: l_msg_count NUMBER;
51: l_msg_data VARCHAR2(2000);
52: l_debug_level NUMBER;
53:

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60:
61: BEGIN
62:
63: -- Initialize API return status to success
64: x_return_status := fnd_api.g_ret_sts_success;
65:
66: -- Standard Start of API savepoint
67: SAVEPOINT process_transaction;
68:

Line 70: IF FND_API.To_Boolean( p_init_msg_list ) THEN

66: -- Standard Start of API savepoint
67: SAVEPOINT process_transaction;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.To_Boolean( p_init_msg_list ) THEN
71: FND_MSG_PUB.Initialize;
72: END IF;
73:
74: -- Standard call to check for call compatibility.

Line 77: FND_API.Compatible_API_Call (

73:
74: -- Standard call to check for call compatibility.
75: IF NOT
76:
77: FND_API.Compatible_API_Call (
78: p_current_version_number => l_api_version,
79: p_caller_version_number => p_api_version,
80: p_api_name => l_api_name,
81: p_pkg_name => g_pkg_name) THEN

Line 83: RAISE fnd_api.g_exc_unexpected_error;

79: p_caller_version_number => p_api_version,
80: p_api_name => l_api_name,
81: p_pkg_name => g_pkg_name) THEN
82:
83: RAISE fnd_api.g_exc_unexpected_error;
84:
85: END IF;
86:
87: csi_t_gen_utility_pvt.dump_api_info(

Line 114: IF l_return_status <> fnd_api.g_ret_sts_success THEN

110: p_sub_type_id => p_txn_rec.txn_sub_type_id,
111: x_sub_type_rec => l_sub_type_rec,
112: x_return_status => l_return_status);
113:
114: IF l_return_status <> fnd_api.g_ret_sts_success THEN
115: RAISE fnd_api.g_exc_error;
116: END IF;
117:
118: /* ---------------------------------------------------------------- */

Line 115: RAISE fnd_api.g_exc_error;

111: x_sub_type_rec => l_sub_type_rec,
112: x_return_status => l_return_status);
113:
114: IF l_return_status <> fnd_api.g_ret_sts_success THEN
115: RAISE fnd_api.g_exc_error;
116: END IF;
117:
118: /* ---------------------------------------------------------------- */
119: /* This routine validates the sub types and the passed instance */

Line 129: IF l_return_status <> fnd_api.g_ret_sts_success THEN

125: p_txn_instances_tbl => l_instances_tbl,
126: p_txn_i_parties_tbl => l_parties_tbl,
127: x_return_status => l_return_status);
128:
129: IF l_return_status <> fnd_api.g_ret_sts_success THEN
130: RAISE fnd_api.g_exc_error;
131: END IF;
132:
133: csi_process_txn_pvt.validate_dest_location_rec(

Line 130: RAISE fnd_api.g_exc_error;

126: p_txn_i_parties_tbl => l_parties_tbl,
127: x_return_status => l_return_status);
128:
129: IF l_return_status <> fnd_api.g_ret_sts_success THEN
130: RAISE fnd_api.g_exc_error;
131: END IF;
132:
133: csi_process_txn_pvt.validate_dest_location_rec(
134: p_in_out_flag => p_in_out_flag,

Line 138: IF l_return_status <> fnd_api.g_ret_sts_success THEN

134: p_in_out_flag => p_in_out_flag,
135: p_dest_location_rec => p_dest_location_rec,
136: x_return_status => l_return_status);
137:
138: IF l_return_status <> fnd_api.g_ret_sts_success THEN
139: RAISE fnd_api.g_exc_error;
140: END IF;
141:
142: debug('Parse I');

Line 139: RAISE fnd_api.g_exc_error;

135: p_dest_location_rec => p_dest_location_rec,
136: x_return_status => l_return_status);
137:
138: IF l_return_status <> fnd_api.g_ret_sts_success THEN
139: RAISE fnd_api.g_exc_error;
140: END IF;
141:
142: debug('Parse I');
143:

Line 150: IF nvl(l_transaction_rec.transaction_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

146: /* Create transaction and use the same transaction rec throughout the program */
147:
148: l_transaction_rec := p_txn_rec;
149:
150: IF nvl(l_transaction_rec.transaction_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
151:
152: csi_t_gen_utility_pvt.dump_api_info(
153: p_pkg_name => 'csi_transactions_pvt',
154: p_api_name => 'create_transaction');

Line 158: p_commit => fnd_api.g_false,

154: p_api_name => 'create_transaction');
155:
156: csi_transactions_pvt.create_transaction (
157: p_api_version => 1.0,
158: p_commit => fnd_api.g_false,
159: p_init_msg_list => fnd_api.g_true,
160: p_validation_level => fnd_api.g_valid_level_full,
161: p_success_if_exists_flag => 'Y',
162: p_transaction_rec => l_transaction_rec,

Line 159: p_init_msg_list => fnd_api.g_true,

155:
156: csi_transactions_pvt.create_transaction (
157: p_api_version => 1.0,
158: p_commit => fnd_api.g_false,
159: p_init_msg_list => fnd_api.g_true,
160: p_validation_level => fnd_api.g_valid_level_full,
161: p_success_if_exists_flag => 'Y',
162: p_transaction_rec => l_transaction_rec,
163: x_return_status => l_return_status,

Line 160: p_validation_level => fnd_api.g_valid_level_full,

156: csi_transactions_pvt.create_transaction (
157: p_api_version => 1.0,
158: p_commit => fnd_api.g_false,
159: p_init_msg_list => fnd_api.g_true,
160: p_validation_level => fnd_api.g_valid_level_full,
161: p_success_if_exists_flag => 'Y',
162: p_transaction_rec => l_transaction_rec,
163: x_return_status => l_return_status,
164: x_msg_count => l_msg_count,

Line 167: IF l_return_status <> fnd_api.g_ret_sts_success THEN

163: x_return_status => l_return_status,
164: x_msg_count => l_msg_count,
165: x_msg_data => l_msg_data );
166:
167: IF l_return_status <> fnd_api.g_ret_sts_success THEN
168: RAISE fnd_api.g_exc_error;
169: END IF;
170:
171: p_txn_rec := l_transaction_rec;

Line 168: RAISE fnd_api.g_exc_error;

164: x_msg_count => l_msg_count,
165: x_msg_data => l_msg_data );
166:
167: IF l_return_status <> fnd_api.g_ret_sts_success THEN
168: RAISE fnd_api.g_exc_error;
169: END IF;
170:
171: p_txn_rec := l_transaction_rec;
172:

Line 180: IF nvl(l_instances_tbl(l_i_ind).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

176:
177: FOR l_i_ind IN l_instances_tbl.FIRST .. l_instances_tbl.LAST
178: LOOP
179:
180: IF nvl(l_instances_tbl(l_i_ind).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
181: THEN
182:
183: debug('Source instance reference not specified.');
184:

Line 198: IF l_return_status <> fnd_api.g_ret_sts_success THEN

194: p_organization_id => l_instances_tbl(l_i_ind).vld_organization_id,
195: x_item_attr_rec => l_item_attr_rec,
196: x_return_status => l_return_status);
197:
198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
199: RAISE fnd_api.g_exc_error;
200: END IF;
201:
202: IF l_item_attr_rec.stockable_flag = 'Y' THEN

Line 199: RAISE fnd_api.g_exc_error;

195: x_item_attr_rec => l_item_attr_rec,
196: x_return_status => l_return_status);
197:
198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
199: RAISE fnd_api.g_exc_error;
200: END IF;
201:
202: IF l_item_attr_rec.stockable_flag = 'Y' THEN
203:

Line 217: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char

213: /* exclude misc receipt (source location attributes are null) */
214: /* and WIP assy completion. These transactions will not have */
215: /* source instances. */
216:
217: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
218: OR
219: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
220: OR
221: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 219: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

215: /* source instances. */
216:
217: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
218: OR
219: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
220: OR
221: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
222: OR
223: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char

Line 221: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

217: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
218: OR
219: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
220: OR
221: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
222: OR
223: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char
224: THEN
225:

Line 223: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char

219: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
220: OR
221: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
222: OR
223: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char
224: THEN
225:
226: csi_process_txn_pvt.get_src_instance_id(
227: p_in_out_flag => p_in_out_flag,

Line 236: IF l_return_status <> fnd_api.g_ret_sts_success THEN

232: p_transaction_rec => l_transaction_rec,
233: x_instance_id => l_instance_id,
234: x_return_status => l_return_status);
235:
236: IF l_return_status <> fnd_api.g_ret_sts_success THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;
239:
240: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;

Line 237: RAISE fnd_api.g_exc_error;

233: x_instance_id => l_instance_id,
234: x_return_status => l_return_status);
235:
236: IF l_return_status <> fnd_api.g_ret_sts_success THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;
239:
240: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;
241:

Line 243: l_instances_tbl(l_i_ind).new_instance_id := fnd_api.g_miss_num;

239:
240: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;
241:
242: ELSE
243: l_instances_tbl(l_i_ind).new_instance_id := fnd_api.g_miss_num;
244: END IF;
245:
246: IF nvl(l_instances_tbl(l_i_ind).new_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: debug('Source instance identified. Instance ID :'||l_instances_tbl(l_i_ind).new_instance_id);

Line 246: IF nvl(l_instances_tbl(l_i_ind).new_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

242: ELSE
243: l_instances_tbl(l_i_ind).new_instance_id := fnd_api.g_miss_num;
244: END IF;
245:
246: IF nvl(l_instances_tbl(l_i_ind).new_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: debug('Source instance identified. Instance ID :'||l_instances_tbl(l_i_ind).new_instance_id);
248: ELSE
249: debug('Process Transaction could not identity a source instance.');
250: END IF;

Line 260: END IF; -- instance_id = fnd_api.g_miss_num

256: debug('Source instance reference specified.');
257:
258: l_instances_tbl(l_i_ind).new_instance_id := l_instances_tbl(l_i_ind).instance_id;
259:
260: END IF; -- instance_id = fnd_api.g_miss_num
261:
262: END LOOP; -- txn_instance_tbl loop
263:
264: END IF; -- IF txn_instance_tbl.COUNT > 0

Line 274: IF nvl(p_validate_only_flag, fnd_api.g_false) = fnd_api.g_false THEN

270: /* --------------------------------------------------------------- */
271:
272: debug('Parse II');
273:
274: IF nvl(p_validate_only_flag, fnd_api.g_false) = fnd_api.g_false THEN
275:
276: IF l_instances_tbl.COUNT > 0 THEN
277:
278: FOR l_instance_index IN l_instances_tbl.FIRST .. l_instances_tbl.LAST

Line 298: IF l_return_status <> fnd_api.g_ret_sts_success THEN

294: p_organization_id => l_instances_tbl(l_instance_index).vld_organization_id,
295: x_item_attr_rec => l_item_attr_rec,
296: x_return_status => l_return_status);
297:
298: IF l_return_status <> fnd_api.g_ret_sts_success THEN
299: RAISE fnd_api.g_exc_error;
300: END IF;
301:
302: /* -------------------------------------------------------------- */

Line 299: RAISE fnd_api.g_exc_error;

295: x_item_attr_rec => l_item_attr_rec,
296: x_return_status => l_return_status);
297:
298: IF l_return_status <> fnd_api.g_ret_sts_success THEN
299: RAISE fnd_api.g_exc_error;
300: END IF;
301:
302: /* -------------------------------------------------------------- */
303: /* call the process_IB routine that either creates a new instance */

Line 346: IF l_return_status <> fnd_api.g_ret_sts_success THEN

342: p_transaction_rec => l_transaction_rec,
343: px_txn_error_rec => px_txn_error_rec,
344: x_return_status => l_return_status);
345:
346: IF l_return_status <> fnd_api.g_ret_sts_success THEN
347: RAISE fnd_api.g_exc_error;
348: END IF;
349:
350: END IF;

Line 347: RAISE fnd_api.g_exc_error;

343: px_txn_error_rec => px_txn_error_rec,
344: x_return_status => l_return_status);
345:
346: IF l_return_status <> fnd_api.g_ret_sts_success THEN
347: RAISE fnd_api.g_exc_error;
348: END IF;
349:
350: END IF;
351:

Line 368: IF l_return_status <> fnd_api.g_ret_sts_success THEN

364: p_ii_relationships_tbl => p_ii_relationships_tbl,
365: p_transaction_rec => l_transaction_rec,
366: x_return_status => l_return_status);
367:
368: IF l_return_status <> fnd_api.g_ret_sts_success THEN
369: RAISE fnd_api.g_exc_error;
370: END IF;
371:
372: END IF;

Line 369: RAISE fnd_api.g_exc_error;

365: p_transaction_rec => l_transaction_rec,
366: x_return_status => l_return_status);
367:
368: IF l_return_status <> fnd_api.g_ret_sts_success THEN
369: RAISE fnd_api.g_exc_error;
370: END IF;
371:
372: END IF;
373:

Line 379: IF fnd_api.to_boolean( p_commit ) then

375:
376: -- END MAIN API Code
377:
378: -- Standard check of p_commit.
379: IF fnd_api.to_boolean( p_commit ) then
380: commit work;
381: END IF;
382:
383: debug('Process transaction successful.');

Line 393: WHEN fnd_api.g_exc_error THEN

389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: EXCEPTION
393: WHEN fnd_api.g_exc_error THEN
394:
395: rollback to process_transaction;
396: x_return_status := fnd_api.g_ret_sts_error;
397:

Line 396: x_return_status := fnd_api.g_ret_sts_error;

392: EXCEPTION
393: WHEN fnd_api.g_exc_error THEN
394:
395: rollback to process_transaction;
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: fnd_msg_pub.count_and_get (
399: p_count => x_msg_count,
400: p_data => x_msg_data);

Line 405: WHEN fnd_api.g_exc_unexpected_error THEN

401:
402: x_msg_data := csi_t_gen_utility_pvt.dump_error_stack;
403: debug('Error(E) :'||x_msg_data);
404:
405: WHEN fnd_api.g_exc_unexpected_error THEN
406:
407: rollback to process_transaction;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409:

Line 408: x_return_status := fnd_api.g_ret_sts_unexp_error;

404:
405: WHEN fnd_api.g_exc_unexpected_error THEN
406:
407: rollback to process_transaction;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409:
410: fnd_msg_pub.count_and_get(
411: p_count => x_msg_count,
412: p_data => x_msg_data);

Line 421: x_return_status := fnd_api.g_ret_sts_unexp_error ;

417: WHEN others THEN
418:
419: rollback to process_transaction;
420:
421: x_return_status := fnd_api.g_ret_sts_unexp_error ;
422:
423: fnd_msg_pub.add_exc_msg(
424: p_pkg_name => g_pkg_name,
425: p_procedure_name => l_api_name);

Line 438: p_commit IN VARCHAR2 := fnd_api.g_false,

434: END process_transaction;
435:
436: PROCEDURE process_transaction (
437: p_api_version IN NUMBER,
438: p_commit IN VARCHAR2 := fnd_api.g_false,
439: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
440: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
441: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
442: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'

Line 439: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

435:
436: PROCEDURE process_transaction (
437: p_api_version IN NUMBER,
438: p_commit IN VARCHAR2 := fnd_api.g_false,
439: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
440: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
441: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
442: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
443: p_dest_location_rec IN OUT NOCOPY dest_location_rec,

Line 440: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

436: PROCEDURE process_transaction (
437: p_api_version IN NUMBER,
438: p_commit IN VARCHAR2 := fnd_api.g_false,
439: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
440: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
441: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
442: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
443: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
444: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 441: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,

437: p_api_version IN NUMBER,
438: p_commit IN VARCHAR2 := fnd_api.g_false,
439: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
440: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
441: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
442: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
443: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
444: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
445: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,

Line 458: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2 )
456: IS
457: l_error_rec csi_datastructures_pub.transaction_error_rec;
458: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
459: l_msg_count number;
460: l_msg_data varchar2(2000);
461: BEGIN
462:

Line 463: x_return_status := fnd_api.g_ret_sts_success;

459: l_msg_count number;
460: l_msg_data varchar2(2000);
461: BEGIN
462:
463: x_return_status := fnd_api.g_ret_sts_success;
464:
465: csi_process_txn_grp.process_transaction(
466: p_api_version => p_api_version,
467: p_commit => p_commit,

Line 487: IF l_return_status <> fnd_api.g_ret_sts_success THEN

483: x_return_status => l_return_status,
484: x_msg_count => x_msg_count,
485: x_msg_data => x_msg_data );
486:
487: IF l_return_status <> fnd_api.g_ret_sts_success THEN
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: EXCEPTION

Line 488: RAISE fnd_api.g_exc_error;

484: x_msg_count => x_msg_count,
485: x_msg_data => x_msg_data );
486:
487: IF l_return_status <> fnd_api.g_ret_sts_success THEN
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: EXCEPTION
492: WHEN fnd_api.g_exc_error THEN

Line 492: WHEN fnd_api.g_exc_error THEN

488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: EXCEPTION
492: WHEN fnd_api.g_exc_error THEN
493: x_return_status := fnd_api.g_ret_sts_error;
494:
495: WHEN others THEN
496: x_return_status := fnd_api.g_ret_sts_error;

Line 493: x_return_status := fnd_api.g_ret_sts_error;

489: END IF;
490:
491: EXCEPTION
492: WHEN fnd_api.g_exc_error THEN
493: x_return_status := fnd_api.g_ret_sts_error;
494:
495: WHEN others THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497:

Line 496: x_return_status := fnd_api.g_ret_sts_error;

492: WHEN fnd_api.g_exc_error THEN
493: x_return_status := fnd_api.g_ret_sts_error;
494:
495: WHEN others THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497:
498: fnd_msg_pub.add_exc_msg(
499: p_pkg_name => 'csi_process_txn_grp',
500: p_procedure_name => 'process_transaction');