APPS.PQH_SS_WORKFLOW dependencies on FND_PROFILE

Line 2371: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')

2367: --
2368: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2369: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2370: -- assignment_id, selected_person_id,
2371: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2372: FROM hr_api_transactions
2373: WHERE item_type = c_itemType
2374: AND item_key = c_itemKey;
2375: --

Line 2384: -- l_profileValue := NVL(fnd_profile.value(l_profileName),'N');

2380: -- l_ntfId := SUBSTR(document_id,1,INSTR(document_id,':')-1);
2381: -- l_checkProfile := SUBSTR(document_id,INSTR(document_id,':')+1);
2382:
2383: -- IF (l_checkProfile = 'Y' ) THEN
2384: -- l_profileValue := NVL(fnd_profile.value(l_profileName),'N');
2385: -- END IF;
2386:
2387: --dbms_output.put_line('NtfId: '||l_ntfId);
2388:

Line 2751: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');

2747: --
2748: -- if future termination then check profile and set error or warning
2749: IF ( l_terminationDate > trunc(sysdate) ) THEN
2750: p_sendToHr := 'Y'; -- so that it is send to hr rep
2751: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');
2752: --
2753: IF ( l_profileValue = 'ERROR' OR l_slParmFound= 'Y' ) THEN
2754: p_hasErrors := 'Y'; -- To send error notification
2755: l_errorMsg := l_errorMsg||add_message('ERR','PQH','PQH_SS_FUT_TERM_EXISTS_ERR',

Line 2796: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_TRANSACTION_REFRESH'),'N');

2792:
2793: IF (p_calledFrom = 'FINAL_VALIDATION') THEN
2794: l_errorMsg := l_errorMsg||add_message('ERR','PQH','PQH_SS_INTRVN_ACTN_NTF_ERR',p_calledFrom,p_addToPub);
2795: ELSE
2796: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_TRANSACTION_REFRESH'),'N');
2797: --
2798: IF (l_profileValue = 'N') THEN
2799:
2800: l_errorMsg := l_errorMsg||

Line 2809: --IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' AND l_editAllowed='Y') THEN

2805: l_warningMsg := l_warningMsg||
2806: add_message('WRN','PQH','PQH_SS_INTRVN_ACTN_NTF_WRN',p_calledFrom,p_addToPub);
2807: else
2808: -- check the profile if the system is configured for approvers editing
2809: --IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' AND l_editAllowed='Y') THEN
2810: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
2811: l_warningMsg := l_warningMsg||
2812: add_message('WRN','PER','HR_INTRVN_ACTN_NTF_WRN_AE',p_calledFrom,p_addToPub);
2813: null;

Line 2810: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN

2806: add_message('WRN','PQH','PQH_SS_INTRVN_ACTN_NTF_WRN',p_calledFrom,p_addToPub);
2807: else
2808: -- check the profile if the system is configured for approvers editing
2809: --IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' AND l_editAllowed='Y') THEN
2810: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
2811: l_warningMsg := l_warningMsg||
2812: add_message('WRN','PER','HR_INTRVN_ACTN_NTF_WRN_AE',p_calledFrom,p_addToPub);
2813: null;
2814: else

Line 2826: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');

2822: --
2823: END IF;
2824: --
2825: IF ( l_futureChange = 'Y' ) THEN
2826: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');
2827: if (l_profileValue = 'APPROVE_ONLY' AND NVL(l_slParmFound,'X') <> 'Y' ) THEN
2828: -- if it's final validation and intervening changes are found, then the txn will
2829: -- not be routed to HR Rep, intead Transaction error notification will be sent
2830: -- When that happens no need to show the warning "Future change exist, txn will

Line 2858: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_CONCURRENT_TXN'),'N');

2854: --
2855: END IF;
2856: -- Pending Transaction Found
2857: IF ( l_pendingTxn = 'Y' ) THEN
2858: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_CONCURRENT_TXN'),'N');
2859: IF (l_profileValue = 'N') THEN
2860: p_hasErrors := 'Y';
2861: l_errorMsg := l_errorMsg||
2862: add_message('ERR','PQH','PQH_SS_PENDING_TXN_NTF_ERR',p_calledFrom,p_addToPub);

Line 2870: l_profileValue := NVL(fnd_profile.value('PQH_ENABLE_INELIGIBLE_ACTIONS'),'N');

2866: END IF;
2867: END IF;
2868: -- Person is Ineligible
2869: IF ( l_isPersonElig = 'N' ) THEN -- Person Ineligible
2870: l_profileValue := NVL(fnd_profile.value('PQH_ENABLE_INELIGIBLE_ACTIONS'),'N');
2871: IF (l_profileValue = 'N') THEN
2872: p_hasErrors := 'Y';
2873: l_errorMsg := l_errorMsg||
2874: add_message('ERR','PQH','PQH_SS_PERSON_INELIG_NTF_ERR',p_calledFrom,p_addToPub);