eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASKS_PUB dependencies on FND_MESSAGE

Line 315: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');

311: l_trans_valid := validate_state_transition ('TASK_STATUS', p_old_status_id, p_new_status_id);
312: IF l_trans_valid = fnd_api.g_false THEN
313: l_valid_statuses := get_valid_statuses ('TASK_STATUS', p_old_status_id);
314: IF l_valid_statuses IS NULL THEN
315: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
316: ELSE
317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;

Line 317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');

313: l_valid_statuses := get_valid_statuses ('TASK_STATUS', p_old_status_id);
314: IF l_valid_statuses IS NULL THEN
315: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
316: ELSE
317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;
320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
321: fnd_msg_pub.ADD;

Line 318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);

314: IF l_valid_statuses IS NULL THEN
315: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
316: ELSE
317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;
320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
321: fnd_msg_pub.ADD;
322: RAISE fnd_api.g_exc_error;

Line 320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));

316: ELSE
317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;
320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
321: fnd_msg_pub.ADD;
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: END validate_status_change;

Line 382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');

378: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
379: IF validate_state_transition ('TASK_STATUS', l_old_status_id, l_close_status_id) = fnd_api.g_false THEN
380: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_old_status_id);
381: IF l_valid_statuses IS NULL THEN
382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
383: ELSE
384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;

Line 384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');

380: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_old_status_id);
381: IF l_valid_statuses IS NULL THEN
382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
383: ELSE
384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;
387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
388: fnd_msg_pub.ADD;

Line 385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);

381: IF l_valid_statuses IS NULL THEN
382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
383: ELSE
384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;
387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
388: fnd_msg_pub.ADD;
389: RAISE fnd_api.g_exc_error;

Line 387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));

383: ELSE
384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;
387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
388: fnd_msg_pub.ADD;
389: RAISE fnd_api.g_exc_error;
390: END IF;
391:

Line 401: fnd_message.set_name('CSF', 'CSF_CLOSED_TASK');

397: IF v_task_assignment.closed_flag = 'N'
398: AND v_task_assignment.cancelled_flag = 'N'
399: AND v_task_assignment.completed_flag = 'N'
400: AND v_task_assignment.rejected_flag = 'N' THEN
401: fnd_message.set_name('CSF', 'CSF_CLOSED_TASK');
402: fnd_msg_pub.ADD;
403: RAISE fnd_api.g_exc_error;
404: END IF;
405:

Line 410: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');

406: -- Check whether the Debrief is closed if Task Assignment is not open
407: -- and only when the profile "CSFW: Update Schedulable Task" is set to Yes
408: IF l_update_schedulable_task = 'YES' THEN
409: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
410: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
411: fnd_msg_pub.ADD;
412: RAISE fnd_api.g_exc_error;
413: END IF;
414: END IF;

Line 506: fnd_message.set_name('CSF', l_message_name);

502: , x_reason_code => l_message_name
503: );
504:
505: IF NOT l_schedulable THEN
506: fnd_message.set_name('CSF', l_message_name);
507: fnd_msg_pub.ADD;
508: RAISE fnd_api.g_exc_error;
509: END IF;
510:

Line 980: fnd_message.set_name ('CSF', l_reason_code);

976: );
977:
978: -- Task is not schedulable.
979: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN
980: fnd_message.set_name ('CSF', l_reason_code);
981: fnd_msg_pub.ADD;
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:

Line 1239: fnd_message.set_name ('CSF', 'CSF_CLOSED_TASK');

1235: AND v_task_assignment.completed_flag = 'N'
1236: AND v_task_assignment.cancelled_flag = 'N'
1237: AND v_task_assignment.rejected_flag = 'N' )
1238: THEN
1239: fnd_message.set_name ('CSF', 'CSF_CLOSED_TASK');
1240: fnd_msg_pub.ADD;
1241: RAISE fnd_api.g_exc_error;
1242: END IF;
1243:

Line 1246: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');

1242: END IF;
1243:
1244: -- Task Assignment is not open. Check for Debrief
1245: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
1246: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
1247: fnd_msg_pub.ADD;
1248: RAISE fnd_api.g_exc_error;
1249: END IF;
1250:

Line 1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');

1648:
1649: IF l_task_info.task_split_flag IS NOT NULL
1650: OR l_planned_effort_minutes > fnd_profile.value('CSR_DEFAULT_SHIFT_DURATION')
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1653: fnd_message.set_token('TASK_NUMBER',l_task_number);
1654: fnd_msg_pub.add;
1655: RAISE fnd_api.g_exc_error;
1656: END IF;

Line 1653: fnd_message.set_token('TASK_NUMBER',l_task_number);

1649: IF l_task_info.task_split_flag IS NOT NULL
1650: OR l_planned_effort_minutes > fnd_profile.value('CSR_DEFAULT_SHIFT_DURATION')
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1653: fnd_message.set_token('TASK_NUMBER',l_task_number);
1654: fnd_msg_pub.add;
1655: RAISE fnd_api.g_exc_error;
1656: END IF;
1657:

Line 1865: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');

1861: COMMIT WORK;
1862: END IF;
1863:
1864: IF l_overlap_tasks IS NOT NULL THEN
1865: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');
1866: fnd_message.set_token('TASKID', l_task_number);
1867: fnd_message.set_token('TASKS',l_overlap_tasks);
1868: fnd_msg_pub.add;
1869: END IF;

Line 1866: fnd_message.set_token('TASKID', l_task_number);

1862: END IF;
1863:
1864: IF l_overlap_tasks IS NOT NULL THEN
1865: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');
1866: fnd_message.set_token('TASKID', l_task_number);
1867: fnd_message.set_token('TASKS',l_overlap_tasks);
1868: fnd_msg_pub.add;
1869: END IF;
1870:

Line 1867: fnd_message.set_token('TASKS',l_overlap_tasks);

1863:
1864: IF l_overlap_tasks IS NOT NULL THEN
1865: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');
1866: fnd_message.set_token('TASKID', l_task_number);
1867: fnd_message.set_token('TASKS',l_overlap_tasks);
1868: fnd_msg_pub.add;
1869: END IF;
1870:
1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1987: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');

1983: OPEN c_task_details;
1984: FETCH c_task_details INTO l_task_details;
1985: IF c_task_details%NOTFOUND THEN
1986: CLOSE c_task_details;
1987: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1988: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
1989: fnd_msg_pub.ADD;
1990: RAISE fnd_api.g_exc_error;
1991: END IF;

Line 1988: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));

1984: FETCH c_task_details INTO l_task_details;
1985: IF c_task_details%NOTFOUND THEN
1986: CLOSE c_task_details;
1987: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1988: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
1989: fnd_msg_pub.ADD;
1990: RAISE fnd_api.g_exc_error;
1991: END IF;
1992: CLOSE c_task_details;

Line 1998: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');

1994: OPEN c_task_details_1;
1995: FETCH c_task_details_1 INTO l_task_details;
1996: IF c_task_details_1%NOTFOUND THEN
1997: CLOSE c_task_details_1;
1998: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1999: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2000: fnd_msg_pub.ADD;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;

Line 1999: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));

1995: FETCH c_task_details_1 INTO l_task_details;
1996: IF c_task_details_1%NOTFOUND THEN
1997: CLOSE c_task_details_1;
1998: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1999: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2000: fnd_msg_pub.ADD;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: CLOSE c_task_details_1;

Line 2008: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');

2004: END IF;
2005:
2006: -- Trip should not be in Blocked Status
2007: IF l_task_details.trip_status = csf_trips_pub.g_trip_unavailable THEN
2008: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');
2009: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2010: fnd_msg_pub.ADD;
2011: RAISE fnd_api.g_exc_error;
2012: END IF;

Line 2009: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);

2005:
2006: -- Trip should not be in Blocked Status
2007: IF l_task_details.trip_status = csf_trips_pub.g_trip_unavailable THEN
2008: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');
2009: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2010: fnd_msg_pub.ADD;
2011: RAISE fnd_api.g_exc_error;
2012: END IF;
2013:

Line 2019: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');

2015: l_trans_valid := validate_state_transition ('TASK_STATUS', l_task_details.assignment_status_id, l_new_status_id);
2016: IF l_trans_valid = fnd_api.g_false THEN
2017: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_task_details.assignment_status_id);
2018: IF l_valid_statuses IS NULL THEN
2019: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
2020: ELSE
2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;

Line 2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');

2017: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_task_details.assignment_status_id);
2018: IF l_valid_statuses IS NULL THEN
2019: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
2020: ELSE
2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;
2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2025: fnd_msg_pub.ADD;

Line 2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);

2018: IF l_valid_statuses IS NULL THEN
2019: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
2020: ELSE
2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;
2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_error;

Line 2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));

2020: ELSE
2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;
2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_error;
2027: END IF;
2028:

Line 2031: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');

2027: END IF;
2028:
2029: -- Check the Customer Confirmation Status - Should be either No or Received
2030: IF l_task_details.task_confirmation_status = 'R' THEN
2031: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');
2032: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2033: fnd_msg_pub.ADD;
2034: RAISE fnd_api.g_exc_error;
2035: END IF;

Line 2032: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);

2028:
2029: -- Check the Customer Confirmation Status - Should be either No or Received
2030: IF l_task_details.task_confirmation_status = 'R' THEN
2031: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');
2032: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2033: fnd_msg_pub.ADD;
2034: RAISE fnd_api.g_exc_error;
2035: END IF;
2036:

Line 2039: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');

2035: END IF;
2036:
2037: -- Check for Scheduled Dates
2038: IF l_task_details.scheduled_start_date IS NULL THEN
2039: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');
2040: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2041: fnd_msg_pub.ADD;
2042: RAISE fnd_api.g_exc_error;
2043: END IF;

Line 2040: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);

2036:
2037: -- Check for Scheduled Dates
2038: IF l_task_details.scheduled_start_date IS NULL THEN
2039: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');
2040: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2041: fnd_msg_pub.ADD;
2042: RAISE fnd_api.g_exc_error;
2043: END IF;
2044:

Line 2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');

2059:
2060: IF x_return_status = fnd_api.g_ret_sts_success THEN
2061: -- commented for the bug 6801965
2062: -- Committed Task Message is added to the message stack
2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);

2060: IF x_return_status = fnd_api.g_ret_sts_success THEN
2061: -- commented for the bug 6801965
2062: -- Committed Task Message is added to the message stack
2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;

Line 2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2179: x_return_status := fnd_api.g_ret_sts_success;
2180:
2181: -- Check whether the required parameters are passed.
2182: IF p_query_id IS NULL AND p_resource_id IS NULL AND p_task_id IS NULL AND p_trip_id IS NULL THEN
2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2186: fnd_msg_pub.ADD;
2187: RAISE fnd_api.g_exc_error;

Line 2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2180:
2181: -- Check whether the required parameters are passed.
2182: IF p_query_id IS NULL AND p_resource_id IS NULL AND p_task_id IS NULL AND p_trip_id IS NULL THEN
2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2186: fnd_msg_pub.ADD;
2187: RAISE fnd_api.g_exc_error;
2188: END IF;

Line 2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');

2181: -- Check whether the required parameters are passed.
2182: IF p_query_id IS NULL AND p_resource_id IS NULL AND p_task_id IS NULL AND p_trip_id IS NULL THEN
2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2186: fnd_msg_pub.ADD;
2187: RAISE fnd_api.g_exc_error;
2188: END IF;
2189:

Line 2288: fnd_message.set_name('CSF','CSF_NO_TASK_FOR_RESOURCE');

2284: FETCH c_task_list BULK COLLECT INTO l_task_id_tbl, l_task_split_flag_tbl LIMIT 100;
2285:
2286: -- Process each Task in the Task List
2287: IF l_task_id_tbl.COUNT = 0 THEN -- if there are no tasks in the trip #bug7146595
2288: fnd_message.set_name('CSF','CSF_NO_TASK_FOR_RESOURCE');
2289: fnd_msg_pub.ADD;
2290: END IF; -- end of code for the bug7146595
2291: FOR i IN 1..l_task_id_tbl.COUNT
2292: LOOP

Line 2301: fnd_message.set_name('CSF','CSF_AUTO_COMMIT_MULTI_RES');

2297: FETCH check_assignments into l_cnt;
2298: CLOSE check_assignments;
2299: IF l_cnt > 1
2300: THEN
2301: fnd_message.set_name('CSF','CSF_AUTO_COMMIT_MULTI_RES');
2302: fnd_message.set_token ('TASK', task_number(l_task_id_tbl(i)));
2303: fnd_msg_pub.ADD;
2304: l_all_passed := FALSE;
2305: --End of the code added for this bug 6866929

Line 2302: fnd_message.set_token ('TASK', task_number(l_task_id_tbl(i)));

2298: CLOSE check_assignments;
2299: IF l_cnt > 1
2300: THEN
2301: fnd_message.set_name('CSF','CSF_AUTO_COMMIT_MULTI_RES');
2302: fnd_message.set_token ('TASK', task_number(l_task_id_tbl(i)));
2303: fnd_msg_pub.ADD;
2304: l_all_passed := FALSE;
2305: --End of the code added for this bug 6866929
2306: ELSE

Line 2317: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');

2313: -- Check whether any of the Trip containing the Child Task is blocked.
2314: l_blocked_trip_found := FALSE;
2315: FOR j IN 1..l_trip_status_tbl.COUNT LOOP
2316: IF l_trip_status_tbl(j) = csf_trips_pub.g_trip_unavailable THEN
2317: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');
2318: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));
2319: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));
2320: fnd_msg_pub.ADD;
2321: l_blocked_trip_found := TRUE;

Line 2318: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));

2314: l_blocked_trip_found := FALSE;
2315: FOR j IN 1..l_trip_status_tbl.COUNT LOOP
2316: IF l_trip_status_tbl(j) = csf_trips_pub.g_trip_unavailable THEN
2317: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');
2318: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));
2319: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));
2320: fnd_msg_pub.ADD;
2321: l_blocked_trip_found := TRUE;
2322: l_all_passed := FALSE;

Line 2319: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));

2315: FOR j IN 1..l_trip_status_tbl.COUNT LOOP
2316: IF l_trip_status_tbl(j) = csf_trips_pub.g_trip_unavailable THEN
2317: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');
2318: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));
2319: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));
2320: fnd_msg_pub.ADD;
2321: l_blocked_trip_found := TRUE;
2322: l_all_passed := FALSE;
2323: EXIT;

Line 2370: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_NO_TASK');

2366:
2367:
2368:
2369: IF l_processed_count = 0 AND p_query_id IS NOT NULL THEN
2370: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_NO_TASK');
2371: fnd_msg_pub.ADD;
2372: x_return_status := fnd_api.g_ret_sts_error;
2373: END IF;
2374:

Line 2382: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');

2378: -- added code for the bug 6801965
2379: IF l_task_num_tbl.count > 0 THEN
2380: FOR i in 1..l_task_num_tbl.count
2381: LOOP
2382: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2383: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_task_num_tbl(i)));
2384: fnd_msg_pub.ADD;
2385: END LOOP;
2386: END IF;

Line 2383: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_task_num_tbl(i)));

2379: IF l_task_num_tbl.count > 0 THEN
2380: FOR i in 1..l_task_num_tbl.count
2381: LOOP
2382: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2383: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_task_num_tbl(i)));
2384: fnd_msg_pub.ADD;
2385: END LOOP;
2386: END IF;
2387: -- end of code for the bug 6801965