90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: EXCEPTION
93: WHEN OTHERS THEN
94: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
95: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
96: FND_MSG_PUB.ADD;
97: RAISE FND_API.G_EXC_ERROR;
98:
91:
92: EXCEPTION
93: WHEN OTHERS THEN
94: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
95: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
96: FND_MSG_PUB.ADD;
97: RAISE FND_API.G_EXC_ERROR;
98:
99: END INSERT_ROW;
113: open c;
114: fetch c into recinfo;
115: if (c%notfound) then
116: close c;
117: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
118: app_exception.raise_exception;
119: end if;
120: close c;
121: if (
122: recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
123: ) then
124: null;
125: else
126: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
127: app_exception.raise_exception;
128: end if;
129:
130: return;
231: WHERE CRITERIA_PARAM_ID = X_CRITERIA_PARAM_ID;
232:
233: EXCEPTION
234: WHEN NO_DATA_FOUND THEN
235: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
236: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_crit_params_rec');
237: FND_MESSAGE.SET_TOKEN( 'VALUE', X_PARAM_NAME );
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
232:
233: EXCEPTION
234: WHEN NO_DATA_FOUND THEN
235: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
236: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_crit_params_rec');
237: FND_MESSAGE.SET_TOKEN( 'VALUE', X_PARAM_NAME );
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240:
233: EXCEPTION
234: WHEN NO_DATA_FOUND THEN
235: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
236: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_crit_params_rec');
237: FND_MESSAGE.SET_TOKEN( 'VALUE', X_PARAM_NAME );
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240:
241: END Select_Row;