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.AMS_TRIG_PVT dependencies on FND_API

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

42: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Calculate_System_Time(
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: x_msg_count OUT NOCOPY NUMBER ,
48: x_msg_data OUT NOCOPY VARCHAR2 ,
49: x_return_status OUT NOCOPY VARCHAR2 ,
50:

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

79: -- End of Comments
80:
81: PROCEDURE Create_Trigger
82: ( p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,

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

80:
81: PROCEDURE Create_Trigger
82: ( p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,

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

81: PROCEDURE Create_Trigger
82: ( p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,

Line 138: IF FND_API.to_boolean(p_init_msg_list) THEN

134: AMS_Utility_PVT.debug_message(l_full_name||': start');
135:
136: END IF;
137:
138: IF FND_API.to_boolean(p_init_msg_list) THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: --

Line 145: IF NOT FND_API.Compatible_API_Call ( l_api_version,

141:
142: --
143: -- Standard call to check for call compatibility.
144: --
145: IF NOT FND_API.Compatible_API_Call ( l_api_version,
146: p_api_version,
147: l_api_name,
148: G_PKG_NAME)
149: THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: p_api_version,
147: l_api_name,
148: G_PKG_NAME)
149: THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: --
154: -- Initialize API return status to success

Line 156: x_return_status := FND_API.G_RET_STS_SUCCESS;

152:
153: --
154: -- Initialize API return status to success
155: --
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: --
159: -- API body
160: --

Line 188: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

184:
185: --
186: -- If any errors happen abort API.
187: --
188: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
189: RAISE FND_API.G_EXC_ERROR;
190: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;

Line 189: RAISE FND_API.G_EXC_ERROR;

185: --
186: -- If any errors happen abort API.
187: --
188: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
189: RAISE FND_API.G_EXC_ERROR;
190: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:

Line 190: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

186: -- If any errors happen abort API.
187: --
188: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
189: RAISE FND_API.G_EXC_ERROR;
190: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Following code is added by ptendulk on 26 Apr 2000 Give call to

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: --
188: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
189: RAISE FND_API.G_EXC_ERROR;
190: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Following code is added by ptendulk on 26 Apr 2000 Give call to
195: -- Calculate System time api which will calculate the system date

Line 212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

208:
209: --
210: -- If any errors happen abort API.
211: --
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;

Line 213: RAISE FND_API.G_EXC_ERROR;

209: --
210: -- If any errors happen abort API.
211: --
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:

Line 214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

210: -- If any errors happen abort API.
211: --
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: --

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: --
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: --
219: -- Insert the Record

Line 233: IF l_trig_rec.trigger_id IS NULL OR l_trig_rec.trigger_id = FND_API.G_MISS_NUM

229:
230: --
231: -- Find Unique Trigger ID if not sent
232: --
233: IF l_trig_rec.trigger_id IS NULL OR l_trig_rec.trigger_id = FND_API.G_MISS_NUM
234: THEN
235: LOOP
236: OPEN c_trig_seq;
237: FETCH c_trig_seq INTO l_trig_rec.trigger_id;

Line 412: -- p_init_msg_list => FND_API.g_false,

408: -- indicate schedule has been defined for the campaign
409: --IF l_trig_rec.arc_trigger_created_for <> 'AMET' THEN
410: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
411: -- p_api_version => l_api_version,
412: -- p_init_msg_list => FND_API.g_false,
413: -- p_commit => FND_API.g_false,
414: -- p_validation_level => FND_API.g_valid_level_full,
415: -- x_return_status => l_return_status,
416: -- x_msg_count => x_msg_count,

Line 413: -- p_commit => FND_API.g_false,

409: --IF l_trig_rec.arc_trigger_created_for <> 'AMET' THEN
410: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
411: -- p_api_version => l_api_version,
412: -- p_init_msg_list => FND_API.g_false,
413: -- p_commit => FND_API.g_false,
414: -- p_validation_level => FND_API.g_valid_level_full,
415: -- x_return_status => l_return_status,
416: -- x_msg_count => x_msg_count,
417: -- x_msg_data => x_msg_data,

Line 414: -- p_validation_level => FND_API.g_valid_level_full,

410: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
411: -- p_api_version => l_api_version,
412: -- p_init_msg_list => FND_API.g_false,
413: -- p_commit => FND_API.g_false,
414: -- p_validation_level => FND_API.g_valid_level_full,
415: -- x_return_status => l_return_status,
416: -- x_msg_count => x_msg_count,
417: -- x_msg_data => x_msg_data,
418:

Line 424: -- IF l_return_status = FND_API.g_ret_sts_error THEN

420: -- p_object_id => l_trig_rec.trigger_created_for_id,
421: -- p_attr => 'TRIG',
422: -- p_attr_defined_flag => 'Y' );
423: --
424: -- IF l_return_status = FND_API.g_ret_sts_error THEN
425: -- RAISE FND_API.g_exc_error;
426: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
427: -- RAISE FND_API.g_exc_unexpected_error;
428: -- END IF;

Line 425: -- RAISE FND_API.g_exc_error;

421: -- p_attr => 'TRIG',
422: -- p_attr_defined_flag => 'Y' );
423: --
424: -- IF l_return_status = FND_API.g_ret_sts_error THEN
425: -- RAISE FND_API.g_exc_error;
426: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
427: -- RAISE FND_API.g_exc_unexpected_error;
428: -- END IF;
429:

Line 426: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

422: -- p_attr_defined_flag => 'Y' );
423: --
424: -- IF l_return_status = FND_API.g_ret_sts_error THEN
425: -- RAISE FND_API.g_exc_error;
426: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
427: -- RAISE FND_API.g_exc_unexpected_error;
428: -- END IF;
429:
430: --END IF;

Line 427: -- RAISE FND_API.g_exc_unexpected_error;

423: --
424: -- IF l_return_status = FND_API.g_ret_sts_error THEN
425: -- RAISE FND_API.g_exc_error;
426: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
427: -- RAISE FND_API.g_exc_unexpected_error;
428: -- END IF;
429:
430: --END IF;
431:

Line 442: IF FND_API.To_Boolean ( p_commit )

438: -- END of API body.
439: --
440:
441: -- Standard check of p_commit.
442: IF FND_API.To_Boolean ( p_commit )
443: THEN
444: COMMIT WORK;
445: END IF;
446:

Line 453: p_encoded => FND_API.G_FALSE

449: --
450: FND_MSG_PUB.Count_AND_Get
451: ( p_count => x_msg_count,
452: p_data => x_msg_data,
453: p_encoded => FND_API.G_FALSE
454: );
455:
456: IF (AMS_DEBUG_HIGH_ON) THEN
457:

Line 466: WHEN FND_API.G_EXC_ERROR THEN

462: END IF;
463:
464: EXCEPTION
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467:
468: ROLLBACK TO Create_Trig_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470:

Line 469: x_return_status := FND_API.G_RET_STS_ERROR ;

465:
466: WHEN FND_API.G_EXC_ERROR THEN
467:
468: ROLLBACK TO Create_Trig_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470:
471: FND_MSG_PUB.Count_AND_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data,

Line 474: p_encoded => FND_API.G_FALSE

470:
471: FND_MSG_PUB.Count_AND_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476:
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

474: p_encoded => FND_API.G_FALSE
475: );
476:
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479:
480: ROLLBACK TO Create_Trig_PVT;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482:

Line 481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479:
480: ROLLBACK TO Create_Trig_PVT;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482:
483: FND_MSG_PUB.Count_AND_Get
484: ( p_count => x_msg_count,
485: p_data => x_msg_data,

Line 486: p_encoded => FND_API.G_FALSE

482:
483: FND_MSG_PUB.Count_AND_Get
484: ( p_count => x_msg_count,
485: p_data => x_msg_data,
486: p_encoded => FND_API.G_FALSE
487: );
488:
489: WHEN OTHERS THEN
490:

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

488:
489: WHEN OTHERS THEN
490:
491: ROLLBACK TO Create_Trig_PVT;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493:
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 502: p_encoded => FND_API.G_FALSE

498:
499: FND_MSG_PUB.Count_AND_Get
500: ( p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => FND_API.G_FALSE
503: );
504: END Create_Trigger;
505:
506: -- Start of Comments

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

541: -- End of Comments
542:
543: PROCEDURE Delete_Trigger
544: ( p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_commit IN VARCHAR2 := FND_API.G_FALSE,
547:
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,

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

542:
543: PROCEDURE Delete_Trigger
544: ( p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_commit IN VARCHAR2 := FND_API.G_FALSE,
547:
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,

Line 603: IF FND_API.to_Boolean( p_init_msg_list ) THEN

599: -- dbms_output.put_line(p_trigger_id);
600: --
601: -- Initialize message list IF p_init_msg_list is set to TRUE.
602: --
603: IF FND_API.to_Boolean( p_init_msg_list ) THEN
604: FND_MSG_PUB.initialize;
605: END IF;
606:
607: --

Line 610: IF NOT FND_API.Compatible_API_Call ( l_api_version,

606:
607: --
608: -- Standard call to check for call compatibility.
609: --
610: IF NOT FND_API.Compatible_API_Call ( l_api_version,
611: p_api_version,
612: l_api_name,
613: G_PKG_NAME)
614: THEN

Line 615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

611: p_api_version,
612: l_api_name,
613: G_PKG_NAME)
614: THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617:
618: --
619: -- Initialize API return status to success

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617:
618: --
619: -- Initialize API return status to success
620: --
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --
624: -- Debug Message
625: --

Line 665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

661: );
662: IF l_assoc_sch>0 THEN -- if exist schedule(s) associated with this triggerId
663: -- throw error msg
664: AMS_Utility_PVT.Error_Message('AMS_TRIG_NO_DEL_CSC_ASSOC');
665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
666:
667: ELSE -- no schedules are associated with this trigger
668: AMS_Utility_PVT.Create_Log (
669: x_return_status => l_return_status,

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678: DELETE FROM AMS_triggers_tl
679: WHERE trigger_id = p_trigger_id ;
680: IF (SQL%NOTFOUND) THEN
681: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684: AMS_Utility_PVT.Create_Log (
685: x_return_status => l_return_status,
686: p_arc_log_used_by => 'TRIG',

Line 698: RAISE FND_API.G_EXC_ERROR;

694: AND object_version_number = p_object_version_number ;
695:
696: IF (SQL%NOTFOUND) THEN
697: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
698: RAISE FND_API.G_EXC_ERROR;
699: ELSE
700: -- Delete the Checks and Actions Attached to the Trigger
701: DELETE FROM ams_trigger_checks
702: WHERE trigger_id = p_trigger_id ;

Line 713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

709:
710: ELSE -- if trigger has started
711: -- throw error msg
712: AMS_Utility_PVT.Error_Message('AMS_TRIG_NO_DEL_TRIG_ACTIVE');
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714:
715:
716: END IF;
717: END IF;

Line 727: IF FND_API.To_Boolean ( p_commit )

723: --
724: -- Standard check of p_commit.
725: --
726: -- dbms_output.put_line('commit : '||p_commit);
727: IF FND_API.To_Boolean ( p_commit )
728: THEN
729: COMMIT WORK;
730: END IF;
731:

Line 738: p_encoded => FND_API.G_FALSE

734: --
735: FND_MSG_PUB.Count_AND_Get
736: ( p_count => x_msg_count,
737: p_data => x_msg_data,
738: p_encoded => FND_API.G_FALSE
739: );
740:
741: --
742: -- Debug message

Line 751: WHEN FND_API.G_EXC_ERROR THEN

747: END IF;
748:
749: EXCEPTION
750:
751: WHEN FND_API.G_EXC_ERROR THEN
752:
753: ROLLBACK TO Delete_Trig_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:

Line 754: x_return_status := FND_API.G_RET_STS_ERROR ;

750:
751: WHEN FND_API.G_EXC_ERROR THEN
752:
753: ROLLBACK TO Delete_Trig_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:
756: FND_MSG_PUB.Count_AND_Get
757: ( p_count => x_msg_count,
758: p_data => x_msg_data,

Line 759: p_encoded => FND_API.G_FALSE

755:
756: FND_MSG_PUB.Count_AND_Get
757: ( p_count => x_msg_count,
758: p_data => x_msg_data,
759: p_encoded => FND_API.G_FALSE
760: );
761:
762:
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

759: p_encoded => FND_API.G_FALSE
760: );
761:
762:
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764:
765: ROLLBACK TO Delete_Trig_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

762:
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764:
765: ROLLBACK TO Delete_Trig_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:
768: FND_MSG_PUB.Count_AND_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data,

Line 771: p_encoded => FND_API.G_FALSE

767:
768: FND_MSG_PUB.Count_AND_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data,
771: p_encoded => FND_API.G_FALSE
772: );
773:
774:
775: WHEN OTHERS THEN

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

774:
775: WHEN OTHERS THEN
776:
777: ROLLBACK TO Delete_Trig_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
781: THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 788: p_encoded => FND_API.G_FALSE

784:
785: FND_MSG_PUB.Count_AND_Get
786: ( p_count => x_msg_count,
787: p_data => x_msg_data,
788: p_encoded => FND_API.G_FALSE
789: );
790:
791: END Delete_Trigger;
792:

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

807: -- End of Comments
808:
809: PROCEDURE Lock_Trigger
810: ( p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
812:
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,

Line 856: IF FND_API.to_Boolean( p_init_msg_list ) THEN

852:
853: --
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: --
856: IF FND_API.to_Boolean( p_init_msg_list ) THEN
857: FND_MSG_PUB.initialize;
858: END IF;
859:
860: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 860: IF NOT FND_API.Compatible_API_Call ( l_api_version,

856: IF FND_API.to_Boolean( p_init_msg_list ) THEN
857: FND_MSG_PUB.initialize;
858: END IF;
859:
860: IF NOT FND_API.Compatible_API_Call ( l_api_version,
861: p_api_version,
862: l_api_name,
863: G_PKG_NAME)
864: THEN

Line 865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

861: p_api_version,
862: l_api_name,
863: G_PKG_NAME)
864: THEN
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: END IF;
867:
868: --
869: -- Initialize API return status to success

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

867:
868: --
869: -- Initialize API return status to success
870: --
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: --
874: -- API body
875: --

Line 899: RAISE FND_API.G_EXC_ERROR;

895: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
896: FND_MSG_PUB.Add;
897: END IF;
898:
899: RAISE FND_API.G_EXC_ERROR;
900: END IF;
901: CLOSE C_ams_triggers;
902:
903: OPEN c_trig_tl ;

Line 916: p_encoded => FND_API.G_FALSE

912: --
913: FND_MSG_PUB.Count_AND_Get
914: ( p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE
917: );
918:
919: IF (AMS_DEBUG_HIGH_ON) THEN
920:

Line 928: WHEN FND_API.G_EXC_ERROR THEN

924:
925: END IF;
926:
927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR ;
930:
931: FND_MSG_PUB.Count_AND_Get
932: ( p_count => x_msg_count,

Line 929: x_return_status := FND_API.G_RET_STS_ERROR ;

925: END IF;
926:
927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR ;
930:
931: FND_MSG_PUB.Count_AND_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data,

Line 934: p_encoded => FND_API.G_FALSE

930:
931: FND_MSG_PUB.Count_AND_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => FND_API.G_FALSE
935: );
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
938:

Line 936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

932: ( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => FND_API.G_FALSE
935: );
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
938:
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

933: p_data => x_msg_data,
934: p_encoded => FND_API.G_FALSE
935: );
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
938:
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,

Line 942: p_encoded => FND_API.G_FALSE

938:
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,
942: p_encoded => FND_API.G_FALSE
943: );
944:
945: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

942: p_encoded => FND_API.G_FALSE
943: );
944:
945: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947:
948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
949: THEN -- MMSG
950: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');

Line 957: p_encoded => FND_API.G_FALSE

953:
954: FND_MSG_PUB.Count_AND_Get
955: ( p_count => x_msg_count,
956: p_data => x_msg_data,
957: p_encoded => FND_API.G_FALSE
958: );
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

957: p_encoded => FND_API.G_FALSE
958: );
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
964: THEN
965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 971: p_encoded => FND_API.G_FALSE

967:
968: FND_MSG_PUB.Count_AND_Get
969: ( p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE
972: );
973: END Lock_Trigger;
974:
975: -- Start of Comments

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

992: -- End of Comments
993:
994: PROCEDURE Update_Trigger
995: ( p_api_version IN NUMBER,
996: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
997: p_commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999:
1000: x_return_status OUT NOCOPY VARCHAR2,

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

993:
994: PROCEDURE Update_Trigger
995: ( p_api_version IN NUMBER,
996: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
997: p_commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999:
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,

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

994: PROCEDURE Update_Trigger
995: ( p_api_version IN NUMBER,
996: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
997: p_commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999:
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,

Line 1041: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1037:
1038: --
1039: -- Initialize message list IF p_init_msg_list is set to TRUE.
1040: --
1041: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044:
1045: --

Line 1048: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1044:
1045: --
1046: -- Standard call to check for call compatibility.
1047: --
1048: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1049: p_api_version,
1050: l_api_name,
1051: G_PKG_NAME)
1052: THEN

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049: p_api_version,
1050: l_api_name,
1051: G_PKG_NAME)
1052: THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: --
1057: -- Initialize API return status to success

Line 1059: x_return_status := FND_API.G_RET_STS_SUCCESS;

1055:
1056: --
1057: -- Initialize API return status to success
1058: --
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060:
1061: --
1062: -- API body
1063: --

Line 1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1076: p_validation_mode => JTF_PLSQL_API.g_update,
1077: x_return_status => l_return_status
1078: );
1079: --dbms_output.put_line('After Item Validation : '||l_return_status);
1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1081: RAISE FND_API.g_exc_unexpected_error;
1082: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1083: RAISE FND_API.g_exc_error;
1084: END IF;

Line 1081: RAISE FND_API.g_exc_unexpected_error;

1077: x_return_status => l_return_status
1078: );
1079: --dbms_output.put_line('After Item Validation : '||l_return_status);
1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1081: RAISE FND_API.g_exc_unexpected_error;
1082: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1083: RAISE FND_API.g_exc_error;
1084: END IF;
1085: END IF;

Line 1082: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1078: );
1079: --dbms_output.put_line('After Item Validation : '||l_return_status);
1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1081: RAISE FND_API.g_exc_unexpected_error;
1082: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1083: RAISE FND_API.g_exc_error;
1084: END IF;
1085: END IF;
1086:

Line 1083: RAISE FND_API.g_exc_error;

1079: --dbms_output.put_line('After Item Validation : '||l_return_status);
1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1081: RAISE FND_API.g_exc_unexpected_error;
1082: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1083: RAISE FND_API.g_exc_error;
1084: END IF;
1085: END IF;
1086:
1087: -- replace g_miss_char/num/date with current column values

Line 1097: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1093: p_complete_rec => l_trig_rec,
1094: x_return_status => l_return_status
1095: );
1096:
1097: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1098: RAISE FND_API.g_exc_unexpected_error;
1099: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1100: RAISE FND_API.g_exc_error;
1101: END IF;

Line 1098: RAISE FND_API.g_exc_unexpected_error;

1094: x_return_status => l_return_status
1095: );
1096:
1097: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1098: RAISE FND_API.g_exc_unexpected_error;
1099: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1100: RAISE FND_API.g_exc_error;
1101: END IF;
1102: END IF;

Line 1099: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1095: );
1096:
1097: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1098: RAISE FND_API.g_exc_unexpected_error;
1099: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1100: RAISE FND_API.g_exc_error;
1101: END IF;
1102: END IF;
1103:

Line 1100: RAISE FND_API.g_exc_error;

1096:
1097: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1098: RAISE FND_API.g_exc_unexpected_error;
1099: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1100: RAISE FND_API.g_exc_error;
1101: END IF;
1102: END IF;
1103:
1104: --dbms_output.put_line('After Validation : '||l_return_status);

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110:
1111: IF l_trig_det_rec.repeat_frequency_type = 'NONE' THEN
1112: IF l_trig_det_rec.last_run_date_time IS NOT NULL THEN
1113: AMS_Utility_PVT.Error_Message('AMS_TRIG_ERR_UPDT_TRIG_FIRED');
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: ELSE
1117: IF l_trig_det_rec.repeat_stop_date_time < SYSDATE THEN
1118: AMS_Utility_PVT.Error_Message('AMS_TRIG_ERR_UPDT_EXPIRED');

Line 1119: RAISE FND_API.G_EXC_ERROR;

1115: END IF;
1116: ELSE
1117: IF l_trig_det_rec.repeat_stop_date_time < SYSDATE THEN
1118: AMS_Utility_PVT.Error_Message('AMS_TRIG_ERR_UPDT_EXPIRED');
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;
1121: END IF;
1122:
1123: -- Following code is added by ptendulk on 26 Apr 2000 Give call to

Line 1187: RAISE FND_API.g_exc_error;

1183: AND object_version_number = l_trig_rec.object_version_number ;
1184:
1185: IF (SQL%NOTFOUND) THEN
1186: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1187: RAISE FND_API.g_exc_error;
1188: END IF;
1189:
1190: UPDATE ams_triggers_tl
1191: SET

Line 1205: RAISE FND_API.g_exc_error;

1201: -- security_group_id = l_trig_rec.security_group_id
1202: WHERE trigger_id = l_trig_rec.trigger_id ;
1203: IF (SQL%NOTFOUND) THEN
1204: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1205: RAISE FND_API.g_exc_error;
1206: END IF;
1207: --
1208: -- END of API body.
1209: --

Line 1214: IF FND_API.to_boolean(p_commit) THEN

1210:
1211: --
1212: -- Standard check of p_commit.
1213: --
1214: IF FND_API.to_boolean(p_commit) THEN
1215: COMMIT;
1216: END IF;
1217:
1218: --

Line 1222: p_encoded => FND_API.g_false,

1218: --
1219: -- Get message count AND IF count is 1, get message info.
1220: --
1221: FND_MSG_PUB.count_and_get(
1222: p_encoded => FND_API.g_false,
1223: p_count => x_msg_count,
1224: p_data => x_msg_data
1225: );
1226:

Line 1233: WHEN FND_API.G_EXC_ERROR THEN

1229: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1230: END IF;
1231:
1232: EXCEPTION
1233: WHEN FND_API.G_EXC_ERROR THEN
1234:
1235: ROLLBACK TO Update_Trig_PVT;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237:

Line 1236: x_return_status := FND_API.G_RET_STS_ERROR ;

1232: EXCEPTION
1233: WHEN FND_API.G_EXC_ERROR THEN
1234:
1235: ROLLBACK TO Update_Trig_PVT;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237:
1238: FND_MSG_PUB.Count_AND_Get
1239: ( p_count => x_msg_count,
1240: p_data => x_msg_data,

Line 1241: p_encoded => FND_API.G_FALSE

1237:
1238: FND_MSG_PUB.Count_AND_Get
1239: ( p_count => x_msg_count,
1240: p_data => x_msg_data,
1241: p_encoded => FND_API.G_FALSE
1242: );
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245:

Line 1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1240: p_data => x_msg_data,
1241: p_encoded => FND_API.G_FALSE
1242: );
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245:
1246: ROLLBACK TO Update_Trig_PVT;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245:
1246: ROLLBACK TO Update_Trig_PVT;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:
1249: FND_MSG_PUB.Count_AND_Get
1250: ( p_count => x_msg_count,
1251: p_data => x_msg_data,

Line 1252: p_encoded => FND_API.G_FALSE

1248:
1249: FND_MSG_PUB.Count_AND_Get
1250: ( p_count => x_msg_count,
1251: p_data => x_msg_data,
1252: p_encoded => FND_API.G_FALSE
1253: );
1254:
1255: WHEN OTHERS THEN
1256:

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1254:
1255: WHEN OTHERS THEN
1256:
1257: ROLLBACK TO Update_Trig_PVT;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259:
1260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1268: p_encoded => FND_API.G_FALSE

1264:
1265: FND_MSG_PUB.Count_AND_Get
1266: ( p_count => x_msg_count,
1267: p_data => x_msg_data,
1268: p_encoded => FND_API.G_FALSE
1269: );
1270: END Update_Trigger;
1271:
1272:

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

1287: -- 10/25/1999 ptendulk created
1288: -- 10-Dec-2002 ptendulk Modified the api parameters
1289: -- End of Comments
1290: PROCEDURE Calculate_System_Time(
1291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1292: x_msg_count OUT NOCOPY NUMBER ,
1293: x_msg_data OUT NOCOPY VARCHAR2 ,
1294: x_return_status OUT NOCOPY VARCHAR2 ,
1295:

Line 1307: IF px_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE

1303:
1304: BEGIN
1305: IF px_trig_rec.usage <> 'MONITOR' THEN
1306: -- USAGE IS TRIGGER
1307: IF px_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE
1308: THEN
1309: AMS_UTILITY_PVT.Convert_Timezone(
1310: p_init_msg_list => p_init_msg_list ,
1311: x_return_status => x_return_status ,

Line 1323: IF px_trig_rec.user_repeat_daily_start_time <> FND_API.G_MISS_DATE

1319: );
1320:
1321: END IF;
1322:
1323: IF px_trig_rec.user_repeat_daily_start_time <> FND_API.G_MISS_DATE
1324: THEN
1325: AMS_UTILITY_PVT.Convert_Timezone(
1326: p_init_msg_list => p_init_msg_list ,
1327: x_return_status => x_return_status ,

Line 1338: IF px_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE

1334: x_out_time => l_trig_rec.repeat_daily_start_time
1335: );
1336: END IF ;
1337:
1338: IF px_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE
1339: THEN
1340: AMS_UTILITY_PVT.Convert_Timezone(
1341: p_init_msg_list => p_init_msg_list ,
1342: x_return_status => x_return_status ,

Line 1353: IF px_trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE

1349: x_out_time => l_trig_rec.repeat_daily_end_time
1350: );
1351: END IF ;
1352:
1353: IF px_trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE
1354: THEN
1355: AMS_UTILITY_PVT.Convert_Timezone(
1356: p_init_msg_list => p_init_msg_list ,
1357: x_return_status => x_return_status ,

Line 1371: IF px_trig_rec.start_date_time <> FND_API.G_MISS_DATE

1367: END IF ;
1368: ELSE
1369: -- FOR MONITORS, THE TIMEZONE CONVERSION IS DONE BY OA.
1370: -- SO, THE REVERSE CONVERSION HAS TO BE DONE TO POPULATE user_date_time fields
1371: IF px_trig_rec.start_date_time <> FND_API.G_MISS_DATE
1372: THEN
1373: AMS_UTILITY_PVT.Convert_Timezone(
1374: p_init_msg_list => p_init_msg_list ,
1375: x_return_status => x_return_status ,

Line 1386: IF px_trig_rec.repeat_daily_start_time <> FND_API.G_MISS_DATE

1382: );
1383:
1384: END IF;
1385:
1386: IF px_trig_rec.repeat_daily_start_time <> FND_API.G_MISS_DATE
1387: THEN
1388: AMS_UTILITY_PVT.Convert_Timezone(
1389: p_init_msg_list => p_init_msg_list ,
1390: x_return_status => x_return_status ,

Line 1400: IF px_trig_rec.repeat_daily_end_time <> FND_API.G_MISS_DATE

1396: x_out_time => l_trig_rec.user_repeat_daily_start_time
1397: );
1398: END IF ;
1399:
1400: IF px_trig_rec.repeat_daily_end_time <> FND_API.G_MISS_DATE
1401: THEN
1402: AMS_UTILITY_PVT.Convert_Timezone(
1403: p_init_msg_list => p_init_msg_list ,
1404: x_return_status => x_return_status ,

Line 1414: IF px_trig_rec.repeat_stop_date_time <> FND_API.G_MISS_DATE

1410: x_out_time => l_trig_rec.user_repeat_daily_end_time
1411: );
1412: END IF ;
1413:
1414: IF px_trig_rec.repeat_stop_date_time <> FND_API.G_MISS_DATE
1415: THEN
1416: AMS_UTILITY_PVT.Convert_Timezone(
1417: p_init_msg_list => p_init_msg_list ,
1418: x_return_status => x_return_status ,

Line 1452: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1448: -- End of Comments
1449:
1450: PROCEDURE Validate_Trigger(
1451: p_api_version IN NUMBER,
1452: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1453: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2,
1456: x_msg_count OUT NOCOPY NUMBER,

Line 1453: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1449:
1450: PROCEDURE Validate_Trigger(
1451: p_api_version IN NUMBER,
1452: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1453: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2,
1456: x_msg_count OUT NOCOPY NUMBER,
1457: x_msg_data OUT NOCOPY VARCHAR2,

Line 1478: IF FND_API.to_boolean(p_init_msg_list) THEN

1474:
1475: AMS_Utility_PVT.debug_message(l_full_name||': start');
1476: END IF;
1477:
1478: IF FND_API.to_boolean(p_init_msg_list) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481:
1482: IF NOT FND_API.compatible_api_call(

Line 1482: IF NOT FND_API.compatible_api_call(

1478: IF FND_API.to_boolean(p_init_msg_list) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481:
1482: IF NOT FND_API.compatible_api_call(
1483: l_api_version,
1484: p_api_version,
1485: l_api_name,
1486: g_pkg_name

Line 1488: RAISE FND_API.g_exc_unexpected_error;

1484: p_api_version,
1485: l_api_name,
1486: g_pkg_name
1487: ) THEN
1488: RAISE FND_API.g_exc_unexpected_error;
1489: END IF;
1490:
1491: x_return_status := FND_API.g_ret_sts_success;
1492:

Line 1491: x_return_status := FND_API.g_ret_sts_success;

1487: ) THEN
1488: RAISE FND_API.g_exc_unexpected_error;
1489: END IF;
1490:
1491: x_return_status := FND_API.g_ret_sts_success;
1492:
1493: ---------------------- validate Trigger Items ------------------------
1494: --
1495: -- Debug Message

Line 1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1505: p_validation_mode => JTF_PLSQL_API.g_create,
1506: x_return_status => l_return_status
1507: );
1508: --dbms_output.put_line('Stat After Item : '||l_return_status);
1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1510: RAISE FND_API.g_exc_unexpected_error;
1511: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1512: RAISE FND_API.g_exc_error;
1513: END IF;

Line 1510: RAISE FND_API.g_exc_unexpected_error;

1506: x_return_status => l_return_status
1507: );
1508: --dbms_output.put_line('Stat After Item : '||l_return_status);
1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1510: RAISE FND_API.g_exc_unexpected_error;
1511: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1512: RAISE FND_API.g_exc_error;
1513: END IF;
1514: END IF;

Line 1511: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1507: );
1508: --dbms_output.put_line('Stat After Item : '||l_return_status);
1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1510: RAISE FND_API.g_exc_unexpected_error;
1511: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1512: RAISE FND_API.g_exc_error;
1513: END IF;
1514: END IF;
1515:

Line 1512: RAISE FND_API.g_exc_error;

1508: --dbms_output.put_line('Stat After Item : '||l_return_status);
1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1510: RAISE FND_API.g_exc_unexpected_error;
1511: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1512: RAISE FND_API.g_exc_error;
1513: END IF;
1514: END IF;
1515:
1516: ---------------------- validate Trigger Records ------------------------

Line 1532: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1528: p_complete_rec => NULL,
1529: x_return_status => l_return_status
1530: );
1531: --dbms_output.put_line('Stat After Record : '||l_return_status);
1532: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1533: RAISE FND_API.g_exc_unexpected_error;
1534: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1535: RAISE FND_API.g_exc_error;
1536: END IF;

Line 1533: RAISE FND_API.g_exc_unexpected_error;

1529: x_return_status => l_return_status
1530: );
1531: --dbms_output.put_line('Stat After Record : '||l_return_status);
1532: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1533: RAISE FND_API.g_exc_unexpected_error;
1534: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1535: RAISE FND_API.g_exc_error;
1536: END IF;
1537: END IF;

Line 1534: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1530: );
1531: --dbms_output.put_line('Stat After Record : '||l_return_status);
1532: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1533: RAISE FND_API.g_exc_unexpected_error;
1534: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1535: RAISE FND_API.g_exc_error;
1536: END IF;
1537: END IF;
1538:

Line 1535: RAISE FND_API.g_exc_error;

1531: --dbms_output.put_line('Stat After Record : '||l_return_status);
1532: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1533: RAISE FND_API.g_exc_unexpected_error;
1534: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1535: RAISE FND_API.g_exc_error;
1536: END IF;
1537: END IF;
1538:
1539: -------------------- finish --------------------------

Line 1541: p_encoded => FND_API.g_false,

1537: END IF;
1538:
1539: -------------------- finish --------------------------
1540: FND_MSG_PUB.count_and_get(
1541: p_encoded => FND_API.g_false,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data
1544: );
1545:

Line 1555: WHEN FND_API.g_exc_error THEN

1551:
1552: END IF;
1553:
1554: EXCEPTION
1555: WHEN FND_API.g_exc_error THEN
1556: x_return_status := FND_API.g_ret_sts_error;
1557: FND_MSG_PUB.count_and_get(
1558: p_encoded => FND_API.g_false,
1559: p_count => x_msg_count,

Line 1556: x_return_status := FND_API.g_ret_sts_error;

1552: END IF;
1553:
1554: EXCEPTION
1555: WHEN FND_API.g_exc_error THEN
1556: x_return_status := FND_API.g_ret_sts_error;
1557: FND_MSG_PUB.count_and_get(
1558: p_encoded => FND_API.g_false,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data

Line 1558: p_encoded => FND_API.g_false,

1554: EXCEPTION
1555: WHEN FND_API.g_exc_error THEN
1556: x_return_status := FND_API.g_ret_sts_error;
1557: FND_MSG_PUB.count_and_get(
1558: p_encoded => FND_API.g_false,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data
1561: );
1562:

Line 1563: WHEN FND_API.g_exc_unexpected_error THEN

1559: p_count => x_msg_count,
1560: p_data => x_msg_data
1561: );
1562:
1563: WHEN FND_API.g_exc_unexpected_error THEN
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,

Line 1564: x_return_status := FND_API.g_ret_sts_unexp_error ;

1560: p_data => x_msg_data
1561: );
1562:
1563: WHEN FND_API.g_exc_unexpected_error THEN
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data

Line 1566: p_encoded => FND_API.g_false,

1562:
1563: WHEN FND_API.g_exc_unexpected_error THEN
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data
1569: );
1570:

