APPS.FND_PROFILE dependencies on DBMS_UTILITY

Line 87: start_time NUMBER := dbms_utility.get_time;

83: /*
84: ** Global variable that stores the start time of initial
85: ** FND_PROFILE use
86: */
87: start_time NUMBER := dbms_utility.get_time;
88:
89: /*========================================================================
90: | Private APIs
91: ========================================================================*/

Line 119: to_char(dbms_utility.get_time - start_time,

115: respId,
116: applId,
117: orgId,
118: serverId,
119: to_char(dbms_utility.get_time - start_time,
120: '999,999,999.99') || ' ms.');
121: END IF;
122: END corelog;
123:

Line 138: to_char(dbms_utility.get_time - start_time,

134: BEGIN
135: IF corelog_is_enabled THEN
136: IF profile_to_log IS NULL THEN
137: fnd_core_log.put_line(profileName || ':' || textLine || ':' ||
138: to_char(dbms_utility.get_time - start_time,
139: '999,999,999.99') || ' ms.');
140: ELSE
141: IF profileName = profile_to_log THEN
142: fnd_core_log.put_line(profileName || ':' || textLine || ':' ||

Line 143: to_char(dbms_utility.get_time - start_time,

139: '999,999,999.99') || ' ms.');
140: ELSE
141: IF profileName = profile_to_log THEN
142: fnd_core_log.put_line(profileName || ':' || textLine || ':' ||
143: to_char(dbms_utility.get_time - start_time,
144: '999,999,999.99') || ' ms.');
145: END IF;
146: END IF;
147: END IF;

Line 158: to_char(dbms_utility.get_time - start_time,

154: PROCEDURE corelog_line(textLine IN VARCHAR2) IS
155: BEGIN
156: IF corelog_is_enabled THEN
157: fnd_core_log.put_line(textLine || ':' ||
158: to_char(dbms_utility.get_time - start_time,
159: '999,999,999.99') || ' ms.');
160: END IF;
161: END corelog_line;
162:

Line 666: tableIndex := dbms_utility.get_hash_value(profileName,

662: BEGIN
663: -- Check if a hash value was provided. If not, generate one given the
664: -- profile option name and the table size
665: IF (profileHashValue IS NULL) THEN
666: tableIndex := dbms_utility.get_hash_value(profileName,
667: 1,
668: table_size);
669: ELSE
670: tableIndex := profileHashValue;

Line 749: dbms_utility.get_hash_value(profileName, 1, table_size));

745: BEGIN
746: -- bug 14773322 - find index variable to check for deleted value
747: tab_index := find(profileName,
748: name_tab,
749: dbms_utility.get_hash_value(profileName, 1, table_size));
750: -- bug 14773322 - check for valid index of profile name with deleted value
751: IF (tab_index < table_size AND
752: val_tab(tab_index) = fnd_delete_value) THEN
753: -- The entry doesn't exist

Line 794: tableIndex := dbms_utility.get_hash_value(profileName,

790: -- Log API entry
791: corelog(profileName, profileValue, 'Enter PUT');
792:
793: IF (profileHashValue IS NULL) THEN
794: tableIndex := dbms_utility.get_hash_value(profileName,
795: 1,
796: table_size);
797: ELSE
798: tableIndex := profileHashValue;

Line 893: corelog_line(dbms_utility.format_error_stack);

889: -- even if profile filter is not enabled
890: corelog_line(profileName || ':' || profileValue ||':' ||
891: 'PUT raised exception. SQLCODE:' || SQLCODE);
892: -- output exception to corelog
893: corelog_line(dbms_utility.format_error_stack);
894: -- output error line numbers to corelog
895: corelog_line(dbms_utility.format_error_backtrace);
896:
897: END put;

Line 895: corelog_line(dbms_utility.format_error_backtrace);

891: 'PUT raised exception. SQLCODE:' || SQLCODE);
892: -- output exception to corelog
893: corelog_line(dbms_utility.format_error_stack);
894: -- output error line numbers to corelog
895: corelog_line(dbms_utility.format_error_backtrace);
896:
897: END put;
898:
899: /*

Line 1554: dbms_utility.get_hash_value(profileNameUpper, 1, table_size));

1550: put(profileNameUpper,
1551: val,
1552: name_tab,
1553: val_tab,
1554: dbms_utility.get_hash_value(profileNameUpper, 1, table_size));
1555: -- Log API Exit
1556: corelog(profileNameUpper, val, 'Exit Public PUT Count=' || inserted);
1557: END put;
1558:

Line 2458: corelog_line(dbms_utility.format_error_stack);

2454: WHEN OTHERS THEN
2455: -- add a corelog dump on exception
2456: corelog_line('GET_ALL_TABLE_VALUES raised exception. SQLCODE:' || SQLCODE);
2457: -- output exception to corelog
2458: corelog_line(dbms_utility.format_error_stack);
2459: -- output error line numbers to corelog
2460: corelog_line(dbms_utility.format_call_stack);
2461: RETURN NULL;
2462:

Line 2460: corelog_line(dbms_utility.format_call_stack);

2456: corelog_line('GET_ALL_TABLE_VALUES raised exception. SQLCODE:' || SQLCODE);
2457: -- output exception to corelog
2458: corelog_line(dbms_utility.format_error_stack);
2459: -- output error line numbers to corelog
2460: corelog_line(dbms_utility.format_call_stack);
2461: RETURN NULL;
2462:
2463: END get_all_table_values;
2464: