DBA Data[Home] [Help]

APPS.PQP_PTY_BUS dependencies on HR_MULTI_MESSAGE

Line 76: if hr_multi_message.exception_add

72: end if;
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
74: exception
75: when app_exception.application_exception then
76: if hr_multi_message.exception_add
77: (p_associated_column1 => 'PQP_PENSION_TYPES_F.CONTRIBUTION_CONVERSION_RULE'
78: ) then
79: hr_utility.set_location(' Leaving:'|| l_proc, 30);
80: raise;

Line 145: if hr_multi_message.exception_add

141: end if;
142: hr_utility.set_location(' Leaving:'|| l_proc, 20);
143: exception
144: when app_exception.application_exception then
145: if hr_multi_message.exception_add
146: (p_associated_column1 => 'PQP_PENSION_TYPES_F.THRESHOLD_CONVERSION_RULE'
147: ) then
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
149: raise;

Line 217: if hr_multi_message.exception_add

213: end if;
214: hr_utility.set_location(' Leaving:'|| l_proc, 20);
215: exception
216: when app_exception.application_exception then
217: if hr_multi_message.exception_add
218: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_CATEGORY'
219: ) then
220: hr_utility.set_location(' Leaving:'|| l_proc, 30);
221: raise;

Line 286: if hr_multi_message.exception_add

282: end if;
283: hr_utility.set_location(' Leaving:'|| l_proc, 20);
284: exception
285: when app_exception.application_exception then
286: if hr_multi_message.exception_add
287: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_PROVIDER_TYPE'
288: ) then
289: hr_utility.set_location(' Leaving:'|| l_proc, 30);
290: raise;

Line 354: if hr_multi_message.exception_add

350: end if;
351: hr_utility.set_location(' Leaving:'|| l_proc, 20);
352: exception
353: when app_exception.application_exception then
354: if hr_multi_message.exception_add
355: (p_associated_column1 => 'PQP_PENSION_TYPES_F.SALARY_CALCULATION_METHOD'
356: ) then
357: hr_utility.set_location(' Leaving:'|| l_proc, 30);
358: raise;

Line 452: if hr_multi_message.exception_add

448: end if;
449: hr_utility.set_location(' Leaving:'|| l_proc, 20);
450: exception
451: when app_exception.application_exception then
452: if hr_multi_message.exception_add
453: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_TYPE_NAME'
454: ) then
455: hr_utility.set_location(' Leaving:'|| l_proc, 30);
456: raise;

Line 547: if hr_multi_message.exception_add

543:
544: hr_utility.set_location(' Leaving:'|| l_proc, 20);
545: exception
546: when app_exception.application_exception then
547: if hr_multi_message.exception_add
548: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_TYPE_ID'
549: ) then
550: hr_utility.set_location(' Leaving:'|| l_proc, 30);
551: raise;

Line 616: if hr_multi_message.exception_add

612: end if;
613: hr_utility.set_location(' Leaving:'|| l_proc, 20);
614: exception
615: when app_exception.application_exception then
616: if hr_multi_message.exception_add
617: (p_associated_column1 => 'PQP_PENSION_TYPES_F.SPECIAL_PENSION_TYPE_CODE'
618: ) then
619: hr_utility.set_location(' Leaving:'|| l_proc, 30);
620: raise;

Line 685: if hr_multi_message.exception_add

681: end if;
682: hr_utility.set_location(' Leaving:'|| l_proc, 20);
683: exception
684: when app_exception.application_exception then
685: if hr_multi_message.exception_add
686: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_SUB_CATEGORY'
687: ) then
688: hr_utility.set_location(' Leaving:'|| l_proc, 30);
689: raise;

Line 754: if hr_multi_message.exception_add

750: end if;
751: hr_utility.set_location(' Leaving:'|| l_proc, 20);
752: exception
753: when app_exception.application_exception then
754: if hr_multi_message.exception_add
755: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_BASIS_CALC_METHOD'
756: ) then
757: hr_utility.set_location(' Leaving:'|| l_proc, 30);
758: raise;

Line 823: if hr_multi_message.exception_add

819: end if;
820: hr_utility.set_location(' Leaving:'|| l_proc, 20);
821: exception
822: when app_exception.application_exception then
823: if hr_multi_message.exception_add
824: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PREVIOUS_YEAR_BONUS_INCLUDED'
825: ) then
826: hr_utility.set_location(' Leaving:'|| l_proc, 30);
827: raise;

Line 892: if hr_multi_message.exception_add

888: end if;
889: hr_utility.set_location(' Leaving:'|| l_proc, 20);
890: exception
891: when app_exception.application_exception then
892: if hr_multi_message.exception_add
893: (p_associated_column1 => 'PQP_PENSION_TYPES_F.RECURRING_BONUS_PERIOD'
894: ) then
895: hr_utility.set_location(' Leaving:'|| l_proc, 30);
896: raise;

Line 961: if hr_multi_message.exception_add

957: end if;
958: hr_utility.set_location(' Leaving:'|| l_proc, 20);
959: exception
960: when app_exception.application_exception then
961: if hr_multi_message.exception_add
962: (p_associated_column1 => 'PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_PERIOD'
963: ) then
964: hr_utility.set_location(' Leaving:'|| l_proc, 30);
965: raise;

Line 1064: if hr_multi_message.exception_add

1060: end if;
1061: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1062: exception
1063: when app_exception.application_exception then
1064: if hr_multi_message.exception_add
1065: (p_associated_column1 => 'PQP_PENSION_TYPES_F.PENSION_SALARY_BALANCE'
1066: ) then
1067: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1068: raise;

Line 1133: if hr_multi_message.exception_add

1129: end if;
1130: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1131: exception
1132: when app_exception.application_exception then
1133: if hr_multi_message.exception_add
1134: (p_associated_column1 => 'PQP_PENSION_TYPES_F.EE_AGE_THRESHOLD'
1135: ) then
1136: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1137: raise;

Line 1202: if hr_multi_message.exception_add

1198: end if;
1199: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1200: exception
1201: when app_exception.application_exception then
1202: if hr_multi_message.exception_add
1203: (p_associated_column1 => 'PQP_PENSION_TYPES_F.ER_AGE_THRESHOLD'
1204: ) then
1205: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1206: raise;

Line 1271: if hr_multi_message.exception_add

1267: end if;
1268: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1269: exception
1270: when app_exception.application_exception then
1271: if hr_multi_message.exception_add
1272: (p_associated_column1 => 'PQP_PENSION_TYPES_F.EE_AGE_CONTRIBUTION'
1273: ) then
1274: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1275: raise;

Line 1340: if hr_multi_message.exception_add

1336: end if;
1337: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1338: exception
1339: when app_exception.application_exception then
1340: if hr_multi_message.exception_add
1341: (p_associated_column1 => 'PQP_PENSION_TYPES_F.ER_AGE_CONTRIBUTION'
1342: ) then
1343: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1344: raise;

Line 1446: hr_multi_message.add

1442: --
1443: -- The primary key is invalid therefore we must error
1444: --
1445: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1446: hr_multi_message.add
1447: (p_associated_column1
1448: => nvl(p_associated_column1,'PENSION_TYPE_ID')
1449: );
1450: --

Line 2158: hr_multi_message.end_validation_set;

2154: -- after validating the set of important attributes,
2155: -- if Multiple Message Detection is enabled and at least
2156: -- one error has been found then abort further validation.
2157: --
2158: hr_multi_message.end_validation_set;
2159: END IF;
2160: --
2161:
2162: IF p_rec.business_group_id IS NOT NULL THEN

Line 2450: hr_multi_message.end_validation_set;

2446: -- After validating the set of important attributes,
2447: -- if Multiple Message Detection is enabled and at least
2448: -- one error has been found then abort further validation.
2449: --
2450: hr_multi_message.end_validation_set;
2451: END IF;
2452: --
2453: --
2454: -- Validate Dependent Attributes

Line 2776: hr_multi_message.end_validation_set;

2772: -- After validating the set of important attributes,
2773: -- if Multiple Message Detection is enabled and at least
2774: -- one error has been found then abort further validation.
2775: --
2776: hr_multi_message.end_validation_set;
2777: END IF;
2778: --
2779: -- Call all supporting business operations
2780: --

Line 2828: hr_multi_message.add();

2824: If c_chk_org_info%FOUND THEN
2825: CLOSE c_chk_org_info;
2826: hr_utility.set_location('Found org info for the PT'||l_proc,30);
2827: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');
2828: hr_multi_message.add();
2829: Else
2830: CLOSE c_chk_org_info;
2831: End If;
2832:

Line 2840: hr_multi_message.add();

2836: If c_chk_asg_info%FOUND THEN
2837: CLOSE c_chk_asg_info;
2838: hr_utility.set_location('Found ASG info for the PT'||l_proc,40);
2839: fnd_message.set_name('PQP','PQP_230049_ASG_INFO_EXISTS');
2840: hr_multi_message.add();
2841: Else
2842: CLOSE c_chk_asg_info;
2843: End If;
2844:

Line 2868: hr_multi_message.add();

2864: If l_max_org_end_dt <> p_effective_date THEN
2865: hr_utility.set_location('Found future dates org eit rows'||l_proc,60);
2866: fnd_message.set_name('PQP','PQP_230050_FUTURE_ORG_INFO');
2867: fnd_message.set_token('ENDDATE',to_char(l_max_org_end_dt));
2868: hr_multi_message.add();
2869: End If;
2870:
2871: -- loop through all asg info rows and fetch the end date greatest than the eff date
2872: FOR temp_rec in c_asg_info_end_dt(p_rec.pension_type_id)

Line 2883: hr_multi_message.add();

2879: If l_max_asg_end_dt <> p_effective_date THEN
2880: hr_utility.set_location('found future dates asg eit rows'||l_proc,70);
2881: fnd_message.set_name('PQP','PQP_230051_FUTURE_ASG_INFO');
2882: fnd_message.set_token('ENDDATE',to_char(l_max_asg_end_dt));
2883: hr_multi_message.add();
2884: End If;
2885:
2886: End If; -- end of date track mode DELETE/ZAP validations
2887:

Line 2918: hr_multi_message.add();

2914: IF c_chk_pggm_org_info%FOUND THEN
2915: CLOSE c_chk_pggm_org_info;
2916: hr_utility.set_location('Found org info for the PT'||l_proc,30);
2917: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');
2918: hr_multi_message.add();
2919: ELSE
2920: CLOSE c_chk_pggm_org_info;
2921: END IF;
2922:

Line 2936: hr_multi_message.add();

2932: IF c_pggm_scheme%FOUND THEN
2933: CLOSE c_pggm_scheme;
2934: hr_utility.set_location('Found scheme info for the PT'||l_proc,30);
2935: fnd_message.set_name('PQP','PQP_2300XX_SCHEME_INFO_EXISTS');
2936: hr_multi_message.add();
2937: ELSE
2938: CLOSE c_pggm_scheme;
2939: END IF;
2940: