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

Line 39: IF l_segment_array(I) = FND_API.G_MISS_CHAR THEN

35: -- Convert any missing values to NULL
36:
37: FOR I IN 1..l_segment_array.COUNT LOOP
38:
39: IF l_segment_array(I) = FND_API.G_MISS_CHAR THEN
40: l_segment_array(I) := NULL;
41: END IF;
42:
43: END LOOP;

Line 63: l_id := FND_API.G_MISS_NUM;

59: -- Function has already pushed a message on the stack. Add to
60: -- the API message list.
61:
62: OE_MSG_PUB.Add;
63: l_id := FND_API.G_MISS_NUM;
64:
65: END IF;
66:
67: RETURN l_id;

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: , 'Key_Flex'
78: );
79: END IF;
80:
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82:
83: END Key_Flex;
84:
85: -- Generator will append new prototypes before end generate comment.

Line 122: RETURN FND_API.G_MISS_NUM;

118: OE_MSG_PUB.Add;
119:
120: END IF;
121:
122: RETURN FND_API.G_MISS_NUM;
123:
124: WHEN OTHERS THEN
125:
126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130: , 'Accounting_Rule'
131: );
132: END IF;
133:
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135:
136: END Accounting_Rule;
137:
138: -- Agreement (Done aksingh)

Line 172: RETURN FND_API.G_MISS_NUM;

168: OE_MSG_PUB.Add;
169:
170: END IF;
171:
172: RETURN FND_API.G_MISS_NUM;
173:
174: WHEN OTHERS THEN
175:
176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: , 'Agreement'
181: );
182: END IF;
183:
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185:
186: END Agreement;
187:
188: -- Conversion_Type (Done aksingh)

Line 222: RETURN FND_API.G_MISS_CHAR;

218: OE_MSG_PUB.Add;
219:
220: END IF;
221:
222: RETURN FND_API.G_MISS_CHAR;
223:
224: WHEN OTHERS THEN
225:
226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: , 'Conversion_Type'
231: );
232: END IF;
233:
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235:
236: END Conversion_Type;
237:
238: -- Deliver_To_Contact (Done aksingh)

Line 280: RETURN FND_API.G_MISS_NUM;

276: OE_MSG_PUB.Add;
277:
278: END IF;
279:
280: RETURN FND_API.G_MISS_NUM;
281:
282: WHEN OTHERS THEN
283:
284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288: , 'Deliver_To_Contact'
289: );
290: END IF;
291:
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293:
294: END Deliver_To_Contact;
295:
296: -- Deliver_To_Org (Done aksingh)

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

316: CURSOR c_deliver_to_org_id IS
317: SELECT ORGANIZATION_ID
318: FROM OE_DELIVER_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

317: SELECT ORGANIZATION_ID
318: FROM OE_DELIVER_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)

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

318: FROM OE_DELIVER_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)

319: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)

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

320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =

Line 325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)

321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)

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

322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 327: nvl( p_deliver_to_city, fnd_api.g_miss_char)

323: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

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

324: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 329: nvl( p_deliver_to_state, fnd_api.g_miss_char)

325: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =
333: nvl( p_deliver_to_country, fnd_api.g_miss_char)

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

326: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =
333: nvl( p_deliver_to_country, fnd_api.g_miss_char)
334: --AND STATUS = 'A'

Line 331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

327: nvl( p_deliver_to_city, fnd_api.g_miss_char)
328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =
333: nvl( p_deliver_to_country, fnd_api.g_miss_char)
334: --AND STATUS = 'A'
335: AND CUSTOMER_ID = p_sold_to_org_id;

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

328: AND nvl(STATE,fnd_api.g_miss_char) =
329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =
333: nvl( p_deliver_to_country, fnd_api.g_miss_char)
334: --AND STATUS = 'A'
335: AND CUSTOMER_ID = p_sold_to_org_id;
336:

Line 333: nvl( p_deliver_to_country, fnd_api.g_miss_char)

329: nvl( p_deliver_to_state, fnd_api.g_miss_char)
330: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
331: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
332: AND nvl(COUNTRY,fnd_api.g_miss_char) =
333: nvl( p_deliver_to_country, fnd_api.g_miss_char)
334: --AND STATUS = 'A'
335: AND CUSTOMER_ID = p_sold_to_org_id;
336:
337: CURSOR C1 IS

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

337: CURSOR C1 IS
338: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
339: FROM OE_DELIVER_TO_ORGS_V
340: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

338: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
339: FROM OE_DELIVER_TO_ORGS_V
340: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)

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

339: FROM OE_DELIVER_TO_ORGS_V
340: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)

340: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)

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

341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =

Line 346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)

342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)

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

343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 348: nvl( p_deliver_to_city, fnd_api.g_miss_char)

344: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

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

345: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 350: nvl( p_deliver_to_state, fnd_api.g_miss_char)

346: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =
354: nvl( p_deliver_to_country, fnd_api.g_miss_char)

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

347: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =
354: nvl( p_deliver_to_country, fnd_api.g_miss_char)
355: --AND STATUS = 'A'

Line 352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

348: nvl( p_deliver_to_city, fnd_api.g_miss_char)
349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =
354: nvl( p_deliver_to_country, fnd_api.g_miss_char)
355: --AND STATUS = 'A'
356: AND CUSTOMER_ID IN

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

349: AND nvl(STATE,fnd_api.g_miss_char) =
350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =
354: nvl( p_deliver_to_country, fnd_api.g_miss_char)
355: --AND STATUS = 'A'
356: AND CUSTOMER_ID IN
357: (

Line 354: nvl( p_deliver_to_country, fnd_api.g_miss_char)

350: nvl( p_deliver_to_state, fnd_api.g_miss_char)
351: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
352: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
353: AND nvl(COUNTRY,fnd_api.g_miss_char) =
354: nvl( p_deliver_to_country, fnd_api.g_miss_char)
355: --AND STATUS = 'A'
356: AND CUSTOMER_ID IN
357: (
358: SELECT p_sold_to_org_id FROM DUAL

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

364: CURSOR C2 IS
365: SELECT ORGANIZATION_ID
366: FROM OE_DELIVER_TO_ORGS_V
367: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

365: SELECT ORGANIZATION_ID
366: FROM OE_DELIVER_TO_ORGS_V
367: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)

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

366: FROM OE_DELIVER_TO_ORGS_V
367: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)

367: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)

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

368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =

Line 373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)

369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)

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

370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 375: nvl( p_deliver_to_city, fnd_api.g_miss_char)

371: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

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

372: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 377: nvl( p_deliver_to_state, fnd_api.g_miss_char)

373: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =
381: nvl( p_deliver_to_country, fnd_api.g_miss_char);

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

374: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =
381: nvl( p_deliver_to_country, fnd_api.g_miss_char);
382: --AND STATUS = 'A';

Line 379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)

375: nvl( p_deliver_to_city, fnd_api.g_miss_char)
376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =
381: nvl( p_deliver_to_country, fnd_api.g_miss_char);
382: --AND STATUS = 'A';
383:

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

376: AND nvl(STATE,fnd_api.g_miss_char) =
377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =
381: nvl( p_deliver_to_country, fnd_api.g_miss_char);
382: --AND STATUS = 'A';
383:
384: l_org varchar2(100);

Line 381: nvl( p_deliver_to_country, fnd_api.g_miss_char);

377: nvl( p_deliver_to_state, fnd_api.g_miss_char)
378: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
379: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
380: AND nvl(COUNTRY,fnd_api.g_miss_char) =
381: nvl( p_deliver_to_country, fnd_api.g_miss_char);
382: --AND STATUS = 'A';
383:
384: l_org varchar2(100);
385: --

Line 390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

386: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
387: --
388: BEGIN
389:
390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

387: --
388: BEGIN
389:
390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char
395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char

388: BEGIN
389:
390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char
395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char
396: THEN

Line 393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char

389:
390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char
395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char
396: THEN
397: RETURN NULL;

Line 394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char

390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char
395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char
396: THEN
397: RETURN NULL;
398: END IF;

Line 395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char

391: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
392: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
393: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
394: AND nvl( p_deliver_to_location,fnd_api.g_miss_char) = fnd_api.g_miss_char
395: AND nvl( p_deliver_to_org, fnd_api.g_miss_char) = fnd_api.g_miss_char
396: THEN
397: RETURN NULL;
398: END IF;
399:

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

415: SELECT ORGANIZATION_ID
416: INTO l_id
417: FROM OE_DELIVER_TO_ORGS_V
418: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
419: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
421: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
422: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
423: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

416: INTO l_id
417: FROM OE_DELIVER_TO_ORGS_V
418: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
419: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
421: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
422: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
423: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
424: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

417: FROM OE_DELIVER_TO_ORGS_V
418: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
419: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
421: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
422: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
423: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
424: DECODE(STATE, NULL, NULL, STATE || ', ')||
425: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 422: nvl( p_deliver_to_address3, fnd_api.g_miss_char)

418: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
419: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
421: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
422: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
423: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
424: DECODE(STATE, NULL, NULL, STATE || ', ')||
425: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
426: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 427: nvl( p_deliver_to_address4, fnd_api.g_miss_char)

423: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
424: DECODE(STATE, NULL, NULL, STATE || ', ')||
425: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
426: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
427: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
428: -- AND STATUS = 'A'
429: AND CUSTOMER_ID = p_sold_to_org_id;
430: END IF;
431:

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

458: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
459: INTO l_id
460: FROM OE_DELIVER_TO_ORGS_V
461: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
462: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
464: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
465: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
466: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

459: INTO l_id
460: FROM OE_DELIVER_TO_ORGS_V
461: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
462: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
464: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
465: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
466: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
467: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

460: FROM OE_DELIVER_TO_ORGS_V
461: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
462: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
464: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
465: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
466: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
467: DECODE(STATE, NULL, NULL, STATE || ', ')||
468: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 465: nvl( p_deliver_to_address3,fnd_api.g_miss_char)

461: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
462: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
464: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
465: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
466: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
467: DECODE(STATE, NULL, NULL, STATE || ', ')||
468: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
469: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 470: NVL( p_deliver_to_address4, fnd_api.g_miss_char)

466: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
467: DECODE(STATE, NULL, NULL, STATE || ', ')||
468: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
469: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
470: NVL( p_deliver_to_address4, fnd_api.g_miss_char)
471: -- AND STATUS = 'A'
472: AND CUSTOMER_ID IN
473: (SELECT p_sold_to_org_id FROM DUAL
474: UNION

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

501: SELECT ORGANIZATION_ID
502: INTO l_id
503: FROM OE_DELIVER_TO_ORGS_V
504: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
505: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
507: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
508: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
509: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)

502: INTO l_id
503: FROM OE_DELIVER_TO_ORGS_V
504: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
505: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
507: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
508: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
509: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
510: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

503: FROM OE_DELIVER_TO_ORGS_V
504: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
505: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
507: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
508: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
509: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
510: DECODE(STATE, NULL, NULL, STATE || ', ')||
511: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 508: nvl( p_deliver_to_address3,fnd_api.g_miss_char)

504: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
505: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
507: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
508: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
509: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
510: DECODE(STATE, NULL, NULL, STATE || ', ')||
511: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
512: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 513: NVL( p_deliver_to_address4, fnd_api.g_miss_char);

509: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
510: DECODE(STATE, NULL, NULL, STATE || ', ')||
511: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
512: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
513: NVL( p_deliver_to_address4, fnd_api.g_miss_char);
514: -- AND STATUS = 'A';
515: END IF;
516:
517: CLOSE C2;

Line 548: RETURN FND_API.G_MISS_NUM;

544: OE_MSG_PUB.Add;
545:
546: END IF;
547:
548: RETURN FND_API.G_MISS_NUM;
549:
550: WHEN OTHERS THEN
551:
552: IF c_deliver_to_org_id%ISOPEN then

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: , 'Deliver_To_Org'
570: );
571: END IF;
572:
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574:
575: END Deliver_To_Org;
576:
577: -- Fob_Point (Done aksingh)

Line 613: RETURN FND_API.G_MISS_CHAR;

609: OE_MSG_PUB.Add;
610:
611: END IF;
612:
613: RETURN FND_API.G_MISS_CHAR;
614:
615: WHEN OTHERS THEN
616:
617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

621: , 'Fob_Point'
622: );
623: END IF;
624:
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626:
627: END Fob_Point;
628:
629: -- Freight_Terms (Done aksingh)

Line 665: RETURN FND_API.G_MISS_CHAR;

661: OE_MSG_PUB.Add;
662:
663: END IF;
664:
665: RETURN FND_API.G_MISS_CHAR;
666:
667: WHEN OTHERS THEN
668:
669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

673: , 'Freight_Terms'
674: );
675: END IF;
676:
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678:
679: END Freight_Terms;
680:
681: -- Intermediate_Ship_To_Contact (Done aksingh)

Line 716: RETURN FND_API.G_MISS_NUM;

712: OE_MSG_PUB.Add;
713:
714: END IF;
715:
716: RETURN FND_API.G_MISS_NUM;
717:
718:
719: WHEN OTHERS THEN
720:

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725: , 'Intermed_Ship_To_Contact'
726: );
727: END IF;
728:
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730:
731: END Intermed_Ship_To_Contact;
732:
733: -- Intermed_Ship_To_Org (Done aksingh)

Line 781: RETURN FND_API.G_MISS_NUM;

777: OE_MSG_PUB.Add;
778:
779: END IF;
780:
781: RETURN FND_API.G_MISS_NUM;
782:
783: WHEN OTHERS THEN
784:
785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: , 'Intermed_Ship_To_Org'
790: );
791: END IF;
792:
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:
795: END Intermed_Ship_To_Org;
796:
797: -- Invoice_To_Contact (Done aksingh)

Line 839: RETURN FND_API.G_MISS_NUM;

835: OE_MSG_PUB.Add;
836:
837: END IF;
838:
839: RETURN FND_API.G_MISS_NUM;
840:
841: WHEN OTHERS THEN
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: , 'Invoice_To_Contact'
848: );
849: END IF;
850:
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852:
853: END Invoice_To_Contact;
854:
855: -- Invoice_To_Org (Done aksingh)

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

875: CURSOR c_invoice_to_org_id IS
876: SELECT ORGANIZATION_ID
877: FROM OE_INVOICE_TO_ORGS_V
878: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

876: SELECT ORGANIZATION_ID
877: FROM OE_INVOICE_TO_ORGS_V
878: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

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

877: FROM OE_INVOICE_TO_ORGS_V
878: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

878: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)

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

879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =

Line 884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)

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

881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 886: nvl( p_invoice_to_city, fnd_api.g_miss_char)

882: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

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

883: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 888: nvl( p_invoice_to_state, fnd_api.g_miss_char)

884: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =
892: nvl( p_invoice_to_country, fnd_api.g_miss_char)

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

885: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =
892: nvl( p_invoice_to_country, fnd_api.g_miss_char)
893: AND STATUS = 'A'

Line 890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

886: nvl( p_invoice_to_city, fnd_api.g_miss_char)
887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =
892: nvl( p_invoice_to_country, fnd_api.g_miss_char)
893: AND STATUS = 'A'
894: AND CUSTOMER_ID = p_sold_to_org_id;

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

887: AND nvl(STATE,fnd_api.g_miss_char) =
888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =
892: nvl( p_invoice_to_country, fnd_api.g_miss_char)
893: AND STATUS = 'A'
894: AND CUSTOMER_ID = p_sold_to_org_id;
895:

Line 892: nvl( p_invoice_to_country, fnd_api.g_miss_char)

888: nvl( p_invoice_to_state, fnd_api.g_miss_char)
889: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
890: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
891: AND nvl(COUNTRY,fnd_api.g_miss_char) =
892: nvl( p_invoice_to_country, fnd_api.g_miss_char)
893: AND STATUS = 'A'
894: AND CUSTOMER_ID = p_sold_to_org_id;
895:
896: BEGIN

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

917: SELECT ORGANIZATION_ID
918: INTO l_id
919: FROM OE_INVOICE_TO_ORGS_V
920: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
921: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
923: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
924: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
925: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

918: INTO l_id
919: FROM OE_INVOICE_TO_ORGS_V
920: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
921: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
923: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
924: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
925: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
926: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

919: FROM OE_INVOICE_TO_ORGS_V
920: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
921: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
923: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
924: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
925: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
926: DECODE(STATE, NULL, NULL, STATE || ', ')||
927: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 924: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

920: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
921: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
923: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
924: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
925: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
926: DECODE(STATE, NULL, NULL, STATE || ', ')||
927: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
928: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 929: NVL( p_invoice_to_address4, fnd_api.g_miss_char)

925: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
926: DECODE(STATE, NULL, NULL, STATE || ', ')||
927: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
928: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
929: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
930: AND STATUS = 'A'
931: AND CUSTOMER_ID = p_sold_to_org_id;
932: END IF;
933:

Line 955: RETURN FND_API.G_MISS_NUM;

951: OE_MSG_PUB.Add;
952:
953: END IF;
954:
955: RETURN FND_API.G_MISS_NUM;
956:
957: WHEN OTHERS THEN
958:
959: IF c_invoice_to_org_id%ISOPEN then

Line 971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

967: , 'Invoice_To_Org'
968: );
969: END IF;
970:
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972:
973: END Invoice_To_Org;
974: */
975: /* Added the new definition of the finction invoice_to_org to fix the bug 2002486 */

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

994: CURSOR c_invoice_to_org_id IS
995: SELECT ORGANIZATION_ID
996: FROM OE_INVOICE_TO_ORGS_V
997: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

995: SELECT ORGANIZATION_ID
996: FROM OE_INVOICE_TO_ORGS_V
997: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

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

996: FROM OE_INVOICE_TO_ORGS_V
997: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

997: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)

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

998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =

Line 1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)

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

1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)

1001: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

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

1002: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)

1003: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)

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

1004: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1012: AND STATUS = 'A'

Line 1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

1005: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1012: AND STATUS = 'A'
1013: AND CUSTOMER_ID = p_sold_to_org_id;

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

1006: AND nvl(STATE,fnd_api.g_miss_char) =
1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1012: AND STATUS = 'A'
1013: AND CUSTOMER_ID = p_sold_to_org_id;
1014:

Line 1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)

1007: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1008: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1009: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1010: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1011: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1012: AND STATUS = 'A'
1013: AND CUSTOMER_ID = p_sold_to_org_id;
1014:
1015: CURSOR C1 IS

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

1015: CURSOR C1 IS
1016: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1017: FROM OE_INVOICE_TO_ORGS_V
1018: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

1016: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1017: FROM OE_INVOICE_TO_ORGS_V
1018: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

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

1017: FROM OE_INVOICE_TO_ORGS_V
1018: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

1018: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)

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

1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =

Line 1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)

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

1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)

1022: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

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

1023: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)

1024: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)

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

1025: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1033: AND STATUS = 'A'

Line 1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

1026: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1033: AND STATUS = 'A'
1034: AND CUSTOMER_ID IN

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

1027: AND nvl(STATE,fnd_api.g_miss_char) =
1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1033: AND STATUS = 'A'
1034: AND CUSTOMER_ID IN
1035: (

Line 1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)

1028: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1029: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1030: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1031: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1033: AND STATUS = 'A'
1034: AND CUSTOMER_ID IN
1035: (
1036: SELECT p_sold_to_org_id FROM DUAL

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

1042: CURSOR C2 IS
1043: SELECT ORGANIZATION_ID
1044: FROM OE_INVOICE_TO_ORGS_V
1045: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

1043: SELECT ORGANIZATION_ID
1044: FROM OE_INVOICE_TO_ORGS_V
1045: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

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

1044: FROM OE_INVOICE_TO_ORGS_V
1045: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

1045: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)

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

1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =

Line 1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)

1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)

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

1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)

1049: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

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

1050: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)

1051: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)

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

1052: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1060: AND STATUS = 'A';

Line 1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)

1053: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1060: AND STATUS = 'A';
1061: --

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

1054: AND nvl(STATE,fnd_api.g_miss_char) =
1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1060: AND STATUS = 'A';
1061: --
1062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)

1055: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1056: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1057: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1060: AND STATUS = 'A';
1061: --
1062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1063: --

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

1090: SELECT ORGANIZATION_ID
1091: INTO l_id
1092: FROM OE_INVOICE_TO_ORGS_V
1093: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1094: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1096: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1097: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1098: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

1091: INTO l_id
1092: FROM OE_INVOICE_TO_ORGS_V
1093: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1094: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1096: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1097: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1098: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1099: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1092: FROM OE_INVOICE_TO_ORGS_V
1093: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1094: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1096: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1097: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1098: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1099: DECODE(STATE, NULL, NULL, STATE || ', ')||
1100: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1097: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

1093: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1094: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1096: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1097: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1098: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1099: DECODE(STATE, NULL, NULL, STATE || ', ')||
1100: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1101: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1102: NVL( p_invoice_to_address4, fnd_api.g_miss_char)

1098: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1099: DECODE(STATE, NULL, NULL, STATE || ', ')||
1100: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1101: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1102: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1103: AND STATUS = 'A'
1104: AND CUSTOMER_ID = p_sold_to_org_id;
1105: END IF;
1106:

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

1120: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1121: INTO l_id
1122: FROM OE_INVOICE_TO_ORGS_V
1123: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1124: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1126: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1127: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1128: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

1121: INTO l_id
1122: FROM OE_INVOICE_TO_ORGS_V
1123: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1124: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1126: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1127: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1128: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1129: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1122: FROM OE_INVOICE_TO_ORGS_V
1123: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1124: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1126: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1127: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1128: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1129: DECODE(STATE, NULL, NULL, STATE || ', ')||
1130: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1127: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

1123: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1124: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1126: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1127: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1128: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1129: DECODE(STATE, NULL, NULL, STATE || ', ')||
1130: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1131: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1132: NVL( p_invoice_to_address4, fnd_api.g_miss_char)

1128: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1129: DECODE(STATE, NULL, NULL, STATE || ', ')||
1130: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1131: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1132: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1133: AND STATUS = 'A'
1134: AND CUSTOMER_ID IN
1135: (SELECT p_sold_to_org_id FROM DUAL
1136: UNION

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

1158: SELECT ORGANIZATION_ID
1159: INTO l_id
1160: FROM OE_INVOICE_TO_ORGS_V
1161: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1162: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1164: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1165: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1166: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)

1159: INTO l_id
1160: FROM OE_INVOICE_TO_ORGS_V
1161: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1162: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1164: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1165: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1166: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1167: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1160: FROM OE_INVOICE_TO_ORGS_V
1161: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1162: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1164: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1165: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1166: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1167: DECODE(STATE, NULL, NULL, STATE || ', ')||
1168: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1165: nvl( p_invoice_to_address3,fnd_api.g_miss_char)

1161: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1162: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1164: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1165: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1166: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1167: DECODE(STATE, NULL, NULL, STATE || ', ')||
1168: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1169: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1170: NVL( p_invoice_to_address4, fnd_api.g_miss_char)

1166: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1167: DECODE(STATE, NULL, NULL, STATE || ', ')||
1168: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1169: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1170: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1171: AND STATUS = 'A';
1172: END IF;
1173:
1174: CLOSE C2;

Line 1204: RETURN FND_API.G_MISS_NUM;

1200: OE_MSG_PUB.Add;
1201:
1202: END IF;
1203:
1204: RETURN FND_API.G_MISS_NUM;
1205:
1206: WHEN OTHERS THEN
1207:
1208: IF c_invoice_to_org_id%ISOPEN then

Line 1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1224: , 'Invoice_To_Org'
1225: );
1226: END IF;
1227:
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229:
1230: END Invoice_To_Org;
1231:
1232: -- Invoicing_Rule (Done aksingh)

Line 1266: RETURN FND_API.G_MISS_NUM;

1262: OE_MSG_PUB.Add;
1263:
1264: END IF;
1265:
1266: RETURN FND_API.G_MISS_NUM;
1267:
1268: WHEN OTHERS THEN
1269:
1270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1274: , 'Invoicing_Rule'
1275: );
1276: END IF;
1277:
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279:
1280: END Invoicing_Rule;
1281:
1282: -- Order_Source (Done aksingh)

Line 1321: RETURN FND_API.G_MISS_NUM;

1317: OE_MSG_PUB.Add;
1318:
1319: END IF;
1320:
1321: RETURN FND_API.G_MISS_NUM;
1322:
1323: WHEN OTHERS THEN
1324:
1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: , 'Order_Source'
1330: );
1331: END IF;
1332:
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334:
1335: END Order_Source;
1336:
1337: -- Order_Type (Done aksingh)

Line 1371: RETURN FND_API.G_MISS_NUM;

1367: OE_MSG_PUB.Add;
1368:
1369: END IF;
1370:
1371: RETURN FND_API.G_MISS_NUM;
1372:
1373: WHEN OTHERS THEN
1374:
1375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: , 'Order_Type'
1380: );
1381: END IF;
1382:
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384:
1385: END Order_Type;
1386:
1387: -- Payment_Term (Done aksingh)

Line 1421: RETURN FND_API.G_MISS_NUM;

1417: OE_MSG_PUB.Add;
1418:
1419: END IF;
1420:
1421: RETURN FND_API.G_MISS_NUM;
1422:
1423: WHEN OTHERS THEN
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1429: , 'Payment_Term'
1430: );
1431: END IF;
1432:
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434:
1435: END Payment_Term;
1436:
1437: -- Price_List (Done aksingh)

Line 1472: RETURN FND_API.G_MISS_NUM;

1468: OE_MSG_PUB.Add;
1469:
1470: END IF;
1471:
1472: RETURN FND_API.G_MISS_NUM;
1473:
1474: WHEN OTHERS THEN
1475:
1476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1480: , 'Price_List'
1481: );
1482: END IF;
1483:
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485:
1486: END Price_List;
1487:
1488: -- Shipment_Priority (Done aksingh)

Line 1524: RETURN FND_API.G_MISS_CHAR;

1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523:
1524: RETURN FND_API.G_MISS_CHAR;
1525:
1526: WHEN OTHERS THEN
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1532: , 'Shipment_Priority'
1533: );
1534: END IF;
1535:
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537:
1538: END Shipment_Priority;
1539:
1540: -- Ship_From_Org (Done aksingh)

Line 1589: RETURN FND_API.G_MISS_NUM;

1585: OE_MSG_PUB.Add;
1586:
1587: END IF;
1588:
1589: RETURN FND_API.G_MISS_NUM;
1590:
1591: WHEN OTHERS THEN
1592:
1593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1597: , 'Ship_From_Org'
1598: );
1599: END IF;
1600:
1601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1602:
1603: END Ship_From_Org;
1604:
1605: -- Ship_To_Contact (Done aksingh)

Line 1648: RETURN FND_API.G_MISS_NUM;

1644: OE_MSG_PUB.Add;
1645:
1646: END IF;
1647:
1648: RETURN FND_API.G_MISS_NUM;
1649:
1650: WHEN OTHERS THEN
1651:
1652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1656: , 'Ship_To_Contact'
1657: );
1658: END IF;
1659:
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661:
1662: END Ship_To_Contact;
1663:
1664: FUNCTION Inventory_Org

Line 1696: RETURN FND_API.G_MISS_NUM;

1692: OE_MSG_PUB.Add;
1693:
1694: END IF;
1695:
1696: RETURN FND_API.G_MISS_NUM;
1697:
1698: WHEN OTHERS THEN
1699:
1700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1704: , 'inventory_org'
1705: );
1706: END IF;
1707:
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709:
1710: END Inventory_Org;
1711:
1712: -- Ship_To_Org (Done aksingh)

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

1732: CURSOR c_ship_to_org_id IS
1733: SELECT ORGANIZATION_ID
1734: FROM OE_SHIP_TO_ORGS_V
1735: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1733: SELECT ORGANIZATION_ID
1734: FROM OE_SHIP_TO_ORGS_V
1735: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)

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

1734: FROM OE_SHIP_TO_ORGS_V
1735: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =

Line 1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1735: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)

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

1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =

Line 1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)

Line 1742: AND nvl( town_or_city, fnd_api.g_miss_char) =

1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =

Line 1743: nvl( p_ship_to_city, fnd_api.g_miss_char)

1739: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

Line 1744: AND nvl( state, fnd_api.g_miss_char) =

1740: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =

Line 1745: nvl( p_ship_to_state, fnd_api.g_miss_char)

1741: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =
1749: nvl( p_ship_to_country, fnd_api.g_miss_char)

Line 1746: AND nvl( postal_code, fnd_api.g_miss_char) =

1742: AND nvl( town_or_city, fnd_api.g_miss_char) =
1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =
1749: nvl( p_ship_to_country, fnd_api.g_miss_char)
1750: AND STATUS = 'A'

Line 1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

1743: nvl( p_ship_to_city, fnd_api.g_miss_char)
1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =
1749: nvl( p_ship_to_country, fnd_api.g_miss_char)
1750: AND STATUS = 'A'
1751: AND CUSTOMER_ID = p_sold_to_org_id;

Line 1748: AND nvl( country, fnd_api.g_miss_char) =

1744: AND nvl( state, fnd_api.g_miss_char) =
1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =
1749: nvl( p_ship_to_country, fnd_api.g_miss_char)
1750: AND STATUS = 'A'
1751: AND CUSTOMER_ID = p_sold_to_org_id;
1752:

Line 1749: nvl( p_ship_to_country, fnd_api.g_miss_char)

1745: nvl( p_ship_to_state, fnd_api.g_miss_char)
1746: AND nvl( postal_code, fnd_api.g_miss_char) =
1747: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1748: AND nvl( country, fnd_api.g_miss_char) =
1749: nvl( p_ship_to_country, fnd_api.g_miss_char)
1750: AND STATUS = 'A'
1751: AND CUSTOMER_ID = p_sold_to_org_id;
1752:
1753: BEGIN

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

1774: SELECT ORGANIZATION_ID
1775: INTO l_id
1776: FROM OE_SHIP_TO_ORGS_V
1777: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1778: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1780: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1781: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1782: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1775: INTO l_id
1776: FROM OE_SHIP_TO_ORGS_V
1777: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1778: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1780: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1781: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1782: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1783: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1776: FROM OE_SHIP_TO_ORGS_V
1777: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1778: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1780: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1781: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1782: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1783: DECODE(STATE, NULL, NULL, STATE || ', ')||
1784: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1781: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1777: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1778: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1780: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1781: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1782: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1783: DECODE(STATE, NULL, NULL, STATE || ', ')||
1784: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1785: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1786: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1782: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1783: DECODE(STATE, NULL, NULL, STATE || ', ')||
1784: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1785: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1786: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1787: AND STATUS = 'A'
1788: AND CUSTOMER_ID = p_sold_to_org_id;
1789: END IF;
1790: CLOSE c_ship_to_org_id;

Line 1811: RETURN FND_API.G_MISS_NUM;

1807: OE_MSG_PUB.Add;
1808:
1809: END IF;
1810:
1811: RETURN FND_API.G_MISS_NUM;
1812:
1813: WHEN OTHERS THEN
1814:
1815: IF c_ship_to_org_id%ISOPEN then

Line 1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1823: , 'Ship_To_Org'
1824: );
1825: END IF;
1826:
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828:
1829: END Ship_To_Org;
1830: */
1831:

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

1852: CURSOR c_ship_to_org_id IS
1853: SELECT ORGANIZATION_ID
1854: FROM OE_SHIP_TO_ORGS_V
1855: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1853: SELECT ORGANIZATION_ID
1854: FROM OE_SHIP_TO_ORGS_V
1855: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)

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

1854: FROM OE_SHIP_TO_ORGS_V
1855: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =

Line 1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1855: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)

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

1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =

Line 1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)

Line 1862: AND nvl( town_or_city, fnd_api.g_miss_char) =

1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =

Line 1863: nvl( p_ship_to_city, fnd_api.g_miss_char)

1859: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

Line 1864: AND nvl( state, fnd_api.g_miss_char) =

1860: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =

Line 1865: nvl( p_ship_to_state, fnd_api.g_miss_char)

1861: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =
1869: nvl( p_ship_to_country, fnd_api.g_miss_char)

Line 1866: AND nvl( postal_code, fnd_api.g_miss_char) =

1862: AND nvl( town_or_city, fnd_api.g_miss_char) =
1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =
1869: nvl( p_ship_to_country, fnd_api.g_miss_char)
1870: AND STATUS = 'A'

Line 1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

1863: nvl( p_ship_to_city, fnd_api.g_miss_char)
1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =
1869: nvl( p_ship_to_country, fnd_api.g_miss_char)
1870: AND STATUS = 'A'
1871: AND CUSTOMER_ID = p_sold_to_org_id;

Line 1868: AND nvl( country, fnd_api.g_miss_char) =

1864: AND nvl( state, fnd_api.g_miss_char) =
1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =
1869: nvl( p_ship_to_country, fnd_api.g_miss_char)
1870: AND STATUS = 'A'
1871: AND CUSTOMER_ID = p_sold_to_org_id;
1872:

Line 1869: nvl( p_ship_to_country, fnd_api.g_miss_char)

1865: nvl( p_ship_to_state, fnd_api.g_miss_char)
1866: AND nvl( postal_code, fnd_api.g_miss_char) =
1867: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1868: AND nvl( country, fnd_api.g_miss_char) =
1869: nvl( p_ship_to_country, fnd_api.g_miss_char)
1870: AND STATUS = 'A'
1871: AND CUSTOMER_ID = p_sold_to_org_id;
1872:
1873: CURSOR C1 IS

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

1873: CURSOR C1 IS
1874: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1875: FROM OE_SHIP_TO_ORGS_V
1876: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1874: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1875: FROM OE_SHIP_TO_ORGS_V
1876: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)

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

1875: FROM OE_SHIP_TO_ORGS_V
1876: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =

Line 1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1876: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)

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

1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =

Line 1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)

Line 1883: AND nvl( town_or_city, fnd_api.g_miss_char) =

1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =

Line 1884: nvl( p_ship_to_city, fnd_api.g_miss_char)

1880: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

Line 1885: AND nvl( state, fnd_api.g_miss_char) =

1881: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =

Line 1886: nvl( p_ship_to_state, fnd_api.g_miss_char)

1882: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)

Line 1887: AND nvl( postal_code, fnd_api.g_miss_char) =

1883: AND nvl( town_or_city, fnd_api.g_miss_char) =
1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)
1891: AND STATUS = 'A'

Line 1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

1884: nvl( p_ship_to_city, fnd_api.g_miss_char)
1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)
1891: AND STATUS = 'A'
1892: AND CUSTOMER_ID in(

Line 1889: AND nvl( country, fnd_api.g_miss_char) =

1885: AND nvl( state, fnd_api.g_miss_char) =
1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)
1891: AND STATUS = 'A'
1892: AND CUSTOMER_ID in(
1893: SELECT p_sold_to_org_id FROM DUAL

Line 1890: nvl( p_ship_to_country, fnd_api.g_miss_char)

1886: nvl( p_ship_to_state, fnd_api.g_miss_char)
1887: AND nvl( postal_code, fnd_api.g_miss_char) =
1888: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)
1891: AND STATUS = 'A'
1892: AND CUSTOMER_ID in(
1893: SELECT p_sold_to_org_id FROM DUAL
1894: UNION

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

1900: CURSOR C2 IS
1901: SELECT ORGANIZATION_ID
1902: FROM OE_SHIP_TO_ORGS_V
1903: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1901: SELECT ORGANIZATION_ID
1902: FROM OE_SHIP_TO_ORGS_V
1903: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)

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

1902: FROM OE_SHIP_TO_ORGS_V
1903: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =

Line 1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1903: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)

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

1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =

Line 1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)

Line 1910: AND nvl( town_or_city, fnd_api.g_miss_char) =

1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =

Line 1911: nvl( p_ship_to_city, fnd_api.g_miss_char)

1907: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

Line 1912: AND nvl( state, fnd_api.g_miss_char) =

1908: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =

Line 1913: nvl( p_ship_to_state, fnd_api.g_miss_char)

1909: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =
1917: nvl( p_ship_to_country, fnd_api.g_miss_char)

Line 1914: AND nvl( postal_code, fnd_api.g_miss_char) =

1910: AND nvl( town_or_city, fnd_api.g_miss_char) =
1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =
1917: nvl( p_ship_to_country, fnd_api.g_miss_char)
1918: AND STATUS = 'A';

Line 1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)

1911: nvl( p_ship_to_city, fnd_api.g_miss_char)
1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =
1917: nvl( p_ship_to_country, fnd_api.g_miss_char)
1918: AND STATUS = 'A';
1919: BEGIN

Line 1916: AND nvl( country, fnd_api.g_miss_char) =

1912: AND nvl( state, fnd_api.g_miss_char) =
1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =
1917: nvl( p_ship_to_country, fnd_api.g_miss_char)
1918: AND STATUS = 'A';
1919: BEGIN
1920:

Line 1917: nvl( p_ship_to_country, fnd_api.g_miss_char)

1913: nvl( p_ship_to_state, fnd_api.g_miss_char)
1914: AND nvl( postal_code, fnd_api.g_miss_char) =
1915: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
1916: AND nvl( country, fnd_api.g_miss_char) =
1917: nvl( p_ship_to_country, fnd_api.g_miss_char)
1918: AND STATUS = 'A';
1919: BEGIN
1920:
1921: IF p_ship_to_address1 IS NULL

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

1942: SELECT ORGANIZATION_ID
1943: INTO l_id
1944: FROM OE_SHIP_TO_ORGS_V
1945: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1946: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1948: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1949: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1950: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1943: INTO l_id
1944: FROM OE_SHIP_TO_ORGS_V
1945: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1946: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1948: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1949: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1950: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1951: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1944: FROM OE_SHIP_TO_ORGS_V
1945: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1946: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1948: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1949: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1950: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1951: DECODE(STATE, NULL, NULL, STATE || ', ')||
1952: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1949: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1945: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1946: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1948: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1949: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1950: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1951: DECODE(STATE, NULL, NULL, STATE || ', ')||
1952: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1953: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1954: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1950: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1951: DECODE(STATE, NULL, NULL, STATE || ', ')||
1952: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1953: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1954: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1955: AND STATUS = 'A'
1956: AND CUSTOMER_ID = p_sold_to_org_id;
1957: END IF;
1958: CLOSE c_ship_to_org_id;

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

1971: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1972: INTO l_id
1973: FROM OE_SHIP_TO_ORGS_V
1974: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1975: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1977: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1978: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1979: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)

1972: INTO l_id
1973: FROM OE_SHIP_TO_ORGS_V
1974: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1975: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1977: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1978: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1979: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1980: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

1973: FROM OE_SHIP_TO_ORGS_V
1974: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1975: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1977: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1978: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1979: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1980: DECODE(STATE, NULL, NULL, STATE || ', ')||
1981: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 1978: nvl( p_ship_to_address3, fnd_api.g_miss_char)

1974: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1975: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1977: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1978: nvl( p_ship_to_address3, fnd_api.g_miss_char)
1979: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1980: DECODE(STATE, NULL, NULL, STATE || ', ')||
1981: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1982: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 1983: nvl( p_ship_to_address4, fnd_api.g_miss_char)

1979: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1980: DECODE(STATE, NULL, NULL, STATE || ', ')||
1981: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1982: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1983: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1984: AND STATUS = 'A'
1985: AND CUSTOMER_ID
1986: in (
1987: SELECT p_sold_to_org_id FROM DUAL

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

2008: SELECT ORGANIZATION_ID
2009: INTO l_id
2010: FROM OE_SHIP_TO_ORGS_V
2011: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2012: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2014: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2015: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2016: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)

2009: INTO l_id
2010: FROM OE_SHIP_TO_ORGS_V
2011: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2012: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2014: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2015: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2016: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2017: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

2010: FROM OE_SHIP_TO_ORGS_V
2011: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2012: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2014: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2015: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2016: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2017: DECODE(STATE, NULL, NULL, STATE || ', ')||
2018: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 2015: nvl( p_ship_to_address3, fnd_api.g_miss_char)

2011: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2012: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2014: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2015: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2016: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2017: DECODE(STATE, NULL, NULL, STATE || ', ')||
2018: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2019: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 2020: nvl( p_ship_to_address4, fnd_api.g_miss_char)

2016: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2017: DECODE(STATE, NULL, NULL, STATE || ', ')||
2018: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2019: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2020: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2021: AND STATUS = 'A';
2022: END IF;
2023: CLOSE C2;
2024:

Line 2043: RETURN FND_API.G_MISS_NUM;

2039: OE_MSG_PUB.Add;
2040:
2041: END IF;
2042:
2043: RETURN FND_API.G_MISS_NUM;
2044:
2045: WHEN OTHERS THEN
2046:
2047: IF c_ship_to_org_id%ISOPEN then

Line 2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2055: , 'Ship_To_Org'
2056: );
2057: END IF;
2058:
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060:
2061: END Ship_To_Org;
2062:
2063: -- Sold_To_Contact (Done aksingh)

Line 2106: RETURN FND_API.G_MISS_NUM;

2102: OE_MSG_PUB.Add;
2103:
2104: END IF;
2105:
2106: RETURN FND_API.G_MISS_NUM;
2107:
2108: WHEN OTHERS THEN
2109:
2110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2114: , 'Sold_To_Contact'
2115: );
2116: END IF;
2117:
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2119:
2120: END Sold_To_Contact;
2121:
2122: -- Sold_To_Org (Done aksingh)

Line 2132: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char

2128: IS
2129: l_id NUMBER;
2130: BEGIN
2131:
2132: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char
2133: AND nvl(p_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2134: THEN
2135: RETURN NULL;
2136: END IF;

Line 2133: AND nvl(p_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char

2129: l_id NUMBER;
2130: BEGIN
2131:
2132: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char
2133: AND nvl(p_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2134: THEN
2135: RETURN NULL;
2136: END IF;
2137:

Line 2138: IF nvl(p_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

2134: THEN
2135: RETURN NULL;
2136: END IF;
2137:
2138: IF nvl(p_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2139:
2140: SELECT ORGANIZATION_ID
2141: INTO l_id
2142: FROM OE_SOLD_TO_ORGS_V

Line 2174: RETURN FND_API.G_MISS_NUM;

2170: OE_MSG_PUB.Add;
2171:
2172: END IF;
2173:
2174: RETURN FND_API.G_MISS_NUM;
2175:
2176: WHEN OTHERS THEN
2177:
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2182: , 'Sold_To_Org'
2183: );
2184: END IF;
2185:
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187:
2188: END Sold_To_Org;
2189:
2190: -- Tax_Exempt (Done aksingh)

Line 2227: RETURN FND_API.G_MISS_CHAR;

2223: OE_MSG_PUB.Add;
2224:
2225: END IF;
2226:
2227: RETURN FND_API.G_MISS_CHAR;
2228:
2229: WHEN OTHERS THEN
2230:
2231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2235: , 'Tax_Exempt'
2236: );
2237: END IF;
2238:
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240:
2241: END Tax_Exempt;
2242:
2243: -- Tax_Exempt_Reason (Done aksingh)

Line 2280: RETURN FND_API.G_MISS_CHAR;

2276: OE_MSG_PUB.Add;
2277:
2278: END IF;
2279:
2280: RETURN FND_API.G_MISS_CHAR;
2281:
2282: WHEN OTHERS THEN
2283:
2284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2288: , 'Tax_Exempt_Reason'
2289: );
2290: END IF;
2291:
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293:
2294: END Tax_Exempt_Reason;
2295:
2296: -- Tax_Point (Done aksingh)

Line 2332: RETURN FND_API.G_MISS_CHAR;

2328: OE_MSG_PUB.Add;
2329:
2330: END IF;
2331:
2332: RETURN FND_API.G_MISS_CHAR;
2333:
2334: WHEN OTHERS THEN
2335:
2336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2340: , 'Tax_Point'
2341: );
2342: END IF;
2343:
2344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2345:
2346: END Tax_Point;
2347:
2348: -- Discount (Done aksingh)

Line 2382: RETURN FND_API.G_MISS_NUM;

2378: OE_MSG_PUB.Add;
2379:
2380: END IF;
2381:
2382: RETURN FND_API.G_MISS_NUM;
2383:
2384: WHEN OTHERS THEN
2385:
2386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2390: , 'Discount'
2391: );
2392: END IF;
2393:
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395:
2396: END Discount;
2397:
2398: -- Sales_Credit_type (Done aksingh)

Line 2431: RETURN FND_API.G_MISS_NUM;

2427: OE_MSG_PUB.Add;
2428:
2429: END IF;
2430:
2431: RETURN FND_API.G_MISS_NUM;
2432:
2433: WHEN OTHERS THEN
2434:
2435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2439: , 'sales_credit_type'
2440: );
2441: END IF;
2442:
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444:
2445: END sales_credit_type;
2446:
2447: -- Salesrep (Done aksingh)

Line 2481: RETURN FND_API.G_MISS_NUM;

2477: OE_MSG_PUB.Add;
2478:
2479: END IF;
2480:
2481: RETURN FND_API.G_MISS_NUM;
2482:
2483: WHEN OTHERS THEN
2484:
2485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2489: , 'Salesrep'
2490: );
2491: END IF;
2492:
2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494:
2495: END Salesrep;
2496:
2497: -- Demand_Bucket_Type (Done aksingh)

Line 2531: RETURN FND_API.G_MISS_CHAR;

2527: OE_MSG_PUB.Add;
2528:
2529: END IF;
2530:
2531: RETURN FND_API.G_MISS_CHAR;
2532:
2533: WHEN OTHERS THEN
2534:
2535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2539: , 'Demand_Bucket_Type'
2540: );
2541: END IF;
2542:
2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544:
2545: END Demand_Bucket_Type;
2546:
2547: -- Inventory_Item

Line 2585: RETURN FND_API.G_MISS_NUM;

2581: OE_MSG_PUB.Add;
2582:
2583: END IF;
2584:
2585: RETURN FND_API.G_MISS_NUM;
2586:
2587: WHEN OTHERS THEN
2588:
2589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2593: , 'Inventory_Item'
2594: );
2595: END IF;
2596:
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598:
2599: END Inventory_Item;
2600:
2601: -- Item_Type (Done aksingh)

Line 2635: RETURN FND_API.G_MISS_CHAR;

2631: OE_MSG_PUB.Add;
2632:
2633: END IF;
2634:
2635: RETURN FND_API.G_MISS_CHAR;
2636:
2637: WHEN OTHERS THEN
2638:
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2643: , 'Item_Type'
2644: );
2645: END IF;
2646:
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648:
2649: END Item_Type;
2650:
2651: -- Line_Type (Done aksingh)

Line 2685: RETURN FND_API.G_MISS_NUM;

2681: OE_MSG_PUB.Add;
2682:
2683: END IF;
2684:
2685: RETURN FND_API.G_MISS_NUM;
2686:
2687: WHEN OTHERS THEN
2688:
2689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2693: , 'Line_Type'
2694: );
2695: END IF;
2696:
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698:
2699: END Line_Type;
2700:
2701: -- Project (Done aksingh -- no code)

Line 2735: RETURN FND_API.G_MISS_NUM;

2731: OE_MSG_PUB.Add;
2732:
2733: END IF;
2734:
2735: RETURN FND_API.G_MISS_NUM;
2736:
2737: WHEN OTHERS THEN
2738:
2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2743: , 'Project'
2744: );
2745: END IF;
2746:
2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748:
2749: END Project;
2750:
2751: -- Rla_Schedule_Type (Done aksingh)

Line 2785: RETURN FND_API.G_MISS_CHAR;

2781: OE_MSG_PUB.Add;
2782:
2783: END IF;
2784:
2785: RETURN FND_API.G_MISS_CHAR;
2786:
2787: WHEN OTHERS THEN
2788:
2789: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2793: , 'Rla_Schedule_Type'
2794: );
2795: END IF;
2796:
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798:
2799: END Rla_Schedule_Type;
2800:
2801: -- Task (Done aksingh -- no code)

Line 2835: RETURN FND_API.G_MISS_NUM;

2831: OE_MSG_PUB.Add;
2832:
2833: END IF;
2834:
2835: RETURN FND_API.G_MISS_NUM;
2836:
2837: WHEN OTHERS THEN
2838:
2839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2843: , 'Task'
2844: );
2845: END IF;
2846:
2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2848:
2849: END Task;
2850:
2851: -- Over_Ship_Reason (Done aksingh)

Line 2884: RETURN FND_API.G_MISS_CHAR;

2880: OE_MSG_PUB.Add;
2881:
2882: END IF;
2883:
2884: RETURN FND_API.G_MISS_CHAR;
2885:
2886: WHEN OTHERS THEN
2887:
2888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2892: , 'Over_Ship_reason'
2893: );
2894: END IF;
2895:
2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2897:
2898: END Over_Ship_reason;
2899:
2900: -- (Done aksingh)

Line 2935: RETURN FND_API.G_MISS_CHAR;

2931: OE_MSG_PUB.Add;
2932:
2933: END IF;
2934:
2935: RETURN FND_API.G_MISS_CHAR;
2936:
2937: WHEN OTHERS THEN
2938:
2939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2943: , 'Return_Reason'
2944: );
2945: END IF;
2946:
2947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2948:
2949: END Return_Reason;
2950:
2951: -- (Done aksingh)

Line 2984: RETURN FND_API.G_MISS_NUM;

2980: OE_MSG_PUB.Add;
2981:
2982: END IF;
2983:
2984: RETURN FND_API.G_MISS_NUM;
2985:
2986: WHEN OTHERS THEN
2987:
2988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2992: , 'Veh_Cus_Item_cum_Key'
2993: );
2994: END IF;
2995:
2996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2997:
2998: END Veh_Cus_Item_cum_Key;
2999:
3000: -- Payment_Type (Done aksingh)

Line 3036: RETURN FND_API.G_MISS_CHAR;

3032: OE_MSG_PUB.Add;
3033:
3034: END IF;
3035:
3036: RETURN FND_API.G_MISS_CHAR;
3037:
3038: WHEN OTHERS THEN
3039:
3040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3044: , 'Payment_Type'
3045: );
3046: END IF;
3047:
3048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3049:
3050: END Payment_Type;
3051:
3052: -- Credit_Card (Done aksingh)

Line 3088: RETURN FND_API.G_MISS_CHAR;

3084: OE_MSG_PUB.Add;
3085:
3086: END IF;
3087:
3088: RETURN FND_API.G_MISS_CHAR;
3089:
3090: WHEN OTHERS THEN
3091:
3092: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3096: , 'Credit_Card'
3097: );
3098: END IF;
3099:
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101:
3102: END Credit_Card;
3103:
3104:

Line 3151: RETURN FND_API.G_MISS_CHAR;

3147: OE_MSG_PUB.Add;
3148:
3149: END IF;
3150:
3151: RETURN FND_API.G_MISS_CHAR;
3152:
3153: WHEN OTHERS THEN
3154:
3155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3159: , 'Currency'
3160: );
3161: END IF;
3162:
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164:
3165: END Currency;
3166:
3167:

Line 3202: RETURN FND_API.G_MISS_CHAR;

3198: OE_MSG_PUB.Add;
3199:
3200: END IF;
3201:
3202: RETURN FND_API.G_MISS_CHAR;
3203:
3204: WHEN OTHERS THEN
3205:
3206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3210: , 'Agreement_Contact'
3211: );
3212: END IF;
3213:
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215:
3216: END Agreement_Contact;
3217:
3218: -- Agreement_Type

Line 3252: RETURN FND_API.G_MISS_CHAR;

3248: OE_MSG_PUB.Add;
3249:
3250: END IF;
3251:
3252: RETURN FND_API.G_MISS_CHAR;
3253:
3254: WHEN OTHERS THEN
3255:
3256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3260: , 'Agreement_Type'
3261: );
3262: END IF;
3263:
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265:
3266: END Agreement_Type;
3267:
3268: -- Customer

Line 3302: RETURN FND_API.G_MISS_CHAR;

3298: OE_MSG_PUB.Add;
3299:
3300: END IF;
3301:
3302: RETURN FND_API.G_MISS_CHAR;
3303:
3304: WHEN OTHERS THEN
3305:
3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3310: , 'Customer'
3311: );
3312: END IF;
3313:
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315:
3316: END Customer;
3317:
3318: -- Invoice_Contact

Line 3352: RETURN FND_API.G_MISS_CHAR;

3348: OE_MSG_PUB.Add;
3349:
3350: END IF;
3351:
3352: RETURN FND_API.G_MISS_CHAR;
3353:
3354: WHEN OTHERS THEN
3355:
3356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3360: , 'Invoice_Contact'
3361: );
3362: END IF;
3363:
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365:
3366: END Invoice_Contact;
3367:
3368: -- Invoice_To_Site_Use

Line 3402: RETURN FND_API.G_MISS_CHAR;

3398: OE_MSG_PUB.Add;
3399:
3400: END IF;
3401:
3402: RETURN FND_API.G_MISS_CHAR;
3403:
3404: WHEN OTHERS THEN
3405:
3406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3410: , 'Invoice_To_Site_Use'
3411: );
3412: END IF;
3413:
3414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3415:
3416: END Invoice_To_Site_Use;
3417:
3418: -- Override_Arule

Line 3452: RETURN FND_API.G_MISS_CHAR;

3448: OE_MSG_PUB.Add;
3449:
3450: END IF;
3451:
3452: RETURN FND_API.G_MISS_CHAR;
3453:
3454: WHEN OTHERS THEN
3455:
3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3460: , 'Override_Arule'
3461: );
3462: END IF;
3463:
3464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3465:
3466: END Override_Arule;
3467:
3468: -- Override_Irule

Line 3502: RETURN FND_API.G_MISS_CHAR;

3498: OE_MSG_PUB.Add;
3499:
3500: END IF;
3501:
3502: RETURN FND_API.G_MISS_CHAR;
3503:
3504: WHEN OTHERS THEN
3505:
3506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3510: , 'Override_Irule'
3511: );
3512: END IF;
3513:
3514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3515:
3516: END Override_Irule;
3517:
3518: -- Revision_Reason

Line 3552: RETURN FND_API.G_MISS_CHAR;

3548: OE_MSG_PUB.Add;
3549:
3550: END IF;
3551:
3552: RETURN FND_API.G_MISS_CHAR;
3553:
3554: WHEN OTHERS THEN
3555:
3556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3560: , 'Revision_Reason'
3561: );
3562: END IF;
3563:
3564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3565:
3566: END Revision_Reason;
3567:
3568: -- Ship_Method (Done aksingh)

Line 3603: RETURN FND_API.G_MISS_CHAR;

3599: OE_MSG_PUB.Add;
3600:
3601: END IF;
3602:
3603: RETURN FND_API.G_MISS_CHAR;
3604:
3605: WHEN OTHERS THEN
3606:
3607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3611: , 'Ship_Method'
3612: );
3613: END IF;
3614:
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3616:
3617: END Ship_Method;
3618:
3619: -- Term

Line 3653: RETURN FND_API.G_MISS_CHAR;

3649: OE_MSG_PUB.Add;
3650:
3651: END IF;
3652:
3653: RETURN FND_API.G_MISS_CHAR;
3654:
3655: WHEN OTHERS THEN
3656:
3657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3661: , 'Term'
3662: );
3663: END IF;
3664:
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666:
3667: END Term;
3668:
3669: -- Secondary_Price_List

Line 3703: RETURN FND_API.G_MISS_NUM;

3699: OE_MSG_PUB.Add;
3700:
3701: END IF;
3702:
3703: RETURN FND_API.G_MISS_NUM;
3704:
3705: WHEN OTHERS THEN
3706:
3707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3711: , 'Secondary_Price_List'
3712: );
3713: END IF;
3714:
3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3716:
3717: END Secondary_Price_List;
3718:
3719: -- Terms

Line 3753: RETURN FND_API.G_MISS_NUM;

3749: OE_MSG_PUB.Add;
3750:
3751: END IF;
3752:
3753: RETURN FND_API.G_MISS_NUM;
3754:
3755: WHEN OTHERS THEN
3756:
3757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3761: , 'Terms'
3762: );
3763: END IF;
3764:
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766:
3767: END Terms;
3768:
3769: -- Automatic_Discount

Line 3803: RETURN FND_API.G_MISS_CHAR;

3799: OE_MSG_PUB.Add;
3800:
3801: END IF;
3802:
3803: RETURN FND_API.G_MISS_CHAR;
3804:
3805: WHEN OTHERS THEN
3806:
3807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3811: , 'Automatic_Discount'
3812: );
3813: END IF;
3814:
3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3816:
3817: END Automatic_Discount;
3818:
3819: -- Discount_Lines

Line 3853: RETURN FND_API.G_MISS_CHAR;

3849: OE_MSG_PUB.Add;
3850:
3851: END IF;
3852:
3853: RETURN FND_API.G_MISS_CHAR;
3854:
3855: WHEN OTHERS THEN
3856:
3857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3861: , 'Discount_Lines'
3862: );
3863: END IF;
3864:
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866:
3867: END Discount_Lines;
3868:
3869: -- Discount_Type

Line 3903: RETURN FND_API.G_MISS_CHAR;

3899: OE_MSG_PUB.Add;
3900:
3901: END IF;
3902:
3903: RETURN FND_API.G_MISS_CHAR;
3904:
3905: WHEN OTHERS THEN
3906:
3907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3911: , 'Discount_Type'
3912: );
3913: END IF;
3914:
3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3916:
3917: END Discount_Type;
3918:
3919: -- Manual_Discount

Line 3953: RETURN FND_API.G_MISS_CHAR;

3949: OE_MSG_PUB.Add;
3950:
3951: END IF;
3952:
3953: RETURN FND_API.G_MISS_CHAR;
3954:
3955: WHEN OTHERS THEN
3956:
3957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3961: , 'Manual_Discount'
3962: );
3963: END IF;
3964:
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966:
3967: END Manual_Discount;
3968:
3969: -- Override_Allowed

Line 4003: RETURN FND_API.G_MISS_CHAR;

3999: OE_MSG_PUB.Add;
4000:
4001: END IF;
4002:
4003: RETURN FND_API.G_MISS_CHAR;
4004:
4005: WHEN OTHERS THEN
4006:
4007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4011: , 'Override_Allowed'
4012: );
4013: END IF;
4014:
4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4016:
4017: END Override_Allowed;
4018:
4019: -- Prorate

Line 4053: RETURN FND_API.G_MISS_CHAR;

4049: OE_MSG_PUB.Add;
4050:
4051: END IF;
4052:
4053: RETURN FND_API.G_MISS_CHAR;
4054:
4055: WHEN OTHERS THEN
4056:
4057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4061: , 'Prorate'
4062: );
4063: END IF;
4064:
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4066:
4067: END Prorate;
4068:
4069:

Line 4104: RETURN FND_API.G_MISS_CHAR;

4100: OE_MSG_PUB.Add;
4101:
4102: END IF;
4103:
4104: RETURN FND_API.G_MISS_CHAR;
4105:
4106: WHEN OTHERS THEN
4107:
4108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4112: , 'Method'
4113: );
4114: END IF;
4115:
4116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4117:
4118: END Method;
4119:
4120: -- Price_List_Line

Line 4154: RETURN FND_API.G_MISS_NUM;

4150: OE_MSG_PUB.Add;
4151:
4152: END IF;
4153:
4154: RETURN FND_API.G_MISS_NUM;
4155:
4156: WHEN OTHERS THEN
4157:
4158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4162: , 'Price_List_Line'
4163: );
4164: END IF;
4165:
4166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4167:
4168: END Price_List_Line;
4169:
4170: -- Pricing_Rule

Line 4204: RETURN FND_API.G_MISS_NUM;

4200: OE_MSG_PUB.Add;
4201:
4202: END IF;
4203:
4204: RETURN FND_API.G_MISS_NUM;
4205:
4206: WHEN OTHERS THEN
4207:
4208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4212: , 'Pricing_Rule'
4213: );
4214: END IF;
4215:
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217:
4218: END Pricing_Rule;
4219:
4220: -- Reprice

Line 4254: RETURN FND_API.G_MISS_CHAR;

4250: OE_MSG_PUB.Add;
4251:
4252: END IF;
4253:
4254: RETURN FND_API.G_MISS_CHAR;
4255:
4256: WHEN OTHERS THEN
4257:
4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4262: , 'Reprice'
4263: );
4264: END IF;
4265:
4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4267:
4268: END Reprice;
4269:
4270: -- Unit

Line 4304: RETURN FND_API.G_MISS_CHAR;

4300: OE_MSG_PUB.Add;
4301:
4302: END IF;
4303:
4304: RETURN FND_API.G_MISS_CHAR;
4305:
4306: WHEN OTHERS THEN
4307:
4308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4312: , 'Unit'
4313: );
4314: END IF;
4315:
4316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4317:
4318: END Unit;
4319:
4320: -- Customer_Class

Line 4354: RETURN FND_API.G_MISS_CHAR;

4350: OE_MSG_PUB.Add;
4351:
4352: END IF;
4353:
4354: RETURN FND_API.G_MISS_CHAR;
4355:
4356: WHEN OTHERS THEN
4357:
4358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4362: , 'Customer_Class'
4363: );
4364: END IF;
4365:
4366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4367:
4368: END Customer_Class;
4369:
4370: -- Discount_Customer

Line 4404: RETURN FND_API.G_MISS_NUM;

4400: OE_MSG_PUB.Add;
4401:
4402: END IF;
4403:
4404: RETURN FND_API.G_MISS_NUM;
4405:
4406: WHEN OTHERS THEN
4407:
4408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4412: , 'Discount_Customer'
4413: );
4414: END IF;
4415:
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417:
4418: END Discount_Customer;
4419:
4420: -- Site_Use

Line 4454: RETURN FND_API.G_MISS_NUM;

4450: OE_MSG_PUB.Add;
4451:
4452: END IF;
4453:
4454: RETURN FND_API.G_MISS_NUM;
4455:
4456: WHEN OTHERS THEN
4457:
4458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4462: , 'Site_Use'
4463: );
4464: END IF;
4465:
4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4467:
4468: END Site_Use;
4469:
4470: -- Entity

Line 4504: RETURN FND_API.G_MISS_NUM;

4500: OE_MSG_PUB.Add;
4501:
4502: END IF;
4503:
4504: RETURN FND_API.G_MISS_NUM;
4505:
4506: WHEN OTHERS THEN
4507:
4508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4512: , 'Entity'
4513: );
4514: END IF;
4515:
4516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4517:
4518: END Entity;
4519:
4520: -- Method_Type

Line 4554: RETURN FND_API.G_MISS_CHAR;

4550: OE_MSG_PUB.Add;
4551:
4552: END IF;
4553:
4554: RETURN FND_API.G_MISS_CHAR;
4555:
4556: WHEN OTHERS THEN
4557:
4558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4562: , 'Method_Type'
4563: );
4564: END IF;
4565:
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567:
4568: END Method_Type;
4569:
4570: /* Pricing Contract Functions : End */

Line 4606: RETURN FND_API.G_MISS_NUM;

4602: OE_MSG_PUB.Add;
4603:
4604: END IF;
4605:
4606: RETURN FND_API.G_MISS_NUM;
4607:
4608: WHEN OTHERS THEN
4609:
4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4614: , 'Lot_Serial'
4615: );
4616: END IF;
4617:
4618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4619:
4620: END Lot_Serial;
4621:
4622: -- Appear_On_Ack

Line 4656: RETURN FND_API.G_MISS_CHAR;

4652: OE_MSG_PUB.Add;
4653:
4654: END IF;
4655:
4656: RETURN FND_API.G_MISS_CHAR;
4657:
4658: WHEN OTHERS THEN
4659:
4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4664: , 'Appear_On_Ack'
4665: );
4666: END IF;
4667:
4668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4669:
4670: END Appear_On_Ack;
4671:
4672: -- Appear_On_Invoice

Line 4706: RETURN FND_API.G_MISS_CHAR;

4702: OE_MSG_PUB.Add;
4703:
4704: END IF;
4705:
4706: RETURN FND_API.G_MISS_CHAR;
4707:
4708: WHEN OTHERS THEN
4709:
4710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4714: , 'Appear_On_Invoice'
4715: );
4716: END IF;
4717:
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719:
4720: END Appear_On_Invoice;
4721:
4722: -- Charge

Line 4756: RETURN FND_API.G_MISS_NUM;

4752: OE_MSG_PUB.Add;
4753:
4754: END IF;
4755:
4756: RETURN FND_API.G_MISS_NUM;
4757:
4758: WHEN OTHERS THEN
4759:
4760: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4764: , 'Charge'
4765: );
4766: END IF;
4767:
4768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4769:
4770: END Charge;
4771:
4772: -- Charge_Type

Line 4806: RETURN FND_API.G_MISS_NUM;

4802: OE_MSG_PUB.Add;
4803:
4804: END IF;
4805:
4806: RETURN FND_API.G_MISS_NUM;
4807:
4808: WHEN OTHERS THEN
4809:
4810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4814: , 'Charge_Type'
4815: );
4816: END IF;
4817:
4818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4819:
4820: END Charge_Type;
4821:
4822: -- Cost_Or_Charge

Line 4856: RETURN FND_API.G_MISS_CHAR;

4852: OE_MSG_PUB.Add;
4853:
4854: END IF;
4855:
4856: RETURN FND_API.G_MISS_CHAR;
4857:
4858: WHEN OTHERS THEN
4859:
4860: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4864: , 'Cost_Or_Charge'
4865: );
4866: END IF;
4867:
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869:
4870: END Cost_Or_Charge;
4871:
4872: -- Departure

Line 4906: RETURN FND_API.G_MISS_NUM;

4902: OE_MSG_PUB.Add;
4903:
4904: END IF;
4905:
4906: RETURN FND_API.G_MISS_NUM;
4907:
4908: WHEN OTHERS THEN
4909:
4910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4914: , 'Departure'
4915: );
4916: END IF;
4917:
4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4919:
4920: END Departure;
4921:
4922: -- Estimated

Line 4956: RETURN FND_API.G_MISS_CHAR;

4952: OE_MSG_PUB.Add;
4953:
4954: END IF;
4955:
4956: RETURN FND_API.G_MISS_CHAR;
4957:
4958: WHEN OTHERS THEN
4959:
4960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4964: , 'Estimated'
4965: );
4966: END IF;
4967:
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969:
4970: END Estimated;
4971:
4972: -- Invoiced

Line 5006: RETURN FND_API.G_MISS_CHAR;

5002: OE_MSG_PUB.Add;
5003:
5004: END IF;
5005:
5006: RETURN FND_API.G_MISS_CHAR;
5007:
5008: WHEN OTHERS THEN
5009:
5010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5014: , 'Invoiced'
5015: );
5016: END IF;
5017:
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019:
5020: END Invoiced;
5021:
5022: -- Parent_Charge

Line 5056: RETURN FND_API.G_MISS_NUM;

5052: OE_MSG_PUB.Add;
5053:
5054: END IF;
5055:
5056: RETURN FND_API.G_MISS_NUM;
5057:
5058: WHEN OTHERS THEN
5059:
5060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5064: , 'Parent_Charge'
5065: );
5066: END IF;
5067:
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069:
5070: END Parent_Charge;
5071:
5072: -- Returnable

Line 5106: RETURN FND_API.G_MISS_CHAR;

5102: OE_MSG_PUB.Add;
5103:
5104: END IF;
5105:
5106: RETURN FND_API.G_MISS_CHAR;
5107:
5108: WHEN OTHERS THEN
5109:
5110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5114: , 'Returnable'
5115: );
5116: END IF;
5117:
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119:
5120: END Returnable;
5121:
5122: -- Tax_Group

Line 5156: RETURN FND_API.G_MISS_CHAR;

5152: OE_MSG_PUB.Add;
5153:
5154: END IF;
5155:
5156: RETURN FND_API.G_MISS_CHAR;
5157:
5158: WHEN OTHERS THEN
5159:
5160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5164: , 'Tax_Group'
5165: );
5166: END IF;
5167:
5168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5169:
5170: END Tax_Group;
5171:
5172:

Line 5207: RETURN FND_API.G_MISS_CHAR;

5203: OE_MSG_PUB.Add;
5204:
5205: END IF;
5206:
5207: RETURN FND_API.G_MISS_CHAR;
5208:
5209: WHEN OTHERS THEN
5210:
5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5215: , 'Flow_Status'
5216: );
5217: END IF;
5218:
5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5220:
5221: END Flow_Status;
5222:
5223:

Line 5239: IF p_ship_from_org_id = FND_API.G_MISS_NUM THEN

5235: THEN
5236: RETURN NULL;
5237: END IF;
5238:
5239: IF p_ship_from_org_id = FND_API.G_MISS_NUM THEN
5240: l_ship_from_org_id := NULL;
5241: ELSE
5242: l_ship_from_org_id := p_ship_from_org_id;
5243: END IF;

Line 5266: RETURN FND_API.G_MISS_CHAR;

5262: OE_MSG_PUB.Add;
5263:
5264: END IF;
5265:
5266: RETURN FND_API.G_MISS_CHAR;
5267:
5268: WHEN OTHERS THEN
5269:
5270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5274: , 'Freight_Carrier'
5275: );
5276: END IF;
5277:
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5279:
5280: END Freight_Carrier;
5281:
5282: -- (Done aksingh)

Line 5317: RETURN FND_API.G_MISS_CHAR;

5313: OE_MSG_PUB.Add;
5314:
5315: END IF;
5316:
5317: RETURN FND_API.G_MISS_CHAR;
5318:
5319: WHEN OTHERS THEN
5320:
5321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5325: , 'Sales_Channel'
5326: );
5327: END IF;
5328:
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330:
5331: END Sales_Channel;
5332:
5333: FUNCTION Customer_Location

Line 5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

5353: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;
5354: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
5355: END IF;
5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

5354: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
5355: END IF;
5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5362: THEN

Line 5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char

5355: END IF;
5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5362: THEN
5363: RETURN NULL;

Line 5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char

5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5362: THEN
5363: RETURN NULL;
5364: END IF;

Line 5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5359: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5360: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5361: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5362: THEN
5363: RETURN NULL;
5364: END IF;
5365:

Line 5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =

5376: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
5377: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
5378: AND SITE.ORG_ID = ACCT_SITE.ORG_ID
5379: AND LOC.ADDRESS1 = p_sold_to_location_address1
5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =

Line 5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)

5377: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
5378: AND SITE.ORG_ID = ACCT_SITE.ORG_ID
5379: AND LOC.ADDRESS1 = p_sold_to_location_address1
5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)

Line 5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =

5378: AND SITE.ORG_ID = ACCT_SITE.ORG_ID
5379: AND LOC.ADDRESS1 = p_sold_to_location_address1
5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =

Line 5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)

5379: AND LOC.ADDRESS1 = p_sold_to_location_address1
5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)

Line 5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =

5380: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =

Line 5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)

5381: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)

Line 5386: AND nvl( LOC.city, fnd_api.g_miss_char) =

5382: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =

Line 5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)

5383: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)

Line 5388: AND nvl( LOC.state, fnd_api.g_miss_char) =

5384: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =

Line 5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)

5385: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =
5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)

Line 5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =

5386: AND nvl( LOC.city, fnd_api.g_miss_char) =
5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =
5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
5394: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id ;

Line 5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)

5387: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =
5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
5394: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id ;
5395:

Line 5392: AND nvl( LOC.country, fnd_api.g_miss_char) =

5388: AND nvl( LOC.state, fnd_api.g_miss_char) =
5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =
5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
5394: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id ;
5395:
5396: RETURN l_id;

Line 5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)

5389: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
5390: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
5391: nvl( p_sold_to_location_postal, fnd_api.g_miss_char)
5392: AND nvl( LOC.country, fnd_api.g_miss_char) =
5393: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
5394: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id ;
5395:
5396: RETURN l_id;
5397:

Line 5411: RETURN FND_API.G_MISS_NUM;

5407: OE_MSG_PUB.Add;
5408:
5409: END IF;
5410:
5411: RETURN FND_API.G_MISS_NUM;
5412:
5413: WHEN OTHERS THEN
5414:
5415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5419: , 'Customer_Location'
5420: );
5421: END IF;
5422:
5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5424:
5425: END Customer_Location;
5426:
5427: FUNCTION END_CUSTOMER

Line 5439: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char

5435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5436:
5437: BEGIN
5438: oe_Debug_pub.add('entereing end customer value to id in cancel order'||p_end_customer||p_end_customer_number);
5439: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
5440: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
5441: THEN
5442: RETURN NULL;
5443: END IF;

Line 5440: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char

5436:
5437: BEGIN
5438: oe_Debug_pub.add('entereing end customer value to id in cancel order'||p_end_customer||p_end_customer_number);
5439: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
5440: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
5441: THEN
5442: RETURN NULL;
5443: END IF;
5444:

Line 5445: IF nvl(p_end_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

5441: THEN
5442: RETURN NULL;
5443: END IF;
5444:
5445: IF nvl(p_end_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
5446: SELECT ORGANIZATION_ID
5447: INTO l_id
5448: FROM OE_SOLD_TO_ORGS_V
5449: WHERE CUSTOMER_NUMBER = p_end_customer_number;

Line 5476: RETURN FND_API.G_MISS_NUM;

5472: OE_MSG_PUB.Add;
5473:
5474: END IF;
5475:
5476: RETURN FND_API.G_MISS_NUM;
5477:
5478: WHEN OTHERS THEN
5479:
5480: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5484: , 'End_customer'
5485: );
5486: END IF;
5487:
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5489:
5490:
5491: END END_CUSTOMER;
5492:

Line 5528: RETURN FND_API.G_MISS_NUM;

5524: OE_MSG_PUB.Add;
5525:
5526: END IF;
5527:
5528: RETURN FND_API.G_MISS_NUM;
5529:
5530: WHEN OTHERS THEN
5531:
5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5536: , 'End_customer_contact'
5537: );
5538: END IF;
5539:
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5541:
5542: END END_CUSTOMER_CONTACT;
5543:
5544:

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

5572: and site_use.status='A'
5573: and acct_site.status='A' --bug 2752321
5574: and acct_site.cust_account_id=in_end_customer_id
5575: and loc.address1 = p_end_customer_site_address1
5576: and nvl( loc.address2, fnd_api.g_miss_char) =
5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =

Line 5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)

5573: and acct_site.status='A' --bug 2752321
5574: and acct_site.cust_account_id=in_end_customer_id
5575: and loc.address1 = p_end_customer_site_address1
5576: and nvl( loc.address2, fnd_api.g_miss_char) =
5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

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

5574: and acct_site.cust_account_id=in_end_customer_id
5575: and loc.address1 = p_end_customer_site_address1
5576: and nvl( loc.address2, fnd_api.g_miss_char) =
5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =

Line 5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)

5575: and loc.address1 = p_end_customer_site_address1
5576: and nvl( loc.address2, fnd_api.g_miss_char) =
5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)

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

5576: and nvl( loc.address2, fnd_api.g_miss_char) =
5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =

Line 5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

5577: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)

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

5578: and nvl( loc.address3, fnd_api.g_miss_char) =
5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =

Line 5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)

5579: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)

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

5580: and nvl( loc.address4, fnd_api.g_miss_char) =
5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =

Line 5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)

5581: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =
5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)

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

5582: and nvl( loc.city, fnd_api.g_miss_char) =
5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =
5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
5590: and site_use.site_use_code = in_end_customer_site_use_code;

Line 5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)

5583: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =
5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
5590: and site_use.site_use_code = in_end_customer_site_use_code;
5591:

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

5584: and nvl( loc.state, fnd_api.g_miss_char) =
5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =
5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
5590: and site_use.site_use_code = in_end_customer_site_use_code;
5591:
5592: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS

Line 5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)

5585: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
5586: and nvl( loc.postal_code, fnd_api.g_miss_char) =
5587: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
5588: and nvl( loc.country, fnd_api.g_miss_char) =
5589: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
5590: and site_use.site_use_code = in_end_customer_site_use_code;
5591:
5592: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5593: SELECT site_use.site_use_id

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

5595: hz_party_sites site,
5596: hz_cust_acct_sites acct_site,
5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5601: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
5602: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5603: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||

Line 5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)

5596: hz_cust_acct_sites acct_site,
5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5601: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
5602: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5603: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
5604: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||

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

5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5601: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
5602: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5603: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
5604: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
5605: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||

Line 5602: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)

5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
5601: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
5602: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
5603: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
5604: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
5605: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
5606: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =

Line 5607: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)

5603: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
5604: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
5605: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
5606: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =
5607: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
5608: AND site_use.status = 'A'
5609: AND acct_site.status ='A' --bug 2752321
5610: AND acct_site.cust_account_id = p_end_customer_id
5611: and site_use.site_use_code=in_end_customer_site_use_code

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

5625: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
5627: END IF;
5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5631: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5632: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5633: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

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

5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
5627: END IF;
5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5631: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5632: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5633: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5634: THEN

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

5627: END IF;
5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5631: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5632: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5633: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5634: THEN
5635: RETURN NULL;

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

5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5631: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5632: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5633: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5634: THEN
5635: RETURN NULL;
5636: END IF;

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

5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
5631: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
5632: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
5633: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
5634: THEN
5635: RETURN NULL;
5636: END IF;
5637:

Line 5773: RETURN FND_API.G_MISS_NUM;

5769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
5770: OE_MSG_PUB.Add;
5771:
5772: END IF;
5773: RETURN FND_API.G_MISS_NUM;
5774:
5775: WHEN OTHERS THEN
5776:
5777: IF c_site_use_id%ISOPEN then

Line 5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5789: , 'end_cstomer_site_id'
5790: );
5791: END IF;
5792:
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794:
5795: END END_CUSTOMER_SITE;
5796:
5797: FUNCTION IB_Owner

Line 5836: RETURN FND_API.G_MISS_CHAR;

5832: OE_MSG_PUB.Add;
5833:
5834: END IF;
5835:
5836: RETURN FND_API.G_MISS_CHAR;
5837:
5838: WHEN OTHERS THEN
5839:
5840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5844: , 'IB_Owner'
5845: );
5846: END IF;
5847:
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849:
5850: END IB_Owner;
5851:
5852: FUNCTION IB_Installed_At_Location

Line 5891: RETURN FND_API.G_MISS_CHAR;

5887: OE_MSG_PUB.Add;
5888:
5889: END IF;
5890:
5891: RETURN FND_API.G_MISS_CHAR;
5892:
5893: WHEN OTHERS THEN
5894:
5895: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5899: , 'ib_installed_at_location'
5900: );
5901: END IF;
5902:
5903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5904:
5905: END IB_Installed_At_Location;
5906:
5907: FUNCTION IB_Current_Location

Line 5946: RETURN FND_API.G_MISS_CHAR;

5942: OE_MSG_PUB.Add;
5943:
5944: END IF;
5945:
5946: RETURN FND_API.G_MISS_CHAR;
5947:
5948: WHEN OTHERS THEN
5949:
5950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5954: , 'ib_current_location'
5955: );
5956: END IF;
5957:
5958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5959:
5960: END IB_Current_Location;
5961:
5962: END OE_CNCL_Value_To_Id;