eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WDT_BUS dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_wdt_shd.api_updating
47: (p_worksheet_detail_id => p_worksheet_detail_id,
48: p_object_version_number => p_object_version_number);

Line 72: hr_utility.set_location('Leaving:'||l_proc, 10);

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_worksheet_detail_id;
75: --
76: -- ----------------------------------------------------------------------------

Line 116: hr_utility.set_location('Entering:'||l_proc,5);

112: where a.worksheet_detail_id = p_parent_worksheet_detail_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_wdt_shd.api_updating
119: (p_worksheet_detail_id => p_worksheet_detail_id,
120: p_object_version_number => p_object_version_number);

Line 148: hr_utility.set_location('Leaving:'||l_proc,10);

144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_parent_worksheet_detail_id;
151: --
152: -- ----------------------------------------------------------------------------

Line 192: hr_utility.set_location('Entering:'||l_proc,5);

188: where a.worksheet_id = p_worksheet_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_wdt_shd.api_updating
195: (p_worksheet_detail_id => p_worksheet_detail_id,
196: p_object_version_number => p_object_version_number);

Line 223: hr_utility.set_location('Leaving:'||l_proc,10);

219: close c1;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_worksheet_id;
226: --
227: -- ----------------------------------------------------------------------------

Line 276: hr_utility.set_location('Entering:'||l_proc,5);

272: ANd bdt.budget_id = wks.budget_id;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc,5);
277: --
278: l_api_updating := pqh_wdt_shd.api_updating
279: (p_worksheet_detail_id => p_worksheet_detail_id,
280: p_object_version_number => p_object_version_number);

Line 297: hr_utility.set_message(8302,'PQH_NO_BUDGETED_ENTITY_CD');

293: Fetch c2 into l_budgeted_entity_cd;
294: If c2%notfound then
295: --
296: Close c2;
297: hr_utility.set_message(8302,'PQH_NO_BUDGETED_ENTITY_CD');
298: hr_utility.raise_error;
299: --
300: End if;
301: Close c2;

Line 298: hr_utility.raise_error;

294: If c2%notfound then
295: --
296: Close c2;
297: hr_utility.set_message(8302,'PQH_NO_BUDGETED_ENTITY_CD');
298: hr_utility.raise_error;
299: --
300: End if;
301: Close c2;
302: --

Line 308: hr_utility.set_message(8302,'PQH_GRADE_MUST_BE_NULL');

304: (l_budgeted_entity_cd = 'POSITION' OR
305: l_budgeted_entity_cd = 'JOB' OR
306: l_budgeted_entity_cd = 'ORGANIZATION') then
307: --
308: hr_utility.set_message(8302,'PQH_GRADE_MUST_BE_NULL');
309: hr_utility.raise_error;
310: --
311: End if;
312: **/

Line 309: hr_utility.raise_error;

305: l_budgeted_entity_cd = 'JOB' OR
306: l_budgeted_entity_cd = 'ORGANIZATION') then
307: --
308: hr_utility.set_message(8302,'PQH_GRADE_MUST_BE_NULL');
309: hr_utility.raise_error;
310: --
311: End if;
312: **/
313: --

Line 334: hr_utility.set_location('Leaving:'||l_proc,10);

330: close c1;
331: --
332: end if;
333: --
334: hr_utility.set_location('Leaving:'||l_proc,10);
335: --
336: End chk_grade_id;
337: --
338: -- ----------------------------------------------------------------------------

Line 378: hr_utility.set_location('Entering:'||l_proc,5);

374: where a.job_id = p_job_id;
375: --
376: Begin
377: --
378: hr_utility.set_location('Entering:'||l_proc,5);
379: --
380: l_api_updating := pqh_wdt_shd.api_updating
381: (p_worksheet_detail_id => p_worksheet_detail_id,
382: p_object_version_number => p_object_version_number);

Line 410: hr_utility.set_location('Leaving:'||l_proc,10);

406: close c1;
407: --
408: end if;
409: --
410: hr_utility.set_location('Leaving:'||l_proc,10);
411: --
412: End chk_job_id;
413: --
414: -- ----------------------------------------------------------------------------

Line 454: hr_utility.set_location('Entering:'||l_proc,5);

450: where a.position_transaction_id = p_position_transaction_id;
451: --
452: Begin
453: --
454: hr_utility.set_location('Entering:'||l_proc,5);
455: --
456: l_api_updating := pqh_wdt_shd.api_updating
457: (p_worksheet_detail_id => p_worksheet_detail_id,
458: p_object_version_number => p_object_version_number);

Line 486: hr_utility.set_location('Leaving:'||l_proc,10);

482: close c1;
483: --
484: end if;
485: --
486: hr_utility.set_location('Leaving:'||l_proc,10);
487: --
488: End chk_position_transaction_id;
489: --
490: -- ----------------------------------------------------------------------------

Line 530: hr_utility.set_location('Entering:'||l_proc,5);

526: where a.budget_detail_id = p_budget_detail_id;
527: --
528: Begin
529: --
530: hr_utility.set_location('Entering:'||l_proc,5);
531: --
532: l_api_updating := pqh_wdt_shd.api_updating
533: (p_worksheet_detail_id => p_worksheet_detail_id,
534: p_object_version_number => p_object_version_number);

Line 562: hr_utility.set_location('Leaving:'||l_proc,10);

558: close c1;
559: --
560: end if;
561: --
562: hr_utility.set_location('Leaving:'||l_proc,10);
563: --
564: End chk_budget_detail_id;
565: --
566: -- ----------------------------------------------------------------------------

Line 624: hr_utility.set_location('Entering:'||l_proc,5);

620: where org_structure_version_id = l_org_structure_version_id);
621: --
622: Begin
623: --
624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: l_api_updating := pqh_wdt_shd.api_updating
627: (p_worksheet_detail_id => p_worksheet_detail_id,
628: p_object_version_number => p_object_version_number);

Line 659: hr_utility.set_message(8302,'PQH_WDT_ORG_SRUCTURE_NOT_FOUND');

655: open c2;
656: Fetch c2 into l_start_organization_id,l_org_structure_version_id ;
657: If c2%notfound then
658: Close c2;
659: hr_utility.set_message(8302,'PQH_WDT_ORG_SRUCTURE_NOT_FOUND');
660: hr_utility.raise_error;
661: End if;
662: Close c2;
663: --

Line 660: hr_utility.raise_error;

656: Fetch c2 into l_start_organization_id,l_org_structure_version_id ;
657: If c2%notfound then
658: Close c2;
659: hr_utility.set_message(8302,'PQH_WDT_ORG_SRUCTURE_NOT_FOUND');
660: hr_utility.raise_error;
661: End if;
662: Close c2;
663: --
664: If p_organization_id <> l_start_organization_id then

Line 670: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BDT_ORG_STRUCT');

666: open c3;
667: Fetch c3 into l_dummy;
668: If c3%notfound then
669: Close c3;
670: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BDT_ORG_STRUCT');
671: hr_utility.raise_error;
672: End if;
673: Close c3;
674: --

Line 671: hr_utility.raise_error;

667: Fetch c3 into l_dummy;
668: If c3%notfound then
669: Close c3;
670: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BDT_ORG_STRUCT');
671: hr_utility.raise_error;
672: End if;
673: Close c3;
674: --
675: End if;

Line 680: hr_utility.set_location('Leaving:'||l_proc,10);

676: --
677: --
678: end if;
679: --
680: hr_utility.set_location('Leaving:'||l_proc,10);
681: --
682: End chk_organization_id;
683: --
684: -- ----------------------------------------------------------------------------

Line 720: hr_utility.set_location('Entering:'||l_proc, 5);

716: l_api_updating boolean;
717: --
718: Begin
719: --
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: l_api_updating := pqh_wdt_shd.api_updating
723: (p_worksheet_detail_id => p_worksheet_detail_id,
724: p_object_version_number => p_object_version_number);

Line 741: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

737: p_effective_date => p_effective_date) then
738: --
739: -- raise error as does not exist as lookup
740: --
741: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
742: hr_utility.raise_error;
743: --
744: end if;
745: --

Line 742: hr_utility.raise_error;

738: --
739: -- raise error as does not exist as lookup
740: --
741: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
742: hr_utility.raise_error;
743: --
744: end if;
745: --
746: end if;

Line 748: hr_utility.set_location('Leaving:'||l_proc,10);

744: end if;
745: --
746: end if;
747: --
748: hr_utility.set_location('Leaving:'||l_proc,10);
749: --
750: end chk_defer_flag;
751: --
752: -- ----------------------------------------------------------------------------

Line 788: hr_utility.set_location('Entering:'||l_proc, 5);

784: l_api_updating boolean;
785: --
786: Begin
787: --
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: l_api_updating := pqh_wdt_shd.api_updating
791: (p_worksheet_detail_id => p_worksheet_detail_id,
792: p_object_version_number => p_object_version_number);

Line 809: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

805: p_effective_date => p_effective_date) then
806: --
807: -- raise error as does not exist as lookup
808: --
809: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
810: hr_utility.raise_error;
811: --
812: end if;
813: --

Line 810: hr_utility.raise_error;

806: --
807: -- raise error as does not exist as lookup
808: --
809: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
810: hr_utility.raise_error;
811: --
812: end if;
813: --
814: end if;

Line 816: hr_utility.set_location('Leaving:'||l_proc,10);

812: end if;
813: --
814: end if;
815: --
816: hr_utility.set_location('Leaving:'||l_proc,10);
817: --
818: end chk_budget_unit3_value_type_cd;
819: --
820: -- ----------------------------------------------------------------------------

Line 856: hr_utility.set_location('Entering:'||l_proc, 5);

852: l_api_updating boolean;
853: --
854: Begin
855: --
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: l_api_updating := pqh_wdt_shd.api_updating
859: (p_worksheet_detail_id => p_worksheet_detail_id,
860: p_object_version_number => p_object_version_number);

Line 877: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

873: p_effective_date => p_effective_date) then
874: --
875: -- raise error as does not exist as lookup
876: --
877: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
878: hr_utility.raise_error;
879: --
880: end if;
881: --

Line 878: hr_utility.raise_error;

874: --
875: -- raise error as does not exist as lookup
876: --
877: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
878: hr_utility.raise_error;
879: --
880: end if;
881: --
882: end if;

Line 884: hr_utility.set_location('Leaving:'||l_proc,10);

880: end if;
881: --
882: end if;
883: --
884: hr_utility.set_location('Leaving:'||l_proc,10);
885: --
886: end chk_budget_unit2_value_type_cd;
887: --
888: -- ----------------------------------------------------------------------------

Line 924: hr_utility.set_location('Entering:'||l_proc, 5);

920: l_api_updating boolean;
921: --
922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := pqh_wdt_shd.api_updating
927: (p_worksheet_detail_id => p_worksheet_detail_id,
928: p_object_version_number => p_object_version_number);

Line 945: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

941: p_effective_date => p_effective_date) then
942: --
943: -- raise error as does not exist as lookup
944: --
945: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
946: hr_utility.raise_error;
947: --
948: end if;
949: --

Line 946: hr_utility.raise_error;

942: --
943: -- raise error as does not exist as lookup
944: --
945: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
946: hr_utility.raise_error;
947: --
948: end if;
949: --
950: end if;

Line 952: hr_utility.set_location('Leaving:'||l_proc,10);

948: end if;
949: --
950: end if;
951: --
952: hr_utility.set_location('Leaving:'||l_proc,10);
953: --
954: end chk_budget_unit1_value_type_cd;
955: --
956: -- ----------------------------------------------------------------------------

Line 992: hr_utility.set_location('Entering:'||l_proc, 5);

988: l_api_updating boolean;
989: --
990: Begin
991: --
992: hr_utility.set_location('Entering:'||l_proc, 5);
993: --
994: l_api_updating := pqh_wdt_shd.api_updating
995: (p_worksheet_detail_id => p_worksheet_detail_id,
996: p_object_version_number => p_object_version_number);

Line 1013: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1009: p_effective_date => p_effective_date) then
1010: --
1011: -- raise error as does not exist as lookup
1012: --
1013: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1014: hr_utility.raise_error;
1015: --
1016: end if;
1017: --

Line 1014: hr_utility.raise_error;

1010: --
1011: -- raise error as does not exist as lookup
1012: --
1013: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1014: hr_utility.raise_error;
1015: --
1016: end if;
1017: --
1018: end if;

Line 1020: hr_utility.set_location('Leaving:'||l_proc,10);

1016: end if;
1017: --
1018: end if;
1019: --
1020: hr_utility.set_location('Leaving:'||l_proc,10);
1021: --
1022: end chk_action_cd;
1023: --
1024: --

Line 1061: hr_utility.set_location('Entering:'||l_proc, 5);

1057: l_api_updating boolean;
1058: --
1059: Begin
1060: --
1061: hr_utility.set_location('Entering:'||l_proc, 5);
1062: --
1063: l_api_updating := pqh_wdt_shd.api_updating
1064: (p_worksheet_detail_id => p_worksheet_detail_id,
1065: p_object_version_number => p_object_version_number);

Line 1082: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1078: p_effective_date => p_effective_date) then
1079: --
1080: -- raise error as does not exist as lookup
1081: --
1082: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1083: hr_utility.raise_error;
1084: --
1085: end if;
1086: --

Line 1083: hr_utility.raise_error;

1079: --
1080: -- raise error as does not exist as lookup
1081: --
1082: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1083: hr_utility.raise_error;
1084: --
1085: end if;
1086: --
1087: end if;

Line 1089: hr_utility.set_location('Leaving:'||l_proc,10);

1085: end if;
1086: --
1087: end if;
1088: --
1089: hr_utility.set_location('Leaving:'||l_proc,10);
1090: --
1091: end chk_status;
1092: --
1093: --

Line 1130: hr_utility.set_location('Entering:'||l_proc, 5);

1126: l_api_updating boolean;
1127: --
1128: Begin
1129: --
1130: hr_utility.set_location('Entering:'||l_proc, 5);
1131: --
1132: l_api_updating := pqh_wdt_shd.api_updating
1133: (p_worksheet_detail_id => p_worksheet_detail_id,
1134: p_object_version_number => p_object_version_number);

Line 1151: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1147: p_effective_date => p_effective_date) then
1148: --
1149: -- raise error as does not exist as lookup
1150: --
1151: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1152: hr_utility.raise_error;
1153: --
1154: end if;
1155: --

Line 1152: hr_utility.raise_error;

1148: --
1149: -- raise error as does not exist as lookup
1150: --
1151: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1152: hr_utility.raise_error;
1153: --
1154: end if;
1155: --
1156: end if;

Line 1158: hr_utility.set_location('Leaving:'||l_proc,10);

1154: end if;
1155: --
1156: end if;
1157: --
1158: hr_utility.set_location('Leaving:'||l_proc,10);
1159: --
1160: end chk_propagation_method;
1161: --
1162: --

Line 1205: hr_utility.set_location('Entering:'||l_proc,5);

1201: where a.position_id = p_position_id;
1202: --
1203: Begin
1204: --
1205: hr_utility.set_location('Entering:'||l_proc,5);
1206: --
1207: l_api_updating := pqh_wdt_shd.api_updating
1208: (p_worksheet_detail_id => p_worksheet_detail_id,
1209: p_object_version_number => p_object_version_number);

Line 1229: hr_utility.set_message(8302,'PQH_INVALID_POSITION_ID');

1225: --
1226: -- raise error as FK does not relate to PK in hr_positions_f
1227: -- table.
1228: --
1229: hr_utility.set_message(8302,'PQH_INVALID_POSITION_ID');
1230: hr_utility.raise_error;
1231: --
1232: end if;
1233: --

Line 1230: hr_utility.raise_error;

1226: -- raise error as FK does not relate to PK in hr_positions_f
1227: -- table.
1228: --
1229: hr_utility.set_message(8302,'PQH_INVALID_POSITION_ID');
1230: hr_utility.raise_error;
1231: --
1232: end if;
1233: --
1234: close c1;

Line 1238: hr_utility.set_location('Leaving:'||l_proc,10);

1234: close c1;
1235: --
1236: end if;
1237: --
1238: hr_utility.set_location('Leaving:'||l_proc,10);
1239: --
1240: End chk_position_id;
1241: --
1242: Procedure chk_user_id (p_worksheet_detail_id in number,

Line 1257: hr_utility.set_location('Entering:'||l_proc,5);

1253: where a.user_id = p_user_id;
1254: --
1255: Begin
1256: --
1257: hr_utility.set_location('Entering:'||l_proc,5);
1258: --
1259: l_api_updating := pqh_wdt_shd.api_updating
1260: (p_worksheet_detail_id => p_worksheet_detail_id,
1261: p_object_version_number => p_object_version_number);

Line 1281: hr_utility.set_message(8302,'PQH_INVALID_USER_ID');

1277: --
1278: -- raise error as FK does not relate to PK in hr_positions_f
1279: -- table.
1280: --
1281: hr_utility.set_message(8302,'PQH_INVALID_USER_ID');
1282: hr_utility.raise_error;
1283: --
1284: end if;
1285: --

Line 1282: hr_utility.raise_error;

1278: -- raise error as FK does not relate to PK in hr_positions_f
1279: -- table.
1280: --
1281: hr_utility.set_message(8302,'PQH_INVALID_USER_ID');
1282: hr_utility.raise_error;
1283: --
1284: end if;
1285: --
1286: close c1;

Line 1290: hr_utility.set_location('Leaving:'||l_proc,10);

1286: close c1;
1287: --
1288: end if;
1289: --
1290: hr_utility.set_location('Leaving:'||l_proc,10);
1291: --
1292: End chk_user_id;
1293: --
1294: --

Line 1311: hr_utility.set_location('Entering:'||l_proc,5);

1307: --
1308: --
1309: Begin
1310: --
1311: hr_utility.set_location('Entering:'||l_proc,5);
1312: --
1313: -- Check if all non-numeric values are all +ve / 0
1314: --
1315: l_api_updating := pqh_wdt_shd.api_updating

Line 1328: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

1324: --
1325: -- Raise error if the value is negative
1326: --
1327: If p_budget_unit1_percent < 0 then
1328: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1329: hr_utility.raise_error;
1330: End if;
1331: end if;
1332: --

Line 1329: hr_utility.raise_error;

1325: -- Raise error if the value is negative
1326: --
1327: If p_budget_unit1_percent < 0 then
1328: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1329: hr_utility.raise_error;
1330: End if;
1331: end if;
1332: --
1333: --

Line 1343: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

1339: --
1340: -- Raise error if the value is negative
1341: --
1342: If p_budget_unit1_value < 0 then
1343: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1344: hr_utility.raise_error;
1345: End if;
1346: end if;
1347: --

Line 1344: hr_utility.raise_error;

1340: -- Raise error if the value is negative
1341: --
1342: If p_budget_unit1_value < 0 then
1343: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1344: hr_utility.raise_error;
1345: End if;
1346: end if;
1347: --
1348: --

Line 1359: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');

1355: --
1356: -- Raise error if the value is negative
1357: --
1358: If p_budget_unit1_available < 0 then
1359: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');
1360: hr_utility.raise_error;
1361: End if;
1362: end if;
1363: **/

Line 1360: hr_utility.raise_error;

1356: -- Raise error if the value is negative
1357: --
1358: If p_budget_unit1_available < 0 then
1359: hr_utility.set_message(8302,'PQH_INVALID_UNIT1_CONSUMED');
1360: hr_utility.raise_error;
1361: End if;
1362: end if;
1363: **/
1364: --

Line 1376: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

1372: --
1373: -- Raise error if the value is negative
1374: --
1375: If p_budget_unit2_percent < 0 then
1376: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1377: hr_utility.raise_error;
1378: End if;
1379: end if;
1380: --

Line 1377: hr_utility.raise_error;

1373: -- Raise error if the value is negative
1374: --
1375: If p_budget_unit2_percent < 0 then
1376: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1377: hr_utility.raise_error;
1378: End if;
1379: end if;
1380: --
1381: --

Line 1391: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

1387: --
1388: -- Raise error if the value is negative
1389: --
1390: If p_budget_unit2_value < 0 then
1391: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1392: hr_utility.raise_error;
1393: End if;
1394: end if;
1395: --

Line 1392: hr_utility.raise_error;

1388: -- Raise error if the value is negative
1389: --
1390: If p_budget_unit2_value < 0 then
1391: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1392: hr_utility.raise_error;
1393: End if;
1394: end if;
1395: --
1396: --

Line 1407: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');

1403: --
1404: -- Raise error if the value is negative
1405: --
1406: If p_budget_unit2_available < 0 then
1407: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');
1408: hr_utility.raise_error;
1409: End if;
1410: end if;
1411: **/

Line 1408: hr_utility.raise_error;

1404: -- Raise error if the value is negative
1405: --
1406: If p_budget_unit2_available < 0 then
1407: hr_utility.set_message(8302,'PQH_INVALID_UNIT2_CONSUMED');
1408: hr_utility.raise_error;
1409: End if;
1410: end if;
1411: **/
1412: --

Line 1423: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');

1419: --
1420: -- Raise error if the value is negative
1421: --
1422: If p_budget_unit3_percent < 0 then
1423: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1424: hr_utility.raise_error;
1425: End if;
1426: end if;
1427: --

Line 1424: hr_utility.raise_error;

1420: -- Raise error if the value is negative
1421: --
1422: If p_budget_unit3_percent < 0 then
1423: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_PERCENT');
1424: hr_utility.raise_error;
1425: End if;
1426: end if;
1427: --
1428: --

Line 1438: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');

1434: --
1435: -- Raise error if the value is negative
1436: --
1437: If p_budget_unit3_value < 0 then
1438: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1439: hr_utility.raise_error;
1440: End if;
1441: end if;
1442: --

Line 1439: hr_utility.raise_error;

1435: -- Raise error if the value is negative
1436: --
1437: If p_budget_unit3_value < 0 then
1438: hr_utility.set_message(8302,'PQH_INVALID_BDGT_UNIT_VALUE');
1439: hr_utility.raise_error;
1440: End if;
1441: end if;
1442: --
1443: --

Line 1454: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');

1450: --
1451: -- Raise error if the value is negative
1452: --
1453: If p_budget_unit3_available < 0 then
1454: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');
1455: hr_utility.raise_error;
1456: End if;
1457: end if;
1458: **/

Line 1455: hr_utility.raise_error;

1451: -- Raise error if the value is negative
1452: --
1453: If p_budget_unit3_available < 0 then
1454: hr_utility.set_message(8302,'PQH_INVALID_UNIT3_CONSUMED');
1455: hr_utility.raise_error;
1456: End if;
1457: end if;
1458: **/
1459: --

Line 1461: hr_utility.set_location('Leaving:'||l_proc,10);

1457: end if;
1458: **/
1459: --
1460: --
1461: hr_utility.set_location('Leaving:'||l_proc,10);
1462: --
1463: End chk_numeric_values;
1464: --
1465: -- ----------------------------------------------------------------------------

Line 1474: hr_utility.set_location('Entering:'||l_proc, 5);

1470: --
1471: l_proc varchar2(72) := g_package||'insert_validate';
1472: --
1473: Begin
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: --
1476: -- Call all supporting business operations
1477: --
1478: chk_worksheet_detail_id

Line 1582: hr_utility.set_location(' Leaving:'||l_proc, 10);

1578: p_budget_unit3_percent => p_rec.budget_unit3_percent,
1579: p_budget_unit3_value => p_rec.budget_unit3_value,
1580: p_object_version_number => p_rec.object_version_number);
1581: --
1582: hr_utility.set_location(' Leaving:'||l_proc, 10);
1583: End insert_validate;
1584: --
1585: -- ----------------------------------------------------------------------------
1586: -- |---------------------------< update_validate >----------------------------|

Line 1594: hr_utility.set_location('Entering:'||l_proc, 5);

1590: --
1591: l_proc varchar2(72) := g_package||'update_validate';
1592: --
1593: Begin
1594: hr_utility.set_location('Entering:'||l_proc, 5);
1595: --
1596: -- Call all supporting business operations
1597: --
1598: chk_worksheet_detail_id

Line 1704: hr_utility.set_location(' Leaving:'||l_proc, 10);

1700: p_object_version_number => p_rec.object_version_number);
1701: --
1702: --
1703: --
1704: hr_utility.set_location(' Leaving:'||l_proc, 10);
1705: End update_validate;
1706: --
1707: -- ----------------------------------------------------------------------------
1708: -- |---------------------------< delete_validate >----------------------------|

Line 1716: hr_utility.set_location('Entering:'||l_proc, 5);

1712: --
1713: l_proc varchar2(72) := g_package||'delete_validate';
1714: --
1715: Begin
1716: hr_utility.set_location('Entering:'||l_proc, 5);
1717: --
1718: -- Call all supporting business operations
1719: --
1720: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1720: hr_utility.set_location(' Leaving:'||l_proc, 10);

1716: hr_utility.set_location('Entering:'||l_proc, 5);
1717: --
1718: -- Call all supporting business operations
1719: --
1720: hr_utility.set_location(' Leaving:'||l_proc, 10);
1721: End delete_validate;
1722: --
1723: end pqh_wdt_bus;