[Home] [Help]
37: l_workitem_id number;
38: l_execution_time date;
39: l_aging_bucket_line_id number;
40:
41: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
42: l_count NUMBER := 0;
43: l_return_status VARCHAR2(20);
44: l_msg_count NUMBER;
45: l_msg_data VARCHAR2(2000);
690: l_dunning_rec_upd_old.status := 'SKIP';
691: -- l_dunning_rec_upd_old.object_type:= 'IEX_STRATEGY';
692: -- l_dunning_rec_upd_old.object_id:= l_workitem_id;
693:
694: IEX_DUNNING_PVT.Update_DUNNING(
695: p_api_version => 1.0
696: , p_init_msg_list => FND_API.G_FALSE
697: , p_commit => FND_API.G_FALSE
698: , p_dunning_rec => l_dunning_rec_upd_old
718:
719: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
720: iex_debug_pub.logmessage ('send_mail: ' || ' WorkItem Id = '||l_workitem_id );
721: -- End Added by gnramasa for bug 5661324 14-Mar-07
722: IEX_DUNNING_PVT.CREATE_DUNNING(
723: p_api_version => 1.0
724: , p_init_msg_list => FND_API.G_FALSE
725: , p_commit => FND_API.G_FALSE
726: , p_dunning_rec => l_dunning_rec
728: , x_return_status => l_return_status
729: , x_msg_count => l_msg_count
730: , x_msg_data => l_msg_data);
731:
732: -- Added call IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION to fix 14256867
733: IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION(
734: p_api_version => 1.0
735: , p_init_msg_list => FND_API.G_FALSE
736: , p_commit => FND_API.G_FALSE
729: , x_msg_count => l_msg_count
730: , x_msg_data => l_msg_data);
731:
732: -- Added call IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION to fix 14256867
733: IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION(
734: p_api_version => 1.0
735: , p_init_msg_list => FND_API.G_FALSE
736: , p_commit => FND_API.G_FALSE
737: , p_delinquencies_tbl => l_del_tbl
761: -- call fulfilment function with multiple bind variables.
762: -- ctlee - 6/18 fulfillment printer method available
763: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();
764: if (l_curr_dmethod = 'FFM') then
765: iex_dunning_pvt.send_fulfillment(
766: p_api_version => 1.0,
767: p_init_msg_list => FND_API.G_TRUE,
768: p_commit => FND_API.G_TRUE,
769: p_FULFILLMENT_BIND_TBL => l_fulfillment_bind_tbl,
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.logmessage ('send_mail: error while checking for previous active xml requests for this workitem: ' || SQLERRM );
802: END IF;
803: END;
804: iex_dunning_pvt.send_xml(
805: p_api_version => 1.0,
806: p_init_msg_list => FND_API.G_TRUE,
807: p_commit => FND_API.G_TRUE,
808: p_resend => 'N',
919: end if;
920: l_dunning_rec_upd.contact_destination := l_contact_destination; -- bug 3955222
921: l_dunning_rec_upd.contact_party_id := l_contact_party_id; -- bug 3955222
922:
923: IEX_DUNNING_PVT.Update_DUNNING(
924: p_api_version => 1.0
925: , p_init_msg_list => FND_API.G_FALSE
926: , p_commit => FND_API.G_FALSE
927: , p_dunning_rec => l_dunning_rec_upd
1810: l_aging_bucket_line_id number;
1811: l_fulfil_temp_id number;
1812: l_xdo_temp_id number;
1813:
1814: l_fulfillment_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
1815: l_count NUMBER := 0;
1816: l_return_status VARCHAR2(20);
1817: l_msg_count NUMBER;
1818: l_msg_data VARCHAR2(2000);
2406: l_dunning_rec_upd_old.status := 'SKIP';
2407: -- l_dunning_rec_upd_old.object_type:= 'WORK_ITEM';
2408: -- l_dunning_rec_upd_old.object_id:= l_workitem_id;
2409:
2410: IEX_DUNNING_PVT.Update_DUNNING(
2411: p_api_version => 1.0
2412: , p_init_msg_list => FND_API.G_FALSE
2413: , p_commit => FND_API.G_FALSE
2414: , p_dunning_rec => l_dunning_rec_upd_old
2429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2430: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before create dunning ' );
2431: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' WorkItem Id = '||l_workitem_id );
2432: END IF;
2433: IEX_DUNNING_PVT.CREATE_DUNNING(
2434: p_api_version => 1.0
2435: , p_init_msg_list => FND_API.G_FALSE
2436: , p_commit => FND_API.G_FALSE
2437: , p_dunning_rec => l_dunning_rec
2439: , x_return_status => l_return_status
2440: , x_msg_count => l_msg_count
2441: , x_msg_data => l_msg_data);
2442:
2443: -- Added call IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION to fix 14256867
2444: IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION(
2445: p_api_version => 1.0
2446: , p_init_msg_list => FND_API.G_FALSE
2447: , p_commit => FND_API.G_FALSE
2440: , x_msg_count => l_msg_count
2441: , x_msg_data => l_msg_data);
2442:
2443: -- Added call IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION to fix 14256867
2444: IEX_DUNNING_PVT.INSERT_DUNNING_TRANSACTION(
2445: p_api_version => 1.0
2446: , p_init_msg_list => FND_API.G_FALSE
2447: , p_commit => FND_API.G_FALSE
2448: , p_delinquencies_tbl => l_del_tbl
2472:
2473:
2474: -- call fulfilment function with multiple bind variables.
2475: if (l_curr_dmethod = 'FFM') then
2476: iex_dunning_pvt.send_fulfillment(
2477: p_api_version => 1.0,
2478: p_init_msg_list => FND_API.G_TRUE,
2479: p_commit => FND_API.G_TRUE,
2480: p_FULFILLMENT_BIND_TBL => l_fulfillment_bind_tbl,
2489: x_contact_destination => l_contact_destination, -- bug 3955222
2490: x_contact_party_id => l_contact_party_id); -- bug 3955222
2491: else
2492: -- for now, resend to 'N' without request_id; to send the old one 'Y' with request id
2493: iex_dunning_pvt.send_xml(
2494: p_api_version => 1.0,
2495: p_init_msg_list => FND_API.G_TRUE,
2496: p_commit => FND_API.G_TRUE,
2497: p_resend => 'N',
2580: end if;
2581: l_dunning_rec_upd.contact_destination := l_contact_destination; -- bug 3955222
2582: l_dunning_rec_upd.contact_party_id := l_contact_party_id; -- bug 3955222
2583:
2584: IEX_DUNNING_PVT.Update_DUNNING(
2585: p_api_version => 1.0
2586: , p_init_msg_list => FND_API.G_FALSE
2587: , p_commit => FND_API.G_TRUE
2588: , p_dunning_rec => l_dunning_rec_upd