302: -- -------------------------------------------------
303: -- Raise business event
304: -- oracle.apps.pv.benefit.referral.statusChange
305: -- -------------------------------------------------
306: Debug('Calling pv_benft_status_change.status_change_raise...');
307: pv_benft_status_change.status_change_raise(
308: p_api_version_number => 1.0,
309: p_init_msg_list => FND_API.G_FALSE,
310: p_commit => FND_API.G_FALSE,
303: -- Raise business event
304: -- oracle.apps.pv.benefit.referral.statusChange
305: -- -------------------------------------------------
306: Debug('Calling pv_benft_status_change.status_change_raise...');
307: pv_benft_status_change.status_change_raise(
308: p_api_version_number => 1.0,
309: p_init_msg_list => FND_API.G_FALSE,
310: p_commit => FND_API.G_FALSE,
311: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
312: p_benefit_id => x.benefit_id,
313: p_entity_id => x.referral_id,
314: p_status_code => 'CLOSED_LOST_OPPTY',
315: p_partner_id => x.partner_id,
316: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
317: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
318: x_return_status => l_return_status,
319: x_msg_count => l_msg_count,
320: x_msg_data => l_msg_data);
313: p_entity_id => x.referral_id,
314: p_status_code => 'CLOSED_LOST_OPPTY',
315: p_partner_id => x.partner_id,
316: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
317: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
318: x_return_status => l_return_status,
319: x_msg_count => l_msg_count,
320: x_msg_data => l_msg_data);
321:
331:
332: -- -------------------------------------------------
333: -- Log the event.
334: -- -------------------------------------------------
335: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
336: pv_benft_status_change.STATUS_CHANGE_LOGGING(
337: p_api_version_number => 1.0,
338: p_init_msg_list => FND_API.G_FALSE,
339: p_commit => FND_API.G_FALSE,
332: -- -------------------------------------------------
333: -- Log the event.
334: -- -------------------------------------------------
335: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
336: pv_benft_status_change.STATUS_CHANGE_LOGGING(
337: p_api_version_number => 1.0,
338: p_init_msg_list => FND_API.G_FALSE,
339: p_commit => FND_API.G_FALSE,
340: p_benefit_id => x.benefit_id,
408: -- -------------------------------------------------
409: -- Raise business event
410: -- oracle.apps.pv.benefit.referral.statusChange
411: -- -------------------------------------------------
412: Debug('Calling pv_benft_status_change.status_change_raise...');
413: pv_benft_status_change.status_change_raise(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
409: -- Raise business event
410: -- oracle.apps.pv.benefit.referral.statusChange
411: -- -------------------------------------------------
412: Debug('Calling pv_benft_status_change.status_change_raise...');
413: pv_benft_status_change.status_change_raise(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
417: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
418: p_benefit_id => x.benefit_id,
419: p_entity_id => x.referral_id,
420: p_status_code => 'CLOSED_OPPTY_WON',
421: p_partner_id => x.partner_id,
422: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
423: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
424: x_return_status => l_return_status,
425: x_msg_count => l_msg_count,
426: x_msg_data => l_msg_data);
419: p_entity_id => x.referral_id,
420: p_status_code => 'CLOSED_OPPTY_WON',
421: p_partner_id => x.partner_id,
422: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
423: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
424: x_return_status => l_return_status,
425: x_msg_count => l_msg_count,
426: x_msg_data => l_msg_data);
427:
436:
437: -- -------------------------------------------------
438: -- Log the event.
439: -- -------------------------------------------------
440: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
441: pv_benft_status_change.STATUS_CHANGE_LOGGING(
442: p_api_version_number => 1.0,
443: p_init_msg_list => FND_API.G_FALSE,
444: p_commit => FND_API.G_FALSE,
437: -- -------------------------------------------------
438: -- Log the event.
439: -- -------------------------------------------------
440: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
441: pv_benft_status_change.STATUS_CHANGE_LOGGING(
442: p_api_version_number => 1.0,
443: p_init_msg_list => FND_API.G_FALSE,
444: p_commit => FND_API.G_FALSE,
445: p_benefit_id => x.benefit_id,
511: -- -------------------------------------------------
512: -- Raise business event
513: -- oracle.apps.pv.benefit.referral.statusChange
514: -- -------------------------------------------------
515: Debug('Calling pv_benft_status_change.status_change_raise...');
516: pv_benft_status_change.status_change_raise(
517: p_api_version_number => 1.0,
518: p_init_msg_list => FND_API.G_FALSE,
519: p_commit => FND_API.G_FALSE,
512: -- Raise business event
513: -- oracle.apps.pv.benefit.referral.statusChange
514: -- -------------------------------------------------
515: Debug('Calling pv_benft_status_change.status_change_raise...');
516: pv_benft_status_change.status_change_raise(
517: p_api_version_number => 1.0,
518: p_init_msg_list => FND_API.G_FALSE,
519: p_commit => FND_API.G_FALSE,
520: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
521: p_benefit_id => x.benefit_id,
522: p_entity_id => x.referral_id,
523: p_status_code => 'CLOSED_DEAD_LEAD',
524: p_partner_id => x.partner_id,
525: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
526: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
527: x_return_status => l_return_status,
528: x_msg_count => l_msg_count,
529: x_msg_data => l_msg_data);
522: p_entity_id => x.referral_id,
523: p_status_code => 'CLOSED_DEAD_LEAD',
524: p_partner_id => x.partner_id,
525: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
526: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
527: x_return_status => l_return_status,
528: x_msg_count => l_msg_count,
529: x_msg_data => l_msg_data);
530:
539:
540: -- -------------------------------------------------
541: -- Log the event.
542: -- -------------------------------------------------
543: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
544: pv_benft_status_change.STATUS_CHANGE_LOGGING(
545: p_api_version_number => 1.0,
546: p_init_msg_list => FND_API.G_FALSE,
547: p_commit => FND_API.G_FALSE,
540: -- -------------------------------------------------
541: -- Log the event.
542: -- -------------------------------------------------
543: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
544: pv_benft_status_change.STATUS_CHANGE_LOGGING(
545: p_api_version_number => 1.0,
546: p_init_msg_list => FND_API.G_FALSE,
547: p_commit => FND_API.G_FALSE,
548: p_benefit_id => x.benefit_id,
615: -- -------------------------------------------------
616: -- Raise business event
617: -- oracle.apps.pv.benefit.referral.statusChange
618: -- -------------------------------------------------
619: Debug('Calling pv_benft_status_change.status_change_raise...');
620: pv_benft_status_change.status_change_raise(
621: p_api_version_number => 1.0,
622: p_init_msg_list => FND_API.G_FALSE,
623: p_commit => FND_API.G_FALSE,
616: -- Raise business event
617: -- oracle.apps.pv.benefit.referral.statusChange
618: -- -------------------------------------------------
619: Debug('Calling pv_benft_status_change.status_change_raise...');
620: pv_benft_status_change.status_change_raise(
621: p_api_version_number => 1.0,
622: p_init_msg_list => FND_API.G_FALSE,
623: p_commit => FND_API.G_FALSE,
624: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
625: p_benefit_id => x.benefit_id,
626: p_entity_id => x.referral_id,
627: p_status_code => 'EXPIRED',
628: p_partner_id => x.partner_id,
629: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
630: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
631: x_return_status => l_return_status,
632: x_msg_count => l_msg_count,
633: x_msg_data => l_msg_data);
626: p_entity_id => x.referral_id,
627: p_status_code => 'EXPIRED',
628: p_partner_id => x.partner_id,
629: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
630: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
631: x_return_status => l_return_status,
632: x_msg_count => l_msg_count,
633: x_msg_data => l_msg_data);
634:
643:
644: -- -------------------------------------------------
645: -- Log the event.
646: -- -------------------------------------------------
647: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
648: pv_benft_status_change.STATUS_CHANGE_LOGGING(
649: p_api_version_number => 1.0,
650: p_init_msg_list => FND_API.G_FALSE,
651: p_commit => FND_API.G_FALSE,
644: -- -------------------------------------------------
645: -- Log the event.
646: -- -------------------------------------------------
647: Debug('Calling pv_benft_status_change.STATUS_CHANGE_LOGGING...');
648: pv_benft_status_change.STATUS_CHANGE_LOGGING(
649: p_api_version_number => 1.0,
650: p_init_msg_list => FND_API.G_FALSE,
651: p_commit => FND_API.G_FALSE,
652: p_benefit_id => x.benefit_id,