DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_PROFILE

Line 1372: l_url:=FND_PROFILE.value ('JTA_UM_APPL_URL');

1368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1369: ibe_util.debug('NotifyRegistration :start notification for p_login_name='||p_login_name);
1370: END If;
1371: -- get the URL from the profile
1372: l_url:=FND_PROFILE.value ('JTA_UM_APPL_URL');
1373:
1374: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1375: ibe_util.debug('NotifyRegistration:l_url='||l_url);
1376: END If;

Line 1378: l_merchant_name:= FND_PROFILE.value('JTF_UM_MERCHANT_NAME');

1374: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1375: ibe_util.debug('NotifyRegistration:l_url='||l_url);
1376: END If;
1377: -- get the merchant name from the profile
1378: l_merchant_name:= FND_PROFILE.value('JTF_UM_MERCHANT_NAME');
1379: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1380: ibe_util.debug('NotifyRegistration:l_merchant_name='||l_merchant_name);
1381: END If;
1382: -- end-ab

Line 1965: l_admin_email_addr := FND_PROFILE.VALUE_SPECIFIC('IBE_ORDER_ADMIN',null,null,671);

1961: If l_notifEnabled = 'Y' Then
1962: IF ( p_status = 'S' ) THEN
1963: getUserType(l_partyId,l_UserType);
1964: if(l_userType = 'IBE_PARTNER' or l_userType = 'IBE_PARTNER_PRIMARY') THEN
1965: l_admin_email_addr := FND_PROFILE.VALUE_SPECIFIC('IBE_ORDER_ADMIN',null,null,671);
1966: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
1967: l_admin_adhoc_user := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id ;
1968: l_admin_adhoc_user_display := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id;
1969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1966: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

1962: IF ( p_status = 'S' ) THEN
1963: getUserType(l_partyId,l_UserType);
1964: if(l_userType = 'IBE_PARTNER' or l_userType = 'IBE_PARTNER_PRIMARY') THEN
1965: l_admin_email_addr := FND_PROFILE.VALUE_SPECIFIC('IBE_ORDER_ADMIN',null,null,671);
1966: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
1967: l_admin_adhoc_user := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id ;
1968: l_admin_adhoc_user_display := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id;
1969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1970: IBE_UTIL.DEBUG('Partner Order-AdminEmail '||l_admin_email_addr||'Name'||l_admin_adhoc_user||'preference'||l_notification_preference);

Line 1996: L_adhoc_user := FND_PROFILE.VALUE_SPECIFIC('IBE_DEF_ORDER_ADMIN_EMAIL',null,null,671);

1992: IBE_UTIL.DEBUG('Partner Order-Adhoc Role: '||l_adhoc_user);
1993: END IF;
1994: END IF; --Partner UserType End If
1995: Else
1996: L_adhoc_user := FND_PROFILE.VALUE_SPECIFIC('IBE_DEF_ORDER_ADMIN_EMAIL',null,null,671);
1997: l_orgId := null;
1998: l_userType := 'ALL';
1999: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
2000: l_order_id := c_quote_rec.order_id;

Line 2012: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');

2008: to view Price or not. This ibe_util.check_user_permission return TRUE if the permission
2009: to view net price is enabled for this user otherwise this function return false */
2010:
2011: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2012: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2013: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2014:
2015: IF (l_permission_to_view_price) THEN
2016: l_view_net_price_flag := 'Y';

Line 2013: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');

2009: to view net price is enabled for this user otherwise this function return false */
2010:
2011: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2012: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2013: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2014:
2015: IF (l_permission_to_view_price) THEN
2016: l_view_net_price_flag := 'Y';
2017: ELSE

Line 2273: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');

2269: to view Price or not. This ibe_util.check_user_permission return TRUE if the permission
2270: to view net price is enabled for this user otherwise this function return false */
2271:
2272: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2273: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2274: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2275:
2276: IF (l_permission_to_view_price) THEN
2277: l_view_net_price_flag := 'Y';

Line 2274: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');

2270: to view net price is enabled for this user otherwise this function return false */
2271:
2272: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2273: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2274: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2275:
2276: IF (l_permission_to_view_price) THEN
2277: l_view_net_price_flag := 'Y';
2278: ELSE

Line 3138: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');

3134: /*The following function call determines whether the user has permission
3135: to view Price or not. */
3136:
3137: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3138: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3139: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3140:
3141: IF (l_permission_to_view_price) THEN
3142: l_view_net_price_flag := 'Y';

Line 3139: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');

3135: to view Price or not. */
3136:
3137: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3138: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3139: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3140:
3141: IF (l_permission_to_view_price) THEN
3142: l_view_net_price_flag := 'Y';
3143: ELSE

Line 3641: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

3637: IF(IBE_UTIL.g_debugon = l_true) THEN
3638: IBE_UTIL.DEBUG('Contracts rep from database l_org_contract_rep: '||l_org_contract_rep);
3639: END IF;
3640:
3641: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
3642:
3643: IF ( p_salesrep_email_id is NOT NULL) THEN
3644: IF(IBE_UTIL.g_debugon = l_true) THEN
3645: IBE_UTIL.DEBUG(' p_salesrep_email_id is NOT NULL: '||p_salesrep_email_id );

Line 3995: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');

3991: /* Permission based pricing function call
3992: This function returns TRUE if the user has permission to view net price
3993: Otherwise this function will return FALSE */
3994: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3995: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3996: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3997:
3998:
3999: IF (l_permission_to_view_price) THEN

Line 3996: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');

3992: This function returns TRUE if the user has permission to view net price
3993: Otherwise this function will return FALSE */
3994: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3995: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3996: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3997:
3998:
3999: IF (l_permission_to_view_price) THEN
4000: l_view_net_price_flag := 'Y';

Line 4270: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

4266: l_sales_rep := c_rep_rec.sales_rep;
4267: END LOOP;
4268:
4269: l_notification_preference :=
4270: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4271:
4272: --Bug 2223507 start
4273: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4274: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN

Line 4775: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

4771: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_Quote_Header_id;
4772: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4773: ibe_util.debug('Notify_end_working:l_item_key: '||l_item_key);
4774: END IF;
4775: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4776:
4777: set_item_attributes
4778: ( p_item_key => l_item_key
4779: ,p_message_name => l_MessageName

Line 4882: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

4878:
4879: BEGIN
4880: x_return_status := FND_API.g_ret_sts_success ;
4881:
4882: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4883:
4884:
4885: l_context_code := p_context_code;
4886:

Line 5017: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5013: ||p_quote_access_rec.Quote_sharee_number;
5014: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5015: IBE_UTIL.DEBUG('Notify_finish_sharing:Item_key : '||l_item_key);
5016: END IF;
5017: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5018:
5019:
5020: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5021: IBE_UTIL.DEBUG('Notify_finish_sharing:Create_process start');

Line 5109: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5105:
5106: BEGIN
5107: x_return_status := FND_API.g_ret_sts_success ;
5108:
5109: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5110:
5111: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5112: IBE_UTIL.DEBUG('Notify_shared_cart:calling identify_cart_quote');
5113: END IF;

Line 5270: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5266: ||p_quote_access_rec.Quote_sharee_number;
5267: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5268: IBE_UTIL.DEBUG('Notify_shared_cart:Item_key: '||l_item_key);
5269: END IF;
5270: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5271:
5272: set_item_attributes
5273: ( p_item_key => l_item_key
5274: ,p_message_name => l_MessageName

Line 5371: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5367:
5368: BEGIN
5369: x_return_status := FND_API.g_ret_sts_success ;
5370:
5371: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5372: l_quote_access_rec := p_quote_access_rec;
5373:
5374: identify_cart_quote(p_quote_header_id => l_quote_access_rec.Quote_Header_id,
5375: x_is_it_quote => l_is_it_quote);

Line 5610: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5606: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5607: ibe_util.debug('Notification Name: '||l_notif_Name||' Enabled: '||l_notif_Enabled);
5608: END IF;
5609:
5610: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5611: locate_contact_point(
5612: p_contact_point_id => p_quote_access_rec.contact_point_id,
5613: x_create_adhoc_flag => l_create_adhoc_flag);
5614:

Line 5720: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5716: ELSE
5717: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id;
5718: END IF;
5719:
5720: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5721:
5722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5723: ibe_util.debug('view_shared_cart:item_key: '||l_item_key);
5724: ibe_util.debug('ready to create process');

Line 5985: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

5981: End if;
5982:
5983: if l_msgEnabled = 'Y' Then
5984: l_item_key := l_event_type||'-'||p_quoteShareeNum||'-'||p_Quote_Header_id;
5985: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5986: If p_emailaddress is not null Then
5987: l_adhoc_user := 'SCU'||p_quoteShareeNum||'Q'||p_Quote_Header_id ;
5988: l_adhoc_user_display := 'SCU'||p_quoteShareeNum||'Q'||p_Quote_Header_id;
5989: wf_directory.CreateAdHocUser(

Line 7367: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');

7363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7364: ibe_util.debug('p_quote_flag '||p_quote_flag);
7365: END IF;
7366: --Get Display Option class profile value
7367: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7368: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7369:
7370: IF(p_quote_flag = fnd_api.g_true) then
7371: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP

Line 7368: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');

7364: ibe_util.debug('p_quote_flag '||p_quote_flag);
7365: END IF;
7366: --Get Display Option class profile value
7367: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7368: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7369:
7370: IF(p_quote_flag = fnd_api.g_true) then
7371: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP
7372: if(g_notif_quote_line_rec.config_instance_name is not null) then

Line 9907: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

9903: --create an adhoc user with session lang and territory as preference
9904: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9905: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9906:
9907: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
9908:
9909: wf_directory.CreateAdHocUser(
9910: name => l_adhoc_user ,
9911: display_name => l_adhoc_user_display ,

Line 9979: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');

9975: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9976: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);
9977: END IF;
9978:
9979: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
9980:
9981: wf_directory.CreateAdHocRole
9982: (role_name => l_adhoc_role,
9983: role_display_name => l_adhoc_role_display,