[Home] [Help]
69: | |
70: +===========================================================================*/
71:
72: PROCEDURE fetch_trx_type( p_trx_type_rec OUT NOCOPY ra_cust_trx_types%rowtype,
73: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
74: x_return_status OUT NOCOPY VARCHAR2
75: )
76: IS
77: BEGIN
85: p_trx_type_rec.name,
86: p_trx_type_rec.allow_overapplication_flag,
87: p_trx_type_rec.natural_application_only_flag,
88: p_trx_type_rec.creation_sign
89: FROM ra_cust_trx_types trxtype, ra_customer_trx header
90: WHERE header.customer_trx_id = p_customer_trx_id
91: AND trxtype.cust_trx_type_id = header.cust_trx_type_id;
92:
93: EXCEPTION
108: | Completes the transaction after the following checks |
109: | 1. Validate Tax enforcement |
110: | 2. Validate if transaction can be completed |
111: | 3. Perform document sequence number handling |
112: | 4. If all fine then update ra_customer_trx with complete_flag =Y|
113: | and call to maintain the payment schedules |
114: | |
115: | SCOPE - PUBLIC |
116: | |
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := NULL,
149: p_commit IN VARCHAR2 := NULL,
150: p_validation_level IN NUMBER := NULL,
151: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2) IS
155:
155:
156: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_TRANSACTION';
157: l_api_version CONSTANT NUMBER := 1.0;
158:
159: l_trx_rec ra_customer_trx%rowtype;
160: l_trx_type_rec ra_cust_trx_types%rowtype;
161: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
162: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
163: l_line_number NUMBER;
157: l_api_version CONSTANT NUMBER := 1.0;
158:
159: l_trx_rec ra_customer_trx%rowtype;
160: l_trx_type_rec ra_cust_trx_types%rowtype;
161: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
162: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
163: l_line_number NUMBER;
164: l_gl_tax_code VARCHAR2(50);
165: l_validation_status BOOLEAN;
158:
159: l_trx_rec ra_customer_trx%rowtype;
160: l_trx_type_rec ra_cust_trx_types%rowtype;
161: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
162: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
163: l_line_number NUMBER;
164: l_gl_tax_code VARCHAR2(50);
165: l_validation_status BOOLEAN;
166: l_error_count NUMBER;
333: +------------------------------------------------------------------------------------*/
334:
335: SELECT copy_doc_number_flag
336: INTO l_copy_doc_num_flag
337: FROM RA_BATCH_SOURCES batch, RA_CUSTOMER_TRX header
338: WHERE batch.batch_source_id = header.batch_source_id
339: AND header.customer_trx_id = p_customer_trx_id;
340:
341: IF NVL (l_copy_doc_num_flag, 'N') = 'Y'
429: | 1. It should not have been posted to GL |
430: | 2. There should not exist any activity against it |
431: | 3. There should not be a chargeback for the transaction |
432: | 4. There should not be debit memo reversal on the transaction |
433: | 4. If none of above then update ra_customer_trx with |
434: | complete_flag =N and call to maintain the payment schedules |
435: | |
436: | SCOPE - PUBLIC |
437: | |
468: p_api_version IN NUMBER,
469: p_init_msg_list IN VARCHAR2 := NULL,
470: p_commit IN VARCHAR2 := NULL,
471: p_validation_level IN NUMBER := NULL,
472: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2) IS
476:
476:
477: l_api_name CONSTANT VARCHAR2(30) := 'INCOMPLETE_TRANSACTION';
478: l_api_version CONSTANT NUMBER := 1.0;
479:
480: l_trx_rec ra_customer_trx%rowtype;
481: l_trx_type_rec ra_cust_trx_types%rowtype;
482: l_posted_flag VARCHAR2(1);
483: l_activity_flag VARCHAR2(1);
484: