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 50: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

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

Line 65: x_return_status := fnd_api.g_ret_sts_success;

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

Line 71: IF FND_API.To_Boolean( p_init_msg_list ) THEN

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

Line 78: FND_API.Compatible_API_Call (

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

Line 84: RAISE fnd_api.g_exc_unexpected_error;

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

Line 115: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 116: RAISE fnd_api.g_exc_error;

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

Line 130: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 131: RAISE fnd_api.g_exc_error;

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

Line 139: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 140: RAISE fnd_api.g_exc_error;

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

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

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

Line 159: p_commit => fnd_api.g_false,

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

Line 160: p_init_msg_list => fnd_api.g_true,

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

Line 161: p_validation_level => fnd_api.g_valid_level_full,

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

Line 168: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 169: RAISE fnd_api.g_exc_error;

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

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

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

Line 213: IF l_return_status <> fnd_api.g_ret_sts_success THEN

209: x_item_attr_rec => l_item_attr_rec,
210: x_return_status => l_return_status,
211: p_inv_txn_typeid_from_cs => p_inv_txn_typeid_from_cs);
212:
213: IF l_return_status <> fnd_api.g_ret_sts_success THEN
214: RAISE fnd_api.g_exc_error;
215: END IF;
216:
217: IF l_item_attr_rec.stockable_flag = 'Y' THEN

Line 214: RAISE fnd_api.g_exc_error;

210: x_return_status => l_return_status,
211: p_inv_txn_typeid_from_cs => p_inv_txn_typeid_from_cs);
212:
213: IF l_return_status <> fnd_api.g_ret_sts_success THEN
214: RAISE fnd_api.g_exc_error;
215: END IF;
216:
217: IF l_item_attr_rec.stockable_flag = 'Y' THEN
218:

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

228: /* exclude misc receipt (source location attributes are null) */
229: /* and WIP assy completion. These transactions will not have */
230: /* source instances. */
231:
232: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
233: OR
234: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
235: OR
236: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

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

230: /* source instances. */
231:
232: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
233: OR
234: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
235: OR
236: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
237: OR
238: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char

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

232: IF nvl(l_instances_tbl(l_i_ind).location_type_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
233: OR
234: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
235: OR
236: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
237: OR
238: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char
239: THEN
240:

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

234: nvl(l_instances_tbl(l_i_ind).location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
235: OR
236: nvl(l_instances_tbl(l_i_ind).inv_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
237: OR
238: nvl(l_instances_tbl(l_i_ind).inv_subinventory_name, fnd_api.g_miss_char)<> fnd_api.g_miss_char
239: THEN
240:
241: csi_process_txn_pvt.get_src_instance_id(
242: p_in_out_flag => p_in_out_flag,

Line 251: IF l_return_status <> fnd_api.g_ret_sts_success THEN

247: p_transaction_rec => l_transaction_rec,
248: x_instance_id => l_instance_id,
249: x_return_status => l_return_status);
250:
251: IF l_return_status <> fnd_api.g_ret_sts_success THEN
252: RAISE fnd_api.g_exc_error;
253: END IF;
254:
255: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;

Line 252: RAISE fnd_api.g_exc_error;

248: x_instance_id => l_instance_id,
249: x_return_status => l_return_status);
250:
251: IF l_return_status <> fnd_api.g_ret_sts_success THEN
252: RAISE fnd_api.g_exc_error;
253: END IF;
254:
255: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;
256:

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

254:
255: l_instances_tbl(l_i_ind).new_instance_id := l_instance_id;
256:
257: ELSE
258: l_instances_tbl(l_i_ind).new_instance_id := fnd_api.g_miss_num;
259: END IF;
260:
261: IF nvl(l_instances_tbl(l_i_ind).new_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
262: debug('Source instance identified. Instance ID :'||l_instances_tbl(l_i_ind).new_instance_id);

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

257: ELSE
258: l_instances_tbl(l_i_ind).new_instance_id := fnd_api.g_miss_num;
259: END IF;
260:
261: IF nvl(l_instances_tbl(l_i_ind).new_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
262: debug('Source instance identified. Instance ID :'||l_instances_tbl(l_i_ind).new_instance_id);
263: ELSE
264: debug('Process Transaction could not identity a source instance.');
265: END IF;

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

271: debug('Source instance reference specified.');
272:
273: l_instances_tbl(l_i_ind).new_instance_id := l_instances_tbl(l_i_ind).instance_id;
274:
275: END IF; -- instance_id = fnd_api.g_miss_num
276:
277: END LOOP; -- txn_instance_tbl loop
278:
279: END IF; -- IF txn_instance_tbl.COUNT > 0

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

285: /* --------------------------------------------------------------- */
286:
287: debug('Parse II');
288:
289: IF nvl(p_validate_only_flag, fnd_api.g_false) = fnd_api.g_false THEN
290:
291: IF l_instances_tbl.COUNT > 0 THEN
292:
293: FOR l_instance_index IN l_instances_tbl.FIRST .. l_instances_tbl.LAST

Line 327: IF l_return_status <> fnd_api.g_ret_sts_success THEN

323: x_item_attr_rec => l_item_attr_rec,
324: x_return_status => l_return_status,
325: p_inv_txn_typeid_from_cs => p_inv_txn_typeid_from_cs);
326:
327: IF l_return_status <> fnd_api.g_ret_sts_success THEN
328: RAISE fnd_api.g_exc_error;
329: END IF;
330:
331: /* -------------------------------------------------------------- */

Line 328: RAISE fnd_api.g_exc_error;

324: x_return_status => l_return_status,
325: p_inv_txn_typeid_from_cs => p_inv_txn_typeid_from_cs);
326:
327: IF l_return_status <> fnd_api.g_ret_sts_success THEN
328: RAISE fnd_api.g_exc_error;
329: END IF;
330:
331: /* -------------------------------------------------------------- */
332: /* call the process_IB routine that either creates a new instance */

Line 366: l_instances_tbl(l_instance_index).call_contracts := FND_API.G_FALSE;

362: ('REPLACED-BY', 'REPLACEMENT-FOR', 'UPGRADED-FROM') AND
363: ( p_ii_relationships_tbl(i).object_index = l_instance_index OR
364: p_ii_relationships_tbl(i).subject_index = l_instance_index ) THEN
365:
366: l_instances_tbl(l_instance_index).call_contracts := FND_API.G_FALSE;
367:
368: FOR ipa_rec in p_ip_accounts_tbl.first..p_ip_accounts_tbl.last loop
369: p_ip_accounts_tbl(ipa_rec).call_contracts := FND_API.G_FALSE;
370: end loop;

Line 369: p_ip_accounts_tbl(ipa_rec).call_contracts := FND_API.G_FALSE;

365:
366: l_instances_tbl(l_instance_index).call_contracts := FND_API.G_FALSE;
367:
368: FOR ipa_rec in p_ip_accounts_tbl.first..p_ip_accounts_tbl.last loop
369: p_ip_accounts_tbl(ipa_rec).call_contracts := FND_API.G_FALSE;
370: end loop;
371:
372: exit;
373: END IF;

Line 395: IF l_return_status <> fnd_api.g_ret_sts_success THEN

391: p_transaction_rec => l_transaction_rec,
392: px_txn_error_rec => px_txn_error_rec,
393: x_return_status => l_return_status);
394:
395: IF l_return_status <> fnd_api.g_ret_sts_success THEN
396: RAISE fnd_api.g_exc_error;
397: END IF;
398:
399: END IF;

Line 396: RAISE fnd_api.g_exc_error;

392: px_txn_error_rec => px_txn_error_rec,
393: x_return_status => l_return_status);
394:
395: IF l_return_status <> fnd_api.g_ret_sts_success THEN
396: RAISE fnd_api.g_exc_error;
397: END IF;
398:
399: END IF;
400:

Line 417: IF l_return_status <> fnd_api.g_ret_sts_success THEN

413: p_ii_relationships_tbl => p_ii_relationships_tbl,
414: p_transaction_rec => l_transaction_rec,
415: x_return_status => l_return_status);
416:
417: IF l_return_status <> fnd_api.g_ret_sts_success THEN
418: RAISE fnd_api.g_exc_error;
419: END IF;
420:
421: END IF;

Line 418: RAISE fnd_api.g_exc_error;

414: p_transaction_rec => l_transaction_rec,
415: x_return_status => l_return_status);
416:
417: IF l_return_status <> fnd_api.g_ret_sts_success THEN
418: RAISE fnd_api.g_exc_error;
419: END IF;
420:
421: END IF;
422:

Line 428: IF fnd_api.to_boolean( p_commit ) then

424:
425: -- END MAIN API Code
426:
427: -- Standard check of p_commit.
428: IF fnd_api.to_boolean( p_commit ) then
429: commit work;
430: END IF;
431:
432: debug('Process transaction successful.');

Line 442: WHEN fnd_api.g_exc_error THEN

438: p_count => x_msg_count,
439: p_data => x_msg_data);
440:
441: EXCEPTION
442: WHEN fnd_api.g_exc_error THEN
443:
444: rollback to process_transaction;
445: x_return_status := fnd_api.g_ret_sts_error;
446:

Line 445: x_return_status := fnd_api.g_ret_sts_error;

441: EXCEPTION
442: WHEN fnd_api.g_exc_error THEN
443:
444: rollback to process_transaction;
445: x_return_status := fnd_api.g_ret_sts_error;
446:
447: fnd_msg_pub.count_and_get (
448: p_count => x_msg_count,
449: p_data => x_msg_data);

Line 454: WHEN fnd_api.g_exc_unexpected_error THEN

450:
451: x_msg_data := csi_t_gen_utility_pvt.dump_error_stack;
452: debug('Error(E) :'||x_msg_data);
453:
454: WHEN fnd_api.g_exc_unexpected_error THEN
455:
456: rollback to process_transaction;
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458:

Line 457: x_return_status := fnd_api.g_ret_sts_unexp_error;

453:
454: WHEN fnd_api.g_exc_unexpected_error THEN
455:
456: rollback to process_transaction;
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458:
459: fnd_msg_pub.count_and_get(
460: p_count => x_msg_count,
461: p_data => x_msg_data);

Line 470: x_return_status := fnd_api.g_ret_sts_unexp_error ;

466: WHEN others THEN
467:
468: rollback to process_transaction;
469:
470: x_return_status := fnd_api.g_ret_sts_unexp_error ;
471:
472: fnd_msg_pub.add_exc_msg(
473: p_pkg_name => g_pkg_name,
474: p_procedure_name => l_api_name);

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

483: END process_transaction;
484:
485: PROCEDURE process_transaction (
486: p_api_version IN NUMBER,
487: p_commit IN VARCHAR2 := fnd_api.g_false,
488: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
489: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
490: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
491: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'

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

484:
485: PROCEDURE process_transaction (
486: p_api_version IN NUMBER,
487: p_commit IN VARCHAR2 := fnd_api.g_false,
488: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
489: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
490: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
491: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
492: p_dest_location_rec IN OUT NOCOPY dest_location_rec,

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

485: PROCEDURE process_transaction (
486: p_api_version IN NUMBER,
487: p_commit IN VARCHAR2 := fnd_api.g_false,
488: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
489: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
490: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
491: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
492: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
493: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

486: p_api_version IN NUMBER,
487: p_commit IN VARCHAR2 := fnd_api.g_false,
488: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
489: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
490: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
491: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
492: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
493: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
494: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,

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

503: x_msg_count OUT NOCOPY NUMBER,
504: x_msg_data OUT NOCOPY VARCHAR2 )
505: IS
506: l_error_rec csi_datastructures_pub.transaction_error_rec;
507: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
508: l_msg_count number;
509: l_msg_data varchar2(2000);
510: BEGIN
511:

Line 512: x_return_status := fnd_api.g_ret_sts_success;

508: l_msg_count number;
509: l_msg_data varchar2(2000);
510: BEGIN
511:
512: x_return_status := fnd_api.g_ret_sts_success;
513:
514: csi_process_txn_grp.process_transaction(
515: p_api_version => p_api_version,
516: p_commit => p_commit,

Line 536: IF l_return_status <> fnd_api.g_ret_sts_success THEN

532: x_return_status => l_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data );
535:
536: IF l_return_status <> fnd_api.g_ret_sts_success THEN
537: RAISE fnd_api.g_exc_error;
538: END IF;
539:
540: EXCEPTION

Line 537: RAISE fnd_api.g_exc_error;

533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data );
535:
536: IF l_return_status <> fnd_api.g_ret_sts_success THEN
537: RAISE fnd_api.g_exc_error;
538: END IF;
539:
540: EXCEPTION
541: WHEN fnd_api.g_exc_error THEN

Line 541: WHEN fnd_api.g_exc_error THEN

537: RAISE fnd_api.g_exc_error;
538: END IF;
539:
540: EXCEPTION
541: WHEN fnd_api.g_exc_error THEN
542: x_return_status := fnd_api.g_ret_sts_error;
543:
544: WHEN others THEN
545: x_return_status := fnd_api.g_ret_sts_error;

Line 542: x_return_status := fnd_api.g_ret_sts_error;

538: END IF;
539:
540: EXCEPTION
541: WHEN fnd_api.g_exc_error THEN
542: x_return_status := fnd_api.g_ret_sts_error;
543:
544: WHEN others THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546:

Line 545: x_return_status := fnd_api.g_ret_sts_error;

541: WHEN fnd_api.g_exc_error THEN
542: x_return_status := fnd_api.g_ret_sts_error;
543:
544: WHEN others THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546:
547: fnd_msg_pub.add_exc_msg(
548: p_pkg_name => 'csi_process_txn_grp',
549: p_procedure_name => 'process_transaction');