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

Line 85: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;

81:
82: l_module_prefix VARCHAR2(100) :='JA_CN_CFS_DATA_CLT_PKG';
83:
84: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_CFS_DATA_CLT_PKG.';
85: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
86: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
87: g_debug_devel INT;
88: -- G_PERIOD_TYPE VARCHAR2(30):='Month';
89:

Line 86: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;

82: l_module_prefix VARCHAR2(100) :='JA_CN_CFS_DATA_CLT_PKG';
83:
84: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_CFS_DATA_CLT_PKG.';
85: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
86: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
87: g_debug_devel INT;
88: -- G_PERIOD_TYPE VARCHAR2(30):='Month';
89:
90: --==========================================================================

Line 134: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

130: ,P_CCID IN NUMBER
131: ,P_CASH_RELATED_ITEM IN VARCHAR2
132: ,P_GIS_JNL_CRI OUT NOCOPY VARCHAR2
133: ) RETURN VARCHAR2 IS
134: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
135: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
136: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
137:
138: l_ledger_id NUMBER := P_LEDGER_ID; --

Line 135: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

131: ,P_CASH_RELATED_ITEM IN VARCHAR2
132: ,P_GIS_JNL_CRI OUT NOCOPY VARCHAR2
133: ) RETURN VARCHAR2 IS
134: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
135: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
136: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
137:
138: l_ledger_id NUMBER := P_LEDGER_ID; --
139: l_le_id NUMBER := P_LE_ID;

Line 197: FND_LOG.String( l_proc_level

193: BEGIN
194: --log for debug
195: IF (l_proc_level >= l_dbg_level)
196: THEN
197: FND_LOG.String( l_proc_level
198: ,l_module_prefix||'.'||l_proc_name||'.begin'
199: ,'Enter procedure for Journal/Transaction '||TO_CHAR(l_jt_id)
200: || '''s Line ' || l_line_num
201: );

Line 376: FND_LOG.String( l_proc_level

372:
373: --log for debug
374: IF (l_proc_level >= l_dbg_level)
375: THEN
376: FND_LOG.String( l_proc_level
377: ,l_module_prefix||'.'||l_proc_name||'.end'
378: ,'Exit procedure for Journal/Transaction '||TO_CHAR(l_jt_id)
379: || '''s Line ' || l_line_num
380: ||' and its l_line_check is ' || l_line_check

Line 389: FND_LOG.String( l_proc_level

385: EXCEPTION
386: WHEN OTHERS THEN
387: IF (l_proc_level >= l_dbg_level)
388: THEN
389: FND_LOG.String( l_proc_level
390: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
391: ,SQLCODE||':'||SQLERRM
392: );
393: FND_LOG.String( l_proc_level

Line 393: FND_LOG.String( l_proc_level

389: FND_LOG.String( l_proc_level
390: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
391: ,SQLCODE||':'||SQLERRM
392: );
393: FND_LOG.String( l_proc_level
394: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
395: ,'For Journal/Transaction '||TO_CHAR(l_jt_id)
396: || '''s Line ' || l_line_num
397: || ', So set the check as ''N'', meaning fall the check.'

Line 443: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

439: ,P_AGIS_CURR_RATE OUT NOCOPY NUMBER
440:
441: ) RETURN boolean IS
442:
443: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
444: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
445: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
446:
447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;

Line 444: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

440:
441: ) RETURN boolean IS
442:
443: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
444: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
445: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
446:
447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
448: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;

Line 455: FND_LOG.String( l_proc_level

451: BEGIN
452: --log for debug
453: IF (l_proc_level >= l_dbg_level)
454: THEN
455: FND_LOG.String( l_proc_level
456: ,l_module_prefix||'.'||l_proc_name||'.begin'
457: ,'Enter procedure for Journal/Transaction '
458: --||TO_CHAR(l_jt_id) || '''s Line ' || l_line_num
459: );

Line 500: FND_LOG.String( l_proc_level

496: EXCEPTION
497: WHEN OTHERS THEN
498: IF (l_proc_level >= l_dbg_level)
499: THEN
500: FND_LOG.String( l_proc_level
501: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
502: ,SQLCODE||':'||SQLERRM
503: );
504: FND_LOG.String( l_proc_level

Line 504: FND_LOG.String( l_proc_level

500: FND_LOG.String( l_proc_level
501: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
502: ,SQLCODE||':'||SQLERRM
503: );
504: FND_LOG.String( l_proc_level
505: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
506: ,--'For Journal/Transaction '||TO_CHAR(l_jt_id)
507: --|| '''s Line ' || l_line_num
508: ''|| ', So set the check as ''N'', meaning fall the check.'

Line 539: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

535: ,P_AMOUNT IN NUMBER
536: ,P_CURRENCY_CODE IN VARCHAR2
537: ,P_AMOUNT_ROUNDED OUT NOCOPY NUMBER
538: ) IS
539: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
540: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
541: l_proc_name VARCHAR2(100) :='Process_GL_Rounding';
542:
543: l_amount NUMBER := P_AMOUNT;

Line 540: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

536: ,P_CURRENCY_CODE IN VARCHAR2
537: ,P_AMOUNT_ROUNDED OUT NOCOPY NUMBER
538: ) IS
539: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
540: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
541: l_proc_name VARCHAR2(100) :='Process_GL_Rounding';
542:
543: l_amount NUMBER := P_AMOUNT;
544: l_currency_code VARCHAR2(15) := P_CURRENCY_CODE;

Line 553: FND_LOG.String( l_proc_level

549: BEGIN
550: --log for debug
551: IF (l_proc_level >= l_dbg_level)
552: THEN
553: FND_LOG.String( l_proc_level
554: ,l_module_prefix||'.'||l_proc_name||'.begin'
555: ,'Enter procedure'
556: );
557: END IF; --(l_proc_level >= l_dbg_level)

Line 569: FND_LOG.string( l_proc_level

565: EXCEPTION
566: WHEN NO_DATA_FOUND THEN
567: IF(l_proc_level >= l_dbg_level)
568: THEN
569: FND_LOG.string( l_proc_level
570: ,l_module_prefix||'.'||l_proc_name||'.NO_DATA_FOUND'
571: ,'The legal entity has no system parameters defined'
572: );
573: END IF;

Line 599: FND_LOG.String( l_proc_level

595:
596: --log for debug
597: IF (l_proc_level >= l_dbg_level)
598: THEN
599: FND_LOG.String( l_proc_level
600: ,l_module_prefix||'.'||l_proc_name||'.end'
601: ,'Exit procedure'
602: );
603: END IF; --(l_proc_level >= l_dbg_level)

Line 609: FND_LOG.String( l_proc_level

605: EXCEPTION
606: WHEN OTHERS THEN
607: IF (l_proc_level >= l_dbg_level)
608: THEN
609: FND_LOG.String( l_proc_level
610: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
611: ,SQLCODE||':'||SQLERRM
612: );
613: END IF; --(l_proc_level >= l_dbg_level)

Line 661: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

657: ,P_GL_PERIOD_TO IN VARCHAR2
658: ,P_SOURCE_APP_ID IN NUMBER
659: ) IS
660: --variables
661: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
662: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
663: l_proc_name VARCHAR2(100) :='Collect_GL_InterCom_Data';
664:
665: l_le_id NUMBER :=P_LE_ID;

Line 662: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

658: ,P_SOURCE_APP_ID IN NUMBER
659: ) IS
660: --variables
661: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
662: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
663: l_proc_name VARCHAR2(100) :='Collect_GL_InterCom_Data';
664:
665: l_le_id NUMBER :=P_LE_ID;
666: l_ledger_id NUMBER :=P_LEDGER_ID;

Line 969: FND_LOG.String( l_proc_level

965: BEGIN
966: --log for debug
967: IF (l_proc_level >= l_dbg_level)
968: THEN
969: FND_LOG.String( l_proc_level
970: ,l_module_prefix||'.'||l_proc_name||'.begin'
971: ,'Enter procedure'
972: );
973: FND_LOG.String( l_proc_level

Line 973: FND_LOG.String( l_proc_level

969: FND_LOG.String( l_proc_level
970: ,l_module_prefix||'.'||l_proc_name||'.begin'
971: ,'Enter procedure'
972: );
973: FND_LOG.String( l_proc_level
974: ,l_module_prefix||'.'||l_proc_name||'.P_SOURCE'
975: ,P_SOURCE_APP_ID
976: );
977: END IF; --(l_proc_level >= l_dbg_level)

Line 1610: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )

1606: )
1607: IS
1608: BEGIN
1609: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
1610: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
1611: THEN
1612: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
1613: , MODULE => p_module
1614: , MESSAGE => p_message

Line 1612: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT

1608: BEGIN
1609: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
1610: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
1611: THEN
1612: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
1613: , MODULE => p_module
1614: , MESSAGE => p_message
1615: );
1616: END IF;

Line 1671: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;

1667: put_log(G_MODULE_PREFIX||l_procedure_name||'.period rowcount'
1668: ,l_row_count);
1669: END IF; --( G_PROC_LEVEL >= g_debug_devel)*/
1670: BEGIN
1671: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;
1672:
1673: -- Initialization
1674: --l_resp_id := FND_PROFILE.VALUE('RESP_ID');
1675: --l_org_id := FND_PROFILE.VALUE('ORG_ID')