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