DBA Data[Home] [Help]

APPS.FUN_RULE_CRIT_PARAMS_PUB dependencies on FND_MESSAGE

Line 163: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');

159: SELECT RULE_OBJECT_ID INTO l_rule_object_id
160: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_to_rule_object_id;
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');
164: fnd_msg_pub.add;
165: x_return_status := fnd_api.g_ret_sts_error;
166: END;
167:

Line 218: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_INVALID_ROB');

214: EXCEPTION
215: WHEN NO_DATA_FOUND THEN
216:
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_INVALID_ROB');
219: FND_MSG_PUB.ADD;
220: FND_MSG_PUB.Count_And_Get(
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,

Line 280: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');

276:
277: IF NOT ((p_object_version_number is null and l_object_version_number is null)
278: OR (p_object_version_number = l_object_version_number))
279: THEN
280: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
281: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_CRIT_PARAMS');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 281: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_CRIT_PARAMS');

277: IF NOT ((p_object_version_number is null and l_object_version_number is null)
278: OR (p_object_version_number = l_object_version_number))
279: THEN
280: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
281: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_CRIT_PARAMS');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:

Line 289: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');

285:
286: p_object_version_number := nvl(l_object_version_number, 1) + 1;
287:
288: EXCEPTION WHEN NO_DATA_FOUND THEN
289: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
290: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_CRIT_PARAMS');
291: FND_MESSAGE.SET_TOKEN('VALUE', 'param_name');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;

Line 290: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_CRIT_PARAMS');

286: p_object_version_number := nvl(l_object_version_number, 1) + 1;
287:
288: EXCEPTION WHEN NO_DATA_FOUND THEN
289: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
290: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_CRIT_PARAMS');
291: FND_MESSAGE.SET_TOKEN('VALUE', 'param_name');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END;

Line 291: FND_MESSAGE.SET_TOKEN('VALUE', 'param_name');

287:
288: EXCEPTION WHEN NO_DATA_FOUND THEN
289: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
290: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_CRIT_PARAMS');
291: FND_MESSAGE.SET_TOKEN('VALUE', 'param_name');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END;
295:

Line 310: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_NO_UPDATE_PARAM');

306: l_dummy := 'N';
307: END;
308:
309: IF(l_dummy = 'N') THEN
310: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_NO_UPDATE_PARAM');
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:

Line 403: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_VALUESET');

399: --Derive the Datatype for ValuSet Based Criteria Param and internally overwrite the same.
400: IF(l_rule_crit_param_rec.flex_value_set_id IS NOT NULL) THEN
401: --Validate if the flex_calue_set_id is Valid or not.
402: IF (NOT FUN_RULE_VALIDATE_PKG.validate_flex_value_set_id (l_rule_crit_param_rec.flex_value_set_id)) THEN
403: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_VALUESET');
404: fnd_msg_pub.add;
405: x_return_status := fnd_api.g_ret_sts_error;
406: ELSE
407: l_rule_crit_param_rec.data_type := FUN_RULE_UTILITY_PKG.getValueSetDataType(l_rule_crit_param_rec.flex_value_set_id);

Line 450: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

446:
447: WHEN OTHERS THEN
448: ROLLBACK TO create_rule_crit_param;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,

Line 451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

447: WHEN OTHERS THEN
448: ROLLBACK TO create_rule_crit_param;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,

Line 529: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

525:
526: WHEN OTHERS THEN
527: ROLLBACK TO create_rule_dup_crit_param;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,

Line 530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

526: WHEN OTHERS THEN
527: ROLLBACK TO create_rule_dup_crit_param;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,

Line 657: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

653:
654: WHEN OTHERS THEN
655: ROLLBACK TO update_rule_crit_param;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
659: FND_MSG_PUB.ADD;
660: FND_MSG_PUB.Count_And_Get(
661: p_encoded => FND_API.G_FALSE,

Line 658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

654: WHEN OTHERS THEN
655: ROLLBACK TO update_rule_crit_param;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
659: FND_MSG_PUB.ADD;
660: FND_MSG_PUB.Count_And_Get(
661: p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,

Line 766: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );

762:
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765:
766: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
767: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
768: FND_MSG_PUB.ADD;
769:
770: FND_MSG_PUB.Count_And_Get(

Line 767: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765:
766: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
767: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
768: FND_MSG_PUB.ADD;
769:
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,

Line 865: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

861:
862: WHEN OTHERS THEN
863: ROLLBACK TO delete_rule_crit_param;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
867: FND_MSG_PUB.ADD;
868: FND_MSG_PUB.Count_And_Get(
869: p_encoded => FND_API.G_FALSE,

Line 866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

862: WHEN OTHERS THEN
863: ROLLBACK TO delete_rule_crit_param;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
867: FND_MSG_PUB.ADD;
868: FND_MSG_PUB.Count_And_Get(
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,