DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on FND_PROFILE

Line 6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

6389: l_last_update_date := SYSDATE;
6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6392: l_request_id := fnd_global.conc_request_id;
6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6395:
6396: OPEN action_parameters_cur;
6397: FETCH action_parameters_cur INTO l_payroll_id, l_process_mode;

Line 6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6392: l_request_id := fnd_global.conc_request_id;
6393: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6394: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6395:
6396: OPEN action_parameters_cur;
6397: FETCH action_parameters_cur INTO l_payroll_id, l_process_mode;
6398: CLOSE action_parameters_cur;

Line 6967: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

6963: BEGIN
6964: SAVEPOINT CEL_ARCHIVE;
6965: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
6966:
6967: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6968: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6969: g_set_of_books_id := l_set_of_books_id;
6970: g_business_group_id := l_business_group_id;
6971: g_enc_line_type := 'U';

Line 6968: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

6964: SAVEPOINT CEL_ARCHIVE;
6965: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
6966:
6967: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6968: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6969: g_set_of_books_id := l_set_of_books_id;
6970: g_business_group_id := l_business_group_id;
6971: g_enc_line_type := 'U';
6972: g_package_name := 'PSP_ENC_CREATE_LINES.';

Line 7484: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

7480: CLOSE error_check_cur;
7481:
7482: IF (l_error_count > 0) THEN
7483: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7484: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7485: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7486: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7487: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7488: l_request_id := fnd_request.submit_request('PSP',

Line 7485: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

7481:
7482: IF (l_error_count > 0) THEN
7483: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7484: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7485: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7486: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7487: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7488: l_request_id := fnd_request.submit_request('PSP',
7489: 'PSPENRSLT',

Line 7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

7623: AND pesl.superceded_line_id is NOT NULL);
7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7625: END IF;
7626:
7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7629: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7630: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7631: l_request_id := fnd_request.submit_request('PSP',

Line 7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7625: END IF;
7626:
7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7629: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7630: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7631: l_request_id := fnd_request.submit_request('PSP',
7632: 'PSPENRSLT',

Line 7655: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

7651: FETCH st_count_cur INTO l_st_count;
7652: CLOSE st_count_cur;
7653:
7654: IF (l_st_count > 0) THEN
7655: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7656: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7657:
7658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Summarize and Transfer');
7659: l_request_id := fnd_request.submit_request('PSP',

Line 7656: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

7652: CLOSE st_count_cur;
7653:
7654: IF (l_st_count > 0) THEN
7655: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7656: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7657:
7658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Summarize and Transfer');
7659: l_request_id := fnd_request.submit_request('PSP',
7660: 'PSPENSTR',

Line 8614: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

8610: p_payroll_id: ' || p_payroll_id || '
8611: p_process_mode: ' || p_process_mode);
8612:
8613: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8614: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8615: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8616: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8617: l_set_of_books_id: ' || l_set_of_books_id || '
8618: l_business_group_id: ' || l_business_group_id);

Line 8615: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

8611: p_process_mode: ' || p_process_mode);
8612:
8613: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8614: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8615: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8616: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8617: l_set_of_books_id: ' || l_set_of_books_id || '
8618: l_business_group_id: ' || l_business_group_id);
8619: