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

Line 71: FND_MSG_PUB.initialize;

67: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: IF FND_API.to_boolean(p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: OKS_RENEW_CONTRACT_PVT.renew_contract(

Line 106: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

102:
103: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
104: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
105: END IF;
106: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
107:
108: EXCEPTION
109: WHEN FND_API.g_exc_error THEN
110: ROLLBACK TO renew_contract_PUB;

Line 116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

112:
113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
115: END IF;
116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.g_exc_unexpected_error THEN
119: ROLLBACK TO renew_contract_PUB;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 125: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

121:
122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
123: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
124: END IF;
125: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
126:
127: WHEN OTHERS THEN
128: ROLLBACK TO renew_contract_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

132: --first log the sqlerrm
133: l_error_text := substr (SQLERRM, 1, 240);
134: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
135: --then add it to the message api list
136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
137: END IF;
138: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
139:
140: END RENEW_CONTRACT;

Line 138: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

134: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
135: --then add it to the message api list
136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
137: END IF;
138: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
139:
140: END RENEW_CONTRACT;
141:
142:

Line 183: FND_MSG_PUB.initialize;

179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: IF FND_API.to_boolean(p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: OKS_RENEW_CONTRACT_PVT.validate_renewal(

Line 210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

206:
207: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
208: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
209: END IF;
210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
211:
212: EXCEPTION
213: WHEN FND_API.g_exc_error THEN
214: x_return_status := FND_API.g_ret_sts_error ;

Line 219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

215:
216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
218: END IF;
219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
220:
221: WHEN FND_API.g_exc_unexpected_error THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:

Line 227: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

223:
224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
226: END IF;
227: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231:

Line 237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

233: --first log the sqlerrm
234: l_error_text := substr (SQLERRM, 1, 240);
235: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
236: --then add it to the message api list
237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
238: END IF;
239: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
240:
241: END VALIDATE_RENEWAL;

Line 239: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

235: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
236: --then add it to the message api list
237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
238: END IF;
239: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
240:
241: END VALIDATE_RENEWAL;
242:
243: /*

Line 315: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

311: --first log the sqlerrm
312: l_error_text := substr (SQLERRM, 1, 240);
313: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
314: --then add it to the message api list
315: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
316: END IF;
317:
318: l_return_value := FND_API.G_FALSE; --F
319: RETURN l_return_value;

Line 359: FND_MSG_PUB.initialize;

355: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: IF FND_API.to_boolean(p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;
360: END IF;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: OKS_RENEW_CONTRACT_PVT.update_invoice_text(

Line 386: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

382:
383: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
384: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
385: END IF;
386: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
387:
388: EXCEPTION
389: WHEN FND_API.g_exc_error THEN
390: ROLLBACK TO update_invoice_text_PUB;

Line 396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

392:
393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
395: END IF;
396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
397:
398: WHEN FND_API.g_exc_unexpected_error THEN
399: ROLLBACK TO update_invoice_text_PUB;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 405: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

401:
402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
403: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
404: END IF;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
406:
407: WHEN OTHERS THEN
408: ROLLBACK TO update_invoice_text_PUB;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 416: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

412: --first log the sqlerrm
413: l_error_text := substr (SQLERRM, 1, 240);
414: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
415: --then add it to the message api list
416: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
417: END IF;
418: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
419:
420: END UPDATE_INVOICE_TEXT;

Line 418: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

414: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
415: --then add it to the message api list
416: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
417: END IF;
418: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
419:
420: END UPDATE_INVOICE_TEXT;
421:
422: /*

Line 463: FND_MSG_PUB.initialize;

459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: IF FND_API.to_boolean(p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: OKS_RENEW_CONTRACT_PVT.get_user_name(

Line 487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

483:
484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
485: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);
486: END IF;
487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
488:
489: EXCEPTION
490: WHEN FND_API.g_exc_error THEN
491: x_return_status := FND_API.g_ret_sts_error ;

Line 496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

492:
493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
495: END IF;
496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500:

Line 504: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

500:
501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
503: END IF;
504: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508:

Line 514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

510: --first log the sqlerrm
511: l_error_text := substr (SQLERRM, 1, 240);
512: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
513: --then add it to the message api list
514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
515: END IF;
516: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
517:
518: END GET_USER_NAME;

Line 516: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

512: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
513: --then add it to the message api list
514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
515: END IF;
516: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
517:
518: END GET_USER_NAME;
519:
520: END OKS_RENEW_CONTRACT_PUB;