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 773: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

769: , p_org_id => p_org_id
770: , x_return_status => l_return_status
771: );
772:
773: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
774: RAISE index_ex;
775: END IF;
776:
777: COMMIT;

Line 1492: , p_init_msg_list => fnd_api.g_false

1488: /* to the interface table jtf_tae_1001_sc_dea_trans */
1489: jty_assign_bulk_pub.collect_trans_data
1490: (
1491: p_api_version_number => 1.0
1492: , p_init_msg_list => fnd_api.g_false
1493: , p_source_id => -1001
1494: , p_trans_id => -1002
1495: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
1496: , p_mode => 'DATE EFFECTIVE'

Line 1512: RAISE fnd_api.g_exc_error;

1508: );
1509:
1510: IF (retcode <> 0) THEN
1511: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed');
1512: RAISE fnd_api.g_exc_error;
1513: END IF;
1514:
1515: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data completed successfully');
1516: debugmsg('SCA : Populating data to WINNERS table');

Line 1525: , p_init_msg_list => fnd_api.g_false

1521: LOOP
1522: jty_assign_bulk_pub.get_winners
1523: (
1524: p_api_version_number => 1.0
1525: , p_init_msg_list => fnd_api.g_false
1526: , p_source_id => -1001
1527: , p_trans_id => -1002
1528: , p_program_name => 'SALES/INCENTIVE COMPENSATION PROGRAM'
1529: , p_mode => 'DATE EFFECTIVE'

Line 1542: RAISE fnd_api.g_exc_error;

1538: );
1539:
1540: IF (retcode <> 0) THEN
1541: debugmsg('SCA : jty_assign_bulk_pub.get_winners has failed');
1542: RAISE fnd_api.g_exc_error;
1543: END IF;
1544: END LOOP;
1545:
1546: debugmsg('SCA : jty_assign_bulk_pub.get_winners completed successfully');

Line 1549: WHEN fnd_api.g_exc_error THEN

1545:
1546: debugmsg('SCA : jty_assign_bulk_pub.get_winners completed successfully');
1547: debugmsg('SCA : End of get_credited_txns');
1548: EXCEPTION
1549: WHEN fnd_api.g_exc_error THEN
1550: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns.g_exc_error');
1551: debugmsg('SCA : SQLCODE : ' || SQLCODE);
1552: debugmsg('SCA : SQLERRM : ' || SQLERRM);
1553: WHEN OTHERS THEN

Line 1599: RAISE fnd_api.g_exc_error;

1595: );
1596:
1597: IF (retcode <> 0) THEN
1598: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names has failed');
1599: RAISE fnd_api.g_exc_error;
1600: END IF;
1601:
1602: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names completed successfully');
1603:

Line 1662: RAISE fnd_api.g_exc_error;

1658: );
1659:
1660: IF (retcode <> 0) THEN
1661: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns has failed');
1662: RAISE fnd_api.g_exc_error;
1663: END IF;
1664:
1665: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns completed successfully');
1666: END LOOP;

Line 1672: WHEN fnd_api.g_exc_error THEN

1668: CLOSE c_credited_txn_cur;
1669:
1670: debugmsg('SCA : End of process_new_txns');
1671: EXCEPTION
1672: WHEN fnd_api.g_exc_error THEN
1673: IF c_credited_txn_cur%ISOPEN THEN
1674: CLOSE c_credited_txn_cur;
1675: END IF;
1676:

Line 2183: RAISE fnd_api.g_exc_error;

2179: );
2180:
2181: IF (retcode <> 0) THEN
2182: debugmsg('SCA : CN_SCATM_TAE_PUB.api_negate_record has failed');
2183: RAISE fnd_api.g_exc_error;
2184: END IF;
2185:
2186: debugmsg('SCA : CN_SCATM_TAE_PUB.api_negate_record completed successfully');
2187: l_loaded_txn_rowid_tbl.TRIM(l_no_of_records);

Line 2194: WHEN fnd_api.g_exc_error THEN

2190: END IF;
2191:
2192: debugmsg('SCA : End of handle_loaded_txns');
2193: EXCEPTION
2194: WHEN fnd_api.g_exc_error THEN
2195: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns.g_exc_error');
2196: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2197: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2198: WHEN OTHERS THEN

Line 2281: RAISE fnd_api.g_exc_error;

2277: );
2278:
2279: IF (retcode <> 0) THEN
2280: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names has failed');
2281: RAISE fnd_api.g_exc_error;
2282: END IF;
2283:
2284: debugmsg('SCA : CN_SCATM_TAE_PUB.get_flex_field_names completed successfully');
2285:

Line 2505: RAISE fnd_api.g_exc_error;

2501: );
2502:
2503: IF (retcode <> 0) THEN
2504: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns has failed');
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507:
2508: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns completed successfully');
2509: END IF;

Line 2577: RAISE fnd_api.g_exc_error;

2573: );
2574:
2575: IF (retcode <> 0) THEN
2576: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns has failed');
2577: RAISE fnd_api.g_exc_error;
2578: END IF;
2579:
2580: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns completed successfully');
2581: END IF;

Line 2598: RAISE fnd_api.g_exc_error;

2594: , retcode => retcode);
2595:
2596: IF (retcode <> 0) THEN
2597: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns has failed');
2598: RAISE fnd_api.g_exc_error;
2599: END IF;
2600:
2601: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_unloaded_txns completed successfully');
2602: /* Make changes to DB for loaded txns present in the PL/SQL table */

Line 2616: RAISE fnd_api.g_exc_error;

2612: );
2613:
2614: IF (retcode <> 0) THEN
2615: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns has failed');
2616: RAISE fnd_api.g_exc_error;
2617: END IF;
2618:
2619: debugmsg('SCA : CN_SCATM_TAE_PUB.handle_loaded_txns completed successfully');
2620: /* insert the credited txns into api table */

Line 2638: RAISE fnd_api.g_exc_error;

2634: );
2635:
2636: IF (retcode <> 0) THEN
2637: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns has failed');
2638: RAISE fnd_api.g_exc_error;
2639: END IF;
2640:
2641: debugmsg('SCA : CN_SCATM_TAE_PUB.insert_api_txns completed successfully');
2642: END LOOP; /* end loop fetch winning records */

Line 2648: WHEN fnd_api.g_exc_error THEN

2644: CLOSE c_credited_txn_cur;
2645:
2646: debugmsg('SCA : End of process_all_txns');
2647: EXCEPTION
2648: WHEN fnd_api.g_exc_error THEN
2649: IF c_credited_txn_cur%ISOPEN THEN
2650: CLOSE c_credited_txn_cur;
2651: END IF;
2652:

Line 2781: RAISE fnd_api.g_exc_error;

2777: );
2778:
2779: IF (retcode <> 0) THEN
2780: debugmsg('SCA : CN_SCATM_TAE_PUB.get_where_clause has failed');
2781: RAISE fnd_api.g_exc_error;
2782: END IF;
2783:
2784: debugmsg('SCA : CN_SCATM_TAE_PUB.get_where_clause completed successfully');
2785: /* Call the territory APIs and get the winning salesreps */

Line 2796: RAISE fnd_api.g_exc_error;

2792: );
2793:
2794: IF (retcode <> 0) THEN
2795: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns has failed');
2796: RAISE fnd_api.g_exc_error;
2797: END IF;
2798:
2799: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns completed successfully');
2800:

Line 2836: -- RAISE fnd_api.g_exc_error;

2832: -- process_new_txns(p_org_id => p_org_id, errbuf => errbuf, retcode => retcode);
2833: --
2834: -- IF (retcode <> 0) THEN
2835: -- debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns has failed');
2836: -- RAISE fnd_api.g_exc_error;
2837: -- END IF;
2838:
2839: -- debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns completed successfully');
2840: -- ELSIF(p_run_mode = 'ALL') THEN

Line 2846: -- RAISE fnd_api.g_exc_error;

2842: -- process_all_txns(p_org_id => p_org_id, errbuf => errbuf, retcode => retcode);
2843: --
2844: -- IF (retcode <> 0) THEN
2845: -- debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns has failed');
2846: -- RAISE fnd_api.g_exc_error;
2847: -- END IF;
2848: --
2849: -- debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns completed successfully');
2850: -- END IF;

Line 2857: RAISE fnd_api.g_exc_error;

2853: -- update_txns_processed(errbuf => errbuf, retcode => retcode);
2854:
2855: IF (retcode <> 0) THEN
2856: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed has failed');
2857: RAISE fnd_api.g_exc_error;
2858: END IF;
2859:
2860: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed completed successfully');
2861: COMMIT;

Line 2878: WHEN fnd_api.g_exc_error THEN

2874: WHEN l_invalid_run_mode THEN
2875: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
2876: debugmsg('SCA : End of SCATM');
2877: cn_message_pkg.end_batch(l_process_audit_id);
2878: WHEN fnd_api.g_exc_error THEN
2879: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
2880: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2881: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2882: debugmsg('SCA : End of SCATM');

Line 2913: RAISE fnd_api.g_exc_error;

2909:
2910:
2911: IF (retcode <> 0) THEN
2912: debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns has failed');
2913: RAISE fnd_api.g_exc_error;
2914: END IF;
2915:
2916:
2917: debugmsg('SCA : CN_SCATM_TAE_PUB.process_new_txns completed successfully');

Line 2926: RAISE fnd_api.g_exc_error;

2922:
2923:
2924: IF (retcode <> 0) THEN
2925: debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns has failed');
2926: RAISE fnd_api.g_exc_error;
2927: END IF;
2928:
2929: debugmsg('SCA : CN_SCATM_TAE_PUB.process_all_txns completed successfully');
2930: END IF;

Line 2938: WHEN fnd_api.g_exc_error THEN

2934:
2935: COMMIT;
2936:
2937: EXCEPTION
2938: WHEN fnd_api.g_exc_error THEN
2939: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
2940: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2941: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2942: debugmsg('SCA : End of SCATM');