APPS.PQH_SS_WORKFLOW dependencies on FND_PROFILE

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

2344: --
2345: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2346: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2347: -- assignment_id, selected_person_id,
2348: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2349: FROM hr_api_transactions
2350: WHERE item_type = c_itemType
2351: AND item_key = c_itemKey;
2352: --

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

2357: -- l_ntfId := SUBSTR(document_id,1,INSTR(document_id,':')-1);
2358: -- l_checkProfile := SUBSTR(document_id,INSTR(document_id,':')+1);
2359:
2360: -- IF (l_checkProfile = 'Y' ) THEN
2361: -- l_profileValue := NVL(fnd_profile.value(l_profileName),'N');
2362: -- END IF;
2363:
2364: --dbms_output.put_line('NtfId: '||l_ntfId);
2365:

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

2723: --
2724: -- if future termination then check profile and set error or warning
2725: IF ( l_terminationDate > trunc(sysdate) ) THEN
2726: p_sendToHr := 'Y'; -- so that it is send to hr rep
2727: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');
2728: --
2729: IF ( l_profileValue = 'ERROR' OR l_slParmFound= 'Y' ) THEN
2730: p_hasErrors := 'Y'; -- To send error notification
2731: l_errorMsg := l_errorMsg||add_message('ERR','PQH','PQH_SS_FUT_TERM_EXISTS_ERR',

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

2768:
2769: IF (p_calledFrom = 'FINAL_VALIDATION') THEN
2770: l_errorMsg := l_errorMsg||add_message('ERR','PQH','PQH_SS_INTRVN_ACTN_NTF_ERR',p_calledFrom,p_addToPub);
2771: ELSE
2772: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_TRANSACTION_REFRESH'),'N');
2773: --
2774: IF (l_profileValue = 'N') THEN
2775:
2776: l_errorMsg := l_errorMsg||

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

2781: l_warningMsg := l_warningMsg||
2782: add_message('WRN','PQH','PQH_SS_INTRVN_ACTN_NTF_WRN',p_calledFrom,p_addToPub);
2783: else
2784: -- check the profile if the system is configured for approvers editing
2785: --IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' AND l_editAllowed='Y') THEN
2786: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
2787: l_warningMsg := l_warningMsg||
2788: add_message('WRN','PER','HR_INTRVN_ACTN_NTF_WRN_AE',p_calledFrom,p_addToPub);
2789: null;

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

2782: add_message('WRN','PQH','PQH_SS_INTRVN_ACTN_NTF_WRN',p_calledFrom,p_addToPub);
2783: else
2784: -- check the profile if the system is configured for approvers editing
2785: --IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' AND l_editAllowed='Y') THEN
2786: IF ( nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
2787: l_warningMsg := l_warningMsg||
2788: add_message('WRN','PER','HR_INTRVN_ACTN_NTF_WRN_AE',p_calledFrom,p_addToPub);
2789: null;
2790: else

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

2798: --
2799: END IF;
2800: --
2801: IF ( l_futureChange = 'Y' ) THEN
2802: l_profileValue := NVL(fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND'),'ERROR');
2803: if (l_profileValue = 'APPROVE_ONLY' AND NVL(l_slParmFound,'X') <> 'Y' ) THEN
2804: -- if it's final validation and intervening changes are found, then the txn will
2805: -- not be routed to HR Rep, intead Transaction error notification will be sent
2806: -- When that happens no need to show the warning "Future change exist, txn will

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

2830: --
2831: END IF;
2832: -- Pending Transaction Found
2833: IF ( l_pendingTxn = 'Y' ) THEN
2834: l_profileValue := NVL(fnd_profile.value('PQH_ALLOW_CONCURRENT_TXN'),'N');
2835: IF (l_profileValue = 'N') THEN
2836: p_hasErrors := 'Y';
2837: l_errorMsg := l_errorMsg||
2838: add_message('ERR','PQH','PQH_SS_PENDING_TXN_NTF_ERR',p_calledFrom,p_addToPub);

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

2842: END IF;
2843: END IF;
2844: -- Person is Ineligible
2845: IF ( l_isPersonElig = 'N' ) THEN -- Person Ineligible
2846: l_profileValue := NVL(fnd_profile.value('PQH_ENABLE_INELIGIBLE_ACTIONS'),'N');
2847: IF (l_profileValue = 'N') THEN
2848: p_hasErrors := 'Y';
2849: l_errorMsg := l_errorMsg||
2850: add_message('ERR','PQH','PQH_SS_PERSON_INELIG_NTF_ERR',p_calledFrom,p_addToPub);