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_BILLING_SCHEDULE_PVT dependencies on FND_API

Line 11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

7: -- Type : Public procedure
8: -- Pre-reqs : None
9: -- Return Value : N/A
10: -- Prameters
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

8: -- Pre-reqs : None
9: -- Return Value : N/A
10: -- Prameters
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

9: -- Return Value : N/A
10: -- Prameters
11: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED

Line 16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

12: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

Line 18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

14: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

15: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

Line 20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

16: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

17: -- p_project_id IN NUMBER REQUIRED
18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

18: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

19: -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

Line 24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

20: -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

Line 25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

21: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

22: -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

Line 27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

23: -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

Line 28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

24: -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

25: -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
33: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1

Line 30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR

26: -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
33: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
34: -- x_return_status OUT VARCHAR2 REQUIRED

Line 31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

27: -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
33: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
34: -- x_return_status OUT VARCHAR2 REQUIRED
35: -- x_msg_count OUT VARCHAR2 REQUIRED

Line 32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

28: -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
29: -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
30: -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
31: -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32: -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
33: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
34: -- x_return_status OUT VARCHAR2 REQUIRED
35: -- x_msg_count OUT VARCHAR2 REQUIRED
36: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

41: --
42: --
43:
44: PROCEDURE Update_Project_Task_Bill_Info(
45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
47: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
48: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
49: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 46: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

42: --
43:
44: PROCEDURE Update_Project_Task_Bill_Info(
45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
47: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
48: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
49: p_debug_mode IN VARCHAR2 DEFAULT 'N',
50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 47: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

43:
44: PROCEDURE Update_Project_Task_Bill_Info(
45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
47: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
48: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
49: p_debug_mode IN VARCHAR2 DEFAULT 'N',
50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_project_id IN NUMBER ,

Line 50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

46: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
47: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
48: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
49: p_debug_mode IN VARCHAR2 DEFAULT 'N',
50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_project_id IN NUMBER ,
52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

48: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
49: p_debug_mode IN VARCHAR2 DEFAULT 'N',
50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_project_id IN NUMBER ,
52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

49: p_debug_mode IN VARCHAR2 DEFAULT 'N',
50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_project_id IN NUMBER ,
52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

50: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: p_project_id IN NUMBER ,
52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

51: p_project_id IN NUMBER ,
52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

52: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

53: p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

54: p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

55: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

56: p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

57: p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

58: p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

59: p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
67: p_record_version_number IN NUMBER DEFAULT 1,

Line 64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

60: p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
67: p_record_version_number IN NUMBER DEFAULT 1,
68: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,

61: p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
67: p_record_version_number IN NUMBER DEFAULT 1,
68: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
69: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,

62: p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
63: p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
66: p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
67: p_record_version_number IN NUMBER DEFAULT 1,
68: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
69: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
70: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 98: IF p_commit = FND_API.G_TRUE

94: l_project_type_class_code PA_PROJECT_TYPES.PROJECT_TYPE_CLASS_CODE%TYPE;
95:
96: BEGIN
97:
98: IF p_commit = FND_API.G_TRUE
99: THEN
100: SAVEPOINT Update_Bill_Info;
101: END IF;
102:

Line 105: IF p_validate_only = FND_API.G_TRUE AND

101: END IF;
102:
103: x_return_status := 'S';
104:
105: IF p_validate_only = FND_API.G_TRUE AND
106: p_validation_level > 0
107: THEN
108:
109: IF (p_debug_mode = 'Y')

Line 139: IF l_return_status = FND_API.G_RET_STS_ERROR

135: p_nlbr_std_bill_rate_sch => p_nlbr_std_bill_rate_sch,
136: x_error_msg_code => l_error_msg_code,
137: x_return_status => l_return_status );
138:
139: IF l_return_status = FND_API.G_RET_STS_ERROR
140: THEN
141: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
142: p_msg_name => l_error_msg_code);
143:

Line 146: RAISE FND_API.G_EXC_ERROR;

142: p_msg_name => l_error_msg_code);
143:
144: x_msg_data := l_error_msg_code;
145: x_return_status := 'E';
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149: END IF;
150:

Line 156: IF p_validate_only <> FND_API.G_TRUE

152: THEN
153: pa_debug.debug('Update_Project_Task_Bill_Info PVT: Checking Lock on record');
154: END IF;
155:
156: IF p_validate_only <> FND_API.G_TRUE
157: THEN
158: BEGIN
159: SELECT 'x' INTO l_dummy_char
160: FROM pa_projects

Line 223: RAISE FND_API.G_EXC_ERROR;

219:
220: IF l_msg_count > 0 THEN
221: x_msg_count := l_msg_count;
222: x_return_status := 'E';
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: IF p_validate_only = FND_API.G_TRUE AND
227: p_validation_level > 0

Line 226: IF p_validate_only = FND_API.G_TRUE AND

222: x_return_status := 'E';
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: IF p_validate_only = FND_API.G_TRUE AND
227: p_validation_level > 0
228: THEN
229: IF p_task_id = FND_API.G_MISS_NUM
230: THEN

Line 229: IF p_task_id = FND_API.G_MISS_NUM

225:
226: IF p_validate_only = FND_API.G_TRUE AND
227: p_validation_level > 0
228: THEN
229: IF p_task_id = FND_API.G_MISS_NUM
230: THEN
231: l_task_id := null;
232: ELSE
233: l_task_id := p_task_id;

Line 236: IF p_lbr_schedule_type = FND_API.G_MISS_CHAR

232: ELSE
233: l_task_id := p_task_id;
234: END IF;
235:
236: IF p_lbr_schedule_type = FND_API.G_MISS_CHAR
237: THEN
238: l_lbr_schedule_type := null;
239: ELSE
240: l_lbr_schedule_type := p_lbr_schedule_type;

Line 243: IF p_non_lbr_schedule_type = FND_API.G_MISS_CHAR

239: ELSE
240: l_lbr_schedule_type := p_lbr_schedule_type;
241: END IF;
242:
243: IF p_non_lbr_schedule_type = FND_API.G_MISS_CHAR
244: THEN
245: l_non_lbr_schedule_type := null;
246: ELSE
247: l_non_lbr_schedule_type := p_non_lbr_schedule_type;

Line 250: IF p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM

246: ELSE
247: l_non_lbr_schedule_type := p_non_lbr_schedule_type;
248: END IF;
249:
250: IF p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM
251: THEN
252: l_emp_bill_rate_sch_id := null;
253: ELSE
254: l_emp_bill_rate_sch_id := p_emp_bill_rate_sch_id;

Line 257: IF p_job_bill_rate_sch_id = FND_API.G_MISS_NUM

253: ELSE
254: l_emp_bill_rate_sch_id := p_emp_bill_rate_sch_id;
255: END IF;
256:
257: IF p_job_bill_rate_sch_id = FND_API.G_MISS_NUM
258: THEN
259: l_job_bill_rate_sch_id := null;
260: ELSE
261: l_job_bill_rate_sch_id := p_job_bill_rate_sch_id;

Line 264: IF p_lbr_sch_fxd_date = FND_API.G_MISS_DATE

260: ELSE
261: l_job_bill_rate_sch_id := p_job_bill_rate_sch_id;
262: END IF;
263:
264: IF p_lbr_sch_fxd_date = FND_API.G_MISS_DATE
265: THEN
266: l_lbr_sch_fxd_date := null;
267: ELSE
268: l_lbr_sch_fxd_date := p_lbr_sch_fxd_date;

Line 271: IF p_lbr_sch_discount = FND_API.G_MISS_NUM

267: ELSE
268: l_lbr_sch_fxd_date := p_lbr_sch_fxd_date;
269: END IF;
270:
271: IF p_lbr_sch_discount = FND_API.G_MISS_NUM
272: THEN
273: l_lbr_sch_discount := null;
274: ELSE
275: l_lbr_sch_discount := p_lbr_sch_discount;

Line 278: IF p_rev_schedule_id = FND_API.G_MISS_NUM

274: ELSE
275: l_lbr_sch_discount := p_lbr_sch_discount;
276: END IF;
277:
278: IF p_rev_schedule_id = FND_API.G_MISS_NUM
279: THEN
280: l_rev_schedule_id := null;
281: ELSE
282: l_rev_schedule_id := p_rev_schedule_id;

Line 285: IF p_inv_schedule_id = FND_API.G_MISS_NUM

281: ELSE
282: l_rev_schedule_id := p_rev_schedule_id;
283: END IF;
284:
285: IF p_inv_schedule_id = FND_API.G_MISS_NUM
286: THEN
287: l_inv_schedule_id := null;
288: ELSE
289: l_inv_schedule_id := p_inv_schedule_id;

Line 292: IF p_rev_ind_sch_fxd_date = FND_API.G_MISS_DATE

288: ELSE
289: l_inv_schedule_id := p_inv_schedule_id;
290: END IF;
291:
292: IF p_rev_ind_sch_fxd_date = FND_API.G_MISS_DATE
293: THEN
294: l_rev_ind_sch_fxd_date := null;
295: ELSE
296: l_rev_ind_sch_fxd_date := p_rev_ind_sch_fxd_date;

Line 299: IF p_inv_ind_sch_fxd_date = FND_API.G_MISS_DATE

295: ELSE
296: l_rev_ind_sch_fxd_date := p_rev_ind_sch_fxd_date;
297: END IF;
298:
299: IF p_inv_ind_sch_fxd_date = FND_API.G_MISS_DATE
300: THEN
301: l_inv_ind_sch_fxd_date := null;
302: ELSE
303: l_inv_ind_sch_fxd_date := p_inv_ind_sch_fxd_date;

Line 306: IF p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM

302: ELSE
303: l_inv_ind_sch_fxd_date := p_inv_ind_sch_fxd_date;
304: END IF;
305:
306: IF p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM
307: THEN
308: l_nlbr_bill_rate_org_id := null;
309: ELSE
310: l_nlbr_bill_rate_org_id := p_nlbr_bill_rate_org_id;

Line 313: IF p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR

309: ELSE
310: l_nlbr_bill_rate_org_id := p_nlbr_bill_rate_org_id;
311: END IF;
312:
313: IF p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR
314: THEN
315: l_nlbr_std_bill_rate_sch := null;
316: ELSE
317: l_nlbr_std_bill_rate_sch := p_nlbr_std_bill_rate_sch;

Line 320: IF p_nlbr_sch_fxd_date = FND_API.G_MISS_DATE

316: ELSE
317: l_nlbr_std_bill_rate_sch := p_nlbr_std_bill_rate_sch;
318: END IF;
319:
320: IF p_nlbr_sch_fxd_date = FND_API.G_MISS_DATE
321: THEN
322: l_nlbr_sch_fxd_date := null;
323: ELSE
324: l_nlbr_sch_fxd_date := p_nlbr_sch_fxd_date;

Line 327: IF p_nlbr_sch_discount = FND_API.G_MISS_NUM

323: ELSE
324: l_nlbr_sch_fxd_date := p_nlbr_sch_fxd_date;
325: END IF;
326:
327: IF p_nlbr_sch_discount = FND_API.G_MISS_NUM
328: THEN
329: l_nlbr_sch_discount := null;
330: ELSE
331: l_nlbr_sch_discount := p_nlbr_sch_discount;

Line 334: IF p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL

330: ELSE
331: l_nlbr_sch_discount := p_nlbr_sch_discount;
332: END IF;
333:
334: IF p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL
335: THEN
336: UPDATE pa_projects
337: SET LABOR_SCH_TYPE = l_lbr_schedule_type,
338: NON_LABOR_SCH_TYPE = l_non_lbr_schedule_type,

Line 358: IF p_validate_only <> FND_API.G_TRUE

354:
355: ELSE
356:
357: --lock pa_tasks table
358: IF p_validate_only <> FND_API.G_TRUE
359: THEN
360: BEGIN
361: SELECT 'x' INTO l_dummy_char
362: FROM pa_tasks

Line 425: RAISE FND_API.G_EXC_ERROR;

421:
422: IF l_msg_count > 0 THEN
423: x_msg_count := l_msg_count;
424: x_return_status := 'E';
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: UPDATE pa_tasks
428: SET LABOR_SCH_TYPE = l_lbr_schedule_type,
429: NON_LABOR_SCH_TYPE = l_non_lbr_schedule_type,

Line 449: IF FND_API.TO_BOOLEAN(P_COMMIT)

445: END IF;
446:
447: END IF;
448:
449: IF FND_API.TO_BOOLEAN(P_COMMIT)
450: THEN
451: COMMIT WORK;
452: END IF;
453:

Line 455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

451: COMMIT WORK;
452: END IF;
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: IF p_commit = FND_API.G_TRUE
457: THEN
458: ROLLBACK TO Update_Bill_Info;
459: END IF;

Line 456: IF p_commit = FND_API.G_TRUE

452: END IF;
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: IF p_commit = FND_API.G_TRUE
457: THEN
458: ROLLBACK TO Update_Bill_Info;
459: END IF;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

456: IF p_commit = FND_API.G_TRUE
457: THEN
458: ROLLBACK TO Update_Bill_Info;
459: END IF;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
462: p_procedure_name => 'Update_Project_Task_Bill_Info',
463: p_error_text => SUBSTRB(SQLERRM,1,240));
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
462: p_procedure_name => 'Update_Project_Task_Bill_Info',
463: p_error_text => SUBSTRB(SQLERRM,1,240));
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: IF p_commit = FND_API.G_TRUE
468: THEN

Line 466: WHEN FND_API.G_EXC_ERROR THEN

462: p_procedure_name => 'Update_Project_Task_Bill_Info',
463: p_error_text => SUBSTRB(SQLERRM,1,240));
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: IF p_commit = FND_API.G_TRUE
468: THEN
469: ROLLBACK TO Update_Bill_Info;
470: END IF;

Line 467: IF p_commit = FND_API.G_TRUE

463: p_error_text => SUBSTRB(SQLERRM,1,240));
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: IF p_commit = FND_API.G_TRUE
468: THEN
469: ROLLBACK TO Update_Bill_Info;
470: END IF;
471: x_return_status := 'E';

Line 474: IF p_commit = FND_API.G_TRUE

470: END IF;
471: x_return_status := 'E';
472:
473: WHEN OTHERS THEN
474: IF p_commit = FND_API.G_TRUE
475: THEN
476: ROLLBACK TO Update_Bill_Info;
477: END IF;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: IF p_commit = FND_API.G_TRUE
475: THEN
476: ROLLBACK TO Update_Bill_Info;
477: END IF;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
480: p_procedure_name => 'Update_Project_Task_Bill_Info',
481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: RAISE;

Line 490: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

486: -- Type : Public procedure
487: -- Pre-reqs : None
488: -- Return Value : N/A
489: -- Prameters
490: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
491: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
492: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
493: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
494: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 491: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

487: -- Pre-reqs : None
488: -- Return Value : N/A
489: -- Prameters
490: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
491: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
492: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
493: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
494: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
495: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 492: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

488: -- Return Value : N/A
489: -- Prameters
490: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
491: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
492: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
493: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
494: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
495: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
496: -- p_project_id IN NUMBER REQUIRED

Line 495: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

491: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
492: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
493: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
494: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
495: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
496: -- p_project_id IN NUMBER REQUIRED
497: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
498: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
499: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,

Line 497: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

493: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
494: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
495: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
496: -- p_project_id IN NUMBER REQUIRED
497: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
498: -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
499: -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
500: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
501: -- x_return_status OUT VARCHAR2 REQUIRED

Line 511: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

507: -- 21-MAY-01 Majid Ansari -Created
508: --
509: --
510: PROCEDURE update_billing_schedule_type(
511: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
513: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
514: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
515: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 512: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

508: --
509: --
510: PROCEDURE update_billing_schedule_type(
511: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
513: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
514: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
515: p_debug_mode IN VARCHAR2 DEFAULT 'N',
516: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 513: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

509: --
510: PROCEDURE update_billing_schedule_type(
511: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
513: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
514: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
515: p_debug_mode IN VARCHAR2 DEFAULT 'N',
516: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
517: p_project_id IN NUMBER ,

Line 516: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

512: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
513: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
514: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
515: p_debug_mode IN VARCHAR2 DEFAULT 'N',
516: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
517: p_project_id IN NUMBER ,
518: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
519: p_lbr_schedule_type IN VARCHAR2 ,
520: p_non_lbr_schedule_type IN VARCHAR2 ,

Line 518: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

514: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
515: p_debug_mode IN VARCHAR2 DEFAULT 'N',
516: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
517: p_project_id IN NUMBER ,
518: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
519: p_lbr_schedule_type IN VARCHAR2 ,
520: p_non_lbr_schedule_type IN VARCHAR2 ,
521: p_record_version_number IN NUMBER DEFAULT 1,
522: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 535: IF p_commit = FND_API.G_TRUE

531:
532: l_task_id NUMBER;
533: l_effective_to_date DATE;
534: BEGIN
535: IF p_commit = FND_API.G_TRUE
536: THEN
537: SAVEPOINT bill_sch_type;
538: END IF;
539:

Line 542: IF p_validate_only = FND_API.G_TRUE AND

538: END IF;
539:
540: x_return_status := 'S';
541:
542: IF p_validate_only = FND_API.G_TRUE AND
543: p_validation_level > 0
544: THEN
545: IF p_task_id = FND_API.G_MISS_NUM
546: THEN

Line 545: IF p_task_id = FND_API.G_MISS_NUM

541:
542: IF p_validate_only = FND_API.G_TRUE AND
543: p_validation_level > 0
544: THEN
545: IF p_task_id = FND_API.G_MISS_NUM
546: THEN
547: l_task_id := null;
548: ELSE
549: l_task_id := p_task_id;

Line 558: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )

554: IF (p_debug_mode = 'Y')
555: THEN
556: pa_debug.debug('update_billing_schedule_type PVT: Checking Lock on record');
557: END IF;
558: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
559: THEN
560: IF p_validate_only <> FND_API.G_TRUE
561: THEN
562: BEGIN

Line 560: IF p_validate_only <> FND_API.G_TRUE

556: pa_debug.debug('update_billing_schedule_type PVT: Checking Lock on record');
557: END IF;
558: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
559: THEN
560: IF p_validate_only <> FND_API.G_TRUE
561: THEN
562: BEGIN
563: SELECT 'x' INTO l_dummy_char
564: FROM pa_projects

Line 624: IF p_validate_only <> FND_API.G_TRUE

620: END;
621: END IF;
622: ELSE
623: --lock pa_tasks
624: IF p_validate_only <> FND_API.G_TRUE
625: THEN
626: BEGIN
627: SELECT 'x' INTO l_dummy_char
628: FROM pa_tasks

Line 693: RAISE FND_API.G_EXC_ERROR;

689:
690: IF l_msg_count > 0 THEN
691: x_msg_count := l_msg_count;
692: x_return_status := 'E';
693: RAISE FND_API.G_EXC_ERROR;
694: END IF;
695:
696: IF p_lbr_schedule_type = 'B' and p_non_lbr_schedule_type = 'B'
697: THEN

Line 698: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )

694: END IF;
695:
696: IF p_lbr_schedule_type = 'B' and p_non_lbr_schedule_type = 'B'
697: THEN
698: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
699: THEN
700: UPDATE pa_projects
701: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
702: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,

Line 724: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )

720: AND RECORD_VERSION_NUMBER = p_record_version_number;
721: END IF;
722: ELSIF p_lbr_schedule_type = 'B' and p_non_lbr_schedule_type = 'I'
723: THEN
724: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
725: THEN
726: UPDATE pa_projects
727: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
728: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,

Line 750: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )

746: AND RECORD_VERSION_NUMBER = p_record_version_number;
747: END IF;
748: ELSIF p_lbr_schedule_type = 'I' and p_non_lbr_schedule_type = 'B'
749: THEN
750: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
751: THEN
752: UPDATE pa_projects
753: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
754: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,

Line 776: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )

772: AND RECORD_VERSION_NUMBER = p_record_version_number;
773: END IF;
774: ELSIF p_lbr_schedule_type = 'I' and p_non_lbr_schedule_type = 'I'
775: THEN
776: IF( p_task_id = FND_API.G_MISS_NUM OR l_task_id is NULL )
777: THEN
778: UPDATE pa_projects
779: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
780: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,

Line 811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

807: END IF;
808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: IF p_commit = FND_API.G_TRUE
813: THEN
814: ROLLBACK TO bill_sch_type;
815: END IF;

Line 812: IF p_commit = FND_API.G_TRUE

808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: IF p_commit = FND_API.G_TRUE
813: THEN
814: ROLLBACK TO bill_sch_type;
815: END IF;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

812: IF p_commit = FND_API.G_TRUE
813: THEN
814: ROLLBACK TO bill_sch_type;
815: END IF;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
818: p_procedure_name => 'update_billing_schedule_type',
819: p_error_text => SUBSTRB(SQLERRM,1,240));
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
818: p_procedure_name => 'update_billing_schedule_type',
819: p_error_text => SUBSTRB(SQLERRM,1,240));
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: IF p_commit = FND_API.G_TRUE
824: THEN

Line 822: WHEN FND_API.G_EXC_ERROR THEN

818: p_procedure_name => 'update_billing_schedule_type',
819: p_error_text => SUBSTRB(SQLERRM,1,240));
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: IF p_commit = FND_API.G_TRUE
824: THEN
825: ROLLBACK TO bill_sch_type;
826: END IF;

Line 823: IF p_commit = FND_API.G_TRUE

819: p_error_text => SUBSTRB(SQLERRM,1,240));
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: IF p_commit = FND_API.G_TRUE
824: THEN
825: ROLLBACK TO bill_sch_type;
826: END IF;
827: x_return_status := 'E';

Line 830: IF p_commit = FND_API.G_TRUE

826: END IF;
827: x_return_status := 'E';
828:
829: WHEN OTHERS THEN
830: IF p_commit = FND_API.G_TRUE
831: THEN
832: ROLLBACK TO bill_sch_type;
833: END IF;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

830: IF p_commit = FND_API.G_TRUE
831: THEN
832: ROLLBACK TO bill_sch_type;
833: END IF;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
836: p_procedure_name => 'update_billing_schedule_type',
837: p_error_text => SUBSTRB(SQLERRM,1,240));
838: RAISE;

Line 847: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

843: -- Type : Public procedure
844: -- Pre-reqs : None
845: -- Return Value : N/A
846: -- Prameters
847: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
848: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
849: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
850: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
851: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 848: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

844: -- Pre-reqs : None
845: -- Return Value : N/A
846: -- Prameters
847: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
848: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
849: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
850: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
851: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
852: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 849: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

845: -- Return Value : N/A
846: -- Prameters
847: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
848: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
849: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
850: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
851: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
852: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
853: -- p_project_id IN NUMBER REQUIRED

Line 852: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

848: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
849: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
850: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
851: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
852: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
853: -- p_project_id IN NUMBER REQUIRED
854: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
855: -- p_labor_multiplier IN NUMBER REQUIRED
856: -- p_effective_from_date IN DATE REQUIRED

Line 854: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

850: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
851: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
852: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
853: -- p_project_id IN NUMBER REQUIRED
854: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
855: -- p_labor_multiplier IN NUMBER REQUIRED
856: -- p_effective_from_date IN DATE REQUIRED
857: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
858: -- x_labor_multiplier_id OUT NUMBER REQUIRED

Line 857: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

853: -- p_project_id IN NUMBER REQUIRED
854: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
855: -- p_labor_multiplier IN NUMBER REQUIRED
856: -- p_effective_from_date IN DATE REQUIRED
857: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
858: -- x_labor_multiplier_id OUT NUMBER REQUIRED
859: -- x_return_status OUT VARCHAR2 REQUIRED
860: -- x_msg_count OUT VARCHAR2 REQUIRED
861: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 869: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

865: -- 21-MAY-01 Majid Ansari -Created
866: --
867: --
868: PROCEDURE Create_Labor_Multiplier(
869: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
870: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
871: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
872: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
873: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 870: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

866: --
867: --
868: PROCEDURE Create_Labor_Multiplier(
869: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
870: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
871: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
872: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
873: p_debug_mode IN VARCHAR2 DEFAULT 'N',
874: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 871: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

867: --
868: PROCEDURE Create_Labor_Multiplier(
869: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
870: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
871: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
872: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
873: p_debug_mode IN VARCHAR2 DEFAULT 'N',
874: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
875: p_project_id IN NUMBER ,

Line 874: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

870: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
871: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
872: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
873: p_debug_mode IN VARCHAR2 DEFAULT 'N',
874: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
875: p_project_id IN NUMBER ,
876: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
877: p_labor_multiplier IN NUMBER ,
878: p_effective_from_date IN DATE ,

Line 876: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

872: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
873: p_debug_mode IN VARCHAR2 DEFAULT 'N',
874: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
875: p_project_id IN NUMBER ,
876: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
877: p_labor_multiplier IN NUMBER ,
878: p_effective_from_date IN DATE ,
879: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
880: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 879: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

875: p_project_id IN NUMBER ,
876: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
877: p_labor_multiplier IN NUMBER ,
878: p_effective_from_date IN DATE ,
879: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
880: x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
881: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
882: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
883: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 895: IF p_commit = FND_API.G_TRUE

891: l_task_id NUMBER;
892: l_effective_to_date DATE;
893: l_labor_multiplier_id NUMBER;
894: BEGIN
895: IF p_commit = FND_API.G_TRUE
896: THEN
897: SAVEPOINT Labor_Multiplier;
898: END IF;
899:

Line 902: IF p_validate_only = FND_API.G_TRUE AND

898: END IF;
899:
900: x_return_status := 'S';
901:
902: IF p_validate_only = FND_API.G_TRUE AND
903: p_validation_level > 0
904: THEN
905: IF p_task_id = FND_API.G_MISS_NUM
906: THEN

Line 905: IF p_task_id = FND_API.G_MISS_NUM

901:
902: IF p_validate_only = FND_API.G_TRUE AND
903: p_validation_level > 0
904: THEN
905: IF p_task_id = FND_API.G_MISS_NUM
906: THEN
907: l_task_id := null;
908: ELSE
909: l_task_id := p_task_id;

Line 912: IF p_effective_to_date = FND_API.G_MISS_DATE

908: ELSE
909: l_task_id := p_task_id;
910: END IF;
911:
912: IF p_effective_to_date = FND_API.G_MISS_DATE
913: THEN
914: l_effective_to_date := null;
915: ELSE
916: l_effective_to_date := p_effective_to_date;

Line 927: RAISE FND_API.G_EXC_ERROR;

923: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
924: x_msg_count := FND_MSG_PUB.count_msg;
925: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
926: x_return_status := 'E';
927: RAISE FND_API.G_EXC_ERROR;
928: END IF;
929:
930:
931: PA_BILLING_SCHEDULE_UTILS.CHECK_START_END_DATE(

Line 937: IF l_return_status = FND_API.G_RET_STS_ERROR

933: p_effective_to_date => l_effective_to_date,
934: x_error_msg_code => l_error_msg_code,
935: x_return_status => l_return_status );
936:
937: IF l_return_status = FND_API.G_RET_STS_ERROR
938: THEN
939: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
940: p_msg_name => l_error_msg_code);
941: x_msg_data := l_error_msg_code;

Line 943: RAISE FND_API.G_EXC_ERROR;

939: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
940: p_msg_name => l_error_msg_code);
941: x_msg_data := l_error_msg_code;
942: x_return_status := 'E';
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946: PA_BILLING_SCHEDULE_UTILS.CHECK_LABOR_MULTIPLIER_REQ(
947: p_labor_multiplier => p_labor_multiplier,

Line 952: IF l_return_status = FND_API.G_RET_STS_ERROR

948: p_effective_from_date => p_effective_from_date,
949: x_error_msg_code => l_error_msg_code,
950: x_return_status => l_return_status );
951:
952: IF l_return_status = FND_API.G_RET_STS_ERROR
953: THEN
954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
955: p_msg_name => l_error_msg_code);
956: x_msg_data := l_error_msg_code;

Line 958: RAISE FND_API.G_EXC_ERROR;

954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
955: p_msg_name => l_error_msg_code);
956: x_msg_data := l_error_msg_code;
957: x_return_status := 'E';
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961:
962: IF NOT PA_BILLING_SCHEDULE_UTILS.DUPLICATE_LABOR_MULTIPLIER(

Line 1008: RAISE FND_API.G_EXC_ERROR;

1004: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1005: p_msg_name => 'PA_PRJ_DATE_OVERLAP' );
1006: x_msg_data := 'PA_PRJ_DATE_OVERLAP';
1007: x_return_status := 'E';
1008: RAISE FND_API.G_EXC_ERROR;
1009: END IF;
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1008: RAISE FND_API.G_EXC_ERROR;
1009: END IF;
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: x_labor_multiplier_id := NULL; -- NOCOPY
1014: IF p_commit = FND_API.G_TRUE
1015: THEN
1016: ROLLBACK TO Labor_Multiplier;

Line 1014: IF p_commit = FND_API.G_TRUE

1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: x_labor_multiplier_id := NULL; -- NOCOPY
1014: IF p_commit = FND_API.G_TRUE
1015: THEN
1016: ROLLBACK TO Labor_Multiplier;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014: IF p_commit = FND_API.G_TRUE
1015: THEN
1016: ROLLBACK TO Labor_Multiplier;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1020: p_procedure_name => 'create_labor_multiplier',
1021: p_error_text => SUBSTRB(SQLERRM,1,240));
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1020: p_procedure_name => 'create_labor_multiplier',
1021: p_error_text => SUBSTRB(SQLERRM,1,240));
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023:
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_labor_multiplier_id := NULL; -- NOCOPY
1026: IF p_commit = FND_API.G_TRUE

Line 1024: WHEN FND_API.G_EXC_ERROR THEN

1020: p_procedure_name => 'create_labor_multiplier',
1021: p_error_text => SUBSTRB(SQLERRM,1,240));
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023:
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_labor_multiplier_id := NULL; -- NOCOPY
1026: IF p_commit = FND_API.G_TRUE
1027: THEN
1028: ROLLBACK TO Labor_Multiplier;

Line 1026: IF p_commit = FND_API.G_TRUE

1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023:
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_labor_multiplier_id := NULL; -- NOCOPY
1026: IF p_commit = FND_API.G_TRUE
1027: THEN
1028: ROLLBACK TO Labor_Multiplier;
1029: END IF;
1030: x_return_status := 'E';

Line 1034: IF p_commit = FND_API.G_TRUE

1030: x_return_status := 'E';
1031:
1032: WHEN OTHERS THEN
1033: x_labor_multiplier_id := NULL; -- NOCOPY
1034: IF p_commit = FND_API.G_TRUE
1035: THEN
1036: ROLLBACK TO Labor_Multiplier;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: IF p_commit = FND_API.G_TRUE
1035: THEN
1036: ROLLBACK TO Labor_Multiplier;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1040: p_procedure_name => 'create_labor_multiplier',
1041: p_error_text => SUBSTRB(SQLERRM,1,240));
1042: RAISE;

Line 1051: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

1047: -- Type : Public procedure
1048: -- Pre-reqs : None
1049: -- Return Value : N/A
1050: -- Prameters
1051: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1052: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1053: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1054: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1055: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 1052: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

1048: -- Pre-reqs : None
1049: -- Return Value : N/A
1050: -- Prameters
1051: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1052: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1053: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1054: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1055: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 1053: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

1049: -- Return Value : N/A
1050: -- Prameters
1051: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1052: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1053: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1054: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1055: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1057: -- p_labor_multiplier_id IN NUMBER REQUIRED

Line 1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

1052: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1053: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1054: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1055: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1057: -- p_labor_multiplier_id IN NUMBER REQUIRED
1058: -- p_project_id IN NUMBER REQUIRED
1059: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1060: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 1059: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

1055: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1057: -- p_labor_multiplier_id IN NUMBER REQUIRED
1058: -- p_project_id IN NUMBER REQUIRED
1059: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1060: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1061: -- p_effective_from_date IN DATE REQUIRED
1062: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
1063: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1

Line 1060: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

1056: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1057: -- p_labor_multiplier_id IN NUMBER REQUIRED
1058: -- p_project_id IN NUMBER REQUIRED
1059: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1060: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1061: -- p_effective_from_date IN DATE REQUIRED
1062: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
1063: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
1064: -- x_return_status OUT VARCHAR2 REQUIRED

Line 1062: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE

1058: -- p_project_id IN NUMBER REQUIRED
1059: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1060: -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1061: -- p_effective_from_date IN DATE REQUIRED
1062: -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
1063: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
1064: -- x_return_status OUT VARCHAR2 REQUIRED
1065: -- x_msg_count OUT VARCHAR2 REQUIRED
1066: -- x_msg_data OUT VARCHAR2 REQUIRED

Line 1074: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1070: -- 21-MAY-01 Majid Ansari -Created
1071: --
1072: --
1073: PROCEDURE Update_Labor_Multiplier(
1074: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1075: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1076: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1077: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1078: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 1075: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1071: --
1072: --
1073: PROCEDURE Update_Labor_Multiplier(
1074: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1075: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1076: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1077: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1078: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1079: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1076: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1072: --
1073: PROCEDURE Update_Labor_Multiplier(
1074: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1075: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1076: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1077: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1078: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1079: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1080: p_labor_multiplier_id IN NUMBER,

Line 1079: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1075: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1076: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1077: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1078: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1079: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1080: p_labor_multiplier_id IN NUMBER,
1081: p_project_id IN NUMBER ,
1082: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1083: p_labor_multiplier IN NUMBER ,

Line 1082: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1078: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1079: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1080: p_labor_multiplier_id IN NUMBER,
1081: p_project_id IN NUMBER ,
1082: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1083: p_labor_multiplier IN NUMBER ,
1084: p_effective_from_date IN DATE ,
1085: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
1086: p_record_version_number IN NUMBER DEFAULT 1,

Line 1085: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,

1081: p_project_id IN NUMBER ,
1082: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1083: p_labor_multiplier IN NUMBER ,
1084: p_effective_from_date IN DATE ,
1085: p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
1086: p_record_version_number IN NUMBER DEFAULT 1,
1087: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1088: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1089: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1100: IF p_commit = FND_API.G_TRUE

1096:
1097: l_task_id NUMBER;
1098: l_effective_to_date DATE;
1099: BEGIN
1100: IF p_commit = FND_API.G_TRUE
1101: THEN
1102: SAVEPOINT Labor_Multiplier;
1103: END IF;
1104:

Line 1107: IF p_validate_only = FND_API.G_TRUE AND

1103: END IF;
1104:
1105: x_return_status := 'S';
1106:
1107: IF p_validate_only = FND_API.G_TRUE AND
1108: p_validation_level > 0
1109: THEN
1110: IF p_task_id = FND_API.G_MISS_NUM
1111: THEN

Line 1110: IF p_task_id = FND_API.G_MISS_NUM

1106:
1107: IF p_validate_only = FND_API.G_TRUE AND
1108: p_validation_level > 0
1109: THEN
1110: IF p_task_id = FND_API.G_MISS_NUM
1111: THEN
1112: l_task_id := null;
1113: ELSE
1114: l_task_id := p_task_id;

Line 1117: IF p_effective_to_date = FND_API.G_MISS_DATE

1113: ELSE
1114: l_task_id := p_task_id;
1115: END IF;
1116:
1117: IF p_effective_to_date = FND_API.G_MISS_DATE
1118: THEN
1119: l_effective_to_date := null;
1120: ELSE
1121: l_effective_to_date := p_effective_to_date;

Line 1132: RAISE FND_API.G_EXC_ERROR;

1128: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
1129: x_msg_count := FND_MSG_PUB.count_msg;
1130: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
1131: x_return_status := 'E';
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:
1135: --Mandatory params check
1136:

Line 1143: IF l_return_status = FND_API.G_RET_STS_ERROR

1139: p_effective_from_date => p_effective_from_date,
1140: x_error_msg_code => l_error_msg_code,
1141: x_return_status => l_return_status );
1142:
1143: IF l_return_status = FND_API.G_RET_STS_ERROR
1144: THEN
1145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1146: p_msg_name => l_error_msg_code);
1147: x_msg_data := l_error_msg_code;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1146: p_msg_name => l_error_msg_code);
1147: x_msg_data := l_error_msg_code;
1148: x_return_status := 'E';
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151:
1152: ---Start end date check
1153: PA_BILLING_SCHEDULE_UTILS.CHECK_START_END_DATE(

Line 1159: IF l_return_status = FND_API.G_RET_STS_ERROR

1155: p_effective_to_date => l_effective_to_date,
1156: x_error_msg_code => l_error_msg_code,
1157: x_return_status => l_return_status );
1158:
1159: IF l_return_status = FND_API.G_RET_STS_ERROR
1160: THEN
1161: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1162: p_msg_name => l_error_msg_code);
1163: x_msg_data := l_error_msg_code;

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1162: p_msg_name => l_error_msg_code);
1163: x_msg_data := l_error_msg_code;
1164: x_return_status := 'E';
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;
1167:
1168:
1169: IF (p_debug_mode = 'Y')

Line 1174: IF p_validate_only <> FND_API.G_TRUE

1170: THEN
1171: pa_debug.debug('Update_Labor_Multiplier PVT: Checking Lock on record');
1172: END IF;
1173:
1174: IF p_validate_only <> FND_API.G_TRUE
1175: THEN
1176: BEGIN
1177: SELECT 'x' INTO l_dummy_char
1178: FROM pa_labor_multipliers

Line 1241: RAISE FND_API.G_EXC_ERROR;

1237:
1238: IF l_msg_count > 0 THEN
1239: x_msg_count := l_msg_count;
1240: x_return_status := 'E';
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: IF NOT PA_BILLING_SCHEDULE_UTILS.DUPLICATE_LABOR_MULTIPLIER(
1245: p_project_id ,

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1265: p_msg_name => 'PA_PRJ_DATE_OVERLAP' );
1266: x_msg_data := 'PA_PRJ_DATE_OVERLAP';
1267: x_return_status := 'E';
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:
1271: EXCEPTION
1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:
1271: EXCEPTION
1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1273: IF p_commit = FND_API.G_TRUE
1274: THEN
1275: ROLLBACK TO Labor_Multiplier;
1276: END IF;

Line 1273: IF p_commit = FND_API.G_TRUE

1269: END IF;
1270:
1271: EXCEPTION
1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1273: IF p_commit = FND_API.G_TRUE
1274: THEN
1275: ROLLBACK TO Labor_Multiplier;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1273: IF p_commit = FND_API.G_TRUE
1274: THEN
1275: ROLLBACK TO Labor_Multiplier;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1279: p_procedure_name => 'update_labor_multiplier',
1280: p_error_text => SUBSTRB(SQLERRM,1,240));
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1279: p_procedure_name => 'update_labor_multiplier',
1280: p_error_text => SUBSTRB(SQLERRM,1,240));
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: IF p_commit = FND_API.G_TRUE
1285: THEN

Line 1283: WHEN FND_API.G_EXC_ERROR THEN

1279: p_procedure_name => 'update_labor_multiplier',
1280: p_error_text => SUBSTRB(SQLERRM,1,240));
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: IF p_commit = FND_API.G_TRUE
1285: THEN
1286: ROLLBACK TO Labor_Multiplier;
1287: END IF;

Line 1284: IF p_commit = FND_API.G_TRUE

1280: p_error_text => SUBSTRB(SQLERRM,1,240));
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: IF p_commit = FND_API.G_TRUE
1285: THEN
1286: ROLLBACK TO Labor_Multiplier;
1287: END IF;
1288: x_return_status := 'E';

Line 1291: IF p_commit = FND_API.G_TRUE

1287: END IF;
1288: x_return_status := 'E';
1289:
1290: WHEN OTHERS THEN
1291: IF p_commit = FND_API.G_TRUE
1292: THEN
1293: ROLLBACK TO Labor_Multiplier;
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1291: IF p_commit = FND_API.G_TRUE
1292: THEN
1293: ROLLBACK TO Labor_Multiplier;
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1297: p_procedure_name => 'update_labor_multiplier',
1298: p_error_text => SUBSTRB(SQLERRM,1,240));
1299: RAISE;

Line 1309: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

1305: -- Type : Public procedure
1306: -- Pre-reqs : None
1307: -- Return Value : N/A
1308: -- Prameters
1309: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1310: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1311: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1312: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1313: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 1310: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

1306: -- Pre-reqs : None
1307: -- Return Value : N/A
1308: -- Prameters
1309: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1310: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1311: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1312: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1313: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1314: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 1311: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

1307: -- Return Value : N/A
1308: -- Prameters
1309: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
1310: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1311: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1312: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1313: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1314: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1315: -- p_labor_multiplier_id IN NUMBER REQUIRED

Line 1314: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

1310: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
1311: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
1312: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
1313: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1314: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1315: -- p_labor_multiplier_id IN NUMBER REQUIRED
1316: -- p_project_id IN NUMBER REQUIRED
1317: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1318: -- p_labor_multiplier IN NUMBER OPTIONAL

Line 1317: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

1313: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
1314: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1315: -- p_labor_multiplier_id IN NUMBER REQUIRED
1316: -- p_project_id IN NUMBER REQUIRED
1317: -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
1318: -- p_labor_multiplier IN NUMBER OPTIONAL
1319: -- p_effective_from_date IN DATE REQUIRED
1320: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
1321: -- x_return_status OUT VARCHAR2 REQUIRED

Line 1331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1327: -- 21-MAY-01 Majid Ansari -Created
1328: --
1329: --
1330: PROCEDURE delete_Labor_Multiplier(
1331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1332: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1333: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1334: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1335: p_debug_mode IN VARCHAR2 DEFAULT 'N',

Line 1332: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1328: --
1329: --
1330: PROCEDURE delete_Labor_Multiplier(
1331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1332: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1333: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1334: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1335: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1336: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1333: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1329: --
1330: PROCEDURE delete_Labor_Multiplier(
1331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1332: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1333: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1334: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1335: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1336: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: p_labor_multiplier_id IN NUMBER,

Line 1336: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1332: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1333: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1334: p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
1335: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1336: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: p_labor_multiplier_id IN NUMBER,
1338: p_project_id IN NUMBER ,
1339: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1340: p_labor_multiplier IN NUMBER ,

Line 1339: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1335: p_debug_mode IN VARCHAR2 DEFAULT 'N',
1336: p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: p_labor_multiplier_id IN NUMBER,
1338: p_project_id IN NUMBER ,
1339: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1340: p_labor_multiplier IN NUMBER ,
1341: p_effective_from_date IN DATE ,
1342: p_record_version_number IN NUMBER DEFAULT 1,
1343: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 1356: IF p_commit = FND_API.G_TRUE

1352:
1353: l_task_id NUMBER;
1354: l_effective_to_date DATE;
1355: BEGIN
1356: IF p_commit = FND_API.G_TRUE
1357: THEN
1358: SAVEPOINT Labor_Multiplier;
1359: END IF;
1360:

Line 1363: IF p_validate_only = FND_API.G_TRUE AND

1359: END IF;
1360:
1361: x_return_status := 'S';
1362:
1363: IF p_validate_only = FND_API.G_TRUE AND
1364: p_validation_level > 0
1365: THEN
1366: IF p_task_id = FND_API.G_MISS_NUM
1367: THEN

Line 1366: IF p_task_id = FND_API.G_MISS_NUM

1362:
1363: IF p_validate_only = FND_API.G_TRUE AND
1364: p_validation_level > 0
1365: THEN
1366: IF p_task_id = FND_API.G_MISS_NUM
1367: THEN
1368: l_task_id := null;
1369: ELSE
1370: l_task_id := p_task_id;

Line 1380: IF p_validate_only <> FND_API.G_TRUE

1376: THEN
1377: pa_debug.debug('Delete_Labor_Multiplier PVT: Checking Lock on record');
1378: END IF;
1379:
1380: IF p_validate_only <> FND_API.G_TRUE
1381: THEN
1382: BEGIN
1383: SELECT 'x' INTO l_dummy_char
1384: FROM pa_labor_multipliers

Line 1447: RAISE FND_API.G_EXC_ERROR;

1443:
1444: IF l_msg_count > 0 THEN
1445: x_msg_count := l_msg_count;
1446: x_return_status := 'E';
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449:
1450: DELETE pa_labor_multipliers
1451: WHERE labor_multiplier_id = p_labor_multiplier_id

Line 1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1450: DELETE pa_labor_multipliers
1451: WHERE labor_multiplier_id = p_labor_multiplier_id
1452: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1455: IF p_commit = FND_API.G_TRUE
1456: THEN
1457: ROLLBACK TO Labor_Multiplier;
1458: END IF;

Line 1455: IF p_commit = FND_API.G_TRUE

1451: WHERE labor_multiplier_id = p_labor_multiplier_id
1452: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1455: IF p_commit = FND_API.G_TRUE
1456: THEN
1457: ROLLBACK TO Labor_Multiplier;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1455: IF p_commit = FND_API.G_TRUE
1456: THEN
1457: ROLLBACK TO Labor_Multiplier;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1461: p_procedure_name => 'delete_labor_multiplier',
1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1461: p_procedure_name => 'delete_labor_multiplier',
1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: IF p_commit = FND_API.G_TRUE
1467: THEN

Line 1465: WHEN FND_API.G_EXC_ERROR THEN

1461: p_procedure_name => 'delete_labor_multiplier',
1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: IF p_commit = FND_API.G_TRUE
1467: THEN
1468: ROLLBACK TO Labor_Multiplier;
1469: END IF;

Line 1466: IF p_commit = FND_API.G_TRUE

1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: IF p_commit = FND_API.G_TRUE
1467: THEN
1468: ROLLBACK TO Labor_Multiplier;
1469: END IF;
1470: x_return_status := 'E';

Line 1473: IF p_commit = FND_API.G_TRUE

1469: END IF;
1470: x_return_status := 'E';
1471:
1472: WHEN OTHERS THEN
1473: IF p_commit = FND_API.G_TRUE
1474: THEN
1475: ROLLBACK TO Labor_Multiplier;
1476: END IF;
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: IF p_commit = FND_API.G_TRUE
1474: THEN
1475: ROLLBACK TO Labor_Multiplier;
1476: END IF;
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1479: p_procedure_name => 'delete_labor_multiplier',
1480: p_error_text => SUBSTRB(SQLERRM,1,240));
1481: RAISE;