1430: l_transaction_id := wf_notification.getattrnumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');
1431: if l_transaction_id is null then
1432: --
1433: if flowmode = 'CREATE' then
1434: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_NEW');
1435: document := fnd_message.get;
1436: else
1437: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_UPDATE');
1438: document := fnd_message.get;
1431: if l_transaction_id is null then
1432: --
1433: if flowmode = 'CREATE' then
1434: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_NEW');
1435: document := fnd_message.get;
1436: else
1437: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_UPDATE');
1438: document := fnd_message.get;
1439: end if;
1433: if flowmode = 'CREATE' then
1434: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_NEW');
1435: document := fnd_message.get;
1436: else
1437: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_UPDATE');
1438: document := fnd_message.get;
1439: end if;
1440: --
1441: else
1434: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_NEW');
1435: document := fnd_message.get;
1436: else
1437: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_UPDATE');
1438: document := fnd_message.get;
1439: end if;
1440: --
1441: else
1442: --
1450: irc_approvals.get_transaction_number_data (
1451: transaction_id => to_char(l_transaction_id),
1452: p_path => '/Transaction/TransCtx/CNode/loggedInPersonId'));
1453: --
1454: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_' || flowmode);
1455: fnd_message.set_token('PERSONNAME', l_originators_name, false);
1456: fnd_message.set_token('VACANCYNAME', l_vacancy_name, false);
1457: document := fnd_message.get;
1458: --
1451: transaction_id => to_char(l_transaction_id),
1452: p_path => '/Transaction/TransCtx/CNode/loggedInPersonId'));
1453: --
1454: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_' || flowmode);
1455: fnd_message.set_token('PERSONNAME', l_originators_name, false);
1456: fnd_message.set_token('VACANCYNAME', l_vacancy_name, false);
1457: document := fnd_message.get;
1458: --
1459: --
1452: p_path => '/Transaction/TransCtx/CNode/loggedInPersonId'));
1453: --
1454: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_' || flowmode);
1455: fnd_message.set_token('PERSONNAME', l_originators_name, false);
1456: fnd_message.set_token('VACANCYNAME', l_vacancy_name, false);
1457: document := fnd_message.get;
1458: --
1459: --
1460: end if;
1453: --
1454: fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_' || flowmode);
1455: fnd_message.set_token('PERSONNAME', l_originators_name, false);
1456: fnd_message.set_token('VACANCYNAME', l_vacancy_name, false);
1457: document := fnd_message.get;
1458: --
1459: --
1460: end if;
1461: --
1547: l_transaction_id := wf_notification.getattrnumber(document_id,'HR_TRANSACTION_REF_ID_ATTR');
1548: if l_transaction_id is null then
1549: --
1550: if flowmode = 'CREATE' then
1551: fnd_message.set_name('PER','IRC_CREATE_OFFER_APPROVAL');
1552: document := fnd_message.get;
1553: else
1554: fnd_message.set_name('PER','IRC_UPDATE_OFFER_APPROVAL');
1555: document := fnd_message.get;
1548: if l_transaction_id is null then
1549: --
1550: if flowmode = 'CREATE' then
1551: fnd_message.set_name('PER','IRC_CREATE_OFFER_APPROVAL');
1552: document := fnd_message.get;
1553: else
1554: fnd_message.set_name('PER','IRC_UPDATE_OFFER_APPROVAL');
1555: document := fnd_message.get;
1556: end if;
1550: if flowmode = 'CREATE' then
1551: fnd_message.set_name('PER','IRC_CREATE_OFFER_APPROVAL');
1552: document := fnd_message.get;
1553: else
1554: fnd_message.set_name('PER','IRC_UPDATE_OFFER_APPROVAL');
1555: document := fnd_message.get;
1556: end if;
1557: --
1558: else
1551: fnd_message.set_name('PER','IRC_CREATE_OFFER_APPROVAL');
1552: document := fnd_message.get;
1553: else
1554: fnd_message.set_name('PER','IRC_UPDATE_OFFER_APPROVAL');
1555: document := fnd_message.get;
1556: end if;
1557: --
1558: else
1559: --
1570: transaction_id => to_char(l_transaction_id),
1571: p_path => '/Transaction/TransCtx/PrsnId'));
1572: --
1573: if flowmode = 'CREATE' then
1574: fnd_message.set_name('PER','IRC_412390_OFFER_APPR_CREATE');
1575: else
1576: fnd_message.set_name('PER','IRC_412391_OFFER_APPR_EDIT');
1577: end if;
1578: fnd_message.set_token('PERSON_NAME', l_applicant_name, false);
1572: --
1573: if flowmode = 'CREATE' then
1574: fnd_message.set_name('PER','IRC_412390_OFFER_APPR_CREATE');
1575: else
1576: fnd_message.set_name('PER','IRC_412391_OFFER_APPR_EDIT');
1577: end if;
1578: fnd_message.set_token('PERSON_NAME', l_applicant_name, false);
1579: fnd_message.set_token('VACANCY_NAME', l_vacancy_name, false);
1580: document := fnd_message.get;
1574: fnd_message.set_name('PER','IRC_412390_OFFER_APPR_CREATE');
1575: else
1576: fnd_message.set_name('PER','IRC_412391_OFFER_APPR_EDIT');
1577: end if;
1578: fnd_message.set_token('PERSON_NAME', l_applicant_name, false);
1579: fnd_message.set_token('VACANCY_NAME', l_vacancy_name, false);
1580: document := fnd_message.get;
1581: --
1582: --
1575: else
1576: fnd_message.set_name('PER','IRC_412391_OFFER_APPR_EDIT');
1577: end if;
1578: fnd_message.set_token('PERSON_NAME', l_applicant_name, false);
1579: fnd_message.set_token('VACANCY_NAME', l_vacancy_name, false);
1580: document := fnd_message.get;
1581: --
1582: --
1583: end if;
1576: fnd_message.set_name('PER','IRC_412391_OFFER_APPR_EDIT');
1577: end if;
1578: fnd_message.set_token('PERSON_NAME', l_applicant_name, false);
1579: fnd_message.set_token('VACANCY_NAME', l_vacancy_name, false);
1580: document := fnd_message.get;
1581: --
1582: --
1583: end if;
1584: --