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

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_To_Errors_Table');
85: EXCEPTION
86: WHEN OTHERS THEN
87: OE_DEBUG_PUB.Add('Insert_To_Errors_Table: Unexpected Error');
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END;
90:
91: --=====================================================================
92: -- NAME: Is_Currency_Valid

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: RETURN l_return_value;
136: EXCEPTION
137: WHEN OTHERS THEN
138: OE_DEBUG_PUB.Add('Is_Currency_Valid: Unexpected Error');
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END Is_Currency_Valid;
141:
142: --=====================================================================
143: -- NAME: Address_Value_To_ID

Line 158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

154: CURSOR c_bill_to_site_use_id (p_bill_to_state VARCHAR2) IS
155: SELECT ORGANIZATION_ID
156: FROM OE_INVOICE_TO_ORGS_V
157: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

155: SELECT ORGANIZATION_ID
156: FROM OE_INVOICE_TO_ORGS_V
157: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

Line 160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

156: FROM OE_INVOICE_TO_ORGS_V
157: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

157: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

Line 162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =

Line 163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)

Line 164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

161: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

Line 166: AND nvl(STATE,fnd_api.g_miss_char) =

162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 167: nvl( p_bill_to_state, fnd_api.g_miss_char)

163: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =
171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

Line 168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

164: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =
171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
172: AND STATUS = 'A'

Line 169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

165: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =
171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
172: AND STATUS = 'A'
173: AND CUSTOMER_ID = p_exposure_rec.bill_to_customer_id

Line 170: AND nvl(COUNTRY,fnd_api.g_miss_char) =

166: AND nvl(STATE,fnd_api.g_miss_char) =
167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =
171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
172: AND STATUS = 'A'
173: AND CUSTOMER_ID = p_exposure_rec.bill_to_customer_id
174: and address_status='A'; --2752321

Line 171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

167: nvl( p_bill_to_state, fnd_api.g_miss_char)
168: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
169: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
170: AND nvl(COUNTRY,fnd_api.g_miss_char) =
171: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
172: AND STATUS = 'A'
173: AND CUSTOMER_ID = p_exposure_rec.bill_to_customer_id
174: and address_status='A'; --2752321
175:

Line 180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

176: CURSOR C1 (p_bill_to_state VARCHAR2) IS
177: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
178: FROM OE_INVOICE_TO_ORGS_V
179: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

177: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
178: FROM OE_INVOICE_TO_ORGS_V
179: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

Line 182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

178: FROM OE_INVOICE_TO_ORGS_V
179: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

179: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

Line 184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =

Line 185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)

Line 186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

183: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

Line 188: AND nvl(STATE,fnd_api.g_miss_char) =

184: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 189: nvl( p_bill_to_state, fnd_api.g_miss_char)

185: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =
193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

Line 190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

186: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =
193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
194: AND STATUS = 'A'

Line 191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

187: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =
193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
194: AND STATUS = 'A'
195: and address_status='A' --2752321

Line 192: AND nvl(COUNTRY,fnd_api.g_miss_char) =

188: AND nvl(STATE,fnd_api.g_miss_char) =
189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =
193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
194: AND STATUS = 'A'
195: and address_status='A' --2752321
196: AND CUSTOMER_ID IN

Line 193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

189: nvl( p_bill_to_state, fnd_api.g_miss_char)
190: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
191: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
192: AND nvl(COUNTRY,fnd_api.g_miss_char) =
193: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
194: AND STATUS = 'A'
195: and address_status='A' --2752321
196: AND CUSTOMER_ID IN
197: (

Line 210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

206: CURSOR C2 (p_bill_to_state VARCHAR2) IS
207: SELECT ORGANIZATION_ID
208: FROM OE_INVOICE_TO_ORGS_V
209: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

207: SELECT ORGANIZATION_ID
208: FROM OE_INVOICE_TO_ORGS_V
209: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

Line 212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

208: FROM OE_INVOICE_TO_ORGS_V
209: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

209: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

Line 214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =

Line 215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)

211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)

Line 216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)

213: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

Line 218: AND nvl(STATE,fnd_api.g_miss_char) =

214: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 219: nvl( p_bill_to_state, fnd_api.g_miss_char)

215: nvl( p_exposure_rec.bill_to_address4,fnd_api.g_miss_char)
216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =
223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

Line 220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

216: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =
223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
224: AND STATUS = 'A'

Line 221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)

217: nvl( p_exposure_rec.bill_to_city, fnd_api.g_miss_char)
218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =
223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
224: AND STATUS = 'A'
225: and address_status='A'; --2752321

Line 222: AND nvl(COUNTRY,fnd_api.g_miss_char) =

218: AND nvl(STATE,fnd_api.g_miss_char) =
219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =
223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
224: AND STATUS = 'A'
225: and address_status='A'; --2752321
226:

Line 223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)

219: nvl( p_bill_to_state, fnd_api.g_miss_char)
220: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
221: nvl( p_exposure_rec.bill_to_postal_code, fnd_api.g_miss_char)
222: AND nvl(COUNTRY,fnd_api.g_miss_char) =
223: nvl( p_exposure_rec.bill_to_country, fnd_api.g_miss_char)
224: AND STATUS = 'A'
225: and address_status='A'; --2752321
226:
227: l_bill_to_site_use_id NUMBER;

Line 250: IF NVL(p_exposure_rec.bill_to_state, FND_API.G_MISS_CHAR) =

246: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations, 5);
247: --
248: -- bug 2346992: Get province if state is NULL or G_MISS_CHAR
249: --
250: IF NVL(p_exposure_rec.bill_to_state, FND_API.G_MISS_CHAR) =
251: FND_API.G_MISS_CHAR
252: THEN
253: l_bill_to_state := p_exposure_rec.bill_to_province;
254: ELSE

Line 251: FND_API.G_MISS_CHAR

247: --
248: -- bug 2346992: Get province if state is NULL or G_MISS_CHAR
249: --
250: IF NVL(p_exposure_rec.bill_to_state, FND_API.G_MISS_CHAR) =
251: FND_API.G_MISS_CHAR
252: THEN
253: l_bill_to_state := p_exposure_rec.bill_to_province;
254: ELSE
255: l_bill_to_state := p_exposure_rec.bill_to_state;

Line 278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

274: SELECT ORGANIZATION_ID
275: INTO l_bill_to_site_use_id
276: FROM OE_INVOICE_TO_ORGS_V
277: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
281: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
282: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

275: INTO l_bill_to_site_use_id
276: FROM OE_INVOICE_TO_ORGS_V
277: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
281: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
282: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
283: DECODE(STATE, NULL, NULL, STATE || ', ')||

Line 280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

276: FROM OE_INVOICE_TO_ORGS_V
277: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
281: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
282: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
283: DECODE(STATE, NULL, NULL, STATE || ', ')||
284: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 281: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

277: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
281: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
282: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
283: DECODE(STATE, NULL, NULL, STATE || ', ')||
284: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
285: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 286: NVL( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)

282: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
283: DECODE(STATE, NULL, NULL, STATE || ', ')||
284: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
285: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
286: NVL( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)
287: AND STATUS = 'A'
288: AND CUSTOMER_ID = p_exposure_rec.bill_to_customer_id
289: and address_status='A'; --2752321
290: END IF;

Line 320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

316: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
317: INTO l_bill_to_site_use_id
318: FROM OE_INVOICE_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
324: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

317: INTO l_bill_to_site_use_id
318: FROM OE_INVOICE_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
324: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
325: DECODE(STATE, NULL, NULL, STATE || ', ')||

Line 322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

318: FROM OE_INVOICE_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
324: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
325: DECODE(STATE, NULL, NULL, STATE || ', ')||
326: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 323: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

319: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
324: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
325: DECODE(STATE, NULL, NULL, STATE || ', ')||
326: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
327: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 328: nvl( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)

324: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
325: DECODE(STATE, NULL, NULL, STATE || ', ')||
326: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
327: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
328: nvl( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)
329: AND STATUS = 'A'
330: and address_status='A' --2752321
331: AND CUSTOMER_ID IN
332: (SELECT p_exposure_rec.bill_to_customer_id

Line 364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =

360: SELECT ORGANIZATION_ID
361: INTO l_bill_to_site_use_id
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
368: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)

361: INTO l_bill_to_site_use_id
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
368: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
369: DECODE(STATE, NULL, NULL, STATE || ', ')||

Line 366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
368: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
369: DECODE(STATE, NULL, NULL, STATE || ', ')||
370: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 367: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)

363: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_exposure_rec.bill_to_address3,fnd_api.g_miss_char)
368: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
369: DECODE(STATE, NULL, NULL, STATE || ', ')||
370: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
371: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 372: NVL( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)

368: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
369: DECODE(STATE, NULL, NULL, STATE || ', ')||
370: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
371: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
372: NVL( p_exposure_rec.bill_to_address4, fnd_api.g_miss_char)
373: AND STATUS = 'A'
374: and address_status='A'; --2752321
375: END IF;
376:

Line 407: RETURN FND_API.G_MISS_NUM;

403: , p_error_message_text => l_message_text
404: );
405:
406: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID', 5);
407: RETURN FND_API.G_MISS_NUM;
408: WHEN TOO_MANY_ROWS THEN
409: IF c_bill_to_site_use_id%ISOPEN then
410: CLOSE c_bill_to_site_use_id;
411: END IF;

Line 433: RETURN FND_API.G_MISS_NUM;

429: , p_error_message_text => l_message_text
430: );
431: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID', 5);
432:
433: RETURN FND_API.G_MISS_NUM;
434: WHEN OTHERS THEN
435: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID', 5);
436: IF c_bill_to_site_use_id%ISOPEN then
437: CLOSE c_bill_to_site_use_id;

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: ( G_PKG_NAME
451: , 'Address_Value_To_ID'
452: );
453: END IF;
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END Address_Value_To_ID;
456:
457: --=====================================================================
458: -- NAME: Get_Bill_To_Site_Use_ID

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473: l_message_text VARCHAR2(2000);
474: l_exposure_rec oe_exposure_interface%ROWTYPE;
475: BEGIN
476: OE_DEBUG_PUB.Add('OEXVECEB: In Get_Bill_To_Site_Use_ID', 4);
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: /* Added the following line to fix the bug 6451056 */
480:
481: MO_GLOBAL.set_policy_context('S', p_exposure_rec.org_id);

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
498: -- This same error message takes care of the case of NULL value
499: -- passed in since a NULL in the select will not select any rows.
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;

Line 530: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN

526: );
527: l_bill_to_customer_id := p_exposure_rec.bill_to_customer_id;
528: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
529: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
530: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: ELSIF p_exposure_rec.bill_to_customer_name IS NOT NULL AND
534: p_exposure_rec.bill_to_customer_number IS NOT NULL THEN

Line 531: x_return_status := FND_API.G_RET_STS_ERROR;

527: l_bill_to_customer_id := p_exposure_rec.bill_to_customer_id;
528: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
529: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
530: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: ELSIF p_exposure_rec.bill_to_customer_name IS NOT NULL AND
534: p_exposure_rec.bill_to_customer_number IS NOT NULL THEN
535: -- check for valid customer ID

Line 556: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN

552: );
553:
554: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
555: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
556: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

553:
554: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
555: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
556: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

573: );
574: END;
575: ELSE
576: -- customer information is missing
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_MISSING');
579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: END IF;
593: ELSE
594: -- insufficient information is provided to derive the invoice site use id.
595: -- Either the bill_to site use ID needs to be provided or the bill-to address.
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_INF_INVALID');
598: l_message_text := FND_MESSAGE.Get;
599: OE_DEBUG_PUB.Add('Error: Insufficient information provided to derive site use ID', 5);
600:

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615:
616: OE_DEBUG_PUB.Add('OEXVECEB: Out Get_Bill_To_Site_Use_ID', 4);
617: EXCEPTION
618: WHEN OTHERS THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END Get_Bill_To_Site_Use_ID;
621:
622: --=====================================================================
623: -- NAME: Validate_Exposure_Source

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: IF c_exposure_source%ISOPEN THEN
767: CLOSE c_exposure_source;
768: END IF;
769: OE_DEBUG_PUB.Add('Validate_Exposure_Source -- Unexpected Error');
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END Validate_Exposure_Source;
772:
773: --=====================================================================
774: --NAME: Validate_Exposure

Line 842: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);
840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);
841:
842: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
843: THEN
844: IF NOT l_any_errors THEN
845: l_any_errors := TRUE;
846: END IF;

Line 879: WHEN FND_API.G_EXC_ERROR THEN

875: END LOOP;
876: -- END IF; -- validation
877: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure');
878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);
881: RAISE;
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Unexpected Error', 2);

Line 882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);
881: RAISE;
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Unexpected Error', 2);
884: RAISE;
885: WHEN OTHERS THEN
886: IF c_rows_to_process%ISOPEN THEN

Line 1157: IF NOT FND_API.Compatible_API_Call( l_api_version,

1153: --
1154: -- Check the version and issue an error if the given version does not
1155: -- match the one in this package.
1156: --
1157: IF NOT FND_API.Compatible_API_Call( l_api_version,
1158: p_api_version,
1159: l_api_name,
1160: G_PKG_NAME)
1161: THEN

Line 1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: END IF;
1175:
1176: -- MOAC start
1177: l_org_id := p_org_id;

Line 1338: WHEN FND_API.G_EXC_ERROR THEN

1334:
1335: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Credit_Exposure');
1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);
1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1341: ROLLBACK;
1342: RAISE;

Line 1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);
1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1341: ROLLBACK;
1342: RAISE;
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Error',1);
1345: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1346: ROLLBACK;
1347: RAISE;