DBA Data[Home] [Help]

APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on FND_MESSAGE

Line 80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)
77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;
82: FND_MSG_PUB.add;
83: RAISE FND_API.g_exc_error;
84: END IF ;

Line 81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;

77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;
82: FND_MSG_PUB.add;
83: RAISE FND_API.g_exc_error;
84: END IF ;
85:

Line 206: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

202:
203: -- Added for M-M to make sure correctly initialized params are passed for the validate_txn_rltnshp routine call down below Start
204:
205: IF p_txn_ii_rltns_rec.subject_type not in ('T', 'I') THEN
206: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);
208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN

Line 207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);

203: -- Added for M-M to make sure correctly initialized params are passed for the validate_txn_rltnshp routine call down below Start
204:
205: IF p_txn_ii_rltns_rec.subject_type not in ('T', 'I') THEN
206: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);
208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

Line 211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);
208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);
213: FND_MSG_PUB.add;
214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'

Line 212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);

208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);
213: FND_MSG_PUB.add;
214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN

Line 217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

213: FND_MSG_PUB.add;
214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);
219: FND_MSG_PUB.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: RAISE fnd_api.g_exc_error;

Line 218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);

214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);
219: FND_MSG_PUB.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: RAISE fnd_api.g_exc_error;
222: ELSIF NOT(p_txn_ii_rltns_rec.subject_type = 'T'

Line 245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');

241: x_return_status => l_return_status);
242:
243: IF l_return_status <> fnd_api.g_ret_sts_success THEN
244:
245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);
247: FND_MSG_PUB.add;
248: RAISE fnd_api.g_exc_error;
249:

Line 246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);

242:
243: IF l_return_status <> fnd_api.g_ret_sts_success THEN
244:
245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);
247: FND_MSG_PUB.add;
248: RAISE fnd_api.g_exc_error;
249:
250: END IF;

Line 267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');

263: x_return_status => l_return_status);
264:
265: IF l_return_status <> fnd_api.g_ret_sts_success THEN
266:
267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);
269: FND_MSG_PUB.add;
270: RAISE fnd_api.g_exc_error;
271:

Line 268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);

264:
265: IF l_return_status <> fnd_api.g_ret_sts_success THEN
266:
267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);
269: FND_MSG_PUB.add;
270: RAISE fnd_api.g_exc_error;
271:
272: END IF;

Line 284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');

280: p_rltns_type_code => p_txn_ii_rltns_rec.relationship_type_code,
281: x_return_status => l_return_status);
282:
283: IF l_return_status = fnd_api.g_ret_sts_error THEN
284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
285: FND_MESSAGE.set_token('RLTNS_CODE',
286: p_txn_ii_rltns_rec.relationship_type_code);
287: FND_MSG_PUB.add;
288: RAISE fnd_api.g_exc_error;

Line 285: FND_MESSAGE.set_token('RLTNS_CODE',

281: x_return_status => l_return_status);
282:
283: IF l_return_status = fnd_api.g_ret_sts_error THEN
284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
285: FND_MESSAGE.set_token('RLTNS_CODE',
286: p_txn_ii_rltns_rec.relationship_type_code);
287: FND_MSG_PUB.add;
288: RAISE fnd_api.g_exc_error;
289: END IF;

Line 311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');

307: -- Validate transfer_components
308: IF p_txn_ii_rltns_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
309: IF p_txn_ii_rltns_rec.relationship_type_code
310: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');

Line 312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');

308: IF p_txn_ii_rltns_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
309: IF p_txn_ii_rltns_rec.relationship_type_code
310: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
316: FND_MSG_PUB.add;

Line 313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);

309: IF p_txn_ii_rltns_rec.relationship_type_code
310: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
316: FND_MSG_PUB.add;
317: p_txn_ii_rltns_rec.transfer_components_flag := fnd_api.g_miss_char;

Line 314: FND_MESSAGE.set_token('REASON','This attribute is applicable to

310: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
316: FND_MSG_PUB.add;
317: p_txn_ii_rltns_rec.transfer_components_flag := fnd_api.g_miss_char;
318: END IF;

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

405: p_transfer_components_flag => p_txn_ii_rltns_rec.transfer_components_flag);
406:
407: exception
408: when others then
409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
410: fnd_message.set_token('MESSAGE',
411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;

Line 410: fnd_message.set_token('MESSAGE',

406:
407: exception
408: when others then
409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
410: fnd_message.set_token('MESSAGE',
411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: end;

Line 563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');

559: x_return_status => l_return_status);
560:
561: IF l_return_status <> fnd_api.g_ret_sts_success THEN
562:
563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);
565: FND_MSG_PUB.add;
566: RAISE fnd_api.g_exc_error;
567:

Line 564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);

560:
561: IF l_return_status <> fnd_api.g_ret_sts_success THEN
562:
563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);
565: FND_MSG_PUB.add;
566: RAISE fnd_api.g_exc_error;
567:
568: END IF;

Line 588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)
585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;
590: FND_MSG_PUB.add;
591: RAISE FND_API.g_exc_error;
592: END IF ;

Line 589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;

585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;
590: FND_MSG_PUB.add;
591: RAISE FND_API.g_exc_error;
592: END IF ;
593:

Line 680: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

676:
677: -- Added for M-M to make sure correctly initialized params are passed for the validate_txn_rltnshp routine call down below
678:
679: IF l_iir_rec.subject_type not in ('T', 'I') THEN
680: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);
682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN

Line 681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);

677: -- Added for M-M to make sure correctly initialized params are passed for the validate_txn_rltnshp routine call down below
678:
679: IF l_iir_rec.subject_type not in ('T', 'I') THEN
680: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);
682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

Line 685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');

681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);
682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);
687: FND_MSG_PUB.add;
688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'

Line 686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);

682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);
687: FND_MSG_PUB.add;
688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN

Line 691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

687: FND_MSG_PUB.add;
688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: RAISE fnd_api.g_exc_error;

Line 692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);

688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: RAISE fnd_api.g_exc_error;
696: ELSIF NOT(l_iir_rec.subject_type = 'T'

Line 715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');

711: x_return_status => l_return_status);
712:
713: IF l_return_status <> fnd_api.g_ret_sts_success THEN
714:
715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);
717: FND_MSG_PUB.add;
718: RAISE fnd_api.g_exc_error;
719:

Line 716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);

712:
713: IF l_return_status <> fnd_api.g_ret_sts_success THEN
714:
715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);
717: FND_MSG_PUB.add;
718: RAISE fnd_api.g_exc_error;
719:
720: END IF;

Line 734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');

730: x_return_status => l_return_status);
731:
732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
733:
734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);
736: FND_MSG_PUB.add;
737: RAISE fnd_api.g_exc_error;
738:

Line 735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);

731:
732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
733:
734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);
736: FND_MSG_PUB.add;
737: RAISE fnd_api.g_exc_error;
738:
739: END IF;

Line 753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');

749: AND tl.transaction_line_id = tld.transaction_line_id;
750:
751: IF l_processing_status = 'PROCESSED' THEN
752:
753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
755: FND_MESSAGE.set_token('STATUS',l_processing_status);
756: FND_MSG_PUB.add;
757: RAISE FND_API.g_exc_error;

Line 754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);

750:
751: IF l_processing_status = 'PROCESSED' THEN
752:
753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
755: FND_MESSAGE.set_token('STATUS',l_processing_status);
756: FND_MSG_PUB.add;
757: RAISE FND_API.g_exc_error;
758:

Line 755: FND_MESSAGE.set_token('STATUS',l_processing_status);

751: IF l_processing_status = 'PROCESSED' THEN
752:
753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
755: FND_MESSAGE.set_token('STATUS',l_processing_status);
756: FND_MSG_PUB.add;
757: RAISE FND_API.g_exc_error;
758:
759: ELSIF l_iir_rec.object_type = 'T' THEN

Line 769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');

765: AND tl.transaction_line_id = tld.transaction_line_id;
766:
767: IF l_processing_status = 'PROCESSED' THEN
768:
769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
771: FND_MESSAGE.set_token('STATUS',l_processing_status);
772: FND_MSG_PUB.add;
773: RAISE FND_API.g_exc_error;

Line 770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);

766:
767: IF l_processing_status = 'PROCESSED' THEN
768:
769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
771: FND_MESSAGE.set_token('STATUS',l_processing_status);
772: FND_MSG_PUB.add;
773: RAISE FND_API.g_exc_error;
774: END IF;

Line 771: FND_MESSAGE.set_token('STATUS',l_processing_status);

767: IF l_processing_status = 'PROCESSED' THEN
768:
769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
771: FND_MESSAGE.set_token('STATUS',l_processing_status);
772: FND_MSG_PUB.add;
773: RAISE FND_API.g_exc_error;
774: END IF;
775: END IF;

Line 786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');

782: AND tl.transaction_line_id = tld.transaction_line_id;
783:
784: IF l_processing_status = 'PROCESSED' THEN
785:
786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
788: FND_MESSAGE.set_token('STATUS',l_processing_status);
789: FND_MSG_PUB.add;
790: RAISE FND_API.g_exc_error;

Line 787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);

783:
784: IF l_processing_status = 'PROCESSED' THEN
785:
786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
788: FND_MESSAGE.set_token('STATUS',l_processing_status);
789: FND_MSG_PUB.add;
790: RAISE FND_API.g_exc_error;
791: END IF;

Line 788: FND_MESSAGE.set_token('STATUS',l_processing_status);

784: IF l_processing_status = 'PROCESSED' THEN
785:
786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
788: FND_MESSAGE.set_token('STATUS',l_processing_status);
789: FND_MSG_PUB.add;
790: RAISE FND_API.g_exc_error;
791: END IF;
792:

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

791: END IF;
792:
793: END IF;
794: Exception when others then
795: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
796: fnd_message.set_token('MESSAGE',
797: 'Unhandled exception in Update Txn reltns'||substr(sqlerrm,1,200));
798: fnd_msg_pub.add;
799: raise fnd_api.g_exc_error;

Line 796: fnd_message.set_token('MESSAGE',

792:
793: END IF;
794: Exception when others then
795: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
796: fnd_message.set_token('MESSAGE',
797: 'Unhandled exception in Update Txn reltns'||substr(sqlerrm,1,200));
798: fnd_msg_pub.add;
799: raise fnd_api.g_exc_error;
800: END;

Line 813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');

809: x_return_status => l_return_status);
810:
811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
812:
813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);
815: FND_MSG_PUB.add;
816: RAISE fnd_api.g_exc_error;
817:

Line 814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);

810:
811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
812:
813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);
815: FND_MSG_PUB.add;
816: RAISE fnd_api.g_exc_error;
817:
818: END IF;

Line 830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');

826:
827: IF l_iir_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
828: IF l_iir_rec.relationship_type_code
829: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');

Line 831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');

827: IF l_iir_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
828: IF l_iir_rec.relationship_type_code
829: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
835: FND_MSG_PUB.add;

Line 832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);

828: IF l_iir_rec.relationship_type_code
829: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
835: FND_MSG_PUB.add;
836: l_iir_rec.transfer_components_flag := fnd_api.g_miss_char;

Line 833: FND_MESSAGE.set_token('REASON','This attribute is applicable to

829: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
835: FND_MSG_PUB.add;
836: l_iir_rec.transfer_components_flag := fnd_api.g_miss_char;
837: END IF;

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

956: p_transfer_components_flag => l_iir_rec.transfer_components_flag);
957:
958: exception
959: when others then
960: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
961: fnd_message.set_token('MESSAGE',
962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));
963: fnd_msg_pub.add;
964: raise fnd_api.g_exc_error;

Line 961: fnd_message.set_token('MESSAGE',

957:
958: exception
959: when others then
960: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
961: fnd_message.set_token('MESSAGE',
962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));
963: fnd_msg_pub.add;
964: raise fnd_api.g_exc_error;
965: end;

Line 1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');

1096: x_return_status => l_return_status);
1097:
1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1099:
1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);
1102: FND_MSG_PUB.add;
1103: RAISE fnd_api.g_exc_error;
1104:

Line 1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);

1097:
1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1099:
1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);
1102: FND_MSG_PUB.add;
1103: RAISE fnd_api.g_exc_error;
1104:
1105: END IF;