APPS.PA_AP_INTEGRATION dependencies on FND_PROFILE

Line 630: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

626: from po_distributions_all
627: where po_distribution_id = p_po_distribution_id ;
628:
629: BEGIN
630: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
631: l_pa_exp_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
632:
633: IF l_pa_debug_flag = 'Y' THEN
634: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 631: l_pa_exp_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');

627: where po_distribution_id = p_po_distribution_id ;
628:
629: BEGIN
630: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
631: l_pa_exp_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
632:
633: IF l_pa_debug_flag = 'Y' THEN
634: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
635: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PA_AP_INTEGRATION', 'Default Exp item date profile:'||l_pa_exp_date_default) ;

Line 714: l_default_exp_org := FND_PROFILE.VALUE('PA_DEFAULT_EXP_ORG');

710: FROM per_organization_units
711: WHERE organization_id = p_organization_id;
712: /* Bug 5555041 - End */
713: BEGIN
714: l_default_exp_org := FND_PROFILE.VALUE('PA_DEFAULT_EXP_ORG');
715:
716: /* Bug 5555041 - Start */
717: OPEN c_get_org_id(l_default_exp_org);
718: FETCH c_get_org_id INTO l_organization_id;

Line 841: decode(NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT'),

837: cursor patc_cursor is
838: select
839: POD.project_id PROJECT_ID,
840: POD.task_id TASK_ID,
841: decode(NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT'),
842: 'INVTRNSDT',
843: p_transaction_date,
844: 'INVGLDT',
845: p_gl_date,

Line 892: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

888: and pod.po_distribution_id = p_po_distribution_id
889: and G.set_of_books_id = pod.set_of_books_id;
890:
891: BEGIN
892: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
893: /*In case of null value of profile option, we would use source doucment ei date*/
894: l_pa_exp_date_default := NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT');
895:
896: /* Verfication variable to check if gms is installed */

Line 894: l_pa_exp_date_default := NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT');

890:
891: BEGIN
892: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
893: /*In case of null value of profile option, we would use source doucment ei date*/
894: l_pa_exp_date_default := NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT');
895:
896: /* Verfication variable to check if gms is installed */
897: l_gms_installed := pa_gms_api.vert_install; /*Added for bug 14050469*/
898:

Line 935: decode(NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT'),

931: IF l_gms_installed THEN /*Added for bug 14050469 */
932:
933: begin
934: select awd.award_id,
935: decode(NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT'),
936: 'INVTRNSDT',
937: p_transaction_date,
938: 'INVGLDT',
939: p_gl_date,