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_DECISION_FACTOR_PVT dependencies on FND_MSG_PUB

Line 56: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

52: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
53: l_update_access_flag VARCHAR2(1);
54: l_lead_id NUMBER;
55: l_curr_row NUMBER;
56: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Create_decision_factors';
58:
59: BEGIN
60: -- Debug Message

Line 62: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API1: ' || l_api_name || 'start');

58:
59: BEGIN
60: -- Debug Message
61: IF l_debug THEN
62: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API1: ' || l_api_name || 'start');
63: END IF;
64:
65:
66:

Line 83: FND_MSG_PUB.initialize;

79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list )
82: THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85:
86:
87: -- Debug Message

Line 89: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API2: ' || l_api_name || 'start');

85:
86:
87: -- Debug Message
88: IF l_debug THEN
89: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API2: ' || l_api_name || 'start');
90: END IF;
91:
92:
93:

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

101: -- Validate Environment
102: -- ******************************************************************
103: IF FND_GLOBAL.User_Id IS NULL
104: THEN
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
106: THEN
107: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
109: FND_MSG_PUB.ADD;

Line 109: FND_MSG_PUB.ADD;

105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
106: THEN
107: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
109: FND_MSG_PUB.ADD;
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:

Line 129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

125: ,x_sales_member_rec => l_identity_sales_member_rec);
126:
127:
128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
130: IF l_debug THEN
131: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
132: 'Private API3: Get_CurrentUser fail');
133: END IF;

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

127:
128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
130: IF l_debug THEN
131: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
132: 'Private API3: Get_CurrentUser fail');
133: END IF;
134:
135: END IF;

Line 143: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API4: Validate_decision_factor');

139: END IF;
140:
141: -- Debug message
142: IF l_debug THEN
143: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API4: Validate_decision_factor');
144: END IF;
145:
146:
147: IF(P_Check_Access_Flag = 'Y') THEN

Line 177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

173: ,x_msg_data => x_msg_data
174: ,x_update_access_flag => l_update_access_flag );
175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
178: IF l_debug THEN
179: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
180: 'Private API5: has_updateOpportunityAccess fail');
181: END IF;

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

175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
178: IF l_debug THEN
179: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
180: 'Private API5: has_updateOpportunityAccess fail');
181: END IF;
182: END IF;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: IF (l_update_access_flag <> 'Y') THEN
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
188: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
189: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
190: FND_MSG_PUB.ADD;
191: END IF;

Line 190: FND_MSG_PUB.ADD;

186: IF (l_update_access_flag <> 'Y') THEN
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
188: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
189: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
190: FND_MSG_PUB.ADD;
191: END IF;
192: RAISE FND_API.G_EXC_ERROR;
193: ELSE
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

190: FND_MSG_PUB.ADD;
191: END IF;
192: RAISE FND_API.G_EXC_ERROR;
193: ELSE
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
195: IF l_debug THEN
196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
197: 'Private API6: has_updateOpportunityAccess succeed');
198: END IF;

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

192: RAISE FND_API.G_EXC_ERROR;
193: ELSE
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
195: IF l_debug THEN
196: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
197: 'Private API6: has_updateOpportunityAccess succeed');
198: END IF;
199:
200: END IF;

Line 226: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API7: Calling create table handler');

222:
223:
224: -- Debug Message
225: IF l_debug THEN
226: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API7: Calling create table handler');
227: END IF;
228:
229: -- Invoke table handler(AS_LEAD_DECISION_FACTORS_PKG.Insert_Row)
230: AS_LEAD_DECISION_FACTORS_PKG.Insert_Row(

Line 284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API8: ' || l_api_name || 'end');

280:
281:
282: -- Debug Message
283: IF l_debug THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API8: ' || l_api_name || 'end');
285: END IF;
286:
287:
288:

Line 290: FND_MSG_PUB.Count_And_Get

286:
287:
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294:

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

294:
295: EXCEPTION
296:
297: WHEN DUP_VAL_ON_INDEX THEN
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
299: THEN
300: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
301: --FND_MSG_PUB.ADD;
302: AS_UTILITY_PVT.Set_Message(

Line 301: --FND_MSG_PUB.ADD;

297: WHEN DUP_VAL_ON_INDEX THEN
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
299: THEN
300: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
301: --FND_MSG_PUB.ADD;
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
305: p_msg_name => 'API_DUP_DECIS_FACTOR_CODE',

Line 304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

300: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
301: --FND_MSG_PUB.ADD;
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
305: p_msg_name => 'API_DUP_DECIS_FACTOR_CODE',
306: p_token1 => 'VALUE',
307: p_token1_value => l_Decision_Factor_rec.DECISION_FACTOR_CODE);
308:

Line 315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
312: P_MODULE => l_module
313: ,P_API_NAME => L_API_NAME
314: ,P_PKG_NAME => G_PKG_NAME
315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
317: ,X_MSG_COUNT => X_MSG_COUNT
318: ,X_MSG_DATA => X_MSG_DATA
319: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 328: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

324: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
325: P_MODULE => l_module
326: ,P_API_NAME => L_API_NAME
327: ,P_PKG_NAME => G_PKG_NAME
328: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
329: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
330: ,X_MSG_COUNT => X_MSG_COUNT
331: ,X_MSG_DATA => X_MSG_DATA
332: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

335: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
336: P_MODULE => l_module
337: ,P_API_NAME => L_API_NAME
338: ,P_PKG_NAME => G_PKG_NAME
339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
340: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
341: ,X_MSG_COUNT => X_MSG_COUNT
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 403: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

399: l_curr_row NUMBER;
400: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
401: l_update_access_flag VARCHAR2(1);
402: l_lead_id NUMBER;
403: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
404: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Update_decision_factors';
405:
406: BEGIN
407: -- Standard Start of API savepoint

Line 422: FND_MSG_PUB.initialize;

418:
419: -- Initialize message list if p_init_msg_list is set to TRUE.
420: IF FND_API.to_Boolean( p_init_msg_list )
421: THEN
422: FND_MSG_PUB.initialize;
423: END IF;
424:
425:
426: -- Debug Message

Line 428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API9: ' || l_api_name || 'start');

424:
425:
426: -- Debug Message
427: IF l_debug THEN
428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API9: ' || l_api_name || 'start');
429: END IF;
430:
431:
432: -- Initialize API return status to SUCCESS

Line 453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

449: ,x_sales_member_rec => l_identity_sales_member_rec);
450:
451:
452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
454: IF l_debug THEN
455: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
456: 'Private API10: Get_CurrentUser fail');
457: END IF;

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

451:
452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
454: IF l_debug THEN
455: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
456: 'Private API10: Get_CurrentUser fail');
457: END IF;
458:
459: END IF;

Line 494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

490: ,x_msg_data => x_msg_data
491: ,x_update_access_flag => l_update_access_flag );
492:
493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
495: IF l_debug THEN
496: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
497: 'Private API11: has_updateOpportunityAccess fail');
498: END IF;

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

492:
493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
495: IF l_debug THEN
496: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
497: 'Private API11: has_updateOpportunityAccess fail');
498: END IF;
499:
500: END IF;

Line 505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: IF (l_update_access_flag <> 'Y') THEN
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
506: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
507: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
508: FND_MSG_PUB.ADD;
509: END IF;

Line 508: FND_MSG_PUB.ADD;

504: IF (l_update_access_flag <> 'Y') THEN
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
506: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
507: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
508: FND_MSG_PUB.ADD;
509: END IF;
510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

508: FND_MSG_PUB.ADD;
509: END IF;
510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
513: IF l_debug THEN
514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
515: 'Private API12: has_updateOpportunityAccess succeed');
516: END IF;

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

510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
513: IF l_debug THEN
514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
515: 'Private API12: has_updateOpportunityAccess succeed');
516: END IF;
517:
518: END IF;

Line 528: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API13: Calling update table handler');

524: -- Hint: Add corresponding Master-Detail business logic here if necessary.
525:
526: -- Debug Message
527: IF l_debug THEN
528: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API13: Calling update table handler');
529: END IF;
530:
531:
532: -- Invoke validation procedures

Line 598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API14: ' || l_api_name || 'end');

594:
595:
596: -- Debug Message
597: IF l_debug THEN
598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API14: ' || l_api_name || 'end');
599: END IF;
600:
601:
602:

Line 604: FND_MSG_PUB.Count_And_Get

600:
601:
602:
603: -- Standard call to get message count and if count is 1, get message info.
604: FND_MSG_PUB.Count_And_Get
605: ( p_count => x_msg_count,
606: p_data => x_msg_data
607: );
608:

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

608:
609: EXCEPTION
610:
611: WHEN DUP_VAL_ON_INDEX THEN
612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
615: --FND_MSG_PUB.ADD;
616: AS_UTILITY_PVT.Set_Message(

Line 615: --FND_MSG_PUB.ADD;

611: WHEN DUP_VAL_ON_INDEX THEN
612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
615: --FND_MSG_PUB.ADD;
616: AS_UTILITY_PVT.Set_Message(
617: p_module => l_module,
618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
619: p_msg_name => 'API_DUP_DECIS_FACTOR_CODE',

Line 618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

614: --FND_MESSAGE.Set_Name('AS', 'API_DUP_DECIS_FACTOR_CODE');
615: --FND_MSG_PUB.ADD;
616: AS_UTILITY_PVT.Set_Message(
617: p_module => l_module,
618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
619: p_msg_name => 'API_DUP_DECIS_FACTOR_CODE',
620: p_token1 => 'VALUE',
621: p_token1_value => l_Decision_Factor_rec.DECISION_FACTOR_CODE);
622:

Line 629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

625: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_MODULE => l_module
627: ,P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_MODULE => l_module
650: ,P_API_NAME => L_API_NAME
651: ,P_PKG_NAME => G_PKG_NAME
652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
653: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
654: ,X_MSG_COUNT => X_MSG_COUNT
655: ,X_MSG_DATA => X_MSG_DATA
656: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 710: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

706: l_curr_row NUMBER;
707: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
708: l_update_access_flag VARCHAR2(1);
709: l_lead_id NUMBER;
710: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
711: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Delete_decision_factors';
712:
713: BEGIN
714: -- Standard Start of API savepoint

Line 729: FND_MSG_PUB.initialize;

725:
726: -- Initialize message list if p_init_msg_list is set to TRUE.
727: IF FND_API.to_Boolean( p_init_msg_list )
728: THEN
729: FND_MSG_PUB.initialize;
730: END IF;
731:
732:
733: -- Debug Message

Line 735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API15: ' || l_api_name || 'start');

731:
732:
733: -- Debug Message
734: IF l_debug THEN
735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API15: ' || l_api_name || 'start');
736: END IF;
737:
738:
739:

Line 760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

756: ,x_sales_member_rec => l_identity_sales_member_rec);
757:
758:
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
761: IF l_debug THEN
762: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
763: 'Private API16: Get_CurrentUser fail');
764: END IF;

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

758:
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
761: IF l_debug THEN
762: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
763: 'Private API16: Get_CurrentUser fail');
764: END IF;
765:
766: END IF;

Line 801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

797: ,x_msg_data => x_msg_data
798: ,x_update_access_flag => l_update_access_flag );
799:
800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
802: IF l_debug THEN
803: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
804: 'Private API17: has_updateOpportunityAccess fail');
805: END IF;

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

799:
800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
802: IF l_debug THEN
803: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
804: 'Private API17: has_updateOpportunityAccess fail');
805: END IF;
806:
807: END IF;

Line 812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: IF (l_update_access_flag <> 'Y') THEN
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
814: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
815: FND_MSG_PUB.ADD;
816: END IF;

Line 815: FND_MSG_PUB.ADD;

811: IF (l_update_access_flag <> 'Y') THEN
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
814: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
815: FND_MSG_PUB.ADD;
816: END IF;
817: RAISE FND_API.G_EXC_ERROR;
818: ELSE
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

815: FND_MSG_PUB.ADD;
816: END IF;
817: RAISE FND_API.G_EXC_ERROR;
818: ELSE
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
820: IF l_debug THEN
821: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
822: 'Private API18: has_updateOpportunityAccess succeed');
823: END IF;

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

817: RAISE FND_API.G_EXC_ERROR;
818: ELSE
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
820: IF l_debug THEN
821: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
822: 'Private API18: has_updateOpportunityAccess succeed');
823: END IF;
824:
825: END IF;

Line 832: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API19: Calling delete table handler');

828:
829:
830: -- Debug Message
831: IF l_debug THEN
832: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API19: Calling delete table handler');
833: END IF;
834:
835:
836: FOR l_curr_row in 1 .. l_count LOOP

Line 857: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API20: ' || l_api_name || 'end');

853:
854:
855: -- Debug Message
856: IF l_debug THEN
857: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API20: ' || l_api_name || 'end');
858: END IF;
859:
860:
861:

Line 863: FND_MSG_PUB.Count_And_Get

859:
860:
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count,
865: p_data => x_msg_data
866: );
867:

Line 874: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

870: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
871: P_MODULE => l_module
872: ,P_API_NAME => L_API_NAME
873: ,P_PKG_NAME => G_PKG_NAME
874: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
875: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
876: ,X_MSG_COUNT => X_MSG_COUNT
877: ,X_MSG_DATA => X_MSG_DATA
878: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 885: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

881: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
882: P_MODULE => l_module
883: ,P_API_NAME => L_API_NAME
884: ,P_PKG_NAME => G_PKG_NAME
885: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
886: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
887: ,X_MSG_COUNT => X_MSG_COUNT
888: ,X_MSG_DATA => X_MSG_DATA
889: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 921: FND_MSG_PUB.initialize;

917:
918: -- Initialize message list if p_init_msg_list is set to TRUE.
919: IF FND_API.to_Boolean( p_init_msg_list )
920: THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924:
925: -- Initialize API return status to SUCCESS

Line 945: FND_MSG_PUB.Count_And_Get

941: NULL;
942: END IF;
943:
944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data
948: );
949:

Line 968: FND_MSG_PUB.initialize;

964:
965: -- Initialize message list if p_init_msg_list is set to TRUE.
966: IF FND_API.to_Boolean( p_init_msg_list )
967: THEN
968: FND_MSG_PUB.initialize;
969: END IF;
970:
971:
972: -- Initialize API return status to SUCCESS

Line 992: FND_MSG_PUB.Count_And_Get

988: NULL;
989: END IF;
990:
991: -- Standard call to get message count and if count is 1, get message info.
992: FND_MSG_PUB.Count_And_Get
993: ( p_count => x_msg_count,
994: p_data => x_msg_data
995: );
996:

Line 1016: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1012: FROM AS_LOOKUPS
1013: WHERE LOOKUP_TYPE = 'DECISION_PRIORITY_TYPE'
1014: AND LOOKUP_CODE = c_Decision_Priority_Code;
1015: l_val VARCHAR2(1);
1016: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1017: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_DECISION_PRIOR_CODE';
1018: BEGIN
1019: -- Initialize message list if p_init_msg_list is set to TRUE.
1020: IF FND_API.to_Boolean( p_init_msg_list )

Line 1022: FND_MSG_PUB.initialize;

1018: BEGIN
1019: -- Initialize message list if p_init_msg_list is set to TRUE.
1020: IF FND_API.to_Boolean( p_init_msg_list )
1021: THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024:
1025: -- Initialize API return status to SUCCESS
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1031: FETCH C_Decis_Prior_Code_Exists into l_val;
1032: IF C_Decis_Prior_Code_Exists%NOTFOUND
1033: THEN
1034: IF l_debug THEN
1035: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1036: 'Private API21: DECISION_PRIORITY_CODE is not valid:' ||P_DECISION_PRIORITY_CODE);
1037: END IF;
1038:
1039:

Line 1042: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1038:
1039:
1040: AS_UTILITY_PVT.Set_Message(
1041: p_module => l_module,
1042: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1043: p_msg_name => 'API_INVALID_DECISION_PRIORITY',
1044: p_token1 => 'COLUMN',
1045: p_token1_value => 'DECISION_PRIORITY_CODE',
1046: p_token2 => 'VALUE',

Line 1055: FND_MSG_PUB.Count_And_Get

1051: CLOSE C_Decis_Prior_Code_Exists;
1052: END IF;
1053:
1054:
1055: FND_MSG_PUB.Count_And_Get
1056: ( p_count => x_msg_count,
1057: p_data => x_msg_data
1058: );
1059:

Line 1087: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1083: SELECT 'X'
1084: FROM AS_LEAD_DECISION_FACTORS
1085: WHERE LEAD_LINE_ID = c_Lead_Line_Id;
1086:
1087: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1088: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_DECISION_FACTOR_CODE';
1089: BEGIN
1090: -- Initialize message list if p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list )

Line 1093: FND_MSG_PUB.initialize;

1089: BEGIN
1090: -- Initialize message list if p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list )
1092: THEN
1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Initialize API return status to SUCCESS
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1105: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1101:
1102: -- OPEN C_D_Decis_Factor_Code_Exists (P_LEAD_LINE_ID);
1103: -- FETCH C_D_Decis_Factor_Code_Exists into l_val;
1104: -- IF C_D_Decis_Factor_Code_Exists%FOUND THEN
1105: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1106: -- 'Private API24: DECISION_FACTOR_CODE exist');
1107:
1108: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1109: -- 'Duplicate DECISION_FACTOR_CODE ');

Line 1108: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1104: -- IF C_D_Decis_Factor_Code_Exists%FOUND THEN
1105: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1106: -- 'Private API24: DECISION_FACTOR_CODE exist');
1107:
1108: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1109: -- 'Duplicate DECISION_FACTOR_CODE ');
1110:
1111: -- AS_UTILITY_PVT.Set_Message(
1112: -- p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1112: -- p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1108: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1109: -- 'Duplicate DECISION_FACTOR_CODE ');
1110:
1111: -- AS_UTILITY_PVT.Set_Message(
1112: -- p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1113: -- p_msg_name => 'API_DUP_DECIS_FACTOR_CODE',
1114: --p_token1 => 'COLUMN',
1115: --p_token1_value => '',
1116: -- p_token1 => 'VALUE',

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

1124:
1125: IF (P_DECISION_FACTOR_CODE is NULL) or (P_DECISION_FACTOR_CODE = FND_API.G_MISS_CHAR)
1126: THEN
1127: IF l_debug THEN
1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1129: 'Private API22: Violate NOT NULL constraint(DECISION_FACTOR_CODE)');
1130: END IF;
1131:
1132:

Line 1135: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1131:
1132:
1133: AS_UTILITY_PVT.Set_Message(
1134: p_module => l_module,
1135: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1136: p_msg_name => 'API_MISSING_ID',
1137: p_token1 => 'COLUMN',
1138: p_token1_value => 'DECISION_FACTOR_CODE');
1139:

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

1143: FETCH C_Decis_Factor_Code_Exists into l_val;
1144: IF C_Decis_Factor_Code_Exists%NOTFOUND
1145: THEN
1146: IF l_debug THEN
1147: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1148: 'Private API23: DECISION_FACTOR_CODE is not valid:' ||
1149: P_DECISION_FACTOR_CODE);
1150: END IF;
1151:

Line 1155: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1151:
1152:
1153: AS_UTILITY_PVT.Set_Message(
1154: p_module => l_module,
1155: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1156: p_msg_name => 'API_INVALID_DECISION_FACTOR',
1157: p_token1 => 'COLUMN',
1158: p_token1_value => 'DECISION_FACTOR_CODE',
1159: p_token2 => 'VALUE',

Line 1169: FND_MSG_PUB.Count_And_Get

1165: END IF;
1166: END IF;
1167:
1168: -- Standard call to get message count and if count is 1, get message info.
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1173:

Line 1194: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1190: FROM AS_LEAD_DECISION_FACTORS
1191: WHERE LEAD_DECISION_FACTOR_ID = c_Lead_DECISION_FACTOR_ID;
1192:
1193: l_val VARCHAR2(1);
1194: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1195: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_L_DECISION_FACTOR_ID';
1196:
1197: BEGIN
1198:

Line 1202: FND_MSG_PUB.initialize;

1198:
1199: -- Initialize message list if p_init_msg_list is set to TRUE.
1200: IF FND_API.to_Boolean( p_init_msg_list )
1201: THEN
1202: FND_MSG_PUB.initialize;
1203: END IF;
1204:
1205: -- Initialize API return status to SUCCESS
1206: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1213: OPEN C_L_Decis_Factor_Id_Exists (P_LEAD_DECISION_FACTOR_ID);
1214: FETCH C_L_Decis_Factor_Id_Exists into l_val;
1215: IF C_L_Decis_Factor_Id_Exists%FOUND THEN
1216: IF l_debug THEN
1217: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1218: 'Private API24: LEAD_LINE_ID exist');
1219: END IF;
1220:
1221: AS_UTILITY_PVT.Set_Message(

Line 1223: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1219: END IF;
1220:
1221: AS_UTILITY_PVT.Set_Message(
1222: p_module => l_module,
1223: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1224: p_msg_name => 'API_DUP_DECIS_FACT_ID',
1225: p_token1 => 'COLUMN',
1226: p_token1_value => 'LEAD_DECISION_FACTOR_ID',
1227: p_token2 => 'VALUE',

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

1238: -- validate NOT NULL column
1239: IF (P_LEAD_DECISION_FACTOR_ID is NULL) or (P_LEAD_DECISION_FACTOR_ID = FND_API.G_MISS_NUM)
1240: THEN
1241: IF l_debug THEN
1242: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1243: 'Private API25: Violate NOT NULL constraint(LEAD_DECISION_FACTOR_ID)');
1244: END IF;
1245:
1246: AS_UTILITY_PVT.Set_Message(

Line 1248: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1244: END IF;
1245:
1246: AS_UTILITY_PVT.Set_Message(
1247: p_module => l_module,
1248: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1249: p_msg_name => 'API_MISSING_ID',
1250: p_token1 => 'COLUMN',
1251: p_token1_value => 'LEAD_DECISION_FACTOR_ID');
1252:

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

1256: FETCH C_L_Decis_Factor_Id_Exists into l_val;
1257: IF C_L_Decis_Factor_Id_Exists%NOTFOUND
1258: THEN
1259: IF l_debug THEN
1260: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1261: 'Private API26: LEAD_DECISION_FACTOR_ID is not valid');
1262: END IF;
1263:
1264: AS_UTILITY_PVT.Set_Message(

Line 1266: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1262: END IF;
1263:
1264: AS_UTILITY_PVT.Set_Message(
1265: p_module => l_module,
1266: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1267: p_msg_name => 'API_INVALID_DECIS_FACT_ID',
1268: p_token1 => 'COLUMN',
1269: p_token1_value => 'LEAD_DECISION_FACTOR_ID',
1270: p_token2 => 'VALUE',

Line 1281: FND_MSG_PUB.Count_And_Get

1277:
1278: END IF;
1279:
1280: -- Standard call to get message count and if count is 1, get message info.
1281: FND_MSG_PUB.Count_And_Get
1282: ( p_count => x_msg_count,
1283: p_data => x_msg_data
1284: );
1285:

Line 1307: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1303: FROM AS_LEAD_LINES
1304: WHERE LEAD_LINE_ID = c_Lead_Line_Id;
1305:
1306: l_val VARCHAR2(1);
1307: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1308: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_LEAD_LINE_ID';
1309:
1310: BEGIN
1311: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1314: FND_MSG_PUB.initialize;

1310: BEGIN
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;
1315: END IF;
1316:
1317: -- Initialize API return status to SUCCESS
1318: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1319:
1320: IF (P_LEAD_LINE_ID is NULL) or (P_LEAD_LINE_ID = FND_API.G_MISS_NUM)
1321: THEN
1322: IF l_debug THEN
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'Private API27: Violate NOT NULL constraint(LEAD_LINE_ID)');
1325: END IF;
1326:
1327:

Line 1330: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1326:
1327:
1328: AS_UTILITY_PVT.Set_Message(
1329: p_module => l_module,
1330: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1331: p_msg_name => 'API_MISSING_ID',
1332: p_token1 => 'COLUMN',
1333: p_token1_value => 'LEAD_LINE_ID');
1334:

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

1338: FETCH C_Lead_Line_Id_Exists into l_val;
1339: IF C_Lead_Line_Id_Exists%NOTFOUND
1340: THEN
1341: IF l_debug THEN
1342: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1343: 'Private API28: LEAD_LEAD_ID is not valid:' ||
1344: P_LEAD_LINE_ID);
1345: END IF;
1346:

Line 1349: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1345: END IF;
1346:
1347: AS_UTILITY_PVT.Set_Message(
1348: p_module => l_module,
1349: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1350: p_msg_name => 'API_INVALID_OPP_LEAD_LINE_ID',
1351: p_token1 => 'COLUMN',
1352: p_token1_value => 'LEAD_LINE_ID',
1353: p_token2 => 'VALUE',

Line 1362: FND_MSG_PUB.Count_And_Get

1358: CLOSE C_Lead_Line_Id_Exists;
1359: END IF;
1360:
1361: -- Standard call to get message count and if count is 1, get message info.
1362: FND_MSG_PUB.Count_And_Get
1363: ( p_count => x_msg_count,
1364: p_data => x_msg_data
1365: );
1366:

Line 1380: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1376: X_Msg_Count OUT NOCOPY NUMBER,
1377: X_Msg_Data OUT NOCOPY VARCHAR2
1378: )
1379: IS
1380: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1381: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_CREATE_BY';
1382: BEGIN
1383:
1384: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1387: FND_MSG_PUB.initialize;

1383:
1384: -- Initialize message list if p_init_msg_list is set to TRUE.
1385: IF FND_API.to_Boolean( p_init_msg_list )
1386: THEN
1387: FND_MSG_PUB.initialize;
1388: END IF;
1389:
1390:
1391: -- Initialize API return status to SUCCESS

Line 1421: FND_MSG_PUB.Count_And_Get

1417: NULL;
1418: END IF;
1419:
1420: -- Standard call to get message count and if count is 1, get message info.
1421: FND_MSG_PUB.Count_And_Get
1422: ( p_count => x_msg_count,
1423: p_data => x_msg_data
1424: );
1425:

Line 1442: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1438: X_Msg_Count OUT NOCOPY NUMBER,
1439: X_Msg_Data OUT NOCOPY VARCHAR2
1440: )
1441: IS
1442: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1443: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_Decision_Factor_rec';
1444: BEGIN
1445:
1446: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1449: FND_MSG_PUB.initialize;

1445:
1446: -- Initialize message list if p_init_msg_list is set to TRUE.
1447: IF FND_API.to_Boolean( p_init_msg_list )
1448: THEN
1449: FND_MSG_PUB.initialize;
1450: END IF;
1451:
1452:
1453: -- Initialize API return status to SUCCESS

Line 1463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1459: -- x_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: -- Debug Message
1462: IF l_debug THEN
1463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1464: END IF;
1465:
1466: -- Standard call to get message count and if count is 1, get message info.
1467: FND_MSG_PUB.Count_And_Get

Line 1467: FND_MSG_PUB.Count_And_Get

1463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1464: END IF;
1465:
1466: -- Standard call to get message count and if count is 1, get message info.
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );
1471:

Line 1487: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1483: IS
1484: l_api_name CONSTANT VARCHAR2(30) := 'Validate_decision_factor';
1485: x_item_property_rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
1486: --x_return_status VARCHAR2(1);
1487: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1488: l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Validate_decision_factor';
1489: BEGIN
1490:
1491: -- Debug Message

Line 1493: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API29: ' || l_api_name || 'start');

1489: BEGIN
1490:
1491: -- Debug Message
1492: IF l_debug THEN
1493: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API29: ' || l_api_name || 'start');
1494: END IF;
1495:
1496:
1497:

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

1512: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1513: raise FND_API.G_EXC_ERROR;
1514: END IF;
1515: IF l_debug THEN
1516: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1517: 'Private API30: Validated DECISION_PRIOR_CODE');
1518: END IF;
1519:
1520:

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

1532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1533: raise FND_API.G_EXC_ERROR;
1534: END IF;
1535: IF l_debug THEN
1536: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1537: 'Private API31: Validated DECISION_FACTOR_CODE');
1538: END IF;
1539:
1540:

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

1550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1551: raise FND_API.G_EXC_ERROR;
1552: END IF;
1553: IF l_debug THEN
1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1555: 'Private API32: Validated LEAD_DECISION_FACTOR_ID');
1556: END IF;
1557:
1558:

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

1570: raise FND_API.G_EXC_ERROR;
1571: END IF;
1572:
1573: IF l_debug THEN
1574: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1575: 'Private API33: Validated LEAD_LINE_ID');
1576: END IF;
1577:
1578:

Line 1612: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API34: ' || l_api_name || 'end');

1608: */
1609:
1610: -- Debug Message
1611: IF l_debug THEN
1612: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API34: ' || l_api_name || 'end');
1613: END IF;
1614:
1615: END Validate_decision_factor;
1616: