[Home] [Help]
28: IS
29: BEGIN
30:
31:
32: x_return_status := fnd_api.g_ret_sts_success;
33:
34: csi_t_gen_utility_pvt.dump_api_info(
35: p_api_name => 'get_rma_info',
36: p_pkg_name => 'csi_rma_fulfill_pub');
56: WHEN no_data_found THEN
57: fnd_message.set_name('CSI', 'CSI_INT_OE_LINE_ID_INVALID');
58: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);
59: fnd_msg_pub.add;
60: RAISE fnd_api.g_exc_error;
61: END;
62:
63: EXCEPTION
64:
61: END;
62:
63: EXCEPTION
64:
65: WHEN fnd_api.g_exc_error THEN
66: x_error_message := fnd_msg_pub.get;
67: x_return_status := fnd_api.g_ret_sts_error;
68:
69: WHEN others THEN
63: EXCEPTION
64:
65: WHEN fnd_api.g_exc_error THEN
66: x_error_message := fnd_msg_pub.get;
67: x_return_status := fnd_api.g_ret_sts_error;
68:
69: WHEN others THEN
70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
71: fnd_message.set_token('MESSAGE', substr(sqlerrm, 240));
71: fnd_message.set_token('MESSAGE', substr(sqlerrm, 240));
72: fnd_msg_pub.add;
73:
74: x_error_message := fnd_msg_pub.get;
75: x_return_status := fnd_api.g_ret_sts_unexp_error;
76:
77: END get_rma_info;
78:
79:
86: x_error_message OUT NOCOPY varchar2,
87: x_rma_line_rec OUT NOCOPY csi_order_ship_pub.mtl_txn_rec)
88: IS
89:
90: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
91: l_api_name varchar2(100) := 'decode_message';
92: l_rma_line_id number;
93:
94: BEGIN
92: l_rma_line_id number;
93:
94: BEGIN
95:
96: x_return_status := fnd_api.g_ret_sts_success;
97:
98: csi_t_gen_utility_pvt.dump_api_info(
99: p_api_name => l_api_name,
100: p_pkg_name => 'csi_rma_fulfill_pub');
100: p_pkg_name => 'csi_rma_fulfill_pub');
101:
102: xnp_xml_utils.decode(p_msg_text, 'RMA_LINE_ID', l_rma_line_id);
103:
104: IF nvl(l_rma_line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
105: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
106: fnd_message.set_token('MESSAGE_id', p_msg_header.message_id);
107: fnd_message.set_token('MESSAGE_CODE', p_msg_header.message_code);
108: fnd_msg_pub.add;
105: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
106: fnd_message.set_token('MESSAGE_id', p_msg_header.message_id);
107: fnd_message.set_token('MESSAGE_CODE', p_msg_header.message_code);
108: fnd_msg_pub.add;
109: RAISE fnd_api.g_exc_error;
110: END IF;
111:
112: get_rma_info(
113: p_rma_line_id => l_rma_line_id,
114: x_rma_line_rec => x_rma_line_rec,
115: x_error_message => x_error_message,
116: x_return_status => l_return_status);
117:
118: IF l_return_status <> fnd_api.g_ret_sts_success THEN
119: debug('CSI_Rma_Fulfill_Pub.Get_rma_Info Failed.');
120: RAISE fnd_api.g_exc_error;
121: END IF;
122:
116: x_return_status => l_return_status);
117:
118: IF l_return_status <> fnd_api.g_ret_sts_success THEN
119: debug('CSI_Rma_Fulfill_Pub.Get_rma_Info Failed.');
120: RAISE fnd_api.g_exc_error;
121: END IF;
122:
123: debug('CSI_Rma_Fulfill_Pub.Decode_Message Successful');
124:
123: debug('CSI_Rma_Fulfill_Pub.Decode_Message Successful');
124:
125: EXCEPTION
126:
127: WHEN fnd_api.g_exc_error THEN
128:
129: x_error_message := fnd_msg_pub.get;
130: x_return_status := fnd_api.g_ret_sts_error;
131:
126:
127: WHEN fnd_api.g_exc_error THEN
128:
129: x_error_message := fnd_msg_pub.get;
130: x_return_status := fnd_api.g_ret_sts_error;
131:
132: debug(x_error_message);
133:
134: WHEN others THEN
138: fnd_message.set_token('SQL_ERROR', substr(sqlerrm, 1, 255));
139: fnd_msg_pub.add;
140:
141: x_error_message := fnd_msg_pub.get;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143:
144: debug(x_error_message);
145:
146: END decode_message;
186: l_shippable_item_flag varchar2(1) := 'N';
187:
188: l_debug_level number;
189: l_error_message varchar2(2000);
190: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
191: l_msg_data varchar2(32767);
192: l_msg_dummy varchar2(32767);
193: l_msg_count number;
194: do_not_process exception;
201: BEGIN
202:
203: savepoint rma_fulfillment;
204:
205: x_return_status := fnd_api.g_ret_sts_success;
206: l_error_rec := px_trx_error_rec;
207:
208: fnd_msg_pub.initialize;
209:
251: debug('Invalid RMA Order Line ID');
252: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
253: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);
254: fnd_msg_pub.add;
255: RAISE fnd_api.g_exc_error;
256: END;
257:
258: l_error_rec.source_line_ref_id := l_rma_line_rec.line_id;
259: l_error_rec.source_line_ref := l_rma_line_rec.line_number||'.'||
272: debug('Invalid Order line details - org_id: '||l_rma_line_rec.org_id);
273: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
274: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);
275: fnd_msg_pub.add;
276: RAISE fnd_api.g_exc_error;
277: End;
278: ELSE
279: l_orgn_id := l_rma_line_rec.sold_from_org_id;
280: END IF;
309: debug('Invalid Organization ID - l_orgn_id: '||l_orgn_id);
310: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
311: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);
312: fnd_msg_pub.add;
313: RAISE fnd_api.g_exc_error;
314: END IF;
315:
316: l_error_rec.inventory_item_id := l_rma_line_rec.inventory_item_id;
317:
334: debug('Could not determine if the line item is shippable or not for the RMA Fulfillment Line.');
335: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
336: fnd_message.set_token('MESSAGE','Could not determine if the line item is shippable or not for the RMA Fulfillment Line.');
337: fnd_msg_pub.add;
338: raise fnd_api.g_exc_error;
339: ELSIF l_shippable_item_flag = 'Y' THEN
340: IF (WF_ENGINE.ACTIVITY_EXIST_IN_PROCESS(
341: 'OEOL' -- ITEM_TYPE
342: ,to_char(l_rma_line_rec.line_id) -- ITEM_KEY
365: debug('Transaction detail is Mandatory for RMA Fulfillment and was NOT found for the line.');
366: fnd_message.set_name('CSI', 'CSI_RMA_TXN_DTLS_REQD');
367: fnd_message.set_token('SRC_TXN_ID', p_rma_line_id);
368: fnd_msg_pub.add;
369: raise fnd_api.g_exc_error;
370: -- call the get api
371: ELSE
372: debug('Transaction Detail Found for the RMA line.');
373: BEGIN
382: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
383: fnd_message.set_token('SRC_TBL', l_src_txn_table);
384: fnd_message.set_token('SRC_ID', p_rma_line_id);
385: fnd_msg_pub.add;
386: RAISE fnd_api.g_exc_error;
387: END IF;
388:
389: UPDATE csi_t_transaction_lines
390: SET processing_status = 'IN_PROCESS'
400: l_g_txn_line_detail_query_rec.source_transaction_flag := 'Y';
401:
402: csi_t_txn_details_grp.get_transaction_details(
403: p_api_version => 1,
404: p_commit => fnd_api.g_false,
405: p_init_msg_list => fnd_api.g_true,
406: p_validation_level => fnd_api.g_valid_level_full,
407: p_txn_line_query_rec => l_g_txn_line_query_rec,
408: p_txn_line_detail_query_rec => l_g_txn_line_detail_query_rec,
401:
402: csi_t_txn_details_grp.get_transaction_details(
403: p_api_version => 1,
404: p_commit => fnd_api.g_false,
405: p_init_msg_list => fnd_api.g_true,
406: p_validation_level => fnd_api.g_valid_level_full,
407: p_txn_line_query_rec => l_g_txn_line_query_rec,
408: p_txn_line_detail_query_rec => l_g_txn_line_detail_query_rec,
409: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
402: csi_t_txn_details_grp.get_transaction_details(
403: p_api_version => 1,
404: p_commit => fnd_api.g_false,
405: p_init_msg_list => fnd_api.g_true,
406: p_validation_level => fnd_api.g_valid_level_full,
407: p_txn_line_query_rec => l_g_txn_line_query_rec,
408: p_txn_line_detail_query_rec => l_g_txn_line_detail_query_rec,
409: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
410: p_get_parties_flag => fnd_api.g_false,
406: p_validation_level => fnd_api.g_valid_level_full,
407: p_txn_line_query_rec => l_g_txn_line_query_rec,
408: p_txn_line_detail_query_rec => l_g_txn_line_detail_query_rec,
409: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
410: p_get_parties_flag => fnd_api.g_false,
411: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
412: p_get_pty_accts_flag => fnd_api.g_false,
413: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
414: p_get_ii_rltns_flag => fnd_api.g_false,
408: p_txn_line_detail_query_rec => l_g_txn_line_detail_query_rec,
409: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
410: p_get_parties_flag => fnd_api.g_false,
411: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
412: p_get_pty_accts_flag => fnd_api.g_false,
413: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
414: p_get_ii_rltns_flag => fnd_api.g_false,
415: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
416: p_get_org_assgns_flag => fnd_api.g_false,
410: p_get_parties_flag => fnd_api.g_false,
411: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
412: p_get_pty_accts_flag => fnd_api.g_false,
413: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
414: p_get_ii_rltns_flag => fnd_api.g_false,
415: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
416: p_get_org_assgns_flag => fnd_api.g_false,
417: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
418: p_get_ext_attrib_vals_flag => fnd_api.g_false,
412: p_get_pty_accts_flag => fnd_api.g_false,
413: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
414: p_get_ii_rltns_flag => fnd_api.g_false,
415: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
416: p_get_org_assgns_flag => fnd_api.g_false,
417: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
418: p_get_ext_attrib_vals_flag => fnd_api.g_false,
419: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
420: p_get_csi_attribs_flag => fnd_api.g_false,
414: p_get_ii_rltns_flag => fnd_api.g_false,
415: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
416: p_get_org_assgns_flag => fnd_api.g_false,
417: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
418: p_get_ext_attrib_vals_flag => fnd_api.g_false,
419: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
420: p_get_csi_attribs_flag => fnd_api.g_false,
421: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
422: p_get_csi_iea_values_flag => fnd_api.g_false,
416: p_get_org_assgns_flag => fnd_api.g_false,
417: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
418: p_get_ext_attrib_vals_flag => fnd_api.g_false,
419: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
420: p_get_csi_attribs_flag => fnd_api.g_false,
421: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
422: p_get_csi_iea_values_flag => fnd_api.g_false,
423: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
424: p_get_txn_systems_flag => fnd_api.g_false,
418: p_get_ext_attrib_vals_flag => fnd_api.g_false,
419: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
420: p_get_csi_attribs_flag => fnd_api.g_false,
421: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
422: p_get_csi_iea_values_flag => fnd_api.g_false,
423: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
424: p_get_txn_systems_flag => fnd_api.g_false,
425: x_txn_systems_tbl => l_g_txn_systems_tbl,
426: x_return_status => l_return_status,
420: p_get_csi_attribs_flag => fnd_api.g_false,
421: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
422: p_get_csi_iea_values_flag => fnd_api.g_false,
423: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
424: p_get_txn_systems_flag => fnd_api.g_false,
425: x_txn_systems_tbl => l_g_txn_systems_tbl,
426: x_return_status => l_return_status,
427: x_msg_count => l_msg_count,
428: x_msg_data => l_msg_data);
426: x_return_status => l_return_status,
427: x_msg_count => l_msg_count,
428: x_msg_data => l_msg_data);
429:
430: IF l_return_status <> fnd_api.g_ret_sts_success THEN
431: debug('Get transaction details for the RMA line fulfillment failed.');
432: raise fnd_api.g_exc_error;
433: END IF;
434: /*
428: x_msg_data => l_msg_data);
429:
430: IF l_return_status <> fnd_api.g_ret_sts_success THEN
431: debug('Get transaction details for the RMA line fulfillment failed.');
432: raise fnd_api.g_exc_error;
433: END IF;
434: /*
435: SELECT transaction_line_id
436: INTO l_g_txn_line_rec.transaction_line_id
456: END IF;
457: END LOOP;
458: END IF;
459: -- changes for bug 3684010.Ensuring that Post de fact sales order Qty changes are taken care of
460: IF nvl(l_rma_line_rec.fulfilled_quantity,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
461: l_canceled_qty := l_rma_line_rec.fulfilled_quantity;
462: ELSE
463: l_canceled_qty := l_rma_line_rec.ordered_quantity;
464: END IF;
466: IF l_tld_quantity <> l_canceled_qty THEN
467: IF l_g_line_dtl_tbl.COUNT > 1 THEN
468: fnd_message.set_name('CSI', 'CSI_TXN_LINE_DTL_QTY_INVALID');
469: fnd_msg_pub.add;
470: RAISE fnd_api.g_exc_error;
471: ELSE
472: debug('Canceled Qty as on the Sales Order: '||l_canceled_qty);
473: debug('Total Source Txn Details Qty : '||l_tld_quantity);
474: l_g_line_dtl_tbl(1).quantity := -1 * l_canceled_qty;
497: p_pkg_name => 'csi_transactions_pvt');
498:
499: csi_transactions_pvt.create_transaction(
500: p_api_version => 1.0,
501: p_commit => fnd_api.g_false,
502: p_init_msg_list => fnd_api.g_true,
503: p_validation_level => fnd_api.g_valid_level_full,
504: p_success_if_exists_flag => 'Y',
505: p_transaction_rec => l_csi_txn_rec,
498:
499: csi_transactions_pvt.create_transaction(
500: p_api_version => 1.0,
501: p_commit => fnd_api.g_false,
502: p_init_msg_list => fnd_api.g_true,
503: p_validation_level => fnd_api.g_valid_level_full,
504: p_success_if_exists_flag => 'Y',
505: p_transaction_rec => l_csi_txn_rec,
506: x_return_status => l_return_status,
499: csi_transactions_pvt.create_transaction(
500: p_api_version => 1.0,
501: p_commit => fnd_api.g_false,
502: p_init_msg_list => fnd_api.g_true,
503: p_validation_level => fnd_api.g_valid_level_full,
504: p_success_if_exists_flag => 'Y',
505: p_transaction_rec => l_csi_txn_rec,
506: x_return_status => l_return_status,
507: x_msg_count => l_msg_count,
506: x_return_status => l_return_status,
507: x_msg_count => l_msg_count,
508: x_msg_data => l_msg_data);
509:
510: IF l_return_status <> fnd_api.g_ret_sts_success THEN
511: debug('Create CSI transaction failed for Fulfill RMA Line.');
512: RAISE fnd_api.g_exc_error;
513: END IF;
514:
508: x_msg_data => l_msg_data);
509:
510: IF l_return_status <> fnd_api.g_ret_sts_success THEN
511: debug('Create CSI transaction failed for Fulfill RMA Line.');
512: RAISE fnd_api.g_exc_error;
513: END IF;
514:
515: fulfill_rma_line(
516: p_rma_line_rec => l_rma_line_rec,
520: x_msg_count => l_msg_count,
521: x_msg_data => l_msg_data,
522: x_return_status => l_return_status);
523:
524: IF l_return_status <> fnd_api.g_ret_sts_success THEN
525: debug('Fulfill RMA Line routine failed.');
526: RAISE fnd_api.g_exc_error;
527: END IF;
528: ELSE
522: x_return_status => l_return_status);
523:
524: IF l_return_status <> fnd_api.g_ret_sts_success THEN
525: debug('Fulfill RMA Line routine failed.');
526: RAISE fnd_api.g_exc_error;
527: END IF;
528: ELSE
529: debug('Instance reference on the Transaction detail is Mandatory for a RMA Fulfillment and was NOT found for the line.');
530: fnd_message.set_name('CSI', 'CSI_RMA_INST_REF_REQD');
529: debug('Instance reference on the Transaction detail is Mandatory for a RMA Fulfillment and was NOT found for the line.');
530: fnd_message.set_name('CSI', 'CSI_RMA_INST_REF_REQD');
531: fnd_message.set_token('SRC_TXN_ID', p_rma_line_id);
532: fnd_msg_pub.add;
533: raise fnd_api.g_exc_error;
534: END IF;
535:
536: EXCEPTION
537: WHEN do_not_process THEN
534: END IF;
535:
536: EXCEPTION
537: WHEN do_not_process THEN
538: x_return_status := fnd_api.g_ret_sts_success;
539: WHEN fnd_api.g_exc_error THEN
540: rollback to rma_fulfillment;
541: x_return_status := fnd_api.g_ret_sts_error;
542: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
535:
536: EXCEPTION
537: WHEN do_not_process THEN
538: x_return_status := fnd_api.g_ret_sts_success;
539: WHEN fnd_api.g_exc_error THEN
540: rollback to rma_fulfillment;
541: x_return_status := fnd_api.g_ret_sts_error;
542: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
543: l_error_rec.error_text := l_error_message;
537: WHEN do_not_process THEN
538: x_return_status := fnd_api.g_ret_sts_success;
539: WHEN fnd_api.g_exc_error THEN
540: rollback to rma_fulfillment;
541: x_return_status := fnd_api.g_ret_sts_error;
542: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
543: l_error_rec.error_text := l_error_message;
544: debug('Error :'||l_error_rec.error_text);
545: px_trx_error_rec := l_error_rec;
560: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
561: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
562: fnd_msg_pub.add;
563:
564: x_return_status := fnd_api.g_ret_sts_error;
565: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
566:
567: l_error_rec.error_text := l_error_message;
568: debug('Error :'||l_error_rec.error_text);
652: l_p_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
653: l_p_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
654: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
655: l_api_version NUMBER := 1.0;
656: l_commit VARCHAR2(1) := fnd_api.g_false;
657: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
658: l_validation_level NUMBER := fnd_api.g_valid_level_full;
659: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
660: l_in_out_flag VARCHAR2(30) := 'NONE';
653: l_p_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
654: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
655: l_api_version NUMBER := 1.0;
656: l_commit VARCHAR2(1) := fnd_api.g_false;
657: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
658: l_validation_level NUMBER := fnd_api.g_valid_level_full;
659: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
660: l_in_out_flag VARCHAR2(30) := 'NONE';
661: l_pty_ind binary_integer;
654: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
655: l_api_version NUMBER := 1.0;
656: l_commit VARCHAR2(1) := fnd_api.g_false;
657: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
658: l_validation_level NUMBER := fnd_api.g_valid_level_full;
659: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
660: l_in_out_flag VARCHAR2(30) := 'NONE';
661: l_pty_ind binary_integer;
662: l_pa_ind binary_integer;
655: l_api_version NUMBER := 1.0;
656: l_commit VARCHAR2(1) := fnd_api.g_false;
657: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
658: l_validation_level NUMBER := fnd_api.g_valid_level_full;
659: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
660: l_in_out_flag VARCHAR2(30) := 'NONE';
661: l_pty_ind binary_integer;
662: l_pa_ind binary_integer;
663: l_oa_ind binary_integer;
683: l_orig_rma_status varchar2(30);
684: l_orig_rma_ref_valid varchar2(1):= 'Y';
685:
686: l_debug_level number;
687: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
688: l_pty_override_flag varchar2(1) := 'N';
689: l_upd_inst_qty varchar2(1) := 'Y';
690: l_msg_data varchar2(32767);
691: l_msg_count number;
710: l_unlock_inst_tbl csi_cz_int.config_tbl;
711: l_validation_status VARCHAR2(1);
712:
713: BEGIN
714: x_return_status := fnd_api.g_ret_sts_success;
715: savepoint fulfill_rma_line;
716: fnd_msg_pub.initialize;
717:
718: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
740: WHEN others THEN
741: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
742: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
743: fnd_msg_pub.add;
744: RAISE fnd_api.g_exc_error;
745: END;
746:
747: l_csi_trxn_rec := p_csi_txn_rec;
748:
758: p_line_dtl_tbl(l_td_ind).txn_line_detail_id;
759:
760: csi_t_txn_details_grp.get_transaction_details(
761: p_api_version => 1,
762: p_commit => fnd_api.g_false,
763: p_init_msg_list => fnd_api.g_true,
764: p_validation_level => fnd_api.g_valid_level_full,
765: p_txn_line_query_rec => l_txn_line_query_rec,
766: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
759:
760: csi_t_txn_details_grp.get_transaction_details(
761: p_api_version => 1,
762: p_commit => fnd_api.g_false,
763: p_init_msg_list => fnd_api.g_true,
764: p_validation_level => fnd_api.g_valid_level_full,
765: p_txn_line_query_rec => l_txn_line_query_rec,
766: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
767: x_txn_line_detail_tbl => l_line_dtl_tbl,
760: csi_t_txn_details_grp.get_transaction_details(
761: p_api_version => 1,
762: p_commit => fnd_api.g_false,
763: p_init_msg_list => fnd_api.g_true,
764: p_validation_level => fnd_api.g_valid_level_full,
765: p_txn_line_query_rec => l_txn_line_query_rec,
766: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
767: x_txn_line_detail_tbl => l_line_dtl_tbl,
768: p_get_parties_flag => fnd_api.g_true,
764: p_validation_level => fnd_api.g_valid_level_full,
765: p_txn_line_query_rec => l_txn_line_query_rec,
766: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
767: x_txn_line_detail_tbl => l_line_dtl_tbl,
768: p_get_parties_flag => fnd_api.g_true,
769: x_txn_party_detail_tbl => l_pty_dtl_tbl,
770: p_get_pty_accts_flag => fnd_api.g_true,
771: x_txn_pty_acct_detail_tbl => l_pty_acct_tbl,
772: p_get_ii_rltns_flag => fnd_api.g_true,
766: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
767: x_txn_line_detail_tbl => l_line_dtl_tbl,
768: p_get_parties_flag => fnd_api.g_true,
769: x_txn_party_detail_tbl => l_pty_dtl_tbl,
770: p_get_pty_accts_flag => fnd_api.g_true,
771: x_txn_pty_acct_detail_tbl => l_pty_acct_tbl,
772: p_get_ii_rltns_flag => fnd_api.g_true,
773: x_txn_ii_rltns_tbl => l_ii_rltns_tbl,
774: p_get_org_assgns_flag => fnd_api.g_true,
768: p_get_parties_flag => fnd_api.g_true,
769: x_txn_party_detail_tbl => l_pty_dtl_tbl,
770: p_get_pty_accts_flag => fnd_api.g_true,
771: x_txn_pty_acct_detail_tbl => l_pty_acct_tbl,
772: p_get_ii_rltns_flag => fnd_api.g_true,
773: x_txn_ii_rltns_tbl => l_ii_rltns_tbl,
774: p_get_org_assgns_flag => fnd_api.g_true,
775: x_txn_org_assgn_tbl => l_org_assgn_tbl,
776: p_get_ext_attrib_vals_flag => fnd_api.g_true,
770: p_get_pty_accts_flag => fnd_api.g_true,
771: x_txn_pty_acct_detail_tbl => l_pty_acct_tbl,
772: p_get_ii_rltns_flag => fnd_api.g_true,
773: x_txn_ii_rltns_tbl => l_ii_rltns_tbl,
774: p_get_org_assgns_flag => fnd_api.g_true,
775: x_txn_org_assgn_tbl => l_org_assgn_tbl,
776: p_get_ext_attrib_vals_flag => fnd_api.g_true,
777: x_txn_ext_attrib_vals_tbl => l_txn_ext_attrib_tbl,
778: p_get_csi_attribs_flag => fnd_api.g_false,
772: p_get_ii_rltns_flag => fnd_api.g_true,
773: x_txn_ii_rltns_tbl => l_ii_rltns_tbl,
774: p_get_org_assgns_flag => fnd_api.g_true,
775: x_txn_org_assgn_tbl => l_org_assgn_tbl,
776: p_get_ext_attrib_vals_flag => fnd_api.g_true,
777: x_txn_ext_attrib_vals_tbl => l_txn_ext_attrib_tbl,
778: p_get_csi_attribs_flag => fnd_api.g_false,
779: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
780: p_get_csi_iea_values_flag => fnd_api.g_false,
774: p_get_org_assgns_flag => fnd_api.g_true,
775: x_txn_org_assgn_tbl => l_org_assgn_tbl,
776: p_get_ext_attrib_vals_flag => fnd_api.g_true,
777: x_txn_ext_attrib_vals_tbl => l_txn_ext_attrib_tbl,
778: p_get_csi_attribs_flag => fnd_api.g_false,
779: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
780: p_get_csi_iea_values_flag => fnd_api.g_false,
781: x_csi_iea_values_tbl => l_csi_eav_tbl,
782: p_get_txn_systems_flag => fnd_api.g_false,
776: p_get_ext_attrib_vals_flag => fnd_api.g_true,
777: x_txn_ext_attrib_vals_tbl => l_txn_ext_attrib_tbl,
778: p_get_csi_attribs_flag => fnd_api.g_false,
779: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
780: p_get_csi_iea_values_flag => fnd_api.g_false,
781: x_csi_iea_values_tbl => l_csi_eav_tbl,
782: p_get_txn_systems_flag => fnd_api.g_false,
783: x_txn_systems_tbl => l_txn_systems_tbl,
784: x_return_status => l_return_status,
778: p_get_csi_attribs_flag => fnd_api.g_false,
779: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
780: p_get_csi_iea_values_flag => fnd_api.g_false,
781: x_csi_iea_values_tbl => l_csi_eav_tbl,
782: p_get_txn_systems_flag => fnd_api.g_false,
783: x_txn_systems_tbl => l_txn_systems_tbl,
784: x_return_status => l_return_status,
785: x_msg_count => l_msg_count,
786: x_msg_data => l_msg_data);
784: x_return_status => l_return_status,
785: x_msg_count => l_msg_count,
786: x_msg_data => l_msg_data);
787:
788: IF l_return_status <> fnd_api.g_ret_sts_success THEN
789: debug('Get transaction details failed for Fulfill RMA Line.');
790: RAISE fnd_api.g_exc_error;
791: END IF;
792:
786: x_msg_data => l_msg_data);
787:
788: IF l_return_status <> fnd_api.g_ret_sts_success THEN
789: debug('Get transaction details failed for Fulfill RMA Line.');
790: RAISE fnd_api.g_exc_error;
791: END IF;
792:
793: l_txn_line_dtl_rec := l_line_dtl_tbl(1);--always one record. Query by TLD ID. bug 3230999. changed all references
794: l_txn_line_dtl_rec.quantity := p_line_dtl_tbl(l_td_ind).quantity; -- changes for bug 3684010
839: when others THEN
840: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
841: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
842: fnd_msg_pub.add;
843: raise fnd_api.g_exc_error;
844: End;
845: --Check if the object id is being updated, if so raise error
846:
847: IF l_curr_object_id <> -9999 THEN
848: IF l_curr_object_id <> l_object_inst_id THEN
849: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');
850: fnd_message.set_token('OBJECT_ID',l_object_inst_id);
851: fnd_msg_pub.add;
852: raise fnd_api.g_exc_error;
853: END IF;
854: END IF;
855: END IF;
856:
861: p_trx_type_id => l_txn_type_id,
862: x_trx_sub_type_rec => l_txn_sub_type_rec,
863: x_return_status => l_return_status) ;
864:
865: IF l_return_status <> fnd_api.g_ret_sts_success THEN
866: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
867: fnd_message.set_token('MESSAGE','Call to the routine csi_utl_pkg.get_sub_type_rec Failed.');
868: fnd_msg_pub.add;
869: raise fnd_api.g_exc_error;
865: IF l_return_status <> fnd_api.g_ret_sts_success THEN
866: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
867: fnd_message.set_token('MESSAGE','Call to the routine csi_utl_pkg.get_sub_type_rec Failed.');
868: fnd_msg_pub.add;
869: raise fnd_api.g_exc_error;
870: END IF;
871:
872: debug(' transaction_type_id :'||l_txn_sub_type_rec.trx_type_id );
873: debug(' default sub_type_id :'||l_txn_sub_type_rec.sub_type_id );
875: --Fix for bug 4243512
876: IF l_txn_sub_type_rec.src_change_owner = 'Y' THEN
877: fnd_message.set_name('CSI','CSI_SUB_TYPE_INVALID');
878: fnd_msg_pub.add;
879: raise fnd_api.g_exc_error;
880: END IF;
881: --end of fix.
882:
883:
894: l_instance_rec.instance_id := l_txn_line_dtl_rec.instance_id;
895:
896: csi_item_instance_pub.get_item_instance_details(
897: p_api_version => 1.0,
898: p_commit => fnd_api.g_false,
899: p_init_msg_list => fnd_api.g_true,
900: p_validation_level => fnd_api.g_valid_level_full,
901: p_instance_rec => l_instance_rec,
902: p_get_parties => fnd_api.g_true,
895:
896: csi_item_instance_pub.get_item_instance_details(
897: p_api_version => 1.0,
898: p_commit => fnd_api.g_false,
899: p_init_msg_list => fnd_api.g_true,
900: p_validation_level => fnd_api.g_valid_level_full,
901: p_instance_rec => l_instance_rec,
902: p_get_parties => fnd_api.g_true,
903: p_party_header_tbl => l_party_header_tbl,
896: csi_item_instance_pub.get_item_instance_details(
897: p_api_version => 1.0,
898: p_commit => fnd_api.g_false,
899: p_init_msg_list => fnd_api.g_true,
900: p_validation_level => fnd_api.g_valid_level_full,
901: p_instance_rec => l_instance_rec,
902: p_get_parties => fnd_api.g_true,
903: p_party_header_tbl => l_party_header_tbl,
904: p_get_accounts => fnd_api.g_true,
898: p_commit => fnd_api.g_false,
899: p_init_msg_list => fnd_api.g_true,
900: p_validation_level => fnd_api.g_valid_level_full,
901: p_instance_rec => l_instance_rec,
902: p_get_parties => fnd_api.g_true,
903: p_party_header_tbl => l_party_header_tbl,
904: p_get_accounts => fnd_api.g_true,
905: p_account_header_tbl => l_account_header_tbl,
906: p_get_org_assignments => fnd_api.g_false,
900: p_validation_level => fnd_api.g_valid_level_full,
901: p_instance_rec => l_instance_rec,
902: p_get_parties => fnd_api.g_true,
903: p_party_header_tbl => l_party_header_tbl,
904: p_get_accounts => fnd_api.g_true,
905: p_account_header_tbl => l_account_header_tbl,
906: p_get_org_assignments => fnd_api.g_false,
907: p_org_header_tbl => l_org_assignments_tbl,
908: p_get_pricing_attribs => fnd_api.g_false,
902: p_get_parties => fnd_api.g_true,
903: p_party_header_tbl => l_party_header_tbl,
904: p_get_accounts => fnd_api.g_true,
905: p_account_header_tbl => l_account_header_tbl,
906: p_get_org_assignments => fnd_api.g_false,
907: p_org_header_tbl => l_org_assignments_tbl,
908: p_get_pricing_attribs => fnd_api.g_false,
909: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
910: p_get_ext_attribs => fnd_api.g_false,
904: p_get_accounts => fnd_api.g_true,
905: p_account_header_tbl => l_account_header_tbl,
906: p_get_org_assignments => fnd_api.g_false,
907: p_org_header_tbl => l_org_assignments_tbl,
908: p_get_pricing_attribs => fnd_api.g_false,
909: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
910: p_get_ext_attribs => fnd_api.g_false,
911: p_ext_attrib_tbl => l_ext_attrib_tbl,
912: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
906: p_get_org_assignments => fnd_api.g_false,
907: p_org_header_tbl => l_org_assignments_tbl,
908: p_get_pricing_attribs => fnd_api.g_false,
909: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
910: p_get_ext_attribs => fnd_api.g_false,
911: p_ext_attrib_tbl => l_ext_attrib_tbl,
912: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
913: p_get_asset_assignments => fnd_api.g_false,
914: p_asset_header_tbl => l_asset_assignment_tbl,
909: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
910: p_get_ext_attribs => fnd_api.g_false,
911: p_ext_attrib_tbl => l_ext_attrib_tbl,
912: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
913: p_get_asset_assignments => fnd_api.g_false,
914: p_asset_header_tbl => l_asset_assignment_tbl,
915: p_time_stamp => l_time_stamp,
916: x_return_status => l_return_status,
917: x_msg_count => l_msg_count,
916: x_return_status => l_return_status,
917: x_msg_count => l_msg_count,
918: x_msg_data => l_msg_data);
919:
920: IF l_return_status <> fnd_api.g_ret_sts_success THEN
921: debug('Get item instance details failed for Fulfill RMA Line.');
922: RAISE fnd_api.g_exc_error;
923: END IF;
924:
918: x_msg_data => l_msg_data);
919:
920: IF l_return_status <> fnd_api.g_ret_sts_success THEN
921: debug('Get item instance details failed for Fulfill RMA Line.');
922: RAISE fnd_api.g_exc_error;
923: END IF;
924:
925: --Initialize the variable
926: l_upd_inst_qty := 'Y';
939: debug('Instance Party not found. Instance:'||l_instance_rec.instance_id);
940: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
941: fnd_message.set_token('MESSAGE','Instance Party not found. Instance:'||l_instance_rec.instance_id);
942: fnd_msg_pub.add;
943: RAISE fnd_api.g_exc_error;
944: END IF;
945:
946:
947: -- Bug 4997771
946:
947: -- Bug 4997771
948: IF ( l_instance_rec.location_type_code = 'INVENTORY'
949: AND
950: NVL(l_instance_rec.active_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date )
951: THEN
952:
953: IF l_inst_owner_pty_id = l_internal_party_id THEN
954: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
953: IF l_inst_owner_pty_id = l_internal_party_id THEN
954: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
955: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
956: fnd_msg_pub.add;
957: RAISE fnd_api.g_exc_error;
958: ELSE
959: debug('Location type code is :'||l_instance_rec.location_type_code);
960: fnd_message.set_name('CSI', 'CSI_NON_RETURNABLE_INSTANCE');
961: fnd_message.set_token('LOC_TYPE_CODE', l_instance_rec.location_type_code);
959: debug('Location type code is :'||l_instance_rec.location_type_code);
960: fnd_message.set_name('CSI', 'CSI_NON_RETURNABLE_INSTANCE');
961: fnd_message.set_token('LOC_TYPE_CODE', l_instance_rec.location_type_code);
962: fnd_msg_pub.add;
963: raise fnd_api.g_exc_error;
964: END IF;
965: END IF;
966:
967:
994: IF nvl(l_txn_sub_type_rec.src_change_owner, 'N') = 'Y' THEN
995: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
996: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
997: fnd_msg_pub.add;
998: RAISE fnd_api.g_exc_error;
999: END IF;
1000: ELSIF l_inst_owner_pty_id <> l_src_txn_owner_pty_id THEN
1001: IF l_pty_override_flag = 'Y' THEN
1002:
1007: l_upd_parties_tbl(1).party_source_table := 'HZ_PARTIES';
1008: l_upd_parties_tbl(1).party_id := l_src_txn_owner_pty_id;
1009: l_upd_parties_tbl(1).relationship_type_code := 'OWNER';
1010: l_upd_parties_tbl(1).contact_flag := 'N';
1011: l_upd_parties_tbl(1).call_contracts := fnd_api.g_false;
1012:
1013: l_upd_pty_accts_tbl(1).ip_account_id := l_owner_acct_ipa_id;
1014: l_upd_pty_accts_tbl(1).object_version_number:= l_owner_acct_obj_ver_num;
1015: l_upd_pty_accts_tbl(1).parent_tbl_index := 1;
1014: l_upd_pty_accts_tbl(1).object_version_number:= l_owner_acct_obj_ver_num;
1015: l_upd_pty_accts_tbl(1).parent_tbl_index := 1;
1016: l_upd_pty_accts_tbl(1).party_account_id := p_rma_line_rec.sold_to_org_id; -- bug 3693594
1017: l_upd_pty_accts_tbl(1).relationship_type_code := 'OWNER';
1018: l_upd_pty_accts_tbl(1).call_contracts := fnd_api.g_false;
1019:
1020: /* Commented the call as part of fix for Bug 2733128. Added call to Update_Item_Instance instead
1021: csi_t_gen_utility_pvt.dump_api_info(
1022: p_pkg_name => 'csi_party_relationships_pub',
1023: p_api_name => 'update_inst_party_relationship');
1024:
1025: csi_party_relationships_pub.update_inst_party_relationship (
1026: p_api_version => 1.0,
1027: p_commit => fnd_api.g_false,
1028: p_init_msg_list => fnd_api.g_true,
1029: p_validation_level => fnd_api.g_valid_level_full,
1030: p_party_tbl => l_upd_parties_tbl,
1031: p_party_account_tbl => l_upd_pty_accts_tbl,
1024:
1025: csi_party_relationships_pub.update_inst_party_relationship (
1026: p_api_version => 1.0,
1027: p_commit => fnd_api.g_false,
1028: p_init_msg_list => fnd_api.g_true,
1029: p_validation_level => fnd_api.g_valid_level_full,
1030: p_party_tbl => l_upd_parties_tbl,
1031: p_party_account_tbl => l_upd_pty_accts_tbl,
1032: p_txn_rec => l_csi_trxn_rec,
1025: csi_party_relationships_pub.update_inst_party_relationship (
1026: p_api_version => 1.0,
1027: p_commit => fnd_api.g_false,
1028: p_init_msg_list => fnd_api.g_true,
1029: p_validation_level => fnd_api.g_valid_level_full,
1030: p_party_tbl => l_upd_parties_tbl,
1031: p_party_account_tbl => l_upd_pty_accts_tbl,
1032: p_txn_rec => l_csi_trxn_rec,
1033: x_return_status => l_return_status,
1048: p_api_name => 'update_item_instance');
1049:
1050: csi_item_instance_pub.update_item_instance(
1051: p_api_version => 1.0,
1052: p_commit => fnd_api.g_false,
1053: p_init_msg_list => fnd_api.g_true,
1054: p_validation_level => fnd_api.g_valid_level_full,
1055: p_instance_rec => l_chg_instance_rec,
1056: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
1049:
1050: csi_item_instance_pub.update_item_instance(
1051: p_api_version => 1.0,
1052: p_commit => fnd_api.g_false,
1053: p_init_msg_list => fnd_api.g_true,
1054: p_validation_level => fnd_api.g_valid_level_full,
1055: p_instance_rec => l_chg_instance_rec,
1056: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
1057: p_party_tbl => l_upd_parties_tbl,
1050: csi_item_instance_pub.update_item_instance(
1051: p_api_version => 1.0,
1052: p_commit => fnd_api.g_false,
1053: p_init_msg_list => fnd_api.g_true,
1054: p_validation_level => fnd_api.g_valid_level_full,
1055: p_instance_rec => l_chg_instance_rec,
1056: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
1057: p_party_tbl => l_upd_parties_tbl,
1058: p_account_tbl => l_upd_pty_accts_tbl,
1064: x_return_status => l_return_status,
1065: x_msg_count => l_msg_count,
1066: x_msg_data => l_msg_data);
1067:
1068: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1069: RAISE fnd_api.g_exc_error;
1070: END IF;
1071:
1072: debug('Ownership Changed Successfully.');
1065: x_msg_count => l_msg_count,
1066: x_msg_data => l_msg_data);
1067:
1068: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1069: RAISE fnd_api.g_exc_error;
1070: END IF;
1071:
1072: debug('Ownership Changed Successfully.');
1073: ELSE
1075: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );
1076: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );
1077: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: END IF;
1081: END IF;
1082: /* Bug 3746600. Since Cancellation is always a expiry now, we do not need the code below. commenting.
1083: ELSE -- inst party = source txn party AND instance is valid - Normal case
1133: debug('Fetch instance details failed ...');
1134: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1135: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1136: fnd_msg_pub.add;
1137: raise fnd_api.g_exc_unexpected_error;
1138: End;
1139:
1140: csi_t_gen_utility_pvt.dump_api_info(
1141: p_pkg_name => 'csi_item_instance_pub',
1142: p_api_name => 'update_item_instance');
1143:
1144: csi_item_instance_pub.update_item_instance(
1145: p_api_version => 1.0,
1146: p_commit => fnd_api.g_false,
1147: p_init_msg_list => fnd_api.g_true,
1148: p_validation_level => fnd_api.g_valid_level_full,
1149: p_instance_rec => l_u_instance_rec,
1150: p_party_tbl => l_u_parties_tbl,
1143:
1144: csi_item_instance_pub.update_item_instance(
1145: p_api_version => 1.0,
1146: p_commit => fnd_api.g_false,
1147: p_init_msg_list => fnd_api.g_true,
1148: p_validation_level => fnd_api.g_valid_level_full,
1149: p_instance_rec => l_u_instance_rec,
1150: p_party_tbl => l_u_parties_tbl,
1151: p_account_tbl => l_u_pty_accts_tbl,
1144: csi_item_instance_pub.update_item_instance(
1145: p_api_version => 1.0,
1146: p_commit => fnd_api.g_false,
1147: p_init_msg_list => fnd_api.g_true,
1148: p_validation_level => fnd_api.g_valid_level_full,
1149: p_instance_rec => l_u_instance_rec,
1150: p_party_tbl => l_u_parties_tbl,
1151: p_account_tbl => l_u_pty_accts_tbl,
1152: p_org_assignments_tbl => l_u_org_units_tbl,
1158: x_return_status => l_return_status,
1159: x_msg_count => l_msg_count,
1160: x_msg_data => l_msg_data);
1161:
1162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1163: RAISE fnd_api.g_exc_error;
1164: END IF;
1165: ELSE
1166: debug('Instance Quantity is -ve already. Error??');
1159: x_msg_count => l_msg_count,
1160: x_msg_data => l_msg_data);
1161:
1162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1163: RAISE fnd_api.g_exc_error;
1164: END IF;
1165: ELSE
1166: debug('Instance Quantity is -ve already. Error??');
1167: l_upd_inst_qty := 'N';
1164: END IF;
1165: ELSE
1166: debug('Instance Quantity is -ve already. Error??');
1167: l_upd_inst_qty := 'N';
1168: --RAISE fnd_api.g_exc_error;
1169: END IF;
1170: ELSE --Not sure about the case??
1171: l_p_instances_tbl(l_td_ind).active_end_date := NULL;
1172: l_upd_inst_qty := 'N';
1198: debug('Could not determine serial control policy?');
1199: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1200: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1201: fnd_msg_pub.add;
1202: RAISE fnd_api.g_exc_unexpected_error;
1203: End;
1204:
1205: l_p_instances_tbl(l_td_ind).instance_id := l_txn_line_dtl_rec.instance_id;
1206: IF ( nvl(l_instance_rec.active_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1202: RAISE fnd_api.g_exc_unexpected_error;
1203: End;
1204:
1205: l_p_instances_tbl(l_td_ind).instance_id := l_txn_line_dtl_rec.instance_id;
1206: IF ( nvl(l_instance_rec.active_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1207: AND l_instance_rec.active_end_date < sysdate ) THEN -- Added this new check, IF as part of 3746600
1208: IF l_instance_rec.instance_usage_code <> 'IN_RELATIONSHIP' THEN
1209: -- ONLY excluding Components since they get expired along with their parent in a config cancellation
1210: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
1209: -- ONLY excluding Components since they get expired along with their parent in a config cancellation
1210: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
1211: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1212: fnd_msg_pub.add;
1213: RAISE fnd_api.g_exc_error;
1214: END IF;
1215: ELSIF l_item_srl_code = 1 THEN
1216: IF abs(l_txn_line_dtl_rec.quantity) > l_instance_rec.quantity THEN
1217: -- check if the quantity is greater than the instance quantity
1217: -- check if the quantity is greater than the instance quantity
1218: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
1219: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1220: fnd_msg_pub.add;
1221: RAISE fnd_api.g_exc_error;
1222: ELSIF l_instance_rec.quantity > abs(l_txn_line_dtl_rec.quantity) THEN -- need to split the source cust prod first
1223: debug('Original Instance Quantity: '||l_instance_rec.quantity);
1224: l_quantity1 := l_instance_rec.quantity - abs(l_txn_line_dtl_rec.quantity) ;
1225:
1231: p_api_name => 'split_item_instance');
1232:
1233: csi_item_instance_pvt.split_item_instance (
1234: p_api_version => 1.0,
1235: p_commit => fnd_api.g_false,
1236: p_init_msg_list => fnd_api.g_true,
1237: p_validation_level => fnd_api.g_valid_level_full,
1238: p_source_instance_rec => l_split_src_inst_rec,
1239: p_quantity1 => l_quantity1,
1232:
1233: csi_item_instance_pvt.split_item_instance (
1234: p_api_version => 1.0,
1235: p_commit => fnd_api.g_false,
1236: p_init_msg_list => fnd_api.g_true,
1237: p_validation_level => fnd_api.g_valid_level_full,
1238: p_source_instance_rec => l_split_src_inst_rec,
1239: p_quantity1 => l_quantity1,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1233: csi_item_instance_pvt.split_item_instance (
1234: p_api_version => 1.0,
1235: p_commit => fnd_api.g_false,
1236: p_init_msg_list => fnd_api.g_true,
1237: p_validation_level => fnd_api.g_valid_level_full,
1238: p_source_instance_rec => l_split_src_inst_rec,
1239: p_quantity1 => l_quantity1,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1241: p_copy_ext_attribs => fnd_api.g_true,
1237: p_validation_level => fnd_api.g_valid_level_full,
1238: p_source_instance_rec => l_split_src_inst_rec,
1239: p_quantity1 => l_quantity1,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1241: p_copy_ext_attribs => fnd_api.g_true,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1238: p_source_instance_rec => l_split_src_inst_rec,
1239: p_quantity1 => l_quantity1,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1241: p_copy_ext_attribs => fnd_api.g_true,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1246: p_copy_pricing_attribs => fnd_api.g_true,
1239: p_quantity1 => l_quantity1,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1241: p_copy_ext_attribs => fnd_api.g_true,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1246: p_copy_pricing_attribs => fnd_api.g_true,
1247: p_txn_rec => l_csi_trxn_rec,
1240: p_quantity2 => abs(l_txn_line_dtl_rec.quantity),
1241: p_copy_ext_attribs => fnd_api.g_true,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1246: p_copy_pricing_attribs => fnd_api.g_true,
1247: p_txn_rec => l_csi_trxn_rec,
1248: x_new_instance_rec => l_split_new_inst_rec,
1241: p_copy_ext_attribs => fnd_api.g_true,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1246: p_copy_pricing_attribs => fnd_api.g_true,
1247: p_txn_rec => l_csi_trxn_rec,
1248: x_new_instance_rec => l_split_new_inst_rec,
1249: x_return_status => l_return_status,
1242: p_copy_org_assignments => fnd_api.g_true,
1243: p_copy_parties => fnd_api.g_true,
1244: p_copy_accounts => fnd_api.g_true,
1245: p_copy_asset_assignments => fnd_api.g_true,
1246: p_copy_pricing_attribs => fnd_api.g_true,
1247: p_txn_rec => l_csi_trxn_rec,
1248: x_new_instance_rec => l_split_new_inst_rec,
1249: x_return_status => l_return_status,
1250: x_msg_count => l_msg_count,
1249: x_return_status => l_return_status,
1250: x_msg_count => l_msg_count,
1251: x_msg_data => l_msg_data);
1252:
1253: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
1254: debug('csi_item_instance_pvt.split_item_instance raised errors');
1255: raise fnd_api.g_exc_error;
1256: END IF;
1257:
1251: x_msg_data => l_msg_data);
1252:
1253: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
1254: debug('csi_item_instance_pvt.split_item_instance raised errors');
1255: raise fnd_api.g_exc_error;
1256: END IF;
1257:
1258: l_p_instances_tbl(l_td_ind).instance_id := l_split_new_inst_rec.instance_id ;
1259: l_p_instances_tbl(l_td_ind).object_version_number := l_split_new_inst_rec.object_version_number;
1352:
1353: -- updating txn dtls to IN_PROCESS. moved this code down here from inside the loop
1354: csi_t_txn_details_grp.update_txn_line_dtls(
1355: p_api_version => 1.0,
1356: p_commit => fnd_api.g_false,
1357: p_init_msg_list => fnd_api.g_true,
1358: p_validation_level => fnd_api.g_valid_level_full,
1359: p_txn_line_rec => l_u_txn_line_rec,
1360: p_txn_line_detail_tbl => l_u_line_dtl_tbl,
1353: -- updating txn dtls to IN_PROCESS. moved this code down here from inside the loop
1354: csi_t_txn_details_grp.update_txn_line_dtls(
1355: p_api_version => 1.0,
1356: p_commit => fnd_api.g_false,
1357: p_init_msg_list => fnd_api.g_true,
1358: p_validation_level => fnd_api.g_valid_level_full,
1359: p_txn_line_rec => l_u_txn_line_rec,
1360: p_txn_line_detail_tbl => l_u_line_dtl_tbl,
1361: px_txn_ii_rltns_tbl => l_u_ii_rltns_tbl,
1354: csi_t_txn_details_grp.update_txn_line_dtls(
1355: p_api_version => 1.0,
1356: p_commit => fnd_api.g_false,
1357: p_init_msg_list => fnd_api.g_true,
1358: p_validation_level => fnd_api.g_valid_level_full,
1359: p_txn_line_rec => l_u_txn_line_rec,
1360: p_txn_line_detail_tbl => l_u_line_dtl_tbl,
1361: px_txn_ii_rltns_tbl => l_u_ii_rltns_tbl,
1362: px_txn_party_detail_tbl => l_u_pty_dtl_tbl,
1366: x_return_status => l_return_status,
1367: x_msg_count => l_msg_count,
1368: x_msg_data => l_msg_data);
1369:
1370: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1371: debug('Update txn line dtls failed for Fulfill RMA Line.');
1372: RAISE fnd_api.g_exc_error;
1373: END IF;
1374: --
1368: x_msg_data => l_msg_data);
1369:
1370: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1371: debug('Update txn line dtls failed for Fulfill RMA Line.');
1372: RAISE fnd_api.g_exc_error;
1373: END IF;
1374: --
1375: -- srramakr TSO with Equipment
1376: -- For Shippable Items, if RMA fulfillment is performed then we need to remove the config keys
1379: IF NVL(p_rma_line_rec.shippable_flag,'N') = 'Y' THEN
1380: IF l_p_instances_tbl.count > 0 THEN
1381: FOR J in l_p_instances_tbl.FIRST .. l_p_instances_tbl.LAST LOOP
1382: IF l_p_instances_tbl(J).instance_id IS NOT NULL AND
1383: l_p_instances_tbl(J).instance_id <> FND_API.G_MISS_NUM THEN
1384: l_lock_id := NULL;
1385: l_lock_status := NULL;
1386: l_locked_inst_rev_num := NULL;
1387: l_p_instances_tbl(J).config_inst_hdr_id := null;
1435: ,x_return_status => l_return_status
1436: ,x_msg_count => l_msg_count
1437: ,x_msg_data => l_msg_data
1438: );
1439: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1440: debug('Unlock Item Instances routine failed.');
1441: RAISE fnd_api.g_exc_error;
1442: END IF;
1443: --
1437: ,x_msg_data => l_msg_data
1438: );
1439: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1440: debug('Unlock Item Instances routine failed.');
1441: RAISE fnd_api.g_exc_error;
1442: END IF;
1443: --
1444: -- Update any pending TLD for the same config keys (fetched from lock table)
1445: -- with the instance_id so that when regular fulfillment happens for this
1471: x_return_status => l_return_status,
1472: x_msg_count => l_msg_count,
1473: x_msg_data => l_msg_data
1474: );
1475: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1476: debug('Remove_Returned_Config_Item routine failed.');
1477: RAISE fnd_api.g_exc_error;
1478: END IF;
1479: END IF;
1473: x_msg_data => l_msg_data
1474: );
1475: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1476: debug('Remove_Returned_Config_Item routine failed.');
1477: RAISE fnd_api.g_exc_error;
1478: END IF;
1479: END IF;
1480: END IF;
1481: --
1508: x_return_status => l_return_status,
1509: x_msg_count => l_msg_count,
1510: x_msg_data => l_msg_data );
1511:
1512: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1513: debug('Process Transaction call failed for Fulfill RMA Line.');
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516: Begin
1510: x_msg_data => l_msg_data );
1511:
1512: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1513: debug('Process Transaction call failed for Fulfill RMA Line.');
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516: Begin
1517:
1518: --Assign the literals.. bug 4311676
1531: b.source_transaction_id = p_rma_line_rec.line_id
1532: AND b.source_transaction_table = l_literal2);
1533: Exception when others Then
1534: debug('Txn details update failed');
1535: raise fnd_api.g_exc_unexpected_error;
1536: End;
1537:
1538: END IF; -- td_tbl count > 0
1539:
1537:
1538: END IF; -- td_tbl count > 0
1539:
1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN
1542: rollback to fulfill_rma_line;
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1545: debug(l_error_message);
1539:
1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN
1542: rollback to fulfill_rma_line;
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1545: debug(l_error_message);
1546: WHEN fnd_api.g_exc_unexpected_error THEN
1547: rollback to fulfill_rma_line;
1542: rollback to fulfill_rma_line;
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1545: debug(l_error_message);
1546: WHEN fnd_api.g_exc_unexpected_error THEN
1547: rollback to fulfill_rma_line;
1548: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1549: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1550: fnd_msg_pub.add;
1547: rollback to fulfill_rma_line;
1548: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1549: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1550: fnd_msg_pub.add;
1551: x_return_status := fnd_api.g_ret_sts_error;
1552: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1553: debug(l_error_message);
1554: END fulfill_rma_line;
1555: