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.OTA_TBD_API dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'return_api_dml_status';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 5);
25: --
26: Return (nvl(g_api_dml, false));
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

24: hr_utility.set_location('Entering:'||l_proc, 5);
25: --
26: Return (nvl(g_api_dml, false));
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 10);
29: End return_api_dml_status;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |---------------------------< constraint_error >---------------------------|

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

75: l_proc varchar2(72) := g_package||'constraint_error';
76: --
77: Begin
78: --
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: --
81: -- Foreign keys
82: --
83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then

Line 103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

99: --
100: -- Primary key
101: --
102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then
103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
104: hr_utility.set_message_token('PROCEDURE', l_proc);
105: hr_utility.set_message_token('STEP','25');
106: hr_utility.raise_error;
107: --

Line 104: hr_utility.set_message_token('PROCEDURE', l_proc);

100: -- Primary key
101: --
102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then
103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
104: hr_utility.set_message_token('PROCEDURE', l_proc);
105: hr_utility.set_message_token('STEP','25');
106: hr_utility.raise_error;
107: --
108: -- Check constraints

Line 105: hr_utility.set_message_token('STEP','25');

101: --
102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then
103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
104: hr_utility.set_message_token('PROCEDURE', l_proc);
105: hr_utility.set_message_token('STEP','25');
106: hr_utility.raise_error;
107: --
108: -- Check constraints
109: --

Line 106: hr_utility.raise_error;

102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then
103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
104: hr_utility.set_message_token('PROCEDURE', l_proc);
105: hr_utility.set_message_token('STEP','25');
106: hr_utility.raise_error;
107: --
108: -- Check constraints
109: --
110: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_SEQ') then

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

148: End If;
149: --
150: FND_MESSAGE.RAISE_ERROR;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: --
154: End constraint_error;
155: --
156: -- ----------------------------------------------------------------------------

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

248: l_proc varchar2(72) := g_package||'g_old_rec_current';
249: l_fct_ret boolean;
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: If (
255: p_booking_deal_id is null or
256: p_object_version_number is null

Line 268: hr_utility.set_location(l_proc, 10);

264: If (
265: p_booking_deal_id = g_old_rec.booking_deal_id and
266: p_object_version_number = g_old_rec.object_version_number
267: ) Then
268: hr_utility.set_location(l_proc, 10);
269: --
270: -- The g_old_rec is current therefore we must
271: -- set the returning function to true
272: --

Line 285: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

281: Close C_Sel1;
282: --
283: -- The primary key is invalid therefore we must error
284: --
285: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
286: hr_utility.raise_error;
287: End If;
288: Close C_Sel1;
289: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 286: hr_utility.raise_error;

282: --
283: -- The primary key is invalid therefore we must error
284: --
285: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
286: hr_utility.raise_error;
287: End If;
288: Close C_Sel1;
289: If (p_object_version_number <> g_old_rec.object_version_number) Then
290: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 290: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

286: hr_utility.raise_error;
287: End If;
288: Close C_Sel1;
289: If (p_object_version_number <> g_old_rec.object_version_number) Then
290: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
291: hr_utility.raise_error;
292: End If;
293: hr_utility.set_location(l_proc, 15);
294: l_fct_ret := true;

Line 291: hr_utility.raise_error;

287: End If;
288: Close C_Sel1;
289: If (p_object_version_number <> g_old_rec.object_version_number) Then
290: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
291: hr_utility.raise_error;
292: End If;
293: hr_utility.set_location(l_proc, 15);
294: l_fct_ret := true;
295: End If;

Line 293: hr_utility.set_location(l_proc, 15);

289: If (p_object_version_number <> g_old_rec.object_version_number) Then
290: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
291: hr_utility.raise_error;
292: End If;
293: hr_utility.set_location(l_proc, 15);
294: l_fct_ret := true;
295: End If;
296: End If;
297: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 297: hr_utility.set_location(' Leaving:'||l_proc, 20);

293: hr_utility.set_location(l_proc, 15);
294: l_fct_ret := true;
295: End If;
296: End If;
297: hr_utility.set_location(' Leaving:'||l_proc, 20);
298: Return (l_fct_ret);
299: --
300: End g_old_rec_current;
301: --

Line 342: hr_utility.set_location('Entering:'||l_proc, 10);

338: and a.cancelled_flag = 'N';
339: --
340: begin
341: --
342: hr_utility.set_location('Entering:'||l_proc, 10);
343: hr_utility.set_location('Booking Deal ID '||p_booking_deal_id,10);
344: hr_utility.set_location('Start Date'||p_start_date,10);
345: hr_utility.set_location('End Date'||p_end_date,10);
346: --

Line 343: hr_utility.set_location('Booking Deal ID '||p_booking_deal_id,10);

339: --
340: begin
341: --
342: hr_utility.set_location('Entering:'||l_proc, 10);
343: hr_utility.set_location('Booking Deal ID '||p_booking_deal_id,10);
344: hr_utility.set_location('Start Date'||p_start_date,10);
345: hr_utility.set_location('End Date'||p_end_date,10);
346: --
347: -- Get number of enrollments currently using booking deal

Line 344: hr_utility.set_location('Start Date'||p_start_date,10);

340: begin
341: --
342: hr_utility.set_location('Entering:'||l_proc, 10);
343: hr_utility.set_location('Booking Deal ID '||p_booking_deal_id,10);
344: hr_utility.set_location('Start Date'||p_start_date,10);
345: hr_utility.set_location('End Date'||p_end_date,10);
346: --
347: -- Get number of enrollments currently using booking deal
348: --

Line 345: hr_utility.set_location('End Date'||p_end_date,10);

341: --
342: hr_utility.set_location('Entering:'||l_proc, 10);
343: hr_utility.set_location('Booking Deal ID '||p_booking_deal_id,10);
344: hr_utility.set_location('Start Date'||p_start_date,10);
345: hr_utility.set_location('End Date'||p_end_date,10);
346: --
347: -- Get number of enrollments currently using booking deal
348: --
349: open c_check_enrollments;

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

368: fnd_message.raise_error;
369: --
370: end if;
371: --
372: hr_utility.set_location('Leaving:'||l_proc,10);
373: --
374: end check_dates_conflict;
375: -- ----------------------------------------------------------------------------
376: -- -----------------------------< SUM_AMOUNT >------------------------------

Line 524: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

520: or (TBD.BOOKING_DEAL_ID <> P_BOOKING_DEAL_ID));
521: --
522: begin
523: --
524: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
525: --
526: open C1;
527: fetch C1
528: into W_FLAG;

Line 534: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 99);

530: CONSTRAINT_ERROR ('DUPLICATE_NAME');
531: end if;
532: close C1;
533: --
534: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 99);
535: --
536: end CHECK_UNIQUE_NAME;
537: --
538: -- ----------------------------------------------------------------------------

Line 554: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

550: W_VALID boolean;
551: --
552: begin
553: --
554: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
555: --
556: if (P_APPROVED_BY_PERSON_ID is not null) then
557: if not ota_general.check_fnd_user(p_approved_by_person_id) then
558: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');

Line 564: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 99);

560: end if;
561:
562: end if;
563: --
564: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 99);
565: --
566: end CHECK_APPROVER;
567: --
568: -- ----------------------------------------------------------------------------

Line 603: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

599: end VALID_PREPURCH_CONTEXT;
600: --
601: begin
602: --
603: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
604: --
605: if (not VALID_PREPURCH_CONTEXT (
606: P_NUMBER_OF_PLACES => P_NUMBER_OF_PLACES,
607: P_LIMIT_EACH_EVENT_FLAG => P_LIMIT_EACH_EVENT_FLAG,

Line 612: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

608: P_PRICE_LIST_ID => P_PRICE_LIST_ID)) then
609: CONSTRAINT_ERROR ('OTA_TBD_CHECK_PREPURCH_CONTEXT');
610: end if;
611: --
612: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
613: --
614: end CHECK_PREPURCH_CONTEXT;
615: --
616: -- ----------------------------------------------------------------------------

Line 648: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

644: end VALID_DISCOUNT_CONTEXT;
645: --
646: begin
647: --
648: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
649: --
650: if (not VALID_DISCOUNT_CONTEXT (
651: P_DISCOUNT_PERCENTAGE => P_DISCOUNT_PERCENTAGE,
652: P_OVERDRAFT_LIMIT => P_OVERDRAFT_LIMIT)) then

Line 656: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

652: P_OVERDRAFT_LIMIT => P_OVERDRAFT_LIMIT)) then
653: CONSTRAINT_ERROR ('OTA_TBD_CHECK_DISCOUNT_CONTEXT');
654: end if;
655: --
656: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
657: --
658: end CHECK_DISCOUNT_CONTEXT;
659: --
660: -- ----------------------------------------------------------------------------

Line 690: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

686: where TPL.PRICE_LIST_ID = P_PRICE_LIST_ID;
687: --
688: begin
689: --
690: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
691: --
692: open C1;
693: fetch C1
694: into W_BUSINESS_GROUP_ID,

Line 715: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

711: and W_TPL_END_DATE )) then
712: CONSTRAINT_ERROR ('OTA_TBD_DATES_TPL');
713: end if;
714: --
715: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
716: --
717: end CHECK_DATES_TPL;
718: --
719: -- ----------------------------------------------------------------------------

Line 760: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

756: where EVT.EVENT_ID = P_EVENT_ID;
757: --
758: begin
759: --
760: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
761: --
762: -- Get event details
763: --
764: open C1;

Line 812: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

808: fnd_message.set_name('OTA','OTA_13497_TBD_PRICE_BASIS');
809: fnd_message.raise_error;
810: end if;
811: --
812: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
813: --
814: end CHECK_EVENT;
815: --
816: -- ----------------------------------------------------------------------------

Line 843: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

839: where TAV.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID;
840: --
841: begin
842: --
843: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
844: --
845: open C1;
846: fetch C1
847: into W_TAV_START_DATE,

Line 863: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

859: and W_TAV_END_DATE )) then
860: CONSTRAINT_ERROR ('OTA_TBD_DATES_TAV');
861: end if;
862: --
863: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
864: --
865: end;
866: --
867: -- ----------------------------------------------------------------------------

Line 893: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

889: and TCU.TYPE = 'D';
890: --
891: begin
892: --
893: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
894: --
895: /*OTA_GENERAL.CHECK_DOMAIN_VALUE (
896: P_DOMAIN_TYPE => 'ACTIVITY_CATEGORY',
897: P_DOMAIN_VALUE => P_CATEGORY);*/

Line 909: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

905: if (not W_VALID) then
906: CONSTRAINT_ERROR ('OTA_TBD_CATEGORY');
907: end if;
908: --
909: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
910: --
911: end CHECK_CATEGORY;
912: --
913: -- ----------------------------------------------------------------------------

Line 928: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

924: := G_PACKAGE || 'VALIDITY_CHECK';
925: --
926: begin
927: --
928: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
929: --
930: -- Name must be unique to business group
931: --
932: CHECK_UNIQUE_NAME (

Line 1021: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

1017: CONSTRAINT_ERROR ('OTA_TBD_EXCLUSIVE_CONTEXT');
1018: --
1019: end if;
1020: --
1021: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
1022: --
1023: end;
1024: --
1025: -- ----------------------------------------------------------------------------

Line 1045: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);

1041: where TFL.BOOKING_DEAL_ID = P_BOOKING_DEAL_ID;
1042: --
1043: begin
1044: --
1045: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
1046: --
1047: open C1;
1048: fetch C1
1049: into W_LINES;

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

1104: --
1105: l_proc varchar2(72) := g_package||'insert_dml';
1106: --
1107: Begin
1108: hr_utility.set_location('Entering:'||l_proc, 5);
1109: p_rec.object_version_number := 1; -- Initialise the object version
1110: --
1111: g_api_dml := true; -- Set the api dml status
1112: --

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

1198: );
1199: --
1200: g_api_dml := false; -- Unset the api dml status
1201: --
1202: hr_utility.set_location(' Leaving:'||l_proc, 10);
1203: Exception
1204: When hr_api.check_integrity_violated Then
1205: -- A check constraint has been violated
1206: g_api_dml := false; -- Unset the api dml status

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

1266: --
1267: l_proc varchar2(72) := g_package||'update_dml';
1268: --
1269: Begin
1270: hr_utility.set_location('Entering:'||l_proc, 5);
1271: --
1272: -- Increment the object version
1273: --
1274: p_rec.object_version_number := p_rec.object_version_number + 1;

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

1322: where booking_deal_id = p_rec.booking_deal_id;
1323: --
1324: g_api_dml := false; -- Unset the api dml status
1325: --
1326: hr_utility.set_location(' Leaving:'||l_proc, 10);
1327: --
1328: Exception
1329: When hr_api.check_integrity_violated Then
1330: -- A check constraint has been violated

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

1388: --
1389: l_proc varchar2(72) := g_package||'delete_dml';
1390: --
1391: Begin
1392: hr_utility.set_location('Entering:'||l_proc, 5);
1393: --
1394: g_api_dml := true; -- Set the api dml status
1395: --
1396: -- Delete the ota_booking_deals row.

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

1399: where booking_deal_id = p_rec.booking_deal_id;
1400: --
1401: g_api_dml := false; -- Unset the api dml status
1402: --
1403: hr_utility.set_location(' Leaving:'||l_proc, 10);
1404: --
1405: Exception
1406: When hr_api.child_integrity_violated then
1407: -- Child integrity has been violated

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

1453: --
1454: Cursor C_Sel1 is select ota_booking_deals_s.nextval from sys.dual;
1455: --
1456: Begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458: --
1459: --
1460: -- Select the next sequence number
1461: --

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

1462: Open C_Sel1;
1463: Fetch C_Sel1 Into p_rec.booking_deal_id;
1464: Close C_Sel1;
1465: --
1466: hr_utility.set_location(' Leaving:'||l_proc, 10);
1467: End pre_insert;
1468: --
1469: -- ----------------------------------------------------------------------------
1470: -- |------------------------------< pre_update >------------------------------|

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

1499: --
1500: l_proc varchar2(72) := g_package||'pre_update';
1501: --
1502: Begin
1503: hr_utility.set_location('Entering:'||l_proc, 5);
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 10);
1506: End pre_update;
1507: --

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

1501: --
1502: Begin
1503: hr_utility.set_location('Entering:'||l_proc, 5);
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 10);
1506: End pre_update;
1507: --
1508: -- ----------------------------------------------------------------------------
1509: -- |------------------------------< pre_delete >------------------------------|

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

1538: --
1539: l_proc varchar2(72) := g_package||'pre_delete';
1540: --
1541: Begin
1542: hr_utility.set_location('Entering:'||l_proc, 5);
1543: --
1544: hr_utility.set_location(' Leaving:'||l_proc, 10);
1545: End pre_delete;
1546: --

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

1540: --
1541: Begin
1542: hr_utility.set_location('Entering:'||l_proc, 5);
1543: --
1544: hr_utility.set_location(' Leaving:'||l_proc, 10);
1545: End pre_delete;
1546: --
1547: -- ----------------------------------------------------------------------------
1548: -- |-----------------------------< post_insert >------------------------------|

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

1577: --
1578: l_proc varchar2(72) := g_package||'post_insert';
1579: --
1580: Begin
1581: hr_utility.set_location('Entering:'||l_proc, 5);
1582: --
1583: hr_utility.set_location(' Leaving:'||l_proc, 10);
1584: End post_insert;
1585: --

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

1579: --
1580: Begin
1581: hr_utility.set_location('Entering:'||l_proc, 5);
1582: --
1583: hr_utility.set_location(' Leaving:'||l_proc, 10);
1584: End post_insert;
1585: --
1586: -- ----------------------------------------------------------------------------
1587: -- |-----------------------------< post_update >------------------------------|

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

1616: --
1617: l_proc varchar2(72) := g_package||'post_update';
1618: --
1619: Begin
1620: hr_utility.set_location('Entering:'||l_proc, 5);
1621: --
1622: hr_utility.set_location(' Leaving:'||l_proc, 10);
1623: End post_update;
1624: --

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

1618: --
1619: Begin
1620: hr_utility.set_location('Entering:'||l_proc, 5);
1621: --
1622: hr_utility.set_location(' Leaving:'||l_proc, 10);
1623: End post_update;
1624: --
1625: -- ----------------------------------------------------------------------------
1626: -- |-----------------------------< post_delete >------------------------------|

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

1655: --
1656: l_proc varchar2(72) := g_package||'post_delete';
1657: --
1658: Begin
1659: hr_utility.set_location('Entering:'||l_proc, 5);
1660: --
1661: hr_utility.set_location(' Leaving:'||l_proc, 10);
1662: End post_delete;
1663: --

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

1657: --
1658: Begin
1659: hr_utility.set_location('Entering:'||l_proc, 5);
1660: --
1661: hr_utility.set_location(' Leaving:'||l_proc, 10);
1662: End post_delete;
1663: --
1664: -- ----------------------------------------------------------------------------
1665: -- |---------------------------------< lck >----------------------------------|

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

1719: --
1720: l_proc varchar2(72) := g_package||'lck';
1721: --
1722: Begin
1723: hr_utility.set_location('Entering:'||l_proc, 5);
1724: --
1725: -- Add any mandatory argument checking here:
1726: -- Example:
1727: -- hr_api.mandatory_arg_error

Line 1739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1735: Close C_Sel1;
1736: --
1737: -- The primary key is invalid therefore we must error
1738: --
1739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1740: hr_utility.raise_error;
1741: End If;
1742: Close C_Sel1;
1743: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 1740: hr_utility.raise_error;

1736: --
1737: -- The primary key is invalid therefore we must error
1738: --
1739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1740: hr_utility.raise_error;
1741: End If;
1742: Close C_Sel1;
1743: If (p_object_version_number <> g_old_rec.object_version_number) Then
1744: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 1744: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

1740: hr_utility.raise_error;
1741: End If;
1742: Close C_Sel1;
1743: If (p_object_version_number <> g_old_rec.object_version_number) Then
1744: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1745: hr_utility.raise_error;
1746: End If;
1747: --
1748: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1745: hr_utility.raise_error;

1741: End If;
1742: Close C_Sel1;
1743: If (p_object_version_number <> g_old_rec.object_version_number) Then
1744: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1745: hr_utility.raise_error;
1746: End If;
1747: --
1748: hr_utility.set_location(' Leaving:'||l_proc, 10);
1749: --

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

1744: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1745: hr_utility.raise_error;
1746: End If;
1747: --
1748: hr_utility.set_location(' Leaving:'||l_proc, 10);
1749: --
1750: -- We need to trap the ORA LOCK exception
1751: --
1752: Exception

Line 1758: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

1754: --
1755: -- The object is locked therefore we need to supply a meaningful
1756: -- error message.
1757: --
1758: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');
1760: hr_utility.raise_error;
1761: End lck;
1762: --

Line 1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');

1755: -- The object is locked therefore we need to supply a meaningful
1756: -- error message.
1757: --
1758: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');
1760: hr_utility.raise_error;
1761: End lck;
1762: --
1763: -- ----------------------------------------------------------------------------

Line 1760: hr_utility.raise_error;

1756: -- error message.
1757: --
1758: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');
1760: hr_utility.raise_error;
1761: End lck;
1762: --
1763: -- ----------------------------------------------------------------------------
1764: -- |-----------------------------< convert_args >-----------------------------|

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

1836: l_proc varchar2(72) := g_package||'convert_args';
1837: --
1838: Begin
1839: --
1840: hr_utility.set_location('Entering:'||l_proc, 5);
1841: --
1842: -- Convert arguments into local l_rec structure.
1843: --
1844: l_rec.booking_deal_id := p_booking_deal_id;

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

1883: l_rec.tbd_information20 := p_tbd_information20;
1884: --
1885: -- Return the plsql record structure.
1886: --
1887: hr_utility.set_location(' Leaving:'||l_proc, 10);
1888: Return(l_rec);
1889: --
1890: End convert_args;
1891: --

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

1934: l_proc varchar2(72) := g_package||'convert_defs';
1935: --
1936: Begin
1937: --
1938: hr_utility.set_location('Entering:'||l_proc, 5);
1939: --
1940: -- We must now examine each argument value in the
1941: -- p_rec plsql record structure
1942: -- to see if a system default is being used. If a system default

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

2058: End If;
2059: --
2060: -- Return the plsql record structure.
2061: --
2062: hr_utility.set_location(' Leaving:'||l_proc, 10);
2063: Return(p_rec);
2064: --
2065: End convert_defs;
2066: --

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

2097: --
2098: l_proc varchar2(72) := g_package||'insert_validate';
2099: --
2100: Begin
2101: hr_utility.set_location('Entering:'||l_proc, 5);
2102: --
2103: -- Call all supporting business operations
2104: --
2105: VALIDITY_CHECK (

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

2106: P_REC => P_REC);
2107: --
2108: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2109: --
2110: hr_utility.set_location(' Leaving:'||l_proc, 10);
2111: End insert_validate;
2112: --
2113: -- ----------------------------------------------------------------------------
2114: -- |---------------------------< update_validate >----------------------------|

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

2143: --
2144: l_proc varchar2(72) := g_package||'update_validate';
2145: --
2146: Begin
2147: hr_utility.set_location('Entering:'||l_proc, 5);
2148: --
2149: -- Call all supporting business operations
2150: --
2151: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

2171: --
2172: VALIDITY_CHECK (
2173: P_REC => P_REC);
2174: --
2175: hr_utility.set_location(' Leaving:'||l_proc, 10);
2176: End update_validate;
2177: --
2178: -- ----------------------------------------------------------------------------
2179: -- |---------------------------< delete_validate >----------------------------|

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

2208: --
2209: l_proc varchar2(72) := g_package||'delete_validate';
2210: --
2211: Begin
2212: hr_utility.set_location('Entering:'||l_proc, 5);
2213: --
2214: -- Call all supporting business operations
2215: --
2216: if (TFL_LINES (

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

2217: P_BOOKING_DEAL_ID => P_REC.BOOKING_DEAL_ID)) then
2218: CONSTRAINT_ERROR ('OTA_TBD_FINANCE_LINES');
2219: end if;
2220: --
2221: hr_utility.set_location(' Leaving:'||l_proc, 10);
2222: End delete_validate;
2223: --
2224: -- ----------------------------------------------------------------------------
2225: -- |---------------------------------< ins >----------------------------------|

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

2232: --
2233: l_proc varchar2(72) := g_package||'ins';
2234: --
2235: Begin
2236: hr_utility.set_location('Entering:'||l_proc, 5);
2237: --
2238: -- Determine if the business process is to be validated.
2239: --
2240: If p_validate then

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

2265: If p_validate then
2266: Raise HR_Api.Validate_Enabled;
2267: End If;
2268: --
2269: hr_utility.set_location(' Leaving:'||l_proc, 10);
2270: Exception
2271: When HR_Api.Validate_Enabled Then
2272: --
2273: -- As the Validate_Enabled exception has been raised

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

2327: l_rec g_rec_type;
2328: l_proc varchar2(72) := g_package||'ins';
2329: --
2330: Begin
2331: hr_utility.set_location('Entering:'||l_proc, 5);
2332: --
2333: -- Call conversion function to turn arguments into the
2334: -- p_rec structure.
2335: --

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

2388: --
2389: p_booking_deal_id := l_rec.booking_deal_id;
2390: p_object_version_number := l_rec.object_version_number;
2391: --
2392: hr_utility.set_location(' Leaving:'||l_proc, 10);
2393: End ins;
2394: --
2395: -- ----------------------------------------------------------------------------
2396: -- |---------------------------------< upd >----------------------------------|

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

2403: --
2404: l_proc varchar2(72) := g_package||'upd';
2405: --
2406: Begin
2407: hr_utility.set_location('Entering:'||l_proc, 5);
2408: --
2409: -- Determine if the business process is to be validated.
2410: --
2411: If p_validate then

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

2448: If p_validate then
2449: Raise HR_Api.Validate_Enabled;
2450: End If;
2451: --
2452: hr_utility.set_location(' Leaving:'||l_proc, 10);
2453: Exception
2454: When HR_Api.Validate_Enabled Then
2455: --
2456: -- As the Validate_Enabled exception has been raised

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

2510: l_rec g_rec_type;
2511: l_proc varchar2(72) := g_package||'upd';
2512: --
2513: Begin
2514: hr_utility.set_location('Entering:'||l_proc, 5);
2515: --
2516: -- Call conversion function to turn arguments into the
2517: -- l_rec structure.
2518: --

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

2567: --
2568: upd(l_rec, p_validate);
2569: p_object_version_number := l_rec.object_version_number;
2570: --
2571: hr_utility.set_location(' Leaving:'||l_proc, 10);
2572: End upd;
2573: --
2574: -- ----------------------------------------------------------------------------
2575: -- |---------------------------------< del >----------------------------------|

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

2582: --
2583: l_proc varchar2(72) := g_package||'del';
2584: --
2585: Begin
2586: hr_utility.set_location('Entering:'||l_proc, 5);
2587: --
2588: -- Determine if the business process is to be validated.
2589: --
2590: If p_validate then

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

2623: If p_validate then
2624: Raise HR_Api.Validate_Enabled;
2625: End If;
2626: --
2627: hr_utility.set_location(' Leaving:'||l_proc, 10);
2628: Exception
2629: When HR_Api.Validate_Enabled Then
2630: --
2631: -- As the Validate_Enabled exception has been raised

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

2647: l_rec g_rec_type;
2648: l_proc varchar2(72) := g_package||'del';
2649: --
2650: Begin
2651: hr_utility.set_location('Entering:'||l_proc, 5);
2652: --
2653: -- As the delete procedure accepts a plsql record structure we do need to
2654: -- convert the arguments into the record structure.
2655: -- We don't need to call the supplied conversion argument routine as we

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

2663: -- business process
2664: --
2665: del(l_rec, p_validate);
2666: --
2667: hr_utility.set_location(' Leaving:'||l_proc, 10);
2668: End del;
2669: --
2670: end OTA_TBD_API;