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.59.12010000.2 2008/10/22 12:51:54 ssreekum 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 2525: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

2521:
2522: -- bug 5845505, send email only if template for the document type is setup
2523: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2524: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2525: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
2526: ' Contract ID ='||p_contract_id||
2527: ' Document Type ='||G_REPORT_TYPE_ACCEPT||')');
2528: END IF;
2529: is_template_defined (

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

2539: );
2540:
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.after',
2543: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
2544: x_return_status||' x_msg_count ='||x_msg_count||')');
2545: END IF;
2546: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2563: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2559:
2560: --log interaction (media type WEB FORM) that customer has accepted the quote
2561: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2562: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2563: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2564: ' Contract ID = '||p_contract_id||
2565: substr(' IH Subject = '||l_email_attr_rec.ih_subject,1,100)||
2566: substr(' IH Message = '||l_email_attr_rec.ih_message||')',1,100));
2567: END IF;

Line 2599: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2595: l_email_attr_rec.SENDER_EMAIL := NULL;
2596:
2597: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2598: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2599: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2600: ' Contract ID ='||p_contract_id||
2601: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
2602: END IF;
2603: set_email_attributes

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

2610: x_msg_count => x_msg_count
2611: );
2612: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2613: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2614: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
2615: x_return_status||' x_msg_count ='||x_msg_count||')');
2616: END IF;
2617: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2637: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

2633: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
2634:
2635: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2636: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2637: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
2638: ' Contract ID ='||p_contract_id||
2639: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
2640: ' Message Subject ='||l_notif_attr_rec.SUBJECT||')');
2641: END IF;

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

2649: x_msg_count => x_msg_count
2650: );
2651: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2652: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2653: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
2654: x_return_status||' x_msg_count ='||x_msg_count||')');
2655: END IF;
2656: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

2764: AND sysdate BETWEEN START_DATE AND NVL(end_date,SYSDATE+1);
2765:
2766: l_send_email_yn VARCHAR2(1) := 'N';
2767: l_item_key wf_items.item_key%TYPE;
2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2772: l_rownotfound BOOLEAN := FALSE;

Line 2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

2765:
2766: l_send_email_yn VARCHAR2(1) := 'N';
2767: l_item_key wf_items.item_key%TYPE;
2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2772: l_rownotfound BOOLEAN := FALSE;
2773: l_reason VARCHAR2(250);

Line 2817: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

2813:
2814: -- bug 5845505, send email only if template for the document type is setup
2815: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2816: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2817: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
2818: ' Contract ID ='||p_contract_id||
2819: ' Document Type ='||G_REPORT_TYPE_CANCEL||')');
2820: END IF;
2821: is_template_defined (

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

2831: );
2832:
2833: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2835: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
2836: x_return_status||' x_msg_count ='||x_msg_count||')');
2837: END IF;
2838: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2857: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2853:
2854: --log interaction (media type WEB FORM) that customer has declined the quote
2855: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2856: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2857: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2858: ' Contract ID = '||p_contract_id||
2859: substr(' IH Message = '||p_comments,1,100)||
2860: substr(' IH Subject = '||l_reason||')',1,100));
2861: END IF;

Line 2894: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

2890: l_email_attr_rec.SENDER_EMAIL := NULL;
2891:
2892: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2893: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2894: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
2895: ' Contract ID ='||p_contract_id||
2896: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
2897: END IF;
2898: set_email_attributes

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

2905: x_msg_count => x_msg_count
2906: );
2907: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2908: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2909: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
2910: x_return_status||' x_msg_count ='||x_msg_count||')');
2911: END IF;
2912: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2930: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

2926: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
2927:
2928: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2929: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2930: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
2931: ' Contract ID ='||p_contract_id||
2932: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
2933: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
2934: END IF;

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

2942: x_msg_count => x_msg_count
2943: );
2944: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2945: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2946: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
2947: x_return_status||' x_msg_count ='||x_msg_count||')');
2948: END IF;
2949: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3077: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3073: l_interaction_subject VARCHAR2(4000);
3074: l_interaction_message VARCHAR2(4000);
3075: l_role_name wf_roles.name%TYPE := NULL;
3076: l_role_email wf_roles.email_address%TYPE;
3077: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3078: l_salesrep_email VARCHAR2(240);
3079: l_salesrep_username VARCHAR2(100);
3080: l_display_rolename VARCHAR2(360);
3081:

Line 3317: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3313: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
3314:
3315: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3316: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3317: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3318: ' Contract ID ='||p_contract_id||
3319: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
3320: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
3321: END IF;

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

3329: x_msg_count => x_msg_count
3330: );
3331: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3332: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3333: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3334: x_return_status||' x_msg_count ='||x_msg_count||')');
3335: END IF;
3336:
3337: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 3626: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3622: l_msg_data VARCHAR2(4000);
3623:
3624: l_contract_id NUMBER;
3625: l_notif_type VARCHAR2(30);
3626: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3627:
3628: l_send_email_yn VARCHAR2(1) := 'N';
3629: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
3630:

Line 3629: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

3625: l_notif_type VARCHAR2(30);
3626: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3627:
3628: l_send_email_yn VARCHAR2(1) := 'N';
3629: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
3630:
3631: BEGIN
3632:
3633: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3669: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3665: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
3666:
3667: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3668: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3669: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3670: ' Contract ID ='||l_contract_id||
3671: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||')');
3672: END IF;
3673: set_notification_attributes

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

3680: x_msg_count => l_msg_count
3681: );
3682: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3683: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3684: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3685: l_return_status||' x_msg_count ='||l_msg_count||')');
3686: END IF;
3687: IF l_return_status <> G_RET_STS_SUCCESS THEN
3688: RAISE FND_API.G_EXC_ERROR;

Line 3698: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

3694:
3695: -- bug 5845505, send email only if template for the document type is setup
3696: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3697: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3698: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
3699: ' Contract ID ='||l_contract_id||
3700: ' Document Type ='||G_REPORT_TYPE_ACTIVE||')');
3701: END IF;
3702: is_template_defined (

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

3711: x_msg_count => l_msg_count
3712: );
3713: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3714: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3715: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
3716: l_return_status||' x_msg_count ='||l_msg_count||')');
3717: END IF;
3718: IF l_return_status <> G_RET_STS_SUCCESS THEN
3719: RAISE FND_API.G_EXC_ERROR;

Line 3870: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

3866:
3867: l_api_version CONSTANT NUMBER := 1.0;
3868: l_api_name CONSTANT VARCHAR2(30) := 'set_notification_attr';
3869:
3870: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
3871:
3872: BEGIN
3873:
3874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3914: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

3910: l_notif_attr_rec.MSGS_FROM_STACK_YN := p_msgs_from_stack_yn;
3911:
3912: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3913: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
3914: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
3915: ' Contract ID ='||l_notif_attr_rec.CONTRACT_ID||
3916: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||')');
3917: END IF;
3918: set_notification_attributes

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

3925: x_msg_count => x_msg_count
3926: );
3927: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3928: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
3929: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
3930: x_return_status||' x_msg_count ='||x_msg_count||')');
3931: END IF;
3932: IF x_return_status <> G_RET_STS_SUCCESS THEN
3933: RAISE FND_API.G_EXC_ERROR;

Line 3997: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

3993: l_msg_data VARCHAR2(4000);
3994:
3995: l_contract_id NUMBER;
3996: l_email_type VARCHAR2(30);
3997: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
3998:
3999: BEGIN
4000:
4001: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4038: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

4034: l_email_attr_rec.IH_MESSAGE := NULL;
4035:
4036: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4037: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
4038: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
4039: ' Contract ID ='||l_email_attr_rec.CONTRACT_ID||
4040: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
4041: END IF;
4042: set_email_attributes

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

4049: x_msg_count => l_msg_count
4050: );
4051: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4052: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
4053: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
4054: l_return_status||' x_msg_count ='||l_msg_count||')');
4055: END IF;
4056: IF l_return_status <> G_RET_STS_SUCCESS THEN
4057: RAISE FND_API.G_EXC_ERROR;

Line 4284: p_wf_attributes IN OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS,

4280: (
4281: p_api_version IN NUMBER,
4282: p_init_msg_list IN VARCHAR2,
4283: p_commit IN VARCHAR2 DEFAULT 'F',
4284: p_wf_attributes IN OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS,
4285: x_return_status OUT NOCOPY VARCHAR2,
4286: x_msg_count OUT NOCOPY NUMBER,
4287: x_msg_data OUT NOCOPY VARCHAR2
4288: ) IS

Line 4655: 'OKS_WF_K_PROCESS_PVT.complete_activity('||

4651: p_activity_name => G_CUST_ACTION ) THEN
4652:
4653: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4654: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
4655: 'OKS_WF_K_PROCESS_PVT.complete_activity('||
4656: ' p_contract_id ='||p_contract_id||')');
4657: END IF;
4658: complete_activity
4659: (

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

4669: x_msg_count => x_msg_count
4670: );
4671: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4672: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
4673: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||x_return_status||
4674: ' x_msg_count ='||x_msg_count||')');
4675: END IF;
4676: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5053: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

5049: l_maybe_renewal_k VARCHAR2(1) := 'N';
5050: l_rowfound BOOLEAN := FALSE;
5051: l_renewaltype_used VARCHAR2(30);
5052: l_renewalntf_to VARCHAR2(100);
5053: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
5054: l_resp_id NUMBER;
5055: l_resp_appl_id NUMBER;
5056:
5057: BEGIN

Line 5157: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

5153: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
5154:
5155: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5156: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
5157: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
5158: ' Contract ID ='||l_contract_id||
5159: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
5160: ' Performer ='||l_notif_attr_rec.PERFORMER||')');
5161: END IF;

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

5169: x_msg_count => l_msg_count
5170: );
5171: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5172: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
5173: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
5174: l_return_status||' x_msg_count ='||l_msg_count||')');
5175: END IF;
5176: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5794: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

5790: l_api_name CONSTANT VARCHAR2(50) := 'submit_for_approval';
5791:
5792: l_send_email_yn VARCHAR2(1) := 'N';
5793: l_item_key wf_items.item_key%TYPE;
5794: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
5795: l_activity_name VARCHAR2(30);
5796: l_irr_flag VARCHAR2(1);
5797:
5798: BEGIN

Line 5882: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

5878:
5879: -- bug 5845505, send email only if template for the document type is setup
5880: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5881: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
5882: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
5883: ' Contract ID ='||p_contract_id||
5884: ' Document Type ='||G_REPORT_TYPE_ACCEPT||')');
5885: END IF;
5886: is_template_defined (

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

5896: );
5897:
5898: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5899: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
5900: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
5901: x_return_status||' x_msg_count ='||x_msg_count||')');
5902: END IF;
5903: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
5904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5920: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

5916:
5917: --log interaction (media type WEB FORM) that customer has accepted the quote
5918: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5919: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
5920: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
5921: ' Contract ID = '||p_contract_id||
5922: substr(' IH Subject = '||l_email_attr_rec.ih_subject,1,100)||
5923: substr(' IH Message = '||l_email_attr_rec.ih_message||')',1,100));
5924: END IF;

Line 5957: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

5953: l_email_attr_rec.SENDER_EMAIL := NULL;
5954:
5955: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5956: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
5957: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
5958: ' Contract ID ='||p_contract_id||
5959: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
5960: END IF;
5961: set_email_attributes

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

5968: x_msg_count => x_msg_count
5969: );
5970: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5971: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
5972: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
5973: x_return_status||' x_msg_count ='||x_msg_count||')');
5974: END IF;
5975: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6350: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

6346: l_negotiation_status VARCHAR2(30);
6347: l_qa_calling_process VARCHAR2(30);
6348: l_online_yn VARCHAR2(1);
6349: l_stop VARCHAR2(1) := 'N';
6350: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6351: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
6352:
6353: BEGIN
6354:

Line 6351: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

6347: l_qa_calling_process VARCHAR2(30);
6348: l_online_yn VARCHAR2(1);
6349: l_stop VARCHAR2(1) := 'N';
6350: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6351: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
6352:
6353: BEGIN
6354:
6355: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 6530: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

6526: l_email_attr_rec.IH_MESSAGE := NULL;
6527:
6528: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6529: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6530: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
6531: ' Contract ID ='||l_contract_id||
6532: ' Email Type ='||l_email_attr_rec.TO_EMAIL||
6533: ' To Email ='||l_qto_email||')');
6534: END IF;

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

6542: x_msg_count => l_msg_count
6543: );
6544: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6545: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6546: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||l_return_status||
6547: ' x_msg_count ='||l_msg_count||')');
6548: END IF;
6549: IF l_return_status <> G_RET_STS_SUCCESS THEN
6550: RAISE FND_API.G_EXC_ERROR;

Line 6583: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

6579: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6580:
6581: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6582: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6583: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
6584: ' Contract ID ='||l_contract_id||
6585: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
6586: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
6587: END IF;

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

6595: x_msg_count => l_msg_count
6596: );
6597: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6598: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6599: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
6600: l_return_status||' x_msg_count ='||l_msg_count||')');
6601: END IF;
6602: IF l_return_status <> G_RET_STS_SUCCESS THEN
6603: RAISE FND_API.G_EXC_ERROR;

Line 6666: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

6662: l_notif_attr_rec.SUBJECT := substr(get_fnd_message,1,200);
6663: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6664: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6665: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6666: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
6667: ' Contract ID ='||l_contract_id||
6668: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
6669: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
6670: END IF;

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

6678: x_msg_count => l_msg_count
6679: );
6680: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6681: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6682: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
6683: l_return_status||' x_msg_count ='||l_msg_count||')');
6684: END IF;
6685: EXCEPTION
6686: WHEN others THEN

Line 6722: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

6718: l_notif_attr_rec.SUBJECT := substr(SQLERRM,1,200);
6719: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6720: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6721: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6722: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
6723: ' Contract ID ='||l_contract_id||
6724: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
6725: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
6726: END IF;

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

6734: x_msg_count => l_msg_count
6735: );
6736: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6737: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
6738: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
6739: l_return_status||' x_msg_count ='||l_msg_count||')');
6740: END IF;
6741: EXCEPTION
6742: WHEN others THEN

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

7475: WHEN OTHERS THEN
7476: x_return_status := G_RET_STS_UNEXP_ERROR;
7477: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7478: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7479: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');
7480: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7481: 'Error: '|| substr(SQLERRM,1,500));
7482: END IF;
7483: END;

Line 7539: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

7535: WHERE kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
7536:
7537: l_contract_id NUMBER;
7538: l_pdf_id NUMBER;
7539: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
7540:
7541: BEGIN
7542: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

7587: WHEN OTHERS THEN
7588: l_return_status := G_RET_STS_UNEXP_ERROR;
7589: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7590: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7591: 'In Others exception for OKS_WF_K_PROCESS_PVT.k_approval_start');
7592: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name,
7593: 'Error: '|| substr(SQLERRM,1,500));
7594: END IF;
7595: END;

Line 7630: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

7626: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
7627:
7628: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7629: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7630: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
7631: ' Contract ID ='||l_contract_id||
7632: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
7633: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
7634: END IF;

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

7642: x_msg_count => l_msg_count
7643: );
7644: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7645: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7646: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
7647: l_return_status||' x_msg_count ='||l_msg_count||')');
7648: END IF;
7649: IF l_return_status <> G_RET_STS_SUCCESS THEN
7650: RAISE FND_API.G_EXC_ERROR;

Line 7765: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

7761: l_api_name CONSTANT VARCHAR2(30) := 'accept_quote';
7762:
7763: l_item_key wf_items.item_key%TYPE;
7764: l_activity_name VARCHAR2(30);
7765: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
7766:
7767: BEGIN
7768: -- start debug log
7769: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7832: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

7828: l_email_attr_rec.IH_MESSAGE := NULL;
7829:
7830: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7831: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7832: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
7833: ' Contract ID ='||p_contract_id||
7834: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
7835: END IF;
7836: set_email_attributes

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

7843: x_msg_count => x_msg_count
7844: );
7845: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7846: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7847: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
7848: x_return_status||' x_msg_count ='||x_msg_count||')');
7849: END IF;
7850: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
7851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7996: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

7992: l_item_key wf_items.item_key%TYPE;
7993: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;
7994: l_process_status VARCHAR2(30);
7995: l_activity_name VARCHAR2(30);
7996: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
7997:
7998: BEGIN
7999: -- start debug log
8000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8078: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||

8074:
8075: -- bug 5845505, send email only if template for the document type is setup
8076: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8077: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8078: 'OKS_WF_K_PROCESS_PVT.is_template_defined('||
8079: ' Contract ID ='||p_contract_id||
8080: ' Document Type ='||G_REPORT_TYPE_CANCEL||')');
8081: END IF;
8082: is_template_defined (

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

8092: );
8093:
8094: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8095: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8096: 'OKS_WF_K_PROCESS_PVT.is_template_defined(x_return_status= '||
8097: x_return_status||' x_msg_count ='||x_msg_count||')');
8098: END IF;
8099: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8120: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

8116:
8117: --log interaction (media type WEB FORM) that salesrep has declined the quote
8118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8120: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
8121: ' Contract ID = '||p_contract_id||
8122: substr(' IH Message = '||p_comments,1,100)||
8123: substr(' IH Subject = '||l_reason||')',1,100));
8124: END IF;

Line 8157: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||

8153: l_email_attr_rec.SENDER_EMAIL := NULL;
8154:
8155: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8156: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8157: 'OKS_WF_K_PROCESS_PVT.set_email_attributes('||
8158: ' Contract ID ='||p_contract_id||
8159: ' Email Type ='||l_email_attr_rec.EMAIL_TYPE||')');
8160: END IF;
8161: set_email_attributes

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

8168: x_msg_count => x_msg_count
8169: );
8170: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8171: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8172: 'OKS_WF_K_PROCESS_PVT.set_email_attributes(x_return_status= '||
8173: x_return_status||' x_msg_count ='||x_msg_count||')');
8174: END IF;
8175: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8205:
8206: IF l_activity_name IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
8207: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8208: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8209: 'OKS_WF_K_PROCESS_PVT.complete_activity(p_contract_id= '||
8210: p_contract_id||' p_resultout ='||l_result_out||
8211: ' p_process_status ='||l_process_status||
8212: ' p_activity_name ='||l_activity_name||')');
8213: END IF;

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

8225: x_msg_data => x_msg_data
8226: ) ;
8227: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8228: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8229: 'OKS_WF_K_PROCESS_PVT.complete_activity(x_return_status= '||
8230: x_return_status||' x_msg_count ='||x_msg_count||')');
8231: END IF;
8232: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
8233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8314: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;

8310: l_msg_count NUMBER;
8311: l_msg_data VARCHAR2(2000);
8312:
8313: l_contract_id NUMBER;
8314: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
8315:
8316: BEGIN
8317:
8318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8379: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

8375: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
8376:
8377: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8378: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8379: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
8380: ' Contract ID ='||l_contract_id||
8381: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
8382: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
8383: END IF;

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

8391: x_msg_count => l_msg_count
8392: );
8393: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8394: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8395: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
8396: l_return_status||' x_msg_count ='||l_msg_count||')');
8397: END IF;
8398: RAISE FND_API.G_EXC_ERROR;
8399: END IF;

Line 8444: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

8440: l_notif_attr_rec.MSGS_FROM_STACK_YN:= 'Y';
8441:
8442: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8443: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8444: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||
8445: ' Contract ID ='||l_contract_id||
8446: ' Notification Type ='||l_notif_attr_rec.NTF_TYPE||
8447: ' Subject ='||l_notif_attr_rec.NTF_SUBJECT||')');
8448: END IF;

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

8456: x_msg_count => l_msg_count
8457: );
8458: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8459: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8460: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes(x_return_status= '||
8461: l_return_status||' x_msg_count ='||l_msg_count||')');
8462: END IF;
8463: RAISE FND_API.G_EXC_ERROR;
8464: END IF;

Line 9000: END OKS_WF_K_PROCESS_PVT;

8996: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8997:
8998: END launch_k_process_wf_blk;
8999:
9000: END OKS_WF_K_PROCESS_PVT;