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 648: l_return_status := fnd_api.g_ret_sts_success;

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

Line 650: IF fnd_api.to_boolean (p_init_msg_list)

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

Line 657: IF NOT fnd_api.compatible_api_call (l_api_version_number,

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

Line 663: RAISE fnd_api.g_exc_unexpected_error;

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

Line 667: x_return_status := fnd_api.g_ret_sts_success;

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

Line 760: RAISE fnd_api.g_exc_error;

756: p_repair_line_id
757: );
758: fnd_msg_pub.ADD;
759: CLOSE cur_repair_order;
760: RAISE fnd_api.g_exc_error;
761: END IF;
762:
763: CLOSE cur_repair_order;
764:

Line 788: RAISE fnd_api.g_exc_error;

784: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
785: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
786: FND_MSG_PUB.Add;
787: CLOSE cur_repair_type_ref;
788: RAISE fnd_api.g_exc_error;
789: END IF;
790:
791: CLOSE cur_repair_type_ref;
792:

Line 807: RAISE FND_API.G_EXC_ERROR;

803: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
804: dbms_output.put_line('Error condition');
805: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: */
810: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
811: THEN

Line 820: p_commit => fnd_api.g_false,

816: END IF;
817:
818: csd_repairs_pvt.create_repair_order
819: (p_api_version_number => 1.0,
820: p_commit => fnd_api.g_false,
821: p_init_msg_list => fnd_api.g_false,
822: p_validation_level => p_validation_level,
823: p_repair_line_id => NULL,
824: p_repln_rec => l_repair_order_rec,

Line 821: p_init_msg_list => fnd_api.g_false,

817:
818: csd_repairs_pvt.create_repair_order
819: (p_api_version_number => 1.0,
820: p_commit => fnd_api.g_false,
821: p_init_msg_list => fnd_api.g_false,
822: p_validation_level => p_validation_level,
823: p_repair_line_id => NULL,
824: p_repln_rec => l_repair_order_rec,
825: x_repair_line_id => x_new_repln_id,

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

828: x_msg_count => x_msg_count,
829: x_msg_data => x_msg_data
830: );
831:
832: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
833: THEN
834: RAISE fnd_api.g_exc_error;
835: END IF;
836:

Line 834: RAISE fnd_api.g_exc_error;

830: );
831:
832: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
833: THEN
834: RAISE fnd_api.g_exc_error;
835: END IF;
836:
837: --Update Repair order line id in the record p_repair_Order_rec and prod txn table
838: l_repair_order_rec.repair_number := l_repair_number;

Line 890: p_commit => fnd_api.g_false,

886: END IF;
887:
888: create_product_txn
889: (p_api_version => 1.0,
890: p_commit => fnd_api.g_false,
891: p_init_msg_list => fnd_api.g_false,
892: p_validation_level => fnd_api.g_valid_level_full,
893: x_return_status => l_return_status,
894: x_msg_count => x_msg_count,

Line 891: p_init_msg_list => fnd_api.g_false,

887:
888: create_product_txn
889: (p_api_version => 1.0,
890: p_commit => fnd_api.g_false,
891: p_init_msg_list => fnd_api.g_false,
892: p_validation_level => fnd_api.g_valid_level_full,
893: x_return_status => l_return_status,
894: x_msg_count => x_msg_count,
895: x_msg_data => x_msg_data,

Line 892: p_validation_level => fnd_api.g_valid_level_full,

888: create_product_txn
889: (p_api_version => 1.0,
890: p_commit => fnd_api.g_false,
891: p_init_msg_list => fnd_api.g_false,
892: p_validation_level => fnd_api.g_valid_level_full,
893: x_return_status => l_return_status,
894: x_msg_count => x_msg_count,
895: x_msg_data => x_msg_data,
896: p_product_txn_rec => p_prod_txn_tbl (i),

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

896: p_product_txn_rec => p_prod_txn_tbl (i),
897: p_add_to_order_flag => p_add_to_order_flag
898: );
899:
900: IF (l_return_status <> fnd_api.g_ret_sts_success)
901: THEN
902: --Rollback to Save point Process_RO
903: RAISE fnd_api.g_exc_error;
904: END IF;

Line 903: RAISE fnd_api.g_exc_error;

899:
900: IF (l_return_status <> fnd_api.g_ret_sts_success)
901: THEN
902: --Rollback to Save point Process_RO
903: RAISE fnd_api.g_exc_error;
904: END IF;
905:
906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
907: )

Line 925: p_commit => Fnd_Api.g_false,

921: -- Call Default Product Txn creation
922: --
923: csd_process_pvt.create_default_prod_txn
924: ( p_api_version => 1.0,
925: p_commit => Fnd_Api.g_false,
926: p_init_msg_list => Fnd_Api.g_false,
927: p_validation_level => Fnd_Api.g_valid_level_full,
928: p_repair_line_id => x_new_repln_id,
929: x_return_status => l_return_status,

Line 926: p_init_msg_list => Fnd_Api.g_false,

922: --
923: csd_process_pvt.create_default_prod_txn
924: ( p_api_version => 1.0,
925: p_commit => Fnd_Api.g_false,
926: p_init_msg_list => Fnd_Api.g_false,
927: p_validation_level => Fnd_Api.g_valid_level_full,
928: p_repair_line_id => x_new_repln_id,
929: x_return_status => l_return_status,
930: x_msg_count => x_msg_count,

Line 927: p_validation_level => Fnd_Api.g_valid_level_full,

923: csd_process_pvt.create_default_prod_txn
924: ( p_api_version => 1.0,
925: p_commit => Fnd_Api.g_false,
926: p_init_msg_list => Fnd_Api.g_false,
927: p_validation_level => Fnd_Api.g_valid_level_full,
928: p_repair_line_id => x_new_repln_id,
929: x_return_status => l_return_status,
930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data

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

937: 'After Create_default_product_txn['
938: || l_repair_order_rec.serial_number|| ']');
939: END IF;
940:
941: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
942: --Rollback to Save point Process_RO
943: RAISE fnd_api.g_exc_error;
944: END IF;
945:

Line 943: RAISE fnd_api.g_exc_error;

939: END IF;
940:
941: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
942: --Rollback to Save point Process_RO
943: RAISE fnd_api.g_exc_error;
944: END IF;
945:
946: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
947: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN

Line 950: p_init_msg_list => Fnd_Api.G_FALSE,

946: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
947: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
948: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
949: p_api_version_number => 1.0,
950: p_init_msg_list => Fnd_Api.G_FALSE,
951: p_commit => Fnd_Api.G_FALSE,
952: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
953: p_repair_line_id => x_new_repln_id,
954: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 951: p_commit => Fnd_Api.G_FALSE,

947: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
948: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
949: p_api_version_number => 1.0,
950: p_init_msg_list => Fnd_Api.G_FALSE,
951: p_commit => Fnd_Api.G_FALSE,
952: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
953: p_repair_line_id => x_new_repln_id,
954: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
955: x_return_status => l_return_status,

Line 952: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

948: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
949: p_api_version_number => 1.0,
950: p_init_msg_list => Fnd_Api.G_FALSE,
951: p_commit => Fnd_Api.G_FALSE,
952: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
953: p_repair_line_id => x_new_repln_id,
954: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
955: x_return_status => l_return_status,
956: x_msg_count => l_msg_count,

Line 998: IF fnd_api.to_boolean (p_commit)

994:
995: -- Api body ends here
996:
997: -- Standard check of p_commit.
998: IF fnd_api.to_boolean (p_commit)
999: THEN
1000: COMMIT WORK;
1001: END IF;
1002:

Line 1015: WHEN fnd_api.g_exc_error

1011: 'Leaving Process_RO'
1012: );
1013: END IF;
1014: EXCEPTION
1015: WHEN fnd_api.g_exc_error
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: ROLLBACK TO sp_process_ro;
1019: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1017: x_return_status := fnd_api.g_ret_sts_error;

1013: END IF;
1014: EXCEPTION
1015: WHEN fnd_api.g_exc_error
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: ROLLBACK TO sp_process_ro;
1019: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );

Line 1030: WHEN fnd_api.g_exc_unexpected_error

1026: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1027: 'EXC_ERROR[' || x_msg_data || ']'
1028: );
1029: END IF;
1030: WHEN fnd_api.g_exc_unexpected_error
1031: THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033: ROLLBACK TO sp_process_ro;
1034: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1032: x_return_status := fnd_api.g_ret_sts_unexp_error;

1028: );
1029: END IF;
1030: WHEN fnd_api.g_exc_unexpected_error
1031: THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033: ROLLBACK TO sp_process_ro;
1034: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );

Line 1047: x_return_status := fnd_api.g_ret_sts_unexp_error;

1043: );
1044: END IF;
1045: WHEN OTHERS
1046: THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048: ROLLBACK TO sp_process_ro;
1049:
1050: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1051: THEN

Line 1237: l_return_status := fnd_api.g_ret_sts_success;

1233: END IF;
1234:
1235: SAVEPOINT sp_create_product_txn;
1236:
1237: l_return_status := fnd_api.g_ret_sts_success;
1238:
1239: IF fnd_api.to_boolean (p_init_msg_list)
1240: THEN
1241: -- initialize message list

Line 1239: IF fnd_api.to_boolean (p_init_msg_list)

1235: SAVEPOINT sp_create_product_txn;
1236:
1237: l_return_status := fnd_api.g_ret_sts_success;
1238:
1239: IF fnd_api.to_boolean (p_init_msg_list)
1240: THEN
1241: -- initialize message list
1242: fnd_msg_pub.initialize;
1243: END IF;

Line 1246: IF NOT fnd_api.compatible_api_call (l_api_version_number,

1242: fnd_msg_pub.initialize;
1243: END IF;
1244:
1245: -- Standard call to check for call compatibility.
1246: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1247: p_api_version,
1248: l_api_name,
1249: g_pkg_name
1250: )

Line 1252: RAISE fnd_api.g_exc_unexpected_error;

1248: l_api_name,
1249: g_pkg_name
1250: )
1251: THEN
1252: RAISE fnd_api.g_exc_unexpected_error;
1253: END IF;
1254:
1255: --Validate input
1256: --Check mandatory parameters Repair_line_id, Action_Code, Action_type, Txn_Billing_Type_Id, Inventory_Item_Id, UOM, Quantity

Line 1294: RAISE fnd_api.g_exc_error;

1290: fnd_msg_pub.ADD;
1291:
1292: CLOSE cur_ro_details;
1293:
1294: RAISE fnd_api.g_exc_error;
1295: END IF;
1296:
1297: CLOSE cur_ro_details;
1298:

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

1318: END IF;
1319:
1320: IF l_bus_process_id < 0
1321: THEN
1322: IF NVL (p_product_txn_rec.business_process_id, fnd_api.g_miss_num) <>
1323: fnd_api.g_miss_num
1324: THEN
1325: l_bus_process_id := p_product_txn_rec.business_process_id;
1326: ELSE

Line 1323: fnd_api.g_miss_num

1319:
1320: IF l_bus_process_id < 0
1321: THEN
1322: IF NVL (p_product_txn_rec.business_process_id, fnd_api.g_miss_num) <>
1323: fnd_api.g_miss_num
1324: THEN
1325: l_bus_process_id := p_product_txn_rec.business_process_id;
1326: ELSE
1327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1336: RAISE fnd_api.g_exc_error;

1332: 'Business process Id does not exist '
1333: );
1334: END IF;
1335:
1336: RAISE fnd_api.g_exc_error;
1337: END IF;
1338: END IF;
1339:
1340: ---------------------------------------------------------------------------------

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

1339:
1340: ---------------------------------------------------------------------------------
1341: --Get the transaction type id
1342: IF (p_product_txn_rec.transaction_type_id IS NULL)
1343: OR (p_product_txn_rec.transaction_type_id = fnd_api.g_miss_num)
1344: THEN
1345: OPEN cur_txn_type_id (p_product_txn_rec.txn_billing_type_id);
1346:
1347: FETCH cur_txn_type_id

Line 1364: RAISE fnd_api.g_exc_error;

1360: END IF;
1361:
1362: CLOSE cur_txn_type_id;
1363:
1364: RAISE fnd_api.g_exc_error;
1365: END IF;
1366:
1367: CLOSE cur_txn_type_id;
1368:

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

1390: END IF;
1391:
1392: -- Get the coverage details from the contract
1393: /*** Contract re arch changes for R12
1394: IF NVL (p_product_txn_rec.contract_id, fnd_api.g_miss_num) <>
1395: fnd_api.g_miss_num
1396: THEN
1397: OPEN cur_coverage_details (l_bus_process_id);
1398:

Line 1395: fnd_api.g_miss_num

1391:
1392: -- Get the coverage details from the contract
1393: /*** Contract re arch changes for R12
1394: IF NVL (p_product_txn_rec.contract_id, fnd_api.g_miss_num) <>
1395: fnd_api.g_miss_num
1396: THEN
1397: OPEN cur_coverage_details (l_bus_process_id);
1398:
1399: FETCH cur_coverage_details

Line 1423: RAISE fnd_api.g_exc_error;

1419: END IF;
1420:
1421: CLOSE cur_coverage_details;
1422:
1423: RAISE fnd_api.g_exc_error;
1424: END IF;
1425:
1426: CLOSE cur_coverage_details;
1427:

Line 1451: RAISE fnd_api.g_exc_error;

1447: fnd_msg_pub.ADD;
1448:
1449: CLOSE cur_cust_details;
1450:
1451: RAISE fnd_api.g_exc_error;
1452: END IF;
1453:
1454: CLOSE cur_cust_details;
1455: END IF;

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

1465: x_line_category_code => l_line_category_code,
1466: x_return_status => x_return_status
1467: );
1468:
1469: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1470: THEN
1471: RAISE fnd_api.g_exc_error;
1472: END IF;
1473:

Line 1471: RAISE fnd_api.g_exc_error;

1467: );
1468:
1469: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1470: THEN
1471: RAISE fnd_api.g_exc_error;
1472: END IF;
1473:
1474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1475: THEN

Line 1501: RAISE fnd_api.g_exc_error;

1497: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1498: p_product_txn_rec.txn_billing_type_id
1499: );
1500: fnd_msg_pub.ADD;
1501: RAISE fnd_api.g_exc_error;
1502: END IF;
1503:
1504: ---------------------------------------------------------------------------------7
1505:

Line 1535: RAISE fnd_api.g_exc_error;

1531: || p_product_txn_rec.inventory_item_id
1532: );
1533: END IF;
1534:
1535: RAISE fnd_api.g_exc_error;
1536: END IF;
1537: END IF;
1538:
1539: ---------------------------------------------------------------------------------8

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

1538:
1539: ---------------------------------------------------------------------------------8
1540: --Derive currency_Code from the oe_price_lists_all for the given price_list_id
1541: -- Get the currency code from the price list if it is null or g_miss
1542: IF NVL (p_product_txn_rec.price_list_id, fnd_api.g_miss_num) <>
1543: fnd_api.g_miss_num
1544: THEN
1545: OPEN cur_pricelist_details (p_product_txn_rec.price_list_id);
1546:

Line 1543: fnd_api.g_miss_num

1539: ---------------------------------------------------------------------------------8
1540: --Derive currency_Code from the oe_price_lists_all for the given price_list_id
1541: -- Get the currency code from the price list if it is null or g_miss
1542: IF NVL (p_product_txn_rec.price_list_id, fnd_api.g_miss_num) <>
1543: fnd_api.g_miss_num
1544: THEN
1545: OPEN cur_pricelist_details (p_product_txn_rec.price_list_id);
1546:
1547: FETCH cur_pricelist_details

Line 1560: RAISE fnd_api.g_exc_error;

1556: fnd_msg_pub.ADD;
1557:
1558: CLOSE cur_pricelist_details;
1559:
1560: RAISE fnd_api.g_exc_error;
1561: END IF;
1562:
1563: CLOSE cur_pricelist_details;
1564:

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

1632: p_product_txn_rec.add_to_order_flag := 'Y';
1633: p_product_txn_rec.order_header_id := l_order_header_id;
1634: ELSE
1635: p_product_txn_rec.add_to_order_flag := 'F';
1636: p_product_txn_rec.order_header_id := fnd_api.g_miss_num;
1637: END IF;
1638: END IF; ----------------IF C
1639: /* END IF; */ ----------IF B
1640:

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

1664: x_charges_rec => l_charges_rec,
1665: x_return_status => x_return_status
1666: );
1667:
1668: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1669: THEN
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1671: THEN
1672: fnd_log.STRING (fnd_log.level_statement,

Line 1678: RAISE fnd_api.g_exc_error;

1674: 'sql error[' || SQLERRM || ']'
1675: );
1676: END IF;
1677:
1678: RAISE fnd_api.g_exc_error;
1679: END IF;
1680:
1681: ----------Temp code
1682: l_charges_rec.charge_line_type := 'ACTUAL';

Line 1698: p_commit => fnd_api.g_false,

1694: END IF;
1695:
1696: csd_process_pvt.process_charge_lines
1697: (p_api_version => 1.0,
1698: p_commit => fnd_api.g_false,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_validation_level => fnd_api.g_valid_level_full,
1701: p_action => 'CREATE',
1702: p_charges_rec => l_charges_rec,

Line 1699: p_init_msg_list => fnd_api.g_false,

1695:
1696: csd_process_pvt.process_charge_lines
1697: (p_api_version => 1.0,
1698: p_commit => fnd_api.g_false,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_validation_level => fnd_api.g_valid_level_full,
1701: p_action => 'CREATE',
1702: p_charges_rec => l_charges_rec,
1703: x_estimate_detail_id => l_estimate_detail_id,

Line 1700: p_validation_level => fnd_api.g_valid_level_full,

1696: csd_process_pvt.process_charge_lines
1697: (p_api_version => 1.0,
1698: p_commit => fnd_api.g_false,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_validation_level => fnd_api.g_valid_level_full,
1701: p_action => 'CREATE',
1702: p_charges_rec => l_charges_rec,
1703: x_estimate_detail_id => l_estimate_detail_id,
1704: x_return_status => x_return_status,

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

1705: x_msg_count => x_msg_count,
1706: x_msg_data => x_msg_data
1707: );
1708:
1709: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1710: THEN
1711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1712: THEN
1713: fnd_log.STRING (fnd_log.level_statement,

Line 1719: RAISE fnd_api.g_exc_error;

1715: 'Error[' || SUBSTR (x_msg_data, 1, 200) || ']'
1716: );
1717: END IF;
1718:
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1723: THEN

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

1793: p_project_id => p_product_txn_rec.project_id,
1794: p_task_id => p_product_txn_rec.task_id,
1795: p_unit_number => p_product_txn_rec.unit_number);
1796:
1797: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1798: THEN
1799: RAISE fnd_api.g_exc_error;
1800: END IF;
1801:

Line 1799: RAISE fnd_api.g_exc_error;

1795: p_unit_number => p_product_txn_rec.unit_number);
1796:
1797: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1798: THEN
1799: RAISE fnd_api.g_exc_error;
1800: END IF;
1801:
1802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1803: THEN

Line 1834: p_commit => fnd_api.g_false,

1830: END IF;
1831:
1832: csd_process_pvt.apply_contract
1833: (p_api_version => 1.0,
1834: p_commit => fnd_api.g_false,
1835: p_init_msg_list => fnd_api.g_false,
1836: p_validation_level => fnd_api.g_valid_level_full,
1837: p_incident_id => l_incident_id,
1838: x_return_status => x_return_status,

Line 1835: p_init_msg_list => fnd_api.g_false,

1831:
1832: csd_process_pvt.apply_contract
1833: (p_api_version => 1.0,
1834: p_commit => fnd_api.g_false,
1835: p_init_msg_list => fnd_api.g_false,
1836: p_validation_level => fnd_api.g_valid_level_full,
1837: p_incident_id => l_incident_id,
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,

Line 1836: p_validation_level => fnd_api.g_valid_level_full,

1832: csd_process_pvt.apply_contract
1833: (p_api_version => 1.0,
1834: p_commit => fnd_api.g_false,
1835: p_init_msg_list => fnd_api.g_false,
1836: p_validation_level => fnd_api.g_valid_level_full,
1837: p_incident_id => l_incident_id,
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,
1840: x_msg_data => x_msg_data

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

1839: x_msg_count => x_msg_count,
1840: x_msg_data => x_msg_data
1841: );
1842:
1843: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1844: THEN
1845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1846: THEN
1847: fnd_log.STRING

Line 1856: RAISE fnd_api.g_exc_error;

1852: || ']'
1853: );
1854: END IF;
1855:
1856: RAISE fnd_api.g_exc_error;
1857: END IF;
1858:
1859: -- THis api will interface and book the charge line
1860: ------------------------------------------------------------------------------------

Line 1898: p_commit => fnd_api.g_false,

1894: l_order_rec.org_id := p_product_txn_rec.organization_id ;
1895:
1896: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1897: ( p_api_version => 1.0 ,
1898: p_commit => fnd_api.g_false,
1899: p_init_msg_list => fnd_api.g_false,
1900: p_validation_level => fnd_api.g_valid_level_full,
1901: p_action => 'CREATE',
1902: p_order_rec => l_order_rec,

Line 1899: p_init_msg_list => fnd_api.g_false,

1895:
1896: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1897: ( p_api_version => 1.0 ,
1898: p_commit => fnd_api.g_false,
1899: p_init_msg_list => fnd_api.g_false,
1900: p_validation_level => fnd_api.g_valid_level_full,
1901: p_action => 'CREATE',
1902: p_order_rec => l_order_rec,
1903: x_return_status => x_return_status,

Line 1900: p_validation_level => fnd_api.g_valid_level_full,

1896: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1897: ( p_api_version => 1.0 ,
1898: p_commit => fnd_api.g_false,
1899: p_init_msg_list => fnd_api.g_false,
1900: p_validation_level => fnd_api.g_valid_level_full,
1901: p_action => 'CREATE',
1902: p_order_rec => l_order_rec,
1903: x_return_status => x_return_status,
1904: x_msg_count => x_msg_count,

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

1903: x_return_status => x_return_status,
1904: x_msg_count => x_msg_count,
1905: x_msg_data => x_msg_data );
1906:
1907: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1909: THEN
1910: fnd_log.STRING (fnd_log.level_statement,
1911: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1914: RAISE FND_API.G_EXC_ERROR;

1910: fnd_log.STRING (fnd_log.level_statement,
1911: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1912: 'process_sales_order failed['||x_msg_data||']');
1913: END IF;
1914: RAISE FND_API.G_EXC_ERROR;
1915: END IF;
1916:
1917: Validate_order(p_est_detail_id => l_estimate_detail_id,
1918: p_order_rec => l_order_rec,

Line 1933: p_commit => fnd_api.g_false,

1929:
1930: IF(l_booked_flag <> 'Y') THEN
1931: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1932: ( p_api_version => 1.0 ,
1933: p_commit => fnd_api.g_false,
1934: p_init_msg_list => fnd_api.g_false,
1935: p_validation_level => fnd_api.g_valid_level_full,
1936: p_action => 'BOOK',
1937: p_order_rec => l_order_rec,

Line 1934: p_init_msg_list => fnd_api.g_false,

1930: IF(l_booked_flag <> 'Y') THEN
1931: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1932: ( p_api_version => 1.0 ,
1933: p_commit => fnd_api.g_false,
1934: p_init_msg_list => fnd_api.g_false,
1935: p_validation_level => fnd_api.g_valid_level_full,
1936: p_action => 'BOOK',
1937: p_order_rec => l_order_rec,
1938: x_return_status => x_return_status,

Line 1935: p_validation_level => fnd_api.g_valid_level_full,

1931: CSD_PROCESS_PVT.PROCESS_SALES_ORDER
1932: ( p_api_version => 1.0 ,
1933: p_commit => fnd_api.g_false,
1934: p_init_msg_list => fnd_api.g_false,
1935: p_validation_level => fnd_api.g_valid_level_full,
1936: p_action => 'BOOK',
1937: p_order_rec => l_order_rec,
1938: x_return_status => x_return_status,
1939: x_msg_count => x_msg_count,

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

1938: x_return_status => x_return_status,
1939: x_msg_count => x_msg_count,
1940: x_msg_data => x_msg_data );
1941:
1942: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1943: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1944: THEN
1945: fnd_log.STRING (fnd_log.level_statement,
1946: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1949: RAISE FND_API.G_EXC_ERROR;

1945: fnd_log.STRING (fnd_log.level_statement,
1946: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1947: 'process_sales_order failed ['||x_msg_Data||']');
1948: END IF;
1949: RAISE FND_API.G_EXC_ERROR;
1950: END IF;
1951: END IF;
1952: /****************
1953: cs_charge_create_order_pub.submit_order

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

1965: );
1966: *************/
1967:
1968: --] 3308535
1969: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1970: THEN
1971: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1972: THEN
1973: fnd_log.STRING

Line 1982: RAISE fnd_api.g_exc_error;

1978: || ']'
1979: );
1980: END IF;
1981:
1982: RAISE fnd_api.g_exc_error;
1983: END IF;
1984: ELSE
1985: l_ro_txn_status := 'CHARGE_ENTERED';
1986: l_prod_txn_status := 'ENTERED';

Line 2008: RAISE fnd_api.g_exc_error;

2004: fnd_message.set_token ('REPAIR_LINE_ID',
2005: p_product_txn_rec.repair_line_id
2006: );
2007: fnd_msg_pub.ADD;
2008: RAISE fnd_api.g_exc_error;
2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2012: THEN

Line 2031: RAISE fnd_api.g_exc_error;

2027: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2028: p_product_txn_rec.product_transaction_id
2029: );
2030: fnd_msg_pub.ADD;
2031: RAISE fnd_api.g_exc_error;
2032: END IF;
2033:
2034: ----------------------------------------------------------------------------
2035:

Line 2039: IF fnd_api.to_boolean (p_commit)

2035:
2036: -- Api body ends here
2037:
2038: -- Standard check of p_commit.
2039: IF fnd_api.to_boolean (p_commit)
2040: THEN
2041: COMMIT WORK;
2042: END IF;
2043:

Line 2056: WHEN fnd_api.g_exc_error

2052: 'Leaving CREATE_PRODUCT_TXN'
2053: );
2054: END IF;
2055: EXCEPTION
2056: WHEN fnd_api.g_exc_error
2057: THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059: log_error_stack ();
2060: ROLLBACK TO sp_create_product_txn;

Line 2058: x_return_status := fnd_api.g_ret_sts_error;

2054: END IF;
2055: EXCEPTION
2056: WHEN fnd_api.g_exc_error
2057: THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059: log_error_stack ();
2060: ROLLBACK TO sp_create_product_txn;
2061: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2062: p_data => x_msg_data

Line 2072: WHEN fnd_api.g_exc_unexpected_error

2068: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2069: 'EXC_ERROR[' || x_msg_data || ']'
2070: );
2071: END IF;
2072: WHEN fnd_api.g_exc_unexpected_error
2073: THEN
2074: x_return_status := fnd_api.g_ret_sts_unexp_error;
2075: ROLLBACK TO sp_create_product_txn;
2076: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2074: x_return_status := fnd_api.g_ret_sts_unexp_error;

2070: );
2071: END IF;
2072: WHEN fnd_api.g_exc_unexpected_error
2073: THEN
2074: x_return_status := fnd_api.g_ret_sts_unexp_error;
2075: ROLLBACK TO sp_create_product_txn;
2076: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2077: p_data => x_msg_data
2078: );

Line 2089: x_return_status := fnd_api.g_ret_sts_unexp_error;

2085: );
2086: END IF;
2087: WHEN OTHERS
2088: THEN
2089: x_return_status := fnd_api.g_ret_sts_unexp_error;
2090: ROLLBACK TO sp_create_product_txn;
2091:
2092: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2093: THEN

Line 2164: IF NOT fnd_api.compatible_api_call (l_api_version,

2160: -- Standard Start of API savepoint
2161: SAVEPOINT create_item_instance;
2162:
2163: -- Standard call to check for call compatibility.
2164: IF NOT fnd_api.compatible_api_call (l_api_version,
2165: p_api_version,
2166: -- l_api_name ,
2167: g_pkg_name,
2168: g_file_name

Line 2171: RAISE fnd_api.g_exc_unexpected_error;

2167: g_pkg_name,
2168: g_file_name
2169: )
2170: THEN
2171: RAISE fnd_api.g_exc_unexpected_error;
2172: END IF;
2173:
2174: -- Initialize message list if p_init_msg_list is set to TRUE.
2175: IF fnd_api.to_boolean (p_init_msg_list)

Line 2175: IF fnd_api.to_boolean (p_init_msg_list)

2171: RAISE fnd_api.g_exc_unexpected_error;
2172: END IF;
2173:
2174: -- Initialize message list if p_init_msg_list is set to TRUE.
2175: IF fnd_api.to_boolean (p_init_msg_list)
2176: THEN
2177: fnd_msg_pub.initialize;
2178: END IF;
2179:

Line 2181: x_return_status := fnd_api.g_ret_sts_success;

2177: fnd_msg_pub.initialize;
2178: END IF;
2179:
2180: -- Initialize API return status to success
2181: x_return_status := fnd_api.g_ret_sts_success;
2182:
2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2184: THEN
2185: fnd_log.STRING (fnd_log.level_statement,

Line 2207: RAISE fnd_api.g_exc_error;

2203: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2204: px_instance_rec.party_site_use_id
2205: );
2206: --px_instance_rec.bill_to_site_use_id);
2207: RAISE fnd_api.g_exc_error;
2208: END;
2209:
2210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2211: THEN

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

2308: x_msg_data => l_msg_data
2309: );
2310:
2311: log_error_stack();
2312: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2313: THEN
2314: RAISE fnd_api.g_exc_error;
2315: END IF;
2316:

Line 2314: RAISE fnd_api.g_exc_error;

2310:
2311: log_error_stack();
2312: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2313: THEN
2314: RAISE fnd_api.g_exc_error;
2315: END IF;
2316:
2317: x_instance_id := l_instance_rec.instance_id;
2318: px_instance_rec.instance_id := l_instance_rec.instance_id;

Line 2322: IF fnd_api.to_boolean (p_commit)

2318: px_instance_rec.instance_id := l_instance_rec.instance_id;
2319: px_instance_rec.instance_number := l_instance_rec.instance_number;
2320:
2321: -- Standard check of p_commit.
2322: IF fnd_api.to_boolean (p_commit)
2323: THEN
2324: COMMIT WORK;
2325: END IF;
2326:

Line 2340: WHEN fnd_api.g_exc_error

2336: 'Leaving CREATE_ITEM_INSTANCE'
2337: );
2338: END IF;
2339: EXCEPTION
2340: WHEN fnd_api.g_exc_error
2341: THEN
2342: ROLLBACK TO create_item_instance;
2343: x_return_status := fnd_api.g_ret_sts_error;
2344: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2343: x_return_status := fnd_api.g_ret_sts_error;

2339: EXCEPTION
2340: WHEN fnd_api.g_exc_error
2341: THEN
2342: ROLLBACK TO create_item_instance;
2343: x_return_status := fnd_api.g_ret_sts_error;
2344: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );
2347:

Line 2356: WHEN fnd_api.g_exc_unexpected_error

2352: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2353: 'EXC_ERROR[' || x_msg_data || ']'
2354: );
2355: END IF;
2356: WHEN fnd_api.g_exc_unexpected_error
2357: THEN
2358: ROLLBACK TO create_item_instance;
2359: x_return_status := fnd_api.g_ret_sts_unexp_error;
2360: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2359: x_return_status := fnd_api.g_ret_sts_unexp_error;

2355: END IF;
2356: WHEN fnd_api.g_exc_unexpected_error
2357: THEN
2358: ROLLBACK TO create_item_instance;
2359: x_return_status := fnd_api.g_ret_sts_unexp_error;
2360: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2361: p_data => x_msg_data
2362: );
2363:

Line 2375: x_return_status := fnd_api.g_ret_sts_unexp_error;

2371: END IF;
2372: WHEN OTHERS
2373: THEN
2374: ROLLBACK TO create_item_instance;
2375: x_return_status := fnd_api.g_ret_sts_unexp_error;
2376:
2377: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2378: THEN
2379: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);

Line 2425: l_return_status := fnd_api.g_ret_sts_success;

2421: 'Checking mandatory parameters'
2422: );
2423: END IF;
2424:
2425: l_return_status := fnd_api.g_ret_sts_success;
2426:
2427: csd_process_util.check_reqd_param
2428: (p_param_value => p_product_txn_rec.repair_line_id,
2429: p_param_name => 'REPAIR_LINE_ID',

Line 2489: RAISE fnd_api.g_exc_error;

2485: IF NOT (csd_process_util.validate_rep_line_id
2486: (p_repair_line_id => p_product_txn_rec.repair_line_id)
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_type
2503: (p_action_type => p_product_txn_rec.action_type)
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 2523: RAISE fnd_api.g_exc_error;

2519: IF NOT (csd_process_util.validate_action_code
2520: (p_action_code => p_product_txn_rec.action_code)
2521: )
2522: THEN
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2527: THEN

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

2547: p_prod_txn_qty => p_product_txn_rec.quantity,
2548: x_return_status => l_return_status
2549: );
2550:
2551: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2552: THEN
2553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2554: THEN
2555: fnd_log.STRING

Line 2562: RAISE fnd_api.g_exc_error;

2558: 'Validate_Quantity failed '
2559: );
2560: END IF;
2561:
2562: RAISE fnd_api.g_exc_error;
2563: END IF;
2564: END IF;
2565:
2566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

2579: END IF;
2580:
2581: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2582: IF (p_product_txn_rec.prod_txn_status IS NOT NULL)
2583: AND (p_product_txn_rec.prod_txn_status <> fnd_api.g_miss_char)
2584: THEN
2585: BEGIN
2586: SELECT 'X'
2587: INTO l_check

Line 2596: RAISE fnd_api.g_exc_error;

2592: WHEN OTHERS
2593: THEN
2594: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2595: fnd_msg_pub.ADD;
2596: RAISE fnd_api.g_exc_error;
2597: END;
2598: END IF;
2599:
2600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 2653: RAISE fnd_api.g_exc_error;

2649: THEN
2650: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2651: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_error;
2654: END is_item_pre_serialized;
2655:
2656: ------------------------------------------------------------------------------
2657: -------------------------------------------------------------------------------

Line 2681: RAISE fnd_api.g_exc_error;

2677: THEN
2678: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2679: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2680: fnd_msg_pub.ADD;
2681: RAISE fnd_api.g_exc_error;
2682: END is_item_ib_trackable;
2683:
2684: ----------------------------------------------------------------------
2685: -- Funciton to validate the order

Line 2765: RAISE fnd_api.g_exc_error;

2761: END IF;
2762:
2763: CLOSE cur_ord_details;
2764:
2765: RAISE fnd_api.g_exc_error;
2766: END IF;
2767:
2768: IF cur_ord_details%ROWCOUNT > 1
2769: THEN

Line 2803: RAISE fnd_api.g_exc_error;

2799: END IF;
2800:
2801: CLOSE cur_ord_line;
2802:
2803: RAISE fnd_api.g_exc_error;
2804: END IF;
2805:
2806: IF cur_ord_line%ROWCOUNT > 1
2807: THEN

Line 2834: RAISE fnd_api.g_exc_error;

2830: || l_order_line_id
2831: );
2832: END IF;
2833:
2834: RAISE fnd_api.g_exc_error;
2835: END IF;
2836:
2837: IF l_unit_selling_price IS NULL
2838: THEN

Line 2852: RAISE fnd_api.g_exc_error;

2848: || l_order_line_id
2849: );
2850: END IF;
2851:
2852: RAISE fnd_api.g_exc_error;
2853: END IF;
2854:
2855: OPEN cur_ord_hdr (p_order_rec.order_header_id);
2856:

Line 2870: RAISE fnd_api.g_exc_error;

2866: fnd_msg_pub.ADD;
2867:
2868: CLOSE cur_ord_hdr;
2869:
2870: RAISE fnd_api.g_exc_error;
2871: END IF;
2872:
2873: CLOSE cur_ord_hdr;
2874:

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

2924: -- like non_source_serial_number non_source_instance_id etc
2925: -- Shipping customer product txn line
2926: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ; -- 11.5.10
2927: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id; -- 11.5.10
2928: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2929: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2930: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2931: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2932: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;

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

2925: -- Shipping customer product txn line
2926: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ; -- 11.5.10
2927: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id; -- 11.5.10
2928: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2929: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2930: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2931: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2932: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

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

2929: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2930: ELSIF p_repair_type_ref in ('RR','WR','E' ) THEN
2931: x_prod_txn_tbl(1).source_serial_number := p_serial_number ;
2932: x_prod_txn_tbl(1).source_instance_id := p_instance_id ;
2933: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2934: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2935: IF p_repair_type_ref = 'E' THEN
2936: x_prod_txn_tbl(2).non_source_instance_id := p_instance_id;
2937: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;

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

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

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

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

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

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

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

2937: x_prod_txn_tbl(2).non_source_serial_number := p_serial_number;
2938: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2939: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2940: ELSE
2941: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2942: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2943: x_prod_txn_tbl(2).source_instance_id := p_instance_id;
2944: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2945: END IF;

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

2938: x_prod_txn_tbl(2).source_instance_id := FND_API.G_MISS_NUM;
2939: x_prod_txn_tbl(2).source_serial_number := FND_API.G_MISS_CHAR;
2940: ELSE
2941: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2942: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2943: x_prod_txn_tbl(2).source_instance_id := p_instance_id;
2944: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2945: END IF;
2946:

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

2945: END IF;
2946:
2947:
2948: ELSIF (p_repair_type_ref = 'AL') THEN
2949: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2950: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2951: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2952: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2953: x_prod_txn_tbl(2).source_serial_number := p_serial_number;

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

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

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

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

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

2948: ELSIF (p_repair_type_ref = 'AL') THEN
2949: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2950: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2951: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2952: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2953: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2954: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2955: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2956: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;

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

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

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

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

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

2956: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2957:
2958: ELSIF ( p_repair_type_ref = 'AE' ) THEN
2959:
2960: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2961: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2962: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2963: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2964: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;

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

2958: ELSIF ( p_repair_type_ref = 'AE' ) THEN
2959:
2960: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2961: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2962: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2963: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2964: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2965: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2966: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;

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

2961: x_prod_txn_tbl(1).non_source_serial_number := p_serial_number ;
2962: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2963: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2964: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2965: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2966: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2967: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2968: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2969:

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

2963: x_prod_txn_tbl(1).non_source_instance_id := p_instance_id ;
2964: x_prod_txn_tbl(2).source_serial_number := p_serial_number ;
2965: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2966: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2967: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2968: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2969:
2970: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2971: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;

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

2966: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2967: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2968: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2969:
2970: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2971: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2972: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2973: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2974:

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

2967: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2968: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2969:
2970: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2971: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2972: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2973: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2974:
2975: x_prod_txn_tbl(2).source_serial_number := p_serial_number;

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

2968: ELSIF p_repair_type_ref in ('ARR','WRL') THEN
2969:
2970: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2971: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2972: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2973: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2974:
2975: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2976: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;

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

2969:
2970: x_prod_txn_tbl(1).source_serial_number := FND_API.G_MISS_CHAR;
2971: x_prod_txn_tbl(1).non_source_serial_number := FND_API.G_MISS_CHAR;
2972: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2973: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2974:
2975: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2976: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2977: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;

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

2972: x_prod_txn_tbl(1).source_instance_id := FND_API.G_MISS_NUM;
2973: x_prod_txn_tbl(1).non_source_instance_id := FND_API.G_MISS_NUM;
2974:
2975: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2976: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2977: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2978: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2979: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2980: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;

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

2974:
2975: x_prod_txn_tbl(2).source_serial_number := p_serial_number;
2976: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2977: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2978: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2979: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2980: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2981: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2982: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;

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

2976: x_prod_txn_tbl(2).non_source_serial_number := FND_API.G_MISS_CHAR;
2977: x_prod_txn_tbl(2).source_instance_id := p_instance_id ;
2978: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2979: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2980: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2981: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2982: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2983: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2984: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;

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

2978: x_prod_txn_tbl(2).non_source_instance_id := FND_API.G_MISS_NUM;
2979: x_prod_txn_tbl(3).source_serial_number := p_serial_number ;
2980: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2981: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2982: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2983: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2984: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2985: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2986: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;

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

2980: x_prod_txn_tbl(3).non_source_serial_number := FND_API.G_MISS_CHAR;
2981: x_prod_txn_tbl(3).source_instance_id := p_instance_id ;
2982: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2983: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2984: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2985: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2986: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;
2987:
2988: END IF;

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

2982: x_prod_txn_tbl(3).non_source_instance_id := FND_API.G_MISS_NUM;
2983: x_prod_txn_tbl(4).source_serial_number := p_serial_number;
2984: x_prod_txn_tbl(4).non_source_serial_number := FND_API.G_MISS_CHAR;
2985: x_prod_txn_tbl(4).source_instance_id := p_instance_id ;
2986: x_prod_txn_tbl(4).non_source_instance_id := FND_API.G_MISS_NUM;
2987:
2988: END IF;
2989:
2990: END upd_instance;