APPS.PSP_ENC_CREATE_LINES dependencies on FND_MESSAGE

Line 484: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');

480: FETCH c_cnt_default_org INTO l_count;
481: CLOSE c_cnt_default_org;
482:
483: IF l_count = 0 THEN
484: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');
485: fnd_msg_pub.add;
486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488:

Line 493: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');

489: OPEN time_pct_def_cur;
490: FETCH time_pct_def_cur INTO p_enc_org_end_date, l_enc_end_date_id, l_prev_enc_end_date;
491: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
492: p_enc_org_end_date := NULL;
493: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
494: fnd_msg_pub.add;
495: g_error_message := fnd_message.get;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;

Line 495: g_error_message := fnd_message.get;

491: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
492: p_enc_org_end_date := NULL;
493: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
494: fnd_msg_pub.add;
495: g_error_message := fnd_message.get;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: CLOSE time_pct_def_cur;
499:

Line 948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');

944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
949: fnd_message.set_token('START_DATE', l_period_start_date);
950: fnd_message.set_token('END_DATE', l_period_end_date);
951: g_error_message := fnd_message.get;
952: RAISE DIVIDE_BY_ZERO;

Line 949: fnd_message.set_token('START_DATE', l_period_start_date);

945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
949: fnd_message.set_token('START_DATE', l_period_start_date);
950: fnd_message.set_token('END_DATE', l_period_end_date);
951: g_error_message := fnd_message.get;
952: RAISE DIVIDE_BY_ZERO;
953: END IF;

Line 950: fnd_message.set_token('END_DATE', l_period_end_date);

946:
947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
949: fnd_message.set_token('START_DATE', l_period_start_date);
950: fnd_message.set_token('END_DATE', l_period_end_date);
951: g_error_message := fnd_message.get;
952: RAISE DIVIDE_BY_ZERO;
953: END IF;
954:

Line 951: g_error_message := fnd_message.get;

947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
949: fnd_message.set_token('START_DATE', l_period_start_date);
950: fnd_message.set_token('END_DATE', l_period_end_date);
951: g_error_message := fnd_message.get;
952: RAISE DIVIDE_BY_ZERO;
953: END IF;
954:
955: l_enc_amount := psp_st_ext.get_enc_amount (p_assignment_id => p_assignment_id,

Line 1677: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');

1673: l_task_id,
1674: l_effective_date,
1675: l_return_status);
1676: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1677: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1678: g_error_message := fnd_message.get;
1679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1680: END IF;
1681:

Line 1678: g_error_message := fnd_message.get;

1674: l_effective_date,
1675: l_return_status);
1676: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1677: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1678: g_error_message := fnd_message.get;
1679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1680: END IF;
1681:
1682: -- R12 moac uptake. Set the MOAC Context to Single

Line 1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');

1738: FETCH exp_org_name_cur INTO l_exp_org_name;
1739: CLOSE exp_org_name_cur;
1740:
1741: IF (l_patc_status IS NOT NULL) THEN
1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);

Line 1743: fnd_message.set_token('PJ', l_project_number);

1739: CLOSE exp_org_name_cur;
1740:
1741: IF (l_patc_status IS NOT NULL) THEN
1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);

Line 1744: fnd_message.set_token('TK', l_task_number);

1740:
1741: IF (l_patc_status IS NOT NULL) THEN
1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

Line 1745: fnd_message.set_token('AW', l_award_number);

1741: IF (l_patc_status IS NOT NULL) THEN
1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

Line 1746: fnd_message.set_token('EO', l_exp_org_name);

1742: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);

Line 1747: fnd_message.set_token('ET', l_expenditure_type);

1743: fnd_message.set_token('PJ', l_project_number);
1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE

Line 1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

1744: fnd_message.set_token('TK', l_task_number);
1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

Line 1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

1745: fnd_message.set_token('AW', l_award_number);
1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);

Line 1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);

1746: fnd_message.set_token('EO', l_exp_org_name);
1747: fnd_message.set_token('ET', l_expenditure_type);
1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);

Line 1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

1748: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);

Line 1753: fnd_message.set_token('PJ', l_project_number);

1749: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);

Line 1754: fnd_message.set_token('TK', l_task_number);

1750: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

Line 1755: fnd_message.set_token('AW', l_award_number);

1751: ELSE
1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

Line 1756: fnd_message.set_token('EO', l_exp_org_name);

1752: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

Line 1757: fnd_message.set_token('ET', l_expenditure_type);

1753: fnd_message.set_token('PJ', l_project_number);
1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1761: END IF;

Line 1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

1754: fnd_message.set_token('TK', l_task_number);
1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1761: END IF;
1762: g_error_message := fnd_message.get;

Line 1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

1755: fnd_message.set_token('AW', l_award_number);
1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1761: END IF;
1762: g_error_message := fnd_message.get;
1763: fnd_file.put_line(fnd_file.log, g_error_message);

Line 1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

1756: fnd_message.set_token('EO', l_exp_org_name);
1757: fnd_message.set_token('ET', l_expenditure_type);
1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1761: END IF;
1762: g_error_message := fnd_message.get;
1763: fnd_file.put_line(fnd_file.log, g_error_message);
1764: RAISE SUSPENSE_AC_INVALID;

Line 1762: g_error_message := fnd_message.get;

1758: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1759: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1760: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1761: END IF;
1762: g_error_message := fnd_message.get;
1763: fnd_file.put_line(fnd_file.log, g_error_message);
1764: RAISE SUSPENSE_AC_INVALID;
1765: END IF;
1766:

Line 1869: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');

1865: l_task_id,
1866: l_effective_date,
1867: l_return_status);
1868: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1869: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1870: g_error_message := fnd_message.get;
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873:

Line 1870: g_error_message := fnd_message.get;

1866: l_effective_date,
1867: l_return_status);
1868: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1869: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1870: g_error_message := fnd_message.get;
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873:
1874: -- R12 moac uptake. Set the MOAC Context to Single

Line 1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');

1929: FETCH exp_org_name_cur INTO l_exp_org_name;
1930: CLOSE exp_org_name_cur;
1931:
1932: IF (l_patc_status IS NOT NULL) THEN
1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);

Line 1934: fnd_message.set_token('PJ', l_project_number);

1930: CLOSE exp_org_name_cur;
1931:
1932: IF (l_patc_status IS NOT NULL) THEN
1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);

Line 1935: fnd_message.set_token('TK', l_task_number);

1931:
1932: IF (l_patc_status IS NOT NULL) THEN
1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

Line 1936: fnd_message.set_token('AW', l_award_number);

1932: IF (l_patc_status IS NOT NULL) THEN
1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

Line 1937: fnd_message.set_token('EO', l_exp_org_name);

1933: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);

Line 1938: fnd_message.set_token('ET', l_expenditure_type);

1934: fnd_message.set_token('PJ', l_project_number);
1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE

Line 1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

1935: fnd_message.set_token('TK', l_task_number);
1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

Line 1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

1936: fnd_message.set_token('AW', l_award_number);
1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);

Line 1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);

1937: fnd_message.set_token('EO', l_exp_org_name);
1938: fnd_message.set_token('ET', l_expenditure_type);
1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);

Line 1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

1939: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);

Line 1944: fnd_message.set_token('PJ', l_project_number);

1940: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);

Line 1945: fnd_message.set_token('TK', l_task_number);

1941: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

Line 1946: fnd_message.set_token('AW', l_award_number);

1942: ELSE
1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

Line 1947: fnd_message.set_token('EO', l_exp_org_name);

1943: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

Line 1948: fnd_message.set_token('ET', l_expenditure_type);

1944: fnd_message.set_token('PJ', l_project_number);
1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1952: END IF;

Line 1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

1945: fnd_message.set_token('TK', l_task_number);
1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1952: END IF;
1953: g_error_message := fnd_message.get;

Line 1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

1946: fnd_message.set_token('AW', l_award_number);
1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1952: END IF;
1953: g_error_message := fnd_message.get;
1954: fnd_file.put_line(fnd_file.log, g_error_message);

Line 1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

1947: fnd_message.set_token('EO', l_exp_org_name);
1948: fnd_message.set_token('ET', l_expenditure_type);
1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1952: END IF;
1953: g_error_message := fnd_message.get;
1954: fnd_file.put_line(fnd_file.log, g_error_message);
1955: RAISE SUSPENSE_AC_INVALID;

Line 1953: g_error_message := fnd_message.get;

1949: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1950: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1951: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1952: END IF;
1953: g_error_message := fnd_message.get;
1954: fnd_file.put_line(fnd_file.log, g_error_message);
1955: RAISE SUSPENSE_AC_INVALID;
1956: END IF;
1957:

Line 2943: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');

2939: OPEN org_name_cur;
2940: FETCH org_name_cur INTO l_organization_name;
2941: CLOSE org_name_cur;
2942:
2943: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
2944: fnd_message.set_token('ORG_NAME', l_organization_name);
2945: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
2946: g_error_message := fnd_message.get;
2947: RAISE no_global_acct_exists;

Line 2944: fnd_message.set_token('ORG_NAME', l_organization_name);

2940: FETCH org_name_cur INTO l_organization_name;
2941: CLOSE org_name_cur;
2942:
2943: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
2944: fnd_message.set_token('ORG_NAME', l_organization_name);
2945: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
2946: g_error_message := fnd_message.get;
2947: RAISE no_global_acct_exists;
2948: END IF;

Line 2945: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);

2941: CLOSE org_name_cur;
2942:
2943: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
2944: fnd_message.set_token('ORG_NAME', l_organization_name);
2945: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
2946: g_error_message := fnd_message.get;
2947: RAISE no_global_acct_exists;
2948: END IF;
2949: END LOOP;

Line 2946: g_error_message := fnd_message.get;

2942:
2943: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
2944: fnd_message.set_token('ORG_NAME', l_organization_name);
2945: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
2946: g_error_message := fnd_message.get;
2947: RAISE no_global_acct_exists;
2948: END IF;
2949: END LOOP;
2950:

Line 3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');

3023: OPEN exp_org_name_cur;
3024: FETCH exp_org_name_cur INTO l_exp_org_name;
3025: CLOSE exp_org_name_cur;
3026:
3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);

Line 3028: fnd_message.set_token('PJ', l_project_number);

3024: FETCH exp_org_name_cur INTO l_exp_org_name;
3025: CLOSE exp_org_name_cur;
3026:
3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);

Line 3029: fnd_message.set_token('TK', l_task_number);

3025: CLOSE exp_org_name_cur;
3026:
3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE

Line 3030: fnd_message.set_token('AW', l_award_number);

3026:
3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);

Line 3031: fnd_message.set_token('EO', l_exp_org_name);

3027: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

Line 3032: fnd_message.set_token('ET', l_expenditure_type);

3028: fnd_message.set_token('PJ', l_project_number);
3029: fnd_message.set_token('TK', l_task_number);
3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);

Line 3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);

Line 3036: fnd_message.set_token('GL', l_gl_description);

3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);
3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);

Line 3038: fnd_message.set_token('START_DATE', l_asg_start_date);

3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);
3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3041: g_error_message := fnd_message.get;
3042: RAISE SUSPENSE_AUTOPOP_FAILED;

Line 3039: fnd_message.set_token('END_DATE', l_asg_end_date);

3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);
3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3041: g_error_message := fnd_message.get;
3042: RAISE SUSPENSE_AUTOPOP_FAILED;
3043: ELSE

Line 3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);

3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);
3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3041: g_error_message := fnd_message.get;
3042: RAISE SUSPENSE_AUTOPOP_FAILED;
3043: ELSE
3044: IF (l_acct_type = 'E') THEN

Line 3041: g_error_message := fnd_message.get;

3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);
3039: fnd_message.set_token('END_DATE', l_asg_end_date);
3040: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3041: g_error_message := fnd_message.get;
3042: RAISE SUSPENSE_AUTOPOP_FAILED;
3043: ELSE
3044: IF (l_acct_type = 'E') THEN
3045: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,

Line 3442: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');

3438: IF (g_error_message IS NULL) THEN
3439: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3440: END IF;
3441: p_return_status := fnd_api.g_ret_sts_unexp_error;
3442: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3443: FND_MSG_PUB.ADD;
3444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3445: END create_controls;
3446:

Line 3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');

3608: END IF; --Main IF :2317856
3609:
3610: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3611: IF l_bus_days_in_period = 0 THEN
3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3613: fnd_message.set_token('START_DATE', p_asg_start_date);
3614: fnd_message.set_token('END_DATE', p_asg_end_date);
3615: g_error_message := fnd_message.get;
3616: RAISE DIVIDE_BY_ZERO;

Line 3613: fnd_message.set_token('START_DATE', p_asg_start_date);

3609:
3610: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3611: IF l_bus_days_in_period = 0 THEN
3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3613: fnd_message.set_token('START_DATE', p_asg_start_date);
3614: fnd_message.set_token('END_DATE', p_asg_end_date);
3615: g_error_message := fnd_message.get;
3616: RAISE DIVIDE_BY_ZERO;
3617: END IF;

Line 3614: fnd_message.set_token('END_DATE', p_asg_end_date);

3610: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3611: IF l_bus_days_in_period = 0 THEN
3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3613: fnd_message.set_token('START_DATE', p_asg_start_date);
3614: fnd_message.set_token('END_DATE', p_asg_end_date);
3615: g_error_message := fnd_message.get;
3616: RAISE DIVIDE_BY_ZERO;
3617: END IF;
3618:

Line 3615: g_error_message := fnd_message.get;

3611: IF l_bus_days_in_period = 0 THEN
3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3613: fnd_message.set_token('START_DATE', p_asg_start_date);
3614: fnd_message.set_token('END_DATE', p_asg_end_date);
3615: g_error_message := fnd_message.get;
3616: RAISE DIVIDE_BY_ZERO;
3617: END IF;
3618:
3619: For j in 1 .. p_poeta_gl_hier_array.COUNT

Line 5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');

5910: IF (l_end_date >= l_asg_start_date) AND (l_start_date <= l_asg_end_date) THEN
5911: IF (l_process_flag = 'BAL') THEN
5912: l_reason_code := '1';
5913: l_schedule_percent := r_enc_period.r_schedule_percent(I);
5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
5915: fnd_message.set_token('START_DATE', l_asg_start_date);
5916: fnd_message.set_token('END_DATE', l_asg_end_date);
5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
5918: g_warning_message := fnd_message.get;

Line 5915: fnd_message.set_token('START_DATE', l_asg_start_date);

5911: IF (l_process_flag = 'BAL') THEN
5912: l_reason_code := '1';
5913: l_schedule_percent := r_enc_period.r_schedule_percent(I);
5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
5915: fnd_message.set_token('START_DATE', l_asg_start_date);
5916: fnd_message.set_token('END_DATE', l_asg_end_date);
5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
5918: g_warning_message := fnd_message.get;
5919: add_cel_warnings(p_start_date => l_asg_start_date,

Line 5916: fnd_message.set_token('END_DATE', l_asg_end_date);

5912: l_reason_code := '1';
5913: l_schedule_percent := r_enc_period.r_schedule_percent(I);
5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
5915: fnd_message.set_token('START_DATE', l_asg_start_date);
5916: fnd_message.set_token('END_DATE', l_asg_end_date);
5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
5918: g_warning_message := fnd_message.get;
5919: add_cel_warnings(p_start_date => l_asg_start_date,
5920: p_hierarchy_code => 'DA',

Line 5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));

5913: l_schedule_percent := r_enc_period.r_schedule_percent(I);
5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
5915: fnd_message.set_token('START_DATE', l_asg_start_date);
5916: fnd_message.set_token('END_DATE', l_asg_end_date);
5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
5918: g_warning_message := fnd_message.get;
5919: add_cel_warnings(p_start_date => l_asg_start_date,
5920: p_hierarchy_code => 'DA',
5921: p_end_date => l_asg_end_date,

Line 5918: g_warning_message := fnd_message.get;

5914: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
5915: fnd_message.set_token('START_DATE', l_asg_start_date);
5916: fnd_message.set_token('END_DATE', l_asg_end_date);
5917: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
5918: g_warning_message := fnd_message.get;
5919: add_cel_warnings(p_start_date => l_asg_start_date,
5920: p_hierarchy_code => 'DA',
5921: p_end_date => l_asg_end_date,
5922: p_warning_code => 'BAL',

Line 5926: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');

5922: p_warning_code => 'BAL',
5923: p_percent => r_enc_period.r_schedule_percent(I));
5924: ELSE
5925: l_reason_code := '3';
5926: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
5927: fnd_message.set_token('START_DATE', l_asg_start_date);
5928: fnd_message.set_token('END_DATE', l_asg_end_date);
5929: g_warning_message := fnd_message.get;
5930: add_cel_warnings(p_start_date => l_asg_start_date,

Line 5927: fnd_message.set_token('START_DATE', l_asg_start_date);

5923: p_percent => r_enc_period.r_schedule_percent(I));
5924: ELSE
5925: l_reason_code := '3';
5926: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
5927: fnd_message.set_token('START_DATE', l_asg_start_date);
5928: fnd_message.set_token('END_DATE', l_asg_end_date);
5929: g_warning_message := fnd_message.get;
5930: add_cel_warnings(p_start_date => l_asg_start_date,
5931: p_hierarchy_code => 'DA',

Line 5928: fnd_message.set_token('END_DATE', l_asg_end_date);

5924: ELSE
5925: l_reason_code := '3';
5926: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
5927: fnd_message.set_token('START_DATE', l_asg_start_date);
5928: fnd_message.set_token('END_DATE', l_asg_end_date);
5929: g_warning_message := fnd_message.get;
5930: add_cel_warnings(p_start_date => l_asg_start_date,
5931: p_hierarchy_code => 'DA',
5932: p_end_date => l_asg_end_date,

Line 5929: g_warning_message := fnd_message.get;

5925: l_reason_code := '3';
5926: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
5927: fnd_message.set_token('START_DATE', l_asg_start_date);
5928: fnd_message.set_token('END_DATE', l_asg_end_date);
5929: g_warning_message := fnd_message.get;
5930: add_cel_warnings(p_start_date => l_asg_start_date,
5931: p_hierarchy_code => 'DA',
5932: p_end_date => l_asg_end_date,
5933: p_warning_code => 'NO_CI');

Line 6463: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');

6459: FROM psp_enc_changed_assignments
6460: WHERE payroll_action_id = pactid;
6461:
6462: IF (SQL%ROWCOUNT = 0) THEN
6463: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6464: g_warning_message := fnd_message.get;
6465: fnd_file.put_line(fnd_file.log, g_warning_message);
6466: psp_general.add_report_error
6467: (p_request_id => l_request_id,

Line 6464: g_warning_message := fnd_message.get;

6460: WHERE payroll_action_id = pactid;
6461:
6462: IF (SQL%ROWCOUNT = 0) THEN
6463: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6464: g_warning_message := fnd_message.get;
6465: fnd_file.put_line(fnd_file.log, g_warning_message);
6466: psp_general.add_report_error
6467: (p_request_id => l_request_id,
6468: p_message_level => 'N',

Line 6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');

6833: FETCH element_name_cur INTO l_element_name;
6834: CLOSE element_name_cur;
6835:
6836: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;

Line 6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6834: CLOSE element_name_cur;
6835:
6836: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN

Line 6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6835:
6836: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');

Line 6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));

6836: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 6841: g_warning_message := fnd_message.get;

6837: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
6838: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

Line 6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');

6839: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;

Line 6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6840: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND

Line 6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6841: g_warning_message := fnd_message.get;
6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN

Line 6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));

6842: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));

Line 6847: g_warning_message := fnd_message.get;

6843: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
6844: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6845: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

Line 6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

Line 6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6856: g_warning_message := fnd_message.get;

Line 6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6856: g_warning_message := fnd_message.get;
6857: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN

Line 6854: fnd_message.set_token('GL', l_gl_description);

6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6856: g_warning_message := fnd_message.get;
6857: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
6858: OPEN project_number_cur(cel_warnings.project_id(recno));

Line 6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6856: g_warning_message := fnd_message.get;
6857: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
6858: OPEN project_number_cur(cel_warnings.project_id(recno));
6859: FETCH project_number_cur INTO l_project_number;

Line 6856: g_warning_message := fnd_message.get;

6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);
6855: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6856: g_warning_message := fnd_message.get;
6857: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
6858: OPEN project_number_cur(cel_warnings.project_id(recno));
6859: FETCH project_number_cur INTO l_project_number;
6860: CLOSE project_number_cur;

Line 6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');

6870: OPEN exp_org_name_cur(cel_warnings.exp_org_id(recno));
6871: FETCH exp_org_name_cur INTO l_exp_org_name;
6872: CLOSE exp_org_name_cur;
6873:
6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);

Line 6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6871: FETCH exp_org_name_cur INTO l_exp_org_name;
6872: CLOSE exp_org_name_cur;
6873:
6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);

Line 6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6872: CLOSE exp_org_name_cur;
6873:
6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);

Line 6877: fnd_message.set_token('PJ', l_project_number);

6873:
6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

Line 6878: fnd_message.set_token('TK', l_task_number);

6874: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

Line 6879: fnd_message.set_token('AW', l_award_number);

6875: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;

Line 6880: fnd_message.set_token('EO', l_exp_org_name);

6876: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN

Line 6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

6877: fnd_message.set_token('PJ', l_project_number);
6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');

Line 6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

6878: fnd_message.set_token('TK', l_task_number);
6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 6883: g_warning_message := fnd_message.get;

6879: fnd_message.set_token('AW', l_award_number);
6880: fnd_message.set_token('EO', l_exp_org_name);
6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

Line 6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');

6881: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6888: g_warning_message := fnd_message.get;
6889: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN

Line 6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6882: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6888: g_warning_message := fnd_message.get;
6889: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
6890: OPEN project_number_cur(cel_warnings.project_id(recno));

Line 6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6883: g_warning_message := fnd_message.get;
6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6888: g_warning_message := fnd_message.get;
6889: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
6890: OPEN project_number_cur(cel_warnings.project_id(recno));
6891: FETCH project_number_cur INTO l_project_number;

Line 6888: g_warning_message := fnd_message.get;

6884: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
6885: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
6886: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6887: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6888: g_warning_message := fnd_message.get;
6889: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
6890: OPEN project_number_cur(cel_warnings.project_id(recno));
6891: FETCH project_number_cur INTO l_project_number;
6892: CLOSE project_number_cur;

Line 6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');

6903: FETCH exp_org_name_cur INTO l_exp_org_name;
6904: CLOSE exp_org_name_cur;
6905:
6906: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);

Line 6908: fnd_message.set_token('PJ', l_project_number);

6904: CLOSE exp_org_name_cur;
6905:
6906: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

Line 6909: fnd_message.set_token('TK', l_task_number);

6905:
6906: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 6910: fnd_message.set_token('AW', l_award_number);

6906: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

Line 6911: fnd_message.set_token('EO', l_exp_org_name);

6907: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));

Line 6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

6908: fnd_message.set_token('PJ', l_project_number);
6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE

Line 6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6909: fnd_message.set_token('TK', l_task_number);
6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

Line 6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6910: fnd_message.set_token('AW', l_award_number);
6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);

Line 6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));

6911: fnd_message.set_token('EO', l_exp_org_name);
6912: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);

Line 6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

6913: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);

Line 6918: fnd_message.set_token('PJ', l_project_number);

6914: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

Line 6919: fnd_message.set_token('TK', l_task_number);

6915: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 6920: fnd_message.set_token('AW', l_award_number);

6916: ELSE
6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

Line 6921: fnd_message.set_token('EO', l_exp_org_name);

6917: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));

Line 6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

6918: fnd_message.set_token('PJ', l_project_number);
6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
6926: END IF;

Line 6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

6919: fnd_message.set_token('TK', l_task_number);
6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
6926: END IF;
6927: g_warning_message := fnd_message.get;

Line 6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

6920: fnd_message.set_token('AW', l_award_number);
6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
6926: END IF;
6927: g_warning_message := fnd_message.get;
6928: END IF;

Line 6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));

6921: fnd_message.set_token('EO', l_exp_org_name);
6922: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
6926: END IF;
6927: g_warning_message := fnd_message.get;
6928: END IF;
6929:

Line 6927: g_warning_message := fnd_message.get;

6923: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6924: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6925: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
6926: END IF;
6927: g_warning_message := fnd_message.get;
6928: END IF;
6929:
6930: psp_general.add_report_error
6931: (p_request_id => g_request_id,

Line 7500: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');

7496: TO_CHAR(l_set_of_books_id));
7497:
7498: IF l_request_id = 0 THEN
7499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7500: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7501: fnd_msg_pub.add;
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503: END IF;
7504: COMMIT;

Line 7643: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');

7639: TO_CHAR(l_set_of_books_id));
7640:
7641: IF l_request_id = 0 THEN
7642: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7643: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7644: fnd_msg_pub.add;
7645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7646: END IF;
7647: COMMIT;

Line 7670: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');

7666: TO_CHAR(l_set_of_books_id));
7667:
7668: IF l_request_id = 0 THEN
7669: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7670: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7671: fnd_msg_pub.add;
7672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7673: END IF;
7674:

Line 7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');

7684: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
7685:
7686: IF call_status = FALSE THEN
7687: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
7689: fnd_msg_pub.add;
7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');

Line 9035: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9031: OPEN process_descr_cur;
9032: FETCH process_descr_cur INTO l_process_description;
9033: CLOSE process_descr_cur;
9034:
9035: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9036: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9037: g_warning_message := fnd_message.get;
9038:
9039: OPEN asg_number_cur (l_enc_begin_date);

Line 9036: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9032: FETCH process_descr_cur INTO l_process_description;
9033: CLOSE process_descr_cur;
9034:
9035: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9036: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9037: g_warning_message := fnd_message.get;
9038:
9039: OPEN asg_number_cur (l_enc_begin_date);
9040: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9037: g_warning_message := fnd_message.get;

9033: CLOSE process_descr_cur;
9034:
9035: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9036: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9037: g_warning_message := fnd_message.get;
9038:
9039: OPEN asg_number_cur (l_enc_begin_date);
9040: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9041: CLOSE asg_number_cur;

Line 9111: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9107: OPEN process_descr_cur;
9108: FETCH process_descr_cur INTO l_process_description;
9109: CLOSE process_descr_cur;
9110:
9111: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9112: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9113: g_warning_message := fnd_message.get;
9114:
9115: OPEN asg_number_cur (l_termination_date1);

Line 9112: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9108: FETCH process_descr_cur INTO l_process_description;
9109: CLOSE process_descr_cur;
9110:
9111: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9112: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9113: g_warning_message := fnd_message.get;
9114:
9115: OPEN asg_number_cur (l_termination_date1);
9116: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9113: g_warning_message := fnd_message.get;

9109: CLOSE process_descr_cur;
9110:
9111: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9112: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9113: g_warning_message := fnd_message.get;
9114:
9115: OPEN asg_number_cur (l_termination_date1);
9116: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9117: CLOSE asg_number_cur;

Line 9178: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9174: OPEN process_descr_cur;
9175: FETCH process_descr_cur INTO l_process_description;
9176: CLOSE process_descr_cur;
9177:
9178: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9179: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9180: g_warning_message := fnd_message.get;
9181:
9182: OPEN asg_number_cur (l_termination_date2);

Line 9179: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9175: FETCH process_descr_cur INTO l_process_description;
9176: CLOSE process_descr_cur;
9177:
9178: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9179: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9180: g_warning_message := fnd_message.get;
9181:
9182: OPEN asg_number_cur (l_termination_date2);
9183: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9180: g_warning_message := fnd_message.get;

9176: CLOSE process_descr_cur;
9177:
9178: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9179: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9180: g_warning_message := fnd_message.get;
9181:
9182: OPEN asg_number_cur (l_termination_date2);
9183: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9184: CLOSE asg_number_cur;

Line 9246: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9242: OPEN process_descr_cur;
9243: FETCH process_descr_cur INTO l_process_description;
9244: CLOSE process_descr_cur;
9245:
9246: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9247: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9248: g_warning_message := fnd_message.get;
9249:
9250: OPEN asg_number_cur (l_termination_date3);

Line 9247: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9243: FETCH process_descr_cur INTO l_process_description;
9244: CLOSE process_descr_cur;
9245:
9246: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9247: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9248: g_warning_message := fnd_message.get;
9249:
9250: OPEN asg_number_cur (l_termination_date3);
9251: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9248: g_warning_message := fnd_message.get;

9244: CLOSE process_descr_cur;
9245:
9246: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9247: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9248: g_warning_message := fnd_message.get;
9249:
9250: OPEN asg_number_cur (l_termination_date3);
9251: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9252: CLOSE asg_number_cur;

Line 9314: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9310: OPEN process_descr_cur;
9311: FETCH process_descr_cur INTO l_process_description;
9312: CLOSE process_descr_cur;
9313:
9314: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9315: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9316: g_warning_message := fnd_message.get;
9317:
9318: OPEN asg_number_cur (l_termination_date4);

Line 9315: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9311: FETCH process_descr_cur INTO l_process_description;
9312: CLOSE process_descr_cur;
9313:
9314: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9315: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9316: g_warning_message := fnd_message.get;
9317:
9318: OPEN asg_number_cur (l_termination_date4);
9319: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9316: g_warning_message := fnd_message.get;

9312: CLOSE process_descr_cur;
9313:
9314: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9315: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9316: g_warning_message := fnd_message.get;
9317:
9318: OPEN asg_number_cur (l_termination_date4);
9319: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9320: CLOSE asg_number_cur;

Line 9382: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');

9378: OPEN process_descr_cur;
9379: FETCH process_descr_cur INTO l_process_description;
9380: CLOSE process_descr_cur;
9381:
9382: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9383: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9384: g_warning_message := fnd_message.get;
9385:
9386: OPEN asg_number_cur (l_termination_date5);

Line 9383: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);

9379: FETCH process_descr_cur INTO l_process_description;
9380: CLOSE process_descr_cur;
9381:
9382: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9383: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9384: g_warning_message := fnd_message.get;
9385:
9386: OPEN asg_number_cur (l_termination_date5);
9387: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9384: g_warning_message := fnd_message.get;

9380: CLOSE process_descr_cur;
9381:
9382: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9383: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9384: g_warning_message := fnd_message.get;
9385:
9386: OPEN asg_number_cur (l_termination_date5);
9387: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9388: CLOSE asg_number_cur;