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 1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1686:
1687: EXCEPTION
1688: WHEN app_exception.application_exception THEN
1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1690: hr_utility.set_location(' Leaving:'||w_proc, 60);
1691: RAISE;
1692: END IF;
1693: hr_utility.set_location(' Leaving:'||w_proc, 70);

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

1902: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1903:
1904: EXCEPTION
1905: WHEN app_exception.application_exception THEN
1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1907: hr_utility.set_location(' Leaving:'||w_proc, 60);
1908: RAISE;
1909: END IF;
1910: hr_utility.set_location(' Leaving:'||w_proc, 70);

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

1978: end if;
1979: --
1980: EXCEPTION
1981: WHEN app_exception.application_exception THEN
1982: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;
1986: END IF;

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

2013: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2014: --
2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;

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

2075: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2076: --
2077: EXCEPTION
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2080: hr_utility.set_location(' Leaving:'||w_proc, 40);
2081: RAISE;
2082: END IF;
2083: hr_utility.set_location(' Leaving:'||w_proc, 50);

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

2365: --
2366: hr_utility.set_location ('Leaving:'||l_proc,10);
2367: EXCEPTION
2368: WHEN app_exception.application_exception THEN
2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);
2371: RAISE;
2372: END IF;
2373: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3039:
3040: hr_utility.set_location(' Leaving:'||l_proc, 10);
3041: EXCEPTION
3042: WHEN app_exception.application_exception THEN
3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);
3045: RAISE;
3046: END IF;
3047: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3162: END IF;
3163: End if;
3164: EXCEPTION
3165: WHEN app_exception.application_exception THEN
3166: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3167: hr_utility.set_location(' Leaving:'||l_proc, 40);
3168: RAISE;
3169: END IF;
3170: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3214: end if;
3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION
3217: WHEN app_exception.application_exception THEN
3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);
3220: RAISE;
3221: END IF;
3222: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION
3365: WHEN app_exception.application_exception THEN
3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);
3368: RAISE;
3369: END IF;
3370: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3418: end if;
3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION
3421: WHEN app_exception.application_exception THEN
3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);
3424: RAISE;
3425: END IF;
3426: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3476: end if;
3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION
3479: WHEN app_exception.application_exception THEN
3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);
3482: RAISE;
3483: END IF;
3484: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3534: end if;
3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION
3537: WHEN app_exception.application_exception THEN
3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);
3540: RAISE;
3541: END IF;
3542: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION
3587: WHEN app_exception.application_exception THEN
3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);
3590: RAISE;
3591: END IF;
3592: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3646: hr_utility.set_location('Leaving:'||l_proc, 20);
3647:
3648: EXCEPTION
3649: WHEN app_exception.application_exception THEN
3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3651: hr_utility.set_location('Leaving:'||l_proc, 40);
3652: RAISE;
3653: END IF;
3654: hr_utility.set_location('Leaving:'||l_proc, 50);

Line 3685: hr_multi_message.end_validation_set;

3681: -- Validate Important Attributes
3682: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3683: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3684: --
3685: hr_multi_message.end_validation_set;
3686:
3687: VALIDITY_CHECKS (
3688: P_REC => P_REC);
3689:

Line 3733: hr_multi_message.end_validation_set;

3729: -- Validate Important Attributes
3730: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3731: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3732: --
3733: hr_multi_message.end_validation_set;
3734:
3735: VALIDITY_CHECKS (
3736: P_REC => P_REC);
3737: --