APPS.FV_COPY_YE_RECORDS_PKG dependencies on FND_LOG

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

51: WHERE treasury_symbol = v_treasury_symbol_new
52: AND set_of_books_id = v_ledger_id;
53: END IF;
54:
55: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
57: 'INSERTING TO FV_YE_GROUPS');
58: END IF;
59: -- create fv_ye_groups record for new record.

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

52: AND set_of_books_id = v_ledger_id;
53: END IF;
54:
55: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
57: 'INSERTING TO FV_YE_GROUPS');
58: END IF;
59: -- create fv_ye_groups record for new record.
60: INSERT INTO fv_ye_groups

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

84:
85: -- create sequences for group_id processing.
86: FOR c_sequences_rec IN c_sequences LOOP
87:
88: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
90: 'SEQUENCE = '||C_SEQUENCES_REC.SEQUENCE);
91: END IF;
92: SELECT fv_ye_group_sequences_s.NEXTVAL

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

85: -- create sequences for group_id processing.
86: FOR c_sequences_rec IN c_sequences LOOP
87:
88: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
90: 'SEQUENCE = '||C_SEQUENCES_REC.SEQUENCE);
91: END IF;
92: SELECT fv_ye_group_sequences_s.NEXTVAL
93: INTO v_sequence_id

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

116:
117: -- create account records for the sequence processing.
118: FOR c_accounts_rec IN c_accounts(c_sequences_rec.sequence_id) LOOP
119:
120: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
121: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
122: 'ACCT_ID ='||C_ACCOUNTS_REC.SEQUENCE_ACCT_ID);
123: END IF;
124: INSERT INTO fv_ye_sequence_accounts

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

117: -- create account records for the sequence processing.
118: FOR c_accounts_rec IN c_accounts(c_sequences_rec.sequence_id) LOOP
119:
120: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
121: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
122: 'ACCT_ID ='||C_ACCOUNTS_REC.SEQUENCE_ACCT_ID);
123: END IF;
124: INSERT INTO fv_ye_sequence_accounts
125: (sequence_id,

Line 159: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,l_errbuff);

155: COMMIT;
156: EXCEPTION
157: WHEN OTHERS THEN
158: l_errbuff := SQLERRM;
159: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,l_errbuff);
160: END copy_record;
161: END fv_copy_ye_records_pkg;
162: