eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_OPP_OBSTACLE_PVT dependencies on FND_MSG_PUB

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

40: l_OBSTACLE_rec AS_OPPORTUNITY_PUB.OBSTACLE_Rec_Type;
41: l_LEAD_OBSTACLE_ID NUMBER;
42: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
43: l_access_flag VARCHAR2(1);
44: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
45: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Create_obstacles';
46: BEGIN
47: -- Standard Start of API savepoint
48: SAVEPOINT CREATE_OBSTACLES_PVT;

Line 63: FND_MSG_PUB.initialize;

59:
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list )
62: THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66:
67: -- Debug Message

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

65:
66:
67: -- Debug Message
68: IF l_debug THEN
69: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
70: END IF;
71:
72:
73:

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

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

Line 107: FND_MSG_PUB.ADD;

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

Line 155: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

151: ,x_update_access_flag => l_access_flag);
152: END IF;
153:
154: IF l_access_flag <> 'Y' THEN
155: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
156: 'API_NO_UPDATE_PRIVILEGE');
157: END IF;
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

168: l_LEAD_OBSTACLE_ID := P_OBSTACLE_Tbl(I).LEAD_OBSTACLE_ID;
169:
170: -- Progress Message
171: --
172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
173: THEN
174: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
175: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
176: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 177: FND_MSG_PUB.Add;

173: THEN
174: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
175: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
176: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
177: FND_MSG_PUB.Add;
178: END IF;
179:
180: l_OBSTACLE_rec := P_OBSTACLE_Tbl(I);
181:

Line 186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');

182: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
183: THEN
184: -- Debug message
185: IF l_debug THEN
186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');
187: END IF;
188:
189:
190: -- Invoke validation procedures

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

205: -- Hint: Add corresponding Master-Detail business logic here if necessary.
206:
207: -- Debug Message
208: IF l_debug THEN
209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
210: END IF;
211:
212:
213: AS_LEAD_OBSTACLES_PKG.Insert_Row(

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

267:
268:
269: -- Debug Message
270: IF l_debug THEN
271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
272: END IF;
273:
274:
275:

Line 277: FND_MSG_PUB.Count_And_Get

273:
274:
275:
276: -- Standard call to get message count and if count is 1, get message info.
277: FND_MSG_PUB.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281:

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

298: */
299: EXCEPTION
300:
301: WHEN DUP_VAL_ON_INDEX THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
303: THEN
304: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
305: FND_MSG_PUB.ADD;
306: END IF;

Line 305: FND_MSG_PUB.ADD;

301: WHEN DUP_VAL_ON_INDEX THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
303: THEN
304: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
305: FND_MSG_PUB.ADD;
306: END IF;
307:
308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
309: P_MODULE => l_module

Line 312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
321: P_MODULE => l_module
322: ,P_API_NAME => L_API_NAME
323: ,P_PKG_NAME => G_PKG_NAME
324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
326: ,X_MSG_COUNT => X_MSG_COUNT
327: ,X_MSG_DATA => X_MSG_DATA
328: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_MODULE => l_module
333: ,P_API_NAME => L_API_NAME
334: ,P_PKG_NAME => G_PKG_NAME
335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
337: ,X_MSG_COUNT => X_MSG_COUNT
338: ,X_MSG_DATA => X_MSG_DATA
339: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

420: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
421: l_rowid ROWID;
422: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
423: l_access_flag VARCHAR2(1);
424: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
425: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Update_obstacles';
426: BEGIN
427: -- Standard Start of API savepoint
428: SAVEPOINT UPDATE_OBSTACLES_PVT;

Line 443: FND_MSG_PUB.initialize;

439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446:
447: -- Debug Message

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

445:
446:
447: -- Debug Message
448: IF l_debug THEN
449: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
450: END IF;
451:
452:
453:

Line 521: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

517: ,x_update_access_flag => l_access_flag);
518: END IF;
519:
520: IF l_access_flag <> 'Y' THEN
521: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
522: 'API_NO_UPDATE_PRIVILEGE');
523: END IF;
524:
525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

532: X_LEAD_OBSTACLE_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
533:
534: -- Progress Message
535: --
536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
537: THEN
538: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
539: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
540: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 541: FND_MSG_PUB.Add;

537: THEN
538: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
539: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
540: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
541: FND_MSG_PUB.Add;
542: END IF;
543:
544: l_OBSTACLE_rec := P_OBSTACLE_Tbl(I);
545:

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

544: l_OBSTACLE_rec := P_OBSTACLE_Tbl(I);
545:
546: -- Debug Message
547: IF l_debug THEN
548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
549: END IF;
550:
551:
552: Open C_Get_obstacle( l_tar_Obstacle_rec.LEAD_OBSTACLE_ID);

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

586: l_ref_Obstacle_rec.ATTRIBUTE15;
587: -- ? l_ref_Obstacle_rec.SECURITY_GROUP_ID;
588:
589: If ( C_Get_obstacle%NOTFOUND) Then
590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
591: THEN
592: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
593: FND_MESSAGE.Set_Token ('INFO', 'obstacle', FALSE);
594: FND_MSG_PUB.Add;

Line 594: FND_MSG_PUB.Add;

590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
591: THEN
592: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
593: FND_MESSAGE.Set_Token ('INFO', 'obstacle', FALSE);
594: FND_MSG_PUB.Add;
595: END IF;
596: raise FND_API.G_EXC_ERROR;
597: END IF;
598: -- Debug Message

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

596: raise FND_API.G_EXC_ERROR;
597: END IF;
598: -- Debug Message
599: IF l_debug THEN
600: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
601: END IF;
602:
603: Close C_Get_obstacle;
604:

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

603: Close C_Get_obstacle;
604:
605: If (l_tar_Obstacle_rec.last_update_date is NULL or
606: l_tar_Obstacle_rec.last_update_date = FND_API.G_MISS_Date ) Then
607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
608: THEN
609: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
610: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
611: FND_MSG_PUB.ADD;

Line 611: FND_MSG_PUB.ADD;

607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
608: THEN
609: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
610: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
611: FND_MSG_PUB.ADD;
612: END IF;
613: raise FND_API.G_EXC_ERROR;
614: End if;
615: -- Check Whether record has been changed by someone else

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

613: raise FND_API.G_EXC_ERROR;
614: End if;
615: -- Check Whether record has been changed by someone else
616: If (l_tar_Obstacle_rec.last_update_date <> l_ref_Obstacle_rec.last_update_date) Then
617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
618: THEN
619: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
620: FND_MESSAGE.Set_Token('INFO', 'obstacle', FALSE);
621: FND_MSG_PUB.ADD;

Line 621: FND_MSG_PUB.ADD;

617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
618: THEN
619: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
620: FND_MESSAGE.Set_Token('INFO', 'obstacle', FALSE);
621: FND_MSG_PUB.ADD;
622: END IF;
623: raise FND_API.G_EXC_ERROR;
624: End if;
625:

Line 630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');

626: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
627: THEN
628: -- Debug message
629: IF l_debug THEN
630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');
631: END IF;
632:
633:
634: -- Invoke validation procedures

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

649: -- Hint: Add corresponding Master-Detail business logic here if necessary.
650:
651: -- Debug Message
652: IF l_debug THEN
653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
654: END IF;
655:
656:
657: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Update_Row)

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

709:
710:
711: -- Debug Message
712: IF l_debug THEN
713: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
714: END IF;
715:
716:
717:

Line 719: FND_MSG_PUB.Count_And_Get

715:
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: ( p_count => x_msg_count,
721: p_data => x_msg_data
722: );
723:

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

740: END IF;
741: */
742: EXCEPTION
743: WHEN DUP_VAL_ON_INDEX THEN
744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
745: THEN
746: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
747: FND_MSG_PUB.ADD;
748: END IF;

Line 747: FND_MSG_PUB.ADD;

743: WHEN DUP_VAL_ON_INDEX THEN
744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
745: THEN
746: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
747: FND_MSG_PUB.ADD;
748: END IF;
749:
750: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
751: P_MODULE => l_module

Line 754: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

750: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
751: P_MODULE => l_module
752: ,P_API_NAME => L_API_NAME
753: ,P_PKG_NAME => G_PKG_NAME
754: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
755: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
756: ,X_MSG_COUNT => X_MSG_COUNT
757: ,X_MSG_DATA => X_MSG_DATA
758: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

762: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
763: P_MODULE => l_module
764: ,P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
767: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
768: ,X_MSG_COUNT => X_MSG_COUNT
769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

773: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
774: P_MODULE => l_module
775: ,P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
778: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
779: ,X_MSG_COUNT => X_MSG_COUNT
780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

819: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
820: l_Obstacle_rec AS_OPPORTUNITY_PUB.Obstacle_Rec_Type;
821: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
822: l_access_flag VARCHAR2(1);
823: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
824: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Delete_obstacles';
825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT DELETE_OBSTACLES_PVT;

Line 842: FND_MSG_PUB.initialize;

838:
839: -- Initialize message list if p_init_msg_list is set to TRUE.
840: IF FND_API.to_Boolean( p_init_msg_list )
841: THEN
842: FND_MSG_PUB.initialize;
843: END IF;
844:
845:
846: -- Debug Message

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

844:
845:
846: -- Debug Message
847: IF l_debug THEN
848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
849: END IF;
850:
851:
852: -- Initialize API return status to SUCCESS

Line 919: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

915: ,x_update_access_flag => l_access_flag);
916: END IF;
917:
918: IF l_access_flag <> 'Y' THEN
919: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
920: 'API_NO_UPDATE_PRIVILEGE');
921: END IF;
922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

931: X_LEAD_OBSTACLE_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: -- Progress Message
934: --
935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
936: THEN
937: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
938: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
939: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 940: FND_MSG_PUB.Add;

936: THEN
937: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
938: FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_OBSTACLE', TRUE);
939: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
940: FND_MSG_PUB.Add;
941: END IF;
942:
943: -- Debug Message
944: IF l_debug THEN

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

941: END IF;
942:
943: -- Debug Message
944: IF l_debug THEN
945: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
946: END IF;
947:
948:
949: AS_LEAD_OBSTACLES_PKG.Delete_Row(

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

969:
970:
971: -- Debug Message
972: IF l_debug THEN
973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
974: END IF;
975:
976:
977:

Line 979: FND_MSG_PUB.Count_And_Get

975:
976:
977:
978: -- Standard call to get message count and if count is 1, get message info.
979: FND_MSG_PUB.Count_And_Get
980: ( p_count => x_msg_count,
981: p_data => x_msg_data
982: );
983:

Line 1008: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1005: P_MODULE => l_module
1006: ,P_API_NAME => L_API_NAME
1007: ,P_PKG_NAME => G_PKG_NAME
1008: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1010: ,X_MSG_COUNT => X_MSG_COUNT
1011: ,X_MSG_DATA => X_MSG_DATA
1012: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1015: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1016: P_MODULE => l_module
1017: ,P_API_NAME => L_API_NAME
1018: ,P_PKG_NAME => G_PKG_NAME
1019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1020: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1021: ,X_MSG_COUNT => X_MSG_COUNT
1022: ,X_MSG_DATA => X_MSG_DATA
1023: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1064: FND_MSG_PUB.initialize;

1060:
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062: IF FND_API.to_Boolean( p_init_msg_list )
1063: THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066:
1067:
1068: -- Initialize API return status to SUCCESS

Line 1082: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1078:
1079: IF C_Lead_Obstacle_Id_Exists%FOUND THEN
1080: AS_UTILITY_PVT.Set_Message(
1081: p_module => l_module,
1082: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1083: p_msg_name => 'API_DUPLICATE_LEAD_OBSTACLE_ID');
1084:
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: END IF;

Line 1098: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1094: IF (p_LEAD_OBSTACLE_ID is NULL) or (p_LEAD_OBSTACLE_ID = FND_API.G_MISS_NUM)
1095: THEN
1096: AS_UTILITY_PVT.Set_Message(
1097: p_module => l_module,
1098: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1099: p_msg_name => 'API_MISSING_LEAD_OBSTACLE_ID');
1100:
1101: x_return_status := FND_API.G_RET_STS_ERROR;
1102: ELSE

Line 1110: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1106: IF C_Lead_Obstacle_Id_Exists%NOTFOUND
1107: THEN
1108: AS_UTILITY_PVT.Set_Message(
1109: p_module => l_module,
1110: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1111: p_msg_name => 'API_INVALID_LEAD_OBSTACLE_ID',
1112: p_token1 => 'VALUE',
1113: p_token1_value => p_LEAD_OBSTACLE_ID );
1114:

Line 1124: FND_MSG_PUB.Count_And_Get

1120:
1121: END IF;
1122:
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get
1125: ( p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );
1128:

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

1144: FROM as_leads_all
1145: WHERE lead_id = c_Lead_Id;
1146:
1147: l_val VARCHAR2(1);
1148: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1149: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Validate_LEAD_ID';
1150:
1151: BEGIN
1152:

Line 1156: FND_MSG_PUB.initialize;

1152:
1153: -- Initialize message list if p_init_msg_list is set to TRUE.
1154: IF FND_API.to_Boolean( p_init_msg_list )
1155: THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159:
1160: -- Initialize API return status to SUCCESS

Line 1179: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1175: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1176: THEN
1177: AS_UTILITY_PVT.Set_Message(
1178: p_module => l_module,
1179: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1180: p_msg_name => 'API_MISSING_LEAD_ID');
1181:
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: ELSE

Line 1191: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1187: IF C_Lead_Id_Exists%NOTFOUND
1188: THEN
1189: AS_UTILITY_PVT.Set_Message(
1190: p_module => l_module,
1191: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1192: p_msg_name => 'API_INVALID_LEAD_ID',
1193: p_token1 => 'VALUE',
1194: p_token1_value => p_LEAD_ID );
1195:

Line 1203: FND_MSG_PUB.Count_And_Get

1199: CLOSE C_Lead_Id_Exists;
1200: END IF;
1201:
1202: -- Standard call to get message count and if count is 1, get message info.
1203: FND_MSG_PUB.Count_And_Get
1204: ( p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );
1207:

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

1226: and lookup_code = c_OBSTACLE_CODE
1227: and enabled_flag = 'Y';
1228:
1229: l_val VARCHAR2(1);
1230: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1231: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Validate_OBSTACLE_CODE';
1232: BEGIN
1233:
1234: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1237: FND_MSG_PUB.initialize;

1233:
1234: -- Initialize message list if p_init_msg_list is set to TRUE.
1235: IF FND_API.to_Boolean( p_init_msg_list )
1236: THEN
1237: FND_MSG_PUB.initialize;
1238: END IF;
1239:
1240:
1241: -- Initialize API return status to SUCCESS

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

1247: OPEN C_OBSTACLE_CODE_Exists ('ISSUE', p_OBSTACLE_CODE);
1248: FETCH C_OBSTACLE_CODE_Exists into l_val;
1249:
1250: IF C_OBSTACLE_CODE_Exists%NOTFOUND THEN
1251: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1252: -- 'Private API: OBSTACLE_CODE is invalid');
1253:
1254: AS_UTILITY_PVT.Set_Message(
1255: p_module => l_module,

Line 1256: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1252: -- 'Private API: OBSTACLE_CODE is invalid');
1253:
1254: AS_UTILITY_PVT.Set_Message(
1255: p_module => l_module,
1256: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1257: p_msg_name => 'API_INVALID_OBSTACLE_CODE',
1258: p_token1 => 'VALUE',
1259: p_token1_value => p_OBSTACLE_CODE );
1260:

Line 1268: FND_MSG_PUB.Count_And_Get

1264: CLOSE C_OBSTACLE_CODE_Exists;
1265: END IF;
1266:
1267: -- Standard call to get message count and if count is 1, get message info.
1268: FND_MSG_PUB.Count_And_Get
1269: ( p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );
1272:

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

1285: X_Msg_Count OUT NOCOPY NUMBER,
1286: X_Msg_Data OUT NOCOPY VARCHAR2
1287: )
1288: IS
1289: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1290: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Validate_Obstacle_rec';
1291: BEGIN
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1296: FND_MSG_PUB.initialize;

1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.
1294: IF FND_API.to_Boolean( p_init_msg_list )
1295: THEN
1296: FND_MSG_PUB.initialize;
1297: END IF;
1298:
1299:
1300: -- Initialize API return status to SUCCESS

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

1306: -- x_return_status := FND_API.G_RET_STS_ERROR;
1307:
1308: -- Debug Message
1309: IF l_debug THEN
1310: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1311: END IF;
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.

Line 1315: FND_MSG_PUB.Count_And_Get

1311: END IF;
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: ( p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1319:

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

1329: X_Msg_Data OUT NOCOPY VARCHAR2
1330: )
1331: IS
1332: l_api_name CONSTANT VARCHAR2(30) := 'Validate_obstacle';
1333: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1334: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Validate_obstacle';
1335: BEGIN
1336:
1337: -- Debug Message

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

1335: BEGIN
1336:
1337: -- Debug Message
1338: IF l_debug THEN
1339: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1340: END IF;
1341:
1342:
1343:

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

1419:
1420:
1421: -- Debug Message
1422: IF l_debug THEN
1423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1424: END IF;
1425:
1426:
1427: END Validate_obstacle;