eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_PURGE dependencies on FND_MESSAGE

Line 14: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');

10: INVALID_PARAM_EXCEPTION EXCEPTION;
11: BEGIN
12:
13: IF (P_END_DATE > sysdate) THEN
14: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
15: FND_MSG_PUB.ADD;
16: RAISE INVALID_DATE_EXCEPTION;
17: END IF;
18:

Line 21: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');

17: END IF;
18:
19: /* Validate if end data is null and request is not for truncate */
20: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE= GMO_CONSTANTS_GRP.NO) THEN
21: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
22: FND_MSG_PUB.ADD;
23: RAISE INVALID_PARAM_EXCEPTION;
24: END IF ;
25:

Line 46: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_DEVICE_DB_ERR');

42: COMMIT;
43: END IF;
44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_DEVICE_DB_ERR');
47: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
48: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
49: FND_MSG_PUB.ADD;
50: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 47: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

43: END IF;
44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_DEVICE_DB_ERR');
47: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
48: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
49: FND_MSG_PUB.ADD;
50: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
51: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_device_data', FALSE);

Line 48: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_DEVICE_DB_ERR');
47: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
48: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
49: FND_MSG_PUB.ADD;
50: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
51: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_device_data', FALSE);
52: end if;

Line 68: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');

64: INVALID_PARAM_EXCEPTION EXCEPTION;
65: BEGIN
66:
67: IF (P_END_DATE > sysdate) THEN
68: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
69: FND_MSG_PUB.ADD;
70: RAISE INVALID_DATE_EXCEPTION;
71: END IF;
72:

Line 75: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');

71: END IF;
72:
73: /* Validate if end data is null and request is not for truncate */
74: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.NO) THEN
75: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
76: FND_MSG_PUB.ADD;
77: RAISE INVALID_PARAM_EXCEPTION;
78: END IF ;
79:

Line 115: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_INSTR_DB_ERR');

111: END IF;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_INSTR_DB_ERR');
116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
118: FND_MSG_PUB.ADD;
119: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_INSTR_DB_ERR');
116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
118: FND_MSG_PUB.ADD;
119: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
120: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_instruction_data', FALSE);

Line 117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

113: EXCEPTION
114: WHEN OTHERS THEN
115: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_INSTR_DB_ERR');
116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
118: FND_MSG_PUB.ADD;
119: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
120: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_instruction_data', FALSE);
121: end if;

Line 135: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');

131: INVALID_PARAM_EXCEPTION EXCEPTION;
132: BEGIN
133:
134: IF (P_END_DATE > sysdate) THEN
135: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
136: FND_MSG_PUB.ADD;
137: RAISE INVALID_DATE_EXCEPTION;
138: END IF;
139:

Line 142: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');

138: END IF;
139:
140: /* Validate if end data is null and request is not for truncate */
141: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.NO) THEN
142: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
143: FND_MSG_PUB.ADD;
144: RAISE INVALID_PARAM_EXCEPTION;
145: END IF ;
146:

Line 163: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_ALL_DB_ERR');

159: END IF;
160:
161: EXCEPTION
162: WHEN OTHERS THEN
163: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_ALL_DB_ERR');
164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
166: FND_MSG_PUB.ADD;
167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

160:
161: EXCEPTION
162: WHEN OTHERS THEN
163: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_ALL_DB_ERR');
164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
166: FND_MSG_PUB.ADD;
167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_all', FALSE);

Line 165: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

161: EXCEPTION
162: WHEN OTHERS THEN
163: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_ALL_DB_ERR');
164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
166: FND_MSG_PUB.ADD;
167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_all', FALSE);
169: end if;

Line 184: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PURGE_TOTAL_START') );

180: l_end_date date;
181: l_err_msg VARCHAR2(4000);
182: BEGIN
183:
184: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PURGE_TOTAL_START') );
185:
186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);

Line 186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');

182: BEGIN
183:
184: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PURGE_TOTAL_START') );
185:
186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);
189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);
190: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);

183:
184: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PURGE_TOTAL_START') );
185:
186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);
189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);
190: fnd_file.put_line(fnd_file.output, fnd_message.get);
191:

Line 188: fnd_message.set_token( 'AGE', P_AGE);

184: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PURGE_TOTAL_START') );
185:
186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);
189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);
190: fnd_file.put_line(fnd_file.output, fnd_message.get);
191:
192: l_end_date := sysdate - to_number(p_age);

Line 189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);

185:
186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);
189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);
190: fnd_file.put_line(fnd_file.output, fnd_message.get);
191:
192: l_end_date := sysdate - to_number(p_age);
193:

Line 190: fnd_file.put_line(fnd_file.output, fnd_message.get);

186: fnd_message.set_name('GMO', 'GMO_PURGE_PARAMETERS');
187: fnd_message.set_token( 'MODULE', P_MODULE_NAME);
188: fnd_message.set_token( 'AGE', P_AGE);
189: fnd_message.set_token( 'TRUNCATE_TABLE', P_TRUNCATE_TABLE);
190: fnd_file.put_line(fnd_file.output, fnd_message.get);
191:
192: l_end_date := sysdate - to_number(p_age);
193:
194: IF(P_MODULE_NAME is null) THEN

Line 208: fnd_message.set_name('GMO', 'GMO_PURGE_TOTAL_END');

204: P_TRUNCATE_TABLE => P_TRUNCATE_TABLE,
205: P_COMMIT => GMO_CONSTANTS_GRP.YES);
206: END IF;
207:
208: fnd_message.set_name('GMO', 'GMO_PURGE_TOTAL_END');
209: fnd_file.put_line(fnd_file.output, fnd_message.get);
210:
211: RETCODE := '0';
212: ERRBUF := '';

Line 209: fnd_file.put_line(fnd_file.output, fnd_message.get);

205: P_COMMIT => GMO_CONSTANTS_GRP.YES);
206: END IF;
207:
208: fnd_message.set_name('GMO', 'GMO_PURGE_TOTAL_END');
209: fnd_file.put_line(fnd_file.output, fnd_message.get);
210:
211: RETCODE := '0';
212: ERRBUF := '';
213: exception

Line 216: l_err_msg := fnd_message.get;

212: ERRBUF := '';
213: exception
214: when others then
215: -- Retrieve error message into errbuf
216: l_err_msg := fnd_message.get;
217: if (l_err_msg is not null) then
218: errbuf := l_err_msg;
219: else
220: errbuf := sqlerrm;