DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on PSP_GENERAL

Line 176: psp_general.TRANSACTION_CHANGE_PURGEBLE; --2431917

172: p_set_of_books_id: ' || p_set_of_books_id);
173:
174: g_error_api_path := '';
175: fnd_msg_pub.initialize;
176: psp_general.TRANSACTION_CHANGE_PURGEBLE; --2431917
177: g_business_group_id := p_business_group_id;
178: g_set_of_books_id := p_set_of_books_id;
179: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
180:

Line 181: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix

177: g_business_group_id := p_business_group_id;
178: g_set_of_books_id := p_set_of_books_id;
179: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
180:
181: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'calling psp_general.get_currency_precision');
183: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
184:
185: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859

Line 182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'calling psp_general.get_currency_precision');

178: g_set_of_books_id := p_set_of_books_id;
179: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
180:
181: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'calling psp_general.get_currency_precision');
183: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
184:
185: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
186: g_suspense_failed := 'FALSE';

Line 183: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);

179: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
180:
181: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'calling psp_general.get_currency_precision');
183: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
184:
185: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
186: g_suspense_failed := 'FALSE';
187: g_process_complete := TRUE;

Line 185: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859

181: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'calling psp_general.get_currency_precision');
183: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
184:
185: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
186: g_suspense_failed := 'FALSE';
187: g_process_complete := TRUE;
188:
189: OPEN autopop_config_cur;

Line 3040: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,

3036: -- OPEN org_susp_ac_cur(l_organization_id,l_encumbrance_date);
3037: -- FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,l_award_id, l_task_id;
3038: IF org_susp_ac_cur%NOTFOUND THEN
3039: / * Following code is added for bug 2056877 ,Added validation for generic suspense account * /
3040: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,
3041: p_business_group_id,
3042: p_set_of_books_id,
3043: l_organization_account_id );
3044: / * --------------------------------------------------------------------

Line 3101: psp_general.poeta_effective_date(l_encumbrance_date,

3097: l_effective_date := p_period_end_date;
3098: ELSE
3099: l_gl_project_flag := 'P';
3100:
3101: psp_general.poeta_effective_date(l_encumbrance_date,
3102: l_project_id,
3103: l_award_id,
3104: l_task_id,
3105: l_effective_date,

Line 3619: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),

3615: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,
3616: l_expenditure_organization_id, l_expenditure_type, l_award_id, l_task_id;
3617:
3618: IF org_susp_ac_cur%NOTFOUND THEN
3619: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),
3620: p_business_group_id,
3621: p_set_of_books_id,
3622: l_organization_account_id);
3623:

Line 3657: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),

3653: l_gl_project_flag := 'G';
3654: l_effective_date := r_suspense_ac.end_date(recno);
3655: ELSE
3656: l_gl_project_flag := 'P';
3657: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3658: l_project_id, l_award_id, l_task_id, l_effective_date,
3659: l_return_status);
3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4939: psp_general.get_gms_effective_date(r_interface.person_id(recno), r_interface.gms_overriding_date(recno));

4935: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Computing PA week ending date(s)');
4936:
4937: FOR recno IN 1..r_interface.txn_interface_id.COUNT
4938: LOOP
4939: psp_general.get_gms_effective_date(r_interface.person_id(recno), r_interface.gms_overriding_date(recno));
4940: -- set the context to single to call pa_utils function
4941: mo_global.set_policy_context('S', r_interface.operating_unit(recno) );
4942: r_interface.exp_end_date(recno) := pa_utils.getweekending(r_interface.gms_overriding_date(recno));
4943: END LOOP;

Line 5614: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,

5610: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id, l_expenditure_organization_id, l_expenditure_type, l_award_id,l_task_id;
5611:
5612: IF org_susp_ac_cur%NOTFOUND THEN
5613: / * Following code is added for bug 2056877 ,Added validation for generic suspense account * /
5614: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,
5615: p_business_group_id,
5616: p_set_of_books_id,
5617: l_organization_account_id);
5618: / * --------------------------------------------------------------------

Line 5673: psp_general.poeta_effective_date(l_encumbrance_date,

5669: l_gl_project_flag := 'G';
5670: l_effective_date := p_period_end_date;
5671: ELSE
5672: l_gl_project_flag := 'P';
5673: psp_general.poeta_effective_date(l_encumbrance_date,
5674: l_project_id,
5675: l_award_id,
5676: l_task_id,
5677: l_effective_date,

Line 6324: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),

6320: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,
6321: l_expenditure_organization_id, l_expenditure_type, l_award_id, l_task_id;
6322:
6323: IF org_susp_ac_cur%NOTFOUND THEN
6324: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),
6325: p_business_group_id,
6326: p_set_of_books_id,
6327: l_organization_account_id);
6328:

Line 6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);

6383: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6384: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6385: l_autopop_error := 'AUTO_POP_NO_VALUE';
6386: END IF;
6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);

Line 6401: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),

6397: END IF;
6398: END IF;
6399: ELSE
6400: l_gl_project_flag := 'P';
6401: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6402: l_project_id, l_award_id, l_task_id, l_effective_date,
6403: l_return_status);
6404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6492: encumbrance_amount = (encumbrance_amount * (psp_general.business_days(enc_start_date, LEAST(enc_end_date, g_def_end_date)) / psp_general.business_days(enc_start_date, enc_end_date))),

6488: suspense_reason_code = 'ES:' || r_suspense_ac.interface_status(recno),
6489: gl_project_flag = l_gl_project_flag,
6490: encumbrance_date = l_effective_date,
6491: enc_end_date = LEAST(enc_end_date, g_def_end_date),
6492: encumbrance_amount = (encumbrance_amount * (psp_general.business_days(enc_start_date, LEAST(enc_end_date, g_def_end_date)) / psp_general.business_days(enc_start_date, enc_end_date))),
6493: status_code = 'N'
6494: WHERE rowid = r_suspense_ac.row_id(recno);
6495:
6496: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'updated psp_enc_lines5 count'||sql%rowcount);

Line 7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));

7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;
7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

Line 7218: psp_general.add_report_error

7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;
7216: END IF;
7217:
7218: psp_general.add_report_error
7219: (p_request_id => l_request_id,
7220: p_message_level => 'W',
7221: p_source_id => st_warnings.assignment_id(recno),
7222: p_source_name => l_assignment_number,