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

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56:
57: BEGIN
58:
59: -- Initialize the return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: --Log Message
63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPE_PVT.Create_Task_Type.begin'
64: ,x_msg => 'Beginning of Create_Task_Type pvt'

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

115: -- Set the excetption Message and the stack
116: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Create_Task_Type'
117: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
118: --
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: RAISE;
121:
122: END Create_Task_Type;
123:

Line 178: x_return_status := FND_API.G_RET_STS_SUCCESS;

174:
175: BEGIN
176:
177: -- Initialize the return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: --Log Message
181: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PVT.Update_Task_Type.begin'
182: ,x_msg => 'Beginning of Update_Task_Type pvt'

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

233: -- Set the excetption Message and the stack
234: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Update_Task_Type'
235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
236: --
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE;
239:
240: END Update_Task_Type;
241:

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252:
253: BEGIN
254:
255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --Log Message
259: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PVT.Delete_Task_Type.begin'
260: ,x_msg => 'Beginning of Delete_Task_Type pvt'

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: WHEN OTHERS THEN
273: -- Set the excetption Message and the stack
274: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Delete_Task_Type'
275: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: RAISE;
278:
279: END Delete_Task_Type;
280:

Line 303: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

299:
300:
301: PROCEDURE CREATE_DELIVERABLE_TYPE
302: (p_api_version IN NUMBER := 1.0
303: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
304: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
305: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 304: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

300:
301: PROCEDURE CREATE_DELIVERABLE_TYPE
302: (p_api_version IN NUMBER := 1.0
303: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
304: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
305: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
308: ,p_debug_mode IN VARCHAR2 := 'N'

Line 305: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

301: PROCEDURE CREATE_DELIVERABLE_TYPE
302: (p_api_version IN NUMBER := 1.0
303: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
304: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
305: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
308: ,p_debug_mode IN VARCHAR2 := 'N'
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

302: (p_api_version IN NUMBER := 1.0
303: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
304: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
305: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
308: ,p_debug_mode IN VARCHAR2 := 'N'
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: l_debug_level5 CONSTANT NUMBER := 5;
338:
339: BEGIN
340: -- Initialize the return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: --Define the savepoint
344: IF (p_commit = FND_API.G_TRUE)
345: THEN

Line 344: IF (p_commit = FND_API.G_TRUE)

340: -- Initialize the return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: --Define the savepoint
344: IF (p_commit = FND_API.G_TRUE)
345: THEN
346: SAVEPOINT CREATE_DELIVERABLE_TYPE;
347: END IF;
348:

Line 384: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

380: l_debug_level3);
381: END IF;
382:
383: -- Initialize the Message Stack
384: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: --Check whether any of p_deliverable_type_name,start date is null

Line 401: x_return_status :=FND_API.G_RET_STS_ERROR;

397: THEN
398: PA_UTILS.ADD_MESSAGE
399: (p_app_short_name => 'PA',
400: p_msg_name => 'PA_DLV_TYPE_EXISTS');
401: x_return_status :=FND_API.G_RET_STS_ERROR;
402: END IF;
403:
404: PA_DEBUG.WRITE(g_module_name,'After Unique Chk',
405: l_debug_level3);

Line 413: x_return_status :=FND_API.G_RET_STS_ERROR;

409: THEN
410: PA_UTILS.ADD_MESSAGE
411: (p_app_short_name => 'PA',
412: p_msg_name => 'PA_TT_INVALID_DATES');
413: x_return_status :=FND_API.G_RET_STS_ERROR;
414: END IF;
415:
416: IF(x_return_status = FND_API.G_RET_STS_ERROR)
417: THEN

Line 416: IF(x_return_status = FND_API.G_RET_STS_ERROR)

412: p_msg_name => 'PA_TT_INVALID_DATES');
413: x_return_status :=FND_API.G_RET_STS_ERROR;
414: END IF;
415:
416: IF(x_return_status = FND_API.G_RET_STS_ERROR)
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:

Line 418: RAISE FND_API.G_EXC_ERROR;

414: END IF;
415:
416: IF(x_return_status = FND_API.G_RET_STS_ERROR)
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: PA_DEBUG.WRITE(g_module_name,'Before Insert',
422: l_debug_level3);

Line 444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

440: );
441:
442: PA_DEBUG.WRITE(g_module_name,'After Insert',
443: l_debug_level3);
444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
445: THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:

Line 446: RAISE FND_API.G_EXC_ERROR;

442: PA_DEBUG.WRITE(g_module_name,'After Insert',
443: l_debug_level3);
444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
445: THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: EXCEPTION
450: -- Set the exception Message and the stack

Line 451: WHEN FND_API.G_EXC_ERROR THEN

447: END IF;
448:
449: EXCEPTION
450: -- Set the exception Message and the stack
451: WHEN FND_API.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: l_msg_count := FND_MSG_PUB.count_msg;
454:
455: -- Rollback to the savepoint defined

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448:
449: EXCEPTION
450: -- Set the exception Message and the stack
451: WHEN FND_API.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: l_msg_count := FND_MSG_PUB.count_msg;
454:
455: -- Rollback to the savepoint defined
456: IF p_commit = FND_API.G_TRUE

Line 456: IF p_commit = FND_API.G_TRUE

452: x_return_status := FND_API.G_RET_STS_ERROR;
453: l_msg_count := FND_MSG_PUB.count_msg;
454:
455: -- Rollback to the savepoint defined
456: IF p_commit = FND_API.G_TRUE
457: THEN
458: ROLLBACK TO CREATE_DELIVERABLE_TYPE;
459: END IF;
460:

Line 464: ( p_encoded => Fnd_Api.G_TRUE

460:
461: IF l_msg_count = 1 AND x_msg_data IS NULL
462: THEN
463: Pa_Interface_Utils_Pub.get_messages
464: ( p_encoded => Fnd_Api.G_TRUE
465: , p_msg_index => 1
466: , p_msg_count => l_msg_count
467: , p_msg_data => l_msg_data
468: , p_data => l_data

Line 483: x_return_status := Fnd_Api.G_RET_STS_ERROR;

479: END IF;
480: RETURN;
481:
482: WHEN INV_ARG_EXC THEN
483: x_return_status := Fnd_Api.G_RET_STS_ERROR;
484: x_msg_count := 1;
485: x_msg_data := 'PA_TASK_TYPE_PVT : CREATE_DELIVERABLE_TYPE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
486:
487: IF p_commit = FND_API.G_TRUE

Line 487: IF p_commit = FND_API.G_TRUE

483: x_return_status := Fnd_Api.G_RET_STS_ERROR;
484: x_msg_count := 1;
485: x_msg_data := 'PA_TASK_TYPE_PVT : CREATE_DELIVERABLE_TYPE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
486:
487: IF p_commit = FND_API.G_TRUE
488: THEN
489: ROLLBACK TO CREATE_DELIVERABLE_TYPE;
490: END IF;
491:

Line 509: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

505: RAISE;
506:
507: WHEN OTHERS THEN
508: -- Set the exception Message and the stack
509: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
510: x_msg_count := 1;
511: x_msg_data := SQLERRM;
512:
513: --Rollback to the savepoint defined

Line 514: IF p_commit = FND_API.G_TRUE

510: x_msg_count := 1;
511: x_msg_data := SQLERRM;
512:
513: --Rollback to the savepoint defined
514: IF p_commit = FND_API.G_TRUE
515: THEN
516: ROLLBACK TO CREATE_DELIVERABLE_TYPE;
517: END IF;
518:

Line 562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
559:
560: PROCEDURE UPDATE_DELIVERABLE_TYPE
561: (p_api_version IN NUMBER := 1.0
562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

559:
560: PROCEDURE UPDATE_DELIVERABLE_TYPE
561: (p_api_version IN NUMBER := 1.0
562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
567: ,p_debug_mode IN VARCHAR2 := 'N'

Line 564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

560: PROCEDURE UPDATE_DELIVERABLE_TYPE
561: (p_api_version IN NUMBER := 1.0
562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
567: ,p_debug_mode IN VARCHAR2 := 'N'
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

561: (p_api_version IN NUMBER := 1.0
562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
567: ,p_debug_mode IN VARCHAR2 := 'N'
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

Line 631: x_return_status := FND_API.G_RET_STS_SUCCESS;

627:
628: BEGIN
629:
630: -- Initialize the return status to success
631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632: --Log message
633: l_debug_mode := p_debug_mode;
634:
635: IF l_debug_mode = 'Y'

Line 670: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))

666:
667: END IF;
668:
669: -- Initialize the Message Stack
670: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))
671: THEN
672: FND_MSG_PUB.initialize;
673: END IF;
674:

Line 676: IF (p_commit = FND_API.G_TRUE)

672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: -- Save point
676: IF (p_commit = FND_API.G_TRUE)
677: THEN
678: savepoint UPDATE_DELIVERABLE_TYPE;
679: END IF;
680:

Line 717: x_return_status :=FND_API.G_RET_STS_ERROR;

713: PA_UTILS.ADD_MESSAGE
714: (p_app_short_name => 'PA'
715: ,p_msg_name => 'PA_DLV_TYPE_EXISTS');
716:
717: x_return_status :=FND_API.G_RET_STS_ERROR;
718: END IF;
719: END IF;
720: PA_DEBUG.WRITE(g_module_name,'After Checking for unique name',
721: l_debug_level3);

Line 737: x_return_status :=FND_API.G_RET_STS_ERROR;

733: PA_UTILS.ADD_MESSAGE
734: (p_app_short_name => 'PA'
735: ,p_msg_name => 'PA_TT_INVALID_DATES');
736:
737: x_return_status :=FND_API.G_RET_STS_ERROR;
738: END IF;
739: END IF;
740: END IF;
741: PA_DEBUG.WRITE(g_module_name,'After checking for invalid dates',

Line 755: x_return_status :=FND_API.G_RET_STS_ERROR;

751: PA_UTILS.ADD_MESSAGE
752: (p_app_short_name => 'PA'
753: ,p_msg_name => 'PA_DLV_TYPE_CLASS_IN_USE');
754:
755: x_return_status :=FND_API.G_RET_STS_ERROR;
756: END IF;
757: END IF;
758:
759: --If the Enable Progress Entry changes from Checked to UNCHECKED then

Line 780: -- x_return_status :=FND_API.G_RET_STS_ERROR;

776: -- PA_UTILS.ADD_MESSAGE
777: -- (p_app_short_name => 'PA'
778: -- ,p_msg_name => 'PA_DLV_BASED_ASSN_EXISTS');
779:
780: -- x_return_status :=FND_API.G_RET_STS_ERROR;
781: -- END IF;
782:
783: OPEN c_progress_rec_exists;
784: FETCH c_progress_rec_exists INTO l_dummy;

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: IF c_progress_rec_exists%found
787: THEN
788: PA_UTILS.Add_Message( p_app_short_name => 'PA'
789: ,p_msg_name => 'PA_DLV_TYPE_PROG_ERR');
790: x_return_status := FND_API.G_RET_STS_ERROR;
791:
792: IF l_debug_mode = 'Y'
793: THEN
794: Pa_Debug.g_err_stage:= ' Error:PA_DLV_TYPE_PROG_ERR';

Line 830: x_return_status:=FND_API.G_RET_STS_ERROR;

826: PA_UTILS.ADD_MESSAGE
827: (p_app_short_name => 'PA'
828: ,p_msg_name => 'PA_DLV_ACTION_EXISTS');
829:
830: x_return_status:=FND_API.G_RET_STS_ERROR;
831: ELSE
832:
833: --before placing call to API check for any errors
834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

830: x_return_status:=FND_API.G_RET_STS_ERROR;
831: ELSE
832:
833: --before placing call to API check for any errors
834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
835: THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:

Line 836: RAISE FND_API.G_EXC_ERROR;

832:
833: --before placing call to API check for any errors
834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
835: THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839: --Place a Call to Delete Deliverable Actions
840: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK

Line 842: ,p_init_msg_list => FND_API.G_FALSE

838:
839: --Place a Call to Delete Deliverable Actions
840: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK
841: (p_api_version => p_api_version
842: ,p_init_msg_list => FND_API.G_FALSE
843: ,p_commit => p_commit
844: ,p_validate_only => p_validate_only
845: ,p_validation_level => p_validation_level
846: ,p_calling_module => p_calling_module

Line 856: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

852: ,x_msg_data => x_msg_data
853: ,x_msg_count => x_msg_count);
854:
855: --After API execution check for errors
856: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: END IF;

Line 858: RAISE FND_API.G_EXC_ERROR;

854:
855: --After API execution check for errors
856: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: END IF;
861: END IF;
862:

Line 863: IF(x_return_status=FND_API.G_RET_STS_ERROR)

859: END IF;
860: END IF;
861: END IF;
862:
863: IF(x_return_status=FND_API.G_RET_STS_ERROR)
864: THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:

Line 865: RAISE FND_API.G_EXC_ERROR;

861: END IF;
862:
863: IF(x_return_status=FND_API.G_RET_STS_ERROR)
864: THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868: --Call PA_TASK_TYPE_PKG.update_row
869: PA_TASK_TYPE_PKG.update_row

Line 885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

881: ,x_return_status => x_return_status
882: ,x_msg_count => x_msg_count
883: ,x_msg_data => x_msg_data
884: );
885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
886: THEN
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:

Line 887: RAISE FND_API.G_EXC_ERROR;

883: ,x_msg_data => x_msg_data
884: );
885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
886: THEN
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: EXCEPTION
891:

Line 892: WHEN FND_API.G_EXC_ERROR THEN

888: END IF;
889:
890: EXCEPTION
891:
892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: l_msg_count := FND_MSG_PUB.count_msg;
895:
896: IF p_commit = FND_API.G_TRUE

Line 893: x_return_status := FND_API.G_RET_STS_ERROR;

889:
890: EXCEPTION
891:
892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: l_msg_count := FND_MSG_PUB.count_msg;
895:
896: IF p_commit = FND_API.G_TRUE
897: THEN

Line 896: IF p_commit = FND_API.G_TRUE

892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: l_msg_count := FND_MSG_PUB.count_msg;
895:
896: IF p_commit = FND_API.G_TRUE
897: THEN
898: ROLLBACK TO UPDATE_DELIVERABLE_TYPE;
899: END IF;
900:

Line 914: ( p_encoded => Fnd_Api.G_TRUE

910:
911: IF l_msg_count = 1 AND x_msg_data IS NULL
912: THEN
913: Pa_Interface_Utils_Pub.get_messages
914: ( p_encoded => Fnd_Api.G_TRUE
915: , p_msg_index => 1
916: , p_msg_count => l_msg_count
917: , p_msg_data => l_msg_data
918: , p_data => l_data

Line 932: x_return_status := Fnd_Api.G_RET_STS_ERROR;

928: Pa_Debug.reset_curr_function;
929: END IF;
930:
931: WHEN INV_ARG_EXC THEN
932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
933: x_msg_count := 1;
934: x_msg_data := 'PA_TASK_TYPE_PVT : UPDATE_DELIVERABLE_TYPE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
935:
936: IF p_commit = FND_API.G_TRUE

Line 936: IF p_commit = FND_API.G_TRUE

932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
933: x_msg_count := 1;
934: x_msg_data := 'PA_TASK_TYPE_PVT : UPDATE_DELIVERABLE_TYPE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
935:
936: IF p_commit = FND_API.G_TRUE
937: THEN
938: ROLLBACK TO UPDATE_DELIVERABLE_TYPE;
939: END IF;
940:

Line 967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

963: RAISE;
964:
965: WHEN OTHERS THEN
966: -- Set the exception Message and the stack
967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
968: x_msg_count := 1;
969: x_msg_data := SQLERRM;
970:
971: IF p_commit = FND_API.G_TRUE

Line 971: IF p_commit = FND_API.G_TRUE

967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
968: x_msg_count := 1;
969: x_msg_data := SQLERRM;
970:
971: IF p_commit = FND_API.G_TRUE
972: THEN
973: ROLLBACK TO UPDATE_DELIVERABLE_TYPE;
974: END IF;
975:

Line 1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1013: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number
1014:
1015: PROCEDURE DELETE_DELIVERABLE_TYPE
1016: (p_api_version IN NUMBER := 1.0
1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1018: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1019: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 1018: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1014:
1015: PROCEDURE DELETE_DELIVERABLE_TYPE
1016: (p_api_version IN NUMBER := 1.0
1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1018: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1019: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1022: ,p_debug_mode IN VARCHAR2 := 'N'

Line 1019: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1015: PROCEDURE DELETE_DELIVERABLE_TYPE
1016: (p_api_version IN NUMBER := 1.0
1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1018: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1019: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1022: ,p_debug_mode IN VARCHAR2 := 'N'
1023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1016: (p_api_version IN NUMBER := 1.0
1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1018: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1019: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1022: ,p_debug_mode IN VARCHAR2 := 'N'
1023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1024: ,p_deliverable_type_id IN pa_task_types.Task_Type_id%TYPE

Line 1045: x_return_status := FND_API.G_RET_STS_SUCCESS;

1041: l_debug_level4 CONSTANT NUMBER := 4;
1042: l_debug_level5 CONSTANT NUMBER := 5;
1043: BEGIN
1044: -- Initialize the return status to success
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046:
1047: --Log message
1048: l_debug_mode :=p_debug_mode;
1049:

Line 1056: IF (p_commit = FND_API.G_TRUE)

1052: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_TYPE',
1053: p_debug_mode => l_debug_mode );
1054: END IF;
1055: --savepoint
1056: IF (p_commit = FND_API.G_TRUE)
1057: THEN
1058: savepoint DELETE_DELIVERABLE_TYPE;
1059: END IF;
1060:

Line 1073: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))

1069: l_debug_level3);
1070: END IF;
1071:
1072: --Initialize the Message Stack
1073: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))
1074: THEN
1075: FND_MSG_PUB.initialize;
1076: END IF;
1077:

Line 1087: ,p_init_msg_list => FND_API.G_FALSE

1083: END IF;
1084: --Call Delete Deliverable Actions API
1085: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK
1086: (p_api_version => p_api_version
1087: ,p_init_msg_list => FND_API.G_FALSE
1088: ,p_commit => p_commit
1089: ,p_validate_only => p_validate_only
1090: ,p_validation_level => p_validation_level
1091: ,p_calling_module => p_calling_module

Line 1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1103: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1104: l_debug_level3);
1105: END IF;
1106:
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1108: THEN
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:

Line 1109: RAISE FND_API.G_EXC_ERROR;

1105: END IF;
1106:
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1108: THEN
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112: --Call PA_TASK_TYPE_PKG.DELETE_ROW(p_deliverable_type_id)
1113: PA_TASK_TYPE_PKG.delete_row

Line 1120: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1116: ,x_return_status => x_return_status
1117: ,x_msg_data => x_msg_data
1118: ,x_msg_count => x_msg_count);
1119:
1120: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1121: THEN
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: EXCEPTION

Line 1122: RAISE FND_API.G_EXC_ERROR;

1118: ,x_msg_count => x_msg_count);
1119:
1120: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1121: THEN
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: EXCEPTION
1125:
1126: WHEN FND_API.G_EXC_ERROR THEN

Line 1126: WHEN FND_API.G_EXC_ERROR THEN

1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: EXCEPTION
1125:
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: l_msg_count := FND_MSG_PUB.count_msg;
1129:
1130: IF p_commit = FND_API.G_TRUE

Line 1127: x_return_status := FND_API.G_RET_STS_ERROR;

1123: END IF;
1124: EXCEPTION
1125:
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: l_msg_count := FND_MSG_PUB.count_msg;
1129:
1130: IF p_commit = FND_API.G_TRUE
1131: THEN

Line 1130: IF p_commit = FND_API.G_TRUE

1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: l_msg_count := FND_MSG_PUB.count_msg;
1129:
1130: IF p_commit = FND_API.G_TRUE
1131: THEN
1132: ROLLBACK TO DELETE_DELIVERABLE_TYPE;
1133: END IF;
1134:

Line 1138: ( p_encoded => Fnd_Api.G_TRUE

1134:
1135: IF l_msg_count = 1 AND x_msg_data IS NULL
1136: THEN
1137: Pa_Interface_Utils_Pub.get_messages
1138: ( p_encoded => Fnd_Api.G_TRUE
1139: , p_msg_index => 1
1140: , p_msg_count => l_msg_count
1141: , p_msg_data => l_msg_data
1142: , p_data => l_data

Line 1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1153: END IF;
1154:
1155: WHEN OTHERS THEN
1156: -- Set the exception Message and the stack
1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1158: x_msg_count := 1;
1159: x_msg_data := SQLERRM;
1160:
1161: IF p_commit = FND_API.G_TRUE

Line 1161: IF p_commit = FND_API.G_TRUE

1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1158: x_msg_count := 1;
1159: x_msg_data := SQLERRM;
1160:
1161: IF p_commit = FND_API.G_TRUE
1162: THEN
1163: ROLLBACK TO DELETE_DELIVERABLE_TYPE;
1164: END IF;
1165: