DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_PROFILE

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

1378: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1379: ibe_util.debug('NotifyRegistration :start notification for p_login_name='||p_login_name);
1380: END If;
1381: -- get the URL from the profile
1382: l_url:=FND_PROFILE.value ('JTA_UM_APPL_URL');
1383:
1384: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1385: ibe_util.debug('NotifyRegistration:l_url='||l_url);
1386: END If;

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

1384: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1385: ibe_util.debug('NotifyRegistration:l_url='||l_url);
1386: END If;
1387: -- get the merchant name from the profile
1388: l_merchant_name:= FND_PROFILE.value('JTF_UM_MERCHANT_NAME');
1389: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1390: ibe_util.debug('NotifyRegistration:l_merchant_name='||l_merchant_name);
1391: END If;
1392: -- end-ab

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

2005: If l_notifEnabled = 'Y' Then
2006: IF ( p_status = 'S' ) THEN
2007: getUserType(l_partyId,l_UserType);
2008: if(l_userType = 'IBE_PARTNER' or l_userType = 'IBE_PARTNER_PRIMARY') THEN
2009: l_admin_email_addr := FND_PROFILE.VALUE_SPECIFIC('IBE_ORDER_ADMIN',null,null,671);
2010: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
2011: l_admin_adhoc_user := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id ;
2012: l_admin_adhoc_user_display := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id;
2013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2006: IF ( p_status = 'S' ) THEN
2007: getUserType(l_partyId,l_UserType);
2008: if(l_userType = 'IBE_PARTNER' or l_userType = 'IBE_PARTNER_PRIMARY') THEN
2009: l_admin_email_addr := FND_PROFILE.VALUE_SPECIFIC('IBE_ORDER_ADMIN',null,null,671);
2010: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
2011: l_admin_adhoc_user := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id ;
2012: l_admin_adhoc_user_display := 'IBEU'||to_char(sysdate,'MMDDYYHH24MISS')||'Q'||p_quote_id;
2013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2014: IBE_UTIL.DEBUG('Partner Order-AdminEmail '||l_admin_email_addr||'Name'||l_admin_adhoc_user||'preference'||l_notification_preference);

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

2036: IBE_UTIL.DEBUG('Partner Order-Adhoc Role: '||l_adhoc_user);
2037: END IF;
2038: END IF; --Partner UserType End If
2039: Else
2040: L_adhoc_user := FND_PROFILE.VALUE_SPECIFIC('IBE_DEF_ORDER_ADMIN_EMAIL',null,null,671);
2041: l_orgId := null;
2042: l_userType := 'ALL';
2043: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
2044: l_order_id := c_quote_rec.order_id;

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

2052: to view Price or not. This ibe_util.check_user_permission return TRUE if the permission
2053: to view net price is enabled for this user otherwise this function return false */
2054:
2055: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2056: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2057: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2058:
2059: IF (l_permission_to_view_price) THEN
2060: l_view_net_price_flag := 'Y';

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

2053: to view net price is enabled for this user otherwise this function return false */
2054:
2055: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2056: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2057: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2058:
2059: IF (l_permission_to_view_price) THEN
2060: l_view_net_price_flag := 'Y';
2061: ELSE

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

2342: to view Price or not. This ibe_util.check_user_permission return TRUE if the permission
2343: to view net price is enabled for this user otherwise this function return false */
2344:
2345: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2346: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2347: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2348:
2349: IF (l_permission_to_view_price) THEN
2350: l_view_net_price_flag := 'Y';

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

2343: to view net price is enabled for this user otherwise this function return false */
2344:
2345: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
2346: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
2347: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
2348:
2349: IF (l_permission_to_view_price) THEN
2350: l_view_net_price_flag := 'Y';
2351: ELSE

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

3229: /*The following function call determines whether the user has permission
3230: to view Price or not. */
3231:
3232: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3233: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3234: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3235:
3236: IF (l_permission_to_view_price) THEN
3237: l_view_net_price_flag := 'Y';

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

3230: to view Price or not. */
3231:
3232: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
3233: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
3234: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
3235:
3236: IF (l_permission_to_view_price) THEN
3237: l_view_net_price_flag := 'Y';
3238: ELSE

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

3732: IF(IBE_UTIL.g_debugon = l_true) THEN
3733: IBE_UTIL.DEBUG('Contracts rep from database l_org_contract_rep: '||l_org_contract_rep);
3734: END IF;
3735:
3736: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
3737:
3738: IF ( p_salesrep_email_id is NOT NULL) THEN
3739: IF(IBE_UTIL.g_debugon = l_true) THEN
3740: IBE_UTIL.DEBUG(' p_salesrep_email_id is NOT NULL: '||p_salesrep_email_id );

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

4086: /* Permission based pricing function call
4087: This function returns TRUE if the user has permission to view net price
4088: Otherwise this function will return FALSE */
4089: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
4090: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
4091: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
4092:
4093:
4094: IF (l_permission_to_view_price) THEN

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

4087: This function returns TRUE if the user has permission to view net price
4088: Otherwise this function will return FALSE */
4089: l_permission_to_view_price := ibe_util.check_user_permission( p_permission => 'IBE_VIEW_NET_PRICE' );
4090: l_paynow_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_PAY_NOW',null,null,671), 'N');
4091: l_reccharge_flag := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_ENABLE_RECURRING_CHARGES',null,null,671), 'N');
4092:
4093:
4094: IF (l_permission_to_view_price) THEN
4095: l_view_net_price_flag := 'Y';

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

4361: l_sales_rep := c_rep_rec.sales_rep;
4362: END LOOP;
4363:
4364: l_notification_preference :=
4365: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4366:
4367: --Bug 2223507 start
4368: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4369: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN

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

4866: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_Quote_Header_id;
4867: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4868: ibe_util.debug('Notify_end_working:l_item_key: '||l_item_key);
4869: END IF;
4870: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4871:
4872: set_item_attributes
4873: ( p_item_key => l_item_key
4874: ,p_message_name => l_MessageName

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

4973:
4974: BEGIN
4975: x_return_status := FND_API.g_ret_sts_success ;
4976:
4977: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4978:
4979:
4980: l_context_code := p_context_code;
4981:

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

5108: ||p_quote_access_rec.Quote_sharee_number;
5109: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5110: IBE_UTIL.DEBUG('Notify_finish_sharing:Item_key : '||l_item_key);
5111: END IF;
5112: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5113:
5114:
5115: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5116: IBE_UTIL.DEBUG('Notify_finish_sharing:Create_process start');

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

5200:
5201: BEGIN
5202: x_return_status := FND_API.g_ret_sts_success ;
5203:
5204: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5205:
5206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5207: IBE_UTIL.DEBUG('Notify_shared_cart:calling identify_cart_quote');
5208: END IF;

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

5361: ||p_quote_access_rec.Quote_sharee_number;
5362: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5363: IBE_UTIL.DEBUG('Notify_shared_cart:Item_key: '||l_item_key);
5364: END IF;
5365: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5366:
5367: set_item_attributes
5368: ( p_item_key => l_item_key
5369: ,p_message_name => l_MessageName

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

5462:
5463: BEGIN
5464: x_return_status := FND_API.g_ret_sts_success ;
5465:
5466: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5467: l_quote_access_rec := p_quote_access_rec;
5468:
5469: identify_cart_quote(p_quote_header_id => l_quote_access_rec.Quote_Header_id,
5470: x_is_it_quote => l_is_it_quote);

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

5701: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5702: ibe_util.debug('Notification Name: '||l_notif_Name||' Enabled: '||l_notif_Enabled);
5703: END IF;
5704:
5705: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5706: locate_contact_point(
5707: p_contact_point_id => p_quote_access_rec.contact_point_id,
5708: x_create_adhoc_flag => l_create_adhoc_flag);
5709:

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

5811: ELSE
5812: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id;
5813: END IF;
5814:
5815: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5816:
5817: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5818: ibe_util.debug('view_shared_cart:item_key: '||l_item_key);
5819: ibe_util.debug('ready to create process');

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

6076: End if;
6077:
6078: if l_msgEnabled = 'Y' Then
6079: l_item_key := l_event_type||'-'||p_quoteShareeNum||'-'||p_Quote_Header_id;
6080: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
6081: If p_emailaddress is not null Then
6082: l_adhoc_user := 'SCU'||p_quoteShareeNum||'Q'||p_Quote_Header_id ;
6083: l_adhoc_user_display := 'SCU'||p_quoteShareeNum||'Q'||p_Quote_Header_id;
6084: wf_directory.CreateAdHocUser(

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

7458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7459: ibe_util.debug('p_quote_flag '||p_quote_flag);
7460: END IF;
7461: --Get Display Option class profile value
7462: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7463: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7464:
7465: IF(p_quote_flag = fnd_api.g_true) then
7466: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP

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

7459: ibe_util.debug('p_quote_flag '||p_quote_flag);
7460: END IF;
7461: --Get Display Option class profile value
7462: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7463: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7464:
7465: IF(p_quote_flag = fnd_api.g_true) then
7466: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP
7467: if(g_notif_quote_line_rec.config_instance_name is not null) then

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

9998: --create an adhoc user with session lang and territory as preference
9999: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10000: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10001:
10002: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
10003:
10004: wf_directory.CreateAdHocUser(
10005: name => l_adhoc_user ,
10006: display_name => l_adhoc_user_display ,

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

10070: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10071: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);
10072: END IF;
10073:
10074: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
10075:
10076: wf_directory.CreateAdHocRole
10077: (role_name => l_adhoc_role,
10078: role_display_name => l_adhoc_role_display,