1 PACKAGE ASO_UPGRADE_PVT AUTHID CURRENT_USER as
2 /* $Header: asovupgs.pls 115.4 2002/12/07 19:39:38 hagrawal ship $ */
3 -- Start of Comments
4 -- Package name : ASO_UPGRADE_PVT
5 -- Purpose :This package will be used to insert the data in all aso migration scripts.
6 -- History :
7 -- NOTE :Data will be inserted in ASO_UPGRADE_ERRORS table.
8 -- End of Comments
9
10 Procedure add_message(
11 p_module_name IN VARCHAR2, --Valid Module Names are 'ASO','QOT:FORMS','QOT:HTML'
12 p_error_level IN VARCHAR2, -- Valid error Levels are 'ERROR','WARNING','INFORMATION'
13 p_error_text IN VARCHAR2,
14 p_creation_date IN DATE := sysdate,
15 p_source_name IN VARCHAR2, -- Pass the scriptname here like 'asopromg.sql'
16 p_table_name IN VARCHAR2 := NULL, -- Pass the table Name which raised the exception
17 p_identifier IN NUMBER := NULL -- Pass the corrosponding id here (e.g., quote_header_id,resource_id)
18 );
19 END ASO_UPGRADE_PVT;