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_MSG_PUB

Line 59: fnd_msg_pub.add;

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:
63: EXCEPTION

Line 66: x_error_message := fnd_msg_pub.get;

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
70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 72: fnd_msg_pub.add;

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;
76:

Line 74: x_error_message := fnd_msg_pub.get;

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;
76:
77: END get_rma_info;
78:

Line 108: fnd_msg_pub.add;

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:
112: get_rma_info(

Line 129: x_error_message := fnd_msg_pub.get;

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:
132: debug(x_error_message);
133:

Line 139: fnd_msg_pub.add;

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;
143:

Line 141: x_error_message := fnd_msg_pub.get;

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;
143:
144: debug(x_error_message);
145:

Line 208: fnd_msg_pub.initialize;

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:
210: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
211:
212: api_log(l_api_name);

Line 254: fnd_msg_pub.add;

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:
258: l_error_rec.source_line_ref_id := l_rma_line_rec.line_id;

Line 275: fnd_msg_pub.add;

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
279: l_orgn_id := l_rma_line_rec.sold_from_org_id;

Line 306: fnd_msg_pub.add;

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);
310: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

Line 312: fnd_msg_pub.add;

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:
316: l_error_rec.inventory_item_id := l_rma_line_rec.inventory_item_id;

Line 337: fnd_msg_pub.add;

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(
341: 'OEOL' -- ITEM_TYPE

Line 368: fnd_msg_pub.add;

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
372: debug('Transaction Detail Found for the RMA line.');

Line 385: fnd_msg_pub.add;

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:
389: UPDATE csi_t_transaction_lines

Line 469: fnd_msg_pub.add;

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);
473: debug('Total Source Txn Details Qty : '||l_tld_quantity);

Line 532: fnd_msg_pub.add;

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:
536: EXCEPTION

Line 562: fnd_msg_pub.add;

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;
566:

Line 718: fnd_msg_pub.initialize;

714: l_last_txn_type_id NUMBER; --Added for bug 12417905
715: BEGIN
716: x_return_status := fnd_api.g_ret_sts_success;
717: savepoint fulfill_rma_line;
718: fnd_msg_pub.initialize;
719:
720: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
721:
722: csi_t_gen_utility_pvt.dump_api_info(

Line 745: fnd_msg_pub.add;

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:
749: l_csi_trxn_rec := p_csi_txn_rec;

Line 844: fnd_msg_pub.add;

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
848:

Line 853: fnd_msg_pub.add;

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;
857: END IF;

Line 870: fnd_msg_pub.add;

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:
874: debug(' transaction_type_id :'||l_txn_sub_type_rec.trx_type_id );

Line 880: fnd_msg_pub.add;

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.
884:

Line 944: fnd_msg_pub.add;

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:
948:

Line 982: fnd_msg_pub.add;

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
986: --STARTS , bug no. 10007311 --modified the fix of bug 10007311, while making the changes for bug 12417905

Line 990: fnd_msg_pub.add;

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
994: END IF;

Line 1025: fnd_msg_pub.add;

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
1029: IF l_pty_override_flag = 'Y' THEN

Line 1106: fnd_msg_pub.add;

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;
1110: /* Bug 3746600. Since Cancellation is always a expiry now, we do not need the code below. commenting.

Line 1164: fnd_msg_pub.add;

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:
1168: csi_t_gen_utility_pvt.dump_api_info(

Line 1229: fnd_msg_pub.add;

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:
1233: l_p_instances_tbl(l_td_ind).instance_id := l_txn_line_dtl_rec.instance_id;

Line 1240: fnd_msg_pub.add;

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
1244: IF abs(l_txn_line_dtl_rec.quantity) > l_instance_rec.quantity THEN

Line 1248: fnd_msg_pub.add;

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);
1252: l_quantity1 := l_instance_rec.quantity - abs(l_txn_line_dtl_rec.quantity) ;

Line 1580: fnd_msg_pub.add;

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);
1584: END fulfill_rma_line;