[Home] [Help]
105:
106: IF (c_rec%NOTFOUND) THEN
107: l_progress := '003';
108: CLOSE c_rec;
109: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
110: app_exception.raise_exception;
111: END IF;
112: CLOSE c_rec;
113:
116: l_progress := '004';
117: IF (l_rec.template_code = p_template_code) THEN
118: NULL;
119: ELSE
120: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
121: app_exception.raise_exception;
122: END IF;
123:
124: l_progress := '005';
127: if(tlinfo.template_name = p_name)
128: then
129: null;
130: else
131: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
132: app_exception.raise_exception;
133: end if;
134: end if;
135: end loop;
351:
352: IF (c_rec%NOTFOUND) THEN
353: l_progress := '003';
354: CLOSE c_rec;
355: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
356: app_exception.raise_exception;
357: END IF;
358: CLOSE c_rec;
359:
362: l_progress := '004';
363: IF (l_rec.template_code = p_template_code) THEN
364: NULL;
365: ELSE
366: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
367: app_exception.raise_exception;
368: END IF;
369: l_progress := '005';
370: IF (l_rec.sequence = p_display_sequence) THEN
369: l_progress := '005';
370: IF (l_rec.sequence = p_display_sequence) THEN
371: NULL;
372: ELSE
373: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
374: app_exception.raise_exception;
375: END IF;
376: l_progress := '006';
377: IF (l_rec.attribute_code = p_attribute_code) THEN
376: l_progress := '006';
377: IF (l_rec.attribute_code = p_attribute_code) THEN
378: NULL;
379: ELSE
380: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
381: app_exception.raise_exception;
382: END IF;
383:
384: l_progress := '007';
385: IF (l_rec.flex_value_set_id = p_flex_value_set_id) OR
386: (l_rec.flex_value_set_id IS NULL AND p_flex_value_set_id IS NULL) THEN
387: NULL;
388: ELSE
389: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED4');
390: app_exception.raise_exception;
391: END IF;
392:
393: l_progress := '011';
394: IF (l_rec.required_flag = p_required_flag) OR
395: (l_rec.required_flag IS NULL AND p_required_flag IS NULL) THEN
396: NULL;
397: ELSE
398: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED8');
399: app_exception.raise_exception;
400: END IF;
401:
402: l_progress := '012';
403: IF (l_rec.node_display_flag = p_node_display_flag) OR
404: (l_rec.node_display_flag IS NULL AND p_node_display_flag IS NULL) THEN
405: NULL;
406: ELSE
407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED9');
408: app_exception.raise_exception;
409: END IF;
410:
411: for tlinfo in c_tl_rec(p_attribute_code) loop
417: OR ((tlinfo.default_value is null) AND (p_default_value is null)))
418: ) then
419: null;
420: else
421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422: app_exception.raise_exception;
423: end if;
424: end if;
425: end loop;
582:
583: IF (c_rec%NOTFOUND) THEN
584: l_progress := '003';
585: CLOSE c_rec;
586: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
587: app_exception.raise_exception;
588: END IF;
589: CLOSE c_rec;
590:
593: l_progress := '004';
594: IF (l_rec.region_code = p_region_code) THEN
595: NULL;
596: ELSE
597: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
598: app_exception.raise_exception;
599: END IF;
600: l_progress := '005';
601: IF (l_rec.item_or_category_flag = p_item_or_category_flag) THEN
600: l_progress := '005';
601: IF (l_rec.item_or_category_flag = p_item_or_category_flag) THEN
602: NULL;
603: ELSE
604: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
605: app_exception.raise_exception;
606: END IF;
607: l_progress := '006';
608: IF (l_rec.item_or_category_id = p_item_or_category_id) THEN
607: l_progress := '006';
608: IF (l_rec.item_or_category_id = p_item_or_category_id) THEN
609: NULL;
610: ELSE
611: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
612: app_exception.raise_exception;
613: END IF;
614:
615: EXCEPTION