[Home] [Help]
150: ,'Begin Procedure. ');
151: END IF;
152:
153: -- wrap parameter to record
154: IF (fnd_profile.VALUE('AR_GTA_ENABLED') = 'Y')
155: THEN
156: l_parameters.customer_num_from := p_customer_num_from;
157: l_parameters.customer_num_to := p_customer_num_to;
158: l_parameters.customer_name_from := p_customer_name_from;
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;
288: l_summary xmltype;
289: l_parameter xmltype;
290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);
292: l_no_data_message VARCHAR2(500);
293: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
294: l_proc_level NUMBER := fnd_log.level_procedure;
341: "ARTrxGLDateTo"))
342: INTO l_parameter
343: FROM dual;
344:
345: fnd_profile.get('AR_GTA_ENABLED'
346: ,l_ar_gta_enabled);
347:
348: IF nvl(l_ar_gta_enabled
349: ,'N') = 'N'
515: l_gt_inv_date_from DATE;
516: l_gt_inv_date_to DATE;
517: l_ar_inv_date_from DATE;
518: l_ar_inv_date_to DATE;
519: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
520: l_ar_gta_gta_not_enabled VARCHAR2(500);
521: l_report xmltype;
522: l_parameter xmltype;
523: l_dbg_msg VARCHAR2(500);
538: l_gt_inv_date_to := fnd_date.canonical_to_date(p_gt_inv_date_to);
539: l_ar_inv_date_from := fnd_date.canonical_to_date(p_ar_inv_date_from);
540: l_ar_inv_date_to := fnd_date.canonical_to_date(p_ar_inv_date_to);
541:
542: fnd_profile.get('AR_GTA_ENABLED'
543: ,l_ar_gta_enabled);
544: IF nvl(l_ar_gta_enabled
545: ,'N') = 'N'
546: THEN
681: ,g_module_prefix || l_procedure_name || '.begin'
682: ,'Procedure begin');
683: END IF;
684:
685: IF fnd_profile.VALUE('AR_GTA_ENABLED') = 'N'
686: THEN
687: fnd_message.set_name('AR'
688: ,'AR_GTA_GTA_NOT_ENABLE');
689:
820: ,g_module_prefix || l_procedure_name || '.begin'
821: ,'Procedure begin');
822: END IF;
823:
824: IF fnd_profile.VALUE('AR_GTA_ENABLED') = 'N'
825: THEN
826: fnd_message.set_name('AR'
827: ,'AR_GTA_GTA_NOT_ENABLE');
828: l_ar_gta_gta_not_enabled := '//' || fnd_message.get;
928: ,g_module_prefix || l_procedure_name || '.begin'
929: ,'Procedure begin');
930: END IF;
931:
932: IF fnd_profile.VALUE('AR_GTA_ENABLED') = 'N'
933: THEN
934: fnd_message.set_name('AR'
935: ,'AR_GTA_GTA_NOT_ENABLE');
936: l_ar_gta_gta_not_enabled := '//' || fnd_message.get;
1134: END IF; --( l_proc_level >= l_dbg_level )
1135:
1136:
1137: --To Get value of profile AR:Golden Tax Enabled
1138: l_ar_gta_enabled := fnd_profile.VALUE(NAME => 'AR_GTA_ENABLED');
1139:
1140: IF (l_ar_gta_enabled IS NULL)
1141: OR --The profile AR:Golden Tax Enabled is Null or set to 'N'
1142: (l_ar_gta_enabled = 'N')
1337:
1338: END IF; --( l_proc_level >= l_dbg_level )
1339:
1340: --To Get value of profile AR:Golden Tax Enabled
1341: l_ar_gta_enabled := fnd_profile.VALUE(NAME => 'AR_GTA_ENABLED');
1342:
1343: IF (l_ar_gta_enabled IS NULL)
1344: OR --The profile AR:Golden Tax Enabled is Null or set to 'N'
1345: (l_ar_gta_enabled = 'N')
1453: ,g_module_prefix || l_procedure_name
1454: ,'Begin Procedure. ');
1455: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1456:
1457: IF (fnd_profile.VALUE('AR_GTA_ENABLED') = 'Y')
1458: THEN
1459: ar_gta_txt_operator_proc.export_customers(p_org_id => l_org_id
1460: ,p_customer_num_from => p_customer_num_from
1461: ,p_customer_num_to => p_customer_num_to
1465: ,p_creation_date_from => fnd_date.canonical_to_date(p_creation_date_from)
1466: ,p_creation_date_to => fnd_date.canonical_to_date(p_creation_date_to));
1467:
1468: ELSE
1469: /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1470: -- report AR_GTA_DISABLE_ERROR in xml format
1471: -- set concurrent status to WARNING
1472: fnd_message.set_name('AR'
1473: ,'AR_GTA_GTA_NOT_ENABLE');
1478:
1479: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
1480: ,message => l_ar_gta_gta_not_enabled);
1481: RETURN;
1482: END IF; /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1483: -- procedure end
1484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1485: THEN
1486: fnd_log.STRING(fnd_log.level_procedure
1543: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1544: , G_MODULE_PREFIX ||'.'|| l_procedure_name
1545: ,'Begin Procedure. ');
1546: END IF;
1547: IF (fnd_profile.VALUE('AR_GTA_ENABLED') = 'Y')
1548: THEN
1549: l_consol_paras.consolidation_id := p_consolidation_id;
1550: l_consol_paras.same_pri_same_dis := p_same_pri_same_dis;
1551: l_consol_paras.same_pri_diff_dis := p_same_pri_diff_dis;
1640: ,p_invoice_type IN VARCHAR2
1641: )
1642: IS
1643: l_procedure_name VARCHAR2(30) := 'Run_Consolidation_Mapping';
1644: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
1645: l_ar_gta_gta_not_enabled VARCHAR2(500);
1646: l_report xmltype;
1647: l_parameter xmltype;
1648: l_dbg_msg VARCHAR2(500);
1660: ,g_module_prefix || l_procedure_name || '.begin'
1661: ,'enter procedure');
1662: END IF;
1663:
1664: fnd_profile.get('AR_GTA_ENABLED', l_ar_gta_enabled);
1665:
1666: IF NVL(l_ar_gta_enabled ,'N') = 'N'
1667: THEN
1668: /* commented by Allen Yang 02-Sep-2009 for bug 8848798
1787: ,g_module_prefix || l_procedure_name || '.begin'
1788: ,'Procedure begin');
1789: END IF;
1790:
1791: IF fnd_profile.VALUE('AR_GTA_ENABLED') = 'N'
1792: THEN
1793: fnd_message.set_name('AR'
1794: ,'AR_GTA_GTA_NOT_ENABLE');
1795:
1872: ,g_module_prefix || l_procedure_name || '.begin'
1873: ,'Procedure begin');
1874: END IF;
1875:
1876: IF fnd_profile.VALUE('AR_GTA_ENABLED') = 'N'
1877: THEN
1878: fnd_message.set_name('AR'
1879: ,'AR_GTA_GTA_NOT_ENABLE');
1880: