DBA Data[Home] [Help]

APPS.JA_CN_HISDATA_MIG_PKG dependencies on FND_LOG

Line 89: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

85: lv_output_Msg VARCHAR2(4000);
86: ln_mig_numbers NUMBER;
87: lv_cashitem_column VARCHAR2(40);
88: lv_cashrelated_column VARCHAR2(40);
89: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
90: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
91: lv_procedure_name VARCHAR2(40) := 'UpdateCashlines';
92: ln_je_header_id NUMBER;
93: ln_je_line_num NUMBER;

Line 90: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

86: ln_mig_numbers NUMBER;
87: lv_cashitem_column VARCHAR2(40);
88: lv_cashrelated_column VARCHAR2(40);
89: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
90: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
91: lv_procedure_name VARCHAR2(40) := 'UpdateCashlines';
92: ln_je_header_id NUMBER;
93: ln_je_line_num NUMBER;
94: TYPE ref_cursor_type IS REF CURSOR;

Line 136: FND_LOG.STRING(ln_proc_level,

132: AND gjl.je_line_num = :2';
133: BEGIN
134: --logging for debug
135: IF (ln_proc_level >= ln_dbg_level) THEN
136: FND_LOG.STRING(ln_proc_level,
137: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
138: '.begin',
139: 'Enter procedure');
140: END IF; --ln_proc_level>=ln_dbg_level

Line 226: FND_LOG.STRING(ln_proc_level,

222: --Output error message
223: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);*/
224: --logging for debug
225: IF (ln_proc_level >= ln_dbg_level) THEN
226: FND_LOG.STRING(ln_proc_level,
227: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
228: 'Exit procedure');
229: END IF; -- (ln_proc_level>=ln_dbg_level)
230: END UpdateGLCashlines;

Line 269: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

265: lv_output_Msg VARCHAR2(4000);
266: ln_mig_numbers NUMBER;
267: lv_cashitem_column VARCHAR2(40);
268: lv_cashrelated_column VARCHAR2(40);
269: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
270: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
271: lv_procedure_name VARCHAR2(40) := 'UpdateSLAHeaderLine';
272: ln_je_header_id NUMBER;
273: ln_je_line_num NUMBER;

Line 270: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

266: ln_mig_numbers NUMBER;
267: lv_cashitem_column VARCHAR2(40);
268: lv_cashrelated_column VARCHAR2(40);
269: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
270: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
271: lv_procedure_name VARCHAR2(40) := 'UpdateSLAHeaderLine';
272: ln_je_header_id NUMBER;
273: ln_je_line_num NUMBER;
274:

Line 278: FND_LOG.STRING(ln_proc_level,

274:
275: BEGIN
276: --logging for debug
277: IF (ln_proc_level >= ln_dbg_level) THEN
278: FND_LOG.STRING(ln_proc_level,
279: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
280: '.begin',
281: 'Enter procedure');
282: END IF; --ln_proc_level>=ln_dbg_level

Line 333: FND_LOG.STRING(ln_proc_level,

329: NULL;
330: END;
331: --logging for debug
332: IF (ln_proc_level >= ln_dbg_level) THEN
333: FND_LOG.STRING(ln_proc_level,
334: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
335: 'Exit procedure');
336: END IF; -- (ln_proc_level>=ln_dbg_level)
337: END UpdateSLAHeaderLine;

Line 367: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

363: PROCEDURE UpdateGLItemizationlines(pn_legal_entitliy_id NUMBER,
364: pn_ledger_id NUMBER,
365: pv_period_name VARCHAR2) IS
366: lv_flag VARCHAR2(10);
367: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
368: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
369: lv_procedure_name VARCHAR2(40) := 'UpdateGLItemizationlines';
370:
371: BEGIN

Line 368: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

364: pn_ledger_id NUMBER,
365: pv_period_name VARCHAR2) IS
366: lv_flag VARCHAR2(10);
367: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
368: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
369: lv_procedure_name VARCHAR2(40) := 'UpdateGLItemizationlines';
370:
371: BEGIN
372:

Line 375: FND_LOG.STRING(ln_proc_level,

371: BEGIN
372:
373: --logging for debug
374: IF (ln_proc_level >= ln_dbg_level) THEN
375: FND_LOG.STRING(ln_proc_level,
376: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
377: '.begin',
378: 'Enter procedure');
379: END IF; --ln_proc_level>=ln_dbg_level

Line 408: FND_LOG.STRING(ln_proc_level,

404: AND gjl.Global_Attribute2 IS NOT NULL;
405:
406: --logging for debug
407: IF (ln_proc_level >= ln_dbg_level) THEN
408: FND_LOG.STRING(ln_proc_level,
409: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
410: '.end',
411: 'Exit procedure');
412: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 460: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

456: pv_period_name VARCHAR2,
457: --pb_msg_tag BOOLEAN, --Add a parameter by Jianchao Chi for bug 11683977
458: lb_need_Update BOOLEAN,
459: lv_prject_seg VARCHAR2) IS
460: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
461: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
462: lv_procedure_name VARCHAR2(40) := 'UpdateItemizationlines';
463: ln_Subsidiary_number NUMBER;
464: lv_customer_seg VARCHAR2(40);

Line 461: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

457: --pb_msg_tag BOOLEAN, --Add a parameter by Jianchao Chi for bug 11683977
458: lb_need_Update BOOLEAN,
459: lv_prject_seg VARCHAR2) IS
460: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
461: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
462: lv_procedure_name VARCHAR2(40) := 'UpdateItemizationlines';
463: ln_Subsidiary_number NUMBER;
464: lv_customer_seg VARCHAR2(40);
465: lv_supplier_seg VARCHAR2(40);

Line 569: FND_LOG.STRING(ln_proc_level,

565: BEGIN
566: --logging for debug
567:
568: IF (ln_proc_level >= ln_dbg_level) THEN
569: FND_LOG.STRING(ln_proc_level,
570: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
571: '.begin',
572: 'Enter procedure');
573: END IF; --ln_proc_level>=ln_dbg_level

Line 826: FND_LOG.STRING(ln_proc_level,

822: END IF; --(lb_need_Update) THEN
823: --END IF; --(ln_Subsidiary_number < 4) --Comment by Jianchao Chi for bug 11683977
824: --logging for debug
825: IF (ln_proc_level >= ln_dbg_level) THEN
826: FND_LOG.STRING(ln_proc_level,
827: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
828: 'Exit procedure');
829: END IF; -- (ln_proc_level>=ln_dbg_level)
830: END UpdateItemizationlines;*/

Line 878: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

874: P_LEDGER_ID IN NUMBER,
875: P_LEDGER_NAME IN VARCHAR2,
876: P_LEGAL_ENTITY_ID IN NUMBER,
877: P_LEGAL_ENTITY IN VARCHAR2) IS
878: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
879: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
880: lv_procedure_name VARCHAR2(40) := 'MigrateHisData';
881: lv_error_flag VARCHAR2(5);
882: lb_Error_Status BOOLEAN;

Line 879: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

875: P_LEDGER_NAME IN VARCHAR2,
876: P_LEGAL_ENTITY_ID IN NUMBER,
877: P_LEGAL_ENTITY IN VARCHAR2) IS
878: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
879: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
880: lv_procedure_name VARCHAR2(40) := 'MigrateHisData';
881: lv_error_flag VARCHAR2(5);
882: lb_Error_Status BOOLEAN;
883:

Line 905: FND_LOG.STRING(ln_proc_level,

901:
902: BEGIN
903: --logging for debug
904: IF (ln_proc_level >= ln_dbg_level) THEN
905: FND_LOG.STRING(ln_proc_level,
906: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
907: '.begin',
908: 'Enter procedure');
909: END IF; --ln_proc_level>=ln_dbg_level

Line 984: FND_LOG.STRING(ln_proc_level,

980: COMMIT;
981:
982: --logging for debug
983: IF (ln_proc_level >= ln_dbg_level) THEN
984: FND_LOG.STRING(ln_proc_level,
985: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
986: '.end',
987: 'Exit procedure');
988: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1060: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1056: P_LEDGER_ID IN NUMBER,
1057: P_LEDGER_NAME IN VARCHAR2,
1058: P_LEGAL_ENTITY_ID IN NUMBER,
1059: P_LEGAL_ENTITY IN VARCHAR2) IS
1060: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1061: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1062: lv_procedure_name VARCHAR2(40) := 'MigrateHisDataCFS';
1063: lv_error_flag VARCHAR2(5);
1064: lb_Error_Status BOOLEAN;

Line 1061: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1057: P_LEDGER_NAME IN VARCHAR2,
1058: P_LEGAL_ENTITY_ID IN NUMBER,
1059: P_LEGAL_ENTITY IN VARCHAR2) IS
1060: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1061: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1062: lv_procedure_name VARCHAR2(40) := 'MigrateHisDataCFS';
1063: lv_error_flag VARCHAR2(5);
1064: lb_Error_Status BOOLEAN;
1065: ln_glcashlines_amount NUMBER := 0;

Line 1084: FND_LOG.STRING(ln_proc_level,

1080:
1081: BEGIN
1082: --logging for debug
1083: IF (ln_proc_level >= ln_dbg_level) THEN
1084: FND_LOG.STRING(ln_proc_level,
1085: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1086: '.begin',
1087: 'Enter procedure');
1088: END IF; --ln_proc_level>=ln_dbg_level

Line 1120: FND_LOG.STRING(ln_proc_level,

1116: --End bug 12353563 by jianchao chi --
1117:
1118: --logging for debug
1119: IF (ln_proc_level >= ln_dbg_level) THEN
1120: FND_LOG.STRING(ln_proc_level,
1121: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1122: '.end',
1123: 'Exit procedure');
1124: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1197: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1193: P_LEDGER_ID IN NUMBER,
1194: P_LEDGER_NAME IN VARCHAR2,
1195: P_LEGAL_ENTITY_ID IN NUMBER,
1196: P_LEGAL_ENTITY IN VARCHAR2) IS
1197: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1198: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1199: lv_procedure_name VARCHAR2(40) := 'MigrateHisDataDE';
1200: lv_error_flag VARCHAR2(5);
1201: lb_Error_Status BOOLEAN;

Line 1198: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1194: P_LEDGER_NAME IN VARCHAR2,
1195: P_LEGAL_ENTITY_ID IN NUMBER,
1196: P_LEGAL_ENTITY IN VARCHAR2) IS
1197: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1198: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1199: lv_procedure_name VARCHAR2(40) := 'MigrateHisDataDE';
1200: lv_error_flag VARCHAR2(5);
1201: lb_Error_Status BOOLEAN;
1202:

Line 1232: FND_LOG.STRING(ln_proc_level,

1228:
1229: BEGIN
1230: --logging for debug
1231: IF (ln_proc_level >= ln_dbg_level) THEN
1232: FND_LOG.STRING(ln_proc_level,
1233: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1234: '.begin',
1235: 'Enter procedure');
1236: END IF; --ln_proc_level>=ln_dbg_level

Line 1459: FND_LOG.STRING(ln_proc_level,

1455: COMMIT;
1456:
1457: --logging for debug
1458: IF (ln_proc_level >= ln_dbg_level) THEN
1459: FND_LOG.STRING(ln_proc_level,
1460: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1461: '.end',
1462: 'Exit procedure');
1463: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1529: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1525: pv_period_name VARCHAR2,
1526: --pb_msg_tag BOOLEAN, --Add a parameter by Jianchao Chi for bug 11683977
1527: lb_need_Update BOOLEAN,
1528: lv_prject_seg VARCHAR2) IS
1529: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1530: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1531: lv_procedure_name VARCHAR2(40) := 'UpdateItemizationlines';
1532: ln_Subsidiary_number NUMBER;
1533: lv_customer_seg VARCHAR2(40);

Line 1530: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1526: --pb_msg_tag BOOLEAN, --Add a parameter by Jianchao Chi for bug 11683977
1527: lb_need_Update BOOLEAN,
1528: lv_prject_seg VARCHAR2) IS
1529: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1530: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1531: lv_procedure_name VARCHAR2(40) := 'UpdateItemizationlines';
1532: ln_Subsidiary_number NUMBER;
1533: lv_customer_seg VARCHAR2(40);
1534: lv_supplier_seg VARCHAR2(40);

Line 1581: FND_LOG.STRING(ln_proc_level,

1577: BEGIN
1578: --logging for debug
1579:
1580: IF (ln_proc_level >= ln_dbg_level) THEN
1581: FND_LOG.STRING(ln_proc_level,
1582: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1583: '.begin',
1584: 'Enter procedure');
1585: END IF; --ln_proc_level>=ln_dbg_level

Line 1780: FND_LOG.STRING(ln_proc_level,

1776: END IF; --(lb_need_Update) THEN
1777:
1778: --logging for debug
1779: IF (ln_proc_level >= ln_dbg_level) THEN
1780: FND_LOG.STRING(ln_proc_level,
1781: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1782: 'Exit procedure');
1783: END IF; -- (ln_proc_level>=ln_dbg_level)
1784: END UpdateItemizationlines;