DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on FND_MESSAGE

Line 107: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

103: -- ******************************************************************
104:
105: IF p_instance_id IS NULL
106: THEN
107: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
108: fnd_msg_pub.add;
109: x_return_status := fnd_api.g_ret_sts_error;
110: RAISE fnd_api.g_exc_error;
111: END IF;

Line 1756: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

1752: IF l_object_id IS NULL AND
1753: l_subject_id IS NULL AND
1754: l_relationship_id IS NULL AND
1755: l_rel_type_code IS NULL THEN
1756: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
1757: fnd_msg_pub.add;
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: RAISE fnd_api.g_exc_error;
1760: END IF;

Line 2153: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

2149: AND ((p_relationship_query_rec.object_id IS NULL) OR (p_relationship_query_rec.object_id = fnd_api.g_miss_num))
2150: AND ((p_relationship_query_rec.subject_id IS NULL) OR (p_relationship_query_rec.subject_id = fnd_api.g_miss_num))
2151: )
2152: THEN
2153: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
2154: fnd_msg_pub.add;
2155: x_return_status := fnd_api.g_ret_sts_error;
2156: RAISE fnd_api.g_exc_error;
2157: END IF;

Line 2169: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

2165: AND p_relationship_query_rec.subject_id <> fnd_api.g_miss_num)
2166: AND (p_relationship_query_rec.object_id IS NOT NULL
2167: AND p_relationship_query_rec.object_id <> fnd_api.g_miss_num)))
2168: THEN
2169: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
2170: fnd_msg_pub.add;
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: RAISE fnd_api.g_exc_error;
2173: ELSIF ((p_relationship_query_rec.subject_id IS NOT NULL

Line 2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');

2228: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2229: THEN
2230: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2231: 'Please provide a valid datetime stamp.');
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2233: FND_MSG_PUB.ADD;
2234: ELSE
2235: get_history( p_rel_rec => l_rel_rec
2236: ,p_new_rec => l_new_rec

Line 2393: fnd_message.set_name('CSI','CSI_NO_RELCODE_PASSED');

2389: IF( (p_relationship_query_rec.object_id IS NOT NULL) AND (p_relationship_query_rec.object_id <> fnd_api.g_miss_num) )
2390: THEN
2391: IF( (p_relationship_query_rec.relationship_type_code IS NULL) OR (p_relationship_query_rec.relationship_type_code = fnd_api.g_miss_char) )
2392: THEN
2393: fnd_message.set_name('CSI','CSI_NO_RELCODE_PASSED');
2394: fnd_msg_pub.add;
2395: RAISE fnd_api.g_exc_error;
2396: END IF;
2397: END IF;

Line 2475: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');

2471: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2472: THEN
2473: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2474: 'Please provide a valid datetime stamp.');
2475: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2476: FND_MSG_PUB.ADD;
2477: ELSE
2478: get_history( p_rel_rec => l_rel_tbl(p_time_csr)
2479: ,p_new_rec => l_new_rec

Line 2993: fnd_message.set_name('CSI','CSI_CONFIG_SET');

2989: WHERE relationship_id=p_relationship_id;
2990: */
2991: IF l_configurator_id is not null
2992: THEN
2993: fnd_message.set_name('CSI','CSI_CONFIG_SET');
2994: fnd_message.set_token('relationship_id',p_relationship_id);
2995: fnd_msg_pub.add;
2996: RETURN TRUE;
2997: ELSE

Line 2994: fnd_message.set_token('relationship_id',p_relationship_id);

2990: */
2991: IF l_configurator_id is not null
2992: THEN
2993: fnd_message.set_name('CSI','CSI_CONFIG_SET');
2994: fnd_message.set_token('relationship_id',p_relationship_id);
2995: fnd_msg_pub.add;
2996: RETURN TRUE;
2997: ELSE
2998: RETURN FALSE;

Line 3032: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');

3028: AND relationship_type_code = p_relship_type_code
3029: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3030: AND ROWNUM = 1 ;
3031: IF SQL%FOUND THEN
3032: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3033: fnd_message.set_token('relationship_type',p_relship_type_code);
3034: fnd_message.set_token('subject_id',p_subject_id);
3035: fnd_message.set_token('object_id',p_object_id);
3036: fnd_msg_pub.add;

Line 3033: fnd_message.set_token('relationship_type',p_relship_type_code);

3029: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3030: AND ROWNUM = 1 ;
3031: IF SQL%FOUND THEN
3032: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3033: fnd_message.set_token('relationship_type',p_relship_type_code);
3034: fnd_message.set_token('subject_id',p_subject_id);
3035: fnd_message.set_token('object_id',p_object_id);
3036: fnd_msg_pub.add;
3037: RETURN FALSE;

Line 3034: fnd_message.set_token('subject_id',p_subject_id);

3030: AND ROWNUM = 1 ;
3031: IF SQL%FOUND THEN
3032: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3033: fnd_message.set_token('relationship_type',p_relship_type_code);
3034: fnd_message.set_token('subject_id',p_subject_id);
3035: fnd_message.set_token('object_id',p_object_id);
3036: fnd_msg_pub.add;
3037: RETURN FALSE;
3038: ELSE

Line 3035: fnd_message.set_token('object_id',p_object_id);

3031: IF SQL%FOUND THEN
3032: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3033: fnd_message.set_token('relationship_type',p_relship_type_code);
3034: fnd_message.set_token('subject_id',p_subject_id);
3035: fnd_message.set_token('object_id',p_object_id);
3036: fnd_msg_pub.add;
3037: RETURN FALSE;
3038: ELSE
3039: RETURN TRUE;

Line 3053: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');

3049: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
3050: AND relationship_id<>p_relationship_id
3051: AND ROWNUM = 1 ;
3052: IF SQL%FOUND THEN
3053: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3054: fnd_message.set_token('relationship_type',p_relship_type_code);
3055: fnd_message.set_token('subject_id',p_subject_id);
3056: fnd_message.set_token('object_id',p_object_id);
3057: fnd_msg_pub.add;

Line 3054: fnd_message.set_token('relationship_type',p_relship_type_code);

3050: AND relationship_id<>p_relationship_id
3051: AND ROWNUM = 1 ;
3052: IF SQL%FOUND THEN
3053: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3054: fnd_message.set_token('relationship_type',p_relship_type_code);
3055: fnd_message.set_token('subject_id',p_subject_id);
3056: fnd_message.set_token('object_id',p_object_id);
3057: fnd_msg_pub.add;
3058: RETURN FALSE;

Line 3055: fnd_message.set_token('subject_id',p_subject_id);

3051: AND ROWNUM = 1 ;
3052: IF SQL%FOUND THEN
3053: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3054: fnd_message.set_token('relationship_type',p_relship_type_code);
3055: fnd_message.set_token('subject_id',p_subject_id);
3056: fnd_message.set_token('object_id',p_object_id);
3057: fnd_msg_pub.add;
3058: RETURN FALSE;
3059: ELSE

Line 3056: fnd_message.set_token('object_id',p_object_id);

3052: IF SQL%FOUND THEN
3053: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
3054: fnd_message.set_token('relationship_type',p_relship_type_code);
3055: fnd_message.set_token('subject_id',p_subject_id);
3056: fnd_message.set_token('object_id',p_object_id);
3057: fnd_msg_pub.add;
3058: RETURN FALSE;
3059: ELSE
3060: RETURN TRUE;

Line 3174: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');

3170: --AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE))
3171: AND ROWNUM=1;
3172: IF SQL%FOUND THEN
3173:
3174: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3175: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3176: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3177: fnd_msg_pub.add;
3178: RETURN FALSE;

Line 3175: fnd_message.set_token('relationship_type_code',p_relship_type_code);

3171: AND ROWNUM=1;
3172: IF SQL%FOUND THEN
3173:
3174: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3175: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3176: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3177: fnd_msg_pub.add;
3178: RETURN FALSE;
3179: END IF;

Line 3176: fnd_message.set_token('SUBJECT_ID',p_subject_id);

3172: IF SQL%FOUND THEN
3173:
3174: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3175: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3176: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3177: fnd_msg_pub.add;
3178: RETURN FALSE;
3179: END IF;
3180: EXCEPTION

Line 3199: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');

3195: --AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE))
3196: AND ROWNUM=1;
3197: IF SQL%FOUND THEN
3198:
3199: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3200: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3201: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3202: fnd_msg_pub.add;
3203: RETURN FALSE;

Line 3200: fnd_message.set_token('relationship_type_code',p_relship_type_code);

3196: AND ROWNUM=1;
3197: IF SQL%FOUND THEN
3198:
3199: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3200: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3201: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3202: fnd_msg_pub.add;
3203: RETURN FALSE;
3204: END IF;

Line 3201: fnd_message.set_token('SUBJECT_ID',p_subject_id);

3197: IF SQL%FOUND THEN
3198:
3199: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
3200: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3201: fnd_message.set_token('SUBJECT_ID',p_subject_id);
3202: fnd_msg_pub.add;
3203: RETURN FALSE;
3204: END IF;
3205: EXCEPTION

Line 3272: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');

3268: WHERE relationship_id=p_relationship_id;
3269:
3270: IF SQL%FOUND THEN
3271: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3272: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3273: fnd_message.set_token('object_id',p_object_id);
3274: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3275: fnd_msg_pub.add;
3276: RETURN FALSE;

Line 3273: fnd_message.set_token('object_id',p_object_id);

3269:
3270: IF SQL%FOUND THEN
3271: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3272: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3273: fnd_message.set_token('object_id',p_object_id);
3274: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3275: fnd_msg_pub.add;
3276: RETURN FALSE;
3277: ELSE

Line 3274: fnd_message.set_token('relationship_type_code',p_relship_type_code);

3270: IF SQL%FOUND THEN
3271: IF ( (l_object_id<>p_object_id) OR (l_relship_type_code<>p_relship_type_code) ) THEN
3272: fnd_message.set_name('CSI','CSI_CANNOT_UPDATE');
3273: fnd_message.set_token('object_id',p_object_id);
3274: fnd_message.set_token('relationship_type_code',p_relship_type_code);
3275: fnd_msg_pub.add;
3276: RETURN FALSE;
3277: ELSE
3278: RETURN TRUE;

Line 3323: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');

3319: IF p_subject_id IS NULL OR
3320: p_subject_id = FND_API.G_MISS_NUM OR
3321: p_object_id IS NULL OR
3322: p_object_id = FND_API.G_MISS_NUM THEN
3323: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');
3324: fnd_msg_pub.add;
3325: x_return_status := fnd_api.g_ret_sts_error;
3326: RETURN;
3327: END IF;

Line 3351: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');

3347: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
3348: l_rel_tbl.count > 0 THEN
3349: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
3350: IF l_rel_tbl(j).subject_id = p_object_id THEN
3351: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');
3352: fnd_msg_pub.add;
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: exit;
3355: END IF;

Line 3359: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');

3355: END IF;
3356: END LOOP;
3357: END IF;
3358: ELSE
3359: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');
3360: fnd_msg_pub.add;
3361: x_return_status := fnd_api.g_ret_sts_error;
3362: END IF;
3363: END check_for_object;

Line 3447: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');

3443: --
3444: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3445: --
3446: IF l_full_dump IS NULL THEN
3447: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3448: FND_MSG_PUB.ADD;
3449: RAISE FND_API.G_EXC_ERROR;
3450: END IF;
3451: --

Line 4412: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

4408: );*/
4409: -- End Add Code for Siebel Genesis Project
4410:
4411: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4412: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4413: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4414: fnd_msg_pub.add;
4415: RAISE fnd_api.g_exc_error;
4416: END IF;

Line 4413: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

4409: -- End Add Code for Siebel Genesis Project
4410:
4411: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4412: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4413: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4414: fnd_msg_pub.add;
4415: RAISE fnd_api.g_exc_error;
4416: END IF;
4417:

Line 4502: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

4498: ,p_child_inst_tbl => px_child_inst_tbl
4499: );
4500:
4501: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4502: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4503: fnd_message.set_token('instance_id',l_instance_rec1.instance_id);
4504: fnd_msg_pub.add;
4505: RAISE fnd_api.g_exc_error;
4506: END IF;

Line 4503: fnd_message.set_token('instance_id',l_instance_rec1.instance_id);

4499: );
4500:
4501: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4502: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4503: fnd_message.set_token('instance_id',l_instance_rec1.instance_id);
4504: fnd_msg_pub.add;
4505: RAISE fnd_api.g_exc_error;
4506: END IF;
4507:

Line 4631: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

4627: );
4628:
4629: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
4630: THEN
4631: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4632: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4633: fnd_msg_pub.add;
4634: RAISE fnd_api.g_exc_error;
4635: END IF;

Line 4632: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

4628:
4629: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
4630: THEN
4631: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4632: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
4633: fnd_msg_pub.add;
4634: RAISE fnd_api.g_exc_error;
4635: END IF;
4636: END IF;

Line 4762: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

4758: ( p_instance_id => p_relationship_tbl(l_count).object_id)
4759: THEN
4760: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4761: THEN
4762: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4763: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4764: FND_MSG_PUB.ADD;
4765: RAISE FND_API.G_EXC_ERROR;
4766: END IF;

Line 4763: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);

4759: THEN
4760: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4761: THEN
4762: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4763: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4764: FND_MSG_PUB.ADD;
4765: RAISE FND_API.G_EXC_ERROR;
4766: END IF;
4767: END IF;

Line 4777: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

4773: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
4774: THEN
4775: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4776: THEN
4777: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4778: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4779: FND_MSG_PUB.ADD;
4780: RAISE FND_API.G_EXC_ERROR;
4781: END IF;

Line 4778: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);

4774: THEN
4775: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4776: THEN
4777: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
4778: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4779: FND_MSG_PUB.ADD;
4780: RAISE FND_API.G_EXC_ERROR;
4781: END IF;
4782: END IF;

Line 4838: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

4834: ( p_instance_id => p_relationship_tbl(l_count).object_id
4835: ,p_mode => 'CREATE'
4836: ,p_relationship_id => NULL )
4837: THEN
4838: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
4839: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4840: fnd_msg_pub.add;
4841: RAISE fnd_api.g_exc_error;
4842: END IF;

Line 4839: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).object_id);

4835: ,p_mode => 'CREATE'
4836: ,p_relationship_id => NULL )
4837: THEN
4838: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
4839: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
4840: fnd_msg_pub.add;
4841: RAISE fnd_api.g_exc_error;
4842: END IF;
4843: END IF;

Line 4852: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

4848: ( p_instance_id => p_relationship_tbl(l_count).subject_id
4849: ,p_mode => 'CREATE'
4850: ,p_relationship_id => NULL )
4851: THEN
4852: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
4853: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4854: fnd_msg_pub.add;
4855: RAISE fnd_api.g_exc_error;
4856: END IF;

Line 4853: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);

4849: ,p_mode => 'CREATE'
4850: ,p_relationship_id => NULL )
4851: THEN
4852: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
4853: fnd_message.set_token('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
4854: fnd_msg_pub.add;
4855: RAISE fnd_api.g_exc_error;
4856: END IF;
4857: END IF;

Line 4959: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');

4955: ,x_msg_data => x_msg_data
4956: );
4957:
4958: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4959: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
4960: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
4961: fnd_msg_pub.add;
4962: RAISE fnd_api.g_exc_error;
4963: ROLLBACK TO create_relationship_pvt;

Line 4960: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );

4956: );
4957:
4958: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4959: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
4960: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
4961: fnd_msg_pub.add;
4962: RAISE fnd_api.g_exc_error;
4963: ROLLBACK TO create_relationship_pvt;
4964: END IF;

Line 5104: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

5100: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5101: THEN
5102: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5103: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5104: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5105: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5106: fnd_msg_pub.add;
5107: RAISE fnd_api.g_exc_error;
5108: END IF;

Line 5105: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

5101: THEN
5102: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5103: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5104: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5105: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5106: fnd_msg_pub.add;
5107: RAISE fnd_api.g_exc_error;
5108: END IF;
5109: END IF;

Line 5332: fnd_message.set_name('CSI','CSI_API_INVALID_PARAMETERS');

5328: (p_relship_id => p_relationship_tbl(l_count).relationship_id,
5329: p_object_id => p_relationship_tbl(l_count).object_id,
5330: p_subject_id => p_relationship_tbl(l_count).subject_id )
5331: THEN
5332: fnd_message.set_name('CSI','CSI_API_INVALID_PARAMETERS');
5333: fnd_msg_pub.add;
5334: RAISE fnd_api.g_exc_error;
5335: END IF;
5336:

Line 5346: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

5342: ( p_instance_id => p_relationship_tbl(l_count).object_id)
5343: THEN
5344: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5345: THEN
5346: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5347: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5348: FND_MSG_PUB.ADD;
5349: RAISE FND_API.G_EXC_ERROR;
5350: END IF;

Line 5347: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);

5343: THEN
5344: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5345: THEN
5346: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5347: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).object_id);
5348: FND_MSG_PUB.ADD;
5349: RAISE FND_API.G_EXC_ERROR;
5350: END IF;
5351: END IF;

Line 5361: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

5357: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
5358: THEN
5359: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5360: THEN
5361: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5362: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5363: FND_MSG_PUB.ADD;
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;

Line 5362: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);

5358: THEN
5359: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5360: THEN
5361: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5362: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_relationship_tbl(l_count).subject_id);
5363: FND_MSG_PUB.ADD;
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366: END IF;

Line 5379: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

5375: ( p_instance_id => l_subject_lock)
5376: THEN
5377: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5378: THEN
5379: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5380: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_subject_lock);
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_ERROR;
5383: END IF;

Line 5380: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_subject_lock);

5376: THEN
5377: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5378: THEN
5379: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
5380: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_subject_lock);
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_ERROR;
5383: END IF;
5384: END IF;

Line 5398: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');

5394: OPEN relship_csr (p_relationship_tbl(l_count).relationship_id);
5395: FETCH relship_csr INTO l_relship_csr;
5396: IF ( (l_relship_csr.object_version_number<>p_relationship_tbl(l_count).object_version_number)
5397: AND (p_relationship_tbl(l_count).object_version_number <> fnd_api.g_miss_num) ) THEN
5398: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
5399: fnd_msg_pub.add;
5400: RAISE fnd_api.g_exc_error;
5401: END IF;
5402: CLOSE relship_csr;

Line 5459: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');

5455: p_relationship_tbl(l_count).relationship_type_code)
5456: and ((active_end_date is null) or (active_end_date > sysdate))
5457: and relationship_id <> p_relationship_tbl(l_count).relationship_id;
5458: --
5459: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');
5460: fnd_msg_pub.add;
5461: x_return_status := fnd_api.g_ret_sts_error;
5462: RAISE fnd_api.g_exc_error;
5463: Exception

Line 5512: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

5508: ( p_instance_id => l_obj_id
5509: ,p_mode => 'UPDATE'
5510: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5511: THEN
5512: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5513: fnd_message.set_token('INSTANCE_ID',l_obj_id);
5514: fnd_msg_pub.add;
5515: RAISE fnd_api.g_exc_error;
5516: END IF;

Line 5513: fnd_message.set_token('INSTANCE_ID',l_obj_id);

5509: ,p_mode => 'UPDATE'
5510: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5511: THEN
5512: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5513: fnd_message.set_token('INSTANCE_ID',l_obj_id);
5514: fnd_msg_pub.add;
5515: RAISE fnd_api.g_exc_error;
5516: END IF;
5517: END IF;

Line 5526: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

5522: ( p_instance_id => l_sub_id
5523: ,p_mode => 'UPDATE'
5524: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5525: THEN
5526: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5527: fnd_message.set_token('INSTANCE_ID',l_sub_id);
5528: fnd_msg_pub.add;
5529: RAISE fnd_api.g_exc_error;
5530: END IF;

Line 5527: fnd_message.set_token('INSTANCE_ID',l_sub_id);

5523: ,p_mode => 'UPDATE'
5524: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5525: THEN
5526: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
5527: fnd_message.set_token('INSTANCE_ID',l_sub_id);
5528: fnd_msg_pub.add;
5529: RAISE fnd_api.g_exc_error;
5530: END IF;
5531: END IF;

Line 5780: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');

5776: ,x_msg_data => x_msg_data
5777: );
5778:
5779: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5780: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5781: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5782: fnd_msg_pub.add;
5783: RAISE fnd_api.g_exc_error;
5784: ROLLBACK TO create_relationship_pvt;

Line 5781: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );

5777: );
5778:
5779: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5780: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
5781: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
5782: fnd_msg_pub.add;
5783: RAISE fnd_api.g_exc_error;
5784: ROLLBACK TO create_relationship_pvt;
5785: END IF;

Line 5830: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

5826: );
5827: END IF;
5828:
5829: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5830: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5831: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5832: fnd_msg_pub.add;
5833: RAISE fnd_api.g_exc_error;
5834: END IF;

Line 5831: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

5827: END IF;
5828:
5829: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5830: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5831: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5832: fnd_msg_pub.add;
5833: RAISE fnd_api.g_exc_error;
5834: END IF;
5835: END IF;

Line 5947: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

5943: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5944: THEN
5945: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5946: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5947: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5948: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5949: fnd_msg_pub.add;
5950: RAISE fnd_api.g_exc_error;
5951: END IF;

Line 5948: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

5944: THEN
5945: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5946: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5947: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5948: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5949: fnd_msg_pub.add;
5950: RAISE fnd_api.g_exc_error;
5951: END IF;
5952: END IF;

Line 6132: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');

6128: OPEN relship_csr (p_relationship_rec.relationship_id);
6129: FETCH relship_csr INTO l_relship_csr;
6130: IF ( (l_relship_csr.object_version_number<>p_relationship_rec.object_version_number)
6131: AND (p_relationship_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
6132: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
6133: fnd_msg_pub.add;
6134: RAISE fnd_api.g_exc_error;
6135: END IF;
6136: CLOSE relship_csr;

Line 6231: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

6227: THEN
6228: --Added the below if condition for bug 5217556--
6229: IF p_txn_rec.transaction_type_id NOT IN (53,54)
6230: THEN
6231: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6232: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.object_id);
6233: FND_MSG_PUB.ADD;
6234: RAISE FND_API.G_EXC_ERROR;
6235: END IF;

Line 6232: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.object_id);

6228: --Added the below if condition for bug 5217556--
6229: IF p_txn_rec.transaction_type_id NOT IN (53,54)
6230: THEN
6231: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6232: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.object_id);
6233: FND_MSG_PUB.ADD;
6234: RAISE FND_API.G_EXC_ERROR;
6235: END IF;
6236: END IF;

Line 6245: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');

6241: THEN
6242: IF csi_item_instance_pvt.check_item_instance_lock
6243: ( p_instance_id => l_relship_csr.subject_id)
6244: THEN
6245: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6246: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;

Line 6246: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);

6242: IF csi_item_instance_pvt.check_item_instance_lock
6243: ( p_instance_id => l_relship_csr.subject_id)
6244: THEN
6245: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6246: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6250: END IF;

Line 6303: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');

6299: ,x_msg_data => x_msg_data
6300: );
6301:
6302: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6303: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6304: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
6305: fnd_msg_pub.add;
6306: RAISE fnd_api.g_exc_error;
6307: ROLLBACK TO create_relationship_pvt;

Line 6304: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );

6300: );
6301:
6302: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6303: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6304: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
6305: fnd_msg_pub.add;
6306: RAISE fnd_api.g_exc_error;
6307: ROLLBACK TO create_relationship_pvt;
6308: END IF;

Line 6348: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

6344: );
6345:
6346:
6347: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6348: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6349: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6350: fnd_msg_pub.add;
6351: RAISE fnd_api.g_exc_error;
6352: END IF;

Line 6349: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

6345:
6346:
6347: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6348: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6349: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6350: fnd_msg_pub.add;
6351: RAISE fnd_api.g_exc_error;
6352: END IF;
6353: END IF;

Line 6474: fnd_message.set_name('CSI','CSI_INVALID_RELSHIPID');

6470: INTO l_dummy
6471: FROM csi_ii_relationships
6472: WHERE relationship_id=p_relationship_id
6473: AND ROWNUM=1;
6474: fnd_message.set_name('CSI','CSI_INVALID_RELSHIPID');
6475: fnd_message.set_token('relationship_id',p_relationship_id);
6476: fnd_msg_pub.add;
6477: x_return_status := fnd_api.g_ret_sts_error;
6478: EXCEPTION

Line 6475: fnd_message.set_token('relationship_id',p_relationship_id);

6471: FROM csi_ii_relationships
6472: WHERE relationship_id=p_relationship_id
6473: AND ROWNUM=1;
6474: fnd_message.set_name('CSI','CSI_INVALID_RELSHIPID');
6475: fnd_message.set_token('relationship_id',p_relationship_id);
6476: fnd_msg_pub.add;
6477: x_return_status := fnd_api.g_ret_sts_error;
6478: EXCEPTION
6479: WHEN NO_DATA_FOUND THEN

Line 6504: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIPID');

6500: x_return_status := fnd_api.g_ret_sts_success;
6501: -- END IF;
6502: EXCEPTION
6503: WHEN NO_DATA_FOUND THEN
6504: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIPID');
6505: fnd_msg_pub.add;
6506: x_return_status := fnd_api.g_ret_sts_error;
6507: END;
6508: ELSE

Line 6509: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_ID_PASSED');

6505: fnd_msg_pub.add;
6506: x_return_status := fnd_api.g_ret_sts_error;
6507: END;
6508: ELSE
6509: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_ID_PASSED');
6510: fnd_msg_pub.add;
6511: x_return_status := fnd_api.g_ret_sts_error;
6512: END IF;
6513: END IF;

Line 6560: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');

6556: END IF;
6557:
6558: EXCEPTION
6559: WHEN NO_DATA_FOUND THEN
6560: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6561: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6562: fnd_msg_pub.add;
6563: x_return_status := fnd_api.g_ret_sts_error;
6564: END;

Line 6561: fnd_message.set_token('relationship_type_code',p_relationship_type_code);

6557:
6558: EXCEPTION
6559: WHEN NO_DATA_FOUND THEN
6560: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6561: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6562: fnd_msg_pub.add;
6563: x_return_status := fnd_api.g_ret_sts_error;
6564: END;
6565: ELSE

Line 6566: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');

6562: fnd_msg_pub.add;
6563: x_return_status := fnd_api.g_ret_sts_error;
6564: END;
6565: ELSE
6566: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6567: --fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6568: fnd_msg_pub.add;
6569: x_return_status := fnd_api.g_ret_sts_error;
6570:

Line 6567: --fnd_message.set_token('relationship_type_code',p_relationship_type_code);

6563: x_return_status := fnd_api.g_ret_sts_error;
6564: END;
6565: ELSE
6566: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6567: --fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6568: fnd_msg_pub.add;
6569: x_return_status := fnd_api.g_ret_sts_error;
6570:
6571: END IF;

Line 6585: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');

6581: x_return_status := fnd_api.g_ret_sts_success;
6582: END IF;
6583: EXCEPTION
6584: WHEN NO_DATA_FOUND THEN
6585: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6586: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6587: fnd_msg_pub.add;
6588: x_return_status := fnd_api.g_ret_sts_error;
6589: END;

Line 6586: fnd_message.set_token('relationship_type_code',p_relationship_type_code);

6582: END IF;
6583: EXCEPTION
6584: WHEN NO_DATA_FOUND THEN
6585: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
6586: fnd_message.set_token('relationship_type_code',p_relationship_type_code);
6587: fnd_msg_pub.add;
6588: x_return_status := fnd_api.g_ret_sts_error;
6589: END;
6590: ELSIF p_relationship_type_code IS NULL -- Added for bug 2151750

Line 6592: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');

6588: x_return_status := fnd_api.g_ret_sts_error;
6589: END;
6590: ELSIF p_relationship_type_code IS NULL -- Added for bug 2151750
6591: THEN
6592: fnd_message.set_name('CSI', 'CSI_NO_RELSHIP_CODE');
6593: fnd_msg_pub.add;
6594: x_return_status := fnd_api.g_ret_sts_error;
6595: END IF;
6596: END IF;

Line 6653: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');

6649: WHERE cii.instance_id=p_object_id
6650: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6651: EXCEPTION
6652: WHEN NO_DATA_FOUND THEN
6653: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
6654: fnd_message.set_token('object_id',p_object_id);
6655: fnd_msg_pub.add;
6656: x_return_status := fnd_api.g_ret_sts_error;
6657: RAISE fnd_api.g_exc_error;

Line 6654: fnd_message.set_token('object_id',p_object_id);

6650: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6651: EXCEPTION
6652: WHEN NO_DATA_FOUND THEN
6653: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
6654: fnd_message.set_token('object_id',p_object_id);
6655: fnd_msg_pub.add;
6656: x_return_status := fnd_api.g_ret_sts_error;
6657: RAISE fnd_api.g_exc_error;
6658: END;

Line 6677: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');

6673: FROM csi_item_instances
6674: WHERE instance_id=p_object_id;
6675: IF l_quantity IS NOT NULL THEN
6676: IF l_quantity<>1 THEN
6677: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6678: fnd_message.set_token('object_id',p_object_id);
6679: fnd_msg_pub.add;
6680: x_return_status := fnd_api.g_ret_sts_error;
6681: END IF;

Line 6678: fnd_message.set_token('object_id',p_object_id);

6674: WHERE instance_id=p_object_id;
6675: IF l_quantity IS NOT NULL THEN
6676: IF l_quantity<>1 THEN
6677: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6678: fnd_message.set_token('object_id',p_object_id);
6679: fnd_msg_pub.add;
6680: x_return_status := fnd_api.g_ret_sts_error;
6681: END IF;
6682: END IF;

Line 6686: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');

6682: END IF;
6683: /* commented by sk for bug 2151750
6684: IF l_location_type_code IS NOT NULL THEN
6685: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6686: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6687: fnd_message.set_token('object_id',p_object_id);
6688: fnd_msg_pub.add;
6689: x_return_status := fnd_api.g_ret_sts_error;
6690: END IF;

Line 6687: fnd_message.set_token('object_id',p_object_id);

6683: /* commented by sk for bug 2151750
6684: IF l_location_type_code IS NOT NULL THEN
6685: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6686: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6687: fnd_message.set_token('object_id',p_object_id);
6688: fnd_msg_pub.add;
6689: x_return_status := fnd_api.g_ret_sts_error;
6690: END IF;
6691: END IF;

Line 6732: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');

6728: --AND NVL(l_item_type,'X') IN ('ATO','PTO') THEN --NON-SERIALIZED ITEM
6729: -- Modified by sk for bug 2266166
6730: NULL;
6731: ELSE
6732: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6733: fnd_message.set_token('object_id',p_object_id);
6734: fnd_msg_pub.add;
6735: x_return_status := fnd_api.g_ret_sts_error;
6736: END IF;

Line 6733: fnd_message.set_token('object_id',p_object_id);

6729: -- Modified by sk for bug 2266166
6730: NULL;
6731: ELSE
6732: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6733: fnd_message.set_token('object_id',p_object_id);
6734: fnd_msg_pub.add;
6735: x_return_status := fnd_api.g_ret_sts_error;
6736: END IF;
6737:

Line 6744: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');

6740: NULL;
6741: END;
6742: EXCEPTION
6743: WHEN NO_DATA_FOUND THEN
6744: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
6745: fnd_message.set_token('object_id',p_object_id);
6746: fnd_msg_pub.add;
6747: x_return_status := fnd_api.g_ret_sts_error;
6748: END;

Line 6745: fnd_message.set_token('object_id',p_object_id);

6741: END;
6742: EXCEPTION
6743: WHEN NO_DATA_FOUND THEN
6744: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
6745: fnd_message.set_token('object_id',p_object_id);
6746: fnd_msg_pub.add;
6747: x_return_status := fnd_api.g_ret_sts_error;
6748: END;
6749: ELSE

Line 6750: fnd_message.set_name('CSI', 'CSI_NO_OBJ_ID_PASSED');

6746: fnd_msg_pub.add;
6747: x_return_status := fnd_api.g_ret_sts_error;
6748: END;
6749: ELSE
6750: fnd_message.set_name('CSI', 'CSI_NO_OBJ_ID_PASSED');
6751: fnd_msg_pub.add;
6752: x_return_status := fnd_api.g_ret_sts_error;
6753: END IF;
6754:

Line 6775: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');

6771: WHERE instance_id=p_object_id;
6772:
6773: IF l_quantity IS NOT NULL THEN
6774: IF l_quantity<>1 THEN
6775: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6776: fnd_message.set_token('object_id',p_object_id);
6777: fnd_msg_pub.add;
6778: x_return_status := fnd_api.g_ret_sts_error;
6779: END IF;

Line 6776: fnd_message.set_token('object_id',p_object_id);

6772:
6773: IF l_quantity IS NOT NULL THEN
6774: IF l_quantity<>1 THEN
6775: fnd_message.set_name('CSI', 'CSI_QTY_NOTEQUAL_TO_ONE');
6776: fnd_message.set_token('object_id',p_object_id);
6777: fnd_msg_pub.add;
6778: x_return_status := fnd_api.g_ret_sts_error;
6779: END IF;
6780: END IF;

Line 6784: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');

6780: END IF;
6781: /* commented by sk for bug 2151750
6782: IF l_location_type_code IS NOT NULL THEN
6783: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6784: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6785: fnd_message.set_token('object_id',p_object_id);
6786: fnd_msg_pub.add;
6787: x_return_status := fnd_api.g_ret_sts_error;
6788: END IF;

Line 6785: fnd_message.set_token('object_id',p_object_id);

6781: /* commented by sk for bug 2151750
6782: IF l_location_type_code IS NOT NULL THEN
6783: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6784: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6785: fnd_message.set_token('object_id',p_object_id);
6786: fnd_msg_pub.add;
6787: x_return_status := fnd_api.g_ret_sts_error;
6788: END IF;
6789: END IF;

Line 6830: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');

6826: --NVL(l_item_type,'X') IN ('ATO','PTO') THEN --NON-SERIALIZED ITEM
6827: -- Modified by sk for bug 2266166
6828: NULL;
6829: ELSE
6830: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6831: fnd_message.set_token('object_id',p_object_id);
6832: fnd_msg_pub.add;
6833: x_return_status := fnd_api.g_ret_sts_error;
6834: END IF;

Line 6831: fnd_message.set_token('object_id',p_object_id);

6827: -- Modified by sk for bug 2266166
6828: NULL;
6829: ELSE
6830: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
6831: fnd_message.set_token('object_id',p_object_id);
6832: fnd_msg_pub.add;
6833: x_return_status := fnd_api.g_ret_sts_error;
6834: END IF;
6835:

Line 6843: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');

6839: END;
6840:
6841: EXCEPTION
6842: WHEN NO_DATA_FOUND THEN
6843: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
6844: fnd_message.set_token('object_id',p_object_id);
6845: fnd_msg_pub.add;
6846: x_return_status := fnd_api.g_ret_sts_error;
6847: END;

Line 6844: fnd_message.set_token('object_id',p_object_id);

6840:
6841: EXCEPTION
6842: WHEN NO_DATA_FOUND THEN
6843: fnd_message.set_name('CSI', 'CSI_INVALID_OBJECT_ID');
6844: fnd_message.set_token('object_id',p_object_id);
6845: fnd_msg_pub.add;
6846: x_return_status := fnd_api.g_ret_sts_error;
6847: END;
6848: END IF;

Line 6898: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');

6894: WHERE cii.instance_id=p_subject_id
6895: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6896: EXCEPTION
6897: WHEN NO_DATA_FOUND THEN
6898: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
6899: fnd_message.set_token('subject_id',p_subject_id);
6900: fnd_msg_pub.add;
6901: x_return_status := fnd_api.g_ret_sts_error;
6902: RAISE fnd_api.g_exc_error;

Line 6899: fnd_message.set_token('subject_id',p_subject_id);

6895: AND (SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE));
6896: EXCEPTION
6897: WHEN NO_DATA_FOUND THEN
6898: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
6899: fnd_message.set_token('subject_id',p_subject_id);
6900: fnd_msg_pub.add;
6901: x_return_status := fnd_api.g_ret_sts_error;
6902: RAISE fnd_api.g_exc_error;
6903: END;

Line 6914: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');

6910: WHERE instance_id=p_subject_id;
6911: /* commented by sk for bug 2151750
6912: IF l_location_type_code IS NOT NULL THEN
6913: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6914: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6915: fnd_message.set_token('subject_id',p_subject_id);
6916: fnd_msg_pub.add;
6917: x_return_status := fnd_api.g_ret_sts_error;
6918: END IF;

Line 6915: fnd_message.set_token('subject_id',p_subject_id);

6911: /* commented by sk for bug 2151750
6912: IF l_location_type_code IS NOT NULL THEN
6913: IF UPPER(l_location_type_code) = 'INVENTORY' THEN
6914: fnd_message.set_name('CSI', 'CSI_INVALID_LOCATION_TYPE');
6915: fnd_message.set_token('subject_id',p_subject_id);
6916: fnd_msg_pub.add;
6917: x_return_status := fnd_api.g_ret_sts_error;
6918: END IF;
6919: END IF;

Line 6923: fnd_message.set_name('CSI', 'CSI_INVALID_SUBJECT_ID');

6919: END IF;
6920: */
6921: EXCEPTION
6922: WHEN NO_DATA_FOUND THEN
6923: fnd_message.set_name('CSI', 'CSI_INVALID_SUBJECT_ID');
6924: fnd_message.set_token('subject_id',p_subject_id);
6925: fnd_msg_pub.add;
6926: x_return_status := fnd_api.g_ret_sts_error;
6927: END;

Line 6924: fnd_message.set_token('subject_id',p_subject_id);

6920: */
6921: EXCEPTION
6922: WHEN NO_DATA_FOUND THEN
6923: fnd_message.set_name('CSI', 'CSI_INVALID_SUBJECT_ID');
6924: fnd_message.set_token('subject_id',p_subject_id);
6925: fnd_msg_pub.add;
6926: x_return_status := fnd_api.g_ret_sts_error;
6927: END;
6928: END IF;

Line 6958: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');

6954: -- initialize api return status to success
6955: x_return_status := fnd_api.g_ret_sts_success;
6956: IF(p_validation_mode ='CREATE') THEN
6957: IF ((p_active_end_date IS NOT NULL) AND (p_active_end_date <> fnd_api.g_miss_date)) THEN
6958: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
6959: fnd_message.set_token('ACTIVE_END_DATE',p_active_end_date);
6960: fnd_msg_pub.add;
6961: x_return_status := fnd_api.g_ret_sts_error;
6962: END IF;

Line 6959: fnd_message.set_token('ACTIVE_END_DATE',p_active_end_date);

6955: x_return_status := fnd_api.g_ret_sts_success;
6956: IF(p_validation_mode ='CREATE') THEN
6957: IF ((p_active_end_date IS NOT NULL) AND (p_active_end_date <> fnd_api.g_miss_date)) THEN
6958: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
6959: fnd_message.set_token('ACTIVE_END_DATE',p_active_end_date);
6960: fnd_msg_pub.add;
6961: x_return_status := fnd_api.g_ret_sts_error;
6962: END IF;
6963: END IF;

Line 7000: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');

6996:
6997:
6998: IF( (p_validation_mode = 'UPDATE') OR (p_validation_mode = 'EXPIRE') ) THEN
6999: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
7000: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
7001: fnd_msg_pub.add;
7002: x_return_status := fnd_api.g_ret_sts_error;
7003: ELSE
7004: x_return_status := fnd_api.g_ret_sts_success;