593: l_return_msg varchar2(200);
594:
595: BEGIN
596:
597: fnd_message.set_name('OTA', 'OTA_13081_LPE_CRS_CMPL_STATUS');
598: fnd_message.set_token('NO_OF_COMPLETED_COURSES', no_of_completed_courses);
599: fnd_message.set_token('NO_OF_MANDATORY_COURSES', no_of_mandatory_courses);
600: l_return_msg := fnd_message.get;
601:
594:
595: BEGIN
596:
597: fnd_message.set_name('OTA', 'OTA_13081_LPE_CRS_CMPL_STATUS');
598: fnd_message.set_token('NO_OF_COMPLETED_COURSES', no_of_completed_courses);
599: fnd_message.set_token('NO_OF_MANDATORY_COURSES', no_of_mandatory_courses);
600: l_return_msg := fnd_message.get;
601:
602: RETURN l_return_msg;
595: BEGIN
596:
597: fnd_message.set_name('OTA', 'OTA_13081_LPE_CRS_CMPL_STATUS');
598: fnd_message.set_token('NO_OF_COMPLETED_COURSES', no_of_completed_courses);
599: fnd_message.set_token('NO_OF_MANDATORY_COURSES', no_of_mandatory_courses);
600: l_return_msg := fnd_message.get;
601:
602: RETURN l_return_msg;
603:
596:
597: fnd_message.set_name('OTA', 'OTA_13081_LPE_CRS_CMPL_STATUS');
598: fnd_message.set_token('NO_OF_COMPLETED_COURSES', no_of_completed_courses);
599: fnd_message.set_token('NO_OF_MANDATORY_COURSES', no_of_mandatory_courses);
600: l_return_msg := fnd_message.get;
601:
602: RETURN l_return_msg;
603:
604: END get_lpe_crse_compl_status_msg;