DBA Data[Home] [Help]

APPS.OTA_EVT_BUS dependencies on HR_MULTI_MESSAGE

Line 207: hr_multi_message.add

203: --
204: -- The primary key is invalid therefore we must error
205: --
206: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
207: hr_multi_message.add
208: (p_associated_column1 => NVL(p_associated_column1, 'EVENT_ID'));
209: --
210: ELSE
211:

Line 477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

473: hr_utility.set_location('Leaving '||l_proc,10);
474: --
475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;
481: END IF;

Line 519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

515: hr_utility.set_location('Leaving '||l_proc,10);
516: --
517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;
523: END IF;

Line 716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN

712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION
715: WHEN app_exception.application_exception THEN
716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);
718: RAISE;
719: END IF;
720: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN

829: --
830: hr_utility.set_location(' Leaving:'||l_proc,10);
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);
835: RAISE;
836: END IF;
837: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',

883: hr_utility.set_location(' Exitting:'||l_proc,10);
884: --
885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',
888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;
891: END IF;

Line 1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:
1013: EXCEPTION
1014: WHEN app_exception.application_exception THEN
1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1016: hr_utility.set_location(' Leaving:'||l_proc, 40);
1017: RAISE;
1018: END IF;
1019: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN

1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:
1045: EXCEPTION
1046: WHEN app_exception.application_exception THEN
1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN
1048: hr_utility.set_location(' Leaving:'||l_proc, 40);
1049: RAISE;
1050: END IF;
1051: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN

1564: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
1565: --
1566: EXCEPTION
1567: WHEN app_exception.application_exception THEN
1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN
1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);
1570: RAISE;
1571: END IF;
1572: hr_utility.set_location(' Leaving:'||W_PROC, 50);

Line 1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1704: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1705:
1706: EXCEPTION
1707: WHEN app_exception.application_exception THEN
1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1709: hr_utility.set_location(' Leaving:'||w_proc, 60);
1710: RAISE;
1711: END IF;
1712: hr_utility.set_location(' Leaving:'||w_proc, 70);

Line 1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1921: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1922:
1923: EXCEPTION
1924: WHEN app_exception.application_exception THEN
1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1926: hr_utility.set_location(' Leaving:'||w_proc, 60);
1927: RAISE;
1928: END IF;
1929: hr_utility.set_location(' Leaving:'||w_proc, 70);

Line 2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',

1997: end if;
1998: --
1999: EXCEPTION
2000: WHEN app_exception.application_exception THEN
2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;
2005: END IF;

Line 2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',

2032: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2033: --
2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;

Line 2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN

2094: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2095: --
2096: EXCEPTION
2097: WHEN app_exception.application_exception THEN
2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2099: hr_utility.set_location(' Leaving:'||w_proc, 40);
2100: RAISE;
2101: END IF;
2102: hr_utility.set_location(' Leaving:'||w_proc, 50);

Line 2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN

2384: --
2385: hr_utility.set_location ('Leaving:'||l_proc,10);
2386: EXCEPTION
2387: WHEN app_exception.application_exception THEN
2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);
2390: RAISE;
2391: END IF;
2392: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN

3059:
3060: hr_utility.set_location(' Leaving:'||l_proc, 10);
3061: EXCEPTION
3062: WHEN app_exception.application_exception THEN
3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);
3065: RAISE;
3066: END IF;
3067: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN

3182: END IF;
3183: End if;
3184: EXCEPTION
3185: WHEN app_exception.application_exception THEN
3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3187: hr_utility.set_location(' Leaving:'||l_proc, 40);
3188: RAISE;
3189: END IF;
3190: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN

3234: end if;
3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION
3237: WHEN app_exception.application_exception THEN
3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);
3240: RAISE;
3241: END IF;
3242: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN

3382: end if;
3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION
3385: WHEN app_exception.application_exception THEN
3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);
3388: RAISE;
3389: END IF;
3390: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN

3438: end if;
3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION
3441: WHEN app_exception.application_exception THEN
3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);
3444: RAISE;
3445: END IF;
3446: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN

3496: end if;
3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION
3499: WHEN app_exception.application_exception THEN
3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);
3502: RAISE;
3503: END IF;
3504: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN

3554: end if;
3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION
3557: WHEN app_exception.application_exception THEN
3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);
3560: RAISE;
3561: END IF;
3562: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN

3604: close csr_offering;
3605: hr_utility.set_location('Leaving:'||l_proc, 20);
3606: EXCEPTION
3607: WHEN app_exception.application_exception THEN
3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);
3610: RAISE;
3611: END IF;
3612: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN

3666: hr_utility.set_location('Leaving:'||l_proc, 20);
3667:
3668: EXCEPTION
3669: WHEN app_exception.application_exception THEN
3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3671: hr_utility.set_location('Leaving:'||l_proc, 40);
3672: RAISE;
3673: END IF;
3674: hr_utility.set_location('Leaving:'||l_proc, 50);

Line 3705: hr_multi_message.end_validation_set;

3701: -- Validate Important Attributes
3702: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3703: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3704: --
3705: hr_multi_message.end_validation_set;
3706:
3707: VALIDITY_CHECKS (
3708: P_REC => P_REC);
3709:

Line 3753: hr_multi_message.end_validation_set;

3749: -- Validate Important Attributes
3750: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3751: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3752: --
3753: hr_multi_message.end_validation_set;
3754:
3755: VALIDITY_CHECKS (
3756: P_REC => P_REC);
3757: --