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_GLOBAL

Line 28: last_updated_by = fnd_global.user_id

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
30: AND batch_line_number = p_batch_line_number
31: AND processed_flag = 'N';
32:

Line 685: last_updated_by = fnd_global.user_id

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
687: AND processed_flag = 'N';
688: COMMIT;
689: x_return_status := fnd_api.g_ret_sts_error;

Line 709: last_updated_by = fnd_global.user_id

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
710: WHERE ship_frm_sd_claim_request_id = p_batch_number
711: AND processed_flag = 'N';
712: COMMIT;
713: x_return_status := fnd_api.g_ret_sts_error;

Line 729: last_updated_by = fnd_global.user_id

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
731: AND processed_flag = 'N';
732: COMMIT;
733: x_return_status := fnd_api.g_ret_sts_error;

Line 781: last_updated_by = fnd_global.user_id

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
782: WHERE ship_frm_sd_claim_request_id = v_batch_lines.batch_id
783: AND batch_line_number = v_batch_lines.batch_line_number
784: AND processed_flag = 'N';
785:

Line 805: last_updated_by = fnd_global.user_id

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
806: WHERE ship_frm_sd_claim_request_id = p_batch_number
807: AND batch_line_number = v_missing_invalid_sts_lines.batch_line_number;
808:
809: x_return_status := fnd_api.g_ret_sts_error;

Line 818: last_updated_by = fnd_global.user_id

814: approved_amount = v_missing_invalid_sts_lines.vendor_auth_cost_monetary_amt,
815: approved_currency_code = v_missing_invalid_sts_lines.vendor_auth_cost_currency_code,
816: object_version_number = object_version_number + 1,
817: last_update_date = sysdate,
818: last_updated_by = fnd_global.user_id
819: WHERE batch_id = l_batch_id
820: AND batch_line_number = v_missing_invalid_sts_lines.batch_line_number
821: AND purge_flag <> 'Y' ;
822:

Line 840: last_updated_by = fnd_global.user_id

836: approved_amount = v_reject_lines.vendor_auth_cost_monetary_amt,
837: approved_currency_code = v_reject_lines.vendor_auth_cost_currency_code,
838: object_version_number = object_version_number + 1,
839: last_update_date = sysdate,
840: last_updated_by = fnd_global.user_id
841: WHERE batch_id = l_batch_id
842: AND batch_line_number = v_reject_lines.batch_line_number
843: AND purge_flag <> 'Y';
844:

Line 861: last_updated_by = fnd_global.user_id

857: approved_amount = agreement_price,
858: approved_currency_code = agreement_currency_code,
859: object_version_number = object_version_number + 1,
860: last_update_date = sysdate,
861: last_updated_by = fnd_global.user_id
862: WHERE batch_id = l_batch_id
863: AND batch_line_number = v_accepted_lines.batch_line_number
864: AND purge_flag <> 'Y';
865:

Line 905: last_updated_by = fnd_global.user_id

901: UPDATE ozf_sd_batch_headers_all
902: SET status_code = 'WIP',
903: object_version_number = object_version_number + 1,
904: last_update_date = sysdate,
905: last_updated_by = fnd_global.user_id
906: WHERE batch_id = l_batch_id;
907:
908:
909:

Line 913: last_updated_by = fnd_global.user_id

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
915: AND processed_flag = 'N';
916:
917: COMMIT;

Line 937: last_updated_by = fnd_global.user_id

933: UPDATE ozf_sd_batch_headers_all
934: SET status_code = 'APPROVED',
935: object_version_number = object_version_number + 1,
936: last_update_date = sysdate,
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

Line 944: last_updated_by = fnd_global.user_id

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
946: AND processed_flag = 'N';
947:
948: COMMIT;

Line 966: last_updated_by = fnd_global.user_id

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
968: AND processed_flag = 'N';
969:
970: COMMIT;

Line 1070: last_updated_by = fnd_global.user_id

1066: SET status_code = 'WIP',
1067: object_version_number = object_version_number + 1,
1068: claim_minor_version = l_claim_minor_version + 1,
1069: last_update_date = sysdate,
1070: last_updated_by = fnd_global.user_id
1071: -- child_batch_id = l_new_batch_id
1072: WHERE batch_id = p_batch_id;
1073:
1074: /*set batch header as APPROVED for child batch*/

Line 1082: last_updated_by = fnd_global.user_id

1078: claim_number = l_claim_number||'_'||l_claim_minor_version,
1079: claim_minor_version = l_claim_minor_version,
1080: object_version_number = object_version_number + 1,
1081: last_update_date = sysdate,
1082: last_updated_by = fnd_global.user_id
1083: WHERE batch_id = l_new_batch_id ;
1084:
1085: update_rejected_line_data(l_batch_number, p_batch_id, l_new_batch_id, x_return_status, x_msg_data);
1086:

Line 1099: last_updated_by = fnd_global.user_id

1095: UPDATE ozf_sd_batch_lines_all
1096: SET batch_id = l_new_batch_id,
1097: object_version_number = object_version_number + 1,
1098: last_update_date = sysdate,
1099: last_updated_by = fnd_global.user_id
1100: WHERE batch_line_number = v_update_batch.batch_line_number AND
1101: batch_id = v_update_batch.batch_id;
1102:
1103: END LOOP;

Line 1229: fnd_global.user_id,

1225: l_disputes(i),
1226: NULL, --review flag
1227: sysdate,
1228: sysdate,
1229: fnd_global.user_id,
1230: fnd_global.conc_request_id,
1231: fnd_global.user_id,
1232: NULL, --created from
1233: fnd_global.conc_login_id,

Line 1230: fnd_global.conc_request_id,

1226: NULL, --review flag
1227: sysdate,
1228: sysdate,
1229: fnd_global.user_id,
1230: fnd_global.conc_request_id,
1231: fnd_global.user_id,
1232: NULL, --created from
1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,

Line 1231: fnd_global.user_id,

1227: sysdate,
1228: sysdate,
1229: fnd_global.user_id,
1230: fnd_global.conc_request_id,
1231: fnd_global.user_id,
1232: NULL, --created from
1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,
1235: NULL, --l_program_update_date,

Line 1233: fnd_global.conc_login_id,

1229: fnd_global.user_id,
1230: fnd_global.conc_request_id,
1231: fnd_global.user_id,
1232: NULL, --created from
1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,
1235: NULL, --l_program_update_date,
1236: fnd_global.conc_program_id, -- p_Operating_Unit,
1237: fnd_global.security_group_id);

Line 1234: fnd_global.prog_appl_id, --l_program_application_id,

1230: fnd_global.conc_request_id,
1231: fnd_global.user_id,
1232: NULL, --created from
1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,
1235: NULL, --l_program_update_date,
1236: fnd_global.conc_program_id, -- p_Operating_Unit,
1237: fnd_global.security_group_id);
1238: END LOOP;

Line 1236: fnd_global.conc_program_id, -- p_Operating_Unit,

1232: NULL, --created from
1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,
1235: NULL, --l_program_update_date,
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',

Line 1237: fnd_global.security_group_id);

1233: fnd_global.conc_login_id,
1234: fnd_global.prog_appl_id, --l_program_application_id,
1235: NULL, --l_program_update_date,
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');

Line 1285: last_updated_by = fnd_global.user_id,

1281: UPDATE ozf_sd_batch_headers_all
1282: SET status_code = 'CLOSED',
1283: claim_id = l_claim_id,
1284: last_update_date = sysdate,
1285: last_updated_by = fnd_global.user_id,
1286: object_version_number = object_version_number + 1
1287: WHERE batch_id = p_batch_id;
1288: ELSE
1289: x_return_status := l_claim_ret_status;

Line 1332: last_updated_by = fnd_global.user_id

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
1333: WHERE batch_line_number = v_rejected_lines.batch_line_number
1334: AND ship_frm_sd_claim_request_id = p_batch_number;
1335:
1336: x_return_status := fnd_api.g_ret_sts_error;

Line 1353: last_updated_by = fnd_global.user_id

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,
1353: last_updated_by = fnd_global.user_id
1354: WHERE batch_line_number = v_rejected_lines.batch_line_number AND
1355: ship_frm_sd_claim_request_id = p_batch_number;
1356:
1357: x_return_status := fnd_api.g_ret_sts_error;

Line 1367: last_updated_by = fnd_global.user_id

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
1368: WHERE batch_line_number = v_rejected_lines.batch_line_number AND
1369: ship_frm_sd_claim_request_id = p_batch_number;
1370:
1371: x_return_status := fnd_api.g_ret_sts_error;

Line 1381: last_updated_by = fnd_global.user_id

1377: SET approved_amount = v_rejected_lines.vendor_auth_cost_monetary_amt,
1378: approved_currency_code = v_rejected_lines.vendor_auth_cost_currency_code,
1379: object_version_number = object_version_number + 1,
1380: last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id
1382: WHERE batch_line_number = v_rejected_lines.batch_line_number AND
1383: batch_id = p_batch_id;
1384:
1385: END LOOP;