[Home] [Help]
108: -- ******************************************************************
109:
110: IF p_instance_id IS NULL
111: THEN
112: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
113: fnd_msg_pub.add;
114: x_return_status := fnd_api.g_ret_sts_error;
115: RAISE fnd_api.g_exc_error;
116: END IF;
1833: IF l_object_id IS NULL AND
1834: l_subject_id IS NULL AND
1835: l_relationship_id IS NULL AND
1836: l_rel_type_code IS NULL THEN
1837: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
1838: fnd_msg_pub.add;
1839: x_return_status := fnd_api.g_ret_sts_error;
1840: RAISE fnd_api.g_exc_error;
1841: END IF;
2274: AND ((p_relationship_query_rec.object_id IS NULL) OR (p_relationship_query_rec.object_id = fnd_api.g_miss_num))
2275: AND ((p_relationship_query_rec.subject_id IS NULL) OR (p_relationship_query_rec.subject_id = fnd_api.g_miss_num))
2276: )
2277: THEN
2278: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
2279: fnd_msg_pub.add;
2280: x_return_status := fnd_api.g_ret_sts_error;
2281: RAISE fnd_api.g_exc_error;
2282: END IF;
2290: AND p_relationship_query_rec.subject_id <> fnd_api.g_miss_num)
2291: AND (p_relationship_query_rec.object_id IS NOT NULL
2292: AND p_relationship_query_rec.object_id <> fnd_api.g_miss_num)))
2293: THEN
2294: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
2295: fnd_msg_pub.add;
2296: x_return_status := fnd_api.g_ret_sts_error;
2297: RAISE fnd_api.g_exc_error;
2298: ELSIF ((p_relationship_query_rec.subject_id IS NOT NULL
2353: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2354: THEN
2355: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2356: 'Please provide a valid datetime stamp.');
2357: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2358: FND_MSG_PUB.ADD;
2359: ELSE
2360: get_history( p_rel_rec => l_rel_rec
2361: ,p_new_rec => l_new_rec
2514: IF( (p_relationship_query_rec.object_id IS NOT NULL) AND (p_relationship_query_rec.object_id <> fnd_api.g_miss_num) )
2515: THEN
2516: IF( (p_relationship_query_rec.relationship_type_code IS NULL) OR (p_relationship_query_rec.relationship_type_code = fnd_api.g_miss_char) )
2517: THEN
2518: fnd_message.set_name('CSI','CSI_NO_RELCODE_PASSED');
2519: fnd_msg_pub.add;
2520: RAISE fnd_api.g_exc_error;
2521: END IF;
2522: END IF;
2598: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2599: THEN
2600: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2601: 'Please provide a valid datetime stamp.');
2602: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2603: FND_MSG_PUB.ADD;
2604: ELSE
2605: get_history( p_rel_rec => l_rel_tbl(p_time_csr)
2606: ,p_new_rec => l_new_rec
3120: WHERE relationship_id=p_relationship_id;
3121: */
3122: IF l_configurator_id is not null
3123: THEN
3124: fnd_message.set_name('CSI','CSI_CONFIG_SET');
3125: fnd_message.set_token('relationship_id',p_relationship_id);
3126: fnd_msg_pub.add;
3127: RETURN TRUE;
3128: ELSE
3121: */
3122: IF l_configurator_id is not null
3123: THEN
3124: fnd_message.set_name('CSI','CSI_CONFIG_SET');
3125: fnd_message.set_token('relationship_id',p_relationship_id);
3126: fnd_msg_pub.add;
3127: RETURN TRUE;
3128: ELSE
3129: RETURN FALSE;
3163: --AND relationship_type_code = p_relship_type_code
3164: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3165: AND ROWNUM = 1 ;
3166: IF SQL%FOUND THEN
3167: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3168: fnd_message.set_token('relationship_type',l_relship_type_code);
3169: fnd_message.set_token('subject_id',p_subject_id);
3170: fnd_message.set_token('object_id',p_object_id);
3171: fnd_msg_pub.add;
3164: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3165: AND ROWNUM = 1 ;
3166: IF SQL%FOUND THEN
3167: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3168: fnd_message.set_token('relationship_type',l_relship_type_code);
3169: fnd_message.set_token('subject_id',p_subject_id);
3170: fnd_message.set_token('object_id',p_object_id);
3171: fnd_msg_pub.add;
3172: RETURN FALSE;
3165: AND ROWNUM = 1 ;
3166: IF SQL%FOUND THEN
3167: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3168: fnd_message.set_token('relationship_type',l_relship_type_code);
3169: fnd_message.set_token('subject_id',p_subject_id);
3170: fnd_message.set_token('object_id',p_object_id);
3171: fnd_msg_pub.add;
3172: RETURN FALSE;
3173: ELSE
3166: IF SQL%FOUND THEN
3167: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3168: fnd_message.set_token('relationship_type',l_relship_type_code);
3169: fnd_message.set_token('subject_id',p_subject_id);
3170: fnd_message.set_token('object_id',p_object_id);
3171: fnd_msg_pub.add;
3172: RETURN FALSE;
3173: ELSE
3174: RETURN TRUE;
3188: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3189: AND relationship_id<>p_relationship_id
3190: AND ROWNUM = 1 ;
3191: IF SQL%FOUND THEN
3192: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3193: fnd_message.set_token('relationship_type',l_relship_type_code);
3194: fnd_message.set_token('subject_id',p_subject_id);
3195: fnd_message.set_token('object_id',p_object_id);
3196: fnd_msg_pub.add;
3189: AND relationship_id<>p_relationship_id
3190: AND ROWNUM = 1 ;
3191: IF SQL%FOUND THEN
3192: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3193: fnd_message.set_token('relationship_type',l_relship_type_code);
3194: fnd_message.set_token('subject_id',p_subject_id);
3195: fnd_message.set_token('object_id',p_object_id);
3196: fnd_msg_pub.add;
3197: RETURN FALSE;
3190: AND ROWNUM = 1 ;
3191: IF SQL%FOUND THEN
3192: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3193: fnd_message.set_token('relationship_type',l_relship_type_code);
3194: fnd_message.set_token('subject_id',p_subject_id);
3195: fnd_message.set_token('object_id',p_object_id);
3196: fnd_msg_pub.add;
3197: RETURN FALSE;
3198: ELSE
3191: IF SQL%FOUND THEN
3192: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3193: fnd_message.set_token('relationship_type',l_relship_type_code);
3194: fnd_message.set_token('subject_id',p_subject_id);
3195: fnd_message.set_token('object_id',p_object_id);
3196: fnd_msg_pub.add;
3197: RETURN FALSE;
3198: ELSE
3199: RETURN TRUE;
3315: --AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE))
3316: AND ROWNUM=1;
3317: IF SQL%FOUND THEN
3318:
3319: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3320: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3321: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3322: fnd_msg_pub.add;
3323: RETURN FALSE;
3316: AND ROWNUM=1;
3317: IF SQL%FOUND THEN
3318:
3319: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3320: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3321: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3322: fnd_msg_pub.add;
3323: RETURN FALSE;
3324: END IF;
3317: IF SQL%FOUND THEN
3318:
3319: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3320: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3321: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3322: fnd_msg_pub.add;
3323: RETURN FALSE;
3324: END IF;
3325: EXCEPTION
3343: --AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE))
3344: AND ROWNUM=1;
3345: IF SQL%FOUND THEN
3346:
3347: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3348: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3349: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3350: fnd_msg_pub.add;
3351: RETURN FALSE;
3344: AND ROWNUM=1;
3345: IF SQL%FOUND THEN
3346:
3347: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3348: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3349: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3350: fnd_msg_pub.add;
3351: RETURN FALSE;
3352: END IF;
3345: IF SQL%FOUND THEN
3346:
3347: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3348: fnd_message.set_token('relationship_type_code',l_relship_type_code);
3349: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3350: fnd_msg_pub.add;
3351: RETURN FALSE;
3352: END IF;
3353: EXCEPTION
3416: WHERE relationship_id=p_relationship_id;
3417:
3418: IF SQL%FOUND THEN
3419: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3420: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3421: fnd_message.set_token('object_id',p_object_id);
3422: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3423: fnd_msg_pub.add;
3424: RETURN FALSE;
3417:
3418: IF SQL%FOUND THEN
3419: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3420: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3421: fnd_message.set_token('object_id',p_object_id);
3422: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3423: fnd_msg_pub.add;
3424: RETURN FALSE;
3425: ELSE
3418: IF SQL%FOUND THEN
3419: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3420: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3421: fnd_message.set_token('object_id',p_object_id);
3422: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3423: fnd_msg_pub.add;
3424: RETURN FALSE;
3425: ELSE
3426: RETURN TRUE;
3467: IF p_subject_id IS NULL OR
3468: p_subject_id = FND_API.G_MISS_NUM OR
3469: p_object_id IS NULL OR
3470: p_object_id = FND_API.G_MISS_NUM THEN
3471: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');
3472: fnd_msg_pub.add;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: RETURN;
3475: END IF;
3495: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
3496: l_rel_tbl.count > 0 THEN
3497: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
3498: IF l_rel_tbl(j).subject_id = p_object_id THEN
3499: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');
3500: fnd_msg_pub.add;
3501: x_return_status := fnd_api.g_ret_sts_error;
3502: exit;
3503: END IF;
3503: END IF;
3504: END LOOP;
3505: END IF;
3506: ELSE
3507: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');
3508: fnd_msg_pub.add;
3509: x_return_status := fnd_api.g_ret_sts_error;
3510: END IF;
3511: END check_for_object;
3591: --
3592: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3593: --
3594: IF l_full_dump IS NULL THEN
3595: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3596: FND_MSG_PUB.ADD;
3597: RAISE FND_API.G_EXC_ERROR;
3598: END IF;
3599: --
4568: );*/
4569: -- End Add Code for Siebel Genesis Project
4570:
4571: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4572: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4573: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4574: fnd_msg_pub.add;
4575: RAISE fnd_api.g_exc_error;
4576: END IF;
4569: -- End Add Code for Siebel Genesis Project
4570:
4571: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4572: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4573: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4574: fnd_msg_pub.add;
4575: RAISE fnd_api.g_exc_error;
4576: END IF;
4577:
4658: ,p_child_inst_tbl => px_child_inst_tbl
4659: );
4660:
4661: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4662: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4663: fnd_message.set_token('instance_id',l_instance_rec1.instance_id);
4664: fnd_msg_pub.add;
4665: RAISE fnd_api.g_exc_error;
4666: END IF;
4659: );
4660:
4661: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4662: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4663: fnd_message.set_token('instance_id',l_instance_rec1.instance_id);
4664: fnd_msg_pub.add;
4665: RAISE fnd_api.g_exc_error;
4666: END IF;
4667:
4787: );
4788:
4789: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
4790: THEN
4791: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4792: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4793: fnd_msg_pub.add;
4794: RAISE fnd_api.g_exc_error;
4795: END IF;
4788:
4789: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
4790: THEN
4791: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4792: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4793: fnd_msg_pub.add;
4794: RAISE fnd_api.g_exc_error;
4795: END IF;
4796: END IF;
4906:
4907: FOR l_count IN 1..l_line_count LOOP
4908: -- check for infinite loop; Added for bug 10081206
4909: IF (p_relationship_tbl(l_count).subject_id = p_relationship_tbl(l_count).object_id) THEN
4910: FND_MESSAGE.SET_NAME('CSI','CSI_RELATIONSHIP_LOOP');
4911: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4912: FND_MSG_PUB.ADD;
4913: RAISE fnd_api.g_exc_error;
4914: END IF;
4907: FOR l_count IN 1..l_line_count LOOP
4908: -- check for infinite loop; Added for bug 10081206
4909: IF (p_relationship_tbl(l_count).subject_id = p_relationship_tbl(l_count).object_id) THEN
4910: FND_MESSAGE.SET_NAME('CSI','CSI_RELATIONSHIP_LOOP');
4911: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4912: FND_MSG_PUB.ADD;
4913: RAISE fnd_api.g_exc_error;
4914: END IF;
4915:
4926: ( p_instance_id => p_relationship_tbl(l_count).object_id)
4927: THEN
4928: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4929: THEN
4930: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4931: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4932: FND_MSG_PUB.ADD;
4933: RAISE FND_API.G_EXC_ERROR;
4934: END IF;
4927: THEN
4928: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4929: THEN
4930: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4931: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4932: FND_MSG_PUB.ADD;
4933: RAISE FND_API.G_EXC_ERROR;
4934: END IF;
4935: END IF;
4941: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
4942: THEN
4943: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4944: THEN
4945: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4946: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_ERROR;
4949: END IF;
4942: THEN
4943: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4944: THEN
4945: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4946: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_ERROR;
4949: END IF;
4950: END IF;
5002: ( p_instance_id => p_relationship_tbl(l_count).object_id
5003: ,p_mode => 'CREATE'
5004: ,p_relationship_id => NULL )
5005: THEN
5006: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5007: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5008: fnd_msg_pub.add;
5009: RAISE fnd_api.g_exc_error;
5010: END IF;
5003: ,p_mode => 'CREATE'
5004: ,p_relationship_id => NULL )
5005: THEN
5006: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5007: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5008: fnd_msg_pub.add;
5009: RAISE fnd_api.g_exc_error;
5010: END IF;
5011: END IF;
5016: ( p_instance_id => p_relationship_tbl(l_count).subject_id
5017: ,p_mode => 'CREATE'
5018: ,p_relationship_id => NULL )
5019: THEN
5020: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5021: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5022: fnd_msg_pub.add;
5023: RAISE fnd_api.g_exc_error;
5024: END IF;
5017: ,p_mode => 'CREATE'
5018: ,p_relationship_id => NULL )
5019: THEN
5020: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5021: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5022: fnd_msg_pub.add;
5023: RAISE fnd_api.g_exc_error;
5024: END IF;
5025: END IF;
5123: ,x_msg_data => x_msg_data
5124: );
5125:
5126: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5127: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5128: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5129: fnd_msg_pub.add;
5130: RAISE fnd_api.g_exc_error;
5131: ROLLBACK TO create_relationship_pvt;
5124: );
5125:
5126: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5127: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5128: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5129: fnd_msg_pub.add;
5130: RAISE fnd_api.g_exc_error;
5131: ROLLBACK TO create_relationship_pvt;
5132: END IF;
5268: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5269: THEN
5270: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5271: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5272: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5273: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5274: fnd_msg_pub.add;
5275: RAISE fnd_api.g_exc_error;
5276: END IF;
5269: THEN
5270: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5271: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5272: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5273: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5274: fnd_msg_pub.add;
5275: RAISE fnd_api.g_exc_error;
5276: END IF;
5277: END IF;
5505: (p_relship_id => p_relationship_tbl(l_count).relationship_id,
5506: p_object_id => p_relationship_tbl(l_count).object_id,
5507: p_subject_id => p_relationship_tbl(l_count).subject_id )
5508: THEN
5509: fnd_message.set_name('CSI','CSI_API_INVALID_PARAMETERS');
5510: fnd_msg_pub.add;
5511: RAISE fnd_api.g_exc_error;
5512: END IF;
5513:
5519: ( p_instance_id => p_relationship_tbl(l_count).object_id)
5520: THEN
5521: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5522: THEN
5523: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5524: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_ERROR;
5527: END IF;
5520: THEN
5521: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5522: THEN
5523: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5524: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_ERROR;
5527: END IF;
5528: END IF;
5534: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
5535: THEN
5536: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5537: THEN
5538: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5539: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_ERROR;
5542: END IF;
5535: THEN
5536: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5537: THEN
5538: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5539: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_ERROR;
5542: END IF;
5543: END IF;
5552: ( p_instance_id => l_subject_lock)
5553: THEN
5554: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5555: THEN
5556: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5557: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_subject_lock);
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_ERROR;
5560: END IF;
5553: THEN
5554: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5555: THEN
5556: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5557: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_subject_lock);
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_ERROR;
5560: END IF;
5561: END IF;
5571: OPEN relship_csr (p_relationship_tbl(l_count).relationship_id);
5572: FETCH relship_csr INTO l_relship_csr;
5573: IF ( (l_relship_csr.object_version_number<>p_relationship_tbl(l_count).object_version_number)
5574: AND (p_relationship_tbl(l_count).object_version_number <> fnd_api.g_miss_num) ) THEN
5575: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
5576: fnd_msg_pub.add;
5577: RAISE fnd_api.g_exc_error;
5578: END IF;
5579: CLOSE relship_csr;
5632: p_relationship_tbl(l_count).relationship_type_code)
5633: and ((active_end_date is null) or (active_end_date > sysdate))
5634: and relationship_id <> p_relationship_tbl(l_count).relationship_id;
5635: --
5636: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');
5637: fnd_msg_pub.add;
5638: x_return_status := fnd_api.g_ret_sts_error;
5639: RAISE fnd_api.g_exc_error;
5640: Exception
5685: ( p_instance_id => l_obj_id
5686: ,p_mode => 'UPDATE'
5687: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5688: THEN
5689: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5690: fnd_message.set_token('INSTANCE_ID',l_obj_id);
5691: fnd_msg_pub.add;
5692: RAISE fnd_api.g_exc_error;
5693: END IF;
5686: ,p_mode => 'UPDATE'
5687: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5688: THEN
5689: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5690: fnd_message.set_token('INSTANCE_ID',l_obj_id);
5691: fnd_msg_pub.add;
5692: RAISE fnd_api.g_exc_error;
5693: END IF;
5694: END IF;
5699: ( p_instance_id => l_sub_id
5700: ,p_mode => 'UPDATE'
5701: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5702: THEN
5703: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5704: fnd_message.set_token('INSTANCE_ID',l_sub_id);
5705: fnd_msg_pub.add;
5706: RAISE fnd_api.g_exc_error;
5707: END IF;
5700: ,p_mode => 'UPDATE'
5701: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5702: THEN
5703: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5704: fnd_message.set_token('INSTANCE_ID',l_sub_id);
5705: fnd_msg_pub.add;
5706: RAISE fnd_api.g_exc_error;
5707: END IF;
5708: END IF;
5953: ,x_msg_data => x_msg_data
5954: );
5955:
5956: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5957: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5958: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5959: fnd_msg_pub.add;
5960: RAISE fnd_api.g_exc_error;
5961: ROLLBACK TO create_relationship_pvt;
5954: );
5955:
5956: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5957: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5958: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5959: fnd_msg_pub.add;
5960: RAISE fnd_api.g_exc_error;
5961: ROLLBACK TO create_relationship_pvt;
5962: END IF;
6027: );
6028: END IF;
6029:
6030: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6031: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6032: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6033: fnd_msg_pub.add;
6034: RAISE fnd_api.g_exc_error;
6035: END IF;
6028: END IF;
6029:
6030: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6031: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6032: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6033: fnd_msg_pub.add;
6034: RAISE fnd_api.g_exc_error;
6035: END IF;
6036: END IF;
6144: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
6145: THEN
6146: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6147: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
6148: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6149: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6150: fnd_msg_pub.add;
6151: RAISE fnd_api.g_exc_error;
6152: END IF;
6145: THEN
6146: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6147: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
6148: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6149: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6150: fnd_msg_pub.add;
6151: RAISE fnd_api.g_exc_error;
6152: END IF;
6153: END IF;
6337: OPEN relship_csr (p_relationship_rec.relationship_id);
6338: FETCH relship_csr INTO l_relship_csr;
6339: IF ( (l_relship_csr.object_version_number<>p_relationship_rec.object_version_number)
6340: AND (p_relationship_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
6341: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
6342: fnd_msg_pub.add;
6343: RAISE fnd_api.g_exc_error;
6344: END IF;
6345: CLOSE relship_csr;
6458: THEN
6459: --Added the below if condition for bug 5217556--
6460: IF p_txn_rec.transaction_type_id NOT IN (53,54)
6461: THEN
6462: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6463: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.object_id);
6464: FND_MSG_PUB.ADD;
6465: RAISE FND_API.G_EXC_ERROR;
6466: END IF;
6459: --Added the below if condition for bug 5217556--
6460: IF p_txn_rec.transaction_type_id NOT IN (53,54)
6461: THEN
6462: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6463: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.object_id);
6464: FND_MSG_PUB.ADD;
6465: RAISE FND_API.G_EXC_ERROR;
6466: END IF;
6467: END IF;
6490: --Changed the IF condition for Bug 12357214
6491: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.subject_id)
6492: IF (l_is_locked)
6493: THEN
6494: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6495: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);
6496: FND_MSG_PUB.ADD;
6497: RAISE FND_API.G_EXC_ERROR;
6498: END IF;
6491: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.subject_id)
6492: IF (l_is_locked)
6493: THEN
6494: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6495: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);
6496: FND_MSG_PUB.ADD;
6497: RAISE FND_API.G_EXC_ERROR;
6498: END IF;
6499: END IF;
6548: ,x_msg_data => x_msg_data
6549: );
6550:
6551: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6552: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6553: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
6554: fnd_msg_pub.add;
6555: RAISE fnd_api.g_exc_error;
6556: ROLLBACK TO create_relationship_pvt;
6549: );
6550:
6551: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6552: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6553: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
6554: fnd_msg_pub.add;
6555: RAISE fnd_api.g_exc_error;
6556: ROLLBACK TO create_relationship_pvt;
6557: END IF;
6601: );
6602:
6603:
6604: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6605: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6606: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6607: fnd_msg_pub.add;
6608: RAISE fnd_api.g_exc_error;
6609: END IF;
6602:
6603:
6604: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6605: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6606: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6607: fnd_msg_pub.add;
6608: RAISE fnd_api.g_exc_error;
6609: END IF;
6610: END IF;
6731: INTO l_dummy
6732: FROM csi_ii_relationships
6733: WHERE relationship_id=p_relationship_id
6734: AND ROWNUM=1;
6735: fnd_message.set_name('CSI','CSI_INVALID_RELSHIPID');
6736: fnd_message.set_token('relationship_id',p_relationship_id);
6737: fnd_msg_pub.add;
6738: x_return_status := fnd_api.g_ret_sts_error;
6739: EXCEPTION
6732: FROM csi_ii_relationships
6733: WHERE relationship_id=p_relationship_id
6734: AND ROWNUM=1;
6735: fnd_message.set_name('CSI','CSI_INVALID_RELSHIPID');
6736: fnd_message.set_token('relationship_id',p_relationship_id);
6737: fnd_msg_pub.add;
6738: x_return_status := fnd_api.g_ret_sts_error;
6739: EXCEPTION
6740: WHEN NO_DATA_FOUND THEN
6761: x_return_status := fnd_api.g_ret_sts_success;
6762: -- END IF;
6763: EXCEPTION
6764: WHEN NO_DATA_FOUND THEN
6765: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIPID');
6766: fnd_msg_pub.add;
6767: x_return_status := fnd_api.g_ret_sts_error;
6768: END;
6769: ELSE
6766: fnd_msg_pub.add;
6767: x_return_status := fnd_api.g_ret_sts_error;
6768: END;
6769: ELSE
6770: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_ID_PASSED');
6771: fnd_msg_pub.add;
6772: x_return_status := fnd_api.g_ret_sts_error;
6773: END IF;
6774: END IF;
6818: END IF;
6819:
6820: EXCEPTION
6821: WHEN NO_DATA_FOUND THEN
6822: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6823: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6824: fnd_msg_pub.add;
6825: x_return_status := fnd_api.g_ret_sts_error;
6826: END;
6819:
6820: EXCEPTION
6821: WHEN NO_DATA_FOUND THEN
6822: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6823: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6824: fnd_msg_pub.add;
6825: x_return_status := fnd_api.g_ret_sts_error;
6826: END;
6827: ELSE
6824: fnd_msg_pub.add;
6825: x_return_status := fnd_api.g_ret_sts_error;
6826: END;
6827: ELSE
6828: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6829: --fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6830: fnd_msg_pub.add;
6831: x_return_status := fnd_api.g_ret_sts_error;
6832:
6825: x_return_status := fnd_api.g_ret_sts_error;
6826: END;
6827: ELSE
6828: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6829: --fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6830: fnd_msg_pub.add;
6831: x_return_status := fnd_api.g_ret_sts_error;
6832:
6833: END IF;
6843: x_return_status := fnd_api.g_ret_sts_success;
6844: END IF;
6845: EXCEPTION
6846: WHEN NO_DATA_FOUND THEN
6847: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6848: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6849: fnd_msg_pub.add;
6850: x_return_status := fnd_api.g_ret_sts_error;
6851: END;
6844: END IF;
6845: EXCEPTION
6846: WHEN NO_DATA_FOUND THEN
6847: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6848: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6849: fnd_msg_pub.add;
6850: x_return_status := fnd_api.g_ret_sts_error;
6851: END;
6852: ELSIF p_relationship_type_code IS NULL -- Added for bug 2151750
6850: x_return_status := fnd_api.g_ret_sts_error;
6851: END;
6852: ELSIF p_relationship_type_code IS NULL -- Added for bug 2151750
6853: THEN
6854: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6855: fnd_msg_pub.add;
6856: x_return_status := fnd_api.g_ret_sts_error;
6857: END IF;
6858: END IF;
6912: WHERE cii.instance_id=p_object_id
6913: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6914: EXCEPTION
6915: WHEN NO_DATA_FOUND THEN
6916: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
6917: fnd_message.set_token('object_id',p_object_id);
6918: fnd_msg_pub.add;
6919: x_return_status := fnd_api.g_ret_sts_error;
6920: RAISE fnd_api.g_exc_error;
6913: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6914: EXCEPTION
6915: WHEN NO_DATA_FOUND THEN
6916: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
6917: fnd_message.set_token('object_id',p_object_id);
6918: fnd_msg_pub.add;
6919: x_return_status := fnd_api.g_ret_sts_error;
6920: RAISE fnd_api.g_exc_error;
6921: END;
6936: FROM csi_item_instances
6937: WHERE instance_id=p_object_id;
6938: IF l_quantity IS NOT NULL THEN
6939: IF l_quantity<>1 THEN
6940: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6941: fnd_message.set_token('object_id',p_object_id);
6942: fnd_msg_pub.add;
6943: x_return_status := fnd_api.g_ret_sts_error;
6944: END IF;
6937: WHERE instance_id=p_object_id;
6938: IF l_quantity IS NOT NULL THEN
6939: IF l_quantity<>1 THEN
6940: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6941: fnd_message.set_token('object_id',p_object_id);
6942: fnd_msg_pub.add;
6943: x_return_status := fnd_api.g_ret_sts_error;
6944: END IF;
6945: END IF;
6945: END IF;
6946: /* commented by sk for bug 2151750
6947: IF l_location_type_code IS NOT NULL THEN
6948: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6949: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6950: fnd_message.set_token('object_id',p_object_id);
6951: fnd_msg_pub.add;
6952: x_return_status := fnd_api.g_ret_sts_error;
6953: END IF;
6946: /* commented by sk for bug 2151750
6947: IF l_location_type_code IS NOT NULL THEN
6948: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6949: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6950: fnd_message.set_token('object_id',p_object_id);
6951: fnd_msg_pub.add;
6952: x_return_status := fnd_api.g_ret_sts_error;
6953: END IF;
6954: END IF;
6991: --AND NVL(l_item_type,'X') IN ('ATO','PTO') THEN --NON-SERIALIZED ITEM
6992: -- Modified by sk for bug 2266166
6993: NULL;
6994: ELSE
6995: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6996: fnd_message.set_token('object_id',p_object_id);
6997: fnd_msg_pub.add;
6998: x_return_status := fnd_api.g_ret_sts_error;
6999: END IF;
6992: -- Modified by sk for bug 2266166
6993: NULL;
6994: ELSE
6995: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6996: fnd_message.set_token('object_id',p_object_id);
6997: fnd_msg_pub.add;
6998: x_return_status := fnd_api.g_ret_sts_error;
6999: END IF;
7000:
7003: NULL;
7004: END;
7005: EXCEPTION
7006: WHEN NO_DATA_FOUND THEN
7007: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
7008: fnd_message.set_token('object_id',p_object_id);
7009: fnd_msg_pub.add;
7010: x_return_status := fnd_api.g_ret_sts_error;
7011: END;
7004: END;
7005: EXCEPTION
7006: WHEN NO_DATA_FOUND THEN
7007: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
7008: fnd_message.set_token('object_id',p_object_id);
7009: fnd_msg_pub.add;
7010: x_return_status := fnd_api.g_ret_sts_error;
7011: END;
7012: ELSE
7009: fnd_msg_pub.add;
7010: x_return_status := fnd_api.g_ret_sts_error;
7011: END;
7012: ELSE
7013: fnd_message.set_name('CSI', 'CSI_NO_OBJ_ID_PASSED');
7014: fnd_msg_pub.add;
7015: x_return_status := fnd_api.g_ret_sts_error;
7016: END IF;
7017:
7034: WHERE instance_id=p_object_id;
7035:
7036: IF l_quantity IS NOT NULL THEN
7037: IF l_quantity<>1 THEN
7038: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
7039: fnd_message.set_token('object_id',p_object_id);
7040: fnd_msg_pub.add;
7041: x_return_status := fnd_api.g_ret_sts_error;
7042: END IF;
7035:
7036: IF l_quantity IS NOT NULL THEN
7037: IF l_quantity<>1 THEN
7038: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
7039: fnd_message.set_token('object_id',p_object_id);
7040: fnd_msg_pub.add;
7041: x_return_status := fnd_api.g_ret_sts_error;
7042: END IF;
7043: END IF;
7043: END IF;
7044: /* commented by sk for bug 2151750
7045: IF l_location_type_code IS NOT NULL THEN
7046: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
7047: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
7048: fnd_message.set_token('object_id',p_object_id);
7049: fnd_msg_pub.add;
7050: x_return_status := fnd_api.g_ret_sts_error;
7051: END IF;
7044: /* commented by sk for bug 2151750
7045: IF l_location_type_code IS NOT NULL THEN
7046: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
7047: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
7048: fnd_message.set_token('object_id',p_object_id);
7049: fnd_msg_pub.add;
7050: x_return_status := fnd_api.g_ret_sts_error;
7051: END IF;
7052: END IF;
7089: --NVL(l_item_type,'X') IN ('ATO','PTO') THEN --NON-SERIALIZED ITEM
7090: -- Modified by sk for bug 2266166
7091: NULL;
7092: ELSE
7093: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
7094: fnd_message.set_token('object_id',p_object_id);
7095: fnd_msg_pub.add;
7096: x_return_status := fnd_api.g_ret_sts_error;
7097: END IF;
7090: -- Modified by sk for bug 2266166
7091: NULL;
7092: ELSE
7093: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
7094: fnd_message.set_token('object_id',p_object_id);
7095: fnd_msg_pub.add;
7096: x_return_status := fnd_api.g_ret_sts_error;
7097: END IF;
7098:
7102: END;
7103:
7104: EXCEPTION
7105: WHEN NO_DATA_FOUND THEN
7106: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
7107: fnd_message.set_token('object_id',p_object_id);
7108: fnd_msg_pub.add;
7109: x_return_status := fnd_api.g_ret_sts_error;
7110: END;
7103:
7104: EXCEPTION
7105: WHEN NO_DATA_FOUND THEN
7106: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
7107: fnd_message.set_token('object_id',p_object_id);
7108: fnd_msg_pub.add;
7109: x_return_status := fnd_api.g_ret_sts_error;
7110: END;
7111: END IF;
7158: WHERE cii.instance_id=p_subject_id
7159: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
7160: EXCEPTION
7161: WHEN NO_DATA_FOUND THEN
7162: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
7163: fnd_message.set_token('subject_id',p_subject_id);
7164: fnd_msg_pub.add;
7165: x_return_status := fnd_api.g_ret_sts_error;
7166: RAISE fnd_api.g_exc_error;
7159: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
7160: EXCEPTION
7161: WHEN NO_DATA_FOUND THEN
7162: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
7163: fnd_message.set_token('subject_id',p_subject_id);
7164: fnd_msg_pub.add;
7165: x_return_status := fnd_api.g_ret_sts_error;
7166: RAISE fnd_api.g_exc_error;
7167: END;
7174: WHERE instance_id=p_subject_id;
7175: /* commented by sk for bug 2151750
7176: IF l_location_type_code IS NOT NULL THEN
7177: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
7178: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
7179: fnd_message.set_token('subject_id',p_subject_id);
7180: fnd_msg_pub.add;
7181: x_return_status := fnd_api.g_ret_sts_error;
7182: END IF;
7175: /* commented by sk for bug 2151750
7176: IF l_location_type_code IS NOT NULL THEN
7177: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
7178: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
7179: fnd_message.set_token('subject_id',p_subject_id);
7180: fnd_msg_pub.add;
7181: x_return_status := fnd_api.g_ret_sts_error;
7182: END IF;
7183: END IF;
7183: END IF;
7184: */
7185: EXCEPTION
7186: WHEN NO_DATA_FOUND THEN
7187: fnd_message.set_name('CSI', 'CSI_INVALID_SUBJECT_ID');
7188: fnd_message.set_token('subject_id',p_subject_id);
7189: fnd_msg_pub.add;
7190: x_return_status := fnd_api.g_ret_sts_error;
7191: END;
7184: */
7185: EXCEPTION
7186: WHEN NO_DATA_FOUND THEN
7187: fnd_message.set_name('CSI', 'CSI_INVALID_SUBJECT_ID');
7188: fnd_message.set_token('subject_id',p_subject_id);
7189: fnd_msg_pub.add;
7190: x_return_status := fnd_api.g_ret_sts_error;
7191: END;
7192: END IF;
7219: -- initialize api return status to success
7220: x_return_status := fnd_api.g_ret_sts_success;
7221: IF(p_validation_mode ='CREATE') THEN
7222: IF ((p_active_end_date IS NOT NULL) AND (p_active_end_date <> fnd_api.g_miss_date)) THEN
7223: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
7224: fnd_message.set_token('ACTIVE_END_DATE',p_active_end_date);
7225: fnd_msg_pub.add;
7226: x_return_status := fnd_api.g_ret_sts_error;
7227: END IF;
7220: x_return_status := fnd_api.g_ret_sts_success;
7221: IF(p_validation_mode ='CREATE') THEN
7222: IF ((p_active_end_date IS NOT NULL) AND (p_active_end_date <> fnd_api.g_miss_date)) THEN
7223: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
7224: fnd_message.set_token('ACTIVE_END_DATE',p_active_end_date);
7225: fnd_msg_pub.add;
7226: x_return_status := fnd_api.g_ret_sts_error;
7227: END IF;
7228: END IF;
7262:
7263:
7264: IF( (p_validation_mode = 'UPDATE') OR (p_validation_mode = 'EXPIRE') ) THEN
7265: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
7266: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
7267: fnd_msg_pub.add;
7268: x_return_status := fnd_api.g_ret_sts_error;
7269: ELSE
7270: x_return_status := fnd_api.g_ret_sts_success;