1366:
1367: -- If p_effective_date is not NULL then set it on the g_txn_ctx.EFFECTIVE_DATE
1368: if ( p_effective_date is not null ) then
1369: BEGIN
1370: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.canonical_to_date(p_effective_date));
1371: EXCEPTION When Others then
1372: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.chardate_to_date(p_effective_date));
1373: END;
1374: end if;
1368: if ( p_effective_date is not null ) then
1369: BEGIN
1370: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.canonical_to_date(p_effective_date));
1371: EXCEPTION When Others then
1372: hr_transaction_swi.g_txn_ctx.EFFECTIVE_DATE := trunc(fnd_date.chardate_to_date(p_effective_date));
1373: END;
1374: end if;
1375:
1376: hr_utility.set_location('Call Set_Person_Context: '|| l_proc, 15);