DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on FND_GLOBAL

Line 240: cst_space CONSTANT VARCHAR2(1) := Fnd_Global.Local_Chr(31);

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: */

Line 319: v_error_text := v_error_text||Fnd_Global.Local_Chr(10)||'p_rule_call_name=>'||p_rule_call_name;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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=>'||

Line 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

Line 356: v_error_text := v_error_text||','||Fnd_Global.Local_Chr(10)||'p_param_1=>'''||p_param_1||'''';

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||'''';

Line 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||'''';

Line 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||'''';

Line 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||'''';

Line 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||'''';

Line 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||'''';

Line 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||'''';

Line 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||'''';

Line 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

Line 394: ','||Fnd_Global.Local_Chr(10)||'p_param_10=>'''||p_param_10||'''';

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||

Line 399: ','||Fnd_Global.Local_Chr(10)||'p_param_11=>'''||p_param_11||'''';

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||

Line 404: ','||Fnd_Global.Local_Chr(10)||'p_param_12=>'''||p_param_12||'''';

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||

Line 409: ','||Fnd_Global.Local_Chr(10)||'p_param_13=>'''||p_param_13||'''';

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||

Line 414: ','||Fnd_Global.Local_Chr(10)||'p_param_14=>'''||p_param_14||'''';

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||

Line 419: ','||Fnd_Global.Local_Chr(10)||'p_param_15=>'''||p_param_15||'''';

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||

Line 424: ','||Fnd_Global.Local_Chr(10)||'p_param_16=>'''||p_param_16||'''';

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||

Line 429: ','||Fnd_Global.Local_Chr(10)||'p_param_17=>'''||p_param_17||'''';

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||

Line 434: ','||Fnd_Global.Local_Chr(10)||'p_param_18=>'''||p_param_18||'''';

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||

Line 439: ','||Fnd_Global.Local_Chr(10)||'p_param_19=>'''||p_param_19||'''';

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

Line 445: ','||Fnd_Global.Local_Chr(10)||'p_param_20=>'''||p_param_20||'''';

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||

Line 450: ','||Fnd_Global.Local_Chr(10)||'p_param_21=>'''||p_param_21||'''';

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||

Line 455: ','||Fnd_Global.Local_Chr(10)||'p_param_22=>'''||p_param_22||'''';

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||

Line 460: ','||Fnd_Global.Local_Chr(10)||'p_param_23=>'''||p_param_23||'''';

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||

Line 465: ','||Fnd_Global.Local_Chr(10)||'p_param_24=>'''||p_param_24||'''';

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||

Line 470: ','||Fnd_Global.Local_Chr(10)||'p_param_25=>'''||p_param_25||'''';

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||

Line 475: ','||Fnd_Global.Local_Chr(10)||'p_param_26=>'''||p_param_26||'''';

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||

Line 480: ','||Fnd_Global.Local_Chr(10)||'p_param_27=>'''||p_param_27||'''';

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||

Line 485: ','||Fnd_Global.Local_Chr(10)||'p_param_28=>'''||p_param_28||'''';

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||

Line 490: ','||Fnd_Global.Local_Chr(10)||'p_param_29=>'''||p_param_29||'''';

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||

Line 495: ','||Fnd_Global.Local_Chr(10)||'p_param_30=>'''||p_param_30||'''';

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||

Line 500: ','||Fnd_Global.Local_Chr(10)||'p_param_31=>'''||p_param_31||'''';

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||

Line 505: ','||Fnd_Global.Local_Chr(10)||'p_param_32=>'''||p_param_32||'''';

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||

Line 510: ','||Fnd_Global.Local_Chr(10)||'p_param_33=>'''||p_param_33||'''';

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||

Line 515: ','||Fnd_Global.Local_Chr(10)||'p_param_34=>'''||p_param_34||'''';

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||

Line 520: ','||Fnd_Global.Local_Chr(10)||'p_param_35=>'''||p_param_35||'''';

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||

Line 525: ','||Fnd_Global.Local_Chr(10)||'p_param_36=>'''||p_param_36||'''';

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||

Line 530: ','||Fnd_Global.Local_Chr(10)||'p_param_37=>'''||p_param_37||'''';

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||

Line 535: ','||Fnd_Global.Local_Chr(10)||'p_param_38=>'''||p_param_38||'''';

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||

Line 540: ','||Fnd_Global.Local_Chr(10)||'p_param_39=>'''||p_param_39||'''';

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||

Line 545: ','||Fnd_Global.Local_Chr(10)||'p_param_40=>'''||p_param_40||'''';

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||

Line 550: ','||Fnd_Global.Local_Chr(10)||'p_param_41=>'''||p_param_41||'''';

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||

Line 555: ','||Fnd_Global.Local_Chr(10)||'p_param_42=>'''||p_param_42||'''';

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||

Line 560: ','||Fnd_Global.Local_Chr(10)||'p_param_43=>'''||p_param_43||'''';

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||

Line 565: ','||Fnd_Global.Local_Chr(10)||'p_param_44=>'''||p_param_44||'''';

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||

Line 570: ','||Fnd_Global.Local_Chr(10)||'p_param_45=>'''||p_param_45||'''';

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||

Line 575: ','||Fnd_Global.Local_Chr(10)||'p_param_46=>'''||p_param_46||'''';

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||

Line 580: ','||Fnd_Global.Local_Chr(10)||'p_param_47=>'''||p_param_47||'''';

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||

Line 585: ','||Fnd_Global.Local_Chr(10)||'p_param_48=>'''||p_param_48||'''';

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||

Line 590: ','||Fnd_Global.Local_Chr(10)||'p_param_49=>'''||p_param_49||'''';

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||

Line 595: ','||Fnd_Global.Local_Chr(10)||'p_param_50=>'''||p_param_50||'''';

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||

Line 600: ','||Fnd_Global.Local_Chr(10)||'p_param_51=>'''||p_param_51||'''';

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||

Line 605: ','||Fnd_Global.Local_Chr(10)||'p_param_52=>'''||p_param_52||'''';

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||

Line 610: ','||Fnd_Global.Local_Chr(10)||'p_param_53=>'''||p_param_53||'''';

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||

Line 615: ','||Fnd_Global.Local_Chr(10)||'p_param_54=>'''||p_param_54||'''';

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||

Line 620: ','||Fnd_Global.Local_Chr(10)||'p_param_55=>'''||p_param_55||'''';

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||

Line 625: ','||Fnd_Global.Local_Chr(10)||'p_param_56=>'''||p_param_56||'''';

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||

Line 630: ','||Fnd_Global.Local_Chr(10)||'p_param_57=>'''||p_param_57||'''';

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||

Line 635: ','||Fnd_Global.Local_Chr(10)||'p_param_58=>'''||p_param_58||'''';

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||

Line 640: ','||Fnd_Global.Local_Chr(10)||'p_param_59=>'''||p_param_59||'''';

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

Line 1788: v_message := v_message||Fnd_Global.Local_Chr(10);

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;

Line 3682: 'Invalid condition rule return ('||v_result||')'||Fnd_Global.Local_Chr(10)||

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

Line 3765: 'Invalid condition rule return ('||v_result||')'||Fnd_Global.Local_Chr(10)||

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

Line 6615: gv_stack_index||Fnd_Global.Local_Chr(10)||

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;