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_BULK_VALUE_TO_ID dependencies on FND_API

Line 78: and nvl( loc.address2, fnd_api.g_miss_char) =

74: and site_use.status='A'
75: and acct_site.status='A' --bug 2752321
76: and acct_site.cust_account_id=in_end_customer_id
77: and loc.address1 = p_end_customer_site_address1
78: and nvl( loc.address2, fnd_api.g_miss_char) =
79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =

Line 79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)

75: and acct_site.status='A' --bug 2752321
76: and acct_site.cust_account_id=in_end_customer_id
77: and loc.address1 = p_end_customer_site_address1
78: and nvl( loc.address2, fnd_api.g_miss_char) =
79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

Line 80: and nvl( loc.address3, fnd_api.g_miss_char) =

76: and acct_site.cust_account_id=in_end_customer_id
77: and loc.address1 = p_end_customer_site_address1
78: and nvl( loc.address2, fnd_api.g_miss_char) =
79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =

Line 81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)

77: and loc.address1 = p_end_customer_site_address1
78: and nvl( loc.address2, fnd_api.g_miss_char) =
79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)

Line 82: and nvl( loc.address4, fnd_api.g_miss_char) =

78: and nvl( loc.address2, fnd_api.g_miss_char) =
79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =

Line 83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

79: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)

Line 84: and nvl( loc.city, fnd_api.g_miss_char) =

80: and nvl( loc.address3, fnd_api.g_miss_char) =
81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =

Line 85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)

81: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)

Line 86: and nvl( loc.state, fnd_api.g_miss_char) =

82: and nvl( loc.address4, fnd_api.g_miss_char) =
83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =

Line 87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)

83: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =
91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)

Line 88: and nvl( loc.postal_code, fnd_api.g_miss_char) =

84: and nvl( loc.city, fnd_api.g_miss_char) =
85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =
91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
92: and site_use.site_use_code = in_end_customer_site_use_code;

Line 89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)

85: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =
91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
92: and site_use.site_use_code = in_end_customer_site_use_code;
93:

Line 90: and nvl( loc.country, fnd_api.g_miss_char) =

86: and nvl( loc.state, fnd_api.g_miss_char) =
87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =
91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
92: and site_use.site_use_code = in_end_customer_site_use_code;
93:
94: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS

Line 91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)

87: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
88: and nvl( loc.postal_code, fnd_api.g_miss_char) =
89: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
90: and nvl( loc.country, fnd_api.g_miss_char) =
91: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
92: and site_use.site_use_code = in_end_customer_site_use_code;
93:
94: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
95: SELECT site_use.site_use_id

Line 101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =

97: hz_party_sites site,
98: hz_cust_acct_sites acct_site,
99: hz_cust_site_uses site_use
100: WHERE loc.ADDRESS1 = p_end_customer_site_address1
101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
104: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
105: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||

Line 102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)

98: hz_cust_acct_sites acct_site,
99: hz_cust_site_uses site_use
100: WHERE loc.ADDRESS1 = p_end_customer_site_address1
101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
104: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
105: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
106: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||

Line 103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =

99: hz_cust_site_uses site_use
100: WHERE loc.ADDRESS1 = p_end_customer_site_address1
101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
104: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
105: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
106: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
107: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||

Line 104: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)

100: WHERE loc.ADDRESS1 = p_end_customer_site_address1
101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
104: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
105: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
106: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
107: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
108: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =

Line 109: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

105: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
106: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
107: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
108: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =
109: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
110: AND site_use.status = 'A'
111: AND acct_site.status ='A' --bug 2752321
112: AND acct_site.cust_account_id = p_end_customer_id
113: and site_use.site_use_code=in_end_customer_site_use_code

Line 131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

127: oe_debug_pub.add(' address4: in HVOP '||p_end_customer_site_address4);
128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );
129: END IF;
130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );
129: END IF;
130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
136: THEN

Line 133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char

129: END IF;
130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
136: THEN
137: RETURN NULL;

Line 134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char

130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
136: THEN
137: RETURN NULL;
138: END IF;

Line 135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
133: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
134: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
135: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
136: THEN
137: RETURN NULL;
138: END IF;
139:

Line 276: RETURN FND_API.G_MISS_NUM;

272: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
273: OE_MSG_PUB.Add;
274:
275: END IF;
276: RETURN FND_API.G_MISS_NUM;
277:
278: WHEN OTHERS THEN
279:
280: IF c_site_use_id%ISOPEN then

Line 296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

292: , 'end_cstomer_site_id'
293: );
294: END IF;
295:
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297:
298: END END_CUSTOMER_SITE;
299:
300: -- Function to get end customer id

Line 337: RETURN FND_API.G_MISS_NUM;

333: OE_MSG_PUB.Add;
334:
335: END IF;
336:
337: RETURN FND_API.G_MISS_NUM;
338:
339: WHEN OTHERS THEN
340:
341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345: , 'End_customer_contact'
346: );
347: END IF;
348:
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350:
351: END GET_END_CUSTOMER_CONTACT_ID;
352: -- Bug 5054618}
353:

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161: OE_BULK_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Headers'
1164: );
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END Headers;
1167:
1168:
1169: ---------------------------------------------------------------------

Line 1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1964: OE_BULK_MSG_PUB.Add_Exc_Msg
1965: ( G_PKG_NAME
1966: , 'Lines'
1967: );
1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969: END Lines;
1970:
1971:
1972: ---------------------------------------------------------------------

Line 2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2069: OE_BULK_MSG_PUB.Add_Exc_Msg
2070: ( G_PKG_NAME
2071: , 'Adjustments'
2072: );
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: END Adjustments;
2075:
2076:
2077: ---------------------------------------------------------------------

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: OE_BULK_MSG_PUB.Add_Exc_Msg
2245: ( G_PKG_NAME
2246: , 'INSERT_ERROR_MESSAGES'
2247: );
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END INSERT_ERROR_MESSAGES;
2250:
2251: END OE_Bulk_Value_To_Id;