DBA Data[Home] [Help]

APPS.ARW_CMREQ_COVER dependencies on ARW_CMREQ_COVER

Line 1: PACKAGE BODY arw_cmreq_cover AS

1: PACKAGE BODY arw_cmreq_cover AS
2: /* $Header: ARWCMRQB.pls 120.39.12010000.3 2008/09/03 06:42:03 naneja ship $ */
3:
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 65: arp_util.debug('arw_cmreq_cover.ar_request_cm(+)' );

61: WHERE ps.customer_trx_id = p_customer_trx_id;
62:
63: BEGIN
64: IF PG_DEBUG in ('Y', 'C') THEN
65: arp_util.debug('arw_cmreq_cover.ar_request_cm(+)' );
66: END IF;
67:
68: /*---------------------+
69: | Set the Org Context |

Line 506: arw_cmreq_cover.ar_autocreate_cm(

502: BEGIN
503:
504: -- bug 2290738, add p_status to capture status of CM creation
505:
506: arw_cmreq_cover.ar_autocreate_cm(
507: p_request_id => l_request_id,
508: p_batch_source_name => p_batch_source_name,
509: p_credit_method_rules => p_credit_method_rules,
510: p_credit_method_installments => p_credit_method_installments,

Line 537: arp_util.debug('error encountered in arw_cmreq_cover.ar_autocreate_cm, return -1');

533: where request_id = l_request_id;
534:
535: if l_status is not null then
536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_util.debug('error encountered in arw_cmreq_cover.ar_autocreate_cm, return -1');
538: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)');
539: END IF;
540: return('-1');
541: end if;

Line 538: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)');

534:
535: if l_status is not null then
536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_util.debug('error encountered in arw_cmreq_cover.ar_autocreate_cm, return -1');
538: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)');
539: END IF;
540: return('-1');
541: end if;
542: ELSE

Line 545: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)' || l_profile_value);

541: end if;
542: ELSE
543: fnd_profile.get('AR_USE_OAM_IN_CMWF', l_profile_value);
544: IF PG_DEBUG in ('Y', 'C') THEN
545: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)' || l_profile_value);
546: END IF;
547: IF (l_profile_value = 'Y') Then
548: BEGIN
549: l_threshold := WF_ENGINE.threshold;

Line 568: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)');

564:
565: END IF;
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)');
569: END IF;
570: RETURN l_request_id;
571:
572: EXCEPTION

Line 647: arp_util.debug('arw_cmreq_cover.ar_autocreate_cm(+)');

643:
644: BEGIN
645:
646: IF PG_DEBUG in ('Y', 'C') THEN
647: arp_util.debug('arw_cmreq_cover.ar_autocreate_cm(+)');
648: arp_util.debug( 'in parameters are : ');
649: arp_util.debug( 'p_request_id = ' || to_char(p_request_id));
650: arp_util.debug( 'p_batch_source_name = ' || p_batch_source_name);
651: arp_util.debug( 'p_credit_method_rules = ' || p_credit_method_rules);

Line 1127: arp_util.debug( 'arw_cmreq_cover.get_cm_defaults(-)');

1123: END IF;
1124:
1125:
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_util.debug( 'arw_cmreq_cover.get_cm_defaults(-)');
1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN

Line 1168: WF_CORE.CONTEXT('ARW_CMREQ_COVER', 'CANCEL_CM_REQUEST',

1164:
1165: exception
1166: when others then
1167:
1168: WF_CORE.CONTEXT('ARW_CMREQ_COVER', 'CANCEL_CM_REQUEST',
1169: p_event.getEventName(), p_subscription_guid);
1170: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1171:
1172: RETURN 'ERROR';

Line 1176: END ARW_CMREQ_COVER;

1172: RETURN 'ERROR';
1173:
1174: end;
1175:
1176: END ARW_CMREQ_COVER;