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 FND_API

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

434: , x_Return_Status OUT NOCOPY VARCHAR2
435: )
436: IS
437: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
439: l_result VARCHAR2(2000);
440:
441: is_valid boolean;
442: is_passed boolean := false;

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: check_status number;
444: l_catalog_group_name VARCHAR2(1000);
445: concat_group_name VARCHAR2(1000);
446: BEGIN
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: fnd_flex_key_api.set_session_mode('seed_data');
450: --
451: -- If the user has specified the name, id and segment then id is first

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 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 481: l_return_status := FND_API.G_RET_STS_ERROR;

477: ( x_mesg_token_Tbl => l_mesg_token_tbl
478: , p_application_id => 'EGO'
479: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
480: );
481: l_return_status := FND_API.G_RET_STS_ERROR;
482: ELSE
483: --
484: -- Get the corresponding Catalog group id
485: --

Line 510: l_return_status := FND_API.G_RET_STS_ERROR;

506: ( x_mesg_token_Tbl => l_mesg_token_tbl
507: , p_application_id => 'EGO'
508: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
509: );
510: l_return_status := FND_API.G_RET_STS_ERROR;
511: END IF;
512: ELSE
513:
514: -- dbms_output.put_line('Error if it is update or delete . . .');

Line 527: l_return_status := FND_API.G_RET_STS_ERROR;

523: ( x_mesg_token_Tbl => l_mesg_token_tbl
524: , p_application_id => 'EGO'
525: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
526: );
527: l_return_status := FND_API.G_RET_STS_ERROR;
528: ELSE
529:
530: /* CCID will be generated when it does not exist in the
531: case of SYNC and CREATE */

Line 555: l_return_status := FND_API.G_RET_STS_ERROR;

551: ( x_mesg_token_Tbl => l_mesg_token_tbl
552: , p_application_id => 'EGO'
553: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
554: );
555: l_return_status := FND_API.G_RET_STS_ERROR;
556: END IF;
557: END IF;
558: END IF;
559: END IF;

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 599: l_return_status := FND_API.G_RET_STS_ERROR;

595: ( x_mesg_token_Tbl => l_mesg_token_tbl
596: , p_application_id => 'EGO'
597: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
598: );
599: l_return_status := FND_API.G_RET_STS_ERROR;
600:
601: /* It is an error if the group name does not exist
602: when the transaction type is DELETE or UPDATE */
603:

Line 613: l_return_status := FND_API.G_RET_STS_ERROR;

609: ( x_mesg_token_Tbl => l_mesg_token_tbl
610: , p_application_id => 'EGO'
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

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 666: l_return_status := FND_API.G_RET_STS_ERROR;

662: ( x_mesg_token_Tbl => l_mesg_token_tbl
663: , p_application_id => 'EGO'
664: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
665: );
666: l_return_status := FND_API.G_RET_STS_ERROR;
667: END IF;
668:
669: ELSE
670: /* Default the existing segments if the current operation is not CREATE*/

Line 682: l_return_status := FND_API.G_RET_STS_ERROR;

678: ( x_mesg_token_Tbl => l_mesg_token_tbl
679: , p_application_id => 'EGO'
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;

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 723: l_return_status := FND_API.G_RET_STS_ERROR;

719: ( x_mesg_token_Tbl => l_mesg_token_tbl
720: , p_application_id => 'EGO'
721: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
722: );
723: l_return_status := FND_API.G_RET_STS_ERROR;
724: END IF;
725: ELSE
726:
727: /* It is an error if the CCID does not exist

Line 738: l_return_status := FND_API.G_RET_STS_ERROR;

734: ( x_mesg_token_Tbl => l_mesg_token_tbl
735: , p_application_id => 'EGO'
736: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
737: );
738: l_return_status := FND_API.G_RET_STS_ERROR;
739: ELSE
740:
741: /* Validate the segments and Generate ID if the Transaction type
742: is SYNC or CREATE */

Line 762: l_return_status := FND_API.G_RET_STS_ERROR;

758: ( x_mesg_token_Tbl => l_mesg_token_tbl
759: , p_application_id => 'EGO'
760: , p_message_text => G_Error_Msg_Text
761: );
762: l_return_status := FND_API.G_RET_STS_ERROR;
763: END IF;
764: END IF;
765: END IF;
766: END IF;

Line 776: l_return_status := FND_API.G_RET_STS_ERROR;

772: ( x_mesg_token_Tbl => l_mesg_token_tbl
773: , p_application_id => 'EGO'
774: , p_message_text => 'EGO_CAT_KEYCOLS_NOT_PASSED'
775: );
776: l_return_status := FND_API.G_RET_STS_ERROR;
777: END IF;
778: --
779: -- Get Parent Catalog Group Id using Parent Catalog Group Name
780: --

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 805: l_return_status := FND_API.G_RET_STS_ERROR;

801: ( x_mesg_token_Tbl => l_mesg_token_tbl
802: , p_application_id => 'EGO'
803: , p_message_text => G_Error_Msg_Text
804: );
805: l_return_status := FND_API.G_RET_STS_ERROR;
806: END IF;
807: END IF;
808:
809: --

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 831: l_return_status := FND_API.G_RET_STS_ERROR;

827: ( x_mesg_token_Tbl => l_mesg_token_tbl
828: , p_application_id => 'EGO'
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;

Line 861: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

857: , x_Return_Status OUT NOCOPY VARCHAR2
858: )
859: IS
860: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
861: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
862: l_result VARCHAR2(2000);
863:
864: is_valid boolean;
865: is_new boolean;

Line 870: x_return_status := FND_API.G_RET_STS_SUCCESS;

866: check_status number;
867: l_catalog_group_name VARCHAR2(1000);
868: concat_group_name VARCHAR2(1000);
869: BEGIN
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871: fnd_flex_key_api.set_session_mode('seed_data');
872:
873:
874: -- dbms_output.put_line('Performing UUI conversion . . . ');

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 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 907: l_return_status := FND_API.G_RET_STS_ERROR;

903: ( x_mesg_token_Tbl => l_mesg_token_tbl
904: , p_application_id => 'EGO'
905: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
906: );
907: l_return_status := FND_API.G_RET_STS_ERROR;
908: ELSE
909: --
910: -- Get the corresponding Catalog group id
911: --

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 967: l_return_status := FND_API.G_RET_STS_ERROR;

963: ( x_mesg_token_Tbl => l_mesg_token_tbl
964: , p_application_id => 'EGO'
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: )

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 1012: l_return_status := FND_API.G_RET_STS_ERROR;

1008: ( x_mesg_token_Tbl => l_mesg_token_tbl
1009: , p_application_id => 'EGO'
1010: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
1011: );
1012: l_return_status := FND_API.G_RET_STS_ERROR;
1013: END IF;
1014: END IF;
1015:
1016: END IF;

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 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 1062: l_return_status := FND_API.G_RET_STS_ERROR;

1058: ( x_mesg_token_Tbl => l_mesg_token_tbl
1059: , p_application_id => 'EGO'
1060: , p_message_text => G_Error_Msg_Text
1061: );
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

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 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 1104: l_return_status := FND_API.G_RET_STS_ERROR;

1100: ( x_mesg_token_Tbl => l_mesg_token_tbl
1101: , p_application_id => 'EGO'
1102: , p_message_text => G_Error_Msg_Text
1103: );
1104: l_return_status := FND_API.G_RET_STS_ERROR;
1105: END IF;
1106: END IF;
1107: END IF;
1108:

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 1138: l_return_status := FND_API.G_RET_STS_ERROR;

1134: ( x_mesg_token_Tbl => l_mesg_token_tbl
1135: , p_application_id => 'EGO'
1136: , p_message_text => G_Error_Msg_Text
1137: );
1138: l_return_status := FND_API.G_RET_STS_ERROR;
1139: END IF;
1140: END IF;
1141:
1142: --

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 1164: l_return_status := FND_API.G_RET_STS_ERROR;

1160: ( x_mesg_token_Tbl => l_mesg_token_tbl
1161: , p_application_id => 'EGO'
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:

Line 1191: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

1187: ( x_Return_Status OUT NOCOPY VARCHAR2
1188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: )
1190: IS
1191: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1192: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1193: l_err_text VARCHAR2(2000);
1194: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1195: BEGIN