DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FND_LOG

Line 118: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

114: ,P_LINE_NUM IN VARCHAR2
115: ,P_CCID IN NUMBER
116: ,P_CASH_RELATED_ITEM IN VARCHAR2
117: ) RETURN VARCHAR2 IS
118: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
119: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
120: l_proc_name VARCHAR2(100) :='Line_Check';
121:
122: l_coa_id number := P_COA_ID;

Line 119: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

115: ,P_CCID IN NUMBER
116: ,P_CASH_RELATED_ITEM IN VARCHAR2
117: ) RETURN VARCHAR2 IS
118: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
119: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
120: l_proc_name VARCHAR2(100) :='Line_Check';
121:
122: l_coa_id number := P_COA_ID;
123: l_ledger_id NUMBER := P_LEDGER_ID;

Line 182: FND_LOG.String( l_proc_level

178: BEGIN
179: --log for debug
180: IF (l_proc_level >= l_dbg_level)
181: THEN
182: FND_LOG.String( l_proc_level
183: ,l_module_prefix||'.'||l_proc_name||'.begin'
184: ,'Enter procedure for Journal/Transaction '||TO_CHAR(l_jt_id)
185: || '''s Line ' || l_line_num
186: );

Line 336: FND_LOG.String( l_proc_level

332:
333: --log for debug
334: IF (l_proc_level >= l_dbg_level)
335: THEN
336: FND_LOG.String( l_proc_level
337: ,l_module_prefix||'.'||l_proc_name||'.end'
338: ,'Exit procedure for Journal/Transaction '||TO_CHAR(l_jt_id)
339: || '''s Line ' || l_line_num
340: ||' and its l_line_chk is ' || l_line_chk

Line 349: FND_LOG.String( l_proc_level

345: EXCEPTION
346: WHEN OTHERS THEN
347: IF (l_proc_level >= l_dbg_level)
348: THEN
349: FND_LOG.String( l_proc_level
350: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
351: ,SQLCODE||':'||SQLERRM
352: );
353: FND_LOG.String( l_proc_level

Line 353: FND_LOG.String( l_proc_level

349: FND_LOG.String( l_proc_level
350: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
351: ,SQLCODE||':'||SQLERRM
352: );
353: FND_LOG.String( l_proc_level
354: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
355: ,'For Journal/Transaction '||TO_CHAR(l_jt_id)
356: || '''s Line ' || l_line_num
357: || ', So set the check as ''EXCLUDED'', meaning excluded the line.'

Line 388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

384: ,P_CCID IN NUMBER
385: ,P_ACCOUNT OUT NOCOPY VARCHAR2
386: ,P_ACCOUNT_DESC OUT NOCOPY VARCHAR2
387: ) IS
388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
390: l_proc_name VARCHAR2(100) :='Get_Account_Combo_and_Desc';
391:
392: l_ledger_id number := P_LEDGER_ID;

Line 389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

385: ,P_ACCOUNT OUT NOCOPY VARCHAR2
386: ,P_ACCOUNT_DESC OUT NOCOPY VARCHAR2
387: ) IS
388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
390: l_proc_name VARCHAR2(100) :='Get_Account_Combo_and_Desc';
391:
392: l_ledger_id number := P_LEDGER_ID;
393: l_cc_id number := P_CCID;

Line 576: FND_LOG.String( l_proc_level

572: EXCEPTION
573: WHEN OTHERS THEN
574: IF (l_proc_level >= l_dbg_level)
575: THEN
576: FND_LOG.String( l_proc_level
577: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
578: ,SQLCODE||':'||SQLERRM);
579: END IF; --(l_proc_level >= l_dbg_level)
580: P_ACCOUNT := '';

Line 628: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

624: ,P_JOURNAL_CTG IN VARCHAR2
625: ,P_STATUS IN VARCHAR2
626: ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
627: ) IS
628: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
629: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
630: l_proc_name VARCHAR2(100) :='GL_Validation';
631:
632: l_le_id NUMBER := P_LE_ID;

Line 629: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

625: ,P_STATUS IN VARCHAR2
626: ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
627: ) IS
628: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
629: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
630: l_proc_name VARCHAR2(100) :='GL_Validation';
631:
632: l_le_id NUMBER := P_LE_ID;
633: l_coa_id NUMBER := P_COA_ID;

Line 861: FND_LOG.String( l_proc_level

857:
858: --log for debug
859: IF (l_proc_level >= l_dbg_level)
860: THEN
861: FND_LOG.String( l_proc_level
862: ,l_module_prefix||'.'||l_proc_name||'.begin'
863: ,'Enter procedure'
864: );
865: FND_LOG.String( l_proc_level

Line 865: FND_LOG.String( l_proc_level

861: FND_LOG.String( l_proc_level
862: ,l_module_prefix||'.'||l_proc_name||'.begin'
863: ,'Enter procedure'
864: );
865: FND_LOG.String( l_proc_level
866: ,l_module_prefix||'.'||l_proc_name||'.parameters'
867: ,'P_LE_ID '||P_LE_ID
868: );
869: FND_LOG.String( l_proc_level

Line 869: FND_LOG.String( l_proc_level

865: FND_LOG.String( l_proc_level
866: ,l_module_prefix||'.'||l_proc_name||'.parameters'
867: ,'P_LE_ID '||P_LE_ID
868: );
869: FND_LOG.String( l_proc_level
870: ,l_module_prefix||'.'||l_proc_name||'.parameters'
871: ,'P_START_PERIOD '||P_START_PERIOD
872: );
873: FND_LOG.String( l_proc_level

Line 873: FND_LOG.String( l_proc_level

869: FND_LOG.String( l_proc_level
870: ,l_module_prefix||'.'||l_proc_name||'.parameters'
871: ,'P_START_PERIOD '||P_START_PERIOD
872: );
873: FND_LOG.String( l_proc_level
874: ,l_module_prefix||'.'||l_proc_name||'.parameters'
875: ,'P_END_PERIOD '||P_END_PERIOD
876: );
877: FND_LOG.String( l_proc_level

Line 877: FND_LOG.String( l_proc_level

873: FND_LOG.String( l_proc_level
874: ,l_module_prefix||'.'||l_proc_name||'.parameters'
875: ,'P_END_PERIOD '||P_END_PERIOD
876: );
877: FND_LOG.String( l_proc_level
878: ,l_module_prefix||'.'||l_proc_name||'.parameters'
879: ,'P_SOURCE '||P_SOURCE
880: );
881: FND_LOG.String( l_proc_level

Line 881: FND_LOG.String( l_proc_level

877: FND_LOG.String( l_proc_level
878: ,l_module_prefix||'.'||l_proc_name||'.parameters'
879: ,'P_SOURCE '||P_SOURCE
880: );
881: FND_LOG.String( l_proc_level
882: ,l_module_prefix||'.'||l_proc_name||'.parameters'
883: ,'P_JOURNAL_CTG '||P_JOURNAL_CTG
884: );
885: FND_LOG.String( l_proc_level --Added for CNAO Enhancement

Line 885: FND_LOG.String( l_proc_level --Added for CNAO Enhancement

881: FND_LOG.String( l_proc_level
882: ,l_module_prefix||'.'||l_proc_name||'.parameters'
883: ,'P_JOURNAL_CTG '||P_JOURNAL_CTG
884: );
885: FND_LOG.String( l_proc_level --Added for CNAO Enhancement
886: ,l_module_prefix||'.'||l_proc_name||'.parameters'
887: ,'P_COM_SEG '||P_COM_SEG
888: );
889: END IF; --(l_proc_level >= l_dbg_level)

Line 1222: FND_LOG.String( l_proc_level

1218:
1219: --log for debug
1220: IF (l_proc_level >= l_dbg_level)
1221: THEN
1222: FND_LOG.String( l_proc_level
1223: ,l_module_prefix||'.'||l_proc_name||'.end'
1224: ,'Exit procedure'
1225: );
1226: END IF; --(l_proc_level >= l_dbg_level)

Line 1232: FND_LOG.String( l_proc_level

1228: EXCEPTION
1229: WHEN JA_CN_INCOMPLETE_DFF_ASSIGN THEN
1230: IF (l_proc_level >= l_dbg_level)
1231: THEN
1232: FND_LOG.String( l_proc_level
1233: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_INCOMPLETE_DFF_ASSIGN '
1234: ,l_msg_incomplete_dff_assign);
1235: END IF; --(l_proc_level >= l_dbg_level)
1236: /*FND_FILE.put_line(FND_FILE.output, '0');

Line 1256: FND_LOG.String( l_proc_level

1252: Report it with l_msg_no_cashflow_item;*/
1253: WHEN OTHERS THEN
1254: IF (l_proc_level >= l_dbg_level)
1255: THEN
1256: FND_LOG.String( l_proc_level
1257: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
1258: ,SQLCODE||':'||SQLERRM);
1259: END IF; --(l_proc_level >= l_dbg_level)
1260: /*FND_FILE.put_line(FND_FILE.output, '0');

Line 1317: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1313: ,P_END_PERIOD IN VARCHAR2
1314: ,P_STATUS IN VARCHAR2
1315: ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1316: ) IS
1317: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1318: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1319: l_proc_name VARCHAR2(100) :='Intercompany_Validation';
1320:
1321: l_coa_id NUMBER := P_COA_ID;

Line 1318: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1314: ,P_STATUS IN VARCHAR2
1315: ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1316: ) IS
1317: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1318: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1319: l_proc_name VARCHAR2(100) :='Intercompany_Validation';
1320:
1321: l_coa_id NUMBER := P_COA_ID;
1322: l_le_id NUMBER := P_LE_ID;

Line 1586: FND_LOG.String( l_proc_level

1582:
1583: --log for debug
1584: IF (l_proc_level >= l_dbg_level)
1585: THEN
1586: FND_LOG.String( l_proc_level
1587: ,l_module_prefix||'.'||l_proc_name||'.begin'
1588: ,'Enter procedure'
1589: );
1590: FND_LOG.String( l_proc_level

Line 1590: FND_LOG.String( l_proc_level

1586: FND_LOG.String( l_proc_level
1587: ,l_module_prefix||'.'||l_proc_name||'.begin'
1588: ,'Enter procedure'
1589: );
1590: FND_LOG.String( l_proc_level
1591: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1592: ,'P_LE_ID '||P_LE_ID
1593: );
1594: FND_LOG.String( l_proc_level

Line 1594: FND_LOG.String( l_proc_level

1590: FND_LOG.String( l_proc_level
1591: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1592: ,'P_LE_ID '||P_LE_ID
1593: );
1594: FND_LOG.String( l_proc_level
1595: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1596: ,'P_START_PERIOD '||l_period_from
1597: );
1598: FND_LOG.String( l_proc_level

Line 1598: FND_LOG.String( l_proc_level

1594: FND_LOG.String( l_proc_level
1595: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1596: ,'P_START_PERIOD '||l_period_from
1597: );
1598: FND_LOG.String( l_proc_level
1599: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1600: ,'P_END_PERIOD '||l_period_to
1601: );
1602: FND_LOG.String( l_proc_level --Added for CNAO Enhancement

Line 1602: FND_LOG.String( l_proc_level --Added for CNAO Enhancement

1598: FND_LOG.String( l_proc_level
1599: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1600: ,'P_END_PERIOD '||l_period_to
1601: );
1602: FND_LOG.String( l_proc_level --Added for CNAO Enhancement
1603: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1604: ,'P_COM_SEG '||l_com_seg
1605: );
1606: END IF; --(l_proc_level >= l_dbg_level)

Line 1966: FND_LOG.String(l_proc_level

1962: JA_CN_UTILITY.Output_Conc(l_xml_root.getclobval());
1963:
1964: --log for debug
1965: IF (l_proc_level >= l_dbg_level) THEN
1966: FND_LOG.String(l_proc_level
1967: ,l_module_prefix||'.'||l_proc_name||'.end'
1968: ,'Exit procedure'
1969: );
1970: END IF; --(l_proc_level >= l_dbg_level)

Line 1975: FND_LOG.String( l_proc_level

1971:
1972: EXCEPTION
1973: WHEN JA_CN_INCOMPLETE_DFF_ASSIGN THEN
1974: IF (l_proc_level >= l_dbg_level) THEN
1975: FND_LOG.String( l_proc_level
1976: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_INCOMPLETE_DFF_ASSIGN '
1977: ,l_msg_incomplete_dff_assign);
1978: END IF; --(l_proc_level >= l_dbg_level)
1979: /*FND_FILE.put_line(FND_FILE.output, '0');

Line 1998: FND_LOG.String( l_proc_level

1994: WHEN JA_CN_NO_CASHFLOWITEM THEN
1995: Report it with l_msg_no_cashflow_item;*/
1996: WHEN OTHERS THEN
1997: IF (l_proc_level >= l_dbg_level) THEN
1998: FND_LOG.String( l_proc_level
1999: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
2000: ,SQLCODE||':'||SQLERRM);
2001: END IF; --(l_proc_level >= l_dbg_level)
2002: /*FND_FILE.put_line(FND_FILE.output, '0');