eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_SYSTEMS_PVT dependencies on FND_MESSAGE

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

986: AND ((p_system_query_rec.system_type_code IS NULL) OR (p_system_query_rec.system_type_code = fnd_api.g_miss_char))
987: AND ((p_system_query_rec.system_number IS NULL) OR (p_system_query_rec.system_number = fnd_api.g_miss_char))
988: )
989: THEN
990: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
991: fnd_msg_pub.add;
992: x_return_status := fnd_api.g_ret_sts_error;
993: RAISE fnd_api.g_exc_error;
994: END IF;

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

1041: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
1042: THEN
1043: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
1044: 'Please provide a valid datetime stamp.');
1045: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
1046: FND_MSG_PUB.ADD;
1047: ELSE
1048: get_history( p_sys_rec => l_sys_rec
1049: ,p_new_rec => l_new_rec

Line 1149: FND_MESSAGE.SET_NAME('CSI', 'CSI_SYSTEM_DUP_NAME');

1145: x_return_status := fnd_api.g_ret_sts_success;
1146: OPEN dup_cur;
1147: FETCH dup_cur INTO l_dummy;
1148: IF (dup_cur%FOUND) THEN
1149: FND_MESSAGE.SET_NAME('CSI', 'CSI_SYSTEM_DUP_NAME');
1150: fnd_msg_pub.add;
1151: x_return_status := fnd_api.g_ret_sts_error;
1152: END IF;
1153:

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

1195: OPEN par_chld_csr;
1196: FETCH par_chld_csr INTO l_dummy;
1197: IF (par_chld_csr%found) THEN
1198: --CLOSE par_chld_csr;
1199: fnd_message.set_name('CSI','CSI_CHILD_PARENT_REL_LOOP');
1200: fnd_msg_pub.add;
1201: x_return_status := fnd_api.g_ret_sts_error;
1202: END IF;
1203: CLOSE par_chld_csr;

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

1202: END IF;
1203: CLOSE par_chld_csr;
1204:
1205: ELSE
1206: fnd_message.set_name('CSI', 'CSI_PARENT_CHILD_INVALID');
1207: fnd_msg_pub.add;
1208: x_return_status := fnd_api.g_ret_sts_error;
1209: END IF;
1210:

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

1243: --
1244: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
1245: --
1246: IF l_full_dump IS NULL THEN
1247: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:

Line 2666: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');

2662: l_month := p_system_rec.coterminate_day_month||'-1996';
2663: l_date := to_date(l_month, 'DD-MM-YYYY');
2664: EXCEPTION
2665: WHEN OTHERS THEN
2666: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');
2667: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);
2668: fnd_msg_pub.add;
2669: RAISE fnd_api.g_exc_error;
2670: END;

Line 2667: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);

2663: l_date := to_date(l_month, 'DD-MM-YYYY');
2664: EXCEPTION
2665: WHEN OTHERS THEN
2666: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');
2667: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);
2668: fnd_msg_pub.add;
2669: RAISE fnd_api.g_exc_error;
2670: END;
2671: END IF;

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

2741:
2742: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2743:
2744:
2745: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
2746: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
2747: fnd_msg_pub.add;
2748:
2749: RAISE fnd_api.g_exc_error;

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

2742: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2743:
2744:
2745: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
2746: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
2747: fnd_msg_pub.add;
2748:
2749: RAISE fnd_api.g_exc_error;
2750: RETURN;

Line 3125: fnd_message.set_name('CSI', 'CSI_API_MANDATORY_CUSTOMER');

3121: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
3122: END IF;
3123: --
3124: IF p_system_rec.customer_id IS NULL THEN
3125: fnd_message.set_name('CSI', 'CSI_API_MANDATORY_CUSTOMER');
3126: fnd_msg_pub.add;
3127: RAISE fnd_api.g_exc_error;
3128: END IF;
3129: --

Line 3131: fnd_message.set_name('CSI', 'CSI_API_MANDATORY_SYSTEM_TYPE');

3127: RAISE fnd_api.g_exc_error;
3128: END IF;
3129: --
3130: IF p_system_rec.system_type_code IS NULL THEN
3131: fnd_message.set_name('CSI', 'CSI_API_MANDATORY_SYSTEM_TYPE');
3132: fnd_msg_pub.add;
3133: RAISE fnd_api.g_exc_error;
3134: END IF;
3135: --

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

3137: OPEN systems_csr (p_system_rec.system_id);
3138: FETCH systems_csr INTO l_sys_csr;
3139: IF ( (l_sys_csr.object_version_number<>p_system_rec.object_version_number)
3140: AND (p_system_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
3141: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
3142: fnd_msg_pub.add;
3143: RAISE fnd_api.g_exc_error;
3144: END IF;
3145: CLOSE systems_csr;

Line 3238: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');

3234: l_month := p_system_rec.coterminate_day_month||'-1996';
3235: l_date := to_date(l_month, 'DD-MM-YYYY');
3236: EXCEPTION
3237: WHEN OTHERS THEN
3238: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');
3239: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);
3240: fnd_msg_pub.add;
3241: RAISE fnd_api.g_exc_error;
3242: END;

Line 3239: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);

3235: l_date := to_date(l_month, 'DD-MM-YYYY');
3236: EXCEPTION
3237: WHEN OTHERS THEN
3238: fnd_message.set_name('CSI','CSI_INVALID_COTERM_DATE');
3239: fnd_message.set_token('Coterminate_Day_Month',p_system_rec.coterminate_day_month);
3240: fnd_msg_pub.add;
3241: RAISE fnd_api.g_exc_error;
3242: END;
3243: END IF;

Line 3275: fnd_message.set_name('CSI','CSI_FAILED_TO_EXPIRE_SYSTEM');

3271: x_msg_data => x_msg_data
3272: );
3273:
3274: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3275: fnd_message.set_name('CSI','CSI_FAILED_TO_EXPIRE_SYSTEM');
3276: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );
3277: fnd_msg_pub.add;
3278: RAISE fnd_api.g_exc_error;
3279: END IF;

Line 3276: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );

3272: );
3273:
3274: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3275: fnd_message.set_name('CSI','CSI_FAILED_TO_EXPIRE_SYSTEM');
3276: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );
3277: fnd_msg_pub.add;
3278: RAISE fnd_api.g_exc_error;
3279: END IF;
3280: ELSIF ( p_system_rec.end_date_active IS NOT NULL

Line 3302: fnd_message.set_name('CSI','CSI_HAS_TXNS');

3298: END;
3299:
3300: IF l_transaction_date > p_system_rec.end_date_active
3301: THEN
3302: fnd_message.set_name('CSI','CSI_HAS_TXNS');
3303: fnd_message.set_token('END_DATE_ACTIVE',p_system_rec.end_date_active );
3304: fnd_msg_pub.add;
3305: RAISE fnd_api.g_exc_error;
3306: -- srramakr. If the Active end date is < sysdate, then call to Expire_System

Line 3303: fnd_message.set_token('END_DATE_ACTIVE',p_system_rec.end_date_active );

3299:
3300: IF l_transaction_date > p_system_rec.end_date_active
3301: THEN
3302: fnd_message.set_name('CSI','CSI_HAS_TXNS');
3303: fnd_message.set_token('END_DATE_ACTIVE',p_system_rec.end_date_active );
3304: fnd_msg_pub.add;
3305: RAISE fnd_api.g_exc_error;
3306: -- srramakr. If the Active end date is < sysdate, then call to Expire_System
3307: -- was missed. Fixed as a part of Bug 2230262.

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

3319: x_msg_data => x_msg_data
3320: );
3321:
3322: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3323: fnd_message.set_name('CSI','CSI_FAILED_TO_EXPIRE_SYSTEM');
3324: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );
3325: fnd_msg_pub.add;
3326: RAISE fnd_api.g_exc_error;
3327: END IF;

Line 3324: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );

3320: );
3321:
3322: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3323: fnd_message.set_name('CSI','CSI_FAILED_TO_EXPIRE_SYSTEM');
3324: fnd_message.set_token('SYSTEM_ID',p_system_rec.system_id );
3325: fnd_msg_pub.add;
3326: RAISE fnd_api.g_exc_error;
3327: END IF;
3328: END IF;

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

3443: ,x_msg_data => x_msg_data
3444: );
3445:
3446: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3447: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
3448: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
3449: fnd_msg_pub.add;
3450:
3451: RAISE fnd_api.g_exc_error;

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

3444: );
3445:
3446: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3447: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
3448: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
3449: fnd_msg_pub.add;
3450:
3451: RAISE fnd_api.g_exc_error;
3452: RETURN;

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

4102: OPEN systems_csr (p_system_rec.system_id);
4103: FETCH systems_csr INTO l_sys_csr;
4104: IF ( (l_sys_csr.object_version_number<>p_system_rec.object_version_number)
4105: AND (p_system_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
4106: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
4107: fnd_msg_pub.add;
4108: RAISE fnd_api.g_exc_error;
4109: END IF;
4110: CLOSE systems_csr;

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

4157: ,x_msg_data => x_msg_data
4158: );
4159:
4160: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4161: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
4162: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
4163: fnd_msg_pub.add;
4164:
4165: RAISE fnd_api.g_exc_error;

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

4158: );
4159:
4160: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4161: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_TXN');
4162: fnd_message.set_token('transaction_id',p_txn_rec.transaction_id );
4163: fnd_msg_pub.add;
4164:
4165: RAISE fnd_api.g_exc_error;
4166: RETURN;

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

4227: ,x_msg_count => x_msg_count
4228: ,x_msg_data => x_msg_data
4229: );
4230: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4231: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4232: fnd_message.set_token('instance_id',expire_csr.instance_id);
4233: fnd_msg_pub.add;
4234: RAISE fnd_api.g_exc_error;
4235: RETURN;

Line 4232: fnd_message.set_token('instance_id',expire_csr.instance_id);

4228: ,x_msg_data => x_msg_data
4229: );
4230: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4231: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
4232: fnd_message.set_token('instance_id',expire_csr.instance_id);
4233: fnd_msg_pub.add;
4234: RAISE fnd_api.g_exc_error;
4235: RETURN;
4236: END IF;

Line 4419: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');

4415: SELECT 'x'
4416: INTO l_dummy
4417: FROM csi_systems_b
4418: WHERE system_id=p_system_id;
4419: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');
4420: fnd_message.set_token('system_id',p_system_id);
4421: fnd_msg_pub.add;
4422: x_return_status := fnd_api.g_ret_sts_error;
4423: EXCEPTION

Line 4420: fnd_message.set_token('system_id',p_system_id);

4416: INTO l_dummy
4417: FROM csi_systems_b
4418: WHERE system_id=p_system_id;
4419: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');
4420: fnd_message.set_token('system_id',p_system_id);
4421: fnd_msg_pub.add;
4422: x_return_status := fnd_api.g_ret_sts_error;
4423: EXCEPTION
4424: WHEN no_data_found THEN

Line 4439: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');

4435: FROM csi_systems_b
4436: WHERE system_id=p_system_id;
4437: EXCEPTION
4438: WHEN no_data_found THEN
4439: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');
4440: fnd_message.set_token('system_id',p_system_id);
4441: fnd_msg_pub.add;
4442: x_return_status := fnd_api.g_ret_sts_error;
4443: END;

Line 4440: fnd_message.set_token('system_id',p_system_id);

4436: WHERE system_id=p_system_id;
4437: EXCEPTION
4438: WHEN no_data_found THEN
4439: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');
4440: fnd_message.set_token('system_id',p_system_id);
4441: fnd_msg_pub.add;
4442: x_return_status := fnd_api.g_ret_sts_error;
4443: END;
4444: ELSE

Line 4445: fnd_message.set_name('CSI', 'CSI_NO_SYSTEM_ID');

4441: fnd_msg_pub.add;
4442: x_return_status := fnd_api.g_ret_sts_error;
4443: END;
4444: ELSE
4445: fnd_message.set_name('CSI', 'CSI_NO_SYSTEM_ID');
4446: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_ID');
4447: fnd_msg_pub.add;
4448: x_return_status := fnd_api.g_ret_sts_error;
4449: END IF;

Line 4446: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_ID');

4442: x_return_status := fnd_api.g_ret_sts_error;
4443: END;
4444: ELSE
4445: fnd_message.set_name('CSI', 'CSI_NO_SYSTEM_ID');
4446: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_ID');
4447: fnd_msg_pub.add;
4448: x_return_status := fnd_api.g_ret_sts_error;
4449: END IF;
4450:

Line 4504: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');

4500: WHERE party_id=p_customer_id; */
4501:
4502: EXCEPTION
4503: WHEN no_data_found THEN
4504: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');
4505: fnd_message.set_token('customer_id',p_customer_id);
4506: fnd_msg_pub.add;
4507: x_return_status := fnd_api.g_ret_sts_error;
4508: END;

Line 4505: fnd_message.set_token('customer_id',p_customer_id);

4501:
4502: EXCEPTION
4503: WHEN no_data_found THEN
4504: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');
4505: fnd_message.set_token('customer_id',p_customer_id);
4506: fnd_msg_pub.add;
4507: x_return_status := fnd_api.g_ret_sts_error;
4508: END;
4509: ELSE

Line 4510: fnd_message.set_name('CSI', 'CSI_CUST_ID_NOT_PASSED');

4506: fnd_msg_pub.add;
4507: x_return_status := fnd_api.g_ret_sts_error;
4508: END;
4509: ELSE
4510: fnd_message.set_name('CSI', 'CSI_CUST_ID_NOT_PASSED');
4511: fnd_message.set_token('REQUIRED_PARAM','CUSTOMER_ID');
4512: fnd_msg_pub.add;
4513: x_return_status := fnd_api.g_ret_sts_error;
4514:

Line 4511: fnd_message.set_token('REQUIRED_PARAM','CUSTOMER_ID');

4507: x_return_status := fnd_api.g_ret_sts_error;
4508: END;
4509: ELSE
4510: fnd_message.set_name('CSI', 'CSI_CUST_ID_NOT_PASSED');
4511: fnd_message.set_token('REQUIRED_PARAM','CUSTOMER_ID');
4512: fnd_msg_pub.add;
4513: x_return_status := fnd_api.g_ret_sts_error;
4514:
4515: END IF;

Line 4533: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');

4529: FROM hz_parties
4530: WHERE party_id=p_customer_id; */
4531: EXCEPTION
4532: WHEN no_data_found THEN
4533: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');
4534: fnd_message.set_token('customer_id',p_customer_id);
4535: fnd_msg_pub.add;
4536: x_return_status := fnd_api.g_ret_sts_error;
4537: END;

Line 4534: fnd_message.set_token('customer_id',p_customer_id);

4530: WHERE party_id=p_customer_id; */
4531: EXCEPTION
4532: WHEN no_data_found THEN
4533: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');
4534: fnd_message.set_token('customer_id',p_customer_id);
4535: fnd_msg_pub.add;
4536: x_return_status := fnd_api.g_ret_sts_error;
4537: END;
4538: END IF;

Line 4584: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');

4580: WHERE lookup_type=l_sys_lookup_type
4581: AND lookup_code=p_system_type_code;
4582: EXCEPTION
4583: WHEN no_data_found THEN
4584: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');
4585: fnd_message.set_token('system_type_code',p_system_type_code);
4586: fnd_msg_pub.add;
4587: x_return_status := fnd_api.g_ret_sts_error;
4588: END;

Line 4585: fnd_message.set_token('system_type_code',p_system_type_code);

4581: AND lookup_code=p_system_type_code;
4582: EXCEPTION
4583: WHEN no_data_found THEN
4584: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');
4585: fnd_message.set_token('system_type_code',p_system_type_code);
4586: fnd_msg_pub.add;
4587: x_return_status := fnd_api.g_ret_sts_error;
4588: END;
4589: ELSE

Line 4590: fnd_message.set_name('CSI', 'CSI_NO_SYS_TYPE_CODE');

4586: fnd_msg_pub.add;
4587: x_return_status := fnd_api.g_ret_sts_error;
4588: END;
4589: ELSE
4590: fnd_message.set_name('CSI', 'CSI_NO_SYS_TYPE_CODE');
4591: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_TYPE_CODE');
4592:
4593: fnd_msg_pub.add;
4594: x_return_status := fnd_api.g_ret_sts_error;

Line 4591: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_TYPE_CODE');

4587: x_return_status := fnd_api.g_ret_sts_error;
4588: END;
4589: ELSE
4590: fnd_message.set_name('CSI', 'CSI_NO_SYS_TYPE_CODE');
4591: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_TYPE_CODE');
4592:
4593: fnd_msg_pub.add;
4594: x_return_status := fnd_api.g_ret_sts_error;
4595:

Line 4608: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');

4604: WHERE lookup_type=l_sys_lookup_type
4605: AND lookup_code=p_system_type_code;
4606: EXCEPTION
4607: WHEN no_data_found THEN
4608: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');
4609: fnd_message.set_token('system_type_code',p_system_type_code);
4610: fnd_msg_pub.add;
4611: x_return_status := fnd_api.g_ret_sts_error;
4612: END;

Line 4609: fnd_message.set_token('system_type_code',p_system_type_code);

4605: AND lookup_code=p_system_type_code;
4606: EXCEPTION
4607: WHEN no_data_found THEN
4608: fnd_message.set_name('CSI', 'CSI_INVALID_SYS_TYPE_CODE');
4609: fnd_message.set_token('system_type_code',p_system_type_code);
4610: fnd_msg_pub.add;
4611: x_return_status := fnd_api.g_ret_sts_error;
4612: END;
4613: END IF;

Line 4660: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');

4656: FROM csi_systems_b
4657: WHERE system_id=p_parent_system_id;
4658: EXCEPTION
4659: WHEN no_data_found THEN
4660: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');
4661: fnd_message.set_token('parent_system_id',p_parent_system_id);
4662: fnd_msg_pub.add;
4663: x_return_status := fnd_api.g_ret_sts_error;
4664: END;

Line 4661: fnd_message.set_token('parent_system_id',p_parent_system_id);

4657: WHERE system_id=p_parent_system_id;
4658: EXCEPTION
4659: WHEN no_data_found THEN
4660: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');
4661: fnd_message.set_token('parent_system_id',p_parent_system_id);
4662: fnd_msg_pub.add;
4663: x_return_status := fnd_api.g_ret_sts_error;
4664: END;
4665: END IF;

Line 4678: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');

4674: FROM csi_systems_b
4675: WHERE system_id=p_parent_system_id;
4676: EXCEPTION
4677: WHEN no_data_found THEN
4678: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');
4679: fnd_message.set_token('parent_system_id',p_parent_system_id);
4680: fnd_msg_pub.add;
4681: x_return_status := fnd_api.g_ret_sts_error;
4682: END;

Line 4679: fnd_message.set_token('parent_system_id',p_parent_system_id);

4675: WHERE system_id=p_parent_system_id;
4676: EXCEPTION
4677: WHEN no_data_found THEN
4678: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');
4679: fnd_message.set_token('parent_system_id',p_parent_system_id);
4680: fnd_msg_pub.add;
4681: x_return_status := fnd_api.g_ret_sts_error;
4682: END;
4683: END IF;

Line 4727: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');

4723: FROM hz_parties
4724: WHERE party_id=p_ship_to_contact_id;
4725: EXCEPTION
4726: WHEN no_data_found THEN
4727: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');
4728: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);
4729: fnd_msg_pub.add;
4730: x_return_status := fnd_api.g_ret_sts_error;
4731: END;

Line 4728: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);

4724: WHERE party_id=p_ship_to_contact_id;
4725: EXCEPTION
4726: WHEN no_data_found THEN
4727: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');
4728: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);
4729: fnd_msg_pub.add;
4730: x_return_status := fnd_api.g_ret_sts_error;
4731: END;
4732:

Line 4744: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');

4740: FROM hz_parties
4741: WHERE party_id=p_ship_to_contact_id;
4742: EXCEPTION
4743: WHEN no_data_found THEN
4744: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');
4745: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);
4746: fnd_msg_pub.add;
4747: x_return_status := fnd_api.g_ret_sts_error;
4748: END;

Line 4745: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);

4741: WHERE party_id=p_ship_to_contact_id;
4742: EXCEPTION
4743: WHEN no_data_found THEN
4744: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');
4745: fnd_message.set_token('ship_to_contact_id',p_ship_to_contact_id);
4746: fnd_msg_pub.add;
4747: x_return_status := fnd_api.g_ret_sts_error;
4748: END;
4749: END IF;

Line 4793: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');

4789: FROM hz_parties
4790: WHERE party_id=p_bill_to_contact_id;
4791: EXCEPTION
4792: WHEN no_data_found THEN
4793: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');
4794: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);
4795: fnd_msg_pub.add;
4796: x_return_status := fnd_api.g_ret_sts_error;
4797: END;

Line 4794: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);

4790: WHERE party_id=p_bill_to_contact_id;
4791: EXCEPTION
4792: WHEN no_data_found THEN
4793: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');
4794: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);
4795: fnd_msg_pub.add;
4796: x_return_status := fnd_api.g_ret_sts_error;
4797: END;
4798: END IF;

Line 4809: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');

4805: FROM hz_parties
4806: WHERE party_id=p_bill_to_contact_id;
4807: EXCEPTION
4808: WHEN no_data_found THEN
4809: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');
4810: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);
4811: fnd_msg_pub.add;
4812: x_return_status := fnd_api.g_ret_sts_error;
4813: END;

Line 4810: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);

4806: WHERE party_id=p_bill_to_contact_id;
4807: EXCEPTION
4808: WHEN no_data_found THEN
4809: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');
4810: fnd_message.set_token('bill_to_contact_id',p_bill_to_contact_id);
4811: fnd_msg_pub.add;
4812: x_return_status := fnd_api.g_ret_sts_error;
4813: END;
4814: END IF;

Line 4858: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');

4854: FROM hz_parties
4855: WHERE party_id=p_technical_contact_id;
4856: EXCEPTION
4857: WHEN no_data_found THEN
4858: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');
4859: fnd_message.set_token('technical_contact_id',p_technical_contact_id);
4860: fnd_msg_pub.add;
4861: x_return_status := fnd_api.g_ret_sts_error;
4862: END;

Line 4859: fnd_message.set_token('technical_contact_id',p_technical_contact_id);

4855: WHERE party_id=p_technical_contact_id;
4856: EXCEPTION
4857: WHEN no_data_found THEN
4858: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');
4859: fnd_message.set_token('technical_contact_id',p_technical_contact_id);
4860: fnd_msg_pub.add;
4861: x_return_status := fnd_api.g_ret_sts_error;
4862: END;
4863: END IF;

Line 4874: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');

4870: FROM hz_parties
4871: WHERE party_id=p_technical_contact_id;
4872: EXCEPTION
4873: WHEN no_data_found THEN
4874: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');
4875: fnd_message.set_token('technical_contact_id',p_technical_contact_id);
4876: fnd_msg_pub.add;
4877: x_return_status := fnd_api.g_ret_sts_error;
4878: END;

Line 4875: fnd_message.set_token('technical_contact_id',p_technical_contact_id);

4871: WHERE party_id=p_technical_contact_id;
4872: EXCEPTION
4873: WHEN no_data_found THEN
4874: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');
4875: fnd_message.set_token('technical_contact_id',p_technical_contact_id);
4876: fnd_msg_pub.add;
4877: x_return_status := fnd_api.g_ret_sts_error;
4878: END;
4879: END IF;

Line 4922: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');

4918: FROM hz_parties
4919: WHERE party_id=p_service_admin_contact_id;
4920: EXCEPTION
4921: WHEN no_data_found THEN
4922: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');
4923: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);
4924: fnd_msg_pub.add;
4925: x_return_status := fnd_api.g_ret_sts_error;
4926: END;

Line 4923: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);

4919: WHERE party_id=p_service_admin_contact_id;
4920: EXCEPTION
4921: WHEN no_data_found THEN
4922: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');
4923: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);
4924: fnd_msg_pub.add;
4925: x_return_status := fnd_api.g_ret_sts_error;
4926: END;
4927: END IF;

Line 4938: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');

4934: FROM hz_parties
4935: WHERE party_id=p_service_admin_contact_id;
4936: EXCEPTION
4937: WHEN no_data_found THEN
4938: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');
4939: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);
4940: fnd_msg_pub.add;
4941: x_return_status := fnd_api.g_ret_sts_error;
4942: END;

Line 4939: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);

4935: WHERE party_id=p_service_admin_contact_id;
4936: EXCEPTION
4937: WHEN no_data_found THEN
4938: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');
4939: fnd_message.set_token('service_admin_contact_id',p_service_admin_contact_id);
4940: fnd_msg_pub.add;
4941: x_return_status := fnd_api.g_ret_sts_error;
4942: END;
4943: END IF;

Line 4987: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');

4983: WHERE site_use_id = p_ship_to_site_use_id
4984: AND site_use_code = 'SHIP_TO';
4985: EXCEPTION
4986: WHEN no_data_found THEN
4987: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');
4988: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);
4989: fnd_msg_pub.add;
4990: x_return_status := fnd_api.g_ret_sts_error;
4991: END;

Line 4988: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);

4984: AND site_use_code = 'SHIP_TO';
4985: EXCEPTION
4986: WHEN no_data_found THEN
4987: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');
4988: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);
4989: fnd_msg_pub.add;
4990: x_return_status := fnd_api.g_ret_sts_error;
4991: END;
4992: END IF;

Line 5004: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');

5000: WHERE site_use_id = p_ship_to_site_use_id
5001: AND site_use_code = 'SHIP_TO';
5002: EXCEPTION
5003: WHEN no_data_found THEN
5004: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');
5005: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);
5006: fnd_msg_pub.add;
5007: x_return_status := fnd_api.g_ret_sts_error;
5008: END;

Line 5005: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);

5001: AND site_use_code = 'SHIP_TO';
5002: EXCEPTION
5003: WHEN no_data_found THEN
5004: fnd_message.set_name('CSI', 'CSI_INVALID_SHIP_TO_ID');
5005: fnd_message.set_token('ship_to_site_use_id',p_ship_to_site_use_id);
5006: fnd_msg_pub.add;
5007: x_return_status := fnd_api.g_ret_sts_error;
5008: END;
5009: END IF;

Line 5054: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');

5050: WHERE site_use_id = p_bill_to_site_use_id
5051: AND site_use_code = 'BILL_TO';
5052: EXCEPTION
5053: WHEN no_data_found THEN
5054: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');
5055: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);
5056: fnd_msg_pub.add;
5057: x_return_status := fnd_api.g_ret_sts_error;
5058: END;

Line 5055: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);

5051: AND site_use_code = 'BILL_TO';
5052: EXCEPTION
5053: WHEN no_data_found THEN
5054: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');
5055: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);
5056: fnd_msg_pub.add;
5057: x_return_status := fnd_api.g_ret_sts_error;
5058: END;
5059: END IF;

Line 5071: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');

5067: WHERE site_use_id = p_bill_to_site_use_id
5068: AND site_use_code = 'BILL_TO';
5069: EXCEPTION
5070: WHEN no_data_found THEN
5071: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');
5072: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);
5073: fnd_msg_pub.add;
5074: x_return_status := fnd_api.g_ret_sts_error;
5075: END;

Line 5072: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);

5068: AND site_use_code = 'BILL_TO';
5069: EXCEPTION
5070: WHEN no_data_found THEN
5071: fnd_message.set_name('CSI', 'CSI_INVALID_BILL_TO_ID');
5072: fnd_message.set_token('bill_to_site_use_id',p_bill_to_site_use_id);
5073: fnd_msg_pub.add;
5074: x_return_status := fnd_api.g_ret_sts_error;
5075: END;
5076: END IF;

Line 5121: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');

5117: FROM hz_party_sites
5118: WHERE party_site_id=p_install_site_use_id;
5119: EXCEPTION
5120: WHEN no_data_found THEN
5121: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');
5122: fnd_message.set_token('install_site_use_id',p_install_site_use_id);
5123: fnd_msg_pub.add;
5124: x_return_status := fnd_api.g_ret_sts_error;
5125: END;

Line 5122: fnd_message.set_token('install_site_use_id',p_install_site_use_id);

5118: WHERE party_site_id=p_install_site_use_id;
5119: EXCEPTION
5120: WHEN no_data_found THEN
5121: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');
5122: fnd_message.set_token('install_site_use_id',p_install_site_use_id);
5123: fnd_msg_pub.add;
5124: x_return_status := fnd_api.g_ret_sts_error;
5125: END;
5126: END IF;

Line 5137: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');

5133: FROM hz_party_sites
5134: WHERE party_site_id=p_install_site_use_id;
5135: EXCEPTION
5136: WHEN no_data_found THEN
5137: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');
5138: fnd_message.set_token('install_site_use_id',p_install_site_use_id);
5139: fnd_msg_pub.add;
5140: x_return_status := fnd_api.g_ret_sts_error;
5141: END;

Line 5138: fnd_message.set_token('install_site_use_id',p_install_site_use_id);

5134: WHERE party_site_id=p_install_site_use_id;
5135: EXCEPTION
5136: WHEN no_data_found THEN
5137: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');
5138: fnd_message.set_token('install_site_use_id',p_install_site_use_id);
5139: fnd_msg_pub.add;
5140: x_return_status := fnd_api.g_ret_sts_error;
5141: END;
5142: END IF;

Line 5183: fnd_message.set_name('CSI', 'CSI_INVALID_AUTOSYS_ID');

5179: FROM csi_systems_b
5180: WHERE system_id=p_auto_sys_id;
5181: EXCEPTION
5182: WHEN no_data_found THEN
5183: fnd_message.set_name('CSI', 'CSI_INVALID_AUTOSYS_ID');
5184: fnd_message.set_token('autocreated_from_system_id',p_auto_sys_id);
5185: fnd_msg_pub.add;
5186: x_return_status := fnd_api.g_ret_sts_error;
5187: END;

Line 5184: fnd_message.set_token('autocreated_from_system_id',p_auto_sys_id);

5180: WHERE system_id=p_auto_sys_id;
5181: EXCEPTION
5182: WHEN no_data_found THEN
5183: fnd_message.set_name('CSI', 'CSI_INVALID_AUTOSYS_ID');
5184: fnd_message.set_token('autocreated_from_system_id',p_auto_sys_id);
5185: fnd_msg_pub.add;
5186: x_return_status := fnd_api.g_ret_sts_error;
5187: END;
5188: END IF;

Line 5227: fnd_message.set_name('CSI', 'CSI_INVALID_START_DATE');

5223: AND ( (p_end_date IS NOT NULL) AND (p_end_date<>fnd_api.g_miss_date) )
5224: THEN
5225: IF (p_start_date > p_end_date)
5226: THEN
5227: fnd_message.set_name('CSI', 'CSI_INVALID_START_DATE');
5228: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);
5229: fnd_msg_pub.add;
5230: x_return_status := fnd_api.g_ret_sts_error;
5231: END IF;

Line 5228: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);

5224: THEN
5225: IF (p_start_date > p_end_date)
5226: THEN
5227: fnd_message.set_name('CSI', 'CSI_INVALID_START_DATE');
5228: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);
5229: fnd_msg_pub.add;
5230: x_return_status := fnd_api.g_ret_sts_error;
5231: END IF;
5232: ELSIF ( (p_start_date IS NULL) OR (p_start_date = fnd_api.g_miss_date) )

Line 5235: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');

5231: END IF;
5232: ELSIF ( (p_start_date IS NULL) OR (p_start_date = fnd_api.g_miss_date) )
5233: AND ( (p_end_date IS NOT NULL) AND (p_end_date<>fnd_api.g_miss_date) )
5234: THEN
5235: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');
5236: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5237: fnd_msg_pub.add;
5238: x_return_status := fnd_api.g_ret_sts_error;
5239: END IF;

Line 5236: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

5232: ELSIF ( (p_start_date IS NULL) OR (p_start_date = fnd_api.g_miss_date) )
5233: AND ( (p_end_date IS NOT NULL) AND (p_end_date<>fnd_api.g_miss_date) )
5234: THEN
5235: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');
5236: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5237: fnd_msg_pub.add;
5238: x_return_status := fnd_api.g_ret_sts_error;
5239: END IF;
5240: END IF;

Line 5248: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');

5244: AND ( (p_end_date IS NOT NULL) AND (p_end_date<>fnd_api.g_miss_date) )
5245: THEN
5246: IF (p_start_date > p_end_date)
5247: THEN
5248: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5249: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);
5250: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5251: fnd_msg_pub.add;
5252: x_return_status := fnd_api.g_ret_sts_error;

Line 5249: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);

5245: THEN
5246: IF (p_start_date > p_end_date)
5247: THEN
5248: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5249: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);
5250: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5251: fnd_msg_pub.add;
5252: x_return_status := fnd_api.g_ret_sts_error;
5253: END IF;

Line 5250: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

5246: IF (p_start_date > p_end_date)
5247: THEN
5248: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5249: fnd_message.set_token('START_DATE_ACTIVE',p_start_date);
5250: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5251: fnd_msg_pub.add;
5252: x_return_status := fnd_api.g_ret_sts_error;
5253: END IF;
5254: ELSIF ( (p_start_date IS NULL) OR (p_start_date = fnd_api.g_miss_date) )

Line 5264: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');

5260: FROM csi_systems_b
5261: WHERE system_id = p_system_id;
5262: IF l_start_date_active > p_end_date
5263: THEN
5264: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5265: fnd_message.set_token('START_DATE_ACTIVE',l_start_date_active);
5266: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5267: fnd_msg_pub.add;
5268: x_return_status := fnd_api.g_ret_sts_error;

Line 5265: fnd_message.set_token('START_DATE_ACTIVE',l_start_date_active);

5261: WHERE system_id = p_system_id;
5262: IF l_start_date_active > p_end_date
5263: THEN
5264: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5265: fnd_message.set_token('START_DATE_ACTIVE',l_start_date_active);
5266: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5267: fnd_msg_pub.add;
5268: x_return_status := fnd_api.g_ret_sts_error;
5269: END IF;

Line 5266: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

5262: IF l_start_date_active > p_end_date
5263: THEN
5264: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');
5265: fnd_message.set_token('START_DATE_ACTIVE',l_start_date_active);
5266: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5267: fnd_msg_pub.add;
5268: x_return_status := fnd_api.g_ret_sts_error;
5269: END IF;
5270: EXCEPTION

Line 5272: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');

5268: x_return_status := fnd_api.g_ret_sts_error;
5269: END IF;
5270: EXCEPTION
5271: WHEN NO_DATA_FOUND THEN
5272: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');
5273: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5274: fnd_msg_pub.add;
5275: x_return_status := fnd_api.g_ret_sts_error;
5276: END;

Line 5273: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

5269: END IF;
5270: EXCEPTION
5271: WHEN NO_DATA_FOUND THEN
5272: fnd_message.set_name('CSI', 'CSI_INVALID_END_DATE');
5273: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
5274: fnd_msg_pub.add;
5275: x_return_status := fnd_api.g_ret_sts_error;
5276: END;
5277: END IF;

Line 5318: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');

5314: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')
5315: THEN
5316: NULL;
5317: ELSE
5318: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');
5319: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');
5320: fnd_msg_pub.add;
5321: x_return_status := fnd_api.g_ret_sts_error;
5322: END IF;

Line 5319: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');

5315: THEN
5316: NULL;
5317: ELSE
5318: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');
5319: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');
5320: fnd_msg_pub.add;
5321: x_return_status := fnd_api.g_ret_sts_error;
5322: END IF;
5323: END IF;

Line 5328: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');

5324: END IF;
5325:
5326: IF p_validation_mode='UPDATE' THEN
5327: IF ( (p_name IS NULL) OR (p_name=fnd_api.g_miss_char) ) THEN
5328: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');
5329: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');
5330: fnd_msg_pub.add;
5331: x_return_status := fnd_api.g_ret_sts_error;
5332: END IF;

Line 5329: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');

5325:
5326: IF p_validation_mode='UPDATE' THEN
5327: IF ( (p_name IS NULL) OR (p_name=fnd_api.g_miss_char) ) THEN
5328: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');
5329: fnd_message.set_token('REQUIRED_PARAM','SYSTEM_NAME');
5330: fnd_msg_pub.add;
5331: x_return_status := fnd_api.g_ret_sts_error;
5332: END IF;
5333: END IF;

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

5368:
5369:
5370: IF ( (p_validation_mode = 'UPDATE') OR (p_validation_mode = 'EXPIRE') ) THEN
5371: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
5372: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
5373: fnd_msg_pub.add;
5374: x_return_status := fnd_api.g_ret_sts_error;
5375: END IF;
5376: END IF;

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

5618: AND ((p_system_query_rec.system_type_code IS NULL) OR (p_system_query_rec.system_type_code = fnd_api.g_miss_char))
5619: AND ((p_system_query_rec.system_number IS NULL) OR (p_system_query_rec.system_number = fnd_api.g_miss_char))
5620: )
5621: THEN
5622: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
5623: fnd_msg_pub.add;
5624: x_return_status := fnd_api.g_ret_sts_error;
5625: RAISE fnd_api.g_exc_error;
5626: END IF;

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

5673: IF ( (l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date) )
5674: THEN
5675: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
5676: 'Please provide a valid datetime stamp.');
5677: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
5678: FND_MSG_PUB.ADD;
5679: ELSE
5680: get_history( p_sys_rec => l_sys_rec
5681: ,p_new_rec => l_new_rec