82: BEGIN
83:
84: IF p_action = 'I' -- Insert
85: THEN
86: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_INSERTED' );
87: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
88: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
89:
90: ELSIF p_action = 'U' -- Update
83:
84: IF p_action = 'I' -- Insert
85: THEN
86: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_INSERTED' );
87: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
88: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
89:
90: ELSIF p_action = 'U' -- Update
91: THEN
84: IF p_action = 'I' -- Insert
85: THEN
86: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_INSERTED' );
87: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
88: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
89:
90: ELSIF p_action = 'U' -- Update
91: THEN
92: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_UPDATED' );
88: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
89:
90: ELSIF p_action = 'U' -- Update
91: THEN
92: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_UPDATED' );
93: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
94: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
95:
96: ELSIF p_action = 'D' -- Delete
89:
90: ELSIF p_action = 'U' -- Update
91: THEN
92: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_UPDATED' );
93: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
94: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
95:
96: ELSIF p_action = 'D' -- Delete
97: THEN
90: ELSIF p_action = 'U' -- Update
91: THEN
92: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_UPDATED' );
93: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
94: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
95:
96: ELSIF p_action = 'D' -- Delete
97: THEN
98: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_DELETED' );
94: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
95:
96: ELSIF p_action = 'D' -- Delete
97: THEN
98: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_DELETED' );
99: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
100:
101: ELSIF p_action = 'E' -- Error
102: THEN
95:
96: ELSIF p_action = 'D' -- Delete
97: THEN
98: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_DELETED' );
99: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
100:
101: ELSIF p_action = 'E' -- Error
102: THEN
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );
99: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );
100:
101: ELSIF p_action = 'E' -- Error
102: THEN
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );
104: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
105: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );
107:
100:
101: ELSIF p_action = 'E' -- Error
102: THEN
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );
104: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
105: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );
107:
108: ELSIF p_action = 'C' -- Completed
101: ELSIF p_action = 'E' -- Error
102: THEN
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );
104: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
105: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );
107:
108: ELSIF p_action = 'C' -- Completed
109: THEN
102: THEN
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );
104: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );
105: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );
107:
108: ELSIF p_action = 'C' -- Completed
109: THEN
110: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_COMPLETED' );
106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );
107:
108: ELSIF p_action = 'C' -- Completed
109: THEN
110: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_COMPLETED' );
111:
112: ELSIF p_action = 'B' -- Load Begin
113: THEN
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
110: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_COMPLETED' );
111:
112: ELSIF p_action = 'B' -- Load Begin
113: THEN
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
111:
112: ELSIF p_action = 'B' -- Load Begin
113: THEN
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
112: ELSIF p_action = 'B' -- Load Begin
113: THEN
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
113: THEN
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
121: ELSE -- Message
114: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_BEGIN' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
121: ELSE -- Message
122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_MESSAGE' );
115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );
116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );
117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
121: ELSE -- Message
122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_MESSAGE' );
123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );
118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
121: ELSE -- Message
122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_MESSAGE' );
123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );
124: END IF;
125:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );
120:
121: ELSE -- Message
122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_MESSAGE' );
123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );
124: END IF;
125:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );
122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_MESSAGE' );
123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );
124: END IF;
125:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );
128:
129: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET );
130: FND_MESSAGE.CLEAR;
123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );
124: END IF;
125:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );
128:
129: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET );
130: FND_MESSAGE.CLEAR;
131:
125:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );
128:
129: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET );
130: FND_MESSAGE.CLEAR;
131:
132: END Write_Log;
133:
126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );
127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );
128:
129: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET );
130: FND_MESSAGE.CLEAR;
131:
132: END Write_Log;
133:
134: END asl_summ_load_glbl_pkg;