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

Line 1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');

1963:
1964:
1965: BEGIN
1966:
1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');
1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);

Line 1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1964:
1965: BEGIN
1966:
1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');
1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);

Line 1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');

1965: BEGIN
1966:
1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');
1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);
1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);

1966:
1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');
1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);
1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1974:

Line 1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);

1967: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARHCRTHI - Convert relationship type to hierarchical.');
1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);
1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1974:
1975: -- get all the relationships for this relationship type

Line 1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);

1968: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);
1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1974:
1975: -- get all the relationships for this relationship type
1976: OPEN c1;

Line 1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1969: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
1970: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship type : '||p_rel_type);
1971: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent allowed : '||p_multi_parent_allowed);
1972: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Include unrelated entities : '||p_incl_unrelated_entities);
1973: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1974:
1975: -- get all the relationships for this relationship type
1976: OPEN c1;
1977: FETCH c1 INTO r1;

Line 2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2024: -- no parent found, proceed
2025: NULL;
2026: WHEN TOO_MANY_ROWS then
2027: -- there is already a parent, so raise error
2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');
2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);
2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');

2025: NULL;
2026: WHEN TOO_MANY_ROWS then
2027: -- there is already a parent, so raise error
2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');
2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);
2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2033: l_conc_status := 'E';

Line 2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);

2026: WHEN TOO_MANY_ROWS then
2027: -- there is already a parent, so raise error
2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');
2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);
2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2033: l_conc_status := 'E';
2034: EXIT;

Line 2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);

2027: -- there is already a parent, so raise error
2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');
2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);
2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2033: l_conc_status := 'E';
2034: EXIT;
2035: END;

Line 2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Multiple parent found for the following child :');
2030: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Child ID : '||l_child_id);
2031: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Chiild Type : '||l_child_object_type);
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2033: l_conc_status := 'E';
2034: EXIT;
2035: END;
2036: END IF;

Line 2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2051: l_temp_parent_table_name := r_parent.subject_table_name;
2052: l_temp_parent_object_type := r_parent.subject_type;
2053: END IF;
2054: IF l_temp_parent_id = l_child_id THEN
2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);

Line 2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');

2052: l_temp_parent_object_type := r_parent.subject_type;
2053: END IF;
2054: IF l_temp_parent_id = l_child_id THEN
2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);

Line 2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);

2053: END IF;
2054: IF l_temp_parent_id = l_child_id THEN
2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);

Line 2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);

2054: IF l_temp_parent_id = l_child_id THEN
2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);
2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);

2055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);
2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2063: l_conc_status := 'E';

Line 2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);

2056: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Circularity exists for the following relationship record : ');
2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);
2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2063: l_conc_status := 'E';
2064: CLOSE c_parent;

Line 2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);

2057: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject ID : '||r1.subject_id);
2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);
2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2063: l_conc_status := 'E';
2064: CLOSE c_parent;
2065: EXIT;

Line 2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2058: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Subject Type : '||r1.subject_type);
2059: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object ID : '||r1.object_id);
2060: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Object Type : '||r1.object_type);
2061: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Relationship Code : '||r1.relationship_code);
2062: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2063: l_conc_status := 'E';
2064: CLOSE c_parent;
2065: EXIT;
2066: END IF;

Line 2132: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2128: CLOSE c1;
2129:
2130: IF l_conc_status = 'E' THEN
2131: ROLLBACK;
2132: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2133: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Conversion of relationship type to hierarchical failed. ');
2134: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2135: ELSE
2136: UPDATE HZ_RELATIONSHIP_TYPES

Line 2133: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Conversion of relationship type to hierarchical failed. ');

2129:
2130: IF l_conc_status = 'E' THEN
2131: ROLLBACK;
2132: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2133: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Conversion of relationship type to hierarchical failed. ');
2134: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2135: ELSE
2136: UPDATE HZ_RELATIONSHIP_TYPES
2137: SET HIERARCHICAL_FLAG = 'Y',

Line 2134: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2130: IF l_conc_status = 'E' THEN
2131: ROLLBACK;
2132: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2133: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Conversion of relationship type to hierarchical failed. ');
2134: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2135: ELSE
2136: UPDATE HZ_RELATIONSHIP_TYPES
2137: SET HIERARCHICAL_FLAG = 'Y',
2138: MULTIPLE_PARENT_ALLOWED = NVL(p_multi_parent_allowed, 'N'),

Line 2142: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2138: MULTIPLE_PARENT_ALLOWED = NVL(p_multi_parent_allowed, 'N'),
2139: INCL_UNRELATED_ENTITIES = NVL(p_incl_unrelated_entities, 'N')
2140: WHERE RELATIONSHIP_TYPE = p_rel_type;
2141:
2142: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2143: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Successfully converted relationship type to hierarchical. ');
2144: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2145: COMMIT;
2146: END IF;

Line 2143: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Successfully converted relationship type to hierarchical. ');

2139: INCL_UNRELATED_ENTITIES = NVL(p_incl_unrelated_entities, 'N')
2140: WHERE RELATIONSHIP_TYPE = p_rel_type;
2141:
2142: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2143: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Successfully converted relationship type to hierarchical. ');
2144: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2145: COMMIT;
2146: END IF;
2147:

Line 2144: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2140: WHERE RELATIONSHIP_TYPE = p_rel_type;
2141:
2142: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2143: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Successfully converted relationship type to hierarchical. ');
2144: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2145: COMMIT;
2146: END IF;
2147:
2148: END convert_rel_type;