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.

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 249: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 468: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

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

Line 473: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL

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

Line 489: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

Line 503: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =

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

Line 504: EGO_Globals.G_OPR_CREATE

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

Line 520: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN

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

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

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

Line 538: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

Line 546: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 586: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

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

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

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

Line 593: EGO_Globals.G_OPR_CREATE

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

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

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

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

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

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

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

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

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

Line 623: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name <> l_Catalog_Group_Name

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

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

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

Line 658: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

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

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

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

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

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

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

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

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

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

Line 699: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

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

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

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

Line 703: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=

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

Line 705: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

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

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

Line 731: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN

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

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

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

Line 747: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

Line 752: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

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

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

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

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

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

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

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

Line 786: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

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

Line 788: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name

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

Line 793: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

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

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

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

Line 797: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

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

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

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

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

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

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

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

Line 819: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=

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

Line 821: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

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

Line 824: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL

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

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

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

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

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

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

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

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

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

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

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

Line 894: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

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

Line 899: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL

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

Line 915: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

Line 930: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

Line 936: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

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

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

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

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

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

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

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

Line 957: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

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

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

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

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

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

Line 1000: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1032: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=

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

Line 1034: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

Line 1047: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

Line 1052: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1077: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

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

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

Line 1088: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

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

Line 1094: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id :=

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

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

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

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

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

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

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

Line 1119: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_Id :=

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

Line 1121: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name

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

Line 1126: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);

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

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

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

Line 1130: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL

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

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

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

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

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

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

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

Line 1152: EGO_Globals.G_Catalog_Group_Rec.parent_Catalog_Group_name :=

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

Line 1154: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

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

Line 1157: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL

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

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

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