[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;
328: +------------------------------------------------------------------------------------*/
329:
330: SELECT copy_doc_number_flag
331: INTO l_copy_doc_num_flag
332: FROM RA_BATCH_SOURCES batch, RA_CUSTOMER_TRX header
333: WHERE batch.batch_source_id = header.batch_source_id
334: AND header.customer_trx_id = p_customer_trx_id;
335:
336: IF NVL (l_copy_doc_num_flag, 'N') = 'Y'
424: | 1. It should not have been posted to GL |
425: | 2. There should not exist any activity against it |
426: | 3. There should not be a chargeback for the transaction |
427: | 4. There should not be debit memo reversal on the transaction |
428: | 4. If none of above then update ra_customer_trx with |
429: | complete_flag =N and call to maintain the payment schedules |
430: | |
431: | SCOPE - PUBLIC |
432: | |
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := NULL,
465: p_commit IN VARCHAR2 := NULL,
466: p_validation_level IN NUMBER := NULL,
467: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
468: x_return_status OUT NOCOPY VARCHAR2,
469: x_msg_count OUT NOCOPY NUMBER,
470: x_msg_data OUT NOCOPY VARCHAR2) IS
471:
471:
472: l_api_name CONSTANT VARCHAR2(30) := 'INCOMPLETE_TRANSACTION';
473: l_api_version CONSTANT NUMBER := 1.0;
474:
475: l_trx_rec ra_customer_trx%rowtype;
476: l_trx_type_rec ra_cust_trx_types%rowtype;
477: l_posted_flag VARCHAR2(1);
478: l_activity_flag VARCHAR2(1);
479: