eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PUBLISH_MISC_INT dependencies on ASO_QUOTE_UTIL_PVT

Line 133: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

129: From wf_local_roles
130: Where name= c_role_name;
131:
132: BEGIN
133: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
134: IF l_debug = 'Y' THEN
135: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
136: END IF;
137:

Line 135: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

131:
132: BEGIN
133: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
134: IF l_debug = 'Y' THEN
135: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
136: END IF;
137:
138: IF l_debug = 'Y' THEN
139: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');

Line 139: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');

135: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
136: END IF;
137:
138: IF l_debug = 'Y' THEN
139: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
140: END IF;
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:

Line 150: ASO_QUOTE_UTIL_PVT.Debug('Check if this notification is enabled.');

146: g_ItemType := 'IBEALERT';
147: END LOOP;
148:
149: IF l_debug = 'Y' THEN
150: ASO_QUOTE_UTIL_PVT.Debug('Check if this notification is enabled.');
151: END IF;
152:
153: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
154: IF l_debug = 'Y' THEN

Line 155: ASO_QUOTE_UTIL_PVT.Debug('Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled);

151: END IF;
152:
153: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
154: IF l_debug = 'Y' THEN
155: ASO_QUOTE_UTIL_PVT.Debug('Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled);
156: END IF;
157:
158: If l_notifEnabled = 'Y' Then
159: l_adhoc_user := upper(p_send_name);

Line 179: ASO_QUOTE_UTIL_PVT.Debug('Get Message - Org_id: '||to_char(l_orgId) ||' User Type: '||l_userType);

175:
176: getUserType(l_partyId,l_UserType);
177:
178: IF l_debug = 'Y' THEN
179: ASO_QUOTE_UTIL_PVT.Debug('Get Message - Org_id: '||to_char(l_orgId) ||' User Type: '||l_userType);
180: END IF;
181:
182: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
183: l_resource_id := c_quote_rec.resource_id;

Line 196: ASO_QUOTE_UTIL_PVT.Debug('Calling Mapping api...'|| 'Org_id :' || l_OrgId);

192: l_full_name := l_last_name || ', ' || l_first_name;
193:
194:
195: IF l_debug = 'Y' THEN
196: ASO_QUOTE_UTIL_PVT.Debug('Calling Mapping api...'|| 'Org_id :' || l_OrgId);
197: END IF;
198:
199: if( g_ItemType = 'IBEALERT') Then
200:

Line 219: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);

215: END IF;
216:
217:
218: IF l_debug = 'Y' THEN
219: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
220: END IF;
221:
222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
223: raise FND_API.G_EXC_ERROR;

Line 239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);

235: l_last_update_date, l_last_update_login;
236: close c_get_role_details;
237:
238: IF l_debug = 'Y' THEN
239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);

Line 240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);

236: close c_get_role_details;
237:
238: IF l_debug = 'Y' THEN
239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);

Line 241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);

237:
238: IF l_debug = 'Y' THEN
239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);

Line 242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);

238: IF l_debug = 'Y' THEN
239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);

Line 243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);

239: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);

Line 244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);

240: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

Line 245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);

241: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

Line 246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);

242: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

Line 247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);

243: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);

Line 248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

244: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);
252: END IF;

Line 249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

245: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);
252: END IF;
253:

Line 250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

246: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);
252: END IF;
253:
254:

Line 251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);

247: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
248: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
249: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
250: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
251: ASO_QUOTE_UTIL_PVT.Debug('p_email_address : '||p_email_address);
252: END IF;
253:
254:
255: wf_parameters := NULL;

Line 277: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');

273: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',l_last_update_login
274: ,wf_parameters);
275:
276: IF l_debug = 'Y' THEN
277: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');
278: END IF;
279:
280: wf_local_synch.propagate_role(p_orig_system =>l_orig_system,
281: p_orig_system_id =>l_orig_system_id,

Line 287: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');

283: p_start_date =>l_start,
284: p_expiration_date =>l_end);
285:
286: IF l_debug = 'Y' THEN
287: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');
288: END IF;
289:
290: -- end bug 5221658
291:

Line 297: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);

293:
294: l_item_key := l_notifName||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_send_name;
295:
296: IF l_debug = 'Y' THEN
297: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);
298: END IF;
299:
300: wf_engine.CreateProcess(
301: itemtype => g_ItemType,

Line 380: ASO_QUOTE_UTIL_PVT.Debug('Process Started');

376: itemtype => g_ItemType,
377: itemkey => l_item_key);
378:
379: IF l_debug = 'Y' THEN
380: ASO_QUOTE_UTIL_PVT.Debug('Process Started');
381: END IF;
382:
383: End If;
384: End If;

Line 387: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

383: End If;
384: End If;
385:
386: IF l_debug = 'Y' THEN
387: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
388: END IF;
389:
390: Exception
391:

Line 400: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

396: wf_core.context('ASO_IBE_INT', 'NotifyUserForRegistration', p_send_name);
397: raise;
398:
399: IF l_debug = 'Y' THEN
400: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
401: END IF;
402:
403: END NotifyUserForRegistration;
404:

Line 504: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

500: From wf_local_roles
501: Where name= c_role_name;
502:
503: BEGIN
504: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
505: IF l_debug = 'Y' THEN
506: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
507: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
508: END IF;

Line 506: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

502:
503: BEGIN
504: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
505: IF l_debug = 'Y' THEN
506: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
507: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
508: END IF;
509:
510: x_return_status := FND_API.g_ret_sts_success;

Line 507: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');

503: BEGIN
504: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
505: IF l_debug = 'Y' THEN
506: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
507: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
508: END IF;
509:
510: x_return_status := FND_API.g_ret_sts_success;
511:

Line 522: ASO_QUOTE_UTIL_PVT.Debug('SOURCE Status done');

518: l_quoteDestStatusId := c_quote_statuses_rec.quote_status_id;
519: END LOOP;
520:
521: IF l_debug = 'Y' THEN
522: ASO_QUOTE_UTIL_PVT.Debug('SOURCE Status done');
523: END IF;
524:
525: ASO_VALIDATE_PVT.Validate_Status_Transition(
526: p_init_msg_list => FND_API.G_FALSE,

Line 534: ASO_QUOTE_UTIL_PVT.Debug('Calling Validate_Status_Transition done ' || x_return_status );

530: x_msg_count => x_msg_count,
531: x_msg_data => x_msg_data);
532:
533: IF l_debug = 'Y' THEN
534: ASO_QUOTE_UTIL_PVT.Debug('Calling Validate_Status_Transition done ' || x_return_status );
535: END IF;
536:
537: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
538: l_notifName := 'ASOQOTPUBLISHEXEC';

Line 554: ASO_QUOTE_UTIL_PVT.Debug('Check if this notification is enabled.');

550: END LOOP;
551:
552:
553: IF l_debug = 'Y' THEN
554: ASO_QUOTE_UTIL_PVT.Debug('Check if this notification is enabled.');
555: END IF;
556:
557: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
558:

Line 560: ASO_QUOTE_UTIL_PVT.Debug('Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled);

556:
557: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
558:
559: IF l_debug = 'Y' THEN
560: ASO_QUOTE_UTIL_PVT.Debug('Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled);
561: END IF;
562:
563: If l_notifEnabled = 'Y' Then
564: l_adhoc_user := upper(p_send_name);

Line 583: ASO_QUOTE_UTIL_PVT.Debug('Get Message - Org_id: '||to_char(l_orgId) ||' User Type: '||l_userType);

579:
580: getUserType(l_partyId,l_UserType);
581:
582: IF l_debug = 'Y' THEN
583: ASO_QUOTE_UTIL_PVT.Debug('Get Message - Org_id: '||to_char(l_orgId) ||' User Type: '||l_userType);
584: END IF;
585:
586: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
587: l_resource_id := c_quote_rec.resource_id;

Line 603: ASO_QUOTE_UTIL_PVT.Debug('Calling Mapping api...'|| 'Org_id :' || l_OrgId);

599: l_cart_name := c_quote_rec.quote_name;
600: END LOOP;
601:
602: IF l_debug = 'Y' THEN
603: ASO_QUOTE_UTIL_PVT.Debug('Calling Mapping api...'|| 'Org_id :' || l_OrgId);
604: END IF;
605:
606:
607: -- get env language

Line 633: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);

629: END IF;
630:
631:
632: IF l_debug = 'Y' THEN
633: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
634: END IF;
635:
636: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
637: raise FND_API.G_EXC_ERROR;

Line 645: ASO_QUOTE_UTIL_PVT.Debug('Create workflow adhoc user for Sales Rep');

641:
642: If l_msgEnabled = 'Y' Then
643: -- bug 2107290 # code Start
644: IF l_debug = 'Y' THEN
645: ASO_QUOTE_UTIL_PVT.Debug('Create workflow adhoc user for Sales Rep');
646: END IF;
647: l_sales_adhoc_user := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id ;
648: l_sales_adhoc_user_display := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
649:

Line 652: ASO_QUOTE_UTIL_PVT.Debug(' l_notification_preference '||l_notification_preference);

648: l_sales_adhoc_user_display := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
649:
650: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
651: IF l_debug = 'Y' THEN
652: ASO_QUOTE_UTIL_PVT.Debug(' l_notification_preference '||l_notification_preference);
653: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_user '||l_sales_adhoc_user);
654: END IF;
655: -- move the CreateAdHocUser Api to a local block -- skm
656: begin

Line 653: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_user '||l_sales_adhoc_user);

649:
650: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
651: IF l_debug = 'Y' THEN
652: ASO_QUOTE_UTIL_PVT.Debug(' l_notification_preference '||l_notification_preference);
653: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_user '||l_sales_adhoc_user);
654: END IF;
655: -- move the CreateAdHocUser Api to a local block -- skm
656: begin
657:

Line 667: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of Ad Hoc User');

663: expiration_date => sysdate + 1,
664: language => l_nls_language);
665:
666: IF l_debug = 'Y' THEN
667: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of Ad Hoc User');
668: END IF;
669:
670: exception
671:

Line 675: ASO_QUOTE_UTIL_PVT.Debug ('Create Ad Hoc User failed');

671:
672: when others then
673:
674: IF l_debug = 'Y' THEN
675: ASO_QUOTE_UTIL_PVT.Debug ('Create Ad Hoc User failed');
676: END IF;
677:
678: end;
679: IF l_debug = 'Y' THEN

Line 680: ASO_QUOTE_UTIL_PVT.Debug('Create workflow role user for Sales Rep');

676: END IF;
677:
678: end;
679: IF l_debug = 'Y' THEN
680: ASO_QUOTE_UTIL_PVT.Debug('Create workflow role user for Sales Rep');
681: END IF;
682:
683: l_role_users := l_adhoc_user ||','||l_sales_adhoc_user;
684: l_sales_adhoc_role := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;

Line 688: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_role '||l_sales_adhoc_role);

684: l_sales_adhoc_role := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
685: l_sales_adhoc_role_display := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
686:
687: IF l_debug = 'Y' THEN
688: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_role '||l_sales_adhoc_role);
689: ASO_QUOTE_UTIL_PVT.Debug(' l_role_users '||l_role_users);
690: END IF;
691: -- move the CreateAdHocRole api to a local block --skm
692: begin

Line 689: ASO_QUOTE_UTIL_PVT.Debug(' l_role_users '||l_role_users);

685: l_sales_adhoc_role_display := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
686:
687: IF l_debug = 'Y' THEN
688: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_role '||l_sales_adhoc_role);
689: ASO_QUOTE_UTIL_PVT.Debug(' l_role_users '||l_role_users);
690: END IF;
691: -- move the CreateAdHocRole api to a local block --skm
692: begin
693:

Line 703: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of AdHoc Role');

699: role_users => l_role_users,
700: expiration_date => sysdate + 1);
701:
702: IF l_debug = 'Y' THEN
703: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of AdHoc Role');
704: END IF;
705: exception
706:
707: when others then

Line 710: ASO_QUOTE_UTIL_PVT.Debug('CreateAdHocRole api failed');

706:
707: when others then
708:
709: IF l_debug = 'Y' THEN
710: ASO_QUOTE_UTIL_PVT.Debug('CreateAdHocRole api failed');
711: END IF;
712:
713: end;
714:

Line 721: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);

717:
718: l_item_key := l_notifName||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_send_name;
719:
720: IF l_debug = 'Y' THEN
721: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);
722: END IF;
723:
724:
725: wf_engine.CreateProcess(

Line 811: ASO_QUOTE_UTIL_PVT.Debug('Process Started');

807: itemtype => g_ItemType,
808: itemkey => l_item_key);
809:
810: IF l_debug = 'Y' THEN
811: ASO_QUOTE_UTIL_PVT.Debug('Process Started');
812: END IF;
813:
814: End If;
815: End If;

Line 828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);

824: l_last_update_date, l_last_update_login;
825: close c_get_role_details;
826:
827: IF l_debug = 'Y' THEN
828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);

Line 829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);

825: close c_get_role_details;
826:
827: IF l_debug = 'Y' THEN
828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);

Line 830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);

826:
827: IF l_debug = 'Y' THEN
828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);

Line 831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);

827: IF l_debug = 'Y' THEN
828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);

Line 832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);

828: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);

Line 833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);

829: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

Line 834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);

830: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

Line 835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);

831: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

Line 836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);

832: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
840: END IF;

Line 837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

833: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
840: END IF;
841:

Line 838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

834: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
840: END IF;
841:
842:

Line 839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

835: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
836: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
837: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
838: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
839: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
840: END IF;
841:
842:
843: wf_parameters := NULL;

Line 863: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');

859: wf_event.AddParameterToList('LAST_UPDATE_LOGIN',l_last_update_login
860: ,wf_parameters);
861:
862: IF l_debug = 'Y' THEN
863: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');
864: END IF;
865:
866: wf_local_synch.propagate_role(p_orig_system =>l_orig_system,
867: p_orig_system_id =>l_orig_system_id,

Line 873: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');

869: p_start_date =>l_start,
870: p_expiration_date =>l_end);
871:
872: IF l_debug = 'Y' THEN
873: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');
874: END IF;
875:
876: -- end bug 5221658
877:

Line 883: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

879:
880:
881:
882: IF l_debug = 'Y' THEN
883: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
884: END IF;
885: Exception
886:
887: When OTHERS Then

Line 891: ASO_QUOTE_UTIL_PVT.Debug('Error in NotifiyForQuotePublish');

887: When OTHERS Then
888:
889:
890: IF l_debug = 'Y' THEN
891: ASO_QUOTE_UTIL_PVT.Debug('Error in NotifiyForQuotePublish');
892: END IF;
893:
894: x_return_status := FND_API.g_ret_sts_error;
895: x_msg_count := 0;

Line 900: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;

896:
897: wf_core.context('ASO_IBE_INT', 'NotifyForQuotePublish', p_send_name);
898: raise;
899:
900: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
901: IF l_debug = 'Y' THEN
902: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
903: END IF;
904:

Line 902: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

898: raise;
899:
900: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
901: IF l_debug = 'Y' THEN
902: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
903: END IF;
904:
905: END NotifyForQuotePublish;
906:

Line 1344: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

1340: and l.subject_table_name = 'HZ_PARTIES'
1341: and l.subject_type = 'PERSON';
1342:
1343: BEGIN
1344: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1345: IF l_debug = 'Y' THEN
1346: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1347: END IF;
1348: -- Standard Start of API savepoint

Line 1346: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

1342:
1343: BEGIN
1344: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1345: IF l_debug = 'Y' THEN
1346: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1347: END IF;
1348: -- Standard Start of API savepoint
1349: SAVEPOINT create_Store_User_int;
1350: IF l_debug = 'Y' THEN

Line 1352: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');

1348: -- Standard Start of API savepoint
1349: SAVEPOINT create_Store_User_int;
1350: IF l_debug = 'Y' THEN
1351:
1352: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1353:
1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);

Line 1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);

1350: IF l_debug = 'Y' THEN
1351:
1352: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1353:
1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);

Line 1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);

1351:
1352: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1353:
1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);

Line 1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);

1352: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1353:
1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1360:

Line 1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);

1353:
1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1360:
1361: END IF;

Line 1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);

1354: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1360:
1361: END IF;
1362:

Line 1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);

1355: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1356: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1357: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1358: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1359: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1360:
1361: END IF;
1362:
1363: -- Standard call to check for call compatibility.

Line 1424: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec1.primary_language_indicator);

1420:
1421: if (l_debug = 'Y') then
1422:
1423:
1424: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec1.primary_language_indicator);
1425:
1426: ASO_QUOTE_UTIL_PVT.Debug('Language use reference id '|| to_char(l_lang_rec1.language_use_reference_id));
1427:
1428: end if;

Line 1426: ASO_QUOTE_UTIL_PVT.Debug('Language use reference id '|| to_char(l_lang_rec1.language_use_reference_id));

1422:
1423:
1424: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec1.primary_language_indicator);
1425:
1426: ASO_QUOTE_UTIL_PVT.Debug('Language use reference id '|| to_char(l_lang_rec1.language_use_reference_id));
1427:
1428: end if;
1429:
1430:

Line 1441: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.update_person_language - unset Primary Language Indicator');

1437: x_msg_data => l_msg_data);
1438:
1439: if (l_debug = 'Y') then
1440:
1441: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.update_person_language - unset Primary Language Indicator');
1442:
1443: end if;
1444: -- set primary language indicator
1445:

Line 1461: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);

1457:
1458: if (l_debug = 'Y') then
1459:
1460:
1461: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1462:
1463: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1464:
1465: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);

Line 1463: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));

1459:
1460:
1461: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1462:
1463: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1464:
1465: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);
1466:
1467: end if;

Line 1465: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);

1461: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1462:
1463: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1464:
1465: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);
1466:
1467: end if;
1468: hz_person_info_v2pub.create_person_language(
1469: p_person_language_rec => l_lang_rec2,

Line 1478: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.create_person_language');

1474:
1475: if (l_debug = 'Y') then
1476:
1477:
1478: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.create_person_language');
1479:
1480: end if;
1481:
1482: ELSE

Line 1489: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '||l_lang_rec2.primary_language_indicator);

1485: l_lang_rec2.language_use_reference_id := l_id;
1486:
1487: if (l_debug = 'Y') then
1488:
1489: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '||l_lang_rec2.primary_language_indicator);
1490: ASO_QUOTE_UTIL_PVT.Debug('Language Use Reference Id '||to_char(l_lang_rec2.language_use_reference_id));
1491:
1492: end if;
1493:

Line 1490: ASO_QUOTE_UTIL_PVT.Debug('Language Use Reference Id '||to_char(l_lang_rec2.language_use_reference_id));

1486:
1487: if (l_debug = 'Y') then
1488:
1489: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '||l_lang_rec2.primary_language_indicator);
1490: ASO_QUOTE_UTIL_PVT.Debug('Language Use Reference Id '||to_char(l_lang_rec2.language_use_reference_id));
1491:
1492: end if;
1493:
1494: hz_person_info_v2pub.update_person_language(

Line 1516: ASO_QUOTE_UTIL_PVT.Debug('Error in iStore User Creation');

1512:
1513: if (l_debug = 'Y') then
1514:
1515:
1516: ASO_QUOTE_UTIL_PVT.Debug('Error in iStore User Creation');
1517:
1518: end if;
1519: end;
1520:

Line 1522: ASO_QUOTE_UTIL_PVT.Debug ('End create_Store_User_int procedure');

1518: end if;
1519: end;
1520:
1521: IF l_debug = 'Y' THEN
1522: ASO_QUOTE_UTIL_PVT.Debug ('End create_Store_User_int procedure');
1523: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1524:
1525: END IF;
1526:

Line 1523: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1519: end;
1520:
1521: IF l_debug = 'Y' THEN
1522: ASO_QUOTE_UTIL_PVT.Debug ('End create_Store_User_int procedure');
1523: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1524:
1525: END IF;
1526:
1527: EXCEPTION

Line 1531: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');

1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error
1529: THEN
1530: IF l_debug = 'Y' THEN
1531: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1532: END IF;
1533: aso_utility_pvt.handle_exceptions (
1534: p_api_name => l_api_name,
1535: p_pkg_name => g_pkg_name,

Line 1545: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1541: x_msg_data => x_msg_data,
1542: x_return_status => x_return_status
1543: );
1544: IF l_debug = 'Y' THEN
1545: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1546: END IF;
1547:
1548: WHEN fnd_api.g_exc_unexpected_error
1549: THEN

Line 1551: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');

1547:
1548: WHEN fnd_api.g_exc_unexpected_error
1549: THEN
1550: IF l_debug = 'Y' THEN
1551: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1552: END IF;
1553: aso_utility_pvt.handle_exceptions (
1554: p_api_name => l_api_name,
1555: p_pkg_name => g_pkg_name,

Line 1565: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1561: x_msg_data => x_msg_data,
1562: x_return_status => x_return_status
1563: );
1564: IF l_debug = 'Y' THEN
1565: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1566: END IF;
1567:
1568: WHEN OTHERS
1569: THEN

Line 1571: ASO_QUOTE_UTIL_PVT.Debug ('When Others Exception in createStoreUser ');

1567:
1568: WHEN OTHERS
1569: THEN
1570: IF l_debug = 'Y' THEN
1571: ASO_QUOTE_UTIL_PVT.Debug ('When Others Exception in createStoreUser ');
1572: END IF;
1573: aso_utility_pvt.handle_exceptions (
1574: p_api_name => l_api_name,
1575: p_pkg_name => g_pkg_name,

Line 1600: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

1596: l_api_name CONSTANT VARCHAR2(30) := 'TestUserName' ;
1597: l_debug VARCHAR2(1);
1598: BEGIN
1599:
1600: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1601: IF l_debug = 'Y' THEN
1602: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1603: END IF;
1604:

Line 1602: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

1598: BEGIN
1599:
1600: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1601: IF l_debug = 'Y' THEN
1602: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1603: END IF;
1604:
1605: x_return_status := Fnd_Api.g_ret_sts_success;
1606:

Line 1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');

1604:
1605: x_return_status := Fnd_Api.g_ret_sts_success;
1606:
1607: IF l_debug = 'Y' THEN
1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1610: END IF;
1611:
1612: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);

Line 1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);

1605: x_return_status := Fnd_Api.g_ret_sts_success;
1606:
1607: IF l_debug = 'Y' THEN
1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1610: END IF;
1611:
1612: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);
1613:

Line 1617: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);

1613:
1614: x_msg_data := fnd_message.get;
1615:
1616: IF l_debug = 'Y' THEN
1617: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1618: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1619: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1620: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1621: END IF;

Line 1618: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');

1614: x_msg_data := fnd_message.get;
1615:
1616: IF l_debug = 'Y' THEN
1617: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1618: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1619: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1620: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1621: END IF;
1622:

Line 1619: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);

1615:
1616: IF l_debug = 'Y' THEN
1617: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1618: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1619: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1620: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1621: END IF;
1622:
1623: EXCEPTION

Line 1620: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1616: IF l_debug = 'Y' THEN
1617: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1618: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1619: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1620: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1621: END IF;
1622:
1623: EXCEPTION
1624:

Line 1638: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1634: ,X_RETURN_STATUS => X_RETURN_STATUS
1635: );
1636:
1637: IF l_debug = 'Y' THEN
1638: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1639: END IF;
1640:
1641: END TestUserName;
1642: