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

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

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 511: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 528: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 556: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 614: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 683: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 739: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 763: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 777: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

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

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

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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