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_COMPETITOR_PROD_PVT dependencies on AS_UTILITY_PVT

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

137:
138:
139: -- Debug Message
140: IF l_debug THEN
141: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
142: 'Private API: ' || l_api_name || ' start');
143: END IF;
144:
145: -- Initialize API return status to SUCCESS

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

227: x_msg_data => x_msg_data,
228: x_update_access_flag => l_access_flag);
229:
230: IF l_access_flag <> 'Y' THEN
231: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
232: 'API_NO_UPDATE_PRIVILEGE');
233: END IF;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

267: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
268: THEN
269: -- Debug message
270: IF l_debug THEN
271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
272: 'Private API: Validate_competitor_prod');
273:
274: END IF;
275:

Line 280: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,

276: -- Invoke validation procedures
277: Validate_competitor_prod(
278: P_Init_Msg_List => FND_API.G_FALSE,
279: P_Validation_Level => p_validation_level,
280: P_Validation_Mode => AS_UTILITY_PVT.G_CREATE,
281: P_Competitor_Prod_Rec => l_Competitor_Prod_Rec,
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,
284: x_msg_data => x_msg_data

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

299: END IF;
300: */
301: -- Debug Message
302: IF l_debug THEN
303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
304: 'Private API: Calling create table handler');
305:
306: END IF;
307:

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

375:
376:
377: -- Debug Message
378: IF l_debug THEN
379: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
380: 'Private API: ' || l_api_name || ' end');
381: END IF;
382:
383:

Line 418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

414: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
415: FND_MSG_PUB.ADD;
416: END IF;
417:
418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
419: P_MODULE => l_module
420: ,P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

419: P_MODULE => l_module
420: ,P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:

Line 429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:
428: WHEN FND_API.G_EXC_ERROR THEN
429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
430: P_MODULE => l_module
431: ,P_API_NAME => L_API_NAME
432: ,P_PKG_NAME => G_PKG_NAME
433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 434: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

430: P_MODULE => l_module
431: ,P_API_NAME => L_API_NAME
432: ,P_PKG_NAME => G_PKG_NAME
433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
434: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
435: ,X_MSG_COUNT => X_MSG_COUNT
436: ,X_MSG_DATA => X_MSG_DATA
437: ,X_RETURN_STATUS => X_RETURN_STATUS);
438:

Line 440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

436: ,X_MSG_DATA => X_MSG_DATA
437: ,X_RETURN_STATUS => X_RETURN_STATUS);
438:
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
441: P_MODULE => l_module
442: ,P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

441: P_MODULE => l_module
442: ,P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
446: ,X_MSG_COUNT => X_MSG_COUNT
447: ,X_MSG_DATA => X_MSG_DATA
448: ,X_RETURN_STATUS => X_RETURN_STATUS);
449:

Line 451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

447: ,X_MSG_DATA => X_MSG_DATA
448: ,X_RETURN_STATUS => X_RETURN_STATUS);
449:
450: WHEN OTHERS THEN
451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_MODULE => l_module
453: ,P_API_NAME => L_API_NAME
454: ,P_PKG_NAME => G_PKG_NAME
455: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 455: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_MODULE => l_module
453: ,P_API_NAME => L_API_NAME
454: ,P_PKG_NAME => G_PKG_NAME
455: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
457: ,X_MSG_COUNT => X_MSG_COUNT
458: ,X_MSG_DATA => X_MSG_DATA
459: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

452: P_MODULE => l_module
453: ,P_API_NAME => L_API_NAME
454: ,P_PKG_NAME => G_PKG_NAME
455: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
457: ,X_MSG_COUNT => X_MSG_COUNT
458: ,X_MSG_DATA => X_MSG_DATA
459: ,X_RETURN_STATUS => X_RETURN_STATUS);
460: End Create_competitor_prods;

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

522:
523:
524: -- Debug Message
525: IF l_debug THEN
526: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
527: 'Private API: ' || l_api_name || ' start');
528: END IF;
529:
530:

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

600: x_msg_data => x_msg_data,
601: x_update_access_flag => l_access_flag);
602:
603: IF l_access_flag <> 'Y' THEN
604: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
605: 'API_NO_UPDATE_PRIVILEGE');
606: END IF;
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

626: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
627:
628: -- Debug Message
629: IF l_debug THEN
630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
631: 'Private API: - Open Cursor to Select');
632:
633: END IF;
634:

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

646: raise FND_API.G_EXC_ERROR;
647: END IF;
648: -- Debug Message
649: IF l_debug THEN
650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
651: 'Private API: - Close Cursor');
652: END IF;
653:
654: Close C_Get_competitor_prod;

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

682: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
683: THEN
684: -- Debug message
685: IF l_debug THEN
686: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
687: 'Private API: Validate_competitor_prod');
688: END IF;
689:
690: -- Invoke validation procedures

Line 694: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

690: -- Invoke validation procedures
691: Validate_competitor_prod(
692: p_init_msg_list => FND_API.G_FALSE,
693: p_validation_level => p_validation_level,
694: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
695: P_Competitor_Prod_Rec => l_Competitor_Prod_Rec,
696: x_return_status => x_return_status,
697: x_msg_count => x_msg_count,
698: x_msg_data => x_msg_data);

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

712: END IF;
713: */
714: -- Debug Message
715: IF l_debug THEN
716: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
717: 'Private API: Calling update table handler');
718: END IF;
719:
720:

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

774:
775:
776: -- Debug Message
777: IF l_debug THEN
778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
779: 'Private API: ' || l_api_name || ' end');
780: END IF;
781:
782:

Line 819: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

815: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
816: FND_MSG_PUB.ADD;
817: END IF;
818:
819: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
820: P_MODULE => l_module
821: ,P_API_NAME => L_API_NAME
822: ,P_PKG_NAME => G_PKG_NAME
823: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 824: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

820: P_MODULE => l_module
821: ,P_API_NAME => L_API_NAME
822: ,P_PKG_NAME => G_PKG_NAME
823: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
824: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
825: ,X_MSG_COUNT => X_MSG_COUNT
826: ,X_MSG_DATA => X_MSG_DATA
827: ,X_RETURN_STATUS => X_RETURN_STATUS);
828:

Line 830: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

826: ,X_MSG_DATA => X_MSG_DATA
827: ,X_RETURN_STATUS => X_RETURN_STATUS);
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
831: P_MODULE => l_module
832: ,P_API_NAME => L_API_NAME
833: ,P_PKG_NAME => G_PKG_NAME
834: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 835: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

831: P_MODULE => l_module
832: ,P_API_NAME => L_API_NAME
833: ,P_PKG_NAME => G_PKG_NAME
834: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
835: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
836: ,X_MSG_COUNT => X_MSG_COUNT
837: ,X_MSG_DATA => X_MSG_DATA
838: ,X_RETURN_STATUS => X_RETURN_STATUS);
839:

Line 841: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

837: ,X_MSG_DATA => X_MSG_DATA
838: ,X_RETURN_STATUS => X_RETURN_STATUS);
839:
840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
841: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
842: P_MODULE => l_module
843: ,P_API_NAME => L_API_NAME
844: ,P_PKG_NAME => G_PKG_NAME
845: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 846: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

842: P_MODULE => l_module
843: ,P_API_NAME => L_API_NAME
844: ,P_PKG_NAME => G_PKG_NAME
845: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
846: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
847: ,X_MSG_COUNT => X_MSG_COUNT
848: ,X_MSG_DATA => X_MSG_DATA
849: ,X_RETURN_STATUS => X_RETURN_STATUS);
850:

Line 852: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

848: ,X_MSG_DATA => X_MSG_DATA
849: ,X_RETURN_STATUS => X_RETURN_STATUS);
850:
851: WHEN OTHERS THEN
852: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
853: P_MODULE => l_module
854: ,P_API_NAME => L_API_NAME
855: ,P_PKG_NAME => G_PKG_NAME
856: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 856: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

852: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
853: P_MODULE => l_module
854: ,P_API_NAME => L_API_NAME
855: ,P_PKG_NAME => G_PKG_NAME
856: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
857: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
858: ,X_MSG_COUNT => X_MSG_COUNT
859: ,X_MSG_DATA => X_MSG_DATA
860: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 857: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

853: P_MODULE => l_module
854: ,P_API_NAME => L_API_NAME
855: ,P_PKG_NAME => G_PKG_NAME
856: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
857: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
858: ,X_MSG_COUNT => X_MSG_COUNT
859: ,X_MSG_DATA => X_MSG_DATA
860: ,X_RETURN_STATUS => X_RETURN_STATUS);
861: End Update_competitor_prods;

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

917:
918:
919: -- Debug Message
920: IF l_debug THEN
921: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
922: 'Private API: ' || l_api_name || ' start');
923: END IF;
924:
925:

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

992: x_update_access_flag => l_access_flag);
993: END IF;
994:
995: IF l_access_flag <> 'Y' THEN
996: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
997: 'API_NO_UPDATE_PRIVILEGE');
998: END IF;
999:
1000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1018: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
1019:
1020: -- Debug Message
1021: IF l_debug THEN
1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1023: 'Private API: Calling delete table handler');
1024: END IF;
1025:
1026:

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

1050:
1051:
1052: -- Debug Message
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Private API: ' || l_api_name || ' end');
1056: END IF;
1057:
1058:

Line 1086: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1082: END IF;
1083: */
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1087: P_MODULE => l_module
1088: ,P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1091: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1087: P_MODULE => l_module
1088: ,P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1091: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1092: ,X_MSG_COUNT => X_MSG_COUNT
1093: ,X_MSG_DATA => X_MSG_DATA
1094: ,X_RETURN_STATUS => X_RETURN_STATUS);
1095:

Line 1097: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1093: ,X_MSG_DATA => X_MSG_DATA
1094: ,X_RETURN_STATUS => X_RETURN_STATUS);
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1098: P_MODULE => l_module
1099: ,P_API_NAME => L_API_NAME
1100: ,P_PKG_NAME => G_PKG_NAME
1101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1102: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1098: P_MODULE => l_module
1099: ,P_API_NAME => L_API_NAME
1100: ,P_PKG_NAME => G_PKG_NAME
1101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1102: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1103: ,X_MSG_COUNT => X_MSG_COUNT
1104: ,X_MSG_DATA => X_MSG_DATA
1105: ,X_RETURN_STATUS => X_RETURN_STATUS);
1106:

Line 1108: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1104: ,X_MSG_DATA => X_MSG_DATA
1105: ,X_RETURN_STATUS => X_RETURN_STATUS);
1106:
1107: WHEN OTHERS THEN
1108: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1109: P_MODULE => l_module
1110: ,P_API_NAME => L_API_NAME
1111: ,P_PKG_NAME => G_PKG_NAME
1112: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1112: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1108: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1109: P_MODULE => l_module
1110: ,P_API_NAME => L_API_NAME
1111: ,P_PKG_NAME => G_PKG_NAME
1112: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1113: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1114: ,X_MSG_COUNT => X_MSG_COUNT
1115: ,X_MSG_DATA => X_MSG_DATA
1116: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1113: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1109: P_MODULE => l_module
1110: ,P_API_NAME => L_API_NAME
1111: ,P_PKG_NAME => G_PKG_NAME
1112: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1113: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1114: ,X_MSG_COUNT => X_MSG_COUNT
1115: ,X_MSG_DATA => X_MSG_DATA
1116: ,X_RETURN_STATUS => X_RETURN_STATUS);
1117: End Delete_competitor_prods;

Line 1142: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1138:
1139: -- Initialize API return status to SUCCESS
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141:
1142: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1143: THEN
1144: -- Hint: Validate data
1145: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1146: -- verify if data is valid

Line 1149: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1145: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1146: -- verify if data is valid
1147: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1148: NULL;
1149: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1150: THEN
1151: -- Hint: Validate data
1152: -- IF p_REQUEST_ID <> G_MISS_CHAR
1153: -- verify if data is valid

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

1204: p_WIN_LOSS_STATUS);
1205: FETCH C_WIN_LOSS_STATUS_Exists into l_val;
1206:
1207: IF C_WIN_LOSS_STATUS_Exists%NOTFOUND THEN
1208: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1209: -- 'Private API: WIN_LOSS_STATUS is invalid');
1210:
1211: AS_UTILITY_PVT.Set_Message(
1212: p_module => l_module,

Line 1211: AS_UTILITY_PVT.Set_Message(

1207: IF C_WIN_LOSS_STATUS_Exists%NOTFOUND THEN
1208: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1209: -- 'Private API: WIN_LOSS_STATUS is invalid');
1210:
1211: AS_UTILITY_PVT.Set_Message(
1212: p_module => l_module,
1213: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1214: p_msg_name => 'API_INVALID_WIN_LOSS_STATUS',
1215: p_token1 => 'VALUE',

Line 1267: AS_UTILITY_PVT.Set_Message(

1263:
1264: IF (p_COMPETITOR_PRODUCT_ID is NULL) or
1265: (p_COMPETITOR_PRODUCT_ID = FND_API.G_MISS_NUM)
1266: THEN
1267: AS_UTILITY_PVT.Set_Message(
1268: p_module => l_module,
1269: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1270: p_msg_name => 'API_MISSING_COMPETITOR_PRODUCT_ID');
1271:

Line 1280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1276: OPEN c_competitor_product_exists(p_COMPETITOR_PRODUCT_ID);
1277: FETCH c_competitor_product_exists into l_val;
1278: IF c_competitor_product_exists%NOTFOUND THEN
1279: IF l_debug THEN
1280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1281: 'Private API: COMPETITOR_PRODUCT_ID is invalid');
1282: END IF;
1283:
1284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1332:
1333: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
1334: THEN
1335: IF l_debug THEN
1336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1337: 'Private API 38: Violate NOT NULL constraint(LEAD_LINE_ID)');
1338: END IF;
1339:
1340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1347: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1343: FETCH C_Lead_Line_Id_Exists into l_val;
1344: IF C_Lead_Line_Id_Exists%NOTFOUND
1345: THEN
1346: IF l_debug THEN
1347: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1348: 'Private API 39: LEAD_LINE_ID is not valid');
1349: END IF;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;

Line 1400: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1396:
1397: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1398: THEN
1399: IF l_debug THEN
1400: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1401: 'Private API 36: Violate NOT NULL constraint(LEAD_ID)');
1402: END IF;
1403:
1404: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1407: FETCH C_Lead_Id_Exists into l_val;
1408: IF C_Lead_Id_Exists%NOTFOUND
1409: THEN
1410: IF l_debug THEN
1411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1412: 'Private API 37: LEAD_ID is not valid');
1413: END IF;
1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1458: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1454: -- Initialize API return status to SUCCESS
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456:
1457: -- Calling from Create API
1458: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1459: THEN
1460: IF (p_LEAD_COMPETITOR_PROD_ID is NOT NULL) and (p_LEAD_COMPETITOR_PROD_ID <> FND_API.G_MISS_NUM)
1461: THEN
1462: OPEN C_Lead_CProd_Id_Exists (p_Lead_Competitor_Prod_Id);

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

1462: OPEN C_Lead_CProd_Id_Exists (p_Lead_Competitor_Prod_Id);
1463: FETCH C_Lead_CProd_Id_Exists into l_val;
1464:
1465: IF C_Lead_CProd_Id_Exists%FOUND THEN
1466: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1467: -- 'Private API: LEAD_COMPETITOR_PROD_ID exist');
1468:
1469: AS_UTILITY_PVT.Set_Message(
1470: p_module => l_module,

Line 1469: AS_UTILITY_PVT.Set_Message(

1465: IF C_Lead_CProd_Id_Exists%FOUND THEN
1466: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1467: -- 'Private API: LEAD_COMPETITOR_PROD_ID exist');
1468:
1469: AS_UTILITY_PVT.Set_Message(
1470: p_module => l_module,
1471: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1472: p_msg_name => 'API_DUPLICATE_LEAD_CPROD_ID',
1473: p_token1 => 'VALUE',

Line 1483: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1479: CLOSE C_Lead_CProd_Id_Exists;
1480: END IF;
1481:
1482: -- Calling from Update API
1483: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1484: THEN
1485: -- validate NOT NULL column
1486: IF (p_LEAD_COMPETITOR_PROD_ID is NULL) or (p_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM)
1487: THEN

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

1484: THEN
1485: -- validate NOT NULL column
1486: IF (p_LEAD_COMPETITOR_PROD_ID is NULL) or (p_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM)
1487: THEN
1488: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1489: -- 'Private API: Violate NOT NULL constraint(LEAD_COMPETITOR_PROD_ID)');
1490:
1491: AS_UTILITY_PVT.Set_Message(
1492: p_module => l_module,

Line 1491: AS_UTILITY_PVT.Set_Message(

1487: THEN
1488: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1489: -- 'Private API: Violate NOT NULL constraint(LEAD_COMPETITOR_PROD_ID)');
1490:
1491: AS_UTILITY_PVT.Set_Message(
1492: p_module => l_module,
1493: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1494: p_msg_name => 'API_MISSING_LEAD_CPROD_ID');
1495:

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

1499: FETCH C_Lead_CProd_Id_Exists into l_val;
1500:
1501: IF C_Lead_CProd_Id_Exists%NOTFOUND
1502: THEN
1503: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1504: -- 'Private API: LEAD_COMPETITOR_PROD_ID is not valid');
1505:
1506: AS_UTILITY_PVT.Set_Message(
1507: p_module => l_module,

Line 1506: AS_UTILITY_PVT.Set_Message(

1502: THEN
1503: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1504: -- 'Private API: LEAD_COMPETITOR_PROD_ID is not valid');
1505:
1506: AS_UTILITY_PVT.Set_Message(
1507: p_module => l_module,
1508: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1509: p_msg_name => 'API_INVALID_LEAD_CPROD_ID',
1510: p_token1 => 'VALUE',

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

1526: END Validate_L_COMPETITOR_PROD_ID;
1527:
1528:
1529: -- Hint: inter-field level validation can be added here.
1530: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1531: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1532: -- stored in database table.
1533:
1534:

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

1586: BEGIN
1587:
1588: -- Debug Message
1589: IF l_debug THEN
1590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1591: END IF;
1592:
1593:
1594:

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

1597:
1598: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1599:
1600: IF l_debug THEN
1601: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1602: 'Private API validate: REQUEST_ID');
1603: END IF;
1604:
1605: Validate_REQUEST_ID(

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

1610: x_msg_count => x_msg_count,
1611: x_msg_data => x_msg_data);
1612:
1613: IF l_debug THEN
1614: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'Private API validate: WIN_LOSS_STATUS ');
1616: END IF;
1617:
1618: Validate_WIN_LOSS_STATUS(

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

1632: x_msg_count => x_msg_count,
1633: x_msg_data => x_msg_data);
1634:
1635: IF l_debug THEN
1636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'Private API validate: LEAD_LINE_ID');
1638: END IF;
1639:
1640: Validate_LEAD_LINE_ID(

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

1645: x_msg_count => x_msg_count,
1646: x_msg_data => x_msg_data);
1647:
1648: IF l_debug THEN
1649: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1650: 'Private API validate: LEAD_ID');
1651: END IF;
1652:
1653: Validate_LEAD_ID(

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

1658: x_msg_count => x_msg_count,
1659: x_msg_data => x_msg_data);
1660:
1661: IF l_debug THEN
1662: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1663: 'Private API validate: L_COMPETITOR_PROD_ID');
1664: END IF;
1665:
1666:

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

1678: -- Hint: Inter-field level validation can be added here
1679: -- invoke record level validation procedures
1680:
1681: IF l_debug THEN
1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1683: 'Private API validate: Competitor_Prod_Rec');
1684: END IF;
1685:
1686:

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

1709:
1710:
1711: -- Debug Message
1712: IF l_debug THEN
1713: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1714: 'Private API: Validation end');
1715: END IF;
1716:
1717: