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.JTF_TASK_RESOURCES_PVT dependencies on FND_API

Line 49: x_return_status := fnd_api.g_ret_sts_success;

45: l_task_template_id jtf_task_templates_tl.task_template_id%TYPE;
46: l_task_name jtf_task_templates_tl.task_name%TYPE;
47: done BOOLEAN := FALSE;
48: BEGIN
49: x_return_status := fnd_api.g_ret_sts_success;
50:
51: --- Assume correct task id is supplied
52: IF p_task_template_id IS NOT NULL
53: THEN

Line 60: x_return_status := fnd_api.g_ret_sts_unexp_error;

56:
57:
58: IF c_task_id%NOTFOUND
59: THEN
60: x_return_status := fnd_api.g_ret_sts_unexp_error;
61: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
62: fnd_message.set_token('TASK_TEMPLATE_ID',P_TASK_TEMPLATE_ID);
63: fnd_msg_pub.add;
64:

Line 96: x_return_status := fnd_api.g_ret_sts_success;

92: l_task_type_id jtf_task_types_tl.task_type_id%TYPE;
93: l_task_name jtf_task_types_tl.name%TYPE;
94: done BOOLEAN := FALSE;
95: BEGIN
96: x_return_status := fnd_api.g_ret_sts_success;
97:
98: --- Assume correct task type id is supplied
99: IF p_task_type_id IS NOT NULL
100: THEN

Line 107: x_return_status := fnd_api.g_ret_sts_unexp_error;

103:
104:
105: IF c_task_type_id%NOTFOUND
106: THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
109: fnd_message.set_token('TASK_TYPE_ID',P_TASK_TYPE_ID);
110: fnd_msg_pub.add;
111:

Line 131: raise fnd_api.g_exc_error;

127:
128: BEGIN
129: if (p_flag is not null) then
130: if (p_flag not in ('Y','N')) then
131: raise fnd_api.g_exc_error;
132: end if;
133: end if;
134: END;
135:

Line 152: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

148:
149:
150: Procedure CREATE_TASK_RSRC_REQ
151: (P_API_VERSION IN NUMBER ,
152: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
153: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
154: P_TASK_ID IN NUMBER DEFAULT NULL ,
155: P_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
156: P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,

Line 153: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

149:
150: Procedure CREATE_TASK_RSRC_REQ
151: (P_API_VERSION IN NUMBER ,
152: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
153: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
154: P_TASK_ID IN NUMBER DEFAULT NULL ,
155: P_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
156: P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,
157: P_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,

Line 194: l_return_status varchar2(1) := fnd_api.g_ret_sts_success ;

190: --
191:
192: l_api_version constant number := 1.0 ;
193: l_api_name constant varchar2(30) := 'CREATE_TASK_RSRC_REQ' ;
194: l_return_status varchar2(1) := fnd_api.g_ret_sts_success ;
195: l_task_id jtf_tasks_b.task_id%type := P_TASK_ID ;
196: l_task_number jtf_tasks_b.task_number%type := P_TASK_NUMBER ;
197: l_task_name jtf_tasks_tl.task_name%type := P_TASK_NAME ;
198: l_task_type_id jtf_task_types_b.task_type_id%type := P_TASK_TYPE_ID ;

Line 225: x_return_status := fnd_api.g_ret_sts_success ;

221:
222:
223: savepoint create_task_resource_pvt ;
224:
225: x_return_status := fnd_api.g_ret_sts_success ;
226:
227:
228:
229: --if p_enabled_flag = jtf_task_utl.g_yes then

Line 278: x_return_status := fnd_api.g_ret_sts_unexp_error ;

274: fetch rr_cur3 into x ;
275:
276: IF rr_cur3%notfound THEN
277:
278: x_return_status := fnd_api.g_ret_sts_unexp_error ;
279: fnd_message.set_name('JTF' ,'JTF_TASK_INSERTING_RESOURCE') ;
280: fnd_msg_pub.add ;
281: raise fnd_api.g_exc_unexpected_error ;
282:

Line 281: raise fnd_api.g_exc_unexpected_error ;

277:
278: x_return_status := fnd_api.g_ret_sts_unexp_error ;
279: fnd_message.set_name('JTF' ,'JTF_TASK_INSERTING_RESOURCE') ;
280: fnd_msg_pub.add ;
281: raise fnd_api.g_exc_unexpected_error ;
282:
283: ELSE
284:
285: X_RESOURCE_REQ_ID := l_resource_req_id ;

Line 289: when fnd_api.g_exc_unexpected_error then

285: X_RESOURCE_REQ_ID := l_resource_req_id ;
286: end if ;
287:
288: exception
289: when fnd_api.g_exc_unexpected_error then
290:
291: rollback to create_task_resource_pvt ;
292: x_return_status := fnd_api.g_ret_sts_unexp_error ;
293: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

Line 292: x_return_status := fnd_api.g_ret_sts_unexp_error ;

288: exception
289: when fnd_api.g_exc_unexpected_error then
290:
291: rollback to create_task_resource_pvt ;
292: x_return_status := fnd_api.g_ret_sts_unexp_error ;
293: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
294: p_data => x_msg_data );
295: when others then
296:

Line 298: x_return_status := fnd_api.g_ret_sts_unexp_error ;

294: p_data => x_msg_data );
295: when others then
296:
297: rollback to create_task_resource_pvt ;
298: x_return_status := fnd_api.g_ret_sts_unexp_error ;
299:
300: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
301: p_data => x_msg_data );
302: END;

Line 316: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

312:
313: Procedure UPDATE_TASK_RSCR_REQ
314: (P_API_VERSION IN NUMBER ,
315: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
316: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
317: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
318: P_RESOURCE_REQ_ID IN NUMBER ,
319: P_TASK_ID IN NUMBER default null ,
320: P_TASK_NAME IN VARCHAR2 default null ,

Line 317: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

313: Procedure UPDATE_TASK_RSCR_REQ
314: (P_API_VERSION IN NUMBER ,
315: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
316: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
317: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
318: P_RESOURCE_REQ_ID IN NUMBER ,
319: P_TASK_ID IN NUMBER default null ,
320: P_TASK_NAME IN VARCHAR2 default null ,
321: P_TASK_NUMBER IN VARCHAR2 default null ,

Line 355: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

351: --
352:
353: l_api_version constant number := 1.0 ;
354: l_api_name constant varchar2(30) := 'CREATE_TASK_RSRC_REQ';
355: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
356: l_task_id jtf_tasks_b.task_id%type := P_TASK_ID ;
357: l_task_number jtf_tasks_b.task_number%type := P_TASK_NUMBER ;
358: l_task_name jtf_tasks_tl.task_name%type := P_TASK_NAME ;
359: l_task_type_id jtf_task_types_b.task_type_id%type := P_TASK_TYPE_ID ;

Line 388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

384: P_TASK_TEMPLATE_ID task_template_id ,
385: P_RESOURCE_TYPE_CODE resource_type_code ,
386: REQUIRED_UNITS required_units,
387: ENABLED_FLAG enabled_flag,
388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

Line 389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,

385: P_RESOURCE_TYPE_CODE resource_type_code ,
386: REQUIRED_UNITS required_units,
387: ENABLED_FLAG enabled_flag,
388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

Line 390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,

386: REQUIRED_UNITS required_units,
387: ENABLED_FLAG enabled_flag,
388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

Line 391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,

387: ENABLED_FLAG enabled_flag,
388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

Line 392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

388: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

Line 393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

389: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

Line 394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

390: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

Line 395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

391: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

Line 396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

392: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

Line 397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

393: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

Line 398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

394: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

Line 399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

395: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category

Line 400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

396: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
404: from jtf_task_rsc_reqs

Line 401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

397: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
404: from jtf_task_rsc_reqs
405: where resource_req_id = l_resource_req_id ;

Line 402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

398: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
404: from jtf_task_rsc_reqs
405: where resource_req_id = l_resource_req_id ;
406:

Line 403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category

399: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
404: from jtf_task_rsc_reqs
405: where resource_req_id = l_resource_req_id ;
406:
407: x char ;

Line 418: x_return_status := fnd_api.g_ret_sts_success ;

414:
415:
416: savepoint update_task_resource_pvt ;
417:
418: x_return_status := fnd_api.g_ret_sts_success ;
419:
420:
421:
422: open trsr_get_cur ;

Line 428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

424:
425: if trsr_get_cur%notfound then
426: fnd_message.set_name( 'JTF', 'JTF_TASK_INV_RES_REQ_ID') ;
427: fnd_msg_pub.add ;
428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
429: raise fnd_api.g_exc_unexpected_error ;
430: end if ;
431:
432: --l_required_units := task_res.REQUIRED_UNITS ;

Line 429: raise fnd_api.g_exc_unexpected_error ;

425: if trsr_get_cur%notfound then
426: fnd_message.set_name( 'JTF', 'JTF_TASK_INV_RES_REQ_ID') ;
427: fnd_msg_pub.add ;
428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
429: raise fnd_api.g_exc_unexpected_error ;
430: end if ;
431:
432: --l_required_units := task_res.REQUIRED_UNITS ;
433:

Line 461: raise fnd_api.g_exc_error ;

457: /* if validate_resource_type_code ( p_resource_type_code =>l_resource_type_code) then
458: l_resource_type_code:=task_res.resource_type_code;
459:
460: else
461: raise fnd_api.g_exc_error ;
462:
463: end if ; */
464:
465: --Task can be updated only if it is active

Line 467: --if l_enabled_flag = fnd_api.G_true then

463: end if ; */
464:
465: --Task can be updated only if it is active
466:
467: --if l_enabled_flag = fnd_api.G_true then
468:
469:
470: jtf_task_resources_pub.lock_task_resources
471: ( P_API_VERSION => 1.0 ,

Line 472: P_INIT_MSG_LIST => fnd_api.g_false ,

468:
469:
470: jtf_task_resources_pub.lock_task_resources
471: ( P_API_VERSION => 1.0 ,
472: P_INIT_MSG_LIST => fnd_api.g_false ,
473: P_COMMIT => fnd_api.g_false ,
474: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,
475: P_OBJECT_VERSION_NUMBER => p_object_version_number,
476: X_RETURN_STATUS => x_return_status ,

Line 473: P_COMMIT => fnd_api.g_false ,

469:
470: jtf_task_resources_pub.lock_task_resources
471: ( P_API_VERSION => 1.0 ,
472: P_INIT_MSG_LIST => fnd_api.g_false ,
473: P_COMMIT => fnd_api.g_false ,
474: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,
475: P_OBJECT_VERSION_NUMBER => p_object_version_number,
476: X_RETURN_STATUS => x_return_status ,
477: X_MSG_DATA => x_msg_data ,

Line 480: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

476: X_RETURN_STATUS => x_return_status ,
477: X_MSG_DATA => x_msg_data ,
478: X_MSG_COUNT => x_msg_count ) ;
479:
480: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
481: THEN
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483: RAISE fnd_api.g_exc_unexpected_error;
484: END IF;

Line 482: x_return_status := fnd_api.g_ret_sts_unexp_error;

478: X_MSG_COUNT => x_msg_count ) ;
479:
480: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
481: THEN
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483: RAISE fnd_api.g_exc_unexpected_error;
484: END IF;
485:
486:

Line 483: RAISE fnd_api.g_exc_unexpected_error;

479:
480: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
481: THEN
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483: RAISE fnd_api.g_exc_unexpected_error;
484: END IF;
485:
486:
487: p_object_version_number := p_object_version_number + 1 ;

Line 530: if fnd_api.to_boolean(p_commit) then

526: if trsr_get_cur%isopen then
527: close trsr_get_cur ;
528: end if ;
529:
530: if fnd_api.to_boolean(p_commit) then
531: commit work ;
532: end if ;
533:
534: -- fnd_msg_pub.count_and_get( p_count => x_msg_count ,

Line 539: when fnd_api.g_exc_unexpected_error then

535: --p_data => x_msg_data ) ;
536:
537:
538: exception
539: when fnd_api.g_exc_unexpected_error then
540: if trsr_get_cur%isopen then
541: close trsr_get_cur ;
542: end if ;
543: rollback to update_task_resource_pvt ;

Line 547: x_return_status := fnd_api.g_ret_sts_unexp_error ;

543: rollback to update_task_resource_pvt ;
544: fnd_message.set_name( 'JTF', 'JTF_TASK_UPD_RES_REQ_ID') ;
545: fnd_message.set_token('RESOURCE_REQ_ID',P_RESOURCE_REQ_ID);
546: fnd_msg_pub.add ;
547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
548: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
549: p_data => x_msg_data );
550: when others then
551: if trsr_get_cur%isopen then

Line 555: x_return_status := fnd_api.g_ret_sts_unexp_error ;

551: if trsr_get_cur%isopen then
552: close trsr_get_cur ;
553: end if ;
554: rollback to update_task_resource_pvt ;
555: x_return_status := fnd_api.g_ret_sts_unexp_error ;
556:
557: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
558: p_data => x_msg_data );
559: end ;

Line 570: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

566:
567: Procedure DELETE_TASK_RSRC_REQ
568: (P_API_VERSION IN NUMBER ,
569: P_OBJECT_VERSION_NUMBER IN NUMBER ,
570: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
571: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
572: P_RESOURCE_REQ_ID IN NUMBER ,
573: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
574: X_MSG_COUNT OUT NOCOPY NUMBER ,

Line 571: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

567: Procedure DELETE_TASK_RSRC_REQ
568: (P_API_VERSION IN NUMBER ,
569: P_OBJECT_VERSION_NUMBER IN NUMBER ,
570: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
571: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
572: P_RESOURCE_REQ_ID IN NUMBER ,
573: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
574: X_MSG_COUNT OUT NOCOPY NUMBER ,
575: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS

Line 596: x_return_status := fnd_api.g_ret_sts_success ;

592: begin
593:
594: savepoint delete_task_resource_pvt ;
595:
596: x_return_status := fnd_api.g_ret_sts_success ;
597:
598: ---call the table handler to delete the resource req
599:
600:

Line 603: P_INIT_MSG_LIST => fnd_api.g_false ,

599:
600:
601: jtf_task_resources_pub.lock_task_resources
602: ( P_API_VERSION => 1.0 ,
603: P_INIT_MSG_LIST => fnd_api.g_false ,
604: P_COMMIT => fnd_api.g_false ,
605: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,
606: P_OBJECT_VERSION_NUMBER => p_object_version_number,
607: X_RETURN_STATUS => x_return_status ,

Line 604: P_COMMIT => fnd_api.g_false ,

600:
601: jtf_task_resources_pub.lock_task_resources
602: ( P_API_VERSION => 1.0 ,
603: P_INIT_MSG_LIST => fnd_api.g_false ,
604: P_COMMIT => fnd_api.g_false ,
605: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,
606: P_OBJECT_VERSION_NUMBER => p_object_version_number,
607: X_RETURN_STATUS => x_return_status ,
608: X_MSG_DATA => x_msg_data ,

Line 611: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

607: X_RETURN_STATUS => x_return_status ,
608: X_MSG_DATA => x_msg_data ,
609: X_MSG_COUNT => x_msg_count ) ;
610:
611: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
612: THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: RAISE fnd_api.g_exc_unexpected_error;
615: END IF;

Line 613: x_return_status := fnd_api.g_ret_sts_unexp_error;

609: X_MSG_COUNT => x_msg_count ) ;
610:
611: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
612: THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: RAISE fnd_api.g_exc_unexpected_error;
615: END IF;
616:
617:

Line 614: RAISE fnd_api.g_exc_unexpected_error;

610:
611: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
612: THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: RAISE fnd_api.g_exc_unexpected_error;
615: END IF;
616:
617:
618: JTF_TASK_RSC_REQS_PKG.DELETE_ROW

Line 627: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

623:
624: if c_res_req_del%found then
625: fnd_message.set_name( 'JTF', 'JTF_TASK_DELETING_RES_REQ_ID') ;
626: fnd_msg_pub.add ;
627: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
628: raise fnd_api.g_exc_unexpected_error ;
629: close c_res_req_del ;
630:
631:

Line 628: raise fnd_api.g_exc_unexpected_error ;

624: if c_res_req_del%found then
625: fnd_message.set_name( 'JTF', 'JTF_TASK_DELETING_RES_REQ_ID') ;
626: fnd_msg_pub.add ;
627: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
628: raise fnd_api.g_exc_unexpected_error ;
629: close c_res_req_del ;
630:
631:
632: else

Line 640: if fnd_api.to_boolean(p_commit) then

636: if c_res_req_del%isopen then
637: close c_res_req_del ;
638: end if;
639:
640: if fnd_api.to_boolean(p_commit) then
641: commit work ;
642: end if ;
643:
644: fnd_msg_pub.count_and_get( p_count => x_msg_count ,

Line 649: when fnd_api.g_exc_unexpected_error then

645: p_data => x_msg_data ) ;
646:
647:
648: exception
649: when fnd_api.g_exc_unexpected_error then
650: rollback to delete_task_resource_pvt ;
651: x_return_status := fnd_api.g_ret_sts_unexp_error ;
652: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
653: p_data => x_msg_data );

Line 651: x_return_status := fnd_api.g_ret_sts_unexp_error ;

647:
648: exception
649: when fnd_api.g_exc_unexpected_error then
650: rollback to delete_task_resource_pvt ;
651: x_return_status := fnd_api.g_ret_sts_unexp_error ;
652: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
653: p_data => x_msg_data );
654:
655:

Line 658: x_return_status := fnd_api.g_ret_sts_unexp_error ;

654:
655:
656: when others then
657: rollback to delete_task_resource_pvt;
658: x_return_status := fnd_api.g_ret_sts_unexp_error ;
659:
660: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
661: p_data => x_msg_data );
662: end ;

Line 827: x_return_status := fnd_api.g_ret_sts_success;

823: begin
824:
825:
826:
827: x_return_status := fnd_api.g_ret_sts_success;
828:
829:
830: X_TASK_RSC_REQ_REC.delete;
831:

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003: x_total_returned := X_TASK_RSC_REQ_REC.count;
1004:
1005: exception
1006:
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010:
1011: (p_count => x_msg_count ,

Line 1008: x_return_status := FND_API.G_RET_STS_ERROR ;

1004:
1005: exception
1006:
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010:
1011: (p_count => x_msg_count ,
1012: p_data => x_msg_data

Line 1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1010:
1011: (p_count => x_msg_count ,
1012: p_data => x_msg_data
1013: );
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015:
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: (p_count => x_msg_count ,

Line 1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1012: p_data => x_msg_data
1013: );
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015:
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: (p_count => x_msg_count ,
1019: p_data => x_msg_data
1020: );

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: p_data => x_msg_data
1020: );
1021: WHEN OTHERS THEN
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1027: END IF;