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_T_TXN_LINE_DTLS_PVT dependencies on FND_MESSAGE

Line 195: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');

191:
192: IF l_return_status <> fnd_api.g_ret_sts_success THEN
193: debug('Validate sub type id failed.');
194:
195: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
196: fnd_message.set_token('SUB_TYPE_ID',p_txn_line_dtl_rec.sub_type_id);
197: fnd_msg_pub.add;
198: raise fnd_api.g_exc_error;
199:

Line 196: fnd_message.set_token('SUB_TYPE_ID',p_txn_line_dtl_rec.sub_type_id);

192: IF l_return_status <> fnd_api.g_ret_sts_success THEN
193: debug('Validate sub type id failed.');
194:
195: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
196: fnd_message.set_token('SUB_TYPE_ID',p_txn_line_dtl_rec.sub_type_id);
197: fnd_msg_pub.add;
198: raise fnd_api.g_exc_error;
199:
200: END IF;

Line 235: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');

231: IF l_return_status <> fnd_api.g_ret_sts_success THEN
232:
233: debug('Validate instance id failed.');
234:
235: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
236: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.instance_id);
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239:

Line 236: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.instance_id);

232:
233: debug('Validate instance id failed.');
234:
235: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
236: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.instance_id);
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239:
240: END IF;

Line 340: fnd_message.set_name('CSI','CSI_TXN_QTY_INVALID');

336: l_quantity := p_txn_line_dtl_rec.quantity;
337:
338: -- validate quantity
339: IF nvl(l_quantity,0) <= 0 THEN
340: fnd_message.set_name('CSI','CSI_TXN_QTY_INVALID');
341: fnd_message.set_token('ITEM_ID',p_txn_line_dtl_rec.inventory_item_id);
342: fnd_message.set_token('QTY',l_quantity);
343: fnd_msg_pub.add;
344: raise fnd_api.g_exc_error;

Line 341: fnd_message.set_token('ITEM_ID',p_txn_line_dtl_rec.inventory_item_id);

337:
338: -- validate quantity
339: IF nvl(l_quantity,0) <= 0 THEN
340: fnd_message.set_name('CSI','CSI_TXN_QTY_INVALID');
341: fnd_message.set_token('ITEM_ID',p_txn_line_dtl_rec.inventory_item_id);
342: fnd_message.set_token('QTY',l_quantity);
343: fnd_msg_pub.add;
344: raise fnd_api.g_exc_error;
345: END IF;

Line 342: fnd_message.set_token('QTY',l_quantity);

338: -- validate quantity
339: IF nvl(l_quantity,0) <= 0 THEN
340: fnd_message.set_name('CSI','CSI_TXN_QTY_INVALID');
341: fnd_message.set_token('ITEM_ID',p_txn_line_dtl_rec.inventory_item_id);
342: fnd_message.set_token('QTY',l_quantity);
343: fnd_msg_pub.add;
344: raise fnd_api.g_exc_error;
345: END IF;
346:

Line 534: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');

530: IF l_return_status <> fnd_api.g_ret_sts_success THEN
531:
532: debug('Validate instance id failed.');
533:
534: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
535: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.parent_instance_id);
536: fnd_msg_pub.add;
537: RAISE fnd_api.g_exc_error;
538:

Line 535: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.parent_instance_id);

531:
532: debug('Validate instance id failed.');
533:
534: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
535: FND_MESSAGE.set_token('INSTANCE_ID',p_txn_line_dtl_rec.parent_instance_id);
536: fnd_msg_pub.add;
537: RAISE fnd_api.g_exc_error;
538:
539: END IF;

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

692: p_overriding_csi_txn_id => p_txn_line_dtl_rec.overriding_csi_txn_id,
693: p_instance_status_id => p_txn_line_dtl_rec.instance_status_id);
694: exception
695: when others then
696: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
697: fnd_message.set_token('MESSAGE',
698: 'csi_t_txn_line_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
699: fnd_msg_pub.add;
700: raise fnd_api.g_exc_error;

Line 697: fnd_message.set_token('MESSAGE',

693: p_instance_status_id => p_txn_line_dtl_rec.instance_status_id);
694: exception
695: when others then
696: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
697: fnd_message.set_token('MESSAGE',
698: 'csi_t_txn_line_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
699: fnd_msg_pub.add;
700: raise fnd_api.g_exc_error;
701: end;

Line 1105: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');

1101: x_return_status => l_return_status);
1102:
1103: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1104:
1105: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1106: FND_MESSAGE.set_token('LINE_DTL_ID',l_td_rec.txn_line_detail_id);
1107: fnd_msg_pub.add;
1108: RAISE fnd_api.g_exc_error;
1109:

Line 1106: FND_MESSAGE.set_token('LINE_DTL_ID',l_td_rec.txn_line_detail_id);

1102:
1103: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1104:
1105: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1106: FND_MESSAGE.set_token('LINE_DTL_ID',l_td_rec.txn_line_detail_id);
1107: fnd_msg_pub.add;
1108: RAISE fnd_api.g_exc_error;
1109:
1110: END IF;

Line 1126: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');

1122: WHERE instance_hdr_id = l_td_rec.config_inst_hdr_id
1123: AND instance_rev_nbr = l_td_rec.config_inst_rev_num
1124: AND config_item_id = l_td_rec.config_inst_item_id;
1125: Exception when no_data_found then
1126: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
1127: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
1128: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
1130: fnd_msg_pub.add;

Line 1127: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);

1123: AND instance_rev_nbr = l_td_rec.config_inst_rev_num
1124: AND config_item_id = l_td_rec.config_inst_item_id;
1125: Exception when no_data_found then
1126: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
1127: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
1128: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
1130: fnd_msg_pub.add;
1131: RAISE fnd_api.g_exc_error;

Line 1128: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);

1124: AND config_item_id = l_td_rec.config_inst_item_id;
1125: Exception when no_data_found then
1126: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
1127: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
1128: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
1130: fnd_msg_pub.add;
1131: RAISE fnd_api.g_exc_error;
1132: when others then

Line 1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);

1125: Exception when no_data_found then
1126: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
1127: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
1128: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
1130: fnd_msg_pub.add;
1131: RAISE fnd_api.g_exc_error;
1132: when others then
1133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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

1129: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
1130: fnd_msg_pub.add;
1131: RAISE fnd_api.g_exc_error;
1132: when others then
1133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1134: fnd_message.set_token('MESSAGE',
1135: 'Error in getting Config Inst data Check Failed. '||substr(sqlerrm,1,200));
1136: fnd_msg_pub.add;
1137: RAISE fnd_api.g_exc_error;

Line 1134: fnd_message.set_token('MESSAGE',

1130: fnd_msg_pub.add;
1131: RAISE fnd_api.g_exc_error;
1132: when others then
1133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1134: fnd_message.set_token('MESSAGE',
1135: 'Error in getting Config Inst data Check Failed. '||substr(sqlerrm,1,200));
1136: fnd_msg_pub.add;
1137: RAISE fnd_api.g_exc_error;
1138: End;

Line 1186: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');

1182:
1183: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1184:
1185: debug('Validate sub type id failed.');
1186: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
1187: fnd_message.set_token('SUB_TYPE_ID',l_td_rec.sub_type_id);
1188: fnd_msg_pub.add;
1189: raise fnd_api.g_exc_error;
1190:

Line 1187: fnd_message.set_token('SUB_TYPE_ID',l_td_rec.sub_type_id);

1183: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1184:
1185: debug('Validate sub type id failed.');
1186: fnd_message.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
1187: fnd_message.set_token('SUB_TYPE_ID',l_td_rec.sub_type_id);
1188: fnd_msg_pub.add;
1189: raise fnd_api.g_exc_error;
1190:
1191: END IF;

Line 1240: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');

1236: x_return_status => l_return_status);
1237:
1238: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1239:
1240: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
1241: FND_MESSAGE.set_token('INSTANCE_ID',l_td_rec.instance_id);
1242: fnd_msg_pub.add;
1243: RAISE fnd_api.g_exc_error;
1244:

Line 1241: FND_MESSAGE.set_token('INSTANCE_ID',l_td_rec.instance_id);

1237:
1238: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1239:
1240: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
1241: FND_MESSAGE.set_token('INSTANCE_ID',l_td_rec.instance_id);
1242: fnd_msg_pub.add;
1243: RAISE fnd_api.g_exc_error;
1244:
1245: END IF;

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

2160: p_overriding_csi_txn_id => l_td_rec.overriding_csi_txn_id,
2161: p_instance_status_id => l_td_rec.instance_status_id);
2162: exception
2163: when others then
2164: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2165: fnd_message.set_token('MESSAGE',
2166: 'csi_t_txn_line_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
2167: fnd_msg_pub.add;
2168: raise fnd_api.g_exc_error;

Line 2165: fnd_message.set_token('MESSAGE',

2161: p_instance_status_id => l_td_rec.instance_status_id);
2162: exception
2163: when others then
2164: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2165: fnd_message.set_token('MESSAGE',
2166: 'csi_t_txn_line_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
2167: fnd_msg_pub.add;
2168: raise fnd_api.g_exc_error;
2169: end;

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

2809: END IF;
2810:
2811: EXCEPTION
2812: WHEN others THEN
2813: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2814: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2815: fnd_msg_pub.add;
2816: x_return_status := fnd_api.g_ret_sts_error;
2817:

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

2810:
2811: EXCEPTION
2812: WHEN others THEN
2813: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2814: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2815: fnd_msg_pub.add;
2816: x_return_status := fnd_api.g_ret_sts_error;
2817:
2818: END bind_query_variables;

Line 3517: fnd_message.set_name('CSI','CSI_TXN_SRC_INFO_MISSING');

3513: IF nvl(p_txn_line_rec.source_transaction_table, fnd_api.g_miss_char) = fnd_api.g_miss_char
3514: OR
3515: nvl(p_txn_line_rec.source_transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
3516:
3517: fnd_message.set_name('CSI','CSI_TXN_SRC_INFO_MISSING');
3518: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3519: fnd_message.set_token('SRC_ID',p_txn_line_rec.source_transaction_id);
3520: fnd_msg_pub.add;
3521: RAISE fnd_api.g_exc_error;

Line 3518: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);

3514: OR
3515: nvl(p_txn_line_rec.source_transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
3516:
3517: fnd_message.set_name('CSI','CSI_TXN_SRC_INFO_MISSING');
3518: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3519: fnd_message.set_token('SRC_ID',p_txn_line_rec.source_transaction_id);
3520: fnd_msg_pub.add;
3521: RAISE fnd_api.g_exc_error;
3522:

Line 3519: fnd_message.set_token('SRC_ID',p_txn_line_rec.source_transaction_id);

3515: nvl(p_txn_line_rec.source_transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
3516:
3517: fnd_message.set_name('CSI','CSI_TXN_SRC_INFO_MISSING');
3518: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3519: fnd_message.set_token('SRC_ID',p_txn_line_rec.source_transaction_id);
3520: fnd_msg_pub.add;
3521: RAISE fnd_api.g_exc_error;
3522:
3523: ELSE

Line 3536: fnd_message.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');

3532:
3533: EXCEPTION
3534: WHEN no_data_found THEN
3535:
3536: fnd_message.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
3537: fnd_message.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
3538: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3539: fnd_msg_pub.add;
3540: RAISE fnd_api.g_exc_error;

Line 3537: fnd_message.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);

3533: EXCEPTION
3534: WHEN no_data_found THEN
3535:
3536: fnd_message.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
3537: fnd_message.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
3538: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3539: fnd_msg_pub.add;
3540: RAISE fnd_api.g_exc_error;
3541: END;

Line 3538: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);

3534: WHEN no_data_found THEN
3535:
3536: fnd_message.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
3537: fnd_message.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
3538: fnd_message.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
3539: fnd_msg_pub.add;
3540: RAISE fnd_api.g_exc_error;
3541: END;
3542:

Line 3559: fnd_message.set_name('CSI','CSI_TXN_LINE_ID_INVALID');

3555: x_transaction_line_rec => l_transaction_line_rec, -- changed for Mass Update R12
3556: x_return_status => l_return_status);
3557:
3558: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3559: fnd_message.set_name('CSI','CSI_TXN_LINE_ID_INVALID');
3560: fnd_message.set_token('TXN_LINE_ID', l_txn_line_rec.transaction_line_id);
3561: fnd_msg_pub.add;
3562: raise fnd_api.g_exc_error;
3563: END IF;

Line 3560: fnd_message.set_token('TXN_LINE_ID', l_txn_line_rec.transaction_line_id);

3556: x_return_status => l_return_status);
3557:
3558: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3559: fnd_message.set_name('CSI','CSI_TXN_LINE_ID_INVALID');
3560: fnd_message.set_token('TXN_LINE_ID', l_txn_line_rec.transaction_line_id);
3561: fnd_msg_pub.add;
3562: raise fnd_api.g_exc_error;
3563: END IF;
3564: