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.OE_INLINE_CUSTOMER_PUB dependencies on OE_VALUE_TO_ID

Line 856: l_duplicate_account := Oe_value_to_id.sold_to_org(

852: End If;
853:
854: -- { Start Check for the Duplidate Account information
855: If customer_rec.customer_type = 'ORGANIZATION' Then
856: l_duplicate_account := Oe_value_to_id.sold_to_org(
857: p_sold_to_org => customer_rec.organization_name,
858: p_customer_number => customer_rec.customer_number);
859: Elsif customer_rec.customer_type = 'PERSON' Then
860: l_duplicate_account := oe_value_to_id.sold_to_org(

Line 860: l_duplicate_account := oe_value_to_id.sold_to_org(

856: l_duplicate_account := Oe_value_to_id.sold_to_org(
857: p_sold_to_org => customer_rec.organization_name,
858: p_customer_number => customer_rec.customer_number);
859: Elsif customer_rec.customer_type = 'PERSON' Then
860: l_duplicate_account := oe_value_to_id.sold_to_org(
861: p_sold_to_org => customer_rec.person_first_name || ' ' ||
862: customer_rec.person_last_name,
863: p_customer_number => customer_rec.customer_number);
864: End If;

Line 878: -- As the data is not duplicate but the call to oe_value_to_id

874: x_return_status := FND_API.G_RET_STS_ERROR;
875: Update_Error_Flag(p_rowid => customer_rec.rowid);
876: Return;
877: Else
878: -- As the data is not duplicate but the call to oe_value_to_id
879: -- has entered one error message in stack(necessary evil!)
880: -- What to do => here is solution delete it
881: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
882: End if; -- Duplicate account check

Line 1860: l_duplicate_address := Oe_Value_To_Id.Ship_To_Org(

1856: END IF ;
1857:
1858: -- {Start of If for duplicate checking
1859: If p_type_of_address = 'SHIP_TO' Then
1860: l_duplicate_address := Oe_Value_To_Id.Ship_To_Org(
1861: p_ship_to_address1 => address_info_rec.address1,
1862: p_ship_to_address2 => address_info_rec.address2,
1863: p_ship_to_address3 => address_info_rec.address3,
1864: p_ship_to_address4 => address_info_rec.address4,

Line 1887: -- As the data is not duplicate but the call to oe_value_to_id

1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1885: Return;
1886: Else
1887: -- As the data is not duplicate but the call to oe_value_to_id
1888: -- has entered one error message in stack(necessary evil!)
1889: -- What to do => here is solution delete it
1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1891: End if; -- duplicate ship_to_org check

Line 1893: l_duplicate_address := Oe_Value_To_Id.Invoice_To_Org(

1889: -- What to do => here is solution delete it
1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1891: End if; -- duplicate ship_to_org check
1892: Elsif p_type_of_address = 'BILL_TO' Then
1893: l_duplicate_address := Oe_Value_To_Id.Invoice_To_Org(
1894: p_invoice_to_address1 => address_info_rec.address1,
1895: p_invoice_to_address2 => address_info_rec.address2,
1896: p_invoice_to_address3 => address_info_rec.address3,
1897: p_invoice_to_address4 => address_info_rec.address4,

Line 1920: -- As the data is not duplicate but the call to oe_value_to_id

1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1918: Return;
1919: Else
1920: -- As the data is not duplicate but the call to oe_value_to_id
1921: -- has entered one error message in stack(necessary evil!)
1922: -- What to do => here is solution delete it
1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1924: End if; -- duplicate bill_to_org check

Line 1926: l_duplicate_address := Oe_Value_To_Id.Deliver_To_Org(

1922: -- What to do => here is solution delete it
1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1924: End if; -- duplicate bill_to_org check
1925: Elsif p_type_of_address = 'DELIVER_TO' Then
1926: l_duplicate_address := Oe_Value_To_Id.Deliver_To_Org(
1927: p_deliver_to_address1 => address_info_rec.address1,
1928: p_deliver_to_address2 => address_info_rec.address2,
1929: p_deliver_to_address3 => address_info_rec.address3,
1930: p_deliver_to_address4 => address_info_rec.address4,

Line 1953: -- As the data is not duplicate but the call to oe_value_to_id

1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1951: Return;
1952: Else
1953: -- As the data is not duplicate but the call to oe_value_to_id
1954: -- has entered one error message in stack(necessary evil!)
1955: -- What to do => here is solution delete it
1956: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1957: End if; -- duplicate deliver_to_org check

Line 2743: l_sold_to_contact := Oe_Value_To_Id.Sold_To_Contact(

2739: From Dual;
2740:
2741: -- { Start of If for duplicate contact check
2742: If l_type_of_contact = 'SOLD_TO' Then
2743: l_sold_to_contact := Oe_Value_To_Id.Sold_To_Contact(
2744: p_sold_to_contact => l_contact_name,
2745: p_sold_to_org_id => l_customer_info_id);
2746: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2747: -- Raise Error and Abort Processing

Line 2758: -- As the data is not duplicate but the call to oe_value_to_id

2754: x_return_status := FND_API.G_RET_STS_ERROR;
2755: Update_Error_Flag(p_rowid => contact_rec.rowid);
2756: Return;
2757: Else
2758: -- As the data is not duplicate but the call to oe_value_to_id
2759: -- has entered one error message in stack(necessary evil!)
2760: -- What to do => here is solution delete it
2761: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2762: End if; -- duplicate sold_to contact check

Line 2764: l_sold_to_contact := Oe_Value_To_Id.Ship_To_Contact(

2760: -- What to do => here is solution delete it
2761: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2762: End if; -- duplicate sold_to contact check
2763: Elsif l_type_of_contact = 'SHIP_TO' Then
2764: l_sold_to_contact := Oe_Value_To_Id.Ship_To_Contact(
2765: p_ship_to_contact => l_contact_name,
2766: p_ship_to_org_id => l_usage_site_id);
2767: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2768: -- Raise Error and Abort Processing

Line 2779: -- As the data is not duplicate but the call to oe_value_to_id

2775: x_return_status := FND_API.G_RET_STS_ERROR;
2776: Update_Error_Flag(p_rowid => contact_rec.rowid);
2777: Return;
2778: Else
2779: -- As the data is not duplicate but the call to oe_value_to_id
2780: -- has entered one error message in stack(necessary evil!)
2781: -- What to do => here is solution delete it
2782: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2783: End if; -- duplicate ship_to contact check

Line 2785: l_sold_to_contact := Oe_Value_To_Id.Invoice_To_Contact(

2781: -- What to do => here is solution delete it
2782: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2783: End if; -- duplicate ship_to contact check
2784: Elsif l_type_of_contact = 'BILL_TO' Then
2785: l_sold_to_contact := Oe_Value_To_Id.Invoice_To_Contact(
2786: p_invoice_to_contact => l_contact_name,
2787: p_invoice_to_org_id => l_usage_site_id);
2788: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2789: -- Raise Error and Abort Processing

Line 2800: -- As the data is not duplicate but the call to oe_value_to_id

2796: x_return_status := FND_API.G_RET_STS_ERROR;
2797: Update_Error_Flag(p_rowid => contact_rec.rowid);
2798: Return;
2799: Else
2800: -- As the data is not duplicate but the call to oe_value_to_id
2801: -- has entered one error message in stack(necessary evil!)
2802: -- What to do => here is solution delete it
2803: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2804: End if; -- duplicate bill_to contact check

Line 2806: l_sold_to_contact := Oe_Value_To_Id.Deliver_To_Contact(

2802: -- What to do => here is solution delete it
2803: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2804: End if; -- duplicate bill_to contact check
2805: Elsif l_type_of_contact = 'DELIVER_TO' Then
2806: l_sold_to_contact := Oe_Value_To_Id.Deliver_To_Contact(
2807: p_deliver_to_contact => l_contact_name,
2808: p_deliver_to_org_id => l_usage_site_id);
2809: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2810: -- Raise Error and Abort Processing

Line 2821: -- As the data is not duplicate but the call to oe_value_to_id

2817: x_return_status := FND_API.G_RET_STS_ERROR;
2818: Update_Error_Flag(p_rowid => contact_rec.rowid);
2819: Return;
2820: Else
2821: -- As the data is not duplicate but the call to oe_value_to_id
2822: -- has entered one error message in stack(necessary evil!)
2823: -- What to do => here is solution delete it
2824: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2825: End if; -- duplicate deliver_to contact check