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_HISDATA_MIG_PKG dependencies on FND_FILE

Line 141: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

137: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
138: '.begin',
139: 'Enter procedure');
140: END IF; --ln_proc_level>=ln_dbg_level
141: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
142: FND_FILE.put_line(FND_FILE.log,
143: lv_procedure_name || '.parameters:' ||
144: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
145: 'pv_period_name=' || pv_period_name || ',' ||

Line 142: FND_FILE.put_line(FND_FILE.log,

138: '.begin',
139: 'Enter procedure');
140: END IF; --ln_proc_level>=ln_dbg_level
141: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
142: FND_FILE.put_line(FND_FILE.log,
143: lv_procedure_name || '.parameters:' ||
144: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
145: 'pv_period_name=' || pv_period_name || ',' ||
146: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 150: FND_FILE.put_line(FND_FILE.log,

146: 'pn_ledger_id=' || pn_ledger_id || ',' ||
147: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);
148: lv_flag := JA_CN_UTILITY.Populate_Ledger_Le_Bsv_Gt(p_Ledger_Id => pn_ledger_id,
149: p_Legal_Entity_Id => pn_legal_entitliy_id);
150: FND_FILE.put_line(FND_FILE.log,
151: lv_procedure_name || 'ln_flag = ' || lv_flag);
152: -- Find DFF cash related item attribute
153: BEGIN
154: SELECT jcda.attribute_column

Line 162: FND_FILE.put_line(FND_FILE.log,

158: AND jcda.descriptive_flexfield_name = 'GL_JE_CATEGORIES'
159: AND jcda.dff_title_code = 'JOCA';
160: EXCEPTION
161: WHEN OTHERS THEN
162: FND_FILE.put_line(FND_FILE.log,
163: lv_procedure_name || SQLCODE || SQLERRM);
164: RAISE;
165: END;
166: -- Construct the cursor to get all the cash related journal lines,

Line 185: FND_FILE.put_line(FND_FILE.log,

181: AND jcda.dff_title_code = 'GLLI'
182: AND b.descriptive_flex_context_code = jcda.context_code;
183: EXCEPTION
184: WHEN OTHERS THEN
185: FND_FILE.put_line(FND_FILE.log,
186: lv_procedure_name || SQLCODE || SQLERRM);
187: RAISE;
188: END;
189: -- Construct the update sql for GL_JE_LINES data migration

Line 223: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);*/

219: VALUE => ln_mig_numbers);
220: lv_output_Msg := Fnd_Message.Get;
221:
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',

Line 283: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

279: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
280: '.begin',
281: 'Enter procedure');
282: END IF; --ln_proc_level>=ln_dbg_level
283: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
284: FND_FILE.put_line(FND_FILE.log,
285: lv_procedure_name || '.parameters:' ||
286: 'pv_period_name=' || pv_period_name || ',' ||
287: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 284: FND_FILE.put_line(FND_FILE.log,

280: '.begin',
281: 'Enter procedure');
282: END IF; --ln_proc_level>=ln_dbg_level
283: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
284: FND_FILE.put_line(FND_FILE.log,
285: lv_procedure_name || '.parameters:' ||
286: 'pv_period_name=' || pv_period_name || ',' ||
287: 'pn_ledger_id=' || pn_ledger_id || ',' ||
288: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);

Line 380: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

376: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
377: '.begin',
378: 'Enter procedure');
379: END IF; --ln_proc_level>=ln_dbg_level
380: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
381: FND_FILE.put_line(FND_FILE.log,
382: lv_procedure_name || '.parameters:' ||
383: 'pv_period_name=' || pv_period_name || ',' ||
384: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 381: FND_FILE.put_line(FND_FILE.log,

377: '.begin',
378: 'Enter procedure');
379: END IF; --ln_proc_level>=ln_dbg_level
380: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
381: FND_FILE.put_line(FND_FILE.log,
382: lv_procedure_name || '.parameters:' ||
383: 'pv_period_name=' || pv_period_name || ',' ||
384: 'pn_ledger_id=' || pn_ledger_id || ',' ||
385: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);

Line 389: FND_FILE.put_line(FND_FILE.log,

385: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);
386: BEGIN
387: lv_flag := JA_CN_UTILITY.Populate_Ledger_Le_Bsv_Gt(p_Ledger_Id => pn_ledger_id,
388: p_Legal_Entity_Id => pn_legal_entitliy_id);
389: FND_FILE.put_line(FND_FILE.log,
390: lv_procedure_name || 'ln_flag = ' || lv_flag);
391: UPDATE gl_je_lines gjl
392: SET gjl.Global_Attribute7 = gjl.Global_Attribute2,
393: gjl.Global_Attribute2 = NULL

Line 415: FND_FILE.put_line(FND_FILE.log,

411: 'Exit procedure');
412: END IF; -- (ln_proc_level>=ln_dbg_level)
413: EXCEPTION
414: WHEN OTHERS THEN
415: FND_FILE.put_line(FND_FILE.log,
416: lv_procedure_name || SQLCODE || SQLERRM);
417: RAISE;
418: END;
419: END UpdateGLItemizationlines;

Line 574: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

570: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
571: '.begin',
572: 'Enter procedure');
573: END IF; --ln_proc_level>=ln_dbg_level
574: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
575: FND_FILE.put_line(FND_FILE.log,
576: lv_procedure_name || '.parameters:' ||
577: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
578: 'pv_period_name=' || pv_period_name || ',' ||

Line 575: FND_FILE.put_line(FND_FILE.log,

571: '.begin',
572: 'Enter procedure');
573: END IF; --ln_proc_level>=ln_dbg_level
574: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
575: FND_FILE.put_line(FND_FILE.log,
576: lv_procedure_name || '.parameters:' ||
577: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
578: 'pv_period_name=' || pv_period_name || ',' ||
579: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 590: FND_FILE.put_line(FND_FILE.log,

586: AND attribute_value = 'Y'
587: AND (id_flex_num = pn_chart_account_id)
588: AND (id_flex_code = 'GL#')
589: AND (application_id = 101);
590: FND_FILE.put_line(FND_FILE.log,
591: lv_procedure_name || 'lv_costcenter_column = ' ||
592: lv_costcenter_column);
593: BEGIN
594: FOR v_row IN cur_setups LOOP

Line 610: FND_FILE.put_line(FND_FILE.log,

606: END IF;
607: END LOOP;
608: EXCEPTION
609: WHEN OTHERS THEN
610: FND_FILE.put_line(FND_FILE.log,
611: lv_procedure_name || SQLCODE || SQLERRM);
612: RAISE;
613: END;
614: FND_FILE.put_line(FND_FILE.log,

Line 614: FND_FILE.put_line(FND_FILE.log,

610: FND_FILE.put_line(FND_FILE.log,
611: lv_procedure_name || SQLCODE || SQLERRM);
612: RAISE;
613: END;
614: FND_FILE.put_line(FND_FILE.log,
615: lv_procedure_name || 'lv_customer_seg = ' ||
616: lv_customer_seg);
617: FND_FILE.put_line(FND_FILE.log,
618: lv_procedure_name || 'lv_supplier_seg = ' ||

Line 617: FND_FILE.put_line(FND_FILE.log,

613: END;
614: FND_FILE.put_line(FND_FILE.log,
615: lv_procedure_name || 'lv_customer_seg = ' ||
616: lv_customer_seg);
617: FND_FILE.put_line(FND_FILE.log,
618: lv_procedure_name || 'lv_supplier_seg = ' ||
619: lv_supplier_seg);
620: FND_FILE.put_line(FND_FILE.log,
621: lv_procedure_name || 'lv_employee_seg = ' ||

Line 620: FND_FILE.put_line(FND_FILE.log,

616: lv_customer_seg);
617: FND_FILE.put_line(FND_FILE.log,
618: lv_procedure_name || 'lv_supplier_seg = ' ||
619: lv_supplier_seg);
620: FND_FILE.put_line(FND_FILE.log,
621: lv_procedure_name || 'lv_employee_seg = ' ||
622: lv_employee_seg);
623: FND_FILE.put_line(FND_FILE.log,
624: lv_procedure_name || 'lv_costcenter_seg = ' ||

Line 623: FND_FILE.put_line(FND_FILE.log,

619: lv_supplier_seg);
620: FND_FILE.put_line(FND_FILE.log,
621: lv_procedure_name || 'lv_employee_seg = ' ||
622: lv_employee_seg);
623: FND_FILE.put_line(FND_FILE.log,
624: lv_procedure_name || 'lv_costcenter_seg = ' ||
625: lv_costcenter_seg);
626: \*SELECT count(*)--Comment by Jianchao Chi for bug 11683977
627: INTO ln_Subsidiary_number

Line 639: FND_FILE.put_line(FND_FILE.log,

635: AND attribute_value = 'Y'
636: AND (id_flex_num = pn_chart_account_id)
637: AND (id_flex_code = 'GL#')
638: AND (application_id = 101)));
639: FND_FILE.put_line(FND_FILE.log,
640: lv_procedure_name || 'ln_Subsidiary_number = ' || ln_Subsidiary_number);
641: IF (ln_Subsidiary_number < 4) THEN
642: Fnd_Message.Set_Name(Application => 'JA',
643: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');

Line 646: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

642: Fnd_Message.Set_Name(Application => 'JA',
643: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');
644: lv_Error_Msg := Fnd_Message.Get;
645: --Output error message
646: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
647: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
648: Message => lv_Error_Msg);
649: --popup error message JA_CN_MISSING_SUBSIDIARY_SETUP
650: ELSE*\

Line 910: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

906: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
907: '.begin',
908: 'Enter procedure');
909: END IF; --ln_proc_level>=ln_dbg_level
910: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
911: FND_FILE.put_line(FND_FILE.log,
912: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
913: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
914: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);

Line 911: FND_FILE.put_line(FND_FILE.log,

907: '.begin',
908: 'Enter procedure');
909: END IF; --ln_proc_level>=ln_dbg_level
910: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
911: FND_FILE.put_line(FND_FILE.log,
912: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
913: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
914: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);
915:

Line 931: FND_FILE.put_line(FND_FILE.log,

927: AND attribute_value = 'Y'
928: AND (id_flex_num = P_COA_ID)
929: AND (id_flex_code = 'GL#')
930: AND (application_id = 101)));
931: FND_FILE.put_line(FND_FILE.log,
932: lv_procedure_name || 'ln_Subsidiary_number = ' ||
933: ln_Subsidiary_number);
934: IF (ln_Subsidiary_number < 4) THEN
935: Fnd_Message.Set_Name(Application => 'JA',

Line 939: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

935: Fnd_Message.Set_Name(Application => 'JA',
936: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');
937: lv_Error_Msg := Fnd_Message.Get;
938: --Output error message
939: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
940: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
941: Message => lv_Error_Msg);
942: END IF;
943:

Line 991: FND_FILE.put_line(FND_FILE.log,

987: 'Exit procedure');
988: END IF; -- (ln_proc_level>=ln_dbg_level)
989: EXCEPTION
990: WHEN OTHERS THEN
991: FND_FILE.put_line(FND_FILE.log,
992: lv_procedure_name || SQLCODE || SQLERRM);
993: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'ERROR',
994: Message => lv_procedure_name ||
995: SQLCODE ||

Line 1012: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);

1008: VALUE => ln_glcashlines_amount);
1009: lv_output_Msg := Fnd_Message.Get;
1010:
1011: --Output error message
1012: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);
1013: END MigrateHisData;*/
1014:
1015: --==========================================================================
1016: -- FUNCTION NAME:

Line 1089: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

1085: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1086: '.begin',
1087: 'Enter procedure');
1088: END IF; --ln_proc_level>=ln_dbg_level
1089: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1090: FND_FILE.put_line(FND_FILE.log,
1091: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
1092: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
1093: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);

Line 1090: FND_FILE.put_line(FND_FILE.log,

1086: '.begin',
1087: 'Enter procedure');
1088: END IF; --ln_proc_level>=ln_dbg_level
1089: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1090: FND_FILE.put_line(FND_FILE.log,
1091: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
1092: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
1093: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);
1094:

Line 1127: FND_FILE.put_line(FND_FILE.log,

1123: 'Exit procedure');
1124: END IF; -- (ln_proc_level>=ln_dbg_level)
1125: EXCEPTION
1126: WHEN OTHERS THEN
1127: FND_FILE.put_line(FND_FILE.log,
1128: lv_procedure_name || SQLCODE || SQLERRM);
1129: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'ERROR',
1130: Message => lv_procedure_name ||
1131: SQLCODE ||

Line 1148: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);

1144: VALUE => ln_glcashlines_amount);
1145: lv_output_Msg := Fnd_Message.Get;
1146:
1147: --Output error message
1148: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);
1149: END MigrateHisDataCFS;
1150:
1151: --==========================================================================
1152: -- FUNCTION NAME:

Line 1237: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

1233: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1234: '.begin',
1235: 'Enter procedure');
1236: END IF; --ln_proc_level>=ln_dbg_level
1237: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1238: FND_FILE.put_line(FND_FILE.log,
1239: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
1240: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
1241: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);

Line 1238: FND_FILE.put_line(FND_FILE.log,

1234: '.begin',
1235: 'Enter procedure');
1236: END IF; --ln_proc_level>=ln_dbg_level
1237: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1238: FND_FILE.put_line(FND_FILE.log,
1239: lv_procedure_name || '.parameters:' || 'P_COA_ID=' ||
1240: P_COA_ID || ',' || 'P_LEDGER_ID=' || P_LEDGER_ID || ',' ||
1241: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);
1242:

Line 1258: FND_FILE.put_line(FND_FILE.log,

1254: AND attribute_value = 'Y'
1255: AND (id_flex_num = P_COA_ID)
1256: AND (id_flex_code = 'GL#')
1257: AND (application_id = 101)));
1258: FND_FILE.put_line(FND_FILE.log,
1259: lv_procedure_name || 'ln_Subsidiary_number = ' ||
1260: ln_Subsidiary_number);
1261: IF (ln_Subsidiary_number < 4) THEN
1262: lb_need_Update := FALSE;

Line 1267: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1263: Fnd_Message.Set_Name(Application => 'JA',
1264: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');
1265: lv_Error_Msg := Fnd_Message.Get;
1266: --Output error message
1267: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1268: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1269: Message => lv_Error_Msg);
1270: END IF;
1271:

Line 1290: FND_FILE.put_line(FND_FILE.log,

1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: lv_prject_project_seg := NULL;
1289: END;
1290: FND_FILE.put_line(FND_FILE.log,
1291: lv_procedure_name || 'lv_prject_project_seg = ' ||
1292: lv_prject_project_seg);
1293: BEGIN
1294:

Line 1324: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1320: Fnd_Message.Set_Name(Application => 'JA',
1321: NAME => 'JA_CN_ERROR_SUBSIDIARY_SETUP');
1322: lv_Error_Msg := Fnd_Message.Get;
1323: --Output error message
1324: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1325: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1326: Message => lv_Error_Msg);
1327: lb_need_Update := FALSE;
1328: END;

Line 1329: FND_FILE.put_line(FND_FILE.log,

1325: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1326: Message => lv_Error_Msg);
1327: lb_need_Update := FALSE;
1328: END;
1329: FND_FILE.put_line(FND_FILE.log,
1330: lv_procedure_name || 'lv_prject_coa_seg = ' ||
1331: lv_prject_coa_seg);
1332: IF (lv_prject_coa_seg IS NOT NULL AND lv_prject_project_seg IS NOT NULL) THEN
1333:

Line 1338: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1334: Fnd_Message.Set_Name(Application => 'JA',
1335: NAME => 'JA_CN_ERROR_SUBSIDIARY_SETUP');
1336: lv_Error_Msg := Fnd_Message.Get;
1337: --Output error message
1338: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1339: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1340: Message => lv_Error_Msg);
1341:
1342: -- popup JA_CN_ERROR_SUBSIDIARY_SETUP

