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.OE_CHARGE_PVT dependencies on FND_API

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

28: -- End of Comments
29:
30: PROCEDURE Get_Charge_Amount
31: ( p_api_version_number IN NUMBER
32: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33: , p_header_id IN NUMBER
34: , p_line_id IN NUMBER
35: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
36: , x_return_status OUT NOCOPY VARCHAR2

Line 35: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE

31: ( p_api_version_number IN NUMBER
32: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33: , p_header_id IN NUMBER
34: , p_line_id IN NUMBER
35: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
36: , x_return_status OUT NOCOPY VARCHAR2
37:
38: , x_msg_count OUT NOCOPY NUMBER
39:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: --
53: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
54: --
55: BEGIN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: -- Check for Header Id
59:
60: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

Line 60: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: -- Check for Header Id
59:
60: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
61:
62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
63: THEN
64:

Line 70: RAISE FND_API.G_EXC_ERROR;

66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
67: OE_MSG_PUB.Add;
68:
69: END IF;
70: RAISE FND_API.G_EXC_ERROR;
71:
72: END IF;
73:
74: IF NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10)

Line 88: IF p_all_charges = FND_API.G_TRUE THEN

84:
85:
86:
87: -- Check the operation whether all charges for the Order are required
88: IF p_all_charges = FND_API.G_TRUE THEN
89: -- Getting Order Total charge amount.
90:
91: -- bug 4060810, improve performance of SQL, with fix for bug 2785662
92: SELECT SUM(nvl(ROUND(

Line 120: ELSIF p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM THEN

116:
117: -- If the line_id is NULL and Header_id is not null then header
118: -- level charges are required.
119:
120: ELSIF p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM THEN
121:
122: -- Getting Header level charge amount.
123:
124: SELECT SUM(ROUND(

Line 178: WHEN FND_API.G_EXC_ERROR THEN

174: END IF;
175: x_charge_amount := l_charge_amount;
176: EXCEPTION
177:
178: WHEN FND_API.G_EXC_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: -- Get message count and data

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: EXCEPTION
177:
178: WHEN FND_API.G_EXC_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: -- Get message count and data
183:
184: OE_MSG_PUB.Count_And_Get

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

187: );
188:
189: WHEN OTHERS THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192:
193: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg

Line 254: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM

250: l_line_rec := OE_ORDER_PUB.G_LINE;
251:
252: -- Validate the Line_id.
253:
254: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
255: THEN
256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
258: END IF;

Line 257: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;

253:
254: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
255: THEN
256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
258: END IF;
259: IF l_debug_level > 0 THEN
260: oe_debug_pub.add( 'EXITING CHARGES' ) ;
261: END IF;

Line 267: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN

263: END IF;
264:
265: -- Check for values of cost_type_code
266:
267: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
270: END IF;
271: IF l_debug_level > 0 THEN

Line 269: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;

265: -- Check for values of cost_type_code
266:
267: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
270: END IF;
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'EXITING CHARGES' ) ;
273: END IF;

Line 280: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR

276:
277: -- Check for Pricing Quantity
278:
279: IF l_line_rec.pricing_quantity IS NULL OR
280: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
281: l_line_rec.pricing_quantity <= 0 THEN
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'L_LINE_REC.PRICING_QUANTITY = FND_API.G_MISS_NUM OR _LINE_REC.PRICING_QUANTITY <= 0' ) ;
284: END IF;

Line 283: oe_debug_pub.add( 'L_LINE_REC.PRICING_QUANTITY = FND_API.G_MISS_NUM OR _LINE_REC.PRICING_QUANTITY <= 0' ) ;

279: IF l_line_rec.pricing_quantity IS NULL OR
280: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
281: l_line_rec.pricing_quantity <= 0 THEN
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'L_LINE_REC.PRICING_QUANTITY = FND_API.G_MISS_NUM OR _LINE_REC.PRICING_QUANTITY <= 0' ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'EXITING CHARGES' ) ;
287: END IF;

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: END IF;
339: IF l_debug_level > 0 THEN
340: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
341: END IF;
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END Get_Cost_Amount;
344:
345: -- Start of Comments
346: -- Function name Get_Cost_Types

Line 391: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM

387: END IF;
388: -- Get the Line record from the Global Record
389: l_line_rec := OE_ORDER_PUB.G_LINE;
390:
391: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
392: THEN
393: RETURN l_cost_tbl;
394: END IF;
395:

Line 437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

433: ( G_PKG_NAME
434: , 'Get_Cost_Types'
435: );
436: END IF;
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438:
439: END Get_Cost_Types;
440:
441: -- Start of Comments

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: ( G_PKG_NAME
488: , 'Get_Shipped_Status'
489: );
490: END IF;
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END Get_Shipped_Status;
493:
494: PROCEDURE Check_Duplicate_Line_Charges
495: (

Line 693: l_Header_adj_tbl(l_charge_index).line_id = FND_API.G_MISS_NUM)

689: AND l_Header_adj_tbl(l_charge_index).operation IN
690: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)
691: AND l_Header_adj_tbl(l_charge_index).Header_id = l_header_id
692: AND (l_Header_adj_tbl(l_charge_index).line_id IS NULL OR
693: l_Header_adj_tbl(l_charge_index).line_id = FND_API.G_MISS_NUM)
694: THEN
695:
696: l_tmp_index := l_Header_adj_tbl.FIRST;
697: WHILE l_tmp_index IS NOT NULL LOOP

Line 793: IF p_header_id IS NULL OR p_header_id = FND_API.G_MISS_NUM THEN

789: --
790: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
791: --
792: BEGIN
793: IF p_header_id IS NULL OR p_header_id = FND_API.G_MISS_NUM THEN
794:
795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
796: THEN
797:

Line 803: RAISE FND_API.G_EXC_ERROR;

799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
800: OE_MSG_PUB.Add;
801:
802: END IF;
803: RAISE FND_API.G_EXC_ERROR;
804: END IF;
805: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
806:
807: -- l_Header_Adj_Tbl := OE_Header_Adj_Util.query_rows(

Line 805: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN

801:
802: END IF;
803: RAISE FND_API.G_EXC_ERROR;
804: END IF;
805: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
806:
807: -- l_Header_Adj_Tbl := OE_Header_Adj_Util.query_rows(
808: -- p_header_id => p_header_id);
809:

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: ( G_PKG_NAME
867: , 'Check_Duplicate_Charges'
868: );
869: END IF;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END Check_Duplicate_Charges;
872:
873:
874: -- Start of Comments

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

1278:
1279: --Recurring Charges
1280: PROCEDURE Get_Rec_Charge_Amount
1281: ( p_api_version_number IN NUMBER
1282: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1283: , p_header_id IN NUMBER
1284: , p_line_id IN NUMBER
1285: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
1286: , p_charge_periodicity_code IN VARCHAR2

Line 1285: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE

1281: ( p_api_version_number IN NUMBER
1282: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1283: , p_header_id IN NUMBER
1284: , p_line_id IN NUMBER
1285: , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
1286: , p_charge_periodicity_code IN VARCHAR2
1287: , x_return_status OUT NOCOPY VARCHAR2
1288: , x_msg_count OUT NOCOPY NUMBER
1289: , x_msg_data OUT NOCOPY VARCHAR2

Line 1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

1299: --
1300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1301: --
1302: BEGIN
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: -- Check for Header Id
1306:
1307: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

Line 1307: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: -- Check for Header Id
1306:
1307: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
1308:
1309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1310: THEN
1311:

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1314: OE_MSG_PUB.Add;
1315:
1316: END IF;
1317: RAISE FND_API.G_EXC_ERROR;
1318:
1319: END IF;
1320:
1321: IF NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10)

Line 1333: IF p_all_charges = FND_API.G_TRUE THEN

1329: OE_ORDER_UTIL.G_Precision:=2;
1330: END IF;
1331:
1332: -- Check the operation whether all charges for the Order are required
1333: IF p_all_charges = FND_API.G_TRUE THEN
1334: SELECT SUM(ROUND(
1335: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',
1336: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
1337: DECODE(L.ORDERED_QUANTITY,0,0,(-P.OPERAND)),

Line 1362: WHEN FND_API.G_EXC_ERROR THEN

1358: END IF;
1359: x_charge_amount := l_charge_amount;
1360: EXCEPTION
1361:
1362: WHEN FND_API.G_EXC_ERROR THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: -- Get message count and data

Line 1364: x_return_status := FND_API.G_RET_STS_ERROR;

1360: EXCEPTION
1361:
1362: WHEN FND_API.G_EXC_ERROR THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: -- Get message count and data
1367:
1368: OE_MSG_PUB.Count_And_Get

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1371: );
1372:
1373: WHEN OTHERS THEN
1374:
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1376:
1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg