DBA Data[Home] [Help]

APPS.OE_BLANKET_FORM_CONTROL dependencies on OE_ID_TO_VALUE

Line 56: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

52:
53: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
54: THEN
55:
56: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
57: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Value_Conversion');
58: OE_MSG_PUB.Add;
59:
60: END IF; */

Line 106: OE_ID_TO_VALUE.Ship_From_Org(

102: l_line_rec.ship_from_org_id := p_line_rec.ship_from_org_id;
103:
104: p_line_val_rec := OE_Line_Util.Get_Values(p_line_rec => l_line_rec);
105:
106: OE_ID_TO_VALUE.Ship_From_Org(
107: p_ship_from_org_id => l_line_rec.ship_from_org_id
108: ,x_ship_from_address1 => p_line_val_rec.ship_from_address1
109: ,x_ship_from_address2 => p_line_val_rec.ship_from_address2
110: ,x_ship_from_address3 => p_line_val_rec.ship_from_address3

Line 122: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

118:
119: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
120: THEN
121:
122: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Value_Conversion');
124: OE_MSG_PUB.Add;
125:
126: END IF; */

Line 156: OE_ID_TO_VALUE.Ship_From_Org(

152: BEGIN
153:
154: OE_MSG_PUB.initialize;
155:
156: OE_ID_TO_VALUE.Ship_From_Org(
157: p_ship_from_org_id => p_header_rec.ship_from_org_id
158: ,x_ship_from_address1 => p_header_val_rec.ship_from_address1
159: ,x_ship_from_address2 => p_header_val_rec.ship_from_address2
160: ,x_ship_from_address3 => p_header_val_rec.ship_from_address3

Line 169: OE_ID_TO_VALUE.Ship_To_Org

165:
166:
167:
168: if p_header_rec.ship_to_org_id is not null then
169: OE_ID_TO_VALUE.Ship_To_Org
170: ( p_ship_to_org_id => p_header_rec.ship_To_org_id
171: , x_ship_to_address1 => p_header_val_rec.ship_to_address1
172: , x_ship_to_address2 => p_header_val_rec.ship_to_address2
173: , x_ship_to_address3 => p_header_val_rec.ship_to_address3

Line 185: OE_ID_TO_VALUE.deliver_To_Org

181: );
182: end if;
183:
184: if p_header_rec.deliver_to_org_id is not null then
185: OE_ID_TO_VALUE.deliver_To_Org
186: ( p_deliver_to_org_id => p_header_rec.deliver_To_org_id
187: , x_deliver_to_address1 => p_header_val_rec.deliver_to_address1
188: , x_deliver_to_address2 => p_header_val_rec.deliver_to_address2
189: , x_deliver_to_address3 => p_header_val_rec.deliver_to_address3

Line 202: OE_ID_TO_VALUE.invoice_To_Org

198: end if;
199:
200:
201: if p_header_rec.invoice_to_org_id is not null then
202: OE_ID_TO_VALUE.invoice_To_Org
203: ( p_invoice_to_org_id => p_header_rec.invoice_To_org_id
204: , x_invoice_to_address1 => p_header_val_rec.invoice_to_address1
205: , x_invoice_to_address2 => p_header_val_rec.invoice_to_address2
206: , x_invoice_to_address3 => p_header_val_rec.invoice_to_address3

Line 219: OE_ID_TO_VALUE.CUSTOMER_LOCATION

215: end if;
216:
217: -- hashraf ... start of pack J
218: if p_header_rec.sold_to_site_use_id is not null then
219: OE_ID_TO_VALUE.CUSTOMER_LOCATION
220: ( p_sold_to_site_use_id => p_header_rec.sold_to_site_use_id,
221: x_sold_to_location_address1 => p_header_val_rec.SOLD_TO_LOCATION_ADDRESS1,
222: x_sold_to_location_address2 => p_header_val_rec.SOLD_TO_LOCATION_ADDRESS2,
223: x_sold_to_location_address3 => p_header_val_rec.SOLD_TO_LOCATION_ADDRESS3,

Line 234: p_header_val_rec.Transaction_Phase := OE_ID_TO_VALUE.Transaction_Phase(p_header_rec.Transaction_Phase_Code);

230: x_sold_to_location_country => p_header_val_rec.SOLD_TO_LOCATION_COUNTRY
231: );
232: end if;
233: if p_header_rec.transaction_phase_code is not null then
234: p_header_val_rec.Transaction_Phase := OE_ID_TO_VALUE.Transaction_Phase(p_header_rec.Transaction_Phase_Code);
235: end if;
236: if p_header_rec.flow_status_code is not null then
237: p_header_val_rec.Status := OE_ID_TO_VALUE.Flow_Status(p_header_rec.Flow_Status_Code);
238: end if;

Line 237: p_header_val_rec.Status := OE_ID_TO_VALUE.Flow_Status(p_header_rec.Flow_Status_Code);

233: if p_header_rec.transaction_phase_code is not null then
234: p_header_val_rec.Transaction_Phase := OE_ID_TO_VALUE.Transaction_Phase(p_header_rec.Transaction_Phase_Code);
235: end if;
236: if p_header_rec.flow_status_code is not null then
237: p_header_val_rec.Status := OE_ID_TO_VALUE.Flow_Status(p_header_rec.Flow_Status_Code);
238: end if;
239: if p_header_rec.user_status_code is not null then
240: p_header_val_rec.User_Status := OE_ID_TO_VALUE.User_Status(p_header_rec.User_Status_Code);
241: end if;

Line 240: p_header_val_rec.User_Status := OE_ID_TO_VALUE.User_Status(p_header_rec.User_Status_Code);

236: if p_header_rec.flow_status_code is not null then
237: p_header_val_rec.Status := OE_ID_TO_VALUE.Flow_Status(p_header_rec.Flow_Status_Code);
238: end if;
239: if p_header_rec.user_status_code is not null then
240: p_header_val_rec.User_Status := OE_ID_TO_VALUE.User_Status(p_header_rec.User_Status_Code);
241: end if;
242:
243: -- hashraf ... end of pack J
244:

Line 246: p_header_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_header_rec.freight_terms_code);

242:
243: -- hashraf ... end of pack J
244:
245: if p_header_rec.freight_terms_code is not null then
246: p_header_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_header_rec.freight_terms_code);
247: end if;
248: if p_header_rec.price_list_id is not null then
249: p_header_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_header_rec.price_list_id);
250: end if;

Line 249: p_header_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_header_rec.price_list_id);

245: if p_header_rec.freight_terms_code is not null then
246: p_header_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_header_rec.freight_terms_code);
247: end if;
248: if p_header_rec.price_list_id is not null then
249: p_header_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_header_rec.price_list_id);
250: end if;
251: if p_header_rec.conversion_type_code is not null then
252: p_header_val_rec.Conversion_Type := OE_ID_TO_VALUE.Conversion_Type(p_header_rec.conversion_type_code);
253: end if;

Line 252: p_header_val_rec.Conversion_Type := OE_ID_TO_VALUE.Conversion_Type(p_header_rec.conversion_type_code);

248: if p_header_rec.price_list_id is not null then
249: p_header_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_header_rec.price_list_id);
250: end if;
251: if p_header_rec.conversion_type_code is not null then
252: p_header_val_rec.Conversion_Type := OE_ID_TO_VALUE.Conversion_Type(p_header_rec.conversion_type_code);
253: end if;
254: if p_header_rec.payment_term_id is not null then
255: p_header_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_header_rec.payment_term_id);
256: end if;

Line 255: p_header_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_header_rec.payment_term_id);

251: if p_header_rec.conversion_type_code is not null then
252: p_header_val_rec.Conversion_Type := OE_ID_TO_VALUE.Conversion_Type(p_header_rec.conversion_type_code);
253: end if;
254: if p_header_rec.payment_term_id is not null then
255: p_header_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_header_rec.payment_term_id);
256: end if;
257: if p_header_rec.accounting_rule_id is not null then
258: p_header_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_header_rec.accounting_rule_id);
259: end if;

Line 258: p_header_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_header_rec.accounting_rule_id);

254: if p_header_rec.payment_term_id is not null then
255: p_header_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_header_rec.payment_term_id);
256: end if;
257: if p_header_rec.accounting_rule_id is not null then
258: p_header_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_header_rec.accounting_rule_id);
259: end if;
260: if p_header_rec.invoicing_rule_id is not null then
261: p_header_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_header_rec.invoicing_rule_id);
262: end if;

Line 261: p_header_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_header_rec.invoicing_rule_id);

257: if p_header_rec.accounting_rule_id is not null then
258: p_header_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_header_rec.accounting_rule_id);
259: end if;
260: if p_header_rec.invoicing_rule_id is not null then
261: p_header_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_header_rec.invoicing_rule_id);
262: end if;
263: if p_header_rec.Salesrep_id is not null then
264: p_header_val_rec.salesrep := OE_ID_TO_VALUE.Salesrep(p_header_rec.Salesrep_id);
265: end if;

Line 264: p_header_val_rec.salesrep := OE_ID_TO_VALUE.Salesrep(p_header_rec.Salesrep_id);

260: if p_header_rec.invoicing_rule_id is not null then
261: p_header_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_header_rec.invoicing_rule_id);
262: end if;
263: if p_header_rec.Salesrep_id is not null then
264: p_header_val_rec.salesrep := OE_ID_TO_VALUE.Salesrep(p_header_rec.Salesrep_id);
265: end if;
266:
267: BEGIN
268: Select meaning

Line 297: OE_ID_TO_VALUE.Ship_From_Org(

293: BEGIN
294: oe_debug_pub.add('enter Populate_Line_Values_ID');
295:
296: OE_MSG_PUB.initialize;
297: OE_ID_TO_VALUE.Ship_From_Org(
298: p_ship_from_org_id => p_line_rec.ship_from_org_id
299: ,x_ship_from_address1 => p_line_val_rec.ship_from_address1
300: ,x_ship_from_address2 => p_line_val_rec.ship_from_address2
301: ,x_ship_from_address3 => p_line_val_rec.ship_from_address3

Line 309: OE_ID_TO_VALUE.Ship_To_Org

305: );
306: oe_debug_pub.add('before Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);
307: if p_line_rec.ship_to_org_id is not null then
308: oe_debug_pub.add('ship to : '||p_line_rec.ship_To_org_id);
309: OE_ID_TO_VALUE.Ship_To_Org
310: ( p_ship_to_org_id => p_line_rec.ship_To_org_id
311: , x_ship_to_address1 => p_line_val_rec.ship_to_address1
312: , x_ship_to_address2 => p_line_val_rec.ship_to_address2
313: , x_ship_to_address3 => p_line_val_rec.ship_to_address3

Line 326: OE_ID_TO_VALUE.deliver_To_Org

322: end if;
323: oe_debug_pub.add('After Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);
324:
325: if p_line_rec.deliver_to_org_id is not null then
326: OE_ID_TO_VALUE.deliver_To_Org
327: ( p_deliver_to_org_id => p_line_rec.deliver_To_org_id
328: , x_deliver_to_address1 => p_line_val_rec.deliver_to_address1
329: , x_deliver_to_address2 => p_line_val_rec.deliver_to_address2
330: , x_deliver_to_address3 => p_line_val_rec.deliver_to_address3

Line 342: OE_ID_TO_VALUE.invoice_To_Org

338: );
339: end if;
340:
341: if p_line_rec.invoice_to_org_id is not null then
342: OE_ID_TO_VALUE.invoice_To_Org
343: ( p_invoice_to_org_id => p_line_rec.invoice_To_org_id
344: , x_invoice_to_address1 => p_line_val_rec.invoice_to_address1
345: , x_invoice_to_address2 => p_line_val_rec.invoice_to_address2
346: , x_invoice_to_address3 => p_line_val_rec.invoice_to_address3

Line 359: p_line_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_line_rec.freight_terms_code);

355: end if;
356:
357:
358: if p_line_rec.freight_terms_code is not null then
359: p_line_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_line_rec.freight_terms_code);
360: end if;
361: if p_line_rec.agreement_id is not null then
362: p_line_val_rec.Agreement := OE_ID_TO_VALUE.Agreement(p_line_rec.agreement_id);
363: end if;

Line 362: p_line_val_rec.Agreement := OE_ID_TO_VALUE.Agreement(p_line_rec.agreement_id);

358: if p_line_rec.freight_terms_code is not null then
359: p_line_val_rec.Freight_Terms := OE_ID_TO_VALUE.Freight_Terms(p_line_rec.freight_terms_code);
360: end if;
361: if p_line_rec.agreement_id is not null then
362: p_line_val_rec.Agreement := OE_ID_TO_VALUE.Agreement(p_line_rec.agreement_id);
363: end if;
364: if p_line_rec.price_list_id is not null then
365: p_line_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_line_rec.price_list_id);
366: end if;

Line 365: p_line_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_line_rec.price_list_id);

361: if p_line_rec.agreement_id is not null then
362: p_line_val_rec.Agreement := OE_ID_TO_VALUE.Agreement(p_line_rec.agreement_id);
363: end if;
364: if p_line_rec.price_list_id is not null then
365: p_line_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_line_rec.price_list_id);
366: end if;
367: if p_line_rec.payment_term_id is not null then
368: p_line_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_line_rec.payment_term_id);
369: end if;

Line 368: p_line_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_line_rec.payment_term_id);

364: if p_line_rec.price_list_id is not null then
365: p_line_val_rec.Price_List := OE_ID_TO_VALUE.Price_List(p_line_rec.price_list_id);
366: end if;
367: if p_line_rec.payment_term_id is not null then
368: p_line_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_line_rec.payment_term_id);
369: end if;
370: if p_line_rec.accounting_rule_id is not null then
371: p_line_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_line_rec.accounting_rule_id);
372: end if;

Line 371: p_line_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_line_rec.accounting_rule_id);

367: if p_line_rec.payment_term_id is not null then
368: p_line_val_rec.Payment_Term := OE_ID_TO_VALUE.Payment_Term(p_line_rec.payment_term_id);
369: end if;
370: if p_line_rec.accounting_rule_id is not null then
371: p_line_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_line_rec.accounting_rule_id);
372: end if;
373: if p_line_rec.invoicing_rule_id is not null then
374: p_line_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_line_rec.invoicing_rule_id);
375: end if;

Line 374: p_line_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_line_rec.invoicing_rule_id);

370: if p_line_rec.accounting_rule_id is not null then
371: p_line_val_rec.Accounting_Rule := OE_ID_TO_VALUE.Accounting_Rule(p_line_rec.accounting_rule_id);
372: end if;
373: if p_line_rec.invoicing_rule_id is not null then
374: p_line_val_rec.Invoicing_Rule := OE_ID_TO_VALUE.Invoicing_Rule(p_line_rec.invoicing_rule_id);
375: end if;
376:
377: -- hashraf ... start of pack J
378: if p_line_rec.transaction_phase_code is not null then

Line 379: p_line_val_rec.transaction_phase := OE_ID_TO_VALUE.Transaction_Phase(p_line_rec.transaction_phase_code);

375: end if;
376:
377: -- hashraf ... start of pack J
378: if p_line_rec.transaction_phase_code is not null then
379: p_line_val_rec.transaction_phase := OE_ID_TO_VALUE.Transaction_Phase(p_line_rec.transaction_phase_code);
380: end if;
381: -- hashraf ... end of pack J
382:
383: if p_line_rec.Salesrep_id is not null then

Line 384: p_line_val_rec.salesrep := OE_ID_TO_VALUE.Salesrep(p_line_rec.Salesrep_id);

380: end if;
381: -- hashraf ... end of pack J
382:
383: if p_line_rec.Salesrep_id is not null then
384: p_line_val_rec.salesrep := OE_ID_TO_VALUE.Salesrep(p_line_rec.Salesrep_id);
385: end if;
386:
387: BEGIN
388:

Line 2316: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

2312: END IF;
2313:
2314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2315: THEN
2316: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sales_Order_Type');
2318: OE_MSG_PUB.Add;
2319:
2320: END IF;