Line 1346: FND_FILE.put_line(FND_FILE.log,

1342: -- popup JA_CN_ERROR_SUBSIDIARY_SETUP
1343: lb_need_Update := FALSE;
1344: END IF;
1345:
1346: FND_FILE.put_line(FND_FILE.log,
1347: lv_procedure_name || 'lv_project_sourrce_flag = ' ||
1348: lv_project_sourrce_flag);
1349: /* FND_FILE.put_line(FND_FILE.log,
1350: lv_procedure_name || 'lv_project_ac_code = ' || lv_project_ac_code);

Line 1349: /* FND_FILE.put_line(FND_FILE.log,

1345:
1346: FND_FILE.put_line(FND_FILE.log,
1347: lv_procedure_name || 'lv_project_sourrce_flag = ' ||
1348: lv_project_sourrce_flag);
1349: /* FND_FILE.put_line(FND_FILE.log,
1350: lv_procedure_name || 'lv_project_ac_code = ' || lv_project_ac_code);
1351: FND_FILE.put_line(FND_FILE.log,
1352: lv_procedure_name || 'lv_coa_segment = ' || lv_coa_segment);*/
1353: IF (lb_need_Update) THEN

Line 1351: FND_FILE.put_line(FND_FILE.log,

1347: lv_procedure_name || 'lv_project_sourrce_flag = ' ||
1348: lv_project_sourrce_flag);
1349: /* FND_FILE.put_line(FND_FILE.log,
1350: lv_procedure_name || 'lv_project_ac_code = ' || lv_project_ac_code);
1351: FND_FILE.put_line(FND_FILE.log,
1352: lv_procedure_name || 'lv_coa_segment = ' || lv_coa_segment);*/
1353: IF (lb_need_Update) THEN
1354: -- Chongwu update for Project solution changes by anita FDD 0.6
1355: IF (lv_project_sourrce_flag = 'PA') THEN

Line 1362: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1358: Fnd_Message.Set_Name(Application => 'JA',
1359: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');
1360: lv_Error_Msg := Fnd_Message.Get;
1361: --Output error message
1362: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1363: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1364: Message => lv_Error_Msg);
1365:
1366: -- popup JA_CN_ MISSING_SUBSIDIARY_SETUP

Line 1375: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1371: Fnd_Message.Set_Name(Application => 'JA',
1372: NAME => 'JA_CN_ERROR_SUBSIDIARY_SETUP');
1373: lv_Error_Msg := Fnd_Message.Get;
1374: --Output error message
1375: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1376: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1377: Message => lv_Error_Msg);
1378:
1379: -- popup JA_CN_ERROR_SUBSIDIARY_SETUP

Line 1393: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1389: Fnd_Message.Set_Name(Application => 'JA',
1390: NAME => 'JA_CN_MISSING_SUBSIDIARY_SETUP');
1391: lv_Error_Msg := Fnd_Message.Get;
1392: --Output error message
1393: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1394: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1395: Message => lv_Error_Msg);
1396:
1397: -- popup JA_CN_MISSING_SUBSIDIARY_SETUP

Line 1406: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);

1402: Fnd_Message.Set_Name(Application => 'JA',
1403: NAME => 'JA_CN_ERROR_SUBSIDIARY_SETUP');
1404: lv_Error_Msg := Fnd_Message.Get;
1405: --Output error message
1406: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
1407: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1408: Message => lv_Error_Msg);
1409:
1410: -- popup JA_CN_INCORRECT_SUBSIDIARY_SETUP

Line 1422: FND_FILE.put_line(FND_FILE.log,

1418: ELSIF (lv_project_sourrce_flag = 'N') THEN
1419: lb_need_Update := FALSE;
1420: END IF; -- (lv_project_sourrce_flag ='PA') THEN
1421: END IF; --(lb_need_Update) THEN
1422: FND_FILE.put_line(FND_FILE.log,
1423: lv_procedure_name || 'lv_prject_seg = ' ||
1424: lv_prject_seg);
1425:
1426: -- choli fix bug 12349159, move the related setup check from UpdateItemizationLines

Line 1466: FND_FILE.put_line(FND_FILE.log,

1462: 'Exit procedure');
1463: END IF; -- (ln_proc_level>=ln_dbg_level)
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: FND_FILE.put_line(FND_FILE.log,
1467: lv_procedure_name || SQLCODE || SQLERRM);
1468: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'ERROR',
1469: Message => lv_procedure_name ||
1470: SQLCODE ||

Line 1484: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);

1480: NAME => 'JA_CN_DATA_MIGRATION_RESULT_D');
1481: lv_output_Msg := Fnd_Message.Get;
1482:
1483: --Output error message
1484: Fnd_File.Put_Line(Fnd_File.Output, lv_output_Msg);
1485: -----choli fixed bug 12344625,
1486: END IF;
1487: -----
1488: END MigrateHisDataDE;

Line 1586: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);

1582: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1583: '.begin',
1584: 'Enter procedure');
1585: END IF; --ln_proc_level>=ln_dbg_level
1586: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1587: FND_FILE.put_line(FND_FILE.log,
1588: lv_procedure_name || '.parameters:' ||
1589: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
1590: 'pv_period_name=' || pv_period_name || ',' ||

Line 1587: FND_FILE.put_line(FND_FILE.log,

1583: '.begin',
1584: 'Enter procedure');
1585: END IF; --ln_proc_level>=ln_dbg_level
1586: FND_FILE.PUT_LINE(FND_FILE.log, 'Enter: ' || lv_procedure_name);
1587: FND_FILE.put_line(FND_FILE.log,
1588: lv_procedure_name || '.parameters:' ||
1589: 'pn_chart_account_id=' || pn_chart_account_id || ',' ||
1590: 'pv_period_name=' || pv_period_name || ',' ||
1591: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 1602: FND_FILE.put_line(FND_FILE.log,

1598: AND attribute_value = 'Y'
1599: AND (id_flex_num = pn_chart_account_id)
1600: AND (id_flex_code = 'GL#')
1601: AND (application_id = 101);
1602: FND_FILE.put_line(FND_FILE.log,
1603: lv_procedure_name || 'lv_costcenter_column = ' ||
1604: lv_costcenter_column);
1605: BEGIN
1606: FOR v_row IN cur_setups LOOP

Line 1622: FND_FILE.put_line(FND_FILE.log,

1618: END IF;
1619: END LOOP;
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: FND_FILE.put_line(FND_FILE.log,
1623: lv_procedure_name || SQLCODE || SQLERRM);
1624: RAISE;
1625: END;
1626: FND_FILE.put_line(FND_FILE.log,

Line 1626: FND_FILE.put_line(FND_FILE.log,

1622: FND_FILE.put_line(FND_FILE.log,
1623: lv_procedure_name || SQLCODE || SQLERRM);
1624: RAISE;
1625: END;
1626: FND_FILE.put_line(FND_FILE.log,
1627: lv_procedure_name || 'lv_customer_seg = ' ||
1628: lv_customer_seg);
1629: FND_FILE.put_line(FND_FILE.log,
1630: lv_procedure_name || 'lv_supplier_seg = ' ||

Line 1629: FND_FILE.put_line(FND_FILE.log,

1625: END;
1626: FND_FILE.put_line(FND_FILE.log,
1627: lv_procedure_name || 'lv_customer_seg = ' ||
1628: lv_customer_seg);
1629: FND_FILE.put_line(FND_FILE.log,
1630: lv_procedure_name || 'lv_supplier_seg = ' ||
1631: lv_supplier_seg);
1632: FND_FILE.put_line(FND_FILE.log,
1633: lv_procedure_name || 'lv_employee_seg = ' ||

Line 1632: FND_FILE.put_line(FND_FILE.log,

1628: lv_customer_seg);
1629: FND_FILE.put_line(FND_FILE.log,
1630: lv_procedure_name || 'lv_supplier_seg = ' ||
1631: lv_supplier_seg);
1632: FND_FILE.put_line(FND_FILE.log,
1633: lv_procedure_name || 'lv_employee_seg = ' ||
1634: lv_employee_seg);
1635: FND_FILE.put_line(FND_FILE.log,
1636: lv_procedure_name || 'lv_costcenter_seg = ' ||

Line 1635: FND_FILE.put_line(FND_FILE.log,

1631: lv_supplier_seg);
1632: FND_FILE.put_line(FND_FILE.log,
1633: lv_procedure_name || 'lv_employee_seg = ' ||
1634: lv_employee_seg);
1635: FND_FILE.put_line(FND_FILE.log,
1636: lv_procedure_name || 'lv_costcenter_seg = ' ||
1637: lv_costcenter_seg);
1638:
1639: -- update JA_CN_JOURNAL_LINES, Construct the update sql for Itemazation data migration