107: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
108: 'p_legal_entity_id:' || p_Legal_Entity_Id);
109: END IF; --(l_proc_level >= l_dbg_level)
110:
111: IF Ja_Cn_Utility.Check_Profile THEN
112: Ja_Cn_Acc_Je_Itemization_Pkg.Transfer_Gl_Sla_To_Cnao(Errbuf => Errbuf,
113: Retcode => Retcode,
114: p_Chart_Of_Accounts_Id => p_Chart_Of_Accounts_Id,
115: p_Ledger_Id => p_Ledger_Id,
116: p_Legal_Entity_Id => p_Legal_Entity_Id,
117: p_Period_Name => p_Period_Name);
118: ELSE
119: l_Error_Flag := 'Y';
120: END IF; --JA_CN_UTILITY.Check_Profile
121:
122: --If above check failed, then set status of concurrent program as warning
123:
124: IF l_Error_Flag = 'Y' THEN
199: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
200: 'p_legal_entity_ID:' || p_Legal_Entity_Id);
201: END IF; --(l_proc_level >= l_dbg_level)
202:
203: IF Ja_Cn_Utility.Check_Profile THEN
204: Ja_Cn_Post_Utility_Pkg.Post_Journal_Itemized(p_Period_Name => p_Period_Name,
205: p_ledger_Id => p_ledger_Id,
206: p_Legal_Entity_Id => p_Legal_Entity_Id);
207: ELSE
205: p_ledger_Id => p_ledger_Id,
206: p_Legal_Entity_Id => p_Legal_Entity_Id);
207: ELSE
208: l_Error_Flag := 'Y';
209: END IF; --JA_CN_UTILITY.Check_Profile
210:
211: --If above check failed, then set status of concurrent program as warning
212: IF l_Error_Flag = 'Y' THEN
213: l_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
293: l_module_prefix || '.' || l_proc_name || '.parameters',
294: 'p_fiscal_year is ' || p_fiscal_year);
295: END IF; --(l_proc_level >= l_dbg_level)
296:
297: IF JA_CN_UTILITY.Check_Profile THEN
298: JA_CN_EAB_EXPORT_PKG.Execute_Export(P_COA_ID => l_coa_id
299: ,p_le_id => l_le_id
300: ,P_LEDGER_ID => l_ledger_id
301: ,p_fiscal_year => p_fiscal_year);
303: l_error_flag := 'Y';
304: retcode := 1;
305: errbuf := '';
306: RETURN;
307: END IF; --JA_CN_UTILITY.Check_Profile
308:
309: --If above check failed, then set status of concurrent program as warning
310:
311: /* IF l_error_flag = 'Y'
424: Dev_Status => l_Req_Status,
425: Message => l_Err_Msg) THEN
426: IF l_Req_Status = 'NORMAL' THEN
427: -- submit charset conversiong
428: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
429: p_Source_Charset => p_Src_Charset,
430: p_Destination_Charset => p_Dest_Charset,
431: p_Source_Separator => p_Separator,
432: x_Charset_Request_Id => l_Chr_Reqid,
432: x_Charset_Request_Id => l_Chr_Reqid,
433: x_Result_Flag => l_Chr_Result);
434: IF l_Chr_Result = 'Success' THEN
435: -- submit change output filename
436: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
437: p_Destination_Charset => p_Dest_Charset,
438: p_Destination_Filename => p_File_Name,
439: x_Filename_Request_Id => l_Fn_Reqid,
440: x_Result_Flag => l_Fn_Result);
582: -- messages, and the concurrent program will not continue performing next logics,these required
583: -- profiles include ' JG: Product', which should be set to 'Asia/Pacific Localizations',
584: -- 'JG: Territory', which should be set to 'China' and 'JA: CNAO Legal Entity', which should be
585: -- NOT NULL.
586: IF JA_CN_UTILITY.Check_Profile THEN
587: /*--Get sob id
588: JA_CN_UTILITY.Get_SOB_And_COA(l_le_id,
589: l_sob_id,
590: l_coa_id,
584: -- 'JG: Territory', which should be set to 'China' and 'JA: CNAO Legal Entity', which should be
585: -- NOT NULL.
586: IF JA_CN_UTILITY.Check_Profile THEN
587: /*--Get sob id
588: JA_CN_UTILITY.Get_SOB_And_COA(l_le_id,
589: l_sob_id,
590: l_coa_id,
591: l_sob_coa_flag);
592:
616: ELSE
617: retcode := 1;
618: errbuf := '';
619: RETURN;
620: END IF; -- JA_CN_UTILITY.Check_Profile
621:
622: IF l_flag = 0 THEN
623: JA_CN_COA_EXP_PKG.Coa_Export(errbuf => errbuf,
624: retcode => retcode,
763: fnd_file.PUT_LINE(fnd_file.LOG,'l_err_msg: '||l_err_msg);*/
764:
765: IF l_Req_Status = 'NORMAL' THEN
766: -- submit charset conversiong
767: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
768: p_Source_Charset => p_Source_Charset,
769: p_Destination_Charset => p_Destination_Charset,
770: p_Source_Separator => p_Source_Separator,
771: x_Charset_Request_Id => l_Chr_Reqid,
772: x_Result_Flag => l_Chr_Result);
773:
774: IF l_Chr_Result = 'Success' THEN
775: -- submit change output filename
776: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
777: p_Destination_Charset => p_Destination_Charset,
778: p_Destination_Filename => p_Destination_Filename,
779: x_Filename_Request_Id => l_Fn_Reqid,
780: x_Result_Flag => l_Fn_Result);
884: fnd_file.PUT_LINE(fnd_file.LOG,'l_req_status: '||l_req_status);
885: fnd_file.PUT_LINE(fnd_file.LOG,'l_err_msg: '||l_err_msg);*/
886: IF l_Req_Status = 'NORMAL' THEN
887: -- submit charset conversiong
888: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
889: p_Source_Charset => p_Source_Charset,
890: p_Destination_Charset => p_Destination_Charset,
891: p_Source_Separator => p_Source_Separator,
892: x_Charset_Request_Id => l_Chr_Reqid,
892: x_Charset_Request_Id => l_Chr_Reqid,
893: x_Result_Flag => l_Chr_Result);
894: IF l_Chr_Result = 'Success' THEN
895: -- submit change output filename
896: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
897: p_Destination_Charset => p_Destination_Charset,
898: p_Destination_Filename => p_Destination_Filename,
899: x_Filename_Request_Id => l_Fn_Reqid,
900: x_Result_Flag => l_Fn_Result);
1004: fnd_file.PUT_LINE(fnd_file.LOG,'l_req_status: '||l_req_status);
1005: fnd_file.PUT_LINE(fnd_file.LOG,'l_err_msg: '||l_err_msg);*/
1006: IF l_Req_Status = 'NORMAL' THEN
1007: -- submit charset conversiong
1008: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
1009: p_Source_Charset => p_Source_Charset,
1010: p_Destination_Charset => p_Destination_Charset,
1011: p_Source_Separator => p_Source_Separator,
1012: x_Charset_Request_Id => l_Chr_Reqid,
1012: x_Charset_Request_Id => l_Chr_Reqid,
1013: x_Result_Flag => l_Chr_Result);
1014: IF l_Chr_Result = 'Success' THEN
1015: -- submit change output filename
1016: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
1017: p_Destination_Charset => p_Destination_Charset,
1018: p_Destination_Filename => p_Destination_Filename,
1019: x_Filename_Request_Id => l_Fn_Reqid,
1020: x_Result_Flag => l_Fn_Result);
1126: fnd_file.PUT_LINE(fnd_file.LOG,'l_req_status: '||l_req_status);
1127: fnd_file.PUT_LINE(fnd_file.LOG,'l_err_msg: '||l_err_msg);*/
1128: IF l_Req_Status = 'NORMAL' THEN
1129: -- submit charset conversiong
1130: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
1131: p_Source_Charset => p_Source_Charset,
1132: p_Destination_Charset => p_Destination_Charset,
1133: p_Source_Separator => p_Source_Separator,
1134: x_Charset_Request_Id => l_Chr_Reqid,
1134: x_Charset_Request_Id => l_Chr_Reqid,
1135: x_Result_Flag => l_Chr_Result);
1136: IF l_Chr_Result = 'Success' THEN
1137: -- submit change output filename
1138: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
1139: p_Destination_Charset => p_Destination_Charset,
1140: p_Destination_Filename => p_Destination_Filename,
1141: x_Filename_Request_Id => l_Fn_Reqid,
1142: x_Result_Flag => l_Fn_Result);
1292: Dev_Status => l_Req_Status,
1293: Message => l_Err_Msg) THEN
1294: IF l_Req_Status = 'NORMAL' THEN
1295: -- submit charset conversiong
1296: Ja_Cn_Utility.Submit_Charset_Conversion(p_Xml_Request_Id => l_Reqid,
1297: p_Source_Charset => p_Source_Charset,
1298: p_Destination_Charset => p_Destination_Charset,
1299: p_Source_Separator => p_Source_Separator,
1300: x_Charset_Request_Id => l_Chr_Reqid,
1300: x_Charset_Request_Id => l_Chr_Reqid,
1301: x_Result_Flag => l_Chr_Result);
1302: IF l_Chr_Result = 'Success' THEN
1303: -- submit change output filename
1304: Ja_Cn_Utility.Change_Output_Filename(p_Xml_Request_Id => l_Reqid,
1305: p_Destination_Charset => p_Destination_Charset,
1306: p_Destination_Filename => p_Destination_Filename,
1307: x_Filename_Request_Id => l_Fn_Reqid,
1308: x_Result_Flag => l_Fn_Result);