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_SALES_LEAD_CONTACTS_PVT dependencies on AS_UTILITY_PVT

Line 104: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

100: FETCH C_CONTACT_ID_Exists into l_val;
101: IF C_CONTACT_ID_Exists%NOTFOUND THEN
102: IF (AS_DEBUG_LOW_ON) THEN
103:
104: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
105: 'Private API: CONTACT_ID is invalid');
106: END IF;
107:
108: AS_UTILITY_PVT.Set_Message(

Line 108: AS_UTILITY_PVT.Set_Message(

104: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
105: 'Private API: CONTACT_ID is invalid');
106: END IF;
107:
108: AS_UTILITY_PVT.Set_Message(
109: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
110: p_msg_name => 'API_INVALID_ID',
111: p_token1 => 'COLUMN',
112: p_token1_value => 'CONTACT_ID',

Line 176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

172: IF (p_CONTACT_PARTY_ID is NULL)
173: THEN
174: IF (AS_DEBUG_LOW_ON) THEN
175:
176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
177: 'Private API: Violate NOT NULL(CONTACT_PARTY_ID)');
178: END IF;
179:
180: AS_UTILITY_PVT.Set_Message(

Line 180: AS_UTILITY_PVT.Set_Message(

176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
177: 'Private API: Violate NOT NULL(CONTACT_PARTY_ID)');
178: END IF;
179:
180: AS_UTILITY_PVT.Set_Message(
181: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
182: p_msg_name => 'API_MISSING_ID',
183: p_token1 => 'COLUMN',
184: p_token1_value => 'CONTACT_PARTY_ID');

Line 191: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE) and

187:
188: ELSE -- p_CONTACT_PARTY_ID is NOT NULL
189:
190: -- Calling from Create APIs, CONTACT_PARTY_ID can not be G_MISS_NUM
191: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE) and
192: (p_CONTACT_PARTY_ID = FND_API.G_MISS_NUM)
193: THEN
194: -- IF (AS_DEBUG_ERROR_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
195: -- 'Private API: CONTACT_PARTY_ID is missing'); END IF;

Line 194: -- IF (AS_DEBUG_ERROR_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

190: -- Calling from Create APIs, CONTACT_PARTY_ID can not be G_MISS_NUM
191: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE) and
192: (p_CONTACT_PARTY_ID = FND_API.G_MISS_NUM)
193: THEN
194: -- IF (AS_DEBUG_ERROR_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
195: -- 'Private API: CONTACT_PARTY_ID is missing'); END IF;
196:
197: AS_UTILITY_PVT.Set_Message(
198: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 197: AS_UTILITY_PVT.Set_Message(

193: THEN
194: -- IF (AS_DEBUG_ERROR_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
195: -- 'Private API: CONTACT_PARTY_ID is missing'); END IF;
196:
197: AS_UTILITY_PVT.Set_Message(
198: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
199: p_msg_name => 'API_MISSING_CONTACT_PARTY_ID');
200:
201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

208: IF C_CONTACT_PARTY_ID_Exists%NOTFOUND
209: THEN
210: IF (AS_DEBUG_LOW_ON) THEN
211:
212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
213: 'Private API: CONTACT_PARTY_ID is invalid');
214: END IF;
215:
216: AS_UTILITY_PVT.Set_Message(

Line 216: AS_UTILITY_PVT.Set_Message(

212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
213: 'Private API: CONTACT_PARTY_ID is invalid');
214: END IF;
215:
216: AS_UTILITY_PVT.Set_Message(
217: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
218: p_msg_name => 'API_INVALID_ID',
219: p_token1 => 'COLUMN',
220: p_token1_value => 'CONTACT_PARTY_ID',

Line 288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

284: FETCH C_PHONE_ID_Exists into l_val;
285: IF C_PHONE_ID_Exists%NOTFOUND THEN
286: IF (AS_DEBUG_LOW_ON) THEN
287:
288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
289: 'Private API: PHONE_ID is invalid');
290: END IF;
291:
292: AS_UTILITY_PVT.Set_Message(

Line 292: AS_UTILITY_PVT.Set_Message(

288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
289: 'Private API: PHONE_ID is invalid');
290: END IF;
291:
292: AS_UTILITY_PVT.Set_Message(
293: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
294: p_msg_name => 'API_INVALID_ID',
295: p_token1 => 'COLUMN',
296: p_token1_value => 'PHONE_ID',

Line 343: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: -- Debug Message
343: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
344: -- 'Validate contact role code'); END IF;
345:
346: -- Validate contact role code
347: IF (p_contact_role_code is NOT NULL

Line 355: AS_UTILITY_PVT.Set_Message(

351: FETCH C_Lookup_Exists into l_val;
352:
353: IF C_Lookup_Exists%NOTFOUND
354: THEN
355: AS_UTILITY_PVT.Set_Message(
356: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
357: p_msg_name => 'API_INVALID_ID',
358: p_token1 => 'COLUMN',
359: p_token1_value => 'CONTACT_ROLE_CODE',

Line 410: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

406:
407: -- Debug Message
408: IF (AS_DEBUG_LOW_ON) THEN
409:
410: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
411: 'PVT: ' || l_api_name || ' Start');
412: END IF;
413:
414: -- Initialize API return status to SUCCESS

Line 531: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

527:
528: -- Debug Message
529: IF (AS_DEBUG_LOW_ON) THEN
530:
531: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
532: 'PVT: ' || l_api_name || ' End');
533: END IF;
534: END Validate_sales_lead_contact;
535:

Line 619: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

615:
616: -- Debug Message
617: IF (AS_DEBUG_LOW_ON) THEN
618:
619: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
620: 'PVT: ' || l_api_name || ' Start');
621: END IF;
622:
623: -- Initialize API return status to SUCCESS

Line 636: AS_UTILITY_PVT.Set_Message(

632: IF FND_GLOBAL.User_Id IS NULL
633: THEN
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
635: THEN
636: AS_UTILITY_PVT.Set_Message(
637: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
638: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
639: p_token1 => 'PROFILE',
640: p_token1_value => 'USER_ID');

Line 701: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

697: then
698:
699: IF (AS_DEBUG_LOW_ON) THEN
700:
701: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
702: 'CK:force setting primary contact flag');
703: END IF;
704:
705:

Line 719: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

715:
716: -- Debug message
717: IF (AS_DEBUG_LOW_ON) THEN
718:
719: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
720: 'Calling Validate_contact');
721: END IF;
722:
723: -- Invoke validation procedures

Line 727: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

723: -- Invoke validation procedures
724: Validate_sales_lead_contact(
725: p_init_msg_list => FND_API.G_FALSE,
726: p_validation_level => p_validation_level,
727: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
728: P_SALES_LEAD_CONTACT_Rec => l_SALES_LEAD_CONTACT_Rec,
729: x_return_status => x_return_status,
730: x_msg_count => x_msg_count,
731: x_msg_data => x_msg_data);

Line 748: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

744: IF(P_Check_Access_Flag = 'Y') THEN
745: -- Call Get_Access_Profiles to get access_profile_rec
746: IF (AS_DEBUG_LOW_ON) THEN
747:
748: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
749: 'Calling Get_Access_Profiles');
750: END IF;
751:
752: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 760: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

756: IF (AS_DEBUG_LOW_ON) THEN
757:
758:
759:
760: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
761: 'Calling Has_updateLeadAccess');
762:
763: END IF;
764:

Line 785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

781:
782: IF l_update_access_flag <> 'Y' THEN
783: IF (AS_DEBUG_ERROR_ON) THEN
784:
785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
786: 'API_NO_CREATE_PRIVILEGE');
787: END IF;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;

Line 818: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

814:
815: -- Debug Message
816: IF (AS_DEBUG_LOW_ON) THEN
817:
818: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
819: 'Calling CONTACTS_Insert_Row');
820: END IF;
821:
822: l_lead_contact_id := l_sales_lead_contact_rec.lead_contact_id;

Line 878: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

874:
875: -- Debug Message
876: IF (AS_DEBUG_LOW_ON) THEN
877:
878: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
879: 'Updating the header table for last updated');
880: END IF;
881:
882: UPDATE as_sales_leads

Line 891: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

887:
888: -- Debug Message
889: IF (AS_DEBUG_LOW_ON) THEN
890:
891: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'Calling Check_primary_contact');
893: END IF;
894:
895: -- Check IF there is only one primary contact

Line 943: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

939:
940: -- Debug Message
941: IF (AS_DEBUG_LOW_ON) THEN
942:
943: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
944: 'Primary Contact for '||p_SALES_LEAD_ID||':'
945: ||l_contact_party_id);
946: END IF;
947:

Line 962: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

958:
959: -- Debug Message
960: IF (AS_DEBUG_LOW_ON) THEN
961:
962: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
963: 'PVT: ' || l_api_name || ' End');
964: END IF;
965:
966:

Line 975: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

971: );
972:
973: EXCEPTION
974: WHEN FND_API.G_EXC_ERROR THEN
975: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
976: P_API_NAME => L_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME
978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
979: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 979: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

975: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
976: P_API_NAME => L_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME
978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
979: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
980: ,X_MSG_COUNT => X_MSG_COUNT
981: ,X_MSG_DATA => X_MSG_DATA
982: ,X_RETURN_STATUS => X_RETURN_STATUS);
983:

Line 985: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

981: ,X_MSG_DATA => X_MSG_DATA
982: ,X_RETURN_STATUS => X_RETURN_STATUS);
983:
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
986: P_API_NAME => L_API_NAME
987: ,P_PKG_NAME => G_PKG_NAME
988: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
989: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 989: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

985: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
986: P_API_NAME => L_API_NAME
987: ,P_PKG_NAME => G_PKG_NAME
988: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
989: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
990: ,X_MSG_COUNT => X_MSG_COUNT
991: ,X_MSG_DATA => X_MSG_DATA
992: ,X_RETURN_STATUS => X_RETURN_STATUS);
993:

Line 995: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

991: ,X_MSG_DATA => X_MSG_DATA
992: ,X_RETURN_STATUS => X_RETURN_STATUS);
993:
994: WHEN OTHERS THEN
995: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
996: P_API_NAME => L_API_NAME
997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
999: ,P_SQLCODE => SQLCODE

Line 998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

994: WHEN OTHERS THEN
995: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
996: P_API_NAME => L_API_NAME
997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
999: ,P_SQLCODE => SQLCODE
1000: ,P_SQLERRM => SQLERRM
1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1002: ,X_MSG_COUNT => X_MSG_COUNT

Line 1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
999: ,P_SQLCODE => SQLCODE
1000: ,P_SQLERRM => SQLERRM
1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1002: ,X_MSG_COUNT => X_MSG_COUNT
1003: ,X_MSG_DATA => X_MSG_DATA
1004: ,X_RETURN_STATUS => X_RETURN_STATUS);
1005: END Create_sales_lead_contacts;

Line 1083: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1079:
1080: -- Debug Message
1081: IF (AS_DEBUG_LOW_ON) THEN
1082:
1083: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'PVT: ' || l_api_name || ' Start');
1085: END IF;
1086:
1087: -- Initialize API return status to SUCCESS

Line 1101: AS_UTILITY_PVT.Set_Message(

1097: IF FND_GLOBAL.User_Id IS NULL
1098: THEN
1099: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1100: THEN
1101: AS_UTILITY_PVT.Set_Message(
1102: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1103: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1104: p_token1 => 'PROFILE',
1105: p_token1_value => 'USER_ID');

Line 1147: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1143: IF (AS_DEBUG_LOW_ON) THEN
1144:
1145:
1146:
1147: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1148: 'lead_contact_id: ' || l_tar_sales_lead_contact_rec.lead_contact_id);
1149:
1150: END IF;
1151:

Line 1155: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1151:
1152: -- Debug message
1153: IF (AS_DEBUG_LOW_ON) THEN
1154:
1155: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1156: 'Calling Validate_sales_lead');
1157: END IF;
1158:
1159: -- Debug Message

Line 1162: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1158:
1159: -- Debug Message
1160: IF (AS_DEBUG_LOW_ON) THEN
1161:
1162: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1163: 'Open C_Get_sales_lead_contact');
1164: END IF;
1165:
1166: Open C_Get_contact(l_tar_SALES_LEAD_CONTACT_rec.LEAD_CONTACT_ID);

Line 1182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1178:
1179: -- Debug Message
1180: IF (AS_DEBUG_LOW_ON) THEN
1181:
1182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1183: 'Close C_Get_sales_lead_contact');
1184: END IF;
1185: Close C_Get_contact;
1186:

Line 1214: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1210:
1211: -- Debug message
1212: IF (AS_DEBUG_LOW_ON) THEN
1213:
1214: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1215: 'Calling Validate_sales_lead_contact');
1216: END IF;
1217:
1218: -- Invoke validation procedures

Line 1222: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

1218: -- Invoke validation procedures
1219: Validate_sales_lead_contact(
1220: p_init_msg_list => FND_API.G_FALSE,
1221: p_validation_level => p_validation_level,
1222: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
1223: P_SALES_LEAD_CONTACT_Rec => l_tar_SALES_LEAD_CONTACT_Rec,
1224: x_return_status => x_return_status,
1225: x_msg_count => x_msg_count,
1226: x_msg_data => x_msg_data);

Line 1237: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1233: IF(P_Check_Access_Flag = 'Y') THEN
1234: -- Call Get_Access_Profiles to get access_profile_rec
1235: IF (AS_DEBUG_LOW_ON) THEN
1236:
1237: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1238: 'Calling Get_Access_Profiles');
1239: END IF;
1240:
1241: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 1249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1245: IF (AS_DEBUG_LOW_ON) THEN
1246:
1247:
1248:
1249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1250: 'Calling Has_updateLeadAccess');
1251:
1252: END IF;
1253:

Line 1258: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1254: IF (AS_DEBUG_LOW_ON) THEN
1255:
1256:
1257:
1258: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1259: 'sales_lead_id: ' || l_tar_sales_lead_contact_rec.sales_lead_id);
1260:
1261: END IF;
1262: AS_ACCESS_PUB.Has_updateLeadAccess(

Line 1282: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1278:
1279: IF l_update_access_flag <> 'Y' THEN
1280: IF (AS_DEBUG_ERROR_ON) THEN
1281:
1282: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1283: 'API_NO_CREATE_PRIVILEGE');
1284: END IF;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;

Line 1299: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1295: -- update the primary contact already in the table
1296: -- Debug Message
1297: IF (AS_DEBUG_LOW_ON) THEN
1298:
1299: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1300: 'Updating existing primary cont');
1301: END IF;
1302:
1303: IF l_tar_SALES_LEAD_CONTACT_Rec.primary_contact_flag = 'Y'

Line 1315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1311:
1312: -- Debug Message
1313: IF (AS_DEBUG_LOW_ON) THEN
1314:
1315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1316: 'Calling CONTACTS_Update_Row');
1317: END IF;
1318: -- Invoke table handler
1319: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Update_Row(

Line 1375: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1371:
1372: -- Debug Message
1373: IF (AS_DEBUG_LOW_ON) THEN
1374:
1375: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1376: 'Updating the header table for last updated');
1377: END IF;
1378:
1379: UPDATE as_sales_leads

Line 1389: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1385:
1386: -- Debug Message
1387: IF (AS_DEBUG_LOW_ON) THEN
1388:
1389: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1390: 'Calling Check_primary_contact');
1391: END IF;
1392:
1393: -- Check IF there is only one primary contact

Line 1444: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1440:
1441: -- Debug Message
1442: IF (AS_DEBUG_LOW_ON) THEN
1443:
1444: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1445: 'Primary Contact for '||
1446: l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID||':'
1447: ||l_contact_party_id);
1448: END IF;

Line 1463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1459:
1460: -- Debug Message
1461: IF (AS_DEBUG_LOW_ON) THEN
1462:
1463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1464: 'PVT: ' || l_api_name || ' End');
1465: END IF;
1466:
1467: -- Standard call to get message count and IF count is 1, get message info.

Line 1474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1470: p_data => x_msg_data );
1471:
1472: EXCEPTION
1473: WHEN FND_API.G_EXC_ERROR THEN
1474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1475: P_API_NAME => L_API_NAME
1476: ,P_PKG_NAME => G_PKG_NAME
1477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1475: P_API_NAME => L_API_NAME
1476: ,P_PKG_NAME => G_PKG_NAME
1477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1479: ,X_MSG_COUNT => X_MSG_COUNT
1480: ,X_MSG_DATA => X_MSG_DATA
1481: ,X_RETURN_STATUS => X_RETURN_STATUS);
1482:

Line 1484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1480: ,X_MSG_DATA => X_MSG_DATA
1481: ,X_RETURN_STATUS => X_RETURN_STATUS);
1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1485: P_API_NAME => L_API_NAME
1486: ,P_PKG_NAME => G_PKG_NAME
1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1488: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1488: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1485: P_API_NAME => L_API_NAME
1486: ,P_PKG_NAME => G_PKG_NAME
1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1488: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1489: ,X_MSG_COUNT => X_MSG_COUNT
1490: ,X_MSG_DATA => X_MSG_DATA
1491: ,X_RETURN_STATUS => X_RETURN_STATUS);
1492:

Line 1494: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1490: ,X_MSG_DATA => X_MSG_DATA
1491: ,X_RETURN_STATUS => X_RETURN_STATUS);
1492:
1493: WHEN OTHERS THEN
1494: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1495: P_API_NAME => L_API_NAME
1496: ,P_PKG_NAME => G_PKG_NAME
1497: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1498: ,P_SQLCODE => SQLCODE

Line 1497: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1493: WHEN OTHERS THEN
1494: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1495: P_API_NAME => L_API_NAME
1496: ,P_PKG_NAME => G_PKG_NAME
1497: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1498: ,P_SQLCODE => SQLCODE
1499: ,P_SQLERRM => SQLERRM
1500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1501: ,X_MSG_COUNT => X_MSG_COUNT

Line 1500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1496: ,P_PKG_NAME => G_PKG_NAME
1497: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1498: ,P_SQLCODE => SQLCODE
1499: ,P_SQLERRM => SQLERRM
1500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1501: ,X_MSG_COUNT => X_MSG_COUNT
1502: ,X_MSG_DATA => X_MSG_DATA
1503: ,X_RETURN_STATUS => X_RETURN_STATUS);
1504: END Update_sales_lead_contacts;

Line 1569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1565:
1566: -- Debug Message
1567: IF (AS_DEBUG_LOW_ON) THEN
1568:
1569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1570: 'PVT:' || l_api_name || 'start');
1571: END IF;
1572:
1573: -- Initialize API return status to SUCCESS

Line 1587: AS_UTILITY_PVT.Set_Message(

1583: IF FND_GLOBAL.User_Id IS NULL
1584: THEN
1585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1586: THEN
1587: AS_UTILITY_PVT.Set_Message(
1588: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1589: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1590: p_token1 => 'PROFILE',
1591: p_token1_value => 'USER_ID');

Line 1633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1629:
1630: -- Debug Message
1631: IF (AS_DEBUG_LOW_ON) THEN
1632:
1633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1634: 'Open C_Get_cont_del');
1635: END IF;
1636:
1637: -- Get the whole record

Line 1655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1651:
1652: -- Debug Message
1653: IF (AS_DEBUG_LOW_ON) THEN
1654:
1655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1656: 'Close C_Get_cont_del');
1657: END IF;
1658: Close C_Get_cont_del;
1659:

Line 1664: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1660: IF(P_Check_Access_Flag = 'Y') THEN
1661: -- Call Get_Access_Profiles to get access_profile_rec
1662: IF (AS_DEBUG_LOW_ON) THEN
1663:
1664: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1665: 'Calling Get_Access_Profiles');
1666: END IF;
1667:
1668: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 1676: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1672: IF (AS_DEBUG_LOW_ON) THEN
1673:
1674:
1675:
1676: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1677: 'Calling Has_updateLeadAccess');
1678:
1679: END IF;
1680:

Line 1701: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1697:
1698: IF l_update_access_flag <> 'Y' THEN
1699: IF (AS_DEBUG_ERROR_ON) THEN
1700:
1701: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1702: 'API_NO_CREATE_PRIVILEGE');
1703: END IF;
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;

Line 1716: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1712:
1713: -- Debug Message
1714: IF (AS_DEBUG_LOW_ON) THEN
1715:
1716: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1717: 'Calling CONTACTS_Delete_Row');
1718: END IF;
1719:
1720: -- Invoke table handler

Line 1735: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1731:
1732: -- Debug Message
1733: IF (AS_DEBUG_LOW_ON) THEN
1734:
1735: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1736: 'Updating the header table for last updated');
1737: END IF;
1738:
1739: UPDATE as_sales_leads

Line 1752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1748: -- ckapoor 011102 bug 2098158 clean up primary_contact_phone_id and primary_cnt_person_party_id
1749: IF l_PRIMARY_CONTACT_FLAG = 'Y' THEN
1750: IF (AS_DEBUG_LOW_ON) THEN
1751:
1752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1753: 'Primary contact is deleted');
1754: END IF;
1755: update as_sales_leads
1756: set primary_contact_party_id = NULL,

Line 1778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1774:
1775: -- Debug Message
1776: IF (AS_DEBUG_LOW_ON) THEN
1777:
1778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1779: 'PVT: ' || l_api_name || ' End');
1780: END IF;
1781:
1782: -- Standard call to get message count and IF count is 1, get message info.

Line 1789: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1785: p_data => x_msg_data );
1786:
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1790: P_API_NAME => L_API_NAME
1791: ,P_PKG_NAME => G_PKG_NAME
1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1789: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1790: P_API_NAME => L_API_NAME
1791: ,P_PKG_NAME => G_PKG_NAME
1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1794: ,X_MSG_COUNT => X_MSG_COUNT
1795: ,X_MSG_DATA => X_MSG_DATA
1796: ,X_RETURN_STATUS => X_RETURN_STATUS);
1797:

Line 1799: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1795: ,X_MSG_DATA => X_MSG_DATA
1796: ,X_RETURN_STATUS => X_RETURN_STATUS);
1797:
1798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1799: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1800: P_API_NAME => L_API_NAME
1801: ,P_PKG_NAME => G_PKG_NAME
1802: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1803: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1803: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1799: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1800: P_API_NAME => L_API_NAME
1801: ,P_PKG_NAME => G_PKG_NAME
1802: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1803: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1804: ,X_MSG_COUNT => X_MSG_COUNT
1805: ,X_MSG_DATA => X_MSG_DATA
1806: ,X_RETURN_STATUS => X_RETURN_STATUS);
1807:

Line 1809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1805: ,X_MSG_DATA => X_MSG_DATA
1806: ,X_RETURN_STATUS => X_RETURN_STATUS);
1807:
1808: WHEN OTHERS THEN
1809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1810: P_API_NAME => L_API_NAME
1811: ,P_PKG_NAME => G_PKG_NAME
1812: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1813: ,P_SQLCODE => SQLCODE

Line 1812: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1808: WHEN OTHERS THEN
1809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1810: P_API_NAME => L_API_NAME
1811: ,P_PKG_NAME => G_PKG_NAME
1812: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1813: ,P_SQLCODE => SQLCODE
1814: ,P_SQLERRM => SQLERRM
1815: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1816: ,X_MSG_COUNT => X_MSG_COUNT

Line 1815: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1811: ,P_PKG_NAME => G_PKG_NAME
1812: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1813: ,P_SQLCODE => SQLCODE
1814: ,P_SQLERRM => SQLERRM
1815: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1816: ,X_MSG_COUNT => X_MSG_COUNT
1817: ,X_MSG_DATA => X_MSG_DATA
1818: ,X_RETURN_STATUS => X_RETURN_STATUS);
1819: END Delete_sales_lead_contacts;

Line 1878: AS_UTILITY_PVT.Set_Message(

1874: IF FND_GLOBAL.User_Id IS NULL
1875: THEN
1876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1877: THEN
1878: AS_UTILITY_PVT.Set_Message(
1879: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1880: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1881: p_token1 => 'PROFILE',
1882: p_token1_value => 'USER_ID');

Line 1910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1906: IF C_Get_Primary_Contact_Count%NOTFOUND THEN
1907: -- Debug Message
1908: IF (AS_DEBUG_LOW_ON) THEN
1909:
1910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1911: 'Private API: No primary contact');
1912: END IF;
1913: END IF;
1914: CLOSE C_Get_Primary_Contact_Count;

Line 1920: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1916: IF l_count > 1 THEN
1917: -- Debug Message
1918: IF (AS_DEBUG_LOW_ON) THEN
1919:
1920: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1921: 'More than one primary contact');
1922: END IF;
1923: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1924: p_msg_name => 'API_PRIMARY_CONTACT_DUP_FOUND');

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

1919:
1920: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1921: 'More than one primary contact');
1922: END IF;
1923: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1924: p_msg_name => 'API_PRIMARY_CONTACT_DUP_FOUND');
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927:

Line 1942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1938:
1939: -- Debug Message
1940: IF (AS_DEBUG_LOW_ON) THEN
1941:
1942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1943: 'PVT: ' || l_api_name || ' End');
1944: END IF;
1945:
1946: -- Standard call to get message count and IF count is 1, get message info.

Line 1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1950: );
1951:
1952: EXCEPTION
1953: WHEN FND_API.G_EXC_ERROR THEN
1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1955: P_API_NAME => L_API_NAME
1956: ,P_PKG_NAME => G_PKG_NAME
1957: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1958: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1958: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1955: P_API_NAME => L_API_NAME
1956: ,P_PKG_NAME => G_PKG_NAME
1957: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1958: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1959: ,X_MSG_COUNT => X_MSG_COUNT
1960: ,X_MSG_DATA => X_MSG_DATA
1961: ,X_RETURN_STATUS => X_RETURN_STATUS);
1962:

Line 1964: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1960: ,X_MSG_DATA => X_MSG_DATA
1961: ,X_RETURN_STATUS => X_RETURN_STATUS);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1965: P_API_NAME => L_API_NAME
1966: ,P_PKG_NAME => G_PKG_NAME
1967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1968: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1968: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1964: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1965: P_API_NAME => L_API_NAME
1966: ,P_PKG_NAME => G_PKG_NAME
1967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1968: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1969: ,X_MSG_COUNT => X_MSG_COUNT
1970: ,X_MSG_DATA => X_MSG_DATA
1971: ,X_RETURN_STATUS => X_RETURN_STATUS);
1972:

Line 1974: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1970: ,X_MSG_DATA => X_MSG_DATA
1971: ,X_RETURN_STATUS => X_RETURN_STATUS);
1972:
1973: WHEN OTHERS THEN
1974: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1975: P_API_NAME => L_API_NAME
1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1978: ,P_SQLCODE => SQLCODE

Line 1977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1973: WHEN OTHERS THEN
1974: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1975: P_API_NAME => L_API_NAME
1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1978: ,P_SQLCODE => SQLCODE
1979: ,P_SQLERRM => SQLERRM
1980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1981: ,X_MSG_COUNT => X_MSG_COUNT

Line 1980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1978: ,P_SQLCODE => SQLCODE
1979: ,P_SQLERRM => SQLERRM
1980: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1981: ,X_MSG_COUNT => X_MSG_COUNT
1982: ,X_MSG_DATA => X_MSG_DATA
1983: ,X_RETURN_STATUS => X_RETURN_STATUS);
1984: END Check_primary_contact;