DBA Data[Home] [Help]

APPS.ASL_SUMM_LOAD_GLBL_PKG dependencies on FND_MESSAGE

Line 86: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_INSERTED' );

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

Line 87: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );

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

Line 88: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );

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' );

Line 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

Line 93: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );

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

Line 94: FND_MESSAGE.SET_TOKEN( 'NUMBER_OF_ROWS', p_num_rows );

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' );

Line 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

Line 99: 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
103: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ERROR' );

Line 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:

Line 104: FND_MESSAGE.SET_TOKEN( 'PROCEDURE', p_procedure );

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

Line 105: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );

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

Line 106: FND_MESSAGE.SET_TOKEN( 'ERROR_MESSAGE', p_message );

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' );

Line 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' );

Line 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 );

Line 115: FND_MESSAGE.SET_TOKEN( 'START_RANGE', p_start );

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 );

Line 116: FND_MESSAGE.SET_TOKEN( 'END_RANGE', p_end );

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:

Line 117: FND_MESSAGE.SET_TOKEN( 'LOAD_YEAR', p_load_year );

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

Line 118: FND_MESSAGE.SET_TOKEN( 'LOAD_MODE', p_load_mode );

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' );

Line 119: FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );

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 );

Line 122: FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_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 );

Line 123: FND_MESSAGE.SET_TOKEN( 'MESSAGE', p_message );

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') );

Line 126: FND_MESSAGE.SET_TOKEN( 'TABLE_NAME', p_table );

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;

Line 127: FND_MESSAGE.SET_TOKEN( 'DATE_TIME', to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS') );

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:

Line 129: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET );

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:

Line 130: FND_MESSAGE.CLEAR;

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;