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.LNS_APPROVAL_ACTION_PUB dependencies on FND_REQUEST

Line 991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);

987: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
988:
989: -- moved the defaultDistributions call to Concurrent Process
990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
992: --call fnd_request_api....
993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
995: ,'LNS_GEN_DIST'

Line 992: --call fnd_request_api....

988:
989: -- moved the defaultDistributions call to Concurrent Process
990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
992: --call fnd_request_api....
993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
995: ,'LNS_GEN_DIST'
996: ,'', '', FALSE

Line 993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());

989: -- moved the defaultDistributions call to Concurrent Process
990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
992: --call fnd_request_api....
993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
995: ,'LNS_GEN_DIST'
996: ,'', '', FALSE
997: ,l_loan_header_rec.loan_id);

Line 994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'

990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
992: --call fnd_request_api....
993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
995: ,'LNS_GEN_DIST'
996: ,'', '', FALSE
997: ,l_loan_header_rec.loan_id);
998: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after call to submit gen distributions request ' || l_request_id);

Line 1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1027:
1028: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then
1029:
1030: /* begin submit request to generate Loan Agreement Report */
1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1032: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1033: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1034: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1035: SELECT

Line 1032: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);

1028: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then
1029:
1030: /* begin submit request to generate Loan Agreement Report */
1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1032: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1033: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1034: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1035: SELECT
1036: lower(iso_language),iso_territory

Line 1033: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());

1029:
1030: /* begin submit request to generate Loan Agreement Report */
1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1032: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1033: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1034: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1035: SELECT
1036: lower(iso_language),iso_territory
1037: INTO

Line 1045: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1041: WHERE
1042: language_code = USERENV('LANG');
1043:
1044:
1045: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1046:
1047: l_xml_output:= fnd_request.add_layout(
1048: template_appl_name => 'LNS',
1049: template_code => 'LNSRPTAG',

Line 1047: l_xml_output:= fnd_request.add_layout(

1043:
1044:
1045: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1046:
1047: l_xml_output:= fnd_request.add_layout(
1048: template_appl_name => 'LNS',
1049: template_code => 'LNSRPTAG',
1050: template_language => l_iso_language,
1051: template_territory => l_iso_territory,

Line 1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1050: template_language => l_iso_language,
1051: template_territory => l_iso_territory,
1052: output_format => 'PDF'
1053: );
1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1055:
1056:
1057: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1058: ,'LNS_AGREEMENT'

Line 1057: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'

1053: );
1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1055:
1056:
1057: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1058: ,'LNS_AGREEMENT'
1059: ,'', '', FALSE
1060: ,l_loan_header_rec.loan_id);
1061:

Line 1066: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';

1062: if l_request_id = 0 then
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
1065: FND_MSG_PUB.Add;
1066: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1067: RAISE FND_API.G_EXC_ERROR;
1068: else
1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1070: end if;

Line 1072: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1068: else
1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1070: end if;
1071:
1072: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1073: /* end submit request to generate Loan Agreement Report */
1074:
1075: end if;
1076: