APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FV_UTILITY

Line 171: fv_utility.log_mesg('Checking if agency is not found.');

167: END;
168: --Need to print out the customer/supplier id, name where update
169: --cannot be done because agency id is not found
170: --in the mapping table
171: fv_utility.log_mesg('Checking if agency is not found.');
172: FOR i in 1..2 LOOP
173:
174: IF i = 1 THEN
175: l_col_select := ' select c.cust_account_id, c.account_name,';

Line 236: fv_utility.log_mesg('Checking if agency in 48 or 95.');

232: END LOOP;
233:
234:
235: --Print the customer/supplier name where the agency id is 48 or 95
236: fv_utility.log_mesg('Checking if agency in 48 or 95.');
237: l_hdr_printed := FALSE;
238: FOR i in 1..2 LOOP
239: IF i = 1 THEN
240: l_col_select := ' SELECT SUBSTR(c.account_name,1,80)

Line 298: fv_utility.log_mesg('Updating cust/supp with 3 digit agency id.');

294:
295:
296: --Update customer/supplier rows with the 3 digit agency id
297: --from the mapping table
298: fv_utility.log_mesg('Updating cust/supp with 3 digit agency id.');
299: FOR j in 1..2 LOOP
300: IF j = 1 THEN
301: --Update new column in hz_cust_accounts_all
302: l_attrib := l_facts1_cust_attribute;

Line 1081: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);

1077:
1078: BEGIN
1079:
1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
1082: END IF;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN

Line 1088: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_err_buff);

1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: g_err_code := SQLCODE;
1087: g_err_buff := l_module||' - When others error: '||SQLERRM;
1088: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_err_buff);
1089: END log;
1090: --------------------------------------------------------------------------------
1091: PROCEDURE DELETE_FACTS_PRC_DTL IS
1092: l_module VARCHAR2(1000) := g_module||'DELETE_FACTS_PRC_DTL';

Line 1131: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_err_buff);

1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: g_err_code := SQLCODE;
1130: g_err_buff := l_module||' - When others error: '||SQLERRM;
1131: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_err_buff);
1132: END DELETE_FACTS_PRC_DTL;
1133: --------------------------------------------------------------------------------
1134: BEGIN
1135: g_module := 'fv.plsql.FV_GTAS_AGENCY_ID_UPGRADE.';