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

Line 95: l_return_status := fnd_api.g_ret_sts_success;

91: BEGIN
92:
93: SAVEPOINT sp_mass_create_ro;
94:
95: l_return_status := fnd_api.g_ret_sts_success;
96: l_debug_level := fnd_log.g_current_runtime_level;
97: l_stmt_level := fnd_log.level_statement;
98: l_event_level := fnd_log.level_event;
99: c_draft_Status := 'D';

Line 110: IF fnd_api.to_boolean (p_init_msg_list)

106: );
107: END IF;
108:
109:
110: IF fnd_api.to_boolean (p_init_msg_list)
111: THEN
112: -- initialize message list
113: fnd_msg_pub.initialize;
114: END IF;

Line 117: IF NOT fnd_api.compatible_api_call (l_api_version_number,

113: fnd_msg_pub.initialize;
114: END IF;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT fnd_api.compatible_api_call (l_api_version_number,
118: p_api_version,
119: l_api_name,
120: g_pkg_name
121: )

Line 123: RAISE fnd_api.g_exc_unexpected_error;

119: l_api_name,
120: g_pkg_name
121: )
122: THEN
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:
126: -- initialize return status
127: x_return_status := fnd_api.g_ret_sts_success;

Line 127: x_return_status := fnd_api.g_ret_sts_success;

123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:
126: -- initialize return status
127: x_return_status := fnd_api.g_ret_sts_success;
128:
129: -- Purge the errors from generic errors table
130: --Delete records from the CSD_GENRIC_ERRMSGS table.
131: IF (l_event_level >= l_debug_level)

Line 149: IF (l_return_status <> fnd_api.g_ret_sts_success)

145: p_source_entity_id1 => p_repair_order_line_id,
146: p_source_entity_type_code => NULL,
147: p_source_entity_id2 => NULL
148: );
149: IF (l_return_status <> fnd_api.g_ret_sts_success)
150: THEN
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:

Line 151: RAISE fnd_api.g_exc_unexpected_error;

147: p_source_entity_id2 => NULL
148: );
149: IF (l_return_status <> fnd_api.g_ret_sts_success)
150: THEN
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154:
155: IF (l_event_level >= l_debug_level)

Line 178: RAISE fnd_api.g_exc_error;

174: IF NVL (l_repair_line_status, ' ') <> c_draft_status
175: THEN
176: fnd_message.set_name ('CSD', 'CSD_INVALID_REPAIR_ORDER');
177: fnd_msg_pub.ADD;
178: RAISE fnd_api.g_exc_error;
179: END IF;
180:
181: IF (l_event_level >= l_debug_level)
182: THEN

Line 199: IF (x_return_status <> fnd_api.g_ret_sts_success)

195: p_instance_id => -1,
196: x_prod_txn_tbl => l_prod_txn_tbl,
197: x_return_status => x_return_status);
198:
199: IF (x_return_status <> fnd_api.g_ret_sts_success)
200: THEN
201: RAISE fnd_api.g_exc_unexpected_error;
202: END IF;
203:

Line 201: RAISE fnd_api.g_exc_unexpected_error;

197: x_return_status => x_return_status);
198:
199: IF (x_return_status <> fnd_api.g_ret_sts_success)
200: THEN
201: RAISE fnd_api.g_exc_unexpected_error;
202: END IF;
203:
204: IF (l_stmt_level >= l_debug_level)
205: THEN

Line 257: l_return_status := fnd_api.g_ret_sts_success;

253: END IF;
254: -- This save point is to make sure only the failed serial number is
255: -- rolled back and the processing continues with the next serial number.
256: SAVEPOINT sp_process_ro_start;
257: l_return_status := fnd_api.g_ret_sts_success;
258:
259: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
260: process_ro (p_api_version => 1.0,
261: p_commit => fnd_api.g_false,

Line 261: p_commit => fnd_api.g_false,

257: l_return_status := fnd_api.g_ret_sts_success;
258:
259: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
260: process_ro (p_api_version => 1.0,
261: p_commit => fnd_api.g_false,
262: p_init_msg_list => fnd_api.g_false,
263: p_validation_level => fnd_api.g_valid_level_full,
264: x_return_status => l_return_status,
265: x_msg_count => l_msg_count,

Line 262: p_init_msg_list => fnd_api.g_false,

258:
259: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
260: process_ro (p_api_version => 1.0,
261: p_commit => fnd_api.g_false,
262: p_init_msg_list => fnd_api.g_false,
263: p_validation_level => fnd_api.g_valid_level_full,
264: x_return_status => l_return_status,
265: x_msg_count => l_msg_count,
266: x_msg_data => l_msg_data,

Line 263: p_validation_level => fnd_api.g_valid_level_full,

259: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
260: process_ro (p_api_version => 1.0,
261: p_commit => fnd_api.g_false,
262: p_init_msg_list => fnd_api.g_false,
263: p_validation_level => fnd_api.g_valid_level_full,
264: x_return_status => l_return_status,
265: x_msg_count => l_msg_count,
266: x_msg_data => l_msg_data,
267: p_repair_line_id => p_repair_order_line_id,

Line 278: IF (l_return_status = fnd_api.g_ret_sts_success)

274: );
275:
276: --If the return_status <> 'S' then
277: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.
278: IF (l_return_status = fnd_api.g_ret_sts_success)
279: THEN
280: IF (l_event_level >= l_debug_level)
281: THEN
282: fnd_log.STRING (l_event_level,

Line 292: p_commit => fnd_api.g_false,

288: END IF;
289: l_count_sn_success := l_count_sn_success + 1;
290: csd_repairs_pvt.copy_attachments
291: (p_api_version => 1.0,
292: p_commit => fnd_api.g_false,
293: p_init_msg_list => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_original_ro_id => p_repair_order_line_id,
296: p_new_ro_id => l_new_repln_id,

Line 293: p_init_msg_list => fnd_api.g_false,

289: l_count_sn_success := l_count_sn_success + 1;
290: csd_repairs_pvt.copy_attachments
291: (p_api_version => 1.0,
292: p_commit => fnd_api.g_false,
293: p_init_msg_list => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_original_ro_id => p_repair_order_line_id,
296: p_new_ro_id => l_new_repln_id,
297: x_return_status => l_return_status,

Line 294: p_validation_level => fnd_api.g_valid_level_full,

290: csd_repairs_pvt.copy_attachments
291: (p_api_version => 1.0,
292: p_commit => fnd_api.g_false,
293: p_init_msg_list => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_original_ro_id => p_repair_order_line_id,
296: p_new_ro_id => l_new_repln_id,
297: x_return_status => l_return_status,
298: x_msg_count => l_msg_count,

Line 317: IF (l_return_status <> fnd_api.g_ret_sts_success)

313: p_source_entity_type_code => 'SERIAL_NUMBER',
314: p_source_entity_id2 => l_repair_order_sn_rec.mass_ro_sn_id
315: );
316:
317: IF (l_return_status <> fnd_api.g_ret_sts_success)
318: THEN
319: RAISE fnd_api.g_exc_unexpected_error;
320: END IF;
321:

Line 319: RAISE fnd_api.g_exc_unexpected_error;

315: );
316:
317: IF (l_return_status <> fnd_api.g_ret_sts_success)
318: THEN
319: RAISE fnd_api.g_exc_unexpected_error;
320: END IF;
321:
322: l_return_status := fnd_api.g_ret_sts_success;
323: END IF;

Line 322: l_return_status := fnd_api.g_ret_sts_success;

318: THEN
319: RAISE fnd_api.g_exc_unexpected_error;
320: END IF;
321:
322: l_return_status := fnd_api.g_ret_sts_success;
323: END IF;
324:
325: END LOOP;
326:

Line 363: l_return_status := fnd_api.g_ret_sts_success;

359: l_count_sn_blank := l_count_sn_blank - 1;
360: -- This save point is to make sure only the failed serial number is
361: -- rolled back and the processing continues with the next serial number.
362: SAVEPOINT sp_process_ro_start;
363: l_return_status := fnd_api.g_ret_sts_success;
364:
365: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
366: process_ro (p_api_version => 1.0,
367: p_commit => fnd_api.g_false,

Line 367: p_commit => fnd_api.g_false,

363: l_return_status := fnd_api.g_ret_sts_success;
364:
365: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
366: process_ro (p_api_version => 1.0,
367: p_commit => fnd_api.g_false,
368: p_init_msg_list => fnd_api.g_false,
369: p_validation_level => fnd_api.g_valid_level_full,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,

Line 368: p_init_msg_list => fnd_api.g_false,

364:
365: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
366: process_ro (p_api_version => 1.0,
367: p_commit => fnd_api.g_false,
368: p_init_msg_list => fnd_api.g_false,
369: p_validation_level => fnd_api.g_valid_level_full,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,
372: x_msg_data => l_msg_data,

Line 369: p_validation_level => fnd_api.g_valid_level_full,

365: --Call Process_RO with l_repair_order_tbl(i), Add_to_Order_flag, Mro_Serial_Number
366: process_ro (p_api_version => 1.0,
367: p_commit => fnd_api.g_false,
368: p_init_msg_list => fnd_api.g_false,
369: p_validation_level => fnd_api.g_valid_level_full,
370: x_return_status => l_return_status,
371: x_msg_count => l_msg_count,
372: x_msg_data => l_msg_data,
373: p_repair_line_id => p_repair_order_line_id,

Line 384: IF (l_return_status = fnd_api.g_ret_sts_success)

380: );
381:
382: --If the return_status <> 'S' then
383: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.
384: IF (l_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: l_count_sn_success := l_count_sn_success + 1;
387: csd_repairs_pvt.copy_attachments
388: (p_api_version => 1.0,

Line 389: p_commit => fnd_api.g_false,

385: THEN
386: l_count_sn_success := l_count_sn_success + 1;
387: csd_repairs_pvt.copy_attachments
388: (p_api_version => 1.0,
389: p_commit => fnd_api.g_false,
390: p_init_msg_list => fnd_api.g_false,
391: p_validation_level => fnd_api.g_valid_level_full,
392: p_original_ro_id => p_repair_order_line_id,
393: p_new_ro_id => l_new_repln_id,

Line 390: p_init_msg_list => fnd_api.g_false,

386: l_count_sn_success := l_count_sn_success + 1;
387: csd_repairs_pvt.copy_attachments
388: (p_api_version => 1.0,
389: p_commit => fnd_api.g_false,
390: p_init_msg_list => fnd_api.g_false,
391: p_validation_level => fnd_api.g_valid_level_full,
392: p_original_ro_id => p_repair_order_line_id,
393: p_new_ro_id => l_new_repln_id,
394: x_return_status => l_return_status,

Line 391: p_validation_level => fnd_api.g_valid_level_full,

387: csd_repairs_pvt.copy_attachments
388: (p_api_version => 1.0,
389: p_commit => fnd_api.g_false,
390: p_init_msg_list => fnd_api.g_false,
391: p_validation_level => fnd_api.g_valid_level_full,
392: p_original_ro_id => p_repair_order_line_id,
393: p_new_ro_id => l_new_repln_id,
394: x_return_status => l_return_status,
395: x_msg_count => l_msg_count,

Line 414: IF (l_return_status <> fnd_api.g_ret_sts_success)

410: p_source_entity_type_code => 'SERIAL_NUMBER',
411: p_source_entity_id2 => -1
412: );
413:
414: IF (l_return_status <> fnd_api.g_ret_sts_success)
415: THEN
416: RAISE fnd_api.g_exc_unexpected_error;
417: END IF;
418:

Line 416: RAISE fnd_api.g_exc_unexpected_error;

412: );
413:
414: IF (l_return_status <> fnd_api.g_ret_sts_success)
415: THEN
416: RAISE fnd_api.g_exc_unexpected_error;
417: END IF;
418:
419: l_return_status := fnd_api.g_ret_sts_success;
420: END IF;

Line 419: l_return_status := fnd_api.g_ret_sts_success;

415: THEN
416: RAISE fnd_api.g_exc_unexpected_error;
417: END IF;
418:
419: l_return_status := fnd_api.g_ret_sts_success;
420: END IF;
421:
422: IF (l_event_level >= l_debug_level)
423: THEN

Line 438: RAISE fnd_api.g_exc_error;

434: IF (l_count_sn = 0)
435: THEN
436: fnd_message.set_name ('CSD', 'CSD_NO_SERIAL_NUMBERS');
437: fnd_msg_pub.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:
441:
442:

Line 469: p_init_msg_list => fnd_api.g_false,

465: END IF;
466:
467: csd_repairs_pvt.delete_repair_order
468: (p_api_version_number => 1.0,
469: p_init_msg_list => fnd_api.g_false,
470: p_commit => fnd_api.g_false,
471: p_validation_level => fnd_api.g_valid_level_full,
472: p_repair_line_id => p_repair_order_line_id,
473: x_return_status => l_return_status,

Line 470: p_commit => fnd_api.g_false,

466:
467: csd_repairs_pvt.delete_repair_order
468: (p_api_version_number => 1.0,
469: p_init_msg_list => fnd_api.g_false,
470: p_commit => fnd_api.g_false,
471: p_validation_level => fnd_api.g_valid_level_full,
472: p_repair_line_id => p_repair_order_line_id,
473: x_return_status => l_return_status,
474: x_msg_count => l_msg_count,

Line 471: p_validation_level => fnd_api.g_valid_level_full,

467: csd_repairs_pvt.delete_repair_order
468: (p_api_version_number => 1.0,
469: p_init_msg_list => fnd_api.g_false,
470: p_commit => fnd_api.g_false,
471: p_validation_level => fnd_api.g_valid_level_full,
472: p_repair_line_id => p_repair_order_line_id,
473: x_return_status => l_return_status,
474: x_msg_count => l_msg_count,
475: x_msg_data => l_msg_data

Line 499: IF fnd_api.to_boolean (p_commit)

495:
496: -- Api body ends here
497:
498: -- Standard check of p_commit.
499: IF fnd_api.to_boolean (p_commit)
500: THEN
501: COMMIT WORK;
502: END IF;
503:

Line 516: WHEN fnd_api.g_exc_error

512: 'Leaving Mass_Create_RO'
513: );
514: END IF;
515: EXCEPTION
516: WHEN fnd_api.g_exc_error
517: THEN
518: x_return_status := fnd_api.g_ret_sts_error;
519: log_error_stack ();
520: ROLLBACK TO sp_mass_create_ro;

Line 518: x_return_status := fnd_api.g_ret_sts_error;

514: END IF;
515: EXCEPTION
516: WHEN fnd_api.g_exc_error
517: THEN
518: x_return_status := fnd_api.g_ret_sts_error;
519: log_error_stack ();
520: ROLLBACK TO sp_mass_create_ro;
521: fnd_msg_pub.count_and_get (p_count => x_msg_count,
522: p_data => x_msg_data

Line 532: WHEN fnd_api.g_exc_unexpected_error

528: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
529: 'EXC_ERROR[' || x_msg_data || ']'
530: );
531: END IF;
532: WHEN fnd_api.g_exc_unexpected_error
533: THEN
534: x_return_status := fnd_api.g_ret_sts_unexp_error;
535: ROLLBACK TO sp_mass_create_ro;
536: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 534: x_return_status := fnd_api.g_ret_sts_unexp_error;

530: );
531: END IF;
532: WHEN fnd_api.g_exc_unexpected_error
533: THEN
534: x_return_status := fnd_api.g_ret_sts_unexp_error;
535: ROLLBACK TO sp_mass_create_ro;
536: fnd_msg_pub.count_and_get (p_count => x_msg_count,
537: p_data => x_msg_data
538: );

Line 549: x_return_status := fnd_api.g_ret_sts_unexp_error;

545: );
546: END IF;
547: WHEN OTHERS
548: THEN
549: x_return_status := fnd_api.g_ret_sts_unexp_error;
550: ROLLBACK TO sp_mass_create_ro;
551:
552: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
553: THEN

Line 647: l_return_status := fnd_api.g_ret_sts_success;

643: END IF;
644:
645: SAVEPOINT sp_process_ro;
646:
647: l_return_status := fnd_api.g_ret_sts_success;
648:
649: IF fnd_api.to_boolean (p_init_msg_list)
650: THEN
651: -- initialize message list

Line 649: IF fnd_api.to_boolean (p_init_msg_list)

645: SAVEPOINT sp_process_ro;
646:
647: l_return_status := fnd_api.g_ret_sts_success;
648:
649: IF fnd_api.to_boolean (p_init_msg_list)
650: THEN
651: -- initialize message list
652: fnd_msg_pub.initialize;
653: END IF;

Line 656: IF NOT fnd_api.compatible_api_call (l_api_version_number,

652: fnd_msg_pub.initialize;
653: END IF;
654:
655: -- Standard call to check for call compatibility.
656: IF NOT fnd_api.compatible_api_call (l_api_version_number,
657: p_api_version,
658: l_api_name,
659: g_pkg_name
660: )

Line 662: RAISE fnd_api.g_exc_unexpected_error;

658: l_api_name,
659: g_pkg_name
660: )
661: THEN
662: RAISE fnd_api.g_exc_unexpected_error;
663: END IF;
664:
665: -- initialize return status
666: x_return_status := fnd_api.g_ret_sts_success;

Line 666: x_return_status := fnd_api.g_ret_sts_success;

662: RAISE fnd_api.g_exc_unexpected_error;
663: END IF;
664:
665: -- initialize return status
666: x_return_status := fnd_api.g_ret_sts_success;
667:
668: -- Get the repair order line details and populate the repair orde record
669: --
670: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 754: RAISE fnd_api.g_exc_error;

750: p_repair_line_id
751: );
752: fnd_msg_pub.ADD;
753: CLOSE cur_repair_order;
754: RAISE fnd_api.g_exc_error;
755: END IF;
756:
757: CLOSE cur_repair_order;
758:

Line 782: RAISE fnd_api.g_exc_error;

778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
779: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
780: FND_MSG_PUB.Add;
781: CLOSE cur_repair_type_ref;
782: RAISE fnd_api.g_exc_error;
783: END IF;
784:
785: CLOSE cur_repair_type_ref;
786:

Line 801: RAISE FND_API.G_EXC_ERROR;

797: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
798: dbms_output.put_line('Error condition');
799: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: */
804: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
805: THEN

Line 814: p_commit => fnd_api.g_false,

810: END IF;
811:
812: csd_repairs_pvt.create_repair_order
813: (p_api_version_number => 1.0,
814: p_commit => fnd_api.g_false,
815: p_init_msg_list => fnd_api.g_false,
816: p_validation_level => p_validation_level,
817: p_repair_line_id => NULL,
818: p_repln_rec => l_repair_order_rec,

Line 815: p_init_msg_list => fnd_api.g_false,

811:
812: csd_repairs_pvt.create_repair_order
813: (p_api_version_number => 1.0,
814: p_commit => fnd_api.g_false,
815: p_init_msg_list => fnd_api.g_false,
816: p_validation_level => p_validation_level,
817: p_repair_line_id => NULL,
818: p_repln_rec => l_repair_order_rec,
819: x_repair_line_id => x_new_repln_id,

Line 826: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

822: x_msg_count => x_msg_count,
823: x_msg_data => x_msg_data
824: );
825:
826: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
827: THEN
828: RAISE fnd_api.g_exc_error;
829: END IF;
830:

Line 828: RAISE fnd_api.g_exc_error;

824: );
825:
826: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
827: THEN
828: RAISE fnd_api.g_exc_error;
829: END IF;
830:
831: --Update Repair order line id in the record p_repair_Order_rec and prod txn table
832: l_repair_order_rec.repair_number := l_repair_number;

Line 884: p_commit => fnd_api.g_false,

880: END IF;
881:
882: create_product_txn
883: (p_api_version => 1.0,
884: p_commit => fnd_api.g_false,
885: p_init_msg_list => fnd_api.g_false,
886: p_validation_level => fnd_api.g_valid_level_full,
887: x_return_status => l_return_status,
888: x_msg_count => x_msg_count,

Line 885: p_init_msg_list => fnd_api.g_false,

881:
882: create_product_txn
883: (p_api_version => 1.0,
884: p_commit => fnd_api.g_false,
885: p_init_msg_list => fnd_api.g_false,
886: p_validation_level => fnd_api.g_valid_level_full,
887: x_return_status => l_return_status,
888: x_msg_count => x_msg_count,
889: x_msg_data => x_msg_data,

Line 886: p_validation_level => fnd_api.g_valid_level_full,

882: create_product_txn
883: (p_api_version => 1.0,
884: p_commit => fnd_api.g_false,
885: p_init_msg_list => fnd_api.g_false,
886: p_validation_level => fnd_api.g_valid_level_full,
887: x_return_status => l_return_status,
888: x_msg_count => x_msg_count,
889: x_msg_data => x_msg_data,
890: p_product_txn_rec => p_prod_txn_tbl (i),

Line 894: IF (l_return_status <> fnd_api.g_ret_sts_success)

890: p_product_txn_rec => p_prod_txn_tbl (i),
891: p_add_to_order_flag => p_add_to_order_flag
892: );
893:
894: IF (l_return_status <> fnd_api.g_ret_sts_success)
895: THEN
896: --Rollback to Save point Process_RO
897: RAISE fnd_api.g_exc_error;
898: END IF;

Line 897: RAISE fnd_api.g_exc_error;

893:
894: IF (l_return_status <> fnd_api.g_ret_sts_success)
895: THEN
896: --Rollback to Save point Process_RO
897: RAISE fnd_api.g_exc_error;
898: END IF;
899:
900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
901: )

Line 919: p_commit => Fnd_Api.g_false,

915: -- Call Default Product Txn creation
916: --
917: csd_process_pvt.create_default_prod_txn
918: ( p_api_version => 1.0,
919: p_commit => Fnd_Api.g_false,
920: p_init_msg_list => Fnd_Api.g_false,
921: p_validation_level => Fnd_Api.g_valid_level_full,
922: p_repair_line_id => x_new_repln_id,
923: x_return_status => l_return_status,

Line 920: p_init_msg_list => Fnd_Api.g_false,

916: --
917: csd_process_pvt.create_default_prod_txn
918: ( p_api_version => 1.0,
919: p_commit => Fnd_Api.g_false,
920: p_init_msg_list => Fnd_Api.g_false,
921: p_validation_level => Fnd_Api.g_valid_level_full,
922: p_repair_line_id => x_new_repln_id,
923: x_return_status => l_return_status,
924: x_msg_count => x_msg_count,

Line 921: p_validation_level => Fnd_Api.g_valid_level_full,

917: csd_process_pvt.create_default_prod_txn
918: ( p_api_version => 1.0,
919: p_commit => Fnd_Api.g_false,
920: p_init_msg_list => Fnd_Api.g_false,
921: p_validation_level => Fnd_Api.g_valid_level_full,
922: p_repair_line_id => x_new_repln_id,
923: x_return_status => l_return_status,
924: x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data

Line 935: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

931: 'After Create_default_product_txn['
932: || l_repair_order_rec.serial_number|| ']');
933: END IF;
934:
935: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
936: --Rollback to Save point Process_RO
937: RAISE fnd_api.g_exc_error;
938: END IF;
939:

Line 937: RAISE fnd_api.g_exc_error;

933: END IF;
934:
935: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
936: --Rollback to Save point Process_RO
937: RAISE fnd_api.g_exc_error;
938: END IF;
939:
940: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
941: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN

Line 944: p_init_msg_list => Fnd_Api.G_FALSE,

940: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
941: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
942: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
943: p_api_version_number => 1.0,
944: p_init_msg_list => Fnd_Api.G_FALSE,
945: p_commit => Fnd_Api.G_FALSE,
946: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
947: p_repair_line_id => x_new_repln_id,
948: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 945: p_commit => Fnd_Api.G_FALSE,

941: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
942: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
943: p_api_version_number => 1.0,
944: p_init_msg_list => Fnd_Api.G_FALSE,
945: p_commit => Fnd_Api.G_FALSE,
946: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
947: p_repair_line_id => x_new_repln_id,
948: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
949: x_return_status => l_return_status,

Line 946: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

942: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
943: p_api_version_number => 1.0,
944: p_init_msg_list => Fnd_Api.G_FALSE,
945: p_commit => Fnd_Api.G_FALSE,
946: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
947: p_repair_line_id => x_new_repln_id,
948: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
949: x_return_status => l_return_status,
950: x_msg_count => l_msg_count,

Line 992: IF fnd_api.to_boolean (p_commit)

988:
989: -- Api body ends here
990:
991: -- Standard check of p_commit.
992: IF fnd_api.to_boolean (p_commit)
993: THEN
994: COMMIT WORK;
995: END IF;
996:

Line 1009: WHEN fnd_api.g_exc_error

1005: 'Leaving Process_RO'
1006: );
1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error
1010: THEN
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: ROLLBACK TO sp_process_ro;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1011: x_return_status := fnd_api.g_ret_sts_error;

1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error
1010: THEN
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: ROLLBACK TO sp_process_ro;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );

Line 1024: WHEN fnd_api.g_exc_unexpected_error

1020: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1021: 'EXC_ERROR[' || x_msg_data || ']'
1022: );
1023: END IF;
1024: WHEN fnd_api.g_exc_unexpected_error
1025: THEN
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: ROLLBACK TO sp_process_ro;
1028: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1026: x_return_status := fnd_api.g_ret_sts_unexp_error;

1022: );
1023: END IF;
1024: WHEN fnd_api.g_exc_unexpected_error
1025: THEN
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: ROLLBACK TO sp_process_ro;
1028: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );

Line 1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

1037: );
1038: END IF;
1039: WHEN OTHERS
1040: THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: ROLLBACK TO sp_process_ro;
1043:
1044: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1045: THEN

Line 1231: l_return_status := fnd_api.g_ret_sts_success;

1227: END IF;
1228:
1229: SAVEPOINT sp_create_product_txn;
1230:
1231: l_return_status := fnd_api.g_ret_sts_success;
1232:
1233: IF fnd_api.to_boolean (p_init_msg_list)
1234: THEN
1235: -- initialize message list

Line 1233: IF fnd_api.to_boolean (p_init_msg_list)

1229: SAVEPOINT sp_create_product_txn;
1230:
1231: l_return_status := fnd_api.g_ret_sts_success;
1232:
1233: IF fnd_api.to_boolean (p_init_msg_list)
1234: THEN
1235: -- initialize message list
1236: fnd_msg_pub.initialize;
1237: END IF;

Line 1240: IF NOT fnd_api.compatible_api_call (l_api_version_number,

1236: fnd_msg_pub.initialize;
1237: END IF;
1238:
1239: -- Standard call to check for call compatibility.
1240: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1241: p_api_version,
1242: l_api_name,
1243: g_pkg_name
1244: )

Line 1246: RAISE fnd_api.g_exc_unexpected_error;

1242: l_api_name,
1243: g_pkg_name
1244: )
1245: THEN
1246: RAISE fnd_api.g_exc_unexpected_error;
1247: END IF;
1248:
1249: --Validate input
1250: --Check mandatory parameters Repair_line_id, Action_Code, Action_type, Txn_Billing_Type_Id, Inventory_Item_Id, UOM, Quantity

Line 1288: RAISE fnd_api.g_exc_error;

1284: fnd_msg_pub.ADD;
1285:
1286: CLOSE cur_ro_details;
1287:
1288: RAISE fnd_api.g_exc_error;
1289: END IF;
1290:
1291: CLOSE cur_ro_details;
1292:

Line 1316: IF NVL (p_product_txn_rec.business_process_id, fnd_api.g_miss_num) <>

1312: END IF;
1313:
1314: IF l_bus_process_id < 0
1315: THEN
1316: IF NVL (p_product_txn_rec.business_process_id, fnd_api.g_miss_num) <>
1317: fnd_api.g_miss_num
1318: THEN
1319: l_bus_process_id := p_product_txn_rec.business_process_id;
1320: ELSE

Line 1317: fnd_api.g_miss_num

1313:
1314: IF l_bus_process_id < 0
1315: THEN
1316: IF NVL (p_product_txn_rec.business_process_id, fnd_api.g_miss_num) <>
1317: fnd_api.g_miss_num
1318: THEN
1319: l_bus_process_id := p_product_txn_rec.business_process_id;
1320: ELSE
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1330: RAISE fnd_api.g_exc_error;

1326: 'Business process Id does not exist '
1327: );
1328: END IF;
1329:
1330: RAISE fnd_api.g_exc_error;
1331: END IF;
1332: END IF;
1333:
1334: ---------------------------------------------------------------------------------

Line 1337: OR (p_product_txn_rec.transaction_type_id = fnd_api.g_miss_num)

1333:
1334: ---------------------------------------------------------------------------------
1335: --Get the transaction type id
1336: IF (p_product_txn_rec.transaction_type_id IS NULL)
1337: OR (p_product_txn_rec.transaction_type_id = fnd_api.g_miss_num)
1338: THEN
1339: OPEN cur_txn_type_id (p_product_txn_rec.txn_billing_type_id);
1340:
1341: FETCH cur_txn_type_id

Line 1358: RAISE fnd_api.g_exc_error;

1354: END IF;
1355:
1356: CLOSE cur_txn_type_id;
1357:
1358: RAISE fnd_api.g_exc_error;
1359: END IF;
1360:
1361: CLOSE cur_txn_type_id;
1362:

Line 1388: IF NVL (p_product_txn_rec.contract_id, fnd_api.g_miss_num) <>

1384: END IF;
1385:
1386: -- Get the coverage details from the contract
1387: /*** Contract re arch changes for R12
1388: IF NVL (p_product_txn_rec.contract_id, fnd_api.g_miss_num) <>
1389: fnd_api.g_miss_num
1390: THEN
1391: OPEN cur_coverage_details (l_bus_process_id);
1392:

Line 1389: fnd_api.g_miss_num

1385:
1386: -- Get the coverage details from the contract
1387: /*** Contract re arch changes for R12
1388: IF NVL (p_product_txn_rec.contract_id, fnd_api.g_miss_num) <>
1389: fnd_api.g_miss_num
1390: THEN
1391: OPEN cur_coverage_details (l_bus_process_id);
1392:
1393: FETCH cur_coverage_details

Line 1417: RAISE fnd_api.g_exc_error;

1413: END IF;
1414:
1415: CLOSE cur_coverage_details;
1416:
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:
1420: CLOSE cur_coverage_details;
1421:

Line 1445: RAISE fnd_api.g_exc_error;

1441: fnd_msg_pub.ADD;
1442:
1443: CLOSE cur_cust_details;
1444:
1445: RAISE fnd_api.g_exc_error;
1446: END IF;
1447:
1448: CLOSE cur_cust_details;
1449: END IF;

Line 1463: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1459: x_line_category_code => l_line_category_code,
1460: x_return_status => x_return_status
1461: );
1462:
1463: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:

Line 1465: RAISE fnd_api.g_exc_error;

1461: );
1462:
1463: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1469: THEN

Line 1495: RAISE fnd_api.g_exc_error;

1491: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1492: p_product_txn_rec.txn_billing_type_id
1493: );
1494: fnd_msg_pub.ADD;
1495: RAISE fnd_api.g_exc_error;
1496: END IF;
1497:
1498: ---------------------------------------------------------------------------------7
1499:

Line 1529: RAISE fnd_api.g_exc_error;

1525: || p_product_txn_rec.inventory_item_id
1526: );
1527: END IF;
1528:
1529: RAISE fnd_api.g_exc_error;
1530: END IF;
1531: END IF;
1532:
1533: ---------------------------------------------------------------------------------8

Line 1536: IF NVL (p_product_txn_rec.price_list_id, fnd_api.g_miss_num) <>

1532:
1533: ---------------------------------------------------------------------------------8
1534: --Derive currency_Code from the oe_price_lists_all for the given price_list_id
1535: -- Get the currency code from the price list if it is null or g_miss
1536: IF NVL (p_product_txn_rec.price_list_id, fnd_api.g_miss_num) <>
1537: fnd_api.g_miss_num
1538: THEN
1539: OPEN cur_pricelist_details (p_product_txn_rec.price_list_id);
1540:

Line 1537: fnd_api.g_miss_num

1533: ---------------------------------------------------------------------------------8
1534: --Derive currency_Code from the oe_price_lists_all for the given price_list_id
1535: -- Get the currency code from the price list if it is null or g_miss
1536: IF NVL (p_product_txn_rec.price_list_id, fnd_api.g_miss_num) <>
1537: fnd_api.g_miss_num
1538: THEN
1539: OPEN cur_pricelist_details (p_product_txn_rec.price_list_id);
1540:
1541: FETCH cur_pricelist_details

Line 1554: RAISE fnd_api.g_exc_error;

1550: fnd_msg_pub.ADD;
1551:
1552: CLOSE cur_pricelist_details;
1553:
1554: RAISE fnd_api.g_exc_error;
1555: END IF;
1556:
1557: CLOSE cur_pricelist_details;
1558:

Line 1630: p_product_txn_rec.order_header_id := fnd_api.g_miss_num;

1626: p_product_txn_rec.add_to_order_flag := 'Y';
1627: p_product_txn_rec.order_header_id := l_order_header_id;
1628: ELSE
1629: p_product_txn_rec.add_to_order_flag := 'F';
1630: p_product_txn_rec.order_header_id := fnd_api.g_miss_num;
1631: END IF;
1632: END IF; ----------------IF C
1633: /* END IF; */ ----------IF B
1634:

Line 1662: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1658: x_charges_rec => l_charges_rec,
1659: x_return_status => x_return_status
1660: );
1661:
1662: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1663: THEN
1664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1665: THEN
1666: fnd_log.STRING (fnd_log.level_statement,

Line 1672: RAISE fnd_api.g_exc_error;

1668: 'sql error[' || SQLERRM || ']'
1669: );
1670: END IF;
1671:
1672: RAISE fnd_api.g_exc_error;
1673: END IF;
1674:
1675: ----------Temp code
1676: l_charges_rec.charge_line_type := 'ACTUAL';

Line 1692: p_commit => fnd_api.g_false,

1688: END IF;
1689:
1690: csd_process_pvt.process_charge_lines
1691: (p_api_version => 1.0,
1692: p_commit => fnd_api.g_false,
1693: p_init_msg_list => fnd_api.g_false,
1694: p_validation_level => fnd_api.g_valid_level_full,
1695: p_action => 'CREATE',
1696: p_charges_rec => l_charges_rec,

Line 1693: p_init_msg_list => fnd_api.g_false,

1689:
1690: csd_process_pvt.process_charge_lines
1691: (p_api_version => 1.0,
1692: p_commit => fnd_api.g_false,
1693: p_init_msg_list => fnd_api.g_false,
1694: p_validation_level => fnd_api.g_valid_level_full,
1695: p_action => 'CREATE',
1696: p_charges_rec => l_charges_rec,
1697: x_estimate_detail_id => l_estimate_detail_id,

Line 1694: p_validation_level => fnd_api.g_valid_level_full,

1690: csd_process_pvt.process_charge_lines
1691: (p_api_version => 1.0,
1692: p_commit => fnd_api.g_false,
1693: p_init_msg_list => fnd_api.g_false,
1694: p_validation_level => fnd_api.g_valid_level_full,
1695: p_action => 'CREATE',
1696: p_charges_rec => l_charges_rec,
1697: x_estimate_detail_id => l_estimate_detail_id,
1698: x_return_status => x_return_status,

Line 1703: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1699: x_msg_count => x_msg_count,
1700: x_msg_data => x_msg_data
1701: );
1702:
1703: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1704: THEN
1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1706: THEN
1707: fnd_log.STRING (fnd_log.level_statement,

Line 1713: RAISE fnd_api.g_exc_error;

1709: 'Error[' || SUBSTR (x_msg_data, 1, 200) || ']'
1710: );
1711: END IF;
1712:
1713: RAISE fnd_api.g_exc_error;
1714: END IF;
1715:
1716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1717: THEN

Line 1791: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1787: p_project_id => p_product_txn_rec.project_id,
1788: p_task_id => p_product_txn_rec.task_id,
1789: p_unit_number => p_product_txn_rec.unit_number);
1790:
1791: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1792: THEN
1793: RAISE fnd_api.g_exc_error;
1794: END IF;
1795:

Line 1793: RAISE fnd_api.g_exc_error;

1789: p_unit_number => p_product_txn_rec.unit_number);
1790:
1791: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1792: THEN
1793: RAISE fnd_api.g_exc_error;
1794: END IF;
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN

Line 1828: p_commit => fnd_api.g_false,

1824: END IF;
1825:
1826: csd_process_pvt.apply_contract
1827: (p_api_version => 1.0,
1828: p_commit => fnd_api.g_false,
1829: p_init_msg_list => fnd_api.g_false,
1830: p_validation_level => fnd_api.g_valid_level_full,
1831: p_incident_id => l_incident_id,
1832: x_return_status => x_return_status,

Line 1829: p_init_msg_list => fnd_api.g_false,

1825:
1826: csd_process_pvt.apply_contract
1827: (p_api_version => 1.0,
1828: p_commit => fnd_api.g_false,
1829: p_init_msg_list => fnd_api.g_false,
1830: p_validation_level => fnd_api.g_valid_level_full,
1831: p_incident_id => l_incident_id,
1832: x_return_status => x_return_status,
1833: x_msg_count => x_msg_count,

Line 1830: p_validation_level => fnd_api.g_valid_level_full,

1826: csd_process_pvt.apply_contract
1827: (p_api_version => 1.0,
1828: p_commit => fnd_api.g_false,
1829: p_init_msg_list => fnd_api.g_false,
1830: p_validation_level => fnd_api.g_valid_level_full,
1831: p_incident_id => l_incident_id,
1832: x_return_status => x_return_status,
1833: x_msg_count => x_msg_count,
1834: x_msg_data => x_msg_data

Line 1837: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1833: x_msg_count => x_msg_count,
1834: x_msg_data => x_msg_data
1835: );
1836:
1837: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1838: THEN
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1840: THEN
1841: fnd_log.STRING

Line 1850: RAISE fnd_api.g_exc_error;

1846: || ']'
1847: );
1848: END IF;
1849:
1850: RAISE fnd_api.g_exc_error;
1851: END IF;
1852:
1853: -- THis api will interface and book the charge line
1854: ------------------------------------------------------------------------------------

Line 1892: p_commit => fnd_api.g_false,

1888: l_order_rec.org_id := p_product_txn_rec.organization_id ;
1889:
1890: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1891: ( p_api_version => 1.0 ,
1892: p_commit => fnd_api.g_false,
1893: p_init_msg_list => fnd_api.g_false,
1894: p_validation_level => fnd_api.g_valid_level_full,
1895: p_action => 'CREATE',
1896: p_order_rec => l_order_rec,

Line 1893: p_init_msg_list => fnd_api.g_false,

1889:
1890: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1891: ( p_api_version => 1.0 ,
1892: p_commit => fnd_api.g_false,
1893: p_init_msg_list => fnd_api.g_false,
1894: p_validation_level => fnd_api.g_valid_level_full,
1895: p_action => 'CREATE',
1896: p_order_rec => l_order_rec,
1897: x_return_status => x_return_status,

Line 1894: p_validation_level => fnd_api.g_valid_level_full,

1890: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1891: ( p_api_version => 1.0 ,
1892: p_commit => fnd_api.g_false,
1893: p_init_msg_list => fnd_api.g_false,
1894: p_validation_level => fnd_api.g_valid_level_full,
1895: p_action => 'CREATE',
1896: p_order_rec => l_order_rec,
1897: x_return_status => x_return_status,
1898: x_msg_count => x_msg_count,

Line 1901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1897: x_return_status => x_return_status,
1898: x_msg_count => x_msg_count,
1899: x_msg_data => x_msg_data );
1900:
1901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1903: THEN
1904: fnd_log.STRING (fnd_log.level_statement,
1905: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1908: RAISE FND_API.G_EXC_ERROR;

1904: fnd_log.STRING (fnd_log.level_statement,
1905: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1906: 'process_sales_order failed['||x_msg_data||']');
1907: END IF;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911: Validate_order(p_est_detail_id => l_estimate_detail_id,
1912: p_order_rec => l_order_rec,

Line 1927: p_commit => fnd_api.g_false,

1923:
1924: IF(l_booked_flag <> 'Y') THEN
1925: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1926: ( p_api_version => 1.0 ,
1927: p_commit => fnd_api.g_false,
1928: p_init_msg_list => fnd_api.g_false,
1929: p_validation_level => fnd_api.g_valid_level_full,
1930: p_action => 'BOOK',
1931: p_order_rec => l_order_rec,

Line 1928: p_init_msg_list => fnd_api.g_false,

1924: IF(l_booked_flag <> 'Y') THEN
1925: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1926: ( p_api_version => 1.0 ,
1927: p_commit => fnd_api.g_false,
1928: p_init_msg_list => fnd_api.g_false,
1929: p_validation_level => fnd_api.g_valid_level_full,
1930: p_action => 'BOOK',
1931: p_order_rec => l_order_rec,
1932: x_return_status => x_return_status,

Line 1929: p_validation_level => fnd_api.g_valid_level_full,

1925: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1926: ( p_api_version => 1.0 ,
1927: p_commit => fnd_api.g_false,
1928: p_init_msg_list => fnd_api.g_false,
1929: p_validation_level => fnd_api.g_valid_level_full,
1930: p_action => 'BOOK',
1931: p_order_rec => l_order_rec,
1932: x_return_status => x_return_status,
1933: x_msg_count => x_msg_count,

Line 1936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1932: x_return_status => x_return_status,
1933: x_msg_count => x_msg_count,
1934: x_msg_data => x_msg_data );
1935:
1936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1938: THEN
1939: fnd_log.STRING (fnd_log.level_statement,
1940: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1943: RAISE FND_API.G_EXC_ERROR;

1939: fnd_log.STRING (fnd_log.level_statement,
1940: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1941: 'process_sales_order failed ['||x_msg_Data||']');
1942: END IF;
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;
1945: END IF;
1946: /****************
1947: cs_charge_create_order_pub.submit_order

Line 1963: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1959: );
1960: *************/
1961:
1962: --] 3308535
1963: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1964: THEN
1965: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1966: THEN
1967: fnd_log.STRING

Line 1976: RAISE fnd_api.g_exc_error;

1972: || ']'
1973: );
1974: END IF;
1975:
1976: RAISE fnd_api.g_exc_error;
1977: END IF;
1978: ELSE
1979: l_ro_txn_status := 'CHARGE_ENTERED';
1980: l_prod_txn_status := 'ENTERED';

Line 2002: RAISE fnd_api.g_exc_error;

1998: fnd_message.set_token ('REPAIR_LINE_ID',
1999: p_product_txn_rec.repair_line_id
2000: );
2001: fnd_msg_pub.ADD;
2002: RAISE fnd_api.g_exc_error;
2003: END IF;
2004:
2005: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2006: THEN

Line 2025: RAISE fnd_api.g_exc_error;

2021: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2022: p_product_txn_rec.product_transaction_id
2023: );
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;
2026: END IF;
2027:
2028: ----------------------------------------------------------------------------
2029:

Line 2033: IF fnd_api.to_boolean (p_commit)

2029:
2030: -- Api body ends here
2031:
2032: -- Standard check of p_commit.
2033: IF fnd_api.to_boolean (p_commit)
2034: THEN
2035: COMMIT WORK;
2036: END IF;
2037:

Line 2050: WHEN fnd_api.g_exc_error

2046: 'Leaving CREATE_PRODUCT_TXN'
2047: );
2048: END IF;
2049: EXCEPTION
2050: WHEN fnd_api.g_exc_error
2051: THEN
2052: x_return_status := fnd_api.g_ret_sts_error;
2053: log_error_stack ();
2054: ROLLBACK TO sp_create_product_txn;

Line 2052: x_return_status := fnd_api.g_ret_sts_error;

2048: END IF;
2049: EXCEPTION
2050: WHEN fnd_api.g_exc_error
2051: THEN
2052: x_return_status := fnd_api.g_ret_sts_error;
2053: log_error_stack ();
2054: ROLLBACK TO sp_create_product_txn;
2055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data

Line 2066: WHEN fnd_api.g_exc_unexpected_error

2062: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2063: 'EXC_ERROR[' || x_msg_data || ']'
2064: );
2065: END IF;
2066: WHEN fnd_api.g_exc_unexpected_error
2067: THEN
2068: x_return_status := fnd_api.g_ret_sts_unexp_error;
2069: ROLLBACK TO sp_create_product_txn;
2070: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2068: x_return_status := fnd_api.g_ret_sts_unexp_error;

2064: );
2065: END IF;
2066: WHEN fnd_api.g_exc_unexpected_error
2067: THEN
2068: x_return_status := fnd_api.g_ret_sts_unexp_error;
2069: ROLLBACK TO sp_create_product_txn;
2070: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );

Line 2083: x_return_status := fnd_api.g_ret_sts_unexp_error;

2079: );
2080: END IF;
2081: WHEN OTHERS
2082: THEN
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: ROLLBACK TO sp_create_product_txn;
2085:
2086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2087: THEN

Line 2158: IF NOT fnd_api.compatible_api_call (l_api_version,

2154: -- Standard Start of API savepoint
2155: SAVEPOINT create_item_instance;
2156:
2157: -- Standard call to check for call compatibility.
2158: IF NOT fnd_api.compatible_api_call (l_api_version,
2159: p_api_version,
2160: -- l_api_name ,
2161: g_pkg_name,
2162: g_file_name

Line 2165: RAISE fnd_api.g_exc_unexpected_error;

2161: g_pkg_name,
2162: g_file_name
2163: )
2164: THEN
2165: RAISE fnd_api.g_exc_unexpected_error;
2166: END IF;
2167:
2168: -- Initialize message list if p_init_msg_list is set to TRUE.
2169: IF fnd_api.to_boolean (p_init_msg_list)

Line 2169: IF fnd_api.to_boolean (p_init_msg_list)

2165: RAISE fnd_api.g_exc_unexpected_error;
2166: END IF;
2167:
2168: -- Initialize message list if p_init_msg_list is set to TRUE.
2169: IF fnd_api.to_boolean (p_init_msg_list)
2170: THEN
2171: fnd_msg_pub.initialize;
2172: END IF;
2173:

Line 2175: x_return_status := fnd_api.g_ret_sts_success;

2171: fnd_msg_pub.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success
2175: x_return_status := fnd_api.g_ret_sts_success;
2176:
2177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2178: THEN
2179: fnd_log.STRING (fnd_log.level_statement,

Line 2201: RAISE fnd_api.g_exc_error;

2197: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2198: px_instance_rec.party_site_use_id
2199: );
2200: --px_instance_rec.bill_to_site_use_id);
2201: RAISE fnd_api.g_exc_error;
2202: END;
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN

Line 2295: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

2291: x_msg_data => l_msg_data
2292: );
2293:
2294: log_error_stack();
2295: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2296: THEN
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299:

Line 2297: RAISE fnd_api.g_exc_error;

2293:
2294: log_error_stack();
2295: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2296: THEN
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299:
2300: x_instance_id := l_instance_rec.instance_id;
2301: px_instance_rec.instance_id := l_instance_rec.instance_id;

Line 2305: IF fnd_api.to_boolean (p_commit)

2301: px_instance_rec.instance_id := l_instance_rec.instance_id;
2302: px_instance_rec.instance_number := l_instance_rec.instance_number;
2303:
2304: -- Standard check of p_commit.
2305: IF fnd_api.to_boolean (p_commit)
2306: THEN
2307: COMMIT WORK;
2308: END IF;
2309:

Line 2323: WHEN fnd_api.g_exc_error

2319: 'Leaving CREATE_ITEM_INSTANCE'
2320: );
2321: END IF;
2322: EXCEPTION
2323: WHEN fnd_api.g_exc_error
2324: THEN
2325: ROLLBACK TO create_item_instance;
2326: x_return_status := fnd_api.g_ret_sts_error;
2327: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2326: x_return_status := fnd_api.g_ret_sts_error;

2322: EXCEPTION
2323: WHEN fnd_api.g_exc_error
2324: THEN
2325: ROLLBACK TO create_item_instance;
2326: x_return_status := fnd_api.g_ret_sts_error;
2327: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2328: p_data => x_msg_data
2329: );
2330:

Line 2339: WHEN fnd_api.g_exc_unexpected_error

2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2336: 'EXC_ERROR[' || x_msg_data || ']'
2337: );
2338: END IF;
2339: WHEN fnd_api.g_exc_unexpected_error
2340: THEN
2341: ROLLBACK TO create_item_instance;
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2342: x_return_status := fnd_api.g_ret_sts_unexp_error;

2338: END IF;
2339: WHEN fnd_api.g_exc_unexpected_error
2340: THEN
2341: ROLLBACK TO create_item_instance;
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2344: p_data => x_msg_data
2345: );
2346:

Line 2358: x_return_status := fnd_api.g_ret_sts_unexp_error;

2354: END IF;
2355: WHEN OTHERS
2356: THEN
2357: ROLLBACK TO create_item_instance;
2358: x_return_status := fnd_api.g_ret_sts_unexp_error;
2359:
2360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2361: THEN
2362: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);

Line 2408: l_return_status := fnd_api.g_ret_sts_success;

2404: 'Checking mandatory parameters'
2405: );
2406: END IF;
2407:
2408: l_return_status := fnd_api.g_ret_sts_success;
2409:
2410: csd_process_util.check_reqd_param
2411: (p_param_value => p_product_txn_rec.repair_line_id,
2412: p_param_name => 'REPAIR_LINE_ID',

Line 2472: RAISE fnd_api.g_exc_error;

2468: IF NOT (csd_process_util.validate_rep_line_id
2469: (p_repair_line_id => p_product_txn_rec.repair_line_id)
2470: )
2471: THEN
2472: RAISE fnd_api.g_exc_error;
2473: END IF;
2474:
2475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2476: THEN

Line 2489: RAISE fnd_api.g_exc_error;

2485: IF NOT (csd_process_util.validate_action_type
2486: (p_action_type => p_product_txn_rec.action_type)
2487: )
2488: THEN
2489: RAISE fnd_api.g_exc_error;
2490: END IF;
2491:
2492: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2493: THEN

Line 2506: RAISE fnd_api.g_exc_error;

2502: IF NOT (csd_process_util.validate_action_code
2503: (p_action_code => p_product_txn_rec.action_code)
2504: )
2505: THEN
2506: RAISE fnd_api.g_exc_error;
2507: END IF;
2508:
2509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2510: THEN

Line 2534: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

2530: p_prod_txn_qty => p_product_txn_rec.quantity,
2531: x_return_status => l_return_status
2532: );
2533:
2534: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2535: THEN
2536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2537: THEN
2538: fnd_log.STRING

Line 2545: RAISE fnd_api.g_exc_error;

2541: 'Validate_Quantity failed '
2542: );
2543: END IF;
2544:
2545: RAISE fnd_api.g_exc_error;
2546: END IF;
2547: END IF;
2548:
2549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2566: AND (p_product_txn_rec.prod_txn_status <> fnd_api.g_miss_char)

2562: END IF;
2563:
2564: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2565: IF (p_product_txn_rec.prod_txn_status IS NOT NULL)
2566: AND (p_product_txn_rec.prod_txn_status <> fnd_api.g_miss_char)
2567: THEN
2568: BEGIN
2569: SELECT 'X'
2570: INTO l_check

Line 2579: RAISE fnd_api.g_exc_error;

2575: WHEN OTHERS
2576: THEN
2577: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END;
2581: END IF;
2582:
2583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 2636: RAISE fnd_api.g_exc_error;

2632: THEN
2633: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2634: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_exc_error;
2637: END is_item_pre_serialized;
2638:
2639: ------------------------------------------------------------------------------
2640: -------------------------------------------------------------------------------

Line 2664: RAISE fnd_api.g_exc_error;

2660: THEN
2661: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2662: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: END is_item_ib_trackable;
2666:
2667: ----------------------------------------------------------------------
2668: -- Funciton to validate the order

Line 2748: RAISE fnd_api.g_exc_error;

2744: END IF;
2745:
2746: CLOSE cur_ord_details;
2747:
2748: RAISE fnd_api.g_exc_error;
2749: END IF;
2750:
2751: IF cur_ord_details%ROWCOUNT > 1
2752: THEN

Line 2786: RAISE fnd_api.g_exc_error;

2782: END IF;
2783:
2784: CLOSE cur_ord_line;
2785:
2786: RAISE fnd_api.g_exc_error;
2787: END IF;
2788:
2789: IF cur_ord_line%ROWCOUNT > 1
2790: THEN

Line 2817: RAISE fnd_api.g_exc_error;

2813: || l_order_line_id
2814: );
2815: END IF;
2816:
2817: RAISE fnd_api.g_exc_error;
2818: END IF;
2819:
2820: IF l_unit_selling_price IS NULL
2821: THEN

Line 2835: RAISE fnd_api.g_exc_error;

2831: || l_order_line_id
2832: );
2833: END IF;
2834:
2835: RAISE fnd_api.g_exc_error;
2836: END IF;
2837:
2838: OPEN cur_ord_hdr (p_order_rec.order_header_id);
2839:

Line 2853: RAISE fnd_api.g_exc_error;

2849: fnd_msg_pub.ADD;
2850:
2851: CLOSE cur_ord_hdr;
2852:
2853: RAISE fnd_api.g_exc_error;
2854: END IF;
2855:
2856: CLOSE cur_ord_hdr;
2857:

Line 2911: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;

2907: -- like non_source_serial_number non_source_instance_id etc
2908: -- Shipping customer product txn line
2909: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ; -- 11.5.10
2910: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id; -- 11.5.10
2911: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2912: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2913: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2914: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2915: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;

Line 2912: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;

2908: -- Shipping customer product txn line
2909: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ; -- 11.5.10
2910: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id; -- 11.5.10
2911: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2912: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2913: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2914: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2915: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;
2916: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2916: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

2912: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2913: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2914: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2915: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;
2916: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2917: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2918: IF p_repair_type_ref = 'E' THEN
2919: x_prod_txn_tbl(2).non_source_instance_id := p_instance_id;
2920: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;

Line 2917: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;

2913: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2914: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2915: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;
2916: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2917: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2918: IF p_repair_type_ref = 'E' THEN
2919: x_prod_txn_tbl(2).non_source_instance_id := p_instance_id;
2920: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;
2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;

Line 2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;

2917: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2918: IF p_repair_type_ref = 'E' THEN
2919: x_prod_txn_tbl(2).non_source_instance_id := p_instance_id;
2920: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;
2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2922: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2923: ELSE
2924: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2925: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2922: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;

2918: IF p_repair_type_ref = 'E' THEN
2919: x_prod_txn_tbl(2).non_source_instance_id := p_instance_id;
2920: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;
2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2922: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2923: ELSE
2924: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2925: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2926: x_prod_txn_tbl(2).source_instance_id := p_instance_id;

Line 2924: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

2920: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;
2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2922: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2923: ELSE
2924: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2925: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2926: x_prod_txn_tbl(2).source_instance_id := p_instance_id;
2927: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2928: END IF;

Line 2925: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

2921: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2922: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2923: ELSE
2924: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2925: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2926: x_prod_txn_tbl(2).source_instance_id := p_instance_id;
2927: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2928: END IF;
2929:

Line 2932: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;

2928: END IF;
2929:
2930:
2931: ELSIF (p_repair_type_ref = 'AL') THEN
2932: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;

Line 2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

2929:
2930:
2931: ELSIF (p_repair_type_ref = 'AL') THEN
2932: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;

2930:
2931: ELSIF (p_repair_type_ref = 'AL') THEN
2932: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2938: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;

Line 2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;

2931: ELSIF (p_repair_type_ref = 'AL') THEN
2932: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2938: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2939: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

Line 2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2938: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2939: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2940:
2941: ELSIF ( p_repair_type_ref = 'AE' ) THEN

Line 2939: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

2935: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2936: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2937: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2938: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2939: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2940:
2941: ELSIF ( p_repair_type_ref = 'AE' ) THEN
2942:
2943: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;

Line 2943: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;

2939: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2940:
2941: ELSIF ( p_repair_type_ref = 'AE' ) THEN
2942:
2943: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2944: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2945: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2946: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2947: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;

Line 2945: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;

2941: ELSIF ( p_repair_type_ref = 'AE' ) THEN
2942:
2943: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2944: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2945: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2946: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2947: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2948: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2949: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;

Line 2948: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

2944: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2945: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2946: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2947: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2948: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2949: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2950: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2951: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2952:

Line 2950: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

2946: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2947: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2948: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2949: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2950: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2951: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2952:
2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;

2949: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2950: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2951: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2952:
2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2957:

Line 2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

2950: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2951: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2952:
2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2957:
2958: x_prod_txn_tbl(2).source_serial_number := p_serial_number;

Line 2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;

2951: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2952:
2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2957:
2958: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;

2952:
2953: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2954: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2957:
2958: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2960: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;

Line 2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

2955: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2956: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2957:
2958: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2960: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2961: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2962: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2961: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

2957:
2958: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2960: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2961: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2962: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2964: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;

Line 2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;

2959: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2960: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2961: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2962: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2964: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2966: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2967: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;

Line 2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;

2961: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2962: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2964: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2966: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2967: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2968: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2969: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;

Line 2967: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;

2963: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2964: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2966: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2967: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2968: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2969: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;
2970:
2971: END IF;

Line 2969: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;

2965: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2966: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2967: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2968: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2969: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;
2970:
2971: END IF;
2972:
2973: END upd_instance;