1452:
1453: -- If p_effective_date is not NULL then set it on the g_txn_ctx.EFFECTIVE_DATE
1454: if ( p_effective_date is not null ) then
1455: BEGIN
1456: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.canonical_to_date(p_effective_date));
1457: EXCEPTION When Others then
1458: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.chardate_to_date(p_effective_date));
1459: END;
1460: end if;
1454: if ( p_effective_date is not null ) then
1455: BEGIN
1456: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.canonical_to_date(p_effective_date));
1457: EXCEPTION When Others then
1458: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.chardate_to_date(p_effective_date));
1459: END;
1460: end if;
1461:
1462: hr_utility.set_location('Call Set_Person_Context: '|| l_proc, 15);