DBA Data[Home] [Help]

APPS.FUN_RULE_DETAILS_PUB dependencies on FND_MESSAGE

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

141:
142: IF NOT ((p_object_version_number is null and l_object_version_number is null)
143: OR (p_object_version_number = l_object_version_number))
144: THEN
145: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
146: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_DETAILS');
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;

Line 146: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_DETAILS');

142: IF NOT ((p_object_version_number is null and l_object_version_number is null)
143: OR (p_object_version_number = l_object_version_number))
144: THEN
145: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
146: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_DETAILS');
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150:

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

150:
151: p_object_version_number := nvl(l_object_version_number, 1) + 1;
152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN
154: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
155: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_DETAILS');
156: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_name');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;

Line 155: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_DETAILS');

151: p_object_version_number := nvl(l_object_version_number, 1) + 1;
152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN
154: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
155: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_DETAILS');
156: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_name');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159: END;

Line 156: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_name');

152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN
154: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
155: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_DETAILS');
156: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_name');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159: END;
160:

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

274:
275: WHEN OTHERS THEN
276: ROLLBACK TO create_rule_detail;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
279: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
280: FND_MSG_PUB.ADD;
281: FND_MSG_PUB.Count_And_Get(
282: p_encoded => FND_API.G_FALSE,

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

275: WHEN OTHERS THEN
276: ROLLBACK TO create_rule_detail;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
279: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
280: FND_MSG_PUB.ADD;
281: FND_MSG_PUB.Count_And_Get(
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,

Line 395: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_DUPLICATE_RULE_NAME');

391: ROLLBACK TO update_rule_detail;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393:
394: IF( INSTR(SQLERRM, 'FUN_RULE_DETAILS_U2') > 0 ) THEN
395: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_DUPLICATE_RULE_NAME');
396: ELSE
397: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
398: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
399: END IF;

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

393:
394: IF( INSTR(SQLERRM, 'FUN_RULE_DETAILS_U2') > 0 ) THEN
395: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_DUPLICATE_RULE_NAME');
396: ELSE
397: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
398: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
399: END IF;
400:
401: FND_MSG_PUB.ADD;

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

394: IF( INSTR(SQLERRM, 'FUN_RULE_DETAILS_U2') > 0 ) THEN
395: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_DUPLICATE_RULE_NAME');
396: ELSE
397: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
398: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
399: END IF;
400:
401: FND_MSG_PUB.ADD;
402: FND_MSG_PUB.Count_And_Get(

Line 467: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );

463:
464: --Check whether primary key has been passed in.
465: IF p_rule_detail_id IS NULL OR
466: p_rule_detail_id = FND_API.G_MISS_NUM THEN
467: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'rule_name' );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;

Line 468: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'rule_name' );

464: --Check whether primary key has been passed in.
465: IF p_rule_detail_id IS NULL OR
466: p_rule_detail_id = FND_API.G_MISS_NUM THEN
467: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'rule_name' );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472: */

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

511: p_data => x_msg_data );
512:
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
516: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
517: FND_MSG_PUB.ADD;
518:
519: FND_MSG_PUB.Count_And_Get(

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

512:
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
516: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
517: FND_MSG_PUB.ADD;
518:
519: FND_MSG_PUB.Count_And_Get(
520: p_encoded => FND_API.G_FALSE,

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

617:
618: WHEN OTHERS THEN
619: ROLLBACK TO delete_rule_detail;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,

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

618: WHEN OTHERS THEN
619: ROLLBACK TO delete_rule_detail;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,