[Home] [Help]
46: n NUMBER := 0;
47: l_batch_header_row gme_batch_header%ROWTYPE;
48: BEGIN
49: /* Set return status to success initially */
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
53: gme_debug.put_line ( 'Check if flexfield is enabled : '
54: || desc_flex_name);
98:
99: IF p_batch_header.attribute_category IS NULL THEN
100: l_attribute_category :=
101: NVL (l_batch_header_row.attribute_category, '');
102: ELSIF p_batch_header.attribute_category = fnd_api.g_miss_char THEN
103: l_attribute_category := '';
104: END IF;
105:
106: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
114: fnd_flex_descval.set_column_value
115: ('ATTRIBUTE1'
116: ,NVL (l_batch_header_row.attribute1
117: ,'') );
118: ELSIF p_batch_header.attribute1 = fnd_api.g_miss_char THEN
119: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
120: ELSE
121: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
122: ,p_batch_header.attribute1);
126: fnd_flex_descval.set_column_value
127: ('ATTRIBUTE2'
128: ,NVL (l_batch_header_row.attribute2
129: ,'') );
130: ELSIF p_batch_header.attribute2 = fnd_api.g_miss_char THEN
131: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
132: ELSE
133: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
134: ,p_batch_header.attribute2);
138: fnd_flex_descval.set_column_value
139: ('ATTRIBUTE3'
140: ,NVL (l_batch_header_row.attribute3
141: ,'') );
142: ELSIF p_batch_header.attribute3 = fnd_api.g_miss_char THEN
143: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
144: ELSE
145: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
146: ,p_batch_header.attribute3);
150: fnd_flex_descval.set_column_value
151: ('ATTRIBUTE4'
152: ,NVL (l_batch_header_row.attribute4
153: ,'') );
154: ELSIF p_batch_header.attribute4 = fnd_api.g_miss_char THEN
155: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
156: ELSE
157: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
158: ,p_batch_header.attribute4);
162: fnd_flex_descval.set_column_value
163: ('ATTRIBUTE5'
164: ,NVL (l_batch_header_row.attribute5
165: ,'') );
166: ELSIF p_batch_header.attribute5 = fnd_api.g_miss_char THEN
167: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
168: ELSE
169: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
170: ,p_batch_header.attribute5);
174: fnd_flex_descval.set_column_value
175: ('ATTRIBUTE6'
176: ,NVL (l_batch_header_row.attribute6
177: ,'') );
178: ELSIF p_batch_header.attribute6 = fnd_api.g_miss_char THEN
179: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
180: ELSE
181: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
182: ,p_batch_header.attribute6);
186: fnd_flex_descval.set_column_value
187: ('ATTRIBUTE7'
188: ,NVL (l_batch_header_row.attribute7
189: ,'') );
190: ELSIF p_batch_header.attribute7 = fnd_api.g_miss_char THEN
191: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
192: ELSE
193: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
194: ,p_batch_header.attribute7);
198: fnd_flex_descval.set_column_value
199: ('ATTRIBUTE8'
200: ,NVL (l_batch_header_row.attribute8
201: ,'') );
202: ELSIF p_batch_header.attribute8 = fnd_api.g_miss_char THEN
203: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
204: ELSE
205: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
206: ,p_batch_header.attribute8);
210: fnd_flex_descval.set_column_value
211: ('ATTRIBUTE9'
212: ,NVL (l_batch_header_row.attribute9
213: ,'') );
214: ELSIF p_batch_header.attribute9 = fnd_api.g_miss_char THEN
215: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
216: ELSE
217: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
218: ,p_batch_header.attribute9);
222: fnd_flex_descval.set_column_value
223: ('ATTRIBUTE10'
224: ,NVL (l_batch_header_row.attribute10
225: ,'') );
226: ELSIF p_batch_header.attribute10 = fnd_api.g_miss_char THEN
227: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
228: ELSE
229: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
230: ,p_batch_header.attribute10);
234: fnd_flex_descval.set_column_value
235: ('ATTRIBUTE11'
236: ,NVL (l_batch_header_row.attribute11
237: ,'') );
238: ELSIF p_batch_header.attribute1 = fnd_api.g_miss_char THEN
239: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
240: ELSE
241: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
242: ,p_batch_header.attribute11);
246: fnd_flex_descval.set_column_value
247: ('ATTRIBUTE12'
248: ,NVL (l_batch_header_row.attribute12
249: ,'') );
250: ELSIF p_batch_header.attribute12 = fnd_api.g_miss_char THEN
251: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
252: ELSE
253: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
254: ,p_batch_header.attribute12);
258: fnd_flex_descval.set_column_value
259: ('ATTRIBUTE13'
260: ,NVL (l_batch_header_row.attribute13
261: ,'') );
262: ELSIF p_batch_header.attribute13 = fnd_api.g_miss_char THEN
263: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
264: ELSE
265: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
266: ,p_batch_header.attribute13);
270: fnd_flex_descval.set_column_value
271: ('ATTRIBUTE14'
272: ,NVL (l_batch_header_row.attribute14
273: ,'') );
274: ELSIF p_batch_header.attribute14 = fnd_api.g_miss_char THEN
275: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
276: ELSE
277: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
278: ,p_batch_header.attribute14);
282: fnd_flex_descval.set_column_value
283: ('ATTRIBUTE15'
284: ,NVL (l_batch_header_row.attribute15
285: ,'') );
286: ELSIF p_batch_header.attribute15 = fnd_api.g_miss_char THEN
287: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
288: ELSE
289: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
290: ,p_batch_header.attribute15);
294: fnd_flex_descval.set_column_value
295: ('ATTRIBUTE16'
296: ,NVL (l_batch_header_row.attribute16
297: ,'') );
298: ELSIF p_batch_header.attribute16 = fnd_api.g_miss_char THEN
299: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
300: ELSE
301: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
302: ,p_batch_header.attribute16);
306: fnd_flex_descval.set_column_value
307: ('ATTRIBUTE17'
308: ,NVL (l_batch_header_row.attribute17
309: ,'') );
310: ELSIF p_batch_header.attribute17 = fnd_api.g_miss_char THEN
311: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
312: ELSE
313: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
314: ,p_batch_header.attribute17);
318: fnd_flex_descval.set_column_value
319: ('ATTRIBUTE18'
320: ,NVL (l_batch_header_row.attribute18
321: ,'') );
322: ELSIF p_batch_header.attribute18 = fnd_api.g_miss_char THEN
323: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
324: ELSE
325: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
326: ,p_batch_header.attribute18);
330: fnd_flex_descval.set_column_value
331: ('ATTRIBUTE19'
332: ,NVL (l_batch_header_row.attribute19
333: ,'') );
334: ELSIF p_batch_header.attribute19 = fnd_api.g_miss_char THEN
335: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
336: ELSE
337: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
338: ,p_batch_header.attribute19);
342: fnd_flex_descval.set_column_value
343: ('ATTRIBUTE20'
344: ,NVL (l_batch_header_row.attribute20
345: ,'') );
346: ELSIF p_batch_header.attribute20 = fnd_api.g_miss_char THEN
347: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
348: ELSE
349: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
350: ,p_batch_header.attribute20);
354: fnd_flex_descval.set_column_value
355: ('ATTRIBUTE21'
356: ,NVL (l_batch_header_row.attribute21
357: ,'') );
358: ELSIF p_batch_header.attribute21 = fnd_api.g_miss_char THEN
359: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
360: ELSE
361: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
362: ,p_batch_header.attribute21);
366: fnd_flex_descval.set_column_value
367: ('ATTRIBUTE22'
368: ,NVL (l_batch_header_row.attribute22
369: ,'') );
370: ELSIF p_batch_header.attribute22 = fnd_api.g_miss_char THEN
371: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
372: ELSE
373: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
374: ,p_batch_header.attribute22);
378: fnd_flex_descval.set_column_value
379: ('ATTRIBUTE23'
380: ,NVL (l_batch_header_row.attribute23
381: ,'') );
382: ELSIF p_batch_header.attribute23 = fnd_api.g_miss_char THEN
383: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
384: ELSE
385: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
386: ,p_batch_header.attribute23);
390: fnd_flex_descval.set_column_value
391: ('ATTRIBUTE24'
392: ,NVL (l_batch_header_row.attribute24
393: ,'') );
394: ELSIF p_batch_header.attribute24 = fnd_api.g_miss_char THEN
395: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
396: ELSE
397: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
398: ,p_batch_header.attribute24);
402: fnd_flex_descval.set_column_value
403: ('ATTRIBUTE25'
404: ,NVL (l_batch_header_row.attribute25
405: ,'') );
406: ELSIF p_batch_header.attribute25 = fnd_api.g_miss_char THEN
407: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
408: ELSE
409: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
410: ,p_batch_header.attribute25);
414: fnd_flex_descval.set_column_value
415: ('ATTRIBUTE26'
416: ,NVL (l_batch_header_row.attribute26
417: ,'') );
418: ELSIF p_batch_header.attribute26 = fnd_api.g_miss_char THEN
419: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
420: ELSE
421: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
422: ,p_batch_header.attribute26);
426: fnd_flex_descval.set_column_value
427: ('ATTRIBUTE27'
428: ,NVL (l_batch_header_row.attribute27
429: ,'') );
430: ELSIF p_batch_header.attribute27 = fnd_api.g_miss_char THEN
431: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
432: ELSE
433: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
434: ,p_batch_header.attribute27);
438: fnd_flex_descval.set_column_value
439: ('ATTRIBUTE28'
440: ,NVL (l_batch_header_row.attribute28
441: ,'') );
442: ELSIF p_batch_header.attribute28 = fnd_api.g_miss_char THEN
443: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
444: ELSE
445: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
446: ,p_batch_header.attribute28);
450: fnd_flex_descval.set_column_value
451: ('ATTRIBUTE29'
452: ,NVL (l_batch_header_row.attribute29
453: ,'') );
454: ELSIF p_batch_header.attribute29 = fnd_api.g_miss_char THEN
455: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
456: ELSE
457: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
458: ,p_batch_header.attribute29);
462: fnd_flex_descval.set_column_value
463: ('ATTRIBUTE30'
464: ,NVL (l_batch_header_row.attribute30
465: ,'') );
466: ELSIF p_batch_header.attribute30 = fnd_api.g_miss_char THEN
467: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
468: ELSE
469: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
470: ,p_batch_header.attribute30);
474: fnd_flex_descval.set_column_value
475: ('ATTRIBUTE31'
476: ,NVL (l_batch_header_row.attribute31
477: ,'') );
478: ELSIF p_batch_header.attribute31 = fnd_api.g_miss_char THEN
479: fnd_flex_descval.set_column_value ('ATTRIBUTE31', '');
480: ELSE
481: fnd_flex_descval.set_column_value ('ATTRIBUTE31'
482: ,p_batch_header.attribute31);
486: fnd_flex_descval.set_column_value
487: ('ATTRIBUTE32'
488: ,NVL (l_batch_header_row.attribute32
489: ,'') );
490: ELSIF p_batch_header.attribute32 = fnd_api.g_miss_char THEN
491: fnd_flex_descval.set_column_value ('ATTRIBUTE32', '');
492: ELSE
493: fnd_flex_descval.set_column_value ('ATTRIBUTE32'
494: ,p_batch_header.attribute32);
498: fnd_flex_descval.set_column_value
499: ('ATTRIBUTE33'
500: ,NVL (l_batch_header_row.attribute33
501: ,'') );
502: ELSIF p_batch_header.attribute33 = fnd_api.g_miss_char THEN
503: fnd_flex_descval.set_column_value ('ATTRIBUTE33', '');
504: ELSE
505: fnd_flex_descval.set_column_value ('ATTRIBUTE33'
506: ,p_batch_header.attribute33);
510: fnd_flex_descval.set_column_value
511: ('ATTRIBUTE34'
512: ,NVL (l_batch_header_row.attribute34
513: ,'') );
514: ELSIF p_batch_header.attribute34 = fnd_api.g_miss_char THEN
515: fnd_flex_descval.set_column_value ('ATTRIBUTE34', '');
516: ELSE
517: fnd_flex_descval.set_column_value ('ATTRIBUTE34'
518: ,p_batch_header.attribute34);
522: fnd_flex_descval.set_column_value
523: ('ATTRIBUTE35'
524: ,NVL (l_batch_header_row.attribute35
525: ,'') );
526: ELSIF p_batch_header.attribute35 = fnd_api.g_miss_char THEN
527: fnd_flex_descval.set_column_value ('ATTRIBUTE35', '');
528: ELSE
529: fnd_flex_descval.set_column_value ('ATTRIBUTE35'
530: ,p_batch_header.attribute35);
534: fnd_flex_descval.set_column_value
535: ('ATTRIBUTE36'
536: ,NVL (l_batch_header_row.attribute36
537: ,'') );
538: ELSIF p_batch_header.attribute36 = fnd_api.g_miss_char THEN
539: fnd_flex_descval.set_column_value ('ATTRIBUTE36', '');
540: ELSE
541: fnd_flex_descval.set_column_value ('ATTRIBUTE36'
542: ,p_batch_header.attribute36);
546: fnd_flex_descval.set_column_value
547: ('ATTRIBUTE37'
548: ,NVL (l_batch_header_row.attribute37
549: ,'') );
550: ELSIF p_batch_header.attribute37 = fnd_api.g_miss_char THEN
551: fnd_flex_descval.set_column_value ('ATTRIBUTE37', '');
552: ELSE
553: fnd_flex_descval.set_column_value ('ATTRIBUTE37'
554: ,p_batch_header.attribute37);
558: fnd_flex_descval.set_column_value
559: ('ATTRIBUTE38'
560: ,NVL (l_batch_header_row.attribute38
561: ,'') );
562: ELSIF p_batch_header.attribute38 = fnd_api.g_miss_char THEN
563: fnd_flex_descval.set_column_value ('ATTRIBUTE38', '');
564: ELSE
565: fnd_flex_descval.set_column_value ('ATTRIBUTE38'
566: ,p_batch_header.attribute38);
570: fnd_flex_descval.set_column_value
571: ('ATTRIBUTE39'
572: ,NVL (l_batch_header_row.attribute39
573: ,'') );
574: ELSIF p_batch_header.attribute39 = fnd_api.g_miss_char THEN
575: fnd_flex_descval.set_column_value ('ATTRIBUTE39', '');
576: ELSE
577: fnd_flex_descval.set_column_value ('ATTRIBUTE39'
578: ,p_batch_header.attribute39);
582: fnd_flex_descval.set_column_value
583: ('ATTRIBUTE40'
584: ,NVL (l_batch_header_row.attribute40
585: ,'') );
586: ELSIF p_batch_header.attribute40 = fnd_api.g_miss_char THEN
587: fnd_flex_descval.set_column_value ('ATTRIBUTE40', '');
588: ELSE
589: fnd_flex_descval.set_column_value ('ATTRIBUTE40'
590: ,p_batch_header.attribute40);
603: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
604: gme_debug.put_line ('Validation Success. ');
605: END IF;
606:
607: x_return_status := fnd_api.g_ret_sts_success;
608: n := fnd_flex_descval.segment_count;
609:
610: /*Now let us copy back the storage value */
611: FOR i IN 1 .. n LOOP
720: ( 'Validation completed with errors for the Flex field : '
721: || desc_flex_name);
722: END IF;
723:
724: x_return_status := fnd_api.g_ret_sts_error;
725: WHEN header_fetch_error THEN
726: x_return_status := fnd_api.g_ret_sts_error;
727: WHEN OTHERS THEN
728: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
722: END IF;
723:
724: x_return_status := fnd_api.g_ret_sts_error;
725: WHEN header_fetch_error THEN
726: x_return_status := fnd_api.g_ret_sts_error;
727: WHEN OTHERS THEN
728: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
729: gme_debug.put_line ( g_pkg_name
730: || '.'
732: || ': '
733: || 'in unexpected error');
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_unexp_error;
737: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
738: END validate_flex_batch_header;
739:
740: /*======================================================================
795: FROM gme_batch_steps
796: WHERE batchstep_id = v_rec_id;
797: BEGIN
798: /* Set return status to success initially */
799: x_return_status := fnd_api.g_ret_sts_success;
800:
801: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
802: gme_debug.put_line ( 'Check if flexfield is enabled : '
803: || desc_flex_name);
847: /* All the following if statements will now retain that data. */
848: IF p_batch_step.attribute_category IS NULL THEN
849: l_attribute_category :=
850: NVL (l_batch_step_row.attribute_category, '');
851: ELSIF p_batch_step.attribute_category = fnd_api.g_miss_char THEN
852: l_attribute_category := '';
853: ELSE
854: l_attribute_category := p_batch_step.attribute_category;
855: END IF;
866: fnd_flex_descval.set_column_value
867: ('ATTRIBUTE1'
868: ,NVL (l_batch_step_row.attribute1
869: ,'') );
870: ELSIF p_batch_step.attribute1 = fnd_api.g_miss_char THEN
871: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
872: l_batch_step_row.attribute1 := '';
873: ELSE
874: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
880: fnd_flex_descval.set_column_value
881: ('ATTRIBUTE2'
882: ,NVL (l_batch_step_row.attribute2
883: ,'') );
884: ELSIF p_batch_step.attribute2 = fnd_api.g_miss_char THEN
885: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
886: l_batch_step_row.attribute2 := '';
887: ELSE
888: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
894: fnd_flex_descval.set_column_value
895: ('ATTRIBUTE3'
896: ,NVL (l_batch_step_row.attribute3
897: ,'') );
898: ELSIF p_batch_step.attribute3 = fnd_api.g_miss_char THEN
899: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
900: l_batch_step_row.attribute3 := '';
901: ELSE
902: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
908: fnd_flex_descval.set_column_value
909: ('ATTRIBUTE4'
910: ,NVL (l_batch_step_row.attribute4
911: ,'') );
912: ELSIF p_batch_step.attribute4 = fnd_api.g_miss_char THEN
913: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
914: l_batch_step_row.attribute4 := '';
915: ELSE
916: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
922: fnd_flex_descval.set_column_value
923: ('ATTRIBUTE5'
924: ,NVL (l_batch_step_row.attribute5
925: ,'') );
926: ELSIF p_batch_step.attribute5 = fnd_api.g_miss_char THEN
927: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
928: l_batch_step_row.attribute5 := '';
929: ELSE
930: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
936: fnd_flex_descval.set_column_value
937: ('ATTRIBUTE6'
938: ,NVL (l_batch_step_row.attribute6
939: ,'') );
940: ELSIF p_batch_step.attribute6 = fnd_api.g_miss_char THEN
941: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
942: l_batch_step_row.attribute6 := '';
943: ELSE
944: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
950: fnd_flex_descval.set_column_value
951: ('ATTRIBUTE7'
952: ,NVL (l_batch_step_row.attribute7
953: ,'') );
954: ELSIF p_batch_step.attribute7 = fnd_api.g_miss_char THEN
955: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
956: l_batch_step_row.attribute7 := '';
957: ELSE
958: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
964: fnd_flex_descval.set_column_value
965: ('ATTRIBUTE8'
966: ,NVL (l_batch_step_row.attribute8
967: ,'') );
968: ELSIF p_batch_step.attribute8 = fnd_api.g_miss_char THEN
969: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
970: l_batch_step_row.attribute8 := '';
971: ELSE
972: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
978: fnd_flex_descval.set_column_value
979: ('ATTRIBUTE9'
980: ,NVL (l_batch_step_row.attribute9
981: ,'') );
982: ELSIF p_batch_step.attribute9 = fnd_api.g_miss_char THEN
983: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
984: l_batch_step_row.attribute9 := '';
985: ELSE
986: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
992: fnd_flex_descval.set_column_value
993: ('ATTRIBUTE10'
994: ,NVL (l_batch_step_row.attribute10
995: ,'') );
996: ELSIF p_batch_step.attribute10 = fnd_api.g_miss_char THEN
997: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
998: l_batch_step_row.attribute10 := '';
999: ELSE
1000: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
1006: fnd_flex_descval.set_column_value
1007: ('ATTRIBUTE11'
1008: ,NVL (l_batch_step_row.attribute11
1009: ,'') );
1010: ELSIF p_batch_step.attribute11 = fnd_api.g_miss_char THEN
1011: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
1012: l_batch_step_row.attribute11 := '';
1013: ELSE
1014: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
1020: fnd_flex_descval.set_column_value
1021: ('ATTRIBUTE12'
1022: ,NVL (l_batch_step_row.attribute12
1023: ,'') );
1024: ELSIF p_batch_step.attribute12 = fnd_api.g_miss_char THEN
1025: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
1026: l_batch_step_row.attribute12 := '';
1027: ELSE
1028: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
1034: fnd_flex_descval.set_column_value
1035: ('ATTRIBUTE13'
1036: ,NVL (l_batch_step_row.attribute13
1037: ,'') );
1038: ELSIF p_batch_step.attribute13 = fnd_api.g_miss_char THEN
1039: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
1040: l_batch_step_row.attribute13 := '';
1041: ELSE
1042: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
1048: fnd_flex_descval.set_column_value
1049: ('ATTRIBUTE14'
1050: ,NVL (l_batch_step_row.attribute14
1051: ,'') );
1052: ELSIF p_batch_step.attribute14 = fnd_api.g_miss_char THEN
1053: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
1054: l_batch_step_row.attribute14 := '';
1055: ELSE
1056: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
1062: fnd_flex_descval.set_column_value
1063: ('ATTRIBUTE15'
1064: ,NVL (l_batch_step_row.attribute15
1065: ,'') );
1066: ELSIF p_batch_step.attribute15 = fnd_api.g_miss_char THEN
1067: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
1068: l_batch_step_row.attribute15 := '';
1069: ELSE
1070: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
1076: fnd_flex_descval.set_column_value
1077: ('ATTRIBUTE16'
1078: ,NVL (l_batch_step_row.attribute16
1079: ,'') );
1080: ELSIF p_batch_step.attribute16 = fnd_api.g_miss_char THEN
1081: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
1082: l_batch_step_row.attribute16 := '';
1083: ELSE
1084: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
1090: fnd_flex_descval.set_column_value
1091: ('ATTRIBUTE17'
1092: ,NVL (l_batch_step_row.attribute17
1093: ,'') );
1094: ELSIF p_batch_step.attribute17 = fnd_api.g_miss_char THEN
1095: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
1096: l_batch_step_row.attribute17 := '';
1097: ELSE
1098: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
1104: fnd_flex_descval.set_column_value
1105: ('ATTRIBUTE18'
1106: ,NVL (l_batch_step_row.attribute18
1107: ,'') );
1108: ELSIF p_batch_step.attribute18 = fnd_api.g_miss_char THEN
1109: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
1110: l_batch_step_row.attribute18 := '';
1111: ELSE
1112: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
1118: fnd_flex_descval.set_column_value
1119: ('ATTRIBUTE19'
1120: ,NVL (l_batch_step_row.attribute19
1121: ,'') );
1122: ELSIF p_batch_step.attribute19 = fnd_api.g_miss_char THEN
1123: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
1124: l_batch_step_row.attribute19 := '';
1125: ELSE
1126: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
1132: fnd_flex_descval.set_column_value
1133: ('ATTRIBUTE20'
1134: ,NVL (l_batch_step_row.attribute20
1135: ,'') );
1136: ELSIF p_batch_step.attribute20 = fnd_api.g_miss_char THEN
1137: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
1138: l_batch_step_row.attribute20 := '';
1139: ELSE
1140: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
1146: fnd_flex_descval.set_column_value
1147: ('ATTRIBUTE21'
1148: ,NVL (l_batch_step_row.attribute21
1149: ,'') );
1150: ELSIF p_batch_step.attribute21 = fnd_api.g_miss_char THEN
1151: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
1152: l_batch_step_row.attribute21 := '';
1153: ELSE
1154: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
1160: fnd_flex_descval.set_column_value
1161: ('ATTRIBUTE22'
1162: ,NVL (l_batch_step_row.attribute22
1163: ,'') );
1164: ELSIF p_batch_step.attribute22 = fnd_api.g_miss_char THEN
1165: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
1166: l_batch_step_row.attribute22 := '';
1167: ELSE
1168: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
1174: fnd_flex_descval.set_column_value
1175: ('ATTRIBUTE23'
1176: ,NVL (l_batch_step_row.attribute23
1177: ,'') );
1178: ELSIF p_batch_step.attribute23 = fnd_api.g_miss_char THEN
1179: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
1180: l_batch_step_row.attribute23 := '';
1181: ELSE
1182: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
1188: fnd_flex_descval.set_column_value
1189: ('ATTRIBUTE24'
1190: ,NVL (l_batch_step_row.attribute24
1191: ,'') );
1192: ELSIF p_batch_step.attribute24 = fnd_api.g_miss_char THEN
1193: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
1194: l_batch_step_row.attribute24 := '';
1195: ELSE
1196: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
1202: fnd_flex_descval.set_column_value
1203: ('ATTRIBUTE25'
1204: ,NVL (l_batch_step_row.attribute25
1205: ,'') );
1206: ELSIF p_batch_step.attribute25 = fnd_api.g_miss_char THEN
1207: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
1208: l_batch_step_row.attribute25 := '';
1209: ELSE
1210: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
1216: fnd_flex_descval.set_column_value
1217: ('ATTRIBUTE26'
1218: ,NVL (l_batch_step_row.attribute26
1219: ,'') );
1220: ELSIF p_batch_step.attribute26 = fnd_api.g_miss_char THEN
1221: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
1222: l_batch_step_row.attribute26 := '';
1223: ELSE
1224: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
1230: fnd_flex_descval.set_column_value
1231: ('ATTRIBUTE27'
1232: ,NVL (l_batch_step_row.attribute27
1233: ,'') );
1234: ELSIF p_batch_step.attribute27 = fnd_api.g_miss_char THEN
1235: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
1236: l_batch_step_row.attribute27 := '';
1237: ELSE
1238: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
1244: fnd_flex_descval.set_column_value
1245: ('ATTRIBUTE28'
1246: ,NVL (l_batch_step_row.attribute28
1247: ,'') );
1248: ELSIF p_batch_step.attribute28 = fnd_api.g_miss_char THEN
1249: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
1250: l_batch_step_row.attribute28 := '';
1251: ELSE
1252: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
1258: fnd_flex_descval.set_column_value
1259: ('ATTRIBUTE29'
1260: ,NVL (l_batch_step_row.attribute29
1261: ,'') );
1262: ELSIF p_batch_step.attribute29 = fnd_api.g_miss_char THEN
1263: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
1264: l_batch_step_row.attribute29 := '';
1265: ELSE
1266: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
1272: fnd_flex_descval.set_column_value
1273: ('ATTRIBUTE30'
1274: ,NVL (l_batch_step_row.attribute30
1275: ,'') );
1276: ELSIF p_batch_step.attribute30 = fnd_api.g_miss_char THEN
1277: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
1278: l_batch_step_row.attribute30 := '';
1279: ELSE
1280: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
1341: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1342: gme_debug.put_line ('Validation Success ');
1343: END IF;
1344:
1345: x_return_status := fnd_api.g_ret_sts_success;
1346: n := fnd_flex_descval.segment_count;
1347:
1348: /*Now let us copy back the storage value */
1349: FOR i IN 1 .. n LOOP
1438: ( 'Validation completed with errors for the Flex field : '
1439: || desc_flex_name);
1440: END IF;
1441:
1442: x_return_status := fnd_api.g_ret_sts_error;
1443: WHEN step_fetch_error THEN
1444: x_return_status := fnd_api.g_ret_sts_error;
1445: WHEN OTHERS THEN
1446: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1440: END IF;
1441:
1442: x_return_status := fnd_api.g_ret_sts_error;
1443: WHEN step_fetch_error THEN
1444: x_return_status := fnd_api.g_ret_sts_error;
1445: WHEN OTHERS THEN
1446: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1447: gme_debug.put_line ( g_pkg_name
1448: || '.'
1450: || ': '
1451: || 'in unexpected error');
1452: END IF;
1453:
1454: x_return_status := fnd_api.g_ret_sts_unexp_error;
1455: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
1456: END validate_flex_batch_step;
1457:
1458: /*======================================================================
1514: FROM gme_batch_step_activities
1515: WHERE batchstep_activity_id = v_rec_id;
1516: BEGIN
1517: /* Set return status to success initially */
1518: x_return_status := fnd_api.g_ret_sts_success;
1519:
1520: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1521: gme_debug.put_line ( 'Check if flexfield is enabled : '
1522: || desc_flex_name);
1567: /* All the following if statements will now retain that data. */
1568: IF p_step_activities.attribute_category IS NULL THEN
1569: l_attribute_category :=
1570: NVL (l_step_activities_row.attribute_category, '');
1571: ELSIF p_step_activities.attribute_category = fnd_api.g_miss_char THEN
1572: l_attribute_category := '';
1573: ELSE
1574: l_attribute_category := p_step_activities.attribute_category;
1575: END IF;
1586: fnd_flex_descval.set_column_value
1587: ('ATTRIBUTE1'
1588: ,NVL (l_step_activities_row.attribute1
1589: ,'') );
1590: ELSIF p_step_activities.attribute1 = fnd_api.g_miss_char THEN
1591: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
1592: l_step_activities_row.attribute1 := '';
1593: ELSE
1594: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
1600: fnd_flex_descval.set_column_value
1601: ('ATTRIBUTE2'
1602: ,NVL (l_step_activities_row.attribute2
1603: ,'') );
1604: ELSIF p_step_activities.attribute2 = fnd_api.g_miss_char THEN
1605: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
1606: l_step_activities_row.attribute2 := '';
1607: ELSE
1608: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
1614: fnd_flex_descval.set_column_value
1615: ('ATTRIBUTE3'
1616: ,NVL (l_step_activities_row.attribute3
1617: ,'') );
1618: ELSIF p_step_activities.attribute3 = fnd_api.g_miss_char THEN
1619: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
1620: l_step_activities_row.attribute3 := '';
1621: ELSE
1622: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
1628: fnd_flex_descval.set_column_value
1629: ('ATTRIBUTE4'
1630: ,NVL (l_step_activities_row.attribute4
1631: ,'') );
1632: ELSIF p_step_activities.attribute4 = fnd_api.g_miss_char THEN
1633: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
1634: l_step_activities_row.attribute4 := '';
1635: ELSE
1636: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
1642: fnd_flex_descval.set_column_value
1643: ('ATTRIBUTE5'
1644: ,NVL (l_step_activities_row.attribute5
1645: ,'') );
1646: ELSIF p_step_activities.attribute5 = fnd_api.g_miss_char THEN
1647: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
1648: l_step_activities_row.attribute5 := '';
1649: ELSE
1650: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
1656: fnd_flex_descval.set_column_value
1657: ('ATTRIBUTE6'
1658: ,NVL (l_step_activities_row.attribute6
1659: ,'') );
1660: ELSIF p_step_activities.attribute6 = fnd_api.g_miss_char THEN
1661: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
1662: l_step_activities_row.attribute6 := '';
1663: ELSE
1664: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
1670: fnd_flex_descval.set_column_value
1671: ('ATTRIBUTE7'
1672: ,NVL (l_step_activities_row.attribute7
1673: ,'') );
1674: ELSIF p_step_activities.attribute7 = fnd_api.g_miss_char THEN
1675: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
1676: l_step_activities_row.attribute7 := '';
1677: ELSE
1678: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
1684: fnd_flex_descval.set_column_value
1685: ('ATTRIBUTE8'
1686: ,NVL (l_step_activities_row.attribute8
1687: ,'') );
1688: ELSIF p_step_activities.attribute8 = fnd_api.g_miss_char THEN
1689: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
1690: l_step_activities_row.attribute8 := '';
1691: ELSE
1692: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
1698: fnd_flex_descval.set_column_value
1699: ('ATTRIBUTE9'
1700: ,NVL (l_step_activities_row.attribute9
1701: ,'') );
1702: ELSIF p_step_activities.attribute9 = fnd_api.g_miss_char THEN
1703: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
1704: l_step_activities_row.attribute9 := '';
1705: ELSE
1706: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
1712: fnd_flex_descval.set_column_value
1713: ('ATTRIBUTE10'
1714: ,NVL (l_step_activities_row.attribute10
1715: ,'') );
1716: ELSIF p_step_activities.attribute10 = fnd_api.g_miss_char THEN
1717: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
1718: l_step_activities_row.attribute10 := '';
1719: ELSE
1720: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
1726: fnd_flex_descval.set_column_value
1727: ('ATTRIBUTE11'
1728: ,NVL (l_step_activities_row.attribute11
1729: ,'') );
1730: ELSIF p_step_activities.attribute11 = fnd_api.g_miss_char THEN
1731: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
1732: l_step_activities_row.attribute11 := '';
1733: ELSE
1734: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
1740: fnd_flex_descval.set_column_value
1741: ('ATTRIBUTE12'
1742: ,NVL (l_step_activities_row.attribute12
1743: ,'') );
1744: ELSIF p_step_activities.attribute12 = fnd_api.g_miss_char THEN
1745: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
1746: l_step_activities_row.attribute12 := '';
1747: ELSE
1748: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
1754: fnd_flex_descval.set_column_value
1755: ('ATTRIBUTE13'
1756: ,NVL (l_step_activities_row.attribute13
1757: ,'') );
1758: ELSIF p_step_activities.attribute13 = fnd_api.g_miss_char THEN
1759: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
1760: l_step_activities_row.attribute13 := '';
1761: ELSE
1762: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
1768: fnd_flex_descval.set_column_value
1769: ('ATTRIBUTE14'
1770: ,NVL (l_step_activities_row.attribute14
1771: ,'') );
1772: ELSIF p_step_activities.attribute14 = fnd_api.g_miss_char THEN
1773: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
1774: l_step_activities_row.attribute14 := '';
1775: ELSE
1776: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
1782: fnd_flex_descval.set_column_value
1783: ('ATTRIBUTE15'
1784: ,NVL (l_step_activities_row.attribute15
1785: ,'') );
1786: ELSIF p_step_activities.attribute15 = fnd_api.g_miss_char THEN
1787: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
1788: l_step_activities_row.attribute15 := '';
1789: ELSE
1790: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
1796: fnd_flex_descval.set_column_value
1797: ('ATTRIBUTE16'
1798: ,NVL (l_step_activities_row.attribute16
1799: ,'') );
1800: ELSIF p_step_activities.attribute16 = fnd_api.g_miss_char THEN
1801: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
1802: l_step_activities_row.attribute16 := '';
1803: ELSE
1804: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
1810: fnd_flex_descval.set_column_value
1811: ('ATTRIBUTE17'
1812: ,NVL (l_step_activities_row.attribute17
1813: ,'') );
1814: ELSIF p_step_activities.attribute17 = fnd_api.g_miss_char THEN
1815: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
1816: l_step_activities_row.attribute17 := '';
1817: ELSE
1818: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
1824: fnd_flex_descval.set_column_value
1825: ('ATTRIBUTE18'
1826: ,NVL (l_step_activities_row.attribute18
1827: ,'') );
1828: ELSIF p_step_activities.attribute18 = fnd_api.g_miss_char THEN
1829: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
1830: l_step_activities_row.attribute18 := '';
1831: ELSE
1832: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
1838: fnd_flex_descval.set_column_value
1839: ('ATTRIBUTE19'
1840: ,NVL (l_step_activities_row.attribute19
1841: ,'') );
1842: ELSIF p_step_activities.attribute19 = fnd_api.g_miss_char THEN
1843: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
1844: l_step_activities_row.attribute19 := '';
1845: ELSE
1846: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
1852: fnd_flex_descval.set_column_value
1853: ('ATTRIBUTE20'
1854: ,NVL (l_step_activities_row.attribute20
1855: ,'') );
1856: ELSIF p_step_activities.attribute20 = fnd_api.g_miss_char THEN
1857: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
1858: l_step_activities_row.attribute20 := '';
1859: ELSE
1860: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
1866: fnd_flex_descval.set_column_value
1867: ('ATTRIBUTE21'
1868: ,NVL (l_step_activities_row.attribute21
1869: ,'') );
1870: ELSIF p_step_activities.attribute21 = fnd_api.g_miss_char THEN
1871: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
1872: l_step_activities_row.attribute21 := '';
1873: ELSE
1874: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
1880: fnd_flex_descval.set_column_value
1881: ('ATTRIBUTE22'
1882: ,NVL (l_step_activities_row.attribute22
1883: ,'') );
1884: ELSIF p_step_activities.attribute22 = fnd_api.g_miss_char THEN
1885: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
1886: l_step_activities_row.attribute22 := '';
1887: ELSE
1888: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
1894: fnd_flex_descval.set_column_value
1895: ('ATTRIBUTE23'
1896: ,NVL (l_step_activities_row.attribute23
1897: ,'') );
1898: ELSIF p_step_activities.attribute23 = fnd_api.g_miss_char THEN
1899: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
1900: l_step_activities_row.attribute23 := '';
1901: ELSE
1902: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
1908: fnd_flex_descval.set_column_value
1909: ('ATTRIBUTE24'
1910: ,NVL (l_step_activities_row.attribute24
1911: ,'') );
1912: ELSIF p_step_activities.attribute24 = fnd_api.g_miss_char THEN
1913: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
1914: l_step_activities_row.attribute24 := '';
1915: ELSE
1916: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
1922: fnd_flex_descval.set_column_value
1923: ('ATTRIBUTE25'
1924: ,NVL (l_step_activities_row.attribute25
1925: ,'') );
1926: ELSIF p_step_activities.attribute25 = fnd_api.g_miss_char THEN
1927: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
1928: l_step_activities_row.attribute25 := '';
1929: ELSE
1930: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
1936: fnd_flex_descval.set_column_value
1937: ('ATTRIBUTE26'
1938: ,NVL (l_step_activities_row.attribute26
1939: ,'') );
1940: ELSIF p_step_activities.attribute26 = fnd_api.g_miss_char THEN
1941: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
1942: l_step_activities_row.attribute26 := '';
1943: ELSE
1944: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
1950: fnd_flex_descval.set_column_value
1951: ('ATTRIBUTE27'
1952: ,NVL (l_step_activities_row.attribute27
1953: ,'') );
1954: ELSIF p_step_activities.attribute27 = fnd_api.g_miss_char THEN
1955: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
1956: l_step_activities_row.attribute27 := '';
1957: ELSE
1958: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
1964: fnd_flex_descval.set_column_value
1965: ('ATTRIBUTE28'
1966: ,NVL (l_step_activities_row.attribute28
1967: ,'') );
1968: ELSIF p_step_activities.attribute28 = fnd_api.g_miss_char THEN
1969: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
1970: l_step_activities_row.attribute28 := '';
1971: ELSE
1972: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
1978: fnd_flex_descval.set_column_value
1979: ('ATTRIBUTE29'
1980: ,NVL (l_step_activities_row.attribute29
1981: ,'') );
1982: ELSIF p_step_activities.attribute29 = fnd_api.g_miss_char THEN
1983: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
1984: l_step_activities_row.attribute29 := '';
1985: ELSE
1986: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
1992: fnd_flex_descval.set_column_value
1993: ('ATTRIBUTE30'
1994: ,NVL (l_step_activities_row.attribute30
1995: ,'') );
1996: ELSIF p_step_activities.attribute30 = fnd_api.g_miss_char THEN
1997: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
1998: l_step_activities_row.attribute30 := '';
1999: ELSE
2000: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
2061: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2062: gme_debug.put_line ('Validation Success ');
2063: END IF;
2064:
2065: x_return_status := fnd_api.g_ret_sts_success;
2066: n := fnd_flex_descval.segment_count;
2067:
2068: /*Now let us copy back the storage value */
2069: FOR i IN 1 .. n LOOP
2188: ( 'Validation completed with errors for the Flex field : '
2189: || desc_flex_name);
2190: END IF;
2191:
2192: x_return_status := fnd_api.g_ret_sts_error;
2193: WHEN step_fetch_error THEN
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: WHEN OTHERS THEN
2196: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2190: END IF;
2191:
2192: x_return_status := fnd_api.g_ret_sts_error;
2193: WHEN step_fetch_error THEN
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: WHEN OTHERS THEN
2196: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2197: gme_debug.put_line ( g_pkg_name
2198: || '.'
2200: || ': '
2201: || 'in unexpected error');
2202: END IF;
2203:
2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
2206: END validate_flex_step_activities;
2207:
2208: /*======================================================================
2265: FROM gme_batch_step_resources
2266: WHERE batchstep_resource_id = v_rec_id;
2267: BEGIN
2268: /* Set return status to success initially */
2269: x_return_status := fnd_api.g_ret_sts_success;
2270:
2271: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2272: gme_debug.put_line ( 'Check if flexfield is enabled : '
2273: || desc_flex_name);
2320: /* All the following if statements will now retain that data. */
2321: IF p_step_resources.attribute_category IS NULL THEN
2322: l_attribute_category :=
2323: NVL (l_step_resource_row.attribute_category, '');
2324: ELSIF p_step_resources.attribute_category = fnd_api.g_miss_char THEN
2325: l_attribute_category := '';
2326: ELSE
2327: l_attribute_category := p_step_resources.attribute_category;
2328: END IF;
2339: fnd_flex_descval.set_column_value
2340: ('ATTRIBUTE1'
2341: ,NVL (l_step_resource_row.attribute1
2342: ,'') );
2343: ELSIF p_step_resources.attribute1 = fnd_api.g_miss_char THEN
2344: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
2345: l_step_resource_row.attribute1 := '';
2346: ELSE
2347: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
2353: fnd_flex_descval.set_column_value
2354: ('ATTRIBUTE2'
2355: ,NVL (l_step_resource_row.attribute2
2356: ,'') );
2357: ELSIF p_step_resources.attribute2 = fnd_api.g_miss_char THEN
2358: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
2359: l_step_resource_row.attribute2 := '';
2360: ELSE
2361: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
2367: fnd_flex_descval.set_column_value
2368: ('ATTRIBUTE3'
2369: ,NVL (l_step_resource_row.attribute3
2370: ,'') );
2371: ELSIF p_step_resources.attribute3 = fnd_api.g_miss_char THEN
2372: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
2373: l_step_resource_row.attribute3 := '';
2374: ELSE
2375: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
2381: fnd_flex_descval.set_column_value
2382: ('ATTRIBUTE4'
2383: ,NVL (l_step_resource_row.attribute4
2384: ,'') );
2385: ELSIF p_step_resources.attribute4 = fnd_api.g_miss_char THEN
2386: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
2387: l_step_resource_row.attribute4 := '';
2388: ELSE
2389: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
2395: fnd_flex_descval.set_column_value
2396: ('ATTRIBUTE5'
2397: ,NVL (l_step_resource_row.attribute5
2398: ,'') );
2399: ELSIF p_step_resources.attribute5 = fnd_api.g_miss_char THEN
2400: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
2401: l_step_resource_row.attribute5 := '';
2402: ELSE
2403: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
2409: fnd_flex_descval.set_column_value
2410: ('ATTRIBUTE6'
2411: ,NVL (l_step_resource_row.attribute6
2412: ,'') );
2413: ELSIF p_step_resources.attribute6 = fnd_api.g_miss_char THEN
2414: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
2415: l_step_resource_row.attribute6 := '';
2416: ELSE
2417: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
2423: fnd_flex_descval.set_column_value
2424: ('ATTRIBUTE7'
2425: ,NVL (l_step_resource_row.attribute7
2426: ,'') );
2427: ELSIF p_step_resources.attribute7 = fnd_api.g_miss_char THEN
2428: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
2429: l_step_resource_row.attribute7 := '';
2430: ELSE
2431: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
2437: fnd_flex_descval.set_column_value
2438: ('ATTRIBUTE8'
2439: ,NVL (l_step_resource_row.attribute8
2440: ,'') );
2441: ELSIF p_step_resources.attribute8 = fnd_api.g_miss_char THEN
2442: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
2443: l_step_resource_row.attribute8 := '';
2444: ELSE
2445: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
2451: fnd_flex_descval.set_column_value
2452: ('ATTRIBUTE9'
2453: ,NVL (l_step_resource_row.attribute9
2454: ,'') );
2455: ELSIF p_step_resources.attribute9 = fnd_api.g_miss_char THEN
2456: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
2457: l_step_resource_row.attribute9 := '';
2458: ELSE
2459: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
2465: fnd_flex_descval.set_column_value
2466: ('ATTRIBUTE10'
2467: ,NVL (l_step_resource_row.attribute10
2468: ,'') );
2469: ELSIF p_step_resources.attribute10 = fnd_api.g_miss_char THEN
2470: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
2471: l_step_resource_row.attribute10 := '';
2472: ELSE
2473: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
2479: fnd_flex_descval.set_column_value
2480: ('ATTRIBUTE11'
2481: ,NVL (l_step_resource_row.attribute11
2482: ,'') );
2483: ELSIF p_step_resources.attribute11 = fnd_api.g_miss_char THEN
2484: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
2485: l_step_resource_row.attribute11 := '';
2486: ELSE
2487: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
2493: fnd_flex_descval.set_column_value
2494: ('ATTRIBUTE12'
2495: ,NVL (l_step_resource_row.attribute12
2496: ,'') );
2497: ELSIF p_step_resources.attribute12 = fnd_api.g_miss_char THEN
2498: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
2499: l_step_resource_row.attribute12 := '';
2500: ELSE
2501: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
2507: fnd_flex_descval.set_column_value
2508: ('ATTRIBUTE13'
2509: ,NVL (l_step_resource_row.attribute13
2510: ,'') );
2511: ELSIF p_step_resources.attribute13 = fnd_api.g_miss_char THEN
2512: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
2513: l_step_resource_row.attribute13 := '';
2514: ELSE
2515: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
2521: fnd_flex_descval.set_column_value
2522: ('ATTRIBUTE14'
2523: ,NVL (l_step_resource_row.attribute14
2524: ,'') );
2525: ELSIF p_step_resources.attribute14 = fnd_api.g_miss_char THEN
2526: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
2527: l_step_resource_row.attribute14 := '';
2528: ELSE
2529: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
2535: fnd_flex_descval.set_column_value
2536: ('ATTRIBUTE15'
2537: ,NVL (l_step_resource_row.attribute15
2538: ,'') );
2539: ELSIF p_step_resources.attribute15 = fnd_api.g_miss_char THEN
2540: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
2541: l_step_resource_row.attribute15 := '';
2542: ELSE
2543: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
2549: fnd_flex_descval.set_column_value
2550: ('ATTRIBUTE16'
2551: ,NVL (l_step_resource_row.attribute16
2552: ,'') );
2553: ELSIF p_step_resources.attribute16 = fnd_api.g_miss_char THEN
2554: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
2555: l_step_resource_row.attribute16 := '';
2556: ELSE
2557: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
2563: fnd_flex_descval.set_column_value
2564: ('ATTRIBUTE17'
2565: ,NVL (l_step_resource_row.attribute17
2566: ,'') );
2567: ELSIF p_step_resources.attribute17 = fnd_api.g_miss_char THEN
2568: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
2569: l_step_resource_row.attribute17 := '';
2570: ELSE
2571: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
2577: fnd_flex_descval.set_column_value
2578: ('ATTRIBUTE18'
2579: ,NVL (l_step_resource_row.attribute18
2580: ,'') );
2581: ELSIF p_step_resources.attribute18 = fnd_api.g_miss_char THEN
2582: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
2583: l_step_resource_row.attribute18 := '';
2584: ELSE
2585: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
2591: fnd_flex_descval.set_column_value
2592: ('ATTRIBUTE19'
2593: ,NVL (l_step_resource_row.attribute19
2594: ,'') );
2595: ELSIF p_step_resources.attribute19 = fnd_api.g_miss_char THEN
2596: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
2597: l_step_resource_row.attribute19 := '';
2598: ELSE
2599: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
2605: fnd_flex_descval.set_column_value
2606: ('ATTRIBUTE20'
2607: ,NVL (l_step_resource_row.attribute20
2608: ,'') );
2609: ELSIF p_step_resources.attribute20 = fnd_api.g_miss_char THEN
2610: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
2611: l_step_resource_row.attribute20 := '';
2612: ELSE
2613: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
2619: fnd_flex_descval.set_column_value
2620: ('ATTRIBUTE21'
2621: ,NVL (l_step_resource_row.attribute21
2622: ,'') );
2623: ELSIF p_step_resources.attribute21 = fnd_api.g_miss_char THEN
2624: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
2625: l_step_resource_row.attribute21 := '';
2626: ELSE
2627: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
2633: fnd_flex_descval.set_column_value
2634: ('ATTRIBUTE22'
2635: ,NVL (l_step_resource_row.attribute22
2636: ,'') );
2637: ELSIF p_step_resources.attribute22 = fnd_api.g_miss_char THEN
2638: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
2639: l_step_resource_row.attribute22 := '';
2640: ELSE
2641: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
2647: fnd_flex_descval.set_column_value
2648: ('ATTRIBUTE23'
2649: ,NVL (l_step_resource_row.attribute23
2650: ,'') );
2651: ELSIF p_step_resources.attribute23 = fnd_api.g_miss_char THEN
2652: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
2653: l_step_resource_row.attribute23 := '';
2654: ELSE
2655: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
2661: fnd_flex_descval.set_column_value
2662: ('ATTRIBUTE24'
2663: ,NVL (l_step_resource_row.attribute24
2664: ,'') );
2665: ELSIF p_step_resources.attribute24 = fnd_api.g_miss_char THEN
2666: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
2667: l_step_resource_row.attribute24 := '';
2668: ELSE
2669: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
2675: fnd_flex_descval.set_column_value
2676: ('ATTRIBUTE25'
2677: ,NVL (l_step_resource_row.attribute25
2678: ,'') );
2679: ELSIF p_step_resources.attribute25 = fnd_api.g_miss_char THEN
2680: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
2681: l_step_resource_row.attribute25 := '';
2682: ELSE
2683: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
2689: fnd_flex_descval.set_column_value
2690: ('ATTRIBUTE26'
2691: ,NVL (l_step_resource_row.attribute26
2692: ,'') );
2693: ELSIF p_step_resources.attribute26 = fnd_api.g_miss_char THEN
2694: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
2695: l_step_resource_row.attribute26 := '';
2696: ELSE
2697: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
2703: fnd_flex_descval.set_column_value
2704: ('ATTRIBUTE27'
2705: ,NVL (l_step_resource_row.attribute27
2706: ,'') );
2707: ELSIF p_step_resources.attribute27 = fnd_api.g_miss_char THEN
2708: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
2709: l_step_resource_row.attribute27 := '';
2710: ELSE
2711: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
2717: fnd_flex_descval.set_column_value
2718: ('ATTRIBUTE28'
2719: ,NVL (l_step_resource_row.attribute28
2720: ,'') );
2721: ELSIF p_step_resources.attribute28 = fnd_api.g_miss_char THEN
2722: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
2723: l_step_resource_row.attribute28 := '';
2724: ELSE
2725: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
2731: fnd_flex_descval.set_column_value
2732: ('ATTRIBUTE29'
2733: ,NVL (l_step_resource_row.attribute29
2734: ,'') );
2735: ELSIF p_step_resources.attribute29 = fnd_api.g_miss_char THEN
2736: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
2737: l_step_resource_row.attribute29 := '';
2738: ELSE
2739: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
2745: fnd_flex_descval.set_column_value
2746: ('ATTRIBUTE30'
2747: ,NVL (l_step_resource_row.attribute30
2748: ,'') );
2749: ELSIF p_step_resources.attribute30 = fnd_api.g_miss_char THEN
2750: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
2751: l_step_resource_row.attribute30 := '';
2752: ELSE
2753: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
2814: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2815: gme_debug.put_line ('Validation Success ');
2816: END IF;
2817:
2818: x_return_status := fnd_api.g_ret_sts_success;
2819: n := fnd_flex_descval.segment_count;
2820:
2821: /*Now let us copy back the storage value */
2822: FOR i IN 1 .. n LOOP
2932: ( 'Validation completed with errors for the Flex field : '
2933: || desc_flex_name);
2934: END IF;
2935:
2936: x_return_status := fnd_api.g_ret_sts_error;
2937: WHEN step_fetch_error THEN
2938: x_return_status := fnd_api.g_ret_sts_error;
2939: WHEN OTHERS THEN
2940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2934: END IF;
2935:
2936: x_return_status := fnd_api.g_ret_sts_error;
2937: WHEN step_fetch_error THEN
2938: x_return_status := fnd_api.g_ret_sts_error;
2939: WHEN OTHERS THEN
2940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2941: gme_debug.put_line ( g_pkg_name
2942: || '.'
2944: || ': '
2945: || 'in unexpected error');
2946: END IF;
2947:
2948: x_return_status := fnd_api.g_ret_sts_unexp_error;
2949: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
2950: END validate_flex_step_resources;
2951:
2952: /*======================================================================
2993: FROM gme_resource_txns
2994: WHERE poc_trans_id = v_rec_id;
2995: BEGIN
2996: /* Set return status to success initially */
2997: x_return_status := fnd_api.g_ret_sts_success;
2998:
2999: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3000: gme_debug.put_line ( 'Check if flexfield is enabled : '
3001: || desc_flex_name);
3040: END IF;
3041:
3042: IF p_resource_txn_rec.attribute_category IS NULL THEN
3043: l_attribute_category := l_resource_txn_rec.attribute_category;
3044: ELSIF p_resource_txn_rec.attribute_category = fnd_api.g_miss_char THEN
3045: l_attribute_category := '';
3046: ELSE
3047: l_attribute_category := p_resource_txn_rec.attribute_category;
3048: END IF;
3058:
3059: IF p_resource_txn_rec.attribute1 IS NULL THEN
3060: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
3061: ,l_resource_txn_rec.attribute1);
3062: ELSIF p_resource_txn_rec.attribute1 = fnd_api.g_miss_char THEN
3063: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
3064: l_resource_txn_rec.attribute1 := '';
3065: ELSE
3066: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
3070:
3071: IF p_resource_txn_rec.attribute2 IS NULL THEN
3072: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
3073: ,l_resource_txn_rec.attribute2);
3074: ELSIF p_resource_txn_rec.attribute2 = fnd_api.g_miss_char THEN
3075: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
3076: l_resource_txn_rec.attribute2 := '';
3077: ELSE
3078: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
3082:
3083: IF p_resource_txn_rec.attribute3 IS NULL THEN
3084: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
3085: ,l_resource_txn_rec.attribute3);
3086: ELSIF p_resource_txn_rec.attribute3 = fnd_api.g_miss_char THEN
3087: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
3088: l_resource_txn_rec.attribute3 := '';
3089: ELSE
3090: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
3094:
3095: IF p_resource_txn_rec.attribute4 IS NULL THEN
3096: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
3097: ,l_resource_txn_rec.attribute4);
3098: ELSIF p_resource_txn_rec.attribute4 = fnd_api.g_miss_char THEN
3099: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
3100: l_resource_txn_rec.attribute4 := '';
3101: ELSE
3102: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
3106:
3107: IF p_resource_txn_rec.attribute5 IS NULL THEN
3108: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
3109: ,l_resource_txn_rec.attribute5);
3110: ELSIF p_resource_txn_rec.attribute5 = fnd_api.g_miss_char THEN
3111: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
3112: l_resource_txn_rec.attribute5 := '';
3113: ELSE
3114: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
3118:
3119: IF p_resource_txn_rec.attribute6 IS NULL THEN
3120: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
3121: ,l_resource_txn_rec.attribute6);
3122: ELSIF p_resource_txn_rec.attribute6 = fnd_api.g_miss_char THEN
3123: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
3124: l_resource_txn_rec.attribute6 := '';
3125: ELSE
3126: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
3130:
3131: IF p_resource_txn_rec.attribute7 IS NULL THEN
3132: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
3133: ,l_resource_txn_rec.attribute7);
3134: ELSIF p_resource_txn_rec.attribute7 = fnd_api.g_miss_char THEN
3135: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
3136: l_resource_txn_rec.attribute7 := '';
3137: ELSE
3138: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
3142:
3143: IF p_resource_txn_rec.attribute8 IS NULL THEN
3144: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
3145: ,l_resource_txn_rec.attribute8);
3146: ELSIF p_resource_txn_rec.attribute8 = fnd_api.g_miss_char THEN
3147: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
3148: l_resource_txn_rec.attribute8 := '';
3149: ELSE
3150: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
3154:
3155: IF p_resource_txn_rec.attribute9 IS NULL THEN
3156: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
3157: ,l_resource_txn_rec.attribute9);
3158: ELSIF p_resource_txn_rec.attribute9 = fnd_api.g_miss_char THEN
3159: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
3160: l_resource_txn_rec.attribute9 := '';
3161: ELSE
3162: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
3166:
3167: IF p_resource_txn_rec.attribute10 IS NULL THEN
3168: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
3169: ,l_resource_txn_rec.attribute10);
3170: ELSIF p_resource_txn_rec.attribute10 = fnd_api.g_miss_char THEN
3171: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
3172: l_resource_txn_rec.attribute10 := '';
3173: ELSE
3174: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
3178:
3179: IF p_resource_txn_rec.attribute11 IS NULL THEN
3180: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
3181: ,l_resource_txn_rec.attribute11);
3182: ELSIF p_resource_txn_rec.attribute11 = fnd_api.g_miss_char THEN
3183: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
3184: l_resource_txn_rec.attribute11 := '';
3185: ELSE
3186: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
3190:
3191: IF p_resource_txn_rec.attribute12 IS NULL THEN
3192: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
3193: ,l_resource_txn_rec.attribute12);
3194: ELSIF p_resource_txn_rec.attribute12 = fnd_api.g_miss_char THEN
3195: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
3196: l_resource_txn_rec.attribute12 := '';
3197: ELSE
3198: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
3202:
3203: IF p_resource_txn_rec.attribute13 IS NULL THEN
3204: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
3205: ,l_resource_txn_rec.attribute13);
3206: ELSIF p_resource_txn_rec.attribute13 = fnd_api.g_miss_char THEN
3207: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
3208: l_resource_txn_rec.attribute13 := '';
3209: ELSE
3210: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
3214:
3215: IF p_resource_txn_rec.attribute14 IS NULL THEN
3216: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
3217: ,l_resource_txn_rec.attribute14);
3218: ELSIF p_resource_txn_rec.attribute1 = fnd_api.g_miss_char THEN
3219: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
3220: l_resource_txn_rec.attribute14 := '';
3221: ELSE
3222: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
3226:
3227: IF p_resource_txn_rec.attribute15 IS NULL THEN
3228: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
3229: ,l_resource_txn_rec.attribute15);
3230: ELSIF p_resource_txn_rec.attribute15 = fnd_api.g_miss_char THEN
3231: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
3232: l_resource_txn_rec.attribute15 := '';
3233: ELSE
3234: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
3238:
3239: IF p_resource_txn_rec.attribute16 IS NULL THEN
3240: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
3241: ,l_resource_txn_rec.attribute16);
3242: ELSIF p_resource_txn_rec.attribute16 = fnd_api.g_miss_char THEN
3243: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
3244: l_resource_txn_rec.attribute16 := '';
3245: ELSE
3246: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
3250:
3251: IF p_resource_txn_rec.attribute17 IS NULL THEN
3252: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
3253: ,l_resource_txn_rec.attribute17);
3254: ELSIF p_resource_txn_rec.attribute17 = fnd_api.g_miss_char THEN
3255: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
3256: l_resource_txn_rec.attribute17 := '';
3257: ELSE
3258: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
3262:
3263: IF p_resource_txn_rec.attribute18 IS NULL THEN
3264: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
3265: ,l_resource_txn_rec.attribute18);
3266: ELSIF p_resource_txn_rec.attribute18 = fnd_api.g_miss_char THEN
3267: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
3268: l_resource_txn_rec.attribute18 := '';
3269: ELSE
3270: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
3274:
3275: IF p_resource_txn_rec.attribute19 IS NULL THEN
3276: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
3277: ,l_resource_txn_rec.attribute19);
3278: ELSIF p_resource_txn_rec.attribute19 = fnd_api.g_miss_char THEN
3279: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
3280: l_resource_txn_rec.attribute19 := '';
3281: ELSE
3282: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
3286:
3287: IF p_resource_txn_rec.attribute20 IS NULL THEN
3288: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
3289: ,l_resource_txn_rec.attribute20);
3290: ELSIF p_resource_txn_rec.attribute20 = fnd_api.g_miss_char THEN
3291: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
3292: l_resource_txn_rec.attribute20 := '';
3293: ELSE
3294: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
3298:
3299: IF p_resource_txn_rec.attribute21 IS NULL THEN
3300: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
3301: ,l_resource_txn_rec.attribute21);
3302: ELSIF p_resource_txn_rec.attribute21 = fnd_api.g_miss_char THEN
3303: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
3304: l_resource_txn_rec.attribute21 := '';
3305: ELSE
3306: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
3310:
3311: IF p_resource_txn_rec.attribute22 IS NULL THEN
3312: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
3313: ,l_resource_txn_rec.attribute22);
3314: ELSIF p_resource_txn_rec.attribute22 = fnd_api.g_miss_char THEN
3315: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
3316: l_resource_txn_rec.attribute22 := '';
3317: ELSE
3318: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
3322:
3323: IF p_resource_txn_rec.attribute23 IS NULL THEN
3324: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
3325: ,l_resource_txn_rec.attribute23);
3326: ELSIF p_resource_txn_rec.attribute23 = fnd_api.g_miss_char THEN
3327: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
3328: l_resource_txn_rec.attribute23 := '';
3329: ELSE
3330: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
3334:
3335: IF p_resource_txn_rec.attribute24 IS NULL THEN
3336: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
3337: ,l_resource_txn_rec.attribute1);
3338: ELSIF p_resource_txn_rec.attribute24 = fnd_api.g_miss_char THEN
3339: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
3340: l_resource_txn_rec.attribute1 := '';
3341: ELSE
3342: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
3346:
3347: IF p_resource_txn_rec.attribute25 IS NULL THEN
3348: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
3349: ,l_resource_txn_rec.attribute25);
3350: ELSIF p_resource_txn_rec.attribute25 = fnd_api.g_miss_char THEN
3351: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
3352: l_resource_txn_rec.attribute25 := '';
3353: ELSE
3354: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
3358:
3359: IF p_resource_txn_rec.attribute26 IS NULL THEN
3360: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
3361: ,l_resource_txn_rec.attribute26);
3362: ELSIF p_resource_txn_rec.attribute26 = fnd_api.g_miss_char THEN
3363: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
3364: l_resource_txn_rec.attribute26 := '';
3365: ELSE
3366: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
3370:
3371: IF p_resource_txn_rec.attribute27 IS NULL THEN
3372: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
3373: ,l_resource_txn_rec.attribute27);
3374: ELSIF p_resource_txn_rec.attribute27 = fnd_api.g_miss_char THEN
3375: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
3376: l_resource_txn_rec.attribute27 := '';
3377: ELSE
3378: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
3382:
3383: IF p_resource_txn_rec.attribute28 IS NULL THEN
3384: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
3385: ,l_resource_txn_rec.attribute28);
3386: ELSIF p_resource_txn_rec.attribute28 = fnd_api.g_miss_char THEN
3387: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
3388: l_resource_txn_rec.attribute28 := '';
3389: ELSE
3390: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
3394:
3395: IF p_resource_txn_rec.attribute29 IS NULL THEN
3396: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
3397: ,l_resource_txn_rec.attribute29);
3398: ELSIF p_resource_txn_rec.attribute29 = fnd_api.g_miss_char THEN
3399: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
3400: l_resource_txn_rec.attribute29 := '';
3401: ELSE
3402: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
3406:
3407: IF p_resource_txn_rec.attribute30 IS NULL THEN
3408: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
3409: ,l_resource_txn_rec.attribute30);
3410: ELSIF p_resource_txn_rec.attribute30 = fnd_api.g_miss_char THEN
3411: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
3412: l_resource_txn_rec.attribute30 := '';
3413: ELSE
3414: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
3471: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3472: gme_debug.put_line ('Validation Success ');
3473: END IF;
3474:
3475: x_return_status := fnd_api.g_ret_sts_success;
3476: n := fnd_flex_descval.segment_count;
3477:
3478: /*Now let us copy back the storage value */
3479: FOR i IN 1 .. n LOOP
3598: ( 'Validation completed with errors for the Flex field : '
3599: || desc_flex_name);
3600: END IF;
3601:
3602: x_return_status := fnd_api.g_ret_sts_error;
3603: WHEN step_fetch_error THEN
3604: x_return_status := fnd_api.g_ret_sts_error;
3605: WHEN OTHERS THEN
3606: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3600: END IF;
3601:
3602: x_return_status := fnd_api.g_ret_sts_error;
3603: WHEN step_fetch_error THEN
3604: x_return_status := fnd_api.g_ret_sts_error;
3605: WHEN OTHERS THEN
3606: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3607: gme_debug.put_line ( g_pkg_name
3608: || '.'
3610: || ': '
3611: || 'in unexpected error');
3612: END IF;
3613:
3614: x_return_status := fnd_api.g_ret_sts_unexp_error;
3615: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
3616: END validate_rsrc_txn_flex;
3617:
3618: /*end*/
3655: validation_error EXCEPTION;
3656: material_fetch_err EXCEPTION;
3657: BEGIN
3658: /* Set return status to success initially */
3659: x_return_status := fnd_api.g_ret_sts_success;
3660:
3661: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3662: gme_debug.put_line ( 'Check if flexfield is enabled : '
3663: || desc_flex_name);
3696:
3697: IF p_material_detail_rec.attribute_category IS NULL THEN
3698: l_attribute_category :=
3699: NVL (l_material_detail_rec.attribute_category, '');
3700: ELSIF p_material_detail_rec.attribute_category = fnd_api.g_miss_char THEN
3701: l_attribute_category := '';
3702: ELSE
3703: l_attribute_category := p_material_detail_rec.attribute_category;
3704: END IF;
3715: fnd_flex_descval.set_column_value
3716: ('ATTRIBUTE1'
3717: ,NVL (l_material_detail_rec.attribute1
3718: ,'') );
3719: ELSIF p_material_detail_rec.attribute1 = fnd_api.g_miss_char THEN
3720: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
3721: l_material_detail_rec.attribute1 := '';
3722: ELSE
3723: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
3729: fnd_flex_descval.set_column_value
3730: ('ATTRIBUTE2'
3731: ,NVL (l_material_detail_rec.attribute2
3732: ,'') );
3733: ELSIF p_material_detail_rec.attribute2 = fnd_api.g_miss_char THEN
3734: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
3735: l_material_detail_rec.attribute2 := '';
3736: ELSE
3737: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
3743: fnd_flex_descval.set_column_value
3744: ('ATTRIBUTE3'
3745: ,NVL (l_material_detail_rec.attribute3
3746: ,'') );
3747: ELSIF p_material_detail_rec.attribute3 = fnd_api.g_miss_char THEN
3748: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
3749: l_material_detail_rec.attribute3 := '';
3750: ELSE
3751: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
3757: fnd_flex_descval.set_column_value
3758: ('ATTRIBUTE4'
3759: ,NVL (l_material_detail_rec.attribute4
3760: ,'') );
3761: ELSIF p_material_detail_rec.attribute4 = fnd_api.g_miss_char THEN
3762: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
3763: l_material_detail_rec.attribute4 := '';
3764: ELSE
3765: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
3771: fnd_flex_descval.set_column_value
3772: ('ATTRIBUTE5'
3773: ,NVL (l_material_detail_rec.attribute5
3774: ,'') );
3775: ELSIF p_material_detail_rec.attribute5 = fnd_api.g_miss_char THEN
3776: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
3777: l_material_detail_rec.attribute5 := '';
3778: ELSE
3779: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
3785: fnd_flex_descval.set_column_value
3786: ('ATTRIBUTE6'
3787: ,NVL (l_material_detail_rec.attribute6
3788: ,'') );
3789: ELSIF p_material_detail_rec.attribute6 = fnd_api.g_miss_char THEN
3790: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
3791: l_material_detail_rec.attribute6 := '';
3792: ELSE
3793: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
3799: fnd_flex_descval.set_column_value
3800: ('ATTRIBUTE7'
3801: ,NVL (l_material_detail_rec.attribute7
3802: ,'') );
3803: ELSIF p_material_detail_rec.attribute7 = fnd_api.g_miss_char THEN
3804: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
3805: l_material_detail_rec.attribute7 := '';
3806: ELSE
3807: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
3813: fnd_flex_descval.set_column_value
3814: ('ATTRIBUTE8'
3815: ,NVL (l_material_detail_rec.attribute8
3816: ,'') );
3817: ELSIF p_material_detail_rec.attribute8 = fnd_api.g_miss_char THEN
3818: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
3819: l_material_detail_rec.attribute8 := '';
3820: ELSE
3821: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
3827: fnd_flex_descval.set_column_value
3828: ('ATTRIBUTE9'
3829: ,NVL (l_material_detail_rec.attribute9
3830: ,'') );
3831: ELSIF p_material_detail_rec.attribute9 = fnd_api.g_miss_char THEN
3832: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
3833: l_material_detail_rec.attribute9 := '';
3834: ELSE
3835: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
3841: fnd_flex_descval.set_column_value
3842: ('ATTRIBUTE10'
3843: ,NVL (l_material_detail_rec.attribute10
3844: ,'') );
3845: ELSIF p_material_detail_rec.attribute10 = fnd_api.g_miss_char THEN
3846: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
3847: l_material_detail_rec.attribute10 := '';
3848: ELSE
3849: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
3855: fnd_flex_descval.set_column_value
3856: ('ATTRIBUTE11'
3857: ,NVL (l_material_detail_rec.attribute11
3858: ,'') );
3859: ELSIF p_material_detail_rec.attribute11 = fnd_api.g_miss_char THEN
3860: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
3861: l_material_detail_rec.attribute11 := '';
3862: ELSE
3863: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
3869: fnd_flex_descval.set_column_value
3870: ('ATTRIBUTE12'
3871: ,NVL (l_material_detail_rec.attribute12
3872: ,'') );
3873: ELSIF p_material_detail_rec.attribute12 = fnd_api.g_miss_char THEN
3874: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
3875: l_material_detail_rec.attribute12 := '';
3876: ELSE
3877: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
3883: fnd_flex_descval.set_column_value
3884: ('ATTRIBUTE13'
3885: ,NVL (l_material_detail_rec.attribute13
3886: ,'') );
3887: ELSIF p_material_detail_rec.attribute13 = fnd_api.g_miss_char THEN
3888: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
3889: l_material_detail_rec.attribute13 := '';
3890: ELSE
3891: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
3897: fnd_flex_descval.set_column_value
3898: ('ATTRIBUTE14'
3899: ,NVL (l_material_detail_rec.attribute14
3900: ,'') );
3901: ELSIF p_material_detail_rec.attribute14 = fnd_api.g_miss_char THEN
3902: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
3903: l_material_detail_rec.attribute14 := '';
3904: ELSE
3905: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
3911: fnd_flex_descval.set_column_value
3912: ('ATTRIBUTE15'
3913: ,NVL (l_material_detail_rec.attribute15
3914: ,'') );
3915: ELSIF p_material_detail_rec.attribute15 = fnd_api.g_miss_char THEN
3916: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
3917: l_material_detail_rec.attribute15 := '';
3918: ELSE
3919: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
3925: fnd_flex_descval.set_column_value
3926: ('ATTRIBUTE16'
3927: ,NVL (l_material_detail_rec.attribute16
3928: ,'') );
3929: ELSIF p_material_detail_rec.attribute16 = fnd_api.g_miss_char THEN
3930: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
3931: l_material_detail_rec.attribute16 := '';
3932: ELSE
3933: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
3939: fnd_flex_descval.set_column_value
3940: ('ATTRIBUTE17'
3941: ,NVL (l_material_detail_rec.attribute17
3942: ,'') );
3943: ELSIF p_material_detail_rec.attribute17 = fnd_api.g_miss_char THEN
3944: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
3945: l_material_detail_rec.attribute17 := '';
3946: ELSE
3947: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
3953: fnd_flex_descval.set_column_value
3954: ('ATTRIBUTE18'
3955: ,NVL (l_material_detail_rec.attribute18
3956: ,'') );
3957: ELSIF p_material_detail_rec.attribute18 = fnd_api.g_miss_char THEN
3958: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
3959: l_material_detail_rec.attribute18 := '';
3960: ELSE
3961: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
3967: fnd_flex_descval.set_column_value
3968: ('ATTRIBUTE19'
3969: ,NVL (l_material_detail_rec.attribute19
3970: ,'') );
3971: ELSIF p_material_detail_rec.attribute19 = fnd_api.g_miss_char THEN
3972: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
3973: l_material_detail_rec.attribute19 := '';
3974: ELSE
3975: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
3981: fnd_flex_descval.set_column_value
3982: ('ATTRIBUTE20'
3983: ,NVL (l_material_detail_rec.attribute20
3984: ,'') );
3985: ELSIF p_material_detail_rec.attribute20 = fnd_api.g_miss_char THEN
3986: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
3987: l_material_detail_rec.attribute20 := '';
3988: ELSE
3989: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
3995: fnd_flex_descval.set_column_value
3996: ('ATTRIBUTE21'
3997: ,NVL (l_material_detail_rec.attribute21
3998: ,'') );
3999: ELSIF p_material_detail_rec.attribute21 = fnd_api.g_miss_char THEN
4000: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
4001: l_material_detail_rec.attribute21 := '';
4002: ELSE
4003: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
4009: fnd_flex_descval.set_column_value
4010: ('ATTRIBUTE22'
4011: ,NVL (l_material_detail_rec.attribute22
4012: ,'') );
4013: ELSIF p_material_detail_rec.attribute22 = fnd_api.g_miss_char THEN
4014: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
4015: l_material_detail_rec.attribute22 := '';
4016: ELSE
4017: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
4023: fnd_flex_descval.set_column_value
4024: ('ATTRIBUTE23'
4025: ,NVL (l_material_detail_rec.attribute23
4026: ,'') );
4027: ELSIF p_material_detail_rec.attribute23 = fnd_api.g_miss_char THEN
4028: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
4029: l_material_detail_rec.attribute23 := '';
4030: ELSE
4031: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
4037: fnd_flex_descval.set_column_value
4038: ('ATTRIBUTE24'
4039: ,NVL (l_material_detail_rec.attribute24
4040: ,'') );
4041: ELSIF p_material_detail_rec.attribute24 = fnd_api.g_miss_char THEN
4042: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
4043: l_material_detail_rec.attribute24 := '';
4044: ELSE
4045: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
4051: fnd_flex_descval.set_column_value
4052: ('ATTRIBUTE25'
4053: ,NVL (l_material_detail_rec.attribute25
4054: ,'') );
4055: ELSIF p_material_detail_rec.attribute25 = fnd_api.g_miss_char THEN
4056: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
4057: l_material_detail_rec.attribute25 := '';
4058: ELSE
4059: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
4065: fnd_flex_descval.set_column_value
4066: ('ATTRIBUTE26'
4067: ,NVL (l_material_detail_rec.attribute26
4068: ,'') );
4069: ELSIF p_material_detail_rec.attribute26 = fnd_api.g_miss_char THEN
4070: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
4071: l_material_detail_rec.attribute26 := '';
4072: ELSE
4073: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
4079: fnd_flex_descval.set_column_value
4080: ('ATTRIBUTE27'
4081: ,NVL (l_material_detail_rec.attribute27
4082: ,'') );
4083: ELSIF p_material_detail_rec.attribute27 = fnd_api.g_miss_char THEN
4084: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
4085: l_material_detail_rec.attribute27 := '';
4086: ELSE
4087: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
4093: fnd_flex_descval.set_column_value
4094: ('ATTRIBUTE28'
4095: ,NVL (l_material_detail_rec.attribute28
4096: ,'') );
4097: ELSIF p_material_detail_rec.attribute28 = fnd_api.g_miss_char THEN
4098: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
4099: l_material_detail_rec.attribute28 := '';
4100: ELSE
4101: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
4107: fnd_flex_descval.set_column_value
4108: ('ATTRIBUTE29'
4109: ,NVL (l_material_detail_rec.attribute29
4110: ,'') );
4111: ELSIF p_material_detail_rec.attribute29 = fnd_api.g_miss_char THEN
4112: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
4113: l_material_detail_rec.attribute29 := '';
4114: ELSE
4115: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
4121: fnd_flex_descval.set_column_value
4122: ('ATTRIBUTE30'
4123: ,NVL (l_material_detail_rec.attribute30
4124: ,'') );
4125: ELSIF p_material_detail_rec.attribute30 = fnd_api.g_miss_char THEN
4126: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
4127: l_material_detail_rec.attribute30 := '';
4128: ELSE
4129: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
4188: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4189: gme_debug.put_line ('Validation Success ');
4190: END IF;
4191:
4192: x_return_status := fnd_api.g_ret_sts_success;
4193: n := fnd_flex_descval.segment_count;
4194:
4195: /*Now let us copy back the storage value */
4196: FOR i IN 1 .. n LOOP
4315: ( 'Validation completed with errors for the Flex field : '
4316: || desc_flex_name);
4317: END IF;
4318:
4319: x_return_status := fnd_api.g_ret_sts_error;
4320: WHEN material_fetch_err THEN
4321: x_return_status := fnd_api.g_ret_sts_error;
4322: WHEN OTHERS THEN
4323: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4317: END IF;
4318:
4319: x_return_status := fnd_api.g_ret_sts_error;
4320: WHEN material_fetch_err THEN
4321: x_return_status := fnd_api.g_ret_sts_error;
4322: WHEN OTHERS THEN
4323: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4324: gme_debug.put_line ( g_pkg_name
4325: || '.'
4327: || ': '
4328: || 'in unexpected error');
4329: END IF;
4330:
4331: x_return_status := fnd_api.g_ret_sts_unexp_error;
4332: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
4333: END validate_flex_material_details;
4334:
4335: /*======================================================================
4391: FROM gme_process_parameters
4392: WHERE process_param_id = v_rec_id;
4393: BEGIN
4394: /* Set return status to success initially */
4395: x_return_status := fnd_api.g_ret_sts_success;
4396:
4397: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4398: gme_debug.put_line ( 'Check if flexfield is enabled : '
4399: || desc_flex_name);
4444: /* All the following if statements will now retain that data. */
4445: IF p_process_param_rec.attribute_category IS NULL THEN
4446: l_attribute_category :=
4447: NVL (l_process_param_rec.attribute_category, '');
4448: ELSIF p_process_param_rec.attribute_category = fnd_api.g_miss_char THEN
4449: l_attribute_category := '';
4450: ELSE
4451: l_attribute_category := p_process_param_rec.attribute_category;
4452: END IF;
4463: fnd_flex_descval.set_column_value
4464: ('ATTRIBUTE1'
4465: ,NVL (l_process_param_rec.attribute1
4466: ,'') );
4467: ELSIF p_process_param_rec.attribute1 = fnd_api.g_miss_char THEN
4468: fnd_flex_descval.set_column_value ('ATTRIBUTE1', '');
4469: l_process_param_rec.attribute1 := '';
4470: ELSE
4471: fnd_flex_descval.set_column_value ('ATTRIBUTE1'
4477: fnd_flex_descval.set_column_value
4478: ('ATTRIBUTE2'
4479: ,NVL (l_process_param_rec.attribute2
4480: ,'') );
4481: ELSIF p_process_param_rec.attribute2 = fnd_api.g_miss_char THEN
4482: fnd_flex_descval.set_column_value ('ATTRIBUTE2', '');
4483: l_process_param_rec.attribute2 := '';
4484: ELSE
4485: fnd_flex_descval.set_column_value ('ATTRIBUTE2'
4491: fnd_flex_descval.set_column_value
4492: ('ATTRIBUTE3'
4493: ,NVL (l_process_param_rec.attribute3
4494: ,'') );
4495: ELSIF p_process_param_rec.attribute3 = fnd_api.g_miss_char THEN
4496: fnd_flex_descval.set_column_value ('ATTRIBUTE3', '');
4497: l_process_param_rec.attribute3 := '';
4498: ELSE
4499: fnd_flex_descval.set_column_value ('ATTRIBUTE3'
4505: fnd_flex_descval.set_column_value
4506: ('ATTRIBUTE4'
4507: ,NVL (l_process_param_rec.attribute4
4508: ,'') );
4509: ELSIF p_process_param_rec.attribute4 = fnd_api.g_miss_char THEN
4510: fnd_flex_descval.set_column_value ('ATTRIBUTE4', '');
4511: l_process_param_rec.attribute4 := '';
4512: ELSE
4513: fnd_flex_descval.set_column_value ('ATTRIBUTE4'
4519: fnd_flex_descval.set_column_value
4520: ('ATTRIBUTE5'
4521: ,NVL (l_process_param_rec.attribute5
4522: ,'') );
4523: ELSIF p_process_param_rec.attribute5 = fnd_api.g_miss_char THEN
4524: fnd_flex_descval.set_column_value ('ATTRIBUTE5', '');
4525: l_process_param_rec.attribute5 := '';
4526: ELSE
4527: fnd_flex_descval.set_column_value ('ATTRIBUTE5'
4533: fnd_flex_descval.set_column_value
4534: ('ATTRIBUTE6'
4535: ,NVL (l_process_param_rec.attribute6
4536: ,'') );
4537: ELSIF p_process_param_rec.attribute6 = fnd_api.g_miss_char THEN
4538: fnd_flex_descval.set_column_value ('ATTRIBUTE6', '');
4539: l_process_param_rec.attribute6 := '';
4540: ELSE
4541: fnd_flex_descval.set_column_value ('ATTRIBUTE6'
4547: fnd_flex_descval.set_column_value
4548: ('ATTRIBUTE7'
4549: ,NVL (l_process_param_rec.attribute7
4550: ,'') );
4551: ELSIF p_process_param_rec.attribute7 = fnd_api.g_miss_char THEN
4552: fnd_flex_descval.set_column_value ('ATTRIBUTE7', '');
4553: l_process_param_rec.attribute7 := '';
4554: ELSE
4555: fnd_flex_descval.set_column_value ('ATTRIBUTE7'
4561: fnd_flex_descval.set_column_value
4562: ('ATTRIBUTE8'
4563: ,NVL (l_process_param_rec.attribute8
4564: ,'') );
4565: ELSIF p_process_param_rec.attribute8 = fnd_api.g_miss_char THEN
4566: fnd_flex_descval.set_column_value ('ATTRIBUTE8', '');
4567: l_process_param_rec.attribute8 := '';
4568: ELSE
4569: fnd_flex_descval.set_column_value ('ATTRIBUTE8'
4575: fnd_flex_descval.set_column_value
4576: ('ATTRIBUTE9'
4577: ,NVL (l_process_param_rec.attribute9
4578: ,'') );
4579: ELSIF p_process_param_rec.attribute9 = fnd_api.g_miss_char THEN
4580: fnd_flex_descval.set_column_value ('ATTRIBUTE9', '');
4581: l_process_param_rec.attribute9 := '';
4582: ELSE
4583: fnd_flex_descval.set_column_value ('ATTRIBUTE9'
4589: fnd_flex_descval.set_column_value
4590: ('ATTRIBUTE10'
4591: ,NVL (l_process_param_rec.attribute10
4592: ,'') );
4593: ELSIF p_process_param_rec.attribute10 = fnd_api.g_miss_char THEN
4594: fnd_flex_descval.set_column_value ('ATTRIBUTE10', '');
4595: l_process_param_rec.attribute10 := '';
4596: ELSE
4597: fnd_flex_descval.set_column_value ('ATTRIBUTE10'
4603: fnd_flex_descval.set_column_value
4604: ('ATTRIBUTE11'
4605: ,NVL (l_process_param_rec.attribute11
4606: ,'') );
4607: ELSIF p_process_param_rec.attribute11 = fnd_api.g_miss_char THEN
4608: fnd_flex_descval.set_column_value ('ATTRIBUTE11', '');
4609: l_process_param_rec.attribute11 := '';
4610: ELSE
4611: fnd_flex_descval.set_column_value ('ATTRIBUTE11'
4617: fnd_flex_descval.set_column_value
4618: ('ATTRIBUTE12'
4619: ,NVL (l_process_param_rec.attribute12
4620: ,'') );
4621: ELSIF p_process_param_rec.attribute12 = fnd_api.g_miss_char THEN
4622: fnd_flex_descval.set_column_value ('ATTRIBUTE12', '');
4623: l_process_param_rec.attribute12 := '';
4624: ELSE
4625: fnd_flex_descval.set_column_value ('ATTRIBUTE12'
4631: fnd_flex_descval.set_column_value
4632: ('ATTRIBUTE13'
4633: ,NVL (l_process_param_rec.attribute13
4634: ,'') );
4635: ELSIF p_process_param_rec.attribute13 = fnd_api.g_miss_char THEN
4636: fnd_flex_descval.set_column_value ('ATTRIBUTE13', '');
4637: l_process_param_rec.attribute13 := '';
4638: ELSE
4639: fnd_flex_descval.set_column_value ('ATTRIBUTE13'
4645: fnd_flex_descval.set_column_value
4646: ('ATTRIBUTE14'
4647: ,NVL (l_process_param_rec.attribute14
4648: ,'') );
4649: ELSIF p_process_param_rec.attribute14 = fnd_api.g_miss_char THEN
4650: fnd_flex_descval.set_column_value ('ATTRIBUTE14', '');
4651: l_process_param_rec.attribute14 := '';
4652: ELSE
4653: fnd_flex_descval.set_column_value ('ATTRIBUTE14'
4659: fnd_flex_descval.set_column_value
4660: ('ATTRIBUTE15'
4661: ,NVL (l_process_param_rec.attribute15
4662: ,'') );
4663: ELSIF p_process_param_rec.attribute15 = fnd_api.g_miss_char THEN
4664: fnd_flex_descval.set_column_value ('ATTRIBUTE15', '');
4665: l_process_param_rec.attribute15 := '';
4666: ELSE
4667: fnd_flex_descval.set_column_value ('ATTRIBUTE15'
4673: fnd_flex_descval.set_column_value
4674: ('ATTRIBUTE16'
4675: ,NVL (l_process_param_rec.attribute16
4676: ,'') );
4677: ELSIF p_process_param_rec.attribute16 = fnd_api.g_miss_char THEN
4678: fnd_flex_descval.set_column_value ('ATTRIBUTE16', '');
4679: l_process_param_rec.attribute16 := '';
4680: ELSE
4681: fnd_flex_descval.set_column_value ('ATTRIBUTE16'
4687: fnd_flex_descval.set_column_value
4688: ('ATTRIBUTE17'
4689: ,NVL (l_process_param_rec.attribute17
4690: ,'') );
4691: ELSIF p_process_param_rec.attribute17 = fnd_api.g_miss_char THEN
4692: fnd_flex_descval.set_column_value ('ATTRIBUTE17', '');
4693: l_process_param_rec.attribute17 := '';
4694: ELSE
4695: fnd_flex_descval.set_column_value ('ATTRIBUTE17'
4701: fnd_flex_descval.set_column_value
4702: ('ATTRIBUTE18'
4703: ,NVL (l_process_param_rec.attribute18
4704: ,'') );
4705: ELSIF p_process_param_rec.attribute18 = fnd_api.g_miss_char THEN
4706: fnd_flex_descval.set_column_value ('ATTRIBUTE18', '');
4707: l_process_param_rec.attribute18 := '';
4708: ELSE
4709: fnd_flex_descval.set_column_value ('ATTRIBUTE18'
4715: fnd_flex_descval.set_column_value
4716: ('ATTRIBUTE19'
4717: ,NVL (l_process_param_rec.attribute19
4718: ,'') );
4719: ELSIF p_process_param_rec.attribute19 = fnd_api.g_miss_char THEN
4720: fnd_flex_descval.set_column_value ('ATTRIBUTE19', '');
4721: l_process_param_rec.attribute19 := '';
4722: ELSE
4723: fnd_flex_descval.set_column_value ('ATTRIBUTE19'
4729: fnd_flex_descval.set_column_value
4730: ('ATTRIBUTE20'
4731: ,NVL (l_process_param_rec.attribute20
4732: ,'') );
4733: ELSIF p_process_param_rec.attribute20 = fnd_api.g_miss_char THEN
4734: fnd_flex_descval.set_column_value ('ATTRIBUTE20', '');
4735: l_process_param_rec.attribute20 := '';
4736: ELSE
4737: fnd_flex_descval.set_column_value ('ATTRIBUTE20'
4743: fnd_flex_descval.set_column_value
4744: ('ATTRIBUTE21'
4745: ,NVL (l_process_param_rec.attribute21
4746: ,'') );
4747: ELSIF p_process_param_rec.attribute21 = fnd_api.g_miss_char THEN
4748: fnd_flex_descval.set_column_value ('ATTRIBUTE21', '');
4749: l_process_param_rec.attribute21 := '';
4750: ELSE
4751: fnd_flex_descval.set_column_value ('ATTRIBUTE21'
4757: fnd_flex_descval.set_column_value
4758: ('ATTRIBUTE22'
4759: ,NVL (l_process_param_rec.attribute22
4760: ,'') );
4761: ELSIF p_process_param_rec.attribute22 = fnd_api.g_miss_char THEN
4762: fnd_flex_descval.set_column_value ('ATTRIBUTE22', '');
4763: l_process_param_rec.attribute22 := '';
4764: ELSE
4765: fnd_flex_descval.set_column_value ('ATTRIBUTE22'
4771: fnd_flex_descval.set_column_value
4772: ('ATTRIBUTE23'
4773: ,NVL (l_process_param_rec.attribute23
4774: ,'') );
4775: ELSIF p_process_param_rec.attribute23 = fnd_api.g_miss_char THEN
4776: fnd_flex_descval.set_column_value ('ATTRIBUTE23', '');
4777: l_process_param_rec.attribute23 := '';
4778: ELSE
4779: fnd_flex_descval.set_column_value ('ATTRIBUTE23'
4785: fnd_flex_descval.set_column_value
4786: ('ATTRIBUTE24'
4787: ,NVL (l_process_param_rec.attribute24
4788: ,'') );
4789: ELSIF p_process_param_rec.attribute24 = fnd_api.g_miss_char THEN
4790: fnd_flex_descval.set_column_value ('ATTRIBUTE24', '');
4791: l_process_param_rec.attribute24 := '';
4792: ELSE
4793: fnd_flex_descval.set_column_value ('ATTRIBUTE24'
4799: fnd_flex_descval.set_column_value
4800: ('ATTRIBUTE25'
4801: ,NVL (l_process_param_rec.attribute25
4802: ,'') );
4803: ELSIF p_process_param_rec.attribute25 = fnd_api.g_miss_char THEN
4804: fnd_flex_descval.set_column_value ('ATTRIBUTE25', '');
4805: l_process_param_rec.attribute25 := '';
4806: ELSE
4807: fnd_flex_descval.set_column_value ('ATTRIBUTE25'
4813: fnd_flex_descval.set_column_value
4814: ('ATTRIBUTE26'
4815: ,NVL (l_process_param_rec.attribute26
4816: ,'') );
4817: ELSIF p_process_param_rec.attribute26 = fnd_api.g_miss_char THEN
4818: fnd_flex_descval.set_column_value ('ATTRIBUTE26', '');
4819: l_process_param_rec.attribute26 := '';
4820: ELSE
4821: fnd_flex_descval.set_column_value ('ATTRIBUTE26'
4827: fnd_flex_descval.set_column_value
4828: ('ATTRIBUTE27'
4829: ,NVL (l_process_param_rec.attribute27
4830: ,'') );
4831: ELSIF p_process_param_rec.attribute27 = fnd_api.g_miss_char THEN
4832: fnd_flex_descval.set_column_value ('ATTRIBUTE27', '');
4833: l_process_param_rec.attribute27 := '';
4834: ELSE
4835: fnd_flex_descval.set_column_value ('ATTRIBUTE27'
4841: fnd_flex_descval.set_column_value
4842: ('ATTRIBUTE28'
4843: ,NVL (l_process_param_rec.attribute28
4844: ,'') );
4845: ELSIF p_process_param_rec.attribute28 = fnd_api.g_miss_char THEN
4846: fnd_flex_descval.set_column_value ('ATTRIBUTE28', '');
4847: l_process_param_rec.attribute28 := '';
4848: ELSE
4849: fnd_flex_descval.set_column_value ('ATTRIBUTE28'
4855: fnd_flex_descval.set_column_value
4856: ('ATTRIBUTE29'
4857: ,NVL (l_process_param_rec.attribute29
4858: ,'') );
4859: ELSIF p_process_param_rec.attribute29 = fnd_api.g_miss_char THEN
4860: fnd_flex_descval.set_column_value ('ATTRIBUTE29', '');
4861: l_process_param_rec.attribute29 := '';
4862: ELSE
4863: fnd_flex_descval.set_column_value ('ATTRIBUTE29'
4869: fnd_flex_descval.set_column_value
4870: ('ATTRIBUTE30'
4871: ,NVL (l_process_param_rec.attribute30
4872: ,'') );
4873: ELSIF p_process_param_rec.attribute30 = fnd_api.g_miss_char THEN
4874: fnd_flex_descval.set_column_value ('ATTRIBUTE30', '');
4875: l_process_param_rec.attribute30 := '';
4876: ELSE
4877: fnd_flex_descval.set_column_value ('ATTRIBUTE30'
4884: /* with a where clause using block fields from the form. */
4885: /* Pass back all flexfield values w/ no validation. */
4886:
4887: /* Nsinha changed the condition IF g_flex_validate_prof = 0 THEN as part of GME_Process_Parameter_APIs_TD */
4888: IF p_validate_flexfields = fnd_api.g_false THEN
4889: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4890: gme_debug.put_line
4891: ('GME Flexfield is not enabled, No validation required.');
4892: END IF;
4940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4941: gme_debug.put_line ('Validation Success ');
4942: END IF;
4943:
4944: x_return_status := fnd_api.g_ret_sts_success;
4945: n := fnd_flex_descval.segment_count;
4946:
4947: /*Now let us copy back the storage value */
4948: FOR i IN 1 .. n LOOP
5067: ( 'Validation completed with errors for the Flex field : '
5068: || desc_flex_name);
5069: END IF;
5070:
5071: x_return_status := fnd_api.g_ret_sts_error;
5072: WHEN process_param_fetch_error THEN
5073: x_return_status := fnd_api.g_ret_sts_error;
5074: WHEN OTHERS THEN
5075: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5069: END IF;
5070:
5071: x_return_status := fnd_api.g_ret_sts_error;
5072: WHEN process_param_fetch_error THEN
5073: x_return_status := fnd_api.g_ret_sts_error;
5074: WHEN OTHERS THEN
5075: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5076: gme_debug.put_line ( g_pkg_name
5077: || '.'
5079: || ': '
5080: || 'in unexpected error');
5081: END IF;
5082:
5083: x_return_status := fnd_api.g_ret_sts_unexp_error;
5084: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
5085: END validate_flex_process_param;
5086:
5087: -- FPBug#4395561 Start
5120: defaulting_error EXCEPTION;
5121:
5122: BEGIN
5123: /* Set return status to success initially */
5124: x_return_status := FND_API.G_RET_STS_SUCCESS;
5125: x_batch_header := p_batch_header;
5126:
5127: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5128: gme_debug.put_line (
5275: --SUCCESS
5276: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5277: gme_debug.put_line ('Defaulting Success. ');
5278: END IF;
5279: x_return_status := FND_API.G_RET_STS_SUCCESS;
5280: n := fnd_flex_descval.segment_count;
5281: /*Now let us copy back the default values returned from the above call */
5282: FOR i IN 1 .. n
5283: LOOP
5391: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5392: gme_debug.put_line (
5393: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
5394: END IF;
5395: x_return_status := FND_API.G_RET_STS_ERROR;
5396: WHEN OTHERS THEN
5397: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5398: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5399: END IF;
5396: WHEN OTHERS THEN
5397: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5398: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5399: END IF;
5400: x_return_status := FND_API.g_ret_sts_unexp_error;
5401: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
5402: END create_flex_batch_header;
5403:
5404: /*======================================================================
5434: l_attribute_category VARCHAR2 (240);
5435: defaulting_error EXCEPTION;
5436: BEGIN
5437: /* Set return status to success initially */
5438: x_return_status := FND_API.G_RET_STS_SUCCESS;
5439: x_batch_step := p_batch_step;
5440:
5441: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5442: gme_debug.put_line (
5560: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5561: gme_debug.put_line ('Defaulting Success. ');
5562: END IF;
5563:
5564: x_return_status := FND_API.G_RET_STS_SUCCESS;
5565: n := fnd_flex_descval.segment_count;
5566: /*Now let us copy back the default values returned from the above call */
5567: FOR i IN 1 .. n
5568: LOOP
5655: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5656: gme_debug.put_line (
5657: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
5658: END IF;
5659: x_return_status := FND_API.G_RET_STS_ERROR;
5660: WHEN OTHERS THEN
5661: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5662: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5663: END IF;
5660: WHEN OTHERS THEN
5661: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5662: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5663: END IF;
5664: x_return_status := FND_API.g_ret_sts_unexp_error;
5665: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
5666: END create_flex_batch_step;
5667: /*======================================================================
5668: -- NAME
5697: l_attribute_category VARCHAR2 (240);
5698: defaulting_error EXCEPTION;
5699: BEGIN
5700: /* Set return status to success initially */
5701: x_return_status := FND_API.G_RET_STS_SUCCESS;
5702: x_step_activities := p_step_activities;
5703:
5704: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5705: gme_debug.put_line (
5822: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5823: gme_debug.put_line ('Defaulting Success. ');
5824: END IF;
5825:
5826: x_return_status := FND_API.G_RET_STS_SUCCESS;
5827: n := fnd_flex_descval.segment_count;
5828: /*Now let us copy back the default values returned from the above call */
5829: FOR i IN 1 .. n
5830: LOOP
5917: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5918: gme_debug.put_line (
5919: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
5920: END IF;
5921: x_return_status := FND_API.G_RET_STS_ERROR;
5922: WHEN OTHERS THEN
5923: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5924: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5925: END IF;
5922: WHEN OTHERS THEN
5923: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
5924: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
5925: END IF;
5926: x_return_status := FND_API.g_ret_sts_unexp_error;
5927: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
5928: END create_flex_step_activities;
5929:
5930: /*======================================================================
5960: l_attribute_category VARCHAR2 (240);
5961: defaulting_error EXCEPTION;
5962: BEGIN
5963: /* Set return status to success initially */
5964: x_return_status := FND_API.G_RET_STS_SUCCESS;
5965: x_step_resources := p_step_resources;
5966:
5967: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
5968: gme_debug.put_line (
6087: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6088: gme_debug.put_line ('Defaulting Success. ');
6089: END IF;
6090:
6091: x_return_status := FND_API.G_RET_STS_SUCCESS;
6092: n := fnd_flex_descval.segment_count;
6093: /*Now let us copy back the default values returned from the above call */
6094: FOR i IN 1 .. n
6095: LOOP
6182: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6183: gme_debug.put_line (
6184: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
6185: END IF;
6186: x_return_status := FND_API.G_RET_STS_ERROR;
6187: WHEN OTHERS THEN
6188: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6189: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6190: END IF;
6187: WHEN OTHERS THEN
6188: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6189: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6190: END IF;
6191: x_return_status := FND_API.g_ret_sts_unexp_error;
6192: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
6193: END create_flex_step_resources;
6194:
6195: /*======================================================================
6224: l_attribute_category VARCHAR2 (240);
6225: defaulting_error EXCEPTION;
6226: BEGIN
6227: /* Set return status to success initially */
6228: x_return_status := FND_API.G_RET_STS_SUCCESS;
6229: x_process_param_rec := p_process_param_rec;
6230:
6231: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6232: gme_debug.put_line (
6351: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6352: gme_debug.put_line ('Defaulting Success. ');
6353: END IF;
6354:
6355: x_return_status := FND_API.G_RET_STS_SUCCESS;
6356: n := fnd_flex_descval.segment_count;
6357: /*Now let us copy back the default values returned from the above call */
6358: FOR i IN 1 .. n
6359: LOOP
6445: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6446: gme_debug.put_line (
6447: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
6448: END IF;
6449: x_return_status := FND_API.G_RET_STS_ERROR;
6450: WHEN OTHERS THEN
6451: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6452: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6453: END IF;
6450: WHEN OTHERS THEN
6451: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6452: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6453: END IF;
6454: x_return_status := FND_API.g_ret_sts_unexp_error;
6455: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
6456: END create_flex_process_param;
6457: /*======================================================================
6458: * NAME
6490: defaulting_error EXCEPTION;
6491:
6492: BEGIN
6493: /* Set return status to success initially */
6494: x_return_status := FND_API.G_RET_STS_SUCCESS;
6495: x_material_detail := p_material_detail;
6496:
6497: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6498: gme_debug.put_line (
6615: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6616: gme_debug.put_line ('Defaulting Success. ');
6617: END IF;
6618:
6619: x_return_status := FND_API.G_RET_STS_SUCCESS;
6620: n := fnd_flex_descval.segment_count;
6621: /*Now let us copy back the default values returned from the above call */
6622: FOR i IN 1 .. n
6623: LOOP
6709: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6710: gme_debug.put_line (
6711: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
6712: END IF;
6713: x_return_status := FND_API.G_RET_STS_ERROR;
6714: WHEN OTHERS THEN
6715: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6716: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6717: END IF;
6714: WHEN OTHERS THEN
6715: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6716: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6717: END IF;
6718: x_return_status := FND_API.g_ret_sts_unexp_error;
6719: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
6720: END create_flex_material_details;
6721:
6722: /*======================================================================
6749: l_attribute_category VARCHAR2 (240);
6750: defaulting_error EXCEPTION;
6751: BEGIN
6752: /* Set return status to success initially */
6753: x_return_status := FND_API.G_RET_STS_SUCCESS;
6754: x_resource_txns := p_resource_txns;
6755:
6756: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6757: gme_debug.put_line (
6875: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6876: gme_debug.put_line ('Defaulting Success. ');
6877: END IF;
6878:
6879: x_return_status := FND_API.G_RET_STS_SUCCESS;
6880: n := fnd_flex_descval.segment_count;
6881: /*Now let us copy back the default values returned from the above call */
6882: FOR i IN 1 .. n
6883: LOOP
6969: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
6970: gme_debug.put_line (
6971: 'Defaulting completed with errors for the Flex field : ' ||desc_flex_name);
6972: END IF;
6973: x_return_status := FND_API.G_RET_STS_ERROR;
6974: WHEN OTHERS THEN
6975: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6976: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6977: END IF;
6974: WHEN OTHERS THEN
6975: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
6976: gme_debug.put_line (g_pkg_name||'.'||desc_flex_name||': '||'in unexpected error');
6977: END IF;
6978: x_return_status := FND_API.g_ret_sts_unexp_error;
6979: fnd_msg_pub.add_exc_msg (g_pkg_name, desc_flex_name);
6980: END create_flex_resource_txns;
6981:
6982: --FPBug#4395561 End