517:
518: -- Bug 2786500:By default message will have 'EMP_CARD_NUM - EXP_RPT_PURPOSE'
519: -- Message can be modified to have one or combination of the following
520: -- EMP_CARD_NUM, EXP_RPT_PURPOSE, EMP_FULL_NAME
521: FND_MESSAGE.SET_NAME('SQLAP','OIE_INVOICE_DESC');
522: l_description := FND_MESSAGE.GET;
523: l_description := replace(l_description,'EMP_FULL_NAME',l_emp_full_name);
524: l_description := replace(l_description,'EMP_CARD_NUM',l_emp_masked_cc_number);
525: l_description := replace(l_description,'EXP_RPT_PURPOSE',l_exp_rpt_purpose);
518: -- Bug 2786500:By default message will have 'EMP_CARD_NUM - EXP_RPT_PURPOSE'
519: -- Message can be modified to have one or combination of the following
520: -- EMP_CARD_NUM, EXP_RPT_PURPOSE, EMP_FULL_NAME
521: FND_MESSAGE.SET_NAME('SQLAP','OIE_INVOICE_DESC');
522: l_description := FND_MESSAGE.GET;
523: l_description := replace(l_description,'EMP_FULL_NAME',l_emp_full_name);
524: l_description := replace(l_description,'EMP_CARD_NUM',l_emp_masked_cc_number);
525: l_description := replace(l_description,'EXP_RPT_PURPOSE',l_exp_rpt_purpose);
526: p_description := substrb(l_description,1,240); --2227571