DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_UTIL dependencies on FND_API

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

81: l_line_rec := OE_ORDER_PUB.G_LINE;
82:
83: -- Validate the Line_id.
84:
85: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
86: THEN
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
89: oe_debug_pub.add( 'EXITING CHARGES' ) ;

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

84:
85: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
86: THEN
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
89: oe_debug_pub.add( 'EXITING CHARGES' ) ;
90: END IF;
91: RETURN NULL;
92: END IF;

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

92: END IF;
93:
94: -- Check for values of cost_type_code
95:
96: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
99: oe_debug_pub.add( 'EXITING CHARGES' ) ;
100: END IF;

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

94: -- Check for values of cost_type_code
95:
96: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
99: oe_debug_pub.add( 'EXITING CHARGES' ) ;
100: END IF;
101: RETURN NULL;
102: END IF;

Line 108: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR

104: -- Check for Pricing Quantity
105:
106: /*
107: IF l_line_rec.pricing_quantity IS NULL OR
108: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
109: l_line_rec.pricing_quantity <= 0 THEN
110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
111: oe_debug_pub.add('exiting charges');
112: RETURN NULL;

Line 110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');

106: /*
107: IF l_line_rec.pricing_quantity IS NULL OR
108: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
109: l_line_rec.pricing_quantity <= 0 THEN
110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
111: oe_debug_pub.add('exiting charges');
112: RETURN NULL;
113: END IF;
114: */

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: END IF;
181: IF l_debug_level > 0 THEN
182: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
183: END IF;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END Get_Cost_Amount;
186:
187: FUNCTION Get_List_Line_Type_Code
188: ( p_key IN NUMBER)

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: 'Get_List_Line_Type_Code'
262: );
263: END IF;
264:
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END Get_List_Line_Type_Code;
267:
268: FUNCTION Get_Estimated_Cost_Amount
269: ( p_cost_type_code IN VARCHAR2

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

285: l_line_rec := OE_ORDER_PUB.G_LINE;
286:
287: -- Validate the Line_id.
288:
289: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
290: THEN
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
293: oe_debug_pub.add( 'EXITING CHARGES' ) ;

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

288:
289: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
290: THEN
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
293: oe_debug_pub.add( 'EXITING CHARGES' ) ;
294: END IF;
295: RETURN NULL;
296: END IF;

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

296: END IF;
297:
298: -- Check for values of cost_type_code
299:
300: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
303: oe_debug_pub.add( 'EXITING CHARGES' ) ;
304: END IF;

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

298: -- Check for values of cost_type_code
299:
300: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
303: oe_debug_pub.add( 'EXITING CHARGES' ) ;
304: END IF;
305: RETURN NULL;
306: END IF;

Line 312: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR

308: -- Check for Pricing Quantity
309:
310: /*
311: IF l_line_rec.pricing_quantity IS NULL OR
312: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
313: l_line_rec.pricing_quantity <= 0 THEN
314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
315: oe_debug_pub.add('exiting charges');
316: RETURN NULL;

Line 314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');

310: /*
311: IF l_line_rec.pricing_quantity IS NULL OR
312: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
313: l_line_rec.pricing_quantity <= 0 THEN
314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
315: oe_debug_pub.add('exiting charges');
316: RETURN NULL;
317: END IF;
318: */

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: END IF;
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END Get_Estimated_Cost_Amount;
368:
369: PROCEDURE Create_Dummy_Adjustment(p_header_id in number) IS
370: l_price_adjustment_id number := -1;

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

440: l_line_rec := OE_ORDER_PUB.G_LINE;
441:
442: -- Validate the Line_id.
443:
444: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
445: THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
448: oe_debug_pub.add( 'EXITING CHARGES' ) ;

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

443:
444: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
445: THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
448: oe_debug_pub.add( 'EXITING CHARGES' ) ;
449: END IF;
450: RETURN NULL;
451: END IF;

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

451: END IF;
452:
453: -- Check for values of cost_type_code
454:
455: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
458: oe_debug_pub.add( 'EXITING CHARGES' ) ;
459: END IF;

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

453: -- Check for values of cost_type_code
454:
455: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
458: oe_debug_pub.add( 'EXITING CHARGES' ) ;
459: END IF;
460: RETURN NULL;
461: END IF;

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: END IF;
492: IF l_debug_level > 0 THEN
493: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
494: END IF;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END Get_Estimated_Cost_Amount_ns;
497:
498: END OE_FREIGHT_RATING_util;