DBA Data[Home] [Help]

APPS.AML_MONITOR_CONDITIONS_PVT dependencies on AS_UTILITY_PVT

Line 60: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

56: END IF;
57:
58: -- Debug Message
59: IF (AS_DEBUG_LOW_ON) THEN
60: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
61: END IF;
62:
63:
64: -- Initialize API return status to SUCCESS

Line 86: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Validate_monitor_condition');

82: END IF;
83:
84: -- Debug message
85: IF (AS_DEBUG_LOW_ON) THEN
86: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Validate_monitor_condition');
87: END IF;
88:
89: -- Invoke validation procedures
90: Validate_monitor_condition(

Line 93: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

89: -- Invoke validation procedures
90: Validate_monitor_condition(
91: p_init_msg_list => FND_API.G_FALSE,
92: p_validation_level => p_validation_level,
93: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
94: P_CONDITION_Rec => P_CONDITION_Rec,
95: x_return_status => x_return_status,
96: x_msg_count => x_msg_count,
97: x_msg_data => x_msg_data);

Line 107: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

103:
104:
105: -- Debug Message
106: IF (AS_DEBUG_LOW_ON) THEN
107: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
108: END IF;
109:
110:
111: -- Invoke table handler(AML_MONITOR_CONDITIONS_PKG.Insert_Row)

Line 176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

172:
173:
174: -- Debug Message
175: IF (AS_DEBUG_LOW_ON) THEN
176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
177: END IF;
178:
179:
180: -- Standard call to get message count and if count is 1, get message info.

Line 188: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

184: );
185:
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME
190: ,P_PKG_NAME => G_PKG_NAME
191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
192: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 192: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

188: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME
190: ,P_PKG_NAME => G_PKG_NAME
191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
192: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
193: ,X_MSG_COUNT => X_MSG_COUNT
194: ,X_MSG_DATA => X_MSG_DATA
195: ,X_RETURN_STATUS => X_RETURN_STATUS);
196:

Line 198: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

194: ,X_MSG_DATA => X_MSG_DATA
195: ,X_RETURN_STATUS => X_RETURN_STATUS);
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
199: P_API_NAME => L_API_NAME
200: ,P_PKG_NAME => G_PKG_NAME
201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
202: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 202: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

198: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
199: P_API_NAME => L_API_NAME
200: ,P_PKG_NAME => G_PKG_NAME
201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
202: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
203: ,X_MSG_COUNT => X_MSG_COUNT
204: ,X_MSG_DATA => X_MSG_DATA
205: ,X_RETURN_STATUS => X_RETURN_STATUS);
206:

Line 208: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

204: ,X_MSG_DATA => X_MSG_DATA
205: ,X_RETURN_STATUS => X_RETURN_STATUS);
206:
207: WHEN OTHERS THEN
208: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
209: P_API_NAME => L_API_NAME
210: ,P_PKG_NAME => G_PKG_NAME
211: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
212: ,P_SQLCODE => SQLCODE

Line 211: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

207: WHEN OTHERS THEN
208: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
209: P_API_NAME => L_API_NAME
210: ,P_PKG_NAME => G_PKG_NAME
211: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
212: ,P_SQLCODE => SQLCODE
213: ,P_SQLERRM => SQLERRM
214: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
215: ,X_MSG_COUNT => X_MSG_COUNT

Line 214: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

210: ,P_PKG_NAME => G_PKG_NAME
211: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
212: ,P_SQLCODE => SQLCODE
213: ,P_SQLERRM => SQLERRM
214: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
215: ,X_MSG_COUNT => X_MSG_COUNT
216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218: End Create_monitor_condition;

Line 315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

311:
312:
313: -- Debug Message
314: IF (AS_DEBUG_LOW_ON) THEN
315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
316: END IF;
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 328: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Open Cursor to Select');

324:
325:
326: -- Debug Message
327: IF (AS_DEBUG_LOW_ON) THEN
328: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Open Cursor to Select');
329: END IF;
330:
331: Open C_Get_monitor_condition( l_tar_CONDITION_rec.MONITOR_CONDITION_ID);
332:

Line 392: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Close Cursor');

388: END IF;
389:
390: -- Debug Message
391: IF (AS_DEBUG_LOW_ON) THEN
392: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Close Cursor');
393: END IF;
394:
395: Close C_Get_monitor_condition;
396:

Line 422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Validate_monitor_condition');

418: End if;
419:
420: -- Debug message
421: IF (AS_DEBUG_LOW_ON) THEN
422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Validate_monitor_condition');
423: END IF;
424:
425: -- Invoke validation procedures
426: Validate_monitor_condition(

Line 429: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

425: -- Invoke validation procedures
426: Validate_monitor_condition(
427: p_init_msg_list => FND_API.G_FALSE,
428: p_validation_level => p_validation_level,
429: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
430: P_CONDITION_Rec => P_CONDITION_Rec,
431: x_return_status => x_return_status,
432: x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data);

Line 445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

441: -- Hint: Add corresponding Master-Detail business logic here if necessary.
442:
443: -- Debug Message
444: IF (AS_DEBUG_LOW_ON) THEN
445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
446: END IF;
447:
448: -- Invoke table handler(aml_MONITOR_CONDITIONS_PKG.Update_Row)
449: AML_MONITOR_CONDITIONS_PKG.Update_Row(

Line 506: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

502:
503:
504: -- Debug Message
505: IF (AS_DEBUG_LOW_ON) THEN
506: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
507: END IF;
508:
509:
510: -- Standard call to get message count and if count is 1, get message info.

Line 518: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

514: );
515:
516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
519: P_API_NAME => L_API_NAME
520: ,P_PKG_NAME => G_PKG_NAME
521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
522: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 522: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

518: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
519: P_API_NAME => L_API_NAME
520: ,P_PKG_NAME => G_PKG_NAME
521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
522: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
523: ,X_MSG_COUNT => X_MSG_COUNT
524: ,X_MSG_DATA => X_MSG_DATA
525: ,X_RETURN_STATUS => X_RETURN_STATUS);
526:

Line 528: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

524: ,X_MSG_DATA => X_MSG_DATA
525: ,X_RETURN_STATUS => X_RETURN_STATUS);
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
532: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 532: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

528: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
532: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
533: ,X_MSG_COUNT => X_MSG_COUNT
534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536:

Line 538: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536:
537: WHEN OTHERS THEN
538: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
539: P_API_NAME => L_API_NAME
540: ,P_PKG_NAME => G_PKG_NAME
541: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
542: ,P_SQLCODE => SQLCODE

Line 541: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

537: WHEN OTHERS THEN
538: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
539: P_API_NAME => L_API_NAME
540: ,P_PKG_NAME => G_PKG_NAME
541: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
542: ,P_SQLCODE => SQLCODE
543: ,P_SQLERRM => SQLERRM
544: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
545: ,X_MSG_COUNT => X_MSG_COUNT

Line 544: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

540: ,P_PKG_NAME => G_PKG_NAME
541: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
542: ,P_SQLCODE => SQLCODE
543: ,P_SQLERRM => SQLERRM
544: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548: End Update_monitor_condition;

Line 592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

588:
589:
590: -- Debug Message
591: IF (AS_DEBUG_LOW_ON) THEN
592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
593: END IF;
594:
595:
596: -- Initialize API return status to SUCCESS

Line 605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

601: --
602:
603: -- Debug Message
604: IF (AS_DEBUG_LOW_ON) THEN
605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
606: END IF;
607:
608: -- Invoke table handler(aml_MONITOR_CONDITIONS_PKG.Delete_Row)
609: AML_MONITOR_CONDITIONS_PKG.Delete_Row(

Line 624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

620:
621:
622: -- Debug Message
623: IF (AS_DEBUG_LOW_ON) THEN
624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
625: END IF;
626:
627: -- Standard call to get message count and if count is 1, get message info.
628: FND_MSG_PUB.Count_And_Get

Line 635: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

631: );
632:
633: EXCEPTION
634: WHEN FND_API.G_EXC_ERROR THEN
635: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

635: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643:

Line 645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
646: P_API_NAME => L_API_NAME
647: ,P_PKG_NAME => G_PKG_NAME
648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
646: P_API_NAME => L_API_NAME
647: ,P_PKG_NAME => G_PKG_NAME
648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
650: ,X_MSG_COUNT => X_MSG_COUNT
651: ,X_MSG_DATA => X_MSG_DATA
652: ,X_RETURN_STATUS => X_RETURN_STATUS);
653:

Line 655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

651: ,X_MSG_DATA => X_MSG_DATA
652: ,X_RETURN_STATUS => X_RETURN_STATUS);
653:
654: WHEN OTHERS THEN
655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
656: P_API_NAME => L_API_NAME
657: ,P_PKG_NAME => G_PKG_NAME
658: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
659: ,P_SQLCODE => SQLCODE

Line 658: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

654: WHEN OTHERS THEN
655: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
656: P_API_NAME => L_API_NAME
657: ,P_PKG_NAME => G_PKG_NAME
658: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
659: ,P_SQLCODE => SQLCODE
660: ,P_SQLERRM => SQLERRM
661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
662: ,X_MSG_COUNT => X_MSG_COUNT

Line 661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

657: ,P_PKG_NAME => G_PKG_NAME
658: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
659: ,P_SQLCODE => SQLCODE
660: ,P_SQLERRM => SQLERRM
661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
662: ,X_MSG_COUNT => X_MSG_COUNT
663: ,X_MSG_DATA => X_MSG_DATA
664: ,X_RETURN_STATUS => X_RETURN_STATUS);
665: End Delete_monitor_condition;

Line 695: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

691:
692: -- Initialize API return status to SUCCESS
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
696: THEN
697: IF (p_monitor_condition_id IS NOT NULL) AND
698: (p_monitor_condition_id <> FND_API.G_MISS_NUM)
699: THEN

Line 705: AS_UTILITY_PVT.Set_Message(

701: FETCH C_condition_Id_Exists into l_val;
702:
703: IF C_condition_Id_Exists%NOTFOUND
704: THEN
705: AS_UTILITY_PVT.Set_Message(
706: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
707: p_msg_name => 'API_INVALID_ID',
708: p_token1 => 'COLUMN',
709: p_token1_value => 'MONITOR_CONDITION_ID',

Line 718: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

714: END IF;
715: CLOSE C_condition_Id_Exists ;
716: END IF;
717:
718: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
719: THEN
720: -- validate NOT NULL column
721: IF (p_monitor_condition_id IS NULL) OR
722: (p_monitor_condition_id = FND_API.G_MISS_NUM)

Line 724: AS_UTILITY_PVT.Set_Message(

720: -- validate NOT NULL column
721: IF (p_monitor_condition_id IS NULL) OR
722: (p_monitor_condition_id = FND_API.G_MISS_NUM)
723: THEN
724: AS_UTILITY_PVT.Set_Message(
725: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
726: p_msg_name => 'API_MISSING_ID',
727: p_token1 => 'COLUMN',
728: p_token1_value => 'MONITOR_CONDITION_ID');

Line 737: AS_UTILITY_PVT.Set_Message(

733: FETCH C_condition_Id_Exists into l_val;
734:
735: IF C_condition_Id_Exists%NOTFOUND
736: THEN
737: AS_UTILITY_PVT.Set_Message(
738: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
739: p_msg_name => 'API_INVALID_ID',
740: p_token1 => 'COLUMN',
741: p_token1_value => 'MONITOR_CONDITION_ID',

Line 793: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

789: BEGIN
790:
791: -- Debug Message
792: IF (AS_DEBUG_LOW_ON) THEN
793: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
794: END IF;
795:
796: -- Initialize API return status to SUCCESS
797: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 915: AS_UTILITY_PVT.Set_Message(

911:
912: OPEN C_time_lag_to_stage_exists(P_CONDITION_Rec.TIME_LAG_TO_STAGE);
913: FETCH C_time_lag_to_stage_exists INTO l_val;
914: IF C_time_lag_to_stage_exists%NOTFOUND THEN
915: AS_UTILITY_PVT.Set_Message(
916: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
917: p_msg_name => 'API_INVALID_ID',
918: p_token1 => 'COLUMN',
919: p_token1_value => 'TIME_LAG_TO_STAGE',

Line 993: AS_UTILITY_PVT.Set_Message(

989:
990: IF ((P_CONDITION_Rec.Reminder_Defined = 'N') AND
991: (P_CONDITION_Rec.Total_Reminders IS NOT NULL OR P_CONDITION_Rec.Reminder_Frequency IS NOT NULL)) THEN
992:
993: AS_UTILITY_PVT.Set_Message(
994: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
995: p_msg_name => 'AS_LEAD_MNTR_REMIND_CLR');
996:
997: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1016: AS_UTILITY_PVT.Set_Message(

1012: END IF;
1013:
1014: IF (P_CONDITION_Rec.Timeout_Defined = 'N' AND P_CONDITION_Rec.Timeout_Duration IS NOT NULL) THEN
1015:
1016: AS_UTILITY_PVT.Set_Message(
1017: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1018: p_msg_name => 'AS_LEAD_MNTR_TMOUT_CLR');
1019:
1020: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1043: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1039:
1040:
1041: -- Debug Message
1042: IF (AS_DEBUG_LOW_ON) THEN
1043: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1044: END IF;
1045:
1046: END Validate_monitor_condition;
1047: