APPS.PSP_ENC_CREATE_LINES dependencies on FND_MESSAGE

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

680: FETCH c_cnt_default_org INTO l_count;
681: CLOSE c_cnt_default_org;
682:
683: IF l_count = 0 THEN
684: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');
685: fnd_msg_pub.add;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END IF;
688:

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

689: OPEN time_pct_def_cur;
690: FETCH time_pct_def_cur INTO p_enc_org_end_date, l_enc_end_date_id, l_prev_enc_end_date;
691: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
692: p_enc_org_end_date := NULL;
693: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
694: fnd_msg_pub.add;
695: g_error_message := fnd_message.get;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;

Line 695: g_error_message := fnd_message.get;

691: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
692: p_enc_org_end_date := NULL;
693: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
694: fnd_msg_pub.add;
695: g_error_message := fnd_message.get;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698: CLOSE time_pct_def_cur;
699:

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

1154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
1155: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1156:
1157: IF (l_bus_working_days = 0) THEN
1158: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
1159: fnd_message.set_token('START_DATE', l_period_start_date);
1160: fnd_message.set_token('END_DATE', l_period_end_date);
1161: g_error_message := fnd_message.get;
1162: RAISE DIVIDE_BY_ZERO;

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

1155: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1156:
1157: IF (l_bus_working_days = 0) THEN
1158: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
1159: fnd_message.set_token('START_DATE', l_period_start_date);
1160: fnd_message.set_token('END_DATE', l_period_end_date);
1161: g_error_message := fnd_message.get;
1162: RAISE DIVIDE_BY_ZERO;
1163: END IF;

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

1156:
1157: IF (l_bus_working_days = 0) THEN
1158: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
1159: fnd_message.set_token('START_DATE', l_period_start_date);
1160: fnd_message.set_token('END_DATE', l_period_end_date);
1161: g_error_message := fnd_message.get;
1162: RAISE DIVIDE_BY_ZERO;
1163: END IF;
1164:

Line 1161: g_error_message := fnd_message.get;

1157: IF (l_bus_working_days = 0) THEN
1158: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
1159: fnd_message.set_token('START_DATE', l_period_start_date);
1160: fnd_message.set_token('END_DATE', l_period_end_date);
1161: g_error_message := fnd_message.get;
1162: RAISE DIVIDE_BY_ZERO;
1163: END IF;
1164:
1165: l_enc_amount := psp_st_ext.get_enc_amount (p_assignment_id => p_assignment_id,

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

1888: l_task_id,
1889: l_effective_date,
1890: l_return_status);
1891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1892: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1893: g_error_message := fnd_message.get;
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896:

Line 1893: g_error_message := fnd_message.get;

1889: l_effective_date,
1890: l_return_status);
1891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1892: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1893: g_error_message := fnd_message.get;
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896:
1897: -- R12 moac uptake. Set the MOAC Context to Single

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

1963: FETCH exp_org_name_cur INTO l_exp_org_name;
1964: CLOSE exp_org_name_cur;
1965:
1966: IF (l_patc_status IS NOT NULL) THEN
1967: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);

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

1964: CLOSE exp_org_name_cur;
1965:
1966: IF (l_patc_status IS NOT NULL) THEN
1967: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);

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

1965:
1966: IF (l_patc_status IS NOT NULL) THEN
1967: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

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

1966: IF (l_patc_status IS NOT NULL) THEN
1967: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

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

1967: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);

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

1968: fnd_message.set_token('PJ', l_project_number);
1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE

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

1969: fnd_message.set_token('TK', l_task_number);
1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

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

1970: fnd_message.set_token('AW', l_award_number);
1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);

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

1971: fnd_message.set_token('EO', l_exp_org_name);
1972: fnd_message.set_token('ET', l_expenditure_type);
1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);

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

1973: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);

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

1974: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);

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

1975: fnd_message.set_token('ERROR_STATUS', l_patc_status);
1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

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

1976: ELSE
1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

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

1977: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

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

1978: fnd_message.set_token('PJ', l_project_number);
1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;

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

1979: fnd_message.set_token('TK', l_task_number);
1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;
1987: g_error_message := fnd_message.get;

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

1980: fnd_message.set_token('AW', l_award_number);
1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;
1987: g_error_message := fnd_message.get;
1988: fnd_file.put_line(fnd_file.log, g_error_message);

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

1981: fnd_message.set_token('EO', l_exp_org_name);
1982: fnd_message.set_token('ET', l_expenditure_type);
1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;
1987: g_error_message := fnd_message.get;
1988: fnd_file.put_line(fnd_file.log, g_error_message);
1989: RAISE SUSPENSE_AC_INVALID;

Line 1987: g_error_message := fnd_message.get;

1983: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;
1987: g_error_message := fnd_message.get;
1988: fnd_file.put_line(fnd_file.log, g_error_message);
1989: RAISE SUSPENSE_AC_INVALID;
1990: END IF;
1991:

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

2090: l_task_id,
2091: l_effective_date,
2092: l_return_status);
2093: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2094: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
2095: g_error_message := fnd_message.get;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:

Line 2095: g_error_message := fnd_message.get;

2091: l_effective_date,
2092: l_return_status);
2093: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2094: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
2095: g_error_message := fnd_message.get;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:
2099: -- R12 moac uptake. Set the MOAC Context to Single

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

2159: FETCH exp_org_name_cur INTO l_exp_org_name;
2160: CLOSE exp_org_name_cur;
2161:
2162: IF (l_patc_status IS NOT NULL) THEN
2163: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);

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

2160: CLOSE exp_org_name_cur;
2161:
2162: IF (l_patc_status IS NOT NULL) THEN
2163: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);

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

2161:
2162: IF (l_patc_status IS NOT NULL) THEN
2163: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

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

2162: IF (l_patc_status IS NOT NULL) THEN
2163: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

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

2163: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);

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

2164: fnd_message.set_token('PJ', l_project_number);
2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE

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

2165: fnd_message.set_token('TK', l_task_number);
2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

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

2166: fnd_message.set_token('AW', l_award_number);
2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);

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

2167: fnd_message.set_token('EO', l_exp_org_name);
2168: fnd_message.set_token('ET', l_expenditure_type);
2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);

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

2169: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);

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

2170: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);

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

2171: fnd_message.set_token('ERROR_STATUS', l_patc_status);
2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);

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

2172: ELSE
2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);

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

2173: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);

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

2174: fnd_message.set_token('PJ', l_project_number);
2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;

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

2175: fnd_message.set_token('TK', l_task_number);
2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;
2183: g_error_message := fnd_message.get;

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

2176: fnd_message.set_token('AW', l_award_number);
2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;
2183: g_error_message := fnd_message.get;
2184: fnd_file.put_line(fnd_file.log, g_error_message);

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

2177: fnd_message.set_token('EO', l_exp_org_name);
2178: fnd_message.set_token('ET', l_expenditure_type);
2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;
2183: g_error_message := fnd_message.get;
2184: fnd_file.put_line(fnd_file.log, g_error_message);
2185: RAISE SUSPENSE_AC_INVALID;

Line 2183: g_error_message := fnd_message.get;

2179: fnd_message.set_token('START_DATE', t_poeta_gl_hier_array(i).r_enc_start_date);
2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;
2183: g_error_message := fnd_message.get;
2184: fnd_file.put_line(fnd_file.log, g_error_message);
2185: RAISE SUSPENSE_AC_INVALID;
2186: END IF;
2187:

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

3169: OPEN org_name_cur;
3170: FETCH org_name_cur INTO l_organization_name;
3171: CLOSE org_name_cur;
3172:
3173: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
3174: fnd_message.set_token('ORG_NAME', l_organization_name);
3175: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
3176: g_error_message := fnd_message.get;
3177: RAISE no_global_acct_exists;

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

3170: FETCH org_name_cur INTO l_organization_name;
3171: CLOSE org_name_cur;
3172:
3173: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
3174: fnd_message.set_token('ORG_NAME', l_organization_name);
3175: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
3176: g_error_message := fnd_message.get;
3177: RAISE no_global_acct_exists;
3178: END IF;

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

3171: CLOSE org_name_cur;
3172:
3173: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
3174: fnd_message.set_token('ORG_NAME', l_organization_name);
3175: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
3176: g_error_message := fnd_message.get;
3177: RAISE no_global_acct_exists;
3178: END IF;
3179: END LOOP;

Line 3176: g_error_message := fnd_message.get;

3172:
3173: fnd_message.set_name('PSP', 'PSP_LD_SUSPENSE_AC_NOT_EXIST');
3174: fnd_message.set_token('ORG_NAME', l_organization_name);
3175: fnd_message.set_token('PAYROLL_DATE', l_asg_start_date);
3176: g_error_message := fnd_message.get;
3177: RAISE no_global_acct_exists;
3178: END IF;
3179: END LOOP;
3180:

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

3253: OPEN exp_org_name_cur;
3254: FETCH exp_org_name_cur INTO l_exp_org_name;
3255: CLOSE exp_org_name_cur;
3256:
3257: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);

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

3254: FETCH exp_org_name_cur INTO l_exp_org_name;
3255: CLOSE exp_org_name_cur;
3256:
3257: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);

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

3255: CLOSE exp_org_name_cur;
3256:
3257: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE

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

3256:
3257: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);

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

3257: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

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

3258: fnd_message.set_token('PJ', l_project_number);
3259: fnd_message.set_token('TK', l_task_number);
3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);

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

3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);

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

3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);
3270: fnd_message.set_token('ERROR_STATUS', l_autopop_error);

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

3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);
3270: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3271: g_error_message := fnd_message.get;
3272: RAISE SUSPENSE_AUTOPOP_FAILED;

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

3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);
3270: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3271: g_error_message := fnd_message.get;
3272: RAISE SUSPENSE_AUTOPOP_FAILED;
3273: ELSE

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

3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);
3270: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3271: g_error_message := fnd_message.get;
3272: RAISE SUSPENSE_AUTOPOP_FAILED;
3273: ELSE
3274: IF (l_acct_type = 'E') THEN

Line 3271: g_error_message := fnd_message.get;

3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);
3269: fnd_message.set_token('END_DATE', l_asg_end_date);
3270: fnd_message.set_token('ERROR_STATUS', l_autopop_error);
3271: g_error_message := fnd_message.get;
3272: RAISE SUSPENSE_AUTOPOP_FAILED;
3273: ELSE
3274: IF (l_acct_type = 'E') THEN
3275: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,

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

3671: IF (g_error_message IS NULL) THEN
3672: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3673: END IF;
3674: p_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3676: FND_MSG_PUB.ADD;
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END create_controls;
3679:

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

3841: END IF; --Main IF :2317856
3842:
3843: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3844: IF l_bus_days_in_period = 0 THEN
3845: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3846: fnd_message.set_token('START_DATE', p_asg_start_date);
3847: fnd_message.set_token('END_DATE', p_asg_end_date);
3848: g_error_message := fnd_message.get;
3849: RAISE DIVIDE_BY_ZERO;

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

3842:
3843: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3844: IF l_bus_days_in_period = 0 THEN
3845: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3846: fnd_message.set_token('START_DATE', p_asg_start_date);
3847: fnd_message.set_token('END_DATE', p_asg_end_date);
3848: g_error_message := fnd_message.get;
3849: RAISE DIVIDE_BY_ZERO;
3850: END IF;

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

3843: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3844: IF l_bus_days_in_period = 0 THEN
3845: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3846: fnd_message.set_token('START_DATE', p_asg_start_date);
3847: fnd_message.set_token('END_DATE', p_asg_end_date);
3848: g_error_message := fnd_message.get;
3849: RAISE DIVIDE_BY_ZERO;
3850: END IF;
3851:

Line 3848: g_error_message := fnd_message.get;

3844: IF l_bus_days_in_period = 0 THEN
3845: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3846: fnd_message.set_token('START_DATE', p_asg_start_date);
3847: fnd_message.set_token('END_DATE', p_asg_end_date);
3848: g_error_message := fnd_message.get;
3849: RAISE DIVIDE_BY_ZERO;
3850: END IF;
3851:
3852: For j in 1 .. p_poeta_gl_hier_array.COUNT

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

6146: IF (l_end_date >= l_asg_start_date) AND (l_start_date <= l_asg_end_date) THEN
6147: IF (l_process_flag = 'BAL') THEN
6148: l_reason_code := '1';
6149: l_schedule_percent := r_enc_period.r_schedule_percent(I);
6150: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
6151: fnd_message.set_token('START_DATE', l_asg_start_date);
6152: fnd_message.set_token('END_DATE', l_asg_end_date);
6153: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
6154: g_warning_message := fnd_message.get;

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

6147: IF (l_process_flag = 'BAL') THEN
6148: l_reason_code := '1';
6149: l_schedule_percent := r_enc_period.r_schedule_percent(I);
6150: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
6151: fnd_message.set_token('START_DATE', l_asg_start_date);
6152: fnd_message.set_token('END_DATE', l_asg_end_date);
6153: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
6154: g_warning_message := fnd_message.get;
6155: add_cel_warnings(p_start_date => l_asg_start_date,

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

6148: l_reason_code := '1';
6149: l_schedule_percent := r_enc_period.r_schedule_percent(I);
6150: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
6151: fnd_message.set_token('START_DATE', l_asg_start_date);
6152: fnd_message.set_token('END_DATE', l_asg_end_date);
6153: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
6154: g_warning_message := fnd_message.get;
6155: add_cel_warnings(p_start_date => l_asg_start_date,
6156: p_hierarchy_code => 'DA',

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

6149: l_schedule_percent := r_enc_period.r_schedule_percent(I);
6150: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
6151: fnd_message.set_token('START_DATE', l_asg_start_date);
6152: fnd_message.set_token('END_DATE', l_asg_end_date);
6153: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
6154: g_warning_message := fnd_message.get;
6155: add_cel_warnings(p_start_date => l_asg_start_date,
6156: p_hierarchy_code => 'DA',
6157: p_end_date => l_asg_end_date,

Line 6154: g_warning_message := fnd_message.get;

6150: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_1');
6151: fnd_message.set_token('START_DATE', l_asg_start_date);
6152: fnd_message.set_token('END_DATE', l_asg_end_date);
6153: fnd_message.set_token('PERCENT', r_enc_period.r_schedule_percent(I));
6154: g_warning_message := fnd_message.get;
6155: add_cel_warnings(p_start_date => l_asg_start_date,
6156: p_hierarchy_code => 'DA',
6157: p_end_date => l_asg_end_date,
6158: p_warning_code => 'BAL',

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

6158: p_warning_code => 'BAL',
6159: p_percent => r_enc_period.r_schedule_percent(I));
6160: ELSE
6161: l_reason_code := '3';
6162: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
6163: fnd_message.set_token('START_DATE', l_asg_start_date);
6164: fnd_message.set_token('END_DATE', l_asg_end_date);
6165: g_warning_message := fnd_message.get;
6166: add_cel_warnings(p_start_date => l_asg_start_date,

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

6159: p_percent => r_enc_period.r_schedule_percent(I));
6160: ELSE
6161: l_reason_code := '3';
6162: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
6163: fnd_message.set_token('START_DATE', l_asg_start_date);
6164: fnd_message.set_token('END_DATE', l_asg_end_date);
6165: g_warning_message := fnd_message.get;
6166: add_cel_warnings(p_start_date => l_asg_start_date,
6167: p_hierarchy_code => 'DA',

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

6160: ELSE
6161: l_reason_code := '3';
6162: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
6163: fnd_message.set_token('START_DATE', l_asg_start_date);
6164: fnd_message.set_token('END_DATE', l_asg_end_date);
6165: g_warning_message := fnd_message.get;
6166: add_cel_warnings(p_start_date => l_asg_start_date,
6167: p_hierarchy_code => 'DA',
6168: p_end_date => l_asg_end_date,

Line 6165: g_warning_message := fnd_message.get;

6161: l_reason_code := '3';
6162: fnd_message.set_name('PSP', 'PSP_DEFAULT_REASON_3');
6163: fnd_message.set_token('START_DATE', l_asg_start_date);
6164: fnd_message.set_token('END_DATE', l_asg_end_date);
6165: g_warning_message := fnd_message.get;
6166: add_cel_warnings(p_start_date => l_asg_start_date,
6167: p_hierarchy_code => 'DA',
6168: p_end_date => l_asg_end_date,
6169: p_warning_code => 'NO_CI');

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

6715: FROM psp_enc_changed_assignments
6716: WHERE payroll_action_id = pactid;
6717:
6718: IF (SQL%ROWCOUNT = 0) THEN
6719: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6720: g_warning_message := fnd_message.get;
6721: fnd_file.put_line(fnd_file.log, g_warning_message);
6722: psp_general.add_report_error
6723: (p_request_id => l_request_id,

Line 6720: g_warning_message := fnd_message.get;

6716: WHERE payroll_action_id = pactid;
6717:
6718: IF (SQL%ROWCOUNT = 0) THEN
6719: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6720: g_warning_message := fnd_message.get;
6721: fnd_file.put_line(fnd_file.log, g_warning_message);
6722: psp_general.add_report_error
6723: (p_request_id => l_request_id,
6724: p_message_level => 'N',

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

7110: FETCH element_name_cur INTO l_element_name;
7111: CLOSE element_name_cur;
7112:
7113: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
7114: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
7115: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;

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

7111: CLOSE element_name_cur;
7112:
7113: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
7114: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
7115: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN

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

7112:
7113: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
7114: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
7115: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');

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

7113: IF (cel_warnings.warning_code(recno) = 'BAL') THEN
7114: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
7115: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 7118: g_warning_message := fnd_message.get;

7114: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_BALNOT100');
7115: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

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

7116: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;

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

7117: fnd_message.set_token('PERCENT', cel_warnings.percent(recno));
7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND

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

7118: g_warning_message := fnd_message.get;
7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN

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

7119: ELSIF (cel_warnings.warning_code(recno) = 'GL') THEN
7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));

Line 7124: g_warning_message := fnd_message.get;

7120: fnd_message.set_name('PSP', 'PSP_CANNOT_ENC_HOURS_TO_GL');
7121: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7122: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

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

7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

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

7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7133: g_warning_message := fnd_message.get;

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

7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7133: g_warning_message := fnd_message.get;
7134: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN

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

7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7133: g_warning_message := fnd_message.get;
7134: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
7135: OPEN project_number_cur(cel_warnings.project_id(recno));

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

7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7133: g_warning_message := fnd_message.get;
7134: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
7135: OPEN project_number_cur(cel_warnings.project_id(recno));
7136: FETCH project_number_cur INTO l_project_number;

Line 7133: g_warning_message := fnd_message.get;

7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);
7132: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7133: g_warning_message := fnd_message.get;
7134: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND (cel_warnings.gl_ccid(recno) IS NULL) THEN
7135: OPEN project_number_cur(cel_warnings.project_id(recno));
7136: FETCH project_number_cur INTO l_project_number;
7137: CLOSE project_number_cur;

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

7147: OPEN exp_org_name_cur(cel_warnings.exp_org_id(recno));
7148: FETCH exp_org_name_cur INTO l_exp_org_name;
7149: CLOSE exp_org_name_cur;
7150:
7151: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);

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

7148: FETCH exp_org_name_cur INTO l_exp_org_name;
7149: CLOSE exp_org_name_cur;
7150:
7151: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);

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

7149: CLOSE exp_org_name_cur;
7150:
7151: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);

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

7150:
7151: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

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

7151: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));

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

7152: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;

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

7153: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN

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

7154: fnd_message.set_token('PJ', l_project_number);
7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');

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

7155: fnd_message.set_token('TK', l_task_number);
7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

Line 7160: g_warning_message := fnd_message.get;

7156: fnd_message.set_token('AW', l_award_number);
7157: fnd_message.set_token('EO', l_exp_org_name);
7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7164: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

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

7158: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7164: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7165: g_warning_message := fnd_message.get;
7166: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN

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

7159: fnd_message.set_token('AUTOPOP_STATUS', cel_warnings.error_status(recno));
7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7164: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7165: g_warning_message := fnd_message.get;
7166: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
7167: OPEN project_number_cur(cel_warnings.project_id(recno));

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

7160: g_warning_message := fnd_message.get;
7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7164: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7165: g_warning_message := fnd_message.get;
7166: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
7167: OPEN project_number_cur(cel_warnings.project_id(recno));
7168: FETCH project_number_cur INTO l_project_number;

Line 7165: g_warning_message := fnd_message.get;

7161: ELSIF (cel_warnings.warning_code(recno) = 'NO_CI') THEN
7162: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_NOCI');
7163: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7164: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7165: g_warning_message := fnd_message.get;
7166: ELSIF (cel_warnings.warning_code(recno) = 'INVALID_CI') THEN
7167: OPEN project_number_cur(cel_warnings.project_id(recno));
7168: FETCH project_number_cur INTO l_project_number;
7169: CLOSE project_number_cur;

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

7180: FETCH exp_org_name_cur INTO l_exp_org_name;
7181: CLOSE exp_org_name_cur;
7182:
7183: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
7184: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);

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

7181: CLOSE exp_org_name_cur;
7182:
7183: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
7184: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

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

7182:
7183: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
7184: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

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

7183: IF (cel_warnings.error_status(recno) IS NOT NULL) THEN
7184: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

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

7184: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));

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

7185: fnd_message.set_token('PJ', l_project_number);
7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE

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

7186: fnd_message.set_token('TK', l_task_number);
7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');

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

7187: fnd_message.set_token('AW', l_award_number);
7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);

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

7188: fnd_message.set_token('EO', l_exp_org_name);
7189: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);

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

7190: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);

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

7191: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));

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

7192: fnd_message.set_token('ERROR_STATUS', cel_warnings.error_status(recno));
7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));

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

7193: ELSE
7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));

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

7194: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_END_PATEO');
7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));

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

7195: fnd_message.set_token('PJ', l_project_number);
7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
7203: END IF;

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

7196: fnd_message.set_token('TK', l_task_number);
7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
7203: END IF;
7204: g_warning_message := fnd_message.get;

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

7197: fnd_message.set_token('AW', l_award_number);
7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
7203: END IF;
7204: g_warning_message := fnd_message.get;
7205: END IF;

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

7198: fnd_message.set_token('EO', l_exp_org_name);
7199: fnd_message.set_token('ET', cel_warnings.exp_type(recno));
7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
7203: END IF;
7204: g_warning_message := fnd_message.get;
7205: END IF;
7206:

Line 7204: g_warning_message := fnd_message.get;

7200: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7201: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7202: fnd_message.set_token('EFFECTIVE_DATE', cel_warnings.effective_date(recno));
7203: END IF;
7204: g_warning_message := fnd_message.get;
7205: END IF;
7206:
7207: psp_general.add_report_error
7208: (p_request_id => g_request_id,

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

7808: TO_CHAR(l_set_of_books_id));
7809:
7810: IF l_request_id = 0 THEN
7811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7812: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7813: fnd_msg_pub.add;
7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7815: END IF;
7816: COMMIT;

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

7951: TO_CHAR(l_set_of_books_id));
7952:
7953: IF l_request_id = 0 THEN
7954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7955: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7956: fnd_msg_pub.add;
7957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7958: END IF;
7959: COMMIT;

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

7986: TO_CHAR(l_set_of_books_id));
7987:
7988: IF l_request_id = 0 THEN
7989: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7990: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7991: fnd_msg_pub.add;
7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7993: END IF;
7994:

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

8004: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
8005:
8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
8009: fnd_msg_pub.add;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;
8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');

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

9642: CLOSE process_descr_cur;
9643:
9644: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_process_description: '||l_process_description);
9645:
9646: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9647: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9648: g_warning_message := fnd_message.get;
9649:
9650: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_warning_message: '||g_warning_message);

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

9643:
9644: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_process_description: '||l_process_description);
9645:
9646: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9647: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9648: g_warning_message := fnd_message.get;
9649:
9650: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_warning_message: '||g_warning_message);
9651:

Line 9648: g_warning_message := fnd_message.get;

9644: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_process_description: '||l_process_description);
9645:
9646: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9647: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9648: g_warning_message := fnd_message.get;
9649:
9650: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_warning_message: '||g_warning_message);
9651:
9652: OPEN asg_number_cur (l_enc_begin_date);

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

9731: OPEN process_descr_cur;
9732: FETCH process_descr_cur INTO l_process_description;
9733: CLOSE process_descr_cur;
9734:
9735: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9736: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9737: g_warning_message := fnd_message.get;
9738:
9739: OPEN asg_number_cur (l_termination_date1);

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

9732: FETCH process_descr_cur INTO l_process_description;
9733: CLOSE process_descr_cur;
9734:
9735: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9736: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9737: g_warning_message := fnd_message.get;
9738:
9739: OPEN asg_number_cur (l_termination_date1);
9740: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9737: g_warning_message := fnd_message.get;

9733: CLOSE process_descr_cur;
9734:
9735: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9736: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9737: g_warning_message := fnd_message.get;
9738:
9739: OPEN asg_number_cur (l_termination_date1);
9740: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9741: CLOSE asg_number_cur;

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

9799: OPEN process_descr_cur;
9800: FETCH process_descr_cur INTO l_process_description;
9801: CLOSE process_descr_cur;
9802:
9803: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9804: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9805: g_warning_message := fnd_message.get;
9806:
9807: OPEN asg_number_cur (l_termination_date2);

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

9800: FETCH process_descr_cur INTO l_process_description;
9801: CLOSE process_descr_cur;
9802:
9803: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9804: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9805: g_warning_message := fnd_message.get;
9806:
9807: OPEN asg_number_cur (l_termination_date2);
9808: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9805: g_warning_message := fnd_message.get;

9801: CLOSE process_descr_cur;
9802:
9803: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9804: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9805: g_warning_message := fnd_message.get;
9806:
9807: OPEN asg_number_cur (l_termination_date2);
9808: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9809: CLOSE asg_number_cur;

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

9868: OPEN process_descr_cur;
9869: FETCH process_descr_cur INTO l_process_description;
9870: CLOSE process_descr_cur;
9871:
9872: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9873: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9874: g_warning_message := fnd_message.get;
9875:
9876: OPEN asg_number_cur (l_termination_date3);

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

9869: FETCH process_descr_cur INTO l_process_description;
9870: CLOSE process_descr_cur;
9871:
9872: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9873: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9874: g_warning_message := fnd_message.get;
9875:
9876: OPEN asg_number_cur (l_termination_date3);
9877: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9874: g_warning_message := fnd_message.get;

9870: CLOSE process_descr_cur;
9871:
9872: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9873: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9874: g_warning_message := fnd_message.get;
9875:
9876: OPEN asg_number_cur (l_termination_date3);
9877: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9878: CLOSE asg_number_cur;

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

9937: OPEN process_descr_cur;
9938: FETCH process_descr_cur INTO l_process_description;
9939: CLOSE process_descr_cur;
9940:
9941: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9942: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9943: g_warning_message := fnd_message.get;
9944:
9945: OPEN asg_number_cur (l_termination_date4);

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

9938: FETCH process_descr_cur INTO l_process_description;
9939: CLOSE process_descr_cur;
9940:
9941: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9942: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9943: g_warning_message := fnd_message.get;
9944:
9945: OPEN asg_number_cur (l_termination_date4);
9946: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 9943: g_warning_message := fnd_message.get;

9939: CLOSE process_descr_cur;
9940:
9941: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9942: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9943: g_warning_message := fnd_message.get;
9944:
9945: OPEN asg_number_cur (l_termination_date4);
9946: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9947: CLOSE asg_number_cur;

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

10006: OPEN process_descr_cur;
10007: FETCH process_descr_cur INTO l_process_description;
10008: CLOSE process_descr_cur;
10009:
10010: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
10011: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
10012: g_warning_message := fnd_message.get;
10013:
10014: OPEN asg_number_cur (l_termination_date5);

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

10007: FETCH process_descr_cur INTO l_process_description;
10008: CLOSE process_descr_cur;
10009:
10010: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
10011: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
10012: g_warning_message := fnd_message.get;
10013:
10014: OPEN asg_number_cur (l_termination_date5);
10015: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;

Line 10012: g_warning_message := fnd_message.get;

10008: CLOSE process_descr_cur;
10009:
10010: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
10011: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
10012: g_warning_message := fnd_message.get;
10013:
10014: OPEN asg_number_cur (l_termination_date5);
10015: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
10016: CLOSE asg_number_cur;