APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALIDATION_EVENTS

Line 827: l_event_code fnd_flex_validation_events.event_code%TYPE;

823: l_old_vset_rec vset_rec_type;
824: l_new_vset_rec vset_rec_type;
825: l_long VARCHAR2(32000);
826: l_count NUMBER;
827: l_event_code fnd_flex_validation_events.event_code%TYPE;
828: l_error VARCHAR2(2000);
829: BEGIN
830: internal_init;
831: debug('Starting to clone...');

Line 1155: -- Clone the rows in FND_FLEX_VALIDATION_EVENTS table.

1151:
1152:
1153: ELSIF (l_new_vset_rec.validation_type IN ('U','P')) THEN
1154: --
1155: -- Clone the rows in FND_FLEX_VALIDATION_EVENTS table.
1156: --
1157: BEGIN
1158: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
1159: COUNT(*)

Line 1161: FROM fnd_flex_validation_events

1157: BEGIN
1158: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
1159: COUNT(*)
1160: INTO l_count
1161: FROM fnd_flex_validation_events
1162: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: report_error(l_func_name,

Line 1166: 'SELECT COUNT fnd_flex_validation_events failed.',

1162: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: report_error(l_func_name,
1166: 'SELECT COUNT fnd_flex_validation_events failed.',
1167: Sqlerrm);
1168: l_ret_code := g_ret_critical_error;
1169: GOTO lbl_return;
1170: END;

Line 1178: FROM fnd_flex_validation_events told

1174: BEGIN
1175: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
1176: user_exit, event_code
1177: INTO l_long, l_event_code
1178: FROM fnd_flex_validation_events told
1179: WHERE told.flex_value_set_id = l_old_vset_rec.flex_value_set_id
1180: AND ROWNUM = 1
1181: AND NOT exists
1182: (SELECT NULL

Line 1183: FROM fnd_flex_validation_events tnew

1179: WHERE told.flex_value_set_id = l_old_vset_rec.flex_value_set_id
1180: AND ROWNUM = 1
1181: AND NOT exists
1182: (SELECT NULL
1183: FROM fnd_flex_validation_events tnew
1184: WHERE tnew.flex_value_set_id = l_new_vset_rec.flex_value_set_id
1185: AND tnew.event_code = told.event_code);
1186: EXCEPTION
1187: WHEN OTHERS THEN

Line 1189: 'SELECT FROM fnd_flex_validation_events ' ||

1185: AND tnew.event_code = told.event_code);
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: report_error(l_func_name,
1189: 'SELECT FROM fnd_flex_validation_events ' ||
1190: 'failed.', Sqlerrm);
1191: l_ret_code := g_ret_critical_error;
1192: GOTO lbl_return;
1193: END;

Line 1195: INSERT INTO fnd_flex_validation_events

1191: l_ret_code := g_ret_critical_error;
1192: GOTO lbl_return;
1193: END;
1194: BEGIN
1195: INSERT INTO fnd_flex_validation_events
1196: (flex_value_set_id,
1197: event_code,
1198: user_exit,
1199: last_update_login,

Line 1213: debug('FND_FLEX_VALIDATION_EVENTS is succesfully cloned.');

1209: l_who_rec.last_updated_by,
1210: l_who_rec.creation_date,
1211: l_who_rec.created_by);
1212: IF (SQL%rowcount = 1) THEN
1213: debug('FND_FLEX_VALIDATION_EVENTS is succesfully cloned.');
1214: debug('event code : ' || l_event_code);
1215: ELSE
1216: report_error(l_func_name,
1217: 'SQL%ROWCOUNT : ' || SQL%rowcount,NULL);

Line 1224: 'INSERT INTO fnd_flex_validation_events failed.',

1220: END IF;
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: report_error(l_func_name,
1224: 'INSERT INTO fnd_flex_validation_events failed.',
1225: Sqlerrm);
1226: l_ret_code := g_ret_critical_error;
1227: GOTO lbl_return;
1228: END;