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

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

424: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_Old_Line_rec';
425: BEGIN
426: -- Debug Message
427: IF l_debug THEN
428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
429: 'Private API: ' || l_api_name || ' start');
430:
431: END IF;
432:

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

466: FETCH C_Category_Item_Exists into l_val;
467: IF C_Category_Item_Exists%NOTFOUND
468: THEN
469: IF l_debug THEN
470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
471: 'Private API: Inventory item doesnot match category');
472: END IF;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

492: ( p_organization_id is NULL or
493: p_organization_id = FND_API.G_MISS_NUM )
494: THEN
495: IF l_debug THEN
496: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
497: 'Private API: ORGANIZATION_ID is missing');
498:
499: END IF;
500:

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

514: FETCH C_Inventory_Item_Exists into l_val;
515: IF C_Inventory_Item_Exists%NOTFOUND
516: THEN
517: IF l_debug THEN
518: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
519: 'Private API: INVENTORY_ITEM_ID is invalid');
520: END IF;
521:
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

533: END IF;
534:
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: ' || l_api_name || ' end');
539:
540: END IF;
541:

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

607: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
608: ELSE
609: CLOSE C_GET_CATEGORY_FROM_ITEM;
610: IF l_debug THEN
611: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
612: 'Private API: Unable to derive product category from item');
613: END IF;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
615: THEN

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

628: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
629: ELSE
630: CLOSE C_GET_CATEGORY_FROM_SIC;
631: IF l_debug THEN
632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
633: 'Private API: Unable to derive product category from secondary interest code');
634: END IF;
635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN

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

649: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
650: ELSE
651: CLOSE C_GET_CATEGORY_FROM_PIC;
652: IF l_debug THEN
653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
654: 'Private API: Unable to derive product category from primary interest code');
655: END IF;
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN

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

670: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
671: ELSE
672: CLOSE C_GET_CATEGORY_FROM_IT;
673: IF l_debug THEN
674: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
675: 'Private API: Unable to derive product category from interest type');
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN

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

817:
818:
819: -- Debug Message
820: IF l_debug THEN
821: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
822: 'Private API: ' || l_api_name || ' start');
823: END IF;
824:
825:

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

877: ,x_sales_member_rec => l_identity_sales_member_rec);
878:
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
882: 'Private API: Get_CurrentUser fail');
883: END IF;
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;

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

887: -- fix for the bug 2776714. Give a meaningful error message when defualt
888: --forecast credit type is null
889: IF l_forecast_credit_type_id IS NULL THEN
890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
893: END IF;
894:
895: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

927: ,x_update_access_flag => l_update_access_flag );
928:
929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
931: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
932: 'Private API: has_updateOpportunityAccess fail');
933: END IF;
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;

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

942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE
945: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
946: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
947: 'Private API: has_updateOpportunityAccess succeed');
948: END IF;
949: END IF;
950: END IF;

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

957: IF l_freeze_flag = 'Y'
958: THEN
959: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
960: IF l_allow_flag <> 'Y' THEN
961: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
962: 'API_OPP_FROZEN');
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965: END IF;

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

976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN
980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
981: 'Processing AS_LEAD_LINE row number '||l_curr_row );
982: END IF;
983:
984: END IF;

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

986: l_line_rec := P_Line_Tbl(l_curr_row);
987:
988: -- Debug message
989: IF l_debug THEN
990: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
991: 'Private API: Validate_opp_line');
992: END IF;
993:
994: -- Default organization from profile ASO_PRODUCT_ORGANIZATION_ID if

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

1074: Derive_PRODUCT_CATEGORY(p_Line_Rec => l_Line_Rec, p_Return_Status => x_return_status);
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: -- Debug message
1077: IF l_debug THEN
1078: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1079: 'Private API: Derive_PRODUCT_CATEGORY fail');
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;

Line 1090: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

1086:
1087: Validate_opp_line(
1088: p_init_msg_list => FND_API.G_FALSE,
1089: p_validation_level => p_validation_level,
1090: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1091: P_Line_Rec => l_Line_Rec,
1092: x_return_status => x_return_status,
1093: x_msg_count => x_msg_count,
1094: x_msg_data => x_msg_data);

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

1095:
1096: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1097: -- Debug message
1098: IF l_debug THEN
1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1100: 'Private API: Validate_opp_line fail');
1101: END IF;
1102:
1103: RAISE FND_API.G_EXC_ERROR;

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

1105:
1106:
1107: -- Debug Message
1108: IF l_debug THEN
1109: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1110: 'Private API: Calling create table handler');
1111: END IF;
1112:
1113: l_LEAD_LINE_ID := l_Line_rec.LEAD_LINE_ID;

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

1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177:
1178: IF l_debug THEN
1179: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1180: 'Private API1: Created line_id: '||l_LEAD_LINE_ID );
1181: END IF;
1182:
1183:

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

1203: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;
1204: l_sales_credit_rec.person_id := l_identity_sales_member_rec.employee_person_id;
1205:
1206: IF l_debug THEN
1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1205:
1206: IF l_debug THEN
1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1212: 'partner_contact_id' ||l_identity_sales_member_rec.partner_contact_id );
1213: END IF;

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

1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1212: 'partner_contact_id' ||l_identity_sales_member_rec.partner_contact_id );
1213: END IF;
1214:
1215: l_sales_credit_rec.salesgroup_id := p_salesgroup_id;

Line 1232: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

1228:
1229: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
1230: AS_OPP_sales_credit_PVT.Validate_SALES_CREDIT_Rec(
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1233: P_SALES_CREDIT_Rec => l_sales_credit_Rec,
1234: x_return_status => x_return_status,
1235: x_msg_count => x_msg_count,
1236: x_msg_data => x_msg_data);

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

1236: x_msg_data => x_msg_data);
1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: IF l_debug THEN
1240: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1241: 'Private API2: Create_Opp_line: validate_sc_rec fail' );
1242: END IF;
1243:
1244: raise FND_API.G_EXC_ERROR;

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

1265: -- Check return status from the above procedure call
1266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1267: THEN
1268: IF l_debug THEN
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Private API3: Create_Opp_line: Create_Sales_credit fail' );
1271: END IF;
1272: raise FND_API.G_EXC_ERROR;
1273: END IF;

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

1307: -- Check return status from the above procedure call
1308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1309: THEN
1310: IF l_debug THEN
1311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1312: 'Private API3: Create_Opp_line: Create_Sales_credit fail' );
1313: END IF;
1314: raise FND_API.G_EXC_ERROR;
1315: END IF;

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

1315: END IF;
1316:
1317: ELSE
1318: IF l_debug THEN
1319: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1320: 'Private API: l_isd_sales_group_id is invalid ' );
1321: END IF;
1322: END IF;
1323: END IF;

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

1336: x_return_status => x_return_status);
1337:
1338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1339: IF l_debug THEN
1340: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1341: 'Private API: Create_Opp_line: Backupdate_header fail' );
1342: END IF;
1343: raise FND_API.G_EXC_ERROR;
1344: END IF;

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

1346: -- Assign/Reassign the territory resources for the opportunity
1347:
1348: -- Debug Message
1349: IF l_debug THEN
1350: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Calling Opportunity Real Time API');
1352: END IF;
1353:
1354: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

1362: );
1363:
1364: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1365: IF l_debug THEN
1366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Opportunity Real Time API fail');
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;

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

1381:
1382:
1383: -- Debug Message
1384: IF l_debug THEN
1385: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1386: 'Private API: ' || l_api_name || ' end');
1387: END IF;
1388:
1389:

Line 1418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1414: */
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1419: P_MODULE => l_module
1420: ,P_API_NAME => L_API_NAME
1421: ,P_PKG_NAME => G_PKG_NAME
1422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1419: P_MODULE => l_module
1420: ,P_API_NAME => L_API_NAME
1421: ,P_PKG_NAME => G_PKG_NAME
1422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1424: ,X_MSG_COUNT => X_MSG_COUNT
1425: ,X_MSG_DATA => X_MSG_DATA
1426: ,X_RETURN_STATUS => X_RETURN_STATUS);
1427:

Line 1429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1425: ,X_MSG_DATA => X_MSG_DATA
1426: ,X_RETURN_STATUS => X_RETURN_STATUS);
1427:
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1430: P_MODULE => l_module
1431: ,P_API_NAME => L_API_NAME
1432: ,P_PKG_NAME => G_PKG_NAME
1433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1434: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1430: P_MODULE => l_module
1431: ,P_API_NAME => L_API_NAME
1432: ,P_PKG_NAME => G_PKG_NAME
1433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1434: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1435: ,X_MSG_COUNT => X_MSG_COUNT
1436: ,X_MSG_DATA => X_MSG_DATA
1437: ,X_RETURN_STATUS => X_RETURN_STATUS);
1438:

Line 1440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1436: ,X_MSG_DATA => X_MSG_DATA
1437: ,X_RETURN_STATUS => X_RETURN_STATUS);
1438:
1439: WHEN OTHERS THEN
1440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1441: P_MODULE => l_module
1442: ,P_API_NAME => L_API_NAME
1443: ,P_PKG_NAME => G_PKG_NAME
1444: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1444: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1441: P_MODULE => l_module
1442: ,P_API_NAME => L_API_NAME
1443: ,P_PKG_NAME => G_PKG_NAME
1444: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1446: ,X_MSG_COUNT => X_MSG_COUNT
1447: ,X_MSG_DATA => X_MSG_DATA
1448: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1441: P_MODULE => l_module
1442: ,P_API_NAME => L_API_NAME
1443: ,P_PKG_NAME => G_PKG_NAME
1444: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1446: ,X_MSG_COUNT => X_MSG_COUNT
1447: ,X_MSG_DATA => X_MSG_DATA
1448: ,X_RETURN_STATUS => X_RETURN_STATUS);
1449: End Create_opp_lines;

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

1530:
1531:
1532: -- Debug Message
1533: IF l_debug THEN
1534: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1535: 'Private API: ' || l_api_name || ' start');
1536: END IF;
1537:
1538:

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

1575: ,x_sales_member_rec => l_identity_sales_member_rec);
1576:
1577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1580: 'Private API: Get_CurrentUser fail');
1581: END IF;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: END IF;

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

1606: ,x_update_access_flag => l_update_access_flag );
1607:
1608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1610: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'has_updateOpportunityAccess fail');
1612: END IF;
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;

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

1631: IF l_freeze_flag = 'Y'
1632: THEN
1633: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1634: IF l_allow_flag <> 'Y' THEN
1635: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1636: 'API_OPP_FROZEN');
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;
1639: END IF;

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

1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN
1654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1655: 'Processing AS_LEAD_LINE row number '||l_curr_row );
1656: END IF;
1657:
1658: END IF;

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

1661:
1662:
1663: -- Debug Message
1664: IF l_debug THEN
1665: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1666: 'Private API: - Open Cursor to Select');
1667: END IF;
1668:
1669: Open C_Get_opp_line( l_Line_rec.LEAD_LINE_ID);

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

1680: raise FND_API.G_EXC_ERROR;
1681: END IF;
1682: -- Debug Message
1683: IF l_debug THEN
1684: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1685: 'Private API: - Close Cursor');
1686: END IF;
1687:
1688: Close C_Get_opp_line;

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

1710: End if;
1711:
1712: -- Debug message
1713: IF l_debug THEN
1714: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1715: 'Private API: Validate_competitor');
1716: END IF;
1717:
1718: -- Invoke validation procedures

Line 1722: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

1718: -- Invoke validation procedures
1719: Validate_opp_line(
1720: p_init_msg_list => FND_API.G_FALSE,
1721: p_validation_level => p_validation_level,
1722: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
1723: P_Line_Rec => l_Line_Rec,
1724: x_return_status => x_return_status,
1725: x_msg_count => x_msg_count,
1726: x_msg_data => x_msg_data);

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

1727:
1728: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1729: -- Debug message
1730: IF l_debug THEN
1731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1732: 'Private API: Validate_opp_line fail');
1733: END IF;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;

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

1766:
1767:
1768: -- Debug Message
1769: IF l_debug THEN
1770: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1771: 'Private API: Calling update table handler');
1772: END IF;
1773:
1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)

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

1863: -- Assign/Reassign the territory resources for the opportunity
1864:
1865: -- Debug Message
1866: IF l_debug THEN
1867: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1868: 'Calling Opportunity Real Time API');
1869: END IF;
1870:
1871: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

1879: );
1880:
1881: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1882: IF l_debug THEN
1883: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1884: 'Opportunity Real Time API fail');
1885: END IF;
1886:
1887: RAISE FND_API.G_EXC_ERROR;

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

1899:
1900:
1901: -- Debug Message
1902: IF l_debug THEN
1903: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1904: 'Private API: ' || l_api_name || ' end');
1905: END IF;
1906:
1907:

Line 1936: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1932: END IF;
1933: */
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_ERROR THEN
1936: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1937: P_MODULE => l_module
1938: ,P_API_NAME => L_API_NAME
1939: ,P_PKG_NAME => G_PKG_NAME
1940: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1941: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1937: P_MODULE => l_module
1938: ,P_API_NAME => L_API_NAME
1939: ,P_PKG_NAME => G_PKG_NAME
1940: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1941: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1942: ,X_MSG_COUNT => X_MSG_COUNT
1943: ,X_MSG_DATA => X_MSG_DATA
1944: ,X_RETURN_STATUS => X_RETURN_STATUS);
1945:

Line 1947: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1943: ,X_MSG_DATA => X_MSG_DATA
1944: ,X_RETURN_STATUS => X_RETURN_STATUS);
1945:
1946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1947: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1948: P_MODULE => l_module
1949: ,P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1952: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1948: P_MODULE => l_module
1949: ,P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1952: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1953: ,X_MSG_COUNT => X_MSG_COUNT
1954: ,X_MSG_DATA => X_MSG_DATA
1955: ,X_RETURN_STATUS => X_RETURN_STATUS);
1956:

Line 1958: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1954: ,X_MSG_DATA => X_MSG_DATA
1955: ,X_RETURN_STATUS => X_RETURN_STATUS);
1956:
1957: WHEN OTHERS THEN
1958: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1959: P_MODULE => l_module
1960: ,P_API_NAME => L_API_NAME
1961: ,P_PKG_NAME => G_PKG_NAME
1962: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1962: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1958: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1959: P_MODULE => l_module
1960: ,P_API_NAME => L_API_NAME
1961: ,P_PKG_NAME => G_PKG_NAME
1962: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1963: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1964: ,X_MSG_COUNT => X_MSG_COUNT
1965: ,X_MSG_DATA => X_MSG_DATA
1966: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1963: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1959: P_MODULE => l_module
1960: ,P_API_NAME => L_API_NAME
1961: ,P_PKG_NAME => G_PKG_NAME
1962: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1963: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1964: ,X_MSG_COUNT => X_MSG_COUNT
1965: ,X_MSG_DATA => X_MSG_DATA
1966: ,X_RETURN_STATUS => X_RETURN_STATUS);
1967: End Update_opp_lines;

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

2052:
2053:
2054: -- Debug Message
2055: IF l_debug THEN
2056: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2057: 'Private API: ' || l_api_name || ' start');
2058: END IF;
2059:
2060:

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

2097: ,x_sales_member_rec => l_identity_sales_member_rec);
2098:
2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2101: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2102: 'Private API: Get_CurrentUser fail');
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: END IF;

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

2127: ,x_update_access_flag => l_update_access_flag );
2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2131: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2132: 'has_updateOpportunityAccess fail');
2133: END IF;
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;

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

2152: IF l_freeze_flag = 'Y'
2153: THEN
2154: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
2155: IF l_allow_flag <> 'Y' THEN
2156: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2157: 'API_OPP_FROZEN');
2158: RAISE FND_API.G_EXC_ERROR;
2159: END IF;
2160: END IF;

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

2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN
2176: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2177: 'Processing AS_LEAD_LINE row number '||l_curr_row );
2178: END IF;
2179:
2180: END IF;

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

2182: l_line_rec := P_Line_Tbl(l_curr_row);
2183:
2184: -- Debug Message
2185: IF l_debug THEN
2186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2187: 'Private API: Calling delete table handler');
2188: END IF;
2189:
2190: -- Invoke table handler(AS_LEAD_LINES_PKG.Delete_Row)

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

2229: -- Assign/Reassign the territory resources for the opportunity
2230:
2231: -- Debug Message
2232: IF l_debug THEN
2233: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2234: 'Calling Opportunity Real Time API');
2235: END IF;
2236:
2237: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

2245: );
2246:
2247: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2248: IF l_debug THEN
2249: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2250: 'Opportunity Real Time API fail');
2251: END IF;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;

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

2264:
2265:
2266: -- Debug Message
2267: IF l_debug THEN
2268: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2269: 'Private API: ' || l_api_name || ' end');
2270: END IF;
2271:
2272:

Line 2300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2296: END IF;
2297: */
2298: EXCEPTION
2299: WHEN FND_API.G_EXC_ERROR THEN
2300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2301: P_MODULE => l_module
2302: ,P_API_NAME => L_API_NAME
2303: ,P_PKG_NAME => G_PKG_NAME
2304: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2305: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2301: P_MODULE => l_module
2302: ,P_API_NAME => L_API_NAME
2303: ,P_PKG_NAME => G_PKG_NAME
2304: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2305: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2306: ,X_MSG_COUNT => X_MSG_COUNT
2307: ,X_MSG_DATA => X_MSG_DATA
2308: ,X_RETURN_STATUS => X_RETURN_STATUS);
2309:

Line 2311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2307: ,X_MSG_DATA => X_MSG_DATA
2308: ,X_RETURN_STATUS => X_RETURN_STATUS);
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2312: P_MODULE => l_module
2313: ,P_API_NAME => L_API_NAME
2314: ,P_PKG_NAME => G_PKG_NAME
2315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2312: P_MODULE => l_module
2313: ,P_API_NAME => L_API_NAME
2314: ,P_PKG_NAME => G_PKG_NAME
2315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2317: ,X_MSG_COUNT => X_MSG_COUNT
2318: ,X_MSG_DATA => X_MSG_DATA
2319: ,X_RETURN_STATUS => X_RETURN_STATUS);
2320:

Line 2322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2318: ,X_MSG_DATA => X_MSG_DATA
2319: ,X_RETURN_STATUS => X_RETURN_STATUS);
2320:
2321: WHEN OTHERS THEN
2322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2323: P_MODULE => l_module
2324: ,P_API_NAME => L_API_NAME
2325: ,P_PKG_NAME => G_PKG_NAME
2326: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2326: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2323: P_MODULE => l_module
2324: ,P_API_NAME => L_API_NAME
2325: ,P_PKG_NAME => G_PKG_NAME
2326: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2328: ,X_MSG_COUNT => X_MSG_COUNT
2329: ,X_MSG_DATA => X_MSG_DATA
2330: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2323: P_MODULE => l_module
2324: ,P_API_NAME => L_API_NAME
2325: ,P_PKG_NAME => G_PKG_NAME
2326: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2328: ,X_MSG_COUNT => X_MSG_COUNT
2329: ,X_MSG_DATA => X_MSG_DATA
2330: ,X_RETURN_STATUS => X_RETURN_STATUS);
2331: End Delete_opp_lines;

Line 2369: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

2365: x_return_status := FND_API.G_RET_STS_SUCCESS;
2366:
2367:
2368: -- Calling from Create API
2369: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
2370: THEN
2371: IF (p_LEAD_LINE_ID is NOT NULL) and (p_LEAD_LINE_ID <> FND_API.G_MISS_NUM)
2372: THEN
2373: OPEN C_Lead_Line_Id_Exists (p_Lead_Line_Id);

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

2373: OPEN C_Lead_Line_Id_Exists (p_Lead_Line_Id);
2374: FETCH C_Lead_Line_Id_Exists into l_val;
2375: IF C_Lead_Line_Id_Exists%FOUND THEN
2376: IF l_debug THEN
2377: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2378: 'Private API: LEAD_LINE_ID exist');
2379: END IF;
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: END IF;

Line 2386: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

2382: CLOSE C_Lead_Line_Id_Exists;
2383: END IF;
2384:
2385: -- Calling from Update API
2386: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2387: THEN
2388: -- validate NOT NULL column
2389: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
2390: THEN

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

2388: -- validate NOT NULL column
2389: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
2390: THEN
2391: IF l_debug THEN
2392: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2393: 'Private API: Violate NOT NULL constraint(LEAD_LINE_ID)');
2394: END IF;
2395: x_return_status := FND_API.G_RET_STS_ERROR;
2396: ELSE

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

2398: FETCH C_Lead_Line_Id_Exists into l_val;
2399: IF C_Lead_Line_Id_Exists%NOTFOUND
2400: THEN
2401: IF l_debug THEN
2402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2403: 'Private API: LEAD_LINE_ID is not valid');
2404: END IF;
2405: x_return_status := FND_API.G_RET_STS_ERROR;
2406: END IF;

Line 2443: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

2439:
2440: -- Initialize API return status to SUCCESS
2441: x_return_status := FND_API.G_RET_STS_SUCCESS;
2442:
2443: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
2444: THEN
2445: -- Hint: Validate data
2446: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
2447: -- verify if data is valid

Line 2450: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

2446: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
2447: -- verify if data is valid
2448: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2449: NULL;
2450: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2451: THEN
2452: -- Hint: Validate data
2453: -- IF p_REQUEST_ID <> G_MISS_CHAR
2454: -- verify if data is valid

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

2500:
2501: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
2502: THEN
2503: IF l_debug THEN
2504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2505: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
2506: END IF;
2507: x_return_status := FND_API.G_RET_STS_ERROR;
2508: ELSE

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

2510: FETCH C_Lead_Id_Exists into l_val;
2511: IF C_Lead_Id_Exists%NOTFOUND
2512: THEN
2513: IF l_debug THEN
2514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2515: 'Private API: LEAD_ID is not valid');
2516: END IF;
2517: x_return_status := FND_API.G_RET_STS_ERROR;
2518: END IF;

Line 2569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2565: OPEN C_INTEREST_TYPE_ID_Exists (p_INTEREST_TYPE_ID);
2566: FETCH C_INTEREST_TYPE_ID_Exists into l_val;
2567: IF C_INTEREST_TYPE_ID_Exists%NOTFOUND THEN
2568: IF l_debug THEN
2569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2570: 'Private API: INTEREST_TYPE_ID is invalid');
2571: END IF;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: END IF;

Line 2624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2620: OPEN C_P_INTEREST_CODE_ID_Exists (p_PRIMARY_INTEREST_CODE_ID);
2621: FETCH C_P_INTEREST_CODE_ID_Exists into l_val;
2622: IF C_P_INTEREST_CODE_ID_Exists%NOTFOUND THEN
2623: IF l_debug THEN
2624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2625: 'Private API: PRIMARY_INTEREST_CODE_ID is invalid');
2626: END IF;
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: END IF;

Line 2680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2676: FETCH C_S_INTEREST_CODE_ID_Exists into l_val;
2677: IF C_S_INTEREST_CODE_ID_Exists%NOTFOUND THEN
2678:
2679: IF l_debug THEN
2680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2681: 'Private API: SECONDARY_INTEREST_CODE_ID is invalid');
2682: END IF;
2683:
2684: x_return_status := FND_API.G_RET_STS_ERROR;

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

2732: -- Initialize API return status to SUCCESS
2733: l_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: IF l_debug THEN
2736: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2737: 'Private API: Validating product category '|| P_CATEGORY_SET_ID ||'+'||P_CATEGORY_ID);
2738: END IF;
2739:
2740:

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

2914: FETCH C_INVENTORY_ITEM_ID_Exists into l_val;
2915: IF C_INVENTORY_ITEM_ID_Exists%NOTFOUND THEN
2916:
2917: IF l_debug THEN
2918: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2919: 'Private API: INVENTORY_ITEM_ID is invalid');
2920: END IF;
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922: END IF;

Line 2957: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

2953:
2954: -- Initialize API return status to SUCCESS
2955: x_return_status := FND_API.G_RET_STS_SUCCESS;
2956:
2957: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
2958: THEN
2959: -- Hint: Validate data
2960: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID<>G_MISS_CHAR
2961: -- verify if data is valid

Line 2964: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

2960: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID<>G_MISS_CHAR
2961: -- verify if data is valid
2962: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2963: NULL;
2964: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2965: THEN
2966: -- Hint: Validate data
2967: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
2968: -- verify if data is valid

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

3016: OPEN C_UOM_CODE_Exists (p_UOM_CODE);
3017: FETCH C_UOM_CODE_Exists into l_val;
3018: IF C_UOM_CODE_Exists%NOTFOUND THEN
3019: IF l_debug THEN
3020: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3021: 'Private API: UOM_CODE is invalid');
3022: END IF;
3023:
3024: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3060: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

3056:
3057: -- Initialize API return status to SUCCESS
3058: x_return_status := FND_API.G_RET_STS_SUCCESS;
3059:
3060: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
3061: THEN
3062: -- Hint: Validate data
3063: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
3064: -- verify if data is valid

Line 3067: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

3063: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
3064: -- verify if data is valid
3065: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3066: NULL;
3067: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
3068: THEN
3069: -- Hint: Validate data
3070: -- IF p_QUANTITY <> G_MISS_CHAR
3071: -- verify if data is valid

Line 3107: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

3103:
3104: -- Initialize API return status to SUCCESS
3105: x_return_status := FND_API.G_RET_STS_SUCCESS;
3106:
3107: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
3108: THEN
3109: -- Hint: Validate data
3110: -- IF p_TOTAL_AMOUNT is not NULL and p_TOTAL_AMOUNT <> G_MISS_CHAR
3111: -- verify if data is valid

Line 3114: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

3110: -- IF p_TOTAL_AMOUNT is not NULL and p_TOTAL_AMOUNT <> G_MISS_CHAR
3111: -- verify if data is valid
3112: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3113: NULL;
3114: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
3115: THEN
3116: -- Hint: Validate data
3117: -- IF p_TOTAL_AMOUNT <> G_MISS_CHAR
3118: -- verify if data is valid

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

3161: IF (UPPER(p_QUOTED_LINE_FLAG) <> 'Y') and
3162: (UPPER(p_QUOTED_LINE_FLAG) <> 'N')
3163: THEN
3164: IF l_debug THEN
3165: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3166: 'Private API: QUOTED_LINE_FLAG is invalid');
3167: END IF;
3168:
3169: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3204: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

3200:
3201: -- Initialize API return status to SUCCESS
3202: x_return_status := FND_API.G_RET_STS_SUCCESS;
3203:
3204: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
3205: THEN
3206: -- Hint: Validate data
3207: -- IF p_PRICE is not NULL and p_PRICE <> G_MISS_CHAR
3208: -- verify if data is valid

Line 3211: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

3207: -- IF p_PRICE is not NULL and p_PRICE <> G_MISS_CHAR
3208: -- verify if data is valid
3209: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3210: NULL;
3211: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
3212: THEN
3213: -- Hint: Validate data
3214: -- IF p_PRICE <> G_MISS_CHAR
3215: -- verify if data is valid

Line 3251: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

3247:
3248: -- Initialize API return status to SUCCESS
3249: x_return_status := FND_API.G_RET_STS_SUCCESS;
3250:
3251: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
3252: THEN
3253: -- Hint: Validate data
3254: -- IF p_PRICE_VOLUME_MARGIN is not NULL and p_PRICE_VOLUME_MARGIN <>
3255: -- G_MISS_CHAR, verify if data is valid

Line 3258: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

3254: -- IF p_PRICE_VOLUME_MARGIN is not NULL and p_PRICE_VOLUME_MARGIN <>
3255: -- G_MISS_CHAR, verify if data is valid
3256: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3257: NULL;
3258: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
3259: THEN
3260: -- Hint: Validate data
3261: -- IF p_PRICE_VOLUME_MARGIN <> G_MISS_CHAR
3262: -- verify if data is valid

Line 3298: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

3294:
3295: -- Initialize API return status to SUCCESS
3296: x_return_status := FND_API.G_RET_STS_SUCCESS;
3297:
3298: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
3299: THEN
3300: -- Hint: Validate data
3301: -- IF p_SHIP_DATE is not NULL and p_SHIP_DATE <> G_MISS_CHAR
3302: -- verify if data is valid

Line 3305: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

3301: -- IF p_SHIP_DATE is not NULL and p_SHIP_DATE <> G_MISS_CHAR
3302: -- verify if data is valid
3303: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3304: NULL;
3305: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
3306: THEN
3307: -- Hint: Validate data
3308: -- IF p_SHIP_DATE <> G_MISS_CHAR
3309: -- verify if data is valid

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

3358: OPEN C_O_OPPORTUNITY_LINE_ID_Exists (p_O_OPPORTUNITY_LINE_ID);
3359: FETCH C_O_OPPORTUNITY_LINE_ID_Exists into l_val;
3360: IF C_O_OPPORTUNITY_LINE_ID_Exists%NOTFOUND THEN
3361: IF l_debug THEN
3362: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3363: 'Private API: O_OPPORTUNITY_LINE_ID is invalid');
3364: END IF;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3366: END IF;

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

3426: -- SOURCE_PROMOTION_ID should exist in ams_source_codes
3427: OPEN C_SOURCE_PROMOTION_ID_Exists (p_SOURCE_PROMOTION_ID);
3428: FETCH C_SOURCE_PROMOTION_ID_Exists into l_val;
3429: IF C_SOURCE_PROMOTION_ID_Exists%NOTFOUND THEN
3430: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
3431: -- 'Private API: SOURCE_PROMOTION_ID is invalid');
3432:
3433: AS_UTILITY_PVT.Set_Message(
3434: p_module => l_module,

Line 3433: AS_UTILITY_PVT.Set_Message(

3429: IF C_SOURCE_PROMOTION_ID_Exists%NOTFOUND THEN
3430: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
3431: -- 'Private API: SOURCE_PROMOTION_ID is invalid');
3432:
3433: AS_UTILITY_PVT.Set_Message(
3434: p_module => l_module,
3435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3436: p_msg_name => 'API_INVALID_SOURCE_PROM_ID',
3437: p_token1 => 'VALUE',

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

3502: OPEN C_OFFER_ID_Exists (p_OFFER_ID);
3503: FETCH C_OFFER_ID_Exists into l_val;
3504: IF C_OFFER_ID_Exists%NOTFOUND THEN
3505: IF l_debug THEN
3506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3507: 'Private API: OFFER_ID is invalid');
3508: END IF;
3509: x_return_status := FND_API.G_RET_STS_ERROR;
3510: END IF;

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

3520: END Validate_OFFER_ID;
3521:
3522:
3523: -- Hint: inter-field level validation can be added here.
3524: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use
3525: -- cursor to get old values for all fields used in inter-field validation
3526: -- and set all G_MISS_XXX fields to original value stored in database
3527: -- table.
3528: PROCEDURE Validate_Line_rec(

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

3580: END IF;
3581:
3582: -- Debug Message
3583: IF l_debug THEN
3584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3585: 'Private API: ' || l_api_name || ' start');
3586:
3587: END IF;
3588:

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

3596: ( p_line_rec.organization_id is NULL or
3597: p_line_rec.organization_id = FND_API.G_MISS_NUM )
3598: THEN
3599: IF l_debug THEN
3600: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3601: 'Private API: ORGANIZATION_ID is missing');
3602:
3603: END IF;
3604:

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

3619: FETCH C_Inventory_Item_Exists into l_val;
3620: IF C_Inventory_Item_Exists%NOTFOUND
3621: THEN
3622: IF l_debug THEN
3623: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3624: 'Private API: INVENTORY_ITEM_ID is invalid');
3625: END IF;
3626:
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

3647: FETCH C_Category_Item_Exists into l_val;
3648: IF C_Category_Item_Exists%NOTFOUND
3649: THEN
3650: IF l_debug THEN
3651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3652: 'Private API: Inventory item doesnot match category');
3653: END IF;
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

3664: END IF;
3665:
3666: -- Debug Message
3667: IF l_debug THEN
3668: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3669: 'Private API: ' || l_api_name || ' end');
3670:
3671: END IF;
3672:

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

3697: BEGIN
3698:
3699: -- Debug Message
3700: IF l_debug THEN
3701: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3702: 'Private API: ' || l_api_name || ' start');
3703: END IF;
3704:
3705:

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

3714: ( p_line_rec.organization_id is NULL or
3715: p_line_rec.organization_id = FND_API.G_MISS_NUM )
3716: THEN
3717: IF l_debug THEN
3718: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3719: 'Private API: ORGANIZATION_ID is missing');
3720:
3721: END IF;
3722:

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

3734: -- Hint: We provide validation procedure for every column. Developer
3735: -- should delete unnecessary validation procedures.
3736:
3737: IF l_debug THEN
3738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3739: 'Private API: Validate Items start');
3740: END IF;
3741:
3742: Validate_LEAD_LINE_ID(

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

3750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3751: raise FND_API.G_EXC_ERROR;
3752: END IF;
3753: IF l_debug THEN
3754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3755: 'Private API: Validated LEAD_LINE_ID');
3756: END IF;
3757:
3758: Validate_LEAD_ID(

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

3766: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3767: raise FND_API.G_EXC_ERROR;
3768: END IF;
3769: IF l_debug THEN
3770: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3771: 'Private API: Validated LEAD_ID');
3772: END IF;
3773:
3774:

Line 3788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3785: raise FND_API.G_EXC_ERROR;
3786: END IF;
3787: IF l_debug THEN
3788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3789: 'Private API: Validated INTEREST_TYPE_ID');
3790: END IF;
3791: */
3792:

Line 3806: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3803: raise FND_API.G_EXC_ERROR;
3804: END IF;
3805: IF l_debug THEN
3806: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3807: 'Private API: Validated P_INTEREST_CODE_ID');
3808: END IF;
3809: */
3810:

Line 3825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3821: raise FND_API.G_EXC_ERROR;
3822: END IF;
3823:
3824: IF l_debug THEN
3825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3826: 'Private API: Validated S_INTEREST_CODE_ID');
3827: END IF;
3828: */
3829: Validate_PRODUCT_CATEGORY(

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

3840: raise FND_API.G_EXC_ERROR;
3841: END IF;
3842:
3843: IF l_debug THEN
3844: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3845: 'Private API: Validated PRODUCT_CATEGORY_ID');
3846: END IF;
3847:
3848:

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

3884: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3885: raise FND_API.G_EXC_ERROR;
3886: END IF;
3887: IF l_debug THEN
3888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3889: 'Private API: Validated UOM_CODE');
3890: END IF;
3891:
3892:

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

3929: raise FND_API.G_EXC_ERROR;
3930: END IF;
3931:
3932: IF l_debug THEN
3933: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3934: 'Private API: Validated QUOTED_LINE_FLAG');
3935: END IF;
3936:
3937:

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

3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986: raise FND_API.G_EXC_ERROR;
3987: END IF;
3988: IF l_debug THEN
3989: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3990: 'Private API: Validated SOURCE_PROMOTION_ID');
3991: END IF;
3992:
3993:

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

4004: raise FND_API.G_EXC_ERROR;
4005: END IF;
4006:
4007: IF l_debug THEN
4008: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4009: 'Private API: Validated OFFER_ID');
4010: END IF;
4011:
4012:

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

4011:
4012:
4013:
4014: IF l_debug THEN
4015: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4016: 'Private API: Validate Items end');
4017: END IF;
4018:
4019: END IF;

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

4048:
4049:
4050: -- Debug Message
4051: IF l_debug THEN
4052: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4053: 'Private API: ' || l_api_name || ' end');
4054: END IF;
4055:
4056: END Validate_opp_line;