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_FUNDING_PUB dependencies on FND_REQUEST

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

5665: -- billing 0-th installment
5666: if l_do_billing > 0 then
5667:
5668: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Submitting Billing Concurrent Program to bill 0-th installment...');
5669: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
5670:
5671: -- Bug#6313716 : Invoke the function add_layout to specify the template type,code etc., before submitting request
5672: SELECT
5673: lower(iso_language),iso_territory

Line 5681: l_xml_output:= fnd_request.add_layout(

5677: FND_LANGUAGES
5678: WHERE
5679: language_code = USERENV('LANG');
5680:
5681: l_xml_output:= fnd_request.add_layout(
5682: template_appl_name => 'LNS',
5683: template_code => 'LNSBILLTML',
5684: template_language => l_iso_language,
5685: template_territory => l_iso_territory,

Line 5689: l_request_id := FND_REQUEST.SUBMIT_REQUEST(

5685: template_territory => l_iso_territory,
5686: output_format => 'PDF'
5687: );
5688:
5689: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
5690: 'LNS',
5691: 'LNS_BILLING',
5692: '', '', FALSE,
5693: null,

Line 5969: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

5965: -- If the loan Dates are shifted then regenerate the loan agreement.
5966:
5967: IF l_dates_shifted_flag = 'Y' THEN
5968: /* begin submit request to generate Loan Agreement Report */
5969: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5970: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
5971:
5972: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
5973:

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

5966:
5967: IF l_dates_shifted_flag = 'Y' THEN
5968: /* begin submit request to generate Loan Agreement Report */
5969: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5970: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
5971:
5972: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
5973:
5974: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request

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

5968: /* begin submit request to generate Loan Agreement Report */
5969: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5970: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
5971:
5972: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
5973:
5974: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
5975: SELECT
5976: lower(iso_language),iso_territory

Line 5985: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

5981: WHERE
5982: language_code = USERENV('LANG');
5983:
5984:
5985: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5986:
5987: l_xml_output:= fnd_request.add_layout(
5988: template_appl_name => 'LNS',
5989: template_code => 'LNSRPTAG',

Line 5987: l_xml_output:= fnd_request.add_layout(

5983:
5984:
5985: logMessage(FND_LOG.LEVEL_STATEMENT, ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5986:
5987: l_xml_output:= fnd_request.add_layout(
5988: template_appl_name => 'LNS',
5989: template_code => 'LNSRPTAG',
5990: template_language => l_iso_language,
5991: template_territory => l_iso_territory,

Line 5994: logMessage(FND_LOG.LEVEL_STATEMENT, ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

5990: template_language => l_iso_language,
5991: template_territory => l_iso_territory,
5992: output_format => 'PDF'
5993: );
5994: logMessage(FND_LOG.LEVEL_STATEMENT, ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5995:
5996:
5997: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
5998: ,'LNS_AGREEMENT'

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

5993: );
5994: logMessage(FND_LOG.LEVEL_STATEMENT, ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
5995:
5996:
5997: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
5998: ,'LNS_AGREEMENT'
5999: ,'', '', FALSE
6000: ,l_loan_header_rec.loan_id,'Y');
6001:

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

6002: if l_request_id = 0 then
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
6005: FND_MSG_PUB.Add;
6006: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
6007: RAISE FND_API.G_EXC_ERROR;
6008: else
6009: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
6010: end if;

Line 6012: logMessage(FND_LOG.LEVEL_STATEMENT, ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

6008: else
6009: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
6010: end if;
6011:
6012: logMessage(FND_LOG.LEVEL_STATEMENT, ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
6013: /* end submit request to generate Loan Agreement Report */
6014:
6015: END IF;
6016: --Bug#6169438 END