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.IBE_WORKFLOW_PVT dependencies on IBE_WORKFLOW_PVT

Line 1: PACKAGE BODY ibe_workflow_pvt AS

1: PACKAGE BODY ibe_workflow_pvt AS
2: /* $Header: IBEVWFB.pls 120.36.12020000.3 2012/08/30 13:19:53 avitiwar ship $ */
3:
4: /*
5: ==============================================================================

Line 7: | ibe_workflow_pvt - Procedure for all iStore alerts that will be

3:
4: /*
5: ==============================================================================
6: | NAME
7: | ibe_workflow_pvt - Procedure for all iStore alerts that will be
8: | executed using Workflow
9: |
10: | MODIFICATION HISTORY
11: | 07/25/00 hjaganat Created for Account Registration

Line 1182: wf_core.context('ibe_workflow_pvt',

1178: When OTHERS Then
1179: x_return_status := FND_API.g_ret_sts_error;
1180: x_msg_count := 0;
1181:
1182: wf_core.context('ibe_workflow_pvt',
1183: 'NotifyRegistration',
1184: p_send_name
1185: );
1186: raise;

Line 1217: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_Approval_Msg');

1213: document_type := 'text/plain';
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1217: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_Approval_Msg');
1218: END IF;
1219:
1220: END;
1221: ----------------------added by abhandar :end -----------------------

Line 1263: IBE_UTIL.DEBUG('ibe_workflow_pvt.Generater_Credential l_credential_line =' || l_credential_line);

1259:
1260: END IF;
1261:
1262: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1263: IBE_UTIL.DEBUG('ibe_workflow_pvt.Generater_Credential l_credential_line =' || l_credential_line);
1264: END IF;
1265: document := l_credential_line;
1266:
1267: document_type := 'text/plain';

Line 1271: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_User_Credential_Msg');

1267: document_type := 'text/plain';
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1271: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_User_Credential_Msg');
1272: END IF;
1273: END Generate_Credential_Msg;
1274:
1275:

Line 1617: wf_core.context('ibe_workflow_pvt',

1613: Exception
1614: When OTHERS Then
1615: x_return_status := FND_API.g_ret_sts_error;
1616: x_msg_count := 0;
1617: wf_core.context('ibe_workflow_pvt',
1618: 'NotifyRegistration',
1619: p_login_name
1620: );
1621: raise;

Line 1801: wf_core.context('ibe_workflow_pvt', 'NotifyForgetLogin', p_login_name);

1797:
1798: WHEN OTHERS THEN
1799: x_return_status := FND_API.g_ret_sts_error;
1800: x_msg_count := 0;
1801: wf_core.context('ibe_workflow_pvt', 'NotifyForgetLogin', p_login_name);
1802: raise;
1803:
1804: END NotifyForgetLogin;
1805:

Line 2478: wf_core.context('ibe_workflow_pvt',

2474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2475: IBE_UTIL.DEBUG('NotifyOrderStatus:Exception block: '||SQLCODE||': '||SQLERRM);
2476: END IF;
2477:
2478: wf_core.context('ibe_workflow_pvt',
2479: 'NotifyOrderStatus',
2480: l_event_type,
2481: to_char(p_quote_id)
2482: );

Line 2706: wf_core.context('ibe_workflow_pvt',

2702: When OTHERS Then
2703: x_return_status := FND_API.g_ret_sts_error;
2704: x_msg_count := 0;
2705:
2706: wf_core.context('ibe_workflow_pvt',
2707: 'NotifyReturnOrderStatus',
2708: l_event_type,
2709: to_char(l_order_header_id)
2710: );

Line 2792: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_workflow_pvt';

2788: l_contact_mid_name VARCHAR2(2000);
2789: l_contact_last_name VARCHAR2(2000);
2790:
2791: l_party_type VARCHAR2(2000);
2792: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_workflow_pvt';
2793: l_api_name CONSTANT VARCHAR2(50) := 'Get_contact_details';
2794: l_api_version NUMBER := 1.0;
2795:
2796: BEGIN

Line 2953: ibe_workflow_pvt.get_contact_details_for_order

2949: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2950: IBE_UTIL.debug('Getting the contact party id');
2951: END IF;
2952: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2953: ibe_workflow_pvt.get_contact_details_for_order
2954: (p_api_version => 1.0 ,
2955: p_init_msg_list => FND_API.G_TRUE ,
2956: p_commit => FND_API.G_FALSE ,
2957: p_order_id => p_order_id ,

Line 3111: wf_core.context('ibe_workflow_pvt',

3107: Exception
3108: When OTHERS Then
3109: x_return_status := FND_API.g_ret_sts_error;
3110: x_msg_count := 0;
3111: wf_core.context('ibe_workflow_pvt',
3112: 'NotifyOrderStatus',
3113: l_event_type,
3114: to_char(p_order_id)
3115: );

Line 3438: wf_core.context('ibe_workflow_pvt',

3434: When OTHERS Then
3435: x_return_status := FND_API.g_ret_sts_error;
3436: x_msg_count := 0;
3437:
3438: wf_core.context('ibe_workflow_pvt',
3439: 'NotifyForContractsStatus',
3440: l_event_type,
3441: to_char(p_quote_id)
3442: );

Line 3866: wf_core.context('ibe_workflow_pvt','NotifyQuote',l_sales_event_type,to_char(p_quote_id));

3862: x_msg_count := 0;
3863: IF(IBE_UTIL.g_debugon = l_true) THEN
3864: IBE_UTIL.DEBUG('NotifyForContractsChange:Exception: '||SQLCODE||SQLERRM);
3865: END IF;
3866: wf_core.context('ibe_workflow_pvt','NotifyQuote',l_sales_event_type,to_char(p_quote_id));
3867: raise;
3868: END NotifyForContractsChange;
3869:
3870:

Line 4639: wf_core.context('ibe_workflow_pvt',

4635: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4636: IBE_UTIL.DEBUG('NotifySalesAssist:Exception block: '||SQLCODE||': '||SQLERRM);
4637: END IF;
4638:
4639: wf_core.context('ibe_workflow_pvt',
4640: 'NotifySalesAssistance',
4641: l_sales_event_type,
4642: to_char(p_quote_id)
4643: );

Line 4895: wf_core.context('IBE_WORKFLOW_PVT',l_notifname,l_messagename,p_quote_header_id);

4891:
4892: WHEN OTHERS THEN
4893: x_return_status := FND_API.g_ret_sts_error;
4894: x_msg_count := 0;
4895: wf_core.context('IBE_WORKFLOW_PVT',l_notifname,l_messagename,p_quote_header_id);
4896: RAISE;
4897:
4898: END Notify_End_Working;
4899:

Line 5138: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);

5134:
5135: WHEN OTHERS THEN
5136: x_return_status := FND_API.g_ret_sts_error;
5137: x_msg_count := 0;
5138: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5139: RAISE;
5140:
5141: END Notify_Finish_Sharing;
5142:

Line 5390: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);

5386:
5387: WHEN OTHERS THEN
5388: x_return_status := FND_API.g_ret_sts_error;
5389: x_msg_count := 0;
5390: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5391: RAISE;
5392:
5393: END Notify_Shared_Cart ;
5394:

Line 5636: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);

5632:
5633: WHEN OTHERS THEN
5634: x_return_status := FND_API.g_ret_sts_error;
5635: x_msg_count := 0;
5636: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5637: RAISE;
5638:
5639: END Notify_access_change;
5640:

Line 5934: --wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);

5930:
5931: WHEN OTHERS THEN
5932: x_return_status := FND_API.g_ret_sts_error;
5933: x_msg_count := 0;
5934: --wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5935: RAISE;
5936:
5937: END;
5938:

Line 6224: wf_core.context('ibe_workflow_pvt','SHAREDCART','SHAREDCART');

6220:
6221: When OTHERS Then
6222: x_return_status := FND_API.g_ret_sts_error;
6223: x_msg_count := 0;
6224: wf_core.context('ibe_workflow_pvt','SHAREDCART','SHAREDCART');
6225: raise;
6226: End NotifyForSharedCart;
6227:
6228:

Line 7791: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);

7787: l_document := l_document || rpad(ltrim(rtrim(ord_detail_tbl(i).item_number)),7)||' ';
7788: l_string_in := rtrim(ord_detail_tbl(i).item_description);
7789: l_string_out := '';
7790: l_string_left := '';
7791: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);
7792: l_document := l_document ||rpad(l_string_out,20)||' ' ;
7793: IF (ord_detail_tbl(i).source_order_number IS NOT NULL) THEN
7794: l_document := l_document || rpad(to_char(ord_detail_tbl(i).source_order_number),9)||' ';
7795: ELSE

Line 7832: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);

7828: IF (lr_length > 12) THEN
7829: lr_string_in := rtrim(ord_detail_tbl(i).return_reason_code);
7830: lr_string_out := '';
7831: lr_string_left := '';
7832: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7833: l_document := l_document||rpad(lr_string_out,11)|| NEWLINE;
7834: lr_length := length(lr_string_left);
7835: IF (lr_length > 0) THEN
7836: lr_string_in := lr_string_left;

Line 7858: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);

7854: WHILE length(l_string_in) > 0 or length(lr_string_in) > 0 LOOP
7855: IF (length(l_string_in) > 0) THEN
7856: l_string_out := '';
7857: l_string_left := '';
7858: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);
7859: IF l_view_net_price_flag = 'Y' THEN
7860: l_document := l_document ||rpad(' ',8)||rpad(l_string_out,20)||rpad(' ',32) ;
7861: ELSE
7862: l_document := l_document ||rpad(' ',8)||rpad(l_string_out,20)||rpad(' ',17) ;

Line 7869: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);

7865: l_string_in := l_string_left ;
7866: IF length(lr_string_in) > 0 THEN
7867: lr_string_out := '';
7868: lr_string_left := '';
7869: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7870: IF l_view_net_price_flag = 'Y' THEN
7871: l_print_len := 11;
7872: ELSE
7873: l_print_len := 11;

Line 7885: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);

7881: ELSE
7882: IF (length(lr_string_in) > 0 ) THEN
7883: lr_string_out := '';
7884: lr_string_left := '';
7885: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7886: --l_document := l_document ||TAB||TAB||TAB||TAB||lr_string_out||NEWLINE ;
7887: IF l_view_net_price_flag = 'Y' THEN
7888: l_print_len := 11;
7889: l_document := l_document ||rpad(' ',60)||rpad(lr_string_out,l_print_len)||NEWLINE;

Line 7944: ibe_workflow_pvt.Generate_Detail(

7940: BEGIN
7941: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7942: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');
7943: END IF;
7944: ibe_workflow_pvt.Generate_Detail(
7945: P_item_key => document_id,
7946: p_quote_flag => l_quote_flag,
7947: p_tax_flag => l_tax_flag,
7948: x_document => document

Line 7960: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_wtax');

7956:
7957: EXCEPTION
7958: WHEN OTHERS THEN
7959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7960: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_wtax');
7961: END IF;
7962:
7963: END;
7964: /********************************************************

Line 7990: ibe_workflow_pvt.GenerateReturnDetail(

7986: l_tax_flag VARCHAR2(1) := fnd_api.g_true;
7987:
7988: BEGIN
7989:
7990: ibe_workflow_pvt.GenerateReturnDetail(
7991: p_item_key => document_id,
7992: p_tax_flag => l_tax_flag,
7993: x_document => document
7994: );

Line 8005: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_wtax');

8001:
8002: EXCEPTION
8003: WHEN OTHERS THEN
8004: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8005: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_wtax');
8006: END IF;
8007:
8008: END Generate_Rtn_ord_Detail_wtax ;
8009:

Line 8028: ibe_workflow_pvt.Generate_Detail(

8024: BEGIN
8025: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8026: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');
8027: END IF;
8028: ibe_workflow_pvt.Generate_Detail(
8029: P_item_key => document_id,
8030: p_quote_flag => l_quote_flag,
8031: p_tax_flag => l_tax_flag,
8032: x_document => document

Line 8044: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_wtax');

8040:
8041: EXCEPTION
8042: WHEN OTHERS THEN
8043: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8044: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_wtax');
8045: END IF;
8046:
8047: END;
8048: --Added by mannamra

Line 8065: ibe_workflow_pvt.Generate_Detail(

8061: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8062: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8063: END IF;
8064: ----DBMS_OUTPUT.PUT('Generate_order_Detail_notax:START');
8065: ibe_workflow_pvt.Generate_Detail(
8066: P_item_key => document_id,
8067: p_quote_flag => l_quote_flag,
8068: p_tax_flag => l_tax_flag,
8069: x_document => document

Line 8080: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_notax');

8076: END IF;
8077: EXCEPTION
8078: WHEN OTHERS THEN
8079: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8080: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_notax');
8081: END IF;
8082:
8083: END;
8084:

Line 8111: ibe_workflow_pvt.GenerateReturnDetail(

8107: l_tax_flag VARCHAR2(1) := fnd_api.g_false;
8108:
8109: BEGIN
8110:
8111: ibe_workflow_pvt.GenerateReturnDetail(
8112: p_item_key => document_id,
8113: p_tax_flag => l_tax_flag,
8114: x_document => document
8115: );

Line 8126: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_notax');

8122:
8123: EXCEPTION
8124: WHEN OTHERS THEN
8125: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8126: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_notax');
8127: END IF;
8128:
8129: END Generate_Rtn_ord_Detail_notax;
8130:

Line 8149: ibe_workflow_pvt.Generate_Detail(

8145: BEGIN
8146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8147: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8148: END IF;
8149: ibe_workflow_pvt.Generate_Detail(
8150: P_item_key => document_id,
8151: p_quote_flag => l_quote_flag,
8152: p_tax_flag => l_tax_flag,
8153: x_document => document

Line 8165: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_notax');

8161:
8162: EXCEPTION
8163: WHEN OTHERS THEN
8164: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8165: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_notax');
8166: END IF;
8167:
8168: END;
8169: --existing API

Line 8276: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);

8272:
8273: l_string_in := rtrim(g_detail_rec.item_description);
8274: l_string_out := '';
8275: l_string_left := '';
8276: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
8277:
8278: l_document := l_document || l_string_out ||TAB;
8279: l_document := l_document || to_char(g_detail_rec.ordered_quantity)||TAB;
8280: l_document := l_document || l_ship_flag;

Line 8289: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);

8285: l_string_in := l_string_left;
8286: WHILE length(l_string_in) > 0 LOOP
8287: l_string_out := '';
8288: l_string_left := '';
8289: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
8290: l_document := l_document || l_string_out ||NEWLINE;
8291: l_string_in := l_string_left;
8292: END LOOP;
8293:

Line 9230: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);

9226:
9227: l_string_in := l_description;
9228: l_string_out := '';
9229: l_string_left := '';
9230: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
9231:
9232: l_document := l_document || l_string_out ||TAB;
9233: l_document := l_document || to_char(g_quote_line_rec.quantity)||TAB;
9234: l_document := l_document || l_ship_flag;

Line 9243: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);

9239: l_string_in := l_string_left;
9240: WHILE length(l_string_in) > 0 LOOP
9241: l_string_out := '';
9242: l_string_left := '';
9243: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
9244: l_document := l_document || l_string_out ||NEWLINE;
9245: l_string_in := l_string_left;
9246: END LOOP;
9247: l_document := l_document || NEWLINE;

Line 9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');

9918: l_email_addr VARCHAR2(2000);
9919:
9920: BEGIN
9921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);

Line 9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);

9919:
9920: BEGIN
9921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9927: END IF;

Line 9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);

9920: BEGIN
9921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9927: END IF;
9928:

Line 9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);

9921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9927: END IF;
9928:
9929: IF (p_user_id > 0) THEN

Line 9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);

9922: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9925: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9926: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9927: END IF;
9928:
9929: IF (p_user_id > 0) THEN
9930: IF (p_user_source IS NOT NULL AND p_user_source = 'HZ_PARTY') THEN

Line 10018: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user = '||x_adhoc_user);

10014:
10015: END IF;
10016:
10017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10018: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user = '||x_adhoc_user);
10019: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user:End') ;
10020: END IF;
10021:
10022: EXCEPTION

Line 10019: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user:End') ;

10015: END IF;
10016:
10017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10018: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user = '||x_adhoc_user);
10019: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user:End') ;
10020: END IF;
10021:
10022: EXCEPTION
10023: WHEN OTHERS THEN

Line 10025: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Exception occured');

10021:
10022: EXCEPTION
10023: WHEN OTHERS THEN
10024: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10025: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Exception occured');
10026: END IF;
10027: RAISE;
10028: END get_wf_user;
10029:

Line 10048: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Start');

10044:
10045: BEGIN
10046:
10047: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10048: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Start');
10049: END IF;
10050: IF (p_wf_users_tbl IS NULL OR p_wf_users_tbl.COUNT <= 0) THEN
10051: return;
10052: END IF;

Line 10071: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);

10067: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
10068: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
10069: END LOOP;
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:

Line 10087: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:End');

10083: expiration_date => sysdate + 1);
10084:
10085: x_wf_role := l_adhoc_role;
10086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10087: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:End');
10088: END IF;
10089:
10090: EXCEPTION
10091: WHEN OTHERS THEN

Line 10093: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Exception occured');

10089:
10090: EXCEPTION
10091: WHEN OTHERS THEN
10092: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10093: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Exception occured');
10094: END IF;
10095: RAISE;
10096: END get_wf_role;
10097:

Line 10396: END ibe_workflow_pvt;

10392: p_string_left := substr(p_string_in,p_string_len+1,length(p_string_in)-p_string_len);
10393: END IF;
10394: END parseString;
10395:
10396: END ibe_workflow_pvt;