[Home] [Help]
1: PACKAGE Body mth_event_PKG AS
2: /*$Header: mthevntb.pls 120.16.12020000.2 2012/07/25 04:03:56 sasuren ship $ */
3:
4: p_event_actions ActionHandlerTableType;
5: p_action_statuses ActionStatusTableType;
295: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
296: l_action_status_rec.notification_id := l_email_id;
297: l_action_status_rec.notification_content := l_content;
298: l_action_status_rec.action_status := l_status;
299: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_NOTIFICATION';
300: l_action_statuses.extend;
301: num_status_rec := num_status_rec + 1;
302: l_action_statuses(num_status_rec) := l_action_status_rec;
303: END IF;
320: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
321: l_action_status_rec.notification_id := l_mobile_id;
322: l_action_status_rec.notification_content := l_content;
323: l_action_status_rec.action_status := l_status;
324: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_NOTIFICATION';
325: l_action_statuses.extend;
326: num_status_rec := num_status_rec + 1;
327: l_action_statuses(num_status_rec) := l_action_status_rec;
328: END IF;
333: EXCEPTION
334: WHEN mailaddress_not_defined THEN
335: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
336: l_action_status_rec.action_status := 'Failed to process notification. Please setup email address or mobile number.';
337: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_NOTIFICATION';
338: l_action_statuses.extend;
339: num_status_rec:=num_status_rec+1;
340: l_action_statuses(num_status_rec) := l_action_status_rec;
341: p_action_statuses := l_action_statuses;
502: EXCEPTION
503: WHEN serial_number_not_found THEN
504: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
505: l_action_status_rec.action_status := 'Failed to invoke EAM_WR due to Serial Number Not Found.';
506: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_EAM_WR';
507: l_action_statuses.extend;
508: num_status_rec := num_status_rec + 1;
509: l_action_statuses(num_status_rec) := l_action_status_rec;
510: p_action_statuses := l_action_statuses;
511:
512: WHEN asset_info_not_found THEN
513: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
514: l_action_status_rec.action_status := 'Failed to invoke EAM_WR due to Asset Information Not Found.';
515: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_EAM_WR';
516: l_action_statuses.extend;
517: num_status_rec := num_status_rec + 1;
518: l_action_statuses(num_status_rec) := l_action_status_rec;
519: p_action_statuses := l_action_statuses;
520:
521: WHEN source_service_not_found THEN
522: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
523: l_action_status_rec.action_status := 'Failed to creat EAM WR due to Source Service is not available.';
524: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_EAM_WR';
525: l_action_statuses.extend;
526: num_status_rec := num_status_rec + 1;
527: l_action_statuses(num_status_rec) := l_action_status_rec;
528: p_action_statuses := l_action_statuses;
529:
530: WHEN OTHERS THEN
531: l_action_status_rec.action_type_code := p_event_action_rec.action_type_code;
532: l_action_status_rec.action_status := 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM;
533: l_action_status_rec.action_handler_api := 'MTH_EVENT_PKG.INVOKE_EVENT_EAM_WR';
534: l_action_statuses.extend;
535: num_status_rec := num_status_rec + 1;
536: l_action_statuses(num_status_rec) := l_action_status_rec;
537: p_action_statuses := l_action_statuses;
690: RETURN 'Failed to process HTTP Request due to Other errors occurs.';
691:
692: END invoke_http_request;
693:
694: END MTH_EVENT_PKG;