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

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

42: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
43: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
44: L_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
45: L_Access_Flag VARCHAR2(1);
46: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Create_competitors';
48:
49: BEGIN
50: -- Standard Start of API savepoint

Line 66: FND_MSG_PUB.initialize;

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

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

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

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

107: -- Validate Environment
108: -- ******************************************************************
109: IF FND_GLOBAL.User_Id IS NULL
110: THEN
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name(' + appShortName +',
114: 'UT_CANNOT_GET_PROFILE_VALUE');
115: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 116: FND_MSG_PUB.ADD;

112: THEN
113: FND_MESSAGE.Set_Name(' + appShortName +',
114: 'UT_CANNOT_GET_PROFILE_VALUE');
115: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
116: FND_MSG_PUB.ADD;
117: END IF;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:

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

161: x_update_access_flag => l_access_flag);
162: END IF;
163:
164: IF l_access_flag <> 'Y' THEN
165: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
166: 'API_NO_UPDATE_PRIVILEGE');
167: END IF;
168:
169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

175: FND_API.G_RET_STS_SUCCESS ;
176:
177: -- Progress Message
178: --
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
180: THEN
181: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
182: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
183: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 184: FND_MSG_PUB.Add;

180: THEN
181: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
182: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
183: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
184: FND_MSG_PUB.Add;
185: END IF;
186:
187: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
188:

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

189: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
190: THEN
191: -- Debug message
192: IF l_debug THEN
193: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
194: 'Private API: Validate_competitor');
195: END IF;
196:
197:

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

212: END IF;
213:
214: -- Debug Message
215: IF l_debug THEN
216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
217: 'Private API: Calling create table handler');
218:
219: END IF;
220:

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

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

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 320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
317: P_MODULE => l_module
318: ,P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
321: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
322: ,X_MSG_COUNT => X_MSG_COUNT
323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
328: P_MODULE => l_module
329: ,P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME
331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
333: ,X_MSG_COUNT => X_MSG_COUNT
334: ,X_MSG_DATA => X_MSG_DATA
335: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

381: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
382: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
383: L_Last_Update_Date DATE;
384: L_Access_Flag VARCHAR2(1);
385: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
386: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Update_competitors';
387:
388: BEGIN
389: -- Standard Start of API savepoint

Line 405: FND_MSG_PUB.initialize;

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

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

407:
408:
409: -- Debug Message
410: IF l_debug THEN
411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
412: 'Private API: ' || l_api_name || ' start');
413: END IF;
414:
415:

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

487: x_update_access_flag => l_access_flag);
488: END IF;
489:
490: IF l_access_flag <> 'Y' THEN
491: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
492: 'API_NO_UPDATE_PRIVILEGE');
493: END IF;
494:
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

501: FND_API.G_RET_STS_SUCCESS ;
502:
503: -- Progress Message
504: --
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
506: THEN
507: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
508: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
509: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 510: FND_MSG_PUB.Add;

506: THEN
507: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
508: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
509: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
510: FND_MSG_PUB.Add;
511: END IF;
512:
513: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
514:

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

513: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
514:
515: -- Debug Message
516: IF l_debug THEN
517: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
518: 'Private API: - Open Cursor to Select');
519: END IF;
520:
521:

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

523:
524: Fetch C_Get_competitor into l_last_update_date;
525:
526: If ( C_Get_competitor%NOTFOUND) Then
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
530: FND_MESSAGE.Set_Token ('INFO', 'competitor', FALSE);
531: FND_MSG_PUB.Add;

Line 531: FND_MSG_PUB.Add;

527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
530: FND_MESSAGE.Set_Token ('INFO', 'competitor', FALSE);
531: FND_MSG_PUB.Add;
532: END IF;
533: raise FND_API.G_EXC_ERROR;
534: END IF;
535: -- Debug Message

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

533: raise FND_API.G_EXC_ERROR;
534: END IF;
535: -- Debug Message
536: IF l_debug THEN
537: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'Private API: - Close Cursor');
539: END IF;
540:
541: Close C_Get_competitor;

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

541: Close C_Get_competitor;
542:
543: If (l_Competitor_rec.last_update_date is NULL or
544: l_Competitor_rec.last_update_date = FND_API.G_MISS_Date ) Then
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
548: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
549: FND_MSG_PUB.ADD;

Line 549: FND_MSG_PUB.ADD;

545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
548: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
549: FND_MSG_PUB.ADD;
550: END IF;
551: raise FND_API.G_EXC_ERROR;
552: End if;
553: -- Check Whether record has been changed by someone else

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

551: raise FND_API.G_EXC_ERROR;
552: End if;
553: -- Check Whether record has been changed by someone else
554: If (l_Competitor_rec.last_update_date <> l_last_update_date) Then
555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
556: THEN
557: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
558: FND_MESSAGE.Set_Token('INFO', 'competitor', FALSE);
559: FND_MSG_PUB.ADD;

Line 559: FND_MSG_PUB.ADD;

555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
556: THEN
557: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
558: FND_MESSAGE.Set_Token('INFO', 'competitor', FALSE);
559: FND_MSG_PUB.ADD;
560: END IF;
561: raise FND_API.G_EXC_ERROR;
562: End if;
563:

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

564: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
565: THEN
566: -- Debug message
567: IF l_debug THEN
568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
569: 'Private API: Validate_competitor');
570: END IF;
571:
572:

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

586: END IF;
587:
588: -- Debug Message
589: IF l_debug THEN
590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
591: 'Private API: Calling update table handler');
592: END IF;
593:
594:

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

652:
653:
654: -- Debug Message
655: IF l_debug THEN
656: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
657: 'Private API: ' || l_api_name || ' end');
658: END IF;
659:
660:

Line 663: FND_MSG_PUB.Count_And_Get

659:
660:
661:
662: -- Standard call to get message count and if count is 1, get message info.
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:

Line 694: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
691: P_MODULE => l_module
692: ,P_API_NAME => L_API_NAME
693: ,P_PKG_NAME => G_PKG_NAME
694: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
695: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
696: ,X_MSG_COUNT => X_MSG_COUNT
697: ,X_MSG_DATA => X_MSG_DATA
698: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

701: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
702: P_MODULE => l_module
703: ,P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME
705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
706: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
707: ,X_MSG_COUNT => X_MSG_COUNT
708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

752: L_Lead_Competitor_Id NUMBER;
753: L_Line_Count CONSTANT NUMBER := P_Competitor_Tbl.count;
754: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
755: L_Access_Flag VARCHAR2(1);
756: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
757: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Delete_competitors';
758:
759: BEGIN
760: -- Standard Start of API savepoint

Line 776: FND_MSG_PUB.initialize;

772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: IF FND_API.to_Boolean( p_init_msg_list )
775: THEN
776: FND_MSG_PUB.initialize;
777: END IF;
778:
779:
780: -- Debug Message

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

778:
779:
780: -- Debug Message
781: IF l_debug THEN
782: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
783: 'Private API: ' || l_api_name || ' start');
784: END IF;
785:
786:

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

854: x_update_access_flag => l_access_flag);
855: END IF;
856:
857: IF l_access_flag <> 'Y' THEN
858: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
859: 'API_NO_UPDATE_PRIVILEGE');
860: END IF;
861:
862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

868: FND_API.G_RET_STS_SUCCESS ;
869:
870: -- Progress Message
871: --
872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
873: THEN
874: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
875: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
876: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 877: FND_MSG_PUB.Add;

873: THEN
874: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
875: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMPETITOR', TRUE);
876: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
877: FND_MSG_PUB.Add;
878: END IF;
879:
880: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
881:

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

880: l_competitor_rec := P_Competitor_Tbl(l_curr_row);
881:
882: -- Debug Message
883: IF l_debug THEN
884: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
885: 'Private API: Calling delete table handler');
886: END IF;
887:
888:

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

912:
913:
914: -- Debug Message
915: IF l_debug THEN
916: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
917: 'Private API: ' || l_api_name || ' end');
918: END IF;
919:
920:

Line 923: FND_MSG_PUB.Count_And_Get

919:
920:
921:
922: -- Standard call to get message count and if count is 1, get message info.
923: FND_MSG_PUB.Count_And_Get
924: ( p_count => x_msg_count,
925: p_data => x_msg_data
926: );
927:

Line 953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
950: P_MODULE => l_module
951: ,P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
955: ,X_MSG_COUNT => X_MSG_COUNT
956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 964: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

960: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
961: P_MODULE => l_module
962: ,P_API_NAME => L_API_NAME
963: ,P_PKG_NAME => G_PKG_NAME
964: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
965: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
966: ,X_MSG_COUNT => X_MSG_COUNT
967: ,X_MSG_DATA => X_MSG_DATA
968: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1006: FND_MSG_PUB.initialize;

1002: BEGIN
1003: -- Initialize message list if p_init_msg_list is set to TRUE.
1004: IF FND_API.to_Boolean( p_init_msg_list )
1005: THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009:
1010: -- Initialize API return status to SUCCESS

Line 1024: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1020:
1021: IF C_Lead_Competitor_Id_Exists%FOUND THEN
1022: AS_UTILITY_PVT.Set_Message(
1023: p_module => l_module,
1024: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1025: p_msg_name => 'API_DUPLICATE_LEAD_COMPETITOR_ID');
1026:
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;

Line 1040: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1036: IF (p_LEAD_COMPETITOR_ID is NULL) or (p_LEAD_COMPETITOR_ID = FND_API.G_MISS_NUM)
1037: THEN
1038: AS_UTILITY_PVT.Set_Message(
1039: p_module => l_module,
1040: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1041: p_msg_name => 'API_MISSING_LEAD_COMPETITOR_ID');
1042:
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: ELSE

Line 1052: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1048: IF C_Lead_Competitor_Id_Exists%NOTFOUND
1049: THEN
1050: AS_UTILITY_PVT.Set_Message(
1051: p_module => l_module,
1052: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1053: p_msg_name => 'API_INVALID_LEAD_COMPETITOR_ID',
1054: p_token1 => 'VALUE',
1055: p_token1_value => p_LEAD_COMPETITOR_ID );
1056:

Line 1066: FND_MSG_PUB.Count_And_Get

1062:
1063: END IF;
1064:
1065: -- Standard call to get message count and if count is 1, get message info.
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_count => x_msg_count,
1068: p_data => x_msg_data
1069: );
1070:

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

1087: FROM as_leads_all
1088: WHERE lead_id = c_Lead_Id;
1089:
1090: l_val VARCHAR2(1);
1091: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1092: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_LEAD_ID';
1093:
1094: BEGIN
1095:

Line 1099: FND_MSG_PUB.initialize;

1095:
1096: -- Initialize message list if p_init_msg_list is set to TRUE.
1097: IF FND_API.to_Boolean( p_init_msg_list )
1098: THEN
1099: FND_MSG_PUB.initialize;
1100: END IF;
1101:
1102:
1103: -- Initialize API return status to SUCCESS

Line 1121: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1117: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1118: THEN
1119: AS_UTILITY_PVT.Set_Message(
1120: p_module => l_module,
1121: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1122: p_msg_name => 'API_MISSING_LEAD_ID');
1123:
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: ELSE

Line 1133: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1129: IF C_Lead_Id_Exists%NOTFOUND
1130: THEN
1131: AS_UTILITY_PVT.Set_Message(
1132: p_module => l_module,
1133: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1134: p_msg_name => 'API_INVALID_LEAD_ID',
1135: p_token1 => 'VALUE',
1136: p_token1_value => p_LEAD_ID );
1137:

Line 1145: FND_MSG_PUB.Count_And_Get

1141: CLOSE C_Lead_Id_Exists;
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: ( p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149:

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

1168: WHERE party_id = c_cmp_Id
1169: AND STATUS in ('A', 'I');
1170:
1171: l_val VARCHAR2(1);
1172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1173: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_COMPETITOR_ID';
1174:
1175: BEGIN
1176:

Line 1180: FND_MSG_PUB.initialize;

1176:
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: IF FND_API.to_Boolean( p_init_msg_list )
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183:
1184: -- Initialize API return status to SUCCESS

Line 1208: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1204: THEN
1205:
1206: AS_UTILITY_PVT.Set_Message(
1207: p_module => l_module,
1208: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1209: p_msg_name => 'API_INVALID_COMP_ID',
1210: p_token1 => 'VALUE',
1211: p_token1_value => p_COMPETITOR_ID );
1212:

Line 1217: FND_MSG_PUB.Count_And_Get

1213: END IF;
1214: END IF;
1215:
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: ( p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );
1221:

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

1234: X_Msg_Count OUT NOCOPY NUMBER,
1235: X_Msg_Data OUT NOCOPY VARCHAR2
1236: )
1237: IS
1238: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1239: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_Competitor_rec';
1240: BEGIN
1241:
1242: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1245: FND_MSG_PUB.initialize;

1241:
1242: -- Initialize message list if p_init_msg_list is set to TRUE.
1243: IF FND_API.to_Boolean( p_init_msg_list )
1244: THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248:
1249: -- Initialize API return status to SUCCESS

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

1255: -- x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: -- Debug Message
1258: IF l_debug THEN
1259: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1260: 'API_INVALID_RECORD');
1261: END IF;
1262:
1263:

Line 1265: FND_MSG_PUB.Count_And_Get

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

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

1282: IS
1283:
1284: l_api_name CONSTANT VARCHAR2(30) := 'Validate_competitor';
1285: l_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
1286: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1287: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_competitor';
1288: BEGIN
1289:
1290: -- Debug Message

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

1288: BEGIN
1289:
1290: -- Debug Message
1291: IF l_debug THEN
1292: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1293: 'Private API: ' || l_api_name || ' start');
1294: END IF;
1295:
1296: -- Initialize API return status to SUCCESS

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

1377:
1378:
1379: -- Debug Message
1380: IF l_debug THEN
1381: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1382: 'Private API: ' || l_api_name || ' end');
1383: END IF;
1384:
1385: END Validate_competitor;