[Home] [Help]
86:
87: EXCEPTION
88: WHEN OTHERS THEN
89: IF (SQLCODE <> -20001 ) THEN
90: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
91: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
92: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
93: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
94: END IF;
87: EXCEPTION
88: WHEN OTHERS THEN
89: IF (SQLCODE <> -20001 ) THEN
90: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
91: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
92: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
93: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
94: END IF;
95: --
88: WHEN OTHERS THEN
89: IF (SQLCODE <> -20001 ) THEN
90: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
91: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
92: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
93: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
94: END IF;
95: --
96: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
89: IF (SQLCODE <> -20001 ) THEN
90: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
91: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
92: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
93: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
94: END IF;
95: --
96: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,SQLERRM);
122: AND TRUNC(NVL(end_date_active, SYSDATE))>= TRUNC(SYSDATE);
123:
124: IF l_count < 1 THEN
125: x_valid := FALSE;
126: FND_MESSAGE.SET_NAME('SQLGL','GL_API_INVALID_CURR');
127: FND_MSG_PUB.ADD;
128:
129: END IF;
130: END IF;
159:
160: EXCEPTION
161: WHEN NO_DATA_FOUND THEN
162: x_valid := FALSE;
163: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
164: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
165: FND_MSG_PUB.ADD;
166:
167: End;
160: EXCEPTION
161: WHEN NO_DATA_FOUND THEN
162: x_valid := FALSE;
163: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
164: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
165: FND_MSG_PUB.ADD;
166:
167: End;
168: ELSIF p_lookup_table = 'PO_LOOKUP_CODES' THEN
178:
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN
181: x_valid := FALSE;
182: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
183: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
184: FND_MSG_PUB.ADD;
185:
186: End;
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN
181: x_valid := FALSE;
182: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
183: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
184: FND_MSG_PUB.ADD;
185:
186: End;
187:
197:
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: x_valid := FALSE;
201: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
202: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
203: FND_MSG_PUB.ADD;
204: End;
205:
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: x_valid := FALSE;
201: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
202: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
203: FND_MSG_PUB.ADD;
204: End;
205:
206: END IF;
244: END IF;
245:
246: IF (l_dup_count_org_id > 0 OR l_dup_count_org_name > 0 ) THEN
247: x_valid := FALSE;
248: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_VEN_SITE');
249: FND_MSG_PUB.ADD;
250: END IF;
251:
252: END Check_dup_vendor_site;
263:
264:
265: IF (nvl(p_federal_flag,'N') = 'N' and p_1099_type is NOT NULL) THEN
266: x_valid := FALSE;
267: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
268: FND_MESSAGE.SET_TOKEN('ID','FEDERAL_REPORTABLE_FLAG');
269: FND_MESSAGE.SET_TOKEN('NAME','1099_TYPE');
270: FND_MSG_PUB.ADD;
271: END IF;
264:
265: IF (nvl(p_federal_flag,'N') = 'N' and p_1099_type is NOT NULL) THEN
266: x_valid := FALSE;
267: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
268: FND_MESSAGE.SET_TOKEN('ID','FEDERAL_REPORTABLE_FLAG');
269: FND_MESSAGE.SET_TOKEN('NAME','1099_TYPE');
270: FND_MSG_PUB.ADD;
271: END IF;
272:
265: IF (nvl(p_federal_flag,'N') = 'N' and p_1099_type is NOT NULL) THEN
266: x_valid := FALSE;
267: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
268: FND_MESSAGE.SET_TOKEN('ID','FEDERAL_REPORTABLE_FLAG');
269: FND_MESSAGE.SET_TOKEN('NAME','1099_TYPE');
270: FND_MSG_PUB.ADD;
271: END IF;
272:
273: END Check_Valid_1099_type;
287: (p_payment_priority <> trunc(p_payment_priority))) THEN
288:
289: x_valid := FALSE;
290:
291: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
292: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PAYMENT_PRIORITY' );
293: FND_MSG_PUB.ADD;
294: END IF;
295: END Check_Payment_Priority;
288:
289: x_valid := FALSE;
290:
291: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
292: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PAYMENT_PRIORITY' );
293: FND_MSG_PUB.ADD;
294: END IF;
295: END Check_Payment_Priority;
296:
315: -- Trap validation error
316: WHEN NO_DATA_FOUND THEN
317: x_valid := FALSE;
318:
319: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
320: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','EMPLOYEE_ID' );
321: FND_MSG_PUB.ADD;
322:
323: END Check_Valid_Employee;
316: WHEN NO_DATA_FOUND THEN
317: x_valid := FALSE;
318:
319: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
320: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','EMPLOYEE_ID' );
321: FND_MSG_PUB.ADD;
322:
323: END Check_Valid_Employee;
324:
334: x_valid := TRUE;
335:
336: IF (p_receipt_reqd_flag = 'N' and p_inspection_reqd_flag = 'Y') THEN
337: x_valid := FALSE;
338: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
339: FND_MESSAGE.SET_TOKEN('ID','INSPECTION_REQUIRED_FLAG');
340: FND_MESSAGE.SET_TOKEN('NAME','RECEIPT_REQUIRED_FLAG');
341: FND_MSG_PUB.ADD;
342: END IF;
335:
336: IF (p_receipt_reqd_flag = 'N' and p_inspection_reqd_flag = 'Y') THEN
337: x_valid := FALSE;
338: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
339: FND_MESSAGE.SET_TOKEN('ID','INSPECTION_REQUIRED_FLAG');
340: FND_MESSAGE.SET_TOKEN('NAME','RECEIPT_REQUIRED_FLAG');
341: FND_MSG_PUB.ADD;
342: END IF;
343:
336: IF (p_receipt_reqd_flag = 'N' and p_inspection_reqd_flag = 'Y') THEN
337: x_valid := FALSE;
338: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
339: FND_MESSAGE.SET_TOKEN('ID','INSPECTION_REQUIRED_FLAG');
340: FND_MESSAGE.SET_TOKEN('NAME','RECEIPT_REQUIRED_FLAG');
341: FND_MSG_PUB.ADD;
342: END IF;
343:
344: END Check_Valid_match_level;
357: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789&- ',
358: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),'X')), 0),0) > 0) THEN
359:
360: x_valid := FALSE;
361: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
362: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','NAME_CONTROL' );
363: FND_MSG_PUB.ADD;
364: END IF;
365:
358: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),'X')), 0),0) > 0) THEN
359:
360: x_valid := FALSE;
361: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
362: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','NAME_CONTROL' );
363: FND_MSG_PUB.ADD;
364: END IF;
365:
366: END Check_Valid_name_control;
387:
388: IF l_dummy < 1 THEN
389: x_valid := FALSE;
390:
391: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
392: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_VIA_LOOKUP_CODE' );
393: FND_MSG_PUB.ADD;
394: END IF;
395:
388: IF l_dummy < 1 THEN
389: x_valid := FALSE;
390:
391: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
392: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_VIA_LOOKUP_CODE' );
393: FND_MSG_PUB.ADD;
394: END IF;
395:
396: END Check_Valid_ship_via;
415: EXCEPTION
416: -- Trap validation error
417: WHEN NO_DATA_FOUND THEN
418: x_valid := FALSE;
419: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
420: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SET_OF_BOOKS_ID' );
421: FND_MSG_PUB.ADD;
422: END Check_Valid_Sob_Id;
423:
416: -- Trap validation error
417: WHEN NO_DATA_FOUND THEN
418: x_valid := FALSE;
419: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
420: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SET_OF_BOOKS_ID' );
421: FND_MSG_PUB.ADD;
422: END Check_Valid_Sob_Id;
423:
424: --
442:
443: IF l_count > 0 THEN
444: x_valid := FALSE;
445:
446: FND_MESSAGE.SET_NAME('SQLAP','AP_EMPLOYEE_ASSIGNED');
447: FND_MSG_PUB.ADD;
448: END IF;
449:
450: END Chk_Dup_Employee;
467: WHERE segment1 = p_segment1;
468:
469: IF l_count > 1 THEN
470: x_valid := FALSE;
471: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
472: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1' );
473: FND_MSG_PUB.ADD;
474: END IF;
475:
468:
469: IF l_count > 1 THEN
470: x_valid := FALSE;
471: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
472: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1' );
473: FND_MSG_PUB.ADD;
474: END IF;
475:
476: END Chk_Dup_segment1_int;
498: WHERE UPPER(vendor_name) = UPPER(p_vendor_name);
499:
500: IF l_count > 1 THEN
501: x_valid := FALSE;
502: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DUPLICATE_NAME');
503: FND_MSG_PUB.ADD;
504: END IF;
505:
506: END Chk_Dup_Vendor_Name_new;
546: END IF;
547:
548: IF l_count > 0 THEN
549: x_valid := FALSE;
550: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DUPLICATE_NAME');
551: FND_MSG_PUB.ADD;
552: END IF;
553:
554: END Chk_Dup_Vendor_Name_new;
581: END IF;
582:
583: IF l_count > 0 THEN
584: x_valid := FALSE;
585: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DUPLICATE_VEN_NUM');
586: FND_MSG_PUB.ADD;
587: END IF;
588:
589: END Chk_Dup_Vendor_Number;
608: EXCEPTION
609: -- Trap validation error
610: WHEN NO_DATA_FOUND THEN
611: x_valid := FALSE;
612: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
613: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','RECEIVING_ROUTING_ID' );
614: FND_MSG_PUB.ADD;
615: END Chk_rcv_routing_id;
616:
609: -- Trap validation error
610: WHEN NO_DATA_FOUND THEN
611: x_valid := FALSE;
612: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
613: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','RECEIVING_ROUTING_ID' );
614: FND_MSG_PUB.ADD;
615: END Chk_rcv_routing_id;
616:
617: --
631: (p_vendor_type = 'EMPLOYEE' --bug6050423
632: AND (p_employee_id is Null OR p_employee_id = ap_null_num)) ) THEN
633:
634: p_valid := FALSE;
635: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
636: FND_MESSAGE.SET_TOKEN('ID','VENDOR_TYPE_LOOKUP_CODE');
637: FND_MESSAGE.SET_TOKEN('NAME','EMPLOYEE_ID');
638: FND_MSG_PUB.ADD;
639: END IF;
632: AND (p_employee_id is Null OR p_employee_id = ap_null_num)) ) THEN
633:
634: p_valid := FALSE;
635: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
636: FND_MESSAGE.SET_TOKEN('ID','VENDOR_TYPE_LOOKUP_CODE');
637: FND_MESSAGE.SET_TOKEN('NAME','EMPLOYEE_ID');
638: FND_MSG_PUB.ADD;
639: END IF;
640:
633:
634: p_valid := FALSE;
635: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
636: FND_MESSAGE.SET_TOKEN('ID','VENDOR_TYPE_LOOKUP_CODE');
637: FND_MESSAGE.SET_TOKEN('NAME','EMPLOYEE_ID');
638: FND_MSG_PUB.ADD;
639: END IF;
640:
641: END employee_type_checks;
673: AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate)
674: );
675:
676: IF (l_count = 0) THEN
677: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_PAYMENT_CURR');
678: p_valid := FALSE;
679: FND_MSG_PUB.ADD;
680: END IF;
681:
701: AND TRUNC(SYSDATE) < TRUNC(NVL(inactive_date, SYSDATE+1));
702:
703: IF l_count < 1 THEN
704: x_valid := FALSE;
705: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_IN_TAX_TYPE');
706: FND_MSG_PUB.ADD;
707: END IF;
708:
709: END Val_Income_Tax_Type;
738:
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: x_valid := FALSE;
742: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
743: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
744: FND_MSG_PUB.ADD;
745: End;
746: ELSE
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: x_valid := FALSE;
742: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
743: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
744: FND_MSG_PUB.ADD;
745: End;
746: ELSE
747: Begin
757:
758: EXCEPTION
759: WHEN NO_DATA_FOUND THEN
760: x_valid := FALSE;
761: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
762: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
763: FND_MSG_PUB.ADD;
764: End;
765: END IF;
758: EXCEPTION
759: WHEN NO_DATA_FOUND THEN
760: x_valid := FALSE;
761: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
762: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
763: FND_MSG_PUB.ADD;
764: End;
765: END IF;
766:
811: END IF;
812:
813: IF l_count > 0 THEN
814: x_valid := FALSE;
815: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DUPLICATE_NAME');
816: FND_MSG_PUB.ADD;
817: END IF;
818:
819: END Chk_Dup_Vendor_Name_update;
837:
838: IF ((NVL(l_ven_num_code, 'MANUAL') = 'MANUAL') AND
839: (p_segment1 is Null)) THEN
840: x_valid := FALSE;
841: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
842: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1');
843: FND_MSG_PUB.ADD;
844: ELSIF l_ven_num_code not in ('MANUAL','AUTOMATIC') then
845: x_valid := FALSE;
838: IF ((NVL(l_ven_num_code, 'MANUAL') = 'MANUAL') AND
839: (p_segment1 is Null)) THEN
840: x_valid := FALSE;
841: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
842: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1');
843: FND_MSG_PUB.ADD;
844: ELSIF l_ven_num_code not in ('MANUAL','AUTOMATIC') then
845: x_valid := FALSE;
846: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
842: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1');
843: FND_MSG_PUB.ADD;
844: ELSIF l_ven_num_code not in ('MANUAL','AUTOMATIC') then
845: x_valid := FALSE;
846: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
847: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','USER_DEFINED_VENDOR_NUM_CODE');
848: FND_MSG_PUB.ADD;
849: END IF;
850:
843: FND_MSG_PUB.ADD;
844: ELSIF l_ven_num_code not in ('MANUAL','AUTOMATIC') then
845: x_valid := FALSE;
846: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
847: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','USER_DEFINED_VENDOR_NUM_CODE');
848: FND_MSG_PUB.ADD;
849: END IF;
850:
851: END Chk_Null_Vendor_Number;
911: END IF;
912:
913: IF p_country = 'US' THEN
914: IF (l_outcome = 'F') THEN
915: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
916: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','NUM_1099' );
917: FND_MSG_PUB.ADD; --bug6050423
918: l_ret_value := 'N';
919: END IF;
912:
913: IF p_country = 'US' THEN
914: IF (l_outcome = 'F') THEN
915: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
916: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','NUM_1099' );
917: FND_MSG_PUB.ADD; --bug6050423
918: l_ret_value := 'N';
919: END IF;
920: END IF;
920: END IF;
921: IF p_country IN ('IT','ES','PT') THEN
922: IF l_return_status = FND_API.G_RET_STS_ERROR
923: THEN
924: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
925: FND_MESSAGE.SET_TOKEN('REG_CODE', l_registration_code);
926: FND_MESSAGE.SET_TOKEN('REG_NUM', p_taxpayer_id);
927: FND_MSG_PUB.ADD; --bug6050423
928: l_ret_value := 'N'; --bug6050423
921: IF p_country IN ('IT','ES','PT') THEN
922: IF l_return_status = FND_API.G_RET_STS_ERROR
923: THEN
924: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
925: FND_MESSAGE.SET_TOKEN('REG_CODE', l_registration_code);
926: FND_MESSAGE.SET_TOKEN('REG_NUM', p_taxpayer_id);
927: FND_MSG_PUB.ADD; --bug6050423
928: l_ret_value := 'N'; --bug6050423
929: END IF;
922: IF l_return_status = FND_API.G_RET_STS_ERROR
923: THEN
924: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
925: FND_MESSAGE.SET_TOKEN('REG_CODE', l_registration_code);
926: FND_MESSAGE.SET_TOKEN('REG_NUM', p_taxpayer_id);
927: FND_MSG_PUB.ADD; --bug6050423
928: l_ret_value := 'N'; --bug6050423
929: END IF;
930: END IF;
952:
953: IF ((l_ven_num_code = 'MANUAL') and (p_segment1 is NULL)) THEN
954:
955: x_valid := FALSE;
956: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
957: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1' );
958: FND_MSG_PUB.ADD;
959: END IF;
960:
953: IF ((l_ven_num_code = 'MANUAL') and (p_segment1 is NULL)) THEN
954:
955: x_valid := FALSE;
956: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
957: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SEGMENT1' );
958: FND_MSG_PUB.ADD;
959: END IF;
960:
961: END Check_valid_vendor_num;
971: x_valid := TRUE;
972:
973: IF p_match_option not IN ('P','R') THEN
974: x_valid := FALSE;
975: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
976: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','MATCH_OPTION' );
977: FND_MSG_PUB.ADD;
978: END IF;
979:
972:
973: IF p_match_option not IN ('P','R') THEN
974: x_valid := FALSE;
975: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
976: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','MATCH_OPTION' );
977: FND_MSG_PUB.ADD;
978: END IF;
979:
980: END Check_Valid_Match_Option;
998:
999: IF l_asp_awt_flag = 'N'
1000: AND p_allow_awt_flag = 'Y' THEN
1001: x_valid := FALSE;
1002: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1003: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','ALLOW_AWT_FLAG' );
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006:
999: IF l_asp_awt_flag = 'N'
1000: AND p_allow_awt_flag = 'Y' THEN
1001: x_valid := FALSE;
1002: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1003: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','ALLOW_AWT_FLAG' );
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006:
1007: END Chk_allow_awt_flag;
1026: BEGIN
1027: If p_awt_id is NOT NULL then
1028:
1029: x_valid := FALSE;
1030: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1031: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1032: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_ID');
1033: FND_MSG_PUB.ADD;
1034: Elsif p_awt_name is NOT NULL Then
1027: If p_awt_id is NOT NULL then
1028:
1029: x_valid := FALSE;
1030: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1031: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1032: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_ID');
1033: FND_MSG_PUB.ADD;
1034: Elsif p_awt_name is NOT NULL Then
1035:
1028:
1029: x_valid := FALSE;
1030: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1031: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1032: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_ID');
1033: FND_MSG_PUB.ADD;
1034: Elsif p_awt_name is NOT NULL Then
1035:
1036: x_valid := FALSE;
1033: FND_MSG_PUB.ADD;
1034: Elsif p_awt_name is NOT NULL Then
1035:
1036: x_valid := FALSE;
1037: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1038: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1039: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1040: FND_MSG_PUB.ADD;
1041: End If;
1034: Elsif p_awt_name is NOT NULL Then
1035:
1036: x_valid := FALSE;
1037: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1038: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1039: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1040: FND_MSG_PUB.ADD;
1041: End If;
1042:
1035:
1036: x_valid := FALSE;
1037: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1038: FND_MESSAGE.SET_TOKEN('ID','ALLOW_AWT_FLAG');
1039: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1040: FND_MSG_PUB.ADD;
1041: End If;
1042:
1043: END;
1054: EXCEPTION
1055: -- Trap validation error
1056: WHEN NO_DATA_FOUND THEN
1057: x_valid := FALSE;
1058: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1059: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','AWT_GROUP_ID' );
1060: FND_MSG_PUB.ADD;
1061: END;
1062:
1055: -- Trap validation error
1056: WHEN NO_DATA_FOUND THEN
1057: x_valid := FALSE;
1058: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1059: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','AWT_GROUP_ID' );
1060: FND_MSG_PUB.ADD;
1061: END;
1062:
1063: ELSIF (p_allow_awt_flag = 'Y' and (p_awt_id is NOT NULL and p_awt_name is NOT NULL)) THEN
1073: EXCEPTION
1074: -- Trap validation error
1075: WHEN NO_DATA_FOUND THEN
1076: x_valid := FALSE;
1077: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1078: FND_MESSAGE.SET_TOKEN('ID','AWT_GROUP_ID');
1079: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1080: FND_MSG_PUB.ADD;
1081: END;
1074: -- Trap validation error
1075: WHEN NO_DATA_FOUND THEN
1076: x_valid := FALSE;
1077: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1078: FND_MESSAGE.SET_TOKEN('ID','AWT_GROUP_ID');
1079: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1080: FND_MSG_PUB.ADD;
1081: END;
1082:
1075: WHEN NO_DATA_FOUND THEN
1076: x_valid := FALSE;
1077: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1078: FND_MESSAGE.SET_TOKEN('ID','AWT_GROUP_ID');
1079: FND_MESSAGE.SET_TOKEN('NAME','AWT_GROUP_NAME');
1080: FND_MSG_PUB.ADD;
1081: END;
1082:
1083: ELSIF (p_allow_awt_flag = 'Y' and (p_awt_id is NULL and p_awt_name is NOT NULL)) THEN
1092: EXCEPTION
1093: -- Trap validation error
1094: WHEN NO_DATA_FOUND THEN
1095: x_valid := FALSE;
1096: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1097: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','AWT_GROUP_NAME' );
1098: FND_MSG_PUB.ADD;
1099: END;
1100:
1093: -- Trap validation error
1094: WHEN NO_DATA_FOUND THEN
1095: x_valid := FALSE;
1096: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1097: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','AWT_GROUP_NAME' );
1098: FND_MSG_PUB.ADD;
1099: END;
1100:
1101: END IF;
1123: -- Trap validation error
1124: WHEN NO_DATA_FOUND THEN
1125: x_valid := FALSE;
1126:
1127: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1128: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','HOLD_BY' );
1129: FND_MSG_PUB.ADD;
1130: END Check_Valid_Hold_by;
1131:
1124: WHEN NO_DATA_FOUND THEN
1125: x_valid := FALSE;
1126:
1127: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1128: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','HOLD_BY' );
1129: FND_MSG_PUB.ADD;
1130: END Check_Valid_Hold_by;
1131:
1132: --
1161: -- Trap validation error
1162: WHEN NO_DATA_FOUND THEN
1163: x_valid := FALSE;
1164:
1165: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1166: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TERMS_ID' );
1167: FND_MSG_PUB.ADD;
1168: END;
1169:
1162: WHEN NO_DATA_FOUND THEN
1163: x_valid := FALSE;
1164:
1165: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1166: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TERMS_ID' );
1167: FND_MSG_PUB.ADD;
1168: END;
1169:
1170: ELSIF (p_terms_id is NOT NULL and p_terms_name is NOT NULL) THEN
1181: -- Trap validation error
1182: WHEN NO_DATA_FOUND THEN
1183: x_valid := FALSE;
1184:
1185: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1186: FND_MESSAGE.SET_TOKEN('ID','TERMS_ID');
1187: FND_MESSAGE.SET_TOKEN('NAME','TERMS_NAME');
1188: FND_MSG_PUB.ADD;
1189: END;
1182: WHEN NO_DATA_FOUND THEN
1183: x_valid := FALSE;
1184:
1185: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1186: FND_MESSAGE.SET_TOKEN('ID','TERMS_ID');
1187: FND_MESSAGE.SET_TOKEN('NAME','TERMS_NAME');
1188: FND_MSG_PUB.ADD;
1189: END;
1190:
1183: x_valid := FALSE;
1184:
1185: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1186: FND_MESSAGE.SET_TOKEN('ID','TERMS_ID');
1187: FND_MESSAGE.SET_TOKEN('NAME','TERMS_NAME');
1188: FND_MSG_PUB.ADD;
1189: END;
1190:
1191: ELSIF (p_terms_id is NULL and p_terms_name is NOT NULL) THEN
1201: -- Trap validation error
1202: WHEN NO_DATA_FOUND THEN
1203: x_valid := FALSE;
1204:
1205: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1206: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TERMS_NAME' );
1207: FND_MSG_PUB.ADD;
1208: END;
1209:
1202: WHEN NO_DATA_FOUND THEN
1203: x_valid := FALSE;
1204:
1205: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1206: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TERMS_NAME' );
1207: FND_MSG_PUB.ADD;
1208: END;
1209:
1210: END IF;
1243: -- Trap validation error
1244: WHEN NO_DATA_FOUND THEN
1245: x_valid := FALSE;
1246:
1247: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1248: FND_MESSAGE.SET_TOKEN('ID','DISTRIBUTION_SET_ID');
1249: FND_MESSAGE.SET_TOKEN('NAME','DISTRIBUTION_SET_NAME');
1250: FND_MSG_PUB.ADD;
1251: END;
1244: WHEN NO_DATA_FOUND THEN
1245: x_valid := FALSE;
1246:
1247: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1248: FND_MESSAGE.SET_TOKEN('ID','DISTRIBUTION_SET_ID');
1249: FND_MESSAGE.SET_TOKEN('NAME','DISTRIBUTION_SET_NAME');
1250: FND_MSG_PUB.ADD;
1251: END;
1252:
1245: x_valid := FALSE;
1246:
1247: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1248: FND_MESSAGE.SET_TOKEN('ID','DISTRIBUTION_SET_ID');
1249: FND_MESSAGE.SET_TOKEN('NAME','DISTRIBUTION_SET_NAME');
1250: FND_MSG_PUB.ADD;
1251: END;
1252:
1253: ELSIF p_dist_id is NULL and p_dist_name is NOT NULL THEN
1262: -- Trap validation error
1263: WHEN NO_DATA_FOUND THEN
1264: x_valid := FALSE;
1265:
1266: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1267: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DISTRIBUTION_SET_NAME' );
1268: FND_MSG_PUB.ADD;
1269: END;
1270:
1263: WHEN NO_DATA_FOUND THEN
1264: x_valid := FALSE;
1265:
1266: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1267: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DISTRIBUTION_SET_NAME' );
1268: FND_MSG_PUB.ADD;
1269: END;
1270:
1271: ELSIF p_dist_id is NOT NULL and p_dist_name is NULL THEN
1280: -- Trap validation error
1281: WHEN NO_DATA_FOUND THEN
1282: x_valid := FALSE;
1283:
1284: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1285: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DISTRIBUTION_SET_ID' );
1286: FND_MSG_PUB.ADD;
1287: END;
1288:
1281: WHEN NO_DATA_FOUND THEN
1282: x_valid := FALSE;
1283:
1284: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1285: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DISTRIBUTION_SET_ID' );
1286: FND_MSG_PUB.ADD;
1287: END;
1288:
1289: END IF;
1328: -- Trap validation error
1329: WHEN NO_DATA_FOUND THEN
1330: x_valid := FALSE;
1331:
1332: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1333: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_TO_LOCATION_ID' );
1334: FND_MSG_PUB.ADD;
1335: END;
1336:
1329: WHEN NO_DATA_FOUND THEN
1330: x_valid := FALSE;
1331:
1332: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1333: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_TO_LOCATION_ID' );
1334: FND_MSG_PUB.ADD;
1335: END;
1336:
1337: ELSIF (p_ship_location_id is NOT NULL and p_ship_location_code is NOT NULL) THEN
1352: -- Trap validation error
1353: WHEN NO_DATA_FOUND THEN
1354: x_valid := FALSE;
1355:
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1357: FND_MESSAGE.SET_TOKEN('ID','SHIP_TO_LOCATION_ID');
1358: FND_MESSAGE.SET_TOKEN('NAME','SHIP_TO_LOCATION_CODE');
1359: FND_MSG_PUB.ADD;
1360: END;
1353: WHEN NO_DATA_FOUND THEN
1354: x_valid := FALSE;
1355:
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1357: FND_MESSAGE.SET_TOKEN('ID','SHIP_TO_LOCATION_ID');
1358: FND_MESSAGE.SET_TOKEN('NAME','SHIP_TO_LOCATION_CODE');
1359: FND_MSG_PUB.ADD;
1360: END;
1361:
1354: x_valid := FALSE;
1355:
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1357: FND_MESSAGE.SET_TOKEN('ID','SHIP_TO_LOCATION_ID');
1358: FND_MESSAGE.SET_TOKEN('NAME','SHIP_TO_LOCATION_CODE');
1359: FND_MSG_PUB.ADD;
1360: END;
1361:
1362: ELSIF (p_ship_location_id is NULL and p_ship_location_code is NOT NULL) THEN
1376: -- Trap validation error
1377: WHEN NO_DATA_FOUND THEN
1378: x_valid := FALSE;
1379:
1380: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1381: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_TO_LOCATION_CODE' );
1382: FND_MSG_PUB.ADD;
1383: END;
1384:
1377: WHEN NO_DATA_FOUND THEN
1378: x_valid := FALSE;
1379:
1380: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1381: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_TO_LOCATION_CODE' );
1382: FND_MSG_PUB.ADD;
1383: END;
1384:
1385: END IF;
1422: -- Trap validation error
1423: WHEN NO_DATA_FOUND THEN
1424: x_valid := FALSE;
1425:
1426: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1427: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','BILL_TO_LOCATION_ID' );
1428: FND_MSG_PUB.ADD;
1429: END;
1430:
1423: WHEN NO_DATA_FOUND THEN
1424: x_valid := FALSE;
1425:
1426: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1427: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','BILL_TO_LOCATION_ID' );
1428: FND_MSG_PUB.ADD;
1429: END;
1430:
1431: ELSIF p_bill_location_id is NOT NULL and p_bill_location_code is NOT NULL THEN
1447: -- Trap validation error
1448: WHEN NO_DATA_FOUND THEN
1449: x_valid := FALSE;
1450:
1451: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1452: FND_MESSAGE.SET_TOKEN('ID','BILL_TO_LOCATION_ID');
1453: FND_MESSAGE.SET_TOKEN('NAME','BILL_TO_LOCATION_CODE');
1454: FND_MSG_PUB.ADD;
1455: END;
1448: WHEN NO_DATA_FOUND THEN
1449: x_valid := FALSE;
1450:
1451: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1452: FND_MESSAGE.SET_TOKEN('ID','BILL_TO_LOCATION_ID');
1453: FND_MESSAGE.SET_TOKEN('NAME','BILL_TO_LOCATION_CODE');
1454: FND_MSG_PUB.ADD;
1455: END;
1456:
1449: x_valid := FALSE;
1450:
1451: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
1452: FND_MESSAGE.SET_TOKEN('ID','BILL_TO_LOCATION_ID');
1453: FND_MESSAGE.SET_TOKEN('NAME','BILL_TO_LOCATION_CODE');
1454: FND_MSG_PUB.ADD;
1455: END;
1456:
1457: ELSIF p_bill_location_id is NULL and p_bill_location_code is NOT NULL THEN
1472: -- Trap validation error
1473: WHEN NO_DATA_FOUND THEN
1474: x_valid := FALSE;
1475:
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1477: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','BILL_TO_LOCATION_CODE' );
1478: FND_MSG_PUB.ADD;
1479: END;
1480:
1473: WHEN NO_DATA_FOUND THEN
1474: x_valid := FALSE;
1475:
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1477: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','BILL_TO_LOCATION_CODE' );
1478: FND_MSG_PUB.ADD;
1479: END;
1480:
1481: END IF;
1509: -- Trap validation error
1510: WHEN NO_DATA_FOUND THEN
1511: x_valid := FALSE;
1512:
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1514: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DEFAULT_PAY_SITE_ID' );
1515: FND_MSG_PUB.ADD;
1516: END Check_Default_pay_site;
1517:
1510: WHEN NO_DATA_FOUND THEN
1511: x_valid := FALSE;
1512:
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1514: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DEFAULT_PAY_SITE_ID' );
1515: FND_MSG_PUB.ADD;
1516: END Check_Default_pay_site;
1517:
1518: --
1533: WHERE region_short_name = p_state
1534: AND sysdate < nvl(inactive_date,sysdate+1);
1535:
1536: IF (l_count = 0) THEN
1537: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_STATE');
1538: FND_MSG_PUB.ADD;
1539: p_valid := FALSE;
1540: END IF;
1541:
1589: END IF;
1590: END IF;
1591: ELSE
1592: -- Bug 5491139 hkaniven start --
1593: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_ORG_INFO');
1594: FND_MSG_PUB.ADD;
1595: -- Bug 5491139 hkaniven end --
1596: END IF;
1597: END;
1627: END IF;
1628: END IF;
1629: ELSE
1630: -- Bug 5491139 hkaniven start --
1631: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ORG_INFO');
1632: FND_MSG_PUB.ADD;
1633: -- Bug 5491139 hkaniven end --
1634: END IF;
1635: END;
1665: END IF;
1666: END IF;
1667: ELSE
1668: -- Bug 5491139 hkaniven start --
1669: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ORG_INFO');
1670: FND_MSG_PUB.ADD;
1671: -- Bug 5491139 hkaniven end --
1672: END IF;
1673: END;
1711:
1712: EXCEPTION
1713: WHEN e_apps_exception THEN
1714: x_valid := FALSE;
1715: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1716: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1717: FND_MESSAGE.SET_TOKEN('NAME','PAY_ON_RECEIPT_SUMMARY_CODE');
1718: FND_MSG_PUB.ADD;
1719: END Check_pay_on_rec_sum_code;
1712: EXCEPTION
1713: WHEN e_apps_exception THEN
1714: x_valid := FALSE;
1715: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1716: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1717: FND_MESSAGE.SET_TOKEN('NAME','PAY_ON_RECEIPT_SUMMARY_CODE');
1718: FND_MSG_PUB.ADD;
1719: END Check_pay_on_rec_sum_code;
1720:
1713: WHEN e_apps_exception THEN
1714: x_valid := FALSE;
1715: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1716: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1717: FND_MESSAGE.SET_TOKEN('NAME','PAY_ON_RECEIPT_SUMMARY_CODE');
1718: FND_MSG_PUB.ADD;
1719: END Check_pay_on_rec_sum_code;
1720:
1721: --
1732: IF upper(p_shipping_control) NOT IN ('SUPPLIER','BUYER') THEN
1733:
1734: x_valid := FALSE;
1735:
1736: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1737: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIPPING_CONTROL' );
1738: FND_MSG_PUB.ADD;
1739: END IF;
1740:
1733:
1734: x_valid := FALSE;
1735:
1736: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1737: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIPPING_CONTROL' );
1738: FND_MSG_PUB.ADD;
1739: END IF;
1740:
1741: END Check_Shipping_Control;
1764:
1765:
1766: IF (nvl(p_purchasing_site_flag,'N') = 'N') THEN
1767: x_valid := FALSE;
1768: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1769: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1770: FND_MESSAGE.SET_TOKEN('NAME','PURCHASING_SITE_FLAG');
1771: FND_MSG_PUB.ADD;
1772: ELSIF (nvl(p_purchasing_site_flag,'N') = 'Y') THEN
1765:
1766: IF (nvl(p_purchasing_site_flag,'N') = 'N') THEN
1767: x_valid := FALSE;
1768: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1769: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1770: FND_MESSAGE.SET_TOKEN('NAME','PURCHASING_SITE_FLAG');
1771: FND_MSG_PUB.ADD;
1772: ELSIF (nvl(p_purchasing_site_flag,'N') = 'Y') THEN
1773:
1766: IF (nvl(p_purchasing_site_flag,'N') = 'N') THEN
1767: x_valid := FALSE;
1768: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1769: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1770: FND_MESSAGE.SET_TOKEN('NAME','PURCHASING_SITE_FLAG');
1771: FND_MSG_PUB.ADD;
1772: ELSIF (nvl(p_purchasing_site_flag,'N') = 'Y') THEN
1773:
1774: If p_pay_on_code IN ('RECEIPT','USE','RECEIPT_AND_USE') Then
1777: End If;
1778:
1779: IF l_dummy = 'N' THEN
1780: x_valid := FALSE;
1781: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1782: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PAY_ON_CODE' );
1783: FND_MSG_PUB.ADD;
1784: ELSIF (p_pay_site_flag = 'N' and l_default_pay_site_id IS NULL) THEN
1785: x_valid := FALSE;
1778:
1779: IF l_dummy = 'N' THEN
1780: x_valid := FALSE;
1781: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
1782: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PAY_ON_CODE' );
1783: FND_MSG_PUB.ADD;
1784: ELSIF (p_pay_site_flag = 'N' and l_default_pay_site_id IS NULL) THEN
1785: x_valid := FALSE;
1786: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1782: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PAY_ON_CODE' );
1783: FND_MSG_PUB.ADD;
1784: ELSIF (p_pay_site_flag = 'N' and l_default_pay_site_id IS NULL) THEN
1785: x_valid := FALSE;
1786: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1787: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1788: FND_MESSAGE.SET_TOKEN('NAME','PAY_SITE_FLAG');
1789: FND_MSG_PUB.ADD;
1790: END IF;
1783: FND_MSG_PUB.ADD;
1784: ELSIF (p_pay_site_flag = 'N' and l_default_pay_site_id IS NULL) THEN
1785: x_valid := FALSE;
1786: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1787: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1788: FND_MESSAGE.SET_TOKEN('NAME','PAY_SITE_FLAG');
1789: FND_MSG_PUB.ADD;
1790: END IF;
1791:
1784: ELSIF (p_pay_site_flag = 'N' and l_default_pay_site_id IS NULL) THEN
1785: x_valid := FALSE;
1786: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_INCONSISTENT');
1787: FND_MESSAGE.SET_TOKEN('ID','PAY_ON_CODE');
1788: FND_MESSAGE.SET_TOKEN('NAME','PAY_SITE_FLAG');
1789: FND_MSG_PUB.ADD;
1790: END IF;
1791:
1792: END IF;
1817: OR (p_pay_on_code = 'RECEIPT' and lookup_code IN ('RECEIPT','PACKING_SLIP'))
1818: );
1819:
1820: IF (l_count = 0) THEN
1821: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_RECPT_SUMM');
1822: FND_MSG_PUB.ADD;
1823: p_valid := FALSE;
1824: END IF;
1825:
2044: operating_unit_name = p_org_name);
2045:
2046: IF (l_dummy_1 > 0 or l_dummy_2 > 1) THEN
2047: x_valid := FALSE;
2048: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2049: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
2050: FND_MSG_PUB.ADD;
2051: END IF;
2052:
2045:
2046: IF (l_dummy_1 > 0 or l_dummy_2 > 1) THEN
2047: x_valid := FALSE;
2048: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2049: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
2050: FND_MSG_PUB.ADD;
2051: END IF;
2052:
2053: End;
2071: operating_unit_name = p_org_name);
2072:
2073: IF (l_dummy_1 > 0 or l_dummy_2 > 1) THEN
2074: x_valid := FALSE;
2075: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2076: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
2077: FND_MSG_PUB.ADD;
2078: END IF;
2079:
2072:
2073: IF (l_dummy_1 > 0 or l_dummy_2 > 1) THEN
2074: x_valid := FALSE;
2075: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2076: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
2077: FND_MSG_PUB.ADD;
2078: END IF;
2079:
2080: END IF;
2098: FROM fnd_territories_vl
2099: WHERE territory_code = p_country_of_origin_code;
2100:
2101: IF (l_count = 0) THEN
2102: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_COUNTRY_OF_ORIG');
2103: FND_MSG_PUB.ADD;
2104:
2105: p_valid := FALSE;
2106: END IF;
2129: l_column_name := 'SELLING_COMPANY_IDENTIFIER';
2130: IF nvl(p_gapless_inv_num_flag,'N') = 'Y' THEN
2131: IF (p_selling_company_identifier IS NULL OR
2132: p_selling_company_identifier = ap_null_char) THEN
2133: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2134: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', l_column_name);
2135: FND_MSG_PUB.ADD;
2136: p_valid := FALSE;
2137: END IF;
2130: IF nvl(p_gapless_inv_num_flag,'N') = 'Y' THEN
2131: IF (p_selling_company_identifier IS NULL OR
2132: p_selling_company_identifier = ap_null_char) THEN
2133: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2134: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', l_column_name);
2135: FND_MSG_PUB.ADD;
2136: p_valid := FALSE;
2137: END IF;
2138: END IF;
2146: WHERE selling_company_identifier = p_selling_company_identifier
2147: AND vendor_id <> p_vendor_id;
2148:
2149: IF l_vendor_count > 0 THEN
2150: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2151: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', l_column_name);
2152: FND_MSG_PUB.ADD;
2153: p_valid := FALSE;
2154: END IF;
2147: AND vendor_id <> p_vendor_id;
2148:
2149: IF l_vendor_count > 0 THEN
2150: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2151: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', l_column_name);
2152: FND_MSG_PUB.ADD;
2153: p_valid := FALSE;
2154: END IF;
2155:
2170: IF p_sup_notif_method NOT IN ('EMAIL','PRINT','FAX') THEN
2171:
2172: x_valid := FALSE;
2173:
2174: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2175: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SUPPLIER_NOTIF_METHOD' );
2176: FND_MSG_PUB.ADD;
2177: END IF;
2178:
2171:
2172: x_valid := FALSE;
2173:
2174: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2175: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SUPPLIER_NOTIF_METHOD' );
2176: FND_MSG_PUB.ADD;
2177: END IF;
2178:
2179: END Check_Valid_Sup_Notif_Method;
2256: WHEN NO_DATA_FOUND THEN
2257: x_valid := FALSE;
2258:
2259: IF p_tolerance_type = 'QUANTITY' THEN
2260: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2261: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_ID' );
2262: FND_MSG_PUB.ADD;
2263: ELSE
2264: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2257: x_valid := FALSE;
2258:
2259: IF p_tolerance_type = 'QUANTITY' THEN
2260: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2261: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_ID' );
2262: FND_MSG_PUB.ADD;
2263: ELSE
2264: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2265: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_ID' );
2260: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2261: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_ID' );
2262: FND_MSG_PUB.ADD;
2263: ELSE
2264: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2265: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_ID' );
2266: FND_MSG_PUB.ADD;
2267: END IF;
2268: END;
2261: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_ID' );
2262: FND_MSG_PUB.ADD;
2263: ELSE
2264: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2265: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_ID' );
2266: FND_MSG_PUB.ADD;
2267: END IF;
2268: END;
2269:
2280: WHEN NO_DATA_FOUND THEN
2281: x_valid := FALSE;
2282:
2283: IF p_tolerance_type = 'QUANTITY' THEN
2284: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2285: FND_MESSAGE.SET_TOKEN('ID','TOLERANCE_ID');
2286: FND_MESSAGE.SET_TOKEN('NAME','TOLERANCE_NAME');
2287: FND_MSG_PUB.ADD;
2288: ELSE
2281: x_valid := FALSE;
2282:
2283: IF p_tolerance_type = 'QUANTITY' THEN
2284: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2285: FND_MESSAGE.SET_TOKEN('ID','TOLERANCE_ID');
2286: FND_MESSAGE.SET_TOKEN('NAME','TOLERANCE_NAME');
2287: FND_MSG_PUB.ADD;
2288: ELSE
2289: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2282:
2283: IF p_tolerance_type = 'QUANTITY' THEN
2284: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2285: FND_MESSAGE.SET_TOKEN('ID','TOLERANCE_ID');
2286: FND_MESSAGE.SET_TOKEN('NAME','TOLERANCE_NAME');
2287: FND_MSG_PUB.ADD;
2288: ELSE
2289: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2290: FND_MESSAGE.SET_TOKEN('ID','SERVICES_TOLERANCE_ID');
2285: FND_MESSAGE.SET_TOKEN('ID','TOLERANCE_ID');
2286: FND_MESSAGE.SET_TOKEN('NAME','TOLERANCE_NAME');
2287: FND_MSG_PUB.ADD;
2288: ELSE
2289: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2290: FND_MESSAGE.SET_TOKEN('ID','SERVICES_TOLERANCE_ID');
2291: FND_MESSAGE.SET_TOKEN('NAME','SERVICES_TOLERANCE_NAME');
2292: FND_MSG_PUB.ADD;
2293: END IF;
2286: FND_MESSAGE.SET_TOKEN('NAME','TOLERANCE_NAME');
2287: FND_MSG_PUB.ADD;
2288: ELSE
2289: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2290: FND_MESSAGE.SET_TOKEN('ID','SERVICES_TOLERANCE_ID');
2291: FND_MESSAGE.SET_TOKEN('NAME','SERVICES_TOLERANCE_NAME');
2292: FND_MSG_PUB.ADD;
2293: END IF;
2294: END;
2287: FND_MSG_PUB.ADD;
2288: ELSE
2289: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMNS_NOT_MATCHED');
2290: FND_MESSAGE.SET_TOKEN('ID','SERVICES_TOLERANCE_ID');
2291: FND_MESSAGE.SET_TOKEN('NAME','SERVICES_TOLERANCE_NAME');
2292: FND_MSG_PUB.ADD;
2293: END IF;
2294: END;
2295:
2304: -- Trap validation error
2305: WHEN NO_DATA_FOUND THEN
2306: x_valid := FALSE;
2307: IF p_tolerance_type = 'QUANTITY' THEN
2308: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2309: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_NAME' );
2310: FND_MSG_PUB.ADD;
2311: ELSE
2312: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2305: WHEN NO_DATA_FOUND THEN
2306: x_valid := FALSE;
2307: IF p_tolerance_type = 'QUANTITY' THEN
2308: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2309: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_NAME' );
2310: FND_MSG_PUB.ADD;
2311: ELSE
2312: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2313: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_NAME' );
2308: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2309: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_NAME' );
2310: FND_MSG_PUB.ADD;
2311: ELSE
2312: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2313: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_NAME' );
2314: FND_MSG_PUB.ADD;
2315: END IF;
2316: END;
2309: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','TOLERANCE_NAME' );
2310: FND_MSG_PUB.ADD;
2311: ELSE
2312: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2313: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SERVICES_TOLERANCE_NAME' );
2314: FND_MSG_PUB.ADD;
2315: END IF;
2316: END;
2317: END IF;
2342: -- Trap validation error
2343: WHEN NO_DATA_FOUND THEN
2344: x_valid := FALSE;
2345:
2346: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2347: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_VIA_LOOKUP_CODE' );
2348: FND_MSG_PUB.ADD;
2349: END Check_Site_Ship_Via;
2350:
2343: WHEN NO_DATA_FOUND THEN
2344: x_valid := FALSE;
2345:
2346: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2347: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','SHIP_VIA_LOOKUP_CODE' );
2348: FND_MSG_PUB.ADD;
2349: END Check_Site_Ship_Via;
2350:
2351: --
2370: -- Trap validation error
2371: WHEN NO_DATA_FOUND THEN
2372: x_valid := FALSE;
2373:
2374: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2375: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_ID' );
2376: FND_MSG_PUB.ADD;
2377:
2378: IF x_valid = TRUE THEN
2371: WHEN NO_DATA_FOUND THEN
2372: x_valid := FALSE;
2373:
2374: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2375: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_ID' );
2376: FND_MSG_PUB.ADD;
2377:
2378: IF x_valid = TRUE THEN
2379: --check usage status
2386:
2387: IF nvl(l_count, -1) > 0 THEN
2388: x_valid := FALSE;
2389:
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2391: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_ID' );
2392: FND_MSG_PUB.ADD;
2393: END IF;
2394: END IF;
2387: IF nvl(l_count, -1) > 0 THEN
2388: x_valid := FALSE;
2389:
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2391: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_ID' );
2392: FND_MSG_PUB.ADD;
2393: END IF;
2394: END IF;
2395:
2416:
2417: IF nvl(l_dummy,0) = 0 THEN
2418: x_valid := FALSE;
2419:
2420: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2421: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','LOCATION_ID' );
2422: FND_MSG_PUB.ADD;
2423: END IF;
2424:
2417: IF nvl(l_dummy,0) = 0 THEN
2418: x_valid := FALSE;
2419:
2420: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2421: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','LOCATION_ID' );
2422: FND_MSG_PUB.ADD;
2423: END IF;
2424:
2425: END Check_Valid_Location_Id;
2444:
2445: IF nvl(l_dummy,0) = 0 THEN
2446: x_valid := FALSE;
2447:
2448: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2449: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_SITE_ID' );
2450: FND_MSG_PUB.ADD;
2451: END IF;
2452:
2445: IF nvl(l_dummy,0) = 0 THEN
2446: x_valid := FALSE;
2447:
2448: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2449: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PARTY_SITE_ID' );
2450: FND_MSG_PUB.ADD;
2451: END IF;
2452:
2453:
2476: -- Trap validation error
2477: WHEN NO_DATA_FOUND THEN
2478: x_valid := FALSE;
2479:
2480: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2481: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','RELATIONSHIP_ID' );
2482: FND_MSG_PUB.ADD;
2483:
2484: END Check_Valid_Relationship_Id;
2477: WHEN NO_DATA_FOUND THEN
2478: x_valid := FALSE;
2479:
2480: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2481: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','RELATIONSHIP_ID' );
2482: FND_MSG_PUB.ADD;
2483:
2484: END Check_Valid_Relationship_Id;
2485:
2505: -- Trap validation error
2506: WHEN NO_DATA_FOUND THEN
2507: x_valid := FALSE;
2508:
2509: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2510: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','ORG_CONTACT_ID' );
2511: FND_MSG_PUB.ADD;
2512:
2513: END Check_Valid_Org_Contact_Id;
2506: WHEN NO_DATA_FOUND THEN
2507: x_valid := FALSE;
2508:
2509: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2510: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','ORG_CONTACT_ID' );
2511: FND_MSG_PUB.ADD;
2512:
2513: END Check_Valid_Org_Contact_Id;
2514:
2554: END IF;
2555: END IF;
2556: ELSE
2557: -- Bug 5491139 hkaniven start --
2558: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_ID');
2559: FND_MSG_PUB.ADD;
2560: -- Bug 5491139 hkaniven end --
2561: END IF;
2562: -- Trap unknown errors
2637: END IF;
2638: END IF;
2639: ELSE
2640: -- Bug 5491139 hkaniven start --
2641: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');
2642: FND_MSG_PUB.ADD;
2643: -- Bug 5491139 hkaniven end --
2644: END IF;
2645: END;
2680: END IF;
2681: END IF;
2682: ELSE
2683: -- Bug 5491139 hkaniven start --
2684: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');
2685: FND_MSG_PUB.ADD;
2686: -- Bug 5491139 hkaniven end --
2687: END IF;
2688: END;
2824: -- Trap validation error
2825: WHEN e_apps_exception THEN
2826: x_valid := FALSE;
2827:
2828: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2829: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DUNS_NUMBER' );
2830: FND_MSG_PUB.ADD;
2831: END Chk_new_duns_number;
2832:
2825: WHEN e_apps_exception THEN
2826: x_valid := FALSE;
2827:
2828: FND_MESSAGE.SET_NAME('SQLAP','AP_IMPORT_COLUMN_INVALID');
2829: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','DUNS_NUMBER' );
2830: FND_MSG_PUB.ADD;
2831: END Chk_new_duns_number;
2832:
2833:
2859: -- Trap validation error
2860: WHEN e_apps_exception THEN
2861: x_valid := FALSE;
2862:
2863: FND_MESSAGE.SET_NAME('SQLAP','AP_CCR_NO_UPDATE');
2864: FND_MSG_PUB.ADD;
2865: END update_supplier_JFMIP_checks;
2866:
2867:
2903: EXCEPTION
2904: -- Trap validation error
2905: WHEN e_apps_exception THEN
2906: x_valid := FALSE;
2907: FND_MESSAGE.SET_NAME('SQLAP','AP_CCR_NO_UPDATE');
2908: FND_MSG_PUB.ADD;
2909:
2910: END Chk_update_site_ccr_values;
2911:
4284: END IF;
4285: END IF;
4286: ELSE
4287: -- Bug 5491139 hkaniven start --
4288: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_INSP_REQ_FLAG');
4289: FND_MSG_PUB.ADD;
4290: -- Bug 5491139 hkaniven end --
4291: END IF;
4292: END IF;
4326: END IF;
4327:
4328: ELSE
4329: -- Bug 5491139 hkaniven start --
4330: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_REC_REQ_FLAG');
4331: FND_MSG_PUB.ADD;
4332: -- Bug 5491139 hkaniven end --
4333: END IF;
4334: END IF;
4369: END IF;
4370: END IF;
4371: ELSE
4372: -- Bug 5491139 hkaniven start --
4373: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYMENT_PRIORITY');
4374: FND_MSG_PUB.ADD;
4375: -- Bug 5491139 hkaniven end --
4376: END IF;
4377: END IF;
4413: END IF;
4414: END IF;
4415: ELSE
4416: -- Bug 5491139 hkaniven start --
4417: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_1099_TYPE');
4418: FND_MSG_PUB.ADD;
4419: -- Bug 5491139 hkaniven end --
4420: END IF;
4421: END IF;
4478: END IF;
4479: END IF;
4480:
4481: ELSE
4482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEFAULT_COUNTRY_CODE_NULL');
4483: FND_MSG_PUB.ADD;
4484: END IF;
4485:
4486: -- End of Bug 6852552
4518: ||' ,Federal_Reportable_Flag: '||p_vendor_rec.federal_reportable_flag);
4519: END IF;
4520: END IF;
4521: ELSE
4522: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TAXPAYER_ID');
4523: FND_MSG_PUB.ADD;
4524: END IF;
4525: END IF;
4526: END IF;
4558: ||' ,Employee_Id: NULL');
4559: END IF;
4560: END IF;
4561: ELSE
4562: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_EMPLOYEE_ID');
4563: FND_MSG_PUB.ADD;
4564: END IF;
4565: END IF;
4566: -- end added by abhsaxen for bug 7147735
4587: END IF;
4588: END IF;
4589: ELSE
4590: -- Bug 5491139 hkaniven start --
4591: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_EMPLOYEE_ID');
4592: FND_MSG_PUB.ADD;
4593: -- Bug 5491139 hkaniven end --
4594: END IF;
4595: END IF;
4623: ||' ,Not able to get Party Id From Employee Id.');
4624: END IF;
4625: END IF;
4626: ELSE
4627: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_EMPLOYEE_ID');
4628: FND_MSG_PUB.ADD;
4629: END IF;
4630: END;
4631: -- end added by abhsaxen for bug 7147735
4671: END IF;
4672: END IF;
4673: ELSE
4674: -- Bug 5491139 hkaniven start --
4675: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_INSPEC_RECEIPT');
4676: FND_MSG_PUB.ADD;
4677: -- Bug 5491139 hkaniven end --
4678: END IF;
4679: END IF;
4712: END IF;
4713: END IF;
4714: ELSE
4715: -- Bug 5491139 hkaniven start --
4716: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_NAME_CONTROL');
4717: FND_MSG_PUB.ADD;
4718: -- Bug 5491139 hkaniven end --
4719: END IF;
4720: END IF;
4761: END IF;
4762: END IF;
4763: ELSE
4764: -- Bug 5491139 hkaniven start --
4765: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_SHIP_INVENTORY');
4766: FND_MSG_PUB.ADD;
4767: -- Bug 5491139 hkaniven end --
4768: END IF;
4769: END IF;
4804: END IF;
4805: END IF;
4806: ELSE
4807: -- Bug 5491139 hkaniven start --
4808: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SOB');
4809: FND_MSG_PUB.ADD;
4810: -- Bug 5491139 hkaniven end --
4811: END IF;
4812: END IF;
4868: END IF;
4869: END IF;
4870: ELSE
4871: -- Bug 5491139 hkaniven start --
4872: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SEGMENT1_INT');
4873: FND_MSG_PUB.ADD;
4874: -- Bug 5491139 hkaniven end --
4875: END IF;
4876: END IF;
4969: END IF;
4970: END IF;
4971: ELSE
4972: -- Bug 5491139 hkaniven start --
4973: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_RCV_ROUTING');
4974: FND_MSG_PUB.ADD;
4975: -- Bug 5491139 hkaniven end --
4976: END IF;
4977: END IF;
5018: END IF;
5019: ELSE
5020:
5021: -- Bug 5491139 hkaniven start --
5022: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_VENDOR_TYPE');
5023: FND_MSG_PUB.ADD;
5024: -- Bug 5491139 hkaniven end --
5025:
5026: END IF;
5059: END IF;
5060: ELSE
5061:
5062: -- Bug 5491139 hkaniven start --
5063: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_INV_CURRENCY');
5064: FND_MSG_PUB.ADD;
5065: -- Bug 5491139 hkaniven end --
5066:
5067: END IF;
5101: END IF;
5102: ELSE
5103:
5104: -- Bug 5491139 hkaniven start --
5105: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_CURRENCY');
5106: FND_MSG_PUB.ADD;
5107: -- Bug 5491139 hkaniven end --
5108:
5109: END IF;
5144: END IF;
5145: ELSE
5146:
5147: -- Bug 5491139 hkaniven start --
5148: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TYPE_1099');
5149: FND_MSG_PUB.ADD;
5150: -- Bug 5491139 hkaniven end --
5151:
5152: END IF;
5215: END IF;
5216:
5217: ELSE
5218:
5219: FND_MESSAGE.SET_NAME('SQLAP','AP_CANT_UPDATE_CCR_VENDOR');
5220: FND_MSG_PUB.ADD;
5221:
5222: END IF;
5223: END IF;
5314: END IF;
5315: ELSE
5316:
5317: -- Bug 5491139 hkaniven start --
5318: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYEE');
5319: FND_MSG_PUB.ADD;
5320: -- Bug 5491139 hkaniven end --
5321:
5322: END IF;
5361: END IF;
5362: ELSE
5363:
5364: -- Bug 5491139 hkaniven start --
5365: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PARTY_ID');
5366: FND_MSG_PUB.ADD;
5367: -- Bug 5491139 hkaniven end --
5368:
5369: END IF;
5412: END IF;
5413: ELSE
5414:
5415: -- Bug 5491139 hkaniven start --
5416: FND_MESSAGE.SET_NAME('SQLAP','AP_NULL_VENDOR_NUMBER');
5417: FND_MSG_PUB.ADD;
5418: -- Bug 5491139 hkaniven end --
5419:
5420: END IF;
5462: END IF;
5463: ELSE
5464:
5465: -- Bug 5491139 hkaniven start --
5466: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ONE_TIME_FLAG');
5467: FND_MSG_PUB.ADD;
5468: -- Bug 5491139 hkaniven end --
5469:
5470: END IF;
5507: END IF;
5508: END IF;
5509: ELSE
5510: -- Bug 5491139 hkaniven start --
5511: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SUMMARY_FLAG');
5512: FND_MSG_PUB.ADD;
5513: -- Bug 5491139 hkaniven end --
5514: END IF;
5515: END IF;
5551: END IF;
5552: END IF;
5553: ELSE
5554: -- Bug 5491139 hkaniven start --
5555: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ENABLED_FLAG');
5556: FND_MSG_PUB.ADD;
5557: -- Bug 5491139 hkaniven end --
5558: END IF;
5559: END IF;
5596: END IF;
5597: END IF;
5598: ELSE
5599: -- Bug 5491139 hkaniven start --
5600: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_TYPE');
5601: FND_MSG_PUB.ADD;
5602: -- Bug 5491139 hkaniven end --
5603: END IF;
5604: END IF;
5641: END IF;
5642: END IF;
5643: ELSE
5644: -- Bug 5491139 hkaniven start --
5645: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_DATE_BASIS');
5646: FND_MSG_PUB.ADD;
5647: -- Bug 5491139 hkaniven end --
5648: END IF;
5649: END IF;
5685: END IF;
5686: END IF;
5687: ELSE
5688: -- Bug 5491139 hkaniven start --
5689: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_GROUP');
5690: FND_MSG_PUB.ADD;
5691: -- Bug 5491139 hkaniven end --
5692:
5693: END IF;
5732: END IF;
5733: END IF;
5734: ELSE
5735: -- Bug 5491139 hkaniven start --
5736: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ORG_TYPE');
5737: FND_MSG_PUB.ADD;
5738: -- Bug 5491139 hkaniven end --
5739: END IF;
5740: END IF;
5777: END IF;
5778: END IF;
5779: ELSE
5780: -- Bug 5491139 hkaniven start --
5781: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_MINORITY_GROUP');
5782: FND_MSG_PUB.ADD;
5783: -- Bug 5491139 hkaniven end --
5784: END IF;
5785: END IF;
5822: END IF;
5823: END IF;
5824: ELSE
5825: -- Bug 5491139 hkaniven start --
5826: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TERMS_DATE');
5827: FND_MSG_PUB.ADD;
5828: -- Bug 5491139 hkaniven end --
5829: END IF;
5830: END IF;
5867: END IF;
5868: END IF;
5869: ELSE
5870: -- Bug 5491139 hkaniven start --
5871: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_QTY_RCV_OPTION');
5872: FND_MSG_PUB.ADD;
5873: -- Bug 5491139 hkaniven end --
5874: END IF;
5875: END IF;
5912: END IF;
5913: END IF;
5914: ELSE
5915: -- Bug 5491139 hkaniven start --
5916: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SHIP_RCV_OPTION');
5917: FND_MSG_PUB.ADD;
5918: -- Bug 5491139 hkaniven end --
5919: END IF;
5920: END IF;
5957: END IF;
5958: END IF;
5959: ELSE
5960: -- Bug 5491139 hkaniven start --
5961: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_REC_RCV_OPTION');
5962: FND_MSG_PUB.ADD;
5963: -- Bug 5491139 hkaniven end --
5964: END IF;
5965: END IF;
6002: END IF;
6003: END IF;
6004: ELSE
6005: -- Bug 5491139 hkaniven start --
6006: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_DEBIT_MEMO');
6007: FND_MSG_PUB.ADD;
6008: -- Bug 5491139 hkaniven end --
6009: END IF;
6010: END IF;
6047: END IF;
6048: END IF;
6049: ELSE
6050: -- Bug 5491139 hkaniven start --
6051: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_FED_REPORTABLE');
6052: FND_MSG_PUB.ADD;
6053: -- Bug 5491139 hkaniven end --
6054: END IF;
6055: END IF;
6092: END IF;
6093: END IF;
6094: ELSE
6095: -- Bug 5491139 hkaniven start --
6096: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_STATE_REPORTABLE');
6097: FND_MSG_PUB.ADD;
6098: -- Bug 5491139 hkaniven end --
6099: END IF;
6100: END IF;
6137: END IF;
6138: END IF;
6139: ELSE
6140: -- Bug 5491139 hkaniven start --
6141: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_CALC_INT');
6142: FND_MSG_PUB.ADD;
6143: -- Bug 5491139 hkaniven end --
6144: END IF;
6145: END IF;
6182: END IF;
6183: END IF;
6184: ELSE
6185: -- Bug 5491139 hkaniven start --
6186: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_EXC_FR_DISC');
6187: FND_MSG_PUB.ADD;
6188: -- Bug 5491139 hkaniven end --
6189: END IF;
6190: END IF;
6227: END IF;
6228: END IF;
6229: ELSE
6230: -- Bug 5491139 hkaniven start --
6231: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_UNMAT_INV');
6232: FND_MSG_PUB.ADD;
6233: -- Bug 5491139 hkaniven end --
6234: END IF;
6235: END IF;
6272: END IF;
6273: END IF;
6274: ELSE
6275: -- Bug 5491139 hkaniven start --
6276: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_UNORD_RCV');
6277: FND_MSG_PUB.ADD;
6278: -- Bug 5491139 hkaniven end --
6279: END IF;
6280: END IF;
6318: END IF;
6319: END IF;
6320: ELSE
6321: -- Bug 5491139 hkaniven start --
6322: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SUB_RCV');
6323: FND_MSG_PUB.ADD;
6324: -- Bug 5491139 hkaniven end --
6325: END IF;
6326: END IF;
6363: END IF;
6364: END IF;
6365: ELSE
6366: -- Bug 5491139 hkaniven start --
6367: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD');
6368: FND_MSG_PUB.ADD;
6369: -- Bug 5491139 hkaniven end --
6370: END IF;
6371: END IF;
6408: END IF;
6409: END IF;
6410: ELSE
6411: -- Bug 5491139 hkaniven start --
6412: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SMALL_BUSINESS');
6413: FND_MSG_PUB.ADD;
6414: -- Bug 5491139 hkaniven end --
6415: END IF;
6416: END IF;
6453: END IF;
6454: END IF;
6455: ELSE
6456: -- Bug 5491139 hkaniven start --
6457: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_WOMEN_OWNED');
6458: FND_MSG_PUB.ADD;
6459: -- Bug 5491139 hkaniven end --
6460: END IF;
6461: END IF;
6498: END IF;
6499: END IF;
6500: ELSE
6501: -- Bug 5491139 hkaniven start --
6502: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_FUT_PAY');
6503: FND_MSG_PUB.ADD;
6504: -- Bug 5491139 hkaniven end --
6505: END IF;
6506: END IF;
6543: END IF;
6544: END IF;
6545: ELSE
6546: -- Bug 5491139 hkaniven start --
6547: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_ALL_PAY');
6548: FND_MSG_PUB.ADD;
6549: -- Bug 5491139 hkaniven end --
6550: END IF;
6551: END IF;
6588: END IF;
6589: END IF;
6590: ELSE
6591: -- Bug 5491139 hkaniven start --
6592: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TAKE_DISC');
6593: FND_MSG_PUB.ADD;
6594: -- Bug 5491139 hkaniven end --
6595: END IF;
6596: END IF;
6630: END IF;
6631: END IF;
6632: ELSE
6633: -- Bug 5491139 hkaniven start --
6634: FND_MESSAGE.SET_NAME('SQLAP','AP_NULL_VENDOR_NUMBER');
6635: FND_MSG_PUB.ADD;
6636: -- Bug 5491139 hkaniven end --
6637: END IF;
6638: END IF;
6674: END IF;
6675: END IF;
6676: ELSE
6677: -- Bug 5491139 hkaniven start --
6678: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_MATCH_OPTION');
6679: FND_MSG_PUB.ADD;
6680: -- Bug 5491139 hkaniven end --
6681: END IF;
6682: END IF;
6727: END IF;
6728: END IF;
6729: ELSE
6730: -- Bug 5491139 hkaniven start --
6731: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_AWT_GROUP');
6732: FND_MSG_PUB.ADD;
6733: -- Bug 5491139 hkaniven end --
6734: END IF;
6735: END IF;
6800: END IF;
6801: END IF;
6802: ELSE
6803: -- Bug 5491139 hkaniven start --
6804: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_TERM');
6805: FND_MSG_PUB.ADD;
6806: -- Bug 5491139 hkaniven end --
6807: END IF;
6808: END IF;
7155: END IF;
7156: END IF;
7157: ELSE
7158: -- Bug 5491139 hkaniven start --
7159: FND_MESSAGE.SET_NAME('SQLAP','AP_ORG_INFO_NULL');
7160: FND_MSG_PUB.ADD;
7161: -- Bug 5491139 hkaniven end --
7162: END IF;
7163: -- RAISE FND_API.G_EXC_ERROR; BUG 6739544
7190: END IF;
7191: END IF;
7192: ELSE
7193: -- Bug 5491139 hkaniven start --
7194: FND_MESSAGE.SET_NAME('SQLAP','AP_ORG_INFO_NULL');
7195: FND_MSG_PUB.ADD;
7196: -- Bug 5491139 hkaniven end --
7197: END IF;
7198: -- RAISE FND_API.G_EXC_ERROR;
8749: END IF;
8750: END IF;
8751: ELSE
8752: -- Bug 5491139 hkaniven start --
8753: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_UNMAT_INV');
8754: FND_MSG_PUB.ADD;
8755: -- Bug 5491139 hkaniven end --
8756: END IF;
8757: END IF;
8793: END IF;
8794: END IF;
8795: ELSE
8796: -- Bug 5491139 hkaniven start --
8797: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TAX_RS_FLAG');
8798: FND_MSG_PUB.ADD;
8799: -- Bug 5491139 hkaniven end --
8800: END IF;
8801: END IF;
8843: ||p_vendor_site_rec.vat_code);
8844: END IF;
8845: END IF;
8846: ELSE
8847: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVALID_VAT_CODE');
8848: FND_MSG_PUB.ADD;
8849: END IF;
8850: END IF;
8851: END IF;
8892: END IF;
8893: END IF;
8894: ELSE
8895: -- Bug 5491139 hkaniven start --
8896: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_DEF_PAY_SITE');
8897: FND_MSG_PUB.ADD;
8898: -- Bug 5491139 hkaniven end --
8899: END IF;
8900: END IF;
8942: END IF;
8943: END IF;
8944: ELSE
8945: -- Bug 5491139 hkaniven start --
8946: FND_MESSAGE.SET_NAME('SQLAP','AP_DUPLICATE_VENDOR_SITE');
8947: FND_MSG_PUB.ADD;
8948: -- Bug 5491139 hkaniven end --
8949: END IF;
8950: END IF;
9014: END IF;
9015: END IF;
9016: ELSE
9017: -- Bug 5491139 hkaniven start --
9018: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_ON_RCE');
9019: FND_MSG_PUB.ADD;
9020: -- Bug 5491139 hkaniven end --
9021: END IF;
9022: END IF;
9058: END IF;
9059: END IF;
9060: ELSE
9061: -- Bug 5491139 hkaniven start --
9062: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SHIPPING_CONTROL');
9063: FND_MSG_PUB.ADD;
9064: -- Bug 5491139 hkaniven end --
9065: END IF;
9066: END IF;
9109: END IF;
9110: END IF;
9111: ELSE
9112: -- Bug 5491139 hkaniven start --
9113: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_TERM');
9114: FND_MSG_PUB.ADD;
9115: -- Bug 5491139 hkaniven end --
9116: END IF;
9117: END IF;
9157: END IF;
9158: END IF;
9159: ELSE
9160: -- Bug 5491139 hkaniven start --
9161: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_ON_CODE');
9162: FND_MSG_PUB.ADD;
9163: -- Bug 5491139 hkaniven end --
9164: END IF;
9165: END IF;
9201: END IF;
9202: END IF;
9203: ELSE
9204: -- Bug 5491139 hkaniven start --
9205: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_ON_RCE');
9206: FND_MSG_PUB.ADD;
9207: -- Bug 5491139 hkaniven end --
9208: END IF;
9209: END IF;
9244: END IF;
9245: END IF;
9246: ELSE
9247: -- Bug 5491139 hkaniven start --
9248: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYMENT_PRIORITY');
9249: FND_MSG_PUB.ADD;
9250: -- Bug 5491139 hkaniven end --
9251: END IF;
9252: END IF;
9283: END IF;
9284: END IF;
9285: ELSE
9286: -- Bug 5491139 hkaniven start --
9287: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_INV_CURRENCY');
9288: FND_MSG_PUB.ADD;
9289: -- Bug 5491139 hkaniven end --
9290: END IF;
9291: END IF;
9326: END IF;
9327: END IF;
9328: ELSE
9329: -- Bug 5491139 hkaniven start --
9330: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_CURRENCY');
9331: FND_MSG_PUB.ADD;
9332: -- Bug 5491139 hkaniven end --
9333: END IF;
9334: END IF;
9371: END IF;
9372: END IF;
9373: ELSE
9374: -- Bug 5491139 hkaniven start --
9375: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ACCOUNTS_PAY_CCID');
9376: FND_MSG_PUB.ADD;
9377: -- Bug 5491139 hkaniven end --
9378: END IF;
9379: END IF;
9415: END IF;
9416: END IF;
9417: ELSE
9418: -- Bug 5491139 hkaniven start --
9419: FND_MESSAGE.SET_NAME('SQLAP','AP_SUPP_INVALID_CCID');
9420: FND_MSG_PUB.ADD;
9421: -- Bug 5491139 hkaniven end --
9422: END IF;
9423: END IF;
9459: END IF;
9460: END IF;
9461: ELSE
9462: -- Bug 5491139 hkaniven start --
9463: FND_MESSAGE.SET_NAME('SQLAP','AP_SUPP_INVALID_CCID');
9464: FND_MSG_PUB.ADD;
9465: -- Bug 5491139 hkaniven end --
9466: END IF;
9467: END IF;
9504: ||p_vendor_site_rec.duns_number);
9505: END IF;
9506: END IF;
9507: ELSE
9508: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_DUNS_NUMBER');
9509: FND_MSG_PUB.ADD;
9510: END IF;
9511: END IF;
9512: END IF;
9553: ||p_vendor_site_rec.vendor_site_id);
9554: END IF;
9555: END IF;
9556: ELSE
9557: FND_MESSAGE.SET_NAME('SQLAP','AP_CCR_NO_UPDATE');
9558: FND_MSG_PUB.ADD;
9559: END IF;
9560: END IF;
9561:
9604: END IF;
9605: END IF;
9606: ELSE
9607: -- Bug 5491139 hkaniven start --
9608: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYEE');
9609: FND_MSG_PUB.ADD;
9610: -- Bug 5491139 hkaniven end --
9611: END IF;
9612: END IF;
9660: ||p_vendor_site_rec.country);
9661: END IF;
9662: END IF;
9663: ELSE
9664: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_COUNTRY');
9665: FND_MSG_PUB.ADD;
9666: END IF; --import
9667: END IF; --country invalid
9668: END IF;
9704: ||', Vendor_Site_Interface_Id: '||p_vendor_site_rec.vendor_site_interface_id);
9705: END IF;
9706: END IF;
9707: ELSE
9708: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PARTY_SITE');
9709: FND_MSG_PUB.ADD;
9710: END IF;
9711: END IF;
9712: END IF;
9782:
9783: END IF;
9784: ELSE
9785: -- Bug 5584046 --
9786: FND_MESSAGE.SET_NAME('SQLAP','AP_MULTIPLE_ADDRESS');
9787: FND_MSG_PUB.ADD;
9788: END IF; --import
9789: ELSIF x_loc_count = 0 AND
9790: p_vendor_site_rec.party_site_id IS NOT NULL THEN
9812:
9813: END IF;
9814: ELSE
9815: -- Bug 5584046 --
9816: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_ADDRESS');
9817: FND_MSG_PUB.ADD;
9818: END IF; --import
9819: -- Bug 7429668 End
9820: ELSE
9846:
9847: END IF;
9848: ELSE
9849: -- Bug 5584046 --
9850: FND_MESSAGE.SET_NAME('SQLAP','AP_NULL_COUNTRY_NAME');
9851: FND_MSG_PUB.ADD;
9852: END IF; --import
9853: END IF;
9854:
9878:
9879: END IF;
9880: ELSE
9881: -- Bug 5584046
9882: FND_MESSAGE.SET_NAME('SQLAP','AP_NULL_ADDRESS_LINE1');
9883: FND_MSG_PUB.ADD;
9884: END IF; --import
9885: END IF;
9886: --bug 5584046
9963: END IF;
9964: END IF;
9965: ELSE
9966: -- Bug 5491139 hkaniven start --
9967: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PRIM_PAY_SITE');
9968: FND_MSG_PUB.ADD;
9969: -- Bug 5491139 hkaniven end --
9970: END IF;
9971: END IF;
10001: END IF;
10002: END IF;
10003: ELSE
10004: -- Bug 5491139 hkaniven start --
10005: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_COUNTRY_ORIGIN');
10006: FND_MSG_PUB.ADD;
10007: -- Bug 5491139 hkaniven end --
10008: END IF;
10009: END IF;
10048: END IF;
10049: END IF;
10050: ELSE
10051: -- Bug 5491139 hkaniven start --
10052: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PCARD_SITE');
10053: FND_MSG_PUB.ADD;
10054: -- Bug 5491139 hkaniven end --
10055: END IF;
10056: END IF;
10091: END IF;
10092: END IF;
10093: ELSE
10094: -- Bug 5491139 hkaniven start --
10095: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PURCHASING_FLAG');
10096: FND_MSG_PUB.ADD;
10097: -- Bug 5491139 hkaniven end --
10098: END IF;
10099: END IF;
10134: END IF;
10135: END IF;
10136: ELSE
10137: -- Bug 5491139 hkaniven start --
10138: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_RFQ_FLAG');
10139: FND_MSG_PUB.ADD;
10140: -- Bug 5491139 hkaniven end --
10141: END IF;
10142: END IF;
10177: END IF;
10178: END IF;
10179: ELSE
10180: -- Bug 5491139 hkaniven start --
10181: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_SITE_FLAG');
10182: FND_MSG_PUB.ADD;
10183: -- Bug 5491139 hkaniven end --
10184: END IF;
10185: END IF;
10220: END IF;
10221: END IF;
10222: ELSE
10223: -- Bug 5491139 hkaniven start --
10224: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ATTN_AR_FLAG');
10225: FND_MSG_PUB.ADD;
10226: -- Bug 5491139 hkaniven end --
10227: END IF;
10228: END IF;
10263: END IF;
10264: END IF;
10265: ELSE
10266: -- Bug 5491139 hkaniven start --
10267: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PRIM_PAY_SITE');
10268: FND_MSG_PUB.ADD;
10269: -- Bug 5491139 hkaniven end --
10270: END IF;
10271: END IF;
10307: END IF;
10308: END IF;
10309: ELSE
10310: -- Bug 5491139 hkaniven start --
10311: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_FREIGHT_TERMS');
10312: FND_MSG_PUB.ADD;
10313: -- Bug 5491139 hkaniven end --
10314: END IF;
10315: END IF;
10350: END IF;
10351: END IF;
10352: ELSE
10353: -- Bug 5491139 hkaniven start --
10354: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_FOB');
10355: FND_MSG_PUB.ADD;
10356: -- Bug 5491139 hkaniven end --
10357: END IF;
10358: END IF;
10394: END IF;
10395: END IF;
10396: ELSE
10397: -- Bug 5491139 hkaniven start --
10398: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_DATE_BASIS');
10399: FND_MSG_PUB.ADD;
10400: -- Bug 5491139 hkaniven end --
10401: END IF;
10402: END IF;
10438: END IF;
10439: END IF;
10440: ELSE
10441: -- Bug 5491139 hkaniven start --
10442: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAY_GROUP');
10443: FND_MSG_PUB.ADD;
10444: -- Bug 5491139 hkaniven end --
10445: END IF;
10446: END IF;
10481: END IF;
10482: END IF;
10483: ELSE
10484: -- Bug 5491139 hkaniven start --
10485: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TERMS_DATE');
10486: FND_MSG_PUB.ADD;
10487: -- Bug 5491139 hkaniven end --
10488: END IF;
10489: END IF;
10526: END IF;
10527: END IF;
10528: ELSE
10529: -- Bug 5491139 hkaniven start --
10530: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_DEBIT_MEMO');
10531: FND_MSG_PUB.ADD;
10532: -- Bug 5491139 hkaniven end --
10533: END IF;
10534: END IF;
10570: END IF;
10571: END IF;
10572: ELSE
10573: -- Bug 5491139 hkaniven start --
10574: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_EXC_FR_DISC');
10575: FND_MSG_PUB.ADD;
10576: -- Bug 5491139 hkaniven end --
10577: END IF;
10578: END IF;
10614: END IF;
10615: END IF;
10616: ELSE
10617: -- Bug 5491139 hkaniven start --
10618: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_FUT_PAY');
10619: FND_MSG_PUB.ADD;
10620: -- Bug 5491139 hkaniven end --
10621: END IF;
10622: END IF;
10657: END IF;
10658: END IF;
10659: ELSE
10660: -- Bug 5491139 hkaniven start --
10661: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_HOLD_ALL_PAY');
10662: FND_MSG_PUB.ADD;
10663: -- Bug 5491139 hkaniven end --
10664: END IF;
10665: END IF;
10700: END IF;
10701: END IF;
10702: ELSE
10703: -- Bug 5491139 hkaniven start --
10704: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_TAKE_DISC');
10705: FND_MSG_PUB.ADD;
10706: -- Bug 5491139 hkaniven end --
10707: END IF;
10708: END IF;
10744: END IF;
10745: END IF;
10746: ELSE
10747: -- Bug 5491139 hkaniven start --
10748: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_MATCH_OPTION');
10749: FND_MSG_PUB.ADD;
10750: -- Bug 5491139 hkaniven end --
10751: END IF;
10752: END IF;
10789: END IF;
10790: END IF;
10791: ELSE
10792: -- Bug 5491139 hkaniven start --
10793: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ALLOW_AWT');
10794: FND_MSG_PUB.ADD;
10795: -- Bug 5491139 hkaniven end --
10796: END IF;
10797: END IF;
10843: END IF;
10844: END IF;
10845: ELSE
10846: -- Bug 5491139 hkaniven start --
10847: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_AWT_GROUP');
10848: FND_MSG_PUB.ADD;
10849: -- Bug 5491139 hkaniven end --
10850: END IF;
10851: END IF;
10893: END IF;
10894: END IF;
10895: ELSE
10896: -- Bug 5491139 hkaniven start --
10897: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_DIST_SET');
10898: FND_MSG_PUB.ADD;
10899: -- Bug 5491139 hkaniven end --
10900: END IF;
10901: END IF;
10943: END IF;
10944: END IF;
10945: ELSE
10946: -- Bug 5491139 hkaniven start --
10947: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_SHIP_LOC');
10948: FND_MSG_PUB.ADD;
10949: -- Bug 5491139 hkaniven end --
10950: END IF;
10951: END IF;
10993: END IF;
10994: END IF;
10995: ELSE
10996: -- Bug 5491139 hkaniven start --
10997: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_BILL_LOC');
10998: FND_MSG_PUB.ADD;
10999: -- Bug 5491139 hkaniven end --
11000: END IF;
11001: END IF;
11037: END IF;
11038: END IF;
11039: ELSE
11040: -- Bug 5491139 hkaniven start --
11041: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_NOTIF_METHOD');
11042: FND_MSG_PUB.ADD;
11043: -- Bug 5491139 hkaniven end --
11044: END IF;
11045: END IF;
11087: END IF;
11088: END IF;
11089: ELSE
11090: -- Bug 5491139 hkaniven start --
11091: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_TOLERANCE');
11092: FND_MSG_PUB.ADD;
11093: -- Bug 5491139 hkaniven end --
11094: END IF;
11095: END IF;
11137: END IF;
11138: END IF;
11139: ELSE
11140: -- Bug 5491139 hkaniven start --
11141: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSIS_SERVICE_TOL');
11142: FND_MSG_PUB.ADD;
11143: -- Bug 5491139 hkaniven end --
11144: END IF;
11145: END IF;
11179: END IF;
11180: END IF;
11181: ELSE
11182: -- Bug 5491139 hkaniven start --
11183: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_RETAINAGE_RATE');
11184: FND_MSG_PUB.ADD;
11185: -- Bug 5491139 hkaniven end --
11186: END IF;
11187: END IF;
11224: END IF;
11225: END IF;
11226: ELSE
11227: -- Bug 5491139 hkaniven start --
11228: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SHIP_VIA');
11229: FND_MSG_PUB.ADD;
11230: -- Bug 5491139 hkaniven end --
11231: END IF;
11232: END IF;
11276: END IF;
11277: END IF;
11278: ELSE
11279: -- Bug 5491139 hkaniven start --
11280: FND_MESSAGE.SET_NAME('SQLAP','AP_DUPLICATE_TAX_RS');
11281: FND_MSG_PUB.ADD;
11282: -- Bug 5491139 hkaniven end --
11283: END IF;
11284: END IF;
11318: END IF;
11319: END IF;
11320: ELSE
11321: -- Bug 5491139 hkaniven start --
11322: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_SHIPPING_CONTROL');
11323: FND_MSG_PUB.ADD;
11324: -- Bug 5491139 hkaniven end --
11325: END IF;
11326: END IF;
12335: END IF;
12336: END IF;
12337: ELSE
12338: -- Bug 5491139 hkaniven start --
12339: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PARTY_SITE');
12340: FND_MSG_PUB.ADD;
12341: -- Bug 5491139 hkaniven end --
12342: END IF;
12343: ELSE
12408: END IF;
12409: END IF;
12410: ELSE
12411: -- Bug 5491139 hkaniven start --
12412: FND_MESSAGE.SET_NAME('SQLAP','AP_INCONSISTENT_PARTY_SITE');
12413: FND_MSG_PUB.ADD;
12414: -- Bug 5491139 hkaniven end --
12415: END IF;*/
12416: END IF;
12440: END IF;
12441: END IF;
12442: ELSE
12443: -- Bug 5491139 hkaniven start --
12444: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PARTY_SITE');
12445: FND_MSG_PUB.ADD;
12446: -- Bug 5491139 hkaniven end --
12447: END IF;
12448: END IF;
12483: END IF;
12484: END IF;
12485: ELSE
12486: -- Bug 5491139 hkaniven start --
12487: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PARTY_SITE');
12488: FND_MSG_PUB.ADD;
12489: -- Bug 5491139 hkaniven end --
12490: END IF;
12491: ELSE
12532: END IF;
12533: END IF;
12534: ELSE
12535: -- Bug 5491139 hkaniven start --
12536: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_REL_PARTY');
12537: FND_MSG_PUB.ADD;
12538: -- Bug 5491139 hkaniven end --
12539: END IF;
12540: ELSE
12583: END IF;
12584: END IF;
12585: ELSE
12586: -- Bug 5491139 hkaniven start --
12587: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_RELATIONSHIP');
12588: FND_MSG_PUB.ADD;
12589: -- Bug 5491139 hkaniven end --
12590: END IF;
12591: ELSE
12635: END IF;
12636: END IF;
12637: ELSE
12638: -- Bug 5491139 hkaniven start --
12639: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_ORG_CONTACT');
12640: FND_MSG_PUB.ADD;
12641: -- Bug 5491139 hkaniven end --
12642: END IF;
12643: ELSE
13102: END IF;
13103: END IF;
13104:
13105: -- Bug 5491139 hkaniven start --
13106: FND_MESSAGE.SET_NAME('SQLAP','AP_BANK_ACCT_CREATION');
13107: FND_MSG_PUB.ADD;
13108: -- Bug 5491139 hkaniven end --
13109: END IF; -- Bank Account Creation API
13110:
13132: END IF;
13133: END IF;
13134:
13135: -- Bug 5491139 hkaniven start --
13136: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_BANK_ACCT_INFO');
13137: FND_MSG_PUB.ADD;
13138: -- Bug 5491139 hkaniven end --
13139: END IF; -- Bank Account Validation API
13140:
13161: END IF;
13162: END IF;
13163:
13164: -- Bug 5491139 hkaniven start --
13165: FND_MESSAGE.SET_NAME('SQLAP','AP_PAYEE_CREATION');
13166: FND_MSG_PUB.ADD;
13167: -- Bug 5491139 hkaniven end --
13168: END IF; -- Payee Creation API
13169:
13187: END IF;
13188: END IF;
13189:
13190: -- Bug 5491139 hkaniven start --
13191: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYEE');
13192: FND_MSG_PUB.ADD;
13193: -- Bug 5491139 hkaniven end --
13194: END IF; -- Payee Validation API
13195:
13732: END IF;
13733: END IF;
13734:
13735: -- Bug 5491139 hkaniven start --
13736: FND_MESSAGE.SET_NAME('SQLAP','AP_BANK_ACCT_CREATION');
13737: FND_MSG_PUB.ADD;
13738: -- Bug 5491139 hkaniven end --
13739: END IF; -- Bank Account Creation API
13740:
13762: END IF;
13763: END IF;
13764:
13765: -- Bug 5491139 hkaniven start --
13766: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_BANK_ACCT_INFO');
13767: FND_MSG_PUB.ADD;
13768: -- Bug 5491139 hkaniven end --
13769: END IF; -- Bank Account Validation API
13770:
13791: END IF;
13792: END IF;
13793:
13794: -- Bug 5491139 hkaniven start --
13795: FND_MESSAGE.SET_NAME('SQLAP','AP_PAYEE_CREATION');
13796: FND_MSG_PUB.ADD;
13797: -- Bug 5491139 hkaniven end --
13798: END IF; -- Payee Creation API
13799:
13817: END IF;
13818: END IF;
13819:
13820: -- Bug 5491139 hkaniven start --
13821: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_PAYEE_INFO');
13822: FND_MSG_PUB.ADD;
13823: -- Bug 5491139 hkaniven end --
13824: END IF; -- Payee Validation API
13825: