DBA Data[Home] [Help]

APPS.PSB_WS_LINE_PERIOD_I_PVT dependencies on FND_API

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

11:
12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,

Line 16: p_commit IN VARCHAR2 := FND_API.G_FALSE,

12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,
20: p_msg_data OUT NOCOPY VARCHAR2,

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

13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,
20: p_msg_data OUT NOCOPY VARCHAR2,
21: --

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version,

61: BEGIN
62: --
63: SAVEPOINT Insert_Row_Pvt ;
64: --
65: IF NOT FND_API.Compatible_API_Call ( l_api_version,
66: p_api_version,
67: l_api_name,
68: G_PKG_NAME )
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

66: p_api_version,
67: l_api_name,
68: G_PKG_NAME )
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
71: END IF;
72:
73: --
74:

Line 75: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

71: END IF;
72:
73: --
74:
75: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize ;
77: END IF;
78: --
79: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 79: p_return_status := FND_API.G_RET_STS_SUCCESS ;

75: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize ;
77: END IF;
78: --
79: p_return_status := FND_API.G_RET_STS_SUCCESS ;
80:
81:
82:
83: -- Initialize the table

Line 100: p_init_msg_list => FND_API.G_FALSE,

96:
97: PSB_WS_ACCT_PVT.Create_Account_Dist
98: (
99: p_api_version => 1.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
103: p_return_status => l_return_status,
104: p_msg_count => p_msg_count,

Line 101: p_commit => FND_API.G_FALSE,

97: PSB_WS_ACCT_PVT.Create_Account_Dist
98: (
99: p_api_version => 1.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
103: p_return_status => l_return_status,
104: p_msg_count => p_msg_count,
105: p_msg_data => p_msg_data,

Line 102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

98: (
99: p_api_version => 1.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
103: p_return_status => l_return_status,
104: p_msg_count => p_msg_count,
105: p_msg_data => p_msg_data,
106: --

Line 118: p_distribute_flag => FND_API.G_FALSE,

114: p_concatenated_segments => p_concatenated_segments,
115: p_currency_code => p_currency_code,
116: p_balance_type => p_balance_type,
117: p_ytd_amount => p_ytd_amount,
118: p_distribute_flag => FND_API.G_FALSE,
119: p_period_amount => l_period_amount,
120: p_service_package_id => p_service_package_id
121:
122: );

Line 124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

120: p_service_package_id => p_service_package_id
121:
122: );
123: --
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR ;
126: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
128: END IF;

Line 125: RAISE FND_API.G_EXC_ERROR ;

121:
122: );
123: --
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR ;
126: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
128: END IF;
129: --

Line 126: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

122: );
123: --
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR ;
126: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
128: END IF;
129: --
130:

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

123: --
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR ;
126: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
128: END IF;
129: --
130:
131: END IF;

Line 136: IF FND_API.To_Boolean ( p_commit ) THEN

132:
133:
134:
135: --
136: IF FND_API.To_Boolean ( p_commit ) THEN
137: COMMIT WORK;
138: END iF;
139: --
140: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: p_data => p_msg_data );
142: --
143: EXCEPTION
144: --
145: WHEN FND_API.G_EXC_ERROR THEN
146: --
147: ROLLBACK TO Insert_Row_Pvt ;
148: p_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 148: p_return_status := FND_API.G_RET_STS_ERROR;

144: --
145: WHEN FND_API.G_EXC_ERROR THEN
146: --
147: ROLLBACK TO Insert_Row_Pvt ;
148: p_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
150: p_data => p_msg_data );
151: --
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

148: p_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
150: p_data => p_msg_data );
151: --
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153: --
154: ROLLBACK TO Insert_Row_Pvt ;
155: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 155: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

151: --
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153: --
154: ROLLBACK TO Insert_Row_Pvt ;
155: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
157: p_data => p_msg_data );
158: --
159: WHEN OTHERS THEN

Line 162: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

158: --
159: WHEN OTHERS THEN
160: --
161: ROLLBACK TO Insert_Row_Pvt ;
162: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163: --
164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
165: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
166: l_api_name);