DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_GRP dependencies on FND_API

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

42: -- End of comments --
43: -----------------------------------------------------------------------------
44: PROCEDURE Receive_CloseLineEvent(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,

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

43: -----------------------------------------------------------------------------
44: PROCEDURE Receive_CloseLineEvent(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,

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

44: PROCEDURE Receive_CloseLineEvent(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,
52: p_revenue_event_line_id IN NUMBER,

Line 92: IF NOT FND_API.Compatible_API_Call (

88: -- Standard start of API savepoint
89: SAVEPOINT Receive_CloseLineEvent_GRP;
90:
91: -- Standard call to check for call compatibility
92: IF NOT FND_API.Compatible_API_Call (
93: l_api_version,
94: p_api_version,
95: l_api_name,
96: G_PKG_NAME ) THEN

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: l_api_version,
94: p_api_version,
95: l_api_name,
96: G_PKG_NAME ) THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE
101: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 101: IF FND_API.to_Boolean(p_init_msg_list) THEN

97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE
101: IF FND_API.to_Boolean(p_init_msg_list) THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to success

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to success
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107: x_msg_count := 0;
108: x_msg_data := '';
109:
110: -- API Body

Line 169: IF FND_API.to_Boolean(p_commit) THEN

165:
166: -- End API Body
167:
168: -- Standard check of p_commit
169: IF FND_API.to_Boolean(p_commit) THEN
170: COMMIT;
171: END IF;
172:
173:

Line 177: , p_encoded => FND_API.g_false

173:
174: FND_MSG_PUB.count_and_get
175: ( p_count => x_msg_count
176: , p_data => x_msg_data
177: , p_encoded => FND_API.g_false
178: );
179:
180: IF l_plog THEN
181: fnd_log.string(

Line 209: , p_encoded => FND_API.g_false

205:
206: FND_MSG_PUB.count_and_get
207: ( p_count => x_msg_count
208: , p_data => x_msg_data
209: , p_encoded => FND_API.g_false
210: );
211:
212: WHEN OTHERS THEN
213:

Line 215: x_return_status := fnd_api.g_ret_sts_unexp_error ;

211:
212: WHEN OTHERS THEN
213:
214: ROLLBACK TO Receive_CloseLineEvent_GRP;
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
219: ,'Receive_CloseLineEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));

Line 234: , p_encoded => FND_API.g_false

230:
231: FND_MSG_PUB.count_and_get
232: ( p_count => x_msg_count
233: , p_data => x_msg_data
234: , p_encoded => FND_API.g_false
235: );
236:
237: END Receive_CloseLineEvent;
238:

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

274: -- End of comments --
275: -----------------------------------------------------------------------------
276: PROCEDURE Return_PeriodStatuses(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,

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

275: -----------------------------------------------------------------------------
276: PROCEDURE Return_PeriodStatuses(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,

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

276: PROCEDURE Return_PeriodStatuses(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_set_of_books_id IN NUMBER,

Line 323: IF NOT FND_API.Compatible_API_Call (

319: -- Standard start of API savepoint
320: SAVEPOINT Return_PeriodStatuses_GRP;
321:
322: -- Standard call to check for call compatibility
323: IF NOT FND_API.Compatible_API_Call (
324: l_api_version,
325: p_api_version,
326: l_api_name,
327: G_PKG_NAME ) THEN

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: l_api_version,
325: p_api_version,
326: l_api_name,
327: G_PKG_NAME ) THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: -- Initialize message list if p_init_msg_list is set to TRUE
332: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 332: IF FND_API.to_Boolean(p_init_msg_list) THEN

328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: -- Initialize message list if p_init_msg_list is set to TRUE
332: IF FND_API.to_Boolean(p_init_msg_list) THEN
333: FND_MSG_PUB.initialize;
334: END IF;
335:
336: -- Initialize API return status to success

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: FND_MSG_PUB.initialize;
334: END IF;
335:
336: -- Initialize API return status to success
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338: x_msg_count := 0;
339: x_msg_data := '';
340:
341: -- API Body

Line 368: IF FND_API.to_Boolean(p_commit) THEN

364:
365: -- End API Body
366:
367: -- Standard check of p_commit
368: IF FND_API.to_Boolean(p_commit) THEN
369: COMMIT;
370: END IF;
371:
372:

Line 394: x_return_status := fnd_api.g_ret_sts_unexp_error ;

390: EXCEPTION
391: WHEN OTHERS THEN
392:
393: ROLLBACK TO Return_PeriodStatuses_GRP;
394: x_return_status := fnd_api.g_ret_sts_unexp_error ;
395:
396: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
398: ,'Return_PeriodStatuses '||l_stmt_num||' : '||substr(SQLERRM,1,200));