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

Line 1068: --dbms_output.put_line('start:'||i);

1064: x_error_location := 0;
1065: IF p_pricing_attr_tbl.COUNT > 0 THEN
1066: FOR i IN p_pricing_attr_tbl.first..p_pricing_attr_tbl.last LOOP
1067: IF p_pricing_attr_tbl.EXISTS(i) THEN
1068: --dbms_output.put_line('start:'||i);
1069: l_pricing_attr_tbl(i).list_line_id := p_pricing_attr_tbl(i).list_line_id;
1070:
1071: l_pricing_attr_tbl(i).product_attribute := p_pricing_attr_tbl(i).product_attribute;
1072: l_pricing_attr_tbl(i).product_attribute_context := 'ITEM';

Line 1080: --dbms_output.put_line('end:'||i);

1076: l_pricing_attr_tbl(i).pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1077: END IF;
1078: l_pricing_attr_tbl(i).excluder_flag := 'Y';
1079: l_pricing_attr_tbl(i).operation := p_pricing_attr_tbl(i).operation;
1080: --dbms_output.put_line('end:'||i);
1081: END IF;
1082: END LOOP;
1083: END IF;
1084:

Line 1102: --dbms_output.put_line('done qp api:'||x_return_status);

1098: x_qualifiers_val_tbl => v_qualifiers_val_tbl,
1099: x_pricing_attr_tbl => v_pricing_attr_tbl,
1100: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1101: );
1102: --dbms_output.put_line('done qp api:'||x_return_status);
1103:
1104: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1105: IF v_pricing_attr_tbl.COUNT > 0 THEN
1106: FOR i IN v_pricing_attr_tbl.first..v_pricing_attr_tbl.last LOOP

Line 1117: --dbms_output.put_line('done qp api:'||x_return_status);

1113: END LOOP;
1114: END IF;
1115: END IF;
1116:
1117: --dbms_output.put_line('done qp api:'||x_return_status);
1118:
1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1120: add_message(x_msg_count);
1121: RAISE Fnd_Api.g_exc_error;

Line 1130: --dbms_output.put_line('done qp api:'||x_return_status);

1126:
1127: IF p_commit = Fnd_Api.g_true THEN
1128: COMMIT WORK;
1129: END IF;
1130: --dbms_output.put_line('done qp api:'||x_return_status);
1131: --dbms_output.put_line('done :');
1132: EXCEPTION
1133: WHEN Fnd_Api.G_EXC_ERROR THEN
1134: x_return_status := Fnd_Api.g_ret_sts_error ;

Line 1131: --dbms_output.put_line('done :');

1127: IF p_commit = Fnd_Api.g_true THEN
1128: COMMIT WORK;
1129: END IF;
1130: --dbms_output.put_line('done qp api:'||x_return_status);
1131: --dbms_output.put_line('done :');
1132: EXCEPTION
1133: WHEN Fnd_Api.G_EXC_ERROR THEN
1134: x_return_status := Fnd_Api.g_ret_sts_error ;
1135: ROLLBACK TO process_exlusions;

Line 1217: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));

1213: RAISE FND_API.G_EXC_ERROR;
1214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: END IF;
1217: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));
1218: IF nvl(l_pricing_attr_tbl.count,0) > 0 THEN
1219: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));
1220: processRegExclusions
1221: (

Line 1219: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));

1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: END IF;
1217: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));
1218: IF nvl(l_pricing_attr_tbl.count,0) > 0 THEN
1219: --dbms_output.put_line('Rltd Pricing attr count is :'||nvl(l_pricing_attr_tbl.count,0));
1220: processRegExclusions
1221: (
1222: p_init_msg_list => FND_API.G_FALSE
1223: ,p_api_version => 1.0

Line 4253: --dbms_output.put_line('calling qp procedure');

4249:
4250:
4251: BEGIN
4252: SAVEPOINT process_qp_list_header;
4253: --dbms_output.put_line('calling qp procedure');
4254:
4255: x_return_status := Fnd_Api.g_ret_sts_success;
4256:
4257:

Line 4388: --dbms_output.put_line('calling qp procedure');

4384: l_modifier_list_rec.global_flag := 'Y';
4385: l_modifier_list_rec.org_id := NULL;
4386: END IF;
4387:
4388: --dbms_output.put_line('calling qp procedure');
4389: Qp_Modifiers_Pub.process_modifiers(
4390: p_api_version_number => 1.0,
4391: p_init_msg_list => FND_API.G_FALSE,
4392: p_return_values => Fnd_Api.G_FALSE,

Line 4407: --dbms_output.put_line('Return status1 is :'||x_return_status);

4403: x_pricing_attr_tbl => v_pricing_attr_tbl,
4404: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
4405: );
4406:
4407: --dbms_output.put_line('Return status1 is :'||x_return_status);
4408: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4409: add_message(x_msg_count);
4410: RAISE Fnd_Api.g_exc_error;
4411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 5515: -- dbms_output.put_line('Adding to :'||nvl(v_modifiers_tbl.count,0) + i);

5511: END IF;
5512: IF nvl(v_modifiers_tbl.count,0) > 0 THEN
5513: FOR i in v_modifiers_tbl.first .. v_modifiers_tbl.last LOOP
5514: IF v_modifiers_tbl.exists(i) THEN
5515: -- dbms_output.put_line('Adding to :'||nvl(v_modifiers_tbl.count,0) + i);
5516: x_modifiers_tbl(nvl(x_modifiers_tbl.count,0) + i) := v_modifiers_tbl(i);
5517: END IF;
5518: END LOOP;
5519: END IF;

Line 7698: --dbms_output.put_line('table count is :'||l_modifier_line_tbl.count);

7694: END IF;
7695:
7696: END IF;
7697: END IF;
7698: --dbms_output.put_line('table count is :'||l_modifier_line_tbl.count);
7699: -- rssharma added flex field on 15-Apr-2003
7700: /* l_modifier_line_all_off_tbl(i).attribute1 := p_modifier_line_tbl(i).attribute1;
7701: l_modifier_line_all_off_tbl(i).attribute2 := p_modifier_line_tbl(i).attribute2;
7702: l_modifier_line_all_off_tbl(i).attribute3 := p_modifier_line_tbl(i).attribute3;

Line 7855: -- --dbms_output.put_line('i:'||i||' : Operation :'||p_modifier_line_tbl(i).operation);

7851: */
7852: FOR i IN p_modifier_line_tbl.first..p_modifier_line_tbl.last LOOP
7853: IF p_modifier_line_tbl.exists(i) THEN
7854: l_modifier_line_tbl(i) := p_modifier_line_tbl(i);
7855: -- --dbms_output.put_line('i:'||i||' : Operation :'||p_modifier_line_tbl(i).operation);
7856: IF ((p_modifier_line_tbl(i).operand IS NOT NULL AND p_modifier_line_tbl(i).operand <> FND_API.g_miss_num)
7857: AND (p_modifier_line_tbl(i).arithmetic_operator IS NOT NULL AND p_modifier_line_tbl(i).arithmetic_operator <> FND_API.g_miss_char))
7858: AND ((p_modifier_line_tbl(i).qd_operand IS NOT NULL AND p_modifier_line_tbl(i).qd_operand <> FND_API.g_miss_num)
7859: AND (p_modifier_line_tbl(i).qd_arithmetic_operator IS NOT NULL AND p_modifier_line_tbl(i).qd_arithmetic_operator <> FND_API.g_miss_char)) THEN

Line 7863: -- --dbms_output.put_line('All :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);

7859: AND (p_modifier_line_tbl(i).qd_arithmetic_operator IS NOT NULL AND p_modifier_line_tbl(i).qd_arithmetic_operator <> FND_API.g_miss_char)) THEN
7860: l_all_index := l_all_index + 1;
7861: l_modifier_line_tbl(i).list_line_id := v_modifier_all_off_tbl(l_all_index).list_line_id;
7862: l_modifier_line_tbl(i).qd_list_line_id := v_modifier_all_acc_tbl(l_all_index).list_line_id;
7863: -- --dbms_output.put_line('All :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);
7864: ELSIF ((p_modifier_line_tbl(i).operand IS NOT NULL AND p_modifier_line_tbl(i).operand <> FND_API.g_miss_num)
7865: AND (p_modifier_line_tbl(i).arithmetic_operator IS NOT NULL AND p_modifier_line_tbl(i).arithmetic_operator <> FND_API.g_miss_char))
7866: AND ((p_modifier_line_tbl(i).qd_operand IS NULL OR p_modifier_line_tbl(i).qd_operand = FND_API.g_miss_num)
7867: OR (p_modifier_line_tbl(i).qd_arithmetic_operator IS NULL OR p_modifier_line_tbl(i).qd_arithmetic_operator = FND_API.g_miss_char)) THEN

Line 7871: -- --dbms_output.put_line('Off :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);

7867: OR (p_modifier_line_tbl(i).qd_arithmetic_operator IS NULL OR p_modifier_line_tbl(i).qd_arithmetic_operator = FND_API.g_miss_char)) THEN
7868: l_off_index := l_off_index + 1;
7869: l_modifier_line_tbl(i).list_line_id := v_modifier_off_tbl(l_off_index).list_line_id;
7870: l_modifier_line_tbl(i).qd_list_line_id := null;
7871: -- --dbms_output.put_line('Off :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);
7872: ELSIF ((p_modifier_line_tbl(i).qd_operand IS NOT NULL AND p_modifier_line_tbl(i).qd_operand <> FND_API.g_miss_num)
7873: AND (p_modifier_line_tbl(i).qd_arithmetic_operator IS NOT NULL AND p_modifier_line_tbl(i).qd_arithmetic_operator <> FND_API.g_miss_char))
7874: AND ((p_modifier_line_tbl(i).operand IS NULL OR p_modifier_line_tbl(i).operand = FND_API.g_miss_num)
7875: OR (p_modifier_line_tbl(i).arithmetic_operator IS NULL OR p_modifier_line_tbl(i).arithmetic_operator = FND_API.g_miss_char)) THEN

Line 7879: -- --dbms_output.put_line('Acc :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);

7875: OR (p_modifier_line_tbl(i).arithmetic_operator IS NULL OR p_modifier_line_tbl(i).arithmetic_operator = FND_API.g_miss_char)) THEN
7876: l_acc_index := l_acc_index + 1;
7877: l_modifier_line_tbl(i).qd_list_line_id := v_modifier_acc_tbl(l_acc_index).list_line_id;
7878: l_modifier_line_tbl(i).list_line_id := null;
7879: -- --dbms_output.put_line('Acc :listlineId'||l_modifier_line_tbl(i).list_line_id || ' td id : '||l_modifier_line_tbl(i).qd_list_line_id);
7880: END IF;
7881: END IF;
7882: END LOOP;
7883: -- Call Related Deal Lines and establish the relation ship.

Line 8798: --dbms_output.put_line('calling qp procedure');

8794: AND act_budget_used_by_id = p_list_header_id;
8795: l_budget_req_count NUMBER := 0;
8796: BEGIN
8797: SAVEPOINT process_modifiers;
8798: --dbms_output.put_line('calling qp procedure');
8799: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
8800: Fnd_Msg_Pub.initialize;
8801: END IF;
8802:

Line 9026: --dbms_output.put_line('calling process qp_ list header');

9022: FND_MSG_PUB.add;
9023: RAISE FND_API.g_exc_error;
9024: END IF;
9025: END IF;
9026: --dbms_output.put_line('calling process qp_ list header');
9027: process_qp_list_header(
9028: p_api_version => 1.0,
9029: p_init_msg_list => p_init_msg_list,
9030: x_return_status => x_return_status,

Line 10555: --dbms_output.put_line('N get_grace_days '||p_sdr_header_id);

10551:
10552:
10553: BEGIN
10554:
10555: --dbms_output.put_line('N get_grace_days '||p_sdr_header_id);
10556:
10557: OPEN c_get_supplier_site_id( p_sdr_header_id ) ;
10558: FETCH c_get_supplier_site_id INTO l_supplier_site_id ;
10559: CLOSE c_get_supplier_site_id ;

Line 10562: --dbms_output.put_line('N supplier_site_id '||l_supplier_site_id);

10558: FETCH c_get_supplier_site_id INTO l_supplier_site_id ;
10559: CLOSE c_get_supplier_site_id ;
10560:
10561:
10562: --dbms_output.put_line('N supplier_site_id '||l_supplier_site_id);
10563:
10564: OPEN c_get_grace_days( l_supplier_site_id ) ;
10565: FETCH c_get_grace_days INTO p_grace_days ;
10566: CLOSE c_get_grace_days ;

Line 10570: --dbms_output.put_line('N grace_days '||p_grace_days);

10566: CLOSE c_get_grace_days ;
10567:
10568:
10569:
10570: --dbms_output.put_line('N grace_days '||p_grace_days);
10571:
10572: RETURN p_grace_days;
10573:
10574: EXCEPTION

Line 10834: --dbms_output.put_line('N: l_list_line_id' || l_list_line_id);

10830: debug_message('N: p_qp_list_header_id' || p_qp_list_header_id);
10831: OPEN cur_get_sys_line_ref_id(line_rec.request_line_id,p_qp_list_header_id);
10832: FETCH cur_get_sys_line_ref_id INTO l_orig_sys_line_ref_id,l_list_line_id;
10833: CLOSE cur_get_sys_line_ref_id;
10834: --dbms_output.put_line('N: l_list_line_id' || l_list_line_id);
10835:
10836: -- END IF;
10837:
10838: debug_message('N: l_orig_sys_line_ref_id' || l_orig_sys_line_ref_id);

Line 10859: --dbms_output.put_line('N: x_modifier_line_tbl(l_prod_index).LIST_HEADER_ID ' || x_modifier_line_tbl(l_prod_index).LIST_HEADER_ID);

10855: debug_message('N: line_rec.request_line_id ' || line_rec.request_line_id );
10856: x_modifier_line_tbl(l_prod_index).LIST_LINE_NO := to_char(line_rec.request_line_id);
10857: debug_message('N: x_modifier_line_tbl(l_prod_index).LIST_LINE_NO ' || x_modifier_line_tbl(l_prod_index).LIST_LINE_NO );
10858: x_modifier_line_tbl(l_prod_index).LIST_HEADER_ID := p_qp_list_header_id;
10859: --dbms_output.put_line('N: x_modifier_line_tbl(l_prod_index).LIST_HEADER_ID ' || x_modifier_line_tbl(l_prod_index).LIST_HEADER_ID);
10860: x_modifier_line_tbl(l_prod_index).LIST_LINE_TYPE_CODE := 'DIS';
10861: x_modifier_line_tbl(l_prod_index).OPERAND := NVL(line_rec.approved_discount_value, line_rec.requested_discount_value);
10862: x_modifier_line_tbl(l_prod_index).ARITHMETIC_OPERATOR := NVL(line_rec.approved_discount_type, line_rec.requested_discount_type);
10863:

Line 10913: --dbms_output.put_line('l_converted_amt '|| l_converted_amt);

10909: l_request_currency_code,
10910: l_supplier_site_id;
10911: CLOSE cur_get_header_info;
10912:
10913: --dbms_output.put_line('l_converted_amt '|| l_converted_amt);
10914:
10915:
10916: IF x_modifier_line_tbl(l_prod_index).ARITHMETIC_OPERATOR = 'AMT'
10917: AND NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency)

Line 11574: --dbms_output.put_line('Nirma 2 ' );

11570: END IF;
11571:
11572: END IF;
11573:
11574: --dbms_output.put_line('Nirma 2 ' );
11575:
11576:
11577:
11578:

Line 11654: --dbms_output.put_line('l_modifier_list_rec.user_status_id set operation as update' );

11650: CLOSE c_offer_info;
11651:
11652:
11653: IF l_modifier_list_rec.user_status_id IS NOT NULL AND l_modifier_list_rec.user_status_id <> fnd_api.g_miss_num THEN -- might have additional stage eg ACTIVE to go
11654: --dbms_output.put_line('l_modifier_list_rec.user_status_id set operation as update' );
11655: l_modifier_list_rec.offer_operation := 'UPDATE';
11656: l_modifier_list_rec.modifier_operation := 'UPDATE';
11657: l_modifier_list_rec.user_status_id := l_modifier_list_rec.user_status_id;
11658: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(l_modifier_list_rec.user_status_id);

Line 11662: --dbms_output.put_line('N: x_qp_list_header_id '||x_qp_list_header_id);

11658: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(l_modifier_list_rec.user_status_id);
11659: END IF;
11660:
11661: /*Create Qualifier Line Records*/
11662: --dbms_output.put_line('N: x_qp_list_header_id '||x_qp_list_header_id);
11663:
11664: IF x_qp_list_header_id IS NOT NULL THEN
11665: populateSDQualifiers(
11666: x_return_status => x_return_status

Line 11857: dbms_output.put_line('N: l_offer_access_rec.user_id '||l_offer_access_rec.user_id);

11853: debug_message('N: p_sdr_header_id '||p_sdr_header_id);
11854: debug_message('N: b4 adding access');
11855:
11856: FOR l_offer_access_rec IN c_offer_access(l_qp_list_header_id,p_sdr_header_id) LOOP
11857: dbms_output.put_line('N: l_offer_access_rec.user_id '||l_offer_access_rec.user_id);
11858: dbms_output.put_line('N: l_qp_list_header_id '||l_qp_list_header_id);
11859: l_access_exists := 0;
11860: OPEN c_access_exists (ozf_utility_pvt.get_resource_id(nvl(l_offer_access_rec.user_id,-1)),l_qp_list_header_id);
11861: FETCH c_access_exists INTO l_access_exists;

Line 11858: dbms_output.put_line('N: l_qp_list_header_id '||l_qp_list_header_id);

11854: debug_message('N: b4 adding access');
11855:
11856: FOR l_offer_access_rec IN c_offer_access(l_qp_list_header_id,p_sdr_header_id) LOOP
11857: dbms_output.put_line('N: l_offer_access_rec.user_id '||l_offer_access_rec.user_id);
11858: dbms_output.put_line('N: l_qp_list_header_id '||l_qp_list_header_id);
11859: l_access_exists := 0;
11860: OPEN c_access_exists (ozf_utility_pvt.get_resource_id(nvl(l_offer_access_rec.user_id,-1)),l_qp_list_header_id);
11861: FETCH c_access_exists INTO l_access_exists;
11862: CLOSE c_access_exists;