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.CN_PURGE_TABLES_PUB dependencies on FND_MSG_PUB

Line 188: FND_MSG_PUB.initialize;

184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: -- Initialize message list if p_init_msg_list is set to TRUE.
187: IF FND_API.to_Boolean( l_init_msg_list ) THEN
188: FND_MSG_PUB.initialize;
189: END IF;
190:
191: -- Initialize API return status to success
192: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 199: fnd_msg_pub.add;

195: l_error_msg := 'p_org_id' || g_error_msg;
196: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
197: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
198: fnd_message.set_token('FIELD','p_org_id');
199: fnd_msg_pub.add;
200: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
201: END IF;
202:
203: mo_global.set_policy_context('S',p_org_id);

Line 210: fnd_msg_pub.add;

206: l_error_msg := 'p_start_period_name' || g_error_msg;
207: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
208: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
209: fnd_message.set_token('FIELD','p_start_period_name');
210: fnd_msg_pub.add;
211: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
212: END IF;
213:
214: IF(p_end_period_name is null) THEN

Line 219: fnd_msg_pub.add;

215: l_error_msg := 'p_end_period_name' || g_error_msg;
216: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
217: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
218: fnd_message.set_token('FIELD','p_end_period_name');
219: fnd_msg_pub.add;
220: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
221: END IF;
222:
223: OPEN get_start_period_id; -- open the cursor

Line 240: fnd_msg_pub.add;

236: l_error_msg := 'Start Period Id calculation error: Please enter proper values for p_start_period_name and p_org_d';
237: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
238: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
239: fnd_message.set_token('FIELD','p_start_period_name');
240: fnd_msg_pub.add;
241: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
242: END IF;
243:
244: IF(l_end_period_id = -1) THEN

Line 249: fnd_msg_pub.add;

245: l_error_msg := 'End Period Id calculation error: Please enter proper values for p_end_period_name and p_org_d';
246: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
247: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
248: fnd_message.set_token('FIELD','p_end_period_name');
249: fnd_msg_pub.add;
250: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
251: END IF;
252:
253: IF(p_run_mode <> 'A' and p_run_mode <> 'P') THEN

Line 258: fnd_msg_pub.add;

254: l_error_msg := 'p_run_mode' || g_error_msg;
255: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
256: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
257: fnd_message.set_token('FIELD','p_run_mode');
258: fnd_msg_pub.add;
259: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
260: END IF;
261:
262: IF(p_run_mode = 'P') THEN

Line 268: fnd_msg_pub.add;

264: l_error_msg := 'p_no_of_workers' || g_error_msg;
265: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
266: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
267: fnd_message.set_token('FIELD','p_no_of_workers (Expected value between 1 and 10)');
268: fnd_msg_pub.add;
269: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
270: END IF;
271:
272: IF(p_worker_id is null or p_worker_id <= 0) THEN

Line 277: fnd_msg_pub.add;

273: l_error_msg := 'p_worker_id' || g_error_msg;
274: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
275: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
276: fnd_message.set_token('FIELD','p_worker_id (Expected value > 0)');
277: fnd_msg_pub.add;
278: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
279: END IF;
280:
281: IF(p_batch_size is null or p_batch_size <= 0) THEN

Line 286: fnd_msg_pub.add;

282: l_error_msg := 'p_batch_size' || g_error_msg;
283: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: l_error_msg: ' || l_error_msg);
284: fnd_message.set_name('CN', 'CN_AP_REQ_FIELD_NOT_SET_ERROR');
285: fnd_message.set_token('FIELD','p_batch_size (Expected value > 0)');
286: fnd_msg_pub.add;
287: RAISE CN_PURGE_REQ_FIELD_NOT_SET_ER;
288: END IF;
289: END IF;
290:

Line 404: FND_MSG_PUB.Count_And_Get

400: x_return_status := 'F';
401: retcode := '-1';
402: --errbuf := l_error_msg;
403: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables:exception: CN_AIA_REQ_FIELD_NOT_SET_ERROR: ');
404: FND_MSG_PUB.Count_And_Get
405: (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data