eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_ERES_EVENT_PUB dependencies on FND_API

Line 162: IF NOT FND_API.Compatible_API_Call (l_api_version ,

158: WHERE DOCUMENT_ID = p_erecord_id;
159:
160: BEGIN
161: -- Standard call to check for call compatibility.
162: IF NOT FND_API.Compatible_API_Call (l_api_version ,
163: p_api_version ,
164: l_api_name ,
165: G_PKG_NAME )
166: THEN

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 171: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: -- Initialize API return status to success
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: -- API Body
179: -- BEGIN Bug : 3834375. Added Secure context to allow query of all rows
180: edr_ctx_pkg.set_secure_attr;

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

184: -- BEGIN Bug : 3834375. remove security context
185: edr_ctx_pkg.unset_secure_attr;
186: -- END Bug : 3834375
187: if (l_count = 0) then
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: end if;
190:
191: close l_count_csr;
192:

Line 203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

199: p_data => x_msg_data
200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205:
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count ,

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205:
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count ,
208: p_data => x_msg_data

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

208: p_data => x_msg_data
209: );
210:
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213:
214: IF FND_MSG_PUB.Check_Msg_Level
215: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN

Line 288: IF NOT FND_API.Compatible_API_Call (l_api_version ,

284: BAD_RELATIONSHIP_ERROR EXCEPTION;
285:
286: BEGIN
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (l_api_version ,
289: p_api_version ,
290: l_api_name ,
291: G_PKG_NAME )
292: THEN

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: p_api_version ,
290: l_api_name ,
291: G_PKG_NAME )
292: THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
297: FND_MSG_PUB.initialize;

Line 296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

292: THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
297: FND_MSG_PUB.initialize;
298: END IF;
299:
300: -- Initialize API return status to success

Line 301: x_return_status := FND_API.G_RET_STS_SUCCESS;

297: FND_MSG_PUB.initialize;
298: END IF;
299:
300: -- Initialize API return status to success
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: -- API Body
304:
305: -- Bug Start: 5087502

Line 435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

431: p_erecord_id => l_parent_erecord_id
432: );
433:
434: -- If any errors happen abort API.
435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE PARENT_ERECORD_ID_ERROR;
439: END IF;

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: );
433:
434: -- If any errors happen abort API.
435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE PARENT_ERECORD_ID_ERROR;
439: END IF;
440: end if;

Line 437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

433:
434: -- If any errors happen abort API.
435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE PARENT_ERECORD_ID_ERROR;
439: END IF;
440: end if;
441:

Line 524: x_return_status := FND_API.G_RET_STS_ERROR ;

520: );
521:
522: EXCEPTION
523: WHEN INVALID_SOURCE_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_ERROR ;
525:
526: fnd_message.set_name('EDR','EDR_VAL_INVALID_SOURCE');
527: fnd_message.set_token('EVENT_NAME', p_event_name);
528: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 542: x_return_status := FND_API.G_RET_STS_ERROR ;

538: p_data => x_msg_data
539: );
540:
541: WHEN DEFERRED_PARAM_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_ERROR ;
543:
544: fnd_message.set_name('EDR','EDR_VAL_INVALID_DEFERRED');
545: fnd_message.set_token('EVENT_NAME', p_event_name);
546: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 561: x_return_status := FND_API.G_RET_STS_ERROR ;

557: p_data => x_msg_data
558: );
559:
560: WHEN INVALID_PAYLOAD_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_ERROR ;
562:
563: fnd_message.set_name('EDR','EDR_VAL_INVALID_PAYLOAD');
564: fnd_message.set_token('EVENT_NAME', p_event_name);
565: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 580: x_return_status := FND_API.G_RET_STS_ERROR ;

576: p_data => x_msg_data
577: );
578:
579: WHEN DEFERRED_DB_ERROR THEN
580: x_return_status := FND_API.G_RET_STS_ERROR ;
581:
582: fnd_message.set_name('EDR','EDR_VAL_INVALID_DEFERRED');
583: fnd_message.set_token('EVENT_NAME', p_event_name);
584: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 599: x_return_status := FND_API.G_RET_STS_ERROR ;

595: p_data => x_msg_data
596: );
597:
598: WHEN INTEREVENT_PARAM_ERROR THEN
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600:
601: fnd_message.set_name('EDR','EDR_VAL_INVALID_INTER_EVENT');
602: fnd_message.set_token('EVENT_NAME', p_event_name);
603: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 618: x_return_status := FND_API.G_RET_STS_ERROR ;

614: p_data => x_msg_data
615: );
616:
617: WHEN INTEREVENT_DB_PARAM_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_ERROR ;
619:
620: fnd_message.set_name('EDR','EDR_VAL_INTER_EVENT_DB');
621: fnd_message.set_token('EVENT_NAME', p_event_name);
622: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 637: x_return_status := FND_API.G_RET_STS_ERROR ;

633: p_data => x_msg_data
634: );
635:
636: WHEN PARENT_ERECORD_ID_ERROR THEN
637: x_return_status := FND_API.G_RET_STS_ERROR ;
638:
639: fnd_message.set_name('EDR','EDR_VAL_INVALID_PARENT_ID');
640: fnd_message.set_token('ERECORD_ID', l_parent_erecord_id);
641: fnd_message.set_token('EVENT_NAME', p_event_name);

Line 658: x_return_status := FND_API.G_RET_STS_ERROR ;

654: );
655:
656:
657: WHEN PARENT_EVENT_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_ERROR ;
659:
660: fnd_message.set_name('EDR','EDR_VAL_INVALID_PARENT_EVENT');
661: fnd_message.set_token('EVENT_NAME', p_event_name);
662: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 680: x_return_status := FND_API.G_RET_STS_ERROR ;

676: p_data => x_msg_data
677: );
678:
679: WHEN INVALID_PARAM_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_ERROR ;
681:
682: fnd_message.set_name('EDR','EDR_VAL_INVALID_PARAM');
683: fnd_message.set_token('EVENT_NAME', p_event_name);
684: fnd_message.set_token('EVENT_KEY', p_event_key);

Line 701: x_return_status := FND_API.G_RET_STS_ERROR ;

697: p_data => x_msg_data
698: );
699:
700: WHEN BAD_RELATIONSHIP_ERROR THEN
701: x_return_status := FND_API.G_RET_STS_ERROR ;
702:
703: FND_MESSAGE.SET_NAME('EDR','EDR_VAL_INVALID_RELATIONSHIP');
704: FND_MESSAGE.SET_TOKEN('PARENT_EVENT', l_parent_event_name);
705: FND_MESSAGE.SET_TOKEN('EVENT_NAME', p_event_name);

Line 720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

716: ( p_count => x_msg_count ,
717: p_data => x_msg_data
718: );
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722:
723: FND_MSG_PUB.Count_And_Get
724: ( p_count => x_msg_count ,

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

717: p_data => x_msg_data
718: );
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722:
723: FND_MSG_PUB.Count_And_Get
724: ( p_count => x_msg_count ,
725: p_data => x_msg_data

Line 729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

725: p_data => x_msg_data
726: );
727:
728: WHEN OTHERS THEN
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
730:
731: IF FND_MSG_PUB.Check_Msg_Level
732: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
733: THEN

Line 765: p_init_msg_list => FND_API.G_TRUE ,

761: l_return_value boolean := false;
762: BEGIN
763: EDR_ERES_EVENT_PUB.VALIDATE_PAYLOAD
764: ( p_api_version => 1.0 ,
765: p_init_msg_list => FND_API.G_TRUE ,
766: x_return_status => l_return_status ,
767: x_msg_count => l_msg_count ,
768: x_msg_data => l_msg_data ,
769: p_event_name => p_event_name ,

Line 783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

779: );
780: end if;
781:
782: -- If any errors happen abort API.
783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: fnd_message.set_encoded(l_msg_data);
785: APP_EXCEPTION.RAISE_EXCEPTION;
786:
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: fnd_message.set_encoded(l_msg_data);
785: APP_EXCEPTION.RAISE_EXCEPTION;
786:
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: fnd_message.set_encoded(l_msg_data);
789: APP_EXCEPTION.RAISE_EXCEPTION;
790:
791: END IF;

Line 793: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

789: APP_EXCEPTION.RAISE_EXCEPTION;
790:
791: END IF;
792:
793: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
794: l_return_value := true;
795: end if;
796:
797: RETURN l_return_value;

Line 828: IF NOT FND_API.Compatible_API_Call (l_api_version ,

824:
825: NO_DATA_ERROR EXCEPTION;
826: BEGIN
827: -- Standard call to check for call compatibility.
828: IF NOT FND_API.Compatible_API_Call (l_api_version ,
829: p_api_version ,
830: l_api_name ,
831: G_PKG_NAME )
832: THEN

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: p_api_version ,
830: l_api_name ,
831: G_PKG_NAME )
832: THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835:
836: -- Initialize message list if p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 837: IF FND_API.to_Boolean( p_init_msg_list ) THEN

833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835:
836: -- Initialize message list if p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean( p_init_msg_list ) THEN
838: FND_MSG_PUB.initialize;
839: END IF;
840:
841: -- Initialize API return status to success

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: FND_MSG_PUB.initialize;
839: END IF;
840:
841: -- Initialize API return status to success
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: -- API Body
845: open l_event_csr;
846:

Line 867: x_return_status := FND_API.G_RET_STS_ERROR;

863: );
864:
865: EXCEPTION
866: WHEN NO_DATA_ERROR then
867: x_return_status := FND_API.G_RET_STS_ERROR;
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871:

Line 869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

865: EXCEPTION
866: WHEN NO_DATA_ERROR then
867: x_return_status := FND_API.G_RET_STS_ERROR;
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871:
872: FND_MSG_PUB.Count_And_Get
873: ( p_count => x_msg_count ,

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

866: WHEN NO_DATA_ERROR then
867: x_return_status := FND_API.G_RET_STS_ERROR;
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871:
872: FND_MSG_PUB.Count_And_Get
873: ( p_count => x_msg_count ,
874: p_data => x_msg_data

Line 878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

874: p_data => x_msg_data
875: );
876:
877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
879:
880: IF FND_MSG_PUB.Check_Msg_Level
881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN

Line 945: IF NOT FND_API.Compatible_API_Call (l_api_version ,

941: --Bug 4122622: End
942:
943: BEGIN
944: -- Standard call to check for call compatibility.
945: IF NOT FND_API.Compatible_API_Call (l_api_version ,
946: p_api_version ,
947: l_api_name ,
948: G_PKG_NAME )
949: THEN

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

946: p_api_version ,
947: l_api_name ,
948: G_PKG_NAME )
949: THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 954: IF FND_API.to_Boolean( p_init_msg_list ) THEN

950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean( p_init_msg_list ) THEN
955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: -- Initialize API return status to success

Line 959: x_return_status := FND_API.G_RET_STS_SUCCESS;

955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: -- Initialize API return status to success
959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:
961: -- API Body
962:
963: --Bug 4122622: Start

Line 977: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

973: x_msg_data => l_msg_data,
974: p_erecord_id => p_child_erecords(i)
975: );
976: -- If any errors happen abort API.
977: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
980: l_wrong_child_id := p_child_erecords(i);
981: RAISE CHILD_ERECORD_ID_ERROR;

Line 978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

974: p_erecord_id => p_child_erecords(i)
975: );
976: -- If any errors happen abort API.
977: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
980: l_wrong_child_id := p_child_erecords(i);
981: RAISE CHILD_ERECORD_ID_ERROR;
982: END IF;

Line 979: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

975: );
976: -- If any errors happen abort API.
977: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
980: l_wrong_child_id := p_child_erecords(i);
981: RAISE CHILD_ERECORD_ID_ERROR;
982: END IF;
983:

Line 995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

991: x_msg_data => l_msg_data,
992: p_erecord_id => p_child_erecords(i)
993: );
994: -- If any errors happen abort API.
995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
998: l_wrong_child_id := p_child_erecords(i);
999: RAISE CHILD_ERECORD_ID_ERROR;

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: p_erecord_id => p_child_erecords(i)
993: );
994: -- If any errors happen abort API.
995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
998: l_wrong_child_id := p_child_erecords(i);
999: RAISE CHILD_ERECORD_ID_ERROR;
1000: END IF;

Line 997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

993: );
994: -- If any errors happen abort API.
995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
998: l_wrong_child_id := p_child_erecords(i);
999: RAISE CHILD_ERECORD_ID_ERROR;
1000: END IF;
1001:

Line 1033: p_init_msg_list => FND_API.G_FALSE,

1029:
1030: --Call raise event with the parameter list as the argument.
1031: EDR_ERES_EVENT_PVT.RAISE_EVENT
1032: ( p_api_version => 1.0,
1033: p_init_msg_list => FND_API.G_FALSE,
1034: p_validation_level => p_validation_level,
1035: x_return_status => l_return_status,
1036: x_msg_count => l_msg_count,
1037: x_msg_data => l_msg_data,

Line 1048: p_init_msg_list => FND_API.G_FALSE,

1044:
1045: -- raise the event
1046: EDR_ERES_EVENT_PVT.RAISE_EVENT
1047: ( p_api_version => 1.0,
1048: p_init_msg_list => FND_API.G_FALSE,
1049: p_validation_level => p_validation_level,
1050: x_return_status => l_return_status,
1051: x_msg_count => l_msg_count,
1052: x_msg_data => l_msg_data,

Line 1061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1057: end if;
1058: --Bug 4122622: End
1059:
1060: -- If any errors happen abort API.
1061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1058: --Bug 4122622: End
1059:
1060: -- If any errors happen abort API.
1061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:

Line 1063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1059:
1060: -- If any errors happen abort API.
1061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:
1067: -- inter event: proceed only if the event has been raised

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060: -- If any errors happen abort API.
1061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:
1067: -- inter event: proceed only if the event has been raised
1068: -- successfully and erecord created

Line 1123: p_init_msg_list => FND_API.G_FALSE ,

1119: /* SKARIMIS . Added condition to post relation only if l_parent_erecord_id in > 0 */
1120: IF nvl(l_parent_erecord_id,-1) > 0 THEN
1121: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1122: ( p_api_version => 1.0 ,
1123: p_init_msg_list => FND_API.G_FALSE ,
1124: p_commit => FND_API.G_FALSE ,
1125: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1126: x_return_status => l_return_status ,
1127: x_msg_count => l_msg_count ,

Line 1124: p_commit => FND_API.G_FALSE ,

1120: IF nvl(l_parent_erecord_id,-1) > 0 THEN
1121: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1122: ( p_api_version => 1.0 ,
1123: p_init_msg_list => FND_API.G_FALSE ,
1124: p_commit => FND_API.G_FALSE ,
1125: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1126: x_return_status => l_return_status ,
1127: x_msg_count => l_msg_count ,
1128: x_msg_data => l_msg_data ,

Line 1125: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

1121: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1122: ( p_api_version => 1.0 ,
1123: p_init_msg_list => FND_API.G_FALSE ,
1124: p_commit => FND_API.G_FALSE ,
1125: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1126: x_return_status => l_return_status ,
1127: x_msg_count => l_msg_count ,
1128: x_msg_data => l_msg_data ,
1129: P_PARENT_ERECORD_ID => l_parent_erecord_id ,

Line 1139: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1135: X_RELATIONSHIP_ID => l_relationship_id
1136: );
1137:
1138: -- If any errors happen abort API.
1139: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;

Line 1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1136: );
1137:
1138: -- If any errors happen abort API.
1139: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;

Line 1141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1137:
1138: -- If any errors happen abort API.
1139: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;
1145: end if; --end of the if for child event

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: -- If any errors happen abort API.
1139: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;
1145: end if; --end of the if for child event
1146:

Line 1158: p_init_msg_list => FND_API.G_FALSE,

1154: while i is not null loop
1155:
1156: GET_EVENT_DETAILS
1157: ( p_api_version => 1.0,
1158: p_init_msg_list => FND_API.G_FALSE,
1159: x_return_status => l_return_status,
1160: x_msg_count => l_msg_count,
1161: x_msg_data => l_msg_data,
1162: p_erecord_id => p_child_erecords(i),

Line 1168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1164: x_event_key => l_child_event_key
1165: );
1166:
1167: -- If any errors happen abort API.
1168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;

Line 1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1165: );
1166:
1167: -- If any errors happen abort API.
1168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173:

Line 1170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1166:
1167: -- If any errors happen abort API.
1168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173:
1174: -- now that we know its an inter event mode and we

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: -- If any errors happen abort API.
1168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173:
1174: -- now that we know its an inter event mode and we
1175: -- have all the information to create the relationship

Line 1184: p_init_msg_list => FND_API.G_FALSE ,

1180: -- no need for validation of parent as its anyhow valid
1181:
1182: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1183: ( p_api_version => 1.0 ,
1184: p_init_msg_list => FND_API.G_FALSE ,
1185: p_commit => FND_API.G_FALSE ,
1186: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1187: x_return_status => l_return_status ,
1188: x_msg_count => l_msg_count ,

Line 1185: p_commit => FND_API.G_FALSE ,

1181:
1182: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1183: ( p_api_version => 1.0 ,
1184: p_init_msg_list => FND_API.G_FALSE ,
1185: p_commit => FND_API.G_FALSE ,
1186: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1187: x_return_status => l_return_status ,
1188: x_msg_count => l_msg_count ,
1189: x_msg_data => l_msg_data ,

Line 1186: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

1182: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1183: ( p_api_version => 1.0 ,
1184: p_init_msg_list => FND_API.G_FALSE ,
1185: p_commit => FND_API.G_FALSE ,
1186: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1187: x_return_status => l_return_status ,
1188: x_msg_count => l_msg_count ,
1189: x_msg_data => l_msg_data ,
1190: P_PARENT_ERECORD_ID => x_event.erecord_id ,

Line 1200: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1196: X_RELATIONSHIP_ID => l_relationship_id
1197: );
1198:
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;

Line 1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1197: );
1198:
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;
1205:

Line 1202: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1198:
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;
1205:
1206: i := p_child_erecords.NEXT(i);

Line 1203: RAISE FND_API.G_EXC_ERROR;

1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;
1205:
1206: i := p_child_erecords.NEXT(i);
1207: end loop;

Line 1223: WHEN FND_API.G_EXC_ERROR THEN

1219: p_data => x_msg_data
1220: );
1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: --no need to set the event status its been set
1225: --in the called API
1226: x_return_status := FND_API.G_RET_STS_ERROR ;
1227:

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR ;

1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: --no need to set the event status its been set
1225: --in the called API
1226: x_return_status := FND_API.G_RET_STS_ERROR ;
1227:
1228: FND_MSG_PUB.Count_And_Get
1229: ( p_count => x_msg_count ,
1230: p_data => x_msg_data

Line 1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1230: p_data => x_msg_data
1231: );
1232:
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: -- in case of unexpected errors. no need to manipulate the
1236: -- return status. the product teams should do an unqualified
1237: -- rollback
1238:

Line 1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1235: -- in case of unexpected errors. no need to manipulate the
1236: -- return status. the product teams should do an unqualified
1237: -- rollback
1238:
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1240:
1241: FND_MSG_PUB.Count_And_Get
1242: ( p_count => x_msg_count ,
1243: p_data => x_msg_data

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: );
1245:
1246: --Bug 4122622: Start
1247: WHEN CHILD_ERECORD_ID_ERROR THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: fnd_message.set_name('EDR','EDR_VAL_INVALID_CHILD_ID');
1250: fnd_message.set_token('ERECORD_ID', l_wrong_child_id);
1251: l_mesg_text := fnd_message.get();
1252: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

Line 1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1262: -- in case of unexpected errors. no need to manipulate the
1263: -- return status. the product teams should do an unqualified
1264: -- rollback
1265:
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1267:
1268: IF FND_MSG_PUB.Check_Msg_Level
1269: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1270: THEN

Line 1358: p_init_msg_list => FND_API.G_FALSE,

1354:
1355: if l_parent_erecord_id is not null and l_parent_erecord_id = EDR_CONSTANTS_GRP.G_DEFAULT_CHAR_ID_VALUE then
1356: GET_ERECORD_ID
1357: ( p_api_version => 1.0,
1358: p_init_msg_list => FND_API.G_FALSE,
1359: x_return_status => l_return_status,
1360: x_msg_count => l_msg_count,
1361: x_msg_data => l_msg_data,
1362: p_events => p_events,

Line 1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1365: x_erecord_id => l_parent_erecord
1366: );
1367:
1368: -- If any errors happen abort API.
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;

Line 1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1366: );
1367:
1368: -- If any errors happen abort API.
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:

Line 1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1367:
1368: -- If any errors happen abort API.
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375:

Line 1372: RAISE FND_API.G_EXC_ERROR;

1368: -- If any errors happen abort API.
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375:
1376: if l_parent_erecord is not null and l_parent_erecord <> EDR_CONSTANTS_GRP.G_DEFAULT_NUM_PARAM_VALUE

Line 1502: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1498: j pls_integer;
1499:
1500: BEGIN
1501: -- Standard call to check for call compatibility.
1502: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1503: p_api_version ,
1504: l_api_name ,
1505: G_PKG_NAME )
1506: THEN

Line 1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1503: p_api_version ,
1504: l_api_name ,
1505: G_PKG_NAME )
1506: THEN
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.
1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.
1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1512: FND_MSG_PUB.initialize;
1513: END IF;
1514:
1515: -- Initialize API return status to success

Line 1516: x_return_status := FND_API.G_RET_STS_SUCCESS;

1512: FND_MSG_PUB.initialize;
1513: END IF;
1514:
1515: -- Initialize API return status to success
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: -- API Body
1519:
1520: --valiadate all the payloads only then start another loop

Line 1523: if (p_validation_level > FND_API.G_VALID_LEVEL_NONE) then

1519:
1520: --valiadate all the payloads only then start another loop
1521: --to raise the events and so forth
1522:
1523: if (p_validation_level > FND_API.G_VALID_LEVEL_NONE) then
1524: i := x_events.FIRST;
1525: while i is not null loop
1526:
1527: --Bug 3136403: Start

Line 1536: p_init_msg_list => FND_API.G_FALSE,

1532: );
1533:
1534: VALIDATE_PAYLOAD
1535: ( p_api_version => 1.0 ,
1536: p_init_msg_list => FND_API.G_FALSE,
1537: x_return_status => l_return_status ,
1538: x_msg_count => l_msg_count ,
1539: x_msg_data => l_msg_data ,
1540: p_event_name => x_events(i).event_name,

Line 1549: p_init_msg_list => FND_API.G_FALSE,

1545:
1546: /*
1547: VALIDATE_PAYLOAD
1548: ( p_api_version => 1.0 ,
1549: p_init_msg_list => FND_API.G_FALSE,
1550: x_return_status => l_return_status ,
1551: x_msg_count => l_msg_count ,
1552: x_msg_data => l_msg_data ,
1553: p_event_name => x_events(i).event_name,

Line 1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1558: */
1559: --Bug 3136403: End
1560:
1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1563: THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN

Line 1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1560:
1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1563: THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;

Line 1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1563: THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569:

Line 1567: RAISE FND_API.G_EXC_ERROR;

1563: THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1570: i := x_events.NEXT(i);
1571: end loop;

Line 1599: p_init_msg_list => FND_API.G_FALSE ,

1595: --the validation level to none
1596:
1597: EDR_ERES_EVENT_PVT.RAISE_EVENT
1598: ( p_api_version => 1.0 ,
1599: p_init_msg_list => FND_API.G_FALSE ,
1600: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1601: x_return_status => l_return_status ,
1602: x_msg_count => l_msg_count ,
1603: x_msg_data => l_msg_data ,

Line 1600: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

1596:
1597: EDR_ERES_EVENT_PVT.RAISE_EVENT
1598: ( p_api_version => 1.0 ,
1599: p_init_msg_list => FND_API.G_FALSE ,
1600: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1601: x_return_status => l_return_status ,
1602: x_msg_count => l_msg_count ,
1603: x_msg_data => l_msg_data ,
1604: x_event => x_events(i) ,

Line 1614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1610: --Bug 4122622: End
1611: );
1612:
1613: -- If any errors happen abort API.
1614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1617: RAISE FND_API.G_EXC_ERROR;
1618: END IF;

Line 1615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1611: );
1612:
1613: -- If any errors happen abort API.
1614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1617: RAISE FND_API.G_EXC_ERROR;
1618: END IF;
1619:

Line 1616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1612:
1613: -- If any errors happen abort API.
1614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1617: RAISE FND_API.G_EXC_ERROR;
1618: END IF;
1619:
1620: --child event: now do processing in case this is a child event

Line 1617: RAISE FND_API.G_EXC_ERROR;

1613: -- If any errors happen abort API.
1614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1617: RAISE FND_API.G_EXC_ERROR;
1618: END IF;
1619:
1620: --child event: now do processing in case this is a child event
1621: --in an inter event context

Line 1699: p_init_msg_list => FND_API.G_FALSE ,

1695: then
1696:
1697: GET_ERECORD_ID
1698: ( p_api_version => 1.0,
1699: p_init_msg_list => FND_API.G_FALSE ,
1700: x_return_status => l_return_status ,
1701: x_msg_count => l_msg_count ,
1702: x_msg_data => l_msg_data ,
1703: p_events => x_events ,

Line 1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1708:
1709: end if;
1710:
1711: -- If any errors happen abort API.
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;

Line 1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1709: end if;
1710:
1711: -- If any errors happen abort API.
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:

Line 1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1710:
1711: -- If any errors happen abort API.
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: -- insert a row in the event relationship table

Line 1715: RAISE FND_API.G_EXC_ERROR;

1711: -- If any errors happen abort API.
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: -- insert a row in the event relationship table
1719: -- we still need to do the validation

Line 1727: p_init_msg_list => FND_API.G_FALSE ,

1723: IF NVL(l_inter_event_tbl(i).child_erecord_id, -1) <> -1 AND
1724: NVL(l_inter_event_tbl(i).parent_erecord_id, -1) <> -1 THEN
1725: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1726: (p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE ,
1728: p_commit => FND_API.G_FALSE ,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1730: x_return_status => l_return_status ,
1731: x_msg_count => l_msg_count ,

Line 1728: p_commit => FND_API.G_FALSE ,

1724: NVL(l_inter_event_tbl(i).parent_erecord_id, -1) <> -1 THEN
1725: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1726: (p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE ,
1728: p_commit => FND_API.G_FALSE ,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1730: x_return_status => l_return_status ,
1731: x_msg_count => l_msg_count ,
1732: x_msg_data => l_msg_data ,

Line 1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

1725: EDR_EVENT_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
1726: (p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE ,
1728: p_commit => FND_API.G_FALSE ,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1730: x_return_status => l_return_status ,
1731: x_msg_count => l_msg_count ,
1732: x_msg_data => l_msg_data ,
1733: P_PARENT_ERECORD_ID => l_inter_event_tbl(i).parent_erecord_id ,

Line 1744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1740: );
1741: END IF;
1742:
1743: -- If any errors happen abort API.
1744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;

Line 1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1741: END IF;
1742:
1743: -- If any errors happen abort API.
1744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;
1749:

Line 1746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1742:
1743: -- If any errors happen abort API.
1744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;
1749:
1750: end loop;

Line 1747: RAISE FND_API.G_EXC_ERROR;

1743: -- If any errors happen abort API.
1744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;
1749:
1750: end loop;
1751:

Line 1765: WHEN FND_API.G_EXC_ERROR THEN

1761: p_data => x_msg_data
1762: );
1763:
1764: EXCEPTION
1765: WHEN FND_API.G_EXC_ERROR THEN
1766: x_overall_status := EDR_CONSTANTS_GRP.g_error_status;
1767: x_return_status := FND_API.G_RET_STS_ERROR ;
1768:
1769: FND_MSG_PUB.Count_And_Get

Line 1767: x_return_status := FND_API.G_RET_STS_ERROR ;

1763:
1764: EXCEPTION
1765: WHEN FND_API.G_EXC_ERROR THEN
1766: x_overall_status := EDR_CONSTANTS_GRP.g_error_status;
1767: x_return_status := FND_API.G_RET_STS_ERROR ;
1768:
1769: FND_MSG_PUB.Count_And_Get
1770: ( p_count => x_msg_count ,
1771: p_data => x_msg_data

Line 1774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1770: ( p_count => x_msg_count ,
1771: p_data => x_msg_data
1772: );
1773:
1774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1775: -- no need to manipulate the overall status. product teams should
1776: -- do an unqualified rollback on getting this exception
1777:
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1775: -- no need to manipulate the overall status. product teams should
1776: -- do an unqualified rollback on getting this exception
1777:
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1779:
1780: FND_MSG_PUB.Count_And_Get
1781: ( p_count => x_msg_count ,
1782: p_data => x_msg_data

Line 1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1785: WHEN OTHERS THEN
1786: -- no need to manipulate the overall status. product teams should
1787: -- do an unqualified rollback on getting this exception
1788:
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1790:
1791: IF FND_MSG_PUB.Check_Msg_Level
1792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1793: THEN

Line 1827: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1823:
1824: i pls_integer;
1825: BEGIN
1826: -- Standard call to check for call compatibility.
1827: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1828: p_api_version ,
1829: l_api_name ,
1830: G_PKG_NAME )
1831: THEN

Line 1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1828: p_api_version ,
1829: l_api_name ,
1830: G_PKG_NAME )
1831: THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:
1835: -- Initialize message list if p_init_msg_list is set to TRUE.
1836: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1836: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:
1835: -- Initialize message list if p_init_msg_list is set to TRUE.
1836: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1837: FND_MSG_PUB.initialize;
1838: END IF;
1839:
1840: -- Initialize API return status to success

Line 1841: x_return_status := FND_API.G_RET_STS_SUCCESS;

1837: FND_MSG_PUB.initialize;
1838: END IF;
1839:
1840: -- Initialize API return status to success
1841: x_return_status := FND_API.G_RET_STS_SUCCESS;
1842:
1843: -- API Body
1844:
1845: i := p_events.FIRST;

Line 1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1859: p_data => x_msg_data
1860: );
1861:
1862: EXCEPTION
1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865:
1866: FND_MSG_PUB.Count_And_Get
1867: ( p_count => x_msg_count ,

Line 1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1860: );
1861:
1862: EXCEPTION
1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865:
1866: FND_MSG_PUB.Count_And_Get
1867: ( p_count => x_msg_count ,
1868: p_data => x_msg_data

Line 1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1868: p_data => x_msg_data
1869: );
1870:
1871: WHEN OTHERS THEN
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873:
1874: IF FND_MSG_PUB.Check_Msg_Level
1875: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1876: THEN