Line 1572: x_return_status := FND_API.g_ret_sts_unexp_error;

1568: p_data => x_msg_data
1569: );
1570:
1571: WHEN OTHERS THEN
1572: x_return_status := FND_API.g_ret_sts_unexp_error;
1573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1574: THEN
1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1576: END IF;

Line 1579: p_encoded => FND_API.g_false,

1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1576: END IF;
1577:
1578: FND_MSG_PUB.count_and_get(
1579: p_encoded => FND_API.g_false,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data
1582: );
1583:

Line 1611: x_return_status := FND_API.G_Ret_Sts_Success;

1607: ) IS
1608:
1609: BEGIN
1610: -- Initialize API/Procedure return status to success
1611: x_return_status := FND_API.G_Ret_Sts_Success;
1612: --
1613: -- Trigger Created For ID
1614: --
1615: IF p_trig_rec.trigger_created_for_id IS NULL

Line 1619: x_return_status := FND_API.G_RET_STS_ERROR;

1615: IF p_trig_rec.trigger_created_for_id IS NULL
1616: THEN
1617: -- missing required field
1618: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_CREATED_FOR');
1619: x_return_status := FND_API.G_RET_STS_ERROR;
1620: -- If any errors happen abort API/Procedure.
1621: RETURN;
1622: END IF;
1623:

Line 1630: x_return_status := FND_API.G_RET_STS_ERROR;

1626: --
1627: IF p_trig_rec.arc_trigger_created_for IS NULL
1628: THEN
1629: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_CREATED_FOR');
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: -- If any errors happen abort API/Procedure.
1632: RETURN;
1633: END IF;
1634:

Line 1641: x_return_status := FND_API.G_RET_STS_ERROR;

1637: --
1638: IF p_trig_rec.triggering_type IS NULL
1639: THEN
1640: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_TRIG_TYPE');
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: -- If any errors happen abort API/Procedure.
1643: RETURN;
1644: END IF;
1645:

Line 1652: x_return_status := FND_API.G_RET_STS_ERROR;

1648: --
1649: IF p_trig_rec.repeat_frequency_type IS NULL
1650: THEN
1651: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_REP_FREQ_TYPE');
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: -- If any errors happen abort API/Procedure.
1654: RETURN;
1655: END IF;
1656:

Line 1663: x_return_status := FND_API.G_RET_STS_ERROR;

1659: --
1660: IF p_trig_rec.trigger_name IS NULL
1661: THEN
1662: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_TRIG_NAME');
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- If any errors happen abort API/Procedure.
1665: RETURN;
1666: END IF;
1667:

Line 1674: x_return_status := FND_API.G_RET_STS_ERROR;

1670: --
1671: IF p_trig_rec.view_application_id IS NULL
1672: THEN
1673: AMS_UTILITY_PVT.Error_Message('AMS_API_MISSING_APP_ID');
1674: x_return_status := FND_API.G_RET_STS_ERROR;
1675: -- If any errors happen abort API/Procedure.
1676: RETURN;
1677: END IF;
1678:

Line 1685: x_return_status := FND_API.G_RET_STS_ERROR;

1681: --
1682: IF p_trig_rec.user_start_date_time IS NULL
1683: THEN
1684: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_START_DT');
1685: x_return_status := FND_API.G_RET_STS_ERROR;
1686: -- If any errors happen abort API/Procedure.
1687: RETURN;
1688: END IF;
1689:

Line 1696: x_return_status := FND_API.G_RET_STS_ERROR;

1692: --
1693: IF p_trig_rec.timezone_id IS NULL
1694: THEN
1695: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_TIMEZONE');
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: -- If any errors happen abort API/Procedure.
1698: RETURN;
1699: END IF;
1700:

Line 1763: x_return_status := FND_API.g_ret_sts_success;

1759: -- end soagrawa 07-Aug-2001
1760:
1761: BEGIN
1762:
1763: x_return_status := FND_API.g_ret_sts_success;
1764:
1765: -- For create_trigger, when trigger_id is passed in, we need to
1766: -- check if this trigger_id is unique.
1767: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 1773: ) = FND_API.g_false

1769: THEN
1770: IF AMS_Utility_PVT.check_uniqueness(
1771: 'AMS_TRIGGERS',
1772: 'TRIGGER_ID = ' || p_trig_rec.trigger_id
1773: ) = FND_API.g_false
1774: THEN
1775: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_DUP_TRIG_ID');
1776: x_return_status := FND_API.g_ret_sts_error;
1777: RETURN;

Line 1776: x_return_status := FND_API.g_ret_sts_error;

1772: 'TRIGGER_ID = ' || p_trig_rec.trigger_id
1773: ) = FND_API.g_false
1774: THEN
1775: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_DUP_TRIG_ID');
1776: x_return_status := FND_API.g_ret_sts_error;
1777: RETURN;
1778: END IF;
1779: END IF;
1780:

Line 1799: ) = FND_API.g_false

1795:
1796: IF AMS_Utility_PVT.Check_Uniqueness(
1797: p_table_name => 'AMS_TRIGGERS_VL',
1798: p_where_clause => l_where_clause
1799: ) = FND_API.g_false
1800: THEN
1801: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_DUP_TRIG_NAME');
1802: x_return_status := FND_API.g_ret_sts_error;
1803: RETURN;

Line 1802: x_return_status := FND_API.g_ret_sts_error;

1798: p_where_clause => l_where_clause
1799: ) = FND_API.g_false
1800: THEN
1801: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_DUP_TRIG_NAME');
1802: x_return_status := FND_API.g_ret_sts_error;
1803: RETURN;
1804: END IF;
1805: */
1806:

Line 1820: x_return_status := FND_API.g_ret_sts_error;

1816:
1817: IF l_dummy IS NOT NULL THEN
1818: -- Duplicate Trigger
1819: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUP_TRIG_NAME');
1820: x_return_status := FND_API.g_ret_sts_error;
1821: RETURN;
1822: END IF ;
1823:
1824: -- end changes soagrawa 07-Aug-2001

Line 1860: x_return_status := FND_API.g_ret_sts_success ;

1856: BEGIN
1857: --
1858: -- Initialize the OUT parameter
1859: --
1860: x_return_status := FND_API.g_ret_sts_success ;
1861:
1862: -- Check arc_trigger_created_for
1863: /* IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR THEN
1864: IF p_trig_rec.arc_trigger_created_for <> 'CAMP'

Line 1863: /* IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR THEN

1859: --
1860: x_return_status := FND_API.g_ret_sts_success ;
1861:
1862: -- Check arc_trigger_created_for
1863: /* IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR THEN
1864: IF p_trig_rec.arc_trigger_created_for <> 'CAMP'
1865: -- Commented by ptendulk on 14-Oct-2001 as Metric is not using triggers for refresh.
1866: -- AND p_trig_rec.arc_trigger_created_for <> 'AMET'
1867: THEN

Line 1869: x_return_status := FND_API.G_RET_STS_ERROR;

1865: -- Commented by ptendulk on 14-Oct-2001 as Metric is not using triggers for refresh.
1866: -- AND p_trig_rec.arc_trigger_created_for <> 'AMET'
1867: THEN
1868: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_CREATED_FOR');
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: -- If any errors happen abort API/Procedure.
1871: RETURN;
1872: END IF;
1873: END IF;

Line 1880: IF p_trig_rec.timezone_id <> FND_API.G_MISS_NUM THEN

1876: l_pk_name := 'UPGRADE_TZ_ID' ;
1877: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1878: l_pk_value := p_trig_rec.timezone_id ;
1879:
1880: IF p_trig_rec.timezone_id <> FND_API.G_MISS_NUM THEN
1881: IF AMS_Utility_PVT.Check_FK_Exists (
1882: p_table_name => l_table_name
1883: ,p_pk_name => l_pk_name
1884: ,p_pk_value => l_pk_value

Line 1887: ) = FND_API.G_FALSE

1883: ,p_pk_name => l_pk_name
1884: ,p_pk_value => l_pk_value
1885: ,p_pk_data_type => l_pk_data_type
1886: ,p_additional_where_clause => null
1887: ) = FND_API.G_FALSE
1888: THEN
1889: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_TIMEZONE');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891: RETURN;

Line 1890: x_return_status := FND_API.G_RET_STS_ERROR;

1886: ,p_additional_where_clause => null
1887: ) = FND_API.G_FALSE
1888: THEN
1889: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_TIMEZONE');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891: RETURN;
1892: END IF;
1893: END IF ;
1894:

Line 1919: x_return_status := FND_API.g_ret_sts_success ;

1915: BEGIN
1916: --
1917: -- Initialize the OUT parameter
1918: --
1919: x_return_status := FND_API.g_ret_sts_success ;
1920: -- Check triggering_type
1921: IF p_trig_rec.triggering_type <> FND_API.G_MISS_CHAR
1922: THEN
1923: IF AMS_Utility_PVT.Check_Lookup_Exists

Line 1921: IF p_trig_rec.triggering_type <> FND_API.G_MISS_CHAR

1917: -- Initialize the OUT parameter
1918: --
1919: x_return_status := FND_API.g_ret_sts_success ;
1920: -- Check triggering_type
1921: IF p_trig_rec.triggering_type <> FND_API.G_MISS_CHAR
1922: THEN
1923: IF AMS_Utility_PVT.Check_Lookup_Exists
1924: ( p_lookup_table_name => 'AMS_LOOKUPS'
1925: ,p_lookup_type => 'AMS_TRIGGER_TYPE'

Line 1927: ) = FND_API.G_FALSE

1923: IF AMS_Utility_PVT.Check_Lookup_Exists
1924: ( p_lookup_table_name => 'AMS_LOOKUPS'
1925: ,p_lookup_type => 'AMS_TRIGGER_TYPE'
1926: ,p_lookup_code => p_trig_rec.triggering_type
1927: ) = FND_API.G_FALSE
1928: THEN
1929: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_TRIGGER_TYPE');
1930: x_return_status := FND_API.G_RET_STS_ERROR;
1931: -- If any errors happen abort API/Procedure.

Line 1930: x_return_status := FND_API.G_RET_STS_ERROR;

1926: ,p_lookup_code => p_trig_rec.triggering_type
1927: ) = FND_API.G_FALSE
1928: THEN
1929: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_TRIGGER_TYPE');
1930: x_return_status := FND_API.G_RET_STS_ERROR;
1931: -- If any errors happen abort API/Procedure.
1932: RETURN;
1933: END IF;
1934: END IF;

Line 1937: IF p_trig_rec.repeat_frequency_type <> FND_API.G_MISS_CHAR

1933: END IF;
1934: END IF;
1935:
1936: -- Check repeat_frequency_type
1937: IF p_trig_rec.repeat_frequency_type <> FND_API.G_MISS_CHAR
1938: AND p_trig_rec.repeat_frequency_type IS NOT NULL
1939: THEN
1940: IF AMS_Utility_PVT.Check_Lookup_Exists
1941: ( p_lookup_table_name => 'AMS_LOOKUPS'

Line 1944: ) = FND_API.G_FALSE

1940: IF AMS_Utility_PVT.Check_Lookup_Exists
1941: ( p_lookup_table_name => 'AMS_LOOKUPS'
1942: ,p_lookup_type => 'AMS_TRIGGER_FREQUENCY_TYPE'
1943: ,p_lookup_code => p_trig_rec.repeat_frequency_type
1944: ) = FND_API.G_FALSE
1945: THEN
1946: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_FREQ_TYPE');
1947: x_return_status := FND_API.G_RET_STS_ERROR;
1948: -- If any errors happen abort API/Procedure.

Line 1947: x_return_status := FND_API.G_RET_STS_ERROR;

1943: ,p_lookup_code => p_trig_rec.repeat_frequency_type
1944: ) = FND_API.G_FALSE
1945: THEN
1946: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_FREQ_TYPE');
1947: x_return_status := FND_API.G_RET_STS_ERROR;
1948: -- If any errors happen abort API/Procedure.
1949: RETURN;
1950: END IF;
1951: END IF;

Line 1981: IF x_return_status <> FND_API.g_ret_sts_success THEN

1977: Check_Trig_Req_Items(
1978: p_trig_rec => p_trig_rec,
1979: x_return_status => x_return_status
1980: );
1981: IF x_return_status <> FND_API.g_ret_sts_success THEN
1982: RETURN;
1983: END IF;
1984: --dbms_output.put_line('After req : '||x_return_status);
1985: Check_Trig_UK_Items(

Line 1991: IF x_return_status <> FND_API.g_ret_sts_success THEN

1987: p_validation_mode => p_validation_mode,
1988: x_return_status => x_return_status
1989: );
1990:
1991: IF x_return_status <> FND_API.g_ret_sts_success THEN
1992: RETURN;
1993: END IF;
1994: --dbms_output.put_line('After uk : '||x_return_status);
1995: Check_Trig_Fk_Items(

Line 2000: IF x_return_status <> FND_API.g_ret_sts_success THEN

1996: p_trig_rec => p_trig_rec,
1997: x_return_status => x_return_status
1998: );
1999:
2000: IF x_return_status <> FND_API.g_ret_sts_success THEN
2001: RETURN;
2002: END IF;
2003: --dbms_output.put_line('After fk : '||x_return_status);
2004: Check_Trig_Lookup_Items(

Line 2009: IF x_return_status <> FND_API.g_ret_sts_success THEN

2005: p_trig_rec => p_trig_rec,
2006: x_return_status => x_return_status
2007: );
2008:
2009: IF x_return_status <> FND_API.g_ret_sts_success THEN
2010: RETURN;
2011: END IF;
2012:
2013: END Check_Trig_Items;

Line 2117: x_return_status := FND_API.g_ret_sts_success;

2113: BEGIN
2114: --
2115: -- Initialize the Out Variable
2116: --
2117: x_return_status := FND_API.g_ret_sts_success;
2118:
2119: -- Check start date time
2120: IF (p_Trig_rec.user_repeat_stop_date_time IS NOT NULL AND
2121: p_Trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE) OR

Line 2121: p_Trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE) OR

2117: x_return_status := FND_API.g_ret_sts_success;
2118:
2119: -- Check start date time
2120: IF (p_Trig_rec.user_repeat_stop_date_time IS NOT NULL AND
2121: p_Trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE) OR
2122: p_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE
2123: THEN
2124: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN
2125: l_start_date := p_complete_rec.user_start_date_time;

Line 2122: p_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE

2118:
2119: -- Check start date time
2120: IF (p_Trig_rec.user_repeat_stop_date_time IS NOT NULL AND
2121: p_Trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE) OR
2122: p_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE
2123: THEN
2124: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN
2125: l_start_date := p_complete_rec.user_start_date_time;
2126: ELSE

Line 2124: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN

2120: IF (p_Trig_rec.user_repeat_stop_date_time IS NOT NULL AND
2121: p_Trig_rec.user_repeat_stop_date_time <> FND_API.G_MISS_DATE) OR
2122: p_trig_rec.user_start_date_time <> FND_API.G_MISS_DATE
2123: THEN
2124: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN
2125: l_start_date := p_complete_rec.user_start_date_time;
2126: ELSE
2127: l_start_date := p_trig_rec.user_start_date_time;
2128: END IF ;

Line 2129: IF p_trig_rec.user_repeat_stop_date_time = FND_API.G_MISS_DATE THEN

2125: l_start_date := p_complete_rec.user_start_date_time;
2126: ELSE
2127: l_start_date := p_trig_rec.user_start_date_time;
2128: END IF ;
2129: IF p_trig_rec.user_repeat_stop_date_time = FND_API.G_MISS_DATE THEN
2130: l_end_date := p_complete_rec.user_repeat_stop_date_time ;
2131: ELSE
2132: l_end_date := p_trig_rec.user_repeat_stop_date_time ;
2133: END IF ;

Line 2135: -- IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN

2131: ELSE
2132: l_end_date := p_trig_rec.user_repeat_stop_date_time ;
2133: END IF ;
2134: -- Following code is added by ptendulk on 26Feb2000
2135: -- IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2136: -- l_trigger_created_for_id := p_complete_rec.trigger_created_for_id ;
2137: -- ELSE
2138: -- l_trigger_created_for_id := p_trig_rec.trigger_created_for_id ;
2139: -- END IF;

Line 2141: -- IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN

2137: -- ELSE
2138: -- l_trigger_created_for_id := p_trig_rec.trigger_created_for_id ;
2139: -- END IF;
2140: --
2141: -- IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN
2142: -- l_trigger_created_for := p_complete_rec.arc_trigger_created_for ;
2143: -- ELSE
2144: -- l_trigger_created_for := p_trig_rec.arc_trigger_created_for ;
2145: -- END IF;

Line 2154: x_return_status := FND_API.G_RET_STS_ERROR;

2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2151: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2152: FND_MSG_PUB.Add;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_ERROR;
2155: RETURN;
2156: END IF;
2157:
2158: --following code is added by cgoyal for bugfix#3055863

Line 2165: p_init_msg_list => FND_API.G_FALSE ,

2161: THEN
2162: -- soagrawa added time zone conversion on 27-aug-2003 for bug# 3115141
2163:
2164: AMS_UTILITY_PVT.Convert_Timezone(
2165: p_init_msg_list => FND_API.G_FALSE ,
2166: x_return_status => x_return_status ,
2167: x_msg_count => l_msg_count ,
2168: x_msg_data => l_msg_data ,
2169: p_user_tz_id => p_trig_rec.timezone_id , -- required

Line 2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2170: p_in_time => l_end_date , -- required
2171: x_out_time => l_tz_end_date
2172: );
2173:
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;

Line 2175: RAISE FND_API.G_EXC_ERROR;

2171: x_out_time => l_tz_end_date
2172: );
2173:
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: -- end soagrawa for bug# 3115141

Line 2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2172: );
2173:
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: -- end soagrawa for bug# 3115141
2180:

Line 2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2173:
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: -- end soagrawa for bug# 3115141
2180:
2181: IF l_tz_end_date < SYSDATE THEN

Line 2188: x_return_status := FND_API.G_RET_STS_ERROR;

2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_END_DT');
2186: FND_MSG_PUB.Add;
2187: END IF;
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: RETURN;
2190: END IF;
2191: END IF;
2192:

Line 2211: -- x_return_status := FND_API.G_RET_STS_ERROR;

2207: ---- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
2208: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2209: -- FND_MSG_PUB.Add;
2210: -- END IF;
2211: -- x_return_status := FND_API.G_RET_STS_ERROR;
2212: -- -- If any errors happen abort API/Procedure.
2213: -- RETURN;
2214: -- END IF;
2215:

Line 2220: IF (p_trig_rec.user_repeat_daily_start_time <> FND_API.G_MISS_DATE AND

2216: END IF;
2217: END IF;
2218: --dbms_output.put_line('After Date Check : '||x_return_status);
2219: -- Check Repeat daily start time
2220: IF (p_trig_rec.user_repeat_daily_start_time <> FND_API.G_MISS_DATE AND
2221: p_trig_rec.user_repeat_daily_start_time IS NOT NULL ) OR
2222: (p_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE AND
2223: p_trig_rec.user_repeat_daily_end_time IS NOT NULL )
2224: THEN

Line 2222: (p_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE AND

2218: --dbms_output.put_line('After Date Check : '||x_return_status);
2219: -- Check Repeat daily start time
2220: IF (p_trig_rec.user_repeat_daily_start_time <> FND_API.G_MISS_DATE AND
2221: p_trig_rec.user_repeat_daily_start_time IS NOT NULL ) OR
2222: (p_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE AND
2223: p_trig_rec.user_repeat_daily_end_time IS NOT NULL )
2224: THEN
2225: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2226: l_daily_start_time := p_complete_rec.user_repeat_daily_start_time;

Line 2225: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN

2221: p_trig_rec.user_repeat_daily_start_time IS NOT NULL ) OR
2222: (p_trig_rec.user_repeat_daily_end_time <> FND_API.G_MISS_DATE AND
2223: p_trig_rec.user_repeat_daily_end_time IS NOT NULL )
2224: THEN
2225: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2226: l_daily_start_time := p_complete_rec.user_repeat_daily_start_time;
2227: ELSE
2228: l_daily_start_time := p_trig_rec.user_repeat_daily_start_time;
2229: END IF;

Line 2231: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN

2227: ELSE
2228: l_daily_start_time := p_trig_rec.user_repeat_daily_start_time;
2229: END IF;
2230:
2231: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN
2232: l_daily_end_time := p_complete_rec.user_repeat_daily_end_time;
2233: ELSE
2234: l_daily_end_time := p_trig_rec.user_repeat_daily_end_time;
2235: END IF;

Line 2241: x_return_status := FND_API.G_RET_STS_ERROR;

2237: IF (l_daily_start_time IS NULL AND l_daily_end_time IS NOT NULL )
2238: OR (l_daily_start_time IS NOT NULL AND l_daily_end_time IS NULL )
2239: THEN
2240: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_RPT_DAILY_TM');
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: -- If any errors happen abort API/Procedure.
2243: RETURN;
2244: ELSIF l_daily_start_time > l_daily_end_time
2245: THEN

Line 2247: x_return_status := FND_API.G_RET_STS_ERROR;

2243: RETURN;
2244: ELSIF l_daily_start_time > l_daily_end_time
2245: THEN
2246: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_DAILY_RANGE');
2247: x_return_status := FND_API.G_RET_STS_ERROR;
2248: -- If any errors happen abort API/Procedure.
2249: RETURN;
2250: END IF;
2251: END IF;

Line 2254: IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR

2250: END IF;
2251: END IF;
2252:
2253: --dbms_output.put_line('After time check : '||x_return_status);
2254: IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR
2255: OR p_trig_rec.trigger_created_for_id <> FND_API.G_MISS_NUM THEN
2256:
2257: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2258: l_trigger_created_for_id := p_complete_rec.trigger_created_for_id ;

Line 2255: OR p_trig_rec.trigger_created_for_id <> FND_API.G_MISS_NUM THEN

2251: END IF;
2252:
2253: --dbms_output.put_line('After time check : '||x_return_status);
2254: IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR
2255: OR p_trig_rec.trigger_created_for_id <> FND_API.G_MISS_NUM THEN
2256:
2257: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2258: l_trigger_created_for_id := p_complete_rec.trigger_created_for_id ;
2259: ELSE

Line 2257: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN

2253: --dbms_output.put_line('After time check : '||x_return_status);
2254: IF p_trig_rec.arc_trigger_created_for <> FND_API.G_MISS_CHAR
2255: OR p_trig_rec.trigger_created_for_id <> FND_API.G_MISS_NUM THEN
2256:
2257: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2258: l_trigger_created_for_id := p_complete_rec.trigger_created_for_id ;
2259: ELSE
2260: l_trigger_created_for_id := p_trig_rec.trigger_created_for_id ;
2261: END IF;

Line 2263: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN

2259: ELSE
2260: l_trigger_created_for_id := p_trig_rec.trigger_created_for_id ;
2261: END IF;
2262:
2263: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN
2264: l_trigger_created_for := p_complete_rec.arc_trigger_created_for ;
2265: ELSE
2266: l_trigger_created_for := p_trig_rec.arc_trigger_created_for ;
2267: END IF;

Line 2289: ) = FND_API.G_FALSE

2285: ,p_pk_name => l_pk_name
2286: ,p_pk_value => l_pk_value
2287: ,p_pk_data_type => l_pk_data_type
2288: ,p_additional_where_clause => l_additional_where_clause
2289: ) = FND_API.G_FALSE
2290: THEN
2291: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_CREATED_FOR');
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: RETURN;

Line 2292: x_return_status := FND_API.G_RET_STS_ERROR;

2288: ,p_additional_where_clause => l_additional_where_clause
2289: ) = FND_API.G_FALSE
2290: THEN
2291: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_INVALID_CREATED_FOR');
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: RETURN;
2294: END IF;
2295: */
2296: END IF;

Line 2299: IF p_trig_rec.repeat_frequency_type <> FND_API.G_MISS_CHAR THEN

2295: */
2296: END IF;
2297: --dbms_output.put_line('After Camp Chk : '||x_return_status);
2298: -- Repeat Every X Frequency
2299: IF p_trig_rec.repeat_frequency_type <> FND_API.G_MISS_CHAR THEN
2300:
2301: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN
2302: l_repeat_freq := p_complete_rec.repeat_every_x_frequency ;
2303: ELSE

Line 2301: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN

2297: --dbms_output.put_line('After Camp Chk : '||x_return_status);
2298: -- Repeat Every X Frequency
2299: IF p_trig_rec.repeat_frequency_type <> FND_API.G_MISS_CHAR THEN
2300:
2301: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN
2302: l_repeat_freq := p_complete_rec.repeat_every_x_frequency ;
2303: ELSE
2304: l_repeat_freq := p_trig_rec.repeat_every_x_frequency ;
2305: END IF;

Line 2311: x_return_status := FND_API.G_RET_STS_ERROR;

2307: IF p_trig_rec.repeat_frequency_type <> 'NONE' AND
2308: l_repeat_freq IS NULL
2309: THEN
2310: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_MISSING_EVERY_X_FREQ');
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: -- If any errors happen abort API/Procedure.
2313: RETURN;
2314: END IF;
2315: END IF;

Line 2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;

2335: x_trig_rec OUT NOCOPY trig_rec_type
2336: )
2337: IS
2338: BEGIN
2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;
2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;

Line 2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;

2336: )
2337: IS
2338: BEGIN
2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;
2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;

Line 2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;

2337: IS
2338: BEGIN
2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;
2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;

Line 2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;

2338: BEGIN
2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;
2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;

Line 2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;

2339: x_trig_rec.trigger_id := FND_API.G_MISS_NUM ;
2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;

Line 2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;

2340: x_trig_rec.last_update_date := FND_API.G_MISS_DATE ;
2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;

Line 2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;

2341: x_trig_rec.last_updated_by := FND_API.G_MISS_NUM ;
2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;

Line 2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;

2342: x_trig_rec.creation_date := FND_API.G_MISS_DATE ;
2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;

Line 2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;

2343: x_trig_rec.created_by := FND_API.G_MISS_NUM ;
2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;

Line 2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;

2344: x_trig_rec.last_update_login := FND_API.G_MISS_NUM ;
2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;

Line 2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;

2345: x_trig_rec.object_version_number := FND_API.G_MISS_NUM ;
2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;

Line 2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;

2346: x_trig_rec.process_id := FND_API.G_MISS_NUM ;
2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;

Line 2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;

2347: x_trig_rec.trigger_created_for_id := FND_API.G_MISS_NUM ;
2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;

Line 2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;

2348: x_trig_rec.arc_trigger_created_for := FND_API.G_MISS_CHAR ;
2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;

Line 2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;

2349: x_trig_rec.triggering_type := FND_API.G_MISS_CHAR ;
2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;

Line 2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;

2350: x_trig_rec.trigger_name := FND_API.G_MISS_CHAR ;
2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;

Line 2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;

2351: x_trig_rec.view_application_id := FND_API.G_MISS_NUM ;
2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;

Line 2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;

2352: x_trig_rec.timezone_id := FND_API.G_MISS_NUM ;
2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;

Line 2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;

2353: x_trig_rec.user_start_date_time := FND_API.G_MISS_DATE ;
2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;

Line 2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;

2354: x_trig_rec.start_date_time := FND_API.G_MISS_DATE ;
2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;

Line 2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;

2355: x_trig_rec.user_last_run_date_time := FND_API.G_MISS_DATE ;
2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;

Line 2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;

2356: x_trig_rec.last_run_date_time := FND_API.G_MISS_DATE ;
2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;

Line 2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;

2357: x_trig_rec.user_next_run_date_time := FND_API.G_MISS_DATE ;
2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;

Line 2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;

2358: x_trig_rec.next_run_date_time := FND_API.G_MISS_DATE ;
2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;

Line 2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;

2359: x_trig_rec.user_repeat_daily_start_time := FND_API.G_MISS_DATE ;
2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;

Line 2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;

2360: x_trig_rec.repeat_daily_start_time := FND_API.G_MISS_DATE ;
2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;

Line 2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;

2361: x_trig_rec.user_repeat_daily_end_time := FND_API.G_MISS_DATE ;
2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;

Line 2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;

2362: x_trig_rec.repeat_daily_end_time := FND_API.G_MISS_DATE ;
2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;

Line 2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;

2363: x_trig_rec.repeat_frequency_type := FND_API.G_MISS_CHAR ;
2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.

Line 2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;

2364: x_trig_rec.repeat_every_x_frequency := FND_API.G_MISS_NUM ;
2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.

Line 2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;

2365: x_trig_rec.user_repeat_stop_date_time := FND_API.G_MISS_DATE ;
2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2373: END Init_Trig_Rec ;

Line 2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;

2366: x_trig_rec.repeat_stop_date_time := FND_API.G_MISS_DATE ;
2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2373: END Init_Trig_Rec ;
2374:

Line 2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.

2367: x_trig_rec.metrics_refresh_type := FND_API.G_MISS_CHAR ;
2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2373: END Init_Trig_Rec ;
2374:
2375: -- Start of Comments

Line 2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.

2368: x_trig_rec.description := FND_API.G_MISS_CHAR ;
2369: x_trig_rec.notify_flag := FND_API.G_MISS_CHAR ;
2370: x_trig_rec.execute_schedule_flag := FND_API.G_MISS_CHAR ;
2371: x_trig_rec.TRIGGERED_STATUS := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2372: x_trig_rec.USAGE := FND_API.G_MISS_CHAR ;-- anchaudh added for R12 monitors.
2373: END Init_Trig_Rec ;
2374:
2375: -- Start of Comments
2376: --

Line 2416: RAISE FND_API.g_exc_error;

2412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2414: FND_MSG_PUB.add;
2415: END IF;
2416: RAISE FND_API.g_exc_error;
2417: END IF;
2418: CLOSE c_trig;
2419:
2420: IF p_trig_rec.process_id = FND_API.G_MISS_NUM THEN

Line 2420: IF p_trig_rec.process_id = FND_API.G_MISS_NUM THEN

2416: RAISE FND_API.g_exc_error;
2417: END IF;
2418: CLOSE c_trig;
2419:
2420: IF p_trig_rec.process_id = FND_API.G_MISS_NUM THEN
2421: x_complete_rec.process_id := l_trig_rec.process_id;
2422: END IF;
2423:
2424: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN

Line 2424: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN

2420: IF p_trig_rec.process_id = FND_API.G_MISS_NUM THEN
2421: x_complete_rec.process_id := l_trig_rec.process_id;
2422: END IF;
2423:
2424: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2425: x_complete_rec.trigger_created_for_id := l_trig_rec.trigger_created_for_id;
2426: END IF;
2427:
2428: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN

Line 2428: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN

2424: IF p_trig_rec.trigger_created_for_id = FND_API.G_MISS_NUM THEN
2425: x_complete_rec.trigger_created_for_id := l_trig_rec.trigger_created_for_id;
2426: END IF;
2427:
2428: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN
2429: x_complete_rec.arc_trigger_created_for := l_trig_rec.arc_trigger_created_for ;
2430: END IF;
2431:
2432: IF p_trig_rec.triggering_type = FND_API.G_MISS_CHAR THEN

Line 2432: IF p_trig_rec.triggering_type = FND_API.G_MISS_CHAR THEN

2428: IF p_trig_rec.arc_trigger_created_for = FND_API.G_MISS_CHAR THEN
2429: x_complete_rec.arc_trigger_created_for := l_trig_rec.arc_trigger_created_for ;
2430: END IF;
2431:
2432: IF p_trig_rec.triggering_type = FND_API.G_MISS_CHAR THEN
2433: x_complete_rec.triggering_type := l_trig_rec.triggering_type ;
2434: END IF;
2435:
2436: IF p_trig_rec.trigger_name = FND_API.G_MISS_CHAR THEN

Line 2436: IF p_trig_rec.trigger_name = FND_API.G_MISS_CHAR THEN

2432: IF p_trig_rec.triggering_type = FND_API.G_MISS_CHAR THEN
2433: x_complete_rec.triggering_type := l_trig_rec.triggering_type ;
2434: END IF;
2435:
2436: IF p_trig_rec.trigger_name = FND_API.G_MISS_CHAR THEN
2437: x_complete_rec.trigger_name := l_trig_rec.trigger_name ;
2438: END IF;
2439:
2440: IF p_trig_rec.view_application_id = FND_API.G_MISS_NUM THEN

Line 2440: IF p_trig_rec.view_application_id = FND_API.G_MISS_NUM THEN

2436: IF p_trig_rec.trigger_name = FND_API.G_MISS_CHAR THEN
2437: x_complete_rec.trigger_name := l_trig_rec.trigger_name ;
2438: END IF;
2439:
2440: IF p_trig_rec.view_application_id = FND_API.G_MISS_NUM THEN
2441: x_complete_rec.view_application_id := l_trig_rec.view_application_id ;
2442: END IF;
2443:
2444: IF p_trig_rec.timezone_id = FND_API.G_MISS_NUM THEN

Line 2444: IF p_trig_rec.timezone_id = FND_API.G_MISS_NUM THEN

2440: IF p_trig_rec.view_application_id = FND_API.G_MISS_NUM THEN
2441: x_complete_rec.view_application_id := l_trig_rec.view_application_id ;
2442: END IF;
2443:
2444: IF p_trig_rec.timezone_id = FND_API.G_MISS_NUM THEN
2445: x_complete_rec.timezone_id := l_trig_rec.timezone_id ;
2446: END IF;
2447:
2448: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN

Line 2448: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN

2444: IF p_trig_rec.timezone_id = FND_API.G_MISS_NUM THEN
2445: x_complete_rec.timezone_id := l_trig_rec.timezone_id ;
2446: END IF;
2447:
2448: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN
2449: x_complete_rec.user_start_date_time := l_trig_rec.user_start_date_time ;
2450: END IF;
2451:
2452: IF p_trig_rec.start_date_time = FND_API.G_MISS_DATE THEN

Line 2452: IF p_trig_rec.start_date_time = FND_API.G_MISS_DATE THEN

2448: IF p_trig_rec.user_start_date_time = FND_API.G_MISS_DATE THEN
2449: x_complete_rec.user_start_date_time := l_trig_rec.user_start_date_time ;
2450: END IF;
2451:
2452: IF p_trig_rec.start_date_time = FND_API.G_MISS_DATE THEN
2453: x_complete_rec.start_date_time := l_trig_rec.start_date_time ;
2454: END IF;
2455:
2456: IF p_trig_rec.user_last_run_date_time = FND_API.G_MISS_DATE THEN

Line 2456: IF p_trig_rec.user_last_run_date_time = FND_API.G_MISS_DATE THEN

2452: IF p_trig_rec.start_date_time = FND_API.G_MISS_DATE THEN
2453: x_complete_rec.start_date_time := l_trig_rec.start_date_time ;
2454: END IF;
2455:
2456: IF p_trig_rec.user_last_run_date_time = FND_API.G_MISS_DATE THEN
2457: x_complete_rec.user_last_run_date_time := l_trig_rec.user_last_run_date_time ;
2458: END IF;
2459:
2460: IF p_trig_rec.last_run_date_time = FND_API.G_MISS_DATE THEN

Line 2460: IF p_trig_rec.last_run_date_time = FND_API.G_MISS_DATE THEN

2456: IF p_trig_rec.user_last_run_date_time = FND_API.G_MISS_DATE THEN
2457: x_complete_rec.user_last_run_date_time := l_trig_rec.user_last_run_date_time ;
2458: END IF;
2459:
2460: IF p_trig_rec.last_run_date_time = FND_API.G_MISS_DATE THEN
2461: x_complete_rec.last_run_date_time := l_trig_rec.last_run_date_time ;
2462: END IF;
2463:
2464: IF p_trig_rec.user_next_run_date_time = FND_API.G_MISS_DATE THEN

Line 2464: IF p_trig_rec.user_next_run_date_time = FND_API.G_MISS_DATE THEN

2460: IF p_trig_rec.last_run_date_time = FND_API.G_MISS_DATE THEN
2461: x_complete_rec.last_run_date_time := l_trig_rec.last_run_date_time ;
2462: END IF;
2463:
2464: IF p_trig_rec.user_next_run_date_time = FND_API.G_MISS_DATE THEN
2465: x_complete_rec.user_next_run_date_time := l_trig_rec.user_next_run_date_time ;
2466: END IF;
2467:
2468: IF p_trig_rec.next_run_date_time = FND_API.G_MISS_DATE THEN

Line 2468: IF p_trig_rec.next_run_date_time = FND_API.G_MISS_DATE THEN

2464: IF p_trig_rec.user_next_run_date_time = FND_API.G_MISS_DATE THEN
2465: x_complete_rec.user_next_run_date_time := l_trig_rec.user_next_run_date_time ;
2466: END IF;
2467:
2468: IF p_trig_rec.next_run_date_time = FND_API.G_MISS_DATE THEN
2469: x_complete_rec.next_run_date_time := l_trig_rec.next_run_date_time ;
2470: END IF;
2471:
2472: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN

Line 2472: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN

2468: IF p_trig_rec.next_run_date_time = FND_API.G_MISS_DATE THEN
2469: x_complete_rec.next_run_date_time := l_trig_rec.next_run_date_time ;
2470: END IF;
2471:
2472: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2473: x_complete_rec.user_repeat_daily_start_time := l_trig_rec.user_repeat_daily_start_time ;
2474: END IF;
2475:
2476: IF p_trig_rec.repeat_daily_start_time = FND_API.G_MISS_DATE THEN

Line 2476: IF p_trig_rec.repeat_daily_start_time = FND_API.G_MISS_DATE THEN

2472: IF p_trig_rec.user_repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2473: x_complete_rec.user_repeat_daily_start_time := l_trig_rec.user_repeat_daily_start_time ;
2474: END IF;
2475:
2476: IF p_trig_rec.repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2477: x_complete_rec.repeat_daily_start_time := l_trig_rec.repeat_daily_start_time ;
2478: END IF;
2479:
2480: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN

Line 2480: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN

2476: IF p_trig_rec.repeat_daily_start_time = FND_API.G_MISS_DATE THEN
2477: x_complete_rec.repeat_daily_start_time := l_trig_rec.repeat_daily_start_time ;
2478: END IF;
2479:
2480: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN
2481: x_complete_rec.user_repeat_daily_end_time := l_trig_rec.user_repeat_daily_end_time ;
2482: END IF;
2483:
2484: IF p_trig_rec.repeat_daily_end_time = FND_API.G_MISS_DATE THEN

Line 2484: IF p_trig_rec.repeat_daily_end_time = FND_API.G_MISS_DATE THEN

2480: IF p_trig_rec.user_repeat_daily_end_time = FND_API.G_MISS_DATE THEN
2481: x_complete_rec.user_repeat_daily_end_time := l_trig_rec.user_repeat_daily_end_time ;
2482: END IF;
2483:
2484: IF p_trig_rec.repeat_daily_end_time = FND_API.G_MISS_DATE THEN
2485: x_complete_rec.repeat_daily_end_time := l_trig_rec.repeat_daily_end_time ;
2486: END IF;
2487:
2488: IF p_trig_rec.repeat_frequency_type = FND_API.G_MISS_CHAR THEN

Line 2488: IF p_trig_rec.repeat_frequency_type = FND_API.G_MISS_CHAR THEN

2484: IF p_trig_rec.repeat_daily_end_time = FND_API.G_MISS_DATE THEN
2485: x_complete_rec.repeat_daily_end_time := l_trig_rec.repeat_daily_end_time ;
2486: END IF;
2487:
2488: IF p_trig_rec.repeat_frequency_type = FND_API.G_MISS_CHAR THEN
2489: x_complete_rec.repeat_frequency_type := l_trig_rec.repeat_frequency_type ;
2490: END IF;
2491:
2492: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN

Line 2492: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN

2488: IF p_trig_rec.repeat_frequency_type = FND_API.G_MISS_CHAR THEN
2489: x_complete_rec.repeat_frequency_type := l_trig_rec.repeat_frequency_type ;
2490: END IF;
2491:
2492: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN
2493: x_complete_rec.repeat_every_x_frequency := l_trig_rec.repeat_every_x_frequency;
2494: END IF;
2495:
2496: IF p_trig_rec.repeat_stop_date_time = FND_API.G_MISS_DATE THEN

Line 2496: IF p_trig_rec.repeat_stop_date_time = FND_API.G_MISS_DATE THEN

2492: IF p_trig_rec.repeat_every_x_frequency = FND_API.G_MISS_NUM THEN
2493: x_complete_rec.repeat_every_x_frequency := l_trig_rec.repeat_every_x_frequency;
2494: END IF;
2495:
2496: IF p_trig_rec.repeat_stop_date_time = FND_API.G_MISS_DATE THEN
2497: x_complete_rec.repeat_stop_date_time := l_trig_rec.repeat_stop_date_time ;
2498: END IF;
2499:
2500: IF p_trig_rec.user_repeat_stop_date_time = FND_API.G_MISS_DATE THEN

Line 2500: IF p_trig_rec.user_repeat_stop_date_time = FND_API.G_MISS_DATE THEN

2496: IF p_trig_rec.repeat_stop_date_time = FND_API.G_MISS_DATE THEN
2497: x_complete_rec.repeat_stop_date_time := l_trig_rec.repeat_stop_date_time ;
2498: END IF;
2499:
2500: IF p_trig_rec.user_repeat_stop_date_time = FND_API.G_MISS_DATE THEN
2501: x_complete_rec.user_repeat_stop_date_time := l_trig_rec.user_repeat_stop_date_time ;
2502: END IF;
2503:
2504:

Line 2506: IF p_trig_rec.metrics_refresh_type = FND_API.G_MISS_CHAR THEN

2502: END IF;
2503:
2504:
2505:
2506: IF p_trig_rec.metrics_refresh_type = FND_API.G_MISS_CHAR THEN
2507: x_complete_rec.metrics_refresh_type := l_trig_rec.metrics_refresh_type ;
2508: END IF;
2509:
2510: IF p_trig_rec.description = FND_API.G_MISS_CHAR THEN

Line 2510: IF p_trig_rec.description = FND_API.G_MISS_CHAR THEN

2506: IF p_trig_rec.metrics_refresh_type = FND_API.G_MISS_CHAR THEN
2507: x_complete_rec.metrics_refresh_type := l_trig_rec.metrics_refresh_type ;
2508: END IF;
2509:
2510: IF p_trig_rec.description = FND_API.G_MISS_CHAR THEN
2511: x_complete_rec.description := l_trig_rec.description ;
2512: END IF;
2513:
2514: -- CGOYAL added for 11.5.8 backport

Line 2515: IF p_trig_rec.NOTIFY_FLAG = FND_API.G_MISS_CHAR THEN

2511: x_complete_rec.description := l_trig_rec.description ;
2512: END IF;
2513:
2514: -- CGOYAL added for 11.5.8 backport
2515: IF p_trig_rec.NOTIFY_FLAG = FND_API.G_MISS_CHAR THEN
2516: x_complete_rec.NOTIFY_FLAG := l_trig_rec.NOTIFY_FLAG ;
2517: END IF;
2518:
2519: IF p_trig_rec.EXECUTE_SCHEDULE_FLAG = FND_API.G_MISS_CHAR THEN

Line 2519: IF p_trig_rec.EXECUTE_SCHEDULE_FLAG = FND_API.G_MISS_CHAR THEN

2515: IF p_trig_rec.NOTIFY_FLAG = FND_API.G_MISS_CHAR THEN
2516: x_complete_rec.NOTIFY_FLAG := l_trig_rec.NOTIFY_FLAG ;
2517: END IF;
2518:
2519: IF p_trig_rec.EXECUTE_SCHEDULE_FLAG = FND_API.G_MISS_CHAR THEN
2520: x_complete_rec.EXECUTE_SCHEDULE_FLAG := l_trig_rec.EXECUTE_SCHEDULE_FLAG ;
2521: END IF;
2522:
2523: -- anchaudh added for R12 monitors.

Line 2524: IF p_trig_rec.TRIGGERED_STATUS = FND_API.G_MISS_CHAR THEN

2520: x_complete_rec.EXECUTE_SCHEDULE_FLAG := l_trig_rec.EXECUTE_SCHEDULE_FLAG ;
2521: END IF;
2522:
2523: -- anchaudh added for R12 monitors.
2524: IF p_trig_rec.TRIGGERED_STATUS = FND_API.G_MISS_CHAR THEN
2525: x_complete_rec.TRIGGERED_STATUS := l_trig_rec.TRIGGERED_STATUS ;
2526: END IF;
2527:
2528: IF p_trig_rec.USAGE = FND_API.G_MISS_CHAR THEN

Line 2528: IF p_trig_rec.USAGE = FND_API.G_MISS_CHAR THEN

2524: IF p_trig_rec.TRIGGERED_STATUS = FND_API.G_MISS_CHAR THEN
2525: x_complete_rec.TRIGGERED_STATUS := l_trig_rec.TRIGGERED_STATUS ;
2526: END IF;
2527:
2528: IF p_trig_rec.USAGE = FND_API.G_MISS_CHAR THEN
2529: x_complete_rec.USAGE := l_trig_rec.USAGE ;
2530: END IF;
2531: --
2532: