DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on OE_ORDER_UTIL

Line 91: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));

87: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
91: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
92: OE_BULK_MSG_PUB.ADD;
93: END IF;
94:
95: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN

Line 99: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));

95: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
100: OE_BULK_MSG_PUB.ADD;
101: END IF;
102:
103: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN

Line 107: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));

103: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
108: OE_BULK_MSG_PUB.ADD;
109: END IF;
110:
111: -- Quantity and UOM Required

Line 117: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));

113: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
117: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
118: OE_BULK_MSG_PUB.ADD;
119: END IF;
120:
121: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line

Line 127: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));

123: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
127: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
128: OE_BULK_MSG_PUB.ADD;
129: END IF;
130:
131: -- Fix bug 1262790

Line 142: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));

138: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
142: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
143: OE_BULK_MSG_PUB.ADD;
144: END IF;
145:
146: IF p_line_rec.payment_term_id(p_index) IS NULL THEN

Line 150: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));

146: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
150: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
151: OE_BULK_MSG_PUB.ADD;
152: END IF;
153: --serla
154: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 173: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));

169: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
173: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
174: OE_BULK_MSG_PUB.ADD;
175: END IF; -- end of accounting_rule_duration null
176: END IF; -- end of variable accounting rule type
177: END IF; -- end of accounting_rule_id not null

Line 192: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));

188: IF p_line_rec.tax_date(p_index) IS NULL THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
192: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
193: OE_BULK_MSG_PUB.ADD;
194: END IF;
195: */
196: -- Tax field checks not required, as checks would prevent orders from

Line 211: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));

207: IF p_line_rec.price_list_id(p_index) IS NULL THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
211: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
212: OE_BULK_MSG_PUB.ADD;
213: END IF;
214:
215: END IF;

Line 825: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));

821: IF p_ship_from_org_id is null THEN
822:
823: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
824: fnd_message.set_token('ATTRIBUTE'
825: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
826: OE_BULK_MSG_PUB.Add;
827: RETURN FALSE;
828:
829: ELSE

Line 2092: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));

2088: -- fix bug 5109227
2089: p_line_rec.lock_control(p_index) := -99 ;
2090: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2092: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2093: OE_BULK_MSG_PUB.Add('Y','ERROR');
2094: -- fix bug 5109227
2095:
2096: IF l_debug_level > 0 THEN

Line 2549: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));

2545: IF (p_line_rec.inventory_item_id(l_index) IS NULL) THEN
2546:
2547: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2549: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2550: OE_BULK_MSG_PUB.Add('Y','ERROR');
2551: p_line_rec.lock_control(l_index) := -99;
2552:
2553: -- To avoid Insert failure, populate not null column.

Line 2567: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));

2563: IF (p_line_rec.line_type_id(l_index) IS NULL) THEN
2564:
2565: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2567: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2568: OE_BULK_MSG_PUB.Add('Y','ERROR');
2569: p_line_rec.lock_control(l_index) := -99;
2570: IF l_debug_level > 0 THEN
2571: oe_debug_pub.add( 'IN ERROR 2 ' ) ;

Line 2593: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));

2589:
2590: p_line_rec.lock_control(l_index) := -99 ;
2591: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2593: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2594: OE_BULK_MSG_PUB.Add('Y','ERROR');
2595:
2596: ELSE
2597:

Line 2617: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));

2613: END IF;
2614: p_line_rec.lock_control(l_index) := -99 ;
2615: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2617: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2618: OE_BULK_MSG_PUB.Add('Y','ERROR');
2619: ELSE
2620: p_line_rec.wf_process_name(l_index) := l_process_name;
2621: END IF;

Line 2647: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));

2643:
2644: p_line_rec.lock_control(l_index) := -99;
2645: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2647: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2648: OE_BULK_MSG_PUB.Add('Y','ERROR');
2649:
2650: END IF;
2651:

Line 2750: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));

2746:
2747: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
2748: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2750: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));
2751: OE_BULK_MSG_PUB.Add;
2752: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2753: END IF;
2754:

Line 2957: OE_Order_Util.Get_Attribute_Name('task_id'));

2953: IF NOT Validate_task(p_line_rec.project_id(l_index),
2954: p_line_rec.task_id(l_index)) THEN
2955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2957: OE_Order_Util.Get_Attribute_Name('task_id'));
2958: OE_BULK_MSG_PUB.Add('Y','ERROR');
2959: p_line_rec.lock_control(l_index) := -99;
2960: IF l_debug_level > 0 THEN
2961: oe_debug_pub.add( 'IN ERROR 14 ' ) ;

Line 3165: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));

3161: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3162: END IF;
3163: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3165: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
3166: OE_BULK_MSG_PUB.Add('Y','ERROR');
3167: END IF;
3168:
3169: END IF; -- Invoice to is not null

Line 3188: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));

3184: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3185: END IF;
3186: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3188: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3189: OE_BULK_MSG_PUB.Add('Y','ERROR');
3190: END IF;
3191:
3192: END IF; -- ship to is not null

Line 3210: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));

3206: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3207: END IF;
3208: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3210: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
3211: OE_BULK_MSG_PUB.Add('Y','ERROR');
3212: END IF;
3213:
3214: END IF; -- deliver to is not null

Line 3310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));

3306: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3307: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3308: p_line_rec.lock_control(l_index) := -99;
3309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
3311: OE_BULK_MSG_PUB.Add('Y','ERROR');
3312: END IF;
3313: END IF;
3314:

Line 3320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

3316: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3317: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3318: p_line_rec.lock_control(l_index) := -99;
3319: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
3321: OE_BULK_MSG_PUB.Add('Y','ERROR');
3322: END IF;
3323: END IF;
3324:

Line 3332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

3328: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3329: p_line_rec.end_customer_id(l_index)) THEN
3330: p_line_rec.lock_control(l_index) := -99;
3331: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
3333: OE_BULK_MSG_PUB.Add('Y','ERROR');
3334: END IF;
3335: END IF;
3336:

Line 3342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));

3338: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3339: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3340: p_line_rec.lock_control(l_index) := -99;
3341: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));
3343: OE_BULK_MSG_PUB.Add('Y','ERROR');
3344: END IF;
3345: END IF;
3346:

Line 3352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));

3348: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3349: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3350: p_line_rec.lock_control(l_index) := -99;
3351: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
3353: OE_BULK_MSG_PUB.Add('Y','ERROR');
3354: END IF;
3355: END IF;
3356:

Line 3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));

3358: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3359: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3360: p_line_rec.lock_control(l_index) := -99;
3361: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));
3363: OE_BULK_MSG_PUB.Add('Y','ERROR');
3364: END IF;
3365: END IF;
3366: --Bug 5054618}

Line 3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));

3385: END IF;
3386: IF l_rule_type = 'PP_DR_ALL' OR l_rule_type = 'PP_DR_PP' THEN
3387: p_line_rec.lock_control(l_index) := -99 ;
3388: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
3390: OE_BULK_MSG_PUB.Add('Y','ERROR');
3391: END IF; -- end of accounting rule type
3392: END IF; -- end of accounting_rule_id not null
3393: END IF; -- end of non-service line