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.OZF_SD_BATCH_FEED_PVT dependencies on FND_MSG_PUB

Line 23: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Starts');

19: PROCEDURE update_stale_data_batch_line(p_batch_number IN VARCHAR2,
20: p_batch_line_number IN VARCHAR2) AS
21:
22: BEGIN
23: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Starts');
24:
25: UPDATE ozf_sd_batch_lines_int_all
26: SET processed_flag = 'S',
27: last_update_date = sysdate,

Line 33: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Ends');

29: WHERE ship_frm_sd_claim_request_id = p_batch_number
30: AND batch_line_number = p_batch_line_number
31: AND processed_flag = 'N';
32:
33: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Ends');
34:
35: EXCEPTION
36: WHEN others THEN
37: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Exception: '||sqlerrm);

Line 37: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Exception: '||sqlerrm);

33: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Ends');
34:
35: EXCEPTION
36: WHEN others THEN
37: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Exception: '||sqlerrm);
38:
39: END update_stale_data_batch_line;
40:
41: PROCEDURE populate_interface(p_batch_number IN VARCHAR2,

Line 238: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Starts');

234: l_seq NUMBER;
235: l_batch_status VARCHAR2(15);
236:
237: BEGIN
238: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Starts');
239:
240: ozf_sd_batch_feed_pvt.update_stale_data_batch_line(p_batch_number, p_batch_line_number);
241:
242: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface',

Line 242: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface',

238: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Starts');
239:
240: ozf_sd_batch_feed_pvt.update_stale_data_batch_line(p_batch_number, p_batch_line_number);
241:
242: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface',
243: 'WebADI Batch - before inserting into interface table');
244:
245: BEGIN
246: INSERT INTO ozf_sd_batch_lines_int_all

Line 643: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Exception: '||sqlerrm);

639: p_disposition_code10);
640:
641: EXCEPTION
642: WHEN others THEN
643: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Exception: '||sqlerrm);
644: END;
645:
646: COMMIT;
647: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Ends');

Line 647: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Ends');

643: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Exception: '||sqlerrm);
644: END;
645:
646: COMMIT;
647: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface', 'Procedure Ends');
648:
649: END populate_interface;
650:
651: PROCEDURE update_data(p_batch_number IN VARCHAR2,

Line 670: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Starts');

666: l_currency_code VARCHAR2(15);
667: l_msg_count NUMBER;
668: BEGIN
669:
670: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Starts');
671:
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: --Retreive batch id

Line 698: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

694: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
695: RETURN;
696: END;
697:
698: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
699: 'Batch Id: '||l_batch_id||' and Batch Status: '||l_batch_status);
700:
701: --raising business event
702: ozf_sd_util_pvt.sd_raise_event (l_batch_id, 'RESPONSE', x_return_status);

Line 751: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

747: AND bl.purge_flag <> 'Y'
748: );
749: EXCEPTION
750: WHEN others THEN
751: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
752: 'Exception Delete OZF_SD_BATCH_LINE_DISPUTES: '||sqlerrm);
753: END;
754:
755: FOR v_vendor_ref IN (SELECT batch_line_number, credit_reference_id

Line 891: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of total lines: '||l_cnt_tot_line);

887: WHERE batch_id = l_batch_id
888: AND status_code = 'REJECTED'
889: AND purge_flag <> 'Y';
890:
891: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of total lines: '||l_cnt_tot_line);
892: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of rejected lines: '||l_cnt_rejected_lines);
893: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of approved lines: '||l_cnt_approved_lines);
894:
895: --All lines are rejected or if none approved

Line 892: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of rejected lines: '||l_cnt_rejected_lines);

888: AND status_code = 'REJECTED'
889: AND purge_flag <> 'Y';
890:
891: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of total lines: '||l_cnt_tot_line);
892: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of rejected lines: '||l_cnt_rejected_lines);
893: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of approved lines: '||l_cnt_approved_lines);
894:
895: --All lines are rejected or if none approved
896:

Line 893: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of approved lines: '||l_cnt_approved_lines);

889: AND purge_flag <> 'Y';
890:
891: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of total lines: '||l_cnt_tot_line);
892: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of rejected lines: '||l_cnt_rejected_lines);
893: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'number of approved lines: '||l_cnt_approved_lines);
894:
895: --All lines are rejected or if none approved
896:
897: IF ( ( l_cnt_rejected_lines = l_cnt_tot_line) OR ( l_cnt_approved_lines = 0 ) ) THEN

Line 975: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

971: RETURN;
972: END IF;
973:
974: IF x_return_status = fnd_api.g_ret_sts_error THEN
975: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
976: 'Entered throwing exception' || x_msg_data);
977: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
978: fnd_message.set_token('MESSAGE', x_msg_data);
979: RAISE fnd_api.g_exc_error;

Line 981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

977: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
978: fnd_message.set_token('MESSAGE', x_msg_data);
979: RAISE fnd_api.g_exc_error;
980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
982: 'Entered throwing unexpected exception');
983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
984: fnd_message.set_token('MESSAGE', x_msg_data);
985: RAISE fnd_api.g_exc_unexpected_error;

Line 988: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Ends');

984: fnd_message.set_token('MESSAGE', x_msg_data);
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987:
988: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Ends');
989:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error THEN
992: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 992: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

988: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Ends');
989:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error THEN
992: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
993: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
996: fnd_message.set_token('MESSAGE', x_msg_data);

Line 997: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

993: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
996: fnd_message.set_token('MESSAGE', x_msg_data);
997: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
998: 'OZF done:' || x_msg_data || '::::');
999:
1000: WHEN fnd_api.g_exc_unexpected_error THEN
1001: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 1001: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

997: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
998: 'OZF done:' || x_msg_data || '::::');
999:
1000: WHEN fnd_api.g_exc_unexpected_error THEN
1001: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1002: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1005: fnd_message.set_token('MESSAGE', x_msg_data);

Line 1006: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

1002: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1005: fnd_message.set_token('MESSAGE', x_msg_data);
1006: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1007: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
1008: WHEN others THEN
1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1010: 'OZF EXCEPTION OTHERS' || sqlerrm);

Line 1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

1005: fnd_message.set_token('MESSAGE', x_msg_data);
1006: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1007: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
1008: WHEN others THEN
1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1010: 'OZF EXCEPTION OTHERS' || sqlerrm);
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1013: fnd_message.set_token('MESSAGE', x_msg_data);

Line 1014: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

1010: 'OZF EXCEPTION OTHERS' || sqlerrm);
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1013: fnd_message.set_token('MESSAGE', x_msg_data);
1014: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1015: 'OZF done OTHERS:' || x_msg_data ||'::::');
1016: END update_data;
1017:
1018: PROCEDURE BATCH_CREATE_APPROVED_LINE_NEW(p_batch_id IN NUMBER,

Line 1041: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::batch_create_approved_line_new',

1037: l_claim_minor_version NUMBER;
1038:
1039: BEGIN
1040:
1041: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::batch_create_approved_line_new',
1042: 'Procedure Starts: Batch Id :'||p_batch_id);
1043:
1044: SELECT batch_number, vendor_id, vendor_site_id, org_id,
1045: currency_code, batch_amount_threshold, batch_line_amount_threshold, claim_number, claim_minor_version

Line 1109: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::batch_create_approved_line_new',

1105: commit;
1106:
1107: process_claim(l_new_batch_id, x_return_status, x_msg_data);
1108:
1109: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::batch_create_approved_line_new',
1110: 'Procedure Ends');
1111:
1112: END BATCH_CREATE_APPROVED_LINE_NEW;
1113:

Line 1121: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_dispute_data',

1117: l_disputes v_disputes;
1118: l_dispute_index NUMBER(2);
1119:
1120: BEGIN
1121: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_dispute_data',
1122: 'Procedure Starts: Batch number -> '||p_batch_number||' Batch Id -> '||p_batch_id|| ' New Batch Id -> '||new_batch_id);
1123:
1124: FOR v_dispute_code IN (SELECT bl.batch_id,
1125: bl.batch_line_id,

Line 1240: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_dispute_data',

1236: fnd_global.conc_program_id, -- p_Operating_Unit,
1237: fnd_global.security_group_id);
1238: END LOOP;
1239: END LOOP;
1240: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_dispute_data',
1241: 'Procedure Ends');
1242: END update_dispute_data;
1243:
1244: PROCEDURE process_claim(p_batch_id IN NUMBER,

Line 1257: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',

1253: l_claim_type VARCHAR2(20) := 'SUPPLIER';
1254: --always defaulted to external claim
1255:
1256: BEGIN
1257: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1258: 'Procedure Starts: Batch Id -> '||p_batch_id);
1259: --call claim API
1260: --update claim number and set batch /closed
1261: ozf_claim_accrual_pvt.initiate_sd_payment(1,

Line 1272: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',

1268: p_batch_id,
1269: l_claim_type,
1270: l_claim_id);
1271:
1272: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1273: 'Return Status of claim API: '||l_claim_ret_status ||' Msg: '||l_claim_msg_data || 'Msg Count: '|| l_claim_msg_count);
1274:
1275: FOR I IN 1..l_claim_msg_count LOOP
1276: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'OZF_SD_BATCH_FEED_PVT::process_claim',

Line 1276: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'OZF_SD_BATCH_FEED_PVT::process_claim',

1272: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1273: 'Return Status of claim API: '||l_claim_ret_status ||' Msg: '||l_claim_msg_data || 'Msg Count: '|| l_claim_msg_count);
1274:
1275: FOR I IN 1..l_claim_msg_count LOOP
1276: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1277: 'Claim API Msg: '|| SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1278: END LOOP;
1279:
1280: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1277: 'Claim API Msg: '|| SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );

1273: 'Return Status of claim API: '||l_claim_ret_status ||' Msg: '||l_claim_msg_data || 'Msg Count: '|| l_claim_msg_count);
1274:
1275: FOR I IN 1..l_claim_msg_count LOOP
1276: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1277: 'Claim API Msg: '|| SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1278: END LOOP;
1279:
1280: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1281: UPDATE ozf_sd_batch_headers_all

Line 1293: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',

1289: x_return_status := l_claim_ret_status;
1290: x_msg_data := l_claim_msg_data;
1291: RAISE fnd_api.g_exc_error;
1292: END IF;
1293: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1294: 'Procedure Ends');
1295: END process_claim;
1296:
1297: PROCEDURE update_rejected_line_data(p_batch_number VARCHAR2,

Line 1305: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_rejected_line_data',

1301: x_msg_data OUT nocopy VARCHAR2) IS
1302: l_currency_code VARCHAR2(15);
1303:
1304: BEGIN
1305: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_rejected_line_data',
1306: 'Procedure Starts: Batch number -> '||p_batch_number||' Batch Id -> '||p_batch_id|| ' New Batch Id -> '||new_batch_id);
1307:
1308: FOR v_rejected_lines IN (SELECT intr.*
1309: FROM ozf_sd_batch_lines_int_all intr, ozf_sd_batch_lines_all bl

Line 1389: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_rejected_line_data',

1385: END LOOP;
1386:
1387: update_dispute_data(p_batch_number,p_batch_id,new_batch_id);
1388:
1389: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_rejected_line_data',
1390: 'Procedure Ends');
1391: END update_rejected_line_data;
1392:
1393: END ozf_sd_batch_feed_pvt;