APPS.FV_COPY_YE_RECORDS_PKG dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

149: COMMIT;
150: EXCEPTION
151: WHEN OTHERS THEN
152: l_errbuff := SQLERRM;
153: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,l_errbuff);
154: END copy_record;
155: END fv_copy_ye_records_pkg;