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_FACTS1_GL_PKG dependencies on FND_LOG

Line 185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

181: EXCEPTION WHEN OTHERS THEN
182: p_err_code := SQLCODE;
183: p_err_buff := 'When others exception in Main - '||SQLERRM;
184: ROLLBACK;
185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
186:
187: END main;
188: --------------------------------------------------------------------------------
189: PROCEDURE CLEANUP

Line 205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

201:
202: EXCEPTION WHEN OTHERS THEN
203: gbl_err_code := SQLCODE;
204: gbl_err_buff := l_module_name||' - When others exception - '||SQLERRM;
205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
206:
207: END CLEANUP;
208:
209: --------------------------------------------------------------------------------

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

256: gbl_acc_segment IS NULL) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;
259:
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
261: 'Balancing Segment: '||gbl_bal_segment);
262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
263: 'Accounting Segment: '||gbl_acc_segment);
264:

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

258: END IF;
259:
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
261: 'Balancing Segment: '||gbl_bal_segment);
262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
263: 'Accounting Segment: '||gbl_acc_segment);
264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN

Line 269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: gbl_err_code := -1 ;
268: gbl_err_buff := 'Balancing or Accounting segment not found.';
269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
270: WHEN invalid_bal_segment THEN
271: gbl_err_code := -1 ;
272: gbl_err_buff := 'Error while fetching balancing segment.';
273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
270: WHEN invalid_bal_segment THEN
271: gbl_err_code := -1 ;
272: gbl_err_buff := 'Error while fetching balancing segment.';
273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
274: WHEN invalid_acc_segment THEN
275: gbl_err_code := -1 ;
276: gbl_err_buff := 'Error while fetching accounting segment.';
277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
274: WHEN invalid_acc_segment THEN
275: gbl_err_code := -1 ;
276: gbl_err_buff := 'Error while fetching accounting segment.';
277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
278: WHEN OTHERS THEN
279: gbl_err_code := -1 ;
280: gbl_err_buff := 'When others error while getting
281: Balancing or Accounting segment - '||SQLERRM;

Line 282: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

278: WHEN OTHERS THEN
279: gbl_err_code := -1 ;
280: gbl_err_buff := 'When others error while getting
281: Balancing or Accounting segment - '||SQLERRM;
282: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
283: END get_segment_names;
284: --------------------------------------------------------------------------------
285: -- Get the period num for the parameter period and also the first period num
286: -- for the year.

Line 335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

331: gbl_period_num_high = 0) THEN
332: gbl_err_code := 2 ;
333: gbl_err_buff := l_module_name||' Period number '||
334: 'found zero for the passed fiscal year.' ;
335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
336: RETURN;
337: END IF;
338:
339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);

Line 417: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

413: --------------------------------------------------------------------------------
414: l_module_name VARCHAR2(1000);
415: BEGIN
416:
417: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
419: module, message_line);
420:
421: END IF;

Line 418: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

414: l_module_name VARCHAR2(1000);
415: BEGIN
416:
417: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
419: module, message_line);
420:
421: END IF;
422:

Line 946: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

942: EXCEPTION
943: WHEN OTHERS THEN
944: gbl_err_code := SQLCODE;
945: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
946: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
947: END process_gl_lines;
948: --------------------------------------------------------------------------------
949: PROCEDURE GET_PARTY_INFO(p_category IN VARCHAR2,
950: p_source IN VARCHAR2,

Line 1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1030: -- get the vendor id from Payables (Includes invoice and Payments)
1031: ------------------------------------------------------------------
1032: IF (p_source = 'Payables' ) THEN
1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);

Line 1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);

1031: ------------------------------------------------------------------
1032: IF (p_source = 'Payables' ) THEN
1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;

Line 1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1032: IF (p_source = 'Payables' ) THEN
1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;
1040:

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

1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;
1040:
1041: BEGIN

Line 1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1076: l_cust_vend_type := 'V';
1077:
1078: ELSE
1079: l_recipient_name := 'Other';
1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1082: 'REFERENCE_2 I.E. INVOICE_ID IS NULL');
1083: END IF;
1084:

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

1077:
1078: ELSE
1079: l_recipient_name := 'Other';
1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1082: 'REFERENCE_2 I.E. INVOICE_ID IS NULL');
1083: END IF;
1084:
1085:

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

1086: END IF;
1087:
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1091: 'NO DATA FOUND FOR SOURCE = PAYABLES !!');
1092: l_recipient_name := 'Other';
1093:
1094: END;

Line 1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1097: -- Get the Vendor ID for Purchasing Inventory Records
1098: ------------------------------------------------------------------
1099: ELSIF (p_source in ('Purchasing' , 'Cost Management')) THEN
1100: IF (p_category = 'Receiving') THEN
1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1104: END IF;
1105: BEGIN

Line 1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1098: ------------------------------------------------------------------
1099: ELSIF (p_source in ('Purchasing' , 'Cost Management')) THEN
1100: IF (p_category = 'Receiving') THEN
1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1104: END IF;
1105: BEGIN
1106:

Line 1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);

1099: ELSIF (p_source in ('Purchasing' , 'Cost Management')) THEN
1100: IF (p_category = 'Receiving') THEN
1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1104: END IF;
1105: BEGIN
1106:
1107: IF p_je_from_sla_flag = 'Y' THEN

Line 1150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1146:
1147: ELSE
1148: IF (p_reference_2 IS NULL) THEN
1149: l_recipient_name := 'Other';
1150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1152: 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');
1153: END IF;
1154: ELSE

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

1147: ELSE
1148: IF (p_reference_2 IS NULL) THEN
1149: l_recipient_name := 'Other';
1150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1152: 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');
1153: END IF;
1154: ELSE
1155: l_recipient_name := 'Other';

Line 1156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1152: 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');
1153: END IF;
1154: ELSE
1155: l_recipient_name := 'Other';
1156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1158: 'REFERENCE_5 I.E. TRANSACTION_ID IS NULL');
1159: END IF;
1160: END IF;

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

1153: END IF;
1154: ELSE
1155: l_recipient_name := 'Other';
1156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1158: 'REFERENCE_5 I.E. TRANSACTION_ID IS NULL');
1159: END IF;
1160: END IF;
1161:

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

1161:
1162: END IF;
1163: EXCEPTION
1164: WHEN NO_DATA_FOUND THEN
1165: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1166: 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS RECEIVING!!');
1167:
1168: l_recipient_name := 'Other';
1169: END;

Line 1172: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1168: l_recipient_name := 'Other';
1169: END;
1170:
1171: ELSIF (p_category = 'Purchases') THEN
1172: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1174: END IF;
1175: BEGIN
1176: IF p_je_from_sla_flag = 'Y' THEN

Line 1173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1169: END;
1170:
1171: ELSIF (p_category = 'Purchases') THEN
1172: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1174: END IF;
1175: BEGIN
1176: IF p_je_from_sla_flag = 'Y' THEN
1177: get_reference_column ('PURCHASE_ORDER',

Line 1214: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1210:
1211: ELSE
1212: l_recipient_name := 'Other';
1213:
1214: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1216: 'REFERENCE_2 I.E. PO HEADER ID IS NULL');
1217: END IF;
1218:

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

1211: ELSE
1212: l_recipient_name := 'Other';
1213:
1214: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1216: 'REFERENCE_2 I.E. PO HEADER ID IS NULL');
1217: END IF;
1218:
1219: END IF;

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

1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN NO_DATA_FOUND THEN
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1224: 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS PURCHASES!!');
1225:
1226: l_recipient_name := 'Other';
1227: END;

Line 1268: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1264:
1265: l_cust_vend_type := 'C';
1266: ELSE
1267: l_recipient_name := 'Other';
1268: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1269: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1270: 'REFERENCE_7 I.E. CUSTOMER_ID IS NULL');
1271: END IF;
1272: END IF;

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

1265: l_cust_vend_type := 'C';
1266: ELSE
1267: l_recipient_name := 'Other';
1268: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1269: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1270: 'REFERENCE_7 I.E. CUSTOMER_ID IS NULL');
1271: END IF;
1272: END IF;
1273: EXCEPTION

Line 1276: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

1272: END IF;
1273: EXCEPTION
1274: WHEN NO_DATA_FOUND THEN
1275: l_recipient_name := 'Other';
1276: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
1277: l_module_name,'NO DATA FOUND WHEN SOURCE IS RECEIVABLES!!');
1278: END;
1279: --------------------------------------------------------------------
1280: -- Vendor id for TC transactions

Line 1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1320: l_cust_vend_type := 'V';
1321:
1322: ELSE
1323: l_recipient_name := 'Other';
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1326: 'REFERENCE_3 I.E. CHECK_ID IS NULL');
1327: END IF;
1328: END IF;

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

1321:
1322: ELSE
1323: l_recipient_name := 'Other';
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1326: 'REFERENCE_3 I.E. CHECK_ID IS NULL');
1327: END IF;
1328: END IF;
1329:

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

1385: l_recipient_name := 'Other';
1386: END IF;
1387: EXCEPTION
1388: WHEN NO_DATA_FOUND THEN
1389: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1390: 'NO DATA FOUND WHEN SOURCE = BUDGETARY TRANSACTION');
1391: END;
1392:
1393: ELSIF (l_govt_non_govt_ind = 'Y') THEN

Line 1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1458: END IF;
1459: END IF;
1460:
1461: IF (party_info_tab(i).party_id IS NULL) THEN
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1464: l_module_name, 'VENDOR ID IS NULL');
1465: END IF;
1466: IF ((l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'Y') OR

Line 1463: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1459: END IF;
1460:
1461: IF (party_info_tab(i).party_id IS NULL) THEN
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1464: l_module_name, 'VENDOR ID IS NULL');
1465: END IF;
1466: IF ((l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'Y') OR
1467: (l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'N'

Line 1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1474: ELSE
1475: party_info_tab(i).record_category := 'REPORTED';
1476: END IF;
1477:
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1480: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1481: END IF;
1482:

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

1475: party_info_tab(i).record_category := 'REPORTED';
1476: END IF;
1477:
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1480: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1481: END IF;
1482:
1483: -- Govt Non Govt Indicator = Y

Line 1497: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1493: party_info_tab(i).record_category := 'REPORTED';
1494: party_info_tab(i).g_ng_indicator := 'F';
1495: END IF;
1496:
1497: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1499: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1500: END IF;
1501:

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

1494: party_info_tab(i).g_ng_indicator := 'F';
1495: END IF;
1496:
1497: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1499: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1500: END IF;
1501:
1502: END IF; -- Govt Non Govt = F or Y

Line 1519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1515: party_info_tab(i).reported_status := 'W';
1516: party_info_tab(i).record_category := 'G_NONFED_VENDOR';
1517: END IF;
1518:
1519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1521: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1522: END IF;
1523:

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

1516: party_info_tab(i).record_category := 'G_NONFED_VENDOR';
1517: END IF;
1518:
1519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1521: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1522: END IF;
1523:
1524: ELSIF (l_govt_non_govt_ind = 'F' and party_info_tab(i).elim_dept IS NULL) THEN

Line 1532: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1528: --l_govt_non_govt_ind := 'F';
1529: party_info_tab(i).g_ng_indicator := 'F';
1530: party_info_tab(i).record_category := 'REPORTED';
1531:
1532: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1534: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1535: END IF;
1536:

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

1529: party_info_tab(i).g_ng_indicator := 'F';
1530: party_info_tab(i).record_category := 'REPORTED';
1531:
1532: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1534: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1535: END IF;
1536:
1537: ELSIF (l_govt_non_govt_ind = 'F' and party_info_tab(i).elim_dept IS NOT NULL) THEN

Line 1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1538: party_info_tab(i).reported_status := 'R';
1539: party_info_tab(i).record_category := 'REPORTED';
1540: --l_govt_non_govt_ind := 'F';
1541: party_info_tab(i).g_ng_indicator := 'F';
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: ' GNG: F');
1545: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1546: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

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

1539: party_info_tab(i).record_category := 'REPORTED';
1540: --l_govt_non_govt_ind := 'F';
1541: party_info_tab(i).g_ng_indicator := 'F';
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: ' GNG: F');
1545: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1546: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1547: END IF;

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

1541: party_info_tab(i).g_ng_indicator := 'F';
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: ' GNG: F');
1545: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1546: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1547: END IF;
1548:
1549: ELSIF (l_govt_non_govt_ind = 'Y' AND

Line 1558: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1554: --l_govt_non_govt_ind := 'N';
1555: party_info_tab(i).g_ng_indicator := 'N';
1556: party_info_tab(i).elim_dept := ' ';
1557:
1558: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1560: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1561: END IF;
1562:

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

1555: party_info_tab(i).g_ng_indicator := 'N';
1556: party_info_tab(i).elim_dept := ' ';
1557:
1558: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1560: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1561: END IF;
1562:
1563: ELSIF (l_govt_non_govt_ind = 'Y' and party_info_tab(i).elim_dept IS NULL) THEN

Line 1571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1567: --l_govt_non_govt_ind := 'F';
1568: party_info_tab(i).g_ng_indicator := 'F';
1569: party_info_tab(i).elim_dept := '00';
1570:
1571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1573: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1574: END IF;
1575:

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

1568: party_info_tab(i).g_ng_indicator := 'F';
1569: party_info_tab(i).elim_dept := '00';
1570:
1571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1573: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1574: END IF;
1575:
1576: ELSIF (l_govt_non_govt_ind = 'Y' and party_info_tab(i).elim_dept IS NOT NULL) THEN

Line 1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1579: party_info_tab(i).record_category := 'REPORTED';
1580: --l_govt_non_govt_ind := 'F';
1581: party_info_tab(i).g_ng_indicator := 'F';
1582:
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');

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

1580: --l_govt_non_govt_ind := 'F';
1581: party_info_tab(i).g_ng_indicator := 'F';
1582:
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

1582:
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1589: ' ELIMINATIONS ID IS NOT NULL');
1590: END IF;

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

1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1589: ' ELIMINATIONS ID IS NOT NULL');
1590: END IF;
1591:
1592: END IF; -- l_govt_non_govt_ind

Line 1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1602: --l_govt_non_govt_ind := 'F';
1603: party_info_tab(i).g_ng_indicator := 'F';
1604: party_info_tab(i).record_category := 'REPORTED';
1605:
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');

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

1603: party_info_tab(i).g_ng_indicator := 'F';
1604: party_info_tab(i).record_category := 'REPORTED';
1605:
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

1605:
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1613: END IF;

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

1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1613: END IF;
1614:
1615: END IF; -- l_govt_non_govt_ind

Line 1648: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

1644: gbl_err_code := 2 ;
1645: gbl_err_buff := 'GET_PARTY_INFO - Exception (Others) - ' ||
1646: to_char(SQLCODE) || ' - ' || SQLERRM;
1647:
1648: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1649: '.final_exception',gbl_err_buff);
1650:
1651: END get_party_info;
1652: --------------------------------------------------------------------------------

Line 1696: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

1692: EXCEPTION WHEN OTHERS THEN
1693: gbl_err_code := 2 ;
1694: gbl_err_buff := l_module_name||' - When others exception - ' ||
1695: to_char(SQLCODE) || ' - ' || SQLERRM;
1696: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1697: gbl_err_buff);
1698:
1699: END insert_exception_recs;
1700: --------------------------------------------------------------------------------

Line 1741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

1737:
1738: IF (l_req_id = 0) THEN
1739: gbl_err_code := '2';
1740: gbl_err_buff := 'Cannot submit FACTS Exception report';
1741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1742: RETURN;
1743: ELSE
1744: COMMIT;
1745: call_status := Fnd_concurrent.Wait_for_request(l_req_id, 20, 0,

Line 1813: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

1809: WHEN OTHERS THEN
1810: gbl_err_code := SQLCODE;
1811: gbl_err_buff := SQLERRM ||
1812: 'When others error in UPDATE_FACTS1_RUN - '||SQLERRM;
1813: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
1814:
1815: END UPDATE_FACTS1_RUN;
1816: --------------------------------------------------------------------------------
1817: PROCEDURE get_reference_column (p_entity_code IN VARCHAR2,

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

1996: log(l_module_name,'line_amount: '||p_party_info_tab(i).party_line_amount);
1997: log(l_module_name,'vendor_type: '||p_party_info_tab(i).vendor_type);
1998:
1999: EXCEPTION WHEN NO_DATA_FOUND THEN
2000: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
2001: 'NO DATA FOUND WHEN SOURCE = :'||p_entity_code);
2002: p_party_info_tab(i).party_line_amount := be_rec.amount;
2003: p_party_info_tab(i).recipient_name := 'Other';
2004: END;

Line 2013: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

2009: WHEN NO_DATA_FOUND THEN
2010: gbl_err_code := SQLCODE;
2011: gbl_err_buff :=
2012: 'No data found error in get_reference_column - '||SQLERRM;
2013: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2014: WHEN OTHERS THEN
2015: gbl_err_code := SQLCODE;
2016: gbl_err_buff :=
2017: 'When others error in get_reference_column - '||SQLERRM;

Line 2018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

2014: WHEN OTHERS THEN
2015: gbl_err_code := SQLCODE;
2016: gbl_err_buff :=
2017: 'When others error in get_reference_column - '||SQLERRM;
2018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2019: END get_reference_column;
2020: --------------------------------------------------------------------------------
2021: BEGIN
2022: g_module_name := 'fv.plsql.FV_FACTS1_GL_PKG.';