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.AZ_R12_TRANSFORM_CASCADE dependencies on FND_LOG

Line 72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

68: v_source_List TYP_NEST_TAB_VARCHAR;
69: BEGIN
70:
71: -- For logging
72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);

Line 73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');

69: BEGIN
70:
71: -- For logging
72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);

Line 74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);

70:
71: -- For logging
72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);

Line 75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);

71: -- For logging
72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);

Line 76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);

72: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
80: END IF;

Line 77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);

73: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'In apply_transform_to_tree procedure');
74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
80: END IF;
81: -- For logging

Line 78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);

74: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
80: END IF;
81: -- For logging
82:

Line 79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);

75: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
76: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
77: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
78: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
79: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
80: END IF;
81: -- For logging
82:
83: DIFF_SCHEMA_URL := p_diff_schema_url;

Line 116: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

112: END LOOP;
113: COMMIT;
114:
115: -- For logging
116: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
117: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ' || to_char(systimestamp), 'apply_transform_to_tree procedure is completed');
118: END IF;
119: -- For logging
120:

Line 117: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ' || to_char(systimestamp), 'apply_transform_to_tree procedure is completed');

113: COMMIT;
114:
115: -- For logging
116: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
117: fnd_log.string(fnd_log.level_statement, c_log_head || 'apply_transform_to_tree : ' || to_char(systimestamp), 'apply_transform_to_tree procedure is completed');
118: END IF;
119: -- For logging
120:
121: EXCEPTION

Line 171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

167:
168: BEGIN
169:
170: -- For logging
171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);

Line 172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');

168: BEGIN
169:
170: -- For logging
171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);

Line 173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);

169:
170: -- For logging
171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);

Line 174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);

170: -- For logging
171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
178: END IF;

Line 175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);

171: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
178: END IF;
179: -- For logging

Line 176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);

172: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'In APPLY_TRANSFORM procedure');
173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
178: END IF;
179: -- For logging
180:

Line 177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);

173: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUEST_ID ---> '||P_REQUEST_ID);
174: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_API_CODE ---> '||P_REQUIRED_API_CODE);
175: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_DEPENDANT_API_CODE ---> '||P_DEPENDANT_API_CODE);
176: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'P_REQUIRED_SOURCE ---> '||P_REQUIRED_SOURCE);
177: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'p_dependant_eo_code ---> '||p_dependant_eo_code);
178: END IF;
179: -- For logging
180:
181:

Line 214: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

210: AND D.TYPE <> -1
211: AND existsNode(VALUE(E),'/V[@A2="Y"]') = 1;
212:
213: -- For logging
214: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
215: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_CHECK_TRFM_ALL_FLAG --> ' || V_CHECK_TRFM_ALL_FLAG);
216: END IF;
217: -- For logging
218:

Line 215: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_CHECK_TRFM_ALL_FLAG --> ' || V_CHECK_TRFM_ALL_FLAG);

211: AND existsNode(VALUE(E),'/V[@A2="Y"]') = 1;
212:
213: -- For logging
214: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
215: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_CHECK_TRFM_ALL_FLAG --> ' || V_CHECK_TRFM_ALL_FLAG);
216: END IF;
217: -- For logging
218:
219: ---

Line 284: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

280:
281: V_DEPENDANT_CHILD_IDS_SQL := V_DEPENDANT_IDS_SQL || ' ';
282:
283: -- For logging
284: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
285: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_ATTR_NAME_LIST Count --> ' || V_REQ_API_ATTR_NAME_LIST.COUNT);
286: END IF;
287: -- For logging
288:

Line 285: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_ATTR_NAME_LIST Count --> ' || V_REQ_API_ATTR_NAME_LIST.COUNT);

281: V_DEPENDANT_CHILD_IDS_SQL := V_DEPENDANT_IDS_SQL || ' ';
282:
283: -- For logging
284: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
285: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_ATTR_NAME_LIST Count --> ' || V_REQ_API_ATTR_NAME_LIST.COUNT);
286: END IF;
287: -- For logging
288:
289: FOR J IN 1 .. V_REQ_API_ATTR_NAME_LIST.COUNT LOOP

Line 293: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

289: FOR J IN 1 .. V_REQ_API_ATTR_NAME_LIST.COUNT LOOP
290:
291: BEGIN
292: -- For logging
293: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
294: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For attribute name --> ' || V_REQ_API_ATTR_NAME_LIST(J));
295: END IF;
296: -- For logging
297:

Line 294: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For attribute name --> ' || V_REQ_API_ATTR_NAME_LIST(J));

290:
291: BEGIN
292: -- For logging
293: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
294: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For attribute name --> ' || V_REQ_API_ATTR_NAME_LIST(J));
295: END IF;
296: -- For logging
297:
298: V_REQ_API_API_ATTR_NAME := V_REQ_API_ATTR_NAME_LIST(J);

Line 307: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

303:
304: V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL||' ( ';
305:
306: -- For logging
307: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
308: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_MAP_ATTR_NAME_LIST Count --> ' || V_REQ_API_MAP_ATTR_NAME_LIST.COUNT);
309: END IF;
310: -- For logging
311:

Line 308: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_MAP_ATTR_NAME_LIST Count --> ' || V_REQ_API_MAP_ATTR_NAME_LIST.COUNT);

304: V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL||' ( ';
305:
306: -- For logging
307: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
308: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_REQ_API_MAP_ATTR_NAME_LIST Count --> ' || V_REQ_API_MAP_ATTR_NAME_LIST.COUNT);
309: END IF;
310: -- For logging
311:
312: --Introduced to take care of one-many mappings between mapped attributes

Line 430: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

426: --V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL||' 1=1 ';
427: V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL||' 1=1 AND PARENT_ID=1 ';
428:
429: -- For logging
430: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
431: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_SQL --> ' || V_DEPENDANT_IDS_SQL);
432: END IF;
433: -- For logging
434:

Line 431: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_SQL --> ' || V_DEPENDANT_IDS_SQL);

427: V_DEPENDANT_IDS_SQL := V_DEPENDANT_IDS_SQL||' 1=1 AND PARENT_ID=1 ';
428:
429: -- For logging
430: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
431: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_SQL --> ' || V_DEPENDANT_IDS_SQL);
432: END IF;
433: -- For logging
434:
435: EXECUTE IMMEDIATE V_DEPENDANT_IDS_SQL BULK COLLECT

Line 439: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

435: EXECUTE IMMEDIATE V_DEPENDANT_IDS_SQL BULK COLLECT
436: INTO V_DEPENDANT_IDS_LIST;
437:
438: -- For logging
439: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
440: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_LIST Count --> ' || V_DEPENDANT_IDS_LIST.COUNT);
441: END IF;
442: -- For logging
443:

Line 440: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_LIST Count --> ' || V_DEPENDANT_IDS_LIST.COUNT);

436: INTO V_DEPENDANT_IDS_LIST;
437:
438: -- For logging
439: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
440: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_IDS_LIST Count --> ' || V_DEPENDANT_IDS_LIST.COUNT);
441: END IF;
442: -- For logging
443:
444: V_EXISTSNODE_NAMEVAL_STR := V_EXISTSNODE_NAMEVAL_STR|| ' 1<>1 )';

Line 448: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

444: V_EXISTSNODE_NAMEVAL_STR := V_EXISTSNODE_NAMEVAL_STR|| ' 1<>1 )';
445:
446: FOR K IN 1 .. V_DEPENDANT_IDS_LIST.COUNT LOOP
447: -- For logging
448: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
449: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K)--> ' || V_DEPENDANT_IDS_LIST(K));
450: END IF;
451: -- For logging
452: V_TRANSFORM_SQL := GET_TRANSFORM_SQL(P_REQUEST_ID,

Line 449: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K)--> ' || V_DEPENDANT_IDS_LIST(K));

445:
446: FOR K IN 1 .. V_DEPENDANT_IDS_LIST.COUNT LOOP
447: -- For logging
448: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
449: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K)--> ' || V_DEPENDANT_IDS_LIST(K));
450: END IF;
451: -- For logging
452: V_TRANSFORM_SQL := GET_TRANSFORM_SQL(P_REQUEST_ID,
453: P_DEPENDANT_SOURCE,

Line 462: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

458:
459: V_TRANSFORM_SQL := V_TRANSFORM_SQL||V_EXISTSNODE_NAMEVAL_STR;
460:
461: -- For logging
462: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);
464: END IF;
465: -- For logging
466:

Line 463: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);

459: V_TRANSFORM_SQL := V_TRANSFORM_SQL||V_EXISTSNODE_NAMEVAL_STR;
460:
461: -- For logging
462: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);
464: END IF;
465: -- For logging
466:
467: EXECUTE IMMEDIATE V_TRANSFORM_SQL;

Line 491: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

487:
488: V_DEP_DETAIL_CHILD_IDS_SQL := V_DEPENDANT_CHILD_IDS_SQL || V_DEP_DETAIL_CHILD_IDS_SQL;
489:
490: -- For logging
491: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
492: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEP_DETAIL_CHILD_IDS_SQL --> ' || V_DEP_DETAIL_CHILD_IDS_SQL);
493: END IF;
494: -- For logging
495:

Line 492: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEP_DETAIL_CHILD_IDS_SQL --> ' || V_DEP_DETAIL_CHILD_IDS_SQL);

488: V_DEP_DETAIL_CHILD_IDS_SQL := V_DEPENDANT_CHILD_IDS_SQL || V_DEP_DETAIL_CHILD_IDS_SQL;
489:
490: -- For logging
491: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
492: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEP_DETAIL_CHILD_IDS_SQL --> ' || V_DEP_DETAIL_CHILD_IDS_SQL);
493: END IF;
494: -- For logging
495:
496: EXECUTE IMMEDIATE V_DEP_DETAIL_CHILD_IDS_SQL BULK COLLECT

Line 499: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

495:
496: EXECUTE IMMEDIATE V_DEP_DETAIL_CHILD_IDS_SQL BULK COLLECT
497: INTO V_DEPENDANT_CHILD_IDS_LIST;
498: -- For logging
499: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
500: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_CHILD_IDS_LIST Count --> ' || V_DEPENDANT_CHILD_IDS_LIST.COUNT);
501: END IF;
502: -- For logging
503: FOR Z IN 1 .. V_DEPENDANT_CHILD_IDS_LIST.COUNT LOOP

Line 500: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_CHILD_IDS_LIST Count --> ' || V_DEPENDANT_CHILD_IDS_LIST.COUNT);

496: EXECUTE IMMEDIATE V_DEP_DETAIL_CHILD_IDS_SQL BULK COLLECT
497: INTO V_DEPENDANT_CHILD_IDS_LIST;
498: -- For logging
499: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
500: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_DEPENDANT_CHILD_IDS_LIST Count --> ' || V_DEPENDANT_CHILD_IDS_LIST.COUNT);
501: END IF;
502: -- For logging
503: FOR Z IN 1 .. V_DEPENDANT_CHILD_IDS_LIST.COUNT LOOP
504: -- For logging

Line 505: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

501: END IF;
502: -- For logging
503: FOR Z IN 1 .. V_DEPENDANT_CHILD_IDS_LIST.COUNT LOOP
504: -- For logging
505: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
506: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_CHILD_IDS_LIST(Z)--> ' || V_DEPENDANT_CHILD_IDS_LIST(Z));
507: END IF;
508: -- For logging
509: V_TRANSFORM_SQL := GET_TRANSFORM_SQL(P_REQUEST_ID,

Line 506: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_CHILD_IDS_LIST(Z)--> ' || V_DEPENDANT_CHILD_IDS_LIST(Z));

502: -- For logging
503: FOR Z IN 1 .. V_DEPENDANT_CHILD_IDS_LIST.COUNT LOOP
504: -- For logging
505: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
506: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_CHILD_IDS_LIST(Z)--> ' || V_DEPENDANT_CHILD_IDS_LIST(Z));
507: END IF;
508: -- For logging
509: V_TRANSFORM_SQL := GET_TRANSFORM_SQL(P_REQUEST_ID,
510: P_DEPENDANT_SOURCE,

Line 514: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

510: P_DEPENDANT_SOURCE,
511: V_CHILD_XSL_STRING,
512: V_DEPENDANT_CHILD_IDS_LIST(Z),'N');
513: -- For logging
514: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
515: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);
516: END IF;
517: -- For logging
518:

Line 515: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);

511: V_CHILD_XSL_STRING,
512: V_DEPENDANT_CHILD_IDS_LIST(Z),'N');
513: -- For logging
514: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
515: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'V_TRANSFORM_SQL --> ' || V_TRANSFORM_SQL);
516: END IF;
517: -- For logging
518:
519: EXECUTE IMMEDIATE V_TRANSFORM_SQL;

Line 530: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

526: ||' AND q.request_id = '||P_REQUEST_ID||
527: ' AND ' || V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
528:
529: -- For logging
530: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
531: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_TEMP_SQL --> ' || V_TEMP_SQL);
532: END IF;
533: -- For logging
534:

Line 531: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_TEMP_SQL --> ' || V_TEMP_SQL);

527: ' AND ' || V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
528:
529: -- For logging
530: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
531: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_TEMP_SQL --> ' || V_TEMP_SQL);
532: END IF;
533: -- For logging
534:
535:

Line 545: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

541: WHERE d.request_id = P_REQUEST_ID
542: AND d.source = p_dependant_source
543: ) f START WITH f.id = V_DEPENDANT_IDS_LIST(K) CONNECT BY PRIOR f.id = f.parent_id) ;
544: -- For logging
545: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
546: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_CONFLICT_CHILD_IDS_LIST.COUNT --> ' || V_CONFLICT_CHILD_IDS_LIST.COUNT);
547: END IF;
548: -- For logging
549:

Line 546: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_CONFLICT_CHILD_IDS_LIST.COUNT --> ' || V_CONFLICT_CHILD_IDS_LIST.COUNT);

542: AND d.source = p_dependant_source
543: ) f START WITH f.id = V_DEPENDANT_IDS_LIST(K) CONNECT BY PRIOR f.id = f.parent_id) ;
544: -- For logging
545: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
546: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_DEPENDANT_IDS_LIST(K) --> ' || V_DEPENDANT_IDS_LIST(K)||'V_CONFLICT_CHILD_IDS_LIST.COUNT --> ' || V_CONFLICT_CHILD_IDS_LIST.COUNT);
547: END IF;
548: -- For logging
549:
550: FOR Y IN 1 .. V_CONFLICT_CHILD_IDS_LIST.COUNT LOOP

Line 557: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

553: ||' AND q.request_id = '||P_REQUEST_ID||
554: ' AND '|| V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
555:
556: -- For logging
557: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
558: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_CONFLICT_CHILD_IDS_LIST(Y) --> ' || V_CONFLICT_CHILD_IDS_LIST(Y)||' V_TEMP_SQL --> ' || V_TEMP_SQL);
559: END IF;
560: -- For logging
561:

Line 558: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_CONFLICT_CHILD_IDS_LIST(Y) --> ' || V_CONFLICT_CHILD_IDS_LIST(Y)||' V_TEMP_SQL --> ' || V_TEMP_SQL);

554: ' AND '|| V_EXISTSNODE_STRING || ' q.source = '''||p_dependant_source||'''';
555:
556: -- For logging
557: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
558: fnd_log.string(fnd_log.level_statement, c_log_head || 'APPLY_TRANSFORM : ', 'For V_CONFLICT_CHILD_IDS_LIST(Y) --> ' || V_CONFLICT_CHILD_IDS_LIST(Y)||' V_TEMP_SQL --> ' || V_TEMP_SQL);
559: END IF;
560: -- For logging
561:
562:

Line 811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

807:
808: BEGIN
809:
810: -- For logging
811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);

Line 812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');

808: BEGIN
809:
810: -- For logging
811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);

Line 813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);

809:
810: -- For logging
811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);
817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);

Line 814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);

810: -- For logging
811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);
817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
818: END IF;

Line 815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);

811: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);
817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
818: END IF;
819: -- For logging

Line 816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);

812: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'In transform_all procedure ...');
813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);
817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
818: END IF;
819: -- For logging
820:

Line 817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);

813: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_job_name ---> '||p_job_name);
814: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_user_id ---> '||p_user_id);
815: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_source ---> '||p_source);
816: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_is_cascade ---> '||p_is_cascade);
817: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'p_diff_schema_url ---> '||p_diff_schema_url);
818: END IF;
819: -- For logging
820:
821: diff_schema_url := p_diff_schema_url;

Line 877: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

873: AND user_id = p_user_id
874: AND request_type = 'T';
875:
876: -- For logging
877: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
878: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'v_eo_code_list.COUNT --> '||v_eo_code_list.COUNT);
879: END IF;
880: -- For logging
881:

Line 878: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'v_eo_code_list.COUNT --> '||v_eo_code_list.COUNT);

874: AND request_type = 'T';
875:
876: -- For logging
877: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
878: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'v_eo_code_list.COUNT --> '||v_eo_code_list.COUNT);
879: END IF;
880: -- For logging
881:
882: FOR i IN 1 .. v_eo_code_list.COUNT

Line 935: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

931: p_request_id,
932: v_source_list(i));
933:
934: -- For logging
935: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
936: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'For --> '||v_source_list(i)||' v_transform_all_sql ---> '||v_transform_all_sql );
937: END IF;
938: -- For logging
939:

Line 936: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'For --> '||v_source_list(i)||' v_transform_all_sql ---> '||v_transform_all_sql );

932: v_source_list(i));
933:
934: -- For logging
935: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
936: fnd_log.string(fnd_log.level_statement, c_log_head || 'transform_all : ', 'For --> '||v_source_list(i)||' v_transform_all_sql ---> '||v_transform_all_sql );
937: END IF;
938: -- For logging
939:
940: EXECUTE IMMEDIATE v_transform_all_sql using V_UPDATE_XSL;

Line 1231: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1227: v_message VARCHAR2(2048);
1228:
1229: BEGIN
1230:
1231: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1232: fnd_message.set_name('AZ', 'AZ_R12_PLSQL_EXCEPTION');
1233: -- Seeded Message
1234: -- Runtime Information
1235: fnd_message.set_token('ERROR_CODE', errcode);