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.QP_UTIL dependencies on FND_FLEX_DSC_API

Line 2651: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');

2647: p_application_column_name VARCHAR2(240);
2648: p_application_id VARCHAR2(30);
2649: BEGIN
2650:
2651: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2652:
2653: FND_PROFILE.PUT('RESP_APPL_ID','0');
2654: FND_PROFILE.PUT('RESP_ID','20419');
2655: FND_PROFILE.PUT('USER_ID','1001');

Line 2660: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

2656:
2657: -- Delete all the segments under the New Global Data Elements Context(if any)
2658:
2659: --dbms_output.put_line ('Before even starting the process');
2660: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
2661: P_NEW_FLEXFIELD_NAME )) THEN
2662: --dbms_output.put_line ('Entered the Processing');
2663: IF (P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
2664: -- Get the New Global Data Elements Context and Its Segments

Line 2688: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT

2684: IF (NEW_GDE_SEGMENTS.NSEGMENTS > 0) THEN
2685: --dbms_output.put_line('New GDE has segments');
2686: FOR I IN 1..NEW_GDE_SEGMENTS.NSEGMENTS LOOP
2687: --dbms_output.put_line('Trying to delete segments under old context');
2688: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT
2689: ,P_NEW_FLEXFIELD_NAME
2690: ,OLD_GDE_CONTEXT_CODE -- Global Data Elements
2691: ,NEW_GDE_SEGMENTS.SEGMENT_NAME(I));
2692: END LOOP;

Line 2714: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

2710: -- Store all the old contexts
2711: GDE_CONTEXTS := L_CONTEXTS;
2712:
2713: -- Check To See If New Flex Structure Exists
2714: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
2715: P_NEW_FLEXFIELD_NAME )) THEN
2716: FOR I IN 1..L_CONTEXTS.NCONTEXTS LOOP
2717: --dbms_output.put_line ( ' Global Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
2718: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN

Line 2722: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

2718: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
2719: --dbms_output.put_line('There are contexts for migration');
2720: IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,NEW_GDE_CONTEXT_CODE) = FALSE) THEN
2721: --dbms_output.put_line ('Creating the Upgrade Context');
2722: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
2723: , P_NEW_FLEXFIELD_NAME
2724: , NEW_GDE_CONTEXT_CODE
2725: , NEW_GDE_CONTEXT_CODE
2726: , NEW_GDE_CONTEXT_CODE

Line 2735: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT

2731: NULL;
2732: --dbms_output.put_line ('Upgrade Context Already Exists');
2733: END IF;
2734:
2735: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT
2736: , P_NEW_FLEXFIELD_NAME
2737: , NEW_GDE_CONTEXT_CODE
2738: , TRUE );
2739:

Line 2740: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT

2736: , P_NEW_FLEXFIELD_NAME
2737: , NEW_GDE_CONTEXT_CODE
2738: , TRUE );
2739:
2740: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT
2741: , P_NEW_FLEXFIELD_NAME
2742: , 'ATTRIBUTE[0-9]+');
2743:
2744: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

Line 2805: FND_FLEX_DSC_API.CREATE_SEGMENT (

2801: p_application_id := QP_APPLICATION_ID;
2802:
2803: --dbms_output.put_line ('Creating the Upgrade Context Segments');
2804: BEGIN
2805: FND_FLEX_DSC_API.CREATE_SEGMENT (
2806: APPL_SHORT_NAME => P_NEW_PRODUCT
2807: , FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
2808: , CONTEXT_NAME => NEW_GDE_CONTEXT_CODE
2809: , NAME => p_segment_name

Line 2856: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

2852: --dbms_output.put_line ('Before Other Context Existance Check');
2853: --dbms_output.put_line ('Context Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
2854: IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,L_CONTEXTS.CONTEXT_CODE(I)) = FALSE) THEN
2855: --dbms_output.put_line ('Creating Other Contexts');
2856: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
2857: , P_NEW_FLEXFIELD_NAME
2858: , L_CONTEXTS.CONTEXT_CODE(I)
2859: , L_CONTEXTS.CONTEXT_NAME(I)
2860: , L_CONTEXTS.CONTEXT_DESCRIPTION(I)

Line 2866: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT

2862: , 'N') ;
2863:
2864: END IF;
2865:
2866: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT
2867: , P_NEW_FLEXFIELD_NAME
2868: , L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2869: , TRUE );
2870:

Line 2871: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT

2867: , P_NEW_FLEXFIELD_NAME
2868: , L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2869: , TRUE );
2870:
2871: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT
2872: , P_NEW_FLEXFIELD_NAME
2873: , 'ATTRIBUTE[0-9]+');
2874:
2875: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

Line 2939: FND_FLEX_DSC_API.CREATE_SEGMENT (

2935: p_application_id := QP_APPLICATION_ID;
2936:
2937: --dbms_output.put_line ('Creating Other Contexts Segments ');
2938: BEGIN
2939: FND_FLEX_DSC_API.CREATE_SEGMENT (
2940: APPL_SHORT_NAME => P_NEW_PRODUCT
2941: , FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
2942: , CONTEXT_NAME => L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2943: , NAME => p_segment_name

Line 3038: FND_FLEX_DSC_API.CREATE_SEGMENT (

3034: p_application_id := QP_APPLICATION_ID;
3035:
3036: --dbms_output.put_line ('Creating the OLD Gde segments to all contexts');
3037: BEGIN
3038: FND_FLEX_DSC_API.CREATE_SEGMENT (
3039: APPL_SHORT_NAME => P_NEW_PRODUCT
3040: , FLEXFIELD_NAME =>P_NEW_FLEXFIELD_NAME
3041: , CONTEXT_NAME => L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
3042: , NAME => p_segment_name

Line 3082: --dbms_output.put_line(fnd_flex_dsc_api.message);

3078: END LOOP; -- CONTEXTS
3079: END IF; /* CHECK FOR NEW FLEX FIELD STRUCTURE EXISTS */
3080: EXCEPTION
3081: WHEN OTHERS THEN
3082: --dbms_output.put_line(fnd_flex_dsc_api.message);
3083: rollback;
3084: Log_Error(p_id1 => -6501,
3085: p_error_type => 'FLEXFIELD UPGRADE',
3086: p_error_desc => fnd_flex_dsc_api.message,

Line 3086: p_error_desc => fnd_flex_dsc_api.message,

3082: --dbms_output.put_line(fnd_flex_dsc_api.message);
3083: rollback;
3084: Log_Error(p_id1 => -6501,
3085: p_error_type => 'FLEXFIELD UPGRADE',
3086: p_error_desc => fnd_flex_dsc_api.message,
3087: p_error_module => 'QP_Upgrade_Context');
3088: raise;
3089: END QP_UPGRADE_CONTEXT;
3090: