APPS.FUN_RULE_DETAILS_PUB dependencies on FUN_RULE_DETAILS

Line 1: PACKAGE BODY FUN_RULE_DETAILS_PUB AS

1: PACKAGE BODY FUN_RULE_DETAILS_PUB AS
2: /*$Header: FUNXTMRULRDTPUB.pls 120.0 2005/06/20 04:30:02 ammishra noship $ */
3:
4:
5: ------------------------------------

Line 75: FUN_RULE_DETAILS_PKG.Insert_Row (

71: RAISE fnd_api.g_exc_error;
72: END IF;
73:
74:
75: FUN_RULE_DETAILS_PKG.Insert_Row (
76: X_ROWID =>l_rowid,
77: X_RULE_DETAIL_ID =>p_rule_detail_rec.rule_detail_id,
78: X_RULE_OBJECT_ID =>p_rule_detail_rec.rule_object_id,
79: X_RULE_NAME =>p_rule_detail_rec.rule_name,

Line 136: FROM FUN_rule_details

132: SELECT OBJECT_VERSION_NUMBER,
133: ROWID
134: INTO l_object_version_number,
135: l_rowid
136: FROM FUN_rule_details
137: WHERE RULE_DETAIL_ID = p_rule_detail_rec.rule_detail_id
138: AND RULE_OBJECT_ID = p_rule_detail_rec.rule_object_id
139: FOR UPDATE OF RULE_NAME NOWAIT;
140:

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 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 176: FUN_RULE_DETAILS_PKG.Update_Row (

172: END IF;
173:
174: -- call to table-handler.
175:
176: FUN_RULE_DETAILS_PKG.Update_Row (
177: X_RULE_DETAIL_ID =>p_rule_detail_rec.rule_detail_id,
178: X_RULE_OBJECT_ID =>p_rule_detail_rec.rule_object_id,
179: X_RULE_NAME =>p_rule_detail_rec.rule_name,
180: X_SEQ =>p_rule_detail_rec.seq,

Line 394: IF( INSTR(SQLERRM, 'FUN_RULE_DETAILS_U2') > 0 ) THEN

390: WHEN OTHERS THEN
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);

Line 416: * FUN_rule_details_PKG.Select_Row

412: * DESCRIPTION
413: * Gets user defined Rules record.
414: *
415: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
416: * FUN_rule_details_PKG.Select_Row
417: *
418: * ARGUMENTS
419: * IN:
420: * p_init_msg_list Initialize message stack if it is set to

Line 477: FUN_RULE_DETAILS_PKG.Select_Row (

473:
474: x_rule_detail_rec.rule_detail_id := p_rule_detail_id;
475: x_rule_detail_rec.rule_object_id := p_rule_object_id;
476:
477: FUN_RULE_DETAILS_PKG.Select_Row (
478: X_RULE_NAME =>x_rule_detail_rec.rule_name,
479: X_RULE_DETAIL_ID =>x_rule_detail_rec.rule_detail_id,
480: X_RULE_OBJECT_ID =>x_rule_detail_rec.rule_object_id,
481: X_SEQ =>x_rule_detail_rec.seq,

Line 584: FROM fun_rule_details

580: -- initialize API return status to success.
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: SELECT rule_detail_id INTO l_rule_detail_id
584: FROM fun_rule_details
585: WHERE rule_object_id = p_rule_object_id
586: AND rule_name = p_rule_name;
587:
588: -- call to table-handler.

Line 589: FUN_RULE_DETAILS_PKG.Delete_Row (

585: WHERE rule_object_id = p_rule_object_id
586: AND rule_name = p_rule_name;
587:
588: -- call to table-handler.
589: FUN_RULE_DETAILS_PKG.Delete_Row (
590: X_RULE_DETAIL_ID => l_rule_detail_id
591: );
592:
593:

Line 630: END FUN_RULE_DETAILS_PUB;

626: p_count => x_msg_count,
627: p_data => x_msg_data);
628: END delete_rule_detail;
629:
630: END FUN_RULE_DETAILS_PUB;