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.CZ_MODEL_CONVERT dependencies on FND_GLOBAL

Line 71: IF fnd_global.conc_request_id > 0 THEN

67: PROCEDURE log_msg(p_caller IN VARCHAR2, p_ndebug IN NUMBER, p_msg IN VARCHAR2, p_level IN NUMBER) IS
68: l_msg varchar2(2000):=NULL;
69: l_api_name constant VARCHAR2(30) := 'log_msg';
70: BEGIN
71: IF fnd_global.conc_request_id > 0 THEN
72: fnd_file.PUT_LINE(fnd_file.LOG, p_msg);
73: END IF;
74: cz_utils.log_report(g_pkg_name, p_caller, p_ndebug, p_msg, p_level);
75: EXCEPTION WHEN OTHERS THEN

Line 398: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'

394: AND c.deleted_flag = '0'
395: AND t.deleted_flag = '0'
396: AND te.deleted_flag = '0'
397: AND te.element_type = 8 -- is a text element
398: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
399: and text.deleted_flag='0'
400: and c.TEMPLATE_UI_DEF_ID = t.UI_DEF_ID
401: and s.signature_type IN ('SES','UCO')
402: AND t.ui_def_id=c.template_ui_def_id

Line 425: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'

421: AND c.deleted_flag = '0'
422: AND t.deleted_flag = '0'
423: AND te.deleted_flag = '0'
424: AND te.element_type = 8 -- is a text element
425: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
426: and text.deleted_flag='0'
427: and c.TEMPLATE_UI_DEF_ID = t.UI_DEF_ID
428: and s.signature_type IN ('SES','UCO')
429: AND t.ui_def_id=c.template_ui_def_id

Line 452: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'

448: AND c.deleted_flag = '0'
449: AND t.deleted_flag = '0'
450: AND te.deleted_flag = '0'
451: AND te.element_type = 8 -- is a text element
452: and text.ui_page_id=t.template_id AND UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
453: and text.deleted_flag='0'
454: and c.TEMPLATE_UI_DEF_ID = t.UI_DEF_ID
455: and s.signature_type IN ('SES','UCO')
456: AND t.ui_def_id=c.template_ui_def_id

Line 537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'

533: cz_intl_texts.ui_def_id,
534: 'NodeUnsatisfied' lceprop,
535: 'UserInputRequired' fceprop
536: FROM cz_intl_texts,cz_ui_defs
537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
538: AND model_id = p_dev_project_id
539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
540: AND cz_ui_defs.devl_project_id=p_dev_project_id
541: AND cz_ui_defs.deleted_flag='0'

Line 549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'

545: cz_intl_texts.ui_def_id,
546: 'Unsatisfied' lceprop,
547: 'UserInputRequired' fceprop
548: FROM cz_intl_texts,cz_ui_defs
549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
550: AND model_id = p_dev_project_id
551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
552: AND cz_ui_defs.devl_project_id=p_dev_project_id
553: AND cz_ui_defs.deleted_flag='0'

Line 561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'

557: cz_intl_texts.ui_def_id,
558: 'SubtreeUnsatisfied' lceprop,
559: 'UserInputRequiredInSubtree' fceprop
560: FROM cz_intl_texts,cz_ui_defs
561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
562: AND model_id = p_dev_project_id
563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
564: AND cz_ui_defs.devl_project_id=p_dev_project_id
565: AND cz_ui_defs.deleted_flag='0'

Line 582: set localized_str=REPLACE(REPLACE(REPLACE(localized_str,fnd_global.local_chr(38)||'NODEUNSATISFIED',fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'UNSATISFIED%'

578: END LOOP;
579:
580:
581: Update cz_localized_texts
582: set localized_str=REPLACE(REPLACE(REPLACE(localized_str,fnd_global.local_chr(38)||'NODEUNSATISFIED',fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'UNSATISFIED%'
583: ,fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%',fnd_global.local_chr(38)||'USERINPUTREQUIREDINSUBTREE')
584: WHERE UPPER(localized_str) LIKE '%'||fnd_global.local_chr(38)||'%UNSATISFIED%'
585: AND model_id = p_dev_project_id
586: AND ui_def_id IN ( SELECT ui_def_id FROM cz_ui_defs

Line 583: ,fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%',fnd_global.local_chr(38)||'USERINPUTREQUIREDINSUBTREE')

579:
580:
581: Update cz_localized_texts
582: set localized_str=REPLACE(REPLACE(REPLACE(localized_str,fnd_global.local_chr(38)||'NODEUNSATISFIED',fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'UNSATISFIED%'
583: ,fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%',fnd_global.local_chr(38)||'USERINPUTREQUIREDINSUBTREE')
584: WHERE UPPER(localized_str) LIKE '%'||fnd_global.local_chr(38)||'%UNSATISFIED%'
585: AND model_id = p_dev_project_id
586: AND ui_def_id IN ( SELECT ui_def_id FROM cz_ui_defs
587: WHERE deleted_flag='0' AND cz_localized_texts.ui_def_id = ui_def_id

Line 584: WHERE UPPER(localized_str) LIKE '%'||fnd_global.local_chr(38)||'%UNSATISFIED%'

580:
581: Update cz_localized_texts
582: set localized_str=REPLACE(REPLACE(REPLACE(localized_str,fnd_global.local_chr(38)||'NODEUNSATISFIED',fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'UNSATISFIED%'
583: ,fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%',fnd_global.local_chr(38)||'USERINPUTREQUIREDINSUBTREE')
584: WHERE UPPER(localized_str) LIKE '%'||fnd_global.local_chr(38)||'%UNSATISFIED%'
585: AND model_id = p_dev_project_id
586: AND ui_def_id IN ( SELECT ui_def_id FROM cz_ui_defs
587: WHERE deleted_flag='0' AND cz_localized_texts.ui_def_id = ui_def_id
588: AND devl_project_id=p_dev_project_id

Line 685: and text_str like '%'||fnd_global.local_chr(38)||upper(ru.name)||'%'

681: FOR v_ui IN
682: (select intl.ui_def_id , ru.name lceprop , REPLACE(REPLACE('Definition'||ru.name ,'DefinitionMaxSelected','DefinitionMaxSelections'),'DefinitionMinSelected','DefinitionMinSelections') fceprop, intl.ui_page_element_id
683: from cz_intl_texts intl, cz_ui_defs ui , cz_rules ru where
684: ru.rule_id in (894,818,812,893,817,811,813,814,815,816)
685: and text_str like '%'||fnd_global.local_chr(38)||upper(ru.name)||'%'
686: and intl.ui_def_id = ui.ui_def_id
687: and intl.deleted_flag='0'
688: and ui.deleted_flag='0'
689: and intl.model_id =ui.devl_project_id

Line 699: UPDATE cz_localized_texts intl SET localized_str = REPLACE(REPLACE(REPLACE(REPLACE(localized_str , ' '||fnd_global.local_chr(38)||'MIN' , ' '||fnd_global.local_chr(38)||'DEFINITIONMIN')

695: displayMessage(2,p_dev_project_id , 'UIE' ,GET_UI_ELEMENT_ID(v_ui.ui_page_element_id),l_api_name,'CZ_CNV_WARN_DIFF_SYSPROP','PROPERTYNAME_1' , v_ui.lceprop,'EXPRESSION_OR_CONDITION' ,' Text Expression ' ,'PROPERTYNAME_2' ,v_ui.fceprop);
696: END LOOP;
697:
698:
699: UPDATE cz_localized_texts intl SET localized_str = REPLACE(REPLACE(REPLACE(REPLACE(localized_str , ' '||fnd_global.local_chr(38)||'MIN' , ' '||fnd_global.local_chr(38)||'DEFINITIONMIN')
700: ,' '||fnd_global.local_chr(38)||'MAX' , ' '||fnd_global.local_chr(38)||'DEFINITIONMAX'),'DEFINITIONMAXSELECTED','DEFINITIONMAXSELECTIONS'),'DEFINITIONMINSELECTED','DEFINITIONMINSELECTIONS')
701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )
702: AND model_id = p_dev_project_id
703: AND EXISTS (

Line 700: ,' '||fnd_global.local_chr(38)||'MAX' , ' '||fnd_global.local_chr(38)||'DEFINITIONMAX'),'DEFINITIONMAXSELECTED','DEFINITIONMAXSELECTIONS'),'DEFINITIONMINSELECTED','DEFINITIONMINSELECTIONS')

696: END LOOP;
697:
698:
699: UPDATE cz_localized_texts intl SET localized_str = REPLACE(REPLACE(REPLACE(REPLACE(localized_str , ' '||fnd_global.local_chr(38)||'MIN' , ' '||fnd_global.local_chr(38)||'DEFINITIONMIN')
700: ,' '||fnd_global.local_chr(38)||'MAX' , ' '||fnd_global.local_chr(38)||'DEFINITIONMAX'),'DEFINITIONMAXSELECTED','DEFINITIONMAXSELECTIONS'),'DEFINITIONMINSELECTED','DEFINITIONMINSELECTIONS')
701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )
702: AND model_id = p_dev_project_id
703: AND EXISTS (
704: SELECT 1 FROM cz_rules WHERE rule_id IN (894,818,812,893,817,811,813,814,815,816)

Line 705: AND localized_str LIKE '%'||fnd_global.local_chr(38)||upper(name)||'%' )

701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )
702: AND model_id = p_dev_project_id
703: AND EXISTS (
704: SELECT 1 FROM cz_rules WHERE rule_id IN (894,818,812,893,817,811,813,814,815,816)
705: AND localized_str LIKE '%'||fnd_global.local_chr(38)||upper(name)||'%' )
706: AND deleted_flag='0';
707:
708:
709: