DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on PSP_GENERAL

Line 174: psp_general.TRANSACTION_CHANGE_PURGEBLE; --2431917

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

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

175: g_business_group_id := p_business_group_id;
176: g_set_of_books_id := p_set_of_books_id;
177: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
178:
179: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
180:
181: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
182:
183: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859

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

177: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */
178:
179: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
180:
181: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
182:
183: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
184: g_suspense_failed := 'FALSE';
185: g_process_complete := TRUE;

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

179: g_currency_code := psp_general.get_currency_code(p_business_group_id);-- For bug 2478000 Qubec fix
180:
181: psp_general.get_currency_precision(g_currency_code, g_precision, g_ext_precision);
182:
183: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
184: g_suspense_failed := 'FALSE';
185: g_process_complete := TRUE;
186:
187: OPEN autopop_config_cur;

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

2994: -- OPEN org_susp_ac_cur(l_organization_id,l_encumbrance_date);
2995: -- FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,l_award_id, l_task_id;
2996: IF org_susp_ac_cur%NOTFOUND THEN
2997: / * Following code is added for bug 2056877 ,Added validation for generic suspense account * /
2998: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,
2999: p_business_group_id,
3000: p_set_of_books_id,
3001: l_organization_account_id );
3002: / * --------------------------------------------------------------------

Line 3059: psp_general.poeta_effective_date(l_encumbrance_date,

3055: l_effective_date := p_period_end_date;
3056: ELSE
3057: l_gl_project_flag := 'P';
3058:
3059: psp_general.poeta_effective_date(l_encumbrance_date,
3060: l_project_id,
3061: l_award_id,
3062: l_task_id,
3063: l_effective_date,

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

3565: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,
3566: l_expenditure_organization_id, l_expenditure_type, l_award_id, l_task_id;
3567:
3568: IF org_susp_ac_cur%NOTFOUND THEN
3569: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),
3570: p_business_group_id,
3571: p_set_of_books_id,
3572: l_organization_account_id);
3573:

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

3603: l_gl_project_flag := 'G';
3604: l_effective_date := r_suspense_ac.end_date(recno);
3605: ELSE
3606: l_gl_project_flag := 'P';
3607: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3608: l_project_id, l_award_id, l_task_id, l_effective_date,
3609: l_return_status);
3610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Computing PA week ending date(s)');
4812:
4813: FOR recno IN 1..r_interface.txn_interface_id.COUNT
4814: LOOP
4815: psp_general.get_gms_effective_date(r_interface.person_id(recno), r_interface.gms_overriding_date(recno));
4816: -- set the context to single to call pa_utils function
4817: mo_global.set_policy_context('S', r_interface.operating_unit(recno) );
4818: r_interface.exp_end_date(recno) := pa_utils.getweekending(r_interface.gms_overriding_date(recno));
4819: END LOOP;

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

5427: 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;
5428:
5429: IF org_susp_ac_cur%NOTFOUND THEN
5430: / * Following code is added for bug 2056877 ,Added validation for generic suspense account * /
5431: l_return_value := psp_general.find_global_suspense(l_encumbrance_date,
5432: p_business_group_id,
5433: p_set_of_books_id,
5434: l_organization_account_id);
5435: / * --------------------------------------------------------------------

Line 5490: psp_general.poeta_effective_date(l_encumbrance_date,

5486: l_gl_project_flag := 'G';
5487: l_effective_date := p_period_end_date;
5488: ELSE
5489: l_gl_project_flag := 'P';
5490: psp_general.poeta_effective_date(l_encumbrance_date,
5491: l_project_id,
5492: l_award_id,
5493: l_task_id,
5494: l_effective_date,

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

6119: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,
6120: l_expenditure_organization_id, l_expenditure_type, l_award_id, l_task_id;
6121:
6122: IF org_susp_ac_cur%NOTFOUND THEN
6123: l_return_value := psp_general.find_global_suspense(r_suspense_ac.encumbrance_date(recno),
6124: p_business_group_id,
6125: p_set_of_books_id,
6126: l_organization_account_id);
6127:

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

6182: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6183: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6184: l_autopop_error := 'AUTO_POP_NO_VALUE';
6185: END IF;
6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);

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

6196: END IF;
6197: END IF;
6198: ELSE
6199: l_gl_project_flag := 'P';
6200: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6201: l_project_id, l_award_id, l_task_id, l_effective_date,
6202: l_return_status);
6203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6289: 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))),

6285: suspense_reason_code = 'ES:' || r_suspense_ac.interface_status(recno),
6286: gl_project_flag = l_gl_project_flag,
6287: encumbrance_date = l_effective_date,
6288: enc_end_date = LEAST(enc_end_date, g_def_end_date),
6289: 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))),
6290: status_code = 'N'
6291: WHERE rowid = r_suspense_ac.row_id(recno);
6292:
6293: add_st_warnings(p_assignment_id => r_suspense_ac.assignment_id(recno),

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

6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;
6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

Line 6982: psp_general.add_report_error

6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;
6980: END IF;
6981:
6982: psp_general.add_report_error
6983: (p_request_id => l_request_id,
6984: p_message_level => 'W',
6985: p_source_id => st_warnings.assignment_id(recno),
6986: p_source_name => l_assignment_number,