[Home] [Help]
12:
13: BEGIN
14:
15: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.existing_org_context';
16: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
17:
18: -- Retrieve CLIENT_INFO org_id value in the performant method recommended by ATG
19: SELECT DECODE(
20: SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
23: INTO l_ret_value
24: FROM dual;
25:
26: return l_ret_value;
27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
28: EXCEPTION
29: WHEN OTHERS THEN
30: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
31: END existing_org_context;
26: return l_ret_value;
27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
28: EXCEPTION
29: WHEN OTHERS THEN
30: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
31: END existing_org_context;
32:
33: PROCEDURE insert_for_report
34: (
43: IS
44: l_module_name VARCHAR2(60);
45: BEGIN
46: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.insert_for_report';
47: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
48:
49: INSERT INTO fv_ccr_process_report
50: (duns_info,record_type,reference1,reference2,reference3,reference4,reference5)
51: VALUES
51: VALUES
52: (p_duns,p_record_type,p_reference1,p_reference2,p_reference3,p_reference4,
53: p_reference5);
54:
55: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
56: EXCEPTION
57: WHEN OTHERS THEN
58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
59: END;
54:
55: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
56: EXCEPTION
57: WHEN OTHERS THEN
58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
59: END;
60:
61:
62: /* Procedure to add supplier party id as owner party id to the bank account created */
149: l_vendor_name VARCHAR2(120);
150: l_module_name VARCHAR2(60);
151: BEGIN
152: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_name';
153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
154:
155: --SELECT vendor_name,num_1099 INTO x_vendor_name,x_num_1099
156: --FROM po_vendors WHERE vendor_id = p_vendor_id;
157:
161: FROM hz_parties hzp, ap_suppliers pav
162: WHERE hzp.party_id = pav.party_id
163: AND pav.vendor_id = p_vendor_id;
164:
165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
166: EXCEPTION
167: WHEN OTHERS THEN
168: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
169: x_vendor_name := null;
164:
165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
166: EXCEPTION
167: WHEN OTHERS THEN
168: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
169: x_vendor_name := null;
170: x_num_1099 := null;
171: END ;
172:
239: END IF;
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
244:
245: END;
246:
247:
260: FROM ap_supplier_sites_all
261: WHERE vendor_site_id = p_vendor_site_id;
262: EXCEPTION
263: WHEN OTHERS THEN
264: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
265: END;
266:
267: PROCEDURE get_vendor_id
268: (
303:
304: BEGIN
305:
306: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
307: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_legal_bus_name: '||p_legal_bus_name);
305:
306: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
307: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_legal_bus_name: '||p_legal_bus_name);
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_fed_check_flag: '||p_fed_check_flag);
313:
306: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
307: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_legal_bus_name: '||p_legal_bus_name);
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_fed_check_flag: '||p_fed_check_flag);
313:
314: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
307: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_legal_bus_name: '||p_legal_bus_name);
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_fed_check_flag: '||p_fed_check_flag);
313:
314: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
315: OPEN vendor_taxp_csr(p_taxpayer_number);
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_legal_bus_name: '||p_legal_bus_name);
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_fed_check_flag: '||p_fed_check_flag);
313:
314: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
315: OPEN vendor_taxp_csr(p_taxpayer_number);
316:
354: END IF;
355: END IF;
356: CLOSE vendor_lbn_csr;
357:
358: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: fv_utility.log_mesg(' Exception in get_vendor_id.');
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: fv_utility.log_mesg(' Exception in get_vendor_id.');
363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
364: x_vendor_id := null;
365: x_vendor_name := null;
366: END;
367:
385: AND branch_number IS NOT NULL;
386: BEGIN
387:
388: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_branch_information';
389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
390:
391: IF(nvl(p_bank_branch_id,0)<>0) THEN
392: BEGIN
393: SELECT bank_name,bank_branch_name,branch_number
395: l_routing_num FROM ce_bank_branches_v
396: WHERE branch_party_id = p_bank_branch_id;
397: EXCEPTION
398: WHEN OTHERS THEN
399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
400: 'Bank Branch exception for'|| p_bank_branch_id);
401: l_bank_name := null;
402: l_bank_branch_name := null;
403: l_routing_num := null;
420: END IF;
421: CLOSE bank_branch_csr;
422: EXCEPTION
423: WHEN OTHERS THEN
424: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
425: x_bank_branch_id := null;
426: x_bank_name := null;
427: x_bank_branch_name := null;
428: CLOSE bank_branch_csr;
431: x_bank_branch_id := null;
432: x_bank_name := null;
433: x_bank_branch_name := null;
434: END IF;
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
436: END;
437:
438: PROCEDURE get_bank_account_information
439: (
464: l_module_name VARCHAR2(60);
465: BEGIN
466: x_update_account:='N';
467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
465: BEGIN
466: x_update_account:='N';
467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_account_type->'||p_account_type);
466: x_update_account:='N';
467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_account_type->'||p_account_type);
474: BEGIN
467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_account_type->'||p_account_type);
474: BEGIN
475:
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_account_type->'||p_account_type);
474: BEGIN
475:
476: IF(nvl(p_bank_account_id,0)<>0) THEN
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);
472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_id->'||p_bank_account_id);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_account_type->'||p_account_type);
474: BEGIN
475:
476: IF(nvl(p_bank_account_id,0)<>0) THEN
477: --Bug8405987
490: l_bank_branch_id := null;
491: l_bank_acct_num:= null;
492: END;
493:
494: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_branch_id->'||l_bank_branch_id);
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_acct_num->'||l_bank_acct_num);
496: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_account_type->'||l_bank_account_type);
497:
498: --Bug 9112680 added space in nvl(if condition) and debug messages
491: l_bank_acct_num:= null;
492: END;
493:
494: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_branch_id->'||l_bank_branch_id);
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_acct_num->'||l_bank_acct_num);
496: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_account_type->'||l_bank_account_type);
497:
498: --Bug 9112680 added space in nvl(if condition) and debug messages
499: IF(l_bank_branch_id IS NOT NULL AND l_bank_acct_num IS NOT NULL
492: END;
493:
494: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_branch_id->'||l_bank_branch_id);
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_acct_num->'||l_bank_acct_num);
496: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bank_account_type->'||l_bank_account_type);
497:
498: --Bug 9112680 added space in nvl(if condition) and debug messages
499: IF(l_bank_branch_id IS NOT NULL AND l_bank_acct_num IS NOT NULL
500: AND l_bank_branch_id = p_bank_branch_id AND l_bank_acct_num=p_bank_account_number) THEN
514: ELSE
515: x_bank_account_id := null;
516: END IF;
517:
518: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_bank_account_id->'||x_bank_account_id);
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_update_account->'||x_update_account);
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
521: EXCEPTION
522: WHEN OTHERS THEN
515: x_bank_account_id := null;
516: END IF;
517:
518: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_bank_account_id->'||x_bank_account_id);
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_update_account->'||x_update_account);
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
521: EXCEPTION
522: WHEN OTHERS THEN
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
516: END IF;
517:
518: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_bank_account_id->'||x_bank_account_id);
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_update_account->'||x_update_account);
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
521: EXCEPTION
522: WHEN OTHERS THEN
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
524: x_bank_account_id := null;
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'x_update_account->'||x_update_account);
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
521: EXCEPTION
522: WHEN OTHERS THEN
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
524: x_bank_account_id := null;
525: END;
526:
527:
546: l_vendor_name VARCHAR2(120);
547: l_supp_num_exist VARCHAR2(1);
548: BEGIN
549: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_federal_indicator';
550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
551:
552: l_init_msg_list := fnd_api.g_true;
553:
554:
575: x_error_code => l_error_code
576: );
577: if(nvl(l_return_status,'E')<>FND_API.G_RET_STS_SUCCESS) THEN
578: if(l_msg_count=1) THEN
579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,
580: 'Get Federal Indicator:' || l_msg_data);
581: else
582: for I IN 0 .. l_msg_count
583: loop
581: else
582: for I IN 0 .. l_msg_count
583: loop
584: l_msg_data := fnd_msg_pub.get(p_encoded=>'F');
585: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,
586: 'Get Federal Indicator:' || l_msg_data);
587: end loop;
588: end if;
589: x_federal:= 'N';
591: end if;
592: ELSE
593: x_federal := 'N';
594: END IF;
595: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
596: EXCEPTION
597: WHEN OTHERS THEN
598: x_federal:= 'N';
599: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,l_module_name,'Get Federal Indicator:'
595: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
596: EXCEPTION
597: WHEN OTHERS THEN
598: x_federal:= 'N';
599: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,l_module_name,'Get Federal Indicator:'
600: || ' Exception');
601: END;
602:
603: /* Procedure used to create or update vendor
761:
762: BEGIN
763:
764: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
762: BEGIN
763:
764: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
763:
764: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
768:
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_id: '||p_ccr_id);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
770: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_ccr_id: '||p_prev_ccr_id);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_type: '|| p_update_type);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
772: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_id: '||p_bank_branch_id);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_vendor_id: '||p_vendor_id);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_pay_site_id: '||p_pay_site_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
775: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_add_site_id: '||p_main_add_site_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
776: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_enabled_flag: '||p_enabled_flag);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_main_address_flag: '||p_main_address_flag);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_taxpayer_number: '||p_taxpayer_number);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_legal_bus_name: '||p_legal_bus_name);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_duns: '||p_duns);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_plus4: '||p_plus4);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_old_bank_account_id: '||p_old_bank_account_id);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_new_bank_account_id: '||p_new_bank_account_id);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_name: '||p_bank_name);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_branch_name: '||p_bank_branch_name);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_num: '||p_bank_num);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_account_num: '||p_bank_account_num);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_org_id: '||p_org_id);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
789: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_update_vendor_flag: '||p_update_vendor_flag);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_ccr_status: '||p_ccr_status);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_insert_vendor_flag: '||p_insert_vendor_flag);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_prev_vendor_id: '||p_prev_vendor_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_file_date: '||p_file_date);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_bank_conc_req_status: '||p_bank_conc_req_status);
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_header_conc_req_status: '||p_header_conc_req_status);
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
803:
796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_assgn_conc_req_status: '||p_assgn_conc_req_status);
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
803:
804:
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_base_currency: '||p_base_currency);
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
803:
804:
805: l_legal_bus_name := p_legal_bus_name;
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_valid_bank_info: '||p_valid_bank_info);
799: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_federal_vendor: '||p_federal_vendor);
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_branch_id: '||p_created_bank_branch_id);
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'p_created_bank_account_id: '||p_created_bank_account_id);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
803:
804:
805: l_legal_bus_name := p_legal_bus_name;
806: -- Bug 6238816. If a vendor with the same name exists,
917: insert_for_report(l_duns_for_report,14,null,p_bank_branch_name,
918: p_bank_num,null,null);
919: END IF;
920:
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
922: 'Updating fv_ccr_vendors with bank_branch_id: '||l_bank_branch_id);
923:
924: UPDATE fv_ccr_vendors
925: SET bank_branch_id = l_bank_branch_id
952: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
953: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
954: l_msg_text := FND_MESSAGE.GET;
955: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
956: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
957: l_vendor_id := p_vendor_id;
958: ELSE
959: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
960: IF(nvl(l_pay_site_id,0)=0 AND
961: l_num_1099 <> p_taxpayer_number) THEN
962: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
963: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
964: l_msg_text := FND_MESSAGE.GET;
965: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
966: l_module_name,l_msg_text);
967: insert_for_report(p_duns,16,l_msg_text,null,
968: null,null,null);
969: ELSIF(l_num_1099 <> p_taxpayer_number) THEN
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317
996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
997: -- l_msg_text := FND_MESSAGE.GET;
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
999: l_module_name,l_msg_text);
1000: insert_for_report(p_duns,16,l_msg_text,null,
1001: null,null,null);
1002: x_vendor_name := l_vendor_name;
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;
1017:
1018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1019: l_module_name,l_msg_text);
1020: insert_for_report(p_duns,16,l_msg_text,null,
1021: null,null,null);
1022: x_vendor_name := l_vendor_name;
1057: END IF;
1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
1059: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
1060: l_msg_text := FND_MESSAGE.GET;
1061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1062: l_module_name,l_msg_text||'Error Code:' ||
1063: SQLCODE ||' Error Text:' || SQLERRM);
1064: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null
1065: ,null,null);
1084: WHERE DUNS=p_duns;
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: l_header_conc_req_status := 'E';
1088: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
1089: END;
1090:
1091:
1092: ELSE
1101: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1102: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1103: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1104: l_msg_text := FND_MESSAGE.GET;
1105: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1106: l_module_name,l_msg_text);
1107: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);
1108: ELSE
1109: --get_vendor_id(p_taxpayer_number,p_legal_bus_name,p_duns,'N',
1120: AND l_supp_num_exist = 'Y') THEN
1121: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1122: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1123: l_msg_text:= FND_MESSAGE.GET;
1124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1125: l_module_name,l_msg_text);
1126: insert_for_report(p_duns,18,l_msg_text,null,
1127: null,null,null);
1128: l_supplier_number := null;
1132: IF(p_taxpayer_number IS NOT NULL) THEN
1133: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1134: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1135: l_msg_text := FND_MESSAGE.GET;
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1137: ,l_module_name,l_msg_text);
1138: insert_for_report(p_duns,16,l_msg_text,null,null
1139: ,null,null);
1140: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1194: l_msg_text := FND_MESSAGE.GET ;
1195: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1196: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1197: || SQLERRM);
1198: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1199: if(l_new_bank_account_id IS NOT NULL AND
1227:
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: l_header_conc_req_status := 'E';
1231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
1232: END;
1233: END IF;
1234:
1235: END IF;
1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1289: l_msg_text := FND_MESSAGE.GET;
1290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1291: ,l_module_name,l_msg_text);
1292: insert_for_report(p_duns,16,l_msg_text,null,null
1293: ,null,null);
1294: ELSE
1402: IF(nvl(l_main_add_site_id,0) = 0) THEN
1403: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1404: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1405: l_msg_text := FND_MESSAGE.GET;
1406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1407: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1408: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1409: ELSE
1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1411: get_vendor_site_code(p_main_add_site_id,l_site_code);
1412: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1413: l_msg_text := FND_MESSAGE.GET;
1414: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1415: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1416: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1417: END IF;
1418:
1441: /* Code for bug 9320586 Starting ********** */
1442: /*Validating Address of Supplier site
1443: */
1444: BEGIN
1445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Before address comparision: whether new and old site address same or not -> ');
1446: IF(NVL(l_vendor_id,0) <> 0 AND NVL(p_pay_site_id,0) <> 0) THEN
1447: SELECT COUNT(*)
1448: INTO l_supplier_sites_count
1449: FROM ap_supplier_sites_all
1449: FROM ap_supplier_sites_all
1450: WHERE vendor_id=l_vendor_id
1451: AND org_id =p_org_id;
1452:
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_sites_count-> '||l_supplier_sites_count);
1454: IF (l_supplier_sites_count >1) THEN
1455: FOR esa_rec IN existing_site_address(l_vendor_id,p_duns,p_org_id)
1456: LOOP
1457: l_ss_address_line1 :=esa_rec.address_line1;
1463: l_ss_address_zip :=esa_rec.zip;
1464: l_ss_address_country :=esa_rec.country;
1465: l_ss_vendor_site_id :=esa_rec.vendor_site_id;
1466: END LOOP;
1467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_vendor_site_id-> '||l_ss_vendor_site_id);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1464: l_ss_address_country :=esa_rec.country;
1465: l_ss_vendor_site_id :=esa_rec.vendor_site_id;
1466: END LOOP;
1467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_vendor_site_id-> '||l_ss_vendor_site_id);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1465: l_ss_vendor_site_id :=esa_rec.vendor_site_id;
1466: END LOOP;
1467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_vendor_site_id-> '||l_ss_vendor_site_id);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1466: END LOOP;
1467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_vendor_site_id-> '||l_ss_vendor_site_id);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_vendor_site_id-> '||l_ss_vendor_site_id);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line1-> '||l_ss_address_line1);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line2-> '||l_ss_address_line2);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_line3-> '||l_ss_address_line3);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_city-> '||l_ss_address_city);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_state-> '||l_ss_address_state);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_country-> '||p_pay_address_country);
1473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_country-> '||l_ss_address_country);
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_country-> '||p_pay_address_country);
1481: IF (l_ss_address_line1 <> p_pay_address_line1 OR l_ss_address_city <> p_pay_address_city
1474: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ss_address_zip-> '||l_ss_address_zip);
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_country-> '||p_pay_address_country);
1481: IF (l_ss_address_line1 <> p_pay_address_line1 OR l_ss_address_city <> p_pay_address_city
1482: OR l_ss_address_state <>p_pay_address_state OR l_ss_address_zip <> p_pay_address_zip
1475: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line1-> '||p_pay_address_line1);
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_country-> '||p_pay_address_country);
1481: IF (l_ss_address_line1 <> p_pay_address_line1 OR l_ss_address_city <> p_pay_address_city
1482: OR l_ss_address_state <>p_pay_address_state OR l_ss_address_zip <> p_pay_address_zip
1483: OR l_ss_address_country <> p_pay_address_country) THEN
1476: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_line2-> '||p_pay_address_line2);
1477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_city-> '||p_pay_address_city);
1478: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_state-> '||p_pay_address_state);
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_zip-> '||p_pay_address_zip);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_pay_address_country-> '||p_pay_address_country);
1481: IF (l_ss_address_line1 <> p_pay_address_line1 OR l_ss_address_city <> p_pay_address_city
1482: OR l_ss_address_state <>p_pay_address_state OR l_ss_address_zip <> p_pay_address_zip
1483: OR l_ss_address_country <> p_pay_address_country) THEN
1484: l_change_pay_site_flg:='Y';
1481: IF (l_ss_address_line1 <> p_pay_address_line1 OR l_ss_address_city <> p_pay_address_city
1482: OR l_ss_address_state <>p_pay_address_state OR l_ss_address_zip <> p_pay_address_zip
1483: OR l_ss_address_country <> p_pay_address_country) THEN
1484: l_change_pay_site_flg:='Y';
1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_change_pay_site_flg-> '||l_change_pay_site_flg);
1486:
1487: /*Inactivating the external payee account created using this old supplier site*/
1488: Begin
1489:
1492: where supplier_site_id=l_ss_vendor_site_id
1493: AND org_id = p_org_id;
1494: exception
1495: when others then
1496: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text|| ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1497: end;
1498:
1499:
1500: Begin
1506: and org_id = p_org_id);
1507:
1508: exception
1509: when others then
1510: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text|| ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1511: end;
1512:
1513: UPDATE ap_supplier_sites_all
1514: SET inactive_date = sysdate,
1520: END IF;
1521: END IF;
1522: EXCEPTION
1523: WHEN OTHERS THEN
1524: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text|| ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1525: END;
1526: -- Commented for testing Address update bug
1527: IF(((l_change_pay_site_flg='Y') OR (NVL(p_pay_site_id,0) = 0)) AND NVL(l_vendor_id,0) <> 0) THEN
1528:
1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1540: l_msg_text := FND_MESSAGE.GET;
1541: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1542: ,l_module_name,l_msg_text);
1543: insert_for_report(p_duns,16,l_msg_text,null,null
1544: ,null,null);
1545: l_account_uses_insert_flag := 'N';
1606: END IF;
1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1608: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1609: l_msg_text := FND_MESSAGE.GET;
1610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1611: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1612: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1613: l_account_uses_insert_flag := 'N';
1614: l_account_uses_upd_flag := 'N';
1685: get_vendor_site_code(p_pay_site_id,l_site_code);
1686: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1687: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1688: l_msg_text := FND_MESSAGE.GET;
1689: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1690: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1691: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1692:
1693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: l_assgn_conc_req_status := 'E';
1735: FND_CLIENT_INFO.set_org_context(l_old_org_id);
1736: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1737: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1738: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1739: THEN
1740: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1774: p_vendor_site_id =>l_pay_site_id,
1775: p_party_Site_Id => null,
1776: p_org_id => p_org_id);
1777:
1778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_affected_inv_cnt: '||l_affected_inv_cnt);
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1775: p_party_Site_Id => null,
1776: p_org_id => p_org_id);
1777:
1778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_affected_inv_cnt: '||l_affected_inv_cnt);
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_org_id: '||p_org_id);
1776: p_org_id => p_org_id);
1777:
1778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_affected_inv_cnt: '||l_affected_inv_cnt);
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_org_id: '||p_org_id);
1784:
1777:
1778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_affected_inv_cnt: '||l_affected_inv_cnt);
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_org_id: '||p_org_id);
1784:
1785: if l_affected_inv_cnt > 0 then
1778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_affected_inv_cnt: '||l_affected_inv_cnt);
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_org_id: '||p_org_id);
1784:
1785: if l_affected_inv_cnt > 0 then
1786: --Bug14373735
1779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_old_bank_account_id: '||p_old_bank_account_id);
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_new_bank_account_id: '||l_new_bank_account_id);
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_vendor_id: '||l_vendor_id);
1782: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_vendor_site_id: '||l_pay_site_id);
1783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_org_id: '||p_org_id);
1784:
1785: if l_affected_inv_cnt > 0 then
1786: --Bug14373735
1787: SELECT party_id
1858: get_vendor_site_code(p_pay_site_id,l_site_code);
1859: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1860: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1861: l_msg_text := FND_MESSAGE.GET;
1862: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1863: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1864: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1865: END;
1866: END IF;
1918: get_vendor_site_code(p_main_add_site_id,l_site_code);
1919: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1920: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1921: l_msg_text := FND_MESSAGE.GET;
1922: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1923: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1924: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1925: END;
1926: END IF;
2032: end if;
2033:
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
2037: END delete_plusfour_assignments;
2038:
2039:
2040: FUNCTION get_org_paysite_id(p_ccrid NUMBER, p_org_id NUMBER)
2132: EXCEPTION
2133: WHEN NO_DATA_FOUND THEN
2134: RETURN p_lookup_code;
2135: WHEN OTHERS THEN
2136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2137: 'fv_ccr_util_pvt.get_lookup_desc',SQLERRM);
2138: RETURN p_lookup_code;
2139:
2140: END get_lookup_desc;
3089: --Bug9142398
3090: --l_assignment.end_date := p_file_date;
3091: l_assignment.end_date:= sysdate-1;
3092:
3093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
3094: 'Calling set payee instr assignment');
3095:
3096: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
3097: p_api_version => l_api_version,
3113: IF(nvl(p_old_bank_account_id,0)=0 AND nvl(p_vendor_id,0)<>0
3114: AND nvl(p_pay_site_id,0)<>0 AND
3115: (p_valid_bank_info='Y' OR p_federal_vendor='N')) THEN
3116:
3117: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
3118: 'Updating iby_pmt_instr_uses_all with end date');
3119:
3120: UPDATE iby_pmt_instr_uses_all
3121: SET END_DATE = sysdate-1,
3221:
3222: l_module_name varchar2(60);
3223: begin
3224: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.check_taxpayerid_diff';
3225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3226:
3227: begin
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;
3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;
3227: begin
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;
3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;
3230:
3231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ccr_tin: '||l_ccr_tin);
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_tin: '||l_supplier_tin);
3233:
3234: if (l_supplier_tin is null or l_ccr_tin is null)then
3235: l_different_tin := 'N';
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;
3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;
3230:
3231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ccr_tin: '||l_ccr_tin);
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_tin: '||l_supplier_tin);
3233:
3234: if (l_supplier_tin is null or l_ccr_tin is null)then
3235: l_different_tin := 'N';
3236: elsif l_supplier_tin <> l_ccr_tin then
3237: l_different_tin := 'Y';
3238: end if;
3239: exception when others then
3240: null;
3241: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
3242: end;
3243:
3244: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning -> l_diffferent_tin: '||l_different_tin);
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3240: null;
3241: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
3242: end;
3243:
3244: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning -> l_diffferent_tin: '||l_different_tin);
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3246:
3247: return l_different_tin;
3248: end check_taxpayerid_diff;
3241: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
3242: end;
3243:
3244: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning -> l_diffferent_tin: '||l_different_tin);
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3246:
3247: return l_different_tin;
3248: end check_taxpayerid_diff;
3249:
3253: l_module_name VARCHAR2(60);
3254:
3255: begin
3256: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ext_cert_val';
3257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3258:
3259: if (p_code = 'DFD') then
3260: begin
3261: select meaning into l_ext_cert_val
3284: end;
3285:
3286: end if;
3287:
3288: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning meaning :'||l_ext_cert_val);
3289: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3290: return l_ext_cert_val;
3291:
3292: EXCEPTION
3285:
3286: end if;
3287:
3288: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning meaning :'||l_ext_cert_val);
3289: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3290: return l_ext_cert_val;
3291:
3292: EXCEPTION
3293: WHEN OTHERS THEN
3290: return l_ext_cert_val;
3291:
3292: EXCEPTION
3293: WHEN OTHERS THEN
3294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3295: return null;
3296: END get_ext_cert_val;
3297:
3298:
3304: l_flagval varchar2(60);
3305:
3306: begin
3307: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_flag_code';
3308: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3309: select flagtype, flagval into l_flagtype, l_flagval
3310: from fv_ccr_flags where duns = p_duns and rownum<=1;
3311:
3312: if(l_flagtype = 'NPD' AND l_flagval = 'Y') then
3333:
3334:
3335: END IF;
3336:
3337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3338: return l_flag_code;
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3338: return l_flag_code;
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3342: return l_flag_code;
3343: end get_ccr_flag_code;
3344:
3345:
3359:
3360: begin
3361: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_numerics';
3362:
3363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code: '||p_code);
3366:
3367: if(p_code in ('LSE', 'LSR')) then
3360: begin
3361: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_numerics';
3362:
3363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code: '||p_code);
3366:
3367: if(p_code in ('LSE', 'LSR')) then
3368: begin
3361: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_numerics';
3362:
3363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code: '||p_code);
3366:
3367: if(p_code in ('LSE', 'LSR')) then
3368: begin
3369: select substr(code, (instr(code, '^', 1,1) + 1), ((instr(code, '^', 1,2)- instr(code, '^', 1,1))-1) ) ,
3376: end;
3377: end if;
3378:
3379:
3380: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_lse: '||l_lse);
3381: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_lsr: '||l_lsr);
3382:
3383: if (p_code in ('CBLC', 'CBLA', 'SBLC', 'SBLA')) then
3384: begin
3377: end if;
3378:
3379:
3380: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_lse: '||l_lse);
3381: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_lsr: '||l_lsr);
3382:
3383: if (p_code in ('CBLC', 'CBLA', 'SBLC', 'SBLA')) then
3384: begin
3385: select substr(code, (instr(code, '^', 1,1) + 1), ((instr(code, '^', 1,2)- instr(code, '^', 1,1))-1) ) ,
3393: null;
3394: end;
3395: end if;
3396:
3397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cblc: '||l_cblc);
3398: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cbla: '||l_cbla);
3399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sblc: '||l_sblc);
3400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sbla: '||l_sbla);
3401:
3394: end;
3395: end if;
3396:
3397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cblc: '||l_cblc);
3398: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cbla: '||l_cbla);
3399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sblc: '||l_sblc);
3400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sbla: '||l_sbla);
3401:
3402: if(p_code = 'BK') then
3395: end if;
3396:
3397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cblc: '||l_cblc);
3398: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cbla: '||l_cbla);
3399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sblc: '||l_sblc);
3400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sbla: '||l_sbla);
3401:
3402: if(p_code = 'BK') then
3403: begin
3396:
3397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cblc: '||l_cblc);
3398: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_cbla: '||l_cbla);
3399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sblc: '||l_sblc);
3400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_sbla: '||l_sbla);
3401:
3402: if(p_code = 'BK') then
3403: begin
3404: select substr(code, (instr(code, '^', 1,1) + 1), ((instr(code, '^', 1,2)- instr(code, '^', 1,1))-1) )
3409: null;
3410: end;
3411: end if;
3412:
3413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_bk: '||l_bk);
3414: if(p_code = 'PG') then
3415: begin
3416: select substr(code, (instr(code, '^', 1,1) + 1), ((instr(code, '^', 1,2)- instr(code, '^', 1,1))-1) )
3417: into l_pg
3421: null;
3422: end;
3423: end if;
3424:
3425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_pg: '||l_pg);
3426:
3427: if(p_code = 'PT') then
3428: begin
3429: select substr(code, (instr(code, '^', 1,1) + 1), ((instr(code, '^', 1,2)- instr(code, '^', 1,1))-1) )
3434: null;
3435: end;
3436: end if;
3437:
3438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_pt: '||l_pt);
3439:
3440: l_numerics_code := case p_code
3441: when 'LSE' then l_lse
3442: when 'LSR' then l_lsr
3448: when 'PG' then l_pg
3449: when 'PT' then l_pt
3450: end;
3451:
3452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_numerics_code: '||l_numerics_code);
3453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3454: return l_numerics_code;
3455:
3456: EXCEPTION
3449: when 'PT' then l_pt
3450: end;
3451:
3452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_numerics_code: '||l_numerics_code);
3453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3454: return l_numerics_code;
3455:
3456: EXCEPTION
3457: WHEN OTHERS THEN
3454: return l_numerics_code;
3455:
3456: EXCEPTION
3457: WHEN OTHERS THEN
3458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3459: return l_numerics_code;
3460: end get_ccr_numerics;
3461:
3462: FUNCTION get_disaster_code(p_duns varchar2, p_code varchar2) return varchar2
3465: l_module_name VARCHAR2(60);
3466:
3467: begin
3468: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_disaster_code';
3469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns : '||p_duns);
3470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code : '||p_code);
3471:
3472: if (substr(p_code, 1, 3) = 'STA') then
3473: begin
3466:
3467: begin
3468: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_disaster_code';
3469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns : '||p_duns);
3470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code : '||p_code);
3471:
3472: if (substr(p_code, 1, 3) = 'STA') then
3473: begin
3474: select lpad('State :', 33)||substr(p_code,4)||' - '||meaning
3526:
3527:
3528: end if;
3529:
3530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning l_dis_code_val :'||l_dis_code_val);
3531: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3532: return l_dis_code_val;
3533:
3534: EXCEPTION
3527:
3528: end if;
3529:
3530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Returning l_dis_code_val :'||l_dis_code_val);
3531: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3532: return l_dis_code_val;
3533:
3534: EXCEPTION
3535: WHEN OTHERS THEN
3532: return l_dis_code_val;
3533:
3534: EXCEPTION
3535: WHEN OTHERS THEN
3536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3537: return l_dis_code_val;
3538: END get_disaster_code;
3539:
3540: function get_supplier_debarred ( p_supplier_id in number,
3548: l_debar_code fv_ccr_class_codes.code%type;
3549:
3550: begin
3551: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_supplier_debarred';
3552: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3553:
3554: select fcc.code into l_debar_code
3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco
3556: where fcv.duns = fcc.duns(+)
3564: return false;
3565:
3566: END IF;
3567:
3568: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3569:
3570: EXCEPTION
3571: WHEN OTHERS THEN
3572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3568: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
3569:
3570: EXCEPTION
3571: WHEN OTHERS THEN
3572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3573: return false;
3574: end get_supplier_debarred;
3575:
3576: END FV_CCR_UTIL_PVT;