1009: close c_task_number;
1010: open c_task_status(g_status);
1011: fetch c_task_status into l_task_name;
1012: close c_task_status;
1013: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1010: open c_task_status(g_status);
1011: fetch c_task_status into l_task_name;
1012: close c_task_status;
1013: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1011: fetch c_task_status into l_task_name;
1012: close c_task_status;
1013: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1019: END IF;
1012: close c_task_status;
1013: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1019: END IF;
1020: END IF;
1400: close c_task_number;
1401: open c_task_status(g_status);
1402: fetch c_task_status into l_task_name;
1403: close c_task_status;
1404: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1401: open c_task_status(g_status);
1402: fetch c_task_status into l_task_name;
1403: close c_task_status;
1404: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1409: raise fnd_api.g_exc_error;
1402: fetch c_task_status into l_task_name;
1403: close c_task_status;
1404: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1409: raise fnd_api.g_exc_error;
1410: END IF;
1403: close c_task_status;
1404: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1409: raise fnd_api.g_exc_error;
1410: END IF;
1411: END IF;
1863: close c_task_number;
1864: open c_task_status(g_status);
1865: fetch c_task_status into l_task_name;
1866: close c_task_status;
1867: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1864: open c_task_status(g_status);
1865: fetch c_task_status into l_task_name;
1866: close c_task_status;
1867: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1872: raise fnd_api.g_exc_error;
1865: fetch c_task_status into l_task_name;
1866: close c_task_status;
1867: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1872: raise fnd_api.g_exc_error;
1873: END IF;
1866: close c_task_status;
1867: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1872: raise fnd_api.g_exc_error;
1873: END IF;
1874: END IF;