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_ADJUSTMENT_EXT_PVT dependencies on DBMS_OUTPUT

Line 3830: dbms_output.put_line(l_price_return_msg);

3826: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN
3827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3828: FND_MESSAGE.set_name('OZF', 'OZF_ORDER_INSERT_ERR');
3829: FND_MSG_PUB.add;
3830: dbms_output.put_line(l_price_return_msg);
3831: END IF;
3832: RAISE FND_API.G_EXC_ERROR;
3833: END IF;
3834:

Line 6744: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - BEGIN 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);

6740: || x_msg_count
6741: || 'Return Status'
6742: || l_return_status
6743: );
6744: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - BEGIN 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
6745: /* FOR_DEBUGGING
6746: -- IF l_return_status <> 'S' THEN
6747: IF(x_msg_count > 0)THEN
6748: FOR I IN 1 .. x_msg_count LOOP

Line 6755: DBMS_OUTPUT.put_line('****(PA):'||x_msg_data);

6751: p_encoded => FND_API.G_FALSE,
6752: p_data => x_msg_data,
6753: p_msg_index_out => l_index);
6754: --ozf_utility_pvt.write_conc_log(l_full_name||' : '||i||x_msg_data);
6755: DBMS_OUTPUT.put_line('****(PA):'||x_msg_data);
6756: END LOOP;
6757: fnd_msg_pub.initialize;
6758: END IF;
6759: -- END IF;

Line 6761: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);

6757: fnd_msg_pub.initialize;
6758: END IF;
6759: -- END IF;
6760: END FOR_DEBUGGING */
6761: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
6762:
6763: IF l_return_status = fnd_api.g_ret_sts_error THEN
6764: RAISE fnd_api.g_exc_error;
6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 6849: ----DBMS_output.put_line ( 'In Process Product' || p_offer_adjustment_id);

6845: write_conc_log ( l_full_name
6846: || ' : '
6847: || 'In Process Product '
6848: || p_offer_adjustment_id);
6849: ----DBMS_output.put_line ( 'In Process Product' || p_offer_adjustment_id);
6850: -- Get all product qualifiers for 'FUND'
6851: FOR product_rec IN c_off_adj_lines
6852: LOOP
6853:

Line 6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);

6858: FND_DSQL.add_text(' FROM ( ');
6859:
6860: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
6861: -- with all items but insert -1 instead
6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');

Line 6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);

6859:
6860: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
6861: -- with all items but insert -1 instead
6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');

Line 6867: ----DBMS_output.put_line (' IN ALL products ');

6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');
6868: ELSE
6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
6870: p_context=> 'ITEM',
6871: p_attribute=> product_rec.product_attribute,

Line 6884: ----DBMS_output.put_line ( 'get sql returns' || l_temp_sql);

6880: write_conc_log ( l_full_name
6881: || ' : '
6882: || 'Get Sql Returns'
6883: || l_temp_sql);
6884: ----DBMS_output.put_line ( 'get sql returns' || l_temp_sql);
6885: /*
6886: l_adjustment_product_sql := 'INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) '
6887: || '(SELECT ''FUND'', ''N'', product_id,'
6888: || product_rec.offer_adjustment_line_id

Line 6902: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);

6898: write_conc_log ( l_full_name
6899: || ' : '
6900: || 'Insert Sql'
6901: || l_stmt_denorm);
6902: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);
6903: --EXECUTE IMMEDIATE l_adjustment_product_sql;
6904: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
6905: FND_DSQL.do_binds;
6906: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 7199: --dbms_output.put_line(' cal Status '||x_return_status);

7195: p_product_item_id => l_adj_info.product_id,
7196: x_fund_amt_tbl=> l_fund_amt_tbl
7197: );
7198:
7199: --dbms_output.put_line(' cal Status '||x_return_status);
7200: write_conc_log(l_full_name ||'Calculate Accrual Amt Return Status ' ||x_return_status);
7201: IF G_DEBUG THEN
7202: ozf_utility_pvt.debug_message (l_full_name ||'Return Status' ||x_return_status);
7203: END IF;

Line 7216: --dbms_output.put_line(' In error ');

7212: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
7213: fnd_message.set_token ('OFFER_NAME', l_off_name);
7214: fnd_msg_pub.ADD;
7215: END IF;
7216: --dbms_output.put_line(' In error ');
7217: IF x_return_status = fnd_api.g_ret_sts_error THEN
7218: RAISE fnd_api.g_exc_error;
7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7220: RAISE fnd_api.g_exc_unexpected_error;