DBA Data[Home] [Help]

APPS.OE_DBI_UTIL dependencies on FND_API

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51:
52: IF l_debug_level > 0 THEN
53: oe_debug_pub.add( 'ENTERING UPDATE_DBI API' , 1 ) ;
54: END IF;
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: l_set_of_books_rec := OE_ORDER_CACHE.LOAD_SET_OF_BOOKS;
58: l_set_of_books_id := l_set_of_books_rec.set_of_books_id;
59: l_currency_code := l_set_of_books_rec.currency_code;

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

60:
61: IF (l_set_of_books_id IS NULL) OR (l_currency_code IS NULL) THEN
62: oe_debug_pub.add( 'SET_OF_BOOKS_ID= '|| L_SET_OF_BOOKS_ID , 1 ) ;
63: oe_debug_pub.add( 'CURRENCY_CODE= '|| L_CURRENCY_CODE , 1 ) ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND

Line 69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND

65: END IF;
66:
67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)
73: THEN

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: WHEN NO_DATA_FOUND THEN
418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add( 'NO DATA FOUND' , 1 ) ;
420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: WHEN OTHERS THEN
424: IF l_debug_level > 0 THEN
425: oe_debug_pub.add( 'In Others of Update_DBI_Log' , 1 ) ;

Line 422: RAISE FND_API.G_EXC_ERROR;

418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add( 'NO DATA FOUND' , 1 ) ;
420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: WHEN OTHERS THEN
424: IF l_debug_level > 0 THEN
425: oe_debug_pub.add( 'In Others of Update_DBI_Log' , 1 ) ;
426: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: OE_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME
432: ,'Update_DBI_log');
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436:
437: END Update_DBI_Log;
438:

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: (G_PKG_NAME
432: ,'Update_DBI_log');
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436:
437: END Update_DBI_Log;
438:
439: END OE_DBI_UTIL;