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