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_MSG_PUB

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 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 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 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 1457: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 1458: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'Process_Sales_Lead_Import');

1454: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');
1455: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
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:

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 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 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 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 1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1615: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'Process_Sales_Lead_Import');
1616: END IF;
1617: End Create_Sales_Lead;
1618:

Line 1615: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'Process_Sales_Lead_Import');

1611: FND_MESSAGE.Set_Token('ROUTINE', 'Process_Sales_lead_Import');
1612: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1613: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1615: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'Process_Sales_Lead_Import');
1616: END IF;
1617: End Create_Sales_Lead;
1618:
1619: procedure create_LeadAndNotes(

Line 1732: FND_MSG_PUB.Add;

1728: if( l_email_list is null ) then
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;

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 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 1839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 1840: FND_MSG_PUB.Add_Exc_Msg('IBE_LEAD_IMPORT_PVT', 'SendEmail');

1836: FND_MESSAGE.Set_Token('ROUTINE', 'SendEmail');
1837: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
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:

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,