DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PVT dependencies on FND_API

Line 161: IF NOT FND_API.Compatible_API_Call (l_api_version ,

157: --Bug 4122622: End
158:
159: BEGIN
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call (l_api_version ,
162: p_api_version ,
163: l_api_name ,
164: G_PKG_NAME )
165: THEN

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: p_api_version ,
163: l_api_name ,
164: G_PKG_NAME )
165: THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: -- Initialize message list if p_init_msg_list is set to TRUE.
170: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 170: IF FND_API.to_Boolean( p_init_msg_list ) THEN

166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: -- Initialize message list if p_init_msg_list is set to TRUE.
170: IF FND_API.to_Boolean( p_init_msg_list ) THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:
174: -- Initialize API return status to success

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: FND_MSG_PUB.initialize;
172: END IF;
173:
174: -- Initialize API return status to success
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: -- API Body
178:
179: -- CHANGE_SOURCE_TYPE(x_event.payload, EDR_CONSTANTS_GRP.g_db_mode);

Line 201: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

197: end if;
198: --Bug 4122622: End
199:
200: --validate that the payload passed is valid
201: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
202:
203: EDR_ERES_EVENT_PUB.VALIDATE_PAYLOAD
204: ( p_api_version => 1.0 ,
205: p_init_msg_list => FND_API.G_FALSE ,

Line 205: p_init_msg_list => FND_API.G_FALSE ,

201: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
202:
203: EDR_ERES_EVENT_PUB.VALIDATE_PAYLOAD
204: ( p_api_version => 1.0 ,
205: p_init_msg_list => FND_API.G_FALSE ,
206: x_return_status => l_return_status ,
207: x_msg_count => l_msg_count ,
208: x_msg_data => l_msg_data ,
209: p_event_name => x_event.event_name ,

Line 219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

215:
216: --Bug 3136403: End
217:
218: -- If any errors happen abort API.
219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE PAYLOAD_VALIDATION_ERROR;
223: END IF;

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: --Bug 3136403: End
217:
218: -- If any errors happen abort API.
219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE PAYLOAD_VALIDATION_ERROR;
223: END IF;
224:

Line 221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

217:
218: -- If any errors happen abort API.
219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE PAYLOAD_VALIDATION_ERROR;
223: END IF;
224:
225: END IF;

Line 246: l_parent_erecord_id <> '-1' and p_validation_level = FND_API.G_VALID_LEVEL_NONE

242: --Validate the parent erecord if they are set and only if they were'nt validated
243: --earlier.
244: --They would'nt be validated if the Validation level was set to NONE.
245: if x_is_child_event and l_parent_erecord_id is not null and
246: l_parent_erecord_id <> '-1' and p_validation_level = FND_API.G_VALID_LEVEL_NONE
247: then
248: EDR_ERES_EVENT_PUB.VALIDATE_ERECORD
249: ( p_api_version => 1.0,
250: x_return_status => l_return_status,

Line 256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

252: x_msg_data => l_msg_data,
253: p_erecord_id => to_number(l_parent_erecord_id,'999999999999.999999')
254: );
255: -- If any errors happen abort API.
256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE PARENT_ERECORD_ID_ERROR;
260: END IF;

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253: p_erecord_id => to_number(l_parent_erecord_id,'999999999999.999999')
254: );
255: -- If any errors happen abort API.
256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE PARENT_ERECORD_ID_ERROR;
260: END IF;
261: END IF;

Line 258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

254: );
255: -- If any errors happen abort API.
256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE PARENT_ERECORD_ID_ERROR;
260: END IF;
261: END IF;
262: --Bug 4122622: End;

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: );
349:
350: EXCEPTION
351: WHEN PAYLOAD_VALIDATION_ERROR THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
354:
355: -- this would pass on the validation errors to the calling
356: -- routine

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: p_data => x_msg_data
361: );
362:
363: WHEN EVENT_RAISE_ERROR THEN
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
366: x_event.erecord_id := null;
367:
368: l_mesg_text := fnd_message.get_string('EDR','EDR_EVENT_RAISE_ERROR');

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: ( p_count => x_msg_count ,
378: p_data => x_msg_data
379: );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
384: x_event.erecord_id := null;
385:

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378: p_data => x_msg_data
379: );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
384: x_event.erecord_id := null;
385:
386: FND_MSG_PUB.Count_And_Get

Line 395: x_return_status := FND_API.G_RET_STS_ERROR ;

391:
392: --Bug 4122622: Start
393: --This exception would be thrown when the parent e-record ID is invalid.
394: WHEN PARENT_ERECORD_ID_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR ;
396:
397: fnd_message.set_name('EDR','EDR_VAL_INVALID_PARENT_ID');
398: fnd_message.set_token('ERECORD_ID', l_parent_erecord_id);
399: fnd_message.set_token('EVENT_NAME', x_event.event_name);

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

410: );
411: --Bug 4122622: End
412:
413: WHEN OTHERS THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
416: x_event.erecord_id := null;
417:
418: IF FND_MSG_PUB.Check_Msg_Level

Line 629: IF NOT FND_API.Compatible_API_Call (l_api_version ,

625: --by default return 0 as the approver count
626: x_approver_count := 0;
627:
628: -- Standard call to check for call compatibility.
629: IF NOT FND_API.Compatible_API_Call (l_api_version ,
630: p_api_version ,
631: l_api_name ,
632: G_PKG_NAME )
633: THEN

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: p_api_version ,
631: l_api_name ,
632: G_PKG_NAME )
633: THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 638: IF FND_API.to_Boolean( p_init_msg_list ) THEN

634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list ) THEN
639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- Initialize API return status to success

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- Initialize API return status to success
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645:
646: -- API Body
647: --validate the event name and get the application id

Line 686: raise FND_API.G_EXC_UNEXPECTED_ERROR;

682: --Bug 2674799: end
683:
684: EXCEPTION
685: when OTHERS THEN
686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688:
689: l_ame_txn_type := nvl(l_ame_txn_type, p_event_name);
690:

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: );
764:
765: EXCEPTION
766: WHEN INVALID_EVENT_NAME_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: -- this would pass on the validation errors to the calling
770: -- routine
771: FND_MSG_PUB.Count_And_Get

Line 776: x_return_status := FND_API.G_RET_STS_ERROR;

772: ( p_count => x_msg_count ,
773: p_data => x_msg_data
774: );
775: WHEN INVALID_USER_NAME_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
777:
778: -- this would pass on the validation errors to the calling
779: -- routine
780: FND_MSG_PUB.Count_And_Get

Line 785: x_return_status := FND_API.G_RET_STS_ERROR;

781: ( p_count => x_msg_count ,
782: p_data => x_msg_data
783: );
784: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
787: fnd_message.set_token( 'EVENT', p_event_NAME);
788: fnd_msg_pub.Add;
789: -- this would pass on the validation errors to the calling

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

792: ( p_count => x_msg_count ,
793: p_data => x_msg_data
794: );
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798:
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count ,

Line 797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

793: p_data => x_msg_data
794: );
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798:
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count ,
801: p_data => x_msg_data

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

801: p_data => x_msg_data
802: );
803:
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806:
807: IF FND_MSG_PUB.Check_Msg_Level
808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
809: THEN