[Home] [Help]
234: p_process_partial VARCHAR2(1);
235: p_debug VARCHAR2(1);
236: p_trace VARCHAR2(1);
237: --********* GLOBAL Variables ***********
238: v_batch_id NUMBER; -- used as unique key in JAI_CMN_MTAX_HDRS_ALL table
239:
240: /* --Ramananda for File.Sql.35*/
241: v_today DATE; -- := trunc(sysdate);
242: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
848:
849: 8. 25-Aug-2005 Aiyer bug 4565665,File Version 120.3
850: Issue : Concurrent program India- Mass Tax REcalculation (JAINMTCH) was throwing the following errors
851: 1. Wrong Number of arguments or types to do_tax_redefaultation .
852: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
853: Reason and Fix:-
854: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
855: This parameter was previously added to debug from backend with dbms_output.
856: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
857: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
858: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
859: This can now be also enabled from conc program.
860:
861: 2. Last_update_date and last_updated_by are not nulls in table JAI_CMN_MTAX_HDRS_ALL however the current procedure
862: was not inserting any value in this columnns, hence the reported error. Fixed this issue by adding these columns in the insert
863: statement.
864: Dependency Due to this bug:-
865: jai_cmn_mtax.pls (120.2)
1020: ', p_process_partial -> '||p_process_partial
1021: );
1022: END IF;
1023:
1024: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1025:
1026: -- Entry into mass tax change requests table.
1027: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1028: (
1023:
1024: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1025:
1026: -- Entry into mass tax change requests table.
1027: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1028: (
1029: batch_id,
1030: org_id,
1031: document_type,
1056: )
1057: VALUES
1058: (
1059: --v_batch_id,
1060: JAI_CMN_MTAX_HDRS_ALL_S.nextval,
1061: ln_org_id,
1062: p_document_type,
1063: p_from_date,
1064: p_to_date,
1113: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1114: UTL_FILE.fclose(v_myfilehandle);
1115: END IF;
1116:
1117: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1118:
1119: COMMIT;
1120: RETURN;
1121: END IF;
1212: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1213: UTL_FILE.fclose(v_myfilehandle);
1214: END IF;
1215:
1216: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1217:
1218: COMMIT;
1219: RETURN;
1220: END IF;
1316: END IF;
1317:
1318: IF v_document_find_failed = 'Y' THEN
1319:
1320: UPDATE JAI_CMN_MTAX_HDRS_ALL
1321: SET error_message = v_message
1322: WHERE batch_id = v_batch_id;
1323:
1324: p_ret_code := 1;
3595: UTL_FILE.fclose(v_myfilehandle);
3596: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
3597: END IF;
3598: v_message := SQLERRM;
3599: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
3600:
3601: p_ret_code := 1;
3602: p_err_buf := v_message;
3603: