236: rule_error EXCEPTION;
237: /*
238: CONSTANTS
239: */
240: cst_space CONSTANT VARCHAR2(1) := Fnd_Global.Local_Chr(31);
241: /*
242: GLOBALS
243: for debuging recursive code
244: */
315: v_error_text VARCHAR2(2000);
316: BEGIN
317: IF p_rule_call_name IS NOT NULL
318: THEN
319: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_call_name=>'||p_rule_call_name;
320: END IF;
321: IF p_rule_number IS NOT NULL
322: THEN
323: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_number=>'||p_rule_number;
319: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_call_name=>'||p_rule_call_name;
320: END IF;
321: IF p_rule_number IS NOT NULL
322: THEN
323: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_number=>'||p_rule_number;
324: END IF;
325: IF p_person_id IS NOT NULL
326: THEN
327: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_person_id=>'||p_person_id;
323: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_number=>'||p_rule_number;
324: END IF;
325: IF p_person_id IS NOT NULL
326: THEN
327: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_person_id=>'||p_person_id;
328: END IF;
329: IF p_course_cd IS NOT NULL
330: THEN
331: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_cde=>'||p_course_cd;
327: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_person_id=>'||p_person_id;
328: END IF;
329: IF p_course_cd IS NOT NULL
330: THEN
331: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_cde=>'||p_course_cd;
332: END IF;
333: IF p_course_version IS NOT NULL
334: THEN
335: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_version=>'||p_course_version;
331: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_cde=>'||p_course_cd;
332: END IF;
333: IF p_course_version IS NOT NULL
334: THEN
335: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_version=>'||p_course_version;
336: END IF;
337: IF p_unit_cd IS NOT NULL
338: THEN
339: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_cd=>'||p_unit_cd;
335: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_course_version=>'||p_course_version;
336: END IF;
337: IF p_unit_cd IS NOT NULL
338: THEN
339: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_cd=>'||p_unit_cd;
340: END IF;
341: IF p_unit_version IS NOT NULL
342: THEN
343: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_version=>'||p_unit_version;
339: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_cd=>'||p_unit_cd;
340: END IF;
341: IF p_unit_version IS NOT NULL
342: THEN
343: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_version=>'||p_unit_version;
344: END IF;
345: IF p_cal_type IS NOT NULL
346: THEN
347: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_cal_type=>'||p_cal_type;
343: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_unit_version=>'||p_unit_version;
344: END IF;
345: IF p_cal_type IS NOT NULL
346: THEN
347: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_cal_type=>'||p_cal_type;
348: END IF;
349: IF p_ci_sequence_number IS NOT NULL
350: THEN
351: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_ci_sequence_number=>'||
347: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_cal_type=>'||p_cal_type;
348: END IF;
349: IF p_ci_sequence_number IS NOT NULL
350: THEN
351: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_ci_sequence_number=>'||
352: p_ci_sequence_number;
353: END IF;
354: IF p_param_1 IS NOT NULL
355: THEN
352: p_ci_sequence_number;
353: END IF;
354: IF p_param_1 IS NOT NULL
355: THEN
356: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_1=>'''||p_param_1||'''';
357: END IF;
358: IF p_param_2 IS NOT NULL
359: THEN
360: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_2=>'''||p_param_2||'''';
356: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_1=>'''||p_param_1||'''';
357: END IF;
358: IF p_param_2 IS NOT NULL
359: THEN
360: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_2=>'''||p_param_2||'''';
361: END IF;
362: IF p_param_3 IS NOT NULL
363: THEN
364: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_3=>'''||p_param_3||'''';
360: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_2=>'''||p_param_2||'''';
361: END IF;
362: IF p_param_3 IS NOT NULL
363: THEN
364: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_3=>'''||p_param_3||'''';
365: END IF;
366: IF p_param_4 IS NOT NULL
367: THEN
368: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_4=>'''||p_param_4||'''';
364: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_3=>'''||p_param_3||'''';
365: END IF;
366: IF p_param_4 IS NOT NULL
367: THEN
368: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_4=>'''||p_param_4||'''';
369: END IF;
370: IF p_param_5 IS NOT NULL
371: THEN
372: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_5=>'''||p_param_5||'''';
368: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_4=>'''||p_param_4||'''';
369: END IF;
370: IF p_param_5 IS NOT NULL
371: THEN
372: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_5=>'''||p_param_5||'''';
373: END IF;
374: IF p_param_6 IS NOT NULL
375: THEN
376: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_6=>'''||p_param_6||'''';
372: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_5=>'''||p_param_5||'''';
373: END IF;
374: IF p_param_6 IS NOT NULL
375: THEN
376: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_6=>'''||p_param_6||'''';
377: END IF;
378: IF p_param_7 IS NOT NULL
379: THEN
380: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_7=>'''||p_param_7||'''';
376: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_6=>'''||p_param_6||'''';
377: END IF;
378: IF p_param_7 IS NOT NULL
379: THEN
380: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_7=>'''||p_param_7||'''';
381: END IF;
382: IF p_param_8 IS NOT NULL
383: THEN
384: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_8=>'''||p_param_8||'''';
380: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_7=>'''||p_param_7||'''';
381: END IF;
382: IF p_param_8 IS NOT NULL
383: THEN
384: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_8=>'''||p_param_8||'''';
385: END IF;
386: IF p_param_9 IS NOT NULL
387: THEN
388: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_9=>'''||p_param_9||'''';
384: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_8=>'''||p_param_8||'''';
385: END IF;
386: IF p_param_9 IS NOT NULL
387: THEN
388: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_9=>'''||p_param_9||'''';
389: END IF;
390: /* more room 99/06/25
391: IF p_param_10 IS NOT NULL
392: THEN
390: /* more room 99/06/25
391: IF p_param_10 IS NOT NULL
392: THEN
393: v_error_text := v_error_text||
394: ','||Fnd_Global.Local_Chr(10)||'p_param_10=>'''||p_param_10||'''';
395: END IF;
396: IF p_param_11 IS NOT NULL
397: THEN
398: v_error_text := v_error_text||
395: END IF;
396: IF p_param_11 IS NOT NULL
397: THEN
398: v_error_text := v_error_text||
399: ','||Fnd_Global.Local_Chr(10)||'p_param_11=>'''||p_param_11||'''';
400: END IF;
401: IF p_param_12 IS NOT NULL
402: THEN
403: v_error_text := v_error_text||
400: END IF;
401: IF p_param_12 IS NOT NULL
402: THEN
403: v_error_text := v_error_text||
404: ','||Fnd_Global.Local_Chr(10)||'p_param_12=>'''||p_param_12||'''';
405: END IF;
406: IF p_param_13 IS NOT NULL
407: THEN
408: v_error_text := v_error_text||
405: END IF;
406: IF p_param_13 IS NOT NULL
407: THEN
408: v_error_text := v_error_text||
409: ','||Fnd_Global.Local_Chr(10)||'p_param_13=>'''||p_param_13||'''';
410: END IF;
411: IF p_param_14 IS NOT NULL
412: THEN
413: v_error_text := v_error_text||
410: END IF;
411: IF p_param_14 IS NOT NULL
412: THEN
413: v_error_text := v_error_text||
414: ','||Fnd_Global.Local_Chr(10)||'p_param_14=>'''||p_param_14||'''';
415: END IF;
416: IF p_param_15 IS NOT NULL
417: THEN
418: v_error_text := v_error_text||
415: END IF;
416: IF p_param_15 IS NOT NULL
417: THEN
418: v_error_text := v_error_text||
419: ','||Fnd_Global.Local_Chr(10)||'p_param_15=>'''||p_param_15||'''';
420: END IF;
421: IF p_param_16 IS NOT NULL
422: THEN
423: v_error_text := v_error_text||
420: END IF;
421: IF p_param_16 IS NOT NULL
422: THEN
423: v_error_text := v_error_text||
424: ','||Fnd_Global.Local_Chr(10)||'p_param_16=>'''||p_param_16||'''';
425: END IF;
426: IF p_param_17 IS NOT NULL
427: THEN
428: v_error_text := v_error_text||
425: END IF;
426: IF p_param_17 IS NOT NULL
427: THEN
428: v_error_text := v_error_text||
429: ','||Fnd_Global.Local_Chr(10)||'p_param_17=>'''||p_param_17||'''';
430: END IF;
431: IF p_param_18 IS NOT NULL
432: THEN
433: v_error_text := v_error_text||
430: END IF;
431: IF p_param_18 IS NOT NULL
432: THEN
433: v_error_text := v_error_text||
434: ','||Fnd_Global.Local_Chr(10)||'p_param_18=>'''||p_param_18||'''';
435: END IF;
436: IF p_param_19 IS NOT NULL
437: THEN
438: v_error_text := v_error_text||
435: END IF;
436: IF p_param_19 IS NOT NULL
437: THEN
438: v_error_text := v_error_text||
439: ','||Fnd_Global.Local_Chr(10)||'p_param_19=>'''||p_param_19||'''';
440: END IF;
441: /* need room hrt
442: IF p_param_20 IS NOT NULL
443: THEN
441: /* need room hrt
442: IF p_param_20 IS NOT NULL
443: THEN
444: v_error_text := v_error_text||
445: ','||Fnd_Global.Local_Chr(10)||'p_param_20=>'''||p_param_20||'''';
446: END IF;
447: IF p_param_21 IS NOT NULL
448: THEN
449: v_error_text := v_error_text||
446: END IF;
447: IF p_param_21 IS NOT NULL
448: THEN
449: v_error_text := v_error_text||
450: ','||Fnd_Global.Local_Chr(10)||'p_param_21=>'''||p_param_21||'''';
451: END IF;
452: IF p_param_22 IS NOT NULL
453: THEN
454: v_error_text := v_error_text||
451: END IF;
452: IF p_param_22 IS NOT NULL
453: THEN
454: v_error_text := v_error_text||
455: ','||Fnd_Global.Local_Chr(10)||'p_param_22=>'''||p_param_22||'''';
456: END IF;
457: IF p_param_23 IS NOT NULL
458: THEN
459: v_error_text := v_error_text||
456: END IF;
457: IF p_param_23 IS NOT NULL
458: THEN
459: v_error_text := v_error_text||
460: ','||Fnd_Global.Local_Chr(10)||'p_param_23=>'''||p_param_23||'''';
461: END IF;
462: IF p_param_24 IS NOT NULL
463: THEN
464: v_error_text := v_error_text||
461: END IF;
462: IF p_param_24 IS NOT NULL
463: THEN
464: v_error_text := v_error_text||
465: ','||Fnd_Global.Local_Chr(10)||'p_param_24=>'''||p_param_24||'''';
466: END IF;
467: IF p_param_25 IS NOT NULL
468: THEN
469: v_error_text := v_error_text||
466: END IF;
467: IF p_param_25 IS NOT NULL
468: THEN
469: v_error_text := v_error_text||
470: ','||Fnd_Global.Local_Chr(10)||'p_param_25=>'''||p_param_25||'''';
471: END IF;
472: IF p_param_26 IS NOT NULL
473: THEN
474: v_error_text := v_error_text||
471: END IF;
472: IF p_param_26 IS NOT NULL
473: THEN
474: v_error_text := v_error_text||
475: ','||Fnd_Global.Local_Chr(10)||'p_param_26=>'''||p_param_26||'''';
476: END IF;
477: IF p_param_27 IS NOT NULL
478: THEN
479: v_error_text := v_error_text||
476: END IF;
477: IF p_param_27 IS NOT NULL
478: THEN
479: v_error_text := v_error_text||
480: ','||Fnd_Global.Local_Chr(10)||'p_param_27=>'''||p_param_27||'''';
481: END IF;
482: IF p_param_28 IS NOT NULL
483: THEN
484: v_error_text := v_error_text||
481: END IF;
482: IF p_param_28 IS NOT NULL
483: THEN
484: v_error_text := v_error_text||
485: ','||Fnd_Global.Local_Chr(10)||'p_param_28=>'''||p_param_28||'''';
486: END IF;
487: IF p_param_29 IS NOT NULL
488: THEN
489: v_error_text := v_error_text||
486: END IF;
487: IF p_param_29 IS NOT NULL
488: THEN
489: v_error_text := v_error_text||
490: ','||Fnd_Global.Local_Chr(10)||'p_param_29=>'''||p_param_29||'''';
491: END IF;
492: IF p_param_30 IS NOT NULL
493: THEN
494: v_error_text := v_error_text||
491: END IF;
492: IF p_param_30 IS NOT NULL
493: THEN
494: v_error_text := v_error_text||
495: ','||Fnd_Global.Local_Chr(10)||'p_param_30=>'''||p_param_30||'''';
496: END IF;
497: IF p_param_31 IS NOT NULL
498: THEN
499: v_error_text := v_error_text||
496: END IF;
497: IF p_param_31 IS NOT NULL
498: THEN
499: v_error_text := v_error_text||
500: ','||Fnd_Global.Local_Chr(10)||'p_param_31=>'''||p_param_31||'''';
501: END IF;
502: IF p_param_32 IS NOT NULL
503: THEN
504: v_error_text := v_error_text||
501: END IF;
502: IF p_param_32 IS NOT NULL
503: THEN
504: v_error_text := v_error_text||
505: ','||Fnd_Global.Local_Chr(10)||'p_param_32=>'''||p_param_32||'''';
506: END IF;
507: IF p_param_33 IS NOT NULL
508: THEN
509: v_error_text := v_error_text||
506: END IF;
507: IF p_param_33 IS NOT NULL
508: THEN
509: v_error_text := v_error_text||
510: ','||Fnd_Global.Local_Chr(10)||'p_param_33=>'''||p_param_33||'''';
511: END IF;
512: IF p_param_34 IS NOT NULL
513: THEN
514: v_error_text := v_error_text||
511: END IF;
512: IF p_param_34 IS NOT NULL
513: THEN
514: v_error_text := v_error_text||
515: ','||Fnd_Global.Local_Chr(10)||'p_param_34=>'''||p_param_34||'''';
516: END IF;
517: IF p_param_35 IS NOT NULL
518: THEN
519: v_error_text := v_error_text||
516: END IF;
517: IF p_param_35 IS NOT NULL
518: THEN
519: v_error_text := v_error_text||
520: ','||Fnd_Global.Local_Chr(10)||'p_param_35=>'''||p_param_35||'''';
521: END IF;
522: IF p_param_36 IS NOT NULL
523: THEN
524: v_error_text := v_error_text||
521: END IF;
522: IF p_param_36 IS NOT NULL
523: THEN
524: v_error_text := v_error_text||
525: ','||Fnd_Global.Local_Chr(10)||'p_param_36=>'''||p_param_36||'''';
526: END IF;
527: IF p_param_37 IS NOT NULL
528: THEN
529: v_error_text := v_error_text||
526: END IF;
527: IF p_param_37 IS NOT NULL
528: THEN
529: v_error_text := v_error_text||
530: ','||Fnd_Global.Local_Chr(10)||'p_param_37=>'''||p_param_37||'''';
531: END IF;
532: IF p_param_38 IS NOT NULL
533: THEN
534: v_error_text := v_error_text||
531: END IF;
532: IF p_param_38 IS NOT NULL
533: THEN
534: v_error_text := v_error_text||
535: ','||Fnd_Global.Local_Chr(10)||'p_param_38=>'''||p_param_38||'''';
536: END IF;
537: IF p_param_39 IS NOT NULL
538: THEN
539: v_error_text := v_error_text||
536: END IF;
537: IF p_param_39 IS NOT NULL
538: THEN
539: v_error_text := v_error_text||
540: ','||Fnd_Global.Local_Chr(10)||'p_param_39=>'''||p_param_39||'''';
541: END IF;
542: IF p_param_40 IS NOT NULL
543: THEN
544: v_error_text := v_error_text||
541: END IF;
542: IF p_param_40 IS NOT NULL
543: THEN
544: v_error_text := v_error_text||
545: ','||Fnd_Global.Local_Chr(10)||'p_param_40=>'''||p_param_40||'''';
546: END IF;
547: IF p_param_41 IS NOT NULL
548: THEN
549: v_error_text := v_error_text||
546: END IF;
547: IF p_param_41 IS NOT NULL
548: THEN
549: v_error_text := v_error_text||
550: ','||Fnd_Global.Local_Chr(10)||'p_param_41=>'''||p_param_41||'''';
551: END IF;
552: IF p_param_42 IS NOT NULL
553: THEN
554: v_error_text := v_error_text||
551: END IF;
552: IF p_param_42 IS NOT NULL
553: THEN
554: v_error_text := v_error_text||
555: ','||Fnd_Global.Local_Chr(10)||'p_param_42=>'''||p_param_42||'''';
556: END IF;
557: IF p_param_43 IS NOT NULL
558: THEN
559: v_error_text := v_error_text||
556: END IF;
557: IF p_param_43 IS NOT NULL
558: THEN
559: v_error_text := v_error_text||
560: ','||Fnd_Global.Local_Chr(10)||'p_param_43=>'''||p_param_43||'''';
561: END IF;
562: IF p_param_44 IS NOT NULL
563: THEN
564: v_error_text := v_error_text||
561: END IF;
562: IF p_param_44 IS NOT NULL
563: THEN
564: v_error_text := v_error_text||
565: ','||Fnd_Global.Local_Chr(10)||'p_param_44=>'''||p_param_44||'''';
566: END IF;
567: IF p_param_45 IS NOT NULL
568: THEN
569: v_error_text := v_error_text||
566: END IF;
567: IF p_param_45 IS NOT NULL
568: THEN
569: v_error_text := v_error_text||
570: ','||Fnd_Global.Local_Chr(10)||'p_param_45=>'''||p_param_45||'''';
571: END IF;
572: IF p_param_46 IS NOT NULL
573: THEN
574: v_error_text := v_error_text||
571: END IF;
572: IF p_param_46 IS NOT NULL
573: THEN
574: v_error_text := v_error_text||
575: ','||Fnd_Global.Local_Chr(10)||'p_param_46=>'''||p_param_46||'''';
576: END IF;
577: IF p_param_47 IS NOT NULL
578: THEN
579: v_error_text := v_error_text||
576: END IF;
577: IF p_param_47 IS NOT NULL
578: THEN
579: v_error_text := v_error_text||
580: ','||Fnd_Global.Local_Chr(10)||'p_param_47=>'''||p_param_47||'''';
581: END IF;
582: IF p_param_48 IS NOT NULL
583: THEN
584: v_error_text := v_error_text||
581: END IF;
582: IF p_param_48 IS NOT NULL
583: THEN
584: v_error_text := v_error_text||
585: ','||Fnd_Global.Local_Chr(10)||'p_param_48=>'''||p_param_48||'''';
586: END IF;
587: IF p_param_49 IS NOT NULL
588: THEN
589: v_error_text := v_error_text||
586: END IF;
587: IF p_param_49 IS NOT NULL
588: THEN
589: v_error_text := v_error_text||
590: ','||Fnd_Global.Local_Chr(10)||'p_param_49=>'''||p_param_49||'''';
591: END IF;
592: IF p_param_50 IS NOT NULL
593: THEN
594: v_error_text := v_error_text||
591: END IF;
592: IF p_param_50 IS NOT NULL
593: THEN
594: v_error_text := v_error_text||
595: ','||Fnd_Global.Local_Chr(10)||'p_param_50=>'''||p_param_50||'''';
596: END IF;
597: IF p_param_51 IS NOT NULL
598: THEN
599: v_error_text := v_error_text||
596: END IF;
597: IF p_param_51 IS NOT NULL
598: THEN
599: v_error_text := v_error_text||
600: ','||Fnd_Global.Local_Chr(10)||'p_param_51=>'''||p_param_51||'''';
601: END IF;
602: IF p_param_52 IS NOT NULL
603: THEN
604: v_error_text := v_error_text||
601: END IF;
602: IF p_param_52 IS NOT NULL
603: THEN
604: v_error_text := v_error_text||
605: ','||Fnd_Global.Local_Chr(10)||'p_param_52=>'''||p_param_52||'''';
606: END IF;
607: IF p_param_53 IS NOT NULL
608: THEN
609: v_error_text := v_error_text||
606: END IF;
607: IF p_param_53 IS NOT NULL
608: THEN
609: v_error_text := v_error_text||
610: ','||Fnd_Global.Local_Chr(10)||'p_param_53=>'''||p_param_53||'''';
611: END IF;
612: IF p_param_54 IS NOT NULL
613: THEN
614: v_error_text := v_error_text||
611: END IF;
612: IF p_param_54 IS NOT NULL
613: THEN
614: v_error_text := v_error_text||
615: ','||Fnd_Global.Local_Chr(10)||'p_param_54=>'''||p_param_54||'''';
616: END IF;
617: IF p_param_55 IS NOT NULL
618: THEN
619: v_error_text := v_error_text||
616: END IF;
617: IF p_param_55 IS NOT NULL
618: THEN
619: v_error_text := v_error_text||
620: ','||Fnd_Global.Local_Chr(10)||'p_param_55=>'''||p_param_55||'''';
621: END IF;
622: IF p_param_56 IS NOT NULL
623: THEN
624: v_error_text := v_error_text||
621: END IF;
622: IF p_param_56 IS NOT NULL
623: THEN
624: v_error_text := v_error_text||
625: ','||Fnd_Global.Local_Chr(10)||'p_param_56=>'''||p_param_56||'''';
626: END IF;
627: IF p_param_57 IS NOT NULL
628: THEN
629: v_error_text := v_error_text||
626: END IF;
627: IF p_param_57 IS NOT NULL
628: THEN
629: v_error_text := v_error_text||
630: ','||Fnd_Global.Local_Chr(10)||'p_param_57=>'''||p_param_57||'''';
631: END IF;
632: IF p_param_58 IS NOT NULL
633: THEN
634: v_error_text := v_error_text||
631: END IF;
632: IF p_param_58 IS NOT NULL
633: THEN
634: v_error_text := v_error_text||
635: ','||Fnd_Global.Local_Chr(10)||'p_param_58=>'''||p_param_58||'''';
636: END IF;
637: IF p_param_59 IS NOT NULL
638: THEN
639: v_error_text := v_error_text||
636: END IF;
637: IF p_param_59 IS NOT NULL
638: THEN
639: v_error_text := v_error_text||
640: ','||Fnd_Global.Local_Chr(10)||'p_param_59=>'''||p_param_59||'''';
641: END IF;
642: */
643: EXCEPTION
644: WHEN OTHERS THEN
1784: IF v_pop_message IS NOT NULL
1785: THEN
1786: IF LENGTH(v_message) > 0
1787: THEN
1788: v_message := v_message||Fnd_Global.Local_Chr(10);
1789: END IF;
1790: v_message := v_message||v_pop_message;
1791: END IF;
1792: END LOOP;
3678: THEN
3679: null;
3680: ELSE
3681: log_error('select_set',
3682: 'Invalid condition rule return ('||v_result||')'||Fnd_Global.Local_Chr(10)||
3683: 'rule='||p_where_rule);
3684: END IF;
3685: /*
3686: next member
3761: THEN
3762: null;
3763: ELSE
3764: log_error('select_N_set',
3765: 'Invalid condition rule return ('||v_result||')'||Fnd_Global.Local_Chr(10)||
3766: 'rule='||p_order_by_rule);
3767: END IF;
3768: /*
3769: next member
6611: THEN
6612: log_error('turing',
6613: 'Unbalanced stack:Start='||
6614: v_start_stack||' Current='||
6615: gv_stack_index||Fnd_Global.Local_Chr(10)||
6616: 'rule='||p_rule_number);
6617: END IF;
6618: do_message(p_rule_number,v_result,p_tds);
6619: gv_turing_level := gv_turing_level - 1;