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

Line 25: if (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) then

21: p_message IN VARCHAR2,
22: p_module IN VARCHAR2
23: ) IS
24: BEGIN
25: if (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) then
26: IBE_Util.Debug(p_module || ': ' || p_message);
27: end if;
28:
29: if( g_debug_flag = 'Y' ) then

Line 159: if( p_status_flag <> FND_API.G_RET_STS_SUCCESS OR nvl(l_write_detail_log, 'Y') = 'Y' ) then

155: || ' Status_Flag = ' || p_status_flag, 'write_log');
156:
157:
158:
159: if( p_status_flag <> FND_API.G_RET_STS_SUCCESS OR nvl(l_write_detail_log, 'Y') = 'Y' ) then
160: BEGIN
161: select ibe_lead_import_details_s1.nextval
162: into l_detail_id
163: From dual;

Line 757: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;

753:
754: g_debug_flag := p_debug_flag;
755:
756: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
757: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
758: Else
759: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
760: End If;
761:

Line 759: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;

755:
756: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
757: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
758: Else
759: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
760: End If;
761:
762: printDebug('IBE_UTIL.G_DEBUGON=' || IBE_UTIL.G_DEBUGON, 'Create_Order_Leads');
763:

Line 900: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then

896: 'Create_Order_leads');
897:
898: l_total := l_total + 1;
899:
900: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
901: printDebug('Success process_sales_lead_import for quote ' || to_char(l_order_rec.quote_header_id),
902: 'Create_Order_leads');
903: l_num_success := l_num_success + 1;
904: else

Line 912: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);

908:
909: if( l_msg_count > 0 ) then
910: l_msg_data := '';
911: FOR i in 1..l_msg_count LOOP
912: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);
913: l_error_msg := replace(l_error_msg, chr(0), ' ');
914: printDebug(l_error_msg, 'Create_order_lead');
915: END LOOP;
916: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);

Line 916: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);

912: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);
913: l_error_msg := replace(l_error_msg, chr(0), ' ');
914: printDebug(l_error_msg, 'Create_order_lead');
915: END LOOP;
916: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);
917: end if;
918: printDebug('Error Message ' || l_msg_data, 'Create_Order_leads');
919: end if;
920:

Line 983: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

979: x_return_status => l_return_status,
980: x_msg_count => l_msg_count,
981: x_msg_data => l_msg_data);
982:
983: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
984: printDebug('Error from send_email', 'SendEmail');
985: raise FND_API.G_EXC_ERROR;
986: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
987: printDebug('Error from send_email', 'SendEmail');

Line 985: raise FND_API.G_EXC_ERROR;

981: x_msg_data => l_msg_data);
982:
983: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
984: printDebug('Error from send_email', 'SendEmail');
985: raise FND_API.G_EXC_ERROR;
986: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
987: printDebug('Error from send_email', 'SendEmail');
988: raise FND_API.G_EXC_UNEXPECTED_ERROR;
989: end if;

Line 986: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

982:
983: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
984: printDebug('Error from send_email', 'SendEmail');
985: raise FND_API.G_EXC_ERROR;
986: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
987: printDebug('Error from send_email', 'SendEmail');
988: raise FND_API.G_EXC_UNEXPECTED_ERROR;
989: end if;
990:

Line 988: raise FND_API.G_EXC_UNEXPECTED_ERROR;

984: printDebug('Error from send_email', 'SendEmail');
985: raise FND_API.G_EXC_ERROR;
986: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
987: printDebug('Error from send_email', 'SendEmail');
988: raise FND_API.G_EXC_UNEXPECTED_ERROR;
989: end if;
990:
991: printDebug('Return to main', 'Create_order_leads');
992: EXCEPTION

Line 1048: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;

1044:
1045: g_debug_flag := p_debug_flag;
1046:
1047: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
1048: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
1049: Else
1050: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
1051: End If;
1052:

Line 1050: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;

1046:
1047: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
1048: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
1049: Else
1050: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
1051: End If;
1052:
1053: printDebug('IBE_UTIL.G_DEBUGON=' || IBE_UTIL.G_DEBUGON, 'Create_Quote_Leads');
1054:

Line 1176: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then

1172: printDebug('after calling process_sales_lead_import ' || l_return_status || ' Num Error: ' || l_msg_count,
1173: 'Create_Quote_leads');
1174:
1175: l_total := l_total + 1;
1176: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
1177: printDebug('Success process_sales_lead_import for quote ' || to_char(l_Quote_rec.quote_header_id),
1178: 'Create_Quote_leads');
1179: l_num_success := l_num_success + 1;
1180: else

Line 1188: --l_error_msg := FND_MSG_PUB.GET(i, FND_API.G_FALSE);

1184:
1185: if( l_msg_count > 0 ) then
1186: l_msg_data := '';
1187: FOR i in 1..l_msg_count LOOP
1188: --l_error_msg := FND_MSG_PUB.GET(i, FND_API.G_FALSE);
1189: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);
1190: l_error_msg := replace(l_error_msg, chr(0), ' ');
1191: printDebug(l_error_msg, 'Create_Quote_leads');
1192: END LOOP;

Line 1189: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);

1185: if( l_msg_count > 0 ) then
1186: l_msg_data := '';
1187: FOR i in 1..l_msg_count LOOP
1188: --l_error_msg := FND_MSG_PUB.GET(i, FND_API.G_FALSE);
1189: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);
1190: l_error_msg := replace(l_error_msg, chr(0), ' ');
1191: printDebug(l_error_msg, 'Create_Quote_leads');
1192: END LOOP;
1193: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);

Line 1193: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);

1189: l_error_msg := l_error_msg || FND_MSG_PUB.GET(i, FND_API.G_FALSE);
1190: l_error_msg := replace(l_error_msg, chr(0), ' ');
1191: printDebug(l_error_msg, 'Create_Quote_leads');
1192: END LOOP;
1193: l_msg_data := FND_MSG_PUB.GET(l_msg_count, FND_API.G_FALSE);
1194: end if;
1195: printDebug('Error Message ' || l_msg_data, 'Create_Quote_leads');
1196: end if;
1197: printDebug('Insert_Log Details ', 'Create_Quote_Leads');

Line 1273: x_return_status := FND_API.G_RET_STS_SUCCESS;

1269:
1270:
1271: BEGIN
1272: printDebug('Inside Process_Sales_Lead_Import ', 'Process_Sales_Lead_Import (+)');
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: printDebug('process_lead','p header rec.party_name ...'||l_header_rec.PARTY_NAME);
1276: printDebug('process_lead','p header rec.party_id ...'|| l_header_rec.PARTY_ID);
1277: printDebug('process_lead','p header rec.party_type ...'|| l_header_rec.PARTY_TYPE);

Line 1445: WHEN FND_API.G_EXC_ERROR THEN

1441:
1442: END LOOP;
1443:
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1446: x_return_status := FND_API.G_RET_STS_ERROR;

1442: END LOOP;
1443:
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

Line 1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1443:
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1451: WHEN OTHERS THEN

Line 1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1445: WHEN FND_API.G_EXC_ERROR THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1454: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');

Line 1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1454: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');
1455: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1456: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 1460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

1456: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1457: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1458: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'Process_Sales_Lead_Import');
1459: END IF;
1460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
1461: end process_sales_lead_import;
1462:
1463: procedure create_sales_lead(
1464: p_header_rec IN G_LEADS_REC,

Line 1501: x_return_status := FND_API.G_RET_STS_SUCCESS;

1497:
1498: BEGIN
1499: --null;
1500: -- first get the promotion_id
1501: x_return_status := FND_API.G_RET_STS_SUCCESS;
1502: x_msg_count := 0;
1503: x_msg_data := '';
1504:
1505: -- l_promotion_code :=nvl(fnd_profile.value_specific('IBE_DEFAULT_LEAD_PROMO_CODE', null, null, 671),'10000');

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: IF c_get_promotion_id%NOTFOUND THEN
1512: close c_get_promotion_id;
1513: FND_MESSAGE.SET_NAME('IBE', 'IBE_LI_INVALID_PROMOTION_CODE');
1514: x_msg_data := FND_MESSAGE.GET;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: x_msg_count := x_msg_count + 1;
1517: printOutput(x_msg_data);
1518: raise FND_API.G_EXC_ERROR;
1519: else

Line 1518: raise FND_API.G_EXC_ERROR;

1514: x_msg_data := FND_MESSAGE.GET;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: x_msg_count := x_msg_count + 1;
1517: printOutput(x_msg_data);
1518: raise FND_API.G_EXC_ERROR;
1519: else
1520: l_sales_lead_rec.source_promotion_id := l_temp_promotion_id;
1521: end if;
1522:

Line 1567: p_init_msg_list => FND_API.G_FALSE,

1563:
1564: printDebug('Calling as_sales_leads_pub.create_sales_lead', 'Create_Sales_Lead');
1565: as_sales_leads_pub.create_sales_lead(
1566: p_api_version_number => 2.0,
1567: p_init_msg_list => FND_API.G_FALSE,
1568: p_commit => FND_API.G_FALSE,
1569: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1570: p_check_access_flag => 'N',
1571: p_admin_flag => 'N',

Line 1568: p_commit => FND_API.G_FALSE,

1564: printDebug('Calling as_sales_leads_pub.create_sales_lead', 'Create_Sales_Lead');
1565: as_sales_leads_pub.create_sales_lead(
1566: p_api_version_number => 2.0,
1567: p_init_msg_list => FND_API.G_FALSE,
1568: p_commit => FND_API.G_FALSE,
1569: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1570: p_check_access_flag => 'N',
1571: p_admin_flag => 'N',
1572: p_admin_group_id => null,

Line 1569: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1565: as_sales_leads_pub.create_sales_lead(
1566: p_api_version_number => 2.0,
1567: p_init_msg_list => FND_API.G_FALSE,
1568: p_commit => FND_API.G_FALSE,
1569: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1570: p_check_access_flag => 'N',
1571: p_admin_flag => 'N',
1572: p_admin_group_id => null,
1573: p_identity_salesforce_id => null,

Line 1586: if( x_return_status = FND_API.G_RET_STS_ERROR ) then

1582: x_sales_lead_line_out_tbl => x_sales_lead_line_out_tbl,
1583: x_sales_lead_cnt_out_tbl => x_sales_lead_cnt_out_tbl);
1584:
1585:
1586: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
1587: raise FND_API.G_EXC_ERROR;
1588: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;

Line 1587: raise FND_API.G_EXC_ERROR;

1583: x_sales_lead_cnt_out_tbl => x_sales_lead_cnt_out_tbl);
1584:
1585:
1586: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
1587: raise FND_API.G_EXC_ERROR;
1588: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;
1591:

Line 1588: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1584:
1585:
1586: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
1587: raise FND_API.G_EXC_ERROR;
1588: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;
1591:
1592:

Line 1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1585:
1586: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
1587: raise FND_API.G_EXC_ERROR;
1588: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;
1591:
1592:
1593: printDebug('After calling as_sales_leads_pub.create_sales_lead ' || x_return_status, 'Create_Sales_lead');

Line 1596: printDebug(FND_MSG_PUB.GET(i, FND_API.G_FALSE), 'Create_sales_lead');

1592:
1593: printDebug('After calling as_sales_leads_pub.create_sales_lead ' || x_return_status, 'Create_Sales_lead');
1594: if( x_msg_count > 1 ) then
1595: For i in 1..x_msg_count LOOP
1596: printDebug(FND_MSG_PUB.GET(i, FND_API.G_FALSE), 'Create_sales_lead');
1597: end LOOP;
1598: elsif( x_msg_count = 1 ) then
1599: printDebug(x_msg_data, 'Create_sales_lead');
1600: end if;

Line 1602: WHEN FND_API.G_EXC_ERROR THEN

1598: elsif( x_msg_count = 1 ) then
1599: printDebug(x_msg_data, 'Create_sales_lead');
1600: end if;
1601: EXCEPTION
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1603: x_return_status := FND_API.G_RET_STS_ERROR;

1599: printDebug(x_msg_data, 'Create_sales_lead');
1600: end if;
1601: EXCEPTION
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

Line 1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1600: end if;
1601: EXCEPTION
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1608: WHEN OTHERS THEN

Line 1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1601: EXCEPTION
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1611: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');

Line 1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1611: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');
1612: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1613: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 1733: raise FND_API.G_EXC_ERROR;

1729: printDebug('l_email_list is null ', 'sendEmail');
1730: FND_MESSAGE.set_Name('IBE', 'IBE_ECR_PROFILE_VALUE');
1731: FND_MESSAGE.set_Token('NAME', 'IBE_LEAD_EMAIL_ADDRESS');
1732: FND_MSG_PUB.Add;
1733: raise FND_API.G_EXC_ERROR;
1734: end if;
1735:
1736: open quote_csr;
1737: LOOP

Line 1800: p_commit => FND_API.G_TRUE,

1796: --dbms_output.put_line(l_body3);
1797:
1798: IBE_WFNOTIFICATION_PVT.send_html_email(
1799: p_api_version => 1.0,
1800: p_commit => FND_API.G_TRUE,
1801: p_init_msg_list => FND_API.G_TRUE,
1802: email_list => l_email_list,
1803: subject => l_subject,
1804: body => l_body||l_body3,

Line 1801: p_init_msg_list => FND_API.G_TRUE,

1797:
1798: IBE_WFNOTIFICATION_PVT.send_html_email(
1799: p_api_version => 1.0,
1800: p_commit => FND_API.G_TRUE,
1801: p_init_msg_list => FND_API.G_TRUE,
1802: email_list => l_email_list,
1803: subject => l_subject,
1804: body => l_body||l_body3,
1805: return_status => l_return_status,

Line 1809: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

1805: return_status => l_return_status,
1806: x_msg_count => l_msg_count,
1807: x_msg_data => l_msg_data);
1808:
1809: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
1810: printDebug('Error from send_email', 'SendEmail');
1811: raise FND_API.G_EXC_ERROR;
1812: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1813: printDebug('Error from send_email', 'SendEmail');

Line 1811: raise FND_API.G_EXC_ERROR;

1807: x_msg_data => l_msg_data);
1808:
1809: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
1810: printDebug('Error from send_email', 'SendEmail');
1811: raise FND_API.G_EXC_ERROR;
1812: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1813: printDebug('Error from send_email', 'SendEmail');
1814: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1815: end if;

Line 1812: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1808:
1809: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
1810: printDebug('Error from send_email', 'SendEmail');
1811: raise FND_API.G_EXC_ERROR;
1812: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1813: printDebug('Error from send_email', 'SendEmail');
1814: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1815: end if;
1816:

Line 1814: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1810: printDebug('Error from send_email', 'SendEmail');
1811: raise FND_API.G_EXC_ERROR;
1812: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1813: printDebug('Error from send_email', 'SendEmail');
1814: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1815: end if;
1816:
1817: printDebug('l_email_list ' || l_email_list, 'Send_Email');
1818: printDebug('l_subject ' || l_subject, 'Send_Email');

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

1818: printDebug('l_subject ' || l_subject, 'Send_Email');
1819: printDebug('l_body ' || l_body, 'Send_Email');
1820: printDebug('l_body3 ' || l_body3, 'Send_Email');
1821:
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: x_msg_data := '';
1824: x_msg_count := 0;
1825:
1826: EXCEPTION

Line 1827: WHEN FND_API.G_EXC_ERROR THEN

1823: x_msg_data := '';
1824: x_msg_count := 0;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1828: x_return_status := FND_API.G_RET_STS_ERROR;

1824: x_msg_count := 0;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

Line 1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN

Line 1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);

1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1836: FND_MESSAGE.Set_Token('ROUTINE', 'SendEmail');

Line 1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_Count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1836: FND_MESSAGE.Set_Token('ROUTINE', 'SendEmail');
1837: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1838: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 1842: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

1838: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1840: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'SendEmail');
1841: END IF;
1842: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
1843: End sendEmail;
1844:
1845: procedure print_Parameter(
1846: p_begin_date IN VARCHAR2,