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 2742: l_sold_to_contact := Oe_Value_To_Id.Sold_To_Contact(

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

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

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

Line 2763: l_sold_to_contact := Oe_Value_To_Id.Ship_To_Contact(

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

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

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

Line 2784: l_sold_to_contact := Oe_Value_To_Id.Invoice_To_Contact(

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

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

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

Line 2805: l_sold_to_contact := Oe_Value_To_Id.Deliver_To_Contact(

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

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

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