[Home] [Help]
1269:
1270: IF (p_retcode = g_SUCCESS) THEN
1271: BEGIN
1272: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
1273: debug(l_module_name,'Insert fv_ar_fin_chrg_inv_lines');
1274: END IF;
1275: INSERT INTO fv_ar_fin_chrg_inv_lines
1276: (
1277: org_id,
1271: BEGIN
1272: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
1273: debug(l_module_name,'Insert fv_ar_fin_chrg_inv_lines');
1274: END IF;
1275: INSERT INTO fv_ar_fin_chrg_inv_lines
1276: (
1277: org_id,
1278: customer_id,
1279: invoice_id,
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: p_retcode := g_FAILURE;
1313: p_errbuf := SQLERRM;
1314: l_location := l_module_name||'.insert_fv_ar_fin_chrg_inv_lines';
1315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1317: END;
1318: END IF;