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_SCA_CREDITS_BATCH_PUB dependencies on FND_API

Line 851: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

847: , p_org_id => p_org_id
848: , x_return_status => l_return_status
849: );
850:
851: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
852: RAISE index_ex;
853: END IF;
854:
855: COMMIT;

Line 1619: RAISE FND_API.G_EXC_ERROR;

1615: -- debug message
1616: retcode := 2;
1617: errbuf := 'STAR should be run at least once in DAE INCREMENTAL mode before running Sales Credit Allocation in INCREMENTAL MODE.';
1618: debugmsg(errbuf);
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:
1622: l_count := 0;
1623:

Line 1643: RAISE FND_API.G_EXC_ERROR;

1639: -- debug message
1640: retcode := 2;
1641: errbuf := 'Last run mode of STAR is DEA TOTAL. SCA can''t be run in incremental mode';
1642: debugmsg(errbuf);
1643: RAISE FND_API.G_EXC_ERROR;
1644: END IF;
1645: END IF;
1646:
1647: get_where_clause(

Line 1661: , p_init_msg_list => fnd_api.g_false

1657: /* insert the selected transactions from cn_comm_lines_api_all table */
1658: /* to the interface table jtf_tae_1001_sc_dea_trans */
1659: jty_assign_bulk_pub.collect_trans_data(
1660: p_api_version_number => 1.0
1661: , p_init_msg_list => fnd_api.g_false
1662: , p_source_id => -1001
1663: , p_trans_id => -1002
1664: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
1665: , p_mode => 'DATE EFFECTIVE'

Line 1682: RAISE fnd_api.g_exc_error;

1678: );
1679:
1680: IF (retcode <> 0) THEN
1681: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed');
1682: RAISE fnd_api.g_exc_error;
1683: END IF;
1684:
1685: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data with mode CLEAR completed successfully. ');
1686:

Line 1761: raise fnd_api.g_exc_error;

1757: COMMIT;
1758:
1759: IF retcode = 2
1760: THEN
1761: raise fnd_api.g_exc_error;
1762: END IF;
1763:
1764: /* insert the selected transactions from cn_comm_lines_api_all table */
1765: /* to the interface table jtf_tae_1001_sc_dea_trans */

Line 1768: , p_init_msg_list => fnd_api.g_false

1764: /* insert the selected transactions from cn_comm_lines_api_all table */
1765: /* to the interface table jtf_tae_1001_sc_dea_trans */
1766: jty_assign_bulk_pub.collect_trans_data(
1767: p_api_version_number => 1.0
1768: , p_init_msg_list => fnd_api.g_false
1769: , p_source_id => -1001
1770: , p_trans_id => -1002
1771: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
1772: , p_mode => 'DATE EFFECTIVE'

Line 1789: RAISE fnd_api.g_exc_error;

1785: );
1786:
1787: IF (retcode <> 0) THEN
1788: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed');
1789: RAISE fnd_api.g_exc_error;
1790: END IF;
1791:
1792: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data with oic_mode '||
1793: 'POST completed successfully');

Line 1834: raise fnd_api.g_exc_error;

1830: COMMIT;
1831:
1832: IF retcode = 2
1833: THEN
1834: raise fnd_api.g_exc_error;
1835: END IF;
1836:
1837: debugmsg('SCA : CN_SCATM_TAE_PUB. Process_Match successful, now will generate stats ');
1838:

Line 1850: RAISE fnd_api.g_exc_error;

1846:
1847: IF (retcode <> 0) THEN
1848: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed while '||
1849: ' trying to generate stats on matches table ');
1850: RAISE fnd_api.g_exc_error;
1851: END IF;
1852:
1853: debugmsg('SCA : CN_SCATM_TAE_PUB. Generate stats on matches table successful');
1854:

Line 1894: raise fnd_api.g_exc_error;

1890: COMMIT;
1891:
1892: IF retcode = 2
1893: THEN
1894: raise fnd_api.g_exc_error;
1895: END IF;
1896:
1897:
1898: debugmsg('SCA : CN_SCATM_TAE_PUB. Process_winners successful, now will generate stats ');

Line 1912: RAISE fnd_api.g_exc_error;

1908:
1909: IF (retcode <> 0) THEN
1910: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed while '||
1911: ' trying to generate stats on winners table ');
1912: RAISE fnd_api.g_exc_error;
1913: END IF;
1914: -- End of Addition
1915: debugmsg('SCA : jty_assign_bulk_pub.generate stats on winners successful');
1916: debugmsg('SCA : jty_assign_bulk_pub.get_winners completed successfully');

Line 1920: WHEN fnd_api.g_exc_error THEN

1916: debugmsg('SCA : jty_assign_bulk_pub.get_winners completed successfully');
1917: debugmsg('SCA : End of get_credited_txns');
1918:
1919: EXCEPTION
1920: WHEN fnd_api.g_exc_error THEN
1921: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns.g_exc_error');
1922: debugmsg('SCA : SQLCODE : ' || SQLCODE);
1923: debugmsg('SCA : SQLERRM : ' || SQLERRM);
1924: WHEN child_proc_fail_exception THEN

Line 1974: RAISE fnd_api.g_exc_error;

1970: );
1971:
1972: IF (retcode <> 0) THEN
1973: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names has failed');
1974: RAISE fnd_api.g_exc_error;
1975: END IF;
1976:
1977: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names completed successfully');
1978:

Line 2037: RAISE fnd_api.g_exc_error;

2033: );
2034:
2035: IF (retcode <> 0) THEN
2036: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns has failed');
2037: RAISE fnd_api.g_exc_error;
2038: END IF;
2039:
2040: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns completed successfully');
2041: END LOOP;

Line 2047: WHEN fnd_api.g_exc_error THEN

2043: CLOSE c_credited_txn_cur;
2044:
2045: debugmsg('SCA : End of process_new_txns');
2046: EXCEPTION
2047: WHEN fnd_api.g_exc_error THEN
2048: IF c_credited_txn_cur%ISOPEN THEN
2049: CLOSE c_credited_txn_cur;
2050: END IF;
2051:

Line 2558: RAISE fnd_api.g_exc_error;

2554: );
2555:
2556: IF (retcode <> 0) THEN
2557: debugmsg('SCA : CN_SCATM_TAE_PUB.api_negate_record has failed');
2558: RAISE fnd_api.g_exc_error;
2559: END IF;
2560:
2561: debugmsg('SCA : CN_SCATM_TAE_PUB.api_negate_record completed successfully');
2562: l_loaded_txn_rowid_tbl.TRIM(l_no_of_records);

Line 2569: WHEN fnd_api.g_exc_error THEN

2565: END IF;
2566:
2567: debugmsg('SCA : End of handle_loaded_txns');
2568: EXCEPTION
2569: WHEN fnd_api.g_exc_error THEN
2570: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns.g_exc_error');
2571: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2572: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2573: WHEN OTHERS THEN

Line 2710: RAISE fnd_api.g_exc_error;

2706: );
2707:
2708: IF (retcode <> 0) THEN
2709: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names has failed');
2710: RAISE fnd_api.g_exc_error;
2711: END IF;
2712:
2713: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names completed successfully');
2714:

Line 2929: RAISE fnd_api.g_exc_error;

2925: );
2926:
2927: IF (retcode <> 0) THEN
2928: --debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns has failed');
2929: RAISE fnd_api.g_exc_error;
2930: END IF;
2931:
2932: --debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns completed successfully');
2933: END IF;

Line 3027: RAISE fnd_api.g_exc_error;

3023: );
3024:
3025: IF (retcode <> 0) THEN
3026: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns has failed');
3027: RAISE fnd_api.g_exc_error;
3028: END IF;
3029:
3030: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns completed successfully');
3031: END IF;

Line 3048: RAISE fnd_api.g_exc_error;

3044: , retcode => retcode);
3045:
3046: IF (retcode <> 0) THEN
3047: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns has failed');
3048: RAISE fnd_api.g_exc_error;
3049: END IF;
3050:
3051: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns completed successfully');
3052: /* Make changes to DB for loaded txns present in the PL/SQL table */

Line 3066: RAISE fnd_api.g_exc_error;

3062: );
3063:
3064: IF (retcode <> 0) THEN
3065: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns has failed');
3066: RAISE fnd_api.g_exc_error;
3067: END IF;
3068:
3069: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns completed successfully');
3070: /* insert the credited txns into api table */

Line 3088: RAISE fnd_api.g_exc_error;

3084: );
3085:
3086: IF (retcode <> 0) THEN
3087: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns has failed');
3088: RAISE fnd_api.g_exc_error;
3089: END IF;
3090:
3091: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns completed successfully');
3092: END LOOP; /* end loop fetch winning records */

Line 3098: WHEN fnd_api.g_exc_error THEN

3094: CLOSE c_credited_txn_cur;
3095:
3096: debugmsg('SCA : End of process_all_txns');
3097: EXCEPTION
3098: WHEN fnd_api.g_exc_error THEN
3099: IF c_credited_txn_cur%ISOPEN THEN
3100: CLOSE c_credited_txn_cur;
3101: END IF;
3102:

Line 3257: RAISE fnd_api.g_exc_error;

3253: );
3254:
3255: IF (retcode <> 0) THEN
3256: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns has failed');
3257: RAISE fnd_api.g_exc_error;
3258: END IF;
3259:
3260: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns completed successfully');
3261:

Line 3298: raise fnd_api.g_exc_error;

3294:
3295: IF retcode = 2
3296: THEN
3297: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed has failed');
3298: raise fnd_api.g_exc_error;
3299: END IF;
3300:
3301: IF (retcode <> 0) THEN
3302: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed has failed');

Line 3303: RAISE fnd_api.g_exc_error;

3299: END IF;
3300:
3301: IF (retcode <> 0) THEN
3302: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed has failed');
3303: RAISE fnd_api.g_exc_error;
3304: END IF;
3305:
3306: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed completed successfully');
3307: -- Call end_batch to end debug log file

Line 3325: WHEN fnd_api.g_exc_error THEN

3321: WHEN l_invalid_run_mode THEN
3322: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
3323: debugmsg('SCA : End of SCATM');
3324: cn_message_pkg.end_batch(l_process_audit_id);
3325: WHEN fnd_api.g_exc_error THEN
3326: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3327: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3328: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3329: debugmsg('SCA : End of SCATM');

Line 3364: RAISE fnd_api.g_exc_error;

3360:
3361:
3362: IF (retcode <> 0) THEN
3363: debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns has failed');
3364: RAISE fnd_api.g_exc_error;
3365: END IF;
3366:
3367:
3368: debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns completed successfully');

Line 3377: RAISE fnd_api.g_exc_error;

3373:
3374:
3375: IF (retcode <> 0) THEN
3376: debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns has failed');
3377: RAISE fnd_api.g_exc_error;
3378: END IF;
3379:
3380: debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns completed successfully');
3381: END IF;

Line 3392: WHEN fnd_api.g_exc_error THEN

3388:
3389: COMMIT;
3390:
3391: EXCEPTION
3392: WHEN fnd_api.g_exc_error THEN
3393: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3394: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3395: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3396: debugmsg('SCA : End of SCATM');

Line 3442: RAISE fnd_api.g_exc_error;

3438: );
3439:
3440: IF (retcode <> 0) THEN
3441: debugmsg('SCA : CN_SCATM_TAE_PUB.get_where_clause has failed');
3442: RAISE fnd_api.g_exc_error;
3443: END IF;
3444:
3445: debugmsg('SCA : CN_SCATM_TAE_PUB.get_where_clause completed successfully');
3446:

Line 3451: , p_init_msg_list => fnd_api.g_false

3447: /* insert the selected transactions from cn_comm_lines_api_all table */
3448: /* to the interface table jtf_tae_1001_sc_dea_trans */
3449: jty_assign_bulk_pub.collect_trans_data(
3450: p_api_version_number => 1.0
3451: , p_init_msg_list => fnd_api.g_false
3452: , p_source_id => -1001
3453: , p_trans_id => -1002
3454: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
3455: , p_mode => 'DATE EFFECTIVE'

Line 3472: RAISE fnd_api.g_exc_error;

3468: );
3469:
3470: IF (retcode <> 0) THEN
3471: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns for INSERT has failed');
3472: RAISE fnd_api.g_exc_error;
3473: END IF;
3474:
3475: debugmsg('SCA : CN_SCATM_TAE_PUB.batch_collect_txns with oic_mode INSERT completed successfully');
3476:

Line 3478: WHEN fnd_api.g_exc_error THEN

3474:
3475: debugmsg('SCA : CN_SCATM_TAE_PUB.batch_collect_txns with oic_mode INSERT completed successfully');
3476:
3477: EXCEPTION
3478: WHEN fnd_api.g_exc_error THEN
3479: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3480: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3481: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3482: debugmsg('SCA : End of SCATM');

Line 3516: , p_init_msg_list => fnd_api.g_false

3512: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
3513:
3514: jty_assign_bulk_pub.get_winners(
3515: p_api_version_number => 1.0
3516: , p_init_msg_list => fnd_api.g_false
3517: , p_source_id => -1001
3518: , p_trans_id => -1002
3519: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
3520: , p_mode => 'DATE EFFECTIVE'

Line 3538: RAISE fnd_api.g_exc_error;

3534: ||' data '||l_msg_data);
3535:
3536: IF (retcode <> 0) THEN
3537: debugmsg('SCA : jty_assign_bulk_pub.get_winners has failed');
3538: RAISE fnd_api.g_exc_error;
3539: END IF;
3540:
3541:
3542: debugmsg('SCA : CN_SCATM_TAE_PUB.batch_process_winners completed successfully');

Line 3544: WHEN fnd_api.g_exc_error THEN

3540:
3541:
3542: debugmsg('SCA : CN_SCATM_TAE_PUB.batch_process_winners completed successfully');
3543: EXCEPTION
3544: WHEN fnd_api.g_exc_error THEN
3545: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3546: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3547: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3548: debugmsg('SCA : End of SCATM');