DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on FV_UTILITY

Line 13: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

9: l_module_name VARCHAR2(60);
10: BEGIN
11:
12: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.existing_org_context';
13: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
14:
15: -- Retrieve CLIENT_INFO org_id value in the performant method recommended by ATG
16: SELECT DECODE(
17: SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 24: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

20: INTO l_ret_value
21: FROM dual;
22:
23: return l_ret_value;
24: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
25: EXCEPTION
26: WHEN OTHERS THEN
27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
28: END existing_org_context;

Line 27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

23: return l_ret_value;
24: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
25: EXCEPTION
26: WHEN OTHERS THEN
27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
28: END existing_org_context;
29:
30: PROCEDURE insert_for_report
31: (

Line 44: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

40: IS
41: l_module_name VARCHAR2(60);
42: BEGIN
43: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.insert_for_report';
44: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
45:
46: INSERT INTO fv_ccr_process_report
47: (duns_info,record_type,reference1,reference2,reference3,reference4,reference5)
48: VALUES

Line 52: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

48: VALUES
49: (p_duns,p_record_type,p_reference1,p_reference2,p_reference3,p_reference4,
50: p_reference5);
51:
52: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
53: EXCEPTION
54: WHEN OTHERS THEN
55: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
56: END;

Line 55: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

51:
52: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
53: EXCEPTION
54: WHEN OTHERS THEN
55: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
56: END;
57:
58:
59: /* Procedure to add supplier party id as owner party id to the bank account created */

Line 150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

146: l_vendor_name VARCHAR2(120);
147: l_module_name VARCHAR2(60);
148: BEGIN
149: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_name';
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
151:
152: --SELECT vendor_name,num_1099 INTO x_vendor_name,x_num_1099
153: --FROM po_vendors WHERE vendor_id = p_vendor_id;
154:

Line 162: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

158: FROM hz_parties hzp, ap_suppliers pav
159: WHERE hzp.party_id = pav.party_id
160: AND pav.vendor_id = p_vendor_id;
161:
162: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
163: EXCEPTION
164: WHEN OTHERS THEN
165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
166: x_vendor_name := null;

Line 165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

161:
162: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
163: EXCEPTION
164: WHEN OTHERS THEN
165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
166: x_vendor_name := null;
167: x_num_1099 := null;
168: END ;
169:

Line 240: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);

236: END IF;
237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
241:
242: END;
243:
244:

Line 261: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);

257: FROM ap_supplier_sites_all
258: WHERE vendor_site_id = p_vendor_site_id;
259: EXCEPTION
260: WHEN OTHERS THEN
261: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
262: END;
263:
264: PROCEDURE get_vendor_id
265: (

Line 304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

300:
301: BEGIN
302:
303: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);
308: fv_utility.log_mesg('p_duns: '||p_duns);

Line 306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);

302:
303: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);
308: fv_utility.log_mesg('p_duns: '||p_duns);
309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);
310:

Line 307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);

303: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);
308: fv_utility.log_mesg('p_duns: '||p_duns);
309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);
310:
311: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN

Line 308: fv_utility.log_mesg('p_duns: '||p_duns);

304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);
308: fv_utility.log_mesg('p_duns: '||p_duns);
309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);
310:
311: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
312: OPEN vendor_taxp_csr(p_taxpayer_number);

Line 309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);

305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);
308: fv_utility.log_mesg('p_duns: '||p_duns);
309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);
310:
311: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
312: OPEN vendor_taxp_csr(p_taxpayer_number);
313: fv_utility.log_mesg('Here1');

Line 313: fv_utility.log_mesg('Here1');

309: fv_utility.log_mesg('p_fed_check_flag: '||p_fed_check_flag);
310:
311: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
312: OPEN vendor_taxp_csr(p_taxpayer_number);
313: fv_utility.log_mesg('Here1');
314: FETCH vendor_taxp_csr INTO x_vendor_id,x_vendor_name;
315: fv_utility.log_mesg('Here2');
316: IF(vendor_taxp_csr%NOTFOUND) THEN
317: x_vendor_id := null;

