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 AS_UTILITY_PVT

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 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 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 202: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,

198: -- Invoke validation procedures
199: Validate_competitor(
200: P_Init_Msg_List => FND_API.G_FALSE,
201: P_Validation_Level => p_validation_level,
202: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,
203: P_Competitor_Rec => l_Competitor_Rec,
204: x_return_status => x_return_status,
205: x_msg_count => x_msg_count,
206: x_msg_data => x_msg_data

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 316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

312: END IF;
313: */
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
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

Line 321: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
325:

Line 327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
336:

Line 338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

334: ,X_MSG_DATA => X_MSG_DATA
335: ,X_RETURN_STATUS => X_RETURN_STATUS);
336:
337: WHEN OTHERS THEN
338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
339: P_MODULE => l_module
340: ,P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
339: P_MODULE => l_module
340: ,P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
344: ,X_MSG_COUNT => X_MSG_COUNT
345: ,X_MSG_DATA => X_MSG_DATA
346: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

339: P_MODULE => l_module
340: ,P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
344: ,X_MSG_COUNT => X_MSG_COUNT
345: ,X_MSG_DATA => X_MSG_DATA
346: ,X_RETURN_STATUS => X_RETURN_STATUS);
347: End Create_competitors;

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 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 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 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 577: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

573: -- Invoke validation procedures
574: Validate_competitor(
575: p_init_msg_list => FND_API.G_FALSE,
576: p_validation_level => p_validation_level,
577: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
578: P_Competitor_Rec => l_Competitor_Rec,
579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data);

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 690: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

686: END IF;
687: */
688: EXCEPTION
689: WHEN FND_API.G_EXC_ERROR THEN
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

Line 695: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
699:

Line 701: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

697: ,X_MSG_DATA => X_MSG_DATA
698: ,X_RETURN_STATUS => X_RETURN_STATUS);
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 706: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
710:

Line 712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);
710:
711: WHEN OTHERS THEN
712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
713: P_MODULE => l_module
714: ,P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 716: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
713: P_MODULE => l_module
714: ,P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
717: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
718: ,X_MSG_COUNT => X_MSG_COUNT
719: ,X_MSG_DATA => X_MSG_DATA
720: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 717: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

713: P_MODULE => l_module
714: ,P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
717: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
718: ,X_MSG_COUNT => X_MSG_COUNT
719: ,X_MSG_DATA => X_MSG_DATA
720: ,X_RETURN_STATUS => X_RETURN_STATUS);
721: End Update_competitors;

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 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 949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

945: END IF;
946: */
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
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

Line 954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
958:

Line 960: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 965: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
969:

Line 971: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

967: ,X_MSG_DATA => X_MSG_DATA
968: ,X_RETURN_STATUS => X_RETURN_STATUS);
969:
970: WHEN OTHERS THEN
971: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
972: P_MODULE => l_module
973: ,P_API_NAME => L_API_NAME
974: ,P_PKG_NAME => G_PKG_NAME
975: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 975: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

971: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
972: P_MODULE => l_module
973: ,P_API_NAME => L_API_NAME
974: ,P_PKG_NAME => G_PKG_NAME
975: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
977: ,X_MSG_COUNT => X_MSG_COUNT
978: ,X_MSG_DATA => X_MSG_DATA
979: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

972: P_MODULE => l_module
973: ,P_API_NAME => L_API_NAME
974: ,P_PKG_NAME => G_PKG_NAME
975: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
977: ,X_MSG_COUNT => X_MSG_COUNT
978: ,X_MSG_DATA => X_MSG_DATA
979: ,X_RETURN_STATUS => X_RETURN_STATUS);
980: End Delete_competitors;

Line 1013: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1009:
1010: -- Initialize API return status to SUCCESS
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1014: THEN
1015:
1016: IF (p_LEAD_COMPETITOR_ID is not NULL) and (p_LEAD_COMPETITOR_ID <> FND_API.G_MISS_NUM)
1017: THEN

Line 1022: AS_UTILITY_PVT.Set_Message(

1018: OPEN C_Lead_Competitor_Id_Exists (p_Lead_Competitor_Id);
1019: FETCH C_Lead_Competitor_Id_Exists into l_val;
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:

Line 1033: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1029:
1030: CLOSE C_Lead_Competitor_Id_Exists;
1031: END IF;
1032:
1033: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1034: THEN
1035:
1036: IF (p_LEAD_COMPETITOR_ID is NULL) or (p_LEAD_COMPETITOR_ID = FND_API.G_MISS_NUM)
1037: THEN

Line 1038: AS_UTILITY_PVT.Set_Message(

1034: THEN
1035:
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:

Line 1050: AS_UTILITY_PVT.Set_Message(

1046: FETCH C_Lead_Competitor_Id_Exists into l_val;
1047:
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',

Line 1110: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',

1106: -- validate NOT NULL column
1107: IF(p_LEAD_ID is NULL)
1108: THEN
1109: IF l_debug THEN
1110: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',
1111: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
1112: END IF;
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1119: AS_UTILITY_PVT.Set_Message(

1115: END IF;
1116:
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:

Line 1131: AS_UTILITY_PVT.Set_Message(

1127: FETCH C_Lead_Id_Exists into l_val;
1128:
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',

Line 1190: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',

1186:
1187: IF(p_COMPETITOR_ID is NULL)
1188: THEN
1189: IF l_debug THEN
1190: AS_UTILITY_PVT.Debug_Message(l_module, 'ERROR',
1191: 'Private API: Violate NOT NULL constraint(COMPETITOR_ID)');
1192: END IF;
1193:
1194: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1206: AS_UTILITY_PVT.Set_Message(

1202:
1203: IF C_COMPETITOR_Id_Exists%NOTFOUND
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',

Line 1225: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use

1221:
1222: END Validate_COMPETITOR_ID;
1223:
1224: -- Hint: inter-field level validation can be added here.
1225: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use
1226: -- cursor to get old values for all fields used in inter-field validation
1227: -- and set all G_MISS_XXX fields to original value stored in database
1228: -- table.
1229: PROCEDURE Validate_Competitor_rec(

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