DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_DISTRIBUTIONS

Line 1017: 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);

1013:
1014: EXIT WHEN fee_account_lines%NOTFOUND ;
1015:
1016: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1017: 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);
1018: END IF;
1019:
1020: Insert into lns_distributions
1021: (DISTRIBUTION_ID

Line 1020: Insert into lns_distributions

1016: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1017: 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);
1018: END IF;
1019:
1020: Insert into lns_distributions
1021: (DISTRIBUTION_ID
1022: ,LOAN_ID
1023: ,LINE_TYPE
1024: ,ACCOUNT_NAME

Line 1036: (LNS_DISTRIBUTIONS_S.nextval

1032: ,LAST_UPDATE_DATE
1033: ,LAST_UPDATED_BY
1034: ,OBJECT_VERSION_NUMBER )
1035: values
1036: (LNS_DISTRIBUTIONS_S.nextval
1037: ,p_loan_id
1038: ,l_line_type
1039: ,l_account_name
1040: ,l_code_combination_id

Line 1052: 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);

1048: ,lns_utility_pub.last_updated_by
1049: ,1) ;
1050:
1051: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1052: 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);
1053: END IF;
1054:
1055: END LOOP ;
1056:

Line 1141: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs

1137: SELECT 'Y'
1138: FROM DUAL
1139: WHERE
1140: EXISTS
1141: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs
1142: WHERE lnsDistribs.ACCOUNT_NAME = 'FEE_RECEIVABLE' AND lnsDistribs.LOAN_ID = c_loan_id);
1143:
1144:
1145: l_fee_assignment_rec fee_assignment_rec_type ;

Line 1258: 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);

1254: /* Only one set of fee account lines of type 'FEE_RECEIVBALE' should be there */
1255: IF( l_loan_fee_acct_line_exists <> 'Y' OR l_account_name <> 'FEE_RECEIVABLE') THEN
1256:
1257: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1258: 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);
1259: END IF;
1260:
1261: Insert into lns_distributions
1262: (DISTRIBUTION_ID

Line 1261: Insert into lns_distributions

1257: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1258: 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);
1259: END IF;
1260:
1261: Insert into lns_distributions
1262: (DISTRIBUTION_ID
1263: ,LOAN_ID
1264: ,LINE_TYPE
1265: ,ACCOUNT_NAME

Line 1278: (LNS_DISTRIBUTIONS_S.nextval

1274: ,LAST_UPDATED_BY
1275: ,OBJECT_VERSION_NUMBER
1276: ,DISB_HEADER_ID )
1277: values
1278: (LNS_DISTRIBUTIONS_S.nextval
1279: ,p_loan_id
1280: ,l_line_type
1281: ,l_account_name
1282: ,l_code_combination_id

Line 1295: 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);

1291: ,1
1292: ,p_disb_header_id) ;
1293:
1294: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1295: 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);
1296: END IF;
1297:
1298: END IF;
1299: