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_SETTLEMENT_DOC_PVT dependencies on FND_GLOBAL

Line 1230: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

1226: payment_status = null,
1227: payment_reference_id = DECODE(payment_method,'RMA',null,payment_reference_id),
1228: payment_reference_date = null,
1229: payment_reference_number = DECODE(payment_method,'RMA',null,payment_reference_number),
1230: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1231: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1232: last_update_date = l_sys_date,
1233: settled_date = null,
1234: settled_by = null

Line 1231: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

1227: payment_reference_id = DECODE(payment_method,'RMA',null,payment_reference_id),
1228: payment_reference_date = null,
1229: payment_reference_number = DECODE(payment_method,'RMA',null,payment_reference_number),
1230: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1231: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1232: last_update_date = l_sys_date,
1233: settled_date = null,
1234: settled_by = null
1235: WHERE claim_id = p_claim_id;

Line 1283: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

1279: and lkp.lookup_code IN (select status_lookup_code
1280: FROM ap_invoice_payments pay, ap_checks chk
1281: WHERE pay.check_id = chk.check_id
1282: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1283: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1284: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1285: last_update_date = l_sys_date
1286: WHERE claim_id = p_claim_id;
1287: END IF;

Line 1284: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

1280: FROM ap_invoice_payments pay, ap_checks chk
1281: WHERE pay.check_id = chk.check_id
1282: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1283: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1284: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1285: last_update_date = l_sys_date
1286: WHERE claim_id = p_claim_id;
1287: END IF;
1288:

Line 1329: ,p_entered_by => FND_GLOBAL.user_id

1325: ,p_source_object_id => p_claim_id
1326: ,p_source_object_code => 'AMS_CLAM'
1327: ,p_notes => l_notif_body
1328: ,p_note_status => NULL
1329: ,p_entered_by => FND_GLOBAL.user_id
1330: ,p_entered_date => SYSDATE
1331: ,p_last_updated_by => FND_GLOBAL.user_id
1332: ,x_jtf_note_id => l_note_id
1333: ,p_note_type => 'AMS_JUSTIFICATION'

Line 1331: ,p_last_updated_by => FND_GLOBAL.user_id

1327: ,p_notes => l_notif_body
1328: ,p_note_status => NULL
1329: ,p_entered_by => FND_GLOBAL.user_id
1330: ,p_entered_date => SYSDATE
1331: ,p_last_updated_by => FND_GLOBAL.user_id
1332: ,x_jtf_note_id => l_note_id
1333: ,p_note_type => 'AMS_JUSTIFICATION'
1334: ,p_last_update_date => l_sys_date
1335: ,p_creation_date => l_sys_date);

Line 2132: , last_updated_by = NVL(FND_GLOBAL.user_id,-1) -- hbandi added this line of code for resolving the Bug # 9793391 .

2128: SET payment_status = p_payment_status
2129: , status_code = p_status_code
2130: , user_status_id = l_claim_rec.user_status_id
2131: , last_update_date = SYSDATE -- hbandi added this line of code for resolving the Bug # 9793391 .
2132: , last_updated_by = NVL(FND_GLOBAL.user_id,-1) -- hbandi added this line of code for resolving the Bug # 9793391 .
2133: WHERE claim_id = p_claim_id;
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 5435: l_created_by := NVL(FND_GLOBAL.user_id,-1);

5431: END IF;
5432:
5433: x_return_status := FND_API.g_ret_sts_success;
5434:
5435: l_created_by := NVL(FND_GLOBAL.user_id,-1);
5436: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
5437: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5438: l_settlement_doc_rec.object_version_number := 1;
5439:

Line 5436: l_updated_by := NVL(FND_GLOBAL.user_id,-1);

5432:
5433: x_return_status := FND_API.g_ret_sts_success;
5434:
5435: l_created_by := NVL(FND_GLOBAL.user_id,-1);
5436: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
5437: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5438: l_settlement_doc_rec.object_version_number := 1;
5439:
5440: --------------------- validate -----------------------

Line 5437: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

5433: x_return_status := FND_API.g_ret_sts_success;
5434:
5435: l_created_by := NVL(FND_GLOBAL.user_id,-1);
5436: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
5437: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5438: l_settlement_doc_rec.object_version_number := 1;
5439:
5440: --------------------- validate -----------------------
5441: -- Validate Environment

Line 5442: IF FND_GLOBAL.user_Id IS NULL THEN

5438: l_settlement_doc_rec.object_version_number := 1;
5439:
5440: --------------------- validate -----------------------
5441: -- Validate Environment
5442: IF FND_GLOBAL.user_Id IS NULL THEN
5443: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');
5444: RAISE FND_API.G_EXC_ERROR;
5445: END IF;
5446:

Line 5529: p_last_updated_by => FND_GLOBAL.USER_ID,

5525: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5526: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5527: px_object_version_number => l_settlement_doc_rec.object_version_number,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_creation_date => SYSDATE,
5531: p_created_by => FND_GLOBAL.USER_ID,
5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

Line 5531: p_created_by => FND_GLOBAL.USER_ID,

5527: px_object_version_number => l_settlement_doc_rec.object_version_number,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_creation_date => SYSDATE,
5531: p_created_by => FND_GLOBAL.USER_ID,
5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5535: p_program_update_date => SYSDATE,

Line 5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_creation_date => SYSDATE,
5531: p_created_by => FND_GLOBAL.USER_ID,
5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5535: p_program_update_date => SYSDATE,
5536: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_creation_date => SYSDATE,
5531: p_created_by => FND_GLOBAL.USER_ID,
5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5535: p_program_update_date => SYSDATE,
5536: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5537: p_created_from => l_settlement_doc_rec.created_from,

Line 5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

5530: p_creation_date => SYSDATE,
5531: p_created_by => FND_GLOBAL.USER_ID,
5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5535: p_program_update_date => SYSDATE,
5536: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5537: p_created_from => l_settlement_doc_rec.created_from,
5538: p_claim_id => l_settlement_doc_rec.claim_id,

Line 5536: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

5532: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5533: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5534: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5535: p_program_update_date => SYSDATE,
5536: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5537: p_created_from => l_settlement_doc_rec.created_from,
5538: p_claim_id => l_settlement_doc_rec.claim_id,
5539: p_claim_line_id => l_settlement_doc_rec.claim_line_id,
5540: p_payment_method => l_settlement_doc_rec.payment_method,

Line 5725: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);

5721:
5722: x_return_status := FND_API.g_ret_sts_success;
5723:
5724:
5725: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
5726: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5727:
5728:
5729: ----------------------- validate ----------------------

Line 5726: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

5722: x_return_status := FND_API.g_ret_sts_success;
5723:
5724:
5725: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
5726: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5727:
5728:
5729: ----------------------- validate ----------------------
5730: -- Varify object_version_number

Line 5835: p_last_updated_by => FND_GLOBAL.USER_ID,

5831: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5832: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5833: p_object_version_number => l_object_version_number,
5834: p_last_update_date => SYSDATE,
5835: p_last_updated_by => FND_GLOBAL.USER_ID,
5836: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5837: p_request_id => l_complete_doc_rec.request_id,
5838: p_program_application_id => l_complete_doc_rec.program_application_id,
5839: p_program_update_date => l_complete_doc_rec.program_update_date,

Line 5836: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5832: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5833: p_object_version_number => l_object_version_number,
5834: p_last_update_date => SYSDATE,
5835: p_last_updated_by => FND_GLOBAL.USER_ID,
5836: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5837: p_request_id => l_complete_doc_rec.request_id,
5838: p_program_application_id => l_complete_doc_rec.program_application_id,
5839: p_program_update_date => l_complete_doc_rec.program_update_date,
5840: p_program_id => l_complete_doc_rec.program_id,

Line 5893: request_id = FND_GLOBAL.CONC_REQUEST_ID,

5889: object_version_number = l_object_version_number,
5890: last_update_date = SYSDATE,
5891: last_updated_by = l_last_updated_by,
5892: last_update_login = l_last_update_login,
5893: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5894: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5895: program_update_date = SYSDATE,
5896: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5897: created_from = l_complete_doc_rec.created_from,

Line 5894: program_application_id = FND_GLOBAL.PROG_APPL_ID,

5890: last_update_date = SYSDATE,
5891: last_updated_by = l_last_updated_by,
5892: last_update_login = l_last_update_login,
5893: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5894: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5895: program_update_date = SYSDATE,
5896: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5897: created_from = l_complete_doc_rec.created_from,
5898: claim_id = l_complete_doc_rec.claim_id,

Line 5896: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

5892: last_update_login = l_last_update_login,
5893: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5894: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5895: program_update_date = SYSDATE,
5896: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5897: created_from = l_complete_doc_rec.created_from,
5898: claim_id = l_complete_doc_rec.claim_id,
5899: claim_line_id = l_complete_doc_rec.claim_line_id,
5900: payment_method = l_complete_doc_rec.payment_method,