DBA Data[Home] [Help]

APPS.BIS_DIMENSION_VALIDATE_PVT dependencies on FND_API

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

20: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_VALIDATE_PVT';
21: --
22: PROCEDURE Validate_Record
23: ( p_api_version IN NUMBER
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
26: , x_return_status OUT VARCHAR2
27: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
28: )

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
28: )
29: IS
30: BEGIN
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33:
34: if( BIS_UTILITIES_PUB.Value_Missing(p_Dimension_Rec.dimension_short_name)
35: = FND_API.G_TRUE

Line 35: = FND_API.G_TRUE

31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33:
34: if( BIS_UTILITIES_PUB.Value_Missing(p_Dimension_Rec.dimension_short_name)
35: = FND_API.G_TRUE
36: OR BIS_UTILITIES_PUB.Value_NULL(p_Dimension_Rec.dimension_short_name)
37: = FND_API.G_TRUE) then
38: --POPULATE THE ERROR TABLE
39: BIS_UTILITIES_PVT.Add_Error_Message

Line 37: = FND_API.G_TRUE) then

33:
34: if( BIS_UTILITIES_PUB.Value_Missing(p_Dimension_Rec.dimension_short_name)
35: = FND_API.G_TRUE
36: OR BIS_UTILITIES_PUB.Value_NULL(p_Dimension_Rec.dimension_short_name)
37: = FND_API.G_TRUE) then
38: --POPULATE THE ERROR TABLE
39: BIS_UTILITIES_PVT.Add_Error_Message
40: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_ID'
41: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 46: RAISE FND_API.G_EXC_ERROR;

42: , p_error_proc_name => G_PKG_NAME||'.Validate_Record'
43: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
44: );
45:
46: RAISE FND_API.G_EXC_ERROR;
47: end if;
48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN

Line 51: x_return_status := FND_API.G_RET_STS_ERROR ;

47: end if;
48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: x_return_status := FND_API.G_RET_STS_ERROR ;
52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;

Line 52: RAISE FND_API.G_EXC_ERROR;

48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: x_return_status := FND_API.G_RET_STS_ERROR ;
52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 53: when FND_API.G_EXC_ERROR then

49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: x_return_status := FND_API.G_RET_STS_ERROR ;
52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 54: x_return_status := FND_API.G_RET_STS_ERROR ;

50: WHEN NO_DATA_FOUND THEN
51: x_return_status := FND_API.G_RET_STS_ERROR ;
52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 55: RAISE FND_API.G_EXC_ERROR;

51: x_return_status := FND_API.G_RET_STS_ERROR ;
52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: when others then

Line 56: when FND_API.G_EXC_UNEXPECTED_ERROR then

52: RAISE FND_API.G_EXC_ERROR;
53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: when others then
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

53: when FND_API.G_EXC_ERROR then
54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: when others then
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
61: BIS_UTILITIES_PVT.Add_Error_Message

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: x_return_status := FND_API.G_RET_STS_ERROR ;
55: RAISE FND_API.G_EXC_ERROR;
56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: when others then
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
61: BIS_UTILITIES_PVT.Add_Error_Message
62: ( p_error_msg_id => SQLCODE

Line 60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

56: when FND_API.G_EXC_UNEXPECTED_ERROR then
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: when others then
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
61: BIS_UTILITIES_PVT.Add_Error_Message
62: ( p_error_msg_id => SQLCODE
63: , p_error_description => SQLERRM
64: , p_error_proc_name => G_PKG_NAME||'.Validate_Record'

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: , p_error_proc_name => G_PKG_NAME||'.Validate_Record'
65: , p_error_table => x_error_tbl
66: , x_error_table => x_error_tbl
67: );
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69:
70: END Validate_Record;
71: --
72: --