Line 315: fv_utility.log_mesg('Here2');

311: IF(p_taxpayer_number IS NOT NULL AND length(p_taxpayer_number) = 9) THEN
312: OPEN vendor_taxp_csr(p_taxpayer_number);
313: fv_utility.log_mesg('Here1');
314: FETCH vendor_taxp_csr INTO x_vendor_id,x_vendor_name;
315: fv_utility.log_mesg('Here2');
316: IF(vendor_taxp_csr%NOTFOUND) THEN
317: x_vendor_id := null;
318: x_vendor_name := null;
319: fv_utility.log_mesg('Here3');

Line 319: fv_utility.log_mesg('Here3');

315: fv_utility.log_mesg('Here2');
316: IF(vendor_taxp_csr%NOTFOUND) THEN
317: x_vendor_id := null;
318: x_vendor_name := null;
319: fv_utility.log_mesg('Here3');
320: IF (p_fed_check_flag='N') THEN
321: OPEN vendor_supp_num_csr(p_taxpayer_number);
322: fv_utility.log_mesg('Here4');
323: FETCH vendor_supp_num_csr INTO l_supp_num;

Line 322: fv_utility.log_mesg('Here4');

318: x_vendor_name := null;
319: fv_utility.log_mesg('Here3');
320: IF (p_fed_check_flag='N') THEN
321: OPEN vendor_supp_num_csr(p_taxpayer_number);
322: fv_utility.log_mesg('Here4');
323: FETCH vendor_supp_num_csr INTO l_supp_num;
324: fv_utility.log_mesg('Here5');
325: IF(vendor_supp_num_csr%NOTFOUND) THEN
326: x_supp_num_exist := 'N';

Line 324: fv_utility.log_mesg('Here5');

320: IF (p_fed_check_flag='N') THEN
321: OPEN vendor_supp_num_csr(p_taxpayer_number);
322: fv_utility.log_mesg('Here4');
323: FETCH vendor_supp_num_csr INTO l_supp_num;
324: fv_utility.log_mesg('Here5');
325: IF(vendor_supp_num_csr%NOTFOUND) THEN
326: x_supp_num_exist := 'N';
327: ELSE x_supp_num_exist := 'Y';
328: END IF;

Line 335: fv_utility.log_mesg('Here6');

331: END IF;
332: CLOSE vendor_taxp_csr;
333: ELSE
334: OPEN vendor_lbn_csr(p_legal_bus_name);
335: fv_utility.log_mesg('Here6');
336: FETCH vendor_lbn_csr INTO x_vendor_id,x_vendor_name;
337: fv_utility.log_mesg('Here7');
338: IF(vendor_lbn_csr%NOTFOUND) THEN
339: x_vendor_id := null;

Line 337: fv_utility.log_mesg('Here7');

333: ELSE
334: OPEN vendor_lbn_csr(p_legal_bus_name);
335: fv_utility.log_mesg('Here6');
336: FETCH vendor_lbn_csr INTO x_vendor_id,x_vendor_name;
337: fv_utility.log_mesg('Here7');
338: IF(vendor_lbn_csr%NOTFOUND) THEN
339: x_vendor_id := null;
340: x_vendor_name := null;
341: IF(p_fed_check_flag='N') THEN

Line 343: fv_utility.log_mesg('Here8');

339: x_vendor_id := null;
340: x_vendor_name := null;
341: IF(p_fed_check_flag='N') THEN
342: OPEN vendor_supp_num_csr(p_duns);
343: fv_utility.log_mesg('Here8');
344: FETCH vendor_supp_num_csr INTO l_supp_num;
345: fv_utility.log_mesg('Here9');
346: IF(vendor_supp_num_csr%NOTFOUND) THEN
347: x_supp_num_exist := 'N';

Line 345: fv_utility.log_mesg('Here9');

