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 351: RAISE FND_API.G_EXC_ERROR;

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

Line 361: RAISE FND_API.G_EXC_ERROR;

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

Line 371: RAISE FND_API.G_EXC_ERROR;

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

Line 408: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 466: IF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 467: RAISE FND_API.g_exc_error;

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

Line 468: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 469: RAISE FND_API.g_exc_unexpected_error;

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

Line 488: IF l_return_status = FND_API.g_ret_sts_error THEN

484: END IF;
485: oe_order_pub.g_line := g_line_rec_tbl(I);
486: build_order_line( p_line => xp_line_tbl(I),
487: x_return_status => l_return_status);
488: IF l_return_status = FND_API.g_ret_sts_error THEN
489: RAISE FND_API.g_exc_error;
490: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
491: RAISE FND_API.g_exc_unexpected_error;
492: END IF;

Line 489: RAISE FND_API.g_exc_error;

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

Line 490: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 491: RAISE FND_API.g_exc_unexpected_error;

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

Line 507: RAISE FND_API.G_EXC_ERROR;

503: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
504: FND_MESSAGE.set_name('OZF', 'OZF_ORD_LINE_TYPE_WRG');
505: FND_MSG_PUB.add;
506: END IF;
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509: End LOOP;
510:
511: IF OZF_DEBUG_LOW_ON THEN

Line 554: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN

550: -- p_line_category =>G_LINE_CATEGORY_tbl,
551: x_status_code =>l_return_status_code,
552: x_status_text =>l_price_return_msg);
553:
554: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN
555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
556: FND_MESSAGE.set_name('OZF', 'OZF_ORDER_INSERT_ERR');
557: FND_MSG_PUB.add;
558: IF OZF_DEBUG_LOW_ON THEN

Line 562: RAISE FND_API.G_EXC_ERROR;

558: IF OZF_DEBUG_LOW_ON THEN
559: ozf_utility_PVT.debug_message(l_price_return_msg);
560: END IF;
561: END IF;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: IF OZF_DEBUG_LOW_ON THEN
565: ozf_utility_PVT.debug_message('After insert lines2' );
566: END IF;

Line 576: IF l_return_status = FND_API.g_ret_sts_error THEN

572: (p_control_rec => l_control_rec,
573: x_return_status => l_return_status,
574: x_return_status_text => l_msg_data);
575:
576: IF l_return_status = FND_API.g_ret_sts_error THEN
577: IF OZF_DEBUG_LOW_ON THEN
578: ozf_utility_PVT.debug_message('in error'||l_msg_data);
579: END IF;
580: RAISE FND_API.g_exc_error;

Line 580: RAISE FND_API.g_exc_error;

576: IF l_return_status = FND_API.g_ret_sts_error THEN
577: IF OZF_DEBUG_LOW_ON THEN
578: ozf_utility_PVT.debug_message('in error'||l_msg_data);
579: END IF;
580: RAISE FND_API.g_exc_error;
581: 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 un'||l_msg_data);
584: END IF;

Line 581: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

577: IF OZF_DEBUG_LOW_ON THEN
578: ozf_utility_PVT.debug_message('in error'||l_msg_data);
579: END IF;
580: RAISE FND_API.g_exc_error;
581: 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 un'||l_msg_data);
584: END IF;
585: RAISE FND_API.g_exc_unexpected_error;

Line 585: RAISE FND_API.g_exc_unexpected_error;

581: 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 un'||l_msg_data);
584: END IF;
585: RAISE FND_API.g_exc_unexpected_error;
586: END IF;
587: IF OZF_DEBUG_LOW_ON THEN
588: ozf_utility_PVT.debug_message('After price_request' );
589: END IF;

Line 659: p_encoded => FND_API.G_FALSE,

655: FND_MSG_PUB.Add;
656: END IF;
657: --Standard call to get message count and if count=1, get the message
658: FND_MSG_PUB.Count_And_Get (
659: p_encoded => FND_API.G_FALSE,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );
663: IF OZF_DEBUG_HIGH_ON THEN

Line 667: WHEN FND_API.G_EXC_ERROR THEN

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

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 672: p_encoded => FND_API.G_FALSE,

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

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 681: p_encoded => FND_API.G_FALSE,

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

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 690: p_encoded => FND_API.G_FALSE,

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

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

706: --
707: ---------------------------------------------------------------------
708: PROCEDURE Purge_Pricing_Temp_table (
709: p_api_version IN NUMBER
710: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
712: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
713: ,x_return_status OUT NOCOPY VARCHAR2
714: ,x_msg_data OUT NOCOPY VARCHAR2

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

707: ---------------------------------------------------------------------
708: PROCEDURE Purge_Pricing_Temp_table (
709: p_api_version IN NUMBER
710: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
712: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
713: ,x_return_status OUT NOCOPY VARCHAR2
714: ,x_msg_data OUT NOCOPY VARCHAR2
715: ,x_msg_count OUT NOCOPY NUMBER

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

708: PROCEDURE Purge_Pricing_Temp_table (
709: p_api_version IN NUMBER
710: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
712: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
713: ,x_return_status OUT NOCOPY VARCHAR2
714: ,x_msg_data OUT NOCOPY VARCHAR2
715: ,x_msg_count OUT NOCOPY NUMBER
716: ) is

Line 725: IF NOT FND_API.Compatible_API_Call (

721:
722: SAVEPOINT PURGE_PRICING_TEMP;
723:
724: -- Standard call to check for call compatibility.
725: IF NOT FND_API.Compatible_API_Call (
726: l_api_version,
727: p_api_version,
728: l_api_name,
729: G_PKG_NAME)

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: p_api_version,
728: l_api_name,
729: G_PKG_NAME)
730: THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733: -- Debug Message
734: IF OZF_DEBUG_LOW_ON THEN
735: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 741: IF FND_API.To_Boolean (p_init_msg_list) THEN

737: FND_MSG_PUB.Add;
738: END IF;
739:
740: --Initialize message list if p_init_msg_list is TRUE.
741: IF FND_API.To_Boolean (p_init_msg_list) THEN
742: FND_MSG_PUB.initialize;
743: END IF;
744:
745: -- Initialize API return status to sucess

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

742: FND_MSG_PUB.initialize;
743: END IF;
744:
745: -- Initialize API return status to sucess
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747:
748: -- Debug Message
749: IF OZF_DEBUG_LOW_ON THEN
750: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 756: WHEN FND_API.G_EXC_ERROR THEN

752: FND_MSG_PUB.Add;
753: END IF;
754:
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO PURGE_PRICING_TEMP;
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754:
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO PURGE_PRICING_TEMP;
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,

Line 761: p_encoded => FND_API.G_FALSE,

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

Line 765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 770: p_encoded => FND_API.G_FALSE,

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

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 779: p_encoded => FND_API.G_FALSE,

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