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 FND_API

Line 185: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
188:
189: IF NOT FND_API.compatible_api_call(l_api_version,

Line 189: IF NOT FND_API.compatible_api_call(l_api_version,

185: IF FND_API.to_boolean(p_init_msg_list) THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: IF NOT FND_API.compatible_api_call(l_api_version,
190: p_api_version,
191: l_api_name,
192: g_pkg_name)
193: THEN

Line 194: RAISE FND_API.g_exc_unexpected_error;

190: p_api_version,
191: l_api_name,
192: g_pkg_name)
193: THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:
197: x_return_status := FND_API.g_ret_sts_success;
198:

Line 197: x_return_status := FND_API.g_ret_sts_success;

193: THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:
197: x_return_status := FND_API.g_ret_sts_success;
198:
199: FOR l_pbh_line IN c_pbh_lines LOOP
200: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'N') LOOP
201: l_stmt_temp := NULL;

Line 274: x_return_status := FND_API.g_ret_sts_unexp_error;

270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: ROLLBACK TO denorm_vo_products;
274: x_return_status := FND_API.g_ret_sts_unexp_error;
275:
276: FND_MESSAGE.set_name('OZF', 'OZF_VO_PROD_STMT_FAILED');
277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
278: FND_MSG_PUB.add;

Line 291: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

287: THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290:
291: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
292: p_count => x_msg_count,
293: p_data => x_msg_data);
294: END denorm_vo_products;
295:

Line 325: x_return_status := Fnd_Api.g_ret_sts_success;

321: DELETE FROM ozf_vo_products_temp;
322:
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;

Line 332: IF NOT FND_API.compatible_api_call(l_api_version,

328:
329: -- ERRBUF := NULL;
330: -- RETCODE := '0';
331:
332: IF NOT FND_API.compatible_api_call(l_api_version,
333: l_api_version,
334: l_api_name,
335: g_pkg_name)
336: THEN

Line 337: RAISE FND_API.g_exc_unexpected_error;

333: l_api_version,
334: l_api_name,
335: g_pkg_name)
336: THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

Line 351: p_init_msg_list => FND_API.g_true,

347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */
350: denorm_vo_products(p_api_version => l_api_version,
351: p_init_msg_list => FND_API.g_true,
352: p_commit => FND_API.g_false,
353: p_offer_id => p_offer_id,
354: x_return_status => x_return_status,
355: x_msg_count => x_msg_count,

Line 352: p_commit => FND_API.g_false,

348: FND_DSQL.add_text(' FROM (');
349: */
350: denorm_vo_products(p_api_version => l_api_version,
351: p_init_msg_list => FND_API.g_true,
352: p_commit => FND_API.g_false,
353: p_offer_id => p_offer_id,
354: x_return_status => x_return_status,
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,

Line 372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 373: RAISE FND_API.g_exc_unexpected_error;

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:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
377: FND_DSQL.do_binds;

Line 390: RAISE FND_API.g_exc_error;

386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
387: FND_MESSAGE.set_name('OZF', 'OZF_DUP_PROD_FOUND');
388: FND_MSG_PUB.add;
389: END IF;
390: RAISE FND_API.g_exc_error;
391: END IF;
392:
393: EXCEPTION
394: /* WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 394: /* WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390: RAISE FND_API.g_exc_error;
391: END IF;
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 ;

Line 398: x_return_status := FND_API.g_ret_sts_unexp_error ;

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:
402: WHEN OTHERS THEN

Line 406: x_return_status := FND_API.g_ret_sts_unexp_error ;

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: */
410: WHEN FND_API.G_EXC_ERROR THEN

Line 410: WHEN FND_API.G_EXC_ERROR THEN

406: x_return_status := FND_API.g_ret_sts_unexp_error ;
407: ERRBUF := SQLERRM || ' - ' || l_stmt_denorm;
408: RETCODE := sqlcode;
409: */
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO check_dup_prod;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: RETCODE := sqlcode;
409: */
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO check_dup_prod;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);

Line 414: p_encoded => FND_API.g_false

410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO check_dup_prod;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

414: p_encoded => FND_API.g_false
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO check_dup_prod;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

416: ,p_data => x_msg_data);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO check_dup_prod;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false
423: ,p_count => x_msg_count
424: ,p_data => x_msg_data);

Line 422: p_encoded => FND_API.g_false

418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO check_dup_prod;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false
423: ,p_count => x_msg_count
424: ,p_data => x_msg_data);
425:
426: WHEN OTHERS THEN

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

424: ,p_data => x_msg_data);
425:
426: WHEN OTHERS THEN
427: ROLLBACK TO check_dup_prod;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
431: END IF;
432: FND_MSG_PUB.count_and_get(

Line 433: p_encoded => FND_API.g_false

429: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
430: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
431: END IF;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false
434: ,p_count => x_msg_count
435: ,p_data => x_msg_data);
436: END check_dup_prod;
437: