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.ITG_SYNCCOAINBOUND_PVT dependencies on ITG_DEBUG

Line 138: itg_debug_pub.Add('ENTERING Add_FlexValue',2);

134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: IF (l_Debug_Level <= 2) THEN
138: itg_debug_pub.Add('ENTERING Add_FlexValue',2);
139: END IF;
140:
141: BEGIN
142: ITG_Debug.setup(

Line 142: ITG_Debug.setup(

138: itg_debug_pub.Add('ENTERING Add_FlexValue',2);
139: END IF;
140:
141: BEGIN
142: ITG_Debug.setup(
143: p_reset => TRUE,
144: p_pkg_name => G_PKG_NAME,
145: p_proc_name => l_api_name);
146:

Line 150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);

146:
147: g_action := 'Flex-value Insert';
148:
149: IF (l_Debug_Level <= 1) THEN
150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);
151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);

Line 151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);

147: g_action := 'Flex-value Insert';
148:
149: IF (l_Debug_Level <= 1) THEN
150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);
151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);

Line 152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);

148:
149: IF (l_Debug_Level <= 1) THEN
150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);
151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);

Line 153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);

149: IF (l_Debug_Level <= 1) THEN
150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);
151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);

Line 154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);

150: itg_debug_pub.Add('AFV - Top of procedure.' ,1);
151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);
158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);

Line 155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);

151: itg_debug_pub.Add('AFV - p_flex_value' ||p_flex_value ,1);
152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);
158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);
159: END IF;

Line 156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);

152: itg_debug_pub.Add('AFV - p_vset_id' ||p_vset_id ,1);
153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);
158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);
159: END IF;
160:

Line 157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);

153: itg_debug_pub.Add('AFV - p_flex_desc' ||p_flex_desc ,1);
154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);
158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);
159: END IF;
160:
161: DECLARE

Line 158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);

154: itg_debug_pub.Add('AFV - p_creation_date' ||p_creation_date ,1);
155: itg_debug_pub.Add('AFV - p_effective_date' ||p_effective_date ,1);
156: itg_debug_pub.Add('AFV - p_expiration_date' ||p_expiration_date,1);
157: itg_debug_pub.Add('AFV - p_acct_type' ||p_acct_type ,1);
158: itg_debug_pub.Add('AFV - p_enabled_flag' ||p_enabled_flag ,1);
159: END IF;
160:
161: DECLARE
162: l_param_name VARCHAR2(30) := NULL;

Line 231: itg_debug_pub.Add('Inserting flex value row.' ,1);

227: l_creation_date := nvl(p_creation_date, SYSDATE);
228:
229: BEGIN
230: IF (l_Debug_Level <= 1) THEN
231: itg_debug_pub.Add('Inserting flex value row.' ,1);
232: END IF;
233:
234: g_action := 'Flex-value insert';
235: FND_FLEX_VALUES_PKG.insert_row(

Line 281: itg_debug_pub.Add('EXITING Add_FlexValue :NO_DATA_FOUND ' ,5);

277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: ITG_MSG.flex_insert_fail(p_flex_value);
280: IF (l_Debug_Level <= 5) THEN
281: itg_debug_pub.Add('EXITING Add_FlexValue :NO_DATA_FOUND ' ,5);
282: END IF;
283:
284: RAISE FND_API.G_EXC_ERROR;
285: END;

Line 288: itg_debug_pub.Add('EXITING Add_FlexValue' ,2);

284: RAISE FND_API.G_EXC_ERROR;
285: END;
286:
287: IF (l_Debug_Level <= 2) THEN
288: itg_debug_pub.Add('EXITING Add_FlexValue' ,2);
289: END IF;
290: END;
291: END Add_FlexValue;
292:

Line 318: itg_debug_pub.Add('ENTERING Change_FlexValue' ,2);

314: l_update_date DATE;
315: BEGIN
316:
317: IF (l_Debug_Level <= 2) THEN
318: itg_debug_pub.Add('ENTERING Change_FlexValue' ,2);
319: END IF;
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: g_action := 'Flex-value update';

Line 325: ITG_Debug.setup(

321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: g_action := 'Flex-value update';
323:
324: BEGIN
325: ITG_Debug.setup(
326: p_reset => TRUE,
327: p_pkg_name => G_PKG_NAME,
328: p_proc_name => l_api_name);
329:

Line 331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);

327: p_pkg_name => G_PKG_NAME,
328: p_proc_name => l_api_name);
329:
330: IF (l_Debug_Level <= 1) THEN
331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);
332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);

Line 332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);

328: p_proc_name => l_api_name);
329:
330: IF (l_Debug_Level <= 1) THEN
331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);
332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);

Line 333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);

329:
330: IF (l_Debug_Level <= 1) THEN
331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);
332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);

Line 334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);

330: IF (l_Debug_Level <= 1) THEN
331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);
332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);
338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);

Line 335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);

331: itg_debug_pub.Add('CFV - Top of procedure.' ,1);
332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);
338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);
339: END IF;

Line 336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);

332: itg_debug_pub.Add('CFV - p_flex_value' ||p_flex_value ,1);
333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);
338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);
339: END IF;
340:

Line 337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);

333: itg_debug_pub.Add('CFV - p_vset_id' ||p_vset_id ,1);
334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);
338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);
339: END IF;
340:
341: /* I am not sure about the value of preventing these validations. */

Line 338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);

334: itg_debug_pub.Add('CFV - p_flex_desc' ||p_flex_desc ,1);
335: itg_debug_pub.Add('CFV - p_update_date' ||p_update_date ,1);
336: itg_debug_pub.Add('CFV - p_effective_date' ||p_effective_date ,1);
337: itg_debug_pub.Add('CFV - p_expiration_date'||p_expiration_date ,1);
338: itg_debug_pub.Add('CFV - p_enabled_flag' ||p_enabled_flag ,1);
339: END IF;
340:
341: /* I am not sure about the value of preventing these validations. */
342: DECLARE

Line 412: itg_debug_pub.Add('EXITING Change_FlexValue' ,2);

408: l_next_id := l_flex_val_tbl.NEXT(l_next_id);
409: END LOOP;
410:
411: IF (l_Debug_Level <= 2) THEN
412: itg_debug_pub.Add('EXITING Change_FlexValue' ,2);
413: END IF;
414: END;
415: END Change_FlexValue;
416:

Line 439: itg_debug_pub.Add('ENTERING Sync_FlexValue' ,2);

435: BEGIN
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: IF (l_Debug_Level <= 2) THEN
439: itg_debug_pub.Add('ENTERING Sync_FlexValue' ,2);
440: END IF;
441:
442: BEGIN
443: SAVEPOINT Sync_FlexValue_PVT;

Line 444: ITG_Debug.setup(

440: END IF;
441:
442: BEGIN
443: SAVEPOINT Sync_FlexValue_PVT;
444: ITG_Debug.setup(
445: p_reset => TRUE,
446: p_pkg_name => G_PKG_NAME,
447: p_proc_name => l_api_name);
448:

Line 451: itg_debug_pub.Add('SFV - Top of procedure.' ,1);

447: p_proc_name => l_api_name);
448:
449:
450: IF (l_Debug_Level <= 1) THEN
451: itg_debug_pub.Add('SFV - Top of procedure.' ,1);
452: itg_debug_pub.Add('SFV - p_syncind'||p_syncind ,1);
453: END IF;
454:
455: g_action := 'Flex-value sync';

Line 452: itg_debug_pub.Add('SFV - p_syncind'||p_syncind ,1);

448:
449:
450: IF (l_Debug_Level <= 1) THEN
451: itg_debug_pub.Add('SFV - Top of procedure.' ,1);
452: itg_debug_pub.Add('SFV - p_syncind'||p_syncind ,1);
453: END IF;
454:
455: g_action := 'Flex-value sync';
456:

Line 491: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue' ,2);

487:
488: COMMIT WORK;
489:
490: IF (l_Debug_Level <= 2) THEN
491: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue' ,2);
492: END IF;
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO Sync_FlexValue_PVT;

Line 499: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue with ERROR' ,6);

495: ROLLBACK TO Sync_FlexValue_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: ITG_msg.checked_error(g_action);
498: IF (l_Debug_Level <= 6) THEN
499: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue with ERROR' ,6);
500: END IF;
501:
502: WHEN OTHERS THEN
503: ROLLBACK TO Sync_FlexValue_PVT;

Line 505: itg_debug.msg('Unexpected error (COA sync) - ' || substr(SQLERRM,1,255),true);

501:
502: WHEN OTHERS THEN
503: ROLLBACK TO Sync_FlexValue_PVT;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: itg_debug.msg('Unexpected error (COA sync) - ' || substr(SQLERRM,1,255),true);
506: ITG_msg.unexpected_error(g_action);
507: IF (l_Debug_Level <= 6) THEN
508: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue with OTHER ERROR' ,6);
509: END IF;

Line 508: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue with OTHER ERROR' ,6);

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: itg_debug.msg('Unexpected error (COA sync) - ' || substr(SQLERRM,1,255),true);
506: ITG_msg.unexpected_error(g_action);
507: IF (l_Debug_Level <= 6) THEN
508: itg_debug_pub.Add('SFV - Done. EXITING Sync_FlexValue with OTHER ERROR' ,6);
509: END IF;
510:
511: END;
512: END Sync_FlexValue;