APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTY_ASSIGN_BULK_PUB

Line 1489: jty_assign_bulk_pub.collect_trans_data

1485: END IF;
1486:
1487: /* insert the selected transactions from cn_comm_lines_api_all table */
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

Line 1511: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data has failed');

1507: , retcode => retcode
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');

Line 1515: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data completed successfully');

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');
1517: /* this api will apply the rules to the transactions present in jtf_tae_1001_sc_dea_trans */
1518: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
1519:

Line 1522: jty_assign_bulk_pub.get_winners

1518: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
1519:
1520: FOR l_worker_id IN 1..l_num_workers
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

Line 1541: debugmsg('SCA : jty_assign_bulk_pub.get_winners has failed');

1537: , retcode => retcode
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:

Line 1546: debugmsg('SCA : jty_assign_bulk_pub.get_winners completed successfully');

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');
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');