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

Line 77: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

73:
74:
75: -- Debug Message
76: IF l_debug THEN
77: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
78: 'Private API: ' || l_api_name || ' start');
79: END IF;
80:
81: -- Initialize API return status to SUCCESS

Line 138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

134:
135: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
137: IF l_debug THEN
138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: 'Private API: Get_CurrentUser fail');
140: END IF;
141: END IF;
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 171: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

167:
168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
170: IF l_debug THEN
171: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
172: 'has_updateOpportunityAccess fail');
173: END IF;
174: END IF;
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

209: END IF;
210:
211: -- Debug message
212: IF l_debug THEN
213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
214: 'Private API: Validate_opp_contact');
215: END IF;
216:
217: -- Invoke validation procedures

Line 221: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

217: -- Invoke validation procedures
218: Validate_opp_contact(
219: p_init_msg_list => FND_API.G_FALSE,
220: p_validation_level => p_validation_level,
221: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
222: P_Contact_Rec => l_Contact_Rec,
223: x_return_status => x_return_status,
224: x_msg_count => x_msg_count,
225: x_msg_data => x_msg_data);

Line 231: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

227:
228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
229: -- Debug message
230: IF l_debug THEN
231: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
232: 'Private API: Validate_opp_Contact fail');
233: END IF;
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;

Line 240: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

236:
237:
238: -- Debug Message
239: IF l_debug THEN
240: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
241: 'Private API: Calling create table handler');
242: END IF;
243: -- the following condition and updation added for Bug#4641320
244: IF l_Contact_rec.PRIMARY_CONTACT_FLAG = 'Y'

Line 307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: IF l_debug THEN
307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
308: 'Private API: Created lead_contact_id = ' || l_LEAD_CONTACT_ID);
309: END IF;
310:
311: END LOOP;

Line 325: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

321:
322:
323: -- Debug Message
324: IF l_debug THEN
325: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
326: 'Private API: ' || l_api_name || ' end');
327:
328: END IF;
329: -- Standard call to get message count and if count is 1, get message info.

Line 357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

353: */
354:
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
358: P_MODULE => l_module
359: ,P_API_NAME => L_API_NAME
360: ,P_PKG_NAME => G_PKG_NAME
361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

358: P_MODULE => l_module
359: ,P_API_NAME => L_API_NAME
360: ,P_PKG_NAME => G_PKG_NAME
361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
363: ,X_MSG_COUNT => X_MSG_COUNT
364: ,X_MSG_DATA => X_MSG_DATA
365: ,X_RETURN_STATUS => X_RETURN_STATUS);
366:

Line 368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

364: ,X_MSG_DATA => X_MSG_DATA
365: ,X_RETURN_STATUS => X_RETURN_STATUS);
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_MODULE => l_module
370: ,P_API_NAME => L_API_NAME
371: ,P_PKG_NAME => G_PKG_NAME
372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 373: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

369: P_MODULE => l_module
370: ,P_API_NAME => L_API_NAME
371: ,P_PKG_NAME => G_PKG_NAME
372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
373: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
374: ,X_MSG_COUNT => X_MSG_COUNT
375: ,X_MSG_DATA => X_MSG_DATA
376: ,X_RETURN_STATUS => X_RETURN_STATUS);
377:

Line 379: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

375: ,X_MSG_DATA => X_MSG_DATA
376: ,X_RETURN_STATUS => X_RETURN_STATUS);
377:
378: WHEN OTHERS THEN
379: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
380: P_MODULE => l_module
381: ,P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 383: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

379: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
380: P_MODULE => l_module
381: ,P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
384: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
385: ,X_MSG_COUNT => X_MSG_COUNT
386: ,X_MSG_DATA => X_MSG_DATA
387: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 384: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

380: P_MODULE => l_module
381: ,P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
384: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
385: ,X_MSG_COUNT => X_MSG_COUNT
386: ,X_MSG_DATA => X_MSG_DATA
387: ,X_RETURN_STATUS => X_RETURN_STATUS);
388: End Create_opp_contacts;

Line 454: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

450:
451:
452: -- Debug Message
453: IF l_debug THEN
454: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
455: 'Private API: ' || l_api_name || ' start');
456: END IF;
457:
458:

Line 500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

496:
497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
499: IF l_debug THEN
500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
501: 'Private API: Get_CurrentUser fail');
502: END IF;
503: END IF;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 533: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

529:
530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
532: IF l_debug THEN
533: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'has_updateOpportunityAccess fail');
535: END IF;
536: END IF;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

572: END IF;
573:
574: -- Debug Message
575: IF l_debug THEN
576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
577: 'Private API: - Open Cursor to Select');
578:
579: END IF;
580:

Line 597: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

593: END IF;
594:
595: -- Debug Message
596: IF l_debug THEN
597: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
598: 'Private API: - Close Cursor');
599: END IF;
600:
601: Close C_Get_opp_contact;

Line 626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

622: End if;
623:
624: -- Debug message
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Private API: Validate_opp_contact');
628:
629: END IF;
630: -- Invoke validation procedures

Line 634: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

630: -- Invoke validation procedures
631: Validate_opp_contact(
632: p_init_msg_list => FND_API.G_FALSE,
633: p_validation_level => p_validation_level,
634: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
635: P_Contact_Rec => l_Contact_Rec,
636: x_return_status => x_return_status,
637: x_msg_count => x_msg_count,
638: x_msg_data => x_msg_data);

Line 643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

639:
640: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
641: -- Debug message
642: IF l_debug THEN
643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
644: 'Private API: Validate_opp_Contact fail');
645: END IF;
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;

Line 651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

647: END IF;
648:
649: -- Debug Message
650: IF l_debug THEN
651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Private API: Calling update table handler');
653:
654: END IF;
655: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Update_Row)

Line 704: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: IF l_debug THEN
704: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
705: 'Private API: Updated lead_contact_id = ' ||l_Contact_rec.LEAD_CONTACT_ID );
706: END IF;
707: END LOOP;
708:

Line 722: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

718:
719:
720: -- Debug Message
721: IF l_debug THEN
722: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
723: 'Private API: ' || l_api_name || ' end');
724: END IF;
725:
726:

Line 755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

751: END IF;
752: */
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
756: P_MODULE => l_module
757: ,P_API_NAME => L_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 760: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

756: P_MODULE => l_module
757: ,P_API_NAME => L_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
760: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
761: ,X_MSG_COUNT => X_MSG_COUNT
762: ,X_MSG_DATA => X_MSG_DATA
763: ,X_RETURN_STATUS => X_RETURN_STATUS);
764:

Line 766: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

762: ,X_MSG_DATA => X_MSG_DATA
763: ,X_RETURN_STATUS => X_RETURN_STATUS);
764:
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
767: P_MODULE => l_module
768: ,P_API_NAME => L_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 771: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

767: P_MODULE => l_module
768: ,P_API_NAME => L_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
771: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
772: ,X_MSG_COUNT => X_MSG_COUNT
773: ,X_MSG_DATA => X_MSG_DATA
774: ,X_RETURN_STATUS => X_RETURN_STATUS);
775:

Line 777: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

773: ,X_MSG_DATA => X_MSG_DATA
774: ,X_RETURN_STATUS => X_RETURN_STATUS);
775:
776: WHEN OTHERS THEN
777: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
778: P_MODULE => l_module
779: ,P_API_NAME => L_API_NAME
780: ,P_PKG_NAME => G_PKG_NAME
781: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 781: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

777: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
778: P_MODULE => l_module
779: ,P_API_NAME => L_API_NAME
780: ,P_PKG_NAME => G_PKG_NAME
781: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
782: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
783: ,X_MSG_COUNT => X_MSG_COUNT
784: ,X_MSG_DATA => X_MSG_DATA
785: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 782: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

778: P_MODULE => l_module
779: ,P_API_NAME => L_API_NAME
780: ,P_PKG_NAME => G_PKG_NAME
781: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
782: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
783: ,X_MSG_COUNT => X_MSG_COUNT
784: ,X_MSG_DATA => X_MSG_DATA
785: ,X_RETURN_STATUS => X_RETURN_STATUS);
786: End Update_opp_contacts;

Line 840: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

836:
837:
838: -- Debug Message
839: IF l_debug THEN
840: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
841: 'Private API: ' || l_api_name || ' start');
842: END IF;
843:
844:

Line 886: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

882:
883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
885: IF l_debug THEN
886: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
887: 'Private API: Get_CurrentUser fail');
888: END IF;
889: END IF;
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

915:
916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
917: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
918: IF l_debug THEN
919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
920: 'has_updateOpportunityAccess fail');
921: END IF;
922: END IF;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 955: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

951:
952:
953: -- Debug Message
954: IF l_debug THEN
955: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
956: 'Private API: Calling delete table handler');
957:
958: END IF;
959: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Delete_Row)

Line 986: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

982:
983:
984: -- Debug Message
985: IF l_debug THEN
986: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
987: 'Private API: ' || l_api_name || ' end');
988: END IF;
989:
990: -- Standard call to get message count and if count is 1, get message info.

Line 1018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1014: END IF;
1015: */
1016: EXCEPTION
1017: WHEN FND_API.G_EXC_ERROR THEN
1018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_MODULE => l_module
1020: ,P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1019: P_MODULE => l_module
1020: ,P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1024: ,X_MSG_COUNT => X_MSG_COUNT
1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);
1027:

Line 1029: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);
1027:
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1030: P_MODULE => l_module
1031: ,P_API_NAME => L_API_NAME
1032: ,P_PKG_NAME => G_PKG_NAME
1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1034: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1030: P_MODULE => l_module
1031: ,P_API_NAME => L_API_NAME
1032: ,P_PKG_NAME => G_PKG_NAME
1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1034: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1035: ,X_MSG_COUNT => X_MSG_COUNT
1036: ,X_MSG_DATA => X_MSG_DATA
1037: ,X_RETURN_STATUS => X_RETURN_STATUS);
1038:

Line 1040: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1036: ,X_MSG_DATA => X_MSG_DATA
1037: ,X_RETURN_STATUS => X_RETURN_STATUS);
1038:
1039: WHEN OTHERS THEN
1040: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1041: P_MODULE => l_module
1042: ,P_API_NAME => L_API_NAME
1043: ,P_PKG_NAME => G_PKG_NAME
1044: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1044: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1040: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1041: P_MODULE => l_module
1042: ,P_API_NAME => L_API_NAME
1043: ,P_PKG_NAME => G_PKG_NAME
1044: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1045: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1046: ,X_MSG_COUNT => X_MSG_COUNT
1047: ,X_MSG_DATA => X_MSG_DATA
1048: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1045: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1041: P_MODULE => l_module
1042: ,P_API_NAME => L_API_NAME
1043: ,P_PKG_NAME => G_PKG_NAME
1044: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1045: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1046: ,X_MSG_COUNT => X_MSG_COUNT
1047: ,X_MSG_DATA => X_MSG_DATA
1048: ,X_RETURN_STATUS => X_RETURN_STATUS);
1049: End Delete_opp_contacts;

Line 1089: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087:
1088: -- Calling from Create API
1089: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1090: THEN
1091: IF (p_LEAD_CONTACT_ID is NOT NULL) and (p_LEAD_CONTACT_ID <> FND_API.G_MISS_NUM)
1092: THEN
1093: OPEN C_Lead_Contact_Id_Exists (p_Lead_Contact_Id);

Line 1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1093: OPEN C_Lead_Contact_Id_Exists (p_Lead_Contact_Id);
1094: FETCH C_Lead_Contact_Id_Exists into l_val;
1095: IF C_Lead_Contact_Id_Exists%FOUND THEN
1096: IF l_debug THEN
1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1098: 'Private API: LEAD_CONTACT_ID exist');
1099: END IF;
1100:
1101: AS_UTILITY_PVT.Set_Message(

Line 1101: AS_UTILITY_PVT.Set_Message(

1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1098: 'Private API: LEAD_CONTACT_ID exist');
1099: END IF;
1100:
1101: AS_UTILITY_PVT.Set_Message(
1102: p_module => l_module,
1103: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1104: p_msg_name => 'AS_INVALID_ID',
1105: p_token1 => 'FIELD_ID',

Line 1114: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1110: CLOSE C_Lead_Contact_Id_Exists;
1111: END IF;
1112:
1113: -- Calling from Update API
1114: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1115: THEN
1116: -- validate NOT NULL column
1117: IF (p_LEAD_CONTACT_ID is NULL) or (p_LEAD_CONTACT_ID = FND_API.G_MISS_NUM)
1118: THEN

Line 1120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1116: -- validate NOT NULL column
1117: IF (p_LEAD_CONTACT_ID is NULL) or (p_LEAD_CONTACT_ID = FND_API.G_MISS_NUM)
1118: THEN
1119: IF l_debug THEN
1120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1121: 'Private API: Violate NOT NULL constraint(LEAD_CONTACT_ID)');
1122: END IF;
1123:
1124: AS_UTILITY_PVT.Set_Message(

Line 1124: AS_UTILITY_PVT.Set_Message(

1120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1121: 'Private API: Violate NOT NULL constraint(LEAD_CONTACT_ID)');
1122: END IF;
1123:
1124: AS_UTILITY_PVT.Set_Message(
1125: p_module => l_module,
1126: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1127: p_msg_name => 'AS_INVALID_ID',
1128: p_token1 => 'FIELD_ID',

Line 1138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1134: FETCH C_Lead_Contact_Id_Exists into l_val;
1135: IF C_Lead_Contact_Id_Exists%NOTFOUND
1136: THEN
1137: IF l_debug THEN
1138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1139: 'Private API: LEAD_CONTACT_ID is not valid');
1140: END IF;
1141:
1142: AS_UTILITY_PVT.Set_Message(

Line 1142: AS_UTILITY_PVT.Set_Message(

1138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1139: 'Private API: LEAD_CONTACT_ID is not valid');
1140: END IF;
1141:
1142: AS_UTILITY_PVT.Set_Message(
1143: p_module => l_module,
1144: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1145: p_msg_name => 'AS_INVALID_ID',
1146: p_token1 => 'FIELD_ID',

Line 1200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1196:
1197: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1198: THEN
1199: IF l_debug THEN
1200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1201: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
1202: END IF;
1203:
1204: AS_UTILITY_PVT.Set_Message(

Line 1204: AS_UTILITY_PVT.Set_Message(

1200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1201: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
1202: END IF;
1203:
1204: AS_UTILITY_PVT.Set_Message(
1205: p_module => l_module,
1206: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1207: p_msg_name => 'AS_INVALID_ID',
1208: p_token1 => 'FIELD_ID',

Line 1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1214: FETCH C_Lead_Id_Exists into l_val;
1215: IF C_Lead_Id_Exists%NOTFOUND
1216: THEN
1217: IF l_debug THEN
1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1219: 'Private API: LEAD_ID is not valid');
1220: END IF;
1221:
1222: AS_UTILITY_PVT.Set_Message(

Line 1222: AS_UTILITY_PVT.Set_Message(

1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1219: 'Private API: LEAD_ID is not valid');
1220: END IF;
1221:
1222: AS_UTILITY_PVT.Set_Message(
1223: p_module => l_module,
1224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1225: p_msg_name => 'AS_INVALID_ID',
1226: p_token1 => 'FIELD_ID',

Line 1283: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1279: OPEN C_CONTACT_ID_Exists (p_CONTACT_ID);
1280: FETCH C_CONTACT_ID_Exists into l_val;
1281: IF C_CONTACT_ID_Exists%NOTFOUND THEN
1282: IF l_debug THEN
1283: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1284: 'Private API: CONTACT_ID is invalid');
1285: END IF;
1286:
1287: AS_UTILITY_PVT.Set_Message(

Line 1287: AS_UTILITY_PVT.Set_Message(

1283: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1284: 'Private API: CONTACT_ID is invalid');
1285: END IF;
1286:
1287: AS_UTILITY_PVT.Set_Message(
1288: p_module => l_module,
1289: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1290: p_msg_name => 'AS_INVALID_ID',
1291: p_token1 => 'FIELD_ID',

Line 1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1334: p_ENABLED_FLAG = FND_API.G_MISS_CHAR )
1335: THEN
1336: --The following code commented by SUBABU for Bug#3537692(ASN)
1337: /*IF l_debug THEN
1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1339: 'Private API: Violate NOT NULL constraint(ENABLED_FLAG)');
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;*/
1342: NULL;

Line 1348: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1344: IF (UPPER(p_ENABLED_FLAG) <> 'Y') and
1345: (UPPER(p_ENABLED_FLAG) <> 'N')
1346: THEN
1347: IF l_debug THEN
1348: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1349: 'Private API: ENABLED_FLAG is invalid');
1350:
1351: END IF;
1352:

Line 1353: AS_UTILITY_PVT.Set_Message(

1349: 'Private API: ENABLED_FLAG is invalid');
1350:
1351: END IF;
1352:
1353: AS_UTILITY_PVT.Set_Message(
1354: p_module => l_module,
1355: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1356: p_msg_name => 'AS_INVALID_ID',
1357: p_token1 => 'FIELD_ID',

Line 1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1404:
1405: IF (p_CUSTOMER_ID is NULL) or (p_CUSTOMER_ID = FND_API.G_MISS_NUM)
1406: THEN
1407: IF l_debug THEN
1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1409: 'Private API: Violate NOT NULL constraint(CUSTOMER_ID)');
1410: END IF;
1411:
1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1409: 'Private API: Violate NOT NULL constraint(CUSTOMER_ID)');
1410: END IF;
1411:
1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1413: p_module => l_module,
1414: p_msg_name => 'AS_INVALID_ID',
1415: p_token1 => 'FIELD_ID',
1416: p_token1_value => 'CUSTOMER_ID');

Line 1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1421: FETCH C_Customer_Id_Exists into l_val;
1422: IF C_Customer_Id_Exists%NOTFOUND
1423: THEN
1424: IF l_debug THEN
1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1426: 'Private API: CUSTOMER_ID is not valid');
1427: END IF;
1428:
1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1426: 'Private API: CUSTOMER_ID is not valid');
1427: END IF;
1428:
1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1430: p_module => l_module,
1431: p_msg_name => 'AS_INVALID_ID',
1432: p_token1 => 'FIELD_ID',
1433: p_token1_value => 'CUSTOMER_ID');

Line 1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1485: OPEN C_ADDRESS_ID_Exists (p_ADDRESS_ID);
1486: FETCH C_ADDRESS_ID_Exists into l_val;
1487: IF C_ADDRESS_ID_Exists%NOTFOUND THEN
1488: IF l_debug THEN
1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1490: 'Private API: ADDRESS_ID is invalid');
1491: END IF;
1492:
1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1490: 'Private API: ADDRESS_ID is invalid');
1491: END IF;
1492:
1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1494: p_module => l_module,
1495: p_msg_name => 'AS_INVALID_ID',
1496: p_token1 => 'FIELD_ID',
1497: p_token1_value => 'ADDRESS_ID');

Line 1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1550: OPEN C_RANK_Exists ( p_RANK);
1551: FETCH C_RANK_Exists into l_val;
1552: IF C_RANK_Exists%NOTFOUND THEN
1553: IF l_debug THEN
1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1555: 'Private API: RANK is invalid');
1556: END IF;
1557:
1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1555: 'Private API: RANK is invalid');
1556: END IF;
1557:
1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1559: p_module => l_module,
1560: p_msg_name => 'AS_INVALID_ID',
1561: p_token1 => 'FIELD_ID',
1562: p_token1_value => 'RANK');

Line 1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1616: OPEN C_PHONE_ID_Exists (p_PHONE_ID);
1617: FETCH C_PHONE_ID_Exists into l_val;
1618: IF C_PHONE_ID_Exists%NOTFOUND THEN
1619: IF l_debug THEN
1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1621: 'Private API: PHONE_ID is invalid');
1622: END IF;
1623:
1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1621: 'Private API: PHONE_ID is invalid');
1622: END IF;
1623:
1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1625: p_module => l_module,
1626: p_msg_name => 'AS_INVALID_ID',
1627: p_token1 => 'FIELD_ID',
1628: p_token1_value => 'PHONE_ID');

Line 1673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1669: p_PRIMARY_CONTACT_FLAG = FND_API.G_MISS_CHAR )
1670: THEN
1671: NULL;
1672: /* Not required item
1673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1674: 'Private API: Violate NOT NULL constraint(PRIMARY_CONTACT_FLAG)');
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: */
1677: ELSE

Line 1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1678: IF (UPPER(p_PRIMARY_CONTACT_FLAG) <> 'Y') and
1679: (UPPER(p_PRIMARY_CONTACT_FLAG) <> 'N')
1680: THEN
1681: IF l_debug THEN
1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1683: 'Private API: PRIMARY_CONTACT_FLAG is invalid');
1684:
1685: END IF;
1686:

Line 1687: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1683: 'Private API: PRIMARY_CONTACT_FLAG is invalid');
1684:
1685: END IF;
1686:
1687: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1688: p_module => l_module,
1689: p_msg_name => 'AS_INVALID_ID',
1690: p_token1 => 'FIELD_ID',
1691: p_token1_value => 'PRIMARY_CONTACT_FLAG');

Line 1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1752:
1753: IF (p_CONTACT_PARTY_ID is NULL) OR (p_CONTACT_PARTY_ID = FND_API.G_MISS_NUM)
1754: THEN
1755: IF l_debug THEN
1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1757: 'Private API: Violate NOT NULL CONTACT_PARTY_ID');
1758: END IF;
1759:
1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1757: 'Private API: Violate NOT NULL CONTACT_PARTY_ID');
1758: END IF;
1759:
1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1761: p_module => l_module,
1762: p_msg_name => 'AS_INVALID_ID',
1763: p_token1 => 'FIELD_ID',
1764: p_token1_value => 'CONTACT_PARTY_ID');

Line 1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1772: FETCH C_CONTACT_PARTY_ID_Exists into l_val;
1773: IF C_CONTACT_PARTY_ID_Exists%NOTFOUND
1774: THEN
1775: IF l_debug THEN
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1777: 'Private API: CONTACT_PARTY_ID is not valid');
1778: END IF;
1779:
1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1777: 'Private API: CONTACT_PARTY_ID is not valid');
1778: END IF;
1779:
1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1781: p_module => l_module,
1782: p_msg_name => 'AS_INVALID_ID',
1783: p_token1 => 'FIELD_ID',
1784: p_token1_value => 'CONTACT_PARTY_ID');

Line 1793: IF C_contact_party_id_dup%FOUND and P_Validation_mode = AS_UTILITY_PVT.G_CREATE THEN

1789:
1790: -- mohali changes for bug 5285071
1791: OPEN C_contact_party_id_dup(p_lead_id, p_contact_party_id);
1792: FETCH C_contact_party_id_dup into l_dup;
1793: IF C_contact_party_id_dup%FOUND and P_Validation_mode = AS_UTILITY_PVT.G_CREATE THEN
1794: IF l_debug THEN
1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1796: 'Private API: CONTACT_PARTY_ID is Duplicate');
1797: END IF;

Line 1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1791: OPEN C_contact_party_id_dup(p_lead_id, p_contact_party_id);
1792: FETCH C_contact_party_id_dup into l_dup;
1793: IF C_contact_party_id_dup%FOUND and P_Validation_mode = AS_UTILITY_PVT.G_CREATE THEN
1794: IF l_debug THEN
1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1796: 'Private API: CONTACT_PARTY_ID is Duplicate');
1797: END IF;
1798:
1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1796: 'Private API: CONTACT_PARTY_ID is Duplicate');
1797: END IF;
1798:
1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1800: p_module => l_module,
1801: p_msg_name => 'API_POSSIBLE_DUP_CONTACT',
1802: p_token1 => 'CONTACT_ID',
1803: p_token1_value => p_CONTACT_PARTY_ID,

Line 1824: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use

1820: END Validate_CONTACT_PARTY_ID;
1821:
1822:
1823: -- Hint: inter-field level validation can be added here.
1824: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use
1825: -- cursor to get old values for all fields used in inter-field validation
1826: -- and set all G_MISS_XXX fields to original value stored in database
1827: -- table.
1828: PROCEDURE Validate_Contact_rec(

Line 1858: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1854: -- x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: -- Debug Message
1857: IF l_debug THEN
1858: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1859: 'Private API: Validated Record');
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get

Line 1887: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1883: BEGIN
1884:
1885: -- Debug Message
1886: IF l_debug THEN
1887: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1888: 'Private API: ' || l_api_name || ' start');
1889: END IF;
1890:
1891: -- Initialize API return status to SUCCESS

Line 1898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1894: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1895: -- Hint: We provide validation procedure for every column. Developer
1896: -- should delete unnecessary validation procedures.
1897: IF l_debug THEN
1898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1899: 'Private API: Validate items start');
1900:
1901: END IF;
1902:

Line 1915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1912: raise FND_API.G_EXC_ERROR;
1913: END IF;
1914: IF l_debug THEN
1915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1916: 'Private API: Validated LEAD_CONTACT_ID ');
1917:
1918: END IF;
1919:

Line 1932: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1929: raise FND_API.G_EXC_ERROR;
1930: END IF;
1931: IF l_debug THEN
1932: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1933: 'Private API: Validated LEAD_ID ');
1934:
1935: END IF;
1936:

Line 1949: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: raise FND_API.G_EXC_ERROR;
1947: END IF;
1948: IF l_debug THEN
1949: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1950: 'Private API: Validated CUSTOMER_ID ');
1951: END IF;
1952:
1953:

Line 1967: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: raise FND_API.G_EXC_ERROR;
1965: END IF;
1966: IF l_debug THEN
1967: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1968: 'Private API: Validated ADDRESS_ID ');
1969: END IF;
1970:
1971: Validate_CONTACT_PARTY_ID(

Line 1985: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1981: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: raise FND_API.G_EXC_ERROR;
1983: END IF;
1984: IF l_debug THEN
1985: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'Private API: Validated CONTACT_PARTY_ID');
1987:
1988: END IF;
1989:

Line 2003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2000: raise FND_API.G_EXC_ERROR;
2001: END IF;
2002: IF l_debug THEN
2003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2004: 'Private API: Validated CONTACT_ID ');
2005:
2006: END IF;
2007:

Line 2022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2019: raise FND_API.G_EXC_ERROR;
2020: END IF;
2021: IF l_debug THEN
2022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2023: 'Private API: Validated PHONE_ID ');
2024:
2025: END IF;
2026:

Line 2039: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2036: raise FND_API.G_EXC_ERROR;
2037: END IF;
2038: IF l_debug THEN
2039: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2040: 'Private API: Validated RANK ');
2041:
2042: END IF;
2043:

Line 2056: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2053: raise FND_API.G_EXC_ERROR;
2054: END IF;
2055: IF l_debug THEN
2056: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2057: 'Private API: Validated ENABLED_FLAG ');
2058:
2059: END IF;
2060:

Line 2073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2070: raise FND_API.G_EXC_ERROR;
2071: END IF;
2072: IF l_debug THEN
2073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2074: 'Private API: Validated PRIMARY_CONTACT_FLAG ');
2075:
2076: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2077: 'Private API: Validate items end');

Line 2076: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2072: IF l_debug THEN
2073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2074: 'Private API: Validated PRIMARY_CONTACT_FLAG ');
2075:
2076: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2077: 'Private API: Validate items end');
2078: END IF;
2079:
2080: END IF;

Line 2111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2107:
2108:
2109: -- Debug Message
2110: IF l_debug THEN
2111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2112: 'Private API: ' || l_api_name || ' end');
2113: END IF;
2114: END Validate_opp_contact;
2115: