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 278: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');

274: ,wf_parameters);
275:
276: /* Commented as per code change for Bug 8711723
277: IF l_debug = 'Y' THEN
278: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');
279: END IF;
280:
281:
282: wf_local_synch.propagate_role(p_orig_system =>l_orig_system,

Line 292: ASO_QUOTE_UTIL_PVT.Debug('Bug : 8711723 , Before Calling propagate_user API 1');

288:
289: /*** Code change start for Bug 8711723 ***/
290:
291: IF l_debug = 'Y' THEN
292: ASO_QUOTE_UTIL_PVT.Debug('Bug : 8711723 , Before Calling propagate_user API 1');
293: END IF;
294:
295: wf_local_synch.propagate_user(p_orig_system =>l_orig_system,
296: p_orig_system_id =>l_orig_system_id,

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

300:
301: /*** Code change end for Bug 8711723 ***/
302:
303: IF l_debug = 'Y' THEN
304: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');
305: END IF;
306:
307: -- end bug 5221658
308:

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

310:
311: l_item_key := l_notifName||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_send_name;
312:
313: IF l_debug = 'Y' THEN
314: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);
315: END IF;
316:
317: wf_engine.CreateProcess(
318: itemtype => g_ItemType,

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

393: itemtype => g_ItemType,
394: itemkey => l_item_key);
395:
396: IF l_debug = 'Y' THEN
397: ASO_QUOTE_UTIL_PVT.Debug('Process Started');
398: END IF;
399:
400: End If;
401: End If;

Line 404: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

400: End If;
401: End If;
402:
403: IF l_debug = 'Y' THEN
404: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
405: END IF;
406:
407: Exception
408:

Line 417: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

413: wf_core.context('ASO_IBE_INT', 'NotifyUserForRegistration', p_send_name);
414: raise;
415:
416: IF l_debug = 'Y' THEN
417: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
418: END IF;
419:
420: END NotifyUserForRegistration;
421:

Line 521: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

517: From wf_local_roles
518: Where name= c_role_name;
519:
520: BEGIN
521: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
522: IF l_debug = 'Y' THEN
523: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
524: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
525: END IF;

Line 523: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

519:
520: BEGIN
521: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
522: IF l_debug = 'Y' THEN
523: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
524: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
525: END IF;
526:
527: x_return_status := FND_API.g_ret_sts_success;

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

520: BEGIN
521: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
522: IF l_debug = 'Y' THEN
523: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
524: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
525: END IF;
526:
527: x_return_status := FND_API.g_ret_sts_success;
528:

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

535: l_quoteDestStatusId := c_quote_statuses_rec.quote_status_id;
536: END LOOP;
537:
538: IF l_debug = 'Y' THEN
539: ASO_QUOTE_UTIL_PVT.Debug('SOURCE Status done');
540: END IF;
541:
542: ASO_VALIDATE_PVT.Validate_Status_Transition(
543: p_init_msg_list => FND_API.G_FALSE,

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

547: x_msg_count => x_msg_count,
548: x_msg_data => x_msg_data);
549:
550: IF l_debug = 'Y' THEN
551: ASO_QUOTE_UTIL_PVT.Debug('Calling Validate_Status_Transition done ' || x_return_status );
552: END IF;
553:
554: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
555: l_notifName := 'ASOQOTPUBLISHEXEC';

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

567: END LOOP;
568:
569:
570: IF l_debug = 'Y' THEN
571: ASO_QUOTE_UTIL_PVT.Debug('Check if this notification is enabled.');
572: END IF;
573:
574: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
575:

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

573:
574: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
575:
576: IF l_debug = 'Y' THEN
577: ASO_QUOTE_UTIL_PVT.Debug('Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled);
578: END IF;
579:
580: If l_notifEnabled = 'Y' Then
581: l_adhoc_user := upper(p_send_name);

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

596:
597: getUserType(l_partyId,l_UserType);
598:
599: IF l_debug = 'Y' THEN
600: ASO_QUOTE_UTIL_PVT.Debug('Get Message - Org_id: '||to_char(l_orgId) ||' User Type: '||l_userType);
601: END IF;
602:
603: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
604: l_resource_id := c_quote_rec.resource_id;

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

616: l_cart_name := c_quote_rec.quote_name;
617: END LOOP;
618:
619: IF l_debug = 'Y' THEN
620: ASO_QUOTE_UTIL_PVT.Debug('Calling Mapping api...'|| 'Org_id :' || l_OrgId);
621: END IF;
622:
623:
624: -- get env language

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

646: END IF;
647:
648:
649: IF l_debug = 'Y' THEN
650: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
651: END IF;
652:
653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
654: raise FND_API.G_EXC_ERROR;

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

658:
659: If l_msgEnabled = 'Y' Then
660: -- bug 2107290 # code Start
661: IF l_debug = 'Y' THEN
662: ASO_QUOTE_UTIL_PVT.Debug('Create workflow adhoc user for Sales Rep');
663: END IF;
664: l_sales_adhoc_user := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id ;
665: l_sales_adhoc_user_display := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
666:

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

665: l_sales_adhoc_user_display := 'QOTU'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
666:
667: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
668: IF l_debug = 'Y' THEN
669: ASO_QUOTE_UTIL_PVT.Debug(' l_notification_preference '||l_notification_preference);
670: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_user '||l_sales_adhoc_user);
671: END IF;
672: -- move the CreateAdHocUser Api to a local block -- skm
673: begin

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

666:
667: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
668: IF l_debug = 'Y' THEN
669: ASO_QUOTE_UTIL_PVT.Debug(' l_notification_preference '||l_notification_preference);
670: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_user '||l_sales_adhoc_user);
671: END IF;
672: -- move the CreateAdHocUser Api to a local block -- skm
673: begin
674:

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

680: expiration_date => sysdate + 1,
681: language => l_nls_language);
682:
683: IF l_debug = 'Y' THEN
684: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of Ad Hoc User');
685: END IF;
686:
687: exception
688:

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

688:
689: when others then
690:
691: IF l_debug = 'Y' THEN
692: ASO_QUOTE_UTIL_PVT.Debug ('Create Ad Hoc User failed');
693: END IF;
694:
695: end;
696: IF l_debug = 'Y' THEN

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

693: END IF;
694:
695: end;
696: IF l_debug = 'Y' THEN
697: ASO_QUOTE_UTIL_PVT.Debug('Create workflow role user for Sales Rep');
698: END IF;
699:
700: l_role_users := l_adhoc_user ||','||l_sales_adhoc_user;
701: l_sales_adhoc_role := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;

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

701: l_sales_adhoc_role := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
702: l_sales_adhoc_role_display := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
703:
704: IF l_debug = 'Y' THEN
705: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_role '||l_sales_adhoc_role);
706: ASO_QUOTE_UTIL_PVT.Debug(' l_role_users '||l_role_users);
707: END IF;
708: -- move the CreateAdHocRole api to a local block --skm
709: begin

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

702: l_sales_adhoc_role_display := 'QOTR'||to_char(sysdate,'MMDDYYHH24MISS')||'P'||p_quote_id;
703:
704: IF l_debug = 'Y' THEN
705: ASO_QUOTE_UTIL_PVT.Debug(' l_sales_adhoc_role '||l_sales_adhoc_role);
706: ASO_QUOTE_UTIL_PVT.Debug(' l_role_users '||l_role_users);
707: END IF;
708: -- move the CreateAdHocRole api to a local block --skm
709: begin
710:

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

716: role_users => l_role_users,
717: expiration_date => sysdate + 1);
718:
719: IF l_debug = 'Y' THEN
720: ASO_QUOTE_UTIL_PVT.Debug('Successful creation of AdHoc Role');
721: END IF;
722: exception
723:
724: when others then

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

723:
724: when others then
725:
726: IF l_debug = 'Y' THEN
727: ASO_QUOTE_UTIL_PVT.Debug('CreateAdHocRole api failed');
728: END IF;
729:
730: end;
731:

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

734:
735: l_item_key := l_notifName||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_send_name;
736:
737: IF l_debug = 'Y' THEN
738: ASO_QUOTE_UTIL_PVT.Debug('Create and Start Process with Item Key: '||l_item_key);
739: END IF;
740:
741:
742: wf_engine.CreateProcess(

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

824: itemtype => g_ItemType,
825: itemkey => l_item_key);
826:
827: IF l_debug = 'Y' THEN
828: ASO_QUOTE_UTIL_PVT.Debug('Process Started');
829: END IF;
830:
831: End If;
832: End If;

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

841: l_last_update_date, l_last_update_login;
842: close c_get_role_details;
843:
844: IF l_debug = 'Y' THEN
845: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);

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

842: close c_get_role_details;
843:
844: IF l_debug = 'Y' THEN
845: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);

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

843:
844: IF l_debug = 'Y' THEN
845: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);

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

844: IF l_debug = 'Y' THEN
845: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);

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

845: ASO_QUOTE_UTIL_PVT.Debug('Printing the details for the role: '||l_adhoc_user);
846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);

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

846: ASO_QUOTE_UTIL_PVT.Debug('l_display_name : '||l_display_name);
847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

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

847: ASO_QUOTE_UTIL_PVT.Debug('l_description : '||l_description);
848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

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

848: ASO_QUOTE_UTIL_PVT.Debug('l_start : '||l_start);
849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
856: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

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

849: ASO_QUOTE_UTIL_PVT.Debug('l_end : '||l_end);
850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
856: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
857: END IF;

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

850: ASO_QUOTE_UTIL_PVT.Debug('l_fax : '||l_fax);
851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
856: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
857: END IF;
858:

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

851: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system : '||l_orig_system);
852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
856: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
857: END IF;
858:
859:

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

852: ASO_QUOTE_UTIL_PVT.Debug('l_orig_system_id : '||l_orig_system_id);
853: ASO_QUOTE_UTIL_PVT.Debug('l_partition : '||l_partition);
854: ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);
855: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);
856: ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);
857: END IF;
858:
859:
860: wf_parameters := NULL;

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

877: ,wf_parameters);
878:
879: /* Commented as per code change for Bug 8711723
880: IF l_debug = 'Y' THEN
881: ASO_QUOTE_UTIL_PVT.Debug('Before Calling propagate_role API');
882: END IF;
883:
884: wf_local_synch.propagate_role(p_orig_system =>l_orig_system,
885: p_orig_system_id =>l_orig_system_id,

Line 893: ASO_QUOTE_UTIL_PVT.Debug('Bug : 8711723 , Before Calling propagate_user API 2');

889: */
890:
891: /*** Code change start for Bug 8711723 ***/
892: IF l_debug = 'Y' THEN
893: ASO_QUOTE_UTIL_PVT.Debug('Bug : 8711723 , Before Calling propagate_user API 2');
894: END IF;
895:
896: wf_local_synch.propagate_user(p_orig_system =>l_orig_system,
897: p_orig_system_id =>l_orig_system_id,

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

900: p_expiration_date =>l_end);
901: /*** Code change end for Bug 8711723 ***/
902:
903: IF l_debug = 'Y' THEN
904: ASO_QUOTE_UTIL_PVT.Debug('After Calling propagate_role API');
905: END IF;
906:
907: -- end bug 5221658
908:

Line 914: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

910:
911:
912:
913: IF l_debug = 'Y' THEN
914: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
915: END IF;
916: Exception
917:
918: When OTHERS Then

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

918: When OTHERS Then
919:
920:
921: IF l_debug = 'Y' THEN
922: ASO_QUOTE_UTIL_PVT.Debug('Error in NotifiyForQuotePublish');
923: END IF;
924:
925: x_return_status := FND_API.g_ret_sts_error;
926: x_msg_count := 0;

Line 931: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;

927:
928: wf_core.context('ASO_IBE_INT', 'NotifyForQuotePublish', p_send_name);
929: raise;
930:
931: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
932: IF l_debug = 'Y' THEN
933: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
934: END IF;
935:

Line 933: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

929: raise;
930:
931: -- ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
932: IF l_debug = 'Y' THEN
933: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
934: END IF;
935:
936: END NotifyForQuotePublish;
937:

Line 1375: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

1371: and l.subject_table_name = 'HZ_PARTIES'
1372: and l.subject_type = 'PERSON';
1373:
1374: BEGIN
1375: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1376: IF l_debug = 'Y' THEN
1377: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1378: END IF;
1379: -- Standard Start of API savepoint

Line 1377: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

1373:
1374: BEGIN
1375: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1376: IF l_debug = 'Y' THEN
1377: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1378: END IF;
1379: -- Standard Start of API savepoint
1380: SAVEPOINT create_Store_User_int;
1381: IF l_debug = 'Y' THEN

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

1379: -- Standard Start of API savepoint
1380: SAVEPOINT create_Store_User_int;
1381: IF l_debug = 'Y' THEN
1382:
1383: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1384:
1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);

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

1381: IF l_debug = 'Y' THEN
1382:
1383: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1384:
1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);

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

1382:
1383: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1384:
1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1390: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);

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

1383: ASO_QUOTE_UTIL_PVT.Debug('aso_publish_misc_int: createStoreUser: Start %%%%%%%%%%%%%%%%%%%');
1384:
1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1390: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1391:

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

1384:
1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1390: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1391:
1392: END IF;

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

1385: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_name: '|| p_user_name);
1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1390: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1391:
1392: END IF;
1393:

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

1386: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_user_password: '|| p_user_password);
1387: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_Address: '|| p_email_address);
1388: ASO_QUOTE_UTIL_PVT.Debug('createStoreUser: p_email_language: '|| p_email_language);
1389: ASO_QUOTE_UTIL_PVT.Debug('p_party_id: '|| p_party_id);
1390: ASO_QUOTE_UTIL_PVT.Debug('p_party_type: '|| p_party_type);
1391:
1392: END IF;
1393:
1394: -- Standard call to check for call compatibility.

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

1451:
1452: if (l_debug = 'Y') then
1453:
1454:
1455: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec1.primary_language_indicator);
1456:
1457: ASO_QUOTE_UTIL_PVT.Debug('Language use reference id '|| to_char(l_lang_rec1.language_use_reference_id));
1458:
1459: end if;

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

1453:
1454:
1455: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec1.primary_language_indicator);
1456:
1457: ASO_QUOTE_UTIL_PVT.Debug('Language use reference id '|| to_char(l_lang_rec1.language_use_reference_id));
1458:
1459: end if;
1460:
1461:

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

1468: x_msg_data => l_msg_data);
1469:
1470: if (l_debug = 'Y') then
1471:
1472: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.update_person_language - unset Primary Language Indicator');
1473:
1474: end if;
1475: -- set primary language indicator
1476:

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

1488:
1489: if (l_debug = 'Y') then
1490:
1491:
1492: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1493:
1494: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1495:
1496: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);

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

1490:
1491:
1492: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1493:
1494: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1495:
1496: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);
1497:
1498: end if;

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

1492: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '|| l_lang_rec2.primary_language_indicator);
1493:
1494: ASO_QUOTE_UTIL_PVT.Debug('party_id '|| to_char(l_lang_rec2.party_id));
1495:
1496: ASO_QUOTE_UTIL_PVT.Debug('language_name '||l_lang_rec2.language_name);
1497:
1498: end if;
1499: hz_person_info_v2pub.create_person_language(
1500: p_person_language_rec => l_lang_rec2,

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

1505:
1506: if (l_debug = 'Y') then
1507:
1508:
1509: ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.create_person_language');
1510:
1511: end if;
1512:
1513: ELSE

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

1516: l_lang_rec2.language_use_reference_id := l_id;
1517:
1518: if (l_debug = 'Y') then
1519:
1520: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '||l_lang_rec2.primary_language_indicator);
1521: ASO_QUOTE_UTIL_PVT.Debug('Language Use Reference Id '||to_char(l_lang_rec2.language_use_reference_id));
1522:
1523: end if;
1524:

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

1517:
1518: if (l_debug = 'Y') then
1519:
1520: ASO_QUOTE_UTIL_PVT.Debug('Primary Language Indicator '||l_lang_rec2.primary_language_indicator);
1521: ASO_QUOTE_UTIL_PVT.Debug('Language Use Reference Id '||to_char(l_lang_rec2.language_use_reference_id));
1522:
1523: end if;
1524:
1525: hz_person_info_v2pub.update_person_language(

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

1543:
1544: if (l_debug = 'Y') then
1545:
1546:
1547: ASO_QUOTE_UTIL_PVT.Debug('Error in iStore User Creation');
1548:
1549: end if;
1550: end;
1551:

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

1549: end if;
1550: end;
1551:
1552: IF l_debug = 'Y' THEN
1553: ASO_QUOTE_UTIL_PVT.Debug ('End create_Store_User_int procedure');
1554: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1555:
1556: END IF;
1557:

Line 1554: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1550: end;
1551:
1552: IF l_debug = 'Y' THEN
1553: ASO_QUOTE_UTIL_PVT.Debug ('End create_Store_User_int procedure');
1554: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1555:
1556: END IF;
1557:
1558: EXCEPTION

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

1558: EXCEPTION
1559: WHEN fnd_api.g_exc_error
1560: THEN
1561: IF l_debug = 'Y' THEN
1562: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1563: END IF;
1564: aso_utility_pvt.handle_exceptions (
1565: p_api_name => l_api_name,
1566: p_pkg_name => g_pkg_name,

Line 1576: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1572: x_msg_data => x_msg_data,
1573: x_return_status => x_return_status
1574: );
1575: IF l_debug = 'Y' THEN
1576: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1577: END IF;
1578:
1579: WHEN fnd_api.g_exc_unexpected_error
1580: THEN

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

1578:
1579: WHEN fnd_api.g_exc_unexpected_error
1580: THEN
1581: IF l_debug = 'Y' THEN
1582: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1583: END IF;
1584: aso_utility_pvt.handle_exceptions (
1585: p_api_name => l_api_name,
1586: p_pkg_name => g_pkg_name,

Line 1596: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1592: x_msg_data => x_msg_data,
1593: x_return_status => x_return_status
1594: );
1595: IF l_debug = 'Y' THEN
1596: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1597: END IF;
1598:
1599: WHEN OTHERS
1600: THEN

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

1598:
1599: WHEN OTHERS
1600: THEN
1601: IF l_debug = 'Y' THEN
1602: ASO_QUOTE_UTIL_PVT.Debug ('When Others Exception in createStoreUser ');
1603: END IF;
1604: aso_utility_pvt.handle_exceptions (
1605: p_api_name => l_api_name,
1606: p_pkg_name => g_pkg_name,

Line 1631: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

1627: l_api_name CONSTANT VARCHAR2(30) := 'TestUserName' ;
1628: l_debug VARCHAR2(1);
1629: BEGIN
1630:
1631: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1632: IF l_debug = 'Y' THEN
1633: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1634: END IF;
1635:

Line 1633: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;

1629: BEGIN
1630:
1631: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1632: IF l_debug = 'Y' THEN
1633: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1634: END IF;
1635:
1636: x_return_status := Fnd_Api.g_ret_sts_success;
1637:

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

1635:
1636: x_return_status := Fnd_Api.g_ret_sts_success;
1637:
1638: IF l_debug = 'Y' THEN
1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1640: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1641: END IF;
1642:
1643: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);

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

1636: x_return_status := Fnd_Api.g_ret_sts_success;
1637:
1638: IF l_debug = 'Y' THEN
1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1640: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1641: END IF;
1642:
1643: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);
1644:

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

1644:
1645: x_msg_data := fnd_message.get;
1646:
1647: IF l_debug = 'Y' THEN
1648: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1649: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1650: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1651: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1652: END IF;

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

1645: x_msg_data := fnd_message.get;
1646:
1647: IF l_debug = 'Y' THEN
1648: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1649: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1650: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1651: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1652: END IF;
1653:

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

1646:
1647: IF l_debug = 'Y' THEN
1648: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1649: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1650: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1651: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1652: END IF;
1653:
1654: EXCEPTION

Line 1651: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1647: IF l_debug = 'Y' THEN
1648: ASO_QUOTE_UTIL_PVT.Debug('x_test_user_status '||x_test_user_status);
1649: ASO_QUOTE_UTIL_PVT.Debug('Successful completion of TestUserName');
1650: ASO_QUOTE_UTIL_PVT.Debug('Return Status '||x_return_status);
1651: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1652: END IF;
1653:
1654: EXCEPTION
1655:

Line 1669: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

1665: ,X_RETURN_STATUS => X_RETURN_STATUS
1666: );
1667:
1668: IF l_debug = 'Y' THEN
1669: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1670: END IF;
1671:
1672: END TestUserName;
1673: