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.PV_SELCRIT_PVT dependencies on AS_UTILITY_PVT

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

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

Line 90: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');

86:
87: -- Debug message
88: IF (AS_DEBUG_HIGH_ON) THEN
89:
90: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');
91: END IF;
92:
93: -- Invoke validation procedures
94: Validate_selcrit(

Line 97: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

93: -- Invoke validation procedures
94: Validate_selcrit(
95: p_init_msg_list => FND_API.G_FALSE,
96: p_validation_level => p_validation_level,
97: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
98: P_SELCRIT_Rec => P_SELCRIT_Rec,
99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data);

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

132:
133: -- Debug Message
134: IF (AS_DEBUG_HIGH_ON) THEN
135:
136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137: END IF;
138:
139: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row)
140: PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row(

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

190:
191: -- Debug Message
192: IF (AS_DEBUG_HIGH_ON) THEN
193:
194: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
195: END IF;
196:
197:
198: -- Standard call to get message count and if count is 1, get message info.

Line 206: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

202: );
203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
207: P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
210: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 210: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

206: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
207: P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
210: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
211: ,X_MSG_COUNT => X_MSG_COUNT
212: ,X_MSG_DATA => X_MSG_DATA
213: ,X_RETURN_STATUS => X_RETURN_STATUS);
214:

Line 216: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

212: ,X_MSG_DATA => X_MSG_DATA
213: ,X_RETURN_STATUS => X_RETURN_STATUS);
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
217: P_API_NAME => L_API_NAME
218: ,P_PKG_NAME => G_PKG_NAME
219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

216: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
217: P_API_NAME => L_API_NAME
218: ,P_PKG_NAME => G_PKG_NAME
219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
221: ,X_MSG_COUNT => X_MSG_COUNT
222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);
224:

Line 226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);
224:
225: WHEN OTHERS THEN
226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
230: ,P_SQLCODE => SQLCODE

Line 229: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

225: WHEN OTHERS THEN
226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
230: ,P_SQLCODE => SQLCODE
231: ,P_SQLERRM => SQLERRM
232: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
233: ,X_MSG_COUNT => X_MSG_COUNT

Line 232: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
230: ,P_SQLCODE => SQLCODE
231: ,P_SQLERRM => SQLERRM
232: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
233: ,X_MSG_COUNT => X_MSG_COUNT
234: ,X_MSG_DATA => X_MSG_DATA
235: ,X_RETURN_STATUS => X_RETURN_STATUS);
236: End Create_selcrit;

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

287:
288: -- Debug Message
289: IF (AS_DEBUG_HIGH_ON) THEN
290:
291: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
292: END IF;
293:
294:
295: -- Initialize API return status to SUCCESS

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

301:
302: -- Debug Message
303: IF (AS_DEBUG_HIGH_ON) THEN
304:
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
306: END IF;
307:
308: Open C_Get_selcrit( l_tar_SELCRIT_rec.SELECTION_CRITERIA_ID);
309: Fetch C_Get_selcrit into

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

321: END IF;
322: -- Debug Message
323: IF (AS_DEBUG_HIGH_ON) THEN
324:
325: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
326: END IF;
327: Close C_Get_selcrit;
328:
329: If (l_tar_SELCRIT_rec.object_version_number is NULL or

Line 353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');

349:
350: -- Debug message
351: IF (AS_DEBUG_HIGH_ON) THEN
352:
353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');
354: END IF;
355:
356: -- Invoke validation procedures
357: Validate_selcrit(

Line 360: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

356: -- Invoke validation procedures
357: Validate_selcrit(
358: p_init_msg_list => FND_API.G_FALSE,
359: p_validation_level => p_validation_level,
360: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
361: P_SELCRIT_Rec => P_SELCRIT_Rec,
362: x_return_status => x_return_status,
363: x_msg_count => x_msg_count,
364: x_msg_data => x_msg_data);

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

397:
398: -- Debug Message
399: IF (AS_DEBUG_HIGH_ON) THEN
400:
401: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
402: END IF;
403:
404: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Update_Row)
405: PV_ENTY_SELECT_CRITERIA_PKG.Update_Row(

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

448:
449: -- Debug Message
450: IF (AS_DEBUG_HIGH_ON) THEN
451:
452: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
453: END IF;
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.

Line 464: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

460: );
461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

464: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
469: ,X_MSG_COUNT => X_MSG_COUNT
470: ,X_MSG_DATA => X_MSG_DATA
471: ,X_RETURN_STATUS => X_RETURN_STATUS);
472:

Line 474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

470: ,X_MSG_DATA => X_MSG_DATA
471: ,X_RETURN_STATUS => X_RETURN_STATUS);
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
475: P_API_NAME => L_API_NAME
476: ,P_PKG_NAME => G_PKG_NAME
477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
475: P_API_NAME => L_API_NAME
476: ,P_PKG_NAME => G_PKG_NAME
477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
479: ,X_MSG_COUNT => X_MSG_COUNT
480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);
482:

Line 484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);
482:
483: WHEN OTHERS THEN
484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
488: ,P_SQLCODE => SQLCODE

Line 487: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

483: WHEN OTHERS THEN
484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
488: ,P_SQLCODE => SQLCODE
489: ,P_SQLERRM => SQLERRM
490: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
491: ,X_MSG_COUNT => X_MSG_COUNT

Line 490: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
488: ,P_SQLCODE => SQLCODE
489: ,P_SQLERRM => SQLERRM
490: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
491: ,X_MSG_COUNT => X_MSG_COUNT
492: ,X_MSG_DATA => X_MSG_DATA
493: ,X_RETURN_STATUS => X_RETURN_STATUS);
494: End Update_selcrit;

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

543:
544: -- Debug Message
545: IF (AS_DEBUG_HIGH_ON) THEN
546:
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
548: END IF;
549:
550:
551: -- Initialize API return status to SUCCESS

Line 599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

595:
596: -- Debug Message
597: IF (AS_DEBUG_HIGH_ON) THEN
598:
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
600: 'Private API: Calling PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row');
601: END IF;
602:
603: PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row(

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

615:
616: -- Debug Message
617: IF (AS_DEBUG_HIGH_ON) THEN
618:
619: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
620: END IF;
621:
622:
623: -- Standard call to get message count and if count is 1, get message info.

Line 631: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

627: );
628:
629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
632: P_API_NAME => L_API_NAME
633: ,P_PKG_NAME => G_PKG_NAME
634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
635: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 635: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

631: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
632: P_API_NAME => L_API_NAME
633: ,P_PKG_NAME => G_PKG_NAME
634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
635: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
636: ,X_MSG_COUNT => X_MSG_COUNT
637: ,X_MSG_DATA => X_MSG_DATA
638: ,X_RETURN_STATUS => X_RETURN_STATUS);
639:

Line 641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

637: ,X_MSG_DATA => X_MSG_DATA
638: ,X_RETURN_STATUS => X_RETURN_STATUS);
639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
642: P_API_NAME => L_API_NAME
643: ,P_PKG_NAME => G_PKG_NAME
644: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
645: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 645: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 651: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

647: ,X_MSG_DATA => X_MSG_DATA
648: ,X_RETURN_STATUS => X_RETURN_STATUS);
649:
650: WHEN OTHERS THEN
651: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
652: P_API_NAME => L_API_NAME
653: ,P_PKG_NAME => G_PKG_NAME
654: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
655: ,P_SQLCODE => SQLCODE

Line 654: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

650: WHEN OTHERS THEN
651: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
652: P_API_NAME => L_API_NAME
653: ,P_PKG_NAME => G_PKG_NAME
654: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
655: ,P_SQLCODE => SQLCODE
656: ,P_SQLERRM => SQLERRM
657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
658: ,X_MSG_COUNT => X_MSG_COUNT

Line 657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

653: ,P_PKG_NAME => G_PKG_NAME
654: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
655: ,P_SQLCODE => SQLCODE
656: ,P_SQLERRM => SQLERRM
657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);
661: End Delete_selcrit;

Line 692: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 697: AS_UTILITY_PVT.Set_Message(

693: THEN
694: IF (p_selection_criteria_id IS NOT NULL) AND
695: (p_selection_criteria_id <> FND_API.G_MISS_NUM)
696: THEN
697: AS_UTILITY_PVT.Set_Message(
698: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
699: p_msg_name => 'API_INVALID_ID',
700: p_token1 => 'selection_criteria_id',
701: p_token1_value => p_selection_criteria_id);

Line 706: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

702:
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: END IF;
705:
706: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
707: THEN
708: -- validate NOT NULL column
709: IF (p_selection_criteria_id IS NULL) OR
710: (p_selection_criteria_id = FND_API.G_MISS_NUM)

Line 712: AS_UTILITY_PVT.Set_Message(

708: -- validate NOT NULL column
709: IF (p_selection_criteria_id IS NULL) OR
710: (p_selection_criteria_id = FND_API.G_MISS_NUM)
711: THEN
712: AS_UTILITY_PVT.Set_Message(
713: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
714: p_msg_name => 'API_MISSING_LEAD_ID');
715:
716: x_return_status := FND_API.G_RET_STS_ERROR;

Line 723: AS_UTILITY_PVT.Set_Message(

719: FETCH C_selection_criteria_id_exists into l_val;
720:
721: IF C_selection_criteria_id_exists%NOTFOUND
722: THEN
723: AS_UTILITY_PVT.Set_Message(
724: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
725: p_msg_name => 'API_INVALID_ID',
726: p_token1 => 'selection_criteria_id',
727: p_token1_value => p_selection_criteria_id );

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

784:
785: -- Debug Message
786: IF (AS_DEBUG_HIGH_ON) THEN
787:
788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
789: END IF;
790:
791:
792: -- Initialize API return status to SUCCESS

Line 886: if (l_attribute_id is not null and p_validation_mode = AS_UTILITY_PVT.G_CREATE) then

882: select attribute_id into l_attribute_id from pv_enty_select_criteria
883: where process_rule_id = p_SELCRIT_REC.process_rule_id and
884: attribute_id = p_SELCRIT_REC.attribute_id;
885:
886: if (l_attribute_id is not null and p_validation_mode = AS_UTILITY_PVT.G_CREATE) then
887: FND_MESSAGE.Set_Name('PV', 'PV_DUPLICATE_TIEBR_ATTRIBUTE');
888: FND_MSG_PUB.Add;
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: raise FND_API.G_EXC_ERROR;

Line 956: if p_validation_mode = AS_UTILITY_PVT.G_CREATE and

952:
953: -- ---------------------------------------------------------------------------
954: -- Chandra added ('INPUT_FILTER', 'MONITOR_SCOPE')
955: -- ---------------------------------------------------------------------------
956: if p_validation_mode = AS_UTILITY_PVT.G_CREATE and
957: p_SELCRIT_REC.SELECTION_TYPE_CODE IN ('INPUT_FILTER', 'MONITOR_SCOPE') then
958:
959: open lc_chk_input_filter_dups (pc_rule_id => p_SELCRIT_REC.process_rule_id,
960: pc_attribute_id => p_SELCRIT_REC.attribute_id);

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

988:
989: -- Debug Message
990: IF (AS_DEBUG_HIGH_ON) THEN
991:
992: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
993: END IF;
994:
995: END Validate_selcrit;
996: