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 OZF_SD_BATCH_LINES_INT_ALL

Line 25: UPDATE ozf_sd_batch_lines_int_all

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,
28: last_updated_by = fnd_global.user_id
29: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 246: INSERT INTO ozf_sd_batch_lines_int_all

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
247: (batch_line_int_id,
248: frm_contact1_name,
249: frm_contact1_email,
250: frm_contact1_fax,

Line 444: (ozf_sd_batch_lines_int_all_s.nextval,

440: gbl_claim_rej_code8,
441: gbl_claim_rej_code9,
442: gbl_claim_rej_code10)
443: VALUES
444: (ozf_sd_batch_lines_int_all_s.nextval,
445: p_to_cntct1_name,
446: p_to_cntct1_email,
447: p_to_cntct1_fax,
448: p_to_cntct1_phone,

Line 682: UPDATE ozf_sd_batch_lines_int_all

678: FROM ozf_sd_batch_headers_all
679: WHERE batch_number = p_batch_number;
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: UPDATE ozf_sd_batch_lines_int_all
683: SET validation_txt = 'Batch ID does not exist',
684: last_update_date = sysdate,
685: last_updated_by = fnd_global.user_id
686: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 705: UPDATE ozf_sd_batch_lines_int_all

701: --raising business event
702: ozf_sd_util_pvt.sd_raise_event (l_batch_id, 'RESPONSE', x_return_status);
703:
704: IF l_batch_status NOT IN ('WIP','SUBMITTED' ) THEN
705: UPDATE ozf_sd_batch_lines_int_all
706: SET processed_flag = 'E',
707: validation_txt = 'Batch not in WIP or SUBMITTED status',
708: last_update_date = sysdate,
709: last_updated_by = fnd_global.user_id

Line 721: FROM ozf_sd_batch_lines_int_all

717:
718: --check whether lines exist for given batch id
719: SELECT COUNT(1)
720: INTO l_cnt_line
721: FROM ozf_sd_batch_lines_int_all
722: WHERE ship_frm_sd_claim_request_id = p_batch_number
723: AND processed_flag = 'N';
724:
725: IF l_cnt_line = 0 THEN

Line 726: UPDATE ozf_sd_batch_lines_int_all

722: WHERE ship_frm_sd_claim_request_id = p_batch_number
723: AND processed_flag = 'N';
724:
725: IF l_cnt_line = 0 THEN
726: UPDATE ozf_sd_batch_lines_int_all
727: SET validation_txt = 'There are no Lines for this Batch ID',
728: last_update_date = sysdate,
729: last_updated_by = fnd_global.user_id
730: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 742: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr

738: BEGIN
739: DELETE ozf_sd_batch_line_disputes
740: WHERE batch_id = l_batch_id
741: AND batch_line_id IN (SELECT bl.batch_line_id
742: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
743: WHERE bl.batch_id = l_batch_id
744: AND bl.batch_id = intr.ship_frm_sd_claim_request_id
745: AND bl.batch_line_number = intr.batch_line_number
746: AND intr.processed_flag = 'N'

Line 756: FROM ozf_sd_batch_lines_int_all

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
756: FROM ozf_sd_batch_lines_int_all
757: WHERE ship_frm_sd_claim_request_id = p_batch_number
758: AND processed_flag = 'N')
759:
760: LOOP

Line 777: UPDATE ozf_sd_batch_lines_int_all

773: WHERE batch_id = l_batch_id
774: AND purge_flag <> 'Y')
775: LOOP
776: IF v_batch_lines.status_code <> 'SUBMITTED' THEN
777: UPDATE ozf_sd_batch_lines_int_all
778: SET validation_txt = 'Batch Line not in SUBMITTED status',
779: GBL_CLAIM_REJ_CODE10 = 'OZF_SD_DATA_ERROR',
780: last_update_date = sysdate,
781: last_updated_by = fnd_global.user_id

Line 794: FROM ozf_sd_batch_lines_int_all

790: END LOOP;
791:
792: FOR v_missing_invalid_sts_lines IN (SELECT batch_line_number,
793: vendor_auth_cost_monetary_amt, vendor_auth_cost_currency_code
794: FROM ozf_sd_batch_lines_int_all
795: WHERE ship_frm_sd_claim_request_id = p_batch_number
796: AND processed_flag = 'N'
797: AND ( (gbl_claim_disposition_code IS NULL) OR ( gbl_claim_disposition_code NOT IN ('APPROVED', 'REJECTED') ) )
798: )

Line 801: UPDATE ozf_sd_batch_lines_int_all

797: AND ( (gbl_claim_disposition_code IS NULL) OR ( gbl_claim_disposition_code NOT IN ('APPROVED', 'REJECTED') ) )
798: )
799: LOOP
800:
801: UPDATE ozf_sd_batch_lines_int_all
802: SET gbl_claim_rej_code10 = 'OZF_SD_NO_RESPONSE',
803: validation_txt = 'STATUS CODE IS EITHER MISSING OR NOT IN APPROVED/REJECTED',
804: last_update_date = sysdate,
805: last_updated_by = fnd_global.user_id

Line 828: FROM ozf_sd_batch_lines_int_all

824:
825: --Update Lines for Rejected lines
826: FOR v_reject_lines IN (SELECT batch_line_number, vendor_auth_cost_monetary_amt,
827: vendor_auth_cost_currency_code
828: FROM ozf_sd_batch_lines_int_all
829: WHERE ship_frm_sd_claim_request_id = p_batch_number
830: AND processed_flag = 'N'
831: AND gbl_claim_disposition_code = 'REJECTED')
832: LOOP

Line 849: FROM ozf_sd_batch_lines_int_all

845: END LOOP;
846:
847: --Update Lines for Accepted lines
848: FOR v_accepted_lines IN (SELECT batch_line_number
849: FROM ozf_sd_batch_lines_int_all
850: WHERE ship_frm_sd_claim_request_id = p_batch_number
851: AND processed_flag = 'N'
852: AND gbl_claim_disposition_code = 'APPROVED')
853: LOOP

Line 910: UPDATE ozf_sd_batch_lines_int_all

906: WHERE batch_id = l_batch_id;
907:
908:
909:
910: UPDATE ozf_sd_batch_lines_int_all
911: SET processed_flag = 'Y',
912: last_update_date = sysdate,
913: last_updated_by = fnd_global.user_id
914: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 941: UPDATE ozf_sd_batch_lines_int_all

937: last_updated_by = fnd_global.user_id
938: WHERE batch_id = l_batch_id;
939:
940: --Mark all rows as processed
941: UPDATE ozf_sd_batch_lines_int_all
942: SET processed_flag = 'Y',
943: last_update_date = sysdate,
944: last_updated_by = fnd_global.user_id
945: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 963: UPDATE ozf_sd_batch_lines_int_all

959:
960: batch_create_approved_line_new(l_batch_id, x_return_status, x_msg_data);
961:
962: --Mark all rows as processed
963: UPDATE ozf_sd_batch_lines_int_all
964: SET processed_flag = 'Y',
965: last_update_date = sysdate,
966: last_updated_by = fnd_global.user_id
967: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1137: ozf_sd_batch_lines_int_all bint

1133: bint.gbl_claim_rej_code8,
1134: bint.gbl_claim_rej_code9,
1135: bint.gbl_claim_rej_code10
1136: FROM ozf_sd_batch_lines_all bl,
1137: ozf_sd_batch_lines_int_all bint
1138: WHERE bl.batch_id = bint.ship_frm_sd_claim_request_id
1139: AND bl.batch_line_number = bint.batch_line_number
1140: AND bl.status_code = 'REJECTED'
1141: AND bint.ship_frm_sd_claim_request_id = p_batch_number

Line 1309: FROM ozf_sd_batch_lines_int_all intr, ozf_sd_batch_lines_all bl

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
1310: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1311: AND intr.processed_flag = 'N'
1312: AND bl.purge_flag <> 'Y'
1313: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1328: UPDATE ozf_sd_batch_lines_int_all

1324: v_rejected_lines.gbl_claim_rej_code8 IS NULL AND
1325: v_rejected_lines.gbl_claim_rej_code9 IS NULL AND
1326: v_rejected_lines.gbl_claim_rej_code10 IS NULL THEN
1327:
1328: UPDATE ozf_sd_batch_lines_int_all
1329: SET gbl_claim_rej_code10 = 'OZF_SD_DATA_ERROR',
1330: validation_txt = 'REJECTION CODE MISSING',
1331: last_update_date = sysdate,
1332: last_updated_by = fnd_global.user_id

Line 1348: UPDATE ozf_sd_batch_lines_int_all

1344: WHERE batch_id = p_batch_id
1345: AND batch_line_number = v_rejected_lines.batch_line_number;
1346:
1347: IF l_currency_code <> v_rejected_lines.vendor_auth_cost_currency_code THEN
1348: UPDATE ozf_sd_batch_lines_int_all
1349: SET validation_txt = 'CURRENCY CODE NOT MATCHING',
1350: gbl_claim_rej_code10 = 'OZF_SD_DATA_ERROR',
1351: gbl_claim_disposition_code = 'REJECTED',
1352: last_update_date = sysdate,

Line 1363: UPDATE ozf_sd_batch_lines_int_all

1359:
1360: END IF;
1361:
1362: IF v_rejected_lines.vendor_auth_cost_monetary_amt < 0 THEN
1363: UPDATE ozf_sd_batch_lines_int_all
1364: SET validation_txt = 'VENDOR_AUTH_COST_MONETARY_AMT CAN NOT BE NEGATIVE',
1365: gbl_claim_rej_code10 = 'OZF_SD_DATA_ERROR',
1366: last_update_date = sysdate,
1367: last_updated_by = fnd_global.user_id