1466: x_return_status OUT NOCOPY VARCHAR2,
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: x_msg_count OUT NOCOPY NUMBER,
1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: x_msg_count OUT NOCOPY NUMBER,
1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;
1482: l_msg_data VARCHAR2(2000) := NULL;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;
1482: l_msg_data VARCHAR2(2000) := NULL;
1483: l_api_message VARCHAR2(2000);
1560: printDebug('contacT_party_id = ' || p_header_rec.rel_party_id || ' customer_id = ' || p_header_rec.party_id,
1561: 'Create_Sales_Lead');
1562: end if;
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,
1561: 'Create_Sales_Lead');
1562: end if;
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,
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');
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;