eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_RMA_FULFILL_PUB dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('CSI', 'CSI_INT_OE_LINE_ID_INVALID');

53: AND oel.line_id = p_rma_line_id;
54:
55: EXCEPTION
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;

Line 58: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);

54:
55: EXCEPTION
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:

Line 70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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));
72: fnd_msg_pub.add;
73:
74: x_error_message := fnd_msg_pub.get;

Line 71: fnd_message.set_token('MESSAGE', substr(sqlerrm, 240));

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));
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;

Line 105: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');

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;
109: RAISE fnd_api.g_exc_error;

Line 106: fnd_message.set_token('MESSAGE_id', p_msg_header.message_id);

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;
109: RAISE fnd_api.g_exc_error;
110: END IF;

Line 107: fnd_message.set_token('MESSAGE_CODE', p_msg_header.message_code);

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;
109: RAISE fnd_api.g_exc_error;
110: END IF;
111:

Line 136: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

132: debug(x_error_message);
133:
134: WHEN others THEN
135:
136: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
137: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
138: fnd_message.set_token('SQL_ERROR', substr(sqlerrm, 1, 255));
139: fnd_msg_pub.add;
140:

Line 137: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);

133:
134: WHEN others THEN
135:
136: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
137: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
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;

Line 138: fnd_message.set_token('SQL_ERROR', substr(sqlerrm, 1, 255));

134: WHEN others THEN
135:
136: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
137: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
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;

Line 252: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

248: AND oel.header_id = oeh.header_id;
249: EXCEPTION
250: WHEN no_data_found THEN
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;

Line 253: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);

249: EXCEPTION
250: WHEN no_data_found THEN
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:

Line 273: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

269: param_name => 'MASTER_ORGANIZATION_ID',
270: p_org_id => l_rma_line_rec.org_id);
271: Exception when others then
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;

Line 274: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);

270: p_org_id => l_rma_line_rec.org_id);
271: Exception when others then
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

Line 303: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');

299: FROM mtl_system_items
300: WHERE inventory_item_id = l_rma_line_rec.inventory_item_id
301: AND organization_id = l_orgn_id;
302: Exception when others then
303: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
304: fnd_message.set_token('INVENTORY_ITEM_ID', l_rma_line_rec.inventory_item_id);
305: fnd_message.set_token('INV_ORGANZATION_ID', l_orgn_id);
306: fnd_msg_pub.add;
307: End;

Line 304: fnd_message.set_token('INVENTORY_ITEM_ID', l_rma_line_rec.inventory_item_id);

300: WHERE inventory_item_id = l_rma_line_rec.inventory_item_id
301: AND organization_id = l_orgn_id;
302: Exception when others then
303: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
304: fnd_message.set_token('INVENTORY_ITEM_ID', l_rma_line_rec.inventory_item_id);
305: fnd_message.set_token('INV_ORGANZATION_ID', l_orgn_id);
306: fnd_msg_pub.add;
307: End;
308: ELSE

Line 305: fnd_message.set_token('INV_ORGANZATION_ID', l_orgn_id);

301: AND organization_id = l_orgn_id;
302: Exception when others then
303: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
304: fnd_message.set_token('INVENTORY_ITEM_ID', l_rma_line_rec.inventory_item_id);
305: fnd_message.set_token('INV_ORGANZATION_ID', l_orgn_id);
306: fnd_msg_pub.add;
307: End;
308: ELSE
309: debug('Invalid Organization ID - l_orgn_id: '||l_orgn_id);

Line 310: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

306: fnd_msg_pub.add;
307: End;
308: ELSE
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;

Line 311: fnd_message.set_token('OE_LINE_ID', p_rma_line_id);

307: End;
308: ELSE
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:

Line 335: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

331: dbms_application_info.set_client_info(l_rma_line_rec.org_id);
332:
333: IF l_shippable_item_flag is NULL THEN
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

Line 336: fnd_message.set_token('MESSAGE','Could not determine if the line item is shippable or not for the RMA Fulfillment Line.');

332:
333: IF l_shippable_item_flag is NULL THEN
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(

Line 366: fnd_message.set_name('CSI', 'CSI_RMA_TXN_DTLS_REQD');

362: l_g_txn_line_rec.source_transaction_type_id := l_txn_type_id;
363:
364: IF NOT(l_found) THEN
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

Line 367: fnd_message.set_token('SRC_TXN_ID', p_rma_line_id);

363:
364: IF NOT(l_found) THEN
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

Line 382: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');

378: AND source_transaction_id = p_rma_line_id;
379:
380: IF l_processing_status = 'PROCESSED' THEN
381: debug('This transaction detail is already PROCESSED.');
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;

Line 383: fnd_message.set_token('SRC_TBL', l_src_txn_table);

379:
380: IF l_processing_status = 'PROCESSED' THEN
381: debug('This transaction detail is already PROCESSED.');
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;

Line 384: fnd_message.set_token('SRC_ID', p_rma_line_id);

380: IF l_processing_status = 'PROCESSED' THEN
381: debug('This transaction detail is already PROCESSED.');
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:

Line 468: fnd_message.set_name('CSI', 'CSI_TXN_LINE_DTL_QTY_INVALID');

464: END IF;
465:
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);

Line 530: fnd_message.set_name('CSI', 'CSI_RMA_INST_REF_REQD');

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');
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;

Line 531: fnd_message.set_token('SRC_TXN_ID', p_rma_line_id);

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');
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:

Line 560: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

556: p_error_message => l_error_message );
557:
558: WHEN others THEN
559: rollback to rma_fulfillment;
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;

Line 561: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

557:
558: WHEN others THEN
559: rollback to rma_fulfillment;
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;

Line 743: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

739: WHERE cust_account_id = p_rma_line_rec.sold_to_org_id;
740:
741: EXCEPTION
742: WHEN others THEN
743: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
744: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
745: fnd_msg_pub.add;
746: RAISE fnd_api.g_exc_error;
747: END;

Line 744: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

740:
741: EXCEPTION
742: WHEN others THEN
743: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
744: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
745: fnd_msg_pub.add;
746: RAISE fnd_api.g_exc_error;
747: END;
748:

Line 842: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

838: Exception
839: when no_data_found THEN
840: l_curr_object_id := -9999;
841: when others THEN
842: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
843: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
844: fnd_msg_pub.add;
845: raise fnd_api.g_exc_error;
846: End;

Line 843: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

839: when no_data_found THEN
840: l_curr_object_id := -9999;
841: when others THEN
842: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
843: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
844: fnd_msg_pub.add;
845: raise fnd_api.g_exc_error;
846: End;
847: --Check if the object id is being updated, if so raise error

Line 851: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');

847: --Check if the object id is being updated, if so raise error
848:
849: IF l_curr_object_id <> -9999 THEN
850: IF l_curr_object_id <> l_object_inst_id THEN
851: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');
852: fnd_message.set_token('OBJECT_ID',l_object_inst_id);
853: fnd_msg_pub.add;
854: raise fnd_api.g_exc_error;
855: END IF;

Line 852: fnd_message.set_token('OBJECT_ID',l_object_inst_id);

848:
849: IF l_curr_object_id <> -9999 THEN
850: IF l_curr_object_id <> l_object_inst_id THEN
851: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');
852: fnd_message.set_token('OBJECT_ID',l_object_inst_id);
853: fnd_msg_pub.add;
854: raise fnd_api.g_exc_error;
855: END IF;
856: END IF;

Line 868: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

864: x_trx_sub_type_rec => l_txn_sub_type_rec,
865: x_return_status => l_return_status) ;
866:
867: IF l_return_status <> fnd_api.g_ret_sts_success THEN
868: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
869: fnd_message.set_token('MESSAGE','Call to the routine csi_utl_pkg.get_sub_type_rec Failed.');
870: fnd_msg_pub.add;
871: raise fnd_api.g_exc_error;
872: END IF;

Line 869: fnd_message.set_token('MESSAGE','Call to the routine csi_utl_pkg.get_sub_type_rec Failed.');

865: x_return_status => l_return_status) ;
866:
867: IF l_return_status <> fnd_api.g_ret_sts_success THEN
868: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
869: fnd_message.set_token('MESSAGE','Call to the routine csi_utl_pkg.get_sub_type_rec Failed.');
870: fnd_msg_pub.add;
871: raise fnd_api.g_exc_error;
872: END IF;
873:

Line 879: fnd_message.set_name('CSI','CSI_SUB_TYPE_INVALID');

875: debug(' default sub_type_id :'||l_txn_sub_type_rec.sub_type_id );
876:
877: --Fix for bug 4243512
878: IF l_txn_sub_type_rec.src_change_owner = 'Y' THEN
879: fnd_message.set_name('CSI','CSI_SUB_TYPE_INVALID');
880: fnd_msg_pub.add;
881: raise fnd_api.g_exc_error;
882: END IF;
883: --end of fix.

Line 942: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

938: END IF;
939: END LOOP;
940: ELSE
941: debug('Instance Party not found. Instance:'||l_instance_rec.instance_id);
942: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
943: fnd_message.set_token('MESSAGE','Instance Party not found. Instance:'||l_instance_rec.instance_id);
944: fnd_msg_pub.add;
945: RAISE fnd_api.g_exc_error;
946: END IF;

Line 943: fnd_message.set_token('MESSAGE','Instance Party not found. Instance:'||l_instance_rec.instance_id);

939: END LOOP;
940: ELSE
941: debug('Instance Party not found. Instance:'||l_instance_rec.instance_id);
942: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
943: fnd_message.set_token('MESSAGE','Instance Party not found. Instance:'||l_instance_rec.instance_id);
944: fnd_msg_pub.add;
945: RAISE fnd_api.g_exc_error;
946: END IF;
947:

Line 980: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');

976:
977: IF l_inst_owner_pty_id = l_internal_party_id THEN
978: --Added for bug 12417905
979: IF(l_has_rma_receipt = 'N') THEN
980: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
981: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
982: fnd_msg_pub.add;
983: RAISE fnd_api.g_exc_error;
984: END IF;

Line 981: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

977: IF l_inst_owner_pty_id = l_internal_party_id THEN
978: --Added for bug 12417905
979: IF(l_has_rma_receipt = 'N') THEN
980: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
981: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
982: fnd_msg_pub.add;
983: RAISE fnd_api.g_exc_error;
984: END IF;
985: ELSE

Line 988: fnd_message.set_name('CSI', 'CSI_NON_RETURNABLE_INSTANCE');

984: END IF;
985: ELSE
986: --STARTS , bug no. 10007311 --modified the fix of bug 10007311, while making the changes for bug 12417905
987: IF(l_has_rma_receipt = 'N') THEN
988: fnd_message.set_name('CSI', 'CSI_NON_RETURNABLE_INSTANCE');
989: fnd_message.set_token('LOC_TYPE_CODE', l_instance_rec.location_type_code);
990: fnd_msg_pub.add;
991: raise fnd_api.g_exc_error;
992: END IF;

Line 989: fnd_message.set_token('LOC_TYPE_CODE', l_instance_rec.location_type_code);

985: ELSE
986: --STARTS , bug no. 10007311 --modified the fix of bug 10007311, while making the changes for bug 12417905
987: IF(l_has_rma_receipt = 'N') THEN
988: fnd_message.set_name('CSI', 'CSI_NON_RETURNABLE_INSTANCE');
989: fnd_message.set_token('LOC_TYPE_CODE', l_instance_rec.location_type_code);
990: fnd_msg_pub.add;
991: raise fnd_api.g_exc_error;
992: END IF;
993: --ENDS bug no. 10007311

Line 1023: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');

1019: debug('Internal party : '||l_internal_party_id);
1020:
1021: IF l_inst_owner_pty_id = l_internal_party_id THEN
1022: IF nvl(l_txn_sub_type_rec.src_change_owner, 'N') = 'Y' THEN
1023: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
1024: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1025: fnd_msg_pub.add;
1026: RAISE fnd_api.g_exc_error;
1027: END IF;

Line 1024: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

1020:
1021: IF l_inst_owner_pty_id = l_internal_party_id THEN
1022: IF nvl(l_txn_sub_type_rec.src_change_owner, 'N') = 'Y' THEN
1023: fnd_message.set_name('CSI','CSI_INT_INST_REF_INVALID');
1024: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1025: fnd_msg_pub.add;
1026: RAISE fnd_api.g_exc_error;
1027: END IF;
1028: ELSIF l_inst_owner_pty_id <> l_src_txn_owner_pty_id THEN

Line 1102: fnd_message.set_name('CSI','CSI_RMA_OWNER_MISMATCH');

1098: END IF;
1099:
1100: debug('Ownership Changed Successfully.');
1101: ELSE
1102: fnd_message.set_name('CSI','CSI_RMA_OWNER_MISMATCH');
1103: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );
1104: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );
1105: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );
1106: fnd_msg_pub.add;

Line 1103: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );

1099:
1100: debug('Ownership Changed Successfully.');
1101: ELSE
1102: fnd_message.set_name('CSI','CSI_RMA_OWNER_MISMATCH');
1103: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );
1104: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );
1105: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );
1106: fnd_msg_pub.add;
1107: RAISE fnd_api.g_exc_error;

Line 1104: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );

1100: debug('Ownership Changed Successfully.');
1101: ELSE
1102: fnd_message.set_name('CSI','CSI_RMA_OWNER_MISMATCH');
1103: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );
1104: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );
1105: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );
1106: fnd_msg_pub.add;
1107: RAISE fnd_api.g_exc_error;
1108: END IF;

Line 1105: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );

1101: ELSE
1102: fnd_message.set_name('CSI','CSI_RMA_OWNER_MISMATCH');
1103: fnd_message.set_token('INSTANCE_ID', l_instance_rec.instance_id );
1104: fnd_message.set_token('OLD_PARTY_ID', l_inst_owner_pty_id );
1105: fnd_message.set_token('NEW_PARTY_ID', l_src_txn_owner_pty_id );
1106: fnd_msg_pub.add;
1107: RAISE fnd_api.g_exc_error;
1108: END IF;
1109: END IF;

Line 1162: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

1158: FROM csi_item_instances
1159: WHERE instance_id = l_instance_rec.instance_id;
1160: Exception when others then
1161: debug('Fetch instance details failed ...');
1162: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1163: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1164: fnd_msg_pub.add;
1165: raise fnd_api.g_exc_unexpected_error;
1166: End;

Line 1163: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

1159: WHERE instance_id = l_instance_rec.instance_id;
1160: Exception when others then
1161: debug('Fetch instance details failed ...');
1162: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1163: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1164: fnd_msg_pub.add;
1165: raise fnd_api.g_exc_unexpected_error;
1166: End;
1167:

Line 1227: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

1223: and organization_id = l_dest_location_rec.inv_organization_id;--l_txn_line_dtl_rec.inv_organization_id;
1224: -- bug 3230999. since OM is always passing master inv.
1225: Exception when others Then
1226: debug('Could not determine serial control policy?');
1227: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1228: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1229: fnd_msg_pub.add;
1230: RAISE fnd_api.g_exc_unexpected_error;
1231: End;

Line 1228: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

1224: -- bug 3230999. since OM is always passing master inv.
1225: Exception when others Then
1226: debug('Could not determine serial control policy?');
1227: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1228: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1229: fnd_msg_pub.add;
1230: RAISE fnd_api.g_exc_unexpected_error;
1231: End;
1232:

Line 1238: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');

1234: IF ( nvl(l_instance_rec.active_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1235: AND l_instance_rec.active_end_date < sysdate ) THEN -- Added this new check, IF as part of 3746600
1236: IF l_instance_rec.instance_usage_code <> 'IN_RELATIONSHIP' THEN
1237: -- ONLY excluding Components since they get expired along with their parent in a config cancellation
1238: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
1239: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1240: fnd_msg_pub.add;
1241: RAISE fnd_api.g_exc_error;
1242: END IF;

Line 1239: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

1235: AND l_instance_rec.active_end_date < sysdate ) THEN -- Added this new check, IF as part of 3746600
1236: IF l_instance_rec.instance_usage_code <> 'IN_RELATIONSHIP' THEN
1237: -- ONLY excluding Components since they get expired along with their parent in a config cancellation
1238: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
1239: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1240: fnd_msg_pub.add;
1241: RAISE fnd_api.g_exc_error;
1242: END IF;
1243: ELSIF l_item_srl_code = 1 THEN

Line 1246: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');

1242: END IF;
1243: ELSIF l_item_srl_code = 1 THEN
1244: IF abs(l_txn_line_dtl_rec.quantity) > l_instance_rec.quantity THEN
1245: -- check if the quantity is greater than the instance quantity
1246: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
1247: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1248: fnd_msg_pub.add;
1249: RAISE fnd_api.g_exc_error;
1250: ELSIF l_instance_rec.quantity > abs(l_txn_line_dtl_rec.quantity) THEN -- need to split the source cust prod first

Line 1247: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

1243: ELSIF l_item_srl_code = 1 THEN
1244: IF abs(l_txn_line_dtl_rec.quantity) > l_instance_rec.quantity THEN
1245: -- check if the quantity is greater than the instance quantity
1246: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
1247: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
1248: fnd_msg_pub.add;
1249: RAISE fnd_api.g_exc_error;
1250: ELSIF l_instance_rec.quantity > abs(l_txn_line_dtl_rec.quantity) THEN -- need to split the source cust prod first
1251: debug('Original Instance Quantity: '||l_instance_rec.quantity);

Line 1578: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

1574: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1575: debug(l_error_message);
1576: WHEN fnd_api.g_exc_unexpected_error THEN
1577: rollback to fulfill_rma_line;
1578: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1579: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1580: fnd_msg_pub.add;
1581: x_return_status := fnd_api.g_ret_sts_error;
1582: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1579: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));

1575: debug(l_error_message);
1576: WHEN fnd_api.g_exc_unexpected_error THEN
1577: rollback to fulfill_rma_line;
1578: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1579: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,255));
1580: fnd_msg_pub.add;
1581: x_return_status := fnd_api.g_ret_sts_error;
1582: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1583: debug(l_error_message);