341: IF(p_fed_check_flag='N') THEN
342: OPEN vendor_supp_num_csr(p_duns);
343: fv_utility.log_mesg('Here8');
344: FETCH vendor_supp_num_csr INTO l_supp_num;
345: fv_utility.log_mesg('Here9');
346: IF(vendor_supp_num_csr%NOTFOUND) THEN
347: x_supp_num_exist := 'N';
348: ELSE x_supp_num_exist := 'Y';
349: END IF;

Line 354: fv_utility.log_mesg('Here10');

350: CLOSE vendor_supp_num_csr;
351: END IF;
352: END IF;
353: CLOSE vendor_lbn_csr;
354: fv_utility.log_mesg('Here10');
355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN

Line 355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

351: END IF;
352: END IF;
353: CLOSE vendor_lbn_csr;
354: fv_utility.log_mesg('Here10');
355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: fv_utility.log_mesg(' Exception in get_vendor_id.');

Line 359: fv_utility.log_mesg(' Exception in get_vendor_id.');

355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: fv_utility.log_mesg(' Exception in get_vendor_id.');
360: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
361: x_vendor_id := null;
362: x_vendor_name := null;
363: END;

Line 360: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: fv_utility.log_mesg(' Exception in get_vendor_id.');
360: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
361: x_vendor_id := null;
362: x_vendor_name := null;
363: END;
364:

Line 384: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

380: l_module_name VARCHAR2(60);
381: BEGIN
382:
383: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_id';
384: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
385:
386: SELECT bank_account_id,aba.bank_branch_id
387: INTO x_bank_account_id,l_bank_branch_id
388: FROM ap_bank_branches abb,ap_bank_accounts_all aba

Line 406: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

402: IF(x_bank_branch_id =0) THEN
403: x_bank_branch_id := null;
404: END IF;
405:
406: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
407: EXCEPTION
408: WHEN OTHERS THEN
409: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
410: x_bank_account_id := null;

Line 409: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

405:
406: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
407: EXCEPTION
408: WHEN OTHERS THEN
409: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
410: x_bank_account_id := null;
411: END;
412: */
413:

Line 435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

431: AND branch_number IS NOT NULL;
432: BEGIN
433:
434: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_branch_information';
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
436:
437: IF(nvl(p_bank_branch_id,0)<>0) THEN
438: BEGIN
439: SELECT bank_name,bank_branch_name,branch_number

Line 445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

441: l_routing_num FROM ce_bank_branches_v
442: WHERE branch_party_id = p_bank_branch_id;
443: EXCEPTION
444: WHEN OTHERS THEN
445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
446: 'Bank Branch exception for'|| p_bank_branch_id);
447: l_bank_name := null;
448: l_bank_branch_name := null;
449: l_routing_num := null;

Line 470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);

466: END IF;
467: CLOSE bank_branch_csr;
468: EXCEPTION
469: WHEN OTHERS THEN
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);
471: x_bank_branch_id := null;
472: x_bank_name := null;
473: x_bank_branch_name := null;
474: CLOSE bank_branch_csr;

Line 481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

477: x_bank_branch_id := null;
478: x_bank_name := null;
479: x_bank_branch_name := null;
480: END IF;
481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
482: END;
483:
484: PROCEDURE get_bank_account_information
485: (

Line 512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

508: l_module_name VARCHAR2(60);
509: BEGIN
510: x_update_account:='N';
511: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
513:
514: BEGIN
515:
516: IF(nvl(p_bank_account_id,0)<>0) THEN

Line 550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

546: ELSE
547: x_bank_account_id := null;
548: END IF;
549:
550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
551: EXCEPTION
552: WHEN OTHERS THEN
553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
554: x_bank_account_id := null;

Line 553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

549:
550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
551: EXCEPTION
552: WHEN OTHERS THEN
553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
554: x_bank_account_id := null;
555: END;
556:
557:

Line 580: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

576: l_vendor_name VARCHAR2(120);
577: l_supp_num_exist VARCHAR2(1);
578: BEGIN
579: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_federal_indicator';
580: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
581:
582: l_init_msg_list := fnd_api.g_true;
583:
584:

Line 609: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,

605: x_error_code => l_error_code
606: );
607: if(nvl(l_return_status,'E')<>FND_API.G_RET_STS_SUCCESS) THEN
608: if(l_msg_count=1) THEN
609: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,
610: 'Get Federal Indicator:' || l_msg_data);
611: else
612: for I IN 0 .. l_msg_count
613: loop

Line 615: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,

611: else
612: for I IN 0 .. l_msg_count
613: loop
614: l_msg_data := fnd_msg_pub.get(p_encoded=>'F');
615: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,
616: 'Get Federal Indicator:' || l_msg_data);
617: end loop;
618: end if;
619: x_federal:= 'N';

Line 625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');

621: end if;
622: ELSE
623: x_federal := 'N';
624: END IF;
625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
626: EXCEPTION
627: WHEN OTHERS THEN
628: x_federal:= 'N';
629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,l_module_name,'Get Federal Indicator:'

Line 629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,l_module_name,'Get Federal Indicator:'

625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
626: EXCEPTION
627: WHEN OTHERS THEN
628: x_federal:= 'N';
629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,l_module_name,'Get Federal Indicator:'
630: || ' Exception');
631: END;
632:
633: /* Procedure used to create or update vendor

Line 767: fv_utility.log_mesg('Another vendor exists with the same

763: FROM ap_suppliers
764: WHERE vendor_name = l_legal_bus_name
765: AND num_1099 <> p_taxpayer_number;
766:
767: fv_utility.log_mesg('Another vendor exists with the same
768: name as : '||l_legal_bus_name);
769: fv_utility.log_mesg('Appending duns number to '||l_legal_bus_name||
770: ' to keep the name unique.');
771:

Line 769: fv_utility.log_mesg('Appending duns number to '||l_legal_bus_name||

765: AND num_1099 <> p_taxpayer_number;
766:
767: fv_utility.log_mesg('Another vendor exists with the same
768: name as : '||l_legal_bus_name);
769: fv_utility.log_mesg('Appending duns number to '||l_legal_bus_name||
770: ' to keep the name unique.');
771:
772: l_legal_bus_name := SUBSTR(l_legal_bus_name,1,231)||p_duns;
773:

Line 779: FV_UTILITY.LOG_MESG(l_msg_text);

775: WHEN NO_DATA_FOUND THEN
776: NULL;
777: WHEN OTHERS THEN
778: l_msg_text := l_module_name||': When others error: Error Code:'||SQLCODE||' Error Text:'||SQLERRM;
779: FV_UTILITY.LOG_MESG(l_msg_text);
780: x_return_status := FND_API.G_RET_STS_ERROR ;
781: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
782: RETURN;
783: END;

Line 788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');

784:
785:
786:
787: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
789: l_dup_site_code:='F';
790: l_user_id := fnd_global.user_id;
791: l_login_id := fnd_global.login_id;
792: l_account_uses_insert_flag := 'N'; -- Do not insert bank acct uses

Line 903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);

899: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
900: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
901: l_msg_text := FND_MESSAGE.GET;
902: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
904: l_vendor_id := p_vendor_id;
905: ELSE
906: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
907: IF(nvl(l_pay_site_id,0)=0 AND

Line 912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

908: l_num_1099 <> p_taxpayer_number) THEN
909: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
910: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
911: l_msg_text := FND_MESSAGE.GET;
912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
913: l_module_name,l_msg_text);
914: insert_for_report(p_duns,16,l_msg_text,null,
915: null,null,null);
916: ELSIF(l_num_1099 <> p_taxpayer_number) THEN

Line 920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

916: ELSIF(l_num_1099 <> p_taxpayer_number) THEN
917: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED');
918: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
919: l_msg_text := FND_MESSAGE.GET;
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
921: l_module_name,l_msg_text);
922: insert_for_report(p_duns,16,l_msg_text,null,
923: null,null,null);
924: x_vendor_name := l_vendor_name;

Line 940: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;
939:
940: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
941: l_module_name,l_msg_text);
942: insert_for_report(p_duns,16,l_msg_text,null,
943: null,null,null);
944: x_vendor_name := l_vendor_name;

Line 983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

979: END IF;
980: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
981: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
982: l_msg_text := FND_MESSAGE.GET;
983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
984: l_module_name,l_msg_text||'Error Code:' ||
985: SQLCODE ||' Error Text:' || SQLERRM);
986: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null
987: ,null,null);

Line 1009: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

1005: WHERE DUNS=p_duns;
1006: EXCEPTION
1007: WHEN OTHERS THEN
1008: l_header_conc_req_status := 'E';
1009: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
1010: END;
1011:
1012:
1013: ELSE

Line 1026: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1022: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1023: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1024: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1025: l_msg_text := FND_MESSAGE.GET;
1026: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1027: l_module_name,l_msg_text);
1028: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);
1029: ELSE
1030: --get_vendor_id(p_taxpayer_number,p_legal_bus_name,p_duns,'N',

Line 1033: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);

1029: ELSE
1030: --get_vendor_id(p_taxpayer_number,p_legal_bus_name,p_duns,'N',
1031: get_vendor_id(p_taxpayer_number,l_legal_bus_name,p_duns,'N',
1032: l_vendor_id,l_vendor_name,l_supp_num_exist);
1033: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1034: fv_utility.log_mesg('l_vendor_name: '||l_vendor_name);
1035: fv_utility.log_mesg('l_supp_num_exist: '||l_supp_num_exist);
1036:
1037: IF(l_vendor_id IS NULL) THEN

Line 1034: fv_utility.log_mesg('l_vendor_name: '||l_vendor_name);

1030: --get_vendor_id(p_taxpayer_number,p_legal_bus_name,p_duns,'N',
1031: get_vendor_id(p_taxpayer_number,l_legal_bus_name,p_duns,'N',
1032: l_vendor_id,l_vendor_name,l_supp_num_exist);
1033: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1034: fv_utility.log_mesg('l_vendor_name: '||l_vendor_name);
1035: fv_utility.log_mesg('l_supp_num_exist: '||l_supp_num_exist);
1036:
1037: IF(l_vendor_id IS NULL) THEN
1038: l_vendor_id :=0;

Line 1035: fv_utility.log_mesg('l_supp_num_exist: '||l_supp_num_exist);

1031: get_vendor_id(p_taxpayer_number,l_legal_bus_name,p_duns,'N',
1032: l_vendor_id,l_vendor_name,l_supp_num_exist);
1033: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1034: fv_utility.log_mesg('l_vendor_name: '||l_vendor_name);
1035: fv_utility.log_mesg('l_supp_num_exist: '||l_supp_num_exist);
1036:
1037: IF(l_vendor_id IS NULL) THEN
1038: l_vendor_id :=0;
1039:

Line 1045: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1041: AND l_supp_num_exist = 'Y') THEN
1042: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1043: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1044: l_msg_text:= FND_MESSAGE.GET;
1045: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1046: l_module_name,l_msg_text);
1047: insert_for_report(p_duns,18,l_msg_text,null,
1048: null,null,null);
1049: l_supplier_number := null;

Line 1057: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

1053: IF(p_taxpayer_number IS NOT NULL) THEN
1054: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1055: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1056: l_msg_text := FND_MESSAGE.GET;
1057: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1058: ,l_module_name,l_msg_text);
1059: insert_for_report(p_duns,16,l_msg_text,null,null
1060: ,null,null);
1061: END IF;

Line 1071: fv_utility.log_mesg('before calling insert_vendor');

1067: if(l_vendor_id IS NULL OR l_vendor_id = 0 ) THEN
1068:
1069: BEGIN
1070: l_msg := null;
1071: fv_utility.log_mesg('before calling insert_vendor');
1072: FV_CCR_UTIL_PVT.insert_vendor
1073: (
1074: --p_vendor_name => p_legal_bus_name,
1075: p_vendor_name => l_legal_bus_name,

Line 1083: fv_utility.log_mesg('after calling insert_vendor');

1079: x_vendor_id =>l_vendor_id,
1080: x_status=>l_status,
1081: x_exception_msg=>l_msg);
1082:
1083: fv_utility.log_mesg('after calling insert_vendor');
1084: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1085: fv_utility.log_mesg('l_status: '||l_status);
1086: fv_utility.log_mesg('l_msg: '||l_msg);
1087:

Line 1084: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);

1080: x_status=>l_status,
1081: x_exception_msg=>l_msg);
1082:
1083: fv_utility.log_mesg('after calling insert_vendor');
1084: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1085: fv_utility.log_mesg('l_status: '||l_status);
1086: fv_utility.log_mesg('l_msg: '||l_msg);
1087:
1088:

Line 1085: fv_utility.log_mesg('l_status: '||l_status);

1081: x_exception_msg=>l_msg);
1082:
1083: fv_utility.log_mesg('after calling insert_vendor');
1084: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1085: fv_utility.log_mesg('l_status: '||l_status);
1086: fv_utility.log_mesg('l_msg: '||l_msg);
1087:
1088:
1089: IF(nvl(l_status,'F')<> 'S' OR l_vendor_id IS NULL) THEN

Line 1086: fv_utility.log_mesg('l_msg: '||l_msg);

1082:
1083: fv_utility.log_mesg('after calling insert_vendor');
1084: fv_utility.log_mesg('l_vendor_id: '||l_vendor_id);
1085: fv_utility.log_mesg('l_status: '||l_status);
1086: fv_utility.log_mesg('l_msg: '||l_msg);
1087:
1088:
1089: IF(nvl(l_status,'F')<> 'S' OR l_vendor_id IS NULL) THEN
1090: RAISE e_supp_exception;

Line 1091: fv_utility.log_mesg('raised e_supp_exception');

1087:
1088:
1089: IF(nvl(l_status,'F')<> 'S' OR l_vendor_id IS NULL) THEN
1090: RAISE e_supp_exception;
1091: fv_utility.log_mesg('raised e_supp_exception');
1092: END IF;
1093: --insert_for_report(p_duns,12,null,p_legal_bus_name,
1094: insert_for_report(p_duns,12,null,l_legal_bus_name,
1095: p_taxpayer_number,null,null);

Line 1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1113: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1114: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1115: l_msg_text := FND_MESSAGE.GET ;
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1117: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1118: || SQLERRM);
1119: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1120: if(l_new_bank_account_id IS NOT NULL AND

Line 1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: l_header_conc_req_status := 'E';
1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
1153: END;
1154: END IF;
1155:
1156: END IF;

Line 1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

1207: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1208: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1209: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1210: l_msg_text := FND_MESSAGE.GET;
1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1212: ,l_module_name,l_msg_text);
1213: insert_for_report(p_duns,16,l_msg_text,null,null
1214: ,null,null);
1215: ELSE

Line 1252: fv_utility.log_mesg('Updating mail poc for main site id:'||l_party_site_id);

1248:
1249: -- Added for bug 6238518
1250: IF (l_status = 'S') THEN
1251: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1252: fv_utility.log_mesg('Updating mail poc for main site id:'||l_party_site_id);
1253: UPDATE hz_party_sites
1254: SET addressee = p_mail_poc
1255: WHERE party_site_id = l_party_site_id;
1256: END IF;

Line 1302: fv_utility.log_mesg('Updating mail poc for main site id: '||l_party_site_id);

1298:
1299: -- Added for bug 6238518
1300: IF (l_status = 'S') THEN
1301: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1302: fv_utility.log_mesg('Updating mail poc for main site id: '||l_party_site_id);
1303: UPDATE hz_party_sites
1304: SET addressee = p_mail_poc
1305: WHERE party_site_id = l_party_site_id;
1306: END IF;

Line 1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1323: IF(nvl(l_main_add_site_id,0) = 0) THEN
1324: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1325: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1326: l_msg_text := FND_MESSAGE.GET;
1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1328: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1329: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1330: ELSE
1331: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');

Line 1335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1331: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1332: get_vendor_site_code(p_main_add_site_id,l_site_code);
1333: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1334: l_msg_text := FND_MESSAGE.GET;
1335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1336: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1337: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1338: END IF;
1339:

Line 1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

1367: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1368: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1369: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1370: l_msg_text := FND_MESSAGE.GET;
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1372: ,l_module_name,l_msg_text);
1373: insert_for_report(p_duns,16,l_msg_text,null,null
1374: ,null,null);
1375: l_account_uses_insert_flag := 'N';

Line 1416: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);

1412:
1413: -- Added for bug 6238518
1414: IF (l_status = 'S') THEN
1415: IF NVL(l_pay_site_flag,'N') = 'Y' THEN
1416: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1417: UPDATE hz_party_sites
1418: SET addressee = p_remit_poc
1419: WHERE party_site_id = l_party_site_id;
1420: END IF;

Line 1440: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1436: END IF;
1437: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1438: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1439: l_msg_text := FND_MESSAGE.GET;
1440: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1441: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1442: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1443: l_account_uses_insert_flag := 'N';
1444: l_account_uses_upd_flag := 'N';

Line 1500: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);

1496: END IF;
1497:
1498: -- Added for bug 6238518
1499: IF (l_status = 'S') THEN
1500: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1501: UPDATE hz_party_sites
1502: SET addressee = p_remit_poc
1503: WHERE party_site_id = l_party_site_id;
1504: END IF;

Line 1519: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1515: get_vendor_site_code(p_pay_site_id,l_site_code);
1516: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1517: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1518: l_msg_text := FND_MESSAGE.GET;
1519: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1520: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1521: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1522:
1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1551: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: l_assgn_conc_req_status := 'E';
1550: FND_CLIENT_INFO.set_org_context(l_old_org_id);
1551: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1552: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1553: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1554: THEN
1555: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1639: get_vendor_site_code(p_pay_site_id,l_site_code);
1640: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1641: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1642: l_msg_text := FND_MESSAGE.GET;
1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1644: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1645: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1646: END;
1647: END IF;

Line 1701: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

1697: get_vendor_site_code(p_main_add_site_id,l_site_code);
1698: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1699: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1700: l_msg_text := FND_MESSAGE.GET;
1701: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1702: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1703: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1704: END;
1705: END IF;

Line 1815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);

1811: end if;
1812:
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
1816: END delete_plusfour_assignments;
1817:
1818:
1819: FUNCTION get_org_paysite_id(p_ccrid NUMBER, p_org_id NUMBER)

Line 1915: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1911: EXCEPTION
1912: WHEN NO_DATA_FOUND THEN
1913: RETURN p_lookup_code;
1914: WHEN OTHERS THEN
1915: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1916: 'fv_ccr_util_pvt.get_lookup_desc',SQLERRM);
1917: RETURN p_lookup_code;
1918:
1919: END get_lookup_desc;

Line 2018: fv_utility.log_mesg('p_vendor_name: '||p_vendor_name);

2014: l_vendor_rec.segment1 := p_supplier_number;
2015:
2016: l_vendor_rec.ORGANIZATION_TYPE_LOOKUP_CODE := p_org_type_lookup_code;
2017:
2018: fv_utility.log_mesg('p_vendor_name: '||p_vendor_name);
2019: fv_utility.log_mesg('p_taxpayer_id: '||p_taxpayer_id);
2020: fv_utility.log_mesg('p_supplier_number: '||p_supplier_number);
2021: fv_utility.log_mesg('p_org_type_lookup_code: '||p_org_type_lookup_code);
2022:

Line 2019: fv_utility.log_mesg('p_taxpayer_id: '||p_taxpayer_id);

2015:
2016: l_vendor_rec.ORGANIZATION_TYPE_LOOKUP_CODE := p_org_type_lookup_code;
2017:
2018: fv_utility.log_mesg('p_vendor_name: '||p_vendor_name);
2019: fv_utility.log_mesg('p_taxpayer_id: '||p_taxpayer_id);
2020: fv_utility.log_mesg('p_supplier_number: '||p_supplier_number);
2021: fv_utility.log_mesg('p_org_type_lookup_code: '||p_org_type_lookup_code);
2022:
2023:

Line 2020: fv_utility.log_mesg('p_supplier_number: '||p_supplier_number);

2016: l_vendor_rec.ORGANIZATION_TYPE_LOOKUP_CODE := p_org_type_lookup_code;
2017:
2018: fv_utility.log_mesg('p_vendor_name: '||p_vendor_name);
2019: fv_utility.log_mesg('p_taxpayer_id: '||p_taxpayer_id);
2020: fv_utility.log_mesg('p_supplier_number: '||p_supplier_number);
2021: fv_utility.log_mesg('p_org_type_lookup_code: '||p_org_type_lookup_code);
2022:
2023:
2024: AP_VENDOR_PUB_PKG.create_vendor(

Line 2021: fv_utility.log_mesg('p_org_type_lookup_code: '||p_org_type_lookup_code);

2017:
2018: fv_utility.log_mesg('p_vendor_name: '||p_vendor_name);
2019: fv_utility.log_mesg('p_taxpayer_id: '||p_taxpayer_id);
2020: fv_utility.log_mesg('p_supplier_number: '||p_supplier_number);
2021: fv_utility.log_mesg('p_org_type_lookup_code: '||p_org_type_lookup_code);
2022:
2023:
2024: AP_VENDOR_PUB_PKG.create_vendor(
2025: p_api_version => l_version,

Line 2037: fv_utility.log_mesg('l_ret_stat: '||l_ret_stat);

2033: x_vendor_id=>x_vendor_id,
2034: x_party_id=>l_party_id);
2035:
2036:
2037: fv_utility.log_mesg('l_ret_stat: '||l_ret_stat);
2038: fv_utility.log_mesg('l_msg_count: '||l_msg_count);
2039:
2040: if(l_ret_stat <> 'S') THEN
2041: if(l_msg_count = 1) THEN

Line 2038: fv_utility.log_mesg('l_msg_count: '||l_msg_count);

2034: x_party_id=>l_party_id);
2035:
2036:
2037: fv_utility.log_mesg('l_ret_stat: '||l_ret_stat);
2038: fv_utility.log_mesg('l_msg_count: '||l_msg_count);
2039:
2040: if(l_ret_stat <> 'S') THEN
2041: if(l_msg_count = 1) THEN
2042: x_exception_msg := l_msg_data;

Line 2051: fv_utility.log_mesg('x_exception_msg: '||x_exception_msg);

2047: end if;
2048: end if;
2049:
2050: x_status := l_ret_stat;
2051: fv_utility.log_mesg('x_exception_msg: '||x_exception_msg);
2052:
2053: exception
2054: when others then
2055: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');

Line 2055: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');

2051: fv_utility.log_mesg('x_exception_msg: '||x_exception_msg);
2052:
2053: exception
2054: when others then
2055: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');
2056: fv_utility.log_mesg(sqlcode||': '||sqlerrm);
2057:
2058: END insert_vendor;
2059:

Line 2056: fv_utility.log_mesg(sqlcode||': '||sqlerrm);

2052:
2053: exception
2054: when others then
2055: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');
2056: fv_utility.log_mesg(sqlcode||': '||sqlerrm);
2057:
2058: END insert_vendor;
2059:
2060:

Line 2698: fv_utility.log_mesg('When others error in update_bank_account.');

2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: x_return_status := fnd_api.g_ret_sts_unexp_error;
2697: -- Print SQLERRM in log file
2698: fv_utility.log_mesg('When others error in update_bank_account.');
2699: END update_bank_account;
2700:
2701:
2702: PROCEDURE process_bank_account_uses