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 FND_MSG_PUB

Line 24: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

20: --
21: -- Item level validation procedures
22: --
23:
24: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:

Line 25: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

21: -- Item level validation procedures
22: --
23:
24: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:
29: PROCEDURE Validate_CONTACT_ID (

Line 26: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

22: --
23:
24: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:
29: PROCEDURE Validate_CONTACT_ID (
30: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 27: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

23:
24: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:
29: PROCEDURE Validate_CONTACT_ID (
30: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31: P_Validation_mode IN VARCHAR2,

Line 90: FND_MSG_PUB.initialize;

86: BEGIN
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list )
89: THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: -- Initialize API return status to SUCCESS
94: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 109: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
113: p_token2 => 'VALUE',

Line 122: FND_MSG_PUB.Count_And_Get

118: CLOSE C_CONTACT_ID_Exists;
119: END IF;
120:
121: -- Standard call to get message count and if count is 1, get message info.
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126:

Line 164: FND_MSG_PUB.initialize;

160: BEGIN
161: -- Initialize message list if p_init_msg_list is set to TRUE.
162: IF FND_API.to_Boolean( p_init_msg_list )
163: THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: -- Initialize API return status to SUCCESS
168: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 181: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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');
185:

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 198: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
202:

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 217: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
221: p_token2 => 'VALUE',

Line 236: FND_MSG_PUB.Count_And_Get

232: -- end ffang 092000 for bug 1406761
233:
234: -- Standard call to get message count and if count is 1, get message info.
235:
236: FND_MSG_PUB.Count_And_Get
237: ( p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240:

Line 273: FND_MSG_PUB.initialize;

269:
270: -- Initialize message list if p_init_msg_list is set to TRUE.
271: IF FND_API.to_Boolean( p_init_msg_list )
272: THEN
273: FND_MSG_PUB.initialize;
274: END IF;
275:
276:
277: -- Initialize API return status to SUCCESS

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 293: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
297: p_token2 => 'VALUE',

Line 306: FND_MSG_PUB.Count_And_Get

302: CLOSE C_PHONE_ID_Exists;
303: END IF;
304:
305: -- Standard call to get message count and if count is 1, get message info.
306: FND_MSG_PUB.Count_And_Get
307: ( p_count => x_msg_count,
308: p_data => x_msg_data
309: );
310:

Line 336: FND_MSG_PUB.initialize;

332: BEGIN
333: -- Initialize message list IF p_init_msg_list is set to TRUE.
334: IF FND_API.to_Boolean( p_init_msg_list )
335: THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 356: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
360: p_token2 => 'VALUE',

Line 368: FND_MSG_PUB.Count_And_Get

364: CLOSE C_Lookup_Exists;
365: END IF;
366:
367: -- Standard call to get message count and IF count is 1, get message info.
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data );
371: END Validate_CONTACT_ROLE_CODE;
372:

Line 404: FND_MSG_PUB.initialize;

400: BEGIN
401: -- Initialize message list IF p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean( p_init_msg_list )
403: THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Debug Message
408: IF (AS_DEBUG_LOW_ON) THEN

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 613: FND_MSG_PUB.initialize;

609:
610: -- Initialize message list IF p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:
616: -- Debug Message
617: IF (AS_DEBUG_LOW_ON) THEN

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 634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

630: -- Validate Environment
631: -- ******************************************************************
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',

Line 637: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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');
641: END IF;

Line 678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

674: := FND_API.G_RET_STS_SUCCESS;
675:
676: -- Progress Message
677: --
678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
679: THEN
680: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
681: FND_MESSAGE.Set_Token ('ROW', 'AS_SALES_LEAD_CONTACT', TRUE);
682: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 683: FND_MSG_PUB.Add;

679: THEN
680: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
681: FND_MESSAGE.Set_Token ('ROW', 'AS_SALES_LEAD_CONTACT', TRUE);
682: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
683: FND_MSG_PUB.Add;
684: END IF;
685:
686: l_sales_lead_contact_rec := p_sales_lead_contact_tbl(l_curr_row);
687: l_sales_lead_contact_rec.sales_lead_id := p_sales_lead_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 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 968: FND_MSG_PUB.Count_And_Get

964: END IF;
965:
966:
967: -- Standard call to get message count and IF count is 1, get message info.
968: FND_MSG_PUB.Count_And_Get
969: ( p_count => x_msg_count,
970: p_data => x_msg_data
971: );
972:

Line 978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
980: ,X_MSG_COUNT => X_MSG_COUNT
981: ,X_MSG_DATA => X_MSG_DATA
982: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 988: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
990: ,X_MSG_COUNT => X_MSG_COUNT
991: ,X_MSG_DATA => X_MSG_DATA
992: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1077: FND_MSG_PUB.initialize;

1073:
1074: -- Initialize message list IF p_init_msg_list is set to TRUE.
1075: IF FND_API.to_Boolean( p_init_msg_list )
1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079:
1080: -- Debug Message
1081: IF (AS_DEBUG_LOW_ON) THEN

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 1099: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1095: -- Validate Environment
1096: -- ******************************************************************
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',

Line 1102: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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');
1106: END IF;

Line 1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1129: := FND_API.G_RET_STS_SUCCESS;
1130:
1131: -- Progress Message
1132: --
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1134: THEN
1135: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1136: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_CONTACT', TRUE);
1137: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1138: FND_MSG_PUB.Add;

1134: THEN
1135: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1136: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_CONTACT', TRUE);
1137: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1138: FND_MSG_PUB.Add;
1139: END IF;
1140:
1141: l_tar_sales_lead_contact_rec := p_sales_lead_contact_tbl(l_curr_row);
1142:

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 1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1166: Open C_Get_contact(l_tar_SALES_LEAD_CONTACT_rec.LEAD_CONTACT_ID);
1167: Fetch C_Get_contact into l_last_update_date;
1168:
1169: IF ( C_Get_contact%NOTFOUND) THEN
1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1171: THEN
1172: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1173: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_CONTACT', FALSE);
1174: FND_MSG_PUB.Add;

Line 1174: FND_MSG_PUB.Add;

1170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1171: THEN
1172: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1173: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_CONTACT', FALSE);
1174: FND_MSG_PUB.Add;
1175: END IF;
1176: raise FND_API.G_EXC_ERROR;
1177: END IF;
1178:

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 1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1187: -- Check Whether record has been changed by someone else
1188: IF (l_tar_SALES_LEAD_CONTACT_rec.last_update_date is NULL or
1189: l_tar_SALES_LEAD_CONTACT_rec.last_update_date = FND_API.G_MISS_Date )
1190: THEN
1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1192: THEN
1193: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1194: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
1195: FND_MSG_PUB.ADD;

Line 1195: FND_MSG_PUB.ADD;

1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1192: THEN
1193: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1194: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
1195: FND_MSG_PUB.ADD;
1196: END IF;
1197: raise FND_API.G_EXC_ERROR;
1198: END IF;
1199:

Line 1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1198: END IF;
1199:
1200: IF (l_tar_SALES_LEAD_CONTACT_rec.last_update_date <> l_last_update_date)
1201: THEN
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD_CONTACT', FALSE);
1206: FND_MSG_PUB.ADD;

Line 1206: FND_MSG_PUB.ADD;

1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD_CONTACT', FALSE);
1206: FND_MSG_PUB.ADD;
1207: END IF;
1208: raise FND_API.G_EXC_ERROR;
1209: END IF;
1210:

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 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 1468: FND_MSG_PUB.Count_And_Get

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.
1468: FND_MSG_PUB.Count_And_Get
1469: ( p_count => x_msg_count,
1470: p_data => x_msg_data );
1471:
1472: EXCEPTION

Line 1477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1479: ,X_MSG_COUNT => X_MSG_COUNT
1480: ,X_MSG_DATA => X_MSG_DATA
1481: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1489: ,X_MSG_COUNT => X_MSG_COUNT
1490: ,X_MSG_DATA => X_MSG_DATA
1491: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1563: FND_MSG_PUB.initialize;

1559:
1560: -- Initialize message list IF p_init_msg_list is set to TRUE.
1561: IF FND_API.to_Boolean( p_init_msg_list )
1562: THEN
1563: FND_MSG_PUB.initialize;
1564: END IF;
1565:
1566: -- Debug Message
1567: IF (AS_DEBUG_LOW_ON) THEN

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 1585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1581: -- Validate Environment
1582: -- ******************************************************************
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',

Line 1588: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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');
1592: END IF;

Line 1620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1616: := FND_API.G_RET_STS_SUCCESS;
1617:
1618: -- Progress Message
1619: --
1620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1621: THEN
1622: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1623: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_CONTACT', TRUE);
1624: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1625: FND_MSG_PUB.Add;

1621: THEN
1622: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1623: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_CONTACT', TRUE);
1624: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1625: FND_MSG_PUB.Add;
1626: END IF;
1627:
1628: l_sales_lead_contact_rec := p_sales_lead_contact_tbl(l_curr_row);
1629:

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 1643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1639: Fetch C_Get_cont_del into l_sales_lead_id, l_primary_contact_flag,
1640: l_contact_party_id;
1641:
1642: IF ( C_Get_cont_del%NOTFOUND) THEN
1643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN
1645: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1646: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_CONTACT', FALSE);
1647: FND_MSG_PUB.Add;

Line 1647: FND_MSG_PUB.Add;

1643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1644: THEN
1645: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1646: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_CONTACT', FALSE);
1647: FND_MSG_PUB.Add;
1648: END IF;
1649: raise FND_API.G_EXC_ERROR;
1650: END IF;
1651:

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 1783: FND_MSG_PUB.Count_And_Get

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.
1783: FND_MSG_PUB.Count_And_Get
1784: ( p_count => x_msg_count,
1785: p_data => x_msg_data );
1786:
1787: EXCEPTION

Line 1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1794: ,X_MSG_COUNT => X_MSG_COUNT
1795: ,X_MSG_DATA => X_MSG_DATA
1796: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1802: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1804: ,X_MSG_COUNT => X_MSG_COUNT
1805: ,X_MSG_DATA => X_MSG_DATA
1806: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1861: FND_MSG_PUB.initialize;

1857: BEGIN
1858: -- Initialize message list IF p_init_msg_list is set to TRUE.
1859: IF FND_API.to_Boolean( p_init_msg_list )
1860: THEN
1861: FND_MSG_PUB.initialize;
1862: END IF;
1863:
1864: -- Initialize API return status to SUCCESS
1865: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1872: -- Validate Environment
1873: -- ******************************************************************
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',

Line 1879: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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');
1883: END IF;

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 1947: FND_MSG_PUB.Count_And_Get

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.
1947: FND_MSG_PUB.Count_And_Get
1948: ( p_count => x_msg_count,
1949: p_data => x_msg_data
1950: );
1951:

Line 1957: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1959: ,X_MSG_COUNT => X_MSG_COUNT
1960: ,X_MSG_DATA => X_MSG_DATA
1961: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1969: ,X_MSG_COUNT => X_MSG_COUNT
1970: ,X_MSG_DATA => X_MSG_DATA
1971: ,X_RETURN_STATUS => X_RETURN_STATUS);