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,
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,
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,
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
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
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
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
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:
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(
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:
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));
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:
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,
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,
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,
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
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
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
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
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:
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));