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

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

74:
75: begin
76: --
77: -- First, check if transaction id exists or not
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: l_transaction_id := hr_transaction_ss.get_transaction_id
80: (p_item_type => p_item_type
81: ,p_item_key => p_item_key);
82: --

Line 85: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,10);

81: ,p_item_key => p_item_key);
82: --
83: IF l_transaction_id is null THEN
84: -- Start a Transaction
85: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,10);
86: hr_transaction_ss.start_transaction
87: (itemtype => p_item_type
88: ,itemkey => p_item_key
89: ,actid => p_activity_id

Line 170: hr_utility.set_location('Exiting:'||l_proc, 15);

166: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
167: itemkey => p_item_key,
168: actid => p_activity_id,
169: aname => gv_wf_review_region_item);
170: hr_utility.set_location('Exiting:'||l_proc, 15);
171: EXCEPTION
172: WHEN OTHERS THEN
173: hr_utility.set_location('Exception:Others'||l_proc,555);
174: l_review_item_name := 'HrPhoneNumbersReview';

Line 173: hr_utility.set_location('Exception:Others'||l_proc,555);

169: aname => gv_wf_review_region_item);
170: hr_utility.set_location('Exiting:'||l_proc, 15);
171: EXCEPTION
172: WHEN OTHERS THEN
173: hr_utility.set_location('Exception:Others'||l_proc,555);
174: l_review_item_name := 'HrPhoneNumbersReview';
175: END;
176:
177: l_count := l_count + 1;

Line 352: hr_utility.set_location('p_contact_relationship_id > 0:'||l_proc,25);

348: l_transaction_table(l_count).param_value := p_contact_set;
349: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
350:
351: if (p_contact_relationship_id > 0 ) then
352: hr_utility.set_location('p_contact_relationship_id > 0:'||l_proc,25);
353: l_count := l_count + 1;
354: l_transaction_table(l_count).param_name := 'P_CONTACT_RELATIONSHIP_ID';
355: l_transaction_table(l_count).param_value := p_contact_relationship_id;
356: l_transaction_table(l_count).param_data_type := 'NUMBER';

Line 372: hr_utility.set_location('Exception:Others'||l_proc,555);

368: ,p_transaction_data => l_transaction_table);
369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: hr_utility.set_location('Exception:Others'||l_proc,555);
373: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
374: p_error_message => p_error_message);
375:
376: end save_transaction;

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

505: l_proc varchar2(72) := g_package||'create_phone';
506:
507: begin
508:
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
511: hr_utility.set_location('SFL:GOTO only_txn'||l_proc,10);
512: GOTO only_transaction;
513: END IF;

Line 511: hr_utility.set_location('SFL:GOTO only_txn'||l_proc,10);

507: begin
508:
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
511: hr_utility.set_location('SFL:GOTO only_txn'||l_proc,10);
512: GOTO only_transaction;
513: END IF;
514:
515: SAVEPOINT create_contact_and_phone;

Line 521: hr_utility.set_location('l_parent_id is null or l_parent_id < 0 :'||l_proc,15);

517: --
518: if (l_parent_id is null or l_parent_id < 0 ) then
519: --
520: -- bug # 2174876
521: hr_utility.set_location('l_parent_id is null or l_parent_id < 0 :'||l_proc,15);
522:
523: if p_per_or_contact = 'CONTACT' or p_per_or_contact = 'EMER_CR_NEW_CONT' or p_per_or_contact = 'EMRG_OVRW_UPD' or p_per_or_contact = 'EMRG_OVRW_DEL' or p_per_or_contact = 'EMER_CR_NEW_REL'
524: or p_per_or_contact = 'DPDNT_CR_NEW_CONT' or p_per_or_contact = 'DPDNT_OVRW_UPD' or p_per_or_contact = 'DPDNT_OVRW_DEL' or p_per_or_contact = 'DPDNT_CR_NEW_REL'
525: or p_per_or_contact = 'COBRA' then

Line 559: hr_utility.set_location('p_per_or_contact = PERSON:'||l_proc,20);

555: end if;
556: -- end bug # 2174876
557: --end bug # 2138073/2115552
558: if p_per_or_contact = 'PERSON' then
559: hr_utility.set_location('p_per_or_contact = PERSON:'||l_proc,20);
560: hr_new_user_reg_ss.processNewUserTransaction(
561: WfItemType => p_item_type,
562: WfItemKey => p_item_key,
563: PersonId => l_parent_id,

Line 623: hr_utility.set_location('rollback to create_contact_and_phone:'||l_proc,25);

619: p_object_version_number => l_dummy_num, -- p_object_version_number,
620: p_phone_id => l_dummy_num); -- p_phone_id);
621: --
622:
623: hr_utility.set_location('rollback to create_contact_and_phone:'||l_proc,25);
624: rollback to create_contact_and_phone;
625:
626: <> -- label for GOTO
627:

Line 638: hr_utility.set_location('Exception:others'||l_proc,555);

634: itemkey => p_item_key,
635: aname => 'HR_CONTACT_SET');
636:
637: exception when others then
638: hr_utility.set_location('Exception:others'||l_proc,555);
639: l_contact_set := 0;
640:
641: end;
642:

Line 703: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,560);

699: EXCEPTION
700: WHEN g_save_transaction_error THEN
701: -- No need to call formatted_error_message, as the messages is already
702: -- formatted.
703: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,560);
704: p_error_message := l_error_message;
705: WHEN hr_utility.hr_error THEN
706: -- -------------------------------------------
707: -- an application error has been raised so we must

Line 705: WHEN hr_utility.hr_error THEN

701: -- No need to call formatted_error_message, as the messages is already
702: -- formatted.
703: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,560);
704: p_error_message := l_error_message;
705: WHEN hr_utility.hr_error THEN
706: -- -------------------------------------------
707: -- an application error has been raised so we must
708: -- redisplay the web form to display the error
709: -- --------------------------------------------

Line 710: hr_utility.set_location('Exception:hr_utility.hr_error THEN'||l_proc,565);

706: -- -------------------------------------------
707: -- an application error has been raised so we must
708: -- redisplay the web form to display the error
709: -- --------------------------------------------
710: hr_utility.set_location('Exception:hr_utility.hr_error THEN'||l_proc,565);
711: hr_message.provide_error;
712: l_message_number := hr_message.last_message_number;
713: IF l_message_number = 'APP-7165' OR
714: l_message_number = 'APP-7155' THEN

Line 726: hr_utility.set_location('Exception:Others'||l_proc,570);

722: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
723: p_error_message => p_error_message);
724: END IF;
725: WHEN OTHERS THEN
726: hr_utility.set_location('Exception:Others'||l_proc,570);
727: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
728: p_error_message => p_error_message);
729:
730: end create_phone;

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

830: l_proc varchar2(72) := g_package||'update_phone';
831:
832: begin
833:
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
836: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);
837: GOTO only_transaction;
838: END IF;

Line 836: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);

832: begin
833:
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
836: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);
837: GOTO only_transaction;
838: END IF;
839:
840:

Line 935: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);

931: );
932:
933: -- check if we got any errors
934: IF (l_error_message IS NOT NULL) THEN
935: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);
936: raise g_save_transaction_error;
937: END IF;
938:
939: hr_utility.set_location('Exiting:'||l_proc, 20);

Line 939: hr_utility.set_location('Exiting:'||l_proc, 20);

935: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);
936: raise g_save_transaction_error;
937: END IF;
938:
939: hr_utility.set_location('Exiting:'||l_proc, 20);
940: EXCEPTION
941: WHEN g_save_transaction_error THEN
942: -- No need to call formatted_error_message, as the messages is already
943: -- formatted.

Line 944: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);

940: EXCEPTION
941: WHEN g_save_transaction_error THEN
942: -- No need to call formatted_error_message, as the messages is already
943: -- formatted.
944: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);
945: p_error_message := l_error_message;
946: WHEN hr_utility.hr_error THEN
947: -- -------------------------------------------
948: -- an application error has been raised so we must

Line 946: WHEN hr_utility.hr_error THEN

942: -- No need to call formatted_error_message, as the messages is already
943: -- formatted.
944: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);
945: p_error_message := l_error_message;
946: WHEN hr_utility.hr_error THEN
947: -- -------------------------------------------
948: -- an application error has been raised so we must
949: -- redisplay the web form to display the error
950: -- --------------------------------------------

Line 951: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,560);

947: -- -------------------------------------------
948: -- an application error has been raised so we must
949: -- redisplay the web form to display the error
950: -- --------------------------------------------
951: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,560);
952: hr_message.provide_error;
953: l_message_number := hr_message.last_message_number;
954: IF l_message_number = 'APP-7165' OR
955: l_message_number = 'APP-7155' THEN

Line 967: hr_utility.set_location('Exception:Others'||l_proc,565);

963: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
964: p_error_message => p_error_message);
965: END IF;
966: WHEN OTHERS THEN
967: hr_utility.set_location('Exception:Others'||l_proc,565);
968: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
969: p_error_message => p_error_message);
970:
971: end update_phone;

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

1033: l_error_message long default null;
1034: l_proc varchar2(72) := g_package||'delete_phone';
1035:
1036: begin
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
1039: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);
1040: GOTO only_transaction;
1041: END IF;

Line 1039: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);

1035:
1036: begin
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: IF (p_save_mode = 'SAVE_FOR_LATER') THEN
1039: hr_utility.set_location('SFL:Goto only_txn'||l_proc,10);
1040: GOTO only_transaction;
1041: END IF;
1042:
1043: -- here's the delegated call to the old PL/SQL routine

Line 1067: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);

1063: , p_error_message => l_error_message);
1064:
1065: -- check if we got any errors
1066: IF (l_error_message IS NOT NULL) THEN
1067: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);
1068: raise g_save_transaction_error;
1069: END IF;
1070:
1071: hr_utility.set_location('Exiting:'||l_proc, 20);

Line 1071: hr_utility.set_location('Exiting:'||l_proc, 20);

1067: hr_utility.set_location('l_error_message IS NOT NULL:'||l_proc,15);
1068: raise g_save_transaction_error;
1069: END IF;
1070:
1071: hr_utility.set_location('Exiting:'||l_proc, 20);
1072: EXCEPTION
1073: WHEN g_save_transaction_error THEN
1074: -- No need to call formatted_error_message, as the messages is already
1075: -- formatted.

Line 1076: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);

1072: EXCEPTION
1073: WHEN g_save_transaction_error THEN
1074: -- No need to call formatted_error_message, as the messages is already
1075: -- formatted.
1076: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);
1077: p_error_message := l_error_message;
1078: WHEN hr_utility.hr_error THEN
1079: -- -------------------------------------------
1080: -- an application error has been raised so we must

Line 1078: WHEN hr_utility.hr_error THEN

1074: -- No need to call formatted_error_message, as the messages is already
1075: -- formatted.
1076: hr_utility.set_location('Exception:g_save_transaction_error'||l_proc,555);
1077: p_error_message := l_error_message;
1078: WHEN hr_utility.hr_error THEN
1079: -- -------------------------------------------
1080: -- an application error has been raised so we must
1081: -- redisplay the web form to display the error
1082: -- --------------------------------------------

Line 1083: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,560);

1079: -- -------------------------------------------
1080: -- an application error has been raised so we must
1081: -- redisplay the web form to display the error
1082: -- --------------------------------------------
1083: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,560);
1084: hr_message.provide_error;
1085: l_message_number := hr_message.last_message_number;
1086: IF l_message_number = 'APP-7165' OR
1087: l_message_number = 'APP-7155' THEN

Line 1099: hr_utility.set_location('Exception:Others'||l_proc,565);

1095: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1096: p_error_message => p_error_message);
1097: END IF;
1098: WHEN OTHERS THEN
1099: hr_utility.set_location('Exception:Others'||l_proc,565);
1100: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1101: p_error_message => p_error_message);
1102:
1103: end delete_phone;

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

1186:
1187: begin
1188:
1189: -- here's the delegated call to the old PL/SQL routine
1190: hr_utility.set_location('Entering:'||l_proc, 5);
1191: hr_phone_api.create_or_update_phone(
1192: p_update_mode => p_update_mode,
1193: p_phone_id => p_phone_id,
1194: p_object_version_number => p_object_version_number,

Line 1233: hr_utility.set_location('Exiting:'||l_proc, 10);

1229: p_attribute29 => p_attribute29,
1230: p_attribute30 => p_attribute30,
1231: p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate),
1232: p_effective_date => p_effective_date);
1233: hr_utility.set_location('Exiting:'||l_proc, 10);
1234: end create_or_update_phone;
1235:
1236: -- ---------------------------------------------------------------------------
1237: -- ---------------------- < get_phone_data_from_tt> -------------------------

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

1279: -- to make further changes or to correct errors.
1280: -----------------------------------------------------------------------------
1281: -- For a given item key, there could be multiple transaction steps saved.
1282:
1283: hr_utility.set_location('Entering:'||l_proc, 5);
1284: hr_transaction_api.get_transaction_step_info
1285: (p_item_type => p_item_type
1286: ,p_item_key => p_item_key
1287: ,p_activity_id => p_activity_id

Line 1301: hr_utility.set_location('Entering For Loop 1..l_trans_step_rows:'||l_proc,10);

1297: -- ---------------------------------------------------------------------
1298: --
1299: ln_index := 0;
1300:
1301: hr_utility.set_location('Entering For Loop 1..l_trans_step_rows:'||l_proc,10);
1302: FOR j in 1..l_trans_step_rows
1303: LOOP
1304: --
1305: -- Now get the transaction data for the given step

Line 1335: hr_utility.set_location('Exception:Others'||l_proc,555);

1331: end loop;
1332: --
1333: exception
1334: when others then
1335: hr_utility.set_location('Exception:Others'||l_proc,555);
1336: null;
1337: end;
1338: ln_index := ln_index + 1;
1339: END LOOP;

Line 1340: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

1336: null;
1337: end;
1338: ln_index := ln_index + 1;
1339: END LOOP;
1340: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1341:
1342: p_trans_rec_count := l_trans_rec_count;
1343: hr_utility.set_location('Exiting:'||l_proc, 20);
1344: EXCEPTION

Line 1343: hr_utility.set_location('Exiting:'||l_proc, 20);

1339: END LOOP;
1340: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1341:
1342: p_trans_rec_count := l_trans_rec_count;
1343: hr_utility.set_location('Exiting:'||l_proc, 20);
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: hr_utility.set_location('Exception:Others'||l_proc,555);
1347: RAISE;

Line 1346: hr_utility.set_location('Exception:Others'||l_proc,555);

1342: p_trans_rec_count := l_trans_rec_count;
1343: hr_utility.set_location('Exiting:'||l_proc, 20);
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: hr_utility.set_location('Exception:Others'||l_proc,555);
1347: RAISE;
1348:
1349: END get_phone_data_from_tt;
1350:

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

1373: begin
1374:
1375:
1376: --
1377: hr_utility.set_location('Entering:'||l_proc, 5);
1378: p_person_id := hr_transaction_api.get_number_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_name => 'P_PERSON_ID');
1381: --

Line 1410: hr_utility.set_location('Exception:Others'||l_proc,555);

1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_CONTACT_SET');
1408: exception
1409: when others then
1410: hr_utility.set_location('Exception:Others'||l_proc,555);
1411: l_contact_set := 1;
1412: end;
1413: if l_contact_set is null then
1414: l_contact_set := 1;

Line 1425: hr_utility.set_location('Exiting:'||l_proc, 15);

1421: -- Added more data for Registration
1422: --
1423:
1424: p_phone_data := nvl(l_phone_id,0)||'^'||l_phone_type||'^'||l_phone_type_meaning||'^'||l_phone_number||'^'||nvl(l_object_version_number,0)||'^'||nvl(l_contact_set,0)||'^'||nvl(l_contact_set,0); -- Packer
1425: hr_utility.set_location('Exiting:'||l_proc, 15);
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 1429: hr_utility.set_location('Exception:Others'||l_proc,555);

1425: hr_utility.set_location('Exiting:'||l_proc, 15);
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: hr_utility.set_location('Exception:Others'||l_proc,555);
1430: RAISE;
1431:
1432: END get_phone_data_from_tt;
1433:

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

1466: -- to make further changes or to correct errors.
1467: -----------------------------------------------------------------------------
1468: -- For a given item key, there could be multiple transaction steps saved.
1469:
1470: hr_utility.set_location('Entering:'||l_proc, 5);
1471: hr_transaction_api.get_transaction_step_info
1472: (p_item_type => p_item_type
1473: ,p_item_key => p_item_key
1474: ,p_activity_id => p_activity_id

Line 1488: hr_utility.set_location('Entering For Loop:1..l_trans_step_rows'||l_proc,10);

1484: -- ---------------------------------------------------------------------
1485: --
1486: ln_index := 0;
1487:
1488: hr_utility.set_location('Entering For Loop:1..l_trans_step_rows'||l_proc,10);
1489: FOR j in 1..l_trans_step_rows
1490: LOOP
1491: --
1492: -- Now get the transaction data for the given step

Line 1658: hr_utility.set_location('Exception:Others'||l_proc,555);

1654: END LOOP;
1655: --
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: hr_utility.set_location('Exception:Others'||l_proc,555);
1659: RAISE;
1660: END;
1661: ln_index := ln_index + 1;
1662: END LOOP;

Line 1663: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

1659: RAISE;
1660: END;
1661: ln_index := ln_index + 1;
1662: END LOOP;
1663: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1664:
1665: p_trans_rec_count := l_trans_rec_count;
1666: hr_utility.set_location('Exiting:'||l_proc, 20);
1667:

Line 1666: hr_utility.set_location('Exiting:'||l_proc, 20);

1662: END LOOP;
1663: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1664:
1665: p_trans_rec_count := l_trans_rec_count;
1666: hr_utility.set_location('Exiting:'||l_proc, 20);
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 1670: hr_utility.set_location('Exception:Others'||l_proc,555);

1666: hr_utility.set_location('Exiting:'||l_proc, 20);
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: hr_utility.set_location('Exception:Others'||l_proc,555);
1671: RAISE;
1672: END get_transaction_details;
1673:
1674: PROCEDURE get_transaction_details

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

1706: -- to make further changes or to correct errors.
1707: -----------------------------------------------------------------------------
1708: -- For a given item key, there could be multiple transaction steps saved.
1709:
1710: hr_utility.set_location('Entering:'||l_proc, 5);
1711: hr_transaction_api.get_transaction_step_info
1712: (p_item_type => p_item_type
1713: ,p_item_key => p_item_key
1714: ,p_activity_id => p_activity_id

Line 1728: hr_utility.set_location('Entering For Loop:1..l_trans_step_rows'||l_proc,10);

1724: -- ---------------------------------------------------------------------
1725: --
1726: ln_index := 0;
1727:
1728: hr_utility.set_location('Entering For Loop:1..l_trans_step_rows'||l_proc,10);
1729: FOR j in 1..l_trans_step_rows
1730: LOOP
1731: --
1732: -- Now get the transaction data for the given step

Line 1903: hr_utility.set_location('Exception:Others'||l_proc,555);

1899: END LOOP;
1900: --
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903: hr_utility.set_location('Exception:Others'||l_proc,555);
1904: RAISE;
1905: END;
1906: ln_index := ln_index + 1;
1907: END LOOP;

Line 1908: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

1904: RAISE;
1905: END;
1906: ln_index := ln_index + 1;
1907: END LOOP;
1908: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1909:
1910: p_trans_rec_count := l_trans_rec_count;
1911: hr_utility.set_location('Exiting:'||l_proc, 20);
1912:

Line 1911: hr_utility.set_location('Exiting:'||l_proc, 20);

1907: END LOOP;
1908: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1909:
1910: p_trans_rec_count := l_trans_rec_count;
1911: hr_utility.set_location('Exiting:'||l_proc, 20);
1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN
1915: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 1915: hr_utility.set_location('Exception:Others'||l_proc,555);

1911: hr_utility.set_location('Exiting:'||l_proc, 20);
1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN
1915: hr_utility.set_location('Exception:Others'||l_proc,555);
1916: RAISE;
1917: END get_transaction_details;
1918:
1919:

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

1952: l_proc varchar2(72) := g_package||'process_api';
1953:
1954:
1955: BEGIN
1956: hr_utility.set_location('Entering:'||l_proc, 5);
1957: if (p_effective_date is not null) then
1958: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);
1959: l_effective_date:= to_date(p_effective_date,g_date_format);
1960: else

Line 1958: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);

1954:
1955: BEGIN
1956: hr_utility.set_location('Entering:'||l_proc, 5);
1957: if (p_effective_date is not null) then
1958: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);
1959: l_effective_date:= to_date(p_effective_date,g_date_format);
1960: else
1961: hr_utility.set_location('p_effective_date is null:'||l_proc,15);
1962: l_effective_date:= to_date(

Line 1961: hr_utility.set_location('p_effective_date is null:'||l_proc,15);

1957: if (p_effective_date is not null) then
1958: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);
1959: l_effective_date:= to_date(p_effective_date,g_date_format);
1960: else
1961: hr_utility.set_location('p_effective_date is null:'||l_proc,15);
1962: l_effective_date:= to_date(
1963: hr_transaction_ss.get_wf_effective_date
1964: (p_transaction_step_id => p_transaction_step_id),g_date_format);
1965: end if;

Line 1995: hr_utility.set_location('IF l_phone_id IS NULL THEN:'||l_proc,20);

1991: (p_transaction_step_id =>
1992: p_transaction_step_id
1993: ,p_name => 'P_PHONE_ID');
1994: IF l_phone_id IS NULL THEN
1995: hr_utility.set_location('IF l_phone_id IS NULL THEN:'||l_proc,20);
1996: -- It's a new phone number.
1997: --
1998: -- PB : Add
1999: --

Line 2007: hr_utility.set_location('l_person_id is null or l_person_id < 0:'||l_proc,25);

2003: -- This is the case where the contact was created.
2004: -- So get contact person id from the global.
2005: --
2006: -- StartRegistration
2007: hr_utility.set_location('l_person_id is null or l_person_id < 0:'||l_proc,25);
2008: l_per_or_contact :=
2009: hr_transaction_api.get_varchar2_Value
2010: (p_transaction_step_id =>
2011: p_transaction_step_id

Line 2014: hr_utility.set_location('Phone.process_api l_per_or_contact : '

2010: (p_transaction_step_id =>
2011: p_transaction_step_id
2012: ,p_name => 'P_PER_OR_CONTACT');
2013: --
2014: hr_utility.set_location('Phone.process_api l_per_or_contact : '
2015: || l_per_or_contact, 22);
2016: --
2017: if l_per_or_contact = 'CONTACT' or l_per_or_contact = 'EMER_CR_NEW_CONT' or l_per_or_contact = 'EMRG_OVRW_UPD' or l_per_or_contact = 'EMRG_OVRW_DEL' or l_per_or_contact = 'EMER_CR_NEW_REL'
2018: or l_per_or_contact = 'DPDNT_CR_NEW_CONT' or l_per_or_contact = 'DPDNT_OVRW_UPD' or l_per_or_contact = 'DPDNT_OVRW_DEL' or l_per_or_contact = 'DPDNT_CR_NEW_REL' then

Line 2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);

2033: -- l_person_id := hr_process_person_ss.g_person_id;
2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);
2038: l_person_id := hr_process_person_ss.g_person_id;
2039: end if;
2040: end if;
2041: --

Line 2044: hr_utility.set_location('Phone.process_api l_person_id : '

2040: end if;
2041: --
2042: end if;
2043: --
2044: hr_utility.set_location('Phone.process_api l_person_id : '
2045: || l_person_id, 22);
2046: hr_phone_api.create_phone
2047: (p_validate => FALSE
2048: ,p_phone_id => l_phone_id

Line 2151: hr_utility.set_location('l_phone_type = DELETE THEN:'||l_proc,35);

2147: (p_transaction_step_id => p_transaction_step_id
2148: ,p_name => 'P_ATTRIBUTE30'));
2149: ELSIF l_phone_type = 'DELETE' THEN
2150: -- Delete the existing phone nuber.
2151: hr_utility.set_location('l_phone_type = DELETE THEN:'||l_proc,35);
2152: hr_phone_api.delete_phone
2153: (p_validate => FALSE
2154: ,p_phone_id => l_phone_id
2155: ,p_object_version_number => l_phone_ovn

Line 2262: hr_utility.set_location('IF p_validate = TRUE THEN:'||l_proc,40);

2258: ,p_name => 'P_ATTRIBUTE30'));
2259: END IF; -- If it's a new of existing phone number ?
2260:
2261: IF p_validate = TRUE THEN
2262: hr_utility.set_location('IF p_validate = TRUE THEN:'||l_proc,40);
2263: ROLLBACK TO process_phones;
2264: END IF;
2265: hr_utility.set_location('Exiting:'||l_proc,45);
2266:

Line 2265: hr_utility.set_location('Exiting:'||l_proc,45);

2261: IF p_validate = TRUE THEN
2262: hr_utility.set_location('IF p_validate = TRUE THEN:'||l_proc,40);
2263: ROLLBACK TO process_phones;
2264: END IF;
2265: hr_utility.set_location('Exiting:'||l_proc,45);
2266:
2267: EXCEPTION
2268: WHEN hr_utility.hr_error THEN
2269: -- ---------------------------------------------------

Line 2268: WHEN hr_utility.hr_error THEN

2264: END IF;
2265: hr_utility.set_location('Exiting:'||l_proc,45);
2266:
2267: EXCEPTION
2268: WHEN hr_utility.hr_error THEN
2269: -- ---------------------------------------------------
2270: -- ---------------------------------------------------
2271: -- an application error has been raised so we must
2272: -- redisplay the web form to display the error

Line 2274: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,555);

2270: -- ---------------------------------------------------
2271: -- an application error has been raised so we must
2272: -- redisplay the web form to display the error
2273: -- ----------------------------------------------------
2274: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,555);
2275: RAISE;
2276: WHEN OTHERS THEN
2277: hr_utility.set_location('Exception:Others'||l_proc,560);
2278: RAISE;

Line 2277: hr_utility.set_location('Exception:Others'||l_proc,560);

2273: -- ----------------------------------------------------
2274: hr_utility.set_location('Exception:hr_utility.hr_error'||l_proc,555);
2275: RAISE;
2276: WHEN OTHERS THEN
2277: hr_utility.set_location('Exception:Others'||l_proc,560);
2278: RAISE;
2279: /*
2280: hr_util_disp_web.display_fatal_errors
2281: (p_message => UPPER(g_package || '.process_api: '