19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN
22:
23: FND_API.g_attr_tbl.DELETE;
24:
25: -- START GEN attributes
26:
27: -- Generator will append new attributes before end generate comment.
25: -- START GEN attributes
26:
27: -- Generator will append new attributes before end generate comment.
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'Key_Flex';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'accounting_rule';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'agreement';
27: -- Generator will append new attributes before end generate comment.
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'Key_Flex';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'accounting_rule';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'agreement';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'conversion_type';
29: FND_API.g_attr_tbl(I).name := 'Key_Flex';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'accounting_rule';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'agreement';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'conversion_type';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'deliver_to_contact';
31: FND_API.g_attr_tbl(I).name := 'accounting_rule';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'agreement';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'conversion_type';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'deliver_to_contact';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'deliver_to_org';
33: FND_API.g_attr_tbl(I).name := 'agreement';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'conversion_type';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'deliver_to_contact';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'deliver_to_org';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'demand_class';
35: FND_API.g_attr_tbl(I).name := 'conversion_type';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'deliver_to_contact';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'deliver_to_org';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'demand_class';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'fob_point';
37: FND_API.g_attr_tbl(I).name := 'deliver_to_contact';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'deliver_to_org';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'demand_class';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'fob_point';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'freight_carrier';
39: FND_API.g_attr_tbl(I).name := 'deliver_to_org';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'demand_class';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'fob_point';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'freight_carrier';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'freight_terms';
41: FND_API.g_attr_tbl(I).name := 'demand_class';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'fob_point';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'freight_carrier';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'freight_terms';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'header';
43: FND_API.g_attr_tbl(I).name := 'fob_point';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'freight_carrier';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'freight_terms';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'header';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_contact';
45: FND_API.g_attr_tbl(I).name := 'freight_carrier';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'freight_terms';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'header';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_contact';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_org';
47: FND_API.g_attr_tbl(I).name := 'freight_terms';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'header';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_contact';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_org';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'invoice_to_contact';
49: FND_API.g_attr_tbl(I).name := 'header';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_contact';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_org';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'invoice_to_contact';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'invoice_to_org';
51: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_contact';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_org';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'invoice_to_contact';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'invoice_to_org';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
53: FND_API.g_attr_tbl(I).name := 'intermed_ship_to_org';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'invoice_to_contact';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'invoice_to_org';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'order_source';
55: FND_API.g_attr_tbl(I).name := 'invoice_to_contact';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'invoice_to_org';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'order_source';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'order_type';
57: FND_API.g_attr_tbl(I).name := 'invoice_to_org';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'order_source';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'order_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'org';
59: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'order_source';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'order_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'org';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'over_ship_reason';
61: FND_API.g_attr_tbl(I).name := 'order_source';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'order_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'org';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'over_ship_reason';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'payment_term';
63: FND_API.g_attr_tbl(I).name := 'order_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'org';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'over_ship_reason';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'payment_term';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'price_list';
65: FND_API.g_attr_tbl(I).name := 'org';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'over_ship_reason';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'payment_term';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'price_list';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'return_reason';
67: FND_API.g_attr_tbl(I).name := 'over_ship_reason';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'payment_term';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'price_list';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'return_reason';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'shipment_priority';
69: FND_API.g_attr_tbl(I).name := 'payment_term';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'price_list';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'return_reason';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'shipment_priority';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'shipping_method';
71: FND_API.g_attr_tbl(I).name := 'price_list';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'return_reason';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'shipment_priority';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'shipping_method';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'ship_from_org';
73: FND_API.g_attr_tbl(I).name := 'return_reason';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'shipment_priority';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'shipping_method';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'ship_from_org';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'ship_to_contact';
75: FND_API.g_attr_tbl(I).name := 'shipment_priority';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'shipping_method';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'ship_from_org';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'ship_to_contact';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'ship_to_org';
77: FND_API.g_attr_tbl(I).name := 'shipping_method';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'ship_from_org';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'ship_to_contact';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'ship_to_org';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'sold_to_contact';
79: FND_API.g_attr_tbl(I).name := 'ship_from_org';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'ship_to_contact';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'ship_to_org';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'sold_to_contact';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'sold_to_org';
81: FND_API.g_attr_tbl(I).name := 'ship_to_contact';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'ship_to_org';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'sold_to_contact';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'sold_to_org';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'source_document_type';
83: FND_API.g_attr_tbl(I).name := 'ship_to_org';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'sold_to_contact';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'sold_to_org';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'source_document_type';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'tax_exempt';
85: FND_API.g_attr_tbl(I).name := 'sold_to_contact';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'sold_to_org';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'source_document_type';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'tax_exempt';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'tax_exempt_reason';
87: FND_API.g_attr_tbl(I).name := 'sold_to_org';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'source_document_type';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'tax_exempt';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'tax_exempt_reason';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'tax_point';
89: FND_API.g_attr_tbl(I).name := 'source_document_type';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'tax_exempt';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'tax_exempt_reason';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'tax_point';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'transactional_curr';
91: FND_API.g_attr_tbl(I).name := 'tax_exempt';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'tax_exempt_reason';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'tax_point';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'transactional_curr';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'automatic';
93: FND_API.g_attr_tbl(I).name := 'tax_exempt_reason';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'tax_point';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'transactional_curr';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'automatic';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'discount';
95: FND_API.g_attr_tbl(I).name := 'tax_point';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'transactional_curr';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'automatic';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'discount';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'discount_line';
97: FND_API.g_attr_tbl(I).name := 'transactional_curr';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'automatic';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'discount';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'discount_line';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'line';
99: FND_API.g_attr_tbl(I).name := 'automatic';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'discount';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'discount_line';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'line';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'price_adjustment';
101: FND_API.g_attr_tbl(I).name := 'discount';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'discount_line';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'line';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'price_adjustment';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'dw_update_advice';
103: FND_API.g_attr_tbl(I).name := 'discount_line';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'line';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'price_adjustment';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'dw_update_advice';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'quota';
105: FND_API.g_attr_tbl(I).name := 'line';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'price_adjustment';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'dw_update_advice';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'quota';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'salesrep';
107: FND_API.g_attr_tbl(I).name := 'price_adjustment';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'dw_update_advice';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'quota';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'salesrep';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'sales_credit_type';
109: FND_API.g_attr_tbl(I).name := 'dw_update_advice';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'quota';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'salesrep';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'sales_credit_type';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'sales_credit';
111: FND_API.g_attr_tbl(I).name := 'quota';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'salesrep';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'sales_credit_type';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'sales_credit';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'component';
113: FND_API.g_attr_tbl(I).name := 'salesrep';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'sales_credit_type';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'sales_credit';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'component';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'component_sequence';
115: FND_API.g_attr_tbl(I).name := 'sales_credit_type';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'sales_credit';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'component';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'component_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'top_model_line';
117: FND_API.g_attr_tbl(I).name := 'sales_credit';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'component';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'component_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'top_model_line';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'customer_dock';
119: FND_API.g_attr_tbl(I).name := 'component';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'component_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'top_model_line';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'customer_dock';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'customer_trx_line';
121: FND_API.g_attr_tbl(I).name := 'component_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'top_model_line';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'customer_dock';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'customer_trx_line';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'demand_bucket_type';
123: FND_API.g_attr_tbl(I).name := 'top_model_line';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'customer_dock';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'customer_trx_line';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'demand_bucket_type';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'dep_plan_required';
125: FND_API.g_attr_tbl(I).name := 'customer_dock';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'customer_trx_line';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'demand_bucket_type';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'dep_plan_required';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'inventory_item';
127: FND_API.g_attr_tbl(I).name := 'customer_trx_line';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'demand_bucket_type';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'dep_plan_required';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'inventory_item';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'item_type';
129: FND_API.g_attr_tbl(I).name := 'demand_bucket_type';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'dep_plan_required';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'inventory_item';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'item_type';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'line_category';
131: FND_API.g_attr_tbl(I).name := 'dep_plan_required';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'inventory_item';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'item_type';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'line_category';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'line_type';
133: FND_API.g_attr_tbl(I).name := 'inventory_item';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'item_type';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'line_category';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'line_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'link_to_line';
135: FND_API.g_attr_tbl(I).name := 'item_type';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'line_category';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'line_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'link_to_line';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'option';
137: FND_API.g_attr_tbl(I).name := 'line_category';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'line_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'link_to_line';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'option';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'project';
139: FND_API.g_attr_tbl(I).name := 'line_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'link_to_line';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'option';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'project';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'reference_header';
141: FND_API.g_attr_tbl(I).name := 'link_to_line';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'option';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'project';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'reference_header';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'reference_line';
143: FND_API.g_attr_tbl(I).name := 'option';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'project';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'reference_header';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'reference_line';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'rla_schedule_type';
145: FND_API.g_attr_tbl(I).name := 'project';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'reference_header';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'reference_line';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'rla_schedule_type';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'task';
147: FND_API.g_attr_tbl(I).name := 'reference_header';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'reference_line';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'rla_schedule_type';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'task';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'tax';
149: FND_API.g_attr_tbl(I).name := 'reference_line';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'rla_schedule_type';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'task';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'tax';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'veh_cus_item_cum_key';
151: FND_API.g_attr_tbl(I).name := 'rla_schedule_type';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'task';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'tax';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'veh_cus_item_cum_key';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'visible_demand';
153: FND_API.g_attr_tbl(I).name := 'task';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'tax';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'veh_cus_item_cum_key';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'visible_demand';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'lot_serial';
155: FND_API.g_attr_tbl(I).name := 'tax';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'veh_cus_item_cum_key';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'visible_demand';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'lot_serial';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'appear_on_ack';
157: FND_API.g_attr_tbl(I).name := 'veh_cus_item_cum_key';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'visible_demand';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'lot_serial';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'appear_on_ack';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'appear_on_invoice';
159: FND_API.g_attr_tbl(I).name := 'visible_demand';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'lot_serial';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'appear_on_ack';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'appear_on_invoice';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'charge';
161: FND_API.g_attr_tbl(I).name := 'lot_serial';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'appear_on_ack';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'appear_on_invoice';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'charge';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'charge_type';
163: FND_API.g_attr_tbl(I).name := 'appear_on_ack';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'appear_on_invoice';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'charge';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'charge_type';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'cost_or_charge';
165: FND_API.g_attr_tbl(I).name := 'appear_on_invoice';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'charge';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'charge_type';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'cost_or_charge';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'currency';
167: FND_API.g_attr_tbl(I).name := 'charge';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'charge_type';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'cost_or_charge';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'currency';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'departure';
169: FND_API.g_attr_tbl(I).name := 'charge_type';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'cost_or_charge';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'currency';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'departure';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'estimated';
171: FND_API.g_attr_tbl(I).name := 'cost_or_charge';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'currency';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'departure';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'estimated';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'invoiced';
173: FND_API.g_attr_tbl(I).name := 'currency';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'departure';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'estimated';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'invoiced';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'parent_charge';
175: FND_API.g_attr_tbl(I).name := 'departure';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'estimated';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'invoiced';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'parent_charge';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'returnable';
177: FND_API.g_attr_tbl(I).name := 'estimated';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'invoiced';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'parent_charge';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'returnable';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'tax_group';
179: FND_API.g_attr_tbl(I).name := 'invoiced';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'parent_charge';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'returnable';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'tax_group';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'payment_type';
181: FND_API.g_attr_tbl(I).name := 'parent_charge';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'returnable';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'tax_group';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'payment_type';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'credit_card';
183: FND_API.g_attr_tbl(I).name := 'returnable';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'tax_group';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'payment_type';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'credit_card';
190: I := I + 1;
191: FND_API.g_attr_tbl(I).name := 'commitment';
185: FND_API.g_attr_tbl(I).name := 'tax_group';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'payment_type';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'credit_card';
190: I := I + 1;
191: FND_API.g_attr_tbl(I).name := 'commitment';
192: -- END GEN attributes
193:
187: FND_API.g_attr_tbl(I).name := 'payment_type';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'credit_card';
190: I := I + 1;
191: FND_API.g_attr_tbl(I).name := 'commitment';
192: -- END GEN attributes
193:
194: END Get_Attr_Tbl;
195:
222: -- Convert any missing values to NULL
223:
224: FOR I IN 1..l_segment_array.COUNT LOOP
225:
226: IF l_segment_array(I) = FND_API.G_MISS_CHAR THEN
227: l_segment_array(I) := NULL;
228: END IF;
229:
230: END LOOP;
246: -- Function has already pushed a message on the stack. Add to
247: -- the API message list.
248:
249: OE_MSG_PUB.Add;
250: l_id := FND_API.G_MISS_NUM;
251:
252: END IF;
253:
254: RETURN l_id;
264: , 'Key_Flex'
265: );
266: END IF;
267:
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269:
270: END Key_Flex;
271:
272: -- Generator will append new prototypes before end generate comment.
308: OE_MSG_PUB.Add;
309:
310: END IF;
311:
312: RETURN FND_API.G_MISS_NUM;
313:
314: WHEN OTHERS THEN
315:
316: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: , 'Accounting_Rule'
321: );
322: END IF;
323:
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325:
326: END Accounting_Rule;
327:
328: -- Agreement
362: OE_MSG_PUB.Add;
363:
364: END IF;
365:
366: RETURN FND_API.G_MISS_NUM;
367:
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
374: , 'Agreement'
375: );
376: END IF;
377:
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379:
380: END Agreement;
381:
382: -- Conversion_Type
415: OE_MSG_PUB.Add;
416:
417: END IF;
418:
419: RETURN FND_API.G_MISS_CHAR;
420:
421: WHEN OTHERS THEN
422:
423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: , 'Conversion_Type'
428: );
429: END IF;
430:
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432:
433: END Conversion_Type;
434:
435: -- Deliver_To_Contact
476: OE_MSG_PUB.Add;
477:
478: END IF;
479:
480: RETURN FND_API.G_MISS_NUM;
481:
482: WHEN OTHERS THEN
483:
484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
488: , 'Deliver_To_Contact'
489: );
490: END IF;
491:
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493:
494: END Deliver_To_Contact;
495:
496: -- Deliver_To_Org
517: CURSOR c_deliver_to_org_id(in_sold_to_org_id number) IS
518: SELECT ORGANIZATION_ID
519: FROM OE_DELIVER_TO_ORGS_V
520: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
518: SELECT ORGANIZATION_ID
519: FROM OE_DELIVER_TO_ORGS_V
520: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
519: FROM OE_DELIVER_TO_ORGS_V
520: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
520: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
524: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
525: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
526: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
534: nvl( p_deliver_to_country, fnd_api.g_miss_char)
527: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
534: nvl( p_deliver_to_country, fnd_api.g_miss_char)
535: AND STATUS = 'A'
528: nvl( p_deliver_to_city, fnd_api.g_miss_char)
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
534: nvl( p_deliver_to_country, fnd_api.g_miss_char)
535: AND STATUS = 'A'
536: AND ADDRESS_STATUS ='A' --bug 2752321
529: AND nvl(STATE,fnd_api.g_miss_char) =
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
534: nvl( p_deliver_to_country, fnd_api.g_miss_char)
535: AND STATUS = 'A'
536: AND ADDRESS_STATUS ='A' --bug 2752321
537: AND CUSTOMER_ID = in_sold_to_org_id;
530: nvl( p_deliver_to_state, fnd_api.g_miss_char)
531: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
532: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
533: AND nvl(COUNTRY,fnd_api.g_miss_char) =
534: nvl( p_deliver_to_country, fnd_api.g_miss_char)
535: AND STATUS = 'A'
536: AND ADDRESS_STATUS ='A' --bug 2752321
537: AND CUSTOMER_ID = in_sold_to_org_id;
538:
539: CURSOR C1(in_sold_to_org_id number) IS
540: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
541: FROM OE_DELIVER_TO_ORGS_V
542: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
540: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
541: FROM OE_DELIVER_TO_ORGS_V
542: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
541: FROM OE_DELIVER_TO_ORGS_V
542: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
542: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
546: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
547: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
548: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
556: nvl( p_deliver_to_country, fnd_api.g_miss_char)
549: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
556: nvl( p_deliver_to_country, fnd_api.g_miss_char)
557: AND STATUS = 'A'
550: nvl( p_deliver_to_city, fnd_api.g_miss_char)
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
556: nvl( p_deliver_to_country, fnd_api.g_miss_char)
557: AND STATUS = 'A'
558: AND ADDRESS_STATUS ='A' --bug 2752321
551: AND nvl(STATE,fnd_api.g_miss_char) =
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
556: nvl( p_deliver_to_country, fnd_api.g_miss_char)
557: AND STATUS = 'A'
558: AND ADDRESS_STATUS ='A' --bug 2752321
559: AND CUSTOMER_ID IN
552: nvl( p_deliver_to_state, fnd_api.g_miss_char)
553: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
554: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
555: AND nvl(COUNTRY,fnd_api.g_miss_char) =
556: nvl( p_deliver_to_country, fnd_api.g_miss_char)
557: AND STATUS = 'A'
558: AND ADDRESS_STATUS ='A' --bug 2752321
559: AND CUSTOMER_ID IN
560: (
567: CURSOR C2 IS
568: SELECT ORGANIZATION_ID
569: FROM OE_DELIVER_TO_ORGS_V
570: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
568: SELECT ORGANIZATION_ID
569: FROM OE_DELIVER_TO_ORGS_V
570: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
569: FROM OE_DELIVER_TO_ORGS_V
570: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
570: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
574: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
575: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
576: nvl( p_deliver_to_address4,fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
584: nvl( p_deliver_to_country, fnd_api.g_miss_char)
577: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
584: nvl( p_deliver_to_country, fnd_api.g_miss_char)
585: AND STATUS = 'A'
578: nvl( p_deliver_to_city, fnd_api.g_miss_char)
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
584: nvl( p_deliver_to_country, fnd_api.g_miss_char)
585: AND STATUS = 'A'
586: AND ADDRESS_STATUS ='A';--bug 2752321
579: AND nvl(STATE,fnd_api.g_miss_char) =
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
584: nvl( p_deliver_to_country, fnd_api.g_miss_char)
585: AND STATUS = 'A'
586: AND ADDRESS_STATUS ='A';--bug 2752321
587:
580: nvl( p_deliver_to_state, fnd_api.g_miss_char)
581: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
582: nvl( p_deliver_to_postal_code, fnd_api.g_miss_char)
583: AND nvl(COUNTRY,fnd_api.g_miss_char) =
584: nvl( p_deliver_to_country, fnd_api.g_miss_char)
585: AND STATUS = 'A'
586: AND ADDRESS_STATUS ='A';--bug 2752321
587:
588: l_org varchar2(100);
596:
597: IF l_debug_level > 0 THEN
598: oe_debug_pub.add( 'DELIVER_TO_ADDRESS1='||P_DELIVER_TO_ADDRESS1||' ADDRESS4='||P_DELIVER_TO_ADDRESS4||' DELIVER_TO_CUST_ID='||P_DELIVER_TO_CUSTOMER_ID ) ;
599: END IF;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
597: IF l_debug_level > 0 THEN
598: oe_debug_pub.add( 'DELIVER_TO_ADDRESS1='||P_DELIVER_TO_ADDRESS1||' ADDRESS4='||P_DELIVER_TO_ADDRESS4||' DELIVER_TO_CUST_ID='||P_DELIVER_TO_CUSTOMER_ID ) ;
599: END IF;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
605: AND nvl( p_sold_to_org_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
598: oe_debug_pub.add( 'DELIVER_TO_ADDRESS1='||P_DELIVER_TO_ADDRESS1||' ADDRESS4='||P_DELIVER_TO_ADDRESS4||' DELIVER_TO_CUST_ID='||P_DELIVER_TO_CUSTOMER_ID ) ;
599: END IF;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
605: AND nvl( p_sold_to_org_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
606: THEN
599: END IF;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
605: AND nvl( p_sold_to_org_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
606: THEN
607: RETURN NULL;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
605: AND nvl( p_sold_to_org_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
606: THEN
607: RETURN NULL;
608: END IF;
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
603: AND nvl( p_deliver_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
604: AND nvl( p_deliver_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
605: AND nvl( p_sold_to_org_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
606: THEN
607: RETURN NULL;
608: END IF;
609:
613: END IF;
614: l_sold_to_org_id := p_sold_to_org_id;
615:
616:
617: IF nvl(p_deliver_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'DELIVER_TO_CUST_ID IS NULL' ) ;
620: END IF;
621: l_deliver_to_customer_id := null;
626: -- checking if the deliver_to_customer_id is sent.
627: -- If the customer relationship is on, then the customers should be related
628: IF l_deliver_to_customer_id is not null then
629: IF lcustomer_relations = 'N' AND
630: nvl(l_deliver_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND DELIVER_TO_CUSTOMER ARE NOT SAME' ) ;
634: END IF;
639: OE_MSG_PUB.Add;
640:
641: END IF;
642:
643: RETURN FND_API.G_MISS_NUM;
644:
645:
646: -- checking if the deliver_to_customer_id is sent.
647: -- If the customer rel is on, then the customers should be related
645:
646: -- checking if the deliver_to_customer_id is sent.
647: -- If the customer rel is on, then the customers should be related
648: ELSIF lcustomer_relations = 'Y' AND
649: nvl(l_deliver_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
652: END IF;
653:
671: OE_MSG_PUB.Add;
672:
673: END IF;
674:
675: RETURN FND_API.G_MISS_NUM;
676: END;
677:
678: END IF; -- type of cust rel
679:
715: SELECT ORGANIZATION_ID
716: INTO l_id
717: FROM OE_DELIVER_TO_ORGS_V
718: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
719: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
720: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
721: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
722: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
723: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
716: INTO l_id
717: FROM OE_DELIVER_TO_ORGS_V
718: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
719: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
720: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
721: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
722: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
723: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
724: DECODE(STATE, NULL, NULL, STATE || ', ')||
717: FROM OE_DELIVER_TO_ORGS_V
718: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
719: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
720: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
721: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
722: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
723: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
724: DECODE(STATE, NULL, NULL, STATE || ', ')||
725: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
718: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
719: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
720: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
721: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
722: nvl( p_deliver_to_address3, fnd_api.g_miss_char)
723: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
724: DECODE(STATE, NULL, NULL, STATE || ', ')||
725: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
726: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
723: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
724: DECODE(STATE, NULL, NULL, STATE || ', ')||
725: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
726: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
727: nvl( p_deliver_to_address4, fnd_api.g_miss_char)
728: AND STATUS = 'A'
729: AND ADDRESS_STATUS ='A' --bug 2752321
730: AND CUSTOMER_ID = l_sold_to_org_id;
731: END IF;
758: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
759: INTO l_id
760: FROM OE_DELIVER_TO_ORGS_V
761: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
762: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
763: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
764: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
765: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
766: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
759: INTO l_id
760: FROM OE_DELIVER_TO_ORGS_V
761: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
762: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
763: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
764: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
765: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
766: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
767: DECODE(STATE, NULL, NULL, STATE || ', ')||
760: FROM OE_DELIVER_TO_ORGS_V
761: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
762: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
763: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
764: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
765: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
766: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
767: DECODE(STATE, NULL, NULL, STATE || ', ')||
768: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
761: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
762: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
763: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
764: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
765: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
766: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
767: DECODE(STATE, NULL, NULL, STATE || ', ')||
768: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
769: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
766: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
767: DECODE(STATE, NULL, NULL, STATE || ', ')||
768: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
769: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
770: NVL( p_deliver_to_address4, fnd_api.g_miss_char)
771: AND STATUS = 'A'
772: AND ADDRESS_STATUS ='A' --bug 2752321
773: AND CUSTOMER_ID IN
774: (SELECT l_sold_to_org_id FROM DUAL
802: SELECT ORGANIZATION_ID
803: INTO l_id
804: FROM OE_DELIVER_TO_ORGS_V
805: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
806: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
807: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
808: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
809: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
810: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
803: INTO l_id
804: FROM OE_DELIVER_TO_ORGS_V
805: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
806: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
807: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
808: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
809: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
810: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
811: DECODE(STATE, NULL, NULL, STATE || ', ')||
804: FROM OE_DELIVER_TO_ORGS_V
805: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
806: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
807: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
808: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
809: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
810: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
811: DECODE(STATE, NULL, NULL, STATE || ', ')||
812: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
805: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
806: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
807: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
808: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
809: nvl( p_deliver_to_address3,fnd_api.g_miss_char)
810: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
811: DECODE(STATE, NULL, NULL, STATE || ', ')||
812: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
813: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
810: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
811: DECODE(STATE, NULL, NULL, STATE || ', ')||
812: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
813: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
814: NVL( p_deliver_to_address4, fnd_api.g_miss_char)
815: AND STATUS = 'A'
816: AND ADDRESS_STATUS ='A'; --bug 2752321
817: END IF;
818:
845: OE_MSG_PUB.Add;
846:
847: END IF;
848:
849: RETURN FND_API.G_MISS_NUM;
850:
851: WHEN OTHERS THEN
852:
853: IF c_deliver_to_org_id%ISOPEN then
870: , 'Deliver_To_Org'
871: );
872: END IF;
873:
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875:
876: END Deliver_To_Org;
877:
878: -- Fob_Point
913: OE_MSG_PUB.Add;
914:
915: END IF;
916:
917: RETURN FND_API.G_MISS_CHAR;
918:
919: WHEN OTHERS THEN
920:
921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: , 'Fob_Point'
926: );
927: END IF;
928:
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930:
931: END Fob_Point;
932:
933: -- Freight_Terms
968: OE_MSG_PUB.Add;
969:
970: END IF;
971:
972: RETURN FND_API.G_MISS_CHAR;
973:
974: WHEN OTHERS THEN
975:
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
980: , 'Freight_Terms'
981: );
982: END IF;
983:
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985:
986: END Freight_Terms;
987:
988: -- Intermediate_Ship_To_Contact
1022: OE_MSG_PUB.Add;
1023:
1024: END IF;
1025:
1026: RETURN FND_API.G_MISS_NUM;
1027:
1028:
1029: WHEN OTHERS THEN
1030:
1035: , 'Intermed_Ship_To_Contact'
1036: );
1037: END IF;
1038:
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040:
1041: END Intermed_Ship_To_Contact;
1042:
1043: -- Intermed_Ship_To_Org
1088: OE_MSG_PUB.Add;
1089:
1090: END IF;
1091:
1092: RETURN FND_API.G_MISS_NUM;
1093:
1094: WHEN OTHERS THEN
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: , 'Intermed_Ship_To_Org'
1101: );
1102: END IF;
1103:
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105:
1106: END Intermed_Ship_To_Org;
1107:
1108: -- Invoice_To_Contact
1153: OE_MSG_PUB.Add;
1154:
1155: END IF;
1156:
1157: RETURN FND_API.G_MISS_NUM;
1158:
1159: WHEN OTHERS THEN
1160:
1161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1165: , 'Invoice_To_Contact'
1166: );
1167: END IF;
1168:
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170:
1171: END Invoice_To_Contact;
1172:
1173: -- Invoice_To_Org
1194: CURSOR c_invoice_to_org_id(in_sold_to_org_id number) IS
1195: SELECT ORGANIZATION_ID
1196: FROM OE_INVOICE_TO_ORGS_V
1197: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1195: SELECT ORGANIZATION_ID
1196: FROM OE_INVOICE_TO_ORGS_V
1197: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1196: FROM OE_INVOICE_TO_ORGS_V
1197: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1197: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1201: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1202: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1203: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1211: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1204: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1211: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1212: AND STATUS = 'A'
1205: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1211: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1212: AND STATUS = 'A'
1213: AND ADDRESS_STATUS ='A' --bug 2752321
1206: AND nvl(STATE,fnd_api.g_miss_char) =
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1211: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1212: AND STATUS = 'A'
1213: AND ADDRESS_STATUS ='A' --bug 2752321
1214: AND CUSTOMER_ID = in_sold_to_org_id;
1207: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1208: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1209: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1210: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1211: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1212: AND STATUS = 'A'
1213: AND ADDRESS_STATUS ='A' --bug 2752321
1214: AND CUSTOMER_ID = in_sold_to_org_id;
1215:
1216: CURSOR C1(in_sold_to_org_id in number) IS
1217: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1218: FROM OE_INVOICE_TO_ORGS_V
1219: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1217: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1218: FROM OE_INVOICE_TO_ORGS_V
1219: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1218: FROM OE_INVOICE_TO_ORGS_V
1219: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1219: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1223: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1224: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1225: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1233: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1226: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1233: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1234: AND STATUS = 'A'
1227: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1233: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1234: AND STATUS = 'A'
1235: AND ADDRESS_STATUS ='A' --bug 2752321
1228: AND nvl(STATE,fnd_api.g_miss_char) =
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1233: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1234: AND STATUS = 'A'
1235: AND ADDRESS_STATUS ='A' --bug 2752321
1236: AND CUSTOMER_ID IN
1229: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1230: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1231: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1232: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1233: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1234: AND STATUS = 'A'
1235: AND ADDRESS_STATUS ='A' --bug 2752321
1236: AND CUSTOMER_ID IN
1237: (
1244: CURSOR C2 IS
1245: SELECT ORGANIZATION_ID
1246: FROM OE_INVOICE_TO_ORGS_V
1247: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1245: SELECT ORGANIZATION_ID
1246: FROM OE_INVOICE_TO_ORGS_V
1247: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1246: FROM OE_INVOICE_TO_ORGS_V
1247: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1247: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1251: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1252: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1253: nvl( p_invoice_to_address4,fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1261: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1254: AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1261: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1262: AND STATUS = 'A'
1255: nvl( p_invoice_to_city, fnd_api.g_miss_char)
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1261: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1262: AND STATUS = 'A'
1263: AND ADDRESS_STATUS ='A';--bug 2752321
1256: AND nvl(STATE,fnd_api.g_miss_char) =
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1261: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1262: AND STATUS = 'A'
1263: AND ADDRESS_STATUS ='A';--bug 2752321
1264:
1257: nvl( p_invoice_to_state, fnd_api.g_miss_char)
1258: AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
1259: nvl( p_invoice_to_postal_code, fnd_api.g_miss_char)
1260: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1261: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1262: AND STATUS = 'A'
1263: AND ADDRESS_STATUS ='A';--bug 2752321
1264:
1265: l_org varchar2(100);
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4||' INVOICE_TO_CUST_ID='||P_INVOICE_TO_CUSTOMER_ID ) ;
1276: END IF;
1277:
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1275: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4||' INVOICE_TO_CUST_ID='||P_INVOICE_TO_CUSTOMER_ID ) ;
1276: END IF;
1277:
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1283: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1276: END IF;
1277:
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1283: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1284: THEN
1277:
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1283: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1284: THEN
1285: RETURN NULL;
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1283: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1284: THEN
1285: RETURN NULL;
1286: END IF;
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
1280: AND nvl( p_invoice_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
1281: AND nvl( p_invoice_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
1282: AND nvl( p_invoice_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1283: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1284: THEN
1285: RETURN NULL;
1286: END IF;
1287:
1291: END IF;
1292: l_sold_to_org_id := p_sold_to_org_id;
1293:
1294:
1295: IF nvl(p_invoice_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add( 'INVOICE_TO_CUST_ID IS NULL' ) ;
1298: END IF;
1299: l_invoice_to_customer_id := null;
1304: -- checking if the invoice_to_customer_id is sent.
1305: -- If the customer relationship is on, then the customers should be related
1306: IF l_invoice_to_customer_id is not null then
1307: IF lcustomer_relations = 'N' AND
1308: nvl(l_invoice_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
1309:
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND INVOICE_TO_CUSTOMER ARE NOT SAME' ) ;
1312: END IF;
1317: OE_MSG_PUB.Add;
1318:
1319: END IF;
1320:
1321: RETURN FND_API.G_MISS_NUM;
1322:
1323:
1324: -- checking if the invoice_to_customer_id is sent.
1325: -- If the customer rel is on, then the customers should be related
1323:
1324: -- checking if the invoice_to_customer_id is sent.
1325: -- If the customer rel is on, then the customers should be related
1326: ELSIF lcustomer_relations = 'Y' AND
1327: nvl(l_invoice_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
1328: IF l_debug_level > 0 THEN
1329: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
1330: END IF;
1331:
1350: OE_MSG_PUB.Add;
1351:
1352: END IF;
1353:
1354: RETURN FND_API.G_MISS_NUM;
1355: END;
1356:
1357: END IF; -- type of cust rel
1358:
1395: SELECT ORGANIZATION_ID
1396: INTO l_id
1397: FROM OE_INVOICE_TO_ORGS_V
1398: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1399: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1400: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1401: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1402: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1403: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1396: INTO l_id
1397: FROM OE_INVOICE_TO_ORGS_V
1398: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1399: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1400: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1401: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1402: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1403: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1404: DECODE(STATE, NULL, NULL, STATE || ', ')||
1397: FROM OE_INVOICE_TO_ORGS_V
1398: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1399: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1400: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1401: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1402: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1403: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1404: DECODE(STATE, NULL, NULL, STATE || ', ')||
1405: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1398: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1399: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1400: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1401: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1402: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1403: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1404: DECODE(STATE, NULL, NULL, STATE || ', ')||
1405: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1406: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1403: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1404: DECODE(STATE, NULL, NULL, STATE || ', ')||
1405: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1406: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1407: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1408: AND STATUS = 'A'
1409: AND ADDRESS_STATUS ='A' --bug 2752321
1410: AND CUSTOMER_ID = l_sold_to_org_id;
1411: END IF;
1440: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1441: INTO l_id
1442: FROM OE_INVOICE_TO_ORGS_V
1443: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1444: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1445: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1446: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1447: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1448: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1441: INTO l_id
1442: FROM OE_INVOICE_TO_ORGS_V
1443: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1444: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1445: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1446: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1447: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1448: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1449: DECODE(STATE, NULL, NULL, STATE || ', ')||
1442: FROM OE_INVOICE_TO_ORGS_V
1443: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1444: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1445: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1446: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1447: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1448: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1449: DECODE(STATE, NULL, NULL, STATE || ', ')||
1450: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1443: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1444: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1445: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1446: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1447: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1448: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1449: DECODE(STATE, NULL, NULL, STATE || ', ')||
1450: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1451: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1448: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1449: DECODE(STATE, NULL, NULL, STATE || ', ')||
1450: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1451: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1452: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1453: AND STATUS = 'A'
1454: AND ADDRESS_STATUS ='A' --bug 2752321
1455: AND CUSTOMER_ID IN
1456: (SELECT l_sold_to_org_id FROM DUAL
1485: SELECT ORGANIZATION_ID
1486: INTO l_id
1487: FROM OE_INVOICE_TO_ORGS_V
1488: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1489: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1490: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1491: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1492: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1493: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1486: INTO l_id
1487: FROM OE_INVOICE_TO_ORGS_V
1488: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1489: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1490: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1491: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1492: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1493: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1494: DECODE(STATE, NULL, NULL, STATE || ', ')||
1487: FROM OE_INVOICE_TO_ORGS_V
1488: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1489: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1490: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1491: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1492: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1493: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1494: DECODE(STATE, NULL, NULL, STATE || ', ')||
1495: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1488: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1489: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1490: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1491: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1492: nvl( p_invoice_to_address3,fnd_api.g_miss_char)
1493: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1494: DECODE(STATE, NULL, NULL, STATE || ', ')||
1495: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1496: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1493: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
1494: DECODE(STATE, NULL, NULL, STATE || ', ')||
1495: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
1496: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1497: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1498: AND STATUS = 'A'
1499: AND ADDRESS_STATUS ='A';--bug 2752321
1500: END IF;
1501:
1528: OE_MSG_PUB.Add;
1529:
1530: END IF;
1531:
1532: RETURN FND_API.G_MISS_NUM;
1533:
1534: WHEN OTHERS THEN
1535:
1536: IF c_invoice_to_org_id%ISOPEN then
1552: , 'Invoice_To_Org'
1553: );
1554: END IF;
1555:
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557:
1558: END Invoice_To_Org;
1559:
1560: -- Invoicing_Rule
1593: OE_MSG_PUB.Add;
1594:
1595: END IF;
1596:
1597: RETURN FND_API.G_MISS_NUM;
1598:
1599: WHEN OTHERS THEN
1600:
1601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1605: , 'Invoicing_Rule'
1606: );
1607: END IF;
1608:
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1610:
1611: END Invoicing_Rule;
1612:
1613: -- Order_Source
1651: OE_MSG_PUB.Add;
1652:
1653: END IF;
1654:
1655: RETURN FND_API.G_MISS_NUM;
1656:
1657: WHEN OTHERS THEN
1658:
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1663: , 'Order_Source'
1664: );
1665: END IF;
1666:
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669: END Order_Source;
1670:
1671: -- Order_Type
1704: OE_MSG_PUB.Add;
1705:
1706: END IF;
1707:
1708: RETURN FND_API.G_MISS_NUM;
1709:
1710: WHEN OTHERS THEN
1711:
1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1716: , 'Order_Type'
1717: );
1718: END IF;
1719:
1720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1721:
1722: END Order_Type;
1723:
1724: -- Payment_Term
1757: OE_MSG_PUB.Add;
1758:
1759: END IF;
1760:
1761: RETURN FND_API.G_MISS_NUM;
1762:
1763: WHEN OTHERS THEN
1764:
1765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1769: , 'Payment_Term'
1770: );
1771: END IF;
1772:
1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1774:
1775: END Payment_Term;
1776:
1777: -- Price_List
1811: OE_MSG_PUB.Add;
1812:
1813: END IF;
1814:
1815: RETURN FND_API.G_MISS_NUM;
1816:
1817: WHEN OTHERS THEN
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1823: , 'Price_List'
1824: );
1825: END IF;
1826:
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828:
1829: END Price_List;
1830:
1831: -- Shipment_Priority
1866: OE_MSG_PUB.Add;
1867:
1868: END IF;
1869:
1870: RETURN FND_API.G_MISS_CHAR;
1871:
1872: WHEN OTHERS THEN
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1878: , 'Shipment_Priority'
1879: );
1880: END IF;
1881:
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883:
1884: END Shipment_Priority;
1885:
1886: -- Ship_From_Org
1928: WHEN NO_DATA_FOUND THEN
1929: select distinct organization_id INTO l_id from oe_ship_from_orgs_v
1930: where name= p_ship_from_org;
1931: WHEN TOO_MANY_ROWS THEN
1932: l_id := fnd_api.g_miss_num;
1933: END;
1934:
1935: RETURN l_id;
1936:
1946: OE_MSG_PUB.Add;
1947:
1948: END IF;
1949:
1950: RETURN FND_API.G_MISS_NUM;
1951:
1952: WHEN OTHERS THEN
1953:
1954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1958: , 'Ship_From_Org'
1959: );
1960: END IF;
1961:
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1963:
1964: END Ship_From_Org;
1965:
1966: -- Ship_To_Contact
2011: OE_MSG_PUB.Add;
2012:
2013: END IF;
2014:
2015: RETURN FND_API.G_MISS_NUM;
2016:
2017: WHEN OTHERS THEN
2018:
2019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2023: , 'Ship_To_Contact'
2024: );
2025: END IF;
2026:
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028:
2029: END Ship_To_Contact;
2030:
2031: FUNCTION Inventory_Org
2062: OE_MSG_PUB.Add;
2063:
2064: END IF;
2065:
2066: RETURN FND_API.G_MISS_NUM;
2067:
2068: WHEN OTHERS THEN
2069:
2070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2074: , 'inventory_org'
2075: );
2076: END IF;
2077:
2078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2079:
2080: END Inventory_Org;
2081:
2082: -- Ship_To_Org
2104: CURSOR c_ship_to_org_id(in_sold_to_org_id number) IS
2105: SELECT ORGANIZATION_ID
2106: FROM OE_SHIP_TO_ORGS_V
2107: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2105: SELECT ORGANIZATION_ID
2106: FROM OE_SHIP_TO_ORGS_V
2107: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2106: FROM OE_SHIP_TO_ORGS_V
2107: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2107: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2111: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2112: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2113: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2121: nvl( p_ship_to_country, fnd_api.g_miss_char)
2114: AND nvl( town_or_city, fnd_api.g_miss_char) =
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2121: nvl( p_ship_to_country, fnd_api.g_miss_char)
2122: AND STATUS = 'A'
2115: nvl( p_ship_to_city, fnd_api.g_miss_char)
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2121: nvl( p_ship_to_country, fnd_api.g_miss_char)
2122: AND STATUS = 'A'
2123: AND ADDRESS_STATUS ='A' --bug 2752321
2116: AND nvl( state, fnd_api.g_miss_char) =
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2121: nvl( p_ship_to_country, fnd_api.g_miss_char)
2122: AND STATUS = 'A'
2123: AND ADDRESS_STATUS ='A' --bug 2752321
2124: AND CUSTOMER_ID = in_sold_to_org_id;
2117: nvl( p_ship_to_state, fnd_api.g_miss_char)
2118: AND nvl( postal_code, fnd_api.g_miss_char) =
2119: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2120: AND nvl( country, fnd_api.g_miss_char) =
2121: nvl( p_ship_to_country, fnd_api.g_miss_char)
2122: AND STATUS = 'A'
2123: AND ADDRESS_STATUS ='A' --bug 2752321
2124: AND CUSTOMER_ID = in_sold_to_org_id;
2125:
2126: CURSOR C1(in_sold_to_org_id number) IS
2127: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
2128: FROM OE_SHIP_TO_ORGS_V
2129: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2127: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
2128: FROM OE_SHIP_TO_ORGS_V
2129: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2128: FROM OE_SHIP_TO_ORGS_V
2129: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2129: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2133: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2134: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2135: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2136: AND nvl( town_or_city, fnd_api.g_miss_char) =
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2144: AND STATUS = 'A'
2137: nvl( p_ship_to_city, fnd_api.g_miss_char)
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2144: AND STATUS = 'A'
2145: AND ADDRESS_STATUS ='A' --bug 2752321
2138: AND nvl( state, fnd_api.g_miss_char) =
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2144: AND STATUS = 'A'
2145: AND ADDRESS_STATUS ='A' --bug 2752321
2146: AND CUSTOMER_ID in(
2139: nvl( p_ship_to_state, fnd_api.g_miss_char)
2140: AND nvl( postal_code, fnd_api.g_miss_char) =
2141: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2142: AND nvl( country, fnd_api.g_miss_char) =
2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2144: AND STATUS = 'A'
2145: AND ADDRESS_STATUS ='A' --bug 2752321
2146: AND CUSTOMER_ID in(
2147: SELECT in_sold_to_org_id FROM DUAL
2154: CURSOR C2 IS
2155: SELECT ORGANIZATION_ID
2156: FROM OE_SHIP_TO_ORGS_V
2157: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2155: SELECT ORGANIZATION_ID
2156: FROM OE_SHIP_TO_ORGS_V
2157: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2156: FROM OE_SHIP_TO_ORGS_V
2157: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2157: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2161: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2162: AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2163: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2171: nvl( p_ship_to_country, fnd_api.g_miss_char)
2164: AND nvl( town_or_city, fnd_api.g_miss_char) =
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2171: nvl( p_ship_to_country, fnd_api.g_miss_char)
2172: AND STATUS = 'A'
2165: nvl( p_ship_to_city, fnd_api.g_miss_char)
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2171: nvl( p_ship_to_country, fnd_api.g_miss_char)
2172: AND STATUS = 'A'
2173: AND ADDRESS_STATUS ='A';
2166: AND nvl( state, fnd_api.g_miss_char) =
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2171: nvl( p_ship_to_country, fnd_api.g_miss_char)
2172: AND STATUS = 'A'
2173: AND ADDRESS_STATUS ='A';
2174:
2167: nvl( p_ship_to_state, fnd_api.g_miss_char)
2168: AND nvl( postal_code, fnd_api.g_miss_char) =
2169: nvl( p_ship_to_postal_code, fnd_api.g_miss_char)
2170: AND nvl( country, fnd_api.g_miss_char) =
2171: nvl( p_ship_to_country, fnd_api.g_miss_char)
2172: AND STATUS = 'A'
2173: AND ADDRESS_STATUS ='A';
2174:
2175: l_ship_to_customer_id number;
2184: IF l_debug_level > 0 THEN
2185: oe_debug_pub.add( 'SHIP_TO_ADDRESS1='||P_SHIP_TO_ADDRESS1||' ADDRESS4='||P_SHIP_TO_ADDRESS4||' SHIP_TO_CUST_ID='||P_SHIP_TO_CUSTOMER_ID||' sold_to_org_id='||p_sold_to_org_id ) ;
2186: END IF;
2187:
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2185: oe_debug_pub.add( 'SHIP_TO_ADDRESS1='||P_SHIP_TO_ADDRESS1||' ADDRESS4='||P_SHIP_TO_ADDRESS4||' SHIP_TO_CUST_ID='||P_SHIP_TO_CUSTOMER_ID||' sold_to_org_id='||p_sold_to_org_id ) ;
2186: END IF;
2187:
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2193: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2186: END IF;
2187:
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2193: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2194: THEN
2187:
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2193: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2194: THEN
2195: RETURN NULL;
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2193: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2194: THEN
2195: RETURN NULL;
2196: END IF;
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
2190: AND nvl( p_ship_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
2191: AND nvl( p_ship_to_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
2192: AND nvl( p_ship_to_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2193: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2194: THEN
2195: RETURN NULL;
2196: END IF;
2197:
2202: END IF;
2203: l_sold_to_org_id := p_sold_to_org_id;
2204:
2205:
2206: IF nvl(p_ship_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'SHIP_TO_CUST_ID IS NULL' ) ;
2209: END IF;
2210: l_ship_to_customer_id := null;
2215: -- checking if the ship_to_customer_id is sent.
2216: -- If the customer relationship is on, then the customers should be related
2217: IF l_ship_to_customer_id is not null then
2218: IF lcustomer_relations = 'N' AND
2219: nvl(l_ship_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND SHIP_TO_CUSTOMER ARE NOT SAME' ) ;
2223: END IF;
2228: OE_MSG_PUB.Add;
2229:
2230: END IF;
2231:
2232: RETURN FND_API.G_MISS_NUM;
2233:
2234:
2235: -- checking if the ship_to_customer_id is sent.
2236: -- If the customer rel is on, then the customers should be related
2234:
2235: -- checking if the ship_to_customer_id is sent.
2236: -- If the customer rel is on, then the customers should be related
2237: ELSIF lcustomer_relations = 'Y' AND
2238: nvl(l_ship_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
2239: IF l_debug_level > 0 THEN
2240: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
2241: END IF;
2242:
2260: OE_MSG_PUB.Add;
2261:
2262: END IF;
2263:
2264: RETURN FND_API.G_MISS_NUM;
2265: END;
2266:
2267: END IF; -- type of cust rel
2268:
2305: SELECT ORGANIZATION_ID
2306: INTO l_id
2307: FROM OE_SHIP_TO_ORGS_V
2308: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2309: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2310: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2311: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2312: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2313: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2306: INTO l_id
2307: FROM OE_SHIP_TO_ORGS_V
2308: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2309: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2310: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2311: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2312: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2313: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2314: DECODE(STATE, NULL, NULL, STATE || ', ')||
2307: FROM OE_SHIP_TO_ORGS_V
2308: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2309: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2310: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2311: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2312: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2313: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2314: DECODE(STATE, NULL, NULL, STATE || ', ')||
2315: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2308: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2309: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2310: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2311: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2312: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2313: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2314: DECODE(STATE, NULL, NULL, STATE || ', ')||
2315: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2316: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2313: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2314: DECODE(STATE, NULL, NULL, STATE || ', ')||
2315: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2316: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2317: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2318: AND STATUS = 'A'
2319: AND ADDRESS_STATUS ='A' --bug 2752321
2320: AND CUSTOMER_ID = l_sold_to_org_id;
2321: END IF;
2338: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
2339: INTO l_id
2340: FROM OE_SHIP_TO_ORGS_V
2341: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2342: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2343: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2344: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2345: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2346: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2339: INTO l_id
2340: FROM OE_SHIP_TO_ORGS_V
2341: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2342: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2343: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2344: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2345: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2346: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2347: DECODE(STATE, NULL, NULL, STATE || ', ')||
2340: FROM OE_SHIP_TO_ORGS_V
2341: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2342: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2343: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2344: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2345: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2346: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2347: DECODE(STATE, NULL, NULL, STATE || ', ')||
2348: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2341: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2342: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2343: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2344: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2345: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2346: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2347: DECODE(STATE, NULL, NULL, STATE || ', ')||
2348: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2349: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2346: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2347: DECODE(STATE, NULL, NULL, STATE || ', ')||
2348: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2349: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2350: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2351: AND STATUS = 'A'
2352: AND ADDRESS_STATUS ='A' --bug 2752321
2353: AND CUSTOMER_ID
2354: in (
2376: SELECT ORGANIZATION_ID
2377: INTO l_id
2378: FROM OE_SHIP_TO_ORGS_V
2379: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2380: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2381: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2382: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2383: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2384: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2377: INTO l_id
2378: FROM OE_SHIP_TO_ORGS_V
2379: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2380: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2381: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2382: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2383: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2384: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2385: DECODE(STATE, NULL, NULL, STATE || ', ')||
2378: FROM OE_SHIP_TO_ORGS_V
2379: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2380: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2381: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2382: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2383: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2384: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2385: DECODE(STATE, NULL, NULL, STATE || ', ')||
2386: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2379: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2380: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2381: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2382: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2383: nvl( p_ship_to_address3, fnd_api.g_miss_char)
2384: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2385: DECODE(STATE, NULL, NULL, STATE || ', ')||
2386: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2387: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2384: AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
2385: DECODE(STATE, NULL, NULL, STATE || ', ')||
2386: DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
2387: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
2388: nvl( p_ship_to_address4, fnd_api.g_miss_char)
2389: AND STATUS = 'A'
2390: AND ADDRESS_STATUS ='A';
2391: END IF;
2392: CLOSE C2;
2417: OE_MSG_PUB.Add;
2418:
2419: END IF;
2420:
2421: RETURN FND_API.G_MISS_NUM;
2422:
2423: WHEN OTHERS THEN
2424:
2425: IF c_ship_to_org_id%ISOPEN then
2441: , 'Ship_To_Org'
2442: );
2443: END IF;
2444:
2445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2446:
2447: END Ship_To_Org;
2448:
2449: -- Sold_To_Contact
2486: OE_MSG_PUB.Add;
2487:
2488: END IF;
2489:
2490: RETURN FND_API.G_MISS_NUM;
2491:
2492: WHEN OTHERS THEN
2493:
2494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2498: , 'Sold_To_Contact'
2499: );
2500: END IF;
2501:
2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2503:
2504: END Sold_To_Contact;
2505:
2506:
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'SITE CUSTOMER = '||P_SITE_CUSTOMER|| ' NUMBER='||P_SITE_CUSTOMER_NUMBER|| ' TYPE='||P_TYPE ) ;
2522: END IF;
2523:
2524: IF nvl(p_site_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
2525: AND nvl(p_site_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2526: THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'SITE CUSTOMER RETURNING NULL' ) ;
2521: oe_debug_pub.add( 'SITE CUSTOMER = '||P_SITE_CUSTOMER|| ' NUMBER='||P_SITE_CUSTOMER_NUMBER|| ' TYPE='||P_TYPE ) ;
2522: END IF;
2523:
2524: IF nvl(p_site_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
2525: AND nvl(p_site_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2526: THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'SITE CUSTOMER RETURNING NULL' ) ;
2529: END IF;
2529: END IF;
2530: RETURN NULL;
2531: END IF;
2532:
2533: IF nvl(p_site_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2534:
2535: IF l_debug_level > 0 THEN
2536: oe_debug_pub.add( 'SITE CUSTOMER SELECTING CUST NUM='||P_SITE_CUSTOMER_NUMBER ) ;
2537: END IF;
2586: OE_MSG_PUB.Add;
2587:
2588: END IF;
2589:
2590: RETURN FND_API.G_MISS_NUM;
2591:
2592: WHEN OTHERS THEN
2593:
2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2598: , 'Site_customer'||p_type
2599: );
2600: END IF;
2601:
2602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2603:
2604: END Site_Customer;
2605:
2606:
2617: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2618: --
2619: BEGIN
2620:
2621: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char
2622: AND nvl(p_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2623: THEN
2624: RETURN NULL;
2625: END IF;
2618: --
2619: BEGIN
2620:
2621: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char
2622: AND nvl(p_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2623: THEN
2624: RETURN NULL;
2625: END IF;
2626:
2623: THEN
2624: RETURN NULL;
2625: END IF;
2626:
2627: IF nvl(p_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2628: SELECT ORGANIZATION_ID
2629: INTO l_id
2630: FROM OE_SOLD_TO_ORGS_V
2631: WHERE CUSTOMER_NUMBER = p_customer_number --added for 3651505
2658: OE_MSG_PUB.Add;
2659:
2660: END IF;
2661:
2662: RETURN FND_API.G_MISS_NUM;
2663:
2664: WHEN TOO_MANY_ROWS THEN
2665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2666: THEN
2670: OE_MSG_PUB.Add;
2671:
2672: END IF;
2673:
2674: RETURN FND_API.G_MISS_NUM;
2675: WHEN OTHERS THEN
2676:
2677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2678: THEN
2681: , 'Sold_To_Org'
2682: );
2683: END IF;
2684:
2685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2686:
2687: END Sold_To_Org;
2688:
2689: -- Tax_Exempt
2725: OE_MSG_PUB.Add;
2726:
2727: END IF;
2728:
2729: RETURN FND_API.G_MISS_CHAR;
2730:
2731: WHEN OTHERS THEN
2732:
2733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2737: , 'Tax_Exempt'
2738: );
2739: END IF;
2740:
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742:
2743: END Tax_Exempt;
2744:
2745: -- Tax_Exempt_Reason
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)
2793: , 'Tax_Exempt_Reason'
2794: );
2795: END IF;
2796:
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798:
2799: END Tax_Exempt_Reason;
2800:
2801: -- Tax_Point
2836: OE_MSG_PUB.Add;
2837:
2838: END IF;
2839:
2840: RETURN FND_API.G_MISS_CHAR;
2841:
2842: WHEN OTHERS THEN
2843:
2844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2848: , 'Tax_Point'
2849: );
2850: END IF;
2851:
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853:
2854: END Tax_Point;
2855:
2856: -- Discount
2889: OE_MSG_PUB.Add;
2890:
2891: END IF;
2892:
2893: RETURN FND_API.G_MISS_NUM;
2894:
2895: WHEN OTHERS THEN
2896:
2897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2901: , 'Discount'
2902: );
2903: END IF;
2904:
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906:
2907: END Discount;
2908:
2909: FUNCTION sales_credit_type
2940: OE_MSG_PUB.Add;
2941:
2942: END IF;
2943:
2944: RETURN FND_API.G_MISS_NUM;
2945:
2946: WHEN OTHERS THEN
2947:
2948: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2952: , 'sales_credit_type'
2953: );
2954: END IF;
2955:
2956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2957:
2958: END sales_credit_type;
2959:
2960: -- Salesrep
2999: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3001: OE_MSG_PUB.Add;
3002: oe_debug_pub.add('Multiple active salesrep with same name');
3003: RETURN FND_API.G_MISS_NUM;
3004:
3005: END;
3006:
3007: WHEN NO_DATA_FOUND THEN
3015: oe_debug_pub.add(' Value to ID conversion no data found on salesrep_id');
3016:
3017: END IF;
3018:
3019: RETURN FND_API.G_MISS_NUM;
3020:
3021: WHEN OTHERS THEN
3022:
3023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3029: END IF;
3030:
3031: oe_debug_pub.add(' Value to ID conversion--salesrep_id:'||SQLERRM);
3032:
3033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3034:
3035: END Salesrep;
3036:
3037: -- Demand_Bucket_Type
3070: OE_MSG_PUB.Add;
3071:
3072: END IF;
3073:
3074: RETURN FND_API.G_MISS_CHAR;
3075:
3076: WHEN OTHERS THEN
3077:
3078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: , 'Demand_Bucket_Type'
3083: );
3084: END IF;
3085:
3086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3087:
3088: END Demand_Bucket_Type;
3089:
3090: -- Inventory_Item
3123: OE_MSG_PUB.Add;
3124:
3125: END IF;
3126:
3127: RETURN FND_API.G_MISS_NUM;
3128:
3129: WHEN OTHERS THEN
3130:
3131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3135: , 'Inventory_Item'
3136: );
3137: END IF;
3138:
3139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3140:
3141: END Inventory_Item;
3142:
3143: -- Item_Type
3176: OE_MSG_PUB.Add;
3177:
3178: END IF;
3179:
3180: RETURN FND_API.G_MISS_CHAR;
3181:
3182: WHEN OTHERS THEN
3183:
3184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3188: , 'Item_Type'
3189: );
3190: END IF;
3191:
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193:
3194: END Item_Type;
3195:
3196: -- Line_Type
3229: OE_MSG_PUB.Add;
3230:
3231: END IF;
3232:
3233: RETURN FND_API.G_MISS_NUM;
3234:
3235: WHEN OTHERS THEN
3236:
3237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3241: , 'Line_Type'
3242: );
3243: END IF;
3244:
3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3246:
3247: END Line_Type;
3248:
3249: -- Project
3282: OE_MSG_PUB.Add;
3283:
3284: END IF;
3285:
3286: RETURN FND_API.G_MISS_NUM;
3287:
3288: WHEN OTHERS THEN
3289:
3290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3294: , 'Project'
3295: );
3296: END IF;
3297:
3298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3299:
3300: END Project;
3301:
3302: -- Rla_Schedule_Type
3335: OE_MSG_PUB.Add;
3336:
3337: END IF;
3338:
3339: RETURN FND_API.G_MISS_CHAR;
3340:
3341: WHEN OTHERS THEN
3342:
3343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3347: , 'Rla_Schedule_Type'
3348: );
3349: END IF;
3350:
3351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3352:
3353: END Rla_Schedule_Type;
3354:
3355: -- Task
3388: OE_MSG_PUB.Add;
3389:
3390: END IF;
3391:
3392: RETURN FND_API.G_MISS_NUM;
3393:
3394: WHEN OTHERS THEN
3395:
3396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3400: , 'Task'
3401: );
3402: END IF;
3403:
3404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3405:
3406: END Task;
3407:
3408: FUNCTION Over_Ship_Reason
3439: OE_MSG_PUB.Add;
3440:
3441: END IF;
3442:
3443: RETURN FND_API.G_MISS_CHAR;
3444:
3445: WHEN OTHERS THEN
3446:
3447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3451: , 'Over_Ship_reason'
3452: );
3453: END IF;
3454:
3455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3456:
3457: END Over_Ship_reason;
3458:
3459: FUNCTION Return_Reason
3492: OE_MSG_PUB.Add;
3493:
3494: END IF;
3495:
3496: RETURN FND_API.G_MISS_CHAR;
3497:
3498: WHEN OTHERS THEN
3499:
3500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3504: , 'Return_Reason'
3505: );
3506: END IF;
3507:
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509:
3510: END Return_Reason;
3511:
3512: FUNCTION Veh_Cus_Item_Cum_Key
3543: OE_MSG_PUB.Add;
3544:
3545: END IF;
3546:
3547: RETURN FND_API.G_MISS_NUM;
3548:
3549: WHEN OTHERS THEN
3550:
3551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3555: , 'Veh_Cus_Item_cum_Key'
3556: );
3557: END IF;
3558:
3559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3560:
3561: END Veh_Cus_Item_cum_Key;
3562:
3563: -- Payment_Type
3633: OE_MSG_PUB.Add;
3634:
3635: END IF;
3636:
3637: RETURN FND_API.G_MISS_CHAR;
3638:
3639: WHEN OTHERS THEN
3640:
3641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3645: , 'Payment_Type'
3646: );
3647: END IF;
3648:
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650:
3651: END Payment_Type;
3652:
3653: -- Credit_Card
3687: OE_MSG_PUB.Add;
3688:
3689: END IF;
3690:
3691: RETURN FND_API.G_MISS_CHAR;
3692:
3693: WHEN OTHERS THEN
3694:
3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3699: , 'Credit_Card'
3700: );
3701: END IF;
3702:
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3704:
3705: END Credit_Card;
3706:
3707:
3742: OE_MSG_PUB.Add;
3743:
3744: END IF;
3745:
3746: RETURN FND_API.G_MISS_NUM;
3747:
3748: WHEN OTHERS THEN
3749:
3750: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3754: , 'Veh_Cus_Item_cum_Key'
3755: );
3756: END IF;
3757:
3758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3759:
3760: END Commitment;
3761:
3762:
3796: OE_MSG_PUB.Add;
3797:
3798: END IF;
3799:
3800: RETURN FND_API.G_MISS_CHAR;
3801:
3802: WHEN OTHERS THEN
3803:
3804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3808: , 'Currency'
3809: );
3810: END IF;
3811:
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813:
3814: END Currency;
3815:
3816:
3850: OE_MSG_PUB.Add;
3851:
3852: END IF;
3853:
3854: RETURN FND_API.G_MISS_CHAR;
3855:
3856: WHEN OTHERS THEN
3857:
3858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3862: , 'Agreement_Contact'
3863: );
3864: END IF;
3865:
3866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3867:
3868: END Agreement_Contact;
3869:
3870: -- Agreement_Type
3903: OE_MSG_PUB.Add;
3904:
3905: END IF;
3906:
3907: RETURN FND_API.G_MISS_CHAR;
3908:
3909: WHEN OTHERS THEN
3910:
3911: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3915: , 'Agreement_Type'
3916: );
3917: END IF;
3918:
3919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3920:
3921: END Agreement_Type;
3922:
3923: -- Customer
3956: OE_MSG_PUB.Add;
3957:
3958: END IF;
3959:
3960: RETURN FND_API.G_MISS_CHAR;
3961:
3962: WHEN OTHERS THEN
3963:
3964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3968: , 'Customer'
3969: );
3970: END IF;
3971:
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3973:
3974: END Customer;
3975:
3976: -- Invoice_Contact
4009: OE_MSG_PUB.Add;
4010:
4011: END IF;
4012:
4013: RETURN FND_API.G_MISS_CHAR;
4014:
4015: WHEN OTHERS THEN
4016:
4017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4021: , 'Invoice_Contact'
4022: );
4023: END IF;
4024:
4025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4026:
4027: END Invoice_Contact;
4028:
4029: -- Invoice_To_Site_Use
4062: OE_MSG_PUB.Add;
4063:
4064: END IF;
4065:
4066: RETURN FND_API.G_MISS_CHAR;
4067:
4068: WHEN OTHERS THEN
4069:
4070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4074: , 'Invoice_To_Site_Use'
4075: );
4076: END IF;
4077:
4078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4079:
4080: END Invoice_To_Site_Use;
4081:
4082: -- Override_Arule
4115: OE_MSG_PUB.Add;
4116:
4117: END IF;
4118:
4119: RETURN FND_API.G_MISS_CHAR;
4120:
4121: WHEN OTHERS THEN
4122:
4123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4127: , 'Override_Arule'
4128: );
4129: END IF;
4130:
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132:
4133: END Override_Arule;
4134:
4135: -- Override_Irule
4168: OE_MSG_PUB.Add;
4169:
4170: END IF;
4171:
4172: RETURN FND_API.G_MISS_CHAR;
4173:
4174: WHEN OTHERS THEN
4175:
4176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4180: , 'Override_Irule'
4181: );
4182: END IF;
4183:
4184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4185:
4186: END Override_Irule;
4187:
4188: -- Revision_Reason
4221: OE_MSG_PUB.Add;
4222:
4223: END IF;
4224:
4225: RETURN FND_API.G_MISS_CHAR;
4226:
4227: WHEN OTHERS THEN
4228:
4229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4233: , 'Revision_Reason'
4234: );
4235: END IF;
4236:
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238:
4239: END Revision_Reason;
4240:
4241: -- Ship_Method
4276: OE_MSG_PUB.Add;
4277:
4278: END IF;
4279:
4280: RETURN FND_API.G_MISS_CHAR;
4281:
4282: WHEN OTHERS THEN
4283:
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4288: , 'Ship_Method'
4289: );
4290: END IF;
4291:
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293:
4294: END Ship_Method;
4295:
4296: -- Term
4329: OE_MSG_PUB.Add;
4330:
4331: END IF;
4332:
4333: RETURN FND_API.G_MISS_CHAR;
4334:
4335: WHEN OTHERS THEN
4336:
4337: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4341: , 'Term'
4342: );
4343: END IF;
4344:
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346:
4347: END Term;
4348:
4349: -- Secondary_Price_List
4382: OE_MSG_PUB.Add;
4383:
4384: END IF;
4385:
4386: RETURN FND_API.G_MISS_NUM;
4387:
4388: WHEN OTHERS THEN
4389:
4390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4394: , 'Secondary_Price_List'
4395: );
4396: END IF;
4397:
4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4399:
4400: END Secondary_Price_List;
4401:
4402: -- Terms
4435: OE_MSG_PUB.Add;
4436:
4437: END IF;
4438:
4439: RETURN FND_API.G_MISS_NUM;
4440:
4441: WHEN OTHERS THEN
4442:
4443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4447: , 'Terms'
4448: );
4449: END IF;
4450:
4451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4452:
4453: END Terms;
4454:
4455: -- Automatic_Discount
4488: OE_MSG_PUB.Add;
4489:
4490: END IF;
4491:
4492: RETURN FND_API.G_MISS_CHAR;
4493:
4494: WHEN OTHERS THEN
4495:
4496: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4500: , 'Automatic_Discount'
4501: );
4502: END IF;
4503:
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505:
4506: END Automatic_Discount;
4507:
4508: -- Discount_Lines
4541: OE_MSG_PUB.Add;
4542:
4543: END IF;
4544:
4545: RETURN FND_API.G_MISS_CHAR;
4546:
4547: WHEN OTHERS THEN
4548:
4549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4553: , 'Discount_Lines'
4554: );
4555: END IF;
4556:
4557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4558:
4559: END Discount_Lines;
4560:
4561: -- Discount_Type
4594: OE_MSG_PUB.Add;
4595:
4596: END IF;
4597:
4598: RETURN FND_API.G_MISS_CHAR;
4599:
4600: WHEN OTHERS THEN
4601:
4602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4606: , 'Discount_Type'
4607: );
4608: END IF;
4609:
4610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4611:
4612: END Discount_Type;
4613:
4614: -- Manual_Discount
4647: OE_MSG_PUB.Add;
4648:
4649: END IF;
4650:
4651: RETURN FND_API.G_MISS_CHAR;
4652:
4653: WHEN OTHERS THEN
4654:
4655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4659: , 'Manual_Discount'
4660: );
4661: END IF;
4662:
4663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4664:
4665: END Manual_Discount;
4666:
4667: -- Override_Allowed
4700: OE_MSG_PUB.Add;
4701:
4702: END IF;
4703:
4704: RETURN FND_API.G_MISS_CHAR;
4705:
4706: WHEN OTHERS THEN
4707:
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4712: , 'Override_Allowed'
4713: );
4714: END IF;
4715:
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717:
4718: END Override_Allowed;
4719:
4720: -- Prorate
4753: OE_MSG_PUB.Add;
4754:
4755: END IF;
4756:
4757: RETURN FND_API.G_MISS_CHAR;
4758:
4759: WHEN OTHERS THEN
4760:
4761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4765: , 'Prorate'
4766: );
4767: END IF;
4768:
4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4770:
4771: END Prorate;
4772:
4773:
4807: OE_MSG_PUB.Add;
4808:
4809: END IF;
4810:
4811: RETURN FND_API.G_MISS_CHAR;
4812:
4813: WHEN OTHERS THEN
4814:
4815: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4819: , 'Method'
4820: );
4821: END IF;
4822:
4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4824:
4825: END Method;
4826:
4827: -- Price_List_Line
4860: OE_MSG_PUB.Add;
4861:
4862: END IF;
4863:
4864: RETURN FND_API.G_MISS_NUM;
4865:
4866: WHEN OTHERS THEN
4867:
4868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4872: , 'Price_List_Line'
4873: );
4874: END IF;
4875:
4876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4877:
4878: END Price_List_Line;
4879:
4880: -- Pricing_Rule
4913: OE_MSG_PUB.Add;
4914:
4915: END IF;
4916:
4917: RETURN FND_API.G_MISS_NUM;
4918:
4919: WHEN OTHERS THEN
4920:
4921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4925: , 'Pricing_Rule'
4926: );
4927: END IF;
4928:
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930:
4931: END Pricing_Rule;
4932:
4933: -- Reprice
4966: OE_MSG_PUB.Add;
4967:
4968: END IF;
4969:
4970: RETURN FND_API.G_MISS_CHAR;
4971:
4972: WHEN OTHERS THEN
4973:
4974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4978: , 'Reprice'
4979: );
4980: END IF;
4981:
4982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4983:
4984: END Reprice;
4985:
4986: -- Unit
5019: OE_MSG_PUB.Add;
5020:
5021: END IF;
5022:
5023: RETURN FND_API.G_MISS_CHAR;
5024:
5025: WHEN OTHERS THEN
5026:
5027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5031: , 'Unit'
5032: );
5033: END IF;
5034:
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036:
5037: END Unit;
5038:
5039: -- Customer_Class
5072: OE_MSG_PUB.Add;
5073:
5074: END IF;
5075:
5076: RETURN FND_API.G_MISS_CHAR;
5077:
5078: WHEN OTHERS THEN
5079:
5080: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5084: , 'Customer_Class'
5085: );
5086: END IF;
5087:
5088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5089:
5090: END Customer_Class;
5091:
5092: -- Discount_Customer
5125: OE_MSG_PUB.Add;
5126:
5127: END IF;
5128:
5129: RETURN FND_API.G_MISS_NUM;
5130:
5131: WHEN OTHERS THEN
5132:
5133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5137: , 'Discount_Customer'
5138: );
5139: END IF;
5140:
5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142:
5143: END Discount_Customer;
5144:
5145: -- Site_Use
5178: OE_MSG_PUB.Add;
5179:
5180: END IF;
5181:
5182: RETURN FND_API.G_MISS_NUM;
5183:
5184: WHEN OTHERS THEN
5185:
5186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: , 'Site_Use'
5191: );
5192: END IF;
5193:
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195:
5196: END Site_Use;
5197:
5198: -- Entity
5231: OE_MSG_PUB.Add;
5232:
5233: END IF;
5234:
5235: RETURN FND_API.G_MISS_NUM;
5236:
5237: WHEN OTHERS THEN
5238:
5239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5243: , 'Entity'
5244: );
5245: END IF;
5246:
5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5248:
5249: END Entity;
5250:
5251: -- Method_Type
5284: OE_MSG_PUB.Add;
5285:
5286: END IF;
5287:
5288: RETURN FND_API.G_MISS_CHAR;
5289:
5290: WHEN OTHERS THEN
5291:
5292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5296: , 'Method_Type'
5297: );
5298: END IF;
5299:
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301:
5302: END Method_Type;
5303:
5304: /* Pricing Contract Functions : End */
5339: OE_MSG_PUB.Add;
5340:
5341: END IF;
5342:
5343: RETURN FND_API.G_MISS_NUM;
5344:
5345: WHEN OTHERS THEN
5346:
5347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5351: , 'Lot_Serial'
5352: );
5353: END IF;
5354:
5355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5356:
5357: END Lot_Serial;
5358:
5359: -- Appear_On_Ack
5392: OE_MSG_PUB.Add;
5393:
5394: END IF;
5395:
5396: RETURN FND_API.G_MISS_CHAR;
5397:
5398: WHEN OTHERS THEN
5399:
5400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5404: , 'Appear_On_Ack'
5405: );
5406: END IF;
5407:
5408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5409:
5410: END Appear_On_Ack;
5411:
5412: -- Appear_On_Invoice
5445: OE_MSG_PUB.Add;
5446:
5447: END IF;
5448:
5449: RETURN FND_API.G_MISS_CHAR;
5450:
5451: WHEN OTHERS THEN
5452:
5453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5457: , 'Appear_On_Invoice'
5458: );
5459: END IF;
5460:
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5462:
5463: END Appear_On_Invoice;
5464:
5465: -- Charge
5498: OE_MSG_PUB.Add;
5499:
5500: END IF;
5501:
5502: RETURN FND_API.G_MISS_NUM;
5503:
5504: WHEN OTHERS THEN
5505:
5506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5510: , 'Charge'
5511: );
5512: END IF;
5513:
5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5515:
5516: END Charge;
5517:
5518: -- Charge_Type
5551: OE_MSG_PUB.Add;
5552:
5553: END IF;
5554:
5555: RETURN FND_API.G_MISS_NUM;
5556:
5557: WHEN OTHERS THEN
5558:
5559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5563: , 'Charge_Type'
5564: );
5565: END IF;
5566:
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568:
5569: END Charge_Type;
5570:
5571: -- Cost_Or_Charge
5604: OE_MSG_PUB.Add;
5605:
5606: END IF;
5607:
5608: RETURN FND_API.G_MISS_CHAR;
5609:
5610: WHEN OTHERS THEN
5611:
5612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5616: , 'Cost_Or_Charge'
5617: );
5618: END IF;
5619:
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621:
5622: END Cost_Or_Charge;
5623:
5624: -- Departure
5657: OE_MSG_PUB.Add;
5658:
5659: END IF;
5660:
5661: RETURN FND_API.G_MISS_NUM;
5662:
5663: WHEN OTHERS THEN
5664:
5665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5669: , 'Departure'
5670: );
5671: END IF;
5672:
5673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5674:
5675: END Departure;
5676:
5677: -- Estimated
5710: OE_MSG_PUB.Add;
5711:
5712: END IF;
5713:
5714: RETURN FND_API.G_MISS_CHAR;
5715:
5716: WHEN OTHERS THEN
5717:
5718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5722: , 'Estimated'
5723: );
5724: END IF;
5725:
5726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5727:
5728: END Estimated;
5729:
5730: -- Invoiced
5763: OE_MSG_PUB.Add;
5764:
5765: END IF;
5766:
5767: RETURN FND_API.G_MISS_CHAR;
5768:
5769: WHEN OTHERS THEN
5770:
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5775: , 'Invoiced'
5776: );
5777: END IF;
5778:
5779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5780:
5781: END Invoiced;
5782:
5783: -- Parent_Charge
5816: OE_MSG_PUB.Add;
5817:
5818: END IF;
5819:
5820: RETURN FND_API.G_MISS_NUM;
5821:
5822: WHEN OTHERS THEN
5823:
5824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5828: , 'Parent_Charge'
5829: );
5830: END IF;
5831:
5832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5833:
5834: END Parent_Charge;
5835:
5836: -- Returnable
5869: OE_MSG_PUB.Add;
5870:
5871: END IF;
5872:
5873: RETURN FND_API.G_MISS_CHAR;
5874:
5875: WHEN OTHERS THEN
5876:
5877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5881: , 'Returnable'
5882: );
5883: END IF;
5884:
5885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5886:
5887: END Returnable;
5888:
5889: -- Tax_Group
5922: OE_MSG_PUB.Add;
5923:
5924: END IF;
5925:
5926: RETURN FND_API.G_MISS_CHAR;
5927:
5928: WHEN OTHERS THEN
5929:
5930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5934: , 'Tax_Group'
5935: );
5936: END IF;
5937:
5938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5939:
5940: END Tax_Group;*/
5941:
5942:
5976: OE_MSG_PUB.Add;
5977:
5978: END IF;
5979:
5980: RETURN FND_API.G_MISS_CHAR;
5981:
5982: WHEN OTHERS THEN
5983:
5984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5988: , 'Flow_Status'
5989: );
5990: END IF;
5991:
5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5993:
5994: END Flow_Status;
5995:
5996: FUNCTION Freight_Carrier
6019: OE_MSG_PUB.Add;
6020:
6021: END IF;
6022:
6023: RETURN FND_API.G_MISS_CHAR;
6024:
6025: WHEN TOO_MANY_ROWS THEN
6026:
6027: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6026:
6027: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6028: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');
6029: OE_MSG_PUB.Add;
6030: RETURN FND_API.G_MISS_CHAR;
6031:
6032: WHEN OTHERS THEN
6033:
6034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6038: , 'Freight_Carrier'
6039: );
6040: END IF;
6041:
6042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6043:
6044: END Freight_Carrier;
6045:
6046: FUNCTION Sales_Channel
6079: OE_MSG_PUB.Add;
6080:
6081: END IF;
6082:
6083: RETURN FND_API.G_MISS_CHAR;
6084:
6085: WHEN OTHERS THEN
6086:
6087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6091: , 'Sales_Channel'
6092: );
6093: END IF;
6094:
6095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6096:
6097: END Sales_Channel;
6098:
6099: FUNCTION Customer_Location
6120: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
6121: END IF;
6122:
6123:
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6125: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6126: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6127: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6128: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6121: END IF;
6122:
6123:
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6125: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6126: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6127: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6128: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6129: THEN
6122:
6123:
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6125: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6126: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6127: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6128: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6129: THEN
6130: RETURN NULL;
6123:
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6125: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6126: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6127: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6128: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6129: THEN
6130: RETURN NULL;
6131: END IF;
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6125: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6126: AND nvl( p_sold_to_location_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6127: AND nvl( p_sold_to_location_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6128: AND nvl( p_sold_to_org_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6129: THEN
6130: RETURN NULL;
6131: END IF;
6132:
6142: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6143: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
6144: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
6145: AND LOC.ADDRESS1 = p_sold_to_location_address1
6146: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6143: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
6144: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
6145: AND LOC.ADDRESS1 = p_sold_to_location_address1
6146: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6144: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
6145: AND LOC.ADDRESS1 = p_sold_to_location_address1
6146: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6145: AND LOC.ADDRESS1 = p_sold_to_location_address1
6146: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6146: AND nvl( LOC.ADDRESS2, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6147: nvl( p_sold_to_location_address2, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6148: AND nvl( LOC.ADDRESS3, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6149: nvl( p_sold_to_location_address3, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6150: AND nvl( LOC.ADDRESS4, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6151: nvl( p_sold_to_location_address4, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6159: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
6152: AND nvl( LOC.city, fnd_api.g_miss_char) =
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6159: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
6160: AND SITE.STATUS = 'A'
6153: nvl( p_sold_to_location_city, fnd_api.g_miss_char)
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6159: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
6160: AND SITE.STATUS = 'A'
6161: AND ACCT_SITE.STATUS = 'A'
6154: AND nvl( LOC.state, fnd_api.g_miss_char) =
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6159: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
6160: AND SITE.STATUS = 'A'
6161: AND ACCT_SITE.STATUS = 'A'
6162: and acct_site.org_id=site.org_id
6155: nvl( p_sold_to_location_state, fnd_api.g_miss_char)
6156: AND nvl( LOC.postal_code, fnd_api.g_miss_char) =
6157: nvl( p_sold_to_location_postal_code, fnd_api.g_miss_char)
6158: AND nvl( LOC.country, fnd_api.g_miss_char) =
6159: nvl( p_sold_to_location_country, fnd_api.g_miss_char)
6160: AND SITE.STATUS = 'A'
6161: AND ACCT_SITE.STATUS = 'A'
6162: and acct_site.org_id=site.org_id
6163: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id;
6181: OE_MSG_PUB.Add;
6182:
6183: END IF;
6184:
6185: RETURN FND_API.G_MISS_NUM;
6186:
6187: WHEN OTHERS THEN
6188:
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6193: , 'Customer_Location'
6194: );
6195: END IF;
6196:
6197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6198:
6199: END Customer_Location;
6200:
6201: --serla begin
6231: OE_MSG_PUB.Add;
6232:
6233: END IF;
6234:
6235: RETURN FND_API.G_MISS_CHAR;
6236:
6237: WHEN OTHERS THEN
6238:
6239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6243: , 'Payment_Collection_Event_Name'
6244: );
6245: END IF;
6246:
6247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6248:
6249: END Payment_Collection_Event_Name;
6250:
6251: FUNCTION Receipt_Method
6277: OE_MSG_PUB.Add;
6278:
6279: END IF;
6280:
6281: RETURN FND_API.G_MISS_CHAR;
6282:
6283: WHEN OTHERS THEN
6284:
6285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6289: , 'Receipt_Method'
6290: );
6291: END IF;
6292:
6293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6294:
6295: END Receipt_Method;
6296: --serla end
6297:
6309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6310:
6311: BEGIN
6312:
6313: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
6314: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
6315: THEN
6316: RETURN NULL;
6317: END IF;
6310:
6311: BEGIN
6312:
6313: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
6314: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
6315: THEN
6316: RETURN NULL;
6317: END IF;
6318:
6315: THEN
6316: RETURN NULL;
6317: END IF;
6318:
6319: IF nvl(p_end_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
6320: SELECT ORGANIZATION_ID
6321: INTO l_id
6322: FROM OE_SOLD_TO_ORGS_V
6323: WHERE CUSTOMER_NUMBER = p_end_customer_number;
6346: OE_MSG_PUB.Add;
6347:
6348: END IF;
6349:
6350: RETURN FND_API.G_MISS_NUM;
6351:
6352: WHEN OTHERS THEN
6353:
6354: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6358: , 'End_customer'
6359: );
6360: END IF;
6361:
6362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6363:
6364:
6365: END END_CUSTOMER;
6366:
6398: OE_MSG_PUB.Add;
6399:
6400: END IF;
6401:
6402: RETURN FND_API.G_MISS_NUM;
6403:
6404: WHEN OTHERS THEN
6405:
6406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6410: , 'End_customer_contact'
6411: );
6412: END IF;
6413:
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415:
6416: END END_CUSTOMER_CONTACT;
6417:
6418:
6447: and acct_site.status='A' --bug 2752321
6448: and acct_site.cust_account_id=in_end_customer_id
6449: and acct_site.org_id=site_use.org_id
6450: and loc.address1 = p_end_customer_site_address1
6451: and nvl( loc.address2, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6448: and acct_site.cust_account_id=in_end_customer_id
6449: and acct_site.org_id=site_use.org_id
6450: and loc.address1 = p_end_customer_site_address1
6451: and nvl( loc.address2, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6449: and acct_site.org_id=site_use.org_id
6450: and loc.address1 = p_end_customer_site_address1
6451: and nvl( loc.address2, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6450: and loc.address1 = p_end_customer_site_address1
6451: and nvl( loc.address2, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6451: and nvl( loc.address2, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6452: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6453: and nvl( loc.address3, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6454: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6455: and nvl( loc.address4, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6456: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6464: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
6457: and nvl( loc.city, fnd_api.g_miss_char) =
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6464: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
6465: and site_use.site_use_code = in_end_customer_site_use_code;
6458: nvl( p_end_customer_site_city, fnd_api.g_miss_char)
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6464: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
6465: and site_use.site_use_code = in_end_customer_site_use_code;
6466:
6459: and nvl( loc.state, fnd_api.g_miss_char) =
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6464: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
6465: and site_use.site_use_code = in_end_customer_site_use_code;
6466:
6467: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS --Changed datatype to VARCHAR2 for bug16474566
6460: nvl( p_end_customer_site_state, fnd_api.g_miss_char)
6461: and nvl( loc.postal_code, fnd_api.g_miss_char) =
6462: nvl( p_end_customer_site_postalcode, fnd_api.g_miss_char)
6463: and nvl( loc.country, fnd_api.g_miss_char) =
6464: nvl( p_end_customer_site_country, fnd_api.g_miss_char)
6465: and site_use.site_use_code = in_end_customer_site_use_code;
6466:
6467: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS --Changed datatype to VARCHAR2 for bug16474566
6468: SELECT /* MOAC_SQL_CHANGE */ site_use.site_use_id
6470: hz_party_sites site,
6471: hz_cust_acct_sites_all acct_site,
6472: hz_cust_site_uses site_use
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6475: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6476: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
6477: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6478: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
6471: hz_cust_acct_sites_all acct_site,
6472: hz_cust_site_uses site_use
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6475: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6476: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
6477: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6478: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
6479: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
6472: hz_cust_site_uses site_use
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6475: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6476: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
6477: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6478: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
6479: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
6480: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6475: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)
6476: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =
6477: nvl( p_end_customer_site_address3, fnd_api.g_miss_char)
6478: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
6479: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
6480: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
6481: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =
6478: AND DECODE(loc.CITY,NULL,NULL,loc.CITY||', ')||
6479: DECODE(loc.STATE, NULL, NULL, loc.STATE || ', ')||
6480: DECODE(POSTAL_CODE, NULL, NULL, loc.POSTAL_CODE || ', ')||
6481: DECODE(loc.COUNTRY, NULL, NULL, loc.COUNTRY) =
6482: nvl( p_end_customer_site_address4, fnd_api.g_miss_char)
6483: AND site_use.status = 'A'
6484: AND acct_site.status ='A' --bug 2752321
6485: AND acct_site.cust_account_id = p_end_customer_id
6486: and site_use.site_use_code=in_end_customer_site_use_code
6501: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
6503: END IF;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6507: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6508: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6509: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
6503: END IF;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6507: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6508: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6509: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6510: THEN
6503: END IF;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6507: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6508: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6509: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6510: THEN
6511: RETURN NULL;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6507: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6508: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6509: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6510: THEN
6511: RETURN NULL;
6512: END IF;
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
6507: AND nvl( p_end_customer_site_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char
6508: AND nvl( p_end_customer_site_address4,fnd_api.g_miss_char) = fnd_api.g_miss_char
6509: AND nvl( p_end_customer_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6510: THEN
6511: RETURN NULL;
6512: END IF;
6513:
6645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
6646: OE_MSG_PUB.Add;
6647:
6648: END IF;
6649: RETURN FND_API.G_MISS_NUM;
6650:
6651: WHEN OTHERS THEN
6652:
6653: IF c_site_use_id%ISOPEN then
6665: , 'end_cstomer_site_id'
6666: );
6667: END IF;
6668:
6669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6670:
6671: END END_CUSTOMER_SITE;
6672:
6673: FUNCTION IB_Owner
6708: OE_MSG_PUB.Add;
6709:
6710: END IF;
6711:
6712: RETURN FND_API.G_MISS_CHAR;
6713:
6714: WHEN OTHERS THEN
6715:
6716: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6720: , 'IB_Owner'
6721: );
6722: END IF;
6723:
6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6725:
6726: END IB_Owner;
6727:
6728: FUNCTION IB_Installed_At_Location
6763: OE_MSG_PUB.Add;
6764:
6765: END IF;
6766:
6767: RETURN FND_API.G_MISS_CHAR;
6768:
6769: WHEN OTHERS THEN
6770:
6771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6775: , 'ib_installed_at_location'
6776: );
6777: END IF;
6778:
6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6780:
6781: END IB_Installed_At_Location;
6782:
6783: FUNCTION IB_Current_Location
6818: OE_MSG_PUB.Add;
6819:
6820: END IF;
6821:
6822: RETURN FND_API.G_MISS_CHAR;
6823:
6824: WHEN OTHERS THEN
6825:
6826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6830: , 'ib_current_location'
6831: );
6832: END IF;
6833:
6834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6835:
6836: END IB_Current_Location;
6837:
6838: -- Added for bug 8478559
6880: OE_MSG_PUB.Add;
6881:
6882: END IF;
6883:
6884: RETURN FND_API.G_MISS_NUM;
6885:
6886: WHEN OTHERS THEN
6887:
6888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6892: , 'Operating_Unit'
6893: );
6894: END IF;
6895:
6896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6897:
6898: END OPERATING_UNIT;
6899:
6900: -- sol_ord_er #16014165
6920: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_PROFILE_ID');
6922: OE_MSG_PUB.Add;
6923: END IF;
6924: RETURN FND_API.G_MISS_NUM;
6925: WHEN OTHERS THEN
6926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6927: THEN
6928: OE_MSG_PUB.Add_Exc_Msg
6929: ( G_PKG_NAME
6930: , 'Billing_Profile'
6931: );
6932: END IF;
6933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6934: END Billing_Profile;
6935:
6936: FUNCTION Billing_Option
6937: ( p_service_bill_option IN VARCHAR2
6957: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_OPTION_CODE');
6959: OE_MSG_PUB.Add;
6960: END IF;
6961: RETURN FND_API.G_MISS_NUM;
6962: WHEN OTHERS THEN
6963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6964: THEN
6965: OE_MSG_PUB.Add_Exc_Msg
6966: ( G_PKG_NAME
6967: , 'Billing_Option'
6968: );
6969: END IF;
6970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6971: END Billing_Option;
6972:
6973: FUNCTION Subscription_Template
6974: ( p_service_subs_template IN VARCHAR2
6994: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBS_TEMPLATE_ID');
6996: OE_MSG_PUB.Add;
6997: END IF;
6998: RETURN FND_API.G_MISS_NUM;
6999: WHEN OTHERS THEN
7000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7001: THEN
7002: OE_MSG_PUB.Add_Exc_Msg
7003: ( G_PKG_NAME
7004: , 'Subscription_Template'
7005: );
7006: END IF;
7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7008: END Subscription_Template;
7009:
7010: FUNCTION Coverage_Template
7011: ( p_service_cov_template IN VARCHAR2
7031: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
7032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COV_TEMPLATE_ID');
7033: OE_MSG_PUB.Add;
7034: END IF;
7035: RETURN FND_API.G_MISS_NUM;
7036: WHEN OTHERS THEN
7037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7038: THEN
7039: OE_MSG_PUB.Add_Exc_Msg
7040: ( G_PKG_NAME
7041: , 'Coverage_Template'
7042: );
7043: END IF;
7044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7045: END Coverage_Template;
7046:
7047: --sol_ord_er #16014165 end
7048: