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.OZF_CHECK_DUP_PROD_PVT dependencies on OZF_UTILITY_PVT

Line 183: ozf_utility_pvt.debug_message(l_full_name || ': start denorm_vo_products');

179: l_stmt_denorm VARCHAR2(32000) := NULL;
180:
181: BEGIN
182: SAVEPOINT denorm_vo_products;
183: ozf_utility_pvt.debug_message(l_full_name || ': start denorm_vo_products');
184:
185: IF FND_API.to_boolean(p_init_msg_list) THEN
186: FND_MSG_PUB.initialize;
187: END IF;

Line 281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));

277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
278: FND_MSG_PUB.add;
279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:

Line 282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));

278: FND_MSG_PUB.add;
279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));

279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
287: THEN

Line 284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));

280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
285:
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
287: THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 327: ozf_utility_pvt.debug_message(l_full_name || ': Start check_dup_prod' || p_offer_id);

323: SAVEPOINT check_dup_prod;
324:
325: x_return_status := Fnd_Api.g_ret_sts_success;
326:
327: ozf_utility_pvt.debug_message(l_full_name || ': Start check_dup_prod' || p_offer_id);
328:
329: -- ERRBUF := NULL;
330: -- RETCODE := '0';
331:

Line 361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);

357: x_product_stmt => l_stmt_product);
358: /*
359: FND_DSQL.add_text(')');
360:
361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);
362:
363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);

Line 366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');

362:
363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));

Line 367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));

363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');

Line 368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));

364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));

365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;

Line 370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));

366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: END IF;

Line 371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');

367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
370: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));
371: ozf_utility_pvt.debug_message ('end STMT--------------------------------------------');
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: END IF;
375:

Line 396: ozf_utility_pvt.debug_message('Unexpected Error: ' || SQLERRM);

392:
393: EXCEPTION
394: /* WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO check_dup_prod;
396: ozf_utility_pvt.debug_message('Unexpected Error: ' || SQLERRM);
397: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);
398: x_return_status := FND_API.g_ret_sts_unexp_error ;
399: ERRBUF := l_msg_data;
400: RETCODE := 2;

Line 397: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);

393: EXCEPTION
394: /* WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO check_dup_prod;
396: ozf_utility_pvt.debug_message('Unexpected Error: ' || SQLERRM);
397: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);
398: x_return_status := FND_API.g_ret_sts_unexp_error ;
399: ERRBUF := l_msg_data;
400: RETCODE := 2;
401:

Line 404: ozf_utility_pvt.debug_message('Other Error: ' || SQLERRM);

400: RETCODE := 2;
401:
402: WHEN OTHERS THEN
403: ROLLBACK TO check_dup_prod;
404: ozf_utility_pvt.debug_message('Other Error: ' || SQLERRM);
405: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);
406: x_return_status := FND_API.g_ret_sts_unexp_error ;
407: ERRBUF := SQLERRM || ' - ' || l_stmt_denorm;
408: RETCODE := sqlcode;

Line 405: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);

401:
402: WHEN OTHERS THEN
403: ROLLBACK TO check_dup_prod;
404: ozf_utility_pvt.debug_message('Other Error: ' || SQLERRM);
405: ozf_utility_pvt.debug_message('Denorm STMT: ' || l_stmt_denorm);
406: x_return_status := FND_API.g_ret_sts_unexp_error ;
407: ERRBUF := SQLERRM || ' - ' || l_stmt_denorm;
408: RETCODE := sqlcode;
409: */