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.OTA_UTILITY dependencies on FND_FILE

Line 2950: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Get_Default_Value_Dff');

2946: END Get_Contexts;
2947:
2948:
2949: BEGIN
2950: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Get_Default_Value_Dff');
2951: IF p_attribute_category IS NOT NULL
2952: OR p_attribute1 IS NOT NULL
2953: OR p_attribute2 IS NOT NULL
2954: OR p_attribute3 IS NOT NULL

Line 2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');

2970: OR p_attribute19 IS NOT NULL
2971: OR p_attribute20 IS NOT NULL THEN RETURN;
2972:
2973: END IF;
2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);
2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);
2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);

Line 2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);

2971: OR p_attribute20 IS NOT NULL THEN RETURN;
2972:
2973: END IF;
2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);
2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);
2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:

Line 2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);

2972:
2973: END IF;
2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);
2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);
2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:
2980: Get_Flexfield;

Line 2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);

2973: END IF;
2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);
2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);
2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:
2980: Get_Flexfield;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);

Line 2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);

2974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Get_Flexfield');
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,'appl_short_name'||appl_short_name);
2976: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexfield'||p_flexfield);
2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:
2980: Get_Flexfield;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);
2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);

Line 2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);

2977: FND_FILE.PUT_LINE(FND_FILE.LOG,'flex_field_name'||flex_field_name);
2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:
2980: Get_Flexfield;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);
2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before GET_CONTEXTS');
2984: GET_CONTEXTS;
2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');

Line 2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);

2978: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_flexinfo'||p_flexinfo);
2979:
2980: Get_Flexfield;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);
2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before GET_CONTEXTS');
2984: GET_CONTEXTS;
2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');
2986:

Line 2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before GET_CONTEXTS');

2979:
2980: Get_Flexfield;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);
2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before GET_CONTEXTS');
2984: GET_CONTEXTS;
2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');
2986:
2987: p_attribute_category := p_flexinfo.default_context_value;

Line 2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');

2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_flexfield'||p_flexfield);
2982: --FND_FILE.PUT_LINE(FND_FILE.LOG,'p_contexts'||p_contexts);
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before GET_CONTEXTS');
2984: GET_CONTEXTS;
2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');
2986:
2987: p_attribute_category := p_flexinfo.default_context_value;
2988:
2989: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_attribute_category :'||p_attribute_category);

Line 2989: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_attribute_category :'||p_attribute_category);

2985: FND_FILE.PUT_LINE(FND_FILE.LOG,'After GET_CONTEXTS');
2986:
2987: p_attribute_category := p_flexinfo.default_context_value;
2988:
2989: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_attribute_category :'||p_attribute_category);
2990: FOR k in 1 .. p_contexts.ncontexts LOOP
2991:
2992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside FOR k in 1 .. p_contexts.ncontexts LOOP'||k);
2993: IF p_contexts.is_global(k)

Line 2992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside FOR k in 1 .. p_contexts.ncontexts LOOP'||k);

2988:
2989: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_attribute_category :'||p_attribute_category);
2990: FOR k in 1 .. p_contexts.ncontexts LOOP
2991:
2992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside FOR k in 1 .. p_contexts.ncontexts LOOP'||k);
2993: IF p_contexts.is_global(k)
2994: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
2995:
2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');

Line 2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');

2992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside FOR k in 1 .. p_contexts.ncontexts LOOP'||k);
2993: IF p_contexts.is_global(k)
2994: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
2995:
2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');
2997: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
2998: ,p_segments
2999: ,TRUE);
3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');

Line 3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');

2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');
2997: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
2998: ,p_segments
2999: ,TRUE);
3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');
3001:
3002: FOR j IN 1 .. p_segments.nsegments LOOP
3003: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside FOR j IN 1 .. p_segments.nsegments LOOP'||j);
3004:

Line 3003: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside FOR j IN 1 .. p_segments.nsegments LOOP'||j);

2999: ,TRUE);
3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');
3001:
3002: FOR j IN 1 .. p_segments.nsegments LOOP
3003: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside FOR j IN 1 .. p_segments.nsegments LOOP'||j);
3004:
3005: l_appl_col_name := p_segments.application_column_name(j);
3006: tempstr := substr(l_appl_col_name, length(l_appl_col_name) -1);
3007: firstchar := ascii(substr(tempstr,1,2));

Line 3008: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_appl_col_name'||l_appl_col_name);

3004:
3005: l_appl_col_name := p_segments.application_column_name(j);
3006: tempstr := substr(l_appl_col_name, length(l_appl_col_name) -1);
3007: firstchar := ascii(substr(tempstr,1,2));
3008: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_appl_col_name'||l_appl_col_name);
3009: FND_FILE.PUT_LINE(FND_FILE.LOG,' tempstr'||tempstr);
3010: FND_FILE.PUT_LINE(FND_FILE.LOG,' firstchar'||firstchar);
3011:
3012: IF firstchar < 49 OR firstchar > 57 THEN

Line 3009: FND_FILE.PUT_LINE(FND_FILE.LOG,' tempstr'||tempstr);

3005: l_appl_col_name := p_segments.application_column_name(j);
3006: tempstr := substr(l_appl_col_name, length(l_appl_col_name) -1);
3007: firstchar := ascii(substr(tempstr,1,2));
3008: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_appl_col_name'||l_appl_col_name);
3009: FND_FILE.PUT_LINE(FND_FILE.LOG,' tempstr'||tempstr);
3010: FND_FILE.PUT_LINE(FND_FILE.LOG,' firstchar'||firstchar);
3011:
3012: IF firstchar < 49 OR firstchar > 57 THEN
3013: i := to_number(substr(tempstr,2,1));

Line 3010: FND_FILE.PUT_LINE(FND_FILE.LOG,' firstchar'||firstchar);

3006: tempstr := substr(l_appl_col_name, length(l_appl_col_name) -1);
3007: firstchar := ascii(substr(tempstr,1,2));
3008: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_appl_col_name'||l_appl_col_name);
3009: FND_FILE.PUT_LINE(FND_FILE.LOG,' tempstr'||tempstr);
3010: FND_FILE.PUT_LINE(FND_FILE.LOG,' firstchar'||firstchar);
3011:
3012: IF firstchar < 49 OR firstchar > 57 THEN
3013: i := to_number(substr(tempstr,2,1));
3014: ELSE

Line 3087: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exit Get_Default_Value_Dff');

3083: dbms_output.put_line('Attribute 18 '||p_attribute18);
3084: dbms_output.put_line('Attribute 19 '||p_attribute19);
3085: dbms_output.put_line('Attribute 20 '||p_attribute20);
3086: */
3087: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exit Get_Default_Value_Dff');
3088: END Get_Default_Value_Dff;
3089:
3090: PROCEDURE Get_Default_Value_Dff(
3091: appl_short_name IN VARCHAR2,