eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_ITEMCAT_VAL_TO_ID dependencies on EGO_GLOBALS

Line 64: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;

60: BEGIN
61:
62: SELECT item_catalog_group_id INTO l_ccid
63: FROM mtl_Item_Catalog_Groups_b WHERE
64: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
65:
66: Return TRUE;
67:
68: EXCEPTION WHEN OTHERS

Line 248: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

244: BEGIN
245: nsegs := fnd_flex_ext.breakup_segments
246: ( delimiter => l_delimiter
247: , concatenated_segs =>
248: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
249: , segments => l_segment_values
250: );
251: kff := fnd_flex_key_api.find_flexfield('INV','MICG');
252: str := fnd_flex_key_api.find_structure(kff, 101);

Line 357: IF ( (EGO_Globals.G_Catalog_Group_Rec.Segment1 IS NOT NULL AND

353:
354: FUNCTION check_segments_populated RETURN BOOLEAN
355: IS
356: BEGIN
357: IF ( (EGO_Globals.G_Catalog_Group_Rec.Segment1 IS NOT NULL AND
358: EGO_Globals.G_Catalog_Group_Rec.Segment1 <> FND_API.G_MISS_CHAR
359: ) OR
360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR

Line 358: EGO_Globals.G_Catalog_Group_Rec.Segment1 <> FND_API.G_MISS_CHAR

354: FUNCTION check_segments_populated RETURN BOOLEAN
355: IS
356: BEGIN
357: IF ( (EGO_Globals.G_Catalog_Group_Rec.Segment1 IS NOT NULL AND
358: EGO_Globals.G_Catalog_Group_Rec.Segment1 <> FND_API.G_MISS_CHAR
359: ) OR
360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR
362: ) OR

Line 360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND

356: BEGIN
357: IF ( (EGO_Globals.G_Catalog_Group_Rec.Segment1 IS NOT NULL AND
358: EGO_Globals.G_Catalog_Group_Rec.Segment1 <> FND_API.G_MISS_CHAR
359: ) OR
360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR
362: ) OR
363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR

Line 361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR

357: IF ( (EGO_Globals.G_Catalog_Group_Rec.Segment1 IS NOT NULL AND
358: EGO_Globals.G_Catalog_Group_Rec.Segment1 <> FND_API.G_MISS_CHAR
359: ) OR
360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR
362: ) OR
363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR
365: ) OR

Line 363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND

359: ) OR
360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR
362: ) OR
363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR
365: ) OR
366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR

Line 364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR

360: (EGO_Globals.G_Catalog_Group_Rec.Segment2 IS NOT NULL AND
361: EGO_Globals.G_Catalog_Group_Rec.Segment2 <> FND_API.G_MISS_CHAR
362: ) OR
363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR
365: ) OR
366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR
368: ) OR

Line 366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND

362: ) OR
363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR
365: ) OR
366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR
368: ) OR
369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR

Line 367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR

363: (EGO_Globals.G_Catalog_Group_Rec.Segment3 IS NOT NULL AND
364: EGO_Globals.G_Catalog_Group_Rec.Segment3 <> FND_API.G_MISS_CHAR
365: ) OR
366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR
368: ) OR
369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR
371: ) OR

Line 369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND

365: ) OR
366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR
368: ) OR
369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR
371: ) OR
372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR

Line 370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR

366: (EGO_Globals.G_Catalog_Group_Rec.Segment4 IS NOT NULL AND
367: EGO_Globals.G_Catalog_Group_Rec.Segment4 <> FND_API.G_MISS_CHAR
368: ) OR
369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR
371: ) OR
372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR
374: ) OR

Line 372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND

368: ) OR
369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR
371: ) OR
372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR
374: ) OR
375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR

Line 373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR

369: (EGO_Globals.G_Catalog_Group_Rec.Segment5 IS NOT NULL AND
370: EGO_Globals.G_Catalog_Group_Rec.Segment5 <> FND_API.G_MISS_CHAR
371: ) OR
372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR
374: ) OR
375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR
377: ) OR

Line 375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND

371: ) OR
372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR
374: ) OR
375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR
377: ) OR
378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR

Line 376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR

372: (EGO_Globals.G_Catalog_Group_Rec.Segment6 IS NOT NULL AND
373: EGO_Globals.G_Catalog_Group_Rec.Segment6 <> FND_API.G_MISS_CHAR
374: ) OR
375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR
377: ) OR
378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR
380: ) OR

Line 378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND

374: ) OR
375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR
377: ) OR
378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR
380: ) OR
381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR

Line 379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR

375: (EGO_Globals.G_Catalog_Group_Rec.Segment7 IS NOT NULL AND
376: EGO_Globals.G_Catalog_Group_Rec.Segment7 <> FND_API.G_MISS_CHAR
377: ) OR
378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR
380: ) OR
381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR
383: ) OR

Line 381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND

377: ) OR
378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR
380: ) OR
381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR
383: ) OR
384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR

Line 382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR

378: (EGO_Globals.G_Catalog_Group_Rec.Segment8 IS NOT NULL AND
379: EGO_Globals.G_Catalog_Group_Rec.Segment8 <> FND_API.G_MISS_CHAR
380: ) OR
381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR
383: ) OR
384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR
386: ) OR

Line 384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND

380: ) OR
381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR
383: ) OR
384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR
386: ) OR
387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR

Line 385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR

381: (EGO_Globals.G_Catalog_Group_Rec.Segment9 IS NOT NULL AND
382: EGO_Globals.G_Catalog_Group_Rec.Segment9 <> FND_API.G_MISS_CHAR
383: ) OR
384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR
386: ) OR
387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR
389: ) OR

Line 387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND

383: ) OR
384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR
386: ) OR
387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR
389: ) OR
390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR

Line 388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR

384: (EGO_Globals.G_Catalog_Group_Rec.Segment10 IS NOT NULL AND
385: EGO_Globals.G_Catalog_Group_Rec.Segment10 <> FND_API.G_MISS_CHAR
386: ) OR
387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR
389: ) OR
390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR
392: ) OR

Line 390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND

386: ) OR
387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR
389: ) OR
390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR
392: ) OR
393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR

Line 391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR

387: (EGO_Globals.G_Catalog_Group_Rec.Segment11 IS NOT NULL AND
388: EGO_Globals.G_Catalog_Group_Rec.Segment12 <> FND_API.G_MISS_CHAR
389: ) OR
390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR
392: ) OR
393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR
395: ) OR

Line 393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND

389: ) OR
390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR
392: ) OR
393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR
395: ) OR
396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR

Line 394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR

390: (EGO_Globals.G_Catalog_Group_Rec.Segment13 IS NOT NULL AND
391: EGO_Globals.G_Catalog_Group_Rec.Segment13 <> FND_API.G_MISS_CHAR
392: ) OR
393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR
395: ) OR
396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR
398: ) OR

Line 396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND

392: ) OR
393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR
395: ) OR
396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR
398: ) OR
399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR

Line 397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR

393: (EGO_Globals.G_Catalog_Group_Rec.Segment14 IS NOT NULL AND
394: EGO_Globals.G_Catalog_Group_Rec.Segment14 <> FND_API.G_MISS_CHAR
395: ) OR
396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR
398: ) OR
399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR
401: ) OR

Line 399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND

395: ) OR
396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR
398: ) OR
399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR
401: ) OR
402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR

Line 400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR

396: (EGO_Globals.G_Catalog_Group_Rec.Segment15 IS NOT NULL AND
397: EGO_Globals.G_Catalog_Group_Rec.Segment15 <> FND_API.G_MISS_CHAR
398: ) OR
399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR
401: ) OR
402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR
404: ) OR

Line 402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND

398: ) OR
399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR
401: ) OR
402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR
404: ) OR
405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR

Line 403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR

399: (EGO_Globals.G_Catalog_Group_Rec.Segment16 IS NOT NULL AND
400: EGO_Globals.G_Catalog_Group_Rec.Segment16 <> FND_API.G_MISS_CHAR
401: ) OR
402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR
404: ) OR
405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR
407: ) OR

Line 405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND

401: ) OR
402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR
404: ) OR
405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR
407: ) OR
408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR

Line 406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR

402: (EGO_Globals.G_Catalog_Group_Rec.Segment17 IS NOT NULL AND
403: EGO_Globals.G_Catalog_Group_Rec.Segment17 <> FND_API.G_MISS_CHAR
404: ) OR
405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR
407: ) OR
408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR
410: ) OR

Line 408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND

404: ) OR
405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR
407: ) OR
408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR
410: ) OR
411: (EGO_Globals.G_Catalog_Group_Rec.Segment20 IS NOT NULL AND
412: EGO_Globals.G_Catalog_Group_Rec.Segment20 <> FND_API.G_MISS_CHAR

Line 409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR

405: (EGO_Globals.G_Catalog_Group_Rec.Segment18 IS NOT NULL AND
406: EGO_Globals.G_Catalog_Group_Rec.Segment18 <> FND_API.G_MISS_CHAR
407: ) OR
408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR
410: ) OR
411: (EGO_Globals.G_Catalog_Group_Rec.Segment20 IS NOT NULL AND
412: EGO_Globals.G_Catalog_Group_Rec.Segment20 <> FND_API.G_MISS_CHAR
413: )

Line 411: (EGO_Globals.G_Catalog_Group_Rec.Segment20 IS NOT NULL AND

407: ) OR
408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR
410: ) OR
411: (EGO_Globals.G_Catalog_Group_Rec.Segment20 IS NOT NULL AND
412: EGO_Globals.G_Catalog_Group_Rec.Segment20 <> FND_API.G_MISS_CHAR
413: )
414: )
415: THEN

Line 412: EGO_Globals.G_Catalog_Group_Rec.Segment20 <> FND_API.G_MISS_CHAR

408: (EGO_Globals.G_Catalog_Group_Rec.Segment19 IS NOT NULL AND
409: EGO_Globals.G_Catalog_Group_Rec.Segment19<> FND_API.G_MISS_CHAR
410: ) OR
411: (EGO_Globals.G_Catalog_Group_Rec.Segment20 IS NOT NULL AND
412: EGO_Globals.G_Catalog_Group_Rec.Segment20 <> FND_API.G_MISS_CHAR
413: )
414: )
415: THEN
416: return true;

Line 458: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR

454: -- would be validated and segments would be disregarded.
455: -- Else segments will be validated.
456: --
457:
458: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
459: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
460: ) AND
461: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
462: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR

Line 459: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

455: -- Else segments will be validated.
456: --
457:
458: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
459: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
460: ) AND
461: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
462: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
463: ) AND Check_Segments_Populated

Line 461: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR

457:
458: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
459: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
460: ) AND
461: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
462: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
463: ) AND Check_Segments_Populated
464: THEN
465: is_passed := TRUE;

Line 462: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR

458: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
459: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
460: ) AND
461: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
462: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
463: ) AND Check_Segments_Populated
464: THEN
465: is_passed := TRUE;
466:

Line 467: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

463: ) AND Check_Segments_Populated
464: THEN
465: is_passed := TRUE;
466:
467: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=
468: concatenate_segments( p_appl_short_name => 'INV'
469: , p_key_flex_code => 'MICG'
470: , p_structure_number => 101
471: );

Line 472: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL

468: concatenate_segments( p_appl_short_name => 'INV'
469: , p_key_flex_code => 'MICG'
470: , p_structure_number => 101
471: );
472: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL
473: THEN
474: -- dbms_output.put_line('concat group name is NULL ' );
475:
476: Error_Handler.Add_Error_Token

Line 488: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

484: -- Get the corresponding Catalog group id
485: --
486: check_status :=
487: Get_Catalog_Group_Id( p_catalog_group_name =>
488: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
489: , p_operation => 'FIND_COMBINATION'
490: );
491: -- dbms_output.put_line('ccid after FIND_COMBINATION . . . ' || check_status );
492:

Line 497: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;

493: IF (check_status IS NOT null)
494: THEN
495: -- if not null then the returned value is the ccid
496:
497: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;
498:
499: /* It is an error if the CCID exists
500: when the transaction type is CREATE */
501:

Line 502: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =

498:
499: /* It is an error if the CCID exists
500: when the transaction type is CREATE */
501:
502: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
503: EGO_Globals.G_OPR_CREATE
504: THEN
505: Error_Handler.Add_Error_Token
506: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 503: EGO_Globals.G_OPR_CREATE

499: /* It is an error if the CCID exists
500: when the transaction type is CREATE */
501:
502: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
503: EGO_Globals.G_OPR_CREATE
504: THEN
505: Error_Handler.Add_Error_Token
506: ( x_mesg_token_Tbl => l_mesg_token_tbl
507: , p_application_id => 'EGO'

Line 519: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN

515:
516: /* It is an error if the CCID does not exist
517: when the transaction type is DELETE or UPDATE */
518:
519: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
520: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
521: THEN
522: Error_Handler.Add_Error_Token
523: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 520: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)

516: /* It is an error if the CCID does not exist
517: when the transaction type is DELETE or UPDATE */
518:
519: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
520: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
521: THEN
522: Error_Handler.Add_Error_Token
523: ( x_mesg_token_Tbl => l_mesg_token_tbl
524: , p_application_id => 'EGO'

Line 537: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

533: -- dbms_output.put_line('CHECK_SEGMENTS from here . . .');
534:
535: check_status :=
536: Get_Catalog_Group_Id( p_catalog_group_name =>
537: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
538: , p_operation => 'CHECK_SEGMENTS'
539: );
540:
541: -- if segments are valid then proceed

Line 545: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

541: -- if segments are valid then proceed
542:
543: IF (check_status = 1)
544: THEN
545: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
546: Generate_Catalog_Group_Id;
547:
548: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
549: ELSE

Line 548: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

544: THEN
545: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
546: Generate_Catalog_Group_Id;
547:
548: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
549: ELSE
550: Error_Handler.Add_Error_Token
551: ( x_mesg_token_Tbl => l_mesg_token_tbl
552: , p_application_id => 'EGO'

Line 563: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND

559: END IF;
560: --
561: -- Convert Catalog_Group_Id into name
562: --
563: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND
564: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM)
565: THEN
566:
567: is_passed := TRUE;

Line 564: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM)

560: --
561: -- Convert Catalog_Group_Id into name
562: --
563: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND
564: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM)
565: THEN
566:
567: is_passed := TRUE;
568:

Line 572: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = 'SYNC'

568:
569: -- If the user has passed catalog_group_id with the transaction_type as 'SYNC'
570: -- then we need to derive the intended transaction_type to proceed from here
571:
572: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = 'SYNC'
573: THEN
574: IF Check_Catalog_CCID THEN
575: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_UPDATE;
576: ELSE

Line 575: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_UPDATE;

571:
572: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = 'SYNC'
573: THEN
574: IF Check_Catalog_CCID THEN
575: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_UPDATE;
576: ELSE
577: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_CREATE;
578: END IF;
579: END IF;

Line 577: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_CREATE;

573: THEN
574: IF Check_Catalog_CCID THEN
575: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_UPDATE;
576: ELSE
577: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_CREATE;
578: END IF;
579: END IF;
580:
581: -- dbms_output.put_line('Getting Group Name from ID ... ');

Line 585: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

581: -- dbms_output.put_line('Getting Group Name from ID ... ');
582:
583: l_Catalog_Group_Name :=
584: Get_Catalog_Group_Name(p_catalog_group_id =>
585: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
586: );
587:
588: /* It is an error if the group name exists
589: when the transaction type is CREATE */

Line 591: IF l_Catalog_Group_Name IS NOT NULL AND EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =

587:
588: /* It is an error if the group name exists
589: when the transaction type is CREATE */
590:
591: IF l_Catalog_Group_Name IS NOT NULL AND EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
592: EGO_Globals.G_OPR_CREATE
593: THEN
594: Error_Handler.Add_Error_Token
595: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 592: EGO_Globals.G_OPR_CREATE

588: /* It is an error if the group name exists
589: when the transaction type is CREATE */
590:
591: IF l_Catalog_Group_Name IS NOT NULL AND EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
592: EGO_Globals.G_OPR_CREATE
593: THEN
594: Error_Handler.Add_Error_Token
595: ( x_mesg_token_Tbl => l_mesg_token_tbl
596: , p_application_id => 'EGO'

Line 605: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE

601: /* It is an error if the group name does not exist
602: when the transaction type is DELETE or UPDATE */
603:
604: ELSIF l_Catalog_Group_Name IS NULL AND
605: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE
606: THEN
607:
608: Error_Handler.Add_Error_Token
609: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 615: ELSIF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NOT NULL AND

611: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
612: );
613: l_return_status := FND_API.G_RET_STS_ERROR;
614:
615: ELSIF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NOT NULL AND
616: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> FND_API.G_MISS_CHAR
617: THEN
618:
619: -- As long as the group name is passed, it takes precedence over the segments

Line 616: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> FND_API.G_MISS_CHAR

612: );
613: l_return_status := FND_API.G_RET_STS_ERROR;
614:
615: ELSIF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NOT NULL AND
616: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> FND_API.G_MISS_CHAR
617: THEN
618:
619: -- As long as the group name is passed, it takes precedence over the segments
620:

Line 621: /* IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR

617: THEN
618:
619: -- As long as the group name is passed, it takes precedence over the segments
620:
621: /* IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR
622: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> l_Catalog_Group_Name
623: THEN
624: -- breakup the segments and store it for use
625: -- during database writes.

Line 622: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> l_Catalog_Group_Name

618:
619: -- As long as the group name is passed, it takes precedence over the segments
620:
621: /* IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR
622: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> l_Catalog_Group_Name
623: THEN
624: -- breakup the segments and store it for use
625: -- during database writes.
626: check_status := Perform_Segment_Breakup(p_create_new => false);

Line 653: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR concat_Group_Name <> l_Catalog_Group_Name

649: -- catalog_group_name : that is fetched using the id is not the
650: -- the same as the concatenation of the segments then, the user
651: -- could be renaming the catalog group.
652:
653: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR concat_Group_Name <> l_Catalog_Group_Name
654: THEN
655: -- dbms_output.put_line('concat group name: ' || concat_Group_Name || ' catalog group name from id: ' || l_Catalog_Group_Name);
656:
657: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

Line 657: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

653: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE OR concat_Group_Name <> l_Catalog_Group_Name
654: THEN
655: -- dbms_output.put_line('concat group name: ' || concat_Group_Name || ' catalog group name from id: ' || l_Catalog_Group_Name);
656:
657: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=
658: concat_Group_Name;
659: END IF;
660: ELSE
661: Error_Handler.Add_Error_Token

Line 675: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE

671:
672: -- For CREATE this is an error condition since we need either Group name or
673: -- the Segments apart from the Id
674:
675: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE
676: THEN
677: Error_Handler.Add_Error_Token
678: ( x_mesg_token_Tbl => l_mesg_token_tbl
679: , p_application_id => 'EGO'

Line 684: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name := l_Catalog_Group_Name;

680: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
681: );
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: ELSE
684: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name := l_Catalog_Group_Name;
685: check_status := Perform_Segment_Breakup(p_create_new => false);
686: END IF;
687: END IF;
688:

Line 691: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND

687: END IF;
688:
689: -- Get Catalog Group Id using Catalog Group Name
690: --
691: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
692: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR)
693: THEN
694:
695: is_passed := TRUE;

Line 692: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR)

688:
689: -- Get Catalog Group Id using Catalog Group Name
690: --
691: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
692: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR)
693: THEN
694:
695: is_passed := TRUE;
696:

Line 698: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

694:
695: is_passed := TRUE;
696:
697: Error_Handler.Write_Debug('getting id for ' ||
698: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
699:
700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
701:
702: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=

Line 700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

696:
697: Error_Handler.Write_Debug('getting id for ' ||
698: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
699:
700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
701:
702: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
703: Get_Catalog_Group_Id( p_catalog_group_name =>
704: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

Line 702: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=

698: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
699:
700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
701:
702: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
703: Get_Catalog_Group_Id( p_catalog_group_name =>
704: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
705: , p_operation => 'FIND_COMBINATION'
706: );

Line 704: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
701:
702: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
703: Get_Catalog_Group_Id( p_catalog_group_name =>
704: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
705: , p_operation => 'FIND_COMBINATION'
706: );
707:
708: IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NOT NULL)

Line 708: IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NOT NULL)

704: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
705: , p_operation => 'FIND_COMBINATION'
706: );
707:
708: IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NOT NULL)
709: THEN
710:
711: check_status := Perform_Segment_Breakup(p_create_new => false);
712:

Line 716: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE

712:
713: /* It is an error if the CCID exists
714: when the transaction type is CREATE */
715:
716: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE
717: THEN
718: Error_Handler.Add_Error_Token
719: ( x_mesg_token_Tbl => l_mesg_token_tbl
720: , p_application_id => 'EGO'

Line 730: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN

726:
727: /* It is an error if the CCID does not exist
728: when the transaction type is DELETE or UPDATE */
729:
730: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
731: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
732: THEN
733: Error_Handler.Add_Error_Token
734: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 731: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)

727: /* It is an error if the CCID does not exist
728: when the transaction type is DELETE or UPDATE */
729:
730: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
731: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
732: THEN
733: Error_Handler.Add_Error_Token
734: ( x_mesg_token_Tbl => l_mesg_token_tbl
735: , p_application_id => 'EGO'

Line 746: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

742: is SYNC or CREATE */
743:
744: check_status :=
745: Get_Catalog_Group_Id( p_catalog_group_name =>
746: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
747: , p_operation => 'CHECK_SEGMENTS'
748: );
749: IF (check_status = 1)
750: THEN

Line 751: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

747: , p_operation => 'CHECK_SEGMENTS'
748: );
749: IF (check_status = 1)
750: THEN
751: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
752: Perform_Segment_Breakup;
753:
754: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
755: ELSIF (check_status = 0)

Line 754: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

750: THEN
751: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
752: Perform_Segment_Breakup;
753:
754: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
755: ELSIF (check_status = 0)
756: THEN
757: Error_Handler.Add_Error_Token
758: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 781: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND

777: END IF;
778: --
779: -- Get Parent Catalog Group Id using Parent Catalog Group Name
780: --
781: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
782: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
783: )
784: THEN
785: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

Line 782: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR

778: --
779: -- Get Parent Catalog Group Id using Parent Catalog Group Name
780: --
781: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
782: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
783: )
784: THEN
785: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
786: Get_Catalog_Group_Id(p_catalog_group_name =>

Line 785: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

781: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
782: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
783: )
784: THEN
785: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
786: Get_Catalog_Group_Id(p_catalog_group_name =>
787: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
788: , p_operation => 'FIND_COMBINATION'
789: );

Line 787: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name

783: )
784: THEN
785: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
786: Get_Catalog_Group_Id(p_catalog_group_name =>
787: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
788: , p_operation => 'FIND_COMBINATION'
789: );
790:
791: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||

Line 792: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

788: , p_operation => 'FIND_COMBINATION'
789: );
790:
791: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
792: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
793:
794: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
795:
796: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

Line 794: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

790:
791: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
792: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
793:
794: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
795:
796: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
797: THEN
798:

Line 796: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

792: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
793:
794: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
795:
796: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
797: THEN
798:
799: -- dbms_output.put_line('Parent Catalog Group Id NOT FOUND . . . ');
800: Error_Handler.Add_Error_Token

Line 812: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND

808:
809: --
810: -- Convert Parent_Catalog_Group_Id into Parent_Catalog_Group_name
811: --
812: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
813: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
814: )
815: THEN
816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);

Line 813: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM

809: --
810: -- Convert Parent_Catalog_Group_Id into Parent_Catalog_Group_name
811: --
812: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
813: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
814: )
815: THEN
816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
817:

Line 816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);

812: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
813: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
814: )
815: THEN
816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
817:
818: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
819: Get_Catalog_Group_Name(p_catalog_group_id =>
820: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

Line 818: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=

814: )
815: THEN
816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
817:
818: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
819: Get_Catalog_Group_Name(p_catalog_group_id =>
820: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
821: );
822:

Line 820: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

816: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
817:
818: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
819: Get_Catalog_Group_Name(p_catalog_group_id =>
820: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
821: );
822:
823: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
824: THEN

Line 823: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL

819: Get_Catalog_Group_Name(p_catalog_group_id =>
820: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
821: );
822:
823: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
824: THEN
825:
826: Error_Handler.Add_Error_Token
827: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 833: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name);

829: , p_message_text => G_Error_Msg_Text
830: );
831: l_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name);
834:
835: END IF;
836:
837: -- dbms_output.put_line('UUI Conversion done . . .returning ' || l_return_status);

Line 885: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR

881: -- would be validated and segments would be disregarded.
882: -- Else segments will be validated.
883: --
884:
885: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
886: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
887: ) AND
888: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR

Line 886: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

882: -- Else segments will be validated.
883: --
884:
885: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
886: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
887: ) AND
888: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
890: ) AND check_segments_populated

Line 888: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR

884:
885: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
886: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
887: ) AND
888: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
890: ) AND check_segments_populated
891: THEN
892: -- dbms_output.put_line('Segments populated . . . ');

Line 889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR

885: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
886: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
887: ) AND
888: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NULL OR
889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
890: ) AND check_segments_populated
891: THEN
892: -- dbms_output.put_line('Segments populated . . . ');
893: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

Line 893: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

889: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name = FND_API.G_MISS_CHAR
890: ) AND check_segments_populated
891: THEN
892: -- dbms_output.put_line('Segments populated . . . ');
893: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=
894: concatenate_segments( p_appl_short_name => 'INV'
895: , p_key_flex_code => 'MICG'
896: , p_structure_number => 101
897: );

Line 898: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL

894: concatenate_segments( p_appl_short_name => 'INV'
895: , p_key_flex_code => 'MICG'
896: , p_structure_number => 101
897: );
898: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL
899: THEN
900: -- dbms_output.put_line('concat group name is NULL ' );
901:
902: Error_Handler.Add_Error_Token

Line 914: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

910: -- Get the corresponding Catalog group id
911: --
912: check_status :=
913: Get_Catalog_Group_Id( p_catalog_group_name =>
914: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
915: , p_operation => 'FIND_COMBINATION'
916: );
917: -- dbms_output.put_line('ccid after FIND_COMBINATION . . . ' || check_status );
918: IF (check_status IS NOT null)

Line 922: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;

918: IF (check_status IS NOT null)
919: THEN
920: -- if not null then the returned value is the ccid
921:
922: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;
923:
924: ELSE
925: -- dbms_output.put_line('CHECK_SEGMENTS from here . . .');
926:

Line 929: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

925: -- dbms_output.put_line('CHECK_SEGMENTS from here . . .');
926:
927: check_status :=
928: Get_Catalog_Group_Id( p_catalog_group_name =>
929: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
930: , p_operation => 'CHECK_SEGMENTS'
931: );
932: -- if segments are valid then proceed
933: IF (check_status = 1)

Line 935: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

931: );
932: -- if segments are valid then proceed
933: IF (check_status = 1)
934: THEN
935: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
936: Perform_Segment_Breakup;
937: is_new := true;
938:
939: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

Line 939: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

935: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
936: Perform_Segment_Breakup;
937: is_new := true;
938:
939: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
940: END IF;
941: END IF;
942: END IF;
943:

Line 949: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND

945:
946: --
947: -- Convert Catalog_Group_Id into name
948: --
949: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND
950: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM
951: ) AND NOT is_new
952: THEN
953: -- dbms_output.put_line('Getting Group Name from ID ... ');

Line 950: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM

946: --
947: -- Convert Catalog_Group_Id into name
948: --
949: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NOT NULL AND
950: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id <> FND_API.G_MISS_NUM
951: ) AND NOT is_new
952: THEN
953: -- dbms_output.put_line('Getting Group Name from ID ... ');
954: l_Catalog_Group_Name :=

Line 956: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

952: THEN
953: -- dbms_output.put_line('Getting Group Name from ID ... ');
954: l_Catalog_Group_Name :=
955: Get_Catalog_Group_Name(p_catalog_group_id =>
956: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
957: );
958:
959: IF l_Catalog_Group_Name IS NULL
960: THEN

Line 969: ELSE IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL OR

965: , p_message_text => G_Error_Msg_Text
966: );
967: l_return_status := FND_API.G_RET_STS_ERROR;
968:
969: ELSE IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL OR
970: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name = FND_API.G_MISS_CHAR
971: )
972: AND
973: check_segments_populated

Line 970: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name = FND_API.G_MISS_CHAR

966: );
967: l_return_status := FND_API.G_RET_STS_ERROR;
968:
969: ELSE IF (EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL OR
970: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name = FND_API.G_MISS_CHAR
971: )
972: AND
973: check_segments_populated
974: THEN

Line 999: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

995: IF concat_Group_Name <> l_Catalog_Group_Name
996: THEN
997: -- dbms_output.put_line('concat group name: ' || concat_Group_Name || ' catalog group name from id: ' || l_Catalog_Group_Name);
998:
999: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=
1000: concat_Group_Name;
1001:
1002: -- breakup the segments and store it for use
1003: -- during database writes.

Line 1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND

1017: END IF;
1018:
1019: -- Get Catalog Group Id using Catalog Group Name
1020: --
1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND
1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

Line 1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND

1018:
1019: -- Get Catalog Group Id using Catalog Group Name
1020: --
1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND
1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )

Line 1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND

1019: -- Get Catalog Group Id using Catalog Group Name
1020: --
1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND
1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )
1027: )

Line 1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR

1020: --
1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND
1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )
1027: )
1028: THEN

Line 1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

1021: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1022: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1023: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE AND
1024: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )
1027: )
1028: THEN
1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

Line 1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )
1027: )
1028: THEN
1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
1032: Get_Catalog_Group_Id( p_catalog_group_name =>
1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

Line 1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

1026: )
1027: )
1028: THEN
1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
1032: Get_Catalog_Group_Id( p_catalog_group_name =>
1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1034: , p_operation => 'FIND_COMBINATION'

Line 1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=

1027: )
1028: THEN
1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
1032: Get_Catalog_Group_Id( p_catalog_group_name =>
1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1034: , p_operation => 'FIND_COMBINATION'
1035: );

Line 1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
1032: Get_Catalog_Group_Id( p_catalog_group_name =>
1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1034: , p_operation => 'FIND_COMBINATION'
1035: );
1036:
1037: --

Line 1042: if(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NULL)

1038: -- If the transaction type was SYNC and the previous opr. did not return
1039: -- a row then it could be a create operation
1040: --
1041:
1042: if(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NULL)
1043: THEN
1044: check_status :=
1045: Get_Catalog_Group_Id( p_catalog_group_name =>
1046: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

Line 1046: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

1042: if(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id IS NULL)
1043: THEN
1044: check_status :=
1045: Get_Catalog_Group_Id( p_catalog_group_name =>
1046: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1047: , p_operation => 'CHECK_SEGMENTS'
1048: );
1049: IF (check_status = 1)
1050: THEN

Line 1051: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

1047: , p_operation => 'CHECK_SEGMENTS'
1048: );
1049: IF (check_status = 1)
1050: THEN
1051: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
1052: Perform_Segment_Breakup;
1053:
1054: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1055: ELSIF (check_status = 0)

Line 1054: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

1050: THEN
1051: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
1052: Perform_Segment_Breakup;
1053:
1054: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1055: ELSIF (check_status = 0)
1056: THEN
1057: Error_Handler.Add_Error_Token
1058: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND

1062: l_return_status := FND_API.G_RET_STS_ERROR;
1063: END IF;
1064: END IF;
1065: /* if the OPERATION IS CREATE rather than SYNC */
1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND
1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

Line 1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND

1063: END IF;
1064: END IF;
1065: /* if the OPERATION IS CREATE rather than SYNC */
1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND
1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1071: )

Line 1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND

1064: END IF;
1065: /* if the OPERATION IS CREATE rather than SYNC */
1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND
1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1071: )
1072: )

Line 1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR

1065: /* if the OPERATION IS CREATE rather than SYNC */
1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND
1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1071: )
1072: )
1073: THEN

Line 1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM

1066: ELSIF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_name IS NOT NULL AND
1067: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name <> FND_API.G_MISS_CHAR AND
1068: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE AND
1069: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id IS NULL OR
1070: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1071: )
1072: )
1073: THEN
1074: check_status :=

Line 1076: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

1072: )
1073: THEN
1074: check_status :=
1075: Get_Catalog_Group_Id( p_catalog_group_name =>
1076: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1077: , p_operation => 'FIND_COMBINATION'
1078: );
1079: IF (check_status <> null)
1080: THEN

Line 1083: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;

1079: IF (check_status <> null)
1080: THEN
1081: -- if not null then the returned value is the ccid
1082:
1083: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;
1084: ELSE
1085: check_status :=
1086: Get_Catalog_Group_Id( p_catalog_group_name =>
1087: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

Line 1087: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

1083: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id := check_status;
1084: ELSE
1085: check_status :=
1086: Get_Catalog_Group_Id( p_catalog_group_name =>
1087: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
1088: , p_operation => 'CHECK_SEGMENTS'
1089: );
1090: -- if segments are valid then proceed
1091: IF (check_status = 1)

Line 1093: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

1089: );
1090: -- if segments are valid then proceed
1091: IF (check_status = 1)
1092: THEN
1093: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
1094: Perform_Segment_Breakup;
1095:
1096: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1097: ELSIF (check_status = 0)

Line 1096: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);

1092: THEN
1093: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=
1094: Perform_Segment_Breakup;
1095:
1096: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1097: ELSIF (check_status = 0)
1098: THEN
1099: Error_Handler.Add_Error_Token
1100: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 1114: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND

1110: --
1111: -- Get Parent Catalog Group Id using Parent Catalog Group Name
1112: --
1113:
1114: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
1115: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
1116: )
1117: THEN
1118: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

Line 1115: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR

1111: -- Get Parent Catalog Group Id using Parent Catalog Group Name
1112: --
1113:
1114: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
1115: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
1116: )
1117: THEN
1118: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
1119: Get_Catalog_Group_Id(p_catalog_group_name =>

Line 1118: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

1114: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name IS NOT NULL AND
1115: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name <> FND_API.G_MISS_CHAR
1116: )
1117: THEN
1118: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
1119: Get_Catalog_Group_Id(p_catalog_group_name =>
1120: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
1121: , p_operation => 'FIND_COMBINATION'
1122: );

Line 1120: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name

1116: )
1117: THEN
1118: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=
1119: Get_Catalog_Group_Id(p_catalog_group_name =>
1120: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
1121: , p_operation => 'FIND_COMBINATION'
1122: );
1123:
1124: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||

Line 1125: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

1121: , p_operation => 'FIND_COMBINATION'
1122: );
1123:
1124: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
1125: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1126:
1127: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1128:
1129: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

Line 1127: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

1123:
1124: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
1125: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1126:
1127: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1128:
1129: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
1130: THEN
1131:

Line 1129: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

1125: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1126:
1127: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1128:
1129: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
1130: THEN
1131:
1132: -- dbms_output.put_line('Parent Catalog Group Id NOT FOUND . . . ');
1133: Error_Handler.Add_Error_Token

Line 1145: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND

1141:
1142: --
1143: -- Convert Parent_Catalog_Group_Id into Parent_Catalog_Group_name
1144: --
1145: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
1146: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
1147: )
1148: THEN
1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);

Line 1146: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM

1142: --
1143: -- Convert Parent_Catalog_Group_Id into Parent_Catalog_Group_name
1144: --
1145: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
1146: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
1147: )
1148: THEN
1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
1150:

Line 1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);

1145: IF (EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
1146: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
1147: )
1148: THEN
1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
1150:
1151: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
1152: Get_Catalog_Group_Name(p_catalog_group_id =>
1153: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

Line 1151: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=

1147: )
1148: THEN
1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
1150:
1151: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
1152: Get_Catalog_Group_Name(p_catalog_group_id =>
1153: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
1154: );
1155:

Line 1153: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

1149: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id);
1150:
1151: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=
1152: Get_Catalog_Group_Name(p_catalog_group_id =>
1153: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
1154: );
1155:
1156: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
1157: THEN

Line 1156: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL

1152: Get_Catalog_Group_Name(p_catalog_group_id =>
1153: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
1154: );
1155:
1156: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
1157: THEN
1158:
1159: Error_Handler.Add_Error_Token
1160: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 1166: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name);

1162: , p_message_text => G_Error_Msg_Text
1163: );
1164: l_return_status := FND_API.G_RET_STS_ERROR;
1165: END IF;
1166: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name);
1167: END IF;
1168:
1169: -- dbms_output.put_line('UUI Conversion done . . .returning ' || l_return_status);
1170: Error_Handler.Write_Debug('UUI Conversion done . . . returning ' || l_return_status) ;