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_ORDER_PRICE_PVT dependencies on FND_API

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36:
37: l_msg_parameter_list WF_PARAMETER_LIST_T;
38:
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: IF OZF_DEBUG_HIGH_ON THEN
43: ozf_utility_PVT.debug_message('in build order header');
44: END IF;

Line 49: oe_order_pub.g_hdr.order_type_id = FND_API.g_miss_num THEN

45: -- Mapping, default and validation rules here
46: -- Since we can not use the OM defaulting rule. We just default order type based on the cust account id
47: /*
48: IF oe_order_pub.g_hdr.order_type_id is null or
49: oe_order_pub.g_hdr.order_type_id = FND_API.g_miss_num THEN
50:
51: OPEN order_type_csr(oe_order_pub.g_hdr.sold_to_org_id);
52: FETCH order_type_csr into oe_order_pub.g_hdr.order_type_id;
53: CLOSE order_type_csr;

Line 58: ,p_init_msg_list => FND_API.G_FALSE

54: END IF;
55:
56: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_Header(
57: p_api_version => 1.0
58: ,p_init_msg_list => FND_API.G_FALSE
59: ,p_commit => FND_API.G_FALSE
60: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
61: ,x_return_status => l_return_status
62: ,x_msg_data => l_msg_data

Line 59: ,p_commit => FND_API.G_FALSE

55:
56: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_Header(
57: p_api_version => 1.0
58: ,p_init_msg_list => FND_API.G_FALSE
59: ,p_commit => FND_API.G_FALSE
60: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
61: ,x_return_status => l_return_status
62: ,x_msg_data => l_msg_data
63: ,x_msg_count => l_msg_count

Line 60: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

56: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_Header(
57: p_api_version => 1.0
58: ,p_init_msg_list => FND_API.G_FALSE
59: ,p_commit => FND_API.G_FALSE
60: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
61: ,x_return_status => l_return_status
62: ,x_msg_data => l_msg_data
63: ,x_msg_count => l_msg_count
64: ,xp_hdr => oe_order_pub.g_hdr

Line 88: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

84: p_event_name => 'oracle.apps.ozf.idsm.OMGHDR',
85: p_event_key => p_hdr.resale_table_type||to_char(p_hdr.chargeback_int_id)||'_'||to_char(sysdate,'YYYYMMDD HH24MISS'),
86: p_parameters => l_msg_parameter_list
87: );
88: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 89: RAISE FND_API.g_exc_unexpected_error;

85: p_event_key => p_hdr.resale_table_type||to_char(p_hdr.chargeback_int_id)||'_'||to_char(sysdate,'YYYYMMDD HH24MISS'),
86: p_parameters => l_msg_parameter_list
87: );
88: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

88: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: END build_order_header;

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: END build_order_header;
97:

Line 95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: END build_order_header;
97:
98: ---------------------------------------------------------------------
99: -- PROCEDURE

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: l_msg_count number;
118: l_return_status varchar2(30);
119: l_msg_parameter_list WF_PARAMETER_LIST_T;
120: BEGIN
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: IF OZF_DEBUG_HIGH_ON THEN
124: ozf_utility_PVT.debug_message('in build order line');
125: END IF;

Line 130: ,p_init_msg_list => FND_API.G_FALSE

126: -- Mapping, default and validation rules here
127: /*
128: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_line(
129: p_api_version => 1.0
130: ,p_init_msg_list => FND_API.G_FALSE
131: ,p_commit => FND_API.G_FALSE
132: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
133: ,x_return_status => l_return_status
134: ,x_msg_data => l_msg_data

Line 131: ,p_commit => FND_API.G_FALSE

127: /*
128: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_line(
129: p_api_version => 1.0
130: ,p_init_msg_list => FND_API.G_FALSE
131: ,p_commit => FND_API.G_FALSE
132: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
133: ,x_return_status => l_return_status
134: ,x_msg_data => l_msg_data
135: ,x_msg_count => l_msg_count

Line 132: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

128: OZF_CHARGEBACK_ATTRMAP_PUB.Create_Global_line(
129: p_api_version => 1.0
130: ,p_init_msg_list => FND_API.G_FALSE
131: ,p_commit => FND_API.G_FALSE
132: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
133: ,x_return_status => l_return_status
134: ,x_msg_data => l_msg_data
135: ,x_msg_count => l_msg_count
136: ,xp_line => oe_order_pub.g_line

Line 159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

155: p_event_name => 'oracle.apps.ozf.idsm.OMGLINE',
156: p_event_key => p_line.resale_table_type||to_char(p_line.chargeback_int_id)||'_'||to_char(sysdate,'YYYYMMDD HH24MISS'),
157: p_parameters => l_msg_parameter_list
158: );
159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 160: RAISE FND_API.g_exc_unexpected_error;

156: p_event_key => p_line.resale_table_type||to_char(p_line.chargeback_int_id)||'_'||to_char(sysdate,'YYYYMMDD HH24MISS'),
157: p_parameters => l_msg_parameter_list
158: );
159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: WHEN OTHERS THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: END build_order_line;

Line 164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: WHEN OTHERS THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: END build_order_line;
168:

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: WHEN OTHERS THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: END build_order_line;
168:
169: ---------------------------------------------------------------------
170: -- PROCEDURE

Line 184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

180: ---------------------------------------------------------------------
181: PROCEDURE Get_Order_Price
182: (
183: p_api_version IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
187:
188: ,x_return_status OUT NOCOPY VARCHAR2

Line 185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

181: PROCEDURE Get_Order_Price
182: (
183: p_api_version IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
187:
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_data OUT NOCOPY VARCHAR2

Line 186: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

182: (
183: p_api_version IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
187:
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_data OUT NOCOPY VARCHAR2
190: ,x_msg_count OUT NOCOPY NUMBER

Line 277: IF NOT FND_API.Compatible_API_Call (

273: BEGIN
274: -- Standard begin of API savepoint
275: SAVEPOINT Get_Order_Price_pvt;
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call (
278: l_api_version,
279: p_api_version,
280: l_api_name,
281: G_PKG_NAME)

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: p_api_version,
280: l_api_name,
281: G_PKG_NAME)
282: THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: -- Debug Message
287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 294: IF FND_API.To_Boolean (p_init_msg_list) THEN

290: FND_MSG_PUB.Add;
291: END IF;
292:
293: --Initialize message list if p_init_msg_list is TRUE.
294: IF FND_API.To_Boolean (p_init_msg_list) THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Initialize API return status to sucess

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Initialize API return status to sucess
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: IF OZF_DEBUG_HIGH_ON THEN
302: ozf_utility_PVT.debug_message('in get_order_price' );
303: END IF;

Line 354: RAISE FND_API.G_EXC_ERROR;

350: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
351: FND_MESSAGE.set_name('OZF', 'OZF_ORD_LN_INDX_MISS');
352: FND_MSG_PUB.add;
353: END IF;
354: RAISE FND_API.G_EXC_ERROR;
355: ELSE
356: G_LINE_INDEX_TBL(I):=xp_line_tbl(I).line_index;
357: END IF;
358:

Line 364: RAISE FND_API.G_EXC_ERROR;

360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
361: FND_MESSAGE.set_name('OZF', 'OZF_ORD_LN_TYPCODE_MISS');
362: FND_MSG_PUB.add;
363: END IF;
364: RAISE FND_API.G_EXC_ERROR;
365: ELSE
366: G_LINE_TYPE_CODE_TBL(I):= xp_line_tbl(I).line_type_code;
367: END IF;
368:

Line 374: RAISE FND_API.G_EXC_ERROR;

370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
371: FND_MESSAGE.set_name('OZF', 'OZF_ORD_EFF_DATE_MISS');
372: FND_MSG_PUB.add;
373: END IF;
374: RAISE FND_API.G_EXC_ERROR;
375: ELSE
376: G_PRICING_EFFECTIVE_DATE_TBL(I):=xp_line_tbl(I).PRICING_EFFECTIVE_DATE;
377: END IF;
378:

Line 411: RAISE FND_API.G_EXC_ERROR;

407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
408: FND_MESSAGE.set_name('OZF', 'OZF_ORD_REQ_TYPCD_MISS');
409: FND_MSG_PUB.add;
410: END IF;
411: RAISE FND_API.G_EXC_ERROR;
412: ELSE
413: G_REQUEST_TYPE_CODE_TBL(I):= xp_line_tbl(I).REQUEST_TYPE_CODE;
414: END IF;
415:

Line 452: IF xp_line_tbl(I).LINE_CATEGORY = FND_API.G_MISS_CHAR THEN

448: G_PRICE_REQUEST_CODE_TBL(I):= xp_line_tbl(I).PRICE_REQUEST_CODE;
449: G_USAGE_PRICING_TYPE_tbl(I):= xp_line_tbl(I).USAGE_PRICING_TYPE;
450:
451: /*
452: IF xp_line_tbl(I).LINE_CATEGORY = FND_API.G_MISS_CHAR THEN
453: G_LINE_CATEGORY_tbl(I):= null;
454: END IF;
455:
456: -- We don't have to fill these columns

Line 469: IF l_return_status = FND_API.g_ret_sts_error THEN

465: END IF;
466: oe_order_pub.g_hdr := g_header_rec;
467: build_order_header( p_hdr => xp_line_tbl(I),
468: x_return_status => l_return_status);
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;

Line 470: RAISE FND_API.g_exc_error;

466: oe_order_pub.g_hdr := g_header_rec;
467: build_order_header( p_hdr => xp_line_tbl(I),
468: x_return_status => l_return_status);
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474:

Line 471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

467: build_order_header( p_hdr => xp_line_tbl(I),
468: x_return_status => l_return_status);
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474:
475: QP_Attr_Mapping_PUB.Build_Contexts(

Line 472: RAISE FND_API.g_exc_unexpected_error;

468: x_return_status => l_return_status);
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474:
475: QP_Attr_Mapping_PUB.Build_Contexts(
476: p_request_type_code => 'ONT',

Line 492: IF l_return_status = FND_API.g_ret_sts_error THEN

488: oe_order_pub.g_hdr := g_header_rec; -- Fix for Bug 12760472
489: oe_order_pub.g_line := g_line_rec_tbl(I);
490: build_order_line( p_line => xp_line_tbl(I),
491: x_return_status => l_return_status);
492: IF l_return_status = FND_API.g_ret_sts_error THEN
493: RAISE FND_API.g_exc_error;
494: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
495: RAISE FND_API.g_exc_unexpected_error;
496: END IF;

Line 493: RAISE FND_API.g_exc_error;

489: oe_order_pub.g_line := g_line_rec_tbl(I);
490: build_order_line( p_line => xp_line_tbl(I),
491: x_return_status => l_return_status);
492: IF l_return_status = FND_API.g_ret_sts_error THEN
493: RAISE FND_API.g_exc_error;
494: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
495: RAISE FND_API.g_exc_unexpected_error;
496: END IF;
497: QP_Attr_Mapping_PUB.Build_Contexts(

Line 494: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

490: build_order_line( p_line => xp_line_tbl(I),
491: x_return_status => l_return_status);
492: IF l_return_status = FND_API.g_ret_sts_error THEN
493: RAISE FND_API.g_exc_error;
494: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
495: RAISE FND_API.g_exc_unexpected_error;
496: END IF;
497: QP_Attr_Mapping_PUB.Build_Contexts(
498: p_request_type_code => 'ONT',

Line 495: RAISE FND_API.g_exc_unexpected_error;

491: x_return_status => l_return_status);
492: IF l_return_status = FND_API.g_ret_sts_error THEN
493: RAISE FND_API.g_exc_error;
494: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
495: RAISE FND_API.g_exc_unexpected_error;
496: END IF;
497: QP_Attr_Mapping_PUB.Build_Contexts(
498: p_request_type_code => 'ONT',
499: p_line_index => xp_line_tbl(I).line_index,

Line 511: RAISE FND_API.G_EXC_ERROR;

507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
508: FND_MESSAGE.set_name('OZF', 'OZF_ORD_LINE_TYPE_WRG');
509: FND_MSG_PUB.add;
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: ozf_utility_pvt.write_conc_log('kd: xp_line_tbl(I).chargeback_int_id- ' || xp_line_tbl(I).chargeback_int_id);
514: End LOOP;
515:

Line 559: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN

555: -- p_line_category =>G_LINE_CATEGORY_tbl,
556: x_status_code =>l_return_status_code,
557: x_status_text =>l_price_return_msg);
558:
559: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN
560: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
561: FND_MESSAGE.set_name('OZF', 'OZF_ORDER_INSERT_ERR');
562: FND_MSG_PUB.add;
563: IF OZF_DEBUG_LOW_ON THEN

Line 567: RAISE FND_API.G_EXC_ERROR;

563: IF OZF_DEBUG_LOW_ON THEN
564: ozf_utility_PVT.debug_message(l_price_return_msg);
565: END IF;
566: END IF;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: IF OZF_DEBUG_LOW_ON THEN
570: ozf_utility_PVT.debug_message('After insert lines2' );
571: END IF;

Line 581: IF l_return_status = FND_API.g_ret_sts_error THEN

577: (p_control_rec => l_control_rec,
578: x_return_status => l_return_status,
579: x_return_status_text => l_msg_data);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: IF OZF_DEBUG_LOW_ON THEN
583: ozf_utility_PVT.debug_message('in error'||l_msg_data);
584: END IF;
585: RAISE FND_API.g_exc_error;

Line 585: RAISE FND_API.g_exc_error;

581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: IF OZF_DEBUG_LOW_ON THEN
583: ozf_utility_PVT.debug_message('in error'||l_msg_data);
584: END IF;
585: RAISE FND_API.g_exc_error;
586: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
587: IF OZF_DEBUG_LOW_ON THEN
588: ozf_utility_PVT.debug_message('in un'||l_msg_data);
589: END IF;

Line 586: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

582: IF OZF_DEBUG_LOW_ON THEN
583: ozf_utility_PVT.debug_message('in error'||l_msg_data);
584: END IF;
585: RAISE FND_API.g_exc_error;
586: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
587: IF OZF_DEBUG_LOW_ON THEN
588: ozf_utility_PVT.debug_message('in un'||l_msg_data);
589: END IF;
590: RAISE FND_API.g_exc_unexpected_error;

Line 590: RAISE FND_API.g_exc_unexpected_error;

586: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
587: IF OZF_DEBUG_LOW_ON THEN
588: ozf_utility_PVT.debug_message('in un'||l_msg_data);
589: END IF;
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592: IF OZF_DEBUG_LOW_ON THEN
593: ozf_utility_PVT.debug_message('After price_request' );
594: END IF;

Line 664: p_encoded => FND_API.G_FALSE,

660: FND_MSG_PUB.Add;
661: END IF;
662: --Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );
668: IF OZF_DEBUG_HIGH_ON THEN

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: IF OZF_DEBUG_HIGH_ON THEN
669: ozf_utility_PVT.debug_message('end of order price');
670: END IF;
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO Get_Order_Price_pvt ;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: END IF;
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO Get_Order_Price_pvt ;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,

Line 677: p_encoded => FND_API.G_FALSE,

673: ROLLBACK TO Get_Order_Price_pvt ;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO Get_Order_Price_pvt;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

679: p_data => x_msg_data
680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO Get_Order_Price_pvt;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,

Line 686: p_encoded => FND_API.G_FALSE,

682: ROLLBACK TO Get_Order_Price_pvt;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );
690: WHEN OTHERS THEN

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

688: p_data => x_msg_data
689: );
690: WHEN OTHERS THEN
691: ROLLBACK TO Get_Order_Price_pvt;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: -- Standard call to get message count and if count=1, get the message
694: FND_MSG_PUB.Count_And_Get (
695: p_encoded => FND_API.G_FALSE,
696: p_count => x_msg_count,

Line 695: p_encoded => FND_API.G_FALSE,

691: ROLLBACK TO Get_Order_Price_pvt;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: -- Standard call to get message count and if count=1, get the message
694: FND_MSG_PUB.Count_And_Get (
695: p_encoded => FND_API.G_FALSE,
696: p_count => x_msg_count,
697: p_data => x_msg_data
698: );
699: END Get_Order_Price;

Line 715: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

711: --
712: ---------------------------------------------------------------------
713: PROCEDURE Purge_Pricing_Temp_table (
714: p_api_version IN NUMBER
715: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
716: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
717: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: ,x_return_status OUT NOCOPY VARCHAR2
719: ,x_msg_data OUT NOCOPY VARCHAR2

Line 716: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

712: ---------------------------------------------------------------------
713: PROCEDURE Purge_Pricing_Temp_table (
714: p_api_version IN NUMBER
715: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
716: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
717: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: ,x_return_status OUT NOCOPY VARCHAR2
719: ,x_msg_data OUT NOCOPY VARCHAR2
720: ,x_msg_count OUT NOCOPY NUMBER

Line 717: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

713: PROCEDURE Purge_Pricing_Temp_table (
714: p_api_version IN NUMBER
715: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
716: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
717: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: ,x_return_status OUT NOCOPY VARCHAR2
719: ,x_msg_data OUT NOCOPY VARCHAR2
720: ,x_msg_count OUT NOCOPY NUMBER
721: ) is

Line 730: IF NOT FND_API.Compatible_API_Call (

726:
727: SAVEPOINT PURGE_PRICING_TEMP;
728:
729: -- Standard call to check for call compatibility.
730: IF NOT FND_API.Compatible_API_Call (
731: l_api_version,
732: p_api_version,
733: l_api_name,
734: G_PKG_NAME)

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: p_api_version,
733: l_api_name,
734: G_PKG_NAME)
735: THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738: -- Debug Message
739: IF OZF_DEBUG_LOW_ON THEN
740: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 746: IF FND_API.To_Boolean (p_init_msg_list) THEN

742: FND_MSG_PUB.Add;
743: END IF;
744:
745: --Initialize message list if p_init_msg_list is TRUE.
746: IF FND_API.To_Boolean (p_init_msg_list) THEN
747: FND_MSG_PUB.initialize;
748: END IF;
749:
750: -- Initialize API return status to sucess

Line 751: x_return_status := FND_API.G_RET_STS_SUCCESS;

747: FND_MSG_PUB.initialize;
748: END IF;
749:
750: -- Initialize API return status to sucess
751: x_return_status := FND_API.G_RET_STS_SUCCESS;
752:
753: -- Debug Message
754: IF OZF_DEBUG_LOW_ON THEN
755: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 761: WHEN FND_API.G_EXC_ERROR THEN

757: FND_MSG_PUB.Add;
758: END IF;
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO PURGE_PRICING_TEMP;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO PURGE_PRICING_TEMP;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,

Line 766: p_encoded => FND_API.G_FALSE,

762: ROLLBACK TO PURGE_PRICING_TEMP;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: ROLLBACK TO PURGE_PRICING_TEMP;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: p_data => x_msg_data
769: );
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: ROLLBACK TO PURGE_PRICING_TEMP;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,

Line 775: p_encoded => FND_API.G_FALSE,

771: ROLLBACK TO PURGE_PRICING_TEMP;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,
777: p_data => x_msg_data
778: );
779: WHEN OTHERS THEN

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: p_data => x_msg_data
778: );
779: WHEN OTHERS THEN
780: ROLLBACK TO PURGE_PRICING_TEMP;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_MSG_PUB.Count_And_Get (
784: p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,

Line 784: p_encoded => FND_API.G_FALSE,

780: ROLLBACK TO PURGE_PRICING_TEMP;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_MSG_PUB.Count_And_Get (
784: p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
788: END Purge_Pricing_Temp_table;