DBA Data[Home] [Help]

APPS.QP_UPGRADE_UTIL dependencies on FND_FLEX_DSC_API

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

128: p_application_column_name VARCHAR2(240);
129: p_application_id VARCHAR2(30);
130: BEGIN
131:
132: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
133:
134: /* vivek
135:
136: FND_PROFILE.PUT('RESP_APPL_ID','0');

Line 142: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

138: FND_PROFILE.PUT('USER_ID','1001');
139: -- Delete all the segments under the New Global Data Elements Context(if any)
140:
141: --dbms_output.put_line ('Before even starting the process');
142: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
143: P_NEW_FLEXFIELD_NAME )) THEN
144: --dbms_output.put_line ('Entered the Processing');
145: IF (P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
146: -- Get the New Global Data Elements Context and Its Segments

Line 170: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT

166: IF (NEW_GDE_SEGMENTS.NSEGMENTS > 0) THEN
167: --dbms_output.put_line('New GDE has segments');
168: FOR I IN 1..NEW_GDE_SEGMENTS.NSEGMENTS LOOP
169: --dbms_output.put_line('Trying to delete segments under old context');
170: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT
171: ,P_NEW_FLEXFIELD_NAME
172: ,OLD_GDE_CONTEXT_CODE -- Global Data Elements
173: ,NEW_GDE_SEGMENTS.SEGMENT_NAME(I));
174: END LOOP;

Line 196: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

192: -- Store all the old contexts
193: GDE_CONTEXTS := L_CONTEXTS;
194:
195: -- Check To See If New Flex Structure Exists
196: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
197: P_NEW_FLEXFIELD_NAME )) THEN
198: FOR I IN 1..L_CONTEXTS.NCONTEXTS LOOP
199: --dbms_output.put_line ( ' Global Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
200: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN

Line 204: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

200: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
201: --dbms_output.put_line('There are contexts for migration');
202: /* vivek IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,NEW_GDE_CONTEXT_CODE) = FALSE) THEN
203: --dbms_output.put_line ('Creating the Upgrade Context');
204: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
205: , P_NEW_FLEXFIELD_NAME
206: , NEW_GDE_CONTEXT_CODE
207: , NEW_GDE_CONTEXT_CODE
208: , NEW_GDE_CONTEXT_CODE

Line 216: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT

212: ELSE
213: NULL;
214: --dbms_output.put_line ('Upgrade Context Already Exists');
215: END IF;
216: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT
217: , P_NEW_FLEXFIELD_NAME
218: , NEW_GDE_CONTEXT_CODE
219: , TRUE );
220:

Line 221: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT

217: , P_NEW_FLEXFIELD_NAME
218: , NEW_GDE_CONTEXT_CODE
219: , TRUE );
220:
221: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT
222: , P_NEW_FLEXFIELD_NAME
223: , 'ATTRIBUTE[0-9]+');
224:
225: vivek */

Line 295: FND_FLEX_DSC_API.MODIFY_SEGMENT (

291: p_application_id := QP_APPLICATION_ID;
292:
293: --dbms_output.put_line ('Creating the Upgrade Context Segments');
294: BEGIN
295: FND_FLEX_DSC_API.MODIFY_SEGMENT (
296: P_APPL_SHORT_NAME => P_NEW_PRODUCT
297: , P_FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
298: , P_CONTEXT_CODE => NEW_GDE_CONTEXT_CODE
299: , P_SEGMENT_NAME => p_segment_name

Line 337: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

333: --dbms_output.put_line ('Before Other Context Existance Check');
334: --dbms_output.put_line ('Context Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
335: /* vivek IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,L_CONTEXTS.CONTEXT_CODE(I)) = FALSE) THEN
336: --dbms_output.put_line ('Creating Other Contexts');
337: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
338: , P_NEW_FLEXFIELD_NAME
339: , L_CONTEXTS.CONTEXT_CODE(I)
340: , L_CONTEXTS.CONTEXT_NAME(I)
341: , L_CONTEXTS.CONTEXT_DESCRIPTION(I)

Line 346: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT

342: , 'Y'
343: , 'N') ;
344:
345: END IF;
346: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT
347: , P_NEW_FLEXFIELD_NAME
348: , L_CONTEXTS.CONTEXT_NAME(I)
349: , TRUE );
350:

Line 351: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT

347: , P_NEW_FLEXFIELD_NAME
348: , L_CONTEXTS.CONTEXT_NAME(I)
349: , TRUE );
350:
351: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT
352: , P_NEW_FLEXFIELD_NAME
353: , 'ATTRIBUTE[0-9]+');
354: vivek */
355:

Line 430: FND_FLEX_DSC_API.MODIFY_SEGMENT (

426: --dbms_output.put_line ('Default type : ' || L_SEGMENTS.DEFAULT_TYPE(J));
427:
428: --dbms_output.put_line ('Creating Other Contexts Segments ');
429: BEGIN
430: FND_FLEX_DSC_API.MODIFY_SEGMENT (
431: P_APPL_SHORT_NAME => P_NEW_PRODUCT
432: , P_FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
433: , P_CONTEXT_CODE => L_CONTEXTS.CONTEXT_CODE(I)
434: , P_SEGMENT_NAME => p_segment_name

Line 527: FND_FLEX_DSC_API.MODIFY_SEGMENT (

523: p_application_id := QP_APPLICATION_ID;
524:
525: --dbms_output.put_line ('Creating the OLD Gde segments to all contexts');
526: BEGIN
527: FND_FLEX_DSC_API.MODIFY_SEGMENT (
528: P_APPL_SHORT_NAME => P_NEW_PRODUCT
529: , P_FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
530: , P_CONTEXT_CODE => L_CONTEXTS.CONTEXT_CODE(I)
531: , P_SEGMENT_NAME => p_segment_name

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

558: END LOOP; -- CONTEXTS
559: END IF; /* CHECK FOR NEW FLEX FIELD STRUCTURE EXISTS */
560: EXCEPTION
561: WHEN OTHERS THEN
562: --dbms_output.put_line(fnd_flex_dsc_api.message);
563: rollback;
564: Log_Error(p_id1 => -6501,
565: p_error_type => 'FLEXFIELD UPGRADE',
566: p_error_desc => fnd_flex_dsc_api.message,

Line 566: p_error_desc => fnd_flex_dsc_api.message,

562: --dbms_output.put_line(fnd_flex_dsc_api.message);
563: rollback;
564: Log_Error(p_id1 => -6501,
565: p_error_type => 'FLEXFIELD UPGRADE',
566: p_error_desc => fnd_flex_dsc_api.message,
567: p_error_module => 'QP_Update_Upgrade');
568: raise;
569: END QP_UPDATE_UPGRADE;
570: