DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_UTIL dependencies on FND_API

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

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

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

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

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

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

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

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

Line 107: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR

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

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

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

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

Line 311: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR

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

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

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

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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