[Home] [Help]
32:
33: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
34: x_return_status := FND_API.G_RET_STS_ERROR;
35: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
36: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
37: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;
40: END IF;
33: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
34: x_return_status := FND_API.G_RET_STS_ERROR;
35: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
36: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
37: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;
40: END IF;
41:
65:
66: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
69: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
70: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
71: FND_MSG_PUB.ADD;
72: END IF;
73: END IF;
66: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
69: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
70: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
71: FND_MSG_PUB.ADD;
72: END IF;
73: END IF;
74:
98:
99: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_DATE) THEN
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
102: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
103: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
104: FND_MSG_PUB.ADD;
105: END IF;
106: END IF;
99: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_DATE) THEN
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
102: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
103: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
104: FND_MSG_PUB.ADD;
105: END IF;
106: END IF;
107:
134:
135: IF (p_end_date < p_start_date ) THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
138: FND_MESSAGE.Set_Name('ASO', 'INVALID COLUMN');
139: FND_MESSAGE.Set_Token('COLUMN', 'END DATE', FALSE);
140: FND_MSG_PUB.ADD;
141: END IF;
142: END IF;
135: IF (p_end_date < p_start_date ) THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
138: FND_MESSAGE.Set_Name('ASO', 'INVALID COLUMN');
139: FND_MESSAGE.Set_Token('COLUMN', 'END DATE', FALSE);
140: FND_MSG_PUB.ADD;
141: END IF;
142: END IF;
143: END IF;
182: IF (C_Party%NOTFOUND OR l_party_status <> 'A') THEN
183: CLOSE C_Party;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
187: FND_MESSAGE.Set_Token('COLUMN', p_party_usage, FALSE);
188: FND_MSG_PUB.ADD;
189: END IF;
190: ELSE
183: CLOSE C_Party;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
187: FND_MESSAGE.Set_Token('COLUMN', p_party_usage, FALSE);
188: FND_MSG_PUB.ADD;
189: END IF;
190: ELSE
191: CLOSE C_Party;
236: IF (C_Contact%NOTFOUND OR l_contact_status <> 'A') THEN
237: CLOSE C_Contact;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
240: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
241: FND_MESSAGE.Set_Token('COLUMN', p_contact_usage, FALSE);
242: FND_MSG_PUB.ADD;
243: END IF;
244: ELSE
237: CLOSE C_Contact;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
240: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
241: FND_MESSAGE.Set_Token('COLUMN', p_contact_usage, FALSE);
242: FND_MSG_PUB.ADD;
243: END IF;
244: ELSE
245: CLOSE C_Contact;
295:
296: CLOSE C_Party_Site;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
299: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
300: FND_MESSAGE.Set_Token('COLUMN', p_site_usage, FALSE);
301: FND_MSG_PUB.ADD;
302: END IF;
303: ELSE
296: CLOSE C_Party_Site;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
299: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
300: FND_MESSAGE.Set_Token('COLUMN', p_site_usage, FALSE);
301: FND_MSG_PUB.ADD;
302: END IF;
303: ELSE
304: CLOSE C_Party_Site;
342: NVL(l_end_date, sysdate))) THEN
343: CLOSE C_Order_Type;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
347: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_TYPE_ID', FALSE);
348: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_type_id), FALSE );
349: FND_MSG_PUB.ADD;
350: END IF;
343: CLOSE C_Order_Type;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
347: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_TYPE_ID', FALSE);
348: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_type_id), FALSE );
349: FND_MSG_PUB.ADD;
350: END IF;
351: ELSE
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
347: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_TYPE_ID', FALSE);
348: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_type_id), FALSE );
349: FND_MSG_PUB.ADD;
350: END IF;
351: ELSE
352: CLOSE C_Order_Type;
392: NVL(l_end_date, sysdate))) THEN
393: CLOSE C_Order_Line_Type;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
397: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_LINE_TYPE_ID', FALSE);
398: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_line_type_id), FALSE );
399: FND_MSG_PUB.ADD;
400: END IF;
393: CLOSE C_Order_Line_Type;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
397: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_LINE_TYPE_ID', FALSE);
398: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_line_type_id), FALSE );
399: FND_MSG_PUB.ADD;
400: END IF;
401: ELSE
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
397: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_LINE_TYPE_ID', FALSE);
398: FND_MESSAGE.Set_Token ('VALUE' ,to_char(p_order_line_type_id), FALSE );
399: FND_MSG_PUB.ADD;
400: END IF;
401: ELSE
402: CLOSE C_Order_Line_Type;
457: NVL(trunc(l_end_date), trunc(sysdate)))) THEN
458: CLOSE C_Price_List;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
461: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
462: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
463: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
458: CLOSE C_Price_List;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
461: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
462: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
463: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
466: ELSE
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
461: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
462: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
463: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
466: ELSE
467: CLOSE C_Price_List;
512: NVL(l_end_date, sysdate))) THEN
513: CLOSE C_Price_List;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
516: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
517: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
518: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
519: FND_MSG_PUB.ADD;
520: END IF;
513: CLOSE C_Price_List;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
516: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
517: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
518: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
519: FND_MSG_PUB.ADD;
520: END IF;
521: ELSIF l_end_date IS NOT NULL AND p_quote_expiration_date <> FND_API.G_MISS_DATE AND nvl(trunc(p_quote_expiration_date), trunc(l_end_date)) > trunc(l_end_date) THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
516: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
517: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
518: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
519: FND_MSG_PUB.ADD;
520: END IF;
521: ELSIF l_end_date IS NOT NULL AND p_quote_expiration_date <> FND_API.G_MISS_DATE AND nvl(trunc(p_quote_expiration_date), trunc(l_end_date)) > trunc(l_end_date) THEN
522: -- ELSIF nvl(p_quote_expiration_date,(sysdate+30)) > l_end_date THEN
521: ELSIF l_end_date IS NOT NULL AND p_quote_expiration_date <> FND_API.G_MISS_DATE AND nvl(trunc(p_quote_expiration_date), trunc(l_end_date)) > trunc(l_end_date) THEN
522: -- ELSIF nvl(p_quote_expiration_date,(sysdate+30)) > l_end_date THEN
523: x_return_status := FND_API.G_RET_STS_ERROR;
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
525: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
526: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
527: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;
522: -- ELSIF nvl(p_quote_expiration_date,(sysdate+30)) > l_end_date THEN
523: x_return_status := FND_API.G_RET_STS_ERROR;
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
525: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
526: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
527: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;
530: --CLOSE C_Price_List;
523: x_return_status := FND_API.G_RET_STS_ERROR;
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
525: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
526: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
527: FND_MESSAGE.Set_Token('VALUE',to_char(p_price_list_id),FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;
530: --CLOSE C_Price_List;
531: END IF;
600: FETCH c_Quote_Status INTO l_quote_status_id, l_enabled_flag;
601: IF (c_Quote_Status%NOTFOUND) THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
605: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
606: FND_MSG_PUB.ADD;
607: END IF;
608: ELSIF (l_enabled_flag <> 'Y') THEN
601: IF (c_Quote_Status%NOTFOUND) THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
605: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
606: FND_MSG_PUB.ADD;
607: END IF;
608: ELSIF (l_enabled_flag <> 'Y') THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608: ELSIF (l_enabled_flag <> 'Y') THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
611: FND_MESSAGE.Set_Name('ASO', 'ASO_DISABLED_STATUS');
612: FND_MSG_PUB.ADD;
613: END IF;
614: END IF;
615: CLOSE C_Quote_Status;
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649: IF (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
653: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;
656: ELSE
649: IF (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
653: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;
656: ELSE
657: OPEN C_Inventory_Item;
661: NVL(l_end_date, sysdate))) THEN
662: CLOSE C_Inventory_Item;
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
665: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
666: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
667: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
668: FND_MSG_PUB.ADD;
669: END IF;
662: CLOSE C_Inventory_Item;
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
665: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
666: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
667: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
668: FND_MSG_PUB.ADD;
669: END IF;
670: ELSIF l_war_flag ='Y'and l_svr_flag ='Y' THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
665: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
666: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
667: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
668: FND_MSG_PUB.ADD;
669: END IF;
670: ELSIF l_war_flag ='Y'and l_svr_flag ='Y' THEN
671: CLOSE C_Inventory_Item;
670: ELSIF l_war_flag ='Y'and l_svr_flag ='Y' THEN
671: CLOSE C_Inventory_Item;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
674: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO4');
675: -- FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
676: FND_MSG_PUB.ADD;
677: END IF;
678: ELSE
671: CLOSE C_Inventory_Item;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
674: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO4');
675: -- FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
676: FND_MSG_PUB.ADD;
677: END IF;
678: ELSE
679: CLOSE C_Inventory_Item;
715: IF (C_item_type_code%NOTFOUND) THEN
716: CLOSE C_item_type_code;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
719: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
720: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_TYPE_CODE', FALSE);
721: FND_MESSAGE.Set_Token('VALUE',p_item_type_code,FALSE);
722: FND_MSG_PUB.ADD;
723: END IF;
716: CLOSE C_item_type_code;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
719: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
720: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_TYPE_CODE', FALSE);
721: FND_MESSAGE.Set_Token('VALUE',p_item_type_code,FALSE);
722: FND_MSG_PUB.ADD;
723: END IF;
724: ELSE
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
719: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
720: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_TYPE_CODE', FALSE);
721: FND_MESSAGE.Set_Token('VALUE',p_item_type_code,FALSE);
722: FND_MSG_PUB.ADD;
723: END IF;
724: ELSE
725: CLOSE C_item_type_code;
757: IF (C_marketing_code%NOTFOUND) THEN
758: CLOSE C_marketing_code;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
761: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
762: FND_MESSAGE.Set_Token('COLUMN', 'MARKETING_SOURCE_CODE_ID', FALSE);
763: FND_MESSAGE.Set_Token('VALUE',to_char(p_mkting_source_code_id),FALSE);
764: FND_MSG_PUB.ADD;
765: END IF;
758: CLOSE C_marketing_code;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
761: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
762: FND_MESSAGE.Set_Token('COLUMN', 'MARKETING_SOURCE_CODE_ID', FALSE);
763: FND_MESSAGE.Set_Token('VALUE',to_char(p_mkting_source_code_id),FALSE);
764: FND_MSG_PUB.ADD;
765: END IF;
766: ELSE
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
761: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
762: FND_MESSAGE.Set_Token('COLUMN', 'MARKETING_SOURCE_CODE_ID', FALSE);
763: FND_MESSAGE.Set_Token('VALUE',to_char(p_mkting_source_code_id),FALSE);
764: FND_MSG_PUB.ADD;
765: END IF;
766: ELSE
767: CLOSE C_marketing_code;
802: IF (C_uom_code%NOTFOUND) THEN
803: CLOSE C_uom_code;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
806: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
807: FND_MESSAGE.Set_Token('COLUMN', 'UOM_CODE', FALSE);
808: FND_MESSAGE.Set_Token('VALUE',p_uom_code,FALSE);
809: FND_MSG_PUB.ADD;
810: END IF;
803: CLOSE C_uom_code;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
806: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
807: FND_MESSAGE.Set_Token('COLUMN', 'UOM_CODE', FALSE);
808: FND_MESSAGE.Set_Token('VALUE',p_uom_code,FALSE);
809: FND_MSG_PUB.ADD;
810: END IF;
811: ELSE
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
806: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
807: FND_MESSAGE.Set_Token('COLUMN', 'UOM_CODE', FALSE);
808: FND_MESSAGE.Set_Token('VALUE',p_uom_code,FALSE);
809: FND_MSG_PUB.ADD;
810: END IF;
811: ELSE
812: CLOSE C_uom_code;
837: (p_tax_exempt_reason_code IS NULL OR
838: p_tax_exempt_reason_code = FND_API.G_MISS_CHAR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
841: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
842: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
843: FND_MSG_PUB.ADD;
844: END IF;
845: END IF;
838: p_tax_exempt_reason_code = FND_API.G_MISS_CHAR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
841: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
842: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
843: FND_MSG_PUB.ADD;
844: END IF;
845: END IF;
846:
890: aso_debug_pub.add('ASO_VALIDATE_PVT.validate_configuration: Inside C_configuration Not Found condition',1,'N');
891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
894: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_CONFIGURATION');
895: FND_MESSAGE.Set_Token('HDR_ID',p_config_header_id, FALSE);
896: FND_MESSAGE.Set_Token('REV_NO',p_config_revision_num, FALSE);
897: FND_MESSAGE.Set_Token('CONFIG_ITEM_ID',p_config_item_id, FALSE);
898: FND_MSG_PUB.ADD;
891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
894: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_CONFIGURATION');
895: FND_MESSAGE.Set_Token('HDR_ID',p_config_header_id, FALSE);
896: FND_MESSAGE.Set_Token('REV_NO',p_config_revision_num, FALSE);
897: FND_MESSAGE.Set_Token('CONFIG_ITEM_ID',p_config_item_id, FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
894: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_CONFIGURATION');
895: FND_MESSAGE.Set_Token('HDR_ID',p_config_header_id, FALSE);
896: FND_MESSAGE.Set_Token('REV_NO',p_config_revision_num, FALSE);
897: FND_MESSAGE.Set_Token('CONFIG_ITEM_ID',p_config_item_id, FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;
900: ELSE
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
894: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_CONFIGURATION');
895: FND_MESSAGE.Set_Token('HDR_ID',p_config_header_id, FALSE);
896: FND_MESSAGE.Set_Token('REV_NO',p_config_revision_num, FALSE);
897: FND_MESSAGE.Set_Token('CONFIG_ITEM_ID',p_config_item_id, FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;
900: ELSE
901: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
943: IF (C_servicetypes%NOTFOUND) THEN
944: CLOSE C_servicetypes;
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
947: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
948: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_TYPE_CODE', FALSE);
949: FND_MESSAGE.Set_Token('VALUE',p_service_ref_type_code,FALSE);
950: FND_MSG_PUB.ADD;
951: END IF;
944: CLOSE C_servicetypes;
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
947: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
948: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_TYPE_CODE', FALSE);
949: FND_MESSAGE.Set_Token('VALUE',p_service_ref_type_code,FALSE);
950: FND_MSG_PUB.ADD;
951: END IF;
952: ELSE
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
947: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
948: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_TYPE_CODE', FALSE);
949: FND_MESSAGE.Set_Token('VALUE',p_service_ref_type_code,FALSE);
950: FND_MSG_PUB.ADD;
951: END IF;
952: ELSE
953: CLOSE C_servicetypes;
1017: CLOSE C_service_item;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019:
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1022: FND_MESSAGE.Set_Token('COLUMN', 'Inventory_item_id', FALSE);
1023: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
1024: FND_MSG_PUB.ADD;
1025: END IF;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019:
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1022: FND_MESSAGE.Set_Token('COLUMN', 'Inventory_item_id', FALSE);
1023: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026:
1019:
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1022: FND_MESSAGE.Set_Token('COLUMN', 'Inventory_item_id', FALSE);
1023: FND_MESSAGE.Set_Token('VALUE',to_char(p_inventory_item_id),FALSE);
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026:
1027: ELSE
1034:
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1038: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1039: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_START_DATE', FALSE);
1040: FND_MSG_PUB.ADD;
1041: END IF;
1042:
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1038: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1039: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_START_DATE', FALSE);
1040: FND_MSG_PUB.ADD;
1041: END IF;
1042:
1043: -- if service we should be able to calc end date
1049:
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051:
1052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1053: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1054: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_END_DATE', FALSE);
1055: FND_MSG_PUB.ADD;
1056: END IF;
1057:
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051:
1052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1053: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1054: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_END_DATE', FALSE);
1055: FND_MSG_PUB.ADD;
1056: END IF;
1057:
1058: END IF; -- start and end date active
1085: IF (p_service_duration IS NOT NULL AND p_service_duration <> FND_API.G_MISS_NUM) THEN
1086: IF p_service_duration < 1 THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1089: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1090: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_DURATION', FALSE);
1091: FND_MESSAGE.Set_Token('VALUE',to_char(p_service_duration),FALSE);
1092: FND_MSG_PUB.ADD;
1093: END IF;
1086: IF p_service_duration < 1 THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1089: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1090: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_DURATION', FALSE);
1091: FND_MESSAGE.Set_Token('VALUE',to_char(p_service_duration),FALSE);
1092: FND_MSG_PUB.ADD;
1093: END IF;
1094: END IF;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1089: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1090: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_DURATION', FALSE);
1091: FND_MESSAGE.Set_Token('VALUE',to_char(p_service_duration),FALSE);
1092: FND_MSG_PUB.ADD;
1093: END IF;
1094: END IF;
1095: END IF;
1138: IF (C_returntypes%NOTFOUND) THEN
1139: CLOSE C_returntypes;
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1142: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1143: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_TYPE_CODE', FALSE);
1144: FND_MESSAGE.Set_Token('VALUE',p_return_ref_type_code,FALSE);
1145: FND_MSG_PUB.ADD;
1146: END IF;
1139: CLOSE C_returntypes;
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1142: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1143: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_TYPE_CODE', FALSE);
1144: FND_MESSAGE.Set_Token('VALUE',p_return_ref_type_code,FALSE);
1145: FND_MSG_PUB.ADD;
1146: END IF;
1147: ELSE
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1142: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1143: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_TYPE_CODE', FALSE);
1144: FND_MESSAGE.Set_Token('VALUE',p_return_ref_type_code,FALSE);
1145: FND_MSG_PUB.ADD;
1146: END IF;
1147: ELSE
1148: CLOSE C_returntypes;
1184: IF (C_employperson%NOTFOUND OR l_status<> 'A') THEN
1185: CLOSE C_employperson;
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1188: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SALES_REP');
1189: FND_MESSAGE.Set_Token('COLUMN','EMPLOYEE_PERSON_ID' , FALSE);
1190: FND_MSG_PUB.ADD;
1191: END IF;
1192: ELSE
1185: CLOSE C_employperson;
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1188: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SALES_REP');
1189: FND_MESSAGE.Set_Token('COLUMN','EMPLOYEE_PERSON_ID' , FALSE);
1190: FND_MSG_PUB.ADD;
1191: END IF;
1192: ELSE
1193: CLOSE C_employperson;
1192: ELSE
1193: CLOSE C_employperson;
1194: IF trunc(sysdate) > nvl(trunc(l_end_date), trunc(sysdate)) THEN
1195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1196: FND_MESSAGE.Set_Name('ASO', 'NOT_EFFECTIVE');
1197: FND_MESSAGE.Set_Token('COLUMN','EMPLOYEE_PERSON_ID' , FALSE);
1198: FND_MSG_PUB.ADD;
1199: END IF;
1200: END IF;
1193: CLOSE C_employperson;
1194: IF trunc(sysdate) > nvl(trunc(l_end_date), trunc(sysdate)) THEN
1195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1196: FND_MESSAGE.Set_Name('ASO', 'NOT_EFFECTIVE');
1197: FND_MESSAGE.Set_Token('COLUMN','EMPLOYEE_PERSON_ID' , FALSE);
1198: FND_MSG_PUB.ADD;
1199: END IF;
1200: END IF;
1201: END IF;
1234:
1235: IF (p_value < 0) THEN
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1238: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
1239: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
1240: FND_MSG_PUB.ADD;
1241: END IF;
1242: END IF;
1235: IF (p_value < 0) THEN
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1238: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
1239: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
1240: FND_MSG_PUB.ADD;
1241: END IF;
1242: END IF;
1243:
1281: IF (C_salescredit_type%NOTFOUND) THEN
1282: CLOSE C_salescredit_type;
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1285: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1286: FND_MESSAGE.Set_Token('COLUMN', 'SALES CREDIT TYPE', FALSE);
1287: FND_MESSAGE.Set_Token('VALUE',to_char(p_salescredit_type_id),FALSE);
1288: FND_MSG_PUB.ADD;
1289: END IF;
1282: CLOSE C_salescredit_type;
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1285: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1286: FND_MESSAGE.Set_Token('COLUMN', 'SALES CREDIT TYPE', FALSE);
1287: FND_MESSAGE.Set_Token('VALUE',to_char(p_salescredit_type_id),FALSE);
1288: FND_MSG_PUB.ADD;
1289: END IF;
1290: ELSE
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1285: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1286: FND_MESSAGE.Set_Token('COLUMN', 'SALES CREDIT TYPE', FALSE);
1287: FND_MESSAGE.Set_Token('VALUE',to_char(p_salescredit_type_id),FALSE);
1288: FND_MSG_PUB.ADD;
1289: END IF;
1290: ELSE
1291: CLOSE C_salescredit_type;
1326: IF (C_party_type%NOTFOUND) THEN
1327: CLOSE C_party_type;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1330: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1331: FND_MESSAGE.Set_Token('COLUMN', 'PARTY TYPE', FALSE);
1332: FND_MESSAGE.Set_Token('VALUE',p_party_type,FALSE);
1333: FND_MSG_PUB.ADD;
1334: END IF;
1327: CLOSE C_party_type;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1330: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1331: FND_MESSAGE.Set_Token('COLUMN', 'PARTY TYPE', FALSE);
1332: FND_MESSAGE.Set_Token('VALUE',p_party_type,FALSE);
1333: FND_MSG_PUB.ADD;
1334: END IF;
1335: ELSE
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1330: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1331: FND_MESSAGE.Set_Token('COLUMN', 'PARTY TYPE', FALSE);
1332: FND_MESSAGE.Set_Token('VALUE',p_party_type,FALSE);
1333: FND_MSG_PUB.ADD;
1334: END IF;
1335: ELSE
1336: CLOSE C_party_type;
1421: IF (C_emp_res%NOTFOUND) OR l_person_id IS NULL OR l_person_id = FND_API.G_MISS_NUM THEN
1422: CLOSE C_emp_res;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
1426: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
1427: FND_MSG_PUB.ADD;
1428: END IF;
1429: ELSIF l_person_id <> p_employee_person_id THEN
1422: CLOSE C_emp_res;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
1426: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
1427: FND_MSG_PUB.ADD;
1428: END IF;
1429: ELSIF l_person_id <> p_employee_person_id THEN
1430: CLOSE C_emp_res;
1429: ELSIF l_person_id <> p_employee_person_id THEN
1430: CLOSE C_emp_res;
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1433: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
1434: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
1435: FND_MSG_PUB.ADD;
1436: END IF;
1437: END IF;
1430: CLOSE C_emp_res;
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1433: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
1434: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
1435: FND_MSG_PUB.ADD;
1436: END IF;
1437: END IF;
1438: END IF;
1469: IF (C_resource_group%NOTFOUND) THEN
1470: CLOSE C_resource_group;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1473: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1474: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE GROUP', FALSE);
1475: FND_MESSAGE.Set_Token('VALUE',to_char(p_resource_group_id),FALSE);
1476: FND_MSG_PUB.ADD;
1477: END IF;
1470: CLOSE C_resource_group;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1473: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1474: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE GROUP', FALSE);
1475: FND_MESSAGE.Set_Token('VALUE',to_char(p_resource_group_id),FALSE);
1476: FND_MSG_PUB.ADD;
1477: END IF;
1478: ELSE
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1473: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1474: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE GROUP', FALSE);
1475: FND_MESSAGE.Set_Token('VALUE',to_char(p_resource_group_id),FALSE);
1476: FND_MSG_PUB.ADD;
1477: END IF;
1478: ELSE
1479: CLOSE C_resource_group;
1514: IF (C_party_object_type%NOTFOUND) THEN
1515: CLOSE C_party_object_type;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1518: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1519: FND_MESSAGE.Set_Token('COLUMN', 'PARTY OBJECT TYPE', FALSE);
1520: FND_MESSAGE.Set_Token('VALUE',p_party_object_type,FALSE);
1521: FND_MSG_PUB.ADD;
1522: END IF;
1515: CLOSE C_party_object_type;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1518: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1519: FND_MESSAGE.Set_Token('COLUMN', 'PARTY OBJECT TYPE', FALSE);
1520: FND_MESSAGE.Set_Token('VALUE',p_party_object_type,FALSE);
1521: FND_MSG_PUB.ADD;
1522: END IF;
1523: ELSE
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1518: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1519: FND_MESSAGE.Set_Token('COLUMN', 'PARTY OBJECT TYPE', FALSE);
1520: FND_MESSAGE.Set_Token('VALUE',p_party_object_type,FALSE);
1521: FND_MSG_PUB.ADD;
1522: END IF;
1523: ELSE
1524: CLOSE C_party_object_type;
1562: IF p_party_object_type IS NOT NULL and p_party_object_type <> FND_API.G_MISS_CHAR THEN
1563: IF p_party_object_id is null OR p_party_object_id = FND_API.G_MISS_NUM THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1566: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
1567: FND_MESSAGE.Set_Token('COLUMN', 'PARTY OBJECT ID', FALSE);
1568: FND_MSG_PUB.ADD;
1569: END IF;
1570: END IF;
1563: IF p_party_object_id is null OR p_party_object_id = FND_API.G_MISS_NUM THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1566: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
1567: FND_MESSAGE.Set_Token('COLUMN', 'PARTY OBJECT ID', FALSE);
1568: FND_MSG_PUB.ADD;
1569: END IF;
1570: END IF;
1571:
1588: IF (C_contact_point%NOTFOUND) THEN
1589: CLOSE C_contact_point;
1590: x_return_status := FND_API.G_RET_STS_ERROR;
1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1592: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1593: FND_MESSAGE.Set_Token('COLUMN', 'CONTACT POINT', FALSE);
1594: FND_MSG_PUB.ADD;
1595: END IF;
1596: ELSE
1589: CLOSE C_contact_point;
1590: x_return_status := FND_API.G_RET_STS_ERROR;
1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1592: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1593: FND_MESSAGE.Set_Token('COLUMN', 'CONTACT POINT', FALSE);
1594: FND_MSG_PUB.ADD;
1595: END IF;
1596: ELSE
1597: CLOSE C_contact_point;
1642: ELSE
1643: CLOSE C_quote_number;
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1646: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1647: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE NUMBER', FALSE);
1648: FND_MSG_PUB.ADD;
1649: END IF;
1650: END IF;
1643: CLOSE C_quote_number;
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1646: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1647: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE NUMBER', FALSE);
1648: FND_MSG_PUB.ADD;
1649: END IF;
1650: END IF;
1651:
1681: FETCH desc_flex_exists INTO l_flex_exists;
1682: IF desc_flex_exists%NOTFOUND THEN
1683: CLOSE desc_flex_exists;
1684: x_return_status := FND_API.G_RET_STS_ERROR;
1685: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_NAME');
1686: FND_MESSAGE.SET_TOKEN('FLEX_NAME',p_desc_flex_name);
1687: FND_MSG_PUB.ADD ;
1688: return;
1689: END IF;
1682: IF desc_flex_exists%NOTFOUND THEN
1683: CLOSE desc_flex_exists;
1684: x_return_status := FND_API.G_RET_STS_ERROR;
1685: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_NAME');
1686: FND_MESSAGE.SET_TOKEN('FLEX_NAME',p_desc_flex_name);
1687: FND_MSG_PUB.ADD ;
1688: return;
1689: END IF;
1690: CLOSE desc_flex_exists;
1709:
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1711: THEN
1712:
1713: FND_MESSAGE.SET_NAME('ASO', 'ASO_DESC_FLEX_INVALID');
1714: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
1715: FND_MSG_PUB.ADD ;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: l_error_msg := FND_FLEX_DESCVAL.error_message;
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1711: THEN
1712:
1713: FND_MESSAGE.SET_NAME('ASO', 'ASO_DESC_FLEX_INVALID');
1714: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
1715: FND_MSG_PUB.ADD ;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: l_error_msg := FND_FLEX_DESCVAL.error_message;
1718: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_MSG');
1714: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
1715: FND_MSG_PUB.ADD ;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: l_error_msg := FND_FLEX_DESCVAL.error_message;
1718: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_MSG');
1719: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_error_msg);
1720: FND_MSG_PUB.ADD ;
1721: END IF;
1722:
1715: FND_MSG_PUB.ADD ;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: l_error_msg := FND_FLEX_DESCVAL.error_message;
1718: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_MSG');
1719: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_error_msg);
1720: FND_MSG_PUB.ADD ;
1721: END IF;
1722:
1723: l_count := fnd_flex_descval.segment_count;
1819: NVL(l_termination_date, sysdate))OR
1820: l_account_status <> 'A') THEN
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1823: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1824: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
1825: FND_MESSAGE.Set_Token('VALUE',to_char(p_cust_account_id),FALSE);
1826: FND_MSG_PUB.ADD;
1827: END IF;
1820: l_account_status <> 'A') THEN
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1823: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1824: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
1825: FND_MESSAGE.Set_Token('VALUE',to_char(p_cust_account_id),FALSE);
1826: FND_MSG_PUB.ADD;
1827: END IF;
1828:
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1823: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1824: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
1825: FND_MESSAGE.Set_Token('VALUE',to_char(p_cust_account_id),FALSE);
1826: FND_MSG_PUB.ADD;
1827: END IF;
1828:
1829: END IF;
1847: l_account_status <> 'A') THEN
1848:
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1851: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_CUST_ACCOUNT', FALSE);
1853: FND_MESSAGE.Set_Token('VALUE',to_char(p_inv_cust_account_id),FALSE);
1854: FND_MSG_PUB.ADD;
1855: END IF;
1848:
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1851: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_CUST_ACCOUNT', FALSE);
1853: FND_MESSAGE.Set_Token('VALUE',to_char(p_inv_cust_account_id),FALSE);
1854: FND_MSG_PUB.ADD;
1855: END IF;
1856:
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1851: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1852: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_CUST_ACCOUNT', FALSE);
1853: FND_MESSAGE.Set_Token('VALUE',to_char(p_inv_cust_account_id),FALSE);
1854: FND_MSG_PUB.ADD;
1855: END IF;
1856:
1857: END IF;
1869: l_account_status <> 'A') THEN
1870:
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1873: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1874: FND_MESSAGE.Set_Token('COLUMN', 'END_CUST_ACCOUNT', FALSE);
1875: FND_MESSAGE.Set_Token('VALUE',to_char(p_end_cust_account_id),FALSE);
1876: FND_MSG_PUB.ADD;
1877: END IF;
1870:
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1873: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1874: FND_MESSAGE.Set_Token('COLUMN', 'END_CUST_ACCOUNT', FALSE);
1875: FND_MESSAGE.Set_Token('VALUE',to_char(p_end_cust_account_id),FALSE);
1876: FND_MSG_PUB.ADD;
1877: END IF;
1878:
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1873: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1874: FND_MESSAGE.Set_Token('COLUMN', 'END_CUST_ACCOUNT', FALSE);
1875: FND_MESSAGE.Set_Token('VALUE',to_char(p_end_cust_account_id),FALSE);
1876: FND_MSG_PUB.ADD;
1877: END IF;
1878:
1879: END IF;
1891: l_account_status <> 'A') THEN
1892:
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1895: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1896: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_CUST_ACCOUNT', FALSE);
1897: FND_MESSAGE.Set_Token('VALUE',to_char(p_shp_cust_account_id),FALSE);
1898: FND_MSG_PUB.ADD;
1899: END IF;
1892:
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1895: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1896: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_CUST_ACCOUNT', FALSE);
1897: FND_MESSAGE.Set_Token('VALUE',to_char(p_shp_cust_account_id),FALSE);
1898: FND_MSG_PUB.ADD;
1899: END IF;
1900:
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1895: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1896: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_CUST_ACCOUNT', FALSE);
1897: FND_MESSAGE.Set_Token('VALUE',to_char(p_shp_cust_account_id),FALSE);
1898: FND_MSG_PUB.ADD;
1899: END IF;
1900:
1901: END IF;
1956: IF (C_Contact%NOTFOUND OR l_status <>'A') THEN
1957:
1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1960: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1961: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1962: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1963: FND_MSG_PUB.ADD;
1964: END IF;
1957:
1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1960: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1961: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1962: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1963: FND_MSG_PUB.ADD;
1964: END IF;
1965: ELSE
1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1960: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1961: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1962: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1963: FND_MSG_PUB.ADD;
1964: END IF;
1965: ELSE
1966: OPEN C_Party_Cust(l_subject_id);
1972: IF ( C_Party_Cust%NOTFOUND OR l_status <> 'A' OR l_party_type <> 'PERSON' ) THEN
1973: CLOSE C_Party_Cust;
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1976: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1977: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1978: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1979: FND_MSG_PUB.ADD;
1980: END IF;
1973: CLOSE C_Party_Cust;
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1976: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1977: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1978: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1979: FND_MSG_PUB.ADD;
1980: END IF;
1981: END IF;
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1976: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1977: FND_MESSAGE.Set_Token('COLUMN', 'org_contact_id', FALSE);
1978: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
1979: FND_MSG_PUB.ADD;
1980: END IF;
1981: END IF;
1982: CLOSE C_Party_Cust;
2023: IF (C_Party%NOTFOUND OR l_party_status <> 'A') THEN
2024: CLOSE C_Party;
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2027: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2028: FND_MESSAGE.Set_Token('COLUMN', 'party_Id', FALSE);
2029: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2030: FND_MSG_PUB.ADD;
2031: END IF;
2024: CLOSE C_Party;
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2027: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2028: FND_MESSAGE.Set_Token('COLUMN', 'party_Id', FALSE);
2029: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2030: FND_MSG_PUB.ADD;
2031: END IF;
2032: ELSE
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2027: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2028: FND_MESSAGE.Set_Token('COLUMN', 'party_Id', FALSE);
2029: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2030: FND_MSG_PUB.ADD;
2031: END IF;
2032: ELSE
2033: CLOSE C_Party;
2077: CLOSE C_Party;
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2080: IF p_site_use ='BILL_TO' THEN
2081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2082: FND_MESSAGE.Set_Token('COLUMN', 'Invoice_to_party_Id', FALSE);
2083: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2080: IF p_site_use ='BILL_TO' THEN
2081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2082: FND_MESSAGE.Set_Token('COLUMN', 'Invoice_to_party_Id', FALSE);
2083: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2086: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2079: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2080: IF p_site_use ='BILL_TO' THEN
2081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2082: FND_MESSAGE.Set_Token('COLUMN', 'Invoice_to_party_Id', FALSE);
2083: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2086: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2087: FND_MESSAGE.Set_Token('COLUMN', 'End_Customer_party_Id', FALSE);
2082: FND_MESSAGE.Set_Token('COLUMN', 'Invoice_to_party_Id', FALSE);
2083: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2086: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2087: FND_MESSAGE.Set_Token('COLUMN', 'End_Customer_party_Id', FALSE);
2088: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2083: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2086: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2087: FND_MESSAGE.Set_Token('COLUMN', 'End_Customer_party_Id', FALSE);
2088: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2084: FND_MSG_PUB.ADD;
2085: ELSIF p_site_use ='END_USER' THEN
2086: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2087: FND_MESSAGE.Set_Token('COLUMN', 'End_Customer_party_Id', FALSE);
2088: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2092: FND_MESSAGE.Set_Token('COLUMN', 'Ship_to_party_Id', FALSE);
2087: FND_MESSAGE.Set_Token('COLUMN', 'End_Customer_party_Id', FALSE);
2088: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2092: FND_MESSAGE.Set_Token('COLUMN', 'Ship_to_party_Id', FALSE);
2093: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2094: FND_MSG_PUB.ADD;
2095: END IF;
2088: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2092: FND_MESSAGE.Set_Token('COLUMN', 'Ship_to_party_Id', FALSE);
2093: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2094: FND_MSG_PUB.ADD;
2095: END IF;
2096: END IF;
2089: FND_MSG_PUB.ADD;
2090: ELSIF p_site_use ='SHIP_TO' THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2092: FND_MESSAGE.Set_Token('COLUMN', 'Ship_to_party_Id', FALSE);
2093: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_id),FALSE);
2094: FND_MSG_PUB.ADD;
2095: END IF;
2096: END IF;
2097: ELSE
2149: IF (p_party_site_id IS NULL OR p_party_site_id = FND_API.G_MISS_NUM) THEN
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151: IF p_party_site_use = 'BILL_TO' THEN
2152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2153: FND_MESSAGE.Set_Name('ASO', 'ASO_BILL_ADDRESS_REQD');
2154: FND_MSG_PUB.ADD;
2155: END IF;
2156: ELSIF p_party_site_use = 'END_USER' THEN
2157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2154: FND_MSG_PUB.ADD;
2155: END IF;
2156: ELSIF p_party_site_use = 'END_USER' THEN
2157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2158: FND_MESSAGE.Set_Name('ASO', 'ASO_END_ADDRESS_REQD');
2159: FND_MSG_PUB.ADD;
2160: END IF;
2161: ELSIF p_party_site_use = 'SHIP_TO' THEN
2162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2159: FND_MSG_PUB.ADD;
2160: END IF;
2161: ELSIF p_party_site_use = 'SHIP_TO' THEN
2162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2163: FND_MESSAGE.Set_Name('ASO', 'ASO_SHIP_ADDRESS_REQD');
2164: FND_MSG_PUB.ADD;
2165: END IF;
2166: END IF;
2167: END IF;
2172: IF (C_Inv_Party_Site%NOTFOUND OR
2173: l_status <> 'A') THEN
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2176: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2177: FND_MESSAGE.Set_Token('COLUMN', 'party_site_id', FALSE);
2178: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_site_id),FALSE);
2179: FND_MSG_PUB.ADD;
2180: END IF;
2173: l_status <> 'A') THEN
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2176: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2177: FND_MESSAGE.Set_Token('COLUMN', 'party_site_id', FALSE);
2178: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_site_id),FALSE);
2179: FND_MSG_PUB.ADD;
2180: END IF;
2181: END IF;
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2176: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2177: FND_MESSAGE.Set_Token('COLUMN', 'party_site_id', FALSE);
2178: FND_MESSAGE.Set_Token('VALUE',to_char(p_party_site_id),FALSE);
2179: FND_MSG_PUB.ADD;
2180: END IF;
2181: END IF;
2182: CLOSE C_Inv_Party_Site;
2263: IF (C_Account%NOTFOUND OR l_account_status <> 'A') THEN
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2266: THEN
2267: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_PARTY_CRS');
2268: FND_MSG_PUB.ADD;
2269: END IF;
2270: END IF;
2271: CLOSE C_Account;
2283: IF (p_cust_party_id IS NOT NULL AND p_cust_party_id <> FND_API.G_MISS_NUM) THEN
2284: IF p_party_id <> p_cust_party_id THEN
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_PARTY_CRS');
2288: FND_MSG_PUB.ADD;
2289: END IF;
2290: END IF;
2291: END IF;
2298: aso_debug_pub.add('Validate_PtyCrs: Person_Reltn: '||l_dummy, 1, 'N');
2299: END IF;
2300: x_return_status := FND_API.G_RET_STS_ERROR;
2301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2302: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_RELATIONSHIP');
2303: FND_MSG_PUB.ADD;
2304: END IF;
2305: END IF;
2306: CLOSE C_Person_Reltn;
2313: aso_debug_pub.add('Validate_PtyCrs: Cust_Party Relation not found: '||l_test, 1, 'N');
2314: END IF;
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2317: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_PARTY_CRS');
2318: FND_MSG_PUB.ADD;
2319: END IF;
2320: END IF;
2321: END IF;
2329: aso_debug_pub.add('Validate_PtyCrs: Org Relation not found: '||l_test, 1, 'N');
2330: END IF;
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2333: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_PARTY_CRS');
2334: FND_MSG_PUB.ADD;
2335: END IF;
2336: END IF;
2337: CLOSE C_org_reltn;
2468: END IF;
2469: IF l_dummy = 'X' THEN
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2472: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_RELATIONSHIP');
2473: FND_MSG_PUB.ADD;
2474: END IF;
2475: END IF;
2476: CLOSE C_Person_Reltn;
2503: IF C_val_inv_id%NOTFOUND or l_exist IS NULL THEN
2504: x_return_status := FND_API.G_RET_STS_ERROR;
2505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
2506: IF p_site_use = 'BILL_TO' THEN
2507: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_INV_PARTY_PT_CRS');
2508: ELSIF p_site_use = 'END_USER' THEN
2509: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_END_PARTY_PT_CRS');
2510: ELSIF p_site_use = 'SHIP_TO' THEN
2511: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_SHP_PARTY_PT_CRS');
2505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
2506: IF p_site_use = 'BILL_TO' THEN
2507: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_INV_PARTY_PT_CRS');
2508: ELSIF p_site_use = 'END_USER' THEN
2509: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_END_PARTY_PT_CRS');
2510: ELSIF p_site_use = 'SHIP_TO' THEN
2511: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_SHP_PARTY_PT_CRS');
2512: END IF;
2513: FND_MSG_PUB.ADD;
2507: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_INV_PARTY_PT_CRS');
2508: ELSIF p_site_use = 'END_USER' THEN
2509: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_END_PARTY_PT_CRS');
2510: ELSIF p_site_use = 'SHIP_TO' THEN
2511: FND_MESSAGE.Set_Name('ASO','ASO_VALIDATE_SHP_PARTY_PT_CRS');
2512: END IF;
2513: FND_MSG_PUB.ADD;
2514: END IF;
2515: END IF;
2684: END IF;
2685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
2687: IF p_site_usage = 'BILL_TO' THEN
2688: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2689: ELSIF p_site_usage = 'END_USER' THEN
2690: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
2691: ELSIF p_site_usage = 'SHIP_TO' THEN
2692: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
2687: IF p_site_usage = 'BILL_TO' THEN
2688: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2689: ELSIF p_site_usage = 'END_USER' THEN
2690: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
2691: ELSIF p_site_usage = 'SHIP_TO' THEN
2692: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
2693: ELSIF p_site_usage = 'SOLD_TO' THEN
2694: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SLD_SITE_AC_CRS'); -- Sold_to
2688: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2689: ELSIF p_site_usage = 'END_USER' THEN
2690: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
2691: ELSIF p_site_usage = 'SHIP_TO' THEN
2692: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
2693: ELSIF p_site_usage = 'SOLD_TO' THEN
2694: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SLD_SITE_AC_CRS'); -- Sold_to
2695: END IF;
2696: FND_MSG_PUB.ADD;
2690: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
2691: ELSIF p_site_usage = 'SHIP_TO' THEN
2692: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
2693: ELSIF p_site_usage = 'SOLD_TO' THEN
2694: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SLD_SITE_AC_CRS'); -- Sold_to
2695: END IF;
2696: FND_MSG_PUB.ADD;
2697: END IF;
2698: END IF;
2755: FETCH C_Contact INTO l_object_id,l_status ;
2756: IF (C_Contact%NOTFOUND OR l_status <> 'A') THEN
2757: x_return_status := FND_API.G_RET_STS_ERROR;
2758: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2759: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'Org_contact_id', FALSE);
2761: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
2762: FND_MSG_PUB.ADD;
2763: END IF;
2756: IF (C_Contact%NOTFOUND OR l_status <> 'A') THEN
2757: x_return_status := FND_API.G_RET_STS_ERROR;
2758: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2759: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'Org_contact_id', FALSE);
2761: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
2762: FND_MSG_PUB.ADD;
2763: END IF;
2764: END IF;
2757: x_return_status := FND_API.G_RET_STS_ERROR;
2758: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2759: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'Org_contact_id', FALSE);
2761: FND_MESSAGE.Set_Token('VALUE',to_char(p_contact_id),FALSE);
2762: FND_MSG_PUB.ADD;
2763: END IF;
2764: END IF;
2765: CLOSE C_Contact;
2773: FETCH C_Cust_account INTO l_acct_status ;
2774: IF C_Cust_account%NOTFOUND or l_acct_status <>'A' THEN
2775: x_return_status := FND_API.G_RET_STS_ERROR;
2776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2777: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
2778: -- FND_MESSAGE.Set_Name('ASO', 'INVALID_OBJECT_PARTY_ID');
2779:
2780: FND_MSG_PUB.ADD;
2781: END IF;
2774: IF C_Cust_account%NOTFOUND or l_acct_status <>'A' THEN
2775: x_return_status := FND_API.G_RET_STS_ERROR;
2776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2777: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
2778: -- FND_MESSAGE.Set_Name('ASO', 'INVALID_OBJECT_PARTY_ID');
2779:
2780: FND_MSG_PUB.ADD;
2781: END IF;
2782: END IF;
2796:
2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2799:
2800: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_PTY_CRS');
2801:
2802: FND_MSG_PUB.ADD;
2803: END IF;
2804: CLOSE C_Contact;
2810: FETCH c_party into l_party_status;
2811: IF c_party%NOTFOUND or l_party_status <> 'A' THEN
2812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2813: THEN
2814: FND_MESSAGE.Set_Name('ASO',
2815: 'ASO_VALIDATE_ORG_CON_PTY_CRS');
2816: --FND_MESSAGE.Set_Token('COLUMN', 'Org_contact_id', FALSE);
2817: FND_MSG_PUB.ADD;
2818: END IF;
2812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2813: THEN
2814: FND_MESSAGE.Set_Name('ASO',
2815: 'ASO_VALIDATE_ORG_CON_PTY_CRS');
2816: --FND_MESSAGE.Set_Token('COLUMN', 'Org_contact_id', FALSE);
2817: FND_MSG_PUB.ADD;
2818: END IF;
2819: END IF;
2820: CLOSE c_party;
3582: IF C1%NOTFOUND or l_exist is NULL THEN
3583: CLOSE C1;
3584: x_return_status := FND_API.G_RET_STS_ERROR;
3585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3586: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3587: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_OBJECT_TYPE_CODE', FALSE);
3588: FND_MESSAGE.Set_Token('VALUE',P_QUOTE_OBJECT_TYPE_CODE,FALSE);
3589: FND_MSG_PUB.ADD;
3590: END IF;
3583: CLOSE C1;
3584: x_return_status := FND_API.G_RET_STS_ERROR;
3585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3586: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3587: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_OBJECT_TYPE_CODE', FALSE);
3588: FND_MESSAGE.Set_Token('VALUE',P_QUOTE_OBJECT_TYPE_CODE,FALSE);
3589: FND_MSG_PUB.ADD;
3590: END IF;
3591:
3584: x_return_status := FND_API.G_RET_STS_ERROR;
3585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3586: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3587: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_OBJECT_TYPE_CODE', FALSE);
3588: FND_MESSAGE.Set_Token('VALUE',P_QUOTE_OBJECT_TYPE_CODE,FALSE);
3589: FND_MSG_PUB.ADD;
3590: END IF;
3591:
3592: ELSE
3629: IF C1%NOTFOUND or l_exist is NULL THEN
3630: CLOSE C1;
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3633: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3634: FND_MESSAGE.Set_Token('COLUMN', 'OBJECT_TYPE_CODE', FALSE);
3635: FND_MESSAGE.Set_Token('VALUE',p_OBJECT_TYPE_CODE,FALSE);
3636: FND_MSG_PUB.ADD;
3637: END IF;
3630: CLOSE C1;
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3633: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3634: FND_MESSAGE.Set_Token('COLUMN', 'OBJECT_TYPE_CODE', FALSE);
3635: FND_MESSAGE.Set_Token('VALUE',p_OBJECT_TYPE_CODE,FALSE);
3636: FND_MSG_PUB.ADD;
3637: END IF;
3638:
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3633: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3634: FND_MESSAGE.Set_Token('COLUMN', 'OBJECT_TYPE_CODE', FALSE);
3635: FND_MESSAGE.Set_Token('VALUE',p_OBJECT_TYPE_CODE,FALSE);
3636: FND_MSG_PUB.ADD;
3637: END IF;
3638:
3639: ELSE
3675: IF C1%NOTFOUND or l_exist is NULL THEN
3676: CLOSE C1;
3677: x_return_status := FND_API.G_RET_STS_ERROR;
3678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3679: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3680: FND_MESSAGE.Set_Token('COLUMN', 'RELATIONSHIP_TYPE_CODE', FALSE);
3681: FND_MESSAGE.Set_Token('VALUE',P_RELATIONSHIP_TYPE_CODE,FALSE);
3682: FND_MSG_PUB.ADD;
3683: END IF;
3676: CLOSE C1;
3677: x_return_status := FND_API.G_RET_STS_ERROR;
3678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3679: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3680: FND_MESSAGE.Set_Token('COLUMN', 'RELATIONSHIP_TYPE_CODE', FALSE);
3681: FND_MESSAGE.Set_Token('VALUE',P_RELATIONSHIP_TYPE_CODE,FALSE);
3682: FND_MSG_PUB.ADD;
3683: END IF;
3684:
3677: x_return_status := FND_API.G_RET_STS_ERROR;
3678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3679: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3680: FND_MESSAGE.Set_Token('COLUMN', 'RELATIONSHIP_TYPE_CODE', FALSE);
3681: FND_MESSAGE.Set_Token('VALUE',P_RELATIONSHIP_TYPE_CODE,FALSE);
3682: FND_MSG_PUB.ADD;
3683: END IF;
3684:
3685: ELSE
3722: NVL(l_end_date, sysdate))) THEN
3723: CLOSE C_Minisite;
3724: x_return_status := FND_API.G_RET_STS_ERROR;
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3727: FND_MESSAGE.Set_Token('COLUMN', 'MSITE_ID', FALSE);
3728: FND_MESSAGE.Set_Token('VALUE',to_char(p_minisite_id),FALSE);
3729: FND_MSG_PUB.ADD;
3730: END IF;
3723: CLOSE C_Minisite;
3724: x_return_status := FND_API.G_RET_STS_ERROR;
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3727: FND_MESSAGE.Set_Token('COLUMN', 'MSITE_ID', FALSE);
3728: FND_MESSAGE.Set_Token('VALUE',to_char(p_minisite_id),FALSE);
3729: FND_MSG_PUB.ADD;
3730: END IF;
3731: ELSE
3724: x_return_status := FND_API.G_RET_STS_ERROR;
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3727: FND_MESSAGE.Set_Token('COLUMN', 'MSITE_ID', FALSE);
3728: FND_MESSAGE.Set_Token('VALUE',to_char(p_minisite_id),FALSE);
3729: FND_MSG_PUB.ADD;
3730: END IF;
3731: ELSE
3732: CLOSE C_Minisite;
3766: NVL(l_end_date, sysdate))) THEN
3767: CLOSE C_Section;
3768: x_return_status := FND_API.G_RET_STS_ERROR;
3769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3770: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3771: FND_MESSAGE.Set_Token('COLUMN', 'SECTION_ID', FALSE);
3772: FND_MESSAGE.Set_Token('VALUE',to_char(p_section_id),FALSE);
3773: FND_MSG_PUB.ADD;
3774: END IF;
3767: CLOSE C_Section;
3768: x_return_status := FND_API.G_RET_STS_ERROR;
3769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3770: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3771: FND_MESSAGE.Set_Token('COLUMN', 'SECTION_ID', FALSE);
3772: FND_MESSAGE.Set_Token('VALUE',to_char(p_section_id),FALSE);
3773: FND_MSG_PUB.ADD;
3774: END IF;
3775: ELSE
3768: x_return_status := FND_API.G_RET_STS_ERROR;
3769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3770: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3771: FND_MESSAGE.Set_Token('COLUMN', 'SECTION_ID', FALSE);
3772: FND_MESSAGE.Set_Token('VALUE',to_char(p_section_id),FALSE);
3773: FND_MSG_PUB.ADD;
3774: END IF;
3775: ELSE
3776: CLOSE C_Section;
3849: --IF nvl(l_percent_total,0) <> 100 THEN --commented to fix bug5671266
3850: IF l_percent_total IS NOT NULL AND l_percent_total <> 100 THEN
3851: x_return_status := FND_API.G_RET_STS_ERROR;
3852: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3853: FND_MESSAGE.Set_Name('ASO', 'ASO_SALES_CREDIT_PERCENT');
3854: FND_MSG_PUB.ADD;
3855: END IF;
3856: END IF;
3857:
3884: IF p_qte_line_rec.LINE_CATEGORY_CODE = 'RETURN' THEN
3885: IF p_sales_credit_tbl.count > 0 THEN
3886: x_return_status := FND_API.G_RET_STS_ERROR;
3887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3888: FND_MESSAGE.Set_Name('ASO', 'ASO_SALES_CREDIT_RETURN');
3889: FND_MSG_PUB.ADD;
3890: END IF;
3891: END IF;
3892: END IF;
4077: aso_debug_pub.add('Validate_Commitment-Invalid Commitment: ', 1, 'N');
4078: END IF;
4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4081: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_COMMITMENT');
4082: FND_MSG_PUB.ADD;
4083: END IF;
4084: END IF;
4085:
4166: aso_debug_pub.add('Validate_Commitment-Invalid Commitment: ', 1, 'N');
4167: END IF;
4168: x_return_status := FND_API.G_RET_STS_ERROR;
4169: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4170: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_COMMITMENT');
4171: FND_MSG_PUB.ADD;
4172: END IF;
4173: END IF;
4174:
4221: aso_debug_pub.add('Validate_Agreement-Agreement Not Found', 1, 'N');
4222: END IF;
4223: x_return_status := FND_API.G_RET_STS_ERROR;
4224: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4225: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_AGREEMENT');
4226: FND_MSG_PUB.ADD;
4227: END IF;
4228: END IF;
4229:
4232: aso_debug_pub.add('Validate_Agreement-Agreement Invalid', 1, 'N');
4233: END IF;
4234: x_return_status := FND_API.G_RET_STS_ERROR;
4235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4236: FND_MESSAGE.Set_Name('ASO', 'ASO_INACTIVE_AGREEMENT');
4237: FND_MSG_PUB.ADD;
4238: END IF;
4239: END IF;
4240:
4279: x_msg_data => x_msg_data);
4280:
4281: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4283: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4284: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_STATUS_ID', FALSE);
4285: FND_MESSAGE.Set_Token('VALUE',to_char(p_source_status_id),FALSE);
4286: FND_MSG_PUB.ADD;
4287: END IF;
4280:
4281: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4283: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4284: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_STATUS_ID', FALSE);
4285: FND_MESSAGE.Set_Token('VALUE',to_char(p_source_status_id),FALSE);
4286: FND_MSG_PUB.ADD;
4287: END IF;
4288: RETURN;
4281: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4283: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4284: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_STATUS_ID', FALSE);
4285: FND_MESSAGE.Set_Token('VALUE',to_char(p_source_status_id),FALSE);
4286: FND_MSG_PUB.ADD;
4287: END IF;
4288: RETURN;
4289: END IF;
4296: x_msg_data => x_msg_data);
4297:
4298: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4300: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4301: FND_MESSAGE.Set_Token('COLUMN', 'DEST_STATUS_ID', FALSE);
4302: FND_MESSAGE.Set_Token('VALUE',to_char(p_dest_status_id),FALSE);
4303: FND_MSG_PUB.ADD;
4304: END IF;
4297:
4298: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4300: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4301: FND_MESSAGE.Set_Token('COLUMN', 'DEST_STATUS_ID', FALSE);
4302: FND_MESSAGE.Set_Token('VALUE',to_char(p_dest_status_id),FALSE);
4303: FND_MSG_PUB.ADD;
4304: END IF;
4305: RETURN;
4298: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4300: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4301: FND_MESSAGE.Set_Token('COLUMN', 'DEST_STATUS_ID', FALSE);
4302: FND_MESSAGE.Set_Token('VALUE',to_char(p_dest_status_id),FALSE);
4303: FND_MSG_PUB.ADD;
4304: END IF;
4305: RETURN;
4306: END IF;
4309: FETCH c_transition INTO l_transition_id, l_enabled_flag;
4310: IF (c_transition%NOTFOUND) THEN
4311: x_return_status := FND_API.G_RET_STS_ERROR;
4312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4313: FND_MESSAGE.Set_Name('ASO', 'ASO_NONEXISTENT_STATUS_TRANS');
4314: FND_MSG_PUB.ADD;
4315: END IF;
4316: ELSIF (l_enabled_flag <> 'Y') THEN
4317: x_return_status := FND_API.G_RET_STS_ERROR;
4315: END IF;
4316: ELSIF (l_enabled_flag <> 'Y') THEN
4317: x_return_status := FND_API.G_RET_STS_ERROR;
4318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4319: FND_MESSAGE.Set_Name('ASO', 'ASO_DISABLED_STATUS_TRANS');
4320: FND_MSG_PUB.ADD;
4321: END IF;
4322: END IF;
4323: CLOSE c_transition;
4358: IF c_k_template%NOTFOUND
4359: THEN
4360: x_return_status := FND_API.G_RET_STS_ERROR;
4361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4362: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4363: FND_MESSAGE.Set_Token('COLUMN', 'TEMPLATE_ID', FALSE);
4364: FND_MSG_PUB.ADD;
4365: END IF;
4366: ELSE
4359: THEN
4360: x_return_status := FND_API.G_RET_STS_ERROR;
4361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4362: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4363: FND_MESSAGE.Set_Token('COLUMN', 'TEMPLATE_ID', FALSE);
4364: FND_MSG_PUB.ADD;
4365: END IF;
4366: ELSE
4367: IF l_major_version <> p_template_major_version
4367: IF l_major_version <> p_template_major_version
4368: THEN
4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4371: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4372: FND_MESSAGE.Set_Token('COLUMN', 'TEMPLATE_MAJOR_VERSION', FALSE);
4373: FND_MESSAGE.Set_Token('VALUE',to_char(p_template_major_version),FALSE);
4374: FND_MSG_PUB.ADD;
4375: END IF;
4368: THEN
4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4371: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4372: FND_MESSAGE.Set_Token('COLUMN', 'TEMPLATE_MAJOR_VERSION', FALSE);
4373: FND_MESSAGE.Set_Token('VALUE',to_char(p_template_major_version),FALSE);
4374: FND_MSG_PUB.ADD;
4375: END IF;
4376: END IF;
4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4371: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
4372: FND_MESSAGE.Set_Token('COLUMN', 'TEMPLATE_MAJOR_VERSION', FALSE);
4373: FND_MESSAGE.Set_Token('VALUE',to_char(p_template_major_version),FALSE);
4374: FND_MSG_PUB.ADD;
4375: END IF;
4376: END IF;
4377: END IF;
4698: ||m_price_attr_tbl(i).pricing_attribute1,1,'N');
4699: END IF;
4700: x_return_status := FND_API.G_RET_STS_ERROR;
4701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4702: FND_MESSAGE.Set_Name('ASO', 'ASO_VAL_PROMO_DUPLICATE_HDR');
4703: FND_MESSAGE.Set_Token('MODHDRID', m_price_attr_tbl(i).pricing_attribute1, FALSE);
4704: FND_MSG_PUB.Add;
4705: END IF;
4706: --RAISE FND_API.G_EXC_ERROR;
4699: END IF;
4700: x_return_status := FND_API.G_RET_STS_ERROR;
4701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4702: FND_MESSAGE.Set_Name('ASO', 'ASO_VAL_PROMO_DUPLICATE_HDR');
4703: FND_MESSAGE.Set_Token('MODHDRID', m_price_attr_tbl(i).pricing_attribute1, FALSE);
4704: FND_MSG_PUB.Add;
4705: END IF;
4706: --RAISE FND_API.G_EXC_ERROR;
4707: End If;
4877: ||m_price_attr_tbl(i).pricing_attribute2,1,'N');
4878: END IF;
4879: x_return_status := FND_API.G_RET_STS_ERROR;
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'ASO_VAL_PROMO_DUPLICATE_LN');
4882: FND_MESSAGE.Set_Token('MODLNID', m_price_attr_tbl(i).pricing_attribute2, FALSE);
4883: FND_MSG_PUB.Add;
4884: END IF;
4885: --RAISE FND_API.G_EXC_ERROR;
4878: END IF;
4879: x_return_status := FND_API.G_RET_STS_ERROR;
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'ASO_VAL_PROMO_DUPLICATE_LN');
4882: FND_MESSAGE.Set_Token('MODLNID', m_price_attr_tbl(i).pricing_attribute2, FALSE);
4883: FND_MSG_PUB.Add;
4884: END IF;
4885: --RAISE FND_API.G_EXC_ERROR;
4886: End If;
4995: NVL(TRUNC(l_end_date), TRUNC(sysdate)))) THEN
4996: CLOSE C_Payment_Terms;
4997: x_return_status := FND_API.G_RET_STS_ERROR;
4998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4999: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5000: FND_MESSAGE.Set_Token('COLUMN', 'PAYMENT_TERM', FALSE);
5001: FND_MESSAGE.Set_Token('VALUE',to_char(p_payment_term_id),FALSE);
5002: FND_MSG_PUB.ADD;
5003: END IF;
4996: CLOSE C_Payment_Terms;
4997: x_return_status := FND_API.G_RET_STS_ERROR;
4998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4999: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5000: FND_MESSAGE.Set_Token('COLUMN', 'PAYMENT_TERM', FALSE);
5001: FND_MESSAGE.Set_Token('VALUE',to_char(p_payment_term_id),FALSE);
5002: FND_MSG_PUB.ADD;
5003: END IF;
5004: ELSE
4997: x_return_status := FND_API.G_RET_STS_ERROR;
4998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4999: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5000: FND_MESSAGE.Set_Token('COLUMN', 'PAYMENT_TERM', FALSE);
5001: FND_MESSAGE.Set_Token('VALUE',to_char(p_payment_term_id),FALSE);
5002: FND_MSG_PUB.ADD;
5003: END IF;
5004: ELSE
5005: CLOSE C_Payment_Terms;
5053: NVL(TRUNC(l_end_date), TRUNC(sysdate)))) THEN
5054: CLOSE C_Freight_Terms;
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5057: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5058: FND_MESSAGE.Set_Token('COLUMN', 'FREIGHT_TERM', FALSE);
5059: FND_MESSAGE.Set_Token('VALUE',p_freight_terms_code,FALSE);
5060: FND_MSG_PUB.ADD;
5061: END IF;
5054: CLOSE C_Freight_Terms;
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5057: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5058: FND_MESSAGE.Set_Token('COLUMN', 'FREIGHT_TERM', FALSE);
5059: FND_MESSAGE.Set_Token('VALUE',p_freight_terms_code,FALSE);
5060: FND_MSG_PUB.ADD;
5061: END IF;
5062: ELSE
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5057: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5058: FND_MESSAGE.Set_Token('COLUMN', 'FREIGHT_TERM', FALSE);
5059: FND_MESSAGE.Set_Token('VALUE',p_freight_terms_code,FALSE);
5060: FND_MSG_PUB.ADD;
5061: END IF;
5062: ELSE
5063: CLOSE C_Freight_Terms;
5149: l_org_id := TO_NUMBER(OE_PROFILE.VALUE('OE_ORGANIZATION_ID',l_hdr_org_id));
5150: ELSE
5151: x_return_status := FND_API.G_RET_STS_ERROR;
5152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5154: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5155: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5156: FND_MSG_PUB.ADD;
5157: END IF;
5150: ELSE
5151: x_return_status := FND_API.G_RET_STS_ERROR;
5152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5154: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5155: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5156: FND_MSG_PUB.ADD;
5157: END IF;
5158: END IF;
5151: x_return_status := FND_API.G_RET_STS_ERROR;
5152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5154: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5155: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5156: FND_MSG_PUB.ADD;
5157: END IF;
5158: END IF;
5159: CLOSE C_qte_header_org_info;
5176: l_org_id := TO_NUMBER(OE_PROFILE.VALUE('OE_ORGANIZATION_ID',l_line_org_id));
5177: ELSE
5178: x_return_status := FND_API.G_RET_STS_ERROR;
5179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5180: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5181: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5182: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5183: FND_MSG_PUB.ADD;
5184: END IF;
5177: ELSE
5178: x_return_status := FND_API.G_RET_STS_ERROR;
5179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5180: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5181: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5182: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5183: FND_MSG_PUB.ADD;
5184: END IF;
5185: END IF;
5178: x_return_status := FND_API.G_RET_STS_ERROR;
5179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5180: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5181: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5182: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5183: FND_MSG_PUB.ADD;
5184: END IF;
5185: END IF;
5186:
5190: END IF;
5191: ELSIF (p_qte_header_id IS NULL OR p_qte_header_id = FND_API.G_MISS_NUM) THEN
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5194: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5195: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5196: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5197: FND_MSG_PUB.ADD;
5198: END IF;
5191: ELSIF (p_qte_header_id IS NULL OR p_qte_header_id = FND_API.G_MISS_NUM) THEN
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5194: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5195: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5196: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5197: FND_MSG_PUB.ADD;
5198: END IF;
5199: END IF;
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5194: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5195: FND_MESSAGE.Set_Token('COLUMN', 'SHIPPING_METHOD', FALSE);
5196: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5197: FND_MSG_PUB.ADD;
5198: END IF;
5199: END IF;
5200: ELSE -- Ship_from_org_id is not null.
5217: NVL(TRUNC(l_end_date), TRUNC(sysdate)))) THEN
5218: CLOSE C_ship_method_code;
5219: x_return_status := FND_API.G_RET_STS_ERROR;
5220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5222: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD_CODE', FALSE);
5223: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5224: FND_MSG_PUB.ADD;
5225: END IF;
5218: CLOSE C_ship_method_code;
5219: x_return_status := FND_API.G_RET_STS_ERROR;
5220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5222: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD_CODE', FALSE);
5223: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5224: FND_MSG_PUB.ADD;
5225: END IF;
5226: ELSE
5219: x_return_status := FND_API.G_RET_STS_ERROR;
5220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5222: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD_CODE', FALSE);
5223: FND_MESSAGE.Set_Token('VALUE',p_ship_method_code,FALSE);
5224: FND_MSG_PUB.ADD;
5225: END IF;
5226: ELSE
5227: CLOSE C_ship_method_code;
5269:
5270: x_return_status := FND_API.G_RET_STS_ERROR;
5271:
5272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5273: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_TYPE');
5274: FND_MSG_PUB.ADD;
5275: END IF;
5276: END IF;
5277: CLOSE c_ln_type_for_ord_type;
5319: IF (l_quote_category_code <> 'MIXED') THEN
5320:
5321: x_return_status := FND_API.G_RET_STS_ERROR;
5322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5323: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY_CODE');
5324: FND_MSG_PUB.ADD;
5325: END IF;
5326: END IF;
5327:
5399: IF l_ln_hd_po_number is null THEN
5400: x_return_status := FND_API.G_RET_STS_ERROR;
5401:
5402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5403: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_PO_NUMBER');
5404: FND_MSG_PUB.ADD;
5405: END IF;
5406:
5407: end if;
5435:
5436: x_return_status := FND_API.G_RET_STS_ERROR;
5437:
5438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5439: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_PO_NUMBER');
5440: FND_MSG_PUB.ADD;
5441: END IF;
5442: end if;
5443:
5508:
5509: x_return_status := fnd_api.g_ret_sts_error;
5510:
5511: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5512: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5513: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5514: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5515: FND_MSG_PUB.ADD;
5516: END IF;
5509: x_return_status := fnd_api.g_ret_sts_error;
5510:
5511: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5512: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5513: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5514: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5515: FND_MSG_PUB.ADD;
5516: END IF;
5517:
5510:
5511: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5512: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5513: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5514: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5515: FND_MSG_PUB.ADD;
5516: END IF;
5517:
5518: end if;
5532:
5533: x_return_status := fnd_api.g_ret_sts_error;
5534:
5535: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5536: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5537: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5538: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5539: FND_MSG_PUB.ADD;
5540: END IF;
5533: x_return_status := fnd_api.g_ret_sts_error;
5534:
5535: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5536: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5537: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5538: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5539: FND_MSG_PUB.ADD;
5540: END IF;
5541:
5534:
5535: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5536: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5537: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5538: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5539: FND_MSG_PUB.ADD;
5540: END IF;
5541:
5542: end if;
5556:
5557: x_return_status := fnd_api.g_ret_sts_error;
5558:
5559: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5560: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5561: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5562: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5563: FND_MSG_PUB.ADD;
5564: END IF;
5557: x_return_status := fnd_api.g_ret_sts_error;
5558:
5559: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5560: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5561: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5562: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5563: FND_MSG_PUB.ADD;
5564: END IF;
5565:
5558:
5559: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5560: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5561: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5562: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5563: FND_MSG_PUB.ADD;
5564: END IF;
5565:
5566: end if;
5570: elsif p_service_ref_type_code = 'PRODUCT_CATALOG' then
5571: if p_service_ref_line_id is null then
5572: x_return_status := fnd_api.g_ret_sts_error;
5573: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5574: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5575: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5576: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5571: if p_service_ref_line_id is null then
5572: x_return_status := fnd_api.g_ret_sts_error;
5573: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5574: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5575: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5576: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5579:
5572: x_return_status := fnd_api.g_ret_sts_error;
5573: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5574: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
5575: FND_MESSAGE.Set_Token('COLUMN', 'SERVICE_REF_LINE_ID', FALSE);
5576: FND_MESSAGE.Set_Token('VALUE',p_service_ref_line_id,FALSE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5579:
5580:
5864: ELSE
5865: x_quote_header_rec.PHONE_ID := NULL ;
5866: aso_debug_pub.add('No Data Found for Cursor...C_VALIDATE_PHONE_CONTACT', 1, 'Y');
5867:
5868: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
5869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_PHONE_NO', TRUE);
5870: FND_MSG_PUB.ADD;
5871: END IF;
5872: aso_debug_pub.add('before Closing the Cursor...C_VALIDATE_PHONE_CONTACT', 1, 'Y');
5865: x_quote_header_rec.PHONE_ID := NULL ;
5866: aso_debug_pub.add('No Data Found for Cursor...C_VALIDATE_PHONE_CONTACT', 1, 'Y');
5867:
5868: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
5869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_PHONE_NO', TRUE);
5870: FND_MSG_PUB.ADD;
5871: END IF;
5872: aso_debug_pub.add('before Closing the Cursor...C_VALIDATE_PHONE_CONTACT', 1, 'Y');
5873: CLOSE C_VALIDATE_PHONE_CONTACT;
5888: ELSE
5889: x_quote_header_rec.PHONE_ID := NULL ;
5890: aso_debug_pub.add('No Data Found for Cursor...C_VALIDATE_PHONE_CUSTOMER', 1, 'Y');
5891:
5892: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
5893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_PHONE_NO', TRUE);
5894: FND_MSG_PUB.ADD;
5895: END IF;
5896: aso_debug_pub.add('Before Closing the Cursor...C_VALIDATE_PHONE_CUSTOMER', 1, 'Y');
5889: x_quote_header_rec.PHONE_ID := NULL ;
5890: aso_debug_pub.add('No Data Found for Cursor...C_VALIDATE_PHONE_CUSTOMER', 1, 'Y');
5891:
5892: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
5893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_PHONE_NO', TRUE);
5894: FND_MSG_PUB.ADD;
5895: END IF;
5896: aso_debug_pub.add('Before Closing the Cursor...C_VALIDATE_PHONE_CUSTOMER', 1, 'Y');
5897: CLOSE C_VALIDATE_PHONE_CUSTOMER;
6044: IF ( p_header = 'Y' ) THEN
6045: x_quote_header_rec.cust_party_id := NULL;
6046: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY(Line Header)', 1, 'Y');
6047:
6048: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6050: FND_MSG_PUB.ADD;
6051: END IF;
6052: END IF;
6045: x_quote_header_rec.cust_party_id := NULL;
6046: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY(Line Header)', 1, 'Y');
6047:
6048: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6050: FND_MSG_PUB.ADD;
6051: END IF;
6052: END IF;
6053:
6055: IF ( p_header = 'Y' ) THEN
6056: x_quote_header_rec.end_customer_cust_party_id := NULL;
6057: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY(Line Header)', 1, 'Y');
6058:
6059: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6061: FND_MSG_PUB.ADD;
6062: END IF;
6063:
6056: x_quote_header_rec.end_customer_cust_party_id := NULL;
6057: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY(Line Header)', 1, 'Y');
6058:
6059: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6061: FND_MSG_PUB.ADD;
6062: END IF;
6063:
6064: IF ( p_header = 'N' ) THEN
6118:
6119: x_quote_header_rec.cust_party_id := NULL;
6120: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY_MANAGER(Line/Header)', 1, 'Y');
6121:
6122: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6124: FND_MSG_PUB.ADD;
6125: END IF;
6126: END IF;
6119: x_quote_header_rec.cust_party_id := NULL;
6120: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY_MANAGER(Line/Header)', 1, 'Y');
6121:
6122: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6124: FND_MSG_PUB.ADD;
6125: END IF;
6126: END IF;
6127:
6130:
6131: x_quote_header_rec.end_customer_cust_party_id := NULL;
6132: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY_MANAGER(Line/Header)', 1, 'Y');
6133:
6134: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6136: FND_MSG_PUB.ADD;
6137: END IF;
6138:
6131: x_quote_header_rec.end_customer_cust_party_id := NULL;
6132: aso_debug_pub.add('No Data Found for Cursor...C_CUST_PARTY_MANAGER(Line/Header)', 1, 'Y');
6133:
6134: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6136: FND_MSG_PUB.ADD;
6137: END IF;
6138:
6139: IF ( p_header = 'N' ) THEN
6173: ELSE
6174: IF ( p_flag = 'SOLD' ) THEN
6175: IF ( p_header = 'Y' ) THEN
6176: x_quote_header_rec.cust_party_id := NULL;
6177: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6178: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6179: FND_MSG_PUB.ADD;
6180: END IF;
6181: END IF;
6174: IF ( p_flag = 'SOLD' ) THEN
6175: IF ( p_header = 'Y' ) THEN
6176: x_quote_header_rec.cust_party_id := NULL;
6177: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6178: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CUSTOMER', TRUE);
6179: FND_MSG_PUB.ADD;
6180: END IF;
6181: END IF;
6182:
6182:
6183: IF ( p_flag = 'END' ) THEN
6184: IF ( p_header = 'Y' ) THEN
6185: x_quote_header_rec.end_customer_cust_party_id := NULL;
6186: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6188: FND_MSG_PUB.ADD;
6189: END IF;
6190: IF ( p_header = 'N' ) THEN
6183: IF ( p_flag = 'END' ) THEN
6184: IF ( p_header = 'Y' ) THEN
6185: x_quote_header_rec.end_customer_cust_party_id := NULL;
6186: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CUSTOMER', TRUE);
6188: FND_MSG_PUB.ADD;
6189: END IF;
6190: IF ( p_header = 'N' ) THEN
6191: x_quote_line_rec.end_customer_cust_party_id := NULL;
6302: --Case:1 BILL
6303: IF P_FLAG = 'BILL' THEN
6304: IF ( p_header = 'Y' ) THEN
6305: x_quote_header_rec.INVOICE_TO_PARTY_ID := NULL;
6306: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CONTACT', TRUE);
6308: FND_MSG_PUB.ADD;
6309: END IF;
6310:
6303: IF P_FLAG = 'BILL' THEN
6304: IF ( p_header = 'Y' ) THEN
6305: x_quote_header_rec.INVOICE_TO_PARTY_ID := NULL;
6306: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CONTACT', TRUE);
6308: FND_MSG_PUB.ADD;
6309: END IF;
6310:
6311: IF ( p_header = 'N' ) THEN
6317:
6318: IF P_FLAG = 'SHIP' THEN
6319: IF ( p_header = 'Y' ) THEN
6320: x_shipment_header_rec.SHIP_TO_PARTY_ID := NULL;
6321: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CONTACT', TRUE);
6323: FND_MSG_PUB.ADD;
6324: END IF;
6325:
6318: IF P_FLAG = 'SHIP' THEN
6319: IF ( p_header = 'Y' ) THEN
6320: x_shipment_header_rec.SHIP_TO_PARTY_ID := NULL;
6321: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CONTACT', TRUE);
6323: FND_MSG_PUB.ADD;
6324: END IF;
6325:
6326: IF ( p_header = 'N' ) THEN
6331: --Case:3 END
6332: IF P_FLAG = 'END' THEN
6333: IF ( p_header = 'Y' ) THEN
6334: x_quote_header_rec.END_CUSTOMER_PARTY_ID := NULL;
6335: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CONTACT', TRUE);
6337: FND_MSG_PUB.ADD;
6338: END IF;
6339:
6332: IF P_FLAG = 'END' THEN
6333: IF ( p_header = 'Y' ) THEN
6334: x_quote_header_rec.END_CUSTOMER_PARTY_ID := NULL;
6335: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_CONTACT', TRUE);
6337: FND_MSG_PUB.ADD;
6338: END IF;
6339:
6340: IF ( p_header = 'N' ) THEN
6345: --Case:4 SOLD
6346: IF P_FLAG = 'SOLD' THEN --No Check for line level
6347: IF ( p_header = 'Y' ) THEN
6348: x_quote_header_rec.PARTY_ID := NULL;
6349: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CONTACT', TRUE);
6351: FND_MSG_PUB.ADD;
6352: END IF;
6353: END IF;
6346: IF P_FLAG = 'SOLD' THEN --No Check for line level
6347: IF ( p_header = 'Y' ) THEN
6348: x_quote_header_rec.PARTY_ID := NULL;
6349: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_CONTACT', TRUE);
6351: FND_MSG_PUB.ADD;
6352: END IF;
6353: END IF;
6354:
6539:
6540: ELSE --Assign Null
6541: IF ( p_header = 'Y' ) THEN
6542: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6543: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6545: FND_MSG_PUB.ADD;
6546: END IF;
6547:
6540: ELSE --Assign Null
6541: IF ( p_header = 'Y' ) THEN
6542: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6543: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6545: FND_MSG_PUB.ADD;
6546: END IF;
6547:
6548: IF ( p_header = 'N' ) THEN
6570: END IF;
6571: ELSE
6572: IF ( p_header = 'Y' ) THEN
6573: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6574: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6576: FND_MSG_PUB.ADD;
6577: END IF;
6578:
6571: ELSE
6572: IF ( p_header = 'Y' ) THEN
6573: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6574: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6576: FND_MSG_PUB.ADD;
6577: END IF;
6578:
6579: IF ( p_header = 'N' ) THEN
6624: IF P_FLAG = 'BILL' THEN
6625:
6626: IF ( p_header = 'Y' ) THEN
6627: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6628: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6630: FND_MSG_PUB.ADD;
6631: END IF;
6632:
6625:
6626: IF ( p_header = 'Y' ) THEN
6627: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6628: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6630: FND_MSG_PUB.ADD;
6631: END IF;
6632:
6633: IF ( p_header = 'N' ) THEN
6638:
6639: IF P_FLAG = 'SHIP' THEN
6640: IF ( p_header = 'Y' ) THEN
6641: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6642: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6644: FND_MSG_PUB.ADD;
6645: END IF;
6646:
6639: IF P_FLAG = 'SHIP' THEN
6640: IF ( p_header = 'Y' ) THEN
6641: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6642: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6644: FND_MSG_PUB.ADD;
6645: END IF;
6646:
6647: IF ( p_header = 'N' ) THEN
6700: IF P_FLAG = 'BILL' THEN
6701:
6702: IF ( p_header = 'Y' ) THEN
6703: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6704: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6705: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6706: FND_MSG_PUB.ADD;
6707: END IF;
6708:
6701:
6702: IF ( p_header = 'Y' ) THEN
6703: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6704: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6705: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6706: FND_MSG_PUB.ADD;
6707: END IF;
6708:
6709: IF ( p_header = 'N' ) THEN
6714:
6715: IF P_FLAG = 'SHIP' THEN
6716: IF ( p_header = 'Y' ) THEN
6717: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6718: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6720: FND_MSG_PUB.ADD;
6721: END IF;
6722:
6715: IF P_FLAG = 'SHIP' THEN
6716: IF ( p_header = 'Y' ) THEN
6717: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6718: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6720: FND_MSG_PUB.ADD;
6721: END IF;
6722:
6723: IF ( p_header = 'N' ) THEN
6765: IF P_FLAG = 'BILL' THEN
6766:
6767: IF ( p_header = 'Y' ) THEN
6768: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6769: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6771: FND_MSG_PUB.ADD;
6772: END IF;
6773:
6766:
6767: IF ( p_header = 'Y' ) THEN
6768: x_quote_header_rec.INVOICE_TO_CUST_PARTY_ID := NULL ;
6769: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_CUSTOMER', TRUE);
6771: FND_MSG_PUB.ADD;
6772: END IF;
6773:
6774: IF ( p_header = 'N' ) THEN
6779:
6780: IF P_FLAG = 'SHIP' THEN
6781: IF ( p_header = 'Y' ) THEN
6782: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6783: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6785: FND_MSG_PUB.ADD;
6786: END IF;
6787:
6780: IF P_FLAG = 'SHIP' THEN
6781: IF ( p_header = 'Y' ) THEN
6782: x_shipment_header_rec.SHIP_TO_CUST_PARTY_ID := NULL;
6783: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
6784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_CUSTOMER', TRUE);
6785: FND_MSG_PUB.ADD;
6786: END IF;
6787:
6788: IF ( p_header = 'N' ) THEN
7063: END IF;
7064: ELSE
7065: IF ( p_header = 'Y' ) THEN
7066: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7067: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7068: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7069: FND_MSG_PUB.ADD;
7070: END IF;
7071: IF ( p_header = 'N' ) THEN
7064: ELSE
7065: IF ( p_header = 'Y' ) THEN
7066: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7067: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7068: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7069: FND_MSG_PUB.ADD;
7070: END IF;
7071: IF ( p_header = 'N' ) THEN
7072: x_quote_line_rec.invoice_to_cust_account_id := NULL;
7095: END IF;
7096: ELSE
7097: IF ( p_header = 'Y' ) THEN
7098: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7099: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7101: FND_MSG_PUB.ADD;
7102: END IF;
7103: IF ( p_header = 'N' ) THEN
7096: ELSE
7097: IF ( p_header = 'Y' ) THEN
7098: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7099: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7101: FND_MSG_PUB.ADD;
7102: END IF;
7103: IF ( p_header = 'N' ) THEN
7104: x_shipment_line_rec.ship_to_cust_account_id := NULL;
7146: ELSE
7147: IF ( p_flag = 'BILL') THEN
7148: IF ( p_header = 'Y' ) THEN
7149: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7150: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7152: FND_MSG_PUB.ADD;
7153: END IF;
7154: IF ( p_header = 'N' ) THEN
7147: IF ( p_flag = 'BILL') THEN
7148: IF ( p_header = 'Y' ) THEN
7149: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7150: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7152: FND_MSG_PUB.ADD;
7153: END IF;
7154: IF ( p_header = 'N' ) THEN
7155: x_quote_line_rec.invoice_to_cust_account_id := NULL;
7157: END IF;
7158: IF ( p_flag = 'SHIP') THEN
7159: IF ( p_header = 'Y' ) THEN
7160: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7161: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7163: FND_MSG_PUB.ADD;
7164: END IF;
7165: IF ( p_header = 'N' ) THEN
7158: IF ( p_flag = 'SHIP') THEN
7159: IF ( p_header = 'Y' ) THEN
7160: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7161: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7163: FND_MSG_PUB.ADD;
7164: END IF;
7165: IF ( p_header = 'N' ) THEN
7166: x_shipment_line_rec.ship_to_cust_account_id := NULL;
7215: ELSE
7216: IF ( p_flag = 'BILL') THEN
7217: IF ( p_header = 'Y' ) THEN
7218: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7219: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7221: FND_MSG_PUB.ADD;
7222: END IF;
7223: IF ( p_header = 'N' ) THEN
7216: IF ( p_flag = 'BILL') THEN
7217: IF ( p_header = 'Y' ) THEN
7218: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7219: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7221: FND_MSG_PUB.ADD;
7222: END IF;
7223: IF ( p_header = 'N' ) THEN
7224: x_quote_line_rec.invoice_to_cust_account_id := NULL;
7227:
7228: IF ( p_flag = 'SHIP') THEN
7229: IF ( p_header = 'Y' ) THEN
7230: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7231: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7233: FND_MSG_PUB.ADD;
7234: END IF;
7235: IF ( p_header = 'N' ) THEN
7228: IF ( p_flag = 'SHIP') THEN
7229: IF ( p_header = 'Y' ) THEN
7230: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7231: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7233: FND_MSG_PUB.ADD;
7234: END IF;
7235: IF ( p_header = 'N' ) THEN
7236: x_shipment_line_rec.ship_to_cust_account_id := NULL;
7272: ELSE
7273: IF ( p_flag = 'BILL') THEN
7274: IF ( p_header = 'Y' ) THEN
7275: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7276: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7278: FND_MSG_PUB.ADD;
7279: END IF;
7280: IF ( p_header = 'N' ) THEN
7273: IF ( p_flag = 'BILL') THEN
7274: IF ( p_header = 'Y' ) THEN
7275: x_quote_header_rec.invoice_to_cust_account_id := NULL;
7276: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ACCOUNT', TRUE);
7278: FND_MSG_PUB.ADD;
7279: END IF;
7280: IF ( p_header = 'N' ) THEN
7281: x_quote_line_rec.invoice_to_cust_account_id := NULL;
7284:
7285: IF ( p_flag = 'SHIP') THEN
7286: IF ( p_header = 'Y' ) THEN
7287: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7288: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7289: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7290: FND_MSG_PUB.ADD;
7291: END IF;
7292:
7285: IF ( p_flag = 'SHIP') THEN
7286: IF ( p_header = 'Y' ) THEN
7287: x_shipment_header_rec.ship_to_cust_account_id := NULL;
7288: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7289: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ACCOUNT', TRUE);
7290: FND_MSG_PUB.ADD;
7291: END IF;
7292:
7293: IF ( p_header = 'N' ) THEN
7419: --Case:1 BILL
7420: IF P_FLAG = 'BILL' THEN
7421: IF ( p_header = 'Y' ) THEN
7422: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7423: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7425: FND_MSG_PUB.ADD;
7426: END IF;
7427:
7420: IF P_FLAG = 'BILL' THEN
7421: IF ( p_header = 'Y' ) THEN
7422: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7423: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7425: FND_MSG_PUB.ADD;
7426: END IF;
7427:
7428: IF ( p_header = 'N' ) THEN
7432: --Case:2 SHIP
7433: IF P_FLAG = 'SHIP' THEN
7434: IF ( p_header = 'Y' ) THEN
7435: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7436: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7437: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7438: FND_MSG_PUB.ADD;
7439: END IF;
7440:
7433: IF P_FLAG = 'SHIP' THEN
7434: IF ( p_header = 'Y' ) THEN
7435: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7436: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7437: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7438: FND_MSG_PUB.ADD;
7439: END IF;
7440:
7441: IF ( p_header = 'N' ) THEN
7445: --Case:3 END
7446: IF P_FLAG = 'END' THEN
7447: IF ( p_header = 'Y' ) THEN
7448: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7449: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7451: FND_MSG_PUB.ADD;
7452: END IF;
7453:
7446: IF P_FLAG = 'END' THEN
7447: IF ( p_header = 'Y' ) THEN
7448: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7449: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7451: FND_MSG_PUB.ADD;
7452: END IF;
7453:
7454: IF ( p_header = 'N' ) THEN
7458: --Case:4 SOLD
7459: IF P_FLAG = 'SOLD' THEN
7460: IF ( p_header = 'Y' ) THEN
7461: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7462: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7464: FND_MSG_PUB.ADD;
7465: END IF;
7466: END IF;
7459: IF P_FLAG = 'SOLD' THEN
7460: IF ( p_header = 'Y' ) THEN
7461: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7462: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7464: FND_MSG_PUB.ADD;
7465: END IF;
7466: END IF;
7467: aso_debug_pub.add('No data found for the cursor...C_CUST_ACCOUNT_MANAGER', 1, 'Y');
7521: --Case:1 BILL
7522: IF P_FLAG = 'BILL' THEN
7523: IF ( p_header = 'Y' ) THEN
7524: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7525: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7526: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7527: FND_MSG_PUB.ADD;
7528: END IF;
7529:
7522: IF P_FLAG = 'BILL' THEN
7523: IF ( p_header = 'Y' ) THEN
7524: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7525: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7526: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7527: FND_MSG_PUB.ADD;
7528: END IF;
7529:
7530: IF ( p_header = 'N' ) THEN
7534: --Case:2 SHIP
7535: IF P_FLAG = 'SHIP' THEN
7536: IF ( p_header = 'Y' ) THEN
7537: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7538: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7540: FND_MSG_PUB.ADD;
7541: END IF;
7542:
7535: IF P_FLAG = 'SHIP' THEN
7536: IF ( p_header = 'Y' ) THEN
7537: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7538: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7540: FND_MSG_PUB.ADD;
7541: END IF;
7542:
7543: IF ( p_header = 'N' ) THEN
7547: --Case:3 END
7548: IF P_FLAG = 'END' THEN
7549: IF ( p_header = 'Y' ) THEN
7550: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7551: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7553: FND_MSG_PUB.ADD;
7554: END IF;
7555:
7548: IF P_FLAG = 'END' THEN
7549: IF ( p_header = 'Y' ) THEN
7550: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7551: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7553: FND_MSG_PUB.ADD;
7554: END IF;
7555:
7556: IF ( p_header = 'N' ) THEN
7560: --Case:4 SOLD
7561: IF P_FLAG = 'SOLD' THEN
7562: IF ( p_header = 'Y' ) THEN
7563: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7564: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7566: FND_MSG_PUB.ADD;
7567: END IF;
7568: END IF;
7561: IF P_FLAG = 'SOLD' THEN
7562: IF ( p_header = 'Y' ) THEN
7563: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7564: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7566: FND_MSG_PUB.ADD;
7567: END IF;
7568: END IF;
7569: aso_debug_pub.add('No Data Found for the cursor...C_CUST_PARTY_ADDRESS_NOT_NULL', 1, 'Y');
7623: --Case:1 BILL
7624: IF P_FLAG = 'BILL' THEN
7625: IF ( p_header = 'Y' ) THEN
7626: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7627: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7629: FND_MSG_PUB.ADD;
7630: END IF;
7631:
7624: IF P_FLAG = 'BILL' THEN
7625: IF ( p_header = 'Y' ) THEN
7626: x_quote_header_rec.INVOICE_TO_PARTY_SITE_ID := NULL;
7627: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_BILL_ADDRESS', TRUE);
7629: FND_MSG_PUB.ADD;
7630: END IF;
7631:
7632: IF ( p_header = 'N' ) THEN
7636: --Case:2 SHIP
7637: IF P_FLAG = 'SHIP' THEN
7638: IF ( p_header = 'Y' ) THEN
7639: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7640: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7642: FND_MSG_PUB.ADD;
7643: END IF;
7644:
7637: IF P_FLAG = 'SHIP' THEN
7638: IF ( p_header = 'Y' ) THEN
7639: x_shipment_header_rec.SHIP_TO_PARTY_SITE_ID := NULL;
7640: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHIP_ADDRESS', TRUE);
7642: FND_MSG_PUB.ADD;
7643: END IF;
7644:
7645: IF ( p_header = 'N' ) THEN
7649: --Case:3 END
7650: IF P_FLAG = 'END' THEN
7651: IF ( p_header = 'Y' ) THEN
7652: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7653: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7655: FND_MSG_PUB.ADD;
7656: END IF;
7657:
7650: IF P_FLAG = 'END' THEN
7651: IF ( p_header = 'Y' ) THEN
7652: x_quote_header_rec.END_CUSTOMER_PARTY_SITE_ID := NULL;
7653: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ADDRESS', TRUE);
7655: FND_MSG_PUB.ADD;
7656: END IF;
7657:
7658: IF ( p_header = 'N' ) THEN
7662: --Case:4 SOLD
7663: IF P_FLAG = 'SOLD' THEN
7664: IF ( p_header = 'Y' ) THEN
7665: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7666: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7668: FND_MSG_PUB.ADD;
7669: END IF;
7670: END IF;
7663: IF P_FLAG = 'SOLD' THEN
7664: IF ( p_header = 'Y' ) THEN
7665: x_quote_header_rec.SOLD_TO_PARTY_SITE_ID := NULL;
7666: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ADDRESS', TRUE);
7668: FND_MSG_PUB.ADD;
7669: END IF;
7670: END IF;
7671: aso_debug_pub.add('no data found for the cursor...C_CUSTOMER_ADDRESS_NOT_NULL', 1, 'Y');
7825: ELSE
7826: IF ( p_flag = 'SOLD' ) THEN
7827: IF ( p_header = 'Y' ) THEN
7828: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7829: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7831: FND_MSG_PUB.ADD;
7832: END IF;
7833: END IF;
7826: IF ( p_flag = 'SOLD' ) THEN
7827: IF ( p_header = 'Y' ) THEN
7828: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7829: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7831: FND_MSG_PUB.ADD;
7832: END IF;
7833: END IF;
7834: IF ( p_flag = 'END' ) THEN
7833: END IF;
7834: IF ( p_flag = 'END' ) THEN
7835: IF ( p_header = 'Y' ) THEN
7836: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7837: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7838: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7839: FND_MSG_PUB.ADD;
7840: END IF;
7841: IF ( p_header = 'N' ) THEN
7834: IF ( p_flag = 'END' ) THEN
7835: IF ( p_header = 'Y' ) THEN
7836: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7837: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7838: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7839: FND_MSG_PUB.ADD;
7840: END IF;
7841: IF ( p_header = 'N' ) THEN
7842: x_quote_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7891: ELSE
7892: IF ( p_flag = 'SOLD' ) THEN
7893: IF ( p_header = 'Y' ) THEN
7894: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7895: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7897: FND_MSG_PUB.ADD;
7898: END IF;
7899: END IF;
7892: IF ( p_flag = 'SOLD' ) THEN
7893: IF ( p_header = 'Y' ) THEN
7894: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7895: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7897: FND_MSG_PUB.ADD;
7898: END IF;
7899: END IF;
7900: IF ( p_flag = 'END' ) THEN
7899: END IF;
7900: IF ( p_flag = 'END' ) THEN
7901: IF ( p_header = 'Y' ) THEN
7902: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7903: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7904: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7905: FND_MSG_PUB.ADD;
7906: END IF;
7907: IF ( p_header = 'N' ) THEN
7900: IF ( p_flag = 'END' ) THEN
7901: IF ( p_header = 'Y' ) THEN
7902: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7903: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7904: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7905: FND_MSG_PUB.ADD;
7906: END IF;
7907: IF ( p_header = 'N' ) THEN
7908: x_quote_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7940: ELSE
7941: IF ( p_flag = 'SOLD' ) THEN
7942: IF ( p_header = 'Y' ) THEN
7943: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7944: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7946: FND_MSG_PUB.ADD;
7947: END IF;
7948: END IF;
7941: IF ( p_flag = 'SOLD' ) THEN
7942: IF ( p_header = 'Y' ) THEN
7943: x_quote_header_rec.CUST_ACCOUNT_ID := NULL;
7944: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_QUOTE_ACCOUNT', TRUE);
7946: FND_MSG_PUB.ADD;
7947: END IF;
7948: END IF;
7949: IF ( p_flag = 'END' ) THEN
7948: END IF;
7949: IF ( p_flag = 'END' ) THEN
7950: IF ( p_header = 'Y' ) THEN
7951: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7952: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7954: FND_MSG_PUB.ADD;
7955: END IF;
7956: IF ( p_header = 'N' ) THEN
7949: IF ( p_flag = 'END' ) THEN
7950: IF ( p_header = 'Y' ) THEN
7951: x_quote_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
7952: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
7953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_END_ACCOUNT', TRUE);
7954: FND_MSG_PUB.ADD;
7955: END IF;
7956: IF ( p_header = 'N' ) THEN
7957: x_quote_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID := NULL;
8440: ELSE
8441: x_Shipment_header_rec.SHIPMENT_PRIORITY_CODE := NULL ;
8442: aso_debug_pub.add('No Data Found for Cursor...C_SHIPMENT_PRIORITY_CODE--Header Level', 1, 'Y');
8443:
8444: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHPMT_PRIORITY', TRUE);
8446: FND_MSG_PUB.ADD;
8447:
8448: aso_debug_pub.add('No Data Found for Cursor C_SHIPMENT_PRIORITY_CODE--Header Level', 1, 'Y');
8441: x_Shipment_header_rec.SHIPMENT_PRIORITY_CODE := NULL ;
8442: aso_debug_pub.add('No Data Found for Cursor...C_SHIPMENT_PRIORITY_CODE--Header Level', 1, 'Y');
8443:
8444: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SHPMT_PRIORITY', TRUE);
8446: FND_MSG_PUB.ADD;
8447:
8448: aso_debug_pub.add('No Data Found for Cursor C_SHIPMENT_PRIORITY_CODE--Header Level', 1, 'Y');
8449: END IF;
8490: ELSE
8491: x_Shipment_header_rec.FOB_CODE := NULL ;
8492: aso_debug_pub.add('No Data Found for Cursor...C_FOB--Header Level', 1, 'Y');
8493:
8494: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_FOB', TRUE);
8496: FND_MSG_PUB.ADD;
8497:
8498: --x_return_status := FND_API.G_RET_STS_ERROR;
8491: x_Shipment_header_rec.FOB_CODE := NULL ;
8492: aso_debug_pub.add('No Data Found for Cursor...C_FOB--Header Level', 1, 'Y');
8493:
8494: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_FOB', TRUE);
8496: FND_MSG_PUB.ADD;
8497:
8498: --x_return_status := FND_API.G_RET_STS_ERROR;
8499: END IF;
8541: ELSE
8542: x_Payment_header_rec.CREDIT_CARD_CODE := NULL ;
8543: aso_debug_pub.add('No Data Found for Cursor...C_CREDIT_CARD_TYPE--Header Level', 1, 'Y');
8544:
8545: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CREDIT_CARD_TYPE', TRUE);
8547: FND_MSG_PUB.ADD;
8548:
8549: --x_return_status := FND_API.G_RET_STS_ERROR;
8542: x_Payment_header_rec.CREDIT_CARD_CODE := NULL ;
8543: aso_debug_pub.add('No Data Found for Cursor...C_CREDIT_CARD_TYPE--Header Level', 1, 'Y');
8544:
8545: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CREDIT_CARD_TYPE', TRUE);
8547: FND_MSG_PUB.ADD;
8548:
8549: --x_return_status := FND_API.G_RET_STS_ERROR;
8550: END IF;
8555: ELSE
8556: x_Payment_header_rec.CREDIT_CARD_CODE := NULL ;
8557: aso_debug_pub.add('Credit card code needs to be null if payment type is not CREDIT_CARD.', 1, 'Y');
8558:
8559: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8560: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CREDIT_CARD_TYPE', TRUE);
8561: FND_MSG_PUB.ADD;
8562:
8563: END IF ;
8556: x_Payment_header_rec.CREDIT_CARD_CODE := NULL ;
8557: aso_debug_pub.add('Credit card code needs to be null if payment type is not CREDIT_CARD.', 1, 'Y');
8558:
8559: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8560: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CREDIT_CARD_TYPE', TRUE);
8561: FND_MSG_PUB.ADD;
8562:
8563: END IF ;
8564: end if;
8607: ELSE
8608: x_Shipment_header_rec.DEMAND_CLASS_CODE := NULL ;
8609: aso_debug_pub.add('No Data Found for Cursor...C_DEMAND_CLASS--Header Level', 1, 'Y');
8610:
8611: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_DEMAND_CLASS', TRUE);
8613: FND_MSG_PUB.ADD;
8614: --x_return_status := FND_API.G_RET_STS_ERROR;
8615: END IF;
8608: x_Shipment_header_rec.DEMAND_CLASS_CODE := NULL ;
8609: aso_debug_pub.add('No Data Found for Cursor...C_DEMAND_CLASS--Header Level', 1, 'Y');
8610:
8611: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_DEMAND_CLASS', TRUE);
8613: FND_MSG_PUB.ADD;
8614: --x_return_status := FND_API.G_RET_STS_ERROR;
8615: END IF;
8616: aso_debug_pub.add('before Closing Cursor C_DEMAND_CLASS--Header Level', 1, 'Y');
8656: ELSE
8657: x_Shipment_header_rec.REQUEST_DATE_TYPE := NULL ;
8658: aso_debug_pub.add('No Data Found for Cursor...C_REQUEST_DATE_TYPE--Header Level', 1, 'Y');
8659:
8660: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8661: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_RQSTD_DATE_TYPE', TRUE);
8662: FND_MSG_PUB.ADD;
8663:
8664: --x_return_status := FND_API.G_RET_STS_ERROR;
8657: x_Shipment_header_rec.REQUEST_DATE_TYPE := NULL ;
8658: aso_debug_pub.add('No Data Found for Cursor...C_REQUEST_DATE_TYPE--Header Level', 1, 'Y');
8659:
8660: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8661: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_RQSTD_DATE_TYPE', TRUE);
8662: FND_MSG_PUB.ADD;
8663:
8664: --x_return_status := FND_API.G_RET_STS_ERROR;
8665: END IF;
8706: ELSE
8707: x_Shipment_header_rec.REQUEST_DATE := NULL ;
8708: aso_debug_pub.add('No Data Found for Cursor...C_REQUEST_DATE--Header Level', 1, 'Y');
8709:
8710: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_REQUESTED_DATE', TRUE);
8712: FND_MSG_PUB.ADD;
8713:
8714: --x_return_status := FND_API.G_RET_STS_ERROR;
8707: x_Shipment_header_rec.REQUEST_DATE := NULL ;
8708: aso_debug_pub.add('No Data Found for Cursor...C_REQUEST_DATE--Header Level', 1, 'Y');
8709:
8710: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_REQUESTED_DATE', TRUE);
8712: FND_MSG_PUB.ADD;
8713:
8714: --x_return_status := FND_API.G_RET_STS_ERROR;
8715: END IF;
8759: x_quote_header_rec.ORG_ID := p_quote_header_rec.ORG_ID ;
8760: else
8761: x_quote_header_rec.ORG_ID := NULL;
8762:
8763: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_OPERATING_UNIT', TRUE);
8765: FND_MSG_PUB.ADD;
8766: end if;
8767: ELSE
8760: else
8761: x_quote_header_rec.ORG_ID := NULL;
8762:
8763: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_OPERATING_UNIT', TRUE);
8765: FND_MSG_PUB.ADD;
8766: end if;
8767: ELSE
8768: x_quote_header_rec.ORG_ID := NULL ;
8767: ELSE
8768: x_quote_header_rec.ORG_ID := NULL ;
8769: aso_debug_pub.add('No Data Found for Cursor...C_OPERATING_UNIT', 1, 'Y');
8770:
8771: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_OPERATING_UNIT', TRUE);
8773: FND_MSG_PUB.ADD;
8774:
8775: --x_return_status := FND_API.G_RET_STS_ERROR;
8768: x_quote_header_rec.ORG_ID := NULL ;
8769: aso_debug_pub.add('No Data Found for Cursor...C_OPERATING_UNIT', 1, 'Y');
8770:
8771: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_OPERATING_UNIT', TRUE);
8773: FND_MSG_PUB.ADD;
8774:
8775: --x_return_status := FND_API.G_RET_STS_ERROR;
8776: END IF;
8847: ELSE
8848: x_quote_header_rec.AUTOMATIC_PRICE_FLAG := NULL ;
8849: aso_debug_pub.add('No Data Found for Cursor...C_AUTOMATIC_PRICING', 1, 'Y');
8850:
8851: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_AUTO_PRICING', TRUE);
8853: FND_MSG_PUB.ADD;
8854: --x_return_status := FND_API.G_RET_STS_ERROR;
8855: END IF;
8848: x_quote_header_rec.AUTOMATIC_PRICE_FLAG := NULL ;
8849: aso_debug_pub.add('No Data Found for Cursor...C_AUTOMATIC_PRICING', 1, 'Y');
8850:
8851: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_AUTO_PRICING', TRUE);
8853: FND_MSG_PUB.ADD;
8854: --x_return_status := FND_API.G_RET_STS_ERROR;
8855: END IF;
8856: aso_debug_pub.add('Before closing Cursor C_AUTOMATIC_PRICING', 1, 'Y');
8875: ELSE
8876: x_quote_header_rec.AUTOMATIC_TAX_FLAG := NULL ;
8877: aso_debug_pub.add('No Data Found for Cursor...C_AUTOMATIC_TAX', 1, 'Y');
8878:
8879: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_AUTOMATIC_TAX', TRUE);
8881: FND_MSG_PUB.ADD;
8882:
8883: --x_return_status := FND_API.G_RET_STS_ERROR;
8876: x_quote_header_rec.AUTOMATIC_TAX_FLAG := NULL ;
8877: aso_debug_pub.add('No Data Found for Cursor...C_AUTOMATIC_TAX', 1, 'Y');
8878:
8879: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_AUTOMATIC_TAX', TRUE);
8881: FND_MSG_PUB.ADD;
8882:
8883: --x_return_status := FND_API.G_RET_STS_ERROR;
8884: END IF;
8905: ELSE
8906: x_Payment_header_rec.PAYMENT_TYPE_CODE := NULL ;
8907: aso_debug_pub.add('No Data Found for Cursor...C_PAYMENT_TYPE--Header Level', 1, 'Y');
8908:
8909: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_PAYMENT_TYPE', TRUE);
8911: FND_MSG_PUB.ADD;
8912:
8913: --x_return_status := FND_API.G_RET_STS_ERROR;
8906: x_Payment_header_rec.PAYMENT_TYPE_CODE := NULL ;
8907: aso_debug_pub.add('No Data Found for Cursor...C_PAYMENT_TYPE--Header Level', 1, 'Y');
8908:
8909: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_PAYMENT_TYPE', TRUE);
8911: FND_MSG_PUB.ADD;
8912:
8913: --x_return_status := FND_API.G_RET_STS_ERROR;
8914: END IF;
8959: ELSE
8960: x_quote_header_rec.SALES_CHANNEL_CODE := NULL ;
8961: aso_debug_pub.add('No Data Found for Cursor...C_SALESCHANNEL', 1, 'Y');
8962:
8963: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SALES_CHANNEL', TRUE);
8965: FND_MSG_PUB.ADD;
8966:
8967: --x_return_status := FND_API.G_RET_STS_ERROR;
8960: x_quote_header_rec.SALES_CHANNEL_CODE := NULL ;
8961: aso_debug_pub.add('No Data Found for Cursor...C_SALESCHANNEL', 1, 'Y');
8962:
8963: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_SALES_CHANNEL', TRUE);
8965: FND_MSG_PUB.ADD;
8966:
8967: --x_return_status := FND_API.G_RET_STS_ERROR;
8968:
8992: ELSE
8993: x_quote_header_rec.CURRENCY_CODE := NULL ;
8994: aso_debug_pub.add('No Data Found for Cursor...C_QOTHDDET_CURRENCY_NOT_NULL', 1, 'Y');
8995:
8996: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CURRENCY', TRUE);
8998: FND_MSG_PUB.ADD;
8999:
9000: --x_return_status := FND_API.G_RET_STS_ERROR;
8993: x_quote_header_rec.CURRENCY_CODE := NULL ;
8994: aso_debug_pub.add('No Data Found for Cursor...C_QOTHDDET_CURRENCY_NOT_NULL', 1, 'Y');
8995:
8996: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
8997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CURRENCY', TRUE);
8998: FND_MSG_PUB.ADD;
8999:
9000: --x_return_status := FND_API.G_RET_STS_ERROR;
9001:
9018: ELSE
9019: x_quote_header_rec.CURRENCY_CODE := NULL ;
9020: aso_debug_pub.add('No Data Found for Cursor...C_QOTHDDET_CURRENCY_NULL', 1, 'Y');
9021:
9022: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
9023: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CURRENCY', TRUE);
9024: FND_MSG_PUB.ADD;
9025: --x_return_status := FND_API.G_RET_STS_ERROR;
9026:
9019: x_quote_header_rec.CURRENCY_CODE := NULL ;
9020: aso_debug_pub.add('No Data Found for Cursor...C_QOTHDDET_CURRENCY_NULL', 1, 'Y');
9021:
9022: FND_MESSAGE.SET_NAME('ASO', 'ASO_DFLT_VLDN_ERR_MSG');
9023: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', 'ASO_DFLT_VLDN_CURRENCY', TRUE);
9024: FND_MSG_PUB.ADD;
9025: --x_return_status := FND_API.G_RET_STS_ERROR;
9026:
9027: END IF;
9586:
9587: x_return_status := fnd_api.g_ret_sts_error;
9588:
9589: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9590: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_BILLTOPARTY');
9591: FND_MSG_PUB.ADD;
9592: END IF;
9593:
9594: end if;
9607:
9608: x_return_status := fnd_api.g_ret_sts_error;
9609:
9610: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9611: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_PAYMENT_DETAILS');
9612: FND_MSG_PUB.ADD;
9613: END IF;
9614:
9615: end if;
9628: close c_get_lines_with_null_payment;
9629: x_return_status := fnd_api.g_ret_sts_error;
9630:
9631: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9632: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_LN_PAYMENT_DETAILS');
9633: FND_MSG_PUB.ADD;
9634: END IF;
9635:
9636: end if;
9663: AND (p_qte_header_rec.org_id IS NOT NULL)
9664: AND (l_org_id <> p_qte_header_rec.org_id)) THEN
9665:
9666: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9667: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_ID_MISMATCH');
9668: FND_MSG_PUB.ADD;
9669: END IF;
9670:
9671: RAISE FND_API.G_EXC_ERROR;
9672: END IF;
9673: END ;
9674: ELSE
9675: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9676: FND_MESSAGE.Set_Name('ASO', 'ASO_WRONG_ACCESS_MODE');
9677: FND_MSG_PUB.ADD;
9678: END IF;
9679:
9680: RAISE FND_API.G_EXC_ERROR;
9760: if C_Get_ship_method%NOTFOUND THEN
9761: Close C_Get_ship_method;
9762: x_return_status := FND_API.G_RET_STS_ERROR;
9763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9764: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9765: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9766: FND_MESSAGE.Set_Token('VALUE', p_ship_method_code, FALSE);
9767: FND_MSG_PUB.ADD;
9768: END IF;
9761: Close C_Get_ship_method;
9762: x_return_status := FND_API.G_RET_STS_ERROR;
9763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9764: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9765: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9766: FND_MESSAGE.Set_Token('VALUE', p_ship_method_code, FALSE);
9767: FND_MSG_PUB.ADD;
9768: END IF;
9769: else
9762: x_return_status := FND_API.G_RET_STS_ERROR;
9763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9764: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9765: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9766: FND_MESSAGE.Set_Token('VALUE', p_ship_method_code, FALSE);
9767: FND_MSG_PUB.ADD;
9768: END IF;
9769: else
9770: Close C_Get_ship_method;
9809: if C_Get_ship_method%NOTFOUND THEN
9810: Close C_Get_ship_method;
9811: x_return_status := FND_API.G_RET_STS_ERROR;
9812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9813: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9814: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9815: FND_MESSAGE.Set_Token('VALUE', l_ship_method_code, FALSE);
9816: FND_MSG_PUB.ADD;
9817: END IF;
9810: Close C_Get_ship_method;
9811: x_return_status := FND_API.G_RET_STS_ERROR;
9812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9813: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9814: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9815: FND_MESSAGE.Set_Token('VALUE', l_ship_method_code, FALSE);
9816: FND_MSG_PUB.ADD;
9817: END IF;
9818: else
9811: x_return_status := FND_API.G_RET_STS_ERROR;
9812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9813: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
9814: FND_MESSAGE.Set_Token('COLUMN', 'SHIP_METHOD', FALSE);
9815: FND_MESSAGE.Set_Token('VALUE', l_ship_method_code, FALSE);
9816: FND_MSG_PUB.ADD;
9817: END IF;
9818: else
9819: Close C_Get_ship_method;