APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALIDATION_EVENTS

Line 829: l_event_code fnd_flex_validation_events.event_code%TYPE;

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

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

1153:
1154:
1155: ELSIF (l_new_vset_rec.validation_type IN ('U','P')) THEN
1156: --
1157: -- Clone the rows in FND_FLEX_VALIDATION_EVENTS table.
1158: --
1159: BEGIN
1160: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
1161: COUNT(*)

Line 1163: FROM fnd_flex_validation_events

1159: BEGIN
1160: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
1161: COUNT(*)
1162: INTO l_count
1163: FROM fnd_flex_validation_events
1164: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: report_error(l_func_name,

Line 1168: 'SELECT COUNT fnd_flex_validation_events failed.',

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

Line 1180: FROM fnd_flex_validation_events told

1176: BEGIN
1177: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
1178: user_exit, event_code
1179: INTO l_long, l_event_code
1180: FROM fnd_flex_validation_events told
1181: WHERE told.flex_value_set_id = l_old_vset_rec.flex_value_set_id
1182: AND ROWNUM = 1
1183: AND NOT exists
1184: (SELECT NULL

Line 1185: FROM fnd_flex_validation_events tnew

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

Line 1191: 'SELECT FROM fnd_flex_validation_events ' ||

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

Line 1197: INSERT INTO fnd_flex_validation_events

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

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

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

Line 1226: 'INSERT INTO fnd_flex_validation_events failed.',

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