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.32 2006/09/19 06:03:43 aannamal 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 1172: wf_core.context('ibe_workflow_pvt',

1168: When OTHERS Then
1169: x_return_status := FND_API.g_ret_sts_error;
1170: x_msg_count := 0;
1171:
1172: wf_core.context('ibe_workflow_pvt',
1173: 'NotifyRegistration',
1174: p_send_name
1175: );
1176: raise;

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

1203: document_type := 'text/plain';
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1207: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_Approval_Msg');
1208: END IF;
1209:
1210: END;
1211: ----------------------added by abhandar :end -----------------------

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

1249:
1250: END IF;
1251:
1252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1253: IBE_UTIL.DEBUG('ibe_workflow_pvt.Generater_Credential l_credential_line =' || l_credential_line);
1254: END IF;
1255: document := l_credential_line;
1256:
1257: document_type := 'text/plain';

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

1257: document_type := 'text/plain';
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1261: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_User_Credential_Msg');
1262: END IF;
1263: END Generate_Credential_Msg;
1264:
1265:

Line 1607: wf_core.context('ibe_workflow_pvt',

1603: Exception
1604: When OTHERS Then
1605: x_return_status := FND_API.g_ret_sts_error;
1606: x_msg_count := 0;
1607: wf_core.context('ibe_workflow_pvt',
1608: 'NotifyRegistration',
1609: p_login_name
1610: );
1611: raise;

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

1787:
1788: WHEN OTHERS THEN
1789: x_return_status := FND_API.g_ret_sts_error;
1790: x_msg_count := 0;
1791: wf_core.context('ibe_workflow_pvt', 'NotifyForgetLogin', p_login_name);
1792: raise;
1793:
1794: END NotifyForgetLogin;
1795:

Line 2405: wf_core.context('ibe_workflow_pvt',

2401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2402: IBE_UTIL.DEBUG('NotifyOrderStatus:Exception block: '||SQLCODE||': '||SQLERRM);
2403: END IF;
2404:
2405: wf_core.context('ibe_workflow_pvt',
2406: 'NotifyOrderStatus',
2407: l_event_type,
2408: to_char(p_quote_id)
2409: );

Line 2616: wf_core.context('ibe_workflow_pvt',

2612: When OTHERS Then
2613: x_return_status := FND_API.g_ret_sts_error;
2614: x_msg_count := 0;
2615:
2616: wf_core.context('ibe_workflow_pvt',
2617: 'NotifyReturnOrderStatus',
2618: l_event_type,
2619: to_char(l_order_header_id)
2620: );

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

2698: l_contact_mid_name VARCHAR2(2000);
2699: l_contact_last_name VARCHAR2(2000);
2700:
2701: l_party_type VARCHAR2(2000);
2702: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_workflow_pvt';
2703: l_api_name CONSTANT VARCHAR2(50) := 'Get_contact_details';
2704: l_api_version NUMBER := 1.0;
2705:
2706: BEGIN

Line 2863: ibe_workflow_pvt.get_contact_details_for_order

2859: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2860: IBE_UTIL.debug('Getting the contact party id');
2861: END IF;
2862: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2863: ibe_workflow_pvt.get_contact_details_for_order
2864: (p_api_version => 1.0 ,
2865: p_init_msg_list => FND_API.G_TRUE ,
2866: p_commit => FND_API.G_FALSE ,
2867: p_order_id => p_order_id ,

Line 3016: wf_core.context('ibe_workflow_pvt',

3012: Exception
3013: When OTHERS Then
3014: x_return_status := FND_API.g_ret_sts_error;
3015: x_msg_count := 0;
3016: wf_core.context('ibe_workflow_pvt',
3017: 'NotifyOrderStatus',
3018: l_event_type,
3019: to_char(p_order_id)
3020: );

Line 3343: wf_core.context('ibe_workflow_pvt',

3339: When OTHERS Then
3340: x_return_status := FND_API.g_ret_sts_error;
3341: x_msg_count := 0;
3342:
3343: wf_core.context('ibe_workflow_pvt',
3344: 'NotifyForContractsStatus',
3345: l_event_type,
3346: to_char(p_quote_id)
3347: );

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

3767: x_msg_count := 0;
3768: IF(IBE_UTIL.g_debugon = l_true) THEN
3769: IBE_UTIL.DEBUG('NotifyForContractsChange:Exception: '||SQLCODE||SQLERRM);
3770: END IF;
3771: wf_core.context('ibe_workflow_pvt','NotifyQuote',l_sales_event_type,to_char(p_quote_id));
3772: raise;
3773: END NotifyForContractsChange;
3774:
3775:

Line 4544: wf_core.context('ibe_workflow_pvt',

4540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4541: IBE_UTIL.DEBUG('NotifySalesAssist:Exception block: '||SQLCODE||': '||SQLERRM);
4542: END IF;
4543:
4544: wf_core.context('ibe_workflow_pvt',
4545: 'NotifySalesAssistance',
4546: l_sales_event_type,
4547: to_char(p_quote_id)
4548: );

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

4796:
4797: WHEN OTHERS THEN
4798: x_return_status := FND_API.g_ret_sts_error;
4799: x_msg_count := 0;
4800: wf_core.context('IBE_WORKFLOW_PVT',l_notifname,l_messagename,p_quote_header_id);
4801: RAISE;
4802:
4803: END Notify_End_Working;
4804:

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

5039:
5040: WHEN OTHERS THEN
5041: x_return_status := FND_API.g_ret_sts_error;
5042: x_msg_count := 0;
5043: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5044: RAISE;
5045:
5046: END Notify_Finish_Sharing;
5047:

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

5291:
5292: WHEN OTHERS THEN
5293: x_return_status := FND_API.g_ret_sts_error;
5294: x_msg_count := 0;
5295: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5296: RAISE;
5297:
5298: END Notify_Shared_Cart ;
5299:

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

5537:
5538: WHEN OTHERS THEN
5539: x_return_status := FND_API.g_ret_sts_error;
5540: x_msg_count := 0;
5541: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5542: RAISE;
5543:
5544: END Notify_access_change;
5545:

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

5835:
5836: WHEN OTHERS THEN
5837: x_return_status := FND_API.g_ret_sts_error;
5838: x_msg_count := 0;
5839: --wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5840: RAISE;
5841:
5842: END;
5843:

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

6125:
6126: When OTHERS Then
6127: x_return_status := FND_API.g_ret_sts_error;
6128: x_msg_count := 0;
6129: wf_core.context('ibe_workflow_pvt','SHAREDCART','SHAREDCART');
6130: raise;
6131: End NotifyForSharedCart;
6132:
6133:

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

7692: l_document := l_document || rpad(ltrim(rtrim(ord_detail_tbl(i).item_number)),7)||' ';
7693: l_string_in := rtrim(ord_detail_tbl(i).item_description);
7694: l_string_out := '';
7695: l_string_left := '';
7696: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);
7697: l_document := l_document ||rpad(l_string_out,20)||' ' ;
7698: IF (ord_detail_tbl(i).source_order_number IS NOT NULL) THEN
7699: l_document := l_document || rpad(to_char(ord_detail_tbl(i).source_order_number),9)||' ';
7700: ELSE

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

7733: IF (lr_length > 12) THEN
7734: lr_string_in := rtrim(ord_detail_tbl(i).return_reason_code);
7735: lr_string_out := '';
7736: lr_string_left := '';
7737: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7738: l_document := l_document||rpad(lr_string_out,11)|| NEWLINE;
7739: lr_length := length(lr_string_left);
7740: IF (lr_length > 0) THEN
7741: lr_string_in := lr_string_left;

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

7759: WHILE length(l_string_in) > 0 or length(lr_string_in) > 0 LOOP
7760: IF (length(l_string_in) > 0) THEN
7761: l_string_out := '';
7762: l_string_left := '';
7763: ibe_workflow_pvt.ParseThisString1(l_string_in,l_string_out,l_string_left);
7764: IF l_view_net_price_flag = 'Y' THEN
7765: l_document := l_document ||rpad(' ',8)||rpad(l_string_out,20)||rpad(' ',32) ;
7766: ELSE
7767: l_document := l_document ||rpad(' ',8)||rpad(l_string_out,20)||rpad(' ',17) ;

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

7770: l_string_in := l_string_left ;
7771: IF length(lr_string_in) > 0 THEN
7772: lr_string_out := '';
7773: lr_string_left := '';
7774: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7775: IF l_view_net_price_flag = 'Y' THEN
7776: l_print_len := 11;
7777: ELSE
7778: l_print_len := 11;

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

7786: ELSE
7787: IF (length(lr_string_in) > 0 ) THEN
7788: lr_string_out := '';
7789: lr_string_left := '';
7790: ibe_workflow_pvt.ParseThisString1(lr_string_in,lr_string_out,lr_string_left);
7791: --l_document := l_document ||TAB||TAB||TAB||TAB||lr_string_out||NEWLINE ;
7792: IF l_view_net_price_flag = 'Y' THEN
7793: l_print_len := 11;
7794: l_document := l_document ||rpad(' ',60)||rpad(lr_string_out,l_print_len)||NEWLINE;

Line 7849: ibe_workflow_pvt.Generate_Detail(

7845: BEGIN
7846: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7847: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');
7848: END IF;
7849: ibe_workflow_pvt.Generate_Detail(
7850: P_item_key => document_id,
7851: p_quote_flag => l_quote_flag,
7852: p_tax_flag => l_tax_flag,
7853: x_document => document

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

7861:
7862: EXCEPTION
7863: WHEN OTHERS THEN
7864: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7865: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_wtax');
7866: END IF;
7867:
7868: END;
7869: /********************************************************

Line 7895: ibe_workflow_pvt.GenerateReturnDetail(

7891: l_tax_flag VARCHAR2(1) := fnd_api.g_true;
7892:
7893: BEGIN
7894:
7895: ibe_workflow_pvt.GenerateReturnDetail(
7896: p_item_key => document_id,
7897: p_tax_flag => l_tax_flag,
7898: x_document => document
7899: );

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

7906:
7907: EXCEPTION
7908: WHEN OTHERS THEN
7909: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7910: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_wtax');
7911: END IF;
7912:
7913: END Generate_Rtn_ord_Detail_wtax ;
7914:

Line 7933: ibe_workflow_pvt.Generate_Detail(

7929: BEGIN
7930: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7931: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');
7932: END IF;
7933: ibe_workflow_pvt.Generate_Detail(
7934: P_item_key => document_id,
7935: p_quote_flag => l_quote_flag,
7936: p_tax_flag => l_tax_flag,
7937: x_document => document

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

7945:
7946: EXCEPTION
7947: WHEN OTHERS THEN
7948: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7949: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_wtax');
7950: END IF;
7951:
7952: END;
7953: --Added by mannamra

Line 7970: ibe_workflow_pvt.Generate_Detail(

7966: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7967: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
7968: END IF;
7969: ----DBMS_OUTPUT.PUT('Generate_order_Detail_notax:START');
7970: ibe_workflow_pvt.Generate_Detail(
7971: P_item_key => document_id,
7972: p_quote_flag => l_quote_flag,
7973: p_tax_flag => l_tax_flag,
7974: x_document => document

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

7981: END IF;
7982: EXCEPTION
7983: WHEN OTHERS THEN
7984: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7985: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_order_Detail_notax');
7986: END IF;
7987:
7988: END;
7989:

Line 8016: ibe_workflow_pvt.GenerateReturnDetail(

8012: l_tax_flag VARCHAR2(1) := fnd_api.g_false;
8013:
8014: BEGIN
8015:
8016: ibe_workflow_pvt.GenerateReturnDetail(
8017: p_item_key => document_id,
8018: p_tax_flag => l_tax_flag,
8019: x_document => document
8020: );

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

8027:
8028: EXCEPTION
8029: WHEN OTHERS THEN
8030: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8031: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_rtn_ord_Detail_notax');
8032: END IF;
8033:
8034: END Generate_Rtn_ord_Detail_notax;
8035:

Line 8054: ibe_workflow_pvt.Generate_Detail(

8050: BEGIN
8051: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8052: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8053: END IF;
8054: ibe_workflow_pvt.Generate_Detail(
8055: P_item_key => document_id,
8056: p_quote_flag => l_quote_flag,
8057: p_tax_flag => l_tax_flag,
8058: x_document => document

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

8066:
8067: EXCEPTION
8068: WHEN OTHERS THEN
8069: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8070: IBE_UTIL.DEBUG('Unidentified error in ibe_workflow_pvt.Generate_quote_Detail_notax');
8071: END IF;
8072:
8073: END;
8074: --existing API

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

8177:
8178: l_string_in := rtrim(g_detail_rec.item_description);
8179: l_string_out := '';
8180: l_string_left := '';
8181: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
8182:
8183: l_document := l_document || l_string_out ||TAB;
8184: l_document := l_document || to_char(g_detail_rec.ordered_quantity)||TAB;
8185: l_document := l_document || l_ship_flag;

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

8190: l_string_in := l_string_left;
8191: WHILE length(l_string_in) > 0 LOOP
8192: l_string_out := '';
8193: l_string_left := '';
8194: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
8195: l_document := l_document || l_string_out ||NEWLINE;
8196: l_string_in := l_string_left;
8197: END LOOP;
8198:

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

9131:
9132: l_string_in := l_description;
9133: l_string_out := '';
9134: l_string_left := '';
9135: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
9136:
9137: l_document := l_document || l_string_out ||TAB;
9138: l_document := l_document || to_char(g_quote_line_rec.quantity)||TAB;
9139: l_document := l_document || l_ship_flag;

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

9144: l_string_in := l_string_left;
9145: WHILE length(l_string_in) > 0 LOOP
9146: l_string_out := '';
9147: l_string_left := '';
9148: ibe_workflow_pvt.ParseThisString(l_string_in,l_string_out,l_string_left);
9149: l_document := l_document || l_string_out ||NEWLINE;
9150: l_string_in := l_string_left;
9151: END LOOP;
9152: l_document := l_document || NEWLINE;

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

9823: l_email_addr VARCHAR2(2000);
9824:
9825: BEGIN
9826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9827: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9828: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9829: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9830: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9831: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);

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

9824:
9825: BEGIN
9826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9827: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9828: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9829: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9830: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9831: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9832: END IF;

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

9825: BEGIN
9826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9827: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9828: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9829: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9830: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9831: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9832: END IF;
9833:

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

9826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9827: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9828: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9829: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9830: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9831: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9832: END IF;
9833:
9834: IF (p_user_id > 0) THEN

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

9827: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Start');
9828: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_id: '||p_user_id);
9829: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input user_source: '||p_user_source);
9830: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input email_address: '||p_email_address);
9831: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Input quote_header_id: '||p_quote_header_id);
9832: END IF;
9833:
9834: IF (p_user_id > 0) THEN
9835: IF (p_user_source IS NOT NULL AND p_user_source = 'HZ_PARTY') THEN

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

9919:
9920: END IF;
9921:
9922: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user = '||x_adhoc_user);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user:End') ;
9925: END IF;
9926:
9927: EXCEPTION

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

9920: END IF;
9921:
9922: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9923: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user = '||x_adhoc_user);
9924: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:x_adhoc_user:End') ;
9925: END IF;
9926:
9927: EXCEPTION
9928: WHEN OTHERS THEN

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

9926:
9927: EXCEPTION
9928: WHEN OTHERS THEN
9929: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9930: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_user:Exception occured');
9931: END IF;
9932: RAISE;
9933: END get_wf_user;
9934:

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

9949:
9950: BEGIN
9951:
9952: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9953: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Start');
9954: END IF;
9955: IF (p_wf_users_tbl IS NULL OR p_wf_users_tbl.COUNT <= 0) THEN
9956: return;
9957: END IF;

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

9972: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
9973: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
9974: END LOOP;
9975: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9976: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);
9977: END IF;
9978:
9979: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
9980:

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

9988: expiration_date => sysdate + 1);
9989:
9990: x_wf_role := l_adhoc_role;
9991: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9992: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:End');
9993: END IF;
9994:
9995: EXCEPTION
9996: WHEN OTHERS THEN

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

9994:
9995: EXCEPTION
9996: WHEN OTHERS THEN
9997: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9998: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Exception occured');
9999: END IF;
10000: RAISE;
10001: END get_wf_role;
10002:

Line 10301: END ibe_workflow_pvt;

10297: p_string_left := substr(p_string_in,p_string_len+1,length(p_string_in)-p_string_len);
10298: END IF;
10299: END parseString;
10300:
10301: END ibe_workflow_pvt;