3123:
3124: -- Trigger the launch of WFs
3125: IF lp_term_rec.preproceeds_yn = G_YES THEN
3126: IF (is_debug_statement_on) THEN
3127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_WF.raise_business_event');
3128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lp_term_rec.id: ' || lp_term_rec.id);
3129: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event: oracle.apps.okl.am.preproceeds');
3130: END IF;
3131: -- Launch the pre-proceeds WF
3128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lp_term_rec.id: ' || lp_term_rec.id);
3129: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event: oracle.apps.okl.am.preproceeds');
3130: END IF;
3131: -- Launch the pre-proceeds WF
3132: OKL_AM_WF.raise_business_event (
3133: p_transaction_id => lp_term_rec.id,
3134: p_event_name => 'oracle.apps.okl.am.preproceeds');
3135: IF (is_debug_statement_on) THEN
3136: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3132: OKL_AM_WF.raise_business_event (
3133: p_transaction_id => lp_term_rec.id,
3134: p_event_name => 'oracle.apps.okl.am.preproceeds');
3135: IF (is_debug_statement_on) THEN
3136: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3137: END IF;
3138:
3139: -- Get the event name
3140: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3152: END IF;
3153:
3154: ELSE
3155: IF (is_debug_statement_on) THEN
3156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_WF.raise_business_event');
3157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lp_term_rec.id: ' || lp_term_rec.id);
3158: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event: oracle.apps.okl.am.postproceeds');
3159: END IF;
3160: -- Launch the post-proceeds WF
3157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lp_term_rec.id: ' || lp_term_rec.id);
3158: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event: oracle.apps.okl.am.postproceeds');
3159: END IF;
3160: -- Launch the post-proceeds WF
3161: OKL_AM_WF.raise_business_event (
3162: p_transaction_id => lp_term_rec.id,
3163: p_event_name => 'oracle.apps.okl.am.postproceeds');
3164: IF (is_debug_statement_on) THEN
3165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3161: OKL_AM_WF.raise_business_event (
3162: p_transaction_id => lp_term_rec.id,
3163: p_event_name => 'oracle.apps.okl.am.postproceeds');
3164: IF (is_debug_statement_on) THEN
3165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3166: END IF;
3167:
3168: -- Get the event name
3169: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3186:
3187: -- Set message on stack
3188: -- Workflow event EVENT_NAME has been requested.
3189: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
3190: p_msg_name => 'OKL_AM_WF_EVENT_MSG',
3191: p_token1 => 'EVENT_NAME',
3192: p_token1_value => l_event_name);
3193:
3194:
3456: -- Check Pre or Post Proceeds
3457: IF nvl(p_term_tbl(i).preproceeds_yn,'*') = G_YES THEN
3458:
3459: IF (is_debug_statement_on) THEN
3460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_WF.raise_business_event');
3461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_tbl(' || i || ').id : ' || p_term_tbl(i).id);
3462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.preproceeds');
3463: END IF;
3464: -- Launch the pre-proceeds WF
3461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_tbl(' || i || ').id : ' || p_term_tbl(i).id);
3462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.preproceeds');
3463: END IF;
3464: -- Launch the pre-proceeds WF
3465: OKL_AM_WF.raise_business_event (
3466: p_transaction_id => p_term_tbl(i).id,
3467: p_event_name => 'oracle.apps.okl.am.preproceeds');
3468: IF (is_debug_statement_on) THEN
3469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3465: OKL_AM_WF.raise_business_event (
3466: p_transaction_id => p_term_tbl(i).id,
3467: p_event_name => 'oracle.apps.okl.am.preproceeds');
3468: IF (is_debug_statement_on) THEN
3469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3470: END IF;
3471:
3472: -- Get the event name
3473: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3489: -- Set message on stack
3490: -- Workflow event EVENT_NAME has been requested.
3491: OKL_API.set_message(
3492: p_app_name => OKL_API.G_APP_NAME,
3493: p_msg_name => 'OKL_AM_WF_EVENT_MSG',
3494: p_token1 => 'EVENT_NAME',
3495: p_token1_value => l_event_name);
3496:
3497: ELSE -- Post Proceeds
3496:
3497: ELSE -- Post Proceeds
3498:
3499: IF (is_debug_statement_on) THEN
3500: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_WF.raise_business_event');
3501: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_tbl(' || i || ').id : ' || p_term_tbl(i).id);
3502: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.postproceeds');
3503: END IF;
3504: -- Launch the post-proceeds WF
3501: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_tbl(' || i || ').id : ' || p_term_tbl(i).id);
3502: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.postproceeds');
3503: END IF;
3504: -- Launch the post-proceeds WF
3505: OKL_AM_WF.raise_business_event (
3506: p_transaction_id => p_term_tbl(i).id,
3507: p_event_name => 'oracle.apps.okl.am.postproceeds');
3508:
3509: IF (is_debug_statement_on) THEN
3506: p_transaction_id => p_term_tbl(i).id,
3507: p_event_name => 'oracle.apps.okl.am.postproceeds');
3508:
3509: IF (is_debug_statement_on) THEN
3510: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3511: END IF;
3512: -- Get the event name
3513: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3514: p_wf_process_type => 'OKLAMPPT',
3529: -- Set message on stack
3530: -- Workflow event EVENT_NAME has been requested.
3531: OKL_API.set_message(
3532: p_app_name => OKL_API.G_APP_NAME,
3533: p_msg_name => 'OKL_AM_WF_EVENT_MSG',
3534: p_token1 => 'EVENT_NAME',
3535: p_token1_value => l_event_name);
3536:
3537: END IF;
3779: RAISE OKL_API.G_EXCEPTION_ERROR;
3780: ELSE
3781:
3782: IF (is_debug_statement_on) THEN
3783: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_WF.raise_business_event');
3784: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_term_rec.id : ' || p_term_rec.id);
3785: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.submitquoteforapproval');
3786: END IF;
3787: -- Launch the NSend Quote WF
3785: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'event : oracle.apps.okl.am.submitquoteforapproval');
3786: END IF;
3787: -- Launch the NSend Quote WF
3788: -- RMUNJULU 3630826 Changed the business event being raised to a new seeded one
3789: OKL_AM_WF.raise_business_event (
3790: p_transaction_id => p_term_rec.id,
3791: p_event_name => 'oracle.apps.okl.am.submitquoteforapproval');
3792: IF (is_debug_statement_on) THEN
3793: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3789: OKL_AM_WF.raise_business_event (
3790: p_transaction_id => p_term_rec.id,
3791: p_event_name => 'oracle.apps.okl.am.submitquoteforapproval');
3792: IF (is_debug_statement_on) THEN
3793: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3795: END IF;
3796: -- Save messages in database
3797: OKL_AM_UTIL_PVT.process_messages (