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.ASN_MIG_SALES_CREDITS_PVT dependencies on FND_API

Line 771: p_init_msg_list => FND_API.G_TRUE,

767: l_lead_workflow_rec.latest_routing_flag := 'Y';
768:
769: PV_ASSIGN_UTIL_PVT.Create_lead_workflow_row (
770: p_api_version_number => 1.0,
771: p_init_msg_list => FND_API.G_TRUE,
772: p_commit => FND_API.G_FALSE,
773: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
774: p_workflow_rec => l_lead_workflow_rec,
775: x_ItemKey => l_itemkey,

Line 772: p_commit => FND_API.G_FALSE,

768:
769: PV_ASSIGN_UTIL_PVT.Create_lead_workflow_row (
770: p_api_version_number => 1.0,
771: p_init_msg_list => FND_API.G_TRUE,
772: p_commit => FND_API.G_FALSE,
773: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
774: p_workflow_rec => l_lead_workflow_rec,
775: x_ItemKey => l_itemkey,
776: x_return_status => l_return_status,

Line 773: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

769: PV_ASSIGN_UTIL_PVT.Create_lead_workflow_row (
770: p_api_version_number => 1.0,
771: p_init_msg_list => FND_API.G_TRUE,
772: p_commit => FND_API.G_FALSE,
773: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
774: p_workflow_rec => l_lead_workflow_rec,
775: x_ItemKey => l_itemkey,
776: x_return_status => l_return_status,
777: x_msg_count => l_msg_count,

Line 780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

776: x_return_status => l_return_status,
777: x_msg_count => l_msg_count,
778: x_msg_data => l_msg_data);
779:
780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
781: RAISE FND_API.G_EXC_ERROR;
782: end if;
783:
784: IF (p_debug_flag = 'Y' AND

Line 781: RAISE FND_API.G_EXC_ERROR;

777: x_msg_count => l_msg_count,
778: x_msg_data => l_msg_data);
779:
780: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
781: RAISE FND_API.G_EXC_ERROR;
782: end if;
783:
784: IF (p_debug_flag = 'Y' AND
785: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 809: p_init_msg_list => FND_API.G_FALSE,

805: l_assignment_rec.wf_item_key := l_itemKey;
806:
807: pv_assign_util_pvt.Create_lead_assignment_row (
808: p_api_version_number => 1.0,
809: p_init_msg_list => FND_API.G_FALSE,
810: p_commit => FND_API.G_FALSE,
811: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
812: p_assignment_rec => l_assignment_rec,
813: x_lead_assignment_id => l_assignment_id,

Line 810: p_commit => FND_API.G_FALSE,

806:
807: pv_assign_util_pvt.Create_lead_assignment_row (
808: p_api_version_number => 1.0,
809: p_init_msg_list => FND_API.G_FALSE,
810: p_commit => FND_API.G_FALSE,
811: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
812: p_assignment_rec => l_assignment_rec,
813: x_lead_assignment_id => l_assignment_id,
814: x_return_status => l_return_status,

Line 811: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

807: pv_assign_util_pvt.Create_lead_assignment_row (
808: p_api_version_number => 1.0,
809: p_init_msg_list => FND_API.G_FALSE,
810: p_commit => FND_API.G_FALSE,
811: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
812: p_assignment_rec => l_assignment_rec,
813: x_lead_assignment_id => l_assignment_id,
814: x_return_status => l_return_status,
815: x_msg_count => l_msg_count,

Line 818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

814: x_return_status => l_return_status,
815: x_msg_count => l_msg_count,
816: x_msg_data => l_msg_data);
817:
818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
822: IF (p_debug_flag = 'Y' AND

Line 819: RAISE FND_API.G_EXC_ERROR;

815: x_msg_count => l_msg_count,
816: x_msg_data => l_msg_data);
817:
818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
822: IF (p_debug_flag = 'Y' AND
823: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 843: ,p_init_msg_list => FND_API.G_FALSE

839: l_party_notify_rec.DECISION_MAKER_FLAG := c2.decision_maker_flag;
840:
841: pv_assign_util_pvt.create_party_notification(
842: p_api_version_number => 1.0
843: ,p_init_msg_list => FND_API.G_FALSE
844: ,p_commit => FND_API.G_FALSE
845: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
846: ,P_party_notify_Rec => l_party_notify_rec
847: ,x_party_notification_id => l_party_notification_id

Line 844: ,p_commit => FND_API.G_FALSE

840:
841: pv_assign_util_pvt.create_party_notification(
842: p_api_version_number => 1.0
843: ,p_init_msg_list => FND_API.G_FALSE
844: ,p_commit => FND_API.G_FALSE
845: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
846: ,P_party_notify_Rec => l_party_notify_rec
847: ,x_party_notification_id => l_party_notification_id
848: ,x_return_status => l_return_status

Line 845: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

841: pv_assign_util_pvt.create_party_notification(
842: p_api_version_number => 1.0
843: ,p_init_msg_list => FND_API.G_FALSE
844: ,p_commit => FND_API.G_FALSE
845: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
846: ,P_party_notify_Rec => l_party_notify_rec
847: ,x_party_notification_id => l_party_notification_id
848: ,x_return_status => l_return_status
849: ,x_msg_count => l_msg_count

Line 852: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

848: ,x_return_status => l_return_status
849: ,x_msg_count => l_msg_count
850: ,x_msg_data => l_msg_data);
851:
852: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF (p_debug_flag = 'Y' AND
856: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 853: RAISE FND_API.G_EXC_ERROR;

849: ,x_msg_count => l_msg_count
850: ,x_msg_data => l_msg_data);
851:
852: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF (p_debug_flag = 'Y' AND
856: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 929: x_return_status := FND_API.G_RET_STS_SUCCESS;

925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
926: 'Begin Update_sc_for_rep');
927: END IF;
928:
929: x_return_status := FND_API.G_RET_STS_SUCCESS;
930:
931: -- Update Sales Credits to only those which the rep
932: -- is getting.
933: l_sc_amount := 0;

Line 1003: p_init_msg_list => FND_API.G_FALSE,

999: l_sc_tbl(1).attribute15 := l_sc_select_rec.attribute15;
1000:
1001: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1002: p_api_version_number => 2.0,
1003: p_init_msg_list => FND_API.G_FALSE,
1004: p_commit => FND_API.G_FALSE,
1005: p_validation_level => 90,
1006: p_identity_salesforce_id => p_identity_sf_id,
1007: p_sales_credit_tbl => l_sc_tbl,

Line 1004: p_commit => FND_API.G_FALSE,

1000:
1001: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1002: p_api_version_number => 2.0,
1003: p_init_msg_list => FND_API.G_FALSE,
1004: p_commit => FND_API.G_FALSE,
1005: p_validation_level => 90,
1006: p_identity_salesforce_id => p_identity_sf_id,
1007: p_sales_credit_tbl => l_sc_tbl,
1008: p_check_access_flag => 'N',

Line 1086: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1082: END IF;
1083: END LOOP;
1084: CLOSE c_rep_quota_credits;
1085:
1086: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089:
1090: -- Update Lead Line Amounts

Line 1087: RAISE FND_API.G_EXC_ERROR;

1083: END LOOP;
1084: CLOSE c_rep_quota_credits;
1085:
1086: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089:
1090: -- Update Lead Line Amounts
1091: l_header_rec.lead_id := p_lead_id;

Line 1096: p_init_msg_list => FND_API.G_FALSE,

1092:
1093: IF l_ll_tbl_count > 0 THEN
1094: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1095: p_api_version_number => 2.0,
1096: p_init_msg_list => FND_API.G_FALSE,
1097: p_commit => FND_API.G_FALSE,
1098: p_validation_level => 90,
1099: p_identity_salesforce_id => p_identity_sf_id,
1100: p_line_tbl => l_ll_tbl,

Line 1097: p_commit => FND_API.G_FALSE,

1093: IF l_ll_tbl_count > 0 THEN
1094: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1095: p_api_version_number => 2.0,
1096: p_init_msg_list => FND_API.G_FALSE,
1097: p_commit => FND_API.G_FALSE,
1098: p_validation_level => 90,
1099: p_identity_salesforce_id => p_identity_sf_id,
1100: p_line_tbl => l_ll_tbl,
1101: p_header_rec => l_header_rec,

Line 1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1109: x_msg_data => x_msg_data
1110: );
1111: END IF;
1112:
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: IF (p_debug_flag = 'Y' AND

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: );
1111: END IF;
1112:
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: IF (p_debug_flag = 'Y' AND
1118: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1125: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1121: END IF;
1122:
1123: EXCEPTION
1124: WHEN OTHERS then
1125: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR;

1122:
1123: EXCEPTION
1124: WHEN OTHERS then
1125: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1130: 'In When others (Update_sc_for_rep). lead_id: '

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1194: 'Begin Update_sc_for_rep');
1195: END IF;
1196:
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: -- Update Sales Credits to only those which the rep
1200: -- is getting.
1201: l_sc_amount := 0;

Line 1271: p_init_msg_list => FND_API.G_FALSE,

1267: l_sc_tbl(1).attribute15 := l_sc_select_rec.attribute15;
1268:
1269: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1270: p_api_version_number => 2.0,
1271: p_init_msg_list => FND_API.G_FALSE,
1272: p_commit => FND_API.G_FALSE,
1273: p_validation_level => 90,
1274: p_identity_salesforce_id => p_identity_sf_id,
1275: p_sales_credit_tbl => l_sc_tbl,

Line 1272: p_commit => FND_API.G_FALSE,

1268:
1269: AS_OPPORTUNITY_PUB.Modify_Sales_Credits(
1270: p_api_version_number => 2.0,
1271: p_init_msg_list => FND_API.G_FALSE,
1272: p_commit => FND_API.G_FALSE,
1273: p_validation_level => 90,
1274: p_identity_salesforce_id => p_identity_sf_id,
1275: p_sales_credit_tbl => l_sc_tbl,
1276: p_check_access_flag => 'N',

Line 1354: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1350: END IF;
1351: END LOOP;
1352: CLOSE c_rep_quota_credits;
1353:
1354: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;
1357:
1358: -- Update Lead Line Amounts

Line 1355: RAISE FND_API.G_EXC_ERROR;

1351: END LOOP;
1352: CLOSE c_rep_quota_credits;
1353:
1354: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;
1357:
1358: -- Update Lead Line Amounts
1359: l_header_rec.lead_id := p_lead_id;

Line 1364: p_init_msg_list => FND_API.G_FALSE,

1360:
1361: IF l_ll_tbl_count > 0 THEN
1362: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1363: p_api_version_number => 2.0,
1364: p_init_msg_list => FND_API.G_FALSE,
1365: p_commit => FND_API.G_FALSE,
1366: p_validation_level => 90,
1367: p_identity_salesforce_id => p_identity_sf_id,
1368: p_line_tbl => l_ll_tbl,

Line 1365: p_commit => FND_API.G_FALSE,

1361: IF l_ll_tbl_count > 0 THEN
1362: AS_OPPORTUNITY_PUB.Update_Opp_Lines(
1363: p_api_version_number => 2.0,
1364: p_init_msg_list => FND_API.G_FALSE,
1365: p_commit => FND_API.G_FALSE,
1366: p_validation_level => 90,
1367: p_identity_salesforce_id => p_identity_sf_id,
1368: p_line_tbl => l_ll_tbl,
1369: p_header_rec => l_header_rec,

Line 1381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1377: x_msg_data => x_msg_data
1378: );
1379: END IF;
1380:
1381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: IF (p_debug_flag = 'Y' AND

Line 1382: RAISE FND_API.G_EXC_ERROR;

1378: );
1379: END IF;
1380:
1381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: IF (p_debug_flag = 'Y' AND
1386: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1393: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1389: END IF;
1390:
1391: EXCEPTION
1392: WHEN OTHERS then
1393: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: END IF;
1396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 1394: x_return_status := FND_API.G_RET_STS_ERROR;

1390:
1391: EXCEPTION
1392: WHEN OTHERS then
1393: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: END IF;
1396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1398: 'In When others (Update_sc_for_rep). lead_id: '

Line 1407: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

1403: End Update_sc_for_rep_line;
1404:
1405: PROCEDURE Copy_Opportunity_Line
1406: ( p_api_version_number IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: p_lead_id IN NUMBER,
1411: p_forecast_credit_type_id IN NUMBER,

Line 1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1404:
1405: PROCEDURE Copy_Opportunity_Line
1406: ( p_api_version_number IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: p_lead_id IN NUMBER,
1411: p_forecast_credit_type_id IN NUMBER,
1412: p_win_probability IN NUMBER,

Line 1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1405: PROCEDURE Copy_Opportunity_Line
1406: ( p_api_version_number IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: p_lead_id IN NUMBER,
1411: p_forecast_credit_type_id IN NUMBER,
1412: p_win_probability IN NUMBER,
1413: p_win_loss_indicator IN VARCHAR2,

Line 1443: l_tot_revenue_opp_forecast_amt NUMBER := FND_API.G_MISS_NUM; -- Added for ASNB

1439: l_customer_id NUMBER;
1440: l_new_status VARCHAR2(30);
1441: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');
1442: l_new_total_amount NUMBER;
1443: l_tot_revenue_opp_forecast_amt NUMBER := FND_API.G_MISS_NUM; -- Added for ASNB
1444: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
1445:
1446: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
1447: l_val NUMBER;

Line 1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1493: -- Standard Start of API savepoint
1494: SAVEPOINT COPY_OPPORTUNITY_PVT;
1495:
1496: -- Standard call to check for call compatibility.
1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1498: p_api_version_number,
1499: l_api_name,
1500: G_PKG_NAME)
1501: THEN

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: p_api_version_number,
1499: l_api_name,
1500: G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1507: IF FND_API.to_Boolean( p_init_msg_list )

1503: END IF;
1504:
1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list )
1508: THEN
1509: FND_MSG_PUB.initialize;
1510: END IF;
1511:

Line 1521: x_return_status := FND_API.G_RET_STS_SUCCESS;

1517: END IF;
1518:
1519:
1520: -- Initialize API return status to SUCCESS
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522:
1523:
1524: -- Copy Opportunity Lines and line details - Sales Credits,
1525: -- Competitor Products and Decision Factors

Line 1591: RAISE FND_API.G_EXC_ERROR;

1587: IF l_debug THEN
1588: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1589: 'Private API: as_lead_lines_pkg.insert_row fail');
1590: END IF;
1591: RAISE FND_API.G_EXC_ERROR;
1592: ELSE
1593: IF l_debug THEN
1594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1595: ' Private API: as_lead_lines_pkg.insert_row '|| l_lead_line_id);

Line 1674: RAISE FND_API.G_EXC_ERROR;

1670: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1671: 'Private API: as_sales_credits_pkg.insert_row fail');
1672: END IF;
1673:
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSE
1676: IF l_debug THEN
1677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1678: 'Private API: as_sales_credits_pkg.insert_row '|| l_sales_credit_id);

Line 1729: RAISE FND_API.G_EXC_ERROR;

1725: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1726: 'Private API: as_lead_comp_products_pkg.insert_row fail');
1727: END IF;
1728:
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSE
1731: IF l_debug THEN
1732: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1733: 'Private API: as_lead_comp_products_pkg.insert_row '|| l_lead_competitor_prod_id);

Line 1780: RAISE FND_API.G_EXC_ERROR;

1776: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1777: 'Private API: as_lead_decision_factors_pkg.insert_row fail');
1778: END IF;
1779:
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSE
1782: IF l_debug THEN
1783: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1784: 'Private API: as_lead_decision_factors_pkg.insert_row '|| l_lead_decision_factor_id );

Line 1795: WHEN FND_API.G_EXC_ERROR THEN

1791:
1792:
1793:
1794: EXCEPTION
1795: WHEN FND_API.G_EXC_ERROR THEN
1796: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1797: P_API_NAME => L_API_NAME
1798: ,P_PKG_NAME => G_PKG_NAME
1799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1801: ,X_MSG_COUNT => X_MSG_COUNT
1802: ,X_MSG_DATA => X_MSG_DATA
1803: ,X_RETURN_STATUS => X_RETURN_STATUS);
1804:
1805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1806: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1807: P_API_NAME => L_API_NAME
1808: ,P_PKG_NAME => G_PKG_NAME
1809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2712: RAISE FND_API.G_EXC_ERROR;

2708: 'Error: Cannot reassign Partner Credits for Opportunity Id'
2709: || l_lead_id(j)
2710: || '. It does not have an owner or an employee in the SalesTeam who can be assigned as the owner');
2711: END IF;
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;
2714: END IF;
2715: END IF;
2716:

Line 2775: p_init_msg_list => FND_API.G_FALSE,

2771: -- Step 3.e.i Copy Opportunity
2772:
2773: Copy_Opportunity_Line
2774: ( p_api_version_number => 2.0,
2775: p_init_msg_list => FND_API.G_FALSE,
2776: p_commit => FND_API.G_FALSE,
2777: p_validation_level => 90,
2778: p_lead_id => l_lead_id(j),
2779: p_forecast_credit_type_id => l_forecast_credit_type_id,

Line 2776: p_commit => FND_API.G_FALSE,

2772:
2773: Copy_Opportunity_Line
2774: ( p_api_version_number => 2.0,
2775: p_init_msg_list => FND_API.G_FALSE,
2776: p_commit => FND_API.G_FALSE,
2777: p_validation_level => 90,
2778: p_lead_id => l_lead_id(j),
2779: p_forecast_credit_type_id => l_forecast_credit_type_id,
2780: p_win_probability => l_win_probability(j),

Line 2795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2791: );
2792:
2793:
2794:
2795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: IF (p_debug_flag = 'Y' AND

Line 2796: RAISE FND_API.G_EXC_ERROR;

2792:
2793:
2794:
2795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: IF (p_debug_flag = 'Y' AND
2800: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2814: Update_sc_for_rep_line (l_lead_id(j),multicredit_opps_rec.lead_line_id, l_first_sf_id, l_first_sg_id,
2815: l_forecast_credit_type_id, l_org_owner_sf_id,
2816: p_debug_flag, l_return_status, l_msg_count, l_msg_data);
2817:
2818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;
2821: END IF;
2822:

Line 2819: RAISE FND_API.G_EXC_ERROR;

2815: l_forecast_credit_type_id, l_org_owner_sf_id,
2816: p_debug_flag, l_return_status, l_msg_count, l_msg_data);
2817:
2818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;
2821: END IF;
2822:
2823: