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

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40: END IF;
41: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Amount_Valid');
42: EXCEPTION
43: WHEN OTHERS THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END Is_Amount_Valid;
46:
47: --=====================================================================
48: -- NAME: Is_Currency_Valid

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: RETURN l_return_value;
91: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Currency_Valid');
92: EXCEPTION
93: WHEN OTHERS THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END Is_Currency_Valid;
96:
97: --=====================================================================
98: -- NAME: Get_Operating_Unit_ID

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
111: l_org_id NUMBER;
112: BEGIN
113: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Operating_Unit_ID');
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: --If the set is multi-org, then get the operating unit information, else
116: --return NULL for the org_id.
117: SELECT NVL(multi_org_flag, 'N')
118: INTO l_multi_org_flag

Line 124: IF p_org_id IS NOT NULL AND p_org_id<>FND_API.G_MISS_NUM THEN

120: --
121: --If both the ou name and org ID are provided, the ou name will be ignored.
122: --
123: IF l_multi_org_flag = 'Y' THEN
124: IF p_org_id IS NOT NULL AND p_org_id<>FND_API.G_MISS_NUM THEN
125: BEGIN
126: SELECT organization_id
127: INTO l_org_id
128: FROM hr_operating_units

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: WHERE organization_id = p_org_id;
130: x_org_id := p_org_id;
131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_ID_INVALID');
135: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);
137: OE_MSG_PUB.Add;

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);
137: OE_MSG_PUB.Add;
138: END;
139: ELSIF p_org_id IS NULL THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
142: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
143: OE_MSG_PUB.Add;
144: ELSIF p_operating_unit_name IS NOT NULL AND

Line 145: p_operating_unit_name <> FND_API.G_MISS_CHAR THEN

141: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
142: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
143: OE_MSG_PUB.Add;
144: ELSIF p_operating_unit_name IS NOT NULL AND
145: p_operating_unit_name <> FND_API.G_MISS_CHAR THEN
146: BEGIN
147: SELECT organization_id
148: INTO l_org_id
149: FROM hr_operating_units

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: WHERE name = p_operating_unit_name;
151: x_org_id := l_org_id;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_NAME_INVALID');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME');
157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );
158: OE_MSG_PUB.Add;

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );
158: OE_MSG_PUB.Add;
159: END;
160: ELSIF p_operating_unit_name IS NULL THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );
164: OE_MSG_PUB.Add;
165: ELSE

Line 166: x_return_status := FND_API.G_RET_STS_ERROR;

162: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );
164: OE_MSG_PUB.Add;
165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');
168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );
169: FND_MESSAGE.SET_TOKEN ('P_ORG_ID', 'P_ORG_ID' );
170: OE_MSG_PUB.Add;

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Operating_Unit_ID');
176: EXCEPTION
177: WHEN OTHERS THEN
178: OE_DEBUG_PUB.Add('Get_Operating_Unit_ID: Unexpected Error');
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END Get_Operating_Unit_ID;
181:
182: --=====================================================================
183: -- NAME: Get_Credit_Check_Rule_ID

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS;

200: l_check_item_categories_flag
201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;
202: BEGIN
203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: IF p_credit_check_rule_id IS NOT NULL AND
206: p_credit_check_rule_id <> FND_API.G_MISS_NUM THEN
207: BEGIN
208: SELECT credit_check_rule_id,

Line 206: p_credit_check_rule_id <> FND_API.G_MISS_NUM THEN

202: BEGIN
203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: IF p_credit_check_rule_id IS NOT NULL AND
206: p_credit_check_rule_id <> FND_API.G_MISS_NUM THEN
207: BEGIN
208: SELECT credit_check_rule_id,
209: name,
210: credit_check_level_code,

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: FROM oe_credit_check_rules
217: WHERE credit_check_rule_id = p_credit_check_rule_id;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_ID_INVALID');
222: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID');
223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );
224: OE_MSG_PUB.Add;

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );
224: OE_MSG_PUB.Add;
225: END;
226: ELSIF p_credit_check_rule_id IS NULL THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID' );
230: OE_MSG_PUB.Add;
231: ELSIF p_credit_check_rule_name IS NOT NULL AND

Line 232: p_credit_check_rule_name <> FND_API.G_MISS_CHAR THEN

228: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID' );
230: OE_MSG_PUB.Add;
231: ELSIF p_credit_check_rule_name IS NOT NULL AND
232: p_credit_check_rule_name <> FND_API.G_MISS_CHAR THEN
233: BEGIN
234: SELECT credit_check_rule_id,
235: name,
236: credit_check_level_code,

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242: FROM oe_credit_check_rules
243: WHERE name = p_credit_check_rule_name;
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_NAME_INVALID');
248: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );
250: OE_MSG_PUB.Add;

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );
250: OE_MSG_PUB.Add;
251: END;
252: ELSIF p_credit_check_rule_name IS NULL THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
256: OE_MSG_PUB.Add;
257: ELSE

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
256: OE_MSG_PUB.Add;
257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');
260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );
261: FND_MESSAGE.SET_TOKEN ('P_CCR_ID', 'P_CREDIT_CHECK_RULE_ID' );
262: OE_MSG_PUB.Add;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);
271: IF l_credit_check_rule_id IS NOT NULL THEN
272: IF NVL(l_credit_check_level_code, 'ORDER') <> 'ORDER' OR
273: NVL(l_check_item_categories_flag,'N') <> 'N' THEN
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INVALID');
276: FND_MESSAGE.Set_Token('CCR_NAME', l_credit_check_rule_name);
277: FND_MESSAGE.Set_Token('API_NAME', 'Check_External_Credit');
278: OE_MSG_PUB.Add;

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: END IF;
283: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Credit_Check_Rule_ID');
284: EXCEPTION
285: WHEN OTHERS THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END Get_Credit_Check_Rule_ID;
288:
289: --=====================================================================
290: -- NAME: Address_Value_To_ID

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

308: CURSOR c_bill_to_site_use_id IS
309: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
310: FROM OE_INVOICE_TO_ORGS_V
311: WHERE ADDRESS_LINE_1 = p_bill_to_address1
312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 313: nvl( p_bill_to_address2, fnd_api.g_miss_char)

309: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
310: FROM OE_INVOICE_TO_ORGS_V
311: WHERE ADDRESS_LINE_1 = p_bill_to_address1
312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)

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

310: FROM OE_INVOICE_TO_ORGS_V
311: WHERE ADDRESS_LINE_1 = p_bill_to_address1
312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 315: nvl( p_bill_to_address3,fnd_api.g_miss_char)

311: WHERE ADDRESS_LINE_1 = p_bill_to_address1
312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)

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

312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =

Line 317: nvl( p_bill_to_address4,fnd_api.g_miss_char)

313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)

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

314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 319: nvl( p_bill_to_city, fnd_api.g_miss_char)

315: nvl( p_bill_to_address3,fnd_api.g_miss_char)
316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

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

316: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 321: nvl( p_bill_to_state, fnd_api.g_miss_char)

317: nvl( p_bill_to_address4,fnd_api.g_miss_char)
318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =
325: nvl( p_bill_to_country, fnd_api.g_miss_char)

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

318: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =
325: nvl( p_bill_to_country, fnd_api.g_miss_char)
326: AND STATUS = 'A'

Line 323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

319: nvl( p_bill_to_city, fnd_api.g_miss_char)
320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =
325: nvl( p_bill_to_country, fnd_api.g_miss_char)
326: AND STATUS = 'A'
327: AND CUSTOMER_ID = p_customer_id

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

320: AND nvl(STATE,fnd_api.g_miss_char) =
321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =
325: nvl( p_bill_to_country, fnd_api.g_miss_char)
326: AND STATUS = 'A'
327: AND CUSTOMER_ID = p_customer_id
328: and address_status='A'; --2752321

Line 325: nvl( p_bill_to_country, fnd_api.g_miss_char)

321: nvl( p_bill_to_state, fnd_api.g_miss_char)
322: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
323: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
324: AND nvl(COUNTRY,fnd_api.g_miss_char) =
325: nvl( p_bill_to_country, fnd_api.g_miss_char)
326: AND STATUS = 'A'
327: AND CUSTOMER_ID = p_customer_id
328: and address_status='A'; --2752321
329:

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

330: CURSOR C1 IS
331: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
332: FROM OE_INVOICE_TO_ORGS_V
333: WHERE ADDRESS_LINE_1 = p_bill_to_address1
334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 335: nvl( p_bill_to_address2, fnd_api.g_miss_char)

331: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
332: FROM OE_INVOICE_TO_ORGS_V
333: WHERE ADDRESS_LINE_1 = p_bill_to_address1
334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)

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

332: FROM OE_INVOICE_TO_ORGS_V
333: WHERE ADDRESS_LINE_1 = p_bill_to_address1
334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 337: nvl( p_bill_to_address3,fnd_api.g_miss_char)

333: WHERE ADDRESS_LINE_1 = p_bill_to_address1
334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)

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

334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =

Line 339: nvl( p_bill_to_address4,fnd_api.g_miss_char)

335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)

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

336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 341: nvl( p_bill_to_city, fnd_api.g_miss_char)

337: nvl( p_bill_to_address3,fnd_api.g_miss_char)
338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

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

338: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 343: nvl( p_bill_to_state, fnd_api.g_miss_char)

339: nvl( p_bill_to_address4,fnd_api.g_miss_char)
340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =
347: nvl( p_bill_to_country, fnd_api.g_miss_char)

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

340: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =
347: nvl( p_bill_to_country, fnd_api.g_miss_char)
348: AND STATUS = 'A'

Line 345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

341: nvl( p_bill_to_city, fnd_api.g_miss_char)
342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =
347: nvl( p_bill_to_country, fnd_api.g_miss_char)
348: AND STATUS = 'A'
349: and address_status='A' --2752321

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

342: AND nvl(STATE,fnd_api.g_miss_char) =
343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =
347: nvl( p_bill_to_country, fnd_api.g_miss_char)
348: AND STATUS = 'A'
349: and address_status='A' --2752321
350: AND CUSTOMER_ID IN

Line 347: nvl( p_bill_to_country, fnd_api.g_miss_char)

343: nvl( p_bill_to_state, fnd_api.g_miss_char)
344: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
345: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
346: AND nvl(COUNTRY,fnd_api.g_miss_char) =
347: nvl( p_bill_to_country, fnd_api.g_miss_char)
348: AND STATUS = 'A'
349: and address_status='A' --2752321
350: AND CUSTOMER_ID IN
351: (

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

360: CURSOR C2 IS
361: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =

Line 365: nvl( p_bill_to_address2, fnd_api.g_miss_char)

361: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)

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

362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =

Line 367: nvl( p_bill_to_address3,fnd_api.g_miss_char)

363: WHERE ADDRESS_LINE_1 = p_bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)

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

364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =

Line 369: nvl( p_bill_to_address4,fnd_api.g_miss_char)

365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)

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

366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =

Line 371: nvl( p_bill_to_city, fnd_api.g_miss_char)

367: nvl( p_bill_to_address3,fnd_api.g_miss_char)
368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

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

368: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =

Line 373: nvl( p_bill_to_state, fnd_api.g_miss_char)

369: nvl( p_bill_to_address4,fnd_api.g_miss_char)
370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =
377: nvl( p_bill_to_country, fnd_api.g_miss_char)

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

370: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =
377: nvl( p_bill_to_country, fnd_api.g_miss_char)
378: AND STATUS = 'A'

Line 375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)

371: nvl( p_bill_to_city, fnd_api.g_miss_char)
372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =
377: nvl( p_bill_to_country, fnd_api.g_miss_char)
378: AND STATUS = 'A'
379: and address_status='A'; --2752321

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

372: AND nvl(STATE,fnd_api.g_miss_char) =
373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =
377: nvl( p_bill_to_country, fnd_api.g_miss_char)
378: AND STATUS = 'A'
379: and address_status='A'; --2752321
380:

Line 377: nvl( p_bill_to_country, fnd_api.g_miss_char)

373: nvl( p_bill_to_state, fnd_api.g_miss_char)
374: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
375: nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
376: AND nvl(COUNTRY,fnd_api.g_miss_char) =
377: nvl( p_bill_to_country, fnd_api.g_miss_char)
378: AND STATUS = 'A'
379: and address_status='A'; --2752321
380:
381: l_bill_to_site_use_id NUMBER;

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

419: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
420: INTO l_bill_to_site_use_id
421: FROM OE_INVOICE_TO_ORGS_V
422: WHERE ADDRESS_LINE_1 = p_bill_to_address1
423: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
424: nvl( p_bill_to_address2, fnd_api.g_miss_char)
425: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
426: nvl( p_bill_to_address3,fnd_api.g_miss_char)
427: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 424: nvl( p_bill_to_address2, fnd_api.g_miss_char)

420: INTO l_bill_to_site_use_id
421: FROM OE_INVOICE_TO_ORGS_V
422: WHERE ADDRESS_LINE_1 = p_bill_to_address1
423: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
424: nvl( p_bill_to_address2, fnd_api.g_miss_char)
425: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
426: nvl( p_bill_to_address3,fnd_api.g_miss_char)
427: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
428: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

421: FROM OE_INVOICE_TO_ORGS_V
422: WHERE ADDRESS_LINE_1 = p_bill_to_address1
423: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
424: nvl( p_bill_to_address2, fnd_api.g_miss_char)
425: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
426: nvl( p_bill_to_address3,fnd_api.g_miss_char)
427: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
428: DECODE(STATE, NULL, NULL, STATE || ', ')||
429: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 426: nvl( p_bill_to_address3,fnd_api.g_miss_char)

422: WHERE ADDRESS_LINE_1 = p_bill_to_address1
423: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
424: nvl( p_bill_to_address2, fnd_api.g_miss_char)
425: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
426: nvl( p_bill_to_address3,fnd_api.g_miss_char)
427: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
428: DECODE(STATE, NULL, NULL, STATE || ', ')||
429: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
430: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 431: NVL( p_bill_to_address4, fnd_api.g_miss_char)

427: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
428: DECODE(STATE, NULL, NULL, STATE || ', ')||
429: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
430: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
431: NVL( p_bill_to_address4, fnd_api.g_miss_char)
432: AND STATUS = 'A'
433: AND CUSTOMER_ID = p_customer_id
434: and address_status='A'; --2752321;
435: END IF;

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

461: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
462: INTO l_bill_to_site_use_id
463: FROM OE_INVOICE_TO_ORGS_V
464: WHERE ADDRESS_LINE_1 = p_bill_to_address1
465: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
466: nvl( p_bill_to_address2, fnd_api.g_miss_char)
467: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
468: nvl( p_bill_to_address3,fnd_api.g_miss_char)
469: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 466: nvl( p_bill_to_address2, fnd_api.g_miss_char)

462: INTO l_bill_to_site_use_id
463: FROM OE_INVOICE_TO_ORGS_V
464: WHERE ADDRESS_LINE_1 = p_bill_to_address1
465: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
466: nvl( p_bill_to_address2, fnd_api.g_miss_char)
467: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
468: nvl( p_bill_to_address3,fnd_api.g_miss_char)
469: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
470: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

463: FROM OE_INVOICE_TO_ORGS_V
464: WHERE ADDRESS_LINE_1 = p_bill_to_address1
465: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
466: nvl( p_bill_to_address2, fnd_api.g_miss_char)
467: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
468: nvl( p_bill_to_address3,fnd_api.g_miss_char)
469: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
470: DECODE(STATE, NULL, NULL, STATE || ', ')||
471: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 468: nvl( p_bill_to_address3,fnd_api.g_miss_char)

464: WHERE ADDRESS_LINE_1 = p_bill_to_address1
465: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
466: nvl( p_bill_to_address2, fnd_api.g_miss_char)
467: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
468: nvl( p_bill_to_address3,fnd_api.g_miss_char)
469: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
470: DECODE(STATE, NULL, NULL, STATE || ', ')||
471: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
472: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 473: nvl( p_bill_to_address4, fnd_api.g_miss_char)

469: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
470: DECODE(STATE, NULL, NULL, STATE || ', ')||
471: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
472: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
473: nvl( p_bill_to_address4, fnd_api.g_miss_char)
474: AND STATUS = 'A'
475: and address_status='A' --2752321
476: AND CUSTOMER_ID IN
477: (SELECT p_customer_id

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

505: SELECT ORGANIZATION_ID
506: INTO l_bill_to_site_use_id
507: FROM OE_INVOICE_TO_ORGS_V
508: WHERE ADDRESS_LINE_1 = p_bill_to_address1
509: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
510: nvl( p_bill_to_address2, fnd_api.g_miss_char)
511: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
512: nvl( p_bill_to_address3,fnd_api.g_miss_char)
513: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||

Line 510: nvl( p_bill_to_address2, fnd_api.g_miss_char)

506: INTO l_bill_to_site_use_id
507: FROM OE_INVOICE_TO_ORGS_V
508: WHERE ADDRESS_LINE_1 = p_bill_to_address1
509: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
510: nvl( p_bill_to_address2, fnd_api.g_miss_char)
511: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
512: nvl( p_bill_to_address3,fnd_api.g_miss_char)
513: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
514: DECODE(STATE, NULL, NULL, STATE || ', ')||

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

507: FROM OE_INVOICE_TO_ORGS_V
508: WHERE ADDRESS_LINE_1 = p_bill_to_address1
509: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
510: nvl( p_bill_to_address2, fnd_api.g_miss_char)
511: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
512: nvl( p_bill_to_address3,fnd_api.g_miss_char)
513: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
514: DECODE(STATE, NULL, NULL, STATE || ', ')||
515: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||

Line 512: nvl( p_bill_to_address3,fnd_api.g_miss_char)

508: WHERE ADDRESS_LINE_1 = p_bill_to_address1
509: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
510: nvl( p_bill_to_address2, fnd_api.g_miss_char)
511: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
512: nvl( p_bill_to_address3,fnd_api.g_miss_char)
513: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
514: DECODE(STATE, NULL, NULL, STATE || ', ')||
515: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
516: DECODE(COUNTRY, NULL, NULL, COUNTRY) =

Line 517: NVL( p_bill_to_address4, fnd_api.g_miss_char)

513: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
514: DECODE(STATE, NULL, NULL, STATE || ', ')||
515: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
516: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
517: NVL( p_bill_to_address4, fnd_api.g_miss_char)
518: AND STATUS = 'A'
519: and address_status='A'; --2752321
520: END IF;
521:

Line 543: RETURN FND_API.G_MISS_NUM;

539:
540: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
541: OE_MSG_PUB.Add;
542: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID');
543: RETURN FND_API.G_MISS_NUM;
544: WHEN TOO_MANY_ROWS THEN
545: IF c_bill_to_site_use_id%ISOPEN then
546: CLOSE c_bill_to_site_use_id;
547: END IF;

Line 560: RETURN FND_API.G_MISS_NUM;

556:
557: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_MULTI');
558: OE_MSG_PUB.Add;
559: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID');
560: RETURN FND_API.G_MISS_NUM;
561: WHEN OTHERS THEN
562: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID');
563: IF c_bill_to_site_use_id%ISOPEN then
564: CLOSE c_bill_to_site_use_id;

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: ( G_PKG_NAME
578: , 'Address_Value_To_ID'
579: );
580: END IF;
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END Address_Value_To_ID;
583:
584: --=====================================================================
585: -- NAME: Get_Bill_To_Site_Use_ID

Line 615: x_return_status := FND_API.G_RET_STS_SUCCESS;

611: l_customer_id NUMBER;
612: l_bill_to_state VARCHAR2(60);
613: BEGIN
614: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Bill_To_Site_Use_ID');
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: --bug4933291
618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
619: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);

Line 622: p_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN

618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
619: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
620:
621: IF p_bill_to_site_use_id IS NOT NULL AND
622: p_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN
623: BEGIN
624: SELECT site_use_id
625: INTO l_bill_to_site_use_id
626: FROM hz_cust_site_uses_all

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: EXCEPTION
631: WHEN NO_DATA_FOUND THEN
632: -- This same error message takes care of the case of NULL value
633: -- passed in since a NULL in the select will not select any rows.
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_ID_INVALID');
636: FND_MESSAGE.Set_Token('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID');
637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );
638: OE_MSG_PUB.Add;

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );
638: OE_MSG_PUB.Add;
639: END;
640: ELSIF p_bill_to_site_use_id IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID' );
644: OE_MSG_PUB.Add;
645:

Line 651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR

647: -- The location and customer information must be provided to derive a
648: -- unique site use id.
649: -- Note that county is not used for ID derivation since it is not used
650: -- by order import either.
651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR
652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR

Line 652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR

648: -- unique site use id.
649: -- Note that county is not used for ID derivation since it is not used
650: -- by order import either.
651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR
652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR

Line 653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR

649: -- Note that county is not used for ID derivation since it is not used
650: -- by order import either.
651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR
652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR

Line 654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR

650: -- by order import either.
651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR
652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR

Line 655: p_bill_to_city <> FND_API.G_MISS_CHAR OR

651: (p_bill_to_address1 <> FND_API.G_MISS_CHAR OR
652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR
659: p_bill_to_province <> FND_API.G_MISS_CHAR)

Line 656: p_bill_to_country <> FND_API.G_MISS_CHAR OR

652: p_bill_to_address2 <> FND_API.G_MISS_CHAR OR
653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR
659: p_bill_to_province <> FND_API.G_MISS_CHAR)
660: THEN

Line 657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR

653: p_bill_to_address3 <> FND_API.G_MISS_CHAR OR
654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR
659: p_bill_to_province <> FND_API.G_MISS_CHAR)
660: THEN
661: -- Determine the l_bill_to_state value to pass to Address_Value_To_ID

Line 658: p_bill_to_state <> FND_API.G_MISS_CHAR OR

654: p_bill_to_address4 <> FND_API.G_MISS_CHAR OR
655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR
659: p_bill_to_province <> FND_API.G_MISS_CHAR)
660: THEN
661: -- Determine the l_bill_to_state value to pass to Address_Value_To_ID
662: -- function. If the state parameter is provided, pass it, else pass the

Line 659: p_bill_to_province <> FND_API.G_MISS_CHAR)

655: p_bill_to_city <> FND_API.G_MISS_CHAR OR
656: p_bill_to_country <> FND_API.G_MISS_CHAR OR
657: p_bill_to_postal_code <> FND_API.G_MISS_CHAR OR
658: p_bill_to_state <> FND_API.G_MISS_CHAR OR
659: p_bill_to_province <> FND_API.G_MISS_CHAR)
660: THEN
661: -- Determine the l_bill_to_state value to pass to Address_Value_To_ID
662: -- function. If the state parameter is provided, pass it, else pass the
663: -- province information (bug 2346992).

Line 664: IF NVL(p_bill_to_state,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR THEN

660: THEN
661: -- Determine the l_bill_to_state value to pass to Address_Value_To_ID
662: -- function. If the state parameter is provided, pass it, else pass the
663: -- province information (bug 2346992).
664: IF NVL(p_bill_to_state,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR THEN
665: l_bill_to_state := p_bill_to_province;
666: ELSE
667: l_bill_to_state := p_bill_to_state;
668: END IF;

Line 671: IF p_customer_id IS NOT NULL AND p_customer_id <> FND_API.G_MISS_NUM THEN

667: l_bill_to_state := p_bill_to_state;
668: END IF;
669:
670: -- location information exists, now check for a valid customer.
671: IF p_customer_id IS NOT NULL AND p_customer_id <> FND_API.G_MISS_NUM THEN
672: l_bill_to_site_use_id := Address_Value_To_ID(
673: p_bill_to_address1 => p_bill_to_address1,
674: p_bill_to_address2 => p_bill_to_address2,
675: p_bill_to_address3 => p_bill_to_address3,

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

680: p_bill_to_postal_code => p_bill_to_postal_code,
681: p_bill_to_country => p_bill_to_country
682: );
683: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
684: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: ELSIF p_customer_id IS NULL THEN
688: -- set error message

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: p_bill_to_country => p_bill_to_country
682: );
683: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
684: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: ELSIF p_customer_id IS NULL THEN
688: -- set error message
689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: ELSIF p_customer_id IS NULL THEN
688: -- set error message
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );
692: OE_MSG_PUB.Add;
693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND

Line 693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND

689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );
692: OE_MSG_PUB.Add;
693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND
694: p_customer_number <> FND_API.G_MISS_CHAR THEN
695: -- check for valid customer_id
696: BEGIN
697: SELECT hca.cust_account_id

Line 694: p_customer_number <> FND_API.G_MISS_CHAR THEN

690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );
692: OE_MSG_PUB.Add;
693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND
694: p_customer_number <> FND_API.G_MISS_CHAR THEN
695: -- check for valid customer_id
696: BEGIN
697: SELECT hca.cust_account_id
698: INTO l_customer_id

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

715: p_bill_to_postal_code => p_bill_to_postal_code,
716: p_bill_to_country => p_bill_to_country
717: );
718: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
719: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: END IF;
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: p_bill_to_country => p_bill_to_country
717: );
718: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
719: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: END IF;
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720: x_return_status := FND_API.G_RET_STS_ERROR;
721: END IF;
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_INVALID');
726: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
727: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
728: OE_MSG_PUB.Add;

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: OE_MSG_PUB.Add;
729: END;
730: ELSE
731: -- customer information is missing
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');
734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: ELSE
740: -- insufficient information is provided to derive the invoice site use id.
741: -- refer use to API documentation. Either the bill_to site use ID needs
742: -- to be provided or the bill-to address.
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_INFO_INVALID');
745: OE_MSG_PUB.Add;
746: END IF;
747: x_bill_to_site_use_id := l_bill_to_site_use_id;

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: x_bill_to_site_use_id := l_bill_to_site_use_id;
748: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Bill_To_Site_Use_ID');
749: EXCEPTION
750: WHEN OTHERS THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END Get_Bill_To_Site_Use_ID;
753:
754: --=====================================================================
755: --API NAME: Check_External_Credit

Line 767: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

763: -- Previous Version 1.0
764: --=====================================================================
765: PROCEDURE Check_External_Credit
766: ( p_api_version IN NUMBER
767: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
768: , x_return_status OUT NOCOPY VARCHAR2
769: , x_msg_count OUT NOCOPY NUMBER
770: , x_msg_data OUT NOCOPY VARCHAR2
771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR

767: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
768: , x_return_status OUT NOCOPY VARCHAR2
769: , x_msg_count OUT NOCOPY NUMBER
770: , x_msg_data OUT NOCOPY VARCHAR2
771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR

768: , x_return_status OUT NOCOPY VARCHAR2
769: , x_msg_count OUT NOCOPY NUMBER
770: , x_msg_data OUT NOCOPY VARCHAR2
771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM

769: , x_msg_count OUT NOCOPY NUMBER
770: , x_msg_data OUT NOCOPY VARCHAR2
771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM

770: , x_msg_data OUT NOCOPY VARCHAR2
771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR

771: , p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR

772: , p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR

773: , p_customer_id IN NUMBER := FND_API.G_MISS_NUM
774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR

774: , p_bill_to_site_use_id IN NUMBER := FND_API.G_MISS_NUM
775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR

775: , p_bill_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR
776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR

776: , p_bill_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR
777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR

777: , p_bill_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR
778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR

778: , p_bill_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR
779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM

Line 783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR

779: , p_bill_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR
780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
787: , p_functional_currency_code IN VARCHAR2

Line 784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR

780: , p_bill_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR
781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
787: , p_functional_currency_code IN VARCHAR2
788: , p_transaction_currency_code IN VARCHAR2

Line 785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR

781: , p_bill_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR
782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
787: , p_functional_currency_code IN VARCHAR2
788: , p_transaction_currency_code IN VARCHAR2
789: , p_transaction_amount IN NUMBER

Line 786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM

782: , p_bill_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR
783: , p_bill_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR
784: , p_bill_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR
785: , p_credit_check_rule_name IN VARCHAR2 := FND_API.G_MISS_CHAR
786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
787: , p_functional_currency_code IN VARCHAR2
788: , p_transaction_currency_code IN VARCHAR2
789: , p_transaction_amount IN NUMBER
790: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 790: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR

786: , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
787: , p_functional_currency_code IN VARCHAR2
788: , p_transaction_currency_code IN VARCHAR2
789: , p_transaction_amount IN NUMBER
790: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR
791: , p_org_id IN NUMBER := FND_API.G_MISS_NUM
792: , x_result_out OUT NOCOPY VARCHAR2
793: , x_cc_hold_comment OUT NOCOPY VARCHAR2
794: )

Line 791: , p_org_id IN NUMBER := FND_API.G_MISS_NUM

787: , p_functional_currency_code IN VARCHAR2
788: , p_transaction_currency_code IN VARCHAR2
789: , p_transaction_amount IN NUMBER
790: , p_operating_unit_name IN VARCHAR2 := FND_API.G_MISS_CHAR
791: , p_org_id IN NUMBER := FND_API.G_MISS_NUM
792: , x_result_out OUT NOCOPY VARCHAR2
793: , x_cc_hold_comment OUT NOCOPY VARCHAR2
794: )
795: IS

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: l_credit_check_rule_id NUMBER;
803: BEGIN
804: OE_DEBUG_PUB.Add('OEXVCECB: In Check_External_Credit');
805: -- Initialize API return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: -- Check the API version and issue an error if the given API version does not
808: -- match the one in this package.
809: IF NOT FND_API.Compatible_API_Call( l_api_version,
810: p_api_version,

Line 809: IF NOT FND_API.Compatible_API_Call( l_api_version,

805: -- Initialize API return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: -- Check the API version and issue an error if the given API version does not
808: -- match the one in this package.
809: IF NOT FND_API.Compatible_API_Call( l_api_version,
810: p_api_version,
811: l_api_name,
812: G_PKG_NAME)
813: THEN

Line 824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

820: OE_MSG_PUB.Add;
821: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
822: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
823: OE_DEBUG_PUB.Add('API Versin Check Failed.');
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: END IF;
826: --
827: -- Show input parameters
828: --

Line 885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND

881: , x_credit_check_rule_id => l_credit_check_rule_id
882: , x_return_status => l_return_status
883: );
884: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
886: NOT l_any_errors THEN
887: l_any_errors := TRUE;
888: OE_DEBUG_PUB.Add('Validate Credit Check Rule Failed.');
889: END IF;

Line 914: l_return_status := FND_API.G_RET_STS_ERROR;

910: MO_GLOBAL.Set_Policy_Context('S',p_org_id);
911: l_org_id := p_org_id;
912: OE_DEBUG_PUB.Add('Context is set for org_id : '|| l_org_id);
913: ELSE
914: l_return_status := FND_API.G_RET_STS_ERROR;
915: OE_DEBUG_PUB.Add('Could not set org context');
916: END IF;
917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND

Line 918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND

914: l_return_status := FND_API.G_RET_STS_ERROR;
915: OE_DEBUG_PUB.Add('Could not set org context');
916: END IF;
917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
919: NOT l_any_errors THEN
920: l_any_errors := TRUE;
921: OE_DEBUG_PUB.Add('Validate Operating Unit Failed.');
922: END IF;

Line 946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND

942: ,x_bill_to_site_use_id => l_bill_to_site_use_id
943: );
944:
945: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '|| l_bill_to_site_use_id);
946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
947: NOT l_any_errors THEN
948: l_any_errors := TRUE;
949: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.');
950: END IF;

Line 957: RAISE FND_API.G_EXC_ERROR;

953: -- If the are any errors encountered during validation of the parameters
954: -- raise error and error messages and do not continue with credit checking.
955: --
956: IF l_any_errors THEN
957: RAISE FND_API.G_EXC_ERROR;
958: END IF;
959: --
960: -- Call the OM credit check engine to perform credit checking
961:

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: OE_MSG_PUB.Count_and_Get (
987: p_count => x_msg_count
988: ,p_data => x_msg_data);

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: OE_MSG_PUB.Count_and_Get (
987: p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

985: x_return_status := FND_API.G_RET_STS_ERROR;
986: OE_MSG_PUB.Count_and_Get (
987: p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: OE_MSG_PUB.Count_and_Get (
992: p_count => x_msg_count
993: ,p_data => x_msg_data);

Line 990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

986: OE_MSG_PUB.Count_and_Get (
987: p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: OE_MSG_PUB.Count_and_Get (
992: p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN OTHERS THEN

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

991: OE_MSG_PUB.Count_and_Get (
992: p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN OTHERS THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
997: OE_MSG_PUB.Add_Exc_Msg (
998: G_PKG_NAME
999: , l_api_name);