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

Line 9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

5: -- Type : Public procedure
6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
12: -- x_ emp_bill_rate_id OUT NUMBER REQUIRED
13: -- x_return_status OUT VARCHAR2 REQUIRED

Line 10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
12: -- x_ emp_bill_rate_id OUT NUMBER REQUIRED
13: -- x_return_status OUT VARCHAR2 REQUIRED
14: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

19: --
20: --
21:
22: PROCEDURE Emp_bill_rate_sch_name_To_Id(
23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
25: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
26: x_emp_bill_rate_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

20: --
21:
22: PROCEDURE Emp_bill_rate_sch_name_To_Id(
23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
25: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
26: x_emp_bill_rate_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 105: x_return_status:= FND_API.G_RET_STS_SUCCESS;

101: ELSE
102: x_emp_bill_rate_id := null;
103: END IF;
104: END IF;
105: x_return_status:= FND_API.G_RET_STS_SUCCESS;
106: EXCEPTION
107: WHEN no_data_found THEN
108: x_emp_bill_rate_id := null;
109: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 109: x_return_status:= FND_API.G_RET_STS_ERROR;

105: x_return_status:= FND_API.G_RET_STS_SUCCESS;
106: EXCEPTION
107: WHEN no_data_found THEN
108: x_emp_bill_rate_id := null;
109: x_return_status:= FND_API.G_RET_STS_ERROR;
110: x_error_msg_code:= 'PA_PRJ_INV_EMP_BR_SCH_ID';
111: WHEN too_many_rows THEN
112: x_emp_bill_rate_id := null;
113: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 113: x_return_status:= FND_API.G_RET_STS_ERROR;

109: x_return_status:= FND_API.G_RET_STS_ERROR;
110: x_error_msg_code:= 'PA_PRJ_INV_EMP_BR_SCH_ID';
111: WHEN too_many_rows THEN
112: x_emp_bill_rate_id := null;
113: x_return_status:= FND_API.G_RET_STS_ERROR;
114: x_error_msg_code:= 'PA_PRJ_TOO_MANY_EMP_BR';
115: WHEN OTHERS THEN
116: x_emp_bill_rate_id := null;
117: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 117: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

113: x_return_status:= FND_API.G_RET_STS_ERROR;
114: x_error_msg_code:= 'PA_PRJ_TOO_MANY_EMP_BR';
115: WHEN OTHERS THEN
116: x_emp_bill_rate_id := null;
117: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
118: RAISE;
119: END Emp_bill_rate_sch_name_To_Id;
120:
121: -- API name : Job_bill_rate_sch_name_To_Id

Line 126: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

122: -- Type : Public procedure
123: -- Pre-reqs : None
124: -- Return Value : N/A
125: -- Prameters
126: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
127: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
128: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
129: -- p_job_group_id IN NUMBER REQUIRED
130: -- x_job_bill_rate_id OUT NUMBER REQUIRED

Line 127: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

123: -- Pre-reqs : None
124: -- Return Value : N/A
125: -- Prameters
126: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
127: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
128: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
129: -- p_job_group_id IN NUMBER REQUIRED
130: -- x_job_bill_rate_id OUT NUMBER REQUIRED
131: -- x_return_status OUT VARCHAR2 REQUIRED

Line 141: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

137: --
138: --
139:
140: PROCEDURE job_bill_rate_sch_name_To_Id(
141: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
142: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
143: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
144: p_job_group_id IN NUMBER ,
145: x_job_bill_rate_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 142: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

138: --
139:
140: PROCEDURE job_bill_rate_sch_name_To_Id(
141: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
142: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
143: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
144: p_job_group_id IN NUMBER ,
145: x_job_bill_rate_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
146: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 227: x_return_status:= FND_API.G_RET_STS_SUCCESS;

223: ELSE
224: x_job_bill_rate_id := null;
225: END IF;
226: END IF;
227: x_return_status:= FND_API.G_RET_STS_SUCCESS;
228: EXCEPTION
229: WHEN no_data_found THEN
230: x_job_bill_rate_id := null;
231: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 231: x_return_status:= FND_API.G_RET_STS_ERROR;

227: x_return_status:= FND_API.G_RET_STS_SUCCESS;
228: EXCEPTION
229: WHEN no_data_found THEN
230: x_job_bill_rate_id := null;
231: x_return_status:= FND_API.G_RET_STS_ERROR;
232: x_error_msg_code:= 'PA_PRJ_INV_JOB_BR_SCH_ID';
233: WHEN too_many_rows THEN
234: x_job_bill_rate_id := null;
235: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 235: x_return_status:= FND_API.G_RET_STS_ERROR;

231: x_return_status:= FND_API.G_RET_STS_ERROR;
232: x_error_msg_code:= 'PA_PRJ_INV_JOB_BR_SCH_ID';
233: WHEN too_many_rows THEN
234: x_job_bill_rate_id := null;
235: x_return_status:= FND_API.G_RET_STS_ERROR;
236: x_error_msg_code:= 'PA_PRJ_TOO_MANY_JOB_BR';
237: WHEN OTHERS THEN
238: x_job_bill_rate_id := null;
239: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 239: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

235: x_return_status:= FND_API.G_RET_STS_ERROR;
236: x_error_msg_code:= 'PA_PRJ_TOO_MANY_JOB_BR';
237: WHEN OTHERS THEN
238: x_job_bill_rate_id := null;
239: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
240: RAISE;
241: END Job_bill_rate_sch_name_To_Id;
242:
243:

Line 249: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

245: -- Type : Public procedure
246: -- Pre-reqs : None
247: -- Return Value : N/A
248: -- Prameters
249: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
250: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
251: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
252: -- x_rev_sch_id OUT NUMBER REQUIRED
253: -- x_return_status OUT VARCHAR2 REQUIRED

Line 250: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

246: -- Pre-reqs : None
247: -- Return Value : N/A
248: -- Prameters
249: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
250: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
251: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
252: -- x_rev_sch_id OUT NUMBER REQUIRED
253: -- x_return_status OUT VARCHAR2 REQUIRED
254: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 263: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

259: --
260: --
261:
262: PROCEDURE Rev_Sch_Name_To_Id(
263: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
264: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
265: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
266: x_rev_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
267: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 264: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

260: --
261:
262: PROCEDURE Rev_Sch_Name_To_Id(
263: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
264: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
265: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
266: x_rev_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
267: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
268: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 351: x_return_status:= FND_API.G_RET_STS_SUCCESS;

347: ELSE
348: x_rev_sch_id := null;
349: END IF;
350: END IF;
351: x_return_status:= FND_API.G_RET_STS_SUCCESS;
352: EXCEPTION
353: WHEN no_data_found THEN
354: x_rev_sch_id := null;
355: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 355: x_return_status:= FND_API.G_RET_STS_ERROR;

351: x_return_status:= FND_API.G_RET_STS_SUCCESS;
352: EXCEPTION
353: WHEN no_data_found THEN
354: x_rev_sch_id := null;
355: x_return_status:= FND_API.G_RET_STS_ERROR;
356: x_error_msg_code:= 'PA_PRJ_REV_SCHEDULE_ID';
357: WHEN too_many_rows THEN
358: x_rev_sch_id := null;
359: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 359: x_return_status:= FND_API.G_RET_STS_ERROR;

355: x_return_status:= FND_API.G_RET_STS_ERROR;
356: x_error_msg_code:= 'PA_PRJ_REV_SCHEDULE_ID';
357: WHEN too_many_rows THEN
358: x_rev_sch_id := null;
359: x_return_status:= FND_API.G_RET_STS_ERROR;
360: x_error_msg_code:= 'PA_PRJ_TOO_MANY_REV_SCH';
361: WHEN OTHERS THEN
362: x_rev_sch_id := null;
363: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 363: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

359: x_return_status:= FND_API.G_RET_STS_ERROR;
360: x_error_msg_code:= 'PA_PRJ_TOO_MANY_REV_SCH';
361: WHEN OTHERS THEN
362: x_rev_sch_id := null;
363: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
364: RAISE;
365: END Rev_Sch_Name_To_Id;
366:
367:

Line 373: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

369: -- Type : Public procedure
370: -- Pre-reqs : None
371: -- Return Value : N/A
372: -- Prameters
373: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
374: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
375: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
376: -- x_inv_sch_id OUT NUMBER REQUIRED
377: -- x_return_status OUT VARCHAR2 REQUIRED

Line 374: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

370: -- Pre-reqs : None
371: -- Return Value : N/A
372: -- Prameters
373: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
374: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
375: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
376: -- x_inv_sch_id OUT NUMBER REQUIRED
377: -- x_return_status OUT VARCHAR2 REQUIRED
378: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 387: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

383: --
384: --
385:
386: PROCEDURE Inv_Sch_Name_To_Id(
387: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
388: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
389: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
390: x_Inv_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
391: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 388: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

384: --
385:
386: PROCEDURE Inv_Sch_Name_To_Id(
387: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
388: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
389: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
390: x_Inv_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
391: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
392: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 475: x_return_status:= FND_API.G_RET_STS_SUCCESS;

471: ELSE
472: x_inv_sch_id := null;
473: END IF;
474: END IF;
475: x_return_status:= FND_API.G_RET_STS_SUCCESS;
476: EXCEPTION
477: WHEN no_data_found THEN
478: x_inv_sch_id := null;
479: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 479: x_return_status:= FND_API.G_RET_STS_ERROR;

475: x_return_status:= FND_API.G_RET_STS_SUCCESS;
476: EXCEPTION
477: WHEN no_data_found THEN
478: x_inv_sch_id := null;
479: x_return_status:= FND_API.G_RET_STS_ERROR;
480: x_error_msg_code:= 'PA_PRJ_INV_SCHEDULE_ID';
481: WHEN too_many_rows THEN
482: x_inv_sch_id := null;
483: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 483: x_return_status:= FND_API.G_RET_STS_ERROR;

479: x_return_status:= FND_API.G_RET_STS_ERROR;
480: x_error_msg_code:= 'PA_PRJ_INV_SCHEDULE_ID';
481: WHEN too_many_rows THEN
482: x_inv_sch_id := null;
483: x_return_status:= FND_API.G_RET_STS_ERROR;
484: x_error_msg_code:= 'PA_PRJ_TOO_MANY_INV_SCH';
485: WHEN OTHERS THEN
486: x_inv_sch_id := null;
487: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 487: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

483: x_return_status:= FND_API.G_RET_STS_ERROR;
484: x_error_msg_code:= 'PA_PRJ_TOO_MANY_INV_SCH';
485: WHEN OTHERS THEN
486: x_inv_sch_id := null;
487: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
488: RAISE;
489: END Inv_Sch_Name_To_Id;
490:
491:

Line 497: -- p_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

493: -- Type : Public procedure
494: -- Pre-reqs : None
495: -- Return Value : N/A
496: -- Prameters
497: -- p_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
498: -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
499: -- p_nlbr_org_id IN NUMBER REQUIRED
500: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
501: -- x_sch_id OUT NUMBER REQUIRED

Line 498: -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

494: -- Pre-reqs : None
495: -- Return Value : N/A
496: -- Prameters
497: -- p_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
498: -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
499: -- p_nlbr_org_id IN NUMBER REQUIRED
500: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
501: -- x_sch_id OUT NUMBER REQUIRED
502: -- x_return_status OUT VARCHAR2 REQUIRED

Line 512: p_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

508: --
509: --
510:
511: PROCEDURE Nlbr_schedule_name_To_Id(
512: p_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
513: p_nlbr_org_id IN NUMBER,
514: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
515: x_sch_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
516: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 536: x_return_status:= FND_API.G_RET_STS_SUCCESS;

532: ELSE
533: x_sch_name := p_sch_name;
534: END IF;
535: END IF;
536: x_return_status:= FND_API.G_RET_STS_SUCCESS;
537: EXCEPTION
538: WHEN no_data_found THEN
539: x_sch_name := NULL;
540: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 540: x_return_status:= FND_API.G_RET_STS_ERROR;

536: x_return_status:= FND_API.G_RET_STS_SUCCESS;
537: EXCEPTION
538: WHEN no_data_found THEN
539: x_sch_name := NULL;
540: x_return_status:= FND_API.G_RET_STS_ERROR;
541: x_error_msg_code:= 'PA_PRJ_NL_SCHEDULE_ID';
542: WHEN too_many_rows THEN
543: x_sch_name := NULL;
544: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 544: x_return_status:= FND_API.G_RET_STS_ERROR;

540: x_return_status:= FND_API.G_RET_STS_ERROR;
541: x_error_msg_code:= 'PA_PRJ_NL_SCHEDULE_ID';
542: WHEN too_many_rows THEN
543: x_sch_name := NULL;
544: x_return_status:= FND_API.G_RET_STS_ERROR;
545: x_error_msg_code:= 'PA_PRJ_TOO_MANY_NL_SCH';
546: WHEN OTHERS THEN
547: x_sch_name := NULL;
548: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 548: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

544: x_return_status:= FND_API.G_RET_STS_ERROR;
545: x_error_msg_code:= 'PA_PRJ_TOO_MANY_NL_SCH';
546: WHEN OTHERS THEN
547: x_sch_name := NULL;
548: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
549: RAISE;
550: END Nlbr_schedule_name_To_Id;
551:
552:

Line 558: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

554: -- Type : Public procedure
555: -- Pre-reqs : None
556: -- Return Value : N/A
557: -- Prameters
558: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
559: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
560: -- p_nlbr_org_id IN NUMBER REQUIRED
561: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
562: -- x_org_id OUT NUMBER REQUIRED

Line 559: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

555: -- Pre-reqs : None
556: -- Return Value : N/A
557: -- Prameters
558: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
559: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
560: -- p_nlbr_org_id IN NUMBER REQUIRED
561: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
562: -- x_org_id OUT NUMBER REQUIRED
563: -- x_return_status OUT VARCHAR2 REQUIRED

Line 573: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

569: --
570: --
571:
572: PROCEDURE NL_org_sch_Name_To_Id(
573: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
574: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
575: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
576: x_org_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
577: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 574: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

570: --
571:
572: PROCEDURE NL_org_sch_Name_To_Id(
573: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
574: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
575: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
576: x_org_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
577: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
578: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 648: x_return_status:= FND_API.G_RET_STS_SUCCESS;

644: ELSE
645: x_org_id := null;
646: END IF;
647: END IF;
648: x_return_status:= FND_API.G_RET_STS_SUCCESS;
649: EXCEPTION
650: WHEN no_data_found THEN
651: x_org_id := null;
652: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 652: x_return_status:= FND_API.G_RET_STS_ERROR;

648: x_return_status:= FND_API.G_RET_STS_SUCCESS;
649: EXCEPTION
650: WHEN no_data_found THEN
651: x_org_id := null;
652: x_return_status:= FND_API.G_RET_STS_ERROR;
653: x_error_msg_code:= 'PA_PRJ_INVALID_ORG';
654: WHEN too_many_rows THEN
655: x_org_id := null;
656: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 656: x_return_status:= FND_API.G_RET_STS_ERROR;

652: x_return_status:= FND_API.G_RET_STS_ERROR;
653: x_error_msg_code:= 'PA_PRJ_INVALID_ORG';
654: WHEN too_many_rows THEN
655: x_org_id := null;
656: x_return_status:= FND_API.G_RET_STS_ERROR;
657: x_error_msg_code:= 'PA_PRJ_TOO_MANY_ORG';
658: WHEN OTHERS THEN
659: x_org_id := null;
660: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 660: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

656: x_return_status:= FND_API.G_RET_STS_ERROR;
657: x_error_msg_code:= 'PA_PRJ_TOO_MANY_ORG';
658: WHEN OTHERS THEN
659: x_org_id := null;
660: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
661: RAISE;
662: END NL_org_sch_Name_To_Id;
663:
664:

Line 671: -- p_task_id IN NUMBER OPTIONAL DEFAULT FND_API.MISS_NUM

667: -- Pre-reqs : None
668: -- Return Value : BOLLEAN
669: -- Prameters
670: -- p_project_id IN NUMBER REQUIRED
671: -- p_task_id IN NUMBER OPTIONAL DEFAULT FND_API.MISS_NUM
672: -- p_effective_from_date IN DATE REQUIRED
673: -- p_effective_to_date IN DATE
674: -- p_labor_multiplier_id IN NUMBER
675: -- x_return_status OUT VARCHAR2 REQUIRED

Line 685: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

681: --
682:
683: FUNCTION Duplicate_labor_Multiplier(
684: p_project_id IN NUMBER ,
685: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
686: p_effective_from_date IN DATE ,
687: p_effective_to_date IN DATE ,
688: p_labor_multiplier_id IN NUMBER ,
689: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 714: x_return_status:= FND_API.G_RET_STS_SUCCESS;

710: ELSE
711: CLOSE cur_lbr_mult;
712: RETURN FALSE;
713: END IF;
714: x_return_status:= FND_API.G_RET_STS_SUCCESS;
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
718: RAISE;

Line 717: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

713: END IF;
714: x_return_status:= FND_API.G_RET_STS_SUCCESS;
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
718: RAISE;
719: END Duplicate_labor_Multiplier;
720:
721: -- API name : Emp_job_mandatory_validation

Line 726: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

722: -- Type : Public procedure
723: -- Pre-reqs : None
724: -- Return Value : N/A
725: -- Prameters
726: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
727: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM
728: -- x_return_status OUT VARCHAR2 REQUIRED
729: -- x_error_msg_code OUT VARCHAR2 REQUIRED
730: --

Line 727: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM

723: -- Pre-reqs : None
724: -- Return Value : N/A
725: -- Prameters
726: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
727: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM
728: -- x_return_status OUT VARCHAR2 REQUIRED
729: -- x_error_msg_code OUT VARCHAR2 REQUIRED
730: --
731: -- History

Line 738: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

734: --
735: --
736:
737: PROCEDURE Emp_job_mandatory_validation(
738: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
739: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
740: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
741: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
742: ) IS

Line 739: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,

735: --
736:
737: PROCEDURE Emp_job_mandatory_validation(
738: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
739: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
740: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
741: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
742: ) IS
743: BEGIN

Line 745: IF p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM

741: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
742: ) IS
743: BEGIN
744: IF pa_install.is_prm_licensed = 'Y' THEN
745: IF p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM
746: THEN
747: x_return_status:= FND_API.G_RET_STS_ERROR;
748: x_error_msg_code:= 'PA_JOB_BILL_RT_SCH_NOT_NULL';
749: END IF;

Line 747: x_return_status:= FND_API.G_RET_STS_ERROR;

743: BEGIN
744: IF pa_install.is_prm_licensed = 'Y' THEN
745: IF p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM
746: THEN
747: x_return_status:= FND_API.G_RET_STS_ERROR;
748: x_error_msg_code:= 'PA_JOB_BILL_RT_SCH_NOT_NULL';
749: END IF;
750: ELSE
751: IF ( p_emp_bill_rate_sch_id IS NULL OR p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM ) AND

Line 751: IF ( p_emp_bill_rate_sch_id IS NULL OR p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM ) AND

747: x_return_status:= FND_API.G_RET_STS_ERROR;
748: x_error_msg_code:= 'PA_JOB_BILL_RT_SCH_NOT_NULL';
749: END IF;
750: ELSE
751: IF ( p_emp_bill_rate_sch_id IS NULL OR p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM ) AND
752: ( p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM )
753: THEN
754: x_return_status:= FND_API.G_RET_STS_ERROR;
755: x_error_msg_code:= 'PA_EJ_BILL_RT_SCH_NOT_NULL';

Line 752: ( p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM )

748: x_error_msg_code:= 'PA_JOB_BILL_RT_SCH_NOT_NULL';
749: END IF;
750: ELSE
751: IF ( p_emp_bill_rate_sch_id IS NULL OR p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM ) AND
752: ( p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM )
753: THEN
754: x_return_status:= FND_API.G_RET_STS_ERROR;
755: x_error_msg_code:= 'PA_EJ_BILL_RT_SCH_NOT_NULL';
756: END IF;

Line 754: x_return_status:= FND_API.G_RET_STS_ERROR;

750: ELSE
751: IF ( p_emp_bill_rate_sch_id IS NULL OR p_emp_bill_rate_sch_id = FND_API.G_MISS_NUM ) AND
752: ( p_job_bill_rate_sch_id IS NULL OR p_job_bill_rate_sch_id = FND_API.G_MISS_NUM )
753: THEN
754: x_return_status:= FND_API.G_RET_STS_ERROR;
755: x_error_msg_code:= 'PA_EJ_BILL_RT_SCH_NOT_NULL';
756: END IF;
757: END IF;
758: EXCEPTION

Line 760: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

756: END IF;
757: END IF;
758: EXCEPTION
759: WHEN OTHERS THEN
760: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
761: RAISE;
762: END Emp_job_mandatory_validation;
763:
764: -- API name : Get_Job_Group_Id

Line 794: x_return_status:= FND_API.G_RET_STS_SUCCESS;

790: BEGIN
791: OPEN cur_job_group;
792: FETCH cur_job_group INTO l_job_group_id;
793: CLOSE cur_job_group;
794: x_return_status:= FND_API.G_RET_STS_SUCCESS;
795: RETURN l_job_group_id;
796: EXCEPTION
797: WHEN OTHERS THEN
798: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 798: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

794: x_return_status:= FND_API.G_RET_STS_SUCCESS;
795: RETURN l_job_group_id;
796: EXCEPTION
797: WHEN OTHERS THEN
798: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
799: RAISE;
800: END Get_Job_Group_Id;
801:
802:

Line 835: x_return_status:= FND_API.G_RET_STS_SUCCESS;

831: OPEN cur_projects_all;
832: FETCH cur_projects_all INTO l_project_type_class_code;
833: CLOSE cur_projects_all;
834: RETURN l_project_type_class_code;
835: x_return_status:= FND_API.G_RET_STS_SUCCESS;
836: EXCEPTION
837: WHEN OTHERS THEN
838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
839: END Get_Project_Type_Class;

Line 838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

834: RETURN l_project_type_class_code;
835: x_return_status:= FND_API.G_RET_STS_SUCCESS;
836: EXCEPTION
837: WHEN OTHERS THEN
838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
839: END Get_Project_Type_Class;
840:
841: -- API name : CHECK_BILL_INFO_REQ
842: -- Type : Public procedure

Line 891: IF l_return_status = FND_API.G_RET_STS_ERROR

887: p_emp_bill_rate_sch_id,
888: p_job_bill_rate_sch_id,
889: l_return_status,
890: l_error_msg_code );
891: IF l_return_status = FND_API.G_RET_STS_ERROR
892: THEN
893: x_error_msg_code := l_error_msg_code;
894: x_return_status := 'E';
895: RAISE FND_API.G_EXC_ERROR;

Line 895: RAISE FND_API.G_EXC_ERROR;

891: IF l_return_status = FND_API.G_RET_STS_ERROR
892: THEN
893: x_error_msg_code := l_error_msg_code;
894: x_return_status := 'E';
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: ELSIF p_lbr_schedule_type = 'I'
898: THEN
899: --If any of the revenue or inv schedule is null then raise a message.

Line 900: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM

896: END IF;
897: ELSIF p_lbr_schedule_type = 'I'
898: THEN
899: --If any of the revenue or inv schedule is null then raise a message.
900: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
901: THEN
902: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
903: x_return_status:= FND_API.G_RET_STS_ERROR;
904: RAISE FND_API.G_EXC_ERROR;

Line 903: x_return_status:= FND_API.G_RET_STS_ERROR;

899: --If any of the revenue or inv schedule is null then raise a message.
900: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
901: THEN
902: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
903: x_return_status:= FND_API.G_RET_STS_ERROR;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:
907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM

Line 904: RAISE FND_API.G_EXC_ERROR;

900: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
901: THEN
902: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
903: x_return_status:= FND_API.G_RET_STS_ERROR;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:
907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
908: THEN

Line 907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM

903: x_return_status:= FND_API.G_RET_STS_ERROR;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:
907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
908: THEN
909: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
910: x_return_status:= FND_API.G_RET_STS_ERROR;
911: RAISE FND_API.G_EXC_ERROR;

Line 910: x_return_status:= FND_API.G_RET_STS_ERROR;

906:
907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
908: THEN
909: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
910: x_return_status:= FND_API.G_RET_STS_ERROR;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: END IF;
914:

Line 911: RAISE FND_API.G_EXC_ERROR;

907: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
908: THEN
909: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
910: x_return_status:= FND_API.G_RET_STS_ERROR;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: END IF;
914:
915: IF p_non_lbr_schedule_type = 'B'

Line 917: IF p_nlbr_bill_rate_org_id IS NULL OR p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM

913: END IF;
914:
915: IF p_non_lbr_schedule_type = 'B'
916: THEN
917: IF p_nlbr_bill_rate_org_id IS NULL OR p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM
918: THEN
919: x_error_msg_code := 'PA_PRJ_ORG_ID_REQ';
920: x_return_status:= FND_API.G_RET_STS_ERROR;
921: RAISE FND_API.G_EXC_ERROR;

Line 920: x_return_status:= FND_API.G_RET_STS_ERROR;

916: THEN
917: IF p_nlbr_bill_rate_org_id IS NULL OR p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM
918: THEN
919: x_error_msg_code := 'PA_PRJ_ORG_ID_REQ';
920: x_return_status:= FND_API.G_RET_STS_ERROR;
921: RAISE FND_API.G_EXC_ERROR;
922: END IF;
923:
924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR

Line 921: RAISE FND_API.G_EXC_ERROR;

917: IF p_nlbr_bill_rate_org_id IS NULL OR p_nlbr_bill_rate_org_id = FND_API.G_MISS_NUM
918: THEN
919: x_error_msg_code := 'PA_PRJ_ORG_ID_REQ';
920: x_return_status:= FND_API.G_RET_STS_ERROR;
921: RAISE FND_API.G_EXC_ERROR;
922: END IF;
923:
924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR
925: THEN

Line 924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR

920: x_return_status:= FND_API.G_RET_STS_ERROR;
921: RAISE FND_API.G_EXC_ERROR;
922: END IF;
923:
924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR
925: THEN
926: x_error_msg_code := 'PA_PRJ_NL_SCH_REQ';
927: x_return_status:= FND_API.G_RET_STS_ERROR;
928: RAISE FND_API.G_EXC_ERROR;

Line 927: x_return_status:= FND_API.G_RET_STS_ERROR;

923:
924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR
925: THEN
926: x_error_msg_code := 'PA_PRJ_NL_SCH_REQ';
927: x_return_status:= FND_API.G_RET_STS_ERROR;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930:
931: ELSIF p_non_lbr_schedule_type = 'I'

Line 928: RAISE FND_API.G_EXC_ERROR;

924: IF p_nlbr_std_bill_rate_sch IS NULL OR p_nlbr_std_bill_rate_sch = FND_API.G_MISS_CHAR
925: THEN
926: x_error_msg_code := 'PA_PRJ_NL_SCH_REQ';
927: x_return_status:= FND_API.G_RET_STS_ERROR;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930:
931: ELSIF p_non_lbr_schedule_type = 'I'
932: THEN

Line 934: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM

930:
931: ELSIF p_non_lbr_schedule_type = 'I'
932: THEN
933:
934: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
935: THEN
936: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
937: x_return_status:= FND_API.G_RET_STS_ERROR;
938: RAISE FND_API.G_EXC_ERROR;

Line 937: x_return_status:= FND_API.G_RET_STS_ERROR;

933:
934: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
935: THEN
936: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
937: x_return_status:= FND_API.G_RET_STS_ERROR;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM

Line 938: RAISE FND_API.G_EXC_ERROR;

934: IF p_rev_schedule_id IS NULL OR p_rev_schedule_id = FND_API.G_MISS_NUM
935: THEN
936: x_error_msg_code := 'PA_PRJ_REV_SCH_REQ';
937: x_return_status:= FND_API.G_RET_STS_ERROR;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
942: THEN

Line 941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM

937: x_return_status:= FND_API.G_RET_STS_ERROR;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
942: THEN
943: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
944: x_return_status:= FND_API.G_RET_STS_ERROR;
945: RAISE FND_API.G_EXC_ERROR;

Line 944: x_return_status:= FND_API.G_RET_STS_ERROR;

940:
941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
942: THEN
943: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
944: x_return_status:= FND_API.G_RET_STS_ERROR;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947: END IF;
948:

Line 945: RAISE FND_API.G_EXC_ERROR;

941: IF p_inv_schedule_id IS NULL OR p_inv_schedule_id = FND_API.G_MISS_NUM
942: THEN
943: x_error_msg_code := 'PA_PRJ_INV_SCH_REQ';
944: x_return_status:= FND_API.G_RET_STS_ERROR;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947: END IF;
948:
949: END IF;

Line 951: WHEN FND_API.G_EXC_ERROR THEN

947: END IF;
948:
949: END IF;
950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status:= FND_API.G_RET_STS_ERROR;
953: END CHECK_BILL_INFO_REQ;
954:
955: -- API name : CHECK_LABOR_MULTIPLIER_REQ

Line 952: x_return_status:= FND_API.G_RET_STS_ERROR;

948:
949: END IF;
950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status:= FND_API.G_RET_STS_ERROR;
953: END CHECK_BILL_INFO_REQ;
954:
955: -- API name : CHECK_LABOR_MULTIPLIER_REQ
956: -- Type : Public procedure

Line 978: x_return_status:= FND_API.G_RET_STS_SUCCESS;

974: x_error_msg_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
975: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
976: ) AS
977: BEGIN
978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
979: IF p_labor_multiplier IS NULL OR p_labor_multiplier = FND_API.G_MISS_NUM
980: THEN
981: x_error_msg_code := 'PA_PRJ_LB_MULT_REQ';
982: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 979: IF p_labor_multiplier IS NULL OR p_labor_multiplier = FND_API.G_MISS_NUM

975: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
976: ) AS
977: BEGIN
978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
979: IF p_labor_multiplier IS NULL OR p_labor_multiplier = FND_API.G_MISS_NUM
980: THEN
981: x_error_msg_code := 'PA_PRJ_LB_MULT_REQ';
982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE FND_API.G_EXC_ERROR;

Line 982: x_return_status:= FND_API.G_RET_STS_ERROR;

978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
979: IF p_labor_multiplier IS NULL OR p_labor_multiplier = FND_API.G_MISS_NUM
980: THEN
981: x_error_msg_code := 'PA_PRJ_LB_MULT_REQ';
982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE

Line 983: RAISE FND_API.G_EXC_ERROR;

979: IF p_labor_multiplier IS NULL OR p_labor_multiplier = FND_API.G_MISS_NUM
980: THEN
981: x_error_msg_code := 'PA_PRJ_LB_MULT_REQ';
982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE
987: THEN

Line 986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE

982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE
987: THEN
988: x_error_msg_code := 'PA_PRJ_ST_DT_REQ';
989: x_return_status:= FND_API.G_RET_STS_ERROR;
990: RAISE FND_API.G_EXC_ERROR;

Line 989: x_return_status:= FND_API.G_RET_STS_ERROR;

985:
986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE
987: THEN
988: x_error_msg_code := 'PA_PRJ_ST_DT_REQ';
989: x_return_status:= FND_API.G_RET_STS_ERROR;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: EXCEPTION

Line 990: RAISE FND_API.G_EXC_ERROR;

986: IF p_effective_from_date IS NULL OR p_effective_from_date = FND_API.G_MISS_DATE
987: THEN
988: x_error_msg_code := 'PA_PRJ_ST_DT_REQ';
989: x_return_status:= FND_API.G_RET_STS_ERROR;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN

Line 994: WHEN FND_API.G_EXC_ERROR THEN

990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN
995: x_return_status:= FND_API.G_RET_STS_ERROR;
996: END CHECK_LABOR_MULTIPLIER_REQ;
997:
998: -- API name : CHECK_START_END_DATE

Line 995: x_return_status:= FND_API.G_RET_STS_ERROR;

991: END IF;
992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN
995: x_return_status:= FND_API.G_RET_STS_ERROR;
996: END CHECK_LABOR_MULTIPLIER_REQ;
997:
998: -- API name : CHECK_START_END_DATE
999: -- Type : Public procedure

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1019: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1020: ) AS
1021: BEGIN
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023: IF p_effective_from_date IS NOT NULL AND p_effective_to_date IS NOT NULL
1024: THEN
1025: IF p_effective_from_date > p_effective_to_date
1026: THEN

Line 1028: x_return_status:= FND_API.G_RET_STS_ERROR;

1024: THEN
1025: IF p_effective_from_date > p_effective_to_date
1026: THEN
1027: x_error_msg_code := 'PA_PRJ_ST_DT_LESS_ED_DT';
1028: x_return_status:= FND_API.G_RET_STS_ERROR;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: END IF;
1032: EXCEPTION

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: IF p_effective_from_date > p_effective_to_date
1026: THEN
1027: x_error_msg_code := 'PA_PRJ_ST_DT_LESS_ED_DT';
1028: x_return_status:= FND_API.G_RET_STS_ERROR;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: END IF;
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: END IF;
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status:= FND_API.G_RET_STS_ERROR;
1035: END CHECK_START_END_DATE;
1036:
1037: END PA_BILLING_SCHEDULE_UTILS;

Line 1034: x_return_status:= FND_API.G_RET_STS_ERROR;

1030: END IF;
1031: END IF;
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status:= FND_API.G_RET_STS_ERROR;
1035: END CHECK_START_END_DATE;
1036:
1037: END PA_BILLING_SCHEDULE_UTILS;