APPS.MSC_X_CUST_FACING_RELEASE dependencies on FND_PROFILE

Line 4: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');

1: PACKAGE BODY MSC_X_CUST_FACING_RELEASE AS
2: /* $Header: */
3:
4: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
5: G_VMI_OM_ORDER_TYPE VARCHAR2(30) := FND_PROFILE.VALUE('MSC_X_VMI_OM_ORDER_TYPE');
6:
7: -- This procesure prints out message to user
8: PROCEDURE log_message( p_user_info IN VARCHAR2)

Line 5: G_VMI_OM_ORDER_TYPE VARCHAR2(30) := FND_PROFILE.VALUE('MSC_X_VMI_OM_ORDER_TYPE');

1: PACKAGE BODY MSC_X_CUST_FACING_RELEASE AS
2: /* $Header: */
3:
4: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
5: G_VMI_OM_ORDER_TYPE VARCHAR2(30) := FND_PROFILE.VALUE('MSC_X_VMI_OM_ORDER_TYPE');
6:
7: -- This procesure prints out message to user
8: PROCEDURE log_message( p_user_info IN VARCHAR2)
9: IS

Line 708: l_request_date := to_date(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));

704: log_debug('Source Organization : '|| l_source_org_id );
705: log_debug('Customer Modeled Org : '|| l_cust_organization_id );
706: log_debug('UOM Code : '|| l_uom_code );
707:
708: l_request_date := to_date(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));
709: -- bug 5248018
710: log_debug('Request Date: '||l_request_date);
711: log_debug('Date format: '||NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));
712:

Line 711: log_debug('Date format: '||NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));

707:
708: l_request_date := to_date(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));
709: -- bug 5248018
710: log_debug('Request Date: '||l_request_date);
711: log_debug('Date format: '||NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));
712:
713: IF (l_vmi_type = G_CONSIGNED_VMI) then
714:
715: log_message('Consigned VMI ');

Line 723: l_request_date := to_date(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));

719: log_message('Creating Sales Order for the Consumption Advice.');
720: lv_action := G_CREATE;
721: lv_transaction_type := G_VMI_OM_ORDER_TYPE;
722: l_request_date := nvl(l_cons_request_date,sysdate);
723: l_request_date := to_date(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY'));
724:
725: elsif (l_transaction_type = G_REPLENISHMENT) then
726: /* Create internal req which inturn will create Int. Sales Order */
727: log_message('Creating Internal Requisition for the Replenishment .');

Line 731: to_char(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY')),

727: log_message('Creating Internal Requisition for the Replenishment .');
728: MSC_X_REPLENISH.create_requisition
729: ( l_inventory_item_id,
730: l_order_quantity,
731: to_char(l_request_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY')),
732: G_OEM_ID, --- customer id
733: l_cust_organization_id, --- customer site id
734: l_source_org_id, --- supplier id , in this case Source_org_id
735: -1, -- supplier_site_id