eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CCR_UTIL_PVT dependencies on FND_LOG

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 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 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 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 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 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 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 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 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;