[Home] [Help]
303: END IF;
304: --
305: IF ( p_cb_ct_id is NULL OR p_reversal_gl_date is NULL OR
306: p_reversal_date is NULL ) THEN
307: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
308: APP_EXCEPTION.raise_exception;
309: END IF;
310: IF PG_DEBUG in ('Y', 'C') THEN
311: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_revcb' );
664: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
665: BEGIN
666: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_ct' );
667: IF ( p_ct_id is NULL ) THEN
668: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
669: APP_EXCEPTION.raise_exception;
670: END IF;
671: --
672: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_ct' );
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_group' );
712: END IF;
713: IF ( p_ps_id is NULL OR p_ass_cr_id is NULL OR p_ct_count is NULL ) THEN
714: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
715: APP_EXCEPTION.raise_exception;
716: END IF;
717: --
718: IF PG_DEBUG in ('Y', 'C') THEN
789: -- ---------------------------------------------------
790: -- If one ore more variables were invalid, display the error
791: -- ---------------------------------------------------
792: IF (l_parameter_tokens <> '') THEN
793: fnd_message.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
794: fnd_message.set_token('PARAMETER',l_parameter_tokens);
795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');
796: app_exception.raise_exception;
797: END IF;
790: -- If one ore more variables were invalid, display the error
791: -- ---------------------------------------------------
792: IF (l_parameter_tokens <> '') THEN
793: fnd_message.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
794: fnd_message.set_token('PARAMETER',l_parameter_tokens);
795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');
796: app_exception.raise_exception;
797: END IF;
798:
791: -- ---------------------------------------------------
792: IF (l_parameter_tokens <> '') THEN
793: fnd_message.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
794: fnd_message.set_token('PARAMETER',l_parameter_tokens);
795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');
796: app_exception.raise_exception;
797: END IF;
798:
799: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(-)' );
1605: into l_term_end_date
1606: from ra_terms where term_id = 5;
1607:
1608: IF (NVL(l_term_end_date, to_date('31-12-4712','DD-MM-YYYY')) < p_trx_date ) THEN
1609: FND_MESSAGE.SET_NAME('AR','AR_RW_PAYMENT_TERM_END_DATED');
1610: APP_EXCEPTION.raise_exception;
1611: END IF;
1612: /*5084781 End*/
1613:
1866: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID
1867: AND rt.code_combination_id IS NOT NULL;
1868: EXCEPTION
1869: WHEN NO_DATA_FOUND THEN
1870: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );
1871: app_exception.raise_exception;
1872: WHEN OTHERS THEN
1873: IF PG_DEBUG in ('Y', 'C') THEN
1874: arp_standard.debug( '-- Exception: select from ar_receivables_trx');
2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: --Fix for Bug 1421614: For 'Partial' we should not raise the exception.
2204: IF NVL(fnd_profile.value('UNIQUE:SEQ_NUMBERS'),'N') = 'A' THEN
2205: FND_MESSAGE.set_name ('AR', 'AR_RW_NO_DOC_SEQ' );
2206: APP_EXCEPTION.raise_exception;
2207: END IF;
2208: END;
2209: