[Home] [Help]
275: p_process_partial VARCHAR2(1);
276: p_debug VARCHAR2(1);
277: p_trace VARCHAR2(1);
278: --********* GLOBAL Variables ***********
279: v_batch_id NUMBER; -- used as unique key in JAI_CMN_MTAX_HDRS_ALL table
280:
281: /* --Ramananda for File.Sql.35*/
282: v_today DATE; -- := trunc(sysdate);
283: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
1178:
1179: 8. 25-Aug-2005 Aiyer bug 4565665,File Version 120.3
1180: Issue : Concurrent program India- Mass Tax REcalculation (JAINMTCH) was throwing the following errors
1181: 1. Wrong Number of arguments or types to do_tax_redefaultation .
1182: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
1183: Reason and Fix:-
1184: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
1185: This parameter was previously added to debug from backend with dbms_output.
1186: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
1187: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
1188: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
1189: This can now be also enabled from conc program.
1190:
1191: 2. Last_update_date and last_updated_by are not nulls in table JAI_CMN_MTAX_HDRS_ALL however the current procedure
1192: was not inserting any value in this columnns, hence the reported error. Fixed this issue by adding these columns in the insert
1193: statement.
1194: Dependency Due to this bug:-
1195: jai_cmn_mtax.pls (120.2)
1370: ', p_process_partial -> '||p_process_partial
1371: );
1372: END IF;
1373:
1374: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1375:
1376: -- Entry into mass tax change requests table.
1377: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1378: (
1373:
1374: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1375:
1376: -- Entry into mass tax change requests table.
1377: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1378: (
1379: batch_id,
1380: org_id,
1381: document_type,
1406: )
1407: VALUES
1408: (
1409: --v_batch_id,
1410: JAI_CMN_MTAX_HDRS_ALL_S.nextval,
1411: ln_org_id,
1412: p_document_type,
1413: p_from_date,
1414: p_to_date,
1467: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1468: UTL_FILE.fclose(v_myfilehandle);
1469: END IF;
1470:
1471: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1472:
1473: COMMIT;
1474: RETURN;
1475: END IF;
1573: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1574: UTL_FILE.fclose(v_myfilehandle);
1575: END IF;
1576:
1577: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1578:
1579: COMMIT;
1580: RETURN;
1581: END IF;
1715: END IF;
1716:
1717: IF v_document_find_failed = 'Y' THEN
1718:
1719: UPDATE JAI_CMN_MTAX_HDRS_ALL
1720: SET error_message = v_message
1721: WHERE batch_id = v_batch_id;
1722:
1723: p_ret_code := 1;
4742: UTL_FILE.fclose(v_myfilehandle);
4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
4744: END IF;
4745: v_message := SQLERRM;
4746: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
4747:
4748: p_ret_code := 1;
4749: p_err_buf := v_message;
4750: