331: null;
332: EXCEPTION
333: WHEN OTHERS THEN
334:
335: fnd_message.set_name ('OTA','OTA_13658_WF_ERR_GETTING_TYPE');
336: RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
337: p_message_name := SUBSTR(SQLERRM, 1,300);
338: END; /* End Check booking Type */
339:
408: END IF;
409: END IF;
410: -- END IF;
411: IF l_booking_status_row.booking_Status_type_id is null then
412: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
413: RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
414: ELSE
415: WF_ENGINE.setitemattrtext(p_item_type,
416: l_item_key,
441: IF (hr_message.last_message_name = 'OTA_13667_WEB_STATUS_NOT_SEEDE') THEN
442: --
443: -- Seed the user friendly message
444: --
445: fnd_message.set_name ('OTA','OTA_WEB_INCORRECT_CONF');
446: --
447: -- Raise the error for the main procedure exception handler
448: -- to handle
449: --
454: THEN
455: --
456: -- Seed the user friendly message
457: --
458: fnd_message.set_name ('OTA','OTA_NO_DELEGATE_INFORMATION');
459: --
460: -- Raise the error for the main procedure exception handler
461: -- to handle
462: p_message_name := 'OTA_NO_DELEGATE_INFORMATION';
466: THEN
467: --
468: -- Seed the user friendly message
469: --
470: fnd_message.set_name ('OTA','OTA_WEB_WF_PROBLEM');
471: -- Raise the error for the main procedure exception handler
472: -- to handle
473: --
474: p_message_name := fnd_message.get;
470: fnd_message.set_name ('OTA','OTA_WEB_WF_PROBLEM');
471: -- Raise the error for the main procedure exception handler
472: -- to handle
473: --
474: p_message_name := fnd_message.get;
475: p_message_name := SUBSTR(SQLERRM, 1,300);
476: --
477: ELSE
478: -- Raise the error for the main procedure exception handler
490: hr_message.provide_error;
491: --
492: -- Seed the user friendly message
493: --
494: fnd_message.set_name ('OTA','OTA_WEB_ERR_GETTING_INFO');
495: --
496: --
497: -- Raise the error for the main procedure exception handler
498: -- to handle
833: l_mode := l_mode || 'BADWF';
834: --
835:
836: END IF; */
837: p_message_name := fnd_message.get;
838: -- p_message_name := SUBSTR(SQLERRM, 1,300);
839: --
840: END; -- End of if p_message is not null
841:
1294: FETCH csr_person_to_enroll_details INTO l_csr_person_to_enroll_details;
1295: --
1296: IF csr_person_to_enroll_details%NOTFOUND THEN
1297: CLOSE csr_person_to_enroll_details;
1298: fnd_message.set_name('PER','HR_51396_WEB_PERSON_NOT_FND');
1299: RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1300: ELSE
1301: CLOSE csr_person_to_enroll_details;
1302: RETURN l_csr_person_to_enroll_details;
1308: -- Handle the exception in the calling code.
1309: RAISE; --OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1310:
1311: WHEN OTHERS THEN
1312: fnd_message.set_name('PER','HR_51396_WEB_PERSON_NOT_FND');
1313: RAISE;
1314:
1315: END Get_Person_To_Enroll_Details;
1316:
2180: --
2181: -- Set a technical message, then the calling proc can decide
2182: -- what to do.
2183: --
2184: fnd_message.set_name('OTA','OTA_13661_PROB_GETTING_DATA');
2185: --
2186: --
2187: ELSE
2188: --