DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_DISTRIBUTIONS

Line 979: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);

975:
976: EXIT WHEN fee_account_lines%NOTFOUND ;
977:
978: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
979: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);
980: END IF;
981:
982: Insert into lns_distributions
983: (DISTRIBUTION_ID

Line 982: Insert into lns_distributions

978: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
979: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);
980: END IF;
981:
982: Insert into lns_distributions
983: (DISTRIBUTION_ID
984: ,LOAN_ID
985: ,LINE_TYPE
986: ,ACCOUNT_NAME

Line 998: (LNS_DISTRIBUTIONS_S.nextval

994: ,LAST_UPDATE_DATE
995: ,LAST_UPDATED_BY
996: ,OBJECT_VERSION_NUMBER )
997: values
998: (LNS_DISTRIBUTIONS_S.nextval
999: ,p_loan_id
1000: ,l_line_type
1001: ,l_account_name
1002: ,l_code_combination_id

Line 1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_FEE_ASSIGNMENT procedure: After inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);

1010: ,lns_utility_pub.last_updated_by
1011: ,1) ;
1012:
1013: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_FEE_ASSIGNMENT procedure: After inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);
1015: END IF;
1016:
1017: END LOOP ;
1018:

Line 1098: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs

1094: SELECT 'Y'
1095: FROM DUAL
1096: WHERE
1097: EXISTS
1098: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs
1099: WHERE lnsDistribs.ACCOUNT_NAME = 'FEE_RECEIVABLE' AND lnsDistribs.LOAN_ID = c_loan_id);
1100:
1101:
1102: l_fee_assignment_rec fee_assignment_rec_type ;

Line 1216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_DISB_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);

1212: /* Only one set of fee account lines of type 'FEE_RECEIVBALE' should be there */
1213: IF( l_loan_fee_acct_line_exists <> 'Y' OR l_account_name <> 'FEE_RECEIVABLE') THEN
1214:
1215: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_DISB_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);
1217: END IF;
1218:
1219: Insert into lns_distributions
1220: (DISTRIBUTION_ID

Line 1219: Insert into lns_distributions

1215: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_DISB_FEE_ASSIGNMENT procedure: Before inserting to lns_distributions record for accountint name '||l_account_name || ' and code comb id ' || l_code_combination_id);
1217: END IF;
1218:
1219: Insert into lns_distributions
1220: (DISTRIBUTION_ID
1221: ,LOAN_ID
1222: ,LINE_TYPE
1223: ,ACCOUNT_NAME

Line 1235: (LNS_DISTRIBUTIONS_S.nextval

1231: ,LAST_UPDATE_DATE
1232: ,LAST_UPDATED_BY
1233: ,OBJECT_VERSION_NUMBER )
1234: values
1235: (LNS_DISTRIBUTIONS_S.nextval
1236: ,p_loan_id
1237: ,l_line_type
1238: ,l_account_name
1239: ,l_code_combination_id

Line 1251: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_DISB_FEE_ASSIGNMENT procedure: After inserting to lns_distributions record for accounting name '||l_account_name || ' and code comb id ' || l_code_combination_id);

1247: ,lns_utility_pub.last_updated_by
1248: ,1) ;
1249:
1250: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1251: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_DISB_FEE_ASSIGNMENT procedure: After inserting to lns_distributions record for accounting name '||l_account_name || ' and code comb id ' || l_code_combination_id);
1252: END IF;
1253:
1254:
1255: END IF;