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

Line 1: PACKAGE BODY OKS_WF_K_PROCESS_PVT AS

1: PACKAGE BODY OKS_WF_K_PROCESS_PVT AS
2: /* $Header: OKSVKWFB.pls 120.66.12020000.2 2013/02/04 15:46:56 mchandak ship $ */
3:
4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_WF_K_PROCESS_PVT';

3:
4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_WF_K_PROCESS_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';

Line 2471: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

2467: l_api_name CONSTANT VARCHAR2(30) := 'customer_accept_quote';
2468:
2469: l_send_email_yn VARCHAR2(1) := 'N';
2470: l_item_key wf_items.item_key%TYPE;
2471: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning

Line 2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

2468:
2469: l_send_email_yn VARCHAR2(1) := 'N';
2470: l_item_key wf_items.item_key%TYPE;
2471: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning
2476: FROM okc_k_headers_all_b okch,

Line 2543: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

2539:
2540: -- bug 5845505, send email only if template for the document type is setup
2541: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2542: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2543: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
2544: ' Contract ID ='||p_contract_id||
2545: ' Document Type ='||G_REPORT_TYPE_ACCEPT||')');
2546: END IF;
2547: is_template_defined (

Line 2561: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||

2557: );
2558:
2559: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2560: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2561: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
2562: x_return_status||' x_msg_count ='||x_msg_count||')');
2563: END IF;
2564: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2581: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2577:
2578: --log interaction (media type WEB FORM) that customer has accepted the quote
2579: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2580: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2581: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2582: ' Contract ID = '||p_contract_id||
2583: substr(' IH Subject = '||l_email_attr_rec.ih_subject,1,100)||
2584: substr(' IH Message = '||l_email_attr_rec.ih_message||')',1,100));
2585: END IF;

Line 2617: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2613: l_email_attr_rec.SENDER_EMAIL := NULL;
2614:
2615: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2616: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2617: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2618: ' Contract ID ='||p_contract_id||
2619: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
2620: END IF;
2621: set_email_attributes

Line 2632: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

2628: x_msg_count => x_msg_count
2629: );
2630: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2632: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
2633: x_return_status||' x_msg_count ='||x_msg_count||')');
2634: END IF;
2635: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2669: 'OKS_WF_K_PROCESS_PVT.set_email_attributes attribute CC_EMAIL is not defined for this workflow item key '||

2665: ELSE
2666:
2667: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2668: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2669: 'OKS_WF_K_PROCESS_PVT.set_email_attributes attribute CC_EMAIL is not defined for this workflow item key '||
2670: l_item_key||')');
2671: END IF;
2672:
2673: END IF;

Line 2693: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

2689: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
2690:
2691: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2692: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2693: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
2694: ' Contract ID ='||p_contract_id||
2695: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
2696: ' Message Subject ='||l_notif_attr_rec.SUBJECT||')');
2697: END IF;

Line 2709: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

2705: x_msg_count => x_msg_count
2706: );
2707: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2708: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2709: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
2710: x_return_status||' x_msg_count ='||x_msg_count||')');
2711: END IF;
2712: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

2842:
2843:
2844: l_send_email_yn VARCHAR2(1) := 'N';
2845: l_item_key wf_items.item_key%TYPE;
2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2850: l_rownotfound BOOLEAN := FALSE;

Line 2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

2843:
2844: l_send_email_yn VARCHAR2(1) := 'N';
2845: l_item_key wf_items.item_key%TYPE;
2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2850: l_rownotfound BOOLEAN := FALSE;
2851: l_reason VARCHAR2(250);

Line 2895: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

2891:
2892: -- bug 5845505, send email only if template for the document type is setup
2893: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2894: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2895: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
2896: ' Contract ID ='||p_contract_id||
2897: ' Document Type ='||G_REPORT_TYPE_CANCEL||')');
2898: END IF;
2899: is_template_defined (

Line 2913: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||

2909: );
2910:
2911: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2912: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2913: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
2914: x_return_status||' x_msg_count ='||x_msg_count||')');
2915: END IF;
2916: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2935: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2931:
2932: --log interaction (media type WEB FORM) that customer has declined the quote
2933: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2934: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2935: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2936: ' Contract ID = '||p_contract_id||
2937: substr(' IH Message = '||p_comments,1,100)||
2938: substr(' IH Subject = '||l_reason||')',1,100));
2939: END IF;

Line 2972: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2968: l_email_attr_rec.SENDER_EMAIL := NULL;
2969:
2970: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2971: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2972: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2973: ' Contract ID ='||p_contract_id||
2974: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
2975: END IF;
2976: set_email_attributes

Line 2987: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

2983: x_msg_count => x_msg_count
2984: );
2985: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2986: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2987: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
2988: x_return_status||' x_msg_count ='||x_msg_count||')');
2989: END IF;
2990: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3024: 'OKS_WF_K_PROCESS_PVT.set_email_attributes attribute CC_EMAIL is not defined for this workflow item key '||

3020: ELSE
3021:
3022: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3023: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3024: 'OKS_WF_K_PROCESS_PVT.set_email_attributes attribute CC_EMAIL is not defined for this workflow item key '||
3025: l_item_key||')');
3026: END IF;
3027:
3028: END IF;

Line 3046: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3042: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
3043:
3044: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3045: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3046: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3047: ' Contract ID ='||p_contract_id||
3048: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
3049: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
3050: END IF;

Line 3062: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

3058: x_msg_count => x_msg_count
3059: );
3060: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3061: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3062: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3063: x_return_status||' x_msg_count ='||x_msg_count||')');
3064: END IF;
3065: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3193: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3189: l_interaction_subject VARCHAR2(4000);
3190: l_interaction_message VARCHAR2(4000);
3191: l_role_name wf_roles.name%TYPE := NULL;
3192: l_role_email wf_roles.email_address%TYPE;
3193: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3194: l_salesrep_email VARCHAR2(240);
3195: l_salesrep_username VARCHAR2(100);
3196: l_display_rolename VARCHAR2(360);
3197:

Line 3433: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3429: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
3430:
3431: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3432: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3433: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3434: ' Contract ID ='||p_contract_id||
3435: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
3436: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
3437: END IF;

Line 3449: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

3445: x_msg_count => x_msg_count
3446: );
3447: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3448: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3449: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3450: x_return_status||' x_msg_count ='||x_msg_count||')');
3451: END IF;
3452:
3453: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 3744: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3740: l_msg_data VARCHAR2(4000);
3741:
3742: l_contract_id NUMBER;
3743: l_notif_type VARCHAR2(30);
3744: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3745:
3746: l_send_email_yn VARCHAR2(1) := 'N';
3747: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
3748:

Line 3747: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

3743: l_notif_type VARCHAR2(30);
3744: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3745:
3746: l_send_email_yn VARCHAR2(1) := 'N';
3747: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
3748:
3749: BEGIN
3750:
3751: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3787: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3783: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
3784:
3785: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3786: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3787: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3788: ' Contract ID ='||l_contract_id||
3789: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||')');
3790: END IF;
3791: set_notification_attributes

Line 3802: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

3798: x_msg_count => l_msg_count
3799: );
3800: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3802: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3803: l_return_status||' x_msg_count ='||l_msg_count||')');
3804: END IF;
3805: IF l_return_status <> G_RET_STS_SUCCESS THEN
3806: RAISE FND_API.G_EXC_ERROR;

Line 3816: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

3812:
3813: -- bug 5845505, send email only if template for the document type is setup
3814: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3815: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3816: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
3817: ' Contract ID ='||l_contract_id||
3818: ' Document Type ='||G_REPORT_TYPE_ACTIVE||')');
3819: END IF;
3820: is_template_defined (

Line 3833: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||

3829: x_msg_count => l_msg_count
3830: );
3831: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3832: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3833: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
3834: l_return_status||' x_msg_count ='||l_msg_count||')');
3835: END IF;
3836: IF l_return_status <> G_RET_STS_SUCCESS THEN
3837: RAISE FND_API.G_EXC_ERROR;

Line 3988: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3984:
3985: l_api_version CONSTANT NUMBER := 1.0;
3986: l_api_name CONSTANT VARCHAR2(30) := 'set_notification_attr';
3987:
3988: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3989:
3990: BEGIN
3991:
3992: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4032: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

4028: l_notif_attr_rec.MSGS_FROM_STACK_YN := p_msgs_from_stack_yn;
4029:
4030: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4031: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
4032: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
4033: ' Contract ID ='||l_notif_attr_rec.CONTRACT_ID||
4034: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||')');
4035: END IF;
4036: set_notification_attributes

Line 4047: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

4043: x_msg_count => x_msg_count
4044: );
4045: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
4047: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
4048: x_return_status||' x_msg_count ='||x_msg_count||')');
4049: END IF;
4050: IF x_return_status <> G_RET_STS_SUCCESS THEN
4051: RAISE FND_API.G_EXC_ERROR;

Line 4115: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

4111: l_msg_data VARCHAR2(4000);
4112:
4113: l_contract_id NUMBER;
4114: l_email_type VARCHAR2(30);
4115: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
4116:
4117: BEGIN
4118:
4119: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4156: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

4152: l_email_attr_rec.IH_MESSAGE := NULL;
4153:
4154: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4155: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
4156: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
4157: ' Contract ID ='||l_email_attr_rec.CONTRACT_ID||
4158: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
4159: END IF;
4160: set_email_attributes

Line 4171: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

4167: x_msg_count => l_msg_count
4168: );
4169: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4170: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
4171: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
4172: l_return_status||' x_msg_count ='||l_msg_count||')');
4173: END IF;
4174: IF l_return_status <> G_RET_STS_SUCCESS THEN
4175: RAISE FND_API.G_EXC_ERROR;

Line 4402: p_wf_attributes IN OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS,

4398: (
4399: p_api_version IN NUMBER,
4400: p_init_msg_list IN VARCHAR2,
4401: p_commit IN VARCHAR2 DEFAULT 'F',
4402: p_wf_attributes IN OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS,
4403: x_return_status OUT NOCOPY VARCHAR2,
4404: x_msg_count OUT NOCOPY NUMBER,
4405: x_msg_data OUT NOCOPY VARCHAR2
4406: ) IS

Line 4810: 'OKS_WF_K_PROCESS_PVT.complete_activity('||

4806: p_activity_name => G_CUST_ACTION ) THEN
4807:
4808: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4809: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
4810: 'OKS_WF_K_PROCESS_PVT.complete_activity('||
4811: ' p_contract_id ='||p_contract_id||')');
4812: END IF;
4813: complete_activity
4814: (

Line 4828: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||x_return_status||

4824: x_msg_count => x_msg_count
4825: );
4826: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4827: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
4828: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||x_return_status||
4829: ' x_msg_count ='||x_msg_count||')');
4830: END IF;
4831: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5219: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

5215: l_maybe_renewal_k VARCHAR2(1) := 'N';
5216: l_rowfound BOOLEAN := FALSE;
5217: l_renewaltype_used VARCHAR2(30);
5218: l_renewalntf_to VARCHAR2(100);
5219: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
5220: l_resp_id NUMBER;
5221: l_resp_appl_id NUMBER;
5222:
5223: BEGIN

Line 5323: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

5319: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
5320:
5321: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
5323: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
5324: ' Contract ID ='||l_contract_id||
5325: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
5326: ' Performer ='||l_notif_attr_rec.PERFORMER||')');
5327: END IF;

Line 5339: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

5335: x_msg_count => l_msg_count
5336: );
5337: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
5339: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
5340: l_return_status||' x_msg_count ='||l_msg_count||')');
5341: END IF;
5342: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6098: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

6094: l_api_name CONSTANT VARCHAR2(50) := 'submit_for_approval';
6095:
6096: l_send_email_yn VARCHAR2(1) := 'N';
6097: l_item_key wf_items.item_key%TYPE;
6098: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6099: l_activity_name VARCHAR2(30);
6100: l_irr_flag VARCHAR2(1);
6101:
6102: BEGIN

Line 6186: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

6182:
6183: -- bug 5845505, send email only if template for the document type is setup
6184: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6185: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6186: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
6187: ' Contract ID ='||p_contract_id||
6188: ' Document Type ='||G_REPORT_TYPE_ACCEPT||')');
6189: END IF;
6190: is_template_defined (

Line 6204: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||

6200: );
6201:
6202: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6203: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6204: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
6205: x_return_status||' x_msg_count ='||x_msg_count||')');
6206: END IF;
6207: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6224: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

6220:
6221: --log interaction (media type WEB FORM) that customer has accepted the quote
6222: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6223: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6224: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
6225: ' Contract ID = '||p_contract_id||
6226: substr(' IH Subject = '||l_email_attr_rec.ih_subject,1,100)||
6227: substr(' IH Message = '||l_email_attr_rec.ih_message||')',1,100));
6228: END IF;

Line 6261: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

6257: l_email_attr_rec.SENDER_EMAIL := NULL;
6258:
6259: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6260: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6261: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
6262: ' Contract ID ='||p_contract_id||
6263: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
6264: END IF;
6265: set_email_attributes

Line 6276: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

6272: x_msg_count => x_msg_count
6273: );
6274: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6275: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6276: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
6277: x_return_status||' x_msg_count ='||x_msg_count||')');
6278: END IF;
6279: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
6280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6654: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

6650: l_negotiation_status VARCHAR2(30);
6651: l_qa_calling_process VARCHAR2(30);
6652: l_online_yn VARCHAR2(1);
6653: l_stop VARCHAR2(1) := 'N';
6654: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6655: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
6656:
6657: BEGIN
6658:

Line 6655: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

6651: l_qa_calling_process VARCHAR2(30);
6652: l_online_yn VARCHAR2(1);
6653: l_stop VARCHAR2(1) := 'N';
6654: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6655: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
6656:
6657: BEGIN
6658:
6659: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 6834: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

6830: l_email_attr_rec.IH_MESSAGE := NULL;
6831:
6832: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6833: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6834: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
6835: ' Contract ID ='||l_contract_id||
6836: ' Email Type ='||l_email_attr_rec.TO_EMAIL||
6837: ' To Email ='||l_qto_email||')');
6838: END IF;

Line 6850: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||l_return_status||

6846: x_msg_count => l_msg_count
6847: );
6848: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6849: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6850: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||l_return_status||
6851: ' x_msg_count ='||l_msg_count||')');
6852: END IF;
6853: IF l_return_status <> G_RET_STS_SUCCESS THEN
6854: RAISE FND_API.G_EXC_ERROR;

Line 6887: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

6883: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6884:
6885: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6886: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6887: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
6888: ' Contract ID ='||l_contract_id||
6889: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
6890: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
6891: END IF;

Line 6903: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

6899: x_msg_count => l_msg_count
6900: );
6901: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6902: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6903: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
6904: l_return_status||' x_msg_count ='||l_msg_count||')');
6905: END IF;
6906: IF l_return_status <> G_RET_STS_SUCCESS THEN
6907: RAISE FND_API.G_EXC_ERROR;

Line 6970: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

6966: l_notif_attr_rec.SUBJECT := substr(get_fnd_message,1,200);
6967: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6968: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6969: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6970: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
6971: ' Contract ID ='||l_contract_id||
6972: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
6973: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
6974: END IF;

Line 6986: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

6982: x_msg_count => l_msg_count
6983: );
6984: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6985: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6986: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
6987: l_return_status||' x_msg_count ='||l_msg_count||')');
6988: END IF;
6989: EXCEPTION
6990: WHEN others THEN

Line 7026: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

7022: l_notif_attr_rec.SUBJECT := substr(SQLERRM,1,200);
7023: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
7024: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7025: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7026: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
7027: ' Contract ID ='||l_contract_id||
7028: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
7029: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
7030: END IF;

Line 7042: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

7038: x_msg_count => l_msg_count
7039: );
7040: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7041: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7042: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
7043: l_return_status||' x_msg_count ='||l_msg_count||')');
7044: END IF;
7045: EXCEPTION
7046: WHEN others THEN

Line 7783: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');

7779: WHEN OTHERS THEN
7780: x_return_status := G_RET_STS_UNEXP_ERROR;
7781: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7782: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7783: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');
7784: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7785: 'Error: '|| substr(SQLERRM,1,500));
7786: END IF;
7787: END;

Line 7843: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

7839: WHERE kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
7840:
7841: l_contract_id NUMBER;
7842: l_pdf_id NUMBER;
7843: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
7844:
7845: BEGIN
7846: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7847: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 7895: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');

7891: WHEN OTHERS THEN
7892: l_return_status := G_RET_STS_UNEXP_ERROR;
7893: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7894: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7895: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');
7896: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7897: 'Error: '|| substr(SQLERRM,1,500));
7898: END IF;
7899: END;

Line 7934: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

7930: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
7931:
7932: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7933: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7934: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
7935: ' Contract ID ='||l_contract_id||
7936: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
7937: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
7938: END IF;

Line 7950: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

7946: x_msg_count => l_msg_count
7947: );
7948: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7949: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7950: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
7951: l_return_status||' x_msg_count ='||l_msg_count||')');
7952: END IF;
7953: IF l_return_status <> G_RET_STS_SUCCESS THEN
7954: RAISE FND_API.G_EXC_ERROR;

Line 8069: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

8065: l_api_name CONSTANT VARCHAR2(30) := 'accept_quote';
8066:
8067: l_item_key wf_items.item_key%TYPE;
8068: l_activity_name VARCHAR2(30);
8069: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
8070:
8071: BEGIN
8072: -- start debug log
8073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8136: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

8132: l_email_attr_rec.IH_MESSAGE := NULL;
8133:
8134: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8135: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8136: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
8137: ' Contract ID ='||p_contract_id||
8138: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
8139: END IF;
8140: set_email_attributes

Line 8151: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

8147: x_msg_count => x_msg_count
8148: );
8149: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8150: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8151: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
8152: x_return_status||' x_msg_count ='||x_msg_count||')');
8153: END IF;
8154: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8300: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

8296: l_item_key wf_items.item_key%TYPE;
8297: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;
8298: l_process_status VARCHAR2(30);
8299: l_activity_name VARCHAR2(30);
8300: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
8301:
8302: BEGIN
8303: -- start debug log
8304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8382: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

8378:
8379: -- bug 5845505, send email only if template for the document type is setup
8380: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8381: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8382: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
8383: ' Contract ID ='||p_contract_id||
8384: ' Document Type ='||G_REPORT_TYPE_CANCEL||')');
8385: END IF;
8386: is_template_defined (

Line 8400: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||

8396: );
8397:
8398: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8399: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8400: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
8401: x_return_status||' x_msg_count ='||x_msg_count||')');
8402: END IF;
8403: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8424: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

8420:
8421: --log interaction (media type WEB FORM) that salesrep has declined the quote
8422: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8423: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8424: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
8425: ' Contract ID = '||p_contract_id||
8426: substr(' IH Message = '||p_comments,1,100)||
8427: substr(' IH Subject = '||l_reason||')',1,100));
8428: END IF;

Line 8461: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

8457: l_email_attr_rec.SENDER_EMAIL := NULL;
8458:
8459: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8460: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8461: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
8462: ' Contract ID ='||p_contract_id||
8463: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
8464: END IF;
8465: set_email_attributes

Line 8476: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||

8472: x_msg_count => x_msg_count
8473: );
8474: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8475: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8476: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
8477: x_return_status||' x_msg_count ='||x_msg_count||')');
8478: END IF;
8479: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8513: 'OKS_WF_K_PROCESS_PVT.complete_activity(p_contract_id= '||

8509:
8510: IF l_activity_name IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
8511: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8512: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8513: 'OKS_WF_K_PROCESS_PVT.complete_activity(p_contract_id= '||
8514: p_contract_id||' p_resultout ='||l_result_out||
8515: ' p_process_status ='||l_process_status||
8516: ' p_activity_name ='||l_activity_name||')');
8517: END IF;

Line 8533: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||

8529: x_msg_data => x_msg_data
8530: ) ;
8531: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8532: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8533: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||
8534: x_return_status||' x_msg_count ='||x_msg_count||')');
8535: END IF;
8536: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8618: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

8614: l_msg_count NUMBER;
8615: l_msg_data VARCHAR2(2000);
8616:
8617: l_contract_id NUMBER;
8618: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
8619:
8620: BEGIN
8621:
8622: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8683: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

8679: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
8680:
8681: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8682: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8683: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
8684: ' Contract ID ='||l_contract_id||
8685: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
8686: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
8687: END IF;

Line 8699: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

8695: x_msg_count => l_msg_count
8696: );
8697: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8698: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8699: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
8700: l_return_status||' x_msg_count ='||l_msg_count||')');
8701: END IF;
8702: RAISE FND_API.G_EXC_ERROR;
8703: END IF;

Line 8748: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

8744: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
8745:
8746: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8747: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8748: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
8749: ' Contract ID ='||l_contract_id||
8750: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
8751: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
8752: END IF;

Line 8764: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||

8760: x_msg_count => l_msg_count
8761: );
8762: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8763: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8764: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
8765: l_return_status||' x_msg_count ='||l_msg_count||')');
8766: END IF;
8767: RAISE FND_API.G_EXC_ERROR;
8768: END IF;

Line 9304: END OKS_WF_K_PROCESS_PVT;

9300: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9301:
9302: END launch_k_process_wf_blk;
9303:
9304: END OKS_WF_K_PROCESS_PVT;