DBA Data[Home] [Help]

APPS.LNS_APPROVAL_ACTION_PUB dependencies on FND_REQUEST

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

1182: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1183:
1184: -- moved the defaultDistributions call to Concurrent Process
1185: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
1186: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1187: --call fnd_request_api....
1188: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1189: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1190: ,'LNS_GEN_DIST'

Line 1187: --call fnd_request_api....

1183:
1184: -- moved the defaultDistributions call to Concurrent Process
1185: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
1186: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1187: --call fnd_request_api....
1188: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1189: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1190: ,'LNS_GEN_DIST'
1191: ,'', '', FALSE

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

1184: -- moved the defaultDistributions call to Concurrent Process
1185: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
1186: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1187: --call fnd_request_api....
1188: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1189: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1190: ,'LNS_GEN_DIST'
1191: ,'', '', FALSE
1192: ,l_loan_header_rec.loan_id);

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

1185: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
1186: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1187: --call fnd_request_api....
1188: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1189: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1190: ,'LNS_GEN_DIST'
1191: ,'', '', FALSE
1192: ,l_loan_header_rec.loan_id);
1193: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after call to submit gen distributions request ' || l_request_id);

Line 1210: 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);

1206: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_header_rec.loan_id);
1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1210: 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);
1211: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1212: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1213: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1214: SELECT

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

1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1210: 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);
1211: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1212: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1213: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1214: SELECT
1215: lower(iso_language),iso_territory

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

1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1210: 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);
1211: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1212: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1213: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1214: SELECT
1215: lower(iso_language),iso_territory
1216: INTO

Line 1224: 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);

1220: WHERE
1221: language_code = USERENV('LANG');
1222:
1223:
1224: 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);
1225:
1226: l_xml_output:= fnd_request.add_layout(
1227: template_appl_name => 'LNS',
1228: template_code => 'LNSRPTAG',

Line 1226: l_xml_output:= fnd_request.add_layout(

1222:
1223:
1224: 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);
1225:
1226: l_xml_output:= fnd_request.add_layout(
1227: template_appl_name => 'LNS',
1228: template_code => 'LNSRPTAG',
1229: template_language => l_iso_language,
1230: template_territory => l_iso_territory,

Line 1233: 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);

1229: template_language => l_iso_language,
1230: template_territory => l_iso_territory,
1231: output_format => 'PDF'
1232: );
1233: 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);
1234:
1235:
1236: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1237: ,'LNS_AGREEMENT'

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

1232: );
1233: 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);
1234:
1235:
1236: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1237: ,'LNS_AGREEMENT'
1238: ,'', '', FALSE
1239: ,l_loan_header_rec.loan_id);
1240:

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

1241: if l_request_id = 0 then
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
1244: FND_MSG_PUB.Add;
1245: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1246: RAISE FND_API.G_EXC_ERROR;
1247: else
1248: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1249: end if;

Line 1251: 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);

1247: else
1248: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1249: end if;
1250:
1251: 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);
1252: -- end submit request to generate Loan Agreement Report
1253: */
1254: end if;
1255: