eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PROC_BATCHES_PKG dependencies on FND_LOG

Line 694: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

690: AND start_date = p_start_date
691: AND end_date = p_end_date);
692: EXCEPTION
693: WHEN OTHERS THEN
694: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
695: fnd_log.STRING(
696: fnd_log.level_unexpected
697: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.loop'
698: , SQLERRM

Line 695: fnd_log.STRING(

691: AND end_date = p_end_date);
692: EXCEPTION
693: WHEN OTHERS THEN
694: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
695: fnd_log.STRING(
696: fnd_log.level_unexpected
697: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.loop'
698: , SQLERRM
699: );

Line 696: fnd_log.level_unexpected

692: EXCEPTION
693: WHEN OTHERS THEN
694: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
695: fnd_log.STRING(
696: fnd_log.level_unexpected
697: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.loop'
698: , SQLERRM
699: );
700: END IF;

Line 785: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

781: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_calcsub_batch: ' || SQLERRM);
782: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.populate_calcsub_batch:');
783: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
784:
785: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
786: fnd_log.STRING(
787: fnd_log.level_unexpected
788: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.exception'
789: , SQLERRM

Line 786: fnd_log.STRING(

782: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.populate_calcsub_batch:');
783: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
784:
785: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
786: fnd_log.STRING(
787: fnd_log.level_unexpected
788: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.exception'
789: , SQLERRM
790: );

Line 787: fnd_log.level_unexpected

783: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
784:
785: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
786: fnd_log.STRING(
787: fnd_log.level_unexpected
788: , 'cn.plsql.cn_proc_batches_pkg.populate_calcsub_batches.exception'
789: , SQLERRM
790: );
791: END IF;

Line 1110: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1106: RETURN TRUE;
1107: END IF;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1111: fnd_log.STRING(
1112: fnd_log.level_unexpected
1113: , 'cn.plsql.cn_proc_batches_pkg.find_srp_incomplete_plan.exception'
1114: , SQLERRM

Line 1111: fnd_log.STRING(

1107: END IF;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1111: fnd_log.STRING(
1112: fnd_log.level_unexpected
1113: , 'cn.plsql.cn_proc_batches_pkg.find_srp_incomplete_plan.exception'
1114: , SQLERRM
1115: );

Line 1112: fnd_log.level_unexpected

1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1111: fnd_log.STRING(
1112: fnd_log.level_unexpected
1113: , 'cn.plsql.cn_proc_batches_pkg.find_srp_incomplete_plan.exception'
1114: , SQLERRM
1115: );
1116: END IF;

Line 1248: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1244:
1245: IF l_counter = 0 THEN /* no one to be calculated */
1246: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1247:
1248: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1249: fnd_log.MESSAGE(
1250: fnd_log.level_exception
1251: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.all_reps'
1252: , FALSE

Line 1249: fnd_log.MESSAGE(

1245: IF l_counter = 0 THEN /* no one to be calculated */
1246: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1247:
1248: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1249: fnd_log.MESSAGE(
1250: fnd_log.level_exception
1251: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.all_reps'
1252: , FALSE
1253: );

Line 1250: fnd_log.level_exception

1246: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1247:
1248: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1249: fnd_log.MESSAGE(
1250: fnd_log.level_exception
1251: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.all_reps'
1252: , FALSE
1253: );
1254: END IF;

Line 1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1340:
1341: IF l_counter = 0 THEN /* no one to be calculated */
1342: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1343:
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.MESSAGE(
1346: fnd_log.level_exception
1347: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.user_specify'
1348: , FALSE

Line 1345: fnd_log.MESSAGE(

1341: IF l_counter = 0 THEN /* no one to be calculated */
1342: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1343:
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.MESSAGE(
1346: fnd_log.level_exception
1347: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.user_specify'
1348: , FALSE
1349: );

Line 1346: fnd_log.level_exception

1342: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_CALCULATE');
1343:
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.MESSAGE(
1346: fnd_log.level_exception
1347: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.user_specify'
1348: , FALSE
1349: );
1350: END IF;

Line 1536: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1532: --fnd_message.set_name('CN', 'CNSBCS_NO_ONE_IN_NOTIFY_LOG');
1533: --raise no_one_with_complete_plan;
1534: -- clku, bug 2783261, we won;t error out if we do not find any reps in
1535: -- notify log, we just set status to complete and return
1536: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1537: fnd_log.STRING
1538: (
1539: fnd_log.level_exception
1540: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.reps_in_notify_log'

Line 1537: fnd_log.STRING

1533: --raise no_one_with_complete_plan;
1534: -- clku, bug 2783261, we won;t error out if we do not find any reps in
1535: -- notify log, we just set status to complete and return
1536: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1537: fnd_log.STRING
1538: (
1539: fnd_log.level_exception
1540: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.reps_in_notify_log'
1541: , 'No salesreps to calculate ...'

Line 1539: fnd_log.level_exception

1535: -- notify log, we just set status to complete and return
1536: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1537: fnd_log.STRING
1538: (
1539: fnd_log.level_exception
1540: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batches.reps_in_notify_log'
1541: , 'No salesreps to calculate ...'
1542: );
1543: END IF;

Line 1563: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1559: RAISE;
1560: WHEN OTHERS THEN
1561: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_process_batch:' || SQLERRM);
1562:
1563: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1564: fnd_log.STRING(
1565: fnd_log.level_unexpected
1566: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batch.exception'
1567: , SQLERRM

Line 1564: fnd_log.STRING(

1560: WHEN OTHERS THEN
1561: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_process_batch:' || SQLERRM);
1562:
1563: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1564: fnd_log.STRING(
1565: fnd_log.level_unexpected
1566: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batch.exception'
1567: , SQLERRM
1568: );

Line 1565: fnd_log.level_unexpected

1561: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches_pkg.populate_process_batch:' || SQLERRM);
1562:
1563: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1564: fnd_log.STRING(
1565: fnd_log.level_unexpected
1566: , 'cn.plsql.cn_proc_batches_pkg.populate_process_batch.exception'
1567: , SQLERRM
1568: );
1569: END IF;

Line 1601: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1597:
1598: l_batch_rec l_calc_batch_csr%ROWTYPE;
1599: l_status cn_calc_submission_batches.status%TYPE;
1600: BEGIN
1601: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1602: fnd_log.STRING(
1603: fnd_log.level_procedure
1604: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.begin'
1605: , 'Beginning of calculation submission procedure ...'

Line 1602: fnd_log.STRING(

1598: l_batch_rec l_calc_batch_csr%ROWTYPE;
1599: l_status cn_calc_submission_batches.status%TYPE;
1600: BEGIN
1601: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1602: fnd_log.STRING(
1603: fnd_log.level_procedure
1604: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.begin'
1605: , 'Beginning of calculation submission procedure ...'
1606: );

Line 1603: fnd_log.level_procedure

1599: l_status cn_calc_submission_batches.status%TYPE;
1600: BEGIN
1601: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1602: fnd_log.STRING(
1603: fnd_log.level_procedure
1604: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.begin'
1605: , 'Beginning of calculation submission procedure ...'
1606: );
1607: END IF;

Line 1684: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1680: cn_message_pkg.end_batch(x_process_audit_id);
1681: END IF;
1682: END IF;
1683:
1684: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1685: fnd_log.STRING(
1686: fnd_log.level_procedure
1687: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.end'
1688: , 'End of calculation submission procedure.'

Line 1685: fnd_log.STRING(

1681: END IF;
1682: END IF;
1683:
1684: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1685: fnd_log.STRING(
1686: fnd_log.level_procedure
1687: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.end'
1688: , 'End of calculation submission procedure.'
1689: );

Line 1686: fnd_log.level_procedure

1682: END IF;
1683:
1684: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1685: fnd_log.STRING(
1686: fnd_log.level_procedure
1687: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.end'
1688: , 'End of calculation submission procedure.'
1689: );
1690: END IF;

Line 1713: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1709: cn_message_pkg.rollback_errormsg_commit(SQLERRM);
1710: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
1711: COMMIT;
1712:
1713: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1714: fnd_log.STRING(
1715: fnd_log.level_unexpected
1716: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.exception'
1717: , SQLERRM

Line 1714: fnd_log.STRING(

1710: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
1711: COMMIT;
1712:
1713: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1714: fnd_log.STRING(
1715: fnd_log.level_unexpected
1716: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.exception'
1717: , SQLERRM
1718: );

Line 1715: fnd_log.level_unexpected

1711: COMMIT;
1712:
1713: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1714: fnd_log.STRING(
1715: fnd_log.level_unexpected
1716: , 'cn.plsql.cn_proc_batches_pkg.calculation_submission.exception'
1717: , SQLERRM
1718: );
1719: END IF;

Line 1736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1732:
1733: RETURN x_physical_batch_id;
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1737: fnd_log.STRING(
1738: fnd_log.level_unexpected
1739: , 'cn.plsql.cn_proc_batches_pkg.get_physical_batch_id.exception'
1740: , SQLERRM

Line 1737: fnd_log.STRING(

1733: RETURN x_physical_batch_id;
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1737: fnd_log.STRING(
1738: fnd_log.level_unexpected
1739: , 'cn.plsql.cn_proc_batches_pkg.get_physical_batch_id.exception'
1740: , SQLERRM
1741: );

Line 1738: fnd_log.level_unexpected

1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1737: fnd_log.STRING(
1738: fnd_log.level_unexpected
1739: , 'cn.plsql.cn_proc_batches_pkg.get_physical_batch_id.exception'
1740: , SQLERRM
1741: );
1742: END IF;

Line 1877: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1873: AND LOG.status = 'INCOMPLETE'
1874: AND LOG.action_link_id IS NOT NULL
1875: AND LOG.org_id = batch.org_id;
1876: BEGIN
1877: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1878: fnd_log.STRING(
1879: fnd_log.level_procedure
1880: , 'cn.plsql.cn_proc_batches_pkg.assign.begin'
1881: , 'Beginning of assigning resources to physical batches ...'

Line 1878: fnd_log.STRING(

1874: AND LOG.action_link_id IS NOT NULL
1875: AND LOG.org_id = batch.org_id;
1876: BEGIN
1877: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1878: fnd_log.STRING(
1879: fnd_log.level_procedure
1880: , 'cn.plsql.cn_proc_batches_pkg.assign.begin'
1881: , 'Beginning of assigning resources to physical batches ...'
1882: );

Line 1879: fnd_log.level_procedure

1875: AND LOG.org_id = batch.org_id;
1876: BEGIN
1877: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1878: fnd_log.STRING(
1879: fnd_log.level_procedure
1880: , 'cn.plsql.cn_proc_batches_pkg.assign.begin'
1881: , 'Beginning of assigning resources to physical batches ...'
1882: );
1883: END IF;

Line 1960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1956:
1957: IF (reps_tbl.COUNT = 0) THEN
1958: cn_message_pkg.set_name('CN', 'PROC_NO_TRX_TO_PROCESS');
1959:
1960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1961: fnd_log.STRING(
1962: fnd_log.level_exception
1963: , 'cn.plsql.cn_proc_batches_pkg.assign.reps_count'
1964: , 'No salesreps to process.'

Line 1961: fnd_log.STRING(

1957: IF (reps_tbl.COUNT = 0) THEN
1958: cn_message_pkg.set_name('CN', 'PROC_NO_TRX_TO_PROCESS');
1959:
1960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1961: fnd_log.STRING(
1962: fnd_log.level_exception
1963: , 'cn.plsql.cn_proc_batches_pkg.assign.reps_count'
1964: , 'No salesreps to process.'
1965: );

Line 1962: fnd_log.level_exception

1958: cn_message_pkg.set_name('CN', 'PROC_NO_TRX_TO_PROCESS');
1959:
1960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1961: fnd_log.STRING(
1962: fnd_log.level_exception
1963: , 'cn.plsql.cn_proc_batches_pkg.assign.reps_count'
1964: , 'No salesreps to process.'
1965: );
1966: END IF;

Line 2044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2040: WHERE action_link_id = action_link.action_link_id AND status = 'INCOMPLETE';
2041: END LOOP;
2042: END IF;
2043:
2044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2045: fnd_log.STRING(
2046: fnd_log.level_procedure
2047: , 'cn.plsql.cn_proc_batches_pkg.assign.end'
2048: , 'Finish assigning resources to physical batches.'

Line 2045: fnd_log.STRING(

2041: END LOOP;
2042: END IF;
2043:
2044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2045: fnd_log.STRING(
2046: fnd_log.level_procedure
2047: , 'cn.plsql.cn_proc_batches_pkg.assign.end'
2048: , 'Finish assigning resources to physical batches.'
2049: );

Line 2046: fnd_log.level_procedure

2042: END IF;
2043:
2044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2045: fnd_log.STRING(
2046: fnd_log.level_procedure
2047: , 'cn.plsql.cn_proc_batches_pkg.assign.end'
2048: , 'Finish assigning resources to physical batches.'
2049: );
2050: END IF;

Line 2062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2058: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches_pkg.assign:');
2059: cn_message_pkg.DEBUG('No transactions to process.');
2060: RAISE;
2061: WHEN OTHERS THEN
2062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2063: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.assign.exception'
2064: , SQLERRM);
2065: END IF;
2066:

Line 2063: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.assign.exception'

2059: cn_message_pkg.DEBUG('No transactions to process.');
2060: RAISE;
2061: WHEN OTHERS THEN
2062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2063: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.assign.exception'
2064: , SQLERRM);
2065: END IF;
2066:
2067: fnd_file.put_line(fnd_file.LOG, 'In cn_proc_batches.assign: ' || SQLERRM);

Line 2119: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

2115: , argument4 => x_physical_batch_id
2116: );
2117:
2118: IF (x_request_id = 0 OR x_request_id IS NULL) THEN
2119: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2120: fnd_log.STRING(
2121: fnd_log.level_error
2122: , 'cn.plsql.cn_proc_batches_pkg.conc_submit.submission_status'
2123: , 'Submission failure for batch: ' || x_physical_batch_id

Line 2120: fnd_log.STRING(

2116: );
2117:
2118: IF (x_request_id = 0 OR x_request_id IS NULL) THEN
2119: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2120: fnd_log.STRING(
2121: fnd_log.level_error
2122: , 'cn.plsql.cn_proc_batches_pkg.conc_submit.submission_status'
2123: , 'Submission failure for batch: ' || x_physical_batch_id
2124: );

Line 2121: fnd_log.level_error

2117:
2118: IF (x_request_id = 0 OR x_request_id IS NULL) THEN
2119: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2120: fnd_log.STRING(
2121: fnd_log.level_error
2122: , 'cn.plsql.cn_proc_batches_pkg.conc_submit.submission_status'
2123: , 'Submission failure for batch: ' || x_physical_batch_id
2124: );
2125: END IF;

Line 2197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2193: l_end_date DATE;
2194: l_payee_count NUMBER;
2195: l_new_request_submitted BOOLEAN;
2196: BEGIN
2197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2198: fnd_log.STRING(
2199: fnd_log.level_procedure
2200: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.begin'
2201: , 'Beginning of conc_dispatch...'

Line 2198: fnd_log.STRING(

2194: l_payee_count NUMBER;
2195: l_new_request_submitted BOOLEAN;
2196: BEGIN
2197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2198: fnd_log.STRING(
2199: fnd_log.level_procedure
2200: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.begin'
2201: , 'Beginning of conc_dispatch...'
2202: );

Line 2199: fnd_log.level_procedure

2195: l_new_request_submitted BOOLEAN;
2196: BEGIN
2197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2198: fnd_log.STRING(
2199: fnd_log.level_procedure
2200: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.begin'
2201: , 'Beginning of conc_dispatch...'
2202: );
2203: END IF;

Line 2339: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2335: IF (NOT l_call_status) THEN
2336: l_failed_request_id := l_primary_request_stack(primary_ptr);
2337: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2338:
2339: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2340: fnd_log.STRING(
2341: fnd_log.level_unexpected
2342: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2343: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id

Line 2340: fnd_log.STRING(

2336: l_failed_request_id := l_primary_request_stack(primary_ptr);
2337: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2338:
2339: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2340: fnd_log.STRING(
2341: fnd_log.level_unexpected
2342: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2343: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id
2344: );

Line 2341: fnd_log.level_unexpected

2337: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2338:
2339: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2340: fnd_log.STRING(
2341: fnd_log.level_unexpected
2342: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2343: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id
2344: );
2345: END IF;

Line 2381: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

2377:
2378: IF l_dev_status IN('ERROR', 'TERMINATING', 'TERMINATED', 'DELETED') THEN
2379: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2380:
2381: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2382: fnd_log.STRING(
2383: fnd_log.level_error
2384: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2385: , 'Request ' || l_failed_request_id || ' failed (batch_id = '

Line 2382: fnd_log.STRING(

2378: IF l_dev_status IN('ERROR', 'TERMINATING', 'TERMINATED', 'DELETED') THEN
2379: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2380:
2381: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2382: fnd_log.STRING(
2383: fnd_log.level_error
2384: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2385: , 'Request ' || l_failed_request_id || ' failed (batch_id = '
2386: || l_temp_phys_batch_id

Line 2383: fnd_log.level_error

2379: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2380:
2381: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2382: fnd_log.STRING(
2383: fnd_log.level_error
2384: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.request_status'
2385: , 'Request ' || l_failed_request_id || ' failed (batch_id = '
2386: || l_temp_phys_batch_id
2387: );

Line 2483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2479: END IF; -- If request_id is null
2480: END LOOP; -- for primary_ptr in 1..x_batch_total
2481: END LOOP; -- while unfinished loop
2482:
2483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2484: fnd_log.STRING(
2485: fnd_log.level_procedure
2486: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.end'
2487: , 'End of conc_dispatch.'

Line 2484: fnd_log.STRING(

2480: END LOOP; -- for primary_ptr in 1..x_batch_total
2481: END LOOP; -- while unfinished loop
2482:
2483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2484: fnd_log.STRING(
2485: fnd_log.level_procedure
2486: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.end'
2487: , 'End of conc_dispatch.'
2488: );

Line 2485: fnd_log.level_procedure

2481: END LOOP; -- while unfinished loop
2482:
2483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2484: fnd_log.STRING(
2485: fnd_log.level_procedure
2486: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.end'
2487: , 'End of conc_dispatch.'
2488: );
2489: END IF;

Line 2499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

2495: -- canceling running/pending requests
2496: IF (l_primary_request_stack.COUNT > 0) THEN
2497: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2498: IF (l_primary_request_stack(i) > 0) THEN
2499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2500: fnd_log.STRING(
2501: fnd_log.level_exception
2502: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception'
2503: , 'Cancelling request: ' || l_primary_request_stack(i)

Line 2500: fnd_log.STRING(

2496: IF (l_primary_request_stack.COUNT > 0) THEN
2497: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2498: IF (l_primary_request_stack(i) > 0) THEN
2499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2500: fnd_log.STRING(
2501: fnd_log.level_exception
2502: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception'
2503: , 'Cancelling request: ' || l_primary_request_stack(i)
2504: );

Line 2501: fnd_log.level_exception

2497: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2498: IF (l_primary_request_stack(i) > 0) THEN
2499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2500: fnd_log.STRING(
2501: fnd_log.level_exception
2502: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception'
2503: , 'Cancelling request: ' || l_primary_request_stack(i)
2504: );
2505: END IF;

Line 2516: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2512: END IF;
2513:
2514: cn_message_pkg.end_batch(x_parent_proc_audit_id);
2515: WHEN OTHERS THEN
2516: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2517: fnd_log.STRING(fnd_log.level_unexpected
2518: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception', SQLERRM);
2519: END IF;
2520:

Line 2517: fnd_log.STRING(fnd_log.level_unexpected

2513:
2514: cn_message_pkg.end_batch(x_parent_proc_audit_id);
2515: WHEN OTHERS THEN
2516: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2517: fnd_log.STRING(fnd_log.level_unexpected
2518: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch.exception', SQLERRM);
2519: END IF;
2520:
2521: fnd_file.put_line(fnd_file.LOG, 'unexpected exception in cn_proc_batches_pkg.conc_dispatch');

Line 2612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2608: FROM cn_process_batches_all
2609: WHERE logical_batch_id = g_logical_batch_id
2610: ORDER BY physical_batch_id DESC;
2611: BEGIN
2612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2613: fnd_log.STRING(
2614: fnd_log.level_procedure
2615: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.begin'
2616: , 'Beginning of conc_dispatch2...'

Line 2613: fnd_log.STRING(

2609: WHERE logical_batch_id = g_logical_batch_id
2610: ORDER BY physical_batch_id DESC;
2611: BEGIN
2612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2613: fnd_log.STRING(
2614: fnd_log.level_procedure
2615: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.begin'
2616: , 'Beginning of conc_dispatch2...'
2617: );

Line 2614: fnd_log.level_procedure

2610: ORDER BY physical_batch_id DESC;
2611: BEGIN
2612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2613: fnd_log.STRING(
2614: fnd_log.level_procedure
2615: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.begin'
2616: , 'Beginning of conc_dispatch2...'
2617: );
2618: END IF;

Line 2727: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2723: IF (NOT l_call_status) THEN
2724: l_failed_request_id := l_primary_request_stack(primary_ptr);
2725: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2726:
2727: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2728: fnd_log.STRING(
2729: fnd_log.level_unexpected
2730: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2731: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id

Line 2728: fnd_log.STRING(

2724: l_failed_request_id := l_primary_request_stack(primary_ptr);
2725: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2726:
2727: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2728: fnd_log.STRING(
2729: fnd_log.level_unexpected
2730: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2731: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id
2732: );

Line 2729: fnd_log.level_unexpected

2725: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2726:
2727: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2728: fnd_log.STRING(
2729: fnd_log.level_unexpected
2730: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2731: , 'Request ' || l_failed_request_id || ' failed (batch_id = ' || l_temp_phys_batch_id
2732: );
2733: END IF;

Line 2777: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

2773:
2774: IF l_dev_status IN('ERROR', 'TERMINATING', 'TERMINATED', 'DELETED') THEN
2775: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2776:
2777: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2778: fnd_log.STRING(
2779: fnd_log.level_error
2780: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2781: , 'Request ' || l_failed_request_id || ' failed (batch_id = '

Line 2778: fnd_log.STRING(

2774: IF l_dev_status IN('ERROR', 'TERMINATING', 'TERMINATED', 'DELETED') THEN
2775: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2776:
2777: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2778: fnd_log.STRING(
2779: fnd_log.level_error
2780: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2781: , 'Request ' || l_failed_request_id || ' failed (batch_id = '
2782: || l_temp_phys_batch_id

Line 2779: fnd_log.level_error

2775: l_temp_phys_batch_id := l_primary_batch_stack(primary_ptr);
2776:
2777: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2778: fnd_log.STRING(
2779: fnd_log.level_error
2780: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.request_status'
2781: , 'Request ' || l_failed_request_id || ' failed (batch_id = '
2782: || l_temp_phys_batch_id
2783: );

Line 2924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2920: END IF;
2921:
2922: END LOOP;
2923:
2924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2925: fnd_log.STRING(
2926: fnd_log.level_procedure
2927: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.end'
2928: , 'End of conc_dispatch.'

Line 2925: fnd_log.STRING(

2921:
2922: END LOOP;
2923:
2924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2925: fnd_log.STRING(
2926: fnd_log.level_procedure
2927: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.end'
2928: , 'End of conc_dispatch.'
2929: );

Line 2926: fnd_log.level_procedure

2922: END LOOP;
2923:
2924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2925: fnd_log.STRING(
2926: fnd_log.level_procedure
2927: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.end'
2928: , 'End of conc_dispatch.'
2929: );
2930: END IF;

Line 2940: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

2936: -- canceling running/pending requests
2937: IF (l_primary_request_stack.COUNT > 0) THEN
2938: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2939: IF (l_primary_request_stack(i) > 0) THEN
2940: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2941: fnd_log.STRING(
2942: fnd_log.level_exception
2943: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2944: , 'Cancelling request: ' || l_primary_request_stack(i)

Line 2941: fnd_log.STRING(

2937: IF (l_primary_request_stack.COUNT > 0) THEN
2938: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2939: IF (l_primary_request_stack(i) > 0) THEN
2940: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2941: fnd_log.STRING(
2942: fnd_log.level_exception
2943: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2944: , 'Cancelling request: ' || l_primary_request_stack(i)
2945: );

Line 2942: fnd_log.level_exception

2938: FOR i IN l_primary_request_stack.FIRST .. l_primary_request_stack.LAST LOOP
2939: IF (l_primary_request_stack(i) > 0) THEN
2940: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2941: fnd_log.STRING(
2942: fnd_log.level_exception
2943: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2944: , 'Cancelling request: ' || l_primary_request_stack(i)
2945: );
2946: END IF;

Line 2961: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2957: cn_message_pkg.DEBUG('Concurrent request failed (physical batch ID=' || l_temp_phys_batch_id
2958: || ')');
2959: cn_message_pkg.end_batch(x_parent_proc_audit_id);
2960: WHEN OTHERS THEN
2961: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2962: fnd_log.STRING(
2963: fnd_log.level_unexpected
2964: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2965: , SQLERRM

Line 2962: fnd_log.STRING(

2958: || ')');
2959: cn_message_pkg.end_batch(x_parent_proc_audit_id);
2960: WHEN OTHERS THEN
2961: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2962: fnd_log.STRING(
2963: fnd_log.level_unexpected
2964: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2965: , SQLERRM
2966: );

Line 2963: fnd_log.level_unexpected

2959: cn_message_pkg.end_batch(x_parent_proc_audit_id);
2960: WHEN OTHERS THEN
2961: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2962: fnd_log.STRING(
2963: fnd_log.level_unexpected
2964: , 'cn.plsql.cn_proc_batches_pkg.conc_dispatch2.exception'
2965: , SQLERRM
2966: );
2967: END IF;

Line 2999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2995: SELECT COUNT(DISTINCT physical_batch_id)
2996: FROM cn_process_batches_all
2997: WHERE logical_batch_id = g_logical_batch_id AND status_code = 'IN_USE';
2998: BEGIN
2999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3000: fnd_log.STRING(
3001: fnd_log.level_procedure
3002: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.begin'
3003: , 'Beginning of seq_dispatch...'

Line 3000: fnd_log.STRING(

2996: FROM cn_process_batches_all
2997: WHERE logical_batch_id = g_logical_batch_id AND status_code = 'IN_USE';
2998: BEGIN
2999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3000: fnd_log.STRING(
3001: fnd_log.level_procedure
3002: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.begin'
3003: , 'Beginning of seq_dispatch...'
3004: );

Line 3001: fnd_log.level_procedure

2997: WHERE logical_batch_id = g_logical_batch_id AND status_code = 'IN_USE';
2998: BEGIN
2999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3000: fnd_log.STRING(
3001: fnd_log.level_procedure
3002: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.begin'
3003: , 'Beginning of seq_dispatch...'
3004: );
3005: END IF;

Line 3055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3051: finished := TRUE;
3052: END IF;
3053: END LOOP;
3054:
3055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3056: fnd_log.STRING(
3057: fnd_log.level_procedure
3058: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.end'
3059: , 'End of seq_dispatch.'

Line 3056: fnd_log.STRING(

3052: END IF;
3053: END LOOP;
3054:
3055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3056: fnd_log.STRING(
3057: fnd_log.level_procedure
3058: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.end'
3059: , 'End of seq_dispatch.'
3060: );

Line 3057: fnd_log.level_procedure

3053: END LOOP;
3054:
3055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3056: fnd_log.STRING(
3057: fnd_log.level_procedure
3058: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.end'
3059: , 'End of seq_dispatch.'
3060: );
3061: END IF;

Line 3064: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3060: );
3061: END IF;
3062: EXCEPTION
3063: WHEN OTHERS THEN
3064: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3065: fnd_log.STRING(fnd_log.level_unexpected
3066: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.exception', SQLERRM);
3067: END IF;
3068:

Line 3065: fnd_log.STRING(fnd_log.level_unexpected

3061: END IF;
3062: EXCEPTION
3063: WHEN OTHERS THEN
3064: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3065: fnd_log.STRING(fnd_log.level_unexpected
3066: , 'cn.plsql.cn_proc_batches_pkg.seq_dispatch.exception', SQLERRM);
3067: END IF;
3068:
3069: cn_message_pkg.DEBUG('Exception occurs in cn_proc_batches.seq_dispatch:');

Line 3090: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3086: l_org_id NUMBER;
3087: BEGIN
3088: retcode := 0; -- success = 0, warning = 1, fail = 2
3089:
3090: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3091: fnd_log.STRING(
3092: fnd_log.level_procedure
3093: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.begin'
3094: , 'Beginning of calculate_batch...'

Line 3091: fnd_log.STRING(

3087: BEGIN
3088: retcode := 0; -- success = 0, warning = 1, fail = 2
3089:
3090: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3091: fnd_log.STRING(
3092: fnd_log.level_procedure
3093: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.begin'
3094: , 'Beginning of calculate_batch...'
3095: );

Line 3092: fnd_log.level_procedure

3088: retcode := 0; -- success = 0, warning = 1, fail = 2
3089:
3090: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3091: fnd_log.STRING(
3092: fnd_log.level_procedure
3093: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.begin'
3094: , 'Beginning of calculate_batch...'
3095: );
3096: END IF;

Line 3140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3136: retcode := 2;
3137: errbuf := l_msg_data;
3138: END IF;
3139:
3140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3141: fnd_log.STRING(
3142: fnd_log.level_procedure
3143: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.end'
3144: , 'End of calculate_batch.'

Line 3141: fnd_log.STRING(

3137: errbuf := l_msg_data;
3138: END IF;
3139:
3140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3141: fnd_log.STRING(
3142: fnd_log.level_procedure
3143: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.end'
3144: , 'End of calculate_batch.'
3145: );

Line 3142: fnd_log.level_procedure

3138: END IF;
3139:
3140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3141: fnd_log.STRING(
3142: fnd_log.level_procedure
3143: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.end'
3144: , 'End of calculate_batch.'
3145: );
3146: END IF;

Line 3156: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3152: WHEN OTHERS THEN
3153: retcode := 2;
3154: errbuf := SQLERRM;
3155:
3156: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3157: fnd_log.STRING(
3158: fnd_log.level_unexpected
3159: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.exception'
3160: , SQLERRM

Line 3157: fnd_log.STRING(

3153: retcode := 2;
3154: errbuf := SQLERRM;
3155:
3156: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3157: fnd_log.STRING(
3158: fnd_log.level_unexpected
3159: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.exception'
3160: , SQLERRM
3161: );

Line 3158: fnd_log.level_unexpected

3154: errbuf := SQLERRM;
3155:
3156: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3157: fnd_log.STRING(
3158: fnd_log.level_unexpected
3159: , 'cn.plsql.cn_proc_batches_pkg.calculate_batch.exception'
3160: , SQLERRM
3161: );
3162: END IF;

Line 3212: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3208: WHERE NAME = p_batch_name AND org_id = l_org_id);
3209:
3210: l_incomplete_plan BOOLEAN := FALSE;
3211: BEGIN
3212: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3213: fnd_log.STRING(
3214: fnd_log.level_procedure
3215: , 'cn.plsql.cn_proc_batches_pkg.calc.begin'
3216: , 'Beginning of concurrent program calc ...'

Line 3213: fnd_log.STRING(

3209:
3210: l_incomplete_plan BOOLEAN := FALSE;
3211: BEGIN
3212: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3213: fnd_log.STRING(
3214: fnd_log.level_procedure
3215: , 'cn.plsql.cn_proc_batches_pkg.calc.begin'
3216: , 'Beginning of concurrent program calc ...'
3217: );

Line 3214: fnd_log.level_procedure

3210: l_incomplete_plan BOOLEAN := FALSE;
3211: BEGIN
3212: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3213: fnd_log.STRING(
3214: fnd_log.level_procedure
3215: , 'cn.plsql.cn_proc_batches_pkg.calc.begin'
3216: , 'Beginning of concurrent program calc ...'
3217: );
3218: END IF;

Line 3236: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3232: fnd_message.set_token('BATCH_NAME'
3233: , cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
3234: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3235:
3236: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3237: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3238: END IF;
3239:
3240: RAISE ABORT;

Line 3237: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);

3233: , cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
3234: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3235:
3236: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3237: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3238: END IF;
3239:
3240: RAISE ABORT;
3241: END IF;

Line 3250: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3246: IF p_start_date > p_end_date THEN
3247: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
3248: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3249:
3250: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3251: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3252: END IF;
3253:
3254: RAISE ABORT;

Line 3251: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);

3247: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
3248: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3249:
3250: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3251: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3252: END IF;
3253:
3254: RAISE ABORT;
3255: ELSE

Line 3264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3260: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');
3261: fnd_message.set_token('DATE', p_start_date);
3262: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3263:
3264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3265: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3266: END IF;
3267:
3268: RAISE ABORT;

Line 3265: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);

3261: fnd_message.set_token('DATE', p_start_date);
3262: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3263:
3264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3265: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3266: END IF;
3267:
3268: RAISE ABORT;
3269: END IF;

Line 3281: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3277: fnd_message.set_name('CN', 'CN_CALC_SUB_OPEN_DATE');
3278: fnd_message.set_token('DATE', p_end_date);
3279: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3280:
3281: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3282: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation'
3283: , TRUE);
3284: END IF;
3285:

Line 3282: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation'

3278: fnd_message.set_token('DATE', p_end_date);
3279: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3280:
3281: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3282: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation'
3283: , TRUE);
3284: END IF;
3285:
3286: RAISE ABORT;

Line 3296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3292: IF p_salesrep_option = 'USER_SPECIFY' AND p_salesrep_id IS NULL THEN
3293: fnd_message.set_name('CN', 'CN_CALC_NO_SALESREP');
3294: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3295:
3296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3297: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3298: END IF;
3299:
3300: RAISE ABORT;

Line 3297: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);

3293: fnd_message.set_name('CN', 'CN_CALC_NO_SALESREP');
3294: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
3295:
3296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3297: fnd_log.MESSAGE(fnd_log.level_error, 'cn.plsql.cn_proc_batches_pkg.calc.validation', TRUE);
3298: END IF;
3299:
3300: RAISE ABORT;
3301: END IF;

Line 3337: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN

3333: END IF;
3334:
3335: COMMIT;
3336:
3337: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3338: fnd_log.STRING(
3339: fnd_log.level_event
3340: , 'cn.plsql.cn_proc_batches_pkg.calc.submission'
3341: , 'Successfully created submission records.'

Line 3338: fnd_log.STRING(

3334:
3335: COMMIT;
3336:
3337: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3338: fnd_log.STRING(
3339: fnd_log.level_event
3340: , 'cn.plsql.cn_proc_batches_pkg.calc.submission'
3341: , 'Successfully created submission records.'
3342: );

Line 3339: fnd_log.level_event

3335: COMMIT;
3336:
3337: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3338: fnd_log.STRING(
3339: fnd_log.level_event
3340: , 'cn.plsql.cn_proc_batches_pkg.calc.submission'
3341: , 'Successfully created submission records.'
3342: );
3343: END IF;

Line 3362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3358: retcode := 2;
3359: errbuf := 'Calculation fails';
3360: END IF;
3361:
3362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3363: fnd_log.STRING(
3364: fnd_log.level_procedure
3365: , 'cn.plsql.cn_proc_batches_pkg.calc.end'
3366: , 'End of concurrent program calc.'

Line 3363: fnd_log.STRING(

3359: errbuf := 'Calculation fails';
3360: END IF;
3361:
3362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3363: fnd_log.STRING(
3364: fnd_log.level_procedure
3365: , 'cn.plsql.cn_proc_batches_pkg.calc.end'
3366: , 'End of concurrent program calc.'
3367: );

Line 3364: fnd_log.level_procedure

3360: END IF;
3361:
3362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3363: fnd_log.STRING(
3364: fnd_log.level_procedure
3365: , 'cn.plsql.cn_proc_batches_pkg.calc.end'
3366: , 'End of concurrent program calc.'
3367: );
3368: END IF;

Line 3486: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3482: l_period_type_id NUMBER;
3483: l_calc_from_period_id NUMBER;
3484: l_calc_to_period_id NUMBER;
3485: BEGIN
3486: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3487: fnd_log.STRING(
3488: fnd_log.level_procedure
3489: , 'cn.plsql.cn_proc_batches_pkg.runner.begin'
3490: , 'Beginning of batch runner '

Line 3487: fnd_log.STRING(

3483: l_calc_from_period_id NUMBER;
3484: l_calc_to_period_id NUMBER;
3485: BEGIN
3486: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3487: fnd_log.STRING(
3488: fnd_log.level_procedure
3489: , 'cn.plsql.cn_proc_batches_pkg.runner.begin'
3490: , 'Beginning of batch runner '
3491: || p_physical_batch_id

Line 3488: fnd_log.level_procedure

3484: l_calc_to_period_id NUMBER;
3485: BEGIN
3486: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3487: fnd_log.STRING(
3488: fnd_log.level_procedure
3489: , 'cn.plsql.cn_proc_batches_pkg.runner.begin'
3490: , 'Beginning of batch runner '
3491: || p_physical_batch_id
3492: || ' in the phase of '

Line 3682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3678:
3679: retcode := 0;
3680: errbuf := 'Batch runner completes successfully.';
3681:
3682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3683: fnd_log.STRING(
3684: fnd_log.level_procedure
3685: , 'cn.plsql.cn_proc_batches_pkg.runner.end'
3686: , 'End of batch runner '

Line 3683: fnd_log.STRING(

3679: retcode := 0;
3680: errbuf := 'Batch runner completes successfully.';
3681:
3682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3683: fnd_log.STRING(
3684: fnd_log.level_procedure
3685: , 'cn.plsql.cn_proc_batches_pkg.runner.end'
3686: , 'End of batch runner '
3687: || p_physical_batch_id

Line 3684: fnd_log.level_procedure

3680: errbuf := 'Batch runner completes successfully.';
3681:
3682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3683: fnd_log.STRING(
3684: fnd_log.level_procedure
3685: , 'cn.plsql.cn_proc_batches_pkg.runner.end'
3686: , 'End of batch runner '
3687: || p_physical_batch_id
3688: || 'at '

Line 3736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3732: ELSE
3733: COMMIT;
3734: END IF;
3735:
3736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3737: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.runner.exception'
3738: , SQLERRM);
3739: END IF;
3740: END runner;

Line 3737: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.runner.exception'

3733: COMMIT;
3734: END IF;
3735:
3736: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3737: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.runner.exception'
3738: , SQLERRM);
3739: END IF;
3740: END runner;
3741:

Line 3853: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3849:
3850: IF l_error_ctr = 1 THEN
3851: fnd_message.set_name('CN', 'PROC_CLS_PKG_MISSING');
3852:
3853: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3854: fnd_log.MESSAGE(
3855: fnd_log.level_error
3856: , 'cn.plsql.cn_proc_batches_pkg.validate_ruleset_status.validation'
3857: , TRUE

Line 3854: fnd_log.MESSAGE(

3850: IF l_error_ctr = 1 THEN
3851: fnd_message.set_name('CN', 'PROC_CLS_PKG_MISSING');
3852:
3853: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3854: fnd_log.MESSAGE(
3855: fnd_log.level_error
3856: , 'cn.plsql.cn_proc_batches_pkg.validate_ruleset_status.validation'
3857: , TRUE
3858: );

Line 3855: fnd_log.level_error

3851: fnd_message.set_name('CN', 'PROC_CLS_PKG_MISSING');
3852:
3853: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3854: fnd_log.MESSAGE(
3855: fnd_log.level_error
3856: , 'cn.plsql.cn_proc_batches_pkg.validate_ruleset_status.validation'
3857: , TRUE
3858: );
3859: END IF;

Line 3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN

3975:
3976: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');
3977: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_OK');
3978:
3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3980: fnd_log.MESSAGE(fnd_log.level_event, 'cn.plsql.cn_proc_batches_pkg.processor.event'
3981: , TRUE);
3982: END IF;
3983: EXCEPTION

Line 3980: fnd_log.MESSAGE(fnd_log.level_event, 'cn.plsql.cn_proc_batches_pkg.processor.event'

3976: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'COMPLETE');
3977: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_OK');
3978:
3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
3980: fnd_log.MESSAGE(fnd_log.level_event, 'cn.plsql.cn_proc_batches_pkg.processor.event'
3981: , TRUE);
3982: END IF;
3983: EXCEPTION
3984: WHEN NO_DATA_FOUND THEN

Line 3990: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

3986: errbuf := 'Completed with error. Please see the log file for details.';
3987: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
3988: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_FAIL');
3989:
3990: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3991: fnd_log.MESSAGE(fnd_log.level_error
3992: , 'cn.plsql.cn_proc_batches_pkg.processor.exception', TRUE);
3993: END IF;
3994: END;

Line 3991: fnd_log.MESSAGE(fnd_log.level_error

3987: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
3988: fnd_message.set_name('CN', 'ALL_PROCESS_DONE_FAIL');
3989:
3990: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
3991: fnd_log.MESSAGE(fnd_log.level_error
3992: , 'cn.plsql.cn_proc_batches_pkg.processor.exception', TRUE);
3993: END IF;
3994: END;
3995:

Line 4013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4009: cn_message_pkg.rollback_errormsg_commit(errbuf);
4010: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4011: cn_message_pkg.end_batch(l_paid);
4012:
4013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4014: fnd_log.STRING(fnd_log.level_unexpected
4015: , 'cn.plsql.cn_proc_batches_pkg.processor.exception', SQLERRM);
4016: END IF;
4017:

Line 4014: fnd_log.STRING(fnd_log.level_unexpected

4010: cn_calc_sub_batches_pkg.update_calc_sub_batch(g_logical_batch_id, 'FAILED');
4011: cn_message_pkg.end_batch(l_paid);
4012:
4013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4014: fnd_log.STRING(fnd_log.level_unexpected
4015: , 'cn.plsql.cn_proc_batches_pkg.processor.exception', SQLERRM);
4016: END IF;
4017:
4018: RAISE;

Line 4066: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4062: l_dummy VARCHAR2(80);
4063: l_request_id NUMBER;
4064: l_process_audit_id NUMBER(15);
4065: BEGIN
4066: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4067: fnd_log.STRING(
4068: fnd_log.level_procedure
4069: , 'cn.plsql.cn_proc_batches_pkg.main.begin'
4070: , 'Beginning of cn_proc_batches_pkg.main...'

Line 4067: fnd_log.STRING(

4063: l_request_id NUMBER;
4064: l_process_audit_id NUMBER(15);
4065: BEGIN
4066: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4067: fnd_log.STRING(
4068: fnd_log.level_procedure
4069: , 'cn.plsql.cn_proc_batches_pkg.main.begin'
4070: , 'Beginning of cn_proc_batches_pkg.main...'
4071: );

Line 4068: fnd_log.level_procedure

4064: l_process_audit_id NUMBER(15);
4065: BEGIN
4066: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4067: fnd_log.STRING(
4068: fnd_log.level_procedure
4069: , 'cn.plsql.cn_proc_batches_pkg.main.begin'
4070: , 'Beginning of cn_proc_batches_pkg.main...'
4071: );
4072: END IF;

Line 4115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4111: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
4112: RAISE ABORT;
4113: END IF;
4114:
4115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4116: fnd_log.STRING(
4117: fnd_log.level_procedure
4118: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4119: , 'Before calling procedure processor.'

Line 4116: fnd_log.STRING(

4112: RAISE ABORT;
4113: END IF;
4114:
4115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4116: fnd_log.STRING(
4117: fnd_log.level_procedure
4118: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4119: , 'Before calling procedure processor.'
4120: );

Line 4117: fnd_log.level_procedure

4113: END IF;
4114:
4115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4116: fnd_log.STRING(
4117: fnd_log.level_procedure
4118: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4119: , 'Before calling procedure processor.'
4120: );
4121: END IF;

Line 4193: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4189: cn_message_pkg.DEBUG('Failed to submit concurrent request (Batch Processor)');
4190: cn_message_pkg.DEBUG(fnd_message.get);
4191: x_process_status_code := 'FAIL';
4192:
4193: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4194: fnd_log.STRING(
4195: fnd_log.level_unexpected
4196: , 'cn.plsql.cn_proc_batches_pkg.main.exception'
4197: , 'Failed to submit request for BATCH_PROCESSOR.'

Line 4194: fnd_log.STRING(

4190: cn_message_pkg.DEBUG(fnd_message.get);
4191: x_process_status_code := 'FAIL';
4192:
4193: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4194: fnd_log.STRING(
4195: fnd_log.level_unexpected
4196: , 'cn.plsql.cn_proc_batches_pkg.main.exception'
4197: , 'Failed to submit request for BATCH_PROCESSOR.'
4198: );

Line 4195: fnd_log.level_unexpected

4191: x_process_status_code := 'FAIL';
4192:
4193: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4194: fnd_log.STRING(
4195: fnd_log.level_unexpected
4196: , 'cn.plsql.cn_proc_batches_pkg.main.exception'
4197: , 'Failed to submit request for BATCH_PROCESSOR.'
4198: );
4199: END IF;

Line 4215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4211: COMMIT;
4212: END IF;
4213: END IF;
4214:
4215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4216: fnd_log.STRING(
4217: fnd_log.level_procedure
4218: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4219: , 'After calling procedure processor.'

Line 4216: fnd_log.STRING(

4212: END IF;
4213: END IF;
4214:
4215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4216: fnd_log.STRING(
4217: fnd_log.level_procedure
4218: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4219: , 'After calling procedure processor.'
4220: );

Line 4217: fnd_log.level_procedure

4213: END IF;
4214:
4215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4216: fnd_log.STRING(
4217: fnd_log.level_procedure
4218: , 'cn.plsql.cn_proc_batches_pkg.main.run_processor'
4219: , 'After calling procedure processor.'
4220: );
4221: END IF;

Line 4223: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4219: , 'After calling procedure processor.'
4220: );
4221: END IF;
4222:
4223: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4224: fnd_log.STRING(
4225: fnd_log.level_procedure
4226: , 'cn.plsql.cn_proc_batches_pkg.main.end'
4227: , 'End of cn_proc_batches_pkg.main...'

Line 4224: fnd_log.STRING(

4220: );
4221: END IF;
4222:
4223: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4224: fnd_log.STRING(
4225: fnd_log.level_procedure
4226: , 'cn.plsql.cn_proc_batches_pkg.main.end'
4227: , 'End of cn_proc_batches_pkg.main...'
4228: );

Line 4225: fnd_log.level_procedure

4221: END IF;
4222:
4223: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4224: fnd_log.STRING(
4225: fnd_log.level_procedure
4226: , 'cn.plsql.cn_proc_batches_pkg.main.end'
4227: , 'End of cn_proc_batches_pkg.main...'
4228: );
4229: END IF;

Line 4249: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4245: x_process_status_code := 'FAIL';
4246: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_FAIL');
4247: cn_message_pkg.end_batch(x_process_audit_id);
4248:
4249: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4250: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.main.exception'
4251: , SQLERRM);
4252: END IF;
4253: END main;

Line 4250: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.main.exception'

4246: --cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_FAIL');
4247: cn_message_pkg.end_batch(x_process_audit_id);
4248:
4249: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4250: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_proc_batches_pkg.main.exception'
4251: , SQLERRM);
4252: END IF;
4253: END main;
4254:

Line 4630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4626: , org_id
4627: FROM cn_calc_submission_batches_all
4628: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
4629: BEGIN
4630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4631: fnd_log.STRING(
4632: fnd_log.level_procedure
4633: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.begin'
4634: , 'Beginning of poulate_bonus_process_batch ...'

Line 4631: fnd_log.STRING(

4627: FROM cn_calc_submission_batches_all
4628: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
4629: BEGIN
4630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4631: fnd_log.STRING(
4632: fnd_log.level_procedure
4633: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.begin'
4634: , 'Beginning of poulate_bonus_process_batch ...'
4635: );

Line 4632: fnd_log.level_procedure

4628: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
4629: BEGIN
4630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4631: fnd_log.STRING(
4632: fnd_log.level_procedure
4633: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.begin'
4634: , 'Beginning of poulate_bonus_process_batch ...'
4635: );
4636: END IF;

Line 4867: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

4863:
4864: IF l_counter = 0 THEN /* no one to be calculated */
4865: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_BONUS');
4866:
4867: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4868: fnd_log.MESSAGE(
4869: fnd_log.level_exception
4870: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.error'
4871: , TRUE

Line 4868: fnd_log.MESSAGE(

4864: IF l_counter = 0 THEN /* no one to be calculated */
4865: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_BONUS');
4866:
4867: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4868: fnd_log.MESSAGE(
4869: fnd_log.level_exception
4870: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.error'
4871: , TRUE
4872: );

Line 4869: fnd_log.level_exception

4865: fnd_message.set_name('CN', 'CNSBCS_NO_ONE_TO_BONUS');
4866:
4867: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4868: fnd_log.MESSAGE(
4869: fnd_log.level_exception
4870: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.error'
4871: , TRUE
4872: );
4873: END IF;

Line 4878: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4874:
4875: RAISE no_comm_lines;
4876: END IF;
4877:
4878: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4879: fnd_log.STRING(
4880: fnd_log.level_procedure
4881: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.end'
4882: , 'Beginning of poulate_bonus_process_batch ...'

Line 4879: fnd_log.STRING(

4875: RAISE no_comm_lines;
4876: END IF;
4877:
4878: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4879: fnd_log.STRING(
4880: fnd_log.level_procedure
4881: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.end'
4882: , 'Beginning of poulate_bonus_process_batch ...'
4883: );

Line 4880: fnd_log.level_procedure

4876: END IF;
4877:
4878: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4879: fnd_log.STRING(
4880: fnd_log.level_procedure
4881: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.end'
4882: , 'Beginning of poulate_bonus_process_batch ...'
4883: );
4884: END IF;

Line 4900: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4896: || 'compensation plan or the period specified is not at the end of the interval'
4897: );
4898: RAISE;
4899: WHEN OTHERS THEN
4900: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4901: fnd_log.STRING(
4902: fnd_log.level_unexpected
4903: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.exception'
4904: , SQLERRM

Line 4901: fnd_log.STRING(

4897: );
4898: RAISE;
4899: WHEN OTHERS THEN
4900: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4901: fnd_log.STRING(
4902: fnd_log.level_unexpected
4903: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.exception'
4904: , SQLERRM
4905: );

Line 4902: fnd_log.level_unexpected

4898: RAISE;
4899: WHEN OTHERS THEN
4900: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4901: fnd_log.STRING(
4902: fnd_log.level_unexpected
4903: , 'cn.plsql.cn_proc_batches_pkg.populate_bonus_process_batch.exception'
4904: , SQLERRM
4905: );
4906: